names

21 rows where case_id = 2421602

✎ 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
5220154 2421602 2421602 plaintiff Huby Thomas     Huby, Thomas 0
5220155 2421602 2421602 defendant Cant Thomas husbandman 586956 586956 Cant, Thomas, of Semer, husbandman 0
5220156 2421602 2421602 defendant Westhous John husbandman 586956 586956 Westhous, John, of Semer, husbandman 1
5220157 2421602 2421602 defendant Westhous William husbandman 586956 586956 Westhous, William, of Semer, husbandman 2
5220158 2421602 2421602 defendant Mason Thomas husbandman 586956 586956 Mason, Thomas, of Semer, husbandman 3
5220159 2421602 2421602 defendant Hunter John husbandman 586956 586956 Hunter, John, of Semer, husbandman 4
5220160 2421602 2421602 defendant Arnald John husbandman 586956 586956 Arnald, John, of Semer, husbandman 5
5220161 2421602 2421602 defendant Lekynfeld Roger husbandman 610110 610110 Lekynfeld, Roger, of Flixton, husbandman 6
5220162 2421602 2421602 defendant Lekynfeld Thomas husbandman 610110 610110 Lekynfeld, Thomas, of Flixton, husbandman 7
5220163 2421602 2421602 defendant Yonge William panier man 586956 586956 Yonge, William, of Semer, panier man 8
5220164 2421602 2421602 defendant Oort Robert husbandman 586956 586956 Oort, Robert, of Semer, husbandman 9
5220165 2421602 2421602 defendant Kidde James tailor 586956 586956 Kidde, James, of Semer, tailor 10
5220166 2421602 2421602 defendant Taillour John tailor 588411 588411 Taillour, John, of Irton, tailor 11
5220167 2421602 2421602 defendant Gryme Robert   860751 860751 Gryme, Robert, of Shirburn in Harforthlythe, cartwright 12
5220168 2421602 2421602 defendant Rouse Robert husbandman 860751 860751 Rouse, Robert, of Shirburn in Harforthlythe, husbandman 13
5220169 2421602 2421602 defendant Scruby Richard laborer 632496 632496 Scruby, Richard, of Wresyll, laborer 14
5220170 2421602 2421602 defendant Barneby John husbandman 594426 594426 Barneby, John, of Benyngton, husbandman 15
5220171 2421602 2421602 defendant Cook James husbandman 785688 785688 Cook, James, of Willerdby, husbandman 16
5220172 2421602 2421602 defendant Cusson John husbandman 610578 610578 Cusson, John, of Scamston, husbandman 17
5220173 2421602 2421602 defendant Squyer Thomas husbandman 610578 610578 Squyer, Thomas, of Scamston, husbandman 18
5220174 2421602 2421602 defendant Waade Richard husbandman 610578 610578 Waade, Richard, of Scamston, husbandman 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);