names

15 rows where case_id = 2203131

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4508484 2203131 2203131 plaintiff Aiton Lawrence     Aiton, Lawrence 0
4508485 2203131 2203131 defendant Hydwyn John     Hydwyn, John 0
4508486 2203131 2203131 defendant de Hall John     de Hall, John 1
4508487 2203131 2203131 defendant Hunter Stephen     Hunter, Stephen 2
4508488 2203131 2203131 defendant Haweson John     Haweson, John 3
4508489 2203131 2203131 defendant Mandelans Peter de     Mandelans, Peter de 4
4508490 2203131 2203131 defendant Barker Richard   605984 605984 Barker, Richard, of Newcastle upon Tyne 5
4508491 2203131 2203131 defendant Byrchefeld Robert     Byrchefeld, Robert 6
4508492 2203131 2203131 defendant Beverley Robert de     Beverley, Robert de 7
4508493 2203131 2203131 defendant Hull John de     Hull, John de 8
4508494 2203131 2203131 defendant Grey Robert     Grey, Robert 9
4508495 2203131 2203131 defendant Cook William     Cook, William 10
4508496 2203131 2203131 defendant Watson John     Watson, John 11
4508497 2203131 2203131 defendant Styrnyng John     Styrnyng, John 12
4508498 2203131 2203131 defendant Hogge John     Hogge, John 13

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