names

11 rows where place_id = 827426

✎ 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
4958537 2344522 2344522 defendant Man John baker 827426 827426 Man, John, of Fornset, Norf, baker 1
4958542 2344523 2344523 defendant Man John baker 827426 827426 Man, John, of Fornset, Norf, baker 1
5023655 2363826 2363826 defendant Verdon William yeoman 827426 827426 Verdon, William, of Fornset, Norf, yeoman 1
5023660 2363827 2363827 defendant Verdon William yeoman 827426 827426 Verdon, William, of Fornset, Norf, yeoman 1
5044428 2369962 2369962 defendant Reede Robert tailor 827426 827426 Reede, Robert, of Fornset, Norf, tailor 2
5062225 2375261 2375261 defendant Verdon William yeoman 827426 827426 Verdon, William, of Fornset, Norf, yeoman 1
5229313 2424184 2424184 defendant Man John baker 827426 827426 Man, John, of Fornset, Norf, baker 0
5229316 2424185 2424185 defendant Man John baker 827426 827426 Man, John, of Fornset, Norf, baker 0
5305877 2446747 2446747 defendant Frysby John   827426 827426 Frysby, John, of Fornset, Norf, clerk, parson & brother 4
5463854 2494103 2494103 defendant Southawe John husbandman 827426 827426 Southawe, John, of Fornset, Norf, husbandman 0
5475386 2497633 2497633 defendant Southawe John husbandman 827426 827426 Southawe, John, of Fornset, Norf, husbandman 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);