names

14 rows where case_id = 2393542

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5124241 2393542 2393542 plaintiff Yates John     Yates, John 0
5124242 2393542 2393542 defendant Walton William esq 700842 700842 Walton, William, of Est Walton, esq 0
5124243 2393542 2393542 defendant Home Thomas gent 596372 596372 Home, Thomas, of Hillyngton, gent 1
5124244 2393542 2393542 defendant Bacon Richard gent 622289 622289 Bacon, Richard, of Dekilburgh, gent 2
5124245 2393542 2393542 defendant Parys Thomas husbandman 825739 825739 Parys, Thomas, of Rokelond juxta Bramerton, husbandman 3
5124246 2393542 2393542 defendant Belward Walter husbandman 588641 588641 Belward, Walter, of Denton, husbandman 4
5124247 2393542 2393542 defendant Lyrlyng Richard husbandman 849163 849163 Lyrlyng, Richard, of Takylston, husbandman 5
5124248 2393542 2393542 defendant Brampton Thomas esq 591103 591103 Brampton, Thomas, of Attilburgh, esq 6
5124249 2393542 2393542 defendant Smethes Robert yeoman 587821 587821 Smethes, Robert, of South Elmham, yeoman 7
5124250 2393542 2393542 defendant Tyte Thomas husbandman 754703 754703 Tyte, Thomas, of Aldebergh, husbandman 8
5124251 2393542 2393542 defendant Orgonmaker Arnald beer bewer 585936 585936 Orgonmaker, Arnald, of Norwich, beer bewer 9
5124252 2393542 2393542 defendant Joynour William (legal representative) 598097 598097 Joynour, William,of West Wykham, executors of 10
5124253 2393542 2393542 defendant Parkyn John husbandman 614677 614677 (Parkyn, John, of Magna Lynton, Cams, husbandman 11
5124254 2393542 2393542 defendant Rogepond Richard husbandman 800924 800924 Rogepond, Richard, of West Wrottyng, Cams, 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);