names

16 rows where case_id = 2475171

✎ 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
5400327 2475171 2475171 plaintiff Frankessh John     Frankessh, John, on his own account 0
5400328 2475171 2475171 defendant Turnour Robert yeoman 586365 586365 Turnour, Robert, of Wymondham, yeoman 0
5400329 2475171 2475171 defendant Bolytont Walter husbandman 883375 883375 Bolytont, Walter, of Aflakton, husbandman 1
5400330 2475171 2475171 defendant Toft John   693199 693199 Toft, John, of Homersfeld, Suff, pedlar 2
5400331 2475171 2475171 defendant Spark John husbandman 592833 592833 Spark, John, of Wakton, husbandman 3
5400332 2475171 2475171 defendant Goldsmyth John husbandman 586559 586559 Goldsmyth, John, of Topcroft, husbandman 4
5400333 2475171 2475171 defendant Call Thomas husbandman 586559 586559 Call, Thomas, of Topcroft, husbandman 5
5400334 2475171 2475171 defendant Middelton Robert gent 592005 592005 Middelton, Robert, of Mendham, Suff, gent 6
5400335 2475171 2475171 defendant Roper Richard chaplain 589536 589536 Roper, Richard, of Shotesham, chaplain 7
5400336 2475171 2475171 defendant Brill John husbandman 586170 586170 Brill, John, of Tybenham, husbandman 8
5400337 2475171 2475171 defendant Pyke John chaplain 586102 586102 Pyke, John, of Hengham, chaplain 9
5400338 2475171 2475171 defendant Harecroft John husbandman 586365 586365 Harecroft, John, of Wymondham, husbandman 10
5400339 2475171 2475171 defendant Langford John husbandman 586365 586365 Langford, John, of Wymondham, husbandman 11
5400340 2475171 2475171 defendant Wyllyams Joan widow 600449 600449 Wyllyams, Joan, of Boston, LIncs, widow 12
5400341 2475171 2475171 defendant Bauge Thomas (legal representative) 602392 602392 Bauge, Thomas, of Helgey, husbandman, administrator of 13
5400342 2475171 2475171 defendant Bauge Richard Dounham Market, butcher   Bauge, Richard, Dounham Market, butcher 14

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