names

13 rows where case_id = 2323614

✎ 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
4889841 2323614 2323614 plaintiff Chapman Richard   635177 635177 Chapman, Richard, of Wodestoke 0
4889842 2323614 2323614 defendant Gorwey Robert pewterer 585869 585869 Gorwey, Robert, of London, pewterer 0
4889843 2323614 2323614 defendant Sheffeld John fletcher 585869 585869 Sheffeld, John, of London, fletcher 1
4889844 2323614 2323614 defendant Yonge William fishmonger 585869 585869 Yonge, William, of London, fishmonger 2
4889845 2323614 2323614 defendant Tele John   585869 585869 Tele, John, of London, pie baker 3
4889846 2323614 2323614 defendant Burton John   585869 585869 Burton, John, of London, mason 4
4889847 2323614 2323614 defendant Trippelowe Nicholas fishmonger 585869 585869 Trippelowe, Nicholas, of London, fishmonger 5
4889848 2323614 2323614 defendant Hamond Thomas bowyer 585869 585869 Hamond, Thomas, of London, bowyer 6
4889849 2323614 2323614 defendant Swansey Thomas tailor 585869 585869 Swansey, Thomas, of London, tailor 7
4889850 2323614 2323614 defendant Buntynge Thomas tailor 585869 585869 Buntynge, Thomas, of London, tailor 8
4889851 2323614 2323614 defendant Stacy John glover 585869 585869 Stacy, John, of London, glover 9
4889852 2323614 2323614 defendant Lynke John butcher 585869 585869 Lynke, John, of London, butcher 10
4889853 2323614 2323614 defendant Stevenes Robert butcher 585869 585869 Stevenes, Robert, of London, butcher 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);