names

17 rows where case_id = 1945074

✎ 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
3759837 1945074 1945074 plaintiff Constable John knight   Constable, John, knight 0
3759838 1945074 1945074 plaintiff Constable Marmaduke knight   Constable, Marmaduke, knight 1
3759839 1945074 1945074 plaintiff Calverley Walter     Calverley, Walter 2
3759840 1945074 1945074 plaintiff Bagot Peter esq   Bagot, Peter, esq 3
3759841 1945074 1945074 plaintiff Savell Henry esq   Savell, Henry, esq 4
3759842 1945074 1945074 plaintiff Snowsell John esq   Snowsell, John, esq 5
3759843 1945074 1945074 plaintiff Grey Ralph esq   Grey, Ralph, esq 6
3759844 1945074 1945074 plaintiff Ardyngton Henry esq   Ardyngton, Henry, esq 7
3759845 1945074 1945074 plaintiff Newport Christopher esq   Newport, Christopher, esq 8
3759846 1945074 1945074 plaintiff Worteley Thomas esq   Worteley, Thomas, esq 9
3759847 1945074 1945074 plaintiff Wylerforte Roger     Wylerforte, Roger 10
3759848 1945074 1945074 plaintiff Bowman William     Bowman, William 11
3759849 1945074 1945074 defendant Starky Thomas gent 600292 600292 Starky, Thomas, of Tong, gent 0
3759850 1945074 1945074 defendant Starky Robert gent 600292 600292 Starky, Robert, of Tong, gent 1
3759851 1945074 1945074 defendant Slygh William laborer 600292 600292 Slygh, William, of Tong, laborer 2
3759852 1945074 1945074 defendant Dytton George laborer 611406 611406 Dytton, George, of Bredon, laborer 3
3759853 1945074 1945074 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);