names

7 rows where place_id = 614677

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3704871 1927816 1927816 defendant Thornton John yeoman 614677 614677 Thornton, John, of Magna Lynton, Cams, yeoman 3
3765182 1946773 1946773 defendant Millecent Richard tailor 614677 614677 Millecent, Richard, of Magna Lynton, Cams, tailor 0
3768394 1947759 1947759 defendant Hokley John butcher 614677 614677 Hokley, John, of Magna Lynton, Cams, butcher 3
3811185 1961394 1961394 defendant Thornton John yeoman 614677 614677 Thornton, John, of Magna Lynton, Cams, yeoman 0
5124253 2393542 2393542 defendant Parkyn John husbandman 614677 614677 (Parkyn, John, of Magna Lynton, Cams, husbandman 11
5345620 2458791 2458791 defendant Snareston Thomas gent 614677 614677 Snareston, Thomas, of Magna Lynton, Cams, gent 0
5353663 2461215 2461215 defendant Taillour Thomas yeoman 614677 614677 Taillour, Thomas, of Magna Lynton, Cams, 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);