names

15 rows where place_id = 595497

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590626 1864710 1864710 defendant Rogers John, senior (legal representative) 595497 595497 Rogers, John, senior, of Hatfeld, Herts, innholder, executor of 0
3590629 1864711 1864711 defendant Roggers John, senior (legal representative) 595497 595497 Roggers, John, senior, of Hatfeld, Herts, innholder, executor of 0
3620714 1874053 1874053 defendant Rogers John yeoman 595497 595497 Rogers, John, of Hatfeld, Herts, yeoman 0
3942378 2004464 2004464 defendant Gryffytes John smith 595497 595497 Gryffytes, John, of Hatfeld, Herts, smith 1
3942381 2004465 2004465 defendant Gryffyth John smith 595497 595497 Gryffyth, John, of Hatfeld, Herts, smith 1
4012290 2029116 2029116 plaintiff Pyggotte Richard esq 595497 595497 Pyggotte, Richard, of Hatfeld, Herts, esq 0
4012305 2029121 2029121 plaintiff Pygotte Richard esq 595497 595497 Pygotte, Richard, of Hatfeld, Herts, esq 0
4879984 2320653 2320653 defendant Gybbus John husbandman 595497 595497 Gybbus, John, of Hatfeld, Herts, husbandman 4
5146279 2400043 2400043 defendant Bemond John gent 595497 595497 Bemond, John, of Hatfeld, Herts, gent 0
5335094 2455563 2455563 defendant Roger Thomas yeoman 595497 595497 Roger, Thomas, of Hatfeld, Herts, yeoman 0
5513646 2509117 2509117 defendant Walterot Thomas, senior esq 595497 595497 Walterot, Thomas, senior, of Hatfeld, Herts, esq 0
5513649 2509118 2509118 defendant Walterot Thomas, senior esq 595497 595497 Walterot, Thomas, senior, of Hatfeld, Herts, esq 0
5517698 2510373 2510373 defendant Fylde Nicholas chapman 595497 595497 Fylde, Nicholas, of Hatfeld, Herts, chapman 3
5634856 2554896 2554896 defendant Bone or Boue Henry maltman 595497 595497 Bone or Boue, Henry, of Hatfeld, Herts, maltman 1
5634861 2554897 2554897 defendant Bone or Boue Henry maltman 595497 595497 Bone or Boue, Henry, of Hatfeld, Herts, maltman 1

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