names

83 rows where place_id = 607366

✎ 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
3668928 1916213 1916213 defendant Pancost John yeoman 607366 607366 Pancost, John, of Rychemond, yeoman 1
3723673 1933680 1933680 plaintiff Perkyns Henry gent 607366 607366 Perkyns, Henry, of Rychemond, gent 0
3786781 1953662 1953662 defendant Dettcott John husbandman 607366 607366 Dettcott, John, of Rychemond, husbandman 3
3801875 1958484 1958484 defendant Trystram William chaplain 607366 607366 Trystram, William, of Rychemond, chaplain 1
3833053 1968261 1968261 defendant Pancost alias Spancoste Thomas yeoman 607366 607366 Pancost alias Spancoste, Thomas, of Rychemond, yeoman 0
3833055 1968262 1968262 defendant Pancost Thomas yeoman 607366 607366 Pancost, Thomas, of Rychemond, yeoman 0
3984153 2019098 2019098 defendant Clarke Thomas gent 607366 607366 Clarke, Thomas, of Rychemond, gent 0
4018860 2031475 2031475 defendant Burros Alice   607366 607366 Burros, Alice, of Rychemond, widow of William Burros, of Richmond 2
4489135 2197318 2197318 plaintiff Taverner Nicholas   607366 607366 Taverner, Nicholas, of Rychemond 0
4489139 2197319 2197319 plaintiff Taverner Nicholas   607366 607366 Taverner, Nicholas, of Rychemond 0
4500202 2200696 2200696 defendant Marschall John   607366 607366 Marschall, John, of Rychemond 0
4500203 2200696 2200696 defendant Henryson John   607366 607366 Henryson, John, of Rychemond 1
4500208 2200696 2200696 defendant Lytster John   607366 607366 Lytster, John, of Rychemond 6
4501571 2201094 2201094 defendant Taverner Nicholas   607366 607366 Taverner, Nicholas, of Rychemond 0
4508137 2203020 2203020 defendant Turnour John   607366 607366 Turnour, John, of Rychemond, son of John 1
4578588 2224791 2224791 defendant Henryson John   607366 607366 Henryson, John, of Rychemond 4
4619975 2237228 2237228 defendant Werkope John miller 607366 607366 Werkope, John, of Rychemond, miller 0
4636690 2242296 2242296 defendant Lynton Richard de   607366 607366 Lynton, Richard de, of Rychemond 2
4649320 2245850 2245850 defendant Myles John walker 607366 607366 Myles, John, of Rychemond, walker 5
4665919 2250818 2250818 defendant Pety Thomas, senior dyer 607366 607366 Pety, Thomas, senior, of Rychemond, dyer 0
4665920 2250818 2250818 defendant Pety Thomas, junior chapman 607366 607366 Pety, Thomas, junior, of Rychemond, chapman 1
4673019 2257206 2257206 defendant Kirkeby Robert hosier 607366 607366 Kirkeby, Robert, of Rychemond, hosier 0
4689525 2262281 2262281 defendant Huddeswell William gent 607366 607366 Huddeswell, William, of Rychemond, gent 0
4717714 2270874 2270874 defendant Walker Robert husbandman 607366 607366 Walker, Robert, of Rychemond, husbandman 0
4720273 2271682 2271682 defendant parles John shoemaker 607366 607366 parles, John, of Rychemond, shoemaker 2
4725085 2273142 2273142 defendant Fraunk William gent 607366 607366 Fraunk, William, of Rychemond, gent 0
4740857 2277839 2277839 defendant Penne William mercer 607366 607366 Penne, William, of Rychemond, mercer 0
4741266 2277943 2277943 defendant Hudson William milner 607366 607366 Hudson, William, of Rychemond, milner 0
4744477 2278907 2278907 defendant Smale Robert chaloner or blanket maker 607366 607366 Smale, Robert, of Rychemond, chaloner or blanket maker 0
4747832 2279873 2279873 plaintiff leScrop Stephen (legal representative) 607366 607366 leScrop, Stephen, of Rychemond, clerk & archdeason, executors of 0
4752699 2281249 2281249 defendant Swyneshede Adam butcher 607366 607366 Swyneshede, Adam, of Rychemond, butcher 0
4752700 2281249 2281249 defendant Flesshewer Roger butcher 607366 607366 Flesshewer, Roger, of Rychemond, butcher 1
4754502 2281788 2281788 defendant Huton Robert barber 607366 607366 Huton, Robert, of Rychemond, barber 2
4766986 2285663 2285663 defendant Myles William walker 607366 607366 Myles, William, of Rychemond, walker 0
4770114 2286621 2286621 defendant Peny William mercer 607366 607366 Peny, William, of Rychemond, mercer 2
4776670 2288694 2288694 defendant Smyth John smith 607366 607366 Smyth, John, of Rychemond, smith 4
4787862 2292269 2292269 defendant Paryls John cordwainer 607366 607366 Paryls, John, of Rychemond, cordwainer 0
4792474 2293734 2293734 defendant Bennok John chapman 607366 607366 Bennok, John, of Rychemond, chapman 0
4792475 2293734 2293734 defendant Bennok Nicholas   607366 607366 Bennok, Nicholas, of Rychemond, yeoman, son of John 1
4793080 2293929 2293929 defendant de Lutton John yeoman 607366 607366 de Lutton, John, of Rychemond, yeoman 0
4795876 2294861 2294861 defendant Tylcok John husbandman 607366 607366 Tylcok, John, of Rychemond, husbandman 0
4814609 2300679 2300679 defendant Fox Thomas shoemaker 607366 607366 Fox, Thomas, of Rychemond, shoemaker 0
4835647 2307140 2307140 defendant Stanell or Stavell John cardmaker 607366 607366 Stanell or Stavell, John, of Rychemond, cardmaker 0
4855780 2313181 2313181 defendant Mallom Thomas smith 607366 607366 Mallom, Thomas, of Rychemond, smith 3
4864352 2315830 2315830 defendant Frank William gent 607366 607366 Frank, William, of Rychemond, gent 0
4864353 2315830 2315830 defendant Clargenet John husbandman 607366 607366 Clargenet, John, of Rychemond, husbandman 1
4864354 2315830 2315830 defendant Lucas Robert draper 607366 607366 together with Lucas, Robert, of Rychemond, draper 2
4864355 2315830 2315830 defendant Moreiour John   607366 607366 Moreiour, John, of Rychemond, parish clerk 3
4864356 2315830 2315830 defendant Nesse John weaver 607366 607366 Nesse, John, of Rychemond, weaver 4
4864357 2315830 2315830 defendant Cardmaker John   607366 607366 Cardmaker, John, of Rychemond, card maker 5
4864358 2315830 2315830 defendant Burgh Thomas cordwainer 607366 607366 Burgh, Thomas, of Rychemond, cordwainer 6
4877214 2319830 2319830 defendant Clergynet Nicholas gent 607366 607366 Clergynet, Nicholas, of Rychemond, or of Ellerton, gent 3
4877253 2319840 2319840 defendant Foxholes Thomas gent 607366 607366 Foxholes, Thomas, of Rychemond, gent 0
4877255 2319841 2319841 defendant Foxholes Thomas gent 607366 607366 Foxholes, Thomas, of Rychemond, gent 0
4883056 2321623 2321623 defendant Spycer Leticia   607366 607366 Spycer, Leticia, of Rychemond, widow of Spycer, John 0
4883057 2321623 2321623 defendant Colbron Thomas spicer 607366 607366 Colbron, Thomas, of Rychemond, spicer 1
4892605 2324415 2324415 defendant Colburn Thomas yeoman 607366 607366 Colburn, Thomas, of Rychemond, yeoman 0
4895827 2325369 2325369 defendant Bannok John yeoman 607366 607366 Bannok, John, of Rychemond, yeoman 2
4926030 2334570 2334570 defendant Blome William chapman 607366 607366 Blome, William, of Rychemond, chapman 4
4926041 2334572 2334572 defendant Blome William chapman 607366 607366 Blome, William, of Rychemond, chapman 4
4978941 2350661 2350661 defendant Frank William gent 607366 607366 Frank, William, of Rychemond, gent 0
4980492 2351104 2351104 defendant Clarionet Thomas yeoman 607366 607366 Clarionet, Thomas, of Rychemond, yeoman 0
5019770 2362661 2362661 defendant Blome William yeoman 607366 607366 Blome, William, of Rychemond, yeoman 1
5097426 2385678 2385678 defendant Gairestange Richard gent 607366 607366 Gairestange, Richard, of Rychemond, gent 0
5097429 2385679 2385679 defendant Gairestange Richard gent 607366 607366 Gairestange, Richard, of Rychemond, gent 0
5100059 2386455 2386455 defendant Cok Thomas butcher 607366 607366 Cok, Thomas, of Rychemond, butcher 1
5100064 2386456 2386456 defendant Cok Thomas butcher 607366 607366 Cok, Thomas, of Rychemond, butcher 1
5115685 2391016 2391016 defendant Wilson John chapman 607366 607366 Wilson, John, of Rychemond, chapman 2
5154690 2402526 2402526 defendant Johnson William weaver 607366 607366 Johnson, William, of Rychemond, weaver 0
5189768 2412753 2412753 defendant Dryffeld Thomas husbandman 607366 607366 Dryffeld, Thomas, of Rychemond, husbandman 0
5278589 2438849 2438849 defendant Appylgarth Thomas yeoman 607366 607366 Appylgarth, Thomas, of Rychemond, yeoman 1
5293787 2443147 2443147 defendant Leche John tailor 607366 607366 Leche, John, of Rychemond, tailor, son of Leche, Thomas, tailor 0
5347332 2459329 2459329 defendant Geldard John yeoman 607366 607366 Geldard, John, of Rychemond, yeoman 2
5347333 2459329 2459329 defendant Ile Henry yeoman 607366 607366 Ile, Henry, of Rychemond, yeoman 3
5492915 2502790 2502790 defendant Tylcok John husbandman 607366 607366 Tylcok, John, of Rychemond, husbandman 1
5492916 2502790 2502790 defendant Blake William husbandman 607366 607366 Blake, William, of Rychemond, husbandman 2
5516625 2510027 2510027 defendant Cornens or Corvens alias Pyper Thomas   607366 607366 Cornens or Corvens alias Pyper, Thomas, of Rychemond, card maker 0
5526226 2512780 2512780 defendant Walker Ralph yeoman 607366 607366 Walker, Ralph, of Rychemond, yeoman 0
5526227 2512780 2512780 defendant Kelett Walter yeoman 607366 607366 Kelett, Walter, of Rychemond, yeoman 1
5526228 2512780 2512780 defendant Sympson Thomas yeoman 607366 607366 Sympson, Thomas, of Rychemond, yeoman 2
5526229 2512780 2512780 defendant Levenwod Robert yeoman 607366 607366 Levenwod, Robert, of Rychemond, yeoman 3
5571007 2526084 2526084 defendant Wherton Michael gent 607366 607366 Wherton, Michael, of Rychemond, gent 1
5582852 2529704 2529704 defendant Bower William yeoman 607366 607366 Bower, William, of Rychemond, yeoman 0

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