names

15 rows where case_id = 2361923

✎ 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
5017211 2361923 2361923 plaintiff Cervyngton David esq   Cervyngton, David, esq 0
5017212 2361923 2361923 defendant Lillyngston Thomas weaver 602520 602520 Lillyngston, Thomas, of Castel Combe, weaver 0
5017213 2361923 2361923 defendant Drewe Thomas weaver 602520 602520 Drewe, Thomas, of Castel Combe, weaver 1
5017214 2361923 2361923 defendant Caden John tucker 602520 602520 Caden, John, of Castel Combe, tucker 2
5017215 2361923 2361923 defendant Hille Henry tucker 602520 602520 Hille, Henry, of Castel Combe, tucker 3
5017216 2361923 2361923 defendant Avereys John tucker 602520 602520 Avereys, John, of Castel Combe, tucker 4
5017217 2361923 2361923 defendant Dagge Thomas baker 602520 602520 Dagge, Thomas, of Castel Combe, baker 5
5017218 2361923 2361923 defendant Frensheman William tucker 602520 602520 Frensheman, William, of Castel Combe, tucker 6
5017219 2361923 2361923 defendant Power William dyer 602520 602520 Power, William, of Castel Combe, dyer 7
5017220 2361923 2361923 defendant Deverose or Denerose Thomas laborer 602520 602520 Deverose or Denerose, Thomas, of Castel Combe, laborer 8
5017221 2361923 2361923 defendant Jones John husbandman 781709 781709 Jones, John, of Netelton, husbandman 9
5017222 2361923 2361923 defendant Bisshop John maltman 801351 801351 Bisshop, John, of Mersshefeld, Glos, maltman 10
5017223 2361923 2361923 defendant Davy Robert laborer 781709 781709 Davy, Robert, of Netelton, laborer 11
5017224 2361923 2361923 defendant Benfeld Thomas husbandman 775946 775946 Benfeld, Thomas, of Mersshefeld, husbandman 12
5017225 2361923 2361923 defendant Hert Thomas baker 775946 775946 Hert, Thomas, of Mersshefeld, baker 13

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