names

13 rows where case_id = 2361996

✎ 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
5017464 2361996 2361996 plaintiff Chestre Richard clerk   Chestre, Richard, clerk 0
5017465 2361996 2361996 defendant Evysby John parson of Fulbek, Lincs   Evysby, John, parson of Fulbek, Lincs 0
5017466 2361996 2361996 defendant (not given) Robert bishop of Holen in Iceland   Holen in Iceland, Robert, bishop of 1
5017467 2361996 2361996 defendant Warde Thomas chapman 674079 674079 Warde, Thomas, of Est Rasyn, Lincs, chapman 2
5017468 2361996 2361996 defendant Scotson Robert husbandman 835660 835660 Scotson, Robert, of Bulke, Lancs, husbandman 3
5017469 2361996 2361996 defendant Abell Henry husbandman 644512 644512 Abell, Henry, of Willesdon, Middx, husbandman 4
5017470 2361996 2361996 defendant Napy Thomas husbandman 674959 674959 Napy, Thomas, of Halton, Lincs, husbandman 5
5017471 2361996 2361996 defendant Hoseham Richard husbandman 835661 835661 Hoseham, Richard, of Slyne, Lincs, husbandman 6
5017472 2361996 2361996 defendant Wodde William smith 608035 608035 Wodde, William, of Lancaster, smith 7
5017473 2361996 2361996 defendant Raby Richard husbandman 835662 835662 Raby, Richard, of Aldeclyffe, Lancs, husbandman 8
5017474 2361996 2361996 defendant Tyther John   596382 596382 Tyther, John, of Donyngton, Lincs, merchant, administrators of 9
5017475 2361996 2361996 defendant Mader John husbandman 834301 834301 (Mader, John, of Benyngworth, Lincs, husbandman 10
5017476 2361996 2361996 defendant Mader Robert merchant 585964 585964 Mader, Robert, of Louthe, Lincs, merchant 11

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