names

13 rows where case_id = 2396177

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5133149 2396177 2396177 plaintiff Horbury Christopher     Horbury, Christopher, on his own account 0
5133150 2396177 2396177 defendant Everard Thomas   603196 603196 Everard, Thomas, of Stokesley, minstrel 0
5133151 2396177 2396177 defendant Baker Edmund husbandman 604178 604178 Baker, Edmund, of Warmefeld, husbandman 1
5133152 2396177 2396177 defendant Grene John yeoman   Grene, John, yeoman 2
5133153 2396177 2396177 defendant Aveley John husbandman 850758 850758 Aveley, John, of Snaypthorp, husbandman 3
5133154 2396177 2396177 defendant Bergh Richard husbandman 624166 624166 Bergh, Richard, of Federston, husbandman 4
5133155 2396177 2396177 defendant Wright Edmund usbandman 763445 763445 Wright, Edmund, of Whitwode, usbandman 5
5133156 2396177 2396177 defendant Dighton John clerk 662814 662814 Dighton, John, of Wollay, clerk 6
5133157 2396177 2396177 defendant Dibhton Robert yeoman 850759 850759 Dibhton, Robert, of Memtheley, yeoman 7
5133158 2396177 2396177 defendant Holden John draper 592299 592299 Holden, John, of Doncaster, draper 8
5133159 2396177 2396177 defendant Criche John baker 592299 592299 Criche, John, of Doncaster, baker 9
5133160 2396177 2396177 defendant Dousyng Anise widow, formerly wife of Testator   Dousyng, Anise, widow, formerly wife of Testator 10
5133161 2396177 2396177 defendant Dousyng Robert (legal representative) 592299 592299 Dousyng, Robert, of Doncaster roper, executrix of 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);