names

109 rows where place_id = 605122

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606700 1869770 1869770 defendant Glascok John butcher 605122 605122 Glascok, John, of Est Ham, butcher 0
3619275 1873631 1873631 defendant Bisshop alias Pontifex William chaplain 605122 605122 Bisshop alias Pontifex, William, of Est Ham, chaplain 0
3631114 1904551 1904551 defendant Danyell John yeoman 605122 605122 Danyell, John, of Est Ham, yeoman 0
3660481 1913540 1913540 defendant Gogge Thomas husbandman 605122 605122 Gogge, Thomas, of East Ham, husbandman 0
3660482 1913540 1913540 defendant Gogge Richard husbandman 605122 605122 Gogge, Richard, of East Ham, husbandman 1
3734685 1937096 1937096 defendant Balson John pulter 605122 605122 Balson, John, of Est Ham, pulter 0
3735093 1937217 1937217 defendant Gouge Nicholas yeoman 605122 605122 Gouge, Nicholas, of Est Ham, yeoman 0
3912119 1994378 1994378 defendant Thornton Henry chaplain 605122 605122 Thornton, Henry, of Est Ham, chaplain 0
3912120 1994378 1994378 defendant Lake Richard husbandman 605122 605122 Lake, Richard, of Est Ham, husbandman 1
3912121 1994378 1994378 defendant Glascok William husbandman 605122 605122 Glascok, William, of Est Ham, husbandman 2
3933286 2001427 2001427 defendant Nuclottes James husbandman 605122 605122 Nuclottes, James, of East Ham, husbandman 4
3991679 2021782 2021782 defendant Stepneth Robert esq 605122 605122 Stepneth, Robert, of East Ham, esq 0
4070798 2049850 2049850 defendant Ambrye John yeoman 605122 605122 Ambrye, John, of East Ham, yeoman 1
4206699 2097882 2097882 defendant Cherry John yeoman 605122 605122 Cherry, John, of Est Ham, yeoman 1
4237416 2108680 2108680 defendant Greane Edward tailor 605122 605122 Greane, Edward, of East Ham, tailor 0
4237418 2108680 2108680 defendant Key Henry husbandman 605122 605122 Key, Henry, of East Ham, husbandman 2
4237421 2108681 2108681 defendant Grene Edward tailor 605122 605122 Grene, Edward, of East Ham, tailor 1
4237422 2108681 2108681 defendant Nashe Robert yeoman 605122 605122 Nashe, Robert, of East Ham, yeoman 2
4237423 2108681 2108681 defendant Baxter Robert blacksmith 605122 605122 Baxter, Robert, of East Ham, blacksmith 3
4273778 2120776 2120776 defendant Barram William yeoman 605122 605122 Barram, William, of East Ham, yeoman 0
4468841 2190929 2190929 defendant Mower Thomas   605122 605122 Mower, Thomas, of East Ham 2
4614729 2235618 2235618 defendant Gardinere John   605122 605122 Gardinere, John, of East Ham 2
4669518 2256172 2256172 defendant Fynkebergh Alexander husbandman 605122 605122 Fynkebergh, Alexander, of East Ham, husbandman 0
4669521 2256172 2256172 defendant Bardener John, junior husbandman 605122 605122 Bardener, John, junior, of East Ham, husbandman 3
4740862 2277841 2277841 defendant London John laborer 605122 605122 London, John, of East Ham, laborer 0
4755816 2282202 2282202 defendant London John laborer 605122 605122 London, John, of East Ham, laborer 2
4757339 2282667 2282667 defendant Gyppe Richard laborer 605122 605122 Gyppe, Richard, of East Ham, laborer 0
4757340 2282668 2282668 plaintiff Botyld Richard   605122 605122 Botyld, Richard, of East Ham 0
4762867 2284367 2284367 plaintiff Gardyner John   605122 605122 Gardyner, John, of East Ham 0
4768879 2286248 2286248 plaintiff Okele William (legal representative) 605122 605122 Okele, William, of East Ham, vicar, executors of 0
4768880 2286248 2286248 plaintiff Fulk John   605122 605122 (Fulk, John, of East Ham 1
4768881 2286248 2286248 plaintiff Cole John   605122 605122 Cole, John, of East Ham 2
4768883 2286248 2286248 defendant Fydkyn William husbandman 605122 605122 Fydkyn, William, of East Ham, husbandman 0
4768884 2286249 2286249 plaintiff Okele William (legal representative) 605122 605122 Okele, William, of East Ham, vicar, executors of 0
4768885 2286249 2286249 plaintiff Fulk John   605122 605122 (Fulk, John, of East Ham 1
4768886 2286249 2286249 plaintiff Sole John   605122 605122 Sole, John, of East Ham 2
4768889 2286249 2286249 defendant Haleman William husbandman 605122 605122 Haleman, William, of East Ham, husbandman 1
4856116 2313285 2313285 defendant Gardener John pulter 605122 605122 Gardener, John, of Est Ham, pulter 1
4910012 2329657 2329657 defendant Hille John husbandman 605122 605122 Hille, John, of East Ham, husbandman 0
4910013 2329657 2329657 defendant Fulcokes John husbandman 605122 605122 Fulcokes, John, of East Ham, husbandman 1
4910014 2329657 2329657 defendant Badon John husbandman 605122 605122 Badon, John, of East Ham, husbandman 2
4979152 2350721 2350721 defendant Wade William fisher 605122 605122 Wade, William, of Est Ham, fisher 2
4979572 2350848 2350848 defendant Clerk John   605122 605122 Clerk, John, of Est Ham, holy water clerk 0
4998057 2356279 2356279 defendant Samon Robert husbandman 605122 605122 Samon, Robert, of East Ham, husbandman 0
4998058 2356279 2356279 defendant Benet William husbandman 605122 605122 Benet, William, of East ham, husbandman 1
5024772 2364166 2364166 defendant Sproute John husbandman 605122 605122 Sproute, John, of Est Ham, husbandman 1
5024779 2364169 2364169 defendant Samon Robert husbandman 605122 605122 Samon, Robert, of Est Ham, husbandman 0
5024780 2364169 2364169 defendant Benet William husbandman 605122 605122 together with Benet, William, of Est Ham, husbandman 1
5063302 2375557 2375557 defendant Samon Robert husbandman 605122 605122 Samon, Robert, of Est Ham, husbandman 0
5086060 2382314 2382314 defendant Heryngman William husbandman 605122 605122 Heryngman, William, of Est Ham, husbandman 4
5087467 2382711 2382711 defendant Samon Robert husbandman 605122 605122 Samon, Robert, of Est Ham, husbandman 0
5096013 2385263 2385263 plaintiff Spycer Thomas   605122 605122 Spycer, Thomas, of Est Ham 0
5105881 2388160 2388160 defendant Heryngman William laborer 605122 605122 Heryngman, William, of Est Ham, laborer 0
5105882 2388160 2388160 defendant Gardener Richard pulter 605122 605122 Gardener, Richard, of Est Ham, pulter 1
5105883 2388160 2388160 defendant Bacon John husbandman 605122 605122 Bacon, John, of Est Ham, husbandman 2
5107847 2388732 2388732 defendant Fydkyn William yeoman 605122 605122 Fydkyn, William, of Est Ham, yeoman 0
5133753 2396363 2396363 defendant Baker John carpenter 605122 605122 Baker, John, of East Ham, carpenter 1
5133754 2396363 2396363 defendant Ben-- John carpenter 605122 605122 Ben--, John, of East Ham, carpenter 2
5146162 2400002 2400002 defendant Keete William husbandman 605122 605122 Keete, William, of East Ham, husbandman 4
5200750 2415978 2415978 defendant Cok John husbandman 605122 605122 Cok, John, of East Ham, husbandman 1
5209198 2418420 2418420 defendant Baton John husbandman 605122 605122 Baton, John, of East Ham, husbandman 0
5209202 2418422 2418422 defendant Bacon John husbandman 605122 605122 Bacon, John, of East Ham, husbandman 0
5212921 2419519 2419519 defendant Stephenson Richard weaver 605122 605122 Stephenson, Richard, of Est Ham, weaver 0
5212926 2419520 2419520 defendant Stephenson Richard weaver 605122 605122 Stephenson, Richard, of Est Ham, weaver 0
5285930 2440900 2440900 defendant Gardyner John yeoman 605122 605122 Gardyner, John, of Est Ham, yeoman 0
5291661 2442568 2442568 defendant Saman Thomas laborer 605122 605122 Saman, Thomas, of Est Ham, laborer 2
5291662 2442568 2442568 defendant atte Wode John husbandman 605122 605122 atte Wode, John, of Est Ham, husbandman 3
5291663 2442568 2442568 defendant Towedemer John, senior husbandman 605122 605122 Towedemer, John, senior, of Est Ham, husbandman 4
5304394 2446314 2446314 plaintiff Hope Robert   605122 605122 Hope, Robert, of East Ham, vicar 0
5305369 2446614 2446614 defendant Cole Richard yeoman 605122 605122 Cole, Richard, of East Ham, yeoman 0
5305371 2446615 2446615 defendant Aysshe John yeoman 605122 605122 Aysshe, John, of East Ham, yeoman 0
5305373 2446616 2446616 defendant Beer Richard yeoman 605122 605122 Beer, Richard, of East Ham, yeoman 0
5305377 2446618 2446618 defendant Tademer John yeoman 605122 605122 Tademer, John, of East Ham, yeoman 0
5321547 2451531 2451531 defendant Peers William pulter 605122 605122 Peers, William, of Est Ham, pulter 1
5321548 2451531 2451531 defendant Sheperd John husbandman 605122 605122 Sheperd, John, of Est Ham, husbandman 2
5369026 2465905 2465905 defendant Frenssh John husbandman 605122 605122 Frenssh, John, of East Ham, husbandman 0
5369028 2465906 2465906 defendant Frenssh John husbandman 605122 605122 Frenssh, John, of East Ham, husbandman 0
5369230 2465976 2465976 defendant Bonok Robert husbandman 605122 605122 Bonok, Robert, of East Ham, husbandman 1
5369231 2465976 2465976 defendant Philip William husbandman 605122 605122 Philip, William, of East Ham, husbandman 2
5369240 2465979 2465979 defendant Peers William skinner 605122 605122 Peers, William, of East Ham, skinner 0
5369244 2465980 2465980 defendant Peers William skinner 605122 605122 Peers, William, of East Ham, skinner 1
5369429 2466031 2466031 defendant Tadmer or Tadiner John husbandman 605122 605122 Tadmer or Tadiner, John, of East Ham, husbandman 3
5369433 2466032 2466032 defendant Heryngman William husbandman 605122 605122 Heryngman, William, of East Ham, husbandman 2
5380945 2469607 2469607 defendant Frenche John pulter 605122 605122 Frenche, John, of East Ham, pulter 1
5380949 2469608 2469608 defendant Frenche John pulter 605122 605122 Frenche, John, of East Ham, pulter 1
5380953 2469609 2469609 defendant Frenssh John pulter 605122 605122 Frenssh, John, of East Ham, pulter 1
5385747 2470997 2470997 defendant Smyth William laborer 605122 605122 Smyth, William, of East Ham, laborer 0
5385748 2470997 2470997 defendant Feld William fisher 605122 605122 Feld, William, of East Ham, fisher 1
5385749 2470997 2470997 defendant Freman Simon fisher 605122 605122 Freman, Simon, of East Ham, fisher 2
5387040 2471360 2471360 defendant Frenche John skinner 605122 605122 Frenche, John, of East Ham, skinner 1
5387045 2471362 2471362 defendant Frenche John skinner 605122 605122 Frenche, John, of East Ham, skinner 1
5392106 2472826 2472826 defendant atte Wode John husbandman 605122 605122 atte Wode, John, of East Ham, husbandman 1
5397940 2474486 2474486 defendant Smyth William laborer 605122 605122 Smyth, William, of East Ham, laborer 0
5397942 2474486 2474486 defendant Freman Simons fisher 605122 605122 Freman, Simons, of East Ham, fisher 2
5411073 2478268 2478268 defendant Freman Edmund fisher 605122 605122 Freman, Edmund, of East Ham, fisher 1
5412357 2478640 2478640 defendant Reeder Thomas reeder 605122 605122 Reeder, Thomas, of East Ham, reeder 5
5418135 2480348 2480348 defendant Bere Richard fisher 605122 605122 Bere, Richard, of East Ham, fisher 2
5435878 2485675 2485675 defendant Bere Richard fisher 605122 605122 Bere, Richard, of East Ham, fisher 2
5446552 2488856 2488856 defendant Hall John husbandman 605122 605122 Hall, John, of East Ham, husbandman 0
5446555 2488856 2488856 defendant More Ellis husbandman 605122 605122 More, Ellis, of East Ham, husbandman 3

Next page

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