names

134 rows where place_id = 587715

✎ 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
3592204 1865178 1865178 defendant Blome Richard laborer 587715 587715 Blome, Richard, of Cokefeld, laborer 2
3602848 1868561 1868561 defendant Femott Peter yeoman 587715 587715 Femott, Peter, of Cokefeld, yeoman 1
3617954 1873240 1873240 defendant Chenerey or Cheverey John yeoman 587715 587715 Chenerey or Cheverey, John, of Cokefeld, yeoman 1
3617955 1873240 1873240 defendant Hore William smith 587715 587715 Hore, William, of Cokefeld, smith 2
3617959 1873241 1873241 defendant Hore William smith 587715 587715 Hore, William, of Cokefeld, smith 1
3630573 1904391 1904391 defendant Kynge Thomas   587715 587715 Kynge, Thomas, of Cokefeld, wheelwright 0
3633492 1905289 1905289 defendant Streter Thomas husbandman 587715 587715 Streter, Thomas, of Cokefeld, husbandman 0
3633493 1905289 1905289 defendant Punt John tailor 587715 587715 Punt, John, of Cokefeld, tailor 1
3674093 1917937 1917937 defendant Borell Ralph gent 587715 587715 Borell, Ralph, of Cokefeld, gent 0
3738049 1938116 1938116 defendant Rykward Thomas husbandman 587715 587715 Rykward, Thomas, of Cokefeld, husbandman 2
3742514 1939531 1939531 defendant Fynall Thomas husbandman 587715 587715 Fynall, Thomas, of Cokefeld, husbandman 0
3742985 1939654 1939654 defendant Rikward Thomas husbandman 587715 587715 Rikward, Thomas, of Cokefeld, husbandman 0
3742988 1939654 1939654 defendant Vynall John wheeler 587715 587715 Vynall, John, of Cokefeld, wheeler 3
3749759 1941835 1941835 defendant Mathewe Richard butcher 587715 587715 Mathewe, Richard, of Cokefeld, butcher 0
3752212 1942617 1942617 defendant Burrell Ralph yeoman 587715 587715 Burrell, Ralph, of Cokefeld, yeoman 0
3759531 1944974 1944974 defendant Beche John tailor 587715 587715 Beche, John, of Cokefeld, tailor 1
3763534 1946230 1946230 defendant Browne William yeoman 587715 587715 Browne, William, of Cokefeld, yeoman 1
3763916 1946357 1946357 defendant Beche John tailor 587715 587715 Beche, John, of Cokefeld, tailor 1
3768367 1947749 1947749 defendant Vynall John husbandman 587715 587715 Vynall, John, of Cokefeld, husbandman 0
3773956 1949570 1949570 defendant Parson alias Peryar Thomas husbandman 587715 587715 Parson alias Peryar, Thomas, of Cokefeld, husbandman 2
3788579 1954227 1954227 defendant Fyeld Thomas husbandman 587715 587715 Fyeld, Thomas, of Cokefeld, husbandman 0
3822871 1965060 1965060 defendant Rycbe Thomas husbandman 587715 587715 Rycbe, Thomas, of Cokefeld, husbandman 2
3838991 1970123 1970123 defendant Joner William husbandman 587715 587715 Joner, William, of Cokefeld, husbandman 0
3841758 1971009 1971009 defendant Mathewe Richard butcher 587715 587715 Mathewe, Richard, of Cokefeld, butcher 0
3848546 1973127 1973127 defendant Brown William carpenter 587715 587715 Brown, William, of Cokefeld, carpenter 1
3850878 1973868 1973868 defendant Mylys Thomas husbandman 587715 587715 Mylys, Thomas, of Cokefeld, husbandman 0
3854660 1975102 1975102 defendant Vynall John wheeler 587715 587715 Vynall, John, of Cokefeld, wheeler 1
3858360 1976274 1976274 defendant Mathewe Richard butcher 587715 587715 Mathewe, Richard, of Cokefeld, butcher 0
3885881 1985535 1985535 defendant Rykward Thomas husbandman 587715 587715 Rykward, Thomas, of Cokefeld, husbandman 0
3885882 1985535 1985535 defendant Standon Gilbert husbandman 587715 587715 Standon, Gilbert, of Cokefeld, husbandman 1
4201885 2096202 2096202 defendant Gatsyer or Catsier George yeoman 587715 587715 Gatsyer or Catsier, George, of Cokefeld, yeoman 1
4426288 2173031 2173031 plaintiff Norwich John de   587715 587715 Norwich, John de, of Cokefeld 0
4444323 2183213 2183213 plaintiff Codeman John   587715 587715 Codeman, John, of Cokefeld 0
4452071 2185635 2185635 plaintiff Hyte Roger   587715 587715 Hyte, Roger, of Cokefeld 0
4452920 2185920 2185920 defendant Cok Robert   587715 587715 Cok, Robert, of Cokefeld, vicar 1
4471315 2191694 2191694 defendant Bret John   587715 587715 Bret, John, of Cokefeld 0
4478072 2193813 2193813 plaintiff Haselyng William   587715 587715 Haselyng, William, of Cokefeld 0
4492648 2198402 2198402 defendant Chynnory John weaver 587715 587715 Chynnory, John, of Cokefeld, weaver 0
4506786 2202594 2202594 defendant Bret John   587715 587715 Bret, John, of Cokefeld 3
4506795 2202595 2202595 defendant Bret John   587715 587715 Bret, John, of Cokefeld 3
4533180 2210644 2210644 defendant Brette John   587715 587715 Brette, John, of Cokefeld 0
4546172 2214748 2214748 defendant Boure John   587715 587715 Boure, John, of Cokefeld 4
4547395 2215114 2215114 defendant Maykyn John   587715 587715 Maykyn, John, of Cokefeld 2
4628493 2239831 2239831 defendant Auncell Roger   587715 587715 Auncell, Roger, of Cokefeld 2
4644487 2244473 2244473 defendant Pertrych Richard   587715 587715 Pertrych, Richard, of Cokefeld 0
4680812 2259620 2259620 plaintiff Lynde Richard clerk & vicar 587715 587715 Lynde, Richard, of Cokefeld, clerk & vicar 0
4680813 2259620 2259620 defendant Worteleforde Thomas shoemaker 587715 587715 Worteleforde, Thomas, of Cokefeld, shoemaker 0
4703002 2266321 2266321 defendant Cok William   587715 587715 Cok, William, of Cokefeld, inland fish seller 0
4706032 2267259 2267259 defendant Chaloner John butcher 587715 587715 Chaloner, John, of Cokefeld, butcher 0
4708173 2267933 2267933 defendant Blakere Thomas husbandman 587715 587715 Blakere, Thomas, of Cokefeld, husbandman 4
4739064 2277309 2277309 defendant Barbour William barber 587715 587715 Barbour, William, of Cokefeld, barber 2
4745496 2279192 2279192 defendant Angeleys William tailor 587715 587715 Angeleys, William, of Cokefeld, tailor 0
4766960 2285654 2285654 defendant Gret Edmund husbandman 587715 587715 Gret, Edmund, of Cokefeld, husbandman 1
4785689 2291555 2291555 defendant Sabbe Thomas yeoman 587715 587715 Sabbe, Thomas, of Cokefeld, yeoman 0
4791368 2293394 2293394 defendant Bret Edmund yeoman 587715 587715 Bret, Edmund, of Cokefeld, yeoman 1
4831928 2306013 2306013 defendant Cranewys Thomas yeoman 587715 587715 Cranewys, Thomas, of Cokefeld, yeoman 1
4848842 2311100 2311100 defendant Fest Stephen butcher 587715 587715 Fest, Stephen, of Cokefeld, butcher 2
4852021 2312064 2312064 defendant atte Herne William barber 587715 587715 atte Herne, William, of Cokefeld, barber 0
4859209 2314255 2314255 defendant Hamstede Thomas cordwainer 587715 587715 Hamstede, Thomas, of Cokefeld, cordwainer 0
4859938 2314477 2314477 defendant Galyon William butcher 587715 587715 Galyon, William, of Cokefeld, butcher 1
4873953 2318791 2318791 defendant Bougeyn or Bongeyn Henry husbandman 587715 587715 Bougeyn or Bongeyn, Henry, of Cokefeld, husbandman 0
4906416 2328594 2328594 defendant Hill Henry, junior husbandman 587715 587715 Hill, Henry, junior, of Cokefeld, husbandman 0
4906417 2328594 2328594 defendant Hill John husbandman 587715 587715 Hill, John, of Cokefeld, husbandman 1
4912312 2330351 2330351 plaintiff Michell John   587715 587715 Michell, John, of Cokefeld 1
4919708 2332670 2332670 defendant Beton Stephen butcher 587715 587715 Beton, Stephen, of Cokefeld, butcher 0
4919709 2332670 2332670 defendant Crowe Thomas miller 587715 587715 Crowe, Thomas, of Cokefeld, miller 1
4939945 2338880 2338880 defendant Edward Edmund husbandman 587715 587715 Edward, Edmund, of Cokefeld, husbandman 0
4939946 2338880 2338880 defendant Bally Robert husbandman 587715 587715 Bally, Robert, of Cokefeld, husbandman 1
4939947 2338880 2338880 defendant Parker Thomas husbandman 587715 587715 Parker, Thomas, of Cokefeld, husbandman 2
4939948 2338880 2338880 defendant Meller Geoffrey miller 587715 587715 Meller, Geoffrey, of Cokefeld, miller 3
4939949 2338880 2338880 defendant Bocher Stephen yeoman 587715 587715 Bocher, Stephen, of Cokefeld, yeoman 4
4956340 2343860 2343860 defendant Edward Edmund husbandman 587715 587715 Edward, Edmund, of Cokefeld, husbandman 0
4956342 2343860 2343860 defendant Gerard John tailor 587715 587715 Gerard, John, of Cokefeld, tailor 2
4963105 2345872 2345872 defendant Broun Thomas husbandman 587715 587715 Broun, Thomas, of Cokefeld, husbandman 2
4968937 2347673 2347673 defendant Blakman Thomas laborer 587715 587715 Blakman, Thomas, of Cokefeld, laborer 1
4992888 2354753 2354753 defendant Lenthale Edmund esq 587715 587715 Lenthale, Edmund, of Cokefeld, esq 0
5005716 2358566 2358566 defendant (illegible) Henry yeoman 587715 587715 _, Henry, of Cokefeld, yeoman 3
5005717 2358566 2358566 defendant Hill Stephen laborer 587715 587715 Hill, Stephen, of Cokefeld, laborer 4
5009683 2359712 2359712 defendant Chynnore John husbandman 587715 587715 Chynnore, John, of Cokefeld, husbandman 0
5049649 2371518 2371518 defendant Godeman Richard husbandman 587715 587715 Godeman, Richard, of Cokefeld, husbandman 3
5060700 2374780 2374780 plaintiff Gairgrave William esq 587715 587715 Gairgrave, William, of Cokefeld, esq 0
5080321 2380606 2380606 defendant Assy William husbandman 587715 587715 Assy, William, of Cokefeld, husbandman 0
5105956 2388180 2388180 defendant Arteys Richard tailor 587715 587715 Arteys, Richard, of Cokefeld, tailor 0
5107283 2388557 2388557 defendant Boteler Thomas yeoman 587715 587715 Boteler, Thomas, of Cokefeld, yeoman 0
5113305 2390284 2390284 defendant Edward Edmund husbandman 587715 587715 Edward, Edmund, of Cokefeld, husbandman 3
5126236 2394157 2394157 defendant Scarlet William sawer 587715 587715 Scarlet, William, of Cokefeld, sawer 0
5126237 2394157 2394157 defendant Scarlet Thomas sawer 587715 587715 Scarlet, Thomas, of Cokefeld, sawer 1
5130085 2395286 2395286 defendant Sawier William sawyer 587715 587715 Sawier, William, of Cokefeld, sawyer 0
5137031 2397346 2397346 defendant Forde Thomas yeoman 587715 587715 Forde, Thomas, of Cokefeld, yeoman 1
5143756 2399306 2399306 plaintiff atte Homwode Gilbert   587715 587715 atte Homwode, Gilbert, of Cokefeld 0
5173469 2407942 2407942 defendant Forde Thomas yeoman 587715 587715 Forde, Thomas, of Cokefeld, yeoman 1
5173475 2407943 2407943 defendant Forde Thomas yeoman 587715 587715 Forde, Thomas, of Cokefeld, yeoman 1
5174896 2408354 2408354 defendant Cacche Richard yeoman 587715 587715 Cacche, Richard, of Cokefeld, yeoman 1
5195792 2414517 2414517 defendant Cacche Richard yeoman 587715 587715 Cacche, Richard, of Cokefeld, yeoman 0
5209396 2418484 2418484 defendant Cacche Richard yeoman 587715 587715 Cacche, Richard, of Cokefeld, yeoman 0
5226090 2423297 2423297 defendant Elys John husbandman 587715 587715 Elys, John, of Cokefeld, husbandman 1
5238848 2426952 2426952 defendant Forde Robert clerk 587715 587715 Forde, Robert, of Cokefeld, clerk 0
5238849 2426952 2426952 defendant Forde Thomas yeoman 587715 587715 Forde, Thomas, of Cokefeld, yeoman 1
5238850 2426952 2426952 defendant Forde William yeoman 587715 587715 Forde, William, of Cokefeld, yeoman 2
5240365 2427396 2427396 defendant Pekke John carpenter 587715 587715 Pekke, John, of Cokefeld, carpenter 1

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