names

16 rows where case_id = 2402279

✎ 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
5153832 2402279 2402279 plaintiff Kneseworth Richard     Kneseworth, Richard 0
5153833 2402279 2402279 plaintiff Kneseworth Elizabeth     Elizabeth, his wife 1
5153834 2402279 2402279 defendant Reyd Gerard gent 594060 594060 Reyd, Gerard, of Whaddon, gent 0
5153835 2402279 2402279 defendant Lyly John butcher 594060 594060 Lyly, John, of Whaddon, butcher 1
5153836 2402279 2402279 defendant Lyly Alice     Alice, his wife 2
5153837 2402279 2402279 defendant Chapman Christine widow 594060 594060 Chapman, Christine, of Whaddon, widow 3
5153838 2402279 2402279 defendant Smyth Henry smith 594060 594060 Smyth, Henry, of Whaddon, smith 4
5153839 2402279 2402279 defendant Chapman William of Whaddon husbandman   Chapman, William of Whaddon, husbandman 5
5153840 2402279 2402279 defendant Hoket William husbandman 594060 594060 Hoket, William, of Whaddon, husbandman 6
5153841 2402279 2402279 defendant Chapman John husbandman 594060 594060 Chapman, John, of Whaddon, husbandman 7
5153842 2402279 2402279 defendant Scalys John laborer 594060 594060 Scalys, John, of Whaddon, laborer 8
5153843 2402279 2402279 defendant Wangeworth Richard laborer 594060 594060 Wangeworth, Richard, of Whaddon, laborer 9
5153844 2402279 2402279 defendant Spycer William husbandman 594060 594060 Spycer, William, of Whaddon, husbandman 10
5153845 2402279 2402279 defendant Loney Williamm laborer 594060 594060 Loney, Williamm, of Whaddon, laborer 11
5153846 2402279 2402279 defendant Ver William laborer 594060 594060 Ver, William, of Whaddon, laborer 12
5153847 2402279 2402279 defendant Broke William laborer 594060 594060 Broke, William, of Whaddon, laborer 13

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