names

12 rows where case_id = 2428505

✎ 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
5244235 2428505 2428505 plaintiff Penyngton John (legal representative) 764702 764702 Penyngton, John, of Garmethorp, executor of 0
5244236 2428505 2428505 plaintiff Kele Robert     Kele, Robert 1
5244237 2428505 2428505 defendant Trayle John (legal representative) 764702 764702 Trayle, John, of Garmethorp, executors of 0
5244238 2428505 2428505 defendant Blounkeney William clerk 764702 764702 (Blounkeney, William, of Garmethorp, clerk 1
5244239 2428505 2428505 defendant Claxby John husbandman 863511 863511 Claxby, John, of Louthemay, husbandman 2
5244240 2428505 2428505 defendant Garnon Robert husbandman 764702 764702 Garnon, Robert, of Garmethorp, husbandman 3
5244241 2428505 2428505 defendant Trayle Joan widow 764702 764702 Trayle, Joan, of Garmethorp, widow 4
5244242 2428505 2428505 defendant Leydon William thatcher 764702 764702 Leydon, William, of Garmethorp, thatcher 5
5244243 2428505 2428505 defendant Couper Stephen   589461 589461 Couper, Stephen, of Louthe, wright 6
5244244 2428505 2428505 defendant Ludforth William laborer 631564 631564 Ludforth, William, of North Somercotys, laborer 7
5244245 2428505 2428505 defendant Underwode Robert husbandman 863512 863512 Underwode, Robert, of Fulstowemersh, husbandman 8
5244246 2428505 2428505 defendant Helwys Walter laborer 764702 764702 Helwys, Walter, of Garmethorp, laborer 9

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