names

130 rows where place_id = 587667

✎ 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
3592088 1865140 1865140 defendant Godyng Reginald husbandman 587667 587667 Godyng, Reginald, of Est Pekham, husbandman 2
3592505 1865270 1865270 defendant Godyng John husbandman 587667 587667 Godyng, John, of Est Pekham, husbandman 0
3592951 1865417 1865417 defendant Kebyll Thomas laborer 587667 587667 Kebyll, Thomas, of Est Pekham, laborer 1
3592952 1865417 1865417 defendant Wymbyll William laborer 587667 587667 Wymbyll, William, of Est Pekham, laborer 2
3595439 1866207 1866207 defendant Dyker John smith 587667 587667 Dyker, John, of Est Pekham, smith 3
3595440 1866207 1866207 defendant Holman James laborer 587667 587667 Holman, James, of Est Pekham, laborer 4
3634786 1905679 1905679 defendant Cruttynden John husbandman 587667 587667 Cruttynden, John, of Est Pekham, husbandman 0
3652990 1911266 1911266 plaintiff Richerdson Robert   587667 587667 Richerdson, Robert, of Est Pekham 1
3662728 1914261 1914261 defendant Terry William butcher 587667 587667 Terry, William, of East Pekham, butcher 0
3662730 1914262 1914262 defendant Terry William butcher 587667 587667 Terry, William, of East Pekham, butcher 0
3666408 1915444 1915444 defendant Reder Thomas husbandman 587667 587667 Reder, Thomas, of East Pekham, husbandman 2
3671422 1917040 1917040 defendant Dwcke John husbandman 587667 587667 Dwcke, John, of Est Pekham, husbandman 0
3698010 1925602 1925602 defendant Giles William smith 587667 587667 Giles, William, of Est Pekham, smith 3
3703752 1927452 1927452 defendant Chamber Nicholas yeoman 587667 587667 Chamber, Nicholas, of East Pekham, yeoman 0
3723483 1933611 1933611 defendant Payn John smith 587667 587667 Payn, John, of Est Pekham, smith 0
3723485 1933611 1933611 defendant Renkyn John husbandman 587667 587667 Renkyn, John, of East Pekham, husbandman 2
3724559 1933966 1933966 defendant A Downe John tanner 587667 587667 A Downe, John, of Est Pekham, tanner 2
3731705 1936145 1936145 defendant Lake Edward laborer 587667 587667 Lake, Edward, of Est Pekham, laborer 1
3743295 1939773 1939773 defendant Goodyng John yeoman 587667 587667 Goodyng, John, of Est Pekham, yeoman 0
3765186 1946775 1946775 defendant Goodyng John yeoman 587667 587667 Goodyng, John, of Est Pekham, yeoman 0
3766837 1947294 1947294 defendant Kenwode John butcher 587667 587667 Kenwode, John, of Est Pekham, butcher 0
3768770 1947883 1947883 defendant Casyer John gent 587667 587667 Casyer, John, of Est Pekham, gent 0
3786572 1953594 1953594 defendant Casyer John gent 587667 587667 Casyer, John, of Est Pekham, gent 0
3787595 1953908 1953908 defendant Crotynden alias Crokenden John yeoman 587667 587667 Crotynden alias Crokenden, John, of Est Pekham, yeoman 0
3787596 1953908 1953908 defendant Manton Robert carver 587667 587667 Manton, Robert, of Est Pekham, carver 1
3789798 1954640 1954640 defendant Crotenden John husbandman 587667 587667 Crotenden, John, of Est Pekham, husbandman 2
3792898 1955632 1955632 defendant Hoggyn Thomas miller 587667 587667 Hoggyn, Thomas, of Est Pekham, miller 2
3795317 1956404 1956404 defendant Whetnall George gent 587667 587667 Whetnall, George, of Est Pekham, gent 0
3797217 1957011 1957011 defendant Coke Richard thatcher 587667 587667 Coke, Richard, of Est Pekham, thatcher 2
3807506 1960253 1960253 defendant Payn John smith 587667 587667 Payn, John, of East Pekham, smith 0
3807507 1960253 1960253 defendant Jurden Richard miller 587667 587667 Jurden, Richard, of East Pekham, miller 1
3904105 1991616 1991616 defendant Multon George gent 587667 587667 Multon, George, of Est Pekham, gent 0
4030017 2035382 2035382 plaintiff Downe Robert (legal representative) 587667 587667 Downe, Robert, of Est Pekham, yeoman, executors of 0
4030021 2035383 2035383 plaintiff Downe Robert (legal representative) 587667 587667 Downe, Robert, of Est pekham, yeoman, executors of 0
4501864 2201183 2201183 defendant Baker John   587667 587667 Baker, John, of East Pekham 0
4501866 2201184 2201184 defendant Baker John   587667 587667 Baker, John, of East Pekham 0
4623534 2238338 2238338 plaintiff Mewe John   587667 587667 Mewe, John, of East Pekham 0
4644992 2244609 2244609 plaintiff Mewe John esq 587667 587667 Mewe, John, of East Pekham, esq 0
4679433 2259183 2259183 defendant Bartolf Bartholmew butcher 587667 587667 Bartolf, Bartholmew, of East Pekham, butcher 1
4679436 2259184 2259184 defendant Barcolfe Bartholomew butcher 587667 587667 Barcolfe, Bartholomew, of East Pekham, butcher 1
4682466 2260140 2260140 plaintiff Nichole Thomas   587667 587667 Nichole, Thomas, of East Pekham 0
4780702 2289961 2289961 plaintiff Byrche Simon   587667 587667 Byrche, Simon, of Est Pekham 0
4780703 2289961 2289961 defendant Denys John tailor 587667 587667 Denys, John, of Est Pekham, tailor 0
4780704 2289961 2289961 defendant Denemam or Devemam John chandler 587667 587667 Denemam or Devemam, John, of Est Pekham, chandler 1
4820659 2302534 2302534 defendant Belle Agnes single woman 587667 587667 Belle, Agnes, of East Pekham, single woman 0
4844945 2309938 2309938 defendant Fynche Richard husbandman 587667 587667 Fynche, Richard, of East Pekham, husbandman 0
4853753 2312587 2312587 defendant Doke Richard husbandman 587667 587667 Doke, Richard, of East Pekham, husbandman 0
4853754 2312587 2312587 defendant Doke William husbandman 587667 587667 Doke, William, of East Pekham, husbandman 1
4856366 2313366 2313366 plaintiff Barton John butcher 587667 587667 Barton, John, of Est Pekham, butcher 0
4884241 2321980 2321980 defendant Fox Richard laborer 587667 587667 Fox, Richard, of Est Pekham, laborer 2
4905695 2328382 2328382 defendant Brod Richard laborer 587667 587667 Brod, Richard, of Est Pekham, laborer 0
4905696 2328382 2328382 defendant Kebbyll John laborer 587667 587667 Kebbyll, John, of Est Pekham, laborer 1
4905697 2328382 2328382 defendant Brod John laborer 587667 587667 Brod, John, of Est Pekham, laborer 2
4912034 2330267 2330267 defendant Hoghelot Henry laborer 587667 587667 Hoghelot, Henry, of East Pekham, laborer 0
4924764 2334180 2334180 defendant Sandh--- Richard husbandman 587667 587667 Sandh---, Richard, of East Pekham, husbandman 1
4937508 2338106 2338106 defendant Hoghelot Henry husbandman 587667 587667 Hoghelot, Henry, of Est Pekham, husbandman 0
4946548 2340916 2340916 defendant Umfray Thomas yeoman 587667 587667 Umfray, Thomas, of Est Pekham, yeoman 0
4978091 2350411 2350411 defendant Humfrey Thomas husbandman 587667 587667 Humfrey, Thomas, of Est Pekham, husbandman 0
4980406 2351080 2351080 defendant Gowle Henry   587667 587667 Gowle, Henry, of Est Pekham 2
5006341 2358753 2358753 defendant Brod Richard husbandman 587667 587667 Brod, Richard, of East Pekham, husbandman 1
5011783 2360297 2360297 defendant (illegible) John gent 587667 587667 _, John, of East Pekham, gent 0
5058209 2374010 2374010 defendant Coyff Robert husbandman 587667 587667 Coyff, Robert, of Est Pekham, husbandman 0
5073103 2378440 2378440 defendant Bourner Thomas butcher 587667 587667 Bourner, Thomas, of Est Pekham, butcher 3
5079978 2380489 2380489 defendant Donne or Doune William laborer 587667 587667 Donne or Doune, William, of Est Pekham, laborer 3
5092657 2384232 2384232 defendant Renkyn Robert husbandman 587667 587667 Renkyn, Robert, of Est Pekham, husbandman 1
5097396 2385669 2385669 defendant Bournere Thomas butcher 587667 587667 Bournere, Thomas, of Est Pekham, butcher 3
5106316 2388287 2388287 defendant Elyot John laborer 587667 587667 Elyot, John, of Est Pekham, laborer 0
5106321 2388288 2388288 defendant Elyot John laborer 587667 587667 together with Elyot, John, of Est Pekham, laborer 1
5122008 2392852 2392852 defendant Erkebold Richard husbandman 587667 587667 Erkebold, Richard, of Est Pekham, husbandman 0
5122009 2392852 2392852 defendant atte Wode William husbandman 587667 587667 atte Wode, William, of Est Pekham, husbandman 1
5131134 2395596 2395596 defendant Baker John laborer 587667 587667 Baker, John, of East Pekham, laborer 0
5131136 2395597 2395597 defendant Cayff Robert   587667 587667 Cayff, Robert, of East Pekham 0
5141018 2398495 2398495 defendant Erkkold Richard husbandman 587667 587667 Erkkold, Richard, of East Pekham, husbandman 0
5162155 2404665 2404665 defendant Erkebold Richard husbandman 587667 587667 Erkebold, Richard, of East Pekham, husbandman 0
5162156 2404665 2404665 defendant atte Wode William husbandman 587667 587667 atte Wode, William, of East Pekham, husbandman 1
5172214 2407597 2407597 defendant Messanger Thomas husbandman 587667 587667 Messanger, Thomas, of East Pekham, husbandman 0
5176345 2408770 2408770 defendant atte Wode William husbandman 587667 587667 atte Wode, William, of East Pekham, husbandman 1
5219227 2421346 2421346 defendant Renkyn Richard tanner 587667 587667 Renkyn, Richard, of Est Pekham, tanner 4
5227840 2423757 2423757 defendant Stokenbury John, senior smith 587667 587667 Stokenbury, John, senior, of Est Pekham, smith 0
5227841 2423757 2423757 defendant Stokenbury Thomas, junior smith 587667 587667 Stokenbury, Thomas, junior, of Est Pekham, smith 1
5235859 2426068 2426068 defendant Howelot Henry husbandman 587667 587667 Howelot, Henry, of Est Pekham, husbandman 0
5242573 2428034 2428034 defendant Messenger Thomas yeoman 587667 587667 Messenger, Thomas, of Est Pekham, yeoman 2
5242577 2428035 2428035 defendant Messenger Thomas yeoman 587667 587667 Messenger, Thomas, of Est Pekham, yeoman 0
5248884 2429795 2429795 defendant Messengere Thomas yeoman 587667 587667 Messengere, Thomas, of Est Pekham, yeoman 0
5250182 2430169 2430169 defendant Stokenbury Thomas smith 587667 587667 Stokenbury, Thomas, of Est Pekham, smith 0
5256716 2432221 2432221 defendant Humfry John, junior husbandman 587667 587667 Humfry, John, junior, of Est Pekham, husbandman 0
5258115 2432655 2432655 defendant Messanger Thomas husbandman 587667 587667 Messanger, Thomas, of Est Pekham, husbandman 0
5261626 2433744 2433744 defendant Easthawe John butcher 587667 587667 Easthawe, John, of Est Pekham, butcher 0
5266381 2435235 2435235 defendant Bourner Thomas husbandman 587667 587667 Bourner, Thomas, of Est Pekham, husbandman 1
5266648 2435323 2435323 defendant Dorant John clerk 587667 587667 Dorant, John, of Est Pekham, clerk 0
5268157 2435810 2435810 defendant (illegible) Thomas husbandman 587667 587667 ---, Thomas, of East Pekham, husbandman 2
5268868 2436009 2436009 defendant Adilsey John yeoman 587667 587667 Adilsey, John, of East Pekham, yeoman 0
5271152 2436659 2436659 defendant Miller Thomas carpenter 587667 587667 Miller, Thomas, of East Pekham, carpenter 0
5328867 2453711 2453711 defendant Godyng Thomas yeoman 587667 587667 (Godyng, Thomas, of Est Pekham, yeoman 1
5340020 2457087 2457087 defendant Mille Robert laborer 587667 587667 Mille, Robert, of Est Pekham, laborer 0
5366880 2465296 2465296 defendant Esthawe Robert butcher 587667 587667 Esthawe, Robert, of East Pekham, butcher 0
5368974 2465887 2465887 defendant Langle Robert yeoman 587667 587667 Langle, Robert, of East Pekham, yeoman 0
5368975 2465887 2465887 defendant Monke Thomas yeoman 587667 587667 Monke, Thomas, of East Pekham, yeoman 1
5378496 2468859 2468859 defendant Esthawe Robert butcher 587667 587667 Esthawe, Robert, of East Pekham, butcher 1
5397688 2474407 2474407 defendant Godyng William husbandman 587667 587667 Godyng, William, of East Pekham, husbandman 0

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