names

21 rows where case_id = 1868570

✎ 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
3602884 1868570 1868570 plaintiff Clynton William treasurer of Lyons Inn   Clynton, William, treasurer of Lyons Inn 0
3602885 1868570 1868570 defendant Stokes John gent 585929 585929 Stokes, John, of St Clement Danes, gent 0
3602886 1868570 1868570 defendant Laplode John     Laplode, John 1
3602887 1868570 1868570 defendant Cokkys John     Cokkys, John 2
3602888 1868570 1868570 defendant Code Richard     Code, Richard 3
3602889 1868570 1868570 defendant Bassche Thomas     Bassche, Thomas 4
3602890 1868570 1868570 defendant Holcombe William     Holcombe, William 5
3602891 1868570 1868570 defendant Basset John     Basset, John 6
3602892 1868570 1868570 defendant Rokes John     Rokes, John 7
3602893 1868570 1868570 defendant Kelke Thomas     Kelke, Thomas 8
3602894 1868570 1868570 defendant Arthur William     Arthur, William 9
3602895 1868570 1868570 defendant Mille Robert     Mille, Robert 10
3602896 1868570 1868570 defendant Lmollys John     Lmollys, John 11
3602897 1868570 1868570 defendant Trye Thomas     Trye, Thomas 12
3602898 1868570 1868570 defendant Hill William     Hill, William 13
3602899 1868570 1868570 defendant Hill John     Hill, John 14
3602900 1868570 1868570 defendant Walden Richard     Walden, Richard 15
3602901 1868570 1868570 defendant Godeyere Richard     Godeyere, Richard 16
3602902 1868570 1868570 defendant Forthey John     Forthey, John 17
3602903 1868570 1868570 defendant Kyng John     Kyng, John 18
3602904 1868570 1868570 defendant Haccher William     Haccher, William 19

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