names

14 rows where case_id = 2491764

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5456171 2491764 2491764 plaintiff Bysshop John gent 585936 585936 Bysshop, John, of Norwich, gent, on his own account 0
5456172 2491764 2491764 defendant Eston Robert gent 589752 589752 Eston, Robert, of Eston, Suff, gent 0
5456173 2491764 2491764 defendant Wyllys William yeoman 603616 603616 Wyllys, William, of Cley next the sea, yeoman 1
5456174 2491764 2491764 defendant Corne William innholder 585936 585936 Corne, William, of Norwich, innholder 2
5456175 2491764 2491764 defendant Mone Thomas husbandman 589537 589537 Mone, Thomas, of Banburgh, husbandman 3
5456176 2491764 2491764 defendant Noteman John husbandman 703866 703866 Noteman, John, of Burnham St Andrew, husbandman 4
5456177 2491764 2491764 defendant Grogon Walter husbandman 887535 887535 Grogon, Walter, of Burnham Ulph, husbandman 5
5456178 2491764 2491764 defendant Everard Henry husbandman 889516 889516 Everard, Henry, of Aclef, husbandman 6
5456179 2491764 2491764 defendant Lenot John yeoman 585936 585936 Lenot, John, of Norwich, yeoman 7
5456180 2491764 2491764 defendant Thwayte Richard husbandman 601424 601424 Thwayte, Richard, of Stanynghale, husbandman 8
5456181 2491764 2491764 defendant Hulle John husbandman 587294 587294 Hulle, John, of Todyngton, husbandman 9
5456182 2491764 2491764 defendant Galte John husbandman 889517 889517 Galte, John, of Burgh next Aylesham, husbandman 10
5456183 2491764 2491764 defendant Brafford Richard husbandman 587294 587294 Brafford, Richard, of Todyngton, husbandman 11
5456184 2491764 2491764 defendant Elyes John husbandman 889517 889517 Elyes, John, of Burgh next Aylesham, husbandman 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);