names

12 rows where case_id = 2361924

✎ 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
5017226 2361924 2361924 plaintiff Cervyngton David esq   Cervyngton, David, esq 0
5017227 2361924 2361924 defendant Lyllyngston Thomas weaver 602520 602520 Lyllyngston, Thomas, of Castel Combe, weaver 0
5017228 2361924 2361924 defendant Drewe Thomas weaver 602520 602520 Drewe, Thomas, of Castel Combe, weaver 1
5017229 2361924 2361924 defendant Caden John tucker 602520 602520 Caden, John, of Castel Combe, tucker 2
5017230 2361924 2361924 defendant Avereys John tucker 602520 602520 Avereys, John, of Castel Combe, tucker 3
5017231 2361924 2361924 defendant Dagge Thomas tucker 602520 602520 Dagge, Thomas, of Castel Combe, tucker 4
5017232 2361924 2361924 defendant Frensheman William tucker 602520 602520 Frensheman, William, of Castel Combe, tucker 5
5017233 2361924 2361924 defendant Power William dyer 602520 602520 Power, William, of Castel Combe, dyer 6
5017234 2361924 2361924 defendant Denerose Thomas laborer 602520 602520 Denerose, Thomas, of Castel Combe, laborer 7
5017235 2361924 2361924 defendant Jonys John laborer 781709 781709 Jonys, John, of Netelton, laborer 8
5017236 2361924 2361924 defendant Benfeld Thomas husbandman 592036 592036 Benfeld, Thomas, of Mersfeld, Glos, husbandman 9
5017237 2361924 2361924 defendant Hert Thomas husbandman 816841 816841 Hert, Thomas, of Mershefeld, Glos, husbandman 10

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