names

99 rows where place_id = 593660

✎ 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
3612821 1871658 1871658 defendant Flete Hugh baker 593660 593660 Flete, Hugh, of Huntyngdon, Hunts, baker 3
3616487 1872793 1872793 defendant Alward John mercer 593660 593660 Alward, John, of Huntyngdon, Hunts, mercer 0
3619885 1873794 1873794 defendant Bakton Peter yeoman 593660 593660 Bakton, Peter, of Huntyngdon, Hunts, yeoman 0
3646534 1909317 1909317 defendant Deveas Thomas miller 593660 593660 Deveas, Thomas, of Huntyngdon, Hunts, miller 0
3674514 1918080 1918080 defendant Webbe William mercer 593660 593660 Webbe, William, of Huntyngdon, Hunts, mercer 0
3691986 1923658 1923658 defendant Taillour alias Basse Thomas mercer or vintner 593660 593660 Taillour alias Basse, Thomas, of Huntyngdon, Hunts, mercer or vintner 0
3720377 1932652 1932652 defendant Basse Thomas mercer 593660 593660 Basse, Thomas, of Huntyngdon, Hunts, mercer 2
3835043 1968901 1968901 defendant Barnes William shoemaker 593660 593660 Barnes, William, of Huntyngdon, Hunts, shoemaker 0
3884189 1984978 1984978 defendant Myller Bartholomew yeoman 593660 593660 Myller, Bartholomew, of Huntyngdon, Hunts, yeoman 0
3900843 1990510 1990510 defendant Hall Thomas gent 593660 593660 Hall, Thomas, of Huntyngdon, Hunts, gent 0
3919605 1996889 1996889 defendant Drewry Lun mercer 593660 593660 Drewry, Lun, of Huntyngdon, Hunts, mercer 0
3953103 2008152 2008152 defendant Symkot or Symcotes William yeoman 593660 593660 Symkot or Symcotes, William, of Huntyngdon, Hunts, yeoman 0
3962071 2011314 2011314 defendant Smyth Gilbert chapman 593660 593660 Smyth, Gilbert, of Huntyngdon, Hunts, chapman 1
3975962 2016156 2016156 defendant Dyxson Anthony baker 593660 593660 Dyxson, Anthony, of Huntyngdon, Hunts, baker 0
3998906 2024369 2024369 plaintiff Foster Richard yeoman 593660 593660 Foster, Richard, of Huntyngdon, Hunts, yeoman 0
4660841 2249217 2249217 defendant Gregory John chapman 593660 593660 Gregory, John, of Huntyngdon, Hunts, chapman 0
4663181 2249950 2249950 defendant Bocher John husbandman 593660 593660 Bocher, John, of Huntyngdon, Hunts, husbandman 0
4668848 2255961 2255961 defendant Broun John butcher 593660 593660 Broun, John, of Huntyngdon, Hunts, butcher 0
4685340 2261010 2261010 defendant Gregory Simon (legal representative) 593660 593660 Gregory, Simon, of Huntyngdon, Hunts, executrix of 0
4703859 2266586 2266586 defendant Chapman John   593660 593660 Chapman, John, of Huntyngdon, Hunts, single man 1
4715168 2270072 2270072 defendant Chaumpayn John   593660 593660 Chaumpayn, John, of Huntyngdon, Hunts, iron worker 3
4732898 2275467 2275467 defendant Dounham Walter skinner 593660 593660 Dounham, Walter, of Huntyngdon, Hunts, skinner 1
4739442 2277420 2277420 defendant Derby William dyer 593660 593660 Derby, William, of Huntyngdon, Hunts, dyer 2
4740845 2277837 2277837 defendant Gregory John spicer 593660 593660 Gregory, John, of Huntyngdon, Hunts, spicer 1
4741194 2277924 2277924 defendant Gregory John spicer 593660 593660 Gregory, John, of Huntyngdon, Hunts, spicer 0
4753186 2281381 2281381 defendant Dounham Walter skinner 593660 593660 Dounham, Walter, of Huntyngdon, Hunts, skinner 2
4787000 2292001 2292001 defendant Baillyf of Gaynesmaner Nicholas yeoman 593660 593660 Baillyf of Gaynesmaner, Nicholas, of Huntyngdon, Hunts, yeoman 1
4801476 2296642 2296642 defendant Pekke Robert gent 593660 593660 Pekke, Robert, of Huntyngdon, Hunts, gent 0
4801478 2296643 2296643 defendant Pekke Robert gent 593660 593660 Pekke, Robert, of Huntyngdon, Hunts, gent 0
4802110 2296851 2296851 defendant Staunton John husbandman 593660 593660 Staunton, John, of Huntyngdon, Hunts, husbandman 1
4811734 2299779 2299779 defendant Pekke Robert gent 593660 593660 Pekke, Robert, of Huntyngdon, Hunts, gent 0
4813897 2300457 2300457 defendant Cottes William yeoman 593660 593660 Cottes, William, of Huntyngdon, Hunts, yeoman 0
4824161 2303631 2303631 defendant Ostyler John ostler 593660 593660 Ostyler, John, of Huntyngdon, Hunts, ostler 2
4827547 2304664 2304664 defendant Everdon William embroiderer 593660 593660 Everdon, William, of Huntyngdon, Hunts, embroiderer 0
4840453 2308552 2308552 defendant Pekke John gent 593660 593660 Pekke, John, of Huntyngdon, Hunts, gent 0
4841156 2308770 2308770 defendant Carleton Michael skinner 593660 593660 Carleton, Michael, of Huntyngdon, Hunts, skinner 0
4860190 2314547 2314547 defendant Everton alias Coventre William chapman 593660 593660 Everton alias Coventre, William, of Huntyngdon, Hunts, chapman 0
4908812 2329306 2329306 defendant Palmer John butcher 593660 593660 Palmer, John, of Huntyngdon, Hunts, butcher 0
4919201 2332516 2332516 defendant Watson John sadler 593660 593660 Watson, John, of Huntyngdon, Hunts, sadler 1
4937183 2337997 2337997 defendant Toweslond John chapman 593660 593660 Toweslond, John, of Huntyngdon, Hunts, chapman 0
4943525 2339943 2339943 defendant Baker John ostler 593660 593660 Baker, John, of Huntyngdon, Hunts, ostler 0
4955871 2343723 2343723 defendant Skynner Robert yeoman 593660 593660 Skynner, Robert, of Huntyngdon, Hunts, yeoman 0
4955874 2343724 2343724 defendant Skynner Robert yeoman 593660 593660 Skynner, Robert, of Huntyngdon, Hunts, yeoman 0
4981448 2351367 2351367 defendant Cut Thomas butcher 593660 593660 Cut, Thomas, of Huntyngdon, Hunts, butcher 0
4983003 2351823 2351823 defendant Palmyter William smith 593660 593660 Palmyter, William, of Huntyngdon, Hunts, smith 7
5025440 2364338 2364338 defendant Vessy John gent 593660 593660 Vessy, John, of Huntyngdon, Hunts, gent 1
5052902 2372457 2372457 defendant Asshebury John yeoman 593660 593660 Asshebury, John, of Huntyngdon, Hunts, yeoman 0
5075458 2379155 2379155 defendant Odell Robert butcher 593660 593660 Odell, Robert, of Huntyngdon, Hunts, butcher 3
5083013 2381425 2381425 defendant Wode John saddler 593660 593660 Wode, John, of Huntyngdon, Hunts, saddler 2
5083017 2381426 2381426 defendant Wode John saddler 593660 593660 Wode, John, of Huntyngdon, Hunts, saddler 1
5085598 2382184 2382184 defendant Teweslond John spicer 593660 593660 Teweslond, John, of Huntyngdon, Hunts, spicer 0
5085600 2382185 2382185 defendant Toweslond John spicer 593660 593660 Toweslond, John, of Huntyngdon, Hunts, spicer 0
5096894 2385521 2385521 defendant Roke Richard chapman 593660 593660 Roke, Richard, of Huntyngdon, Hunts, chapman 2
5108131 2388816 2388816 defendant Dalton Richard gent 593660 593660 (Dalton, Richard, of Huntyngdon, Hunts, gent 1
5108137 2388817 2388817 defendant Dalton Richard gent 593660 593660 (Dalton, Richard, of Huntyngdon, Hunts, gent 1
5111766 2389834 2389834 defendant Congerton Robert chapman 593660 593660 Congerton, Robert, of Huntyngdon, Hunts, chapman 2
5117850 2391647 2391647 defendant Asshefeld John gent 593660 593660 Asshefeld, John, of Huntyngdon, Hunts, gent 4
5117856 2391648 2391648 defendant Asshefeld John gent 593660 593660 Asshefeld, John, of Huntyngdon, Hunts, gent 4
5145564 2399847 2399847 defendant Cholny William tailor 593660 593660 Cholny, William, of Huntyngdon, Hunts, tailor 2
5180613 2410071 2410071 defendant Cholney William tailor 593660 593660 Cholney, William, of Huntyngdon, Hunts, tailor 2
5212563 2419420 2419420 defendant Polyer John yeoman 593660 593660 Polyer, John, of Huntyngdon, Hunts, yeoman 4
5213994 2419824 2419824 defendant Colny William tailor 593660 593660 Colny, William, of Huntyngdon, Hunts, tailor 2
5214693 2420025 2420025 defendant Ropsely John yeoman 593660 593660 Ropsely, John, of Huntyngdon, Hunts, yeoman 0
5214695 2420026 2420026 defendant Ropsely John yeoman 593660 593660 Ropsely, John, of Huntyngdon, Hunts, yeoman 0
5230524 2424543 2424543 defendant Polyerde John yeoman 593660 593660 Polyerde, John, of Huntyngdon, Hunts, yeoman 4
5267892 2435721 2435721 defendant Morton Robert clerk 593660 593660 Morton, Robert, of Huntyngdon, Hunts, clerk 0
5277158 2438406 2438406 defendant Morton Robert clerk 593660 593660 Morton, Robert, of Huntyngdon, Hunts, clerk 0
5277164 2438407 2438407 defendant Morton Robert clerk 593660 593660 Morton, Robert, of Huntyngdon, Hunts, clerk 0
5277716 2438569 2438569 defendant Elsham Joan widow 593660 593660 Elsham, Joan, of Huntyngdon, Hunts, widow 0
5291903 2442638 2442638 defendant Waryn Edmund gent 593660 593660 Waryn, Edmund, of Huntyngdon, Hunts, gent 0
5315035 2449549 2449549 defendant Sherde Alice widow 593660 593660 Sherde, Alice, of Huntyngdon, Hunts, widow 0
5315038 2449550 2449550 defendant Sherde Alice widow 593660 593660 Sherde, Alice, of Huntyngdon, Hunts, widow 0
5316580 2450044 2450044 defendant Strete John ostler 593660 593660 Strete, John, of Huntyngdon, Hunts, ostler 2
5316586 2450045 2450045 defendant Strete John ostler 593660 593660 Strete, John, of Huntyngdon, Hunts, ostler 4
5322531 2451816 2451816 defendant Edward John baker 593660 593660 Edward, John, of Huntyngdon, Hunts, baker 0
5342329 2457798 2457798 defendant Salesbury John gent 593660 593660 Salesbury, John, of Huntyngdon, Hunts, gent 0
5342331 2457799 2457799 defendant Salesbury John gent 593660 593660 Salesbury, John, of Huntyngdon, Hunts, gent 0
5381873 2469871 2469871 defendant Chyksane Richard gent 593660 593660 Chyksane, Richard, of Huntyngdon, Hunts, gent 0
5390006 2472203 2472203 defendant Chyksand Richard gent 593660 593660 Chyksand, Richard, of Huntyngdon, Hunts, gent 0
5412439 2478667 2478667 defendant Wodewarde John baker 593660 593660 Wodewarde, John, of Huntyngdon, Hunts, baker 0
5416828 2479951 2479951 defendant Frelove Thomas yeoman 593660 593660 Frelove, Thomas, of Huntyngdon, Hunts, yeoman 1
5419895 2480865 2480865 defendant Smyth William tailor 593660 593660 Smyth, William, of Huntyngdon, Hunts, tailor 4
5435558 2485573 2485573 defendant Motte Richard yeoman 593660 593660 Motte, Richard, of Huntyngdon, Hunts, yeoman 2
5439665 2486805 2486805 defendant Gough John innholder 593660 593660 Gough, John, of Huntyngdon, Hunts, innholder 2
5461572 2493400 2493400 defendant Strete John yeoman 593660 593660 Strete, John, of Huntyngdon, Hunts, yeoman 1
5462712 2493755 2493755 defendant Motte Richard yeoman 593660 593660 Motte, Richard, of Huntyngdon, Hunts, yeoman 1
5488271 2501393 2501393 defendant Chiksam Richard innholder 593660 593660 Chiksam, Richard, of Huntyngdon, Hunts, innholder 1
5522359 2511814 2511814 defendant Swertman Robert innholder 593660 593660 Swertman, Robert, of Huntyngdon, Hunts, innholder 2
5537836 2516321 2516321 defendant Carver Thomas merchant 593660 593660 Carver, Thomas, of Huntyngdon, Hunts, merchant 4
5538831 2516633 2516633 defendant Godard William fishomnger 593660 593660 Godard, William, of Huntyngdon, Hunts, fishomnger 0
5538833 2516634 2516634 defendant Sweteman Robert yeoman 593660 593660 Sweteman, Robert, of Huntyngdon, Hunts, yeoman 0
5544045 2518246 2518246 defendant Aswell John husbandman 593660 593660 Aswell, John, of Huntyngdon, Hunts, husbandman 0
5557110 2522036 2522036 defendant Horwode John saddler 593660 593660 Horwode, John, of Huntyngdon, Hunts, saddler 5
5627052 2552430 2552430 defendant Bykeley John drover 593660 593660 Bykeley, John, of Huntyngdon, Hunts, drover 1
5627059 2552431 2552431 defendant Bykeley John drover 593660 593660 Bykeley, John, of Huntyngdon, Hunts, drover 3
5627889 2552691 2552691 defendant Chaumberleyn Roger husbandman 593660 593660 Chaumberleyn, Roger, of Huntyngdon, Hunts, husbandman 0
5627891 2552692 2552692 defendant Chaumberleyn Roger husbandman 593660 593660 Chaumberleyn, Roger, of Huntyngdon, Hunts, husbandman 0
5631112 2553737 2553737 defendant Chaumberleyn Roger hosteler 593660 593660 Chaumberleyn, Roger, of Huntyngdon, Hunts, hosteler 0
5633409 2554444 2554444 defendant Smyth Roger smith 593660 593660 Smyth, Roger, of Huntyngdon, Hunts, smith 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);