names

18 rows where case_id = 1965809

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3825437 1965809 1965809 plaintiff Wylloughby John knight   Wylloughby, John, knight 0
3825438 1965809 1965809 defendant Styrley Nicholas esq 615422 615422 Styrley, Nicholas, of Styrley, esq 0
3825439 1965809 1965809 defendant Weston John collier 615422 615422 Weston, John, of Styrley, collier 1
3825440 1965809 1965809 defendant Weston Robert collier 615422 615422 Weston, Robert, of Styrley, collier 2
3825441 1965809 1965809 defendant Weston Thomas collier 615422 615422 Weston, Thomas, of Styrley, collier 3
3825442 1965809 1965809 defendant Langton Peter collier 615422 615422 Langton, Peter, of Styrley, collier 4
3825443 1965809 1965809 defendant Barlowe Nicholas collier 615422 615422 Barlowe, Nicholas, of Styrley, collier 5
3825444 1965809 1965809 defendant Suker William collier 615422 615422 Suker, William, of Styrley, collier 6
3825445 1965809 1965809 defendant Shawe Gilbert collier 615422 615422 Shawe, Gilbert, of Styrley, collier 7
3825446 1965809 1965809 defendant Harryson John collier 615422 615422 Harryson, John, of Styrley, collier 8
3825447 1965809 1965809 defendant Danmowe John collier 615422 615422 Danmowe, John, of Styrley, collier 9
3825448 1965809 1965809 defendant Weston John collier 635450 635450 Weston, John, of Cossall Marshe, collier 10
3825449 1965809 1965809 defendant Preston Thomas collier 635450 635450 Preston, Thomas, of Cossall Marshe, collier 11
3825450 1965809 1965809 defendant Weston William collier 586664 586664 Weston, William, of Kymberley, collier 12
3825451 1965809 1965809 defendant Lewes William collier 594448 594448 Lewes, William, of Allesworth, collier 13
3825452 1965809 1965809 defendant Robert Thurstan collier 635451 635451 Robert, Thurstan, of Neuthorpp, collier 14
3825453 1965809 1965809 defendant Robert John collier 635452 635452 Robert, John, of Nuthorp, collier 15
3825454 1965809 1965809 defendant Harthorne George collier 635453 635453 Harthorne, George, of Nuthorpp, collier 16

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