names

21 rows where case_id = 2536004

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5603612 2536004 2536004 plaintiff Pek Richard esq   Pek, Richard, esq 0
5603613 2536004 2536004 defendant Eltoft Christopher esq 904939 904939 Eltoft, Christopher, of Sandall Castell, esq 0
5603614 2536004 2536004 defendant Wakefeld John gent 590637 590637 Wakefeld, John, of Sandall, gent 1
5603615 2536004 2536004 defendant Burnand William yeoman 586887 586887 Burnand, William, of Wakefeld, yeoman 2
5603616 2536004 2536004 defendant Turton Richard gent 586887 586887 Turton, Richard, of Wakefeld, gent 3
5603617 2536004 2536004 defendant Turton Simon yeoman 586887 586887 Turton, Simon, of Wakefeld, yeoman 4
5603618 2536004 2536004 defendant Turton John yeoman 586887 586887 Turton, John, of Wakefeld, yeoman 5
5603619 2536004 2536004 defendant Turton Richard, junior yeoman 586887 586887 Turton, Richard, junior, of Wakefeld, yeoman 6
5603620 2536004 2536004 defendant Spynk William dyer 586887 586887 Spynk, William, of Wakefeld, dyer 7
5603621 2536004 2536004 defendant Coke Thomas yeoman 586887 586887 Coke, Thomas, of Wakefeld, yeoman 8
5603622 2536004 2536004 defendant Coke John osteler 586887 586887 Coke, John, of Wakefeld, osteler 9
5603623 2536004 2536004 defendant Barlolowe Owen innholder 586887 586887 Barlolowe, Owen, of Wakefeld, innholder 10
5603624 2536004 2536004 defendant Maisterman William butcher 586887 586887 Maisterman, William, of Wakefeld, butcher 11
5603625 2536004 2536004 defendant Knolles Robert dyer 586887 586887 Knolles, Robert, of Wakefeld, dyer 12
5603626 2536004 2536004 defendant Foldis Henry sherman 586887 586887 Foldis, Henry, of Wakefeld, sherman 13
5603627 2536004 2536004 defendant Strynger Richard   586887 586887 Strynger, Richard, of Wakefeld, coverlet weaver 14
5603628 2536004 2536004 defendant Milnner John clothmaker 586887 586887 Milnner, John, of Wakefeld, clothmaker 15
5603629 2536004 2536004 defendant Stott or Scott Robert fisher 586887 586887 Stott or Scott, Robert, of Wakefeld, fisher 16
5603630 2536004 2536004 defendant Suttyll William laborer 586887 586887 Suttyll, William, of Wakefeld, laborer 17
5603631 2536004 2536004 defendant Swyft George yeoman 904941 904941 Swyft, George, of Wanthorp, yeoman 18
5603632 2536004 2536004 defendant Cake George yeoman 850758 850758 Cake, George, of Snaypthorp, yeoman 19

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);