names

13 rows where case_id = 1873249

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3617976 1873249 1873249 plaintiff Godwyn Richard husbandman 587314 587314 Godwyn, Richard, of Sethyng, husbandman 0
3617977 1873249 1873249 plaintiff Sponer John, senior husbandman   Sponer, John, senior, husbandman 1
3617978 1873249 1873249 plaintiff Broke Roger husbandman   Broke, Roger, husbandman 2
3617979 1873249 1873249 plaintiff Sponer John son of Sponer, Richard, husbandman   Sponer, John, son of Sponer, Richard, husbandman 3
3617980 1873249 1873249 plaintiff Sponer William husbandman   Sponer, William, husbandman 4
3617981 1873249 1873249 plaintiff Calff John husbandman   Calff, John, husbandman 5
3617982 1873249 1873249 plaintiff Colman John husbandman   Colman, John, husbandman 6
3617983 1873249 1873249 plaintiff Wodyryn Richard husbandman   Wodyryn, Richard, husbandman 7
3617984 1873249 1873249 plaintiff Stanford John husbandman   Stanford, John, husbandman 8
3617985 1873249 1873249 plaintiff Wrot John husbandman   Wrot, John, husbandman 9
3617986 1873249 1873249 plaintiff Skernyng John husbandman   Skernyng, John, husbandman 10
3617987 1873249 1873249 plaintiff French William husbandman 587314 587314 French, William, of Sethyng, husbandman 11
3617988 1873249 1873249 defendant Bettys William carpenter 586534 586534 Bettys, William, of Helmyngham, Suff, carpenter 0

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