names

39 rows where place_id = 614164

✎ 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
3702250 1926959 1926959 defendant Briggys Thomas gent 614164 614164 Briggys, Thomas, of Hytcham, gent 0
3731475 1936070 1936070 defendant Briggis Thomas gent 614164 614164 Briggis, Thomas, of Hytcham, gent 0
3759045 1944815 1944815 defendant Brygge Thomas gent 614164 614164 Brygge, Thomas, of Hytcham, gent 0
3944493 2005175 2005175 defendant Raven William, senior yeoman 614164 614164 Raven, William, senior, of Hytcham, yeoman 0
3951829 2007701 2007701 defendant Raven William yeoman 614164 614164 Raven, William, of Hytcham, yeoman 0
3965058 2012382 2012382 plaintiff Bantofte Thomas husbandman 614164 614164 Bantofte, Thomas, of Hytcham, husbandman 0
3966454 2012902 2012902 plaintiff Bowle or Bowell Thomas   614164 614164 Bowle or Bowell, Thomas, of Hytcham 0
3966561 2012938 2012938 defendant Albye alias Brewster William butcher 614164 614164 Albye alias Brewster, William, of Hytcham, butcher 0
3967722 2013345 2013345 defendant Waldegrave William esq 614164 614164 Waldegrave, William, of Hytcham, esq 0
3985581 2019606 2019606 plaintiff Waldegrave William esq 614164 614164 Waldegrave, William, of Hytcham, esq 0
3987639 2020329 2020329 plaintiff Yonge Thomas yeoman 614164 614164 Yonge, Thomas, of Hytcham, yeoman 0
4058805 2045543 2045543 defendant Hardye William yeoman 614164 614164 Hardye, William, of Hytcham, yeoman 0
4058807 2045544 2045544 defendant Yonge Thomas yeoman 614164 614164 Yonge, Thomas, of Hytcham, yeoman 0
4072437 2050444 2050444 defendant Hardy Robert yeoman 614164 614164 Hardy, Robert, of Hytcham, yeoman 0
4081357 2053639 2053639 defendant Yong Thomas husbandman 614164 614164 Yong, Thomas, of Hytcham, husbandman 0
4087729 2055904 2055904 defendant Elgar Randolph husbandman 614164 614164 Elgar, Randolph, of Hytcham, husbandman 0
4095471 2058704 2058704 defendant Hardy Robert yeoman 614164 614164 Hardy, Robert, of Hytcham, yeoman 0
4095473 2058705 2058705 defendant Hardye Robert yeoman 614164 614164 Hardye, Robert, of Hytcham, yeoman 0
4096222 2058976 2058976 defendant Hardy Robert yeoman 614164 614164 Hardy, Robert, of Hytcham, yeoman 0
4096224 2058977 2058977 defendant Hardy Robert yeoman 614164 614164 Hardy, Robert, of Hytcham, yeoman 0
4096229 2058978 2058978 defendant Hardy William yeoman 614164 614164 Hardy, William, of Hytcham, yeoman 3
4133621 2072357 2072357 defendant Hardye Robert yeoman 614164 614164 Hardye, Robert, of Hytcham, yeoman 0
4150802 2078415 2078415 defendant Hardy Robert yeoman 614164 614164 Hardy, Robert, of Hytcham, yeoman 0
4151963 2078796 2078796 defendant Jenor William husbandman 614164 614164 Jenor, William, of Hytcham, husbandman 0
4151965 2078796 2078796 defendant Skyppon Thomas husbandman 614164 614164 Skyppon, Thomas, of Hytcham, husbandman 2
4161455 2082083 2082083 defendant Hardy Robert yeoman 614164 614164 Hardy, Robert, of Hytcham, yeoman 0
4161914 2082236 2082236 defendant Hardye Robert yeoman 614164 614164 Hardye, Robert, of Hytcham, yeoman 0
4169610 2084877 2084877 defendant Raven Thomas husbandman 614164 614164 Raven, Thomas, of Hytcham, husbandman 1
4221927 2103165 2103165 defendant Crismas John   614164 614164 Crismas, John, of Hytcham, rough mason 0
4247627 2112188 2112188 defendant Crismas John   614164 614164 Crismas, John, of Hytcham, rough mason 0
4247628 2112188 2112188 defendant Jenor William yeoman 614164 614164 Jenor, William, of Hytcham, yeoman 1
4252920 2113970 2113970 defendant Landman alias Janninge Leonard husbandman 614164 614164 Landman alias Janninge, Leonard, of Hytcham, husbandman 0
4255204 2114725 2114725 defendant Stockdale Nicholas yeoman 614164 614164 Stockdale, Nicholas, of Hytcham, yeoman 0
4272393 2120341 2120341 defendant Raven Thomas husbandman 614164 614164 Raven, Thomas, of Hytcham, husbandman 0
4337696 2142930 2142930 defendant Kemball Edmund yeoman 614164 614164 Kemball, Edmund, of Hytcham, yeoman 0
4338666 2143277 2143277 defendant Bowle Richard husbandman 614164 614164 Bowle, Richard, of Hytcham, husbandman 2
4347905 2146520 2146520 defendant Kymbolde or Kymball Nicholas yeoman 614164 614164 Kymbolde or Kymball, Nicholas, of Hytcham, yeoman 0
4389982 2161273 2161273 defendant Smythe Edward butcher 614164 614164 Smythe, Edward, of Hytcham, butcher 0
4410048 2167967 2167967 defendant Stockdale Nicholas yeoman 614164 614164 Stockdale, Nicholas, of Hytcham, yeoman 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);