names

13 rows where case_id = 2361995

✎ 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
5017451 2361995 2361995 plaintiff Chestre Richard clerk   Chestre, Richard, clerk 0
5017452 2361995 2361995 defendant Evysby John parson of Fulbek, Lincs   Evysby, John, parson of Fulbek, Lincs 0
5017453 2361995 2361995 defendant (not given) Robert bishop of Holen in Iceland   Holen in Iceland, Robert, bishop of 1
5017454 2361995 2361995 defendant Warde Thomas chapman 674079 674079 Warde, Thomas, of Est Rasyn, Lincs, chapman 2
5017455 2361995 2361995 defendant Scotson Robert husbandman 835660 835660 Scotson, Robert, of Bulke, Lancs, husbandman 3
5017456 2361995 2361995 defendant Abell Henry husbandman 644512 644512 Abell, Henry, of Willesdon, Middx, husbandman 4
5017457 2361995 2361995 defendant Napay Thomas husbandman 674959 674959 Napay, Thomas, of Halton, Lincs, husbandman 5
5017458 2361995 2361995 defendant Hesam Richard husbandman 835661 835661 Hesam, Richard, of Slyne, Lincs, husbandman 6
5017459 2361995 2361995 defendant Wodde William smith 608035 608035 Wodde, William, of Lancaster, smith 7
5017460 2361995 2361995 defendant Raby Richard husbandman 835662 835662 Raby, Richard, of Aldeclyffe, Lancs, husbandman 8
5017461 2361995 2361995 defendant Tyther John   596382 596382 Tyther, John, of Donyngton, Lincs, merchant, administrators of 9
5017462 2361995 2361995 defendant Mader John husbandman 834301 834301 (Mader, John, of Benyngworth, Lincs, husbandman 10
5017463 2361995 2361995 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);