names

13 rows where case_id = 2018543

✎ 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
3982579 2018543 2018543 plaintiff Scryvener Ralph gent   Scryvener, Ralph, gent 0
3982580 2018543 2018543 defendant Perle Richard yeoman 602124 602124 Perle, Richard, of Fynbarowe, yeoman 0
3982581 2018543 2018543 defendant Rode or rede Thomas merchant 586134 586134 Rode or rede, Thomas, of Ipswich, merchant 1
3982582 2018543 2018543 defendant Artrys Henry yeoman 587187 587187 Artrys, Henry, of Laxfeld, yeoman 2
3982583 2018543 2018543 defendant Peke Henry yeoman 589258 589258 Peke, Henry, of Redgrave, yeoman 3
3982584 2018543 2018543 defendant Medocke Geoffrey brewer 666823 666823 Medocke, Geoffrey, of Ipwcih, brewer 4
3982585 2018543 2018543 defendant Sherwood John yeoman 590301 590301 Sherwood, John, of Hoxon, yeoman 5
3982586 2018543 2018543 defendant Garrard Robert yeoman 601444 601444 Garrard, Robert, of Pesenall, yeoman 6
3982587 2018543 2018543 defendant Scoldyng Robert merchant 591252 591252 Scoldyng, Robert, of Sybton, merchant 7
3982588 2018543 2018543 defendant Braunche Thomas yeoman 658449 658449 Braunche, Thomas, of Castle Framlyngham, yeoman 8
3982589 2018543 2018543 defendant Dux Reginald yeoman 666824 666824 Dux, Reginald, of Sweftlyng, yeoman 9
3982590 2018543 2018543 defendant Stowe Thomas husbandman 608033 608033 Stowe, Thomas, of Aldham, Essex, husbandman 10
3982591 2018543 2018543 defendant Butt Richard administrators of   Butt, Richard, administrators of 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);