names

23 rows where place_id = 699863

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4130867 2071352 2071352 defendant Nanspian or Nauspian James esq 699863 699863 Nanspian or Nauspian, James, of Gurlyn, esq 0
4158566 2081067 2081067 defendant Nampion James esq 699863 699863 Nampion, James, of Gurlyn, esq 0
4179535 2088319 2088319 defendant Nanspyan James esq 699863 699863 Nanspyan, James, of Gurlyn, esq 0
4179539 2088320 2088320 defendant Nanspyan James esq 699863 699863 Nanspyan, James, of Gurlyn, esq 0
4202955 2096580 2096580 defendant Nanspyan James esq 699863 699863 Nanspyan, James, of Gurlyn, esq 0
4203172 2096657 2096657 defendant Nanspyan James esq 699863 699863 Nanspyan, James, of Gurlyn, esq 0
4205951 2097624 2097624 defendant Nanspyan James esq 699863 699863 Nanspyan, James, of Gurlyn, esq 0
4217982 2101782 2101782 defendant Nanspian James esq 699863 699863 Nanspian, James, of Gurlyn, esq 0
4244187 2111039 2111039 defendant Nanspyan James esq 699863 699863 Nanspyan, James, of Gurlyn, esq 0
4935139 2337398 2337398 defendant Gurlyn William gent 699863 699863 Gurlyn, William, of Gurlyn, gent 0
4973041 2348868 2348868 defendant Gurlyn Willian gent 699863 699863 Gurlyn, Willian, of Gurlyn, gent 1
4982490 2351683 2351683 defendant Gurlyn William gent 699863 699863 Gurlyn, William, of Gurlyn, gent 0
5088227 2382929 2382929 defendant Gurlyn William, senior gent 699863 699863 Gurlyn, William, senior, of Gurlyn, gent 0
5138229 2397693 2397693 defendant Gurlyn William, senior gent 699863 699863 Gurlyn, William, senior, of Gurlyn, gent 0
5159017 2403756 2403756 defendant Gurlyn William, sen gent 699863 699863 Gurlyn, William, sen, of Gurlyn, gent 0
5174282 2408183 2408183 defendant Gurlyn William, sen gent 699863 699863 Gurlyn, William, sen, of Gurlyn, gent 0
5194888 2414253 2414253 defendant Gurlyn William, sen gent 699863 699863 Gurlyn, William, sen, of Gurlyn, gent 0
5209005 2418366 2418366 defendant Gurlyn William, sen gent 699863 699863 Gurlyn, William, sen, of Gurlyn, gent 0
5245732 2428916 2428916 defendant Gurlyn William gent 699863 699863 Gurlyn, William, of Gurlyn, gent 2
5320760 2451299 2451299 defendant Gurlyn William, senior gent 699863 699863 Gurlyn, William, senior, of Gurlyn, gent 5
5320763 2451300 2451300 defendant Gulyn William gent 699863 699863 Gulyn, William, of Gurlyn, gent 1
5320766 2451301 2451301 defendant Gurlyn William, senior gent 699863 699863 Gurlyn, William, senior, of Gurlyn, gent 1
5338170 2456504 2456504 defendant Gurlyn William, senior gent 699863 699863 Gurlyn, William, senior, of Gurlyn, gent 1

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