names

6 rows where case_id = 1903804

✎ 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
3628556 1903804 1903804 plaintiff Chaunt Joan former wife of Whytlake, Geoffrey, of Norwich, baker   Chaunt, Joan, former wife of Whytlake, Geoffrey, of Norwich, baker, executrix of Chaunt, Thomas, of Norwich, alderman, executors of 0
3628557 1903804 1903804 plaintiff Stalon Stephen barker   (Stalon, Stephen, barker 1
3628558 1903804 1903804 plaintiff Leman Richard hosier 585936 585936 Leman, Richard, of Norwich, hosier 2
3628559 1903804 1903804 defendant Bery John (legal representative) 585936 585936 Bery, John, of Norwich, smith, executors of 0
3628560 1903804 1903804 defendant Cryspyn Richard yeoman 585936 585936 (Cryspyn, Richard, of Norwich, yeoman 1
3628561 1903804 1903804 defendant Colet John yeoman 586471 586471 Colet, John, of Aylesham, yeoman 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);