names

9 rows where place_id = 595773

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3621833 1874369 1874369 plaintiff Hyde Leonard   595773 595773 Hyde, Leonard, of gent 2
3667650 1915826 1915826 plaintiff Wylleford Thomas   595773 595773 Wylleford, Thomas, of gent 0
4031527 2035942 2035942 plaintiff Floudde Thomas   595773 595773 Floudde, Thomas, of gent 0
4336942 2142647 2142647 plaintiff Blagrave John   595773 595773 Blagrave, John, of gent 0
5134128 2396477 2396477 defendant Fox Thomas   595773 595773 Fox, Thomas, of gent 2
5185963 2411641 2411641 plaintiff Hyde William   595773 595773 (Hyde, William, of gent 1
5293581 2443090 2443090 plaintiff Weston William   595773 595773 (Weston, William, of gent 1
5329873 2454004 2454004 plaintiff Barkeby John   595773 595773 (Barkeby, John, of gent, "grammaticus" 1
5499961 2504941 2504941 defendant Freon Stephen   595773 595773 Freon, Stephen, of gent 1

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