names

15 rows where case_id = 2030074

✎ 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
4015023 2030074 2030074 plaintiff Skynner Richard gent, attorney of the bench   Skynner, Richard, gent, attorney of the bench 0
4015024 2030074 2030074 defendant Leke William butcher 591619 591619 Leke, William, of Cryngelford, butcher 0
4015025 2030074 2030074 defendant Anderson William husbandman 603370 603370 Anderson, William, of Lynne, husbandman 1
4015026 2030074 2030074 defendant Browne William husbandman 586365 586365 Browne, William, of Wymondham, husbandman 2
4015027 2030074 2030074 defendant Mone Thomas husbandman 660639 660639 Mone, Thomas, of Hoston, husbandman 3
4015028 2030074 2030074 defendant Parke Thomas husbandman 591106 591106 Parke, Thomas, of Depeham, husbandman 4
4015029 2030074 2030074 defendant Webster John husbandman 597666 597666 Webster, John, of Garveston, husbandman 5
4015030 2030074 2030074 defendant Moneyman William yeoman 588447 588447 Moneyman, William, of Aylysham, yeoman 6
4015031 2030074 2030074 defendant Bennett William clerk 612114 612114 Bennett, William, of Bunwell, clerk 7
4015032 2030074 2030074 defendant Ussher Simon   612752 612752 Ussher, Simon, of Sheringham, ship master 8
4015033 2030074 2030074 defendant Russheborowe Thomas yeoman 634838 634838 Russheborowe Thomas, of Hobbes, yeoman 9
4015034 2030074 2030074 defendant Auncell John (legal representative)   Auncell, John, executors of 10
4015035 2030074 2030074 defendant Warner John yeoman 601978 601978 (Warner, John, of Skornston, yeoman 11
4015036 2030074 2030074 defendant Wyllesey Richard (legal representative) 602137 602137 Wyllesey, Richard, of Ingworth, husbandman, administratrix of 12
4015037 2030074 2030074 defendant Wyllesey Alice widow 602137 602137 Wyllesey, Alice, of Ingworth, widow 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);