names

13 rows where case_id = 2489705

✎ 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
5449381 2489705 2489705 plaintiff Mountford Simon knight   Mountford, Simon, knight 0
5449382 2489705 2489705 defendant Hyde John esq 610091 610091 Hyde, John, of Dencheworth, esq 0
5449383 2489705 2489705 defendant Makney Henry esq 627195 627195 Makney, Henry, of Makney, esq 1
5449384 2489705 2489705 defendant Perkyns John esq 888741 888741 Perkyns, John, of Vynchampstede or Finhampstead, esq 2
5449385 2489705 2489705 defendant Whiteborne Henry yeoman 864426 864426 Whiteborne, Henry, of Sperfold, yeoman 3
5449386 2489705 2489705 defendant Boweyer Thomas yeoman 600601 600601 Boweyer, Thomas, of White Waltham, yeoman 4
5449387 2489705 2489705 defendant Beynton William fuller 587891 587891 Beynton, William, of Redyng, fuller 5
5449388 2489705 2489705 defendant Blyke John yeoman 668316 668316 Blyke, John, of Long Witnam, yeoman 6
5449389 2489705 2489705 defendant Fetiplace James esq 888742 888742 Fetiplace, James, of Powersley, esq 7
5449390 2489705 2489705 defendant Luffyngote Thomas esq 888743 888743 Luffyngote, Thomas, of Elmyngdon, Oxon, esq 8
5449391 2489705 2489705 defendant Carrara Richard gent 888744 888744 Carrara, Richard, of Chemyngfilde, gent 9
5449392 2489705 2489705 defendant Gode Robert yeoman 888745 888745 Gode, Robert, of Old Wyndsore, yeoman 10
5449393 2489705 2489705 defendant Mayr John yeoman 885378 885378 Mayr, John, of Wold Wyndsore, 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);