names

28 rows where place_id = 606572

✎ 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
3665715 1915225 1915225 defendant Smyth Thomas smith 606572 606572 Smyth, Thomas, of Cheston, Herts, smith 2
3709502 1929276 1929276 defendant Lucas John husbandman 606572 606572 Lucas, John, of Cheston, Herts, husbandman 0
3709504 1929277 1929277 defendant Lucas John husbandman 606572 606572 Lucas, John, of Cheston, Herts, husbandman 0
3722880 1933421 1933421 defendant Denes Thomas esq 606572 606572 Denes, Thomas, of Cheston, herts, esq 3
3734582 1937061 1937061 defendant God Richard clerk 606572 606572 God, Richard, of Cheston, Herts, clerk 0
3738758 1938331 1938331 defendant Denes Thomas esq 606572 606572 Denes, Thomas, of Cheston, Herts, esq 0
3912360 1994465 1994465 defendant Verney Dorothy widow 606572 606572 Verney, Dorothy, of Cheston, Herts, widow 0
3952590 2007977 2007977 plaintiff Holdesworth Edward husbandman 606572 606572 Holdesworth, Edward, of Cheston, Herts, husbandman 0
3958736 2010131 2010131 defendant Partriche Hugh esq 606572 606572 Partriche, Hugh, of Cheston, Herts, esq 0
4022669 2032832 2032832 defendant Doughtye William clothier 606572 606572 Doughtye, William, of Cheston, Herts, clothier 0
4022672 2032833 2032833 defendant Doughtye William clothier 606572 606572 Doughtye, William, of Cheston, Herts, clothier 0
4082121 2053905 2053905 defendant Herling Randall baker 606572 606572 Herling, Randall, of Cheston, Herts, baker 0
4240715 2109876 2109876 defendant Hardyn Christopher yeoman 606572 606572 Hardyn, Christopher, of Cheston, Herts, yeoman 0
4325433 2138884 2138884 defendant Hale Francis husbandman 606572 606572 Hale, Francis, of Cheston, herts, husbandman 2
4331958 2140983 2140983 defendant Angell Cuthbert yeoman 606572 606572 Angell, Cuthbert, of Cheston, Herts, yeoman 0
4331962 2140984 2140984 defendant Angell Cuthbert yeoman 606572 606572 Angell, Cuthbert, of Cheston, Herts, yeoman 1
4337085 2142693 2142693 defendant Bushie William yeoman 606572 606572 Bushie, William, of Cheston, Herts, yeoman 1
4341826 2144417 2144417 defendant Turner Thomas gent 606572 606572 Turner, Thomas, of Cheston, Herts, gent 1
4347109 2146245 2146245 defendant Harrys William loader 606572 606572 Harrys, William, of Cheston, Herts, loader 1
4352889 2148236 2148236 defendant Hayes George yeoman 606572 606572 Hayes, George, of Cheston, Herts, yeoman 1
4360356 2150872 2150872 defendant Myles William yeoman 606572 606572 Myles, William, of Cheston, herts, yeoman 3
4360392 2150882 2150882 defendant Bushie William yeoman 606572 606572 Bushie, William, of Cheston, Herts, yeoman 1
4387184 2160366 2160366 defendant Barnes John carrier 606572 606572 Barnes, John, of Cheston, Herts, carrier 2
4398800 2164180 2164180 defendant Harrys William loader 606572 606572 Harrys, William, of Cheston, Herts, loader 1
4703321 2266417 2266417 defendant Birchemere Walter   606572 606572 Birchemere, Walter, of Cheston, Herts, chaplain, formerly parson of the parish church in Waldeneweton or Wold Newton 0
5201466 2416187 2416187 defendant Flyntard John brewer 606572 606572 Flyntard, John, of Cheston, Herts, brewer 0
5305732 2446726 2446726 defendant Adam Edmund maltman 606572 606572 Adam, Edmund, of Cheston, Herts, maltman 0
5373587 2467338 2467338 defendant Edrnes or Gernes Thomas husbandman 606572 606572 Edrnes or Gernes, Thomas, of Cheston, Herts, husbandman 2

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