names

13 rows where case_id = 2376006

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5064776 2376006 2376006 plaintiff Letby Robert     Letby, Robert 0
5064777 2376006 2376006 defendant Thomlynson Thomas husbandman 600786 600786 Thomlynson, Thomas, of Heton, husbandman 0
5064778 2376006 2376006 defendant Thomlynson John husbandman 600786 600786 Thomlynson, John, of Heton, husbandman 1
5064779 2376006 2376006 defendant Robynson John husbandman 600786 600786 Robynson, John, of Heton, husbandman 2
5064780 2376006 2376006 defendant Boyes John husbandman 600786 600786 Boyes, John, of Heton, husbandman 3
5064781 2376006 2376006 defendant Templeman Robert, senior husbandman 600786 600786 Templeman, Robert, senior, of Heton, husbandman 4
5064782 2376006 2376006 defendant Clotherom William husbandman 600786 600786 Clotherom, William, of Heton, husbandman 5
5064783 2376006 2376006 defendant Malmagh Robert husbandman 600786 600786 Malmagh, Robert, of Heton, husbandman 6
5064784 2376006 2376006 defendant Hudson John husbandman 600786 600786 Hudson, John, of Heton, husbandman 7
5064785 2376006 2376006 defendant Templeman Robert, junior husbandman 600786 600786 Templeman, Robert, junior, of Heton, husbandman 8
5064786 2376006 2376006 defendant Templeman William, senior husbandman 600786 600786 Templeman, William, senior, of Heton, husbandman 9
5064787 2376006 2376006 defendant Stevenson John husbandman 840796 840796 Stevenson, John, of Est Thurkilby, husbandman 10
5064788 2376006 2376006 defendant Richardson John husbandman 634339 634339 Richardson, John, of Sesay, 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);