names

13 rows where case_id = 2493383

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5461467 2493383 2493383 plaintiff Mountford Simon knight   Mountford, Simon, knight 0
5461468 2493383 2493383 defendant Hyde John esq 610091 610091 Hyde, John, of Dencheworth, esq 0
5461469 2493383 2493383 defendant Makney Henry esq 627195 627195 Makney, Henry, of Makney, esq 1
5461470 2493383 2493383 defendant Perkyns John esq 888741 888741 Perkyns, John, of Vynchampstede or Finhampstead, esq 2
5461471 2493383 2493383 defendant Whitehorne Henry yeoman 864426 864426 Whitehorne, Henry, of Sperfold, yeoman 3
5461472 2493383 2493383 defendant Boweyer Thomas yeoman 600601 600601 Boweyer, Thomas, of White Waltham, yeoman 4
5461473 2493383 2493383 defendant Beynton William fuller 587891 587891 Beynton, William, of Redyng, fuller 5
5461474 2493383 2493383 defendant Blyke John yeoman 668316 668316 Blyke, John, of Long Witnam, yeoman 6
5461475 2493383 2493383 defendant Fetyplace James esq 890033 890033 Fetyplace, James, of Powerley, esq 7
5461476 2493383 2493383 defendant Luffyngote Thomas esq 890034 890034 Luffyngote, Thomas, of Elmyngden, Oxon, esq 8
5461477 2493383 2493383 defendant Garrard Richard gent 888744 888744 Garrard, Richard, of Chemyngfilde, gent 9
5461478 2493383 2493383 defendant Gode Robert yeoman 803760 803760 Gode, Robert, of Olde Wyndesore, yeoman 10
5461479 2493383 2493383 defendant Meyr John yeoman 890035 890035 Meyr, John, of Wolde 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);