names

11 rows where case_id = 2525106

✎ 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
5567629 2525106 2525106 plaintiff Dunnyng John notary, procurator general, court of Canterbury   Dunnyng, John, notary, procurator general, court of Canterbury, executors of 0
5567630 2525106 2525106 plaintiff Lettys Robert vicar of Kentysshetowne   (Lettys, Robert, vicar of Kentysshetowne 1
5567631 2525106 2525106 plaintiff Longe John procurator general, Court of Arches   Longe, John, procurator general, Court of Arches 2
5567632 2525106 2525106 plaintiff Stubbe Robert procurator general, Court of Arches   Stubbe, Robert, procurator general, Court of Arches 3
5567633 2525106 2525106 defendant Wardell John (legal representative) 900933 900933 Wardell, John, of Hampthull, Beds, clerk, executors of 0
5567634 2525106 2525106 defendant Wright Richard clerk 756661 756661 Wright, Richard, of Hampthull, clerk 1
5567635 2525106 2525106 defendant Tere John merchant 585869 585869 Tere, John, of London, merchant 2
5567636 2525106 2525106 defendant Wattys Richard clerk 593654 593654 Wattys, Richard, of Bray, Berks, clerk 3
5567637 2525106 2525106 defendant Alcat Thomas (legal representative) 649567 649567 Alcat, Thomas, of Edgeware, husbandman, executor of 4
5567638 2525106 2525106 defendant Alcat William husbandman 673787 673787 Alcat, William, of Edgeware, Middx, husbandman 5
5567639 2525106 2525106 defendant Tanne John merchant 625785 625785 Tanne, John, of Lenn, Norf, merchant 6

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