names

10 rows where place_id = 770092

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4564615 2220490 2220490 defendant Wilton Thomas   770092 770092 Wilton, Thomas, of Populton 11
4564616 2220490 2220490 defendant Leget Thomas   770092 770092 Leget, Thomas, of Populton 12
4757402 2282688 2282688 defendant Boswet Henry clerk 770092 770092 Boswet, Henry, of Populton, clerk 0
4757404 2282689 2282689 defendant Bowet Henry clerk 770092 770092 Bowet, Henry, of Populton, clerk 0
4761616 2283978 2283978 defendant Bowet Henry clerk 770092 770092 (Bowet, Henry, of Populton, clerk 4
4785066 2291344 2291344 defendant Bowet Henry clerk 770092 770092 (Bowet, Henry, of Populton, clerk 1
4823930 2303562 2303562 defendant Bowet Henry   770092 770092 Bowet, Henry, of Populton, Yorks clerk 1
4852249 2312131 2312131 defendant Day John husbandman 770092 770092 Day, John, of Populton, husbandman 2
4885721 2322409 2322409 defendant Goldesburgh Ralph esq 770092 770092 Goldesburgh, Ralph, of Populton, esq 3
5138672 2397807 2397807 defendant Botiller John husbandman 770092 770092 Botiller, John, of Populton, husbandman 2

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