names

14 rows where place_id = 598225

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3631647 1904712 1904712 defendant Cobbe Nicholas pulter 598225 598225 Cobbe, Nicholas, of Stepyngley, pulter 0
3634772 1905672 1905672 defendant Sybley Edward husbandman 598225 598225 Sybley, Edward, of Stepyngley, husbandman 1
3679799 1919748 1919748 defendant Coteryche John yeoman 598225 598225 Coteryche, John, of Stepyngley, yeoman 0
3681766 1920396 1920396 defendant Godrich John husbandman 598225 598225 Godrich, John, of Stepyngley, husbandman 1
3682241 1920544 1920544 defendant Gaukys or Gankys John weaver 598225 598225 Gaukys or Gankys, John, of Stepyngley, weaver 0
3702926 1927183 1927183 defendant Coterig John yeoman 598225 598225 Coterig, John, of Stepyngley, yeoman 0
3739686 1938625 1938625 defendant Harman Thomas husbandman 598225 598225 Harman, Thomas, of Stepyngley, husbandman 1
3752316 1942649 1942649 defendant Herman Thomas husbandman 598225 598225 Herman, Thomas, of Stepyngley, husbandman 2
3777979 1950824 1950824 defendant Smyth Richard clerk 598225 598225 Smyth, Richard, of Stepyngley, clerk 0
4078047 2052451 2052451 defendant Norris John husbandman 598225 598225 Norris, John, of Stepyngley, husbandman 1
4105630 2062300 2062300 defendant Style Anne widow 598225 598225 Style, Anne, of Stepyngley, widow 0
4105632 2062301 2062301 defendant Style Anne widow 598225 598225 Style, Anne, of Stepyngley, widow 0
4831527 2305893 2305893 defendant Shepert John husbandman 598225 598225 Shepert, John, of Stepyngley, husbandman 0
4973569 2349047 2349047 defendant Stepyngley Henry yeoman 598225 598225 Stepyngley, Henry, of Stepyngley, yeoman 0

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);