names

20 rows where case_id = 2318218

✎ 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
4872016 2318218 2318218 plaintiff Neuport William     Neuport, William 0
4872017 2318218 2318218 defendant Haslore John chaplain 815512 815512 Haslore, John, of Herluston, chaplain 0
4872018 2318218 2318218 defendant Strangulford John mercer 597973 597973 Strangulford, John, of Lychfeld, mercer 1
4872019 2318218 2318218 defendant Sadeler John saddler 590430 590430 Sadeler, John, of Lichfeld, saddler 2
4872020 2318218 2318218 defendant Yoxhale John barker 590430 590430 Yoxhale, John, of Lichfeld, barker 3
4872021 2318218 2318218 defendant Stubbes John, senior walker 590430 590430 Stubbes, John, senior, of Lichfeld, walker 4
4872022 2318218 2318218 defendant Sporyour Bernard spurrier 588037 588037 Sporyour, Bernard, of Lichefeld, spurrier 5
4872023 2318218 2318218 defendant Bresbroke John husbandman 600025 600025 Bresbroke, John, of Shenston, husbandman 6
4872024 2318218 2318218 defendant Kegworth Thomas yeoman 590430 590430 Kegworth, Thomas, of Lichfeld, yeoman 7
4872025 2318218 2318218 defendant Tyler Thomas tiler 590430 590430 Tyler, Thomas, of Lichfeld, tiler 8
4872026 2318218 2318218 defendant Sutton John weaver 590430 590430 Sutton, John, of Lichfeld, weaver 9
4872027 2318218 2318218 defendant Halsey Richard husbandman 642667 642667 Halsey, Richard, of Walle, husbandman 10
4872028 2318218 2318218 defendant London Thomas   590430 590430 London, Thomas, of Lichfeld, cook 11
4872029 2318218 2318218 defendant Whityngton John glover 590430 590430 Whityngton, John, of Lichfeld, glover 12
4872030 2318218 2318218 defendant Liwerch John laborer 815515 815515 Liwerch, John, of Lichfeld, cordwainer, together with Jaundys, William, of Lichfeld, laborer 13
4872031 2318218 2318218 defendant Gatton Robert saddler 590430 590430 Gatton, Robert, of Lichfeld, saddler 14
4872032 2318218 2318218 defendant Ostiler John ostler 590430 590430 Ostiler, John, of Lichfeld, ostler 15
4872033 2318218 2318218 defendant Fermer John collier 590430 590430 Fermer, John, of Lichfeld, collier 16
4872034 2318218 2318218 defendant Palmer John, senior mercer 590430 590430 Palmer, John, senior, of Lichfeld, mercer 17
4872035 2318218 2318218 defendant Bednall William tailor 590430 590430 Bednall, William, of Lichfeld, tailor 18

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