names

13 rows where case_id = 2471673

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5388179 2471673 2471673 plaintiff Goldesburgh Richard esq   Goldesburgh, Richard, esq 0
5388180 2471673 2471673 defendant Bradford William walker 608970 608970 Bradford, William, of Ardyngton, walker 0
5388181 2471673 2471673 defendant Jakson Robert miller 608970 608970 Jakson, Robert, of Ardyngton, miller 1
5388182 2471673 2471673 defendant Wadyngton William walker 608970 608970 Wadyngton, William, of Ardyngton, walker 2
5388183 2471673 2471673 defendant Wayte Thomas laborer 608970 608970 Wayte, Thomas, of Ardyngton, laborer 3
5388184 2471673 2471673 defendant Kaa Roger walker 608970 608970 Kaa, Roger, of Ardyngton, walker 4
5388185 2471673 2471673 defendant Wayte John laborer 608970 608970 Wayte, John, of Ardyngton, laborer 5
5388186 2471673 2471673 defendant Whiteacreas William smith 608970 608970 Whiteacreas, William, of Ardyngton, smith 6
5388187 2471673 2471673 defendant Willyamson John laborer 608970 608970 Willyamson, John, of Ardyngton, laborer 7
5388188 2471673 2471673 defendant Bradford William, junior laborer 608970 608970 Bradford, William, junior, of Ardyngton, laborer 8
5388189 2471673 2471673 defendant Symm William laborer 608970 608970 Symm, William, of Ardyngton, laborer 9
5388190 2471673 2471673 defendant Mortimer Thomas laborer 608970 608970 Mortimer, Thomas, of Ardyngton, laborer 10
5388191 2471673 2471673 defendant Naute William tailor 608970 608970 Naute, William, of Ardyngton, tailor 11

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