names

14 rows where case_id = 2321761

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4883511 2321761 2321761 plaintiff Frankyssh alias Boston John (legal representative) 585869 585869 Frankyssh alias Boston, John, of London, mercer, executors of 0
4883512 2321761 2321761 plaintiff Frankyssh alias Boston Emma widow   (Frankyssh alias Boston, Emma, widow 1
4883513 2321761 2321761 plaintiff Estfeld William alderman 585869 585869 Estfeld, William, of London, mercer, alderman 2
4883514 2321761 2321761 plaintiff Wythe Hugh mercer 585869 585869 Wythe, Hugh, of London, mercer 3
4883515 2321761 2321761 plaintiff Onhond Thomas mercer 585869 585869 Onhond, Thomas, of London, mercer 4
4883516 2321761 2321761 plaintiff Lyndesey Richard scrivener 585869 585869 Lyndesey, Richard, of London, scrivener 5
4883517 2321761 2321761 defendant Reymound John butcher 585978 585978 Reymound, John, of St Neots, Hunts, butcher 0
4883518 2321761 2321761 defendant West William yeoman 594218 594218 West, William, of St Neots, yeoman 1
4883519 2321761 2321761 defendant Jermyn John (legal representative) 801461 801461 Jermyn, John, of Metefeld, Suff, knight, executors of 2
4883520 2321761 2321761 defendant Jermyn Margery widow 585936 585936 (Jermyn, Margery, of Norwich, widow 3
4883521 2321761 2321761 defendant Jermyn John esq 801461 801461 Jermyn, John, of Metefeld, Suff, esq 4
4883522 2321761 2321761 defendant Couper John vicar of Mendeham, Suff   Couper, John, vicar of Mendeham, Suff 5
4883523 2321761 2321761 defendant Aty or Acy John gent 817000 817000 Aty or Acy, John, of Suthlyngham, Suff, gent 6
4883524 2321761 2321761 defendant Yonge John yeoman 594175 594175 Yonge, John, of Metefeld, yeoman 7

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