names

16 rows where case_id = 2483459

✎ 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
5428524 2483459 2483459 plaintiff Frankessh John     Frankessh, John, on his own account 0
5428525 2483459 2483459 defendant Turnour Robert yeoman 586365 586365 Turnour, Robert, of Wymondham, yeoman 0
5428526 2483459 2483459 defendant Bolitout Walter husbandman 592200 592200 Bolitout, Walter, of Aslakton, husbandman 1
5428527 2483459 2483459 defendant Toft John   693199 693199 Toft, John, of Homersfeld, Suff, pedlar 2
5428528 2483459 2483459 defendant Spark John husbandman 592833 592833 Spark, John, of Wakton, husbandman 3
5428529 2483459 2483459 defendant Goldsmyth John husbandman 586559 586559 Goldsmyth, John, of Topcroft, husbandman 4
5428530 2483459 2483459 defendant Calf Thomas husbandman 586559 586559 Calf, Thomas, of Topcroft, husbandman 5
5428531 2483459 2483459 defendant Middelton Robert gent 592005 592005 Middelton, Robert, of Mendham, Suff, gent 6
5428532 2483459 2483459 defendant Roper Richard chaplain 589536 589536 Roper, Richard, of Shotesham, chaplain 7
5428533 2483459 2483459 defendant Brill John husbandman 586170 586170 Brill, John, of Tybenham, husbandman 8
5428534 2483459 2483459 defendant Pyle John chaplain 586102 586102 Pyle, John, of Hengham, chaplain 9
5428535 2483459 2483459 defendant Harecroft John husbandman 586365 586365 Harecroft, John, of Wymondham, husbandman 10
5428536 2483459 2483459 defendant Langford John husbandman 586365 586365 Langford, John, of Wymondham, husbandman 11
5428537 2483459 2483459 defendant Wyllyams Joan widow 600449 600449 Wyllyams, Joan, of Boston, LIncs, widow 12
5428538 2483459 2483459 defendant Gauge Thomas (legal representative) 602392 602392 Gauge, Thomas, of Helgey, husbandman, administrator of 13
5428539 2483459 2483459 defendant Gauge Richard butcher 768951 768951 Gauge, Richard, of 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);