names

13 rows where case_id = 2050314

✎ 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
4072073 2050314 2050314 plaintiff Norton William     Norton, William 0
4072074 2050314 2050314 defendant Bradley Nicholas currier 589754 589754 Bradley, Nicholas, of Harleston, Norf, currier 0
4072075 2050314 2050314 defendant Bradley Thomas cuturrier 586361 586361 Bradley, Thomas, of Harleston, gelder, cuturrier 1
4072076 2050314 2050314 defendant Burley Christopher tailor 586361 586361 Burley, Christopher, of Harleston, tailor 2
4072077 2050314 2050314 defendant Fluk Edmund merchant 586134 586134 Fluk, Edmund, of Ipswich, merchant 3
4072078 2050314 2050314 defendant Kede Richard   687637 687637 Kede, Richard, of Dalynge, Suff, surgeon 4
4072079 2050314 2050314 defendant Bayman Christopher gent 687638 687638 Bayman, Christopher, of Marlesforde, Suff, gent 5
4072080 2050314 2050314 defendant Seymer Thomas   586361 586361 Seymer, Thomas, of Harleston, surgeon 6
4072081 2050314 2050314 defendant Pole Thomas husbandman 651272 651272 Pole, Thomas, of Alboroughe, Norf, husbandman 7
4072082 2050314 2050314 defendant Androwes William yeoman 605370 605370 Androwes, William, of Wotton, Norf, yeoman 8
4072083 2050314 2050314 defendant Howell William yeoman 687640 687640 Howell, William, of Russell, Norf, yeoman 9
4072084 2050314 2050314 defendant Davye Robert tailor 586361 586361 Davye, Robert, of Harleston, tailor 10
4072085 2050314 2050314 defendant Davye Edward yeoman 591025 591025 Davye, Edward, of Lowestofte, Suff, yeoman 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);