names

16 rows where place_id = 612910

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3695547 1924834 1924834 defendant Hobart John innholder 612910 612910 Hobart, John, of Blyburghe, innholder 0
3946464 2005831 2005831 defendant Codd Nicholas husbandman 612910 612910 Codd, Nicholas, of Blyburghe, husbandman 0
3985416 2019544 2019544 defendant Johnson Thomas husbandman 612910 612910 Johnson, Thomas, of Blyburghe, husbandman 1
4020293 2031980 2031980 defendant Lyngewoode Anthony yeoman 612910 612910 Lyngewoode, Anthony, of Blyburghe, yeoman 0
4020294 2031980 2031980 defendant Waynslett or Waynflett John husbandman 612910 612910 Waynslett or Waynflett, John, of Blyburghe, husbandman 1
4118785 2066999 2066999 defendant Ascue Henry gent 612910 612910 Ascue, Henry, of Blyburghe, gent 1
4142983 2075716 2075716 defendant Stuttinges Robert husbandman 612910 612910 Stuttinges, Robert, of Blyburghe, husbandman 1
4142984 2075716 2075716 defendant Harryson Robert husbandman 612910 612910 Harryson, Robert, of Blyburghe, husbandman 2
4142985 2075716 2075716 defendant Smyth Thomas husbandman 612910 612910 Smyth, Thomas, of Blyburghe, husbandman 3
4142986 2075716 2075716 defendant Storye Hugh husbandman 612910 612910 Storye, Hugh, of Blyburghe, husbandman 4
4142987 2075716 2075716 defendant Hope John husbandman 612910 612910 Hope, John, of Blyburghe, husbandman 5
4233475 2107224 2107224 defendant Neve Thomas yeoman 612910 612910 Neve, Thomas, of Blyburghe, yeoman 0
4243581 2110839 2110839 defendant Whinwery or Whynerye Robert yeoman 612910 612910 Whinwery or Whynerye, Robert, of Blyburghe, yeoman 2
4378136 2157247 2157247 defendant Askewe or Aiscoughe Henry esq 612910 612910 Askewe or Aiscoughe, Henry, of Blyburghe, esq 0
4378137 2157247 2157247 defendant Askewe or Aiscoughe Walter   612910 612910 Askewe or Aiscoughe, Walter, of Blyburghe, gent, his son 1
4393511 2162430 2162430 defendant Neave Thomas gent 612910 612910 Neave, Thomas, of Blyburghe, gent 3

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