names

13 rows where case_id = 2372741

✎ 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
5053810 2372741 2372741 plaintiff Beaumont John Viscount Beaumont   Beaumont, John, Viscount Beaumont 0
5053811 2372741 2372741 defendant Thomlynson Thomas husbandman 600786 600786 Thomlynson, Thomas, of Heton, husbandman 0
5053812 2372741 2372741 defendant Thomlynson John husbandman 600786 600786 Thomlynson, John, of Heton, husbandman 1
5053813 2372741 2372741 defendant Robynson John husbandman 600786 600786 Robynson, John, of Heton, husbandman 2
5053814 2372741 2372741 defendant Boyes John husbandman 600786 600786 Boyes, John, of Heton, husbandman 3
5053815 2372741 2372741 defendant Templeman Robert husbandman 600786 600786 Templeman, Robert, of Heton, husbandman 4
5053816 2372741 2372741 defendant Clotherom William husbandman 600786 600786 Clotherom, William, of Heton, husbandman 5
5053817 2372741 2372741 defendant Malmagh Robert husbandman 600786 600786 Malmagh, Robert, of Heton, husbandman 6
5053818 2372741 2372741 defendant Hudson John husbandman 600786 600786 Hudson, John, of Heton, husbandman 7
5053819 2372741 2372741 defendant Templeman Robert, junior husbandman 600786 600786 Templeman, Robert, junior, of Heton, husbandman 8
5053820 2372741 2372741 defendant Templeman William, senior husbandman 600786 600786 Templeman, William, senior, of Heton, husbandman 9
5053821 2372741 2372741 defendant Stevenson John husbandman 840796 840796 Stevenson, John, of Est Thurkilby, husbandman 10
5053822 2372741 2372741 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);