names

17 rows where case_id = 1945075

✎ 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
3759854 1945075 1945075 plaintiff Constable John knight   Constable, John, knight 0
3759855 1945075 1945075 plaintiff Constable Marmaduke knight   Constable, Marmaduke, knight 1
3759856 1945075 1945075 plaintiff Calverley Walter     Calverley, Walter 2
3759857 1945075 1945075 plaintiff Bagot Peter esq   Bagot, Peter, esq 3
3759858 1945075 1945075 plaintiff Savell Henry esq   Savell, Henry, esq 4
3759859 1945075 1945075 plaintiff Snowsell John esq   Snowsell, John, esq 5
3759860 1945075 1945075 plaintiff Grey Ralph esq   Grey, Ralph, esq 6
3759861 1945075 1945075 plaintiff Ardyngton Henry esq   Ardyngton, Henry, esq 7
3759862 1945075 1945075 plaintiff Newport Christopher esq   Newport, Christopher, esq 8
3759863 1945075 1945075 plaintiff Worteley Thomas esq   Worteley, Thomas, esq 9
3759864 1945075 1945075 plaintiff Wylerforte Roger     Wylerforte, Roger 10
3759865 1945075 1945075 plaintiff Bowman William     Bowman, William 11
3759866 1945075 1945075 defendant Sterky Thomas gent 600292 600292 Sterky, Thomas, of Tong, gent 0
3759867 1945075 1945075 defendant Sterky Robert gent 600292 600292 Sterky, Robert, of Tong, gent 1
3759868 1945075 1945075 defendant Slygh William laborer 600292 600292 Slygh, William, of Tong, laborer 2
3759869 1945075 1945075 defendant Dycton George laborer 600292 600292 Dycton, George, of Tong, laborer 3
3759870 1945075 1945075 defendant Tyrrell Thomas shoemaker 611406 611406 Tyrrell, Thomas, of Bredon, shoemaker 4

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