names

11 rows where case_id = 2327876

✎ 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
4904019 2327876 2327876 plaintiff Hardwyn Thomas   586435 586435 Hardwyn, Thomas, of Leicester, administrators of 0
4904020 2327876 2327876 plaintiff Brokesby Bartholomew esq   (Brokesby, Bartholomew, esq 1
4904021 2327876 2327876 plaintiff Racy Adam     Racy, Adam 2
4904022 2327876 2327876 plaintiff Launder Thomas     Launder, Thomas 3
4904023 2327876 2327876 plaintiff Clement Roger     Clement, Roger 4
4904024 2327876 2327876 plaintiff Hardwyn John     Hardwyn, John 5
4904025 2327876 2327876 defendant Dobbe William   588326 588326 Dobbe, William, of Belton, wright 0
4904026 2327876 2327876 defendant Persyvale Edward husbandman 588326 588326 Persyvale, Edward, of Belton, husbandman 1
4904027 2327876 2327876 defendant Dobbe Oliver   586435 586435 Dobbe, Oliver, of Leicester, wright 2
4904028 2327876 2327876 defendant Thorp John butcher 663870 663870 Thorp, John, of Syston, butcher 3
4904029 2327876 2327876 defendant Mathewe Robert husbandman 663870 663870 Mathewe, Robert, of Syston, husbandman 4

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