names

21 rows where case_id = 2318219

✎ 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
4872036 2318219 2318219 plaintiff Neuport William     Neuport, William 0
4872037 2318219 2318219 defendant Jaundys William laborer 590430 590430 Jaundys, William, of Lichfeld, laborer 0
4872038 2318219 2318219 defendant Gatton Robert saddler 590430 590430 Gatton, Robert, of Lichfeld, saddler 1
4872039 2318219 2318219 defendant Ostiler John ostler 590430 590430 Ostiler, John, of Lichfeld, ostler 2
4872040 2318219 2318219 defendant Fermer John collier 590430 590430 Fermer, John, of Lichfeld, collier 3
4872041 2318219 2318219 defendant Palmer John, senior mercer 590430 590430 Palmer, John, senior, of Lichfeld, mercer 4
4872042 2318219 2318219 defendant Bednall William tailor 590430 590430 Bednall, William, of Lichfeld, tailor 5
4872043 2318219 2318219 defendant Haslore John chaplain 815512 815512 together with Haslore, John, of Herluston, chaplain 6
4872044 2318219 2318219 defendant Strangulford John mercer 597973 597973 Strangulford, John, of Lychfeld, mercer 7
4872045 2318219 2318219 defendant Sadeler John saddler 590430 590430 Sadeler, John, of Lichfeld, saddler 8
4872046 2318219 2318219 defendant Yoxhale John barker 590430 590430 Yoxhale, John, of Lichfeld, barker 9
4872047 2318219 2318219 defendant Stubbes John, senior walker 590430 590430 Stubbes, John, senior, of Lichfeld, walker 10
4872048 2318219 2318219 defendant Sporyour Bernard spurrier 588037 588037 Sporyour, Bernard, of Lichefeld, spurrier 11
4872049 2318219 2318219 defendant Bresbroke John husbandman 600025 600025 Bresbroke, John, of Shenston, husbandman 12
4872050 2318219 2318219 defendant Kegworth Thomas yeoman 590430 590430 Kegworth, Thomas, of Lichfeld, yeoman 13
4872051 2318219 2318219 defendant Tyler Thomas tiler 590430 590430 Tyler, Thomas, of Lichfeld, tiler 14
4872052 2318219 2318219 defendant Sutton John weaver 590430 590430 Sutton, John, of Lichfeld, weaver 15
4872053 2318219 2318219 defendant Halsey Richard husbandman 642667 642667 Halsey, Richard, of Walle, husbandman 16
4872054 2318219 2318219 defendant London Thomas   590430 590430 London, Thomas, of Lichfeld, cook 17
4872055 2318219 2318219 defendant Whityngton John glover 590430 590430 Whityngton, John, of Lichfeld, glover 18
4872056 2318219 2318219 defendant Liwerch John cordwainer 590430 590430 Liwerch, John, of Lichfeld, cordwainer 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);