names

10 rows where place_id = 587332

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591114 1864844 1864844 defendant Holton Robert fuller or husbandman 587332 587332 Holton, Robert, of Karsey, fuller or husbandman 0
3637511 1906542 1906542 defendant Page Robert husbandman 587332 587332 Page, Robert, of Karsey, husbandman 4
3738866 1938361 1938361 defendant Broke Andrew laborer 587332 587332 Broke, Andrew, of Karsey, laborer 3
3754989 1943507 1943507 defendant Colbrond John husbandman 587332 587332 Colbrond, John, of Karsey, husbandman 0
4197888 2094813 2094813 defendant Bryce Robert, junior tailor 587332 587332 Bryce, Robert, junior, of Karsey, tailor 0
4245274 2111403 2111403 defendant Salter Robert clothier 587332 587332 Salter, Robert, of Karsey, clothier 1
4324953 2138729 2138729 defendant Man Robert yeoman 587332 587332 Man, Robert, of Karsey, yeoman 0
4330087 2140362 2140362 defendant Forth Israel gent 587332 587332 Forth, Israel, of Karsey, gent 0
4336619 2142534 2142534 defendant Skeete Robert husbandman 587332 587332 Skeete, Robert, of Karsey, husbandman 1
5507609 2507277 2507277 defendant Man Richard weaver 587332 587332 Man, Richard, of Karsey, weaver 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);