names

21 rows where case_id = 2318217

✎ 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
4871995 2318217 2318217 plaintiff Neuport William     Neuport, William 0
4871996 2318217 2318217 defendant Haslore John chaplain 815512 815512 Haslore, John, of Herluston, chaplain 0
4871997 2318217 2318217 defendant Strangulford John mercer 590430 590430 Strangulford, John, of Lichfeld, mercer 1
4871998 2318217 2318217 defendant Sadeler John saddler 590430 590430 Sadeler, John, of Lichfeld, saddler 2
4871999 2318217 2318217 defendant Yoxhale John barker 588037 588037 Yoxhale, John, of Lichefeld, barker 3
4872000 2318217 2318217 defendant Stubbes John, junior walker 588037 588037 Stubbes, John, junior, of Lichefeld, walker 4
4872001 2318217 2318217 defendant Sporiour Bernard spurrier 588037 588037 Sporiour, Bernard, of Lichefeld, spurrier 5
4872002 2318217 2318217 defendant Gresbroke John husbandman 600025 600025 Gresbroke, John, of Shenston, husbandman 6
4872003 2318217 2318217 defendant Kegworth Thomas yeoman 588037 588037 Kegworth, Thomas, of Lichefeld, yeoman 7
4872004 2318217 2318217 defendant Tyler Thomas tiler 588037 588037 Tyler, Thomas, of Lichefeld, tiler 8
4872005 2318217 2318217 defendant Sutton John weaver 588037 588037 Sutton, John, of Lichefeld, weaver 9
4872006 2318217 2318217 defendant Jaundys William laborer 588037 588037 Jaundys, William, of Lichefeld, laborer 10
4872007 2318217 2318217 defendant Halsey Richard husbandman 815513 815513 Halsey, Richard, of le Walle, husbandman 11
4872008 2318217 2318217 defendant London Thomas   588037 588037 London, Thomas, of Lichefeld, cook 12
4872009 2318217 2318217 defendant Gatton Robert saddler 588037 588037 Gatton, Robert, of Lichefeld, saddler 13
4872010 2318217 2318217 defendant Whityngton John glover 588037 588037 Whityngton, John, of Lichefeld, glover 14
4872011 2318217 2318217 defendant Ostiler John ostler 588037 588037 Ostiler, John, of Lichefeld, ostler 15
4872012 2318217 2318217 defendant Fermer John collier 588037 588037 Fermer, John, of Lichefeld, collier 16
4872013 2318217 2318217 defendant Liwerch John cordwainer 588037 588037 Liwerch, John, of Lichefeld, cordwainer 17
4872014 2318217 2318217 defendant Palmer John, senior mercer 588037 588037 Palmer, John, senior, of Lichefeld, mercer 18
4872015 2318217 2318217 defendant Bednall William tailor 588037 588037 Bednall, William, of Lichefeld, tailor 19

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