names

13 rows where case_id = 1963304

✎ 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
3817225 1963304 1963304 plaintiff Knyghtley William gent   Knyghtley, William, gent 0
3817226 1963304 1963304 defendant Audeney John husbandman 617565 617565 Audeney, John, of Erpyngham, husbandman 0
3817227 1963304 1963304 defendant Wright Thomas husbandman 586231 586231 Wright, Thomas, of Wygenhale, husbandman 1
3817228 1963304 1963304 defendant Broun Thoma husbandman 601865 601865 Broun, Thoma, of Tacolneston, husbandman 2
3817229 1963304 1963304 defendant Fulk John husbandman 591132 591132 Fulk, John, of Stodey, husbandman 3
3817230 1963304 1963304 defendant Symond John husbandman 626704 626704 Symond, John, of Shadwell, husbandman 4
3817231 1963304 1963304 defendant Gyn John husbandman 590846 590846 Gyn, John, of Shipdam, husbandman 5
3817232 1963304 1963304 defendant Blomfeld George husbandman 602796 602796 Blomfeld, George, of Dunham, husbandman 6
3817233 1963304 1963304 defendant Catton John husbandman 614320 614320 Catton, John, of Harlyng, husbandman 7
3817234 1963304 1963304 defendant Verdon Robert husbandman 607668 607668 Verdon, Robert, of Rudham, husbandman 8
3817235 1963304 1963304 defendant Wright John husbandman 634172 634172 Wright, John, of Pougham, husbandman 9
3817236 1963304 1963304 defendant Owold John husbandman 616257 616257 Owold, John, of Swaffham, husbandman 10
3817237 1963304 1963304 defendant Pak John painter 587751 587751 Pak, John, of Bongey, Suff, painter 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);