names

13 rows where case_id = 2357633

✎ 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
5002460 2357633 2357633 plaintiff Norwich William     Norwich, William 0
5002461 2357633 2357633 defendant Tabbard Simon carpenter 585936 585936 Tabbard, Simon, of Norwich, carpenter 0
5002462 2357633 2357633 defendant Warmale John husbandman 588239 588239 Warmale, John, of Yelverton, husbandman 1
5002463 2357633 2357633 defendant Penne John husbandman 587749 587749 Penne, John, of Redenhale, husbandman 2
5002464 2357633 2357633 defendant Vynne John yeoman 759963 759963 Vynne, John, of Lodne, yeoman 3
5002465 2357633 2357633 defendant Haweys John husbandman 822857 822857 Haweys, John, of Betle, husbandman 4
5002466 2357633 2357633 defendant Reynald Edmund shoemaker 585936 585936 Reynald, Edmund, of Norwich, shoemaker 5
5002467 2357633 2357633 defendant Lent John yeoman 587033 587033 Lent, John, of Crowemere, yeoman 6
5002468 2357633 2357633 defendant Herryson Rumbaldus beer brewer 653005 653005 Herryson, Rumbaldus, of Ipswich, Suffolk, beer brewer 7
5002469 2357633 2357633 defendant Turnour Roger husbandman 592238 592238 Turnour, Roger, of Shipdam, Norf, husbandman 8
5002470 2357633 2357633 defendant Lasy or Lafy John   833439 833439 Lasy or Lafy, John, of Great Yarmouth, sergeaunt 9
5002471 2357633 2357633 defendant Osbern William chaplain 603616 603616 Osbern, William, of Cley next the sea, chaplain 10
5002472 2357633 2357633 defendant Elys Robert merchant 585933 585933 Elys, Robert, of Great Yarmouth, merchant 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);