names

13 rows where case_id = 2512728

✎ 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
5526007 2512728 2512728 plaintiff Hobard James     Hobard, James 0
5526008 2512728 2512728 defendant Hawkyn Thomas laborer 588259 588259 Hawkyn, Thomas, of Flecchyng, laborer 0
5526009 2512728 2512728 defendant Stone Richard laborer 588259 588259 Stone, Richard, of Flecchyng, laborer 1
5526010 2512728 2512728 defendant Wode John yeoman 588259 588259 Wode, John, of Flecchyng, yeoman 2
5526011 2512728 2512728 defendant Denot or Devot William laborer 588259 588259 Denot or Devot, William, of Flecchyng, laborer 3
5526012 2512728 2512728 defendant Snowdoun Richard laborer 589156 589156 Snowdoun, Richard, of Hartfeld, laborer 4
5526013 2512728 2512728 defendant Medeherst Thomas laborer 589156 589156 Medeherst, Thomas, of Hartfeld, laborer 5
5526014 2512728 2512728 defendant Tanner James yeoman 704517 704517 Tanner, James, of Waldorn, yeoman 6
5526015 2512728 2512728 defendant Hall Richard chaplain 589156 589156 Hall, Richard, of Hartfeld, chaplain 7
5526016 2512728 2512728 defendant atte Wode Henry baker 588259 588259 atte Wode, Henry, of Flecchyng, baker 8
5526017 2512728 2512728 defendant Salmon Thomas laborer 587695 587695 Salmon, Thomas, of Buxsted, laborer 9
5526018 2512728 2512728 defendant Cowestok Thomas yeoman 588259 588259 Cowestok, Thomas, of Flecchyng, yeoman 10
5526019 2512728 2512728 defendant Lovell William husbandman 622505 622505 Lovell, William, of Bercomp, husbandman 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);