names

15 rows where case_id = 2478917

✎ 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
5413322 2478917 2478917 plaintiff Frankessh John     Frankessh, John, on his own account 0
5413323 2478917 2478917 defendant Turnour Robert yeoman 586365 586365 Turnour, Robert, of Wymondham, yeoman 0
5413324 2478917 2478917 defendant Bolytout Walter husbandman 592200 592200 Bolytout, Walter, of Aslakton, husbandman 1
5413325 2478917 2478917 defendant Toft John   593151 593151 Toft, John, of Homersfeld, pedlar 2
5413326 2478917 2478917 defendant Spark John husbandman 592833 592833 Spark, John, of Wakton, husbandman 3
5413327 2478917 2478917 defendant Goldsmyth John husbandman 586559 586559 Goldsmyth, John, of Topcroft, husbandman 4
5413328 2478917 2478917 defendant Calf Thomas husbandman 586559 586559 Calf, Thomas, of Topcroft, husbandman 5
5413329 2478917 2478917 defendant Middelton Robert gent 592005 592005 Middelton, Robert, of Mendham, Suff, gent 6
5413330 2478917 2478917 defendant Roper Richard chaplain 621736 621736 Roper, Richard, of Shetesham, chaplain 7
5413331 2478917 2478917 defendant Brill John husbandman 586170 586170 Brill, John, of Tybenham, husbandman 8
5413332 2478917 2478917 defendant Pyle John chaplain 586102 586102 Pyle, John, of Hengham, chaplain 9
5413333 2478917 2478917 defendant Harecroft John husbandman 586365 586365 Harecroft, John, of Wymondham, husbandman 10
5413334 2478917 2478917 defendant Langford John husbandman 586365 586365 Langford, John, of Wymondham, husbandman 11
5413335 2478917 2478917 defendant Willyams Joan widow 600449 600449 Willyams, Joan, of Boston, Lincs, widow 12
5413336 2478917 2478917 defendant Gauge Thomas (legal representative) 602392 602392 Gauge, Thomas, of Helgey, husbandman, administrator of 13

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