names

16 rows where case_id = 2439331

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5280339 2439331 2439331 plaintiff Bysshop John   586516 586516 Bysshop, John, of Marsham 0
5280340 2439331 2439331 defendant Rotheron Edward yeoman 587182 587182 Rotheron, Edward, of Blakeney, merchant, or of Weveton, yeoman 0
5280341 2439331 2439331 defendant Molle Thomas courser 588220 588220 Molle, Thomas, of Wesenham, courser 1
5280342 2439331 2439331 defendant Dey John husbandman 615541 615541 Dey, John, of Geyton, husbandman 2
5280343 2439331 2439331 defendant Payn William parson of Denver   Payn, William, parson of Denver 3
5280344 2439331 2439331 defendant Dory Thomas yeoman 589928 589928 Dory, Thomas, of Mendham, yeoman 4
5280345 2439331 2439331 defendant Yoxale Robert yeoman 596907 596907 Yoxale, Robert, of Ludham, yeoman 5
5280346 2439331 2439331 defendant Martyn Mathew husbandman 586471 586471 Martyn, Mathew, of Aylesham, husbandman 6
5280347 2439331 2439331 defendant Pomeys John yeoman 868083 868083 Pomeys, John, of Runtn juxta Mare, yeoman 7
5280348 2439331 2439331 defendant Emneth Richard   585936 585936 Emneth, Richard, of Norwich, mason 8
5280349 2439331 2439331 defendant Stylberd Valery yeoman 590879 590879 Stylberd, Valery, of Skulthorp, yeoman 9
5280350 2439331 2439331 defendant Estwayte John chaplain 586180 586180 Estwayte, John, of Bury St Edmunds, chaplain 10
5280351 2439331 2439331 defendant Thorn John butcher 586364 586364 Thorn, John, of Long Stratton, butcher 11
5280352 2439331 2439331 defendant Hardyngham Thomas (legal representative)   Hardyngham, Thomas, executors of 12
5280353 2439331 2439331 defendant Hardyngham William clerk 589043 589043 (Hardyngham, William, of North Byrlyngham, clerk 13
5280354 2439331 2439331 defendant Hardyngham Thomas yeoman 607836 607836 Hardyngham, Thomas, of Sloley, yeoman 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);