names

13 rows where case_id = 2365648

✎ 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
5030000 2365648 2365648 plaintiff Paslewe John     Paslewe, John 0
5030001 2365648 2365648 defendant Hirde William yeoman 586397 586397 Hirde, William, of Morton, yeoman 0
5030002 2365648 2365648 defendant John of Hyrde John, of Morton, yeoman   John, of Hyrde, John, of Morton, yeoman 1
5030003 2365648 2365648 defendant Rogerson Joan widow 586397 586397 Rogerson, Joan, of Morton, widow 2
5030004 2365648 2365648 defendant Spence Henry yeoman 837178 837178 Spence, Henry, of Hammesthwayth, yeoman 3
5030005 2365648 2365648 defendant Sergeantson Richard husbandman 837178 837178 Sergeantson, Richard, of Hammesthwayth, husbandman 4
5030006 2365648 2365648 defendant Bunche William yeoman 837179 837179 Bunche, William, of Patheleybryg, yeoman 5
5030007 2365648 2365648 defendant Hervy Richard yeoman 623970 623970 Hervy, Richard, of Clyne, yeoman 6
5030008 2365648 2365648 defendant Shut Stephen yeoman 611336 611336 Shut, Stephen, of Clynt, yeoman 7
5030009 2365648 2365648 defendant Farvyll or Farnyll William yeoman 837178 837178 Farvyll or Farnyll, William, of Hammesthwayth, yeoman 8
5030010 2365648 2365648 defendant Beston William yeoman 837177 837177 Beston, William, of Faweder, yeoman 9
5030011 2365648 2365648 defendant Haxby Richard yeoman 837177 837177 Haxby, Richard, of Faweder, yeoman 10
5030012 2365648 2365648 defendant Harwarde John vicar of Hammesthwayth   Harwarde, John, vicar of Hammesthwayth 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);