names

9 rows where place_id = 587925

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592849 1865379 1865379 defendant Benton John husbandman 587925 587925 Benton, John, of North Mymes, husbandman 4
3631962 1904809 1904809 defendant Dunkerley Richard tailor 587925 587925 Dunkerley, Richard, of North Mymes, tailor 0
3845843 1972254 1972254 plaintiff Fresshewater Robert husbandman 587925 587925 Fresshewater, Robert, of North Mymes, husbandman 0
3845844 1972254 1972254 defendant Donkarley Joan widow 587925 587925 Donkarley, Joan, of North Mymes, widow 0
3845845 1972254 1972254 defendant Grubbe Henry husbandman 587925 587925 Grubbe, Henry, of North Mymes, husbandman 1
4060965 2046330 2046330 defendant Russell James gent 587925 587925 Russell, James, of North Mymes, gent 1
4074256 2051091 2051091 defendant Bowes William yeoman 587925 587925 Bowes William, of North Mymes, yeoman 0
5401667 2475536 2475536 defendant Chylde Peter husbandman 587925 587925 Chylde, Peter, of North Mymes, husbandman 12
5498867 2504601 2504601 plaintiff Parker Hamon yeoman 587925 587925 Parker, Hamon, of North Mymes, yeoman 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);