names

17 rows where case_id = 1940818

✎ 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
3746490 1940818 1940818 plaintiff Constable John knight   Constable, John, knight 0
3746491 1940818 1940818 plaintiff Constable Marmaduke knight   Constable, Marmaduke, knight 1
3746492 1940818 1940818 plaintiff Calverley Walter knight   Calverley, Walter, knight 2
3746493 1940818 1940818 plaintiff Bagot Peter esq   Bagot, Peter, esq 3
3746494 1940818 1940818 plaintiff Savell Henry esq   Savell, Henry, esq 4
3746495 1940818 1940818 plaintiff Snowsell John esq   Snowsell, John, esq 5
3746496 1940818 1940818 plaintiff Grey Ralph esq   Grey, Ralph, esq 6
3746497 1940818 1940818 plaintiff Ardyngton Henry esq   Ardyngton, Henry, esq 7
3746498 1940818 1940818 plaintiff Newport Christopher esq   Newport, Christopher, esq 8
3746499 1940818 1940818 plaintiff Wortley Thomas esq   Wortley, Thomas, esq 9
3746500 1940818 1940818 plaintiff Wylberforte Roger     Wylberforte, Roger 10
3746501 1940818 1940818 plaintiff Bowman William     Bowman, William 11
3746502 1940818 1940818 defendant Starky Thomas gent 600292 600292 Starky, Thomas, of Tong, gent 0
3746503 1940818 1940818 defendant Starky Robert gent 600292 600292 Starky, Robert, of Tong, gent 1
3746504 1940818 1940818 defendant Slygh William laborer 600292 600292 Slygh, William, of Tong, laborer 2
3746505 1940818 1940818 defendant Bitton George laborer 611406 611406 Bitton, George, of Bredon, laborer 3
3746506 1940818 1940818 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);