names

13 rows where case_id = 2378301

✎ 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
5072638 2378301 2378301 plaintiff Thornton John     Thornton, John 0
5072639 2378301 2378301 defendant Thomlynson Thomas husbandman 600786 600786 Thomlynson, Thomas, of Heton, husbandman 0
5072640 2378301 2378301 defendant Thomlynson John husbandman 600786 600786 Thomlynson, John, of Heton, husbandman 1
5072641 2378301 2378301 defendant Robynson John husbandman 600786 600786 Robynson, John, of Heton, husbandman 2
5072642 2378301 2378301 defendant Boyes John husbandman 600786 600786 Boyes, John, of Heton, husbandman 3
5072643 2378301 2378301 defendant Templeman Robert husbandman 600786 600786 Templeman, Robert, of Heton, husbandman 4
5072644 2378301 2378301 defendant Clotherom William husbandman 600786 600786 Clotherom, William, of Heton, husbandman 5
5072645 2378301 2378301 defendant Malmagh Robert husbandman 600786 600786 Malmagh, Robert, of Heton, husbandman 6
5072646 2378301 2378301 defendant Hudson John husbandman 600786 600786 Hudson, John, of Heton, husbandman 7
5072647 2378301 2378301 defendant Templeman Robert, junior husbandman 600786 600786 Templeman, Robert, junior, of Heton, husbandman 8
5072648 2378301 2378301 defendant Templeman William, senior husbandman 600786 600786 Templeman, William, senior, of Heton, husbandman 9
5072649 2378301 2378301 defendant Stevenson John husbandman 840796 840796 Stevenson, John, of Est Thurkilby, husbandman 10
5072650 2378301 2378301 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);