names

13 rows where case_id = 2380427

✎ 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
5079762 2380427 2380427 plaintiff Cervyngton David esq   Cervyngton, David, esq 0
5079763 2380427 2380427 defendant Lyllyngston Thomas weaver 602520 602520 Lyllyngston, Thomas, of Castel Combe, weaver 0
5079764 2380427 2380427 defendant Drewe Thomas weaver 602520 602520 Drewe, Thomas, of Castel Combe, weaver 1
5079765 2380427 2380427 defendant Caden John tucker 602520 602520 Caden, John, of Castel Combe, tucker 2
5079766 2380427 2380427 defendant Hille Henry tucker 602520 602520 Hille, Henry, of Castel Combe, tucker 3
5079767 2380427 2380427 defendant Avereys John tucjer 602520 602520 Avereys, John, of Castel Combe, tucjer 4
5079768 2380427 2380427 defendant Power William dyer 602520 602520 Power,William, of Castel Combe, dyer 5
5079769 2380427 2380427 defendant Denerose or Deverose Thomas laborer 602520 602520 Denerose or Deverose, Thomas, of Castel Combe, laborer 6
5079770 2380427 2380427 defendant Jones John husbandman 781709 781709 Jones, John, of Netelton, husbandman 7
5079771 2380427 2380427 defendant Bysshop John maltman 816841 816841 Bysshop, John, of Mershefeld, Glos, maltman 8
5079772 2380427 2380427 defendant Deny Robery laboter 781709 781709 Deny, Robery, of Netelton, laboter 9
5079773 2380427 2380427 defendant Benfeld Thomas husbandman 777240 777240 Benfeld, Thomas, of Mershefeld, husbandman 10
5079774 2380427 2380427 defendant Hert Thomas baker 777240 777240 Hert, Thomas, of Mershefeld, baker 11

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