names

14 rows where place_id = 798684

✎ 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
4763362 2284530 2284530 defendant Stonham Robert esq 798684 798684 Stonham, Robert, of Great Stoughton, Hunts, esq 0
4763364 2284530 2284530 defendant Robert Stonhames Botiller Edmund yeoman 798684 798684 Robert Stonhames Botiller, Edmund, of Great Stoughton, Hunts, yeoman 2
4763365 2284530 2284530 defendant Smyth John husbandman 798684 798684 Smyth, John, of Great Stoughton, Hunts, husbandman 3
4772231 2287287 2287287 defendant Mersk Acrisius gent 798684 798684 Mersk, Acrisius, of Great Stoughton, Hunts, gent 0
4909189 2329418 2329418 defendant Wawton William esq 798684 798684 Wawton, William, of Great Stoughton, Hunts, esq 0
4925328 2334354 2334354 defendant Botle Robert gent 798684 798684 Botle, Robert, of Great Stoughton, Hunts, gent 0
4987281 2353145 2353145 defendant Wanton William esq 798684 798684 Wanton, William, of Great Stoughton, Hunts, esq 2
5131612 2395727 2395727 defendant Wake John esq 798684 798684 Wake, John, of Great Stoughton, Hunts, esq 0
5151082 2401459 2401459 defendant Wake John esq 798684 798684 Wake, John, of Great Stoughton, Hunts, esq 0
5151128 2401471 2401471 defendant Wake John esq 798684 798684 Wake, John, of Great Stoughton, Hunts, esq 0
5169361 2406775 2406775 defendant Wake John esq 798684 798684 Wake, John, of Great Stoughton, Hunts, esq 0
5187879 2412167 2412167 defendant Kelston John husbandman 798684 798684 Kelston, John, of Great Stoughton, Hunts, husbandman 1
5271511 2436761 2436761 defendant Grene Edward butcher 798684 798684 Grene, Edward, of Great Stoughton, Hunts, butcher 0
5366374 2465135 2465135 defendant Wake John gent 798684 798684 Wake, John, of Great Stoughton, Hunts, gent 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);