names

17 rows where case_id = 1975465

✎ 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
3855870 1975465 1975465 plaintiff Weston Robert     Weston, Robert 0
3855871 1975465 1975465 plaintiff Rychard Thomas     Rychard, Thomas 1
3855872 1975465 1975465 plaintiff Gilberd John     Gilberd, John 2
3855873 1975465 1975465 plaintiff Byrte Robert     Byrte, Robert 3
3855874 1975465 1975465 plaintiff Drocke John     Drocke, John 4
3855875 1975465 1975465 plaintiff Haich Thomas     Haich, Thomas 5
3855876 1975465 1975465 plaintiff Spurway Thomas     Spurway, Thomas 6
3855877 1975465 1975465 plaintiff Bonefaunt Thomas     Bonefaunt, Thomas 7
3855878 1975465 1975465 plaintiff Gale Gilbert     Gale, Gilbert 8
3855879 1975465 1975465 plaintiff Heydon John     Heydon, John 9
3855880 1975465 1975465 plaintiff Trent William     Trent, William 10
3855881 1975465 1975465 plaintiff Alford John     Alford, John 11
3855882 1975465 1975465 plaintiff Stefford William     Stefford, William 12
3855883 1975465 1975465 plaintiff Heydon Alan     Heydon, Alan 13
3855884 1975465 1975465 plaintiff Gilbert Robert     Gilbert, Robert 14
3855885 1975465 1975465 plaintiff Houndeler John     Houndeler, John 15
3855886 1975465 1975465 defendant Hurston Simon, junior husbandman 597587 597587 Hurston, Simon, junior, of Chagford, husbandman 0

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