names

14 rows where place_id = 591459

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604476 1869066 1869066 defendant Casterton Thomas (legal representative) 591459 591459 Casterton, Thomas, of Ketelston, yeoman, executor of 10
3604477 1869066 1869066 defendant Casterton William chaplain 591459 591459 Casterton, William, of Ketelston, chaplain 11
4554383 2217300 2217300 plaintiff Curson John   591459 591459 (Curson, John, of Ketelston 1
4557236 2218196 2218196 defendant Dyke Walter   591459 591459 Dyke, Walter, of Ketelston 0
4638482 2242796 2242796 defendant Breydere William   591459 591459 Breydere, William, of Ketelston 0
4638483 2242796 2242796 defendant Breydere Richard   591459 591459 Breydere, Richard, of Ketelston 1
4638484 2242796 2242796 defendant Greydere John   591459 591459 Greydere, John, of Ketelston 2
4638485 2242796 2242796 defendant Letton John   591459 591459 Letton, John, of Ketelston 3
4638486 2242796 2242796 defendant Lenton John   591459 591459 Lenton, John, of Ketelston 4
4700000 2265421 2265421 defendant Lente John husbandman 591459 591459 Lente, John, of Ketelston, husbandman 0
5331999 2454644 2454644 defendant Burnell Henry yeoman 591459 591459 Burnell, Henry, of Ketelston, yeoman 0
5493911 2503086 2503086 defendant Tey Richard husbandman 591459 591459 Tey, Richard, of Ketelston, husbandman 0
5512757 2508846 2508846 defendant Lavender Robert laborer 591459 591459 Lavender, Robert, of Ketelston, laborer 1
5521042 2511406 2511406 defendant Dalahay Thomas esq 591459 591459 Dalahay, Thomas, of Ketelston, 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);