names

17 rows where case_id = 2472305

✎ 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
5390343 2472305 2472305 plaintiff Martyn John     Martyn, John 0
5390344 2472305 2472305 defendant Chapman William gent 586953 586953 Chapman, William, of Sudbury, gent 0
5390345 2472305 2472305 defendant Keell William chaplain 599075 599075 Keell, William, of Burgate, chaplain 1
5390346 2472305 2472305 defendant Birt Thomas yeoman 625260 625260 Birt, Thomas, of Watlysfeld, yeoman 2
5390347 2472305 2472305 defendant Byrlyngham Thomas butcher 625260 625260 Byrlyngham, Thomas, of Watlysfeld, butcher 3
5390348 2472305 2472305 defendant Casty_ William husbandman 590995 590995 Casty_, William, of Wortham, husbandman 4
5390349 2472305 2472305 defendant Cok Richard clothmaker 586311 586311 Cok, Richard, of Hadle, clothmaker 5
5390350 2472305 2472305 defendant Payn John carrier 591362 591362 Payn, John, of Neylond, carrier 6
5390351 2472305 2472305 defendant Mayhen James yeoman 586180 586180 Mayhen, James, of Bury St Edmunds, yeoman 7
5390352 2472305 2472305 defendant Longe John yeoman 881972 881972 Longe, John, of Battysfords, yeoman 8
5390353 2472305 2472305 defendant Leche (illegible) tanner 879468 879468 Leche, _, of Stratford by Higham, tanner 9
5390354 2472305 2472305 defendant Byrlyngham Thomas   585968 585968 Byrlyngham, Thomas, of Beclys, , tallow chandler 10
5390355 2472305 2472305 defendant Baker John husbandman 585968 585968 Baker, John, of Beclys, husbandman 11
5390356 2472305 2472305 defendant Broun John husbandman 600137 600137 Broun, John, of Cokfeld, husbandman 12
5390357 2472305 2472305 defendant Clement John carpenter 585937 585937 Clement, John, of Bylston, carpenter 13
5390358 2472305 2472305 defendant Beward John husbandman 586143 586143 Beward, John, of Norton, husbandman 14
5390359 2472305 2472305 defendant Donyaunt William chandler 773715 773715 Donyaunt, William, of Halysworth, chandler 15

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