names

30 rows where case_id = 2350432

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4978155 2350432 2350432 plaintiff Brugge Joan     Brugge, Joan 0
4978156 2350432 2350432 plaintiff Stucle Hugh     Stucle, Hugh 1
4978157 2350432 2350432 defendant Langelegh Walter gent 709207 709207 Langelegh, Walter, of Ilfardecombe, gent 0
4978158 2350432 2350432 defendant Gadlyng John butcher 709207 709207 Gadlyng, John, of Ilfardecombe, butcher 1
4978159 2350432 2350432 defendant Blake Thomas merchant 709207 709207 Blake, Thomas, of Ilfardecombe, merchant 2
4978160 2350432 2350432 defendant Wyke Ancelm seaman 709207 709207 Wyke, Ancelm, of Ilfardecombe, seaman 3
4978161 2350432 2350432 defendant Penryse Richard gent 709207 709207 Penryse, Richard, of Ilfardecombe, gent 4
4978162 2350432 2350432 defendant Dyer Thomas yeoman 709207 709207 Dyer, Thomas, of Ilfardecombe, yeoman 5
4978163 2350432 2350432 defendant Bealle Robert laborer 709207 709207 Bealle, Robert, of Ilfardecombe, laborer 6
4978164 2350432 2350432 defendant Brydde Walter seaman 709207 709207 Brydde, Walter, of Ilfardecombe, seaman 7
4978165 2350432 2350432 defendant Gubbe John, junior seaman 709207 709207 Gubbe, John, junior, of Ilfardecombe, seaman 8
4978166 2350432 2350432 defendant Dyryke John shipman 709207 709207 Dyryke, John, of Ilfardecombe, shipman 9
4978167 2350432 2350432 defendant Godelyng John butcher 709207 709207 Godelyng, John, of Ilfardecombe, butcher 10
4978168 2350432 2350432 defendant Fosse Richard husbandman 709207 709207 Fosse, Richard, of Ilfardecombe, husbandman 11
4978169 2350432 2350432 defendant Bounte Richard seaman 709207 709207 Bounte, Richard, of Ilfardecombe, seaman 12
4978170 2350432 2350432 defendant Hoper John seaman 709207 709207 Hoper, John, of Ilfardecombe, seaman 13
4978171 2350432 2350432 defendant Frensheman Adam   709207 709207 Frensheman, Adam, of Ilfardecombe, groom 14
4978172 2350432 2350432 defendant Auncell Thomas seaman 709207 709207 Auncell, Thomas, of Ilfardecombe, seaman 15
4978173 2350432 2350432 defendant Bawele John of Ilfardecombe husbandman   Bawele, John of Ilfardecombe, husbandman 16
4978174 2350432 2350432 defendant Bawle Thomas husbandman 709207 709207 Bawle, Thomas, of Ilfardecombe, husbandman 17
4978175 2350432 2350432 defendant Bayne John weaver 709207 709207 Bayne, John, of Ilfardecombe, weaver 18
4978176 2350432 2350432 defendant Rowe Thomas shipman 709207 709207 Rowe, Thomas, of Ilfardecombe, shipman 19
4978177 2350432 2350432 defendant Rokebeare John butcher 709207 709207 Rokebeare, John, of Ilfardecombe, butcher 20
4978178 2350432 2350432 defendant Pytman Henry weaver 709207 709207 Pytman, Henry, of Ilfardecombe, weaver 21
4978179 2350432 2350432 defendant Dyer John husbandman 709207 709207 Dyer, John, of Ilfardecombe, husbandman 22
4978180 2350432 2350432 defendant Colyford John, senior husbandman 709207 709207 Colyford, John, senior, of Ilfardecombe, husbandman 23
4978181 2350432 2350432 defendant Duke Thomas weaver 709207 709207 Duke, Thomas, of Ilfardecombe, weaver 24
4978182 2350432 2350432 defendant Robert Richard, junior laborer 709207 709207 Robert, Richard, junior, of Ilfardecombe, laborer 25
4978183 2350432 2350432 defendant Edward John hooper 709207 709207 Edward John, of Ilfardecombe, hooper 26
4978184 2350432 2350432 defendant Wythere William laborer 709207 709207 Wythere, William, of Ilfardecombe, laborer 27

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);