names

11 rows where case_id = 2500092

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5483764 2500092 2500092 plaintiff Longe Henry esq   Longe, Henry, esq 0
5483765 2500092 2500092 plaintiff Perquyns John clerk   Perquyns, John, clerk 1
5483766 2500092 2500092 plaintiff Hobbys Thomas clerk   Hobbys, Thomas, clerk 2
5483767 2500092 2500092 plaintiff Lambe John     Lambe, John 3
5483768 2500092 2500092 defendant Tarrant Thomas yeoman 599282 599282 Tarrant, Thomas, of Enford, yeoman 0
5483769 2500092 2500092 defendant Chancy Henry yeoman 690191 690191 Chancy, Henry, of Charlton, yeoman 1
5483770 2500092 2500092 defendant Floure John gent 592465 592465 Floure, John, of Worton, gent 2
5483771 2500092 2500092 defendant Bonde William husbandman 593513 593513 Bonde, William, of Staunton, husbandman 3
5483772 2500092 2500092 defendant Vycarryes William husbandman 892098 892098 Vycarryes, William, of Colke, husbandman 4
5483773 2500092 2500092 defendant Benet William husbandman 892099 892099 Benet, William, of Erchesont, husbandman 5
5483774 2500092 2500092 defendant Pope Nicholas clerk 892100 892100 Pope, Nicholas, of Orston St Mary, clerk 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);