names

8 rows where case_id = 2302258

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4819775 2302258 2302258 plaintiff Polreden John     Polreden, John, on his own account 0
4819776 2302258 2302258 defendant Tregrethes William gent 768494 768494 Tregrethes, William, of Lananta, gent 0
4819777 2302258 2302258 defendant Tregrethes Henry gent 760543 760543 Tregrethes, Henry, of Lavanta, gent 1
4819778 2302258 2302258 defendant Byannowe John husbandman 807337 807337 Byannowe, John, of Tregena, husbandman 2
4819779 2302258 2302258 defendant Hokke John carpenter 807338 807338 with Hokke, John, of Bossoghandany, carpenter 3
4819780 2302258 2302258 defendant Julkyn John   610287 610287 Julkyn, John, of Tavystoke, Devon, law apprentice 4
4819781 2302258 2302258 defendant Jurdan John tinner 807340 807340 Jurdan, John, of Prydeauxvyham, tinner 5
4819782 2302258 2302258 defendant Jurdan Robert (legal representative)   Jurdan, Robert, administrator of 6

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);