names

14 rows where case_id = 2502319

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5491410 2502319 2502319 plaintiff Buxton Robert     Buxton, Robert 0
5491411 2502319 2502319 defendant Gryme Robert clerk 774397 774397 Gryme, Robert, of Wirlyngworth, clerk 0
5491412 2502319 2502319 defendant Hervy Robert baker 586134 586134 Hervy, Robert, of Ipswich, baker 1
5491413 2502319 2502319 defendant Torold Seman chaplain 588118 588118 Torold, Seman, of Framlyngham, chaplain 2
5491414 2502319 2502319 defendant Water Robert husbandman 622173 622173 Water, Robert, of Palgrave, husbandman 3
5491415 2502319 2502319 defendant Bysshop William yeoman 586638 586638 Bysshop, William, of Southwold, yeoman 4
5491416 2502319 2502319 defendant Lodbrook Thomas husbandman 875152 875152 Lodbrook, Thomas, of Parva Belsted, husbandman 5
5491417 2502319 2502319 defendant Nycoll John, senior yeoman 591160 591160 Nycoll, John, senior, of Tatyngton, yeoman 6
5491418 2502319 2502319 defendant Folcard Thomas yeoman 592304 592304 Folcard, Thomas, of Horham, yeoman 7
5491419 2502319 2502319 defendant Leche John husbandman 872324 872324 Leche, John, of Stratford juxta Holton, husbandman 8
5491420 2502319 2502319 defendant Godyng Richard husbandman 591160 591160 Godyng, Richard, of Tatyngton, husbandman 9
5491421 2502319 2502319 defendant Deynes John husbandman 591160 591160 Deynes, John, of Tatyngton, husbandman 10
5491422 2502319 2502319 defendant Sparwe Richard husbandman 606837 606837 Sparwe, Richard, of Levyngton, husbandman 11
5491423 2502319 2502319 defendant Pertryche William butcher 757947 757947 Pertryche, William, of Wodebregge, butcher 12

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