names

14 rows where case_id = 2405828

✎ 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
5166125 2405828 2405828 plaintiff Brounflete Henry knight   Brounflete, Henry, knight 0
5166126 2405828 2405828 defendant Wardrop Robert yeoman 589152 589152 Wardrop, Robert, of Strensall, yeoman 0
5166127 2405828 2405828 defendant Wardrop William yeoman 589152 589152 Wardrop, William, of Strensall, yeoman 1
5166128 2405828 2405828 defendant Fyshburn Robert esq 769568 769568 Fyshburn, Robert, of Ayremyn, esq 2
5166129 2405828 2405828 defendant Burgh William esq 702669 702669 Burgh, William, of Sheryf Hoton, esq 3
5166130 2405828 2405828 defendant Venslowe Richard esq 769568 769568 Venslowe, Richard, of Ayremyn, esq 4
5166131 2405828 2405828 defendant Hardgate Richard yeoman 702669 702669 Hardgate, Richard, of Sheryf Hoton, yeoman 5
5166132 2405828 2405828 defendant Walfon Henry yeoman 602734 602734 Walfon, Henry, of Bawtre, yeoman 6
5166133 2405828 2405828 defendant Jamesson James yeoman 855315 855315 Jamesson, James, of Eleyngton, yeoman 7
5166134 2405828 2405828 defendant Whitlase Richard clerk 852857 852857 Whitlase, Richard, of Hothom, clerk 8
5166135 2405828 2405828 defendant Peirson Robert husbandman 595431 595431 Peirson, Robert, of North Cave, husbandman 9
5166136 2405828 2405828 defendant Hall John yeoman 670405 670405 Hall, John, of Burton Stather, Lincs, yeoman 10
5166137 2405828 2405828 defendant Mangall Robert yeoman 855316 855316 Mangall, Robert, of Roclyff, in Snayth, Yorks, yeoman 11
5166138 2405828 2405828 defendant Baron William yeoman 855317 855317 Baron, William, of Temple Hirste, Yorks, yeoman 12

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