names

13 rows where case_id = 2485037

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5433670 2485037 2485037 plaintiff Mountford Simon knight   Mountford, Simon, knight 0
5433671 2485037 2485037 defendant Hyde John esq 610091 610091 Hyde, John, of Dencheworth, esq 0
5433672 2485037 2485037 defendant Makney Henry esq 627195 627195 Makney, Henry, of Makney, esq 1
5433673 2485037 2485037 defendant Fetyplace James esq 887057 887057 Fetyplace, James, of Powefley, esq 2
5433674 2485037 2485037 defendant Perkyns John esq 887058 887058 Perkyns, John, of Vynchamsted or Finchampstead, esq 3
5433675 2485037 2485037 defendant Luffyngote Thomas esq 887059 887059 Luffyngote, Thomas, of Elvvynden, Oxon, esq 4
5433676 2485037 2485037 defendant Garrard Richard gent 887060 887060 Garrard, Richard, of Chennyngfeld, gent 5
5433677 2485037 2485037 defendant Whitehorne Henry yeoman 864426 864426 Whitehorne, Henry, of Sperfold, yeoman 6
5433678 2485037 2485037 defendant Boweyer Thomas yeoman 600601 600601 Boweyer, Thomas, of White Waltham, yeoman 7
5433679 2485037 2485037 defendant Eede Robert yeoman 640328 640328 Eede, Robert, of Old Wyndesore, yeoman 8
5433680 2485037 2485037 defendant Beynton William fuller 587891 587891 Beynton, William,of Redyng, fuller 9
5433681 2485037 2485037 defendant Blyke John yeoman 668316 668316 Blyke, John, of Long Witnam, yeoman 10
5433682 2485037 2485037 defendant Meyr John yeoman 640328 640328 Meyr, John, of Old Wyndesore, yeoman 11

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