names

9 rows where case_id = 2236939

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4619004 2236939 2236939 plaintiff Herleston John   585936 585936 Herleston, John, of Norwich 0
4619005 2236939 2236939 defendant Owdyn John     Owdyn, John 0
4619006 2236939 2236939 defendant Glise Thomas   587913 587913 Glise, Thomas, of Pulham 1
4619007 2236939 2236939 defendant Cobbe William   587913 587913 Cobbe, William, of Pulham 2
4619008 2236939 2236939 defendant Skonewater Robert   587913 587913 Skonewater, Robert, of Pulham 3
4619009 2236939 2236939 defendant Hoo Thomas   586134 586134 Hoo, Thomas, of Ipswich 4
4619010 2236939 2236939 defendant Stoke William   585936 585936 Stoke, William, of Norwich 5
4619011 2236939 2236939 defendant Bullok John   775056 775056 Bullok, John, of Dikolburgh 6
4619012 2236939 2236939 defendant Large John   635952 635952 Large, John, of Erlham 7

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