names

13 rows where case_id = 2016576

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3977138 2016576 2016576 plaintiff Lawley Richard     Lawley, Richard 0
3977139 2016576 2016576 defendant Wylcock Roger husbandman 586344 586344 Wylcock, Roger, of Burton, husbandman 0
3977140 2016576 2016576 defendant Wilcock Jerome husbandman 586344 586344 Wilcock, Jerome, of Burton, husbandman 1
3977141 2016576 2016576 defendant Wilcock Richard husbandman 586344 586344 Wilcock, Richard, of Burton, husbandman 2
3977142 2016576 2016576 defendant Wilcock John husbandman 586344 586344 Wilcock, John, of Burton, husbandman 3
3977143 2016576 2016576 defendant Wylcock Thomas husbandman 586344 586344 Wylcock, Thomas, of Burton, husbandman 4
3977144 2016576 2016576 defendant Tarte Ralph husbandman 586344 586344 Tarte, Ralph, of Burton, husbandman 5
3977145 2016576 2016576 defendant Grene Thomas husbandman 586344 586344 Grene, Thomas, of Burton, husbandman 6
3977146 2016576 2016576 defendant Haburley Walter husbandman 586344 586344 Haburley, Walter, of Burton, husbandman 7
3977147 2016576 2016576 defendant Haburley William husbandman 586344 586344 Haburley, William, of Burton, husbandman 8
3977148 2016576 2016576 defendant Ball John husbandman 586344 586344 Ball, John, of Burton, husbandman 9
3977149 2016576 2016576 defendant Hygg William husbandman 586344 586344 Hygg, William, of Burton, husbandman 10
3977150 2016576 2016576 defendant Myddleton John husbandman 586344 586344 Myddleton, John, of Burton, husbandman 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);