names

16 rows where case_id = 2435575

✎ 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
5267420 2435575 2435575 plaintiff Wychecotys John esq, sheriff of Lincs   Wychecotys, John, esq, sheriff of Lincs 0
5267421 2435575 2435575 defendant Shyngelherst William husbandman 866177 866177 Shyngelherst, William, of Braunson, husbandman 0
5267422 2435575 2435575 defendant Shyngelherst Robert yeoman 624094 624094 Shyngelherst, Robert, of Wassyngburgh, yeoman 1
5267423 2435575 2435575 defendant Cook John husbandman 624094 624094 Cook, John, of of Wassyngburgh, husbandman 2
5267424 2435575 2435575 defendant Yoman Robert yeoman 866179 866179 Yoman, Robert, of Weste Wyllughby, yeoman 3
5267425 2435575 2435575 defendant Manwer William husbandman 642561 642561 Manwer, William, of Kyrkby Laythorp, husbandman 4
5267426 2435575 2435575 defendant Bate John husbandman 632267 632267 Bate, John, of Old Sleford, husbandman 5
5267427 2435575 2435575 defendant Thomlynson Simon husbandman 589413 589413 Thomlynson, Simon, of Aswardby, husbandman 6
5267428 2435575 2435575 defendant Alverton or Alnerton William yeoman 599982 599982 Alverton or Alnerton, William, of Fulbek, yeoman 7
5267429 2435575 2435575 defendant Sele John yeoman 611632 611632 Sele, John, of Grauntham, yeoman 8
5267430 2435575 2435575 defendant Mares William   599982 599982 Mares, William, of Fulbek, franklin 9
5267431 2435575 2435575 defendant Cokson William husbandman 650801 650801 Cokson, William, of Sudbroke juxta Ancaster, husbandman 10
5267432 2435575 2435575 defendant Holland William yeoman 667227 667227 Holland, William, of Ledenham, yeoman 11
5267433 2435575 2435575 defendant Honley or Houley John yeoman 589723 589723 Honley or Houley, John, of Botheby, yeoman 12
5267434 2435575 2435575 defendant Gleddale William yeoman 866182 866182 Gleddale, William, of Scopwyke, yeoman 13
5267435 2435575 2435575 defendant Watson William yeoman 764271 764271 Watson, William, of Skynnand, yeoman 14

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