names

13 rows where case_id = 2483467

✎ 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
5428561 2483467 2483467 plaintiff Frenkessh John     Frenkessh, John, on his own account 0
5428562 2483467 2483467 defendant Turnour Robert yeoman 586365 586365 Turnour, Robert, of Wymondham, yeoman 0
5428563 2483467 2483467 defendant Bolitout Walter husbandman 592200 592200 Bolitout, Walter, of Aslakton, husbandman 1
5428564 2483467 2483467 defendant Toft John   693199 693199 Toft, John, of Homersfeld, Suff, pedlar 2
5428565 2483467 2483467 defendant Spark John husbandman 592833 592833 Spark, John, of Wakton, husbandman 3
5428566 2483467 2483467 defendant Goldsmyth John husbandman 586559 586559 Goldsmyth, John, of Topcroft, husbandman 4
5428567 2483467 2483467 defendant Roper Richard chaplain 589536 589536 Roper, Richard, of Shotesham, chaplain 5
5428568 2483467 2483467 defendant Bryll John husbandman 586170 586170 Bryll, John, of Tybenham, husbandman 6
5428569 2483467 2483467 defendant Pyke John chaplain 586102 586102 Pyke, John, of Hengham, chaplain 7
5428570 2483467 2483467 defendant Harecroft John husbandman 586365 586365 Harecroft, John, of Wymondham, husbandman 8
5428571 2483467 2483467 defendant Wyllyams Joan widow 600449 600449 Wyllyams, Joan, of Boston, Lincs, widow 9
5428572 2483467 2483467 defendant Gauge Thomas (legal representative) 603876 603876 Gauge, Thomas, of Helgay, husbandman, administrator of 10
5428573 2483467 2483467 defendant Gauge Richard butcher 589617 589617 Gauge, Richard, of Dounham Marker, butcher 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);