names

15 rows where place_id = 594051

✎ 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
3614376 1872146 1872146 defendant Cane or Cave William drover 594051 594051 Cane or Cave, William, of Stanford, Nhants, drover 1
3614384 1872147 1872147 defendant Cane or Cave William drover 594051 594051 Cane or Cave, William, of Stanford, Nhants, drover 2
3767586 1947500 1947500 defendant Cave Thomas gent 594051 594051 Cave, Thomas, of Stanford, Nhants, gent 0
3824319 1965478 1965478 defendant Brygge John innholder 594051 594051 Brygge, John, of Stanford, Nhants, innholder 0
3851325 1974013 1974013 defendant Furnesse John smith 594051 594051 Furnesse, John, of Stanford, Nhants, smith 0
3965664 2012606 2012606 defendant Cave Roger esq 594051 594051 Cave, Roger, of Stanford, Nhants, esq 0
3990893 2021503 2021503 defendant Goolod John tanner 594051 594051 Goolod, John, of Stanford, Nhants, tanner 0
4190113 2092046 2092046 defendant Farye Robert tanner 594051 594051 Farye, Robert, of Stanford, Nhants, tanner 1
4899452 2326470 2326470 defendant of the Iles Reginald husbandman 594051 594051 of the Iles, Reginald, of Stanford, Nhants, husbandman 0
5454613 2491297 2491297 defendant Dalby William   594051 594051 Dalby, William, of Stanford, Nhants 1
5466462 2494906 2494906 defendant Dalby William husbandman 594051 594051 Dalby, William, of Stanford, Nhants, husbandman 1
5466463 2494906 2494906 defendant Fermour John husbandman 594051 594051 Fermour, John, of Stanford, Nhants, husbandman 2
5466467 2494907 2494907 defendant Dalby William   594051 594051 Dalby, William, of Stanford, Nhants 1
5466468 2494907 2494907 defendant Fermour John husbandman 594051 594051 Fermour, John, of Stanford, Nhants, husbandman 2
5542193 2517689 2517689 defendant Cave William grasier or drover 594051 594051 Cave, William, of Stanford, Nhants, grasier or drover 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);