names

13 rows where case_id = 1871461

✎ 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
3612216 1871461 1871461 plaintiff Hubert James     Hubert, James 0
3612217 1871461 1871461 defendant Mersshe William husbandman 590080 590080 Mersshe, William, of Ifeld, husbandman 0
3612218 1871461 1871461 defendant Bregger Thomas husbandman 590080 590080 Bregger, Thomas, of Ifeld, husbandman 1
3612219 1871461 1871461 defendant Valantyne John yeoman 588651 588651 Valantyne, John, of Charlewode, Surrey, yeoman 2
3612220 1871461 1871461 defendant Taby henry laborer 593521 593521 Taby, henry, of Horley, Surrey, laborer 3
3612221 1871461 1871461 defendant Weller Thomas fletcher 593522 593522 Weller, Thomas, of Wourth, fletcher 4
3612222 1871461 1871461 defendant Bawant Richard laborer 591572 591572 Bawant, Richard, of Crawley, laborer 5
3612223 1871461 1871461 defendant Topsell William, junior laborer 593522 593522 Topsell, William, junior, of Wourth, laborer 6
3612224 1871461 1871461 defendant Chamberleyn John laborer 593522 593522 Chamberleyn, John, of Wourth, laborer 7
3612225 1871461 1871461 defendant Robynson John laborer 593522 593522 Robynson, John, of Wourth, laborer 8
3612226 1871461 1871461 defendant Albourn Thomas laborer 593522 593522 Albourn, Thomas, of Wourth, laborer 9
3612227 1871461 1871461 defendant Hert William laborer 593522 593522 Hert, William, of Wourth, laborer 10
3612228 1871461 1871461 defendant Sawyer George laborer 591572 591572 Sawyer, George, of Crawley, laborer 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);