names

20 rows where place_id = 810721

✎ 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
3626165 1903046 1903046 defendant Vernon Henry   810721 810721 Vernon, Henry, of Haddon, Derbs, knight 0
4824095 2303609 2303609 defendant Vernon Richard   810721 810721 Vernon, Richard, of Haddon, Derbs, knight 0
4839447 2308261 2308261 defendant Ryse Richard gent 810721 810721 Ryse, Richard, of Haddon, Derbs, gent 1
4877805 2320022 2320022 defendant Bowen John yeoman 810721 810721 Bowen, John, of Haddon, Derbs, yeoman 1
4877808 2320023 2320023 defendant Bowen John yeoman 810721 810721 Bowen, John, of Haddon, Derbs, yeoman 1
4947978 2341354 2341354 defendant Corbet Richard esq 810721 810721 Corbet, Richard, of Haddon, Derbs, yeoman, former servant of Vernon, Richard, esq 3
4965126 2346495 2346495 defendant Vernon Richard   810721 810721 Vernon, Richard, of Haddon, Derbs, knight 0
4982680 2351732 2351732 defendant Vernon Fulk esq 810721 810721 Vernon, Fulk, of Haddon, Derbs, esq 0
5002089 2357510 2357510 defendant Vernoun Richard   810721 810721 Vernoun, Richard, of Haddon, Derbs, knight 0
5032771 2366474 2366474 defendant Vernon John esq 810721 810721 Vernon, John, of Haddon, Derbs, esq 2
5032789 2366477 2366477 defendant Vernon John esq 810721 810721 Vernon, John, of Haddon, Derbs, esq 2
5079988 2380494 2380494 defendant Vernon William   810721 810721 Vernon, William, of Haddon, Derbs, knight 0
5079990 2380495 2380495 defendant Vernon William   810721 810721 Vernon, William, of Haddon, Derbs, knight 0
5084338 2381826 2381826 defendant Vernon William esq or knight 810721 810721 Vernon, William, of Haddon, Derbs, esq or knight 0
5089066 2383177 2383177 defendant Vernon William   810721 810721 Vernon, William, of Haddon, Derbs, knight 0
5089069 2383178 2383178 defendant Vernon William   810721 810721 Vernon, William, of Haddon, Derbs, knight 0
5100755 2386645 2386645 defendant ap Rys John gent 810721 810721 ap Rys, John, of Haddon, Derbs, gent 0
5109860 2389311 2389311 defendant Vernon Thomas esq 810721 810721 Vernon, Thomas, of Haddon, Derbs, esq 2
5256278 2432087 2432087 defendant Vernon Henry esq 810721 810721 Vernon, Henry, of Haddon, Derbs, esq 0
5475581 2497695 2497695 defendant Vernon Henry esq 810721 810721 Vernon, Henry, of Haddon, Derbs, esq 2

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);