names

15 rows where place_id = 647396

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3895914 1988840 1988840 plaintiff Swynstoo Richard yeoman 647396 647396 Swynstoo, Richard, of Sprotton, Nhants, yeoman 0
4217323 2101554 2101554 defendant Ingersbie Thomas gent 647396 647396 Ingersbie, Thomas, of Sprotton, Nhants, gent 0
4653577 2247053 2247053 defendant Mountfort William esq 647396 647396 Mountfort, William, of Sprotton, Nhants, esq 2
4653584 2247054 2247054 defendant Mountford William esq 647396 647396 Mountford, William, of Sprotton, Nhants, esq 2
4675066 2257811 2257811 defendant Chaumbre John brother of Thomas Chaumbre 647396 647396 Chaumbre, John, of Sprotton, Nhants, brother of Thomas Chaumbre 1
4941786 2339441 2339441 defendant Chaumbre Thomas esq 647396 647396 Chaumbre, Thomas, of Sprotton, Nhants, esq 0
4946199 2340795 2340795 defendant Chambre Thomas esq 647396 647396 Chambre, Thomas, of Sprotton, Nhants, esq 0
4946201 2340796 2340796 defendant Chambre Thomas esq 647396 647396 Chambre, Thomas, of Sprotton, Nhants, esq 0
4946216 2340801 2340801 defendant Chambre Thomas esq 647396 647396 Chambre, Thomas, of Sprotton, Nhants, esq 0
5156977 2403182 2403182 defendant Chambre William gent 647396 647396 Chambre, William, of Sprotton, Nhants, gent 0
5172636 2407724 2407724 defendant Chambre William gent 647396 647396 Chambre, William, of Sprotton, Nhants, gent 0
5192856 2413632 2413632 defendant Chaumbre William gent 647396 647396 Chaumbre, William, of Sprotton, Nhants, gent 0
5395600 2473821 2473821 defendant Chambre John clerk 647396 647396 Chambre, John, of Sprotton, Nhants, clerk 0
5408891 2477619 2477619 defendant Chambre John clerk formerly esquire 647396 647396 Chambre, John, of Sprotton, Nhants, clerk formerly esquire 0
5421945 2481498 2481498 defendant Chambre John   647396 647396 Chambre, John, of Sprotton, Nhants, clerk, formerly esq 0

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