names

128 rows where place_id = 587633

✎ 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
3592011 1865115 1865115 defendant Alchyn Thomas tanner 587633 587633 Alchyn, Thomas, of Stony Stratford, Bucks, tanner 0
3592294 1865203 1865203 defendant Rokes Henry draper 587633 587633 Rokes, Henry, of Stony Stratford, Bucks, draper 0
3595624 1866258 1866258 defendant Marston Edward sherman 587633 587633 Marston, Edward, of Stony Stratford, Bucks, sherman 0
3696079 1924998 1924998 defendant Tweny Walter yeoman 587633 587633 Tweny, Walter, of Stony Stratford, Bucks, yeoman 5
3703673 1927429 1927429 defendant Trowton Richard chapman 587633 587633 Trowton, Richard, of Stony Stratford, Bucks, chapman 2
3712455 1930211 1930211 defendant Forest Thomas shoemaker 587633 587633 Forest, Thomas, of Stony Stratford, Bucks, shoemaker 0
3733482 1936715 1936715 defendant Alyff Peter butcher 587633 587633 Alyff, Peter, of Stony Stratford, Bucks, butcher 0
3749020 1941624 1941624 defendant Frankelyn William yeoman 587633 587633 Frankelyn, William, of Stony Stratford, Bucks, yeoman 2
3758112 1944522 1944522 defendant Bystock William innholder 587633 587633 Bystock, William, of Stony Stratford, Bucks, innholder 2
3776054 1950255 1950255 defendant Bystocke William innholder 587633 587633 Bystocke, William, of Stony Stratford, Bucks, innholder 0
3806950 1960079 1960079 defendant Langley Richard gent 587633 587633 Langley, Richard, of Stony Stratford, Bucks, gent 11
3870275 1980308 1980308 defendant Durant Thomas innholder 587633 587633 Durant, Thomas, of Stony Stratford, Bucks, innholder 0
3871874 1980830 1980830 defendant Rooke John innholder 587633 587633 Rooke, John, of Stony Stratford, Bucks, innholder 1
3924136 1998383 1998383 defendant Coddesdon William butcher 587633 587633 Coddesdon, William, of Stony Stratford, Bucks, butcher 0
3934010 2001673 2001673 defendant Almon Giles chapman 587633 587633 Almon, Giles, of Stony Stratford, Bucks, chapman 1
3934389 2001795 2001795 defendant Osbourn John chapman 587633 587633 Osbourn, John, of Stony Stratford, Bucks, chapman 0
3943871 2004966 2004966 defendant Brydgys Robert yeoman 587633 587633 Brydgys, Robert, of Stony Stratford, Bucks, yeoman 0
3973411 2015271 2015271 defendant Madock Edward yeoman 587633 587633 Madock, Edward, of Stony Stratford, Bucks, yeoman 0
3973414 2015272 2015272 defendant Madock Edward yeoman 587633 587633 Madock, Edward, of Stony Stratford, Bucks, yeoman 0
3999621 2024629 2024629 defendant Thorpe Adam chapman 587633 587633 Thorpe, Adam, of Stony Stratford, Bucks, chapman 1
4004269 2026307 2026307 defendant Vauxe George gent 587633 587633 Vauxe, George, of Stony Stratford, Bucks, gent 0
4006963 2027266 2027266 defendant Vause or Vanse George gent 587633 587633 Vause or Vanse, George, of Stony Stratford, Bucks, gent 0
4008415 2027776 2027776 defendant Vans or Vaus George yeoman 587633 587633 Vans or Vaus, George, of Stony Stratford, Bucks, yeoman 0
4041345 2039394 2039394 defendant Boughey Henry yeoman 587633 587633 Boughey, Henry, of Stony Stratford, Bucks, yeoman 0
4041347 2039395 2039395 defendant Boughey Henry yeoman 587633 587633 Boughey, Henry, of Stony Stratford, Bucks, yeoman 0
4048692 2041977 2041977 plaintiff Thorpe Adam mercer 587633 587633 Thorpe, Adam, of Stony Stratford, Bucks, mercer 1
4049871 2042385 2042385 plaintiff Wakefelde Roger yeoman 587633 587633 Wakefelde, Roger, of Stony Stratford, Bucks, yeoman 0
4057596 2045097 2045097 defendant Wakefyld Roger butcher 587633 587633 Wakefyld, Roger, of Stony Stratford, Bucks, butcher 0
4063192 2047133 2047133 defendant Trongton or Trougton Henry draper 587633 587633 Trongton or Trougton, Henry, of Stony Stratford, Bucks, draper 0
4094652 2058426 2058426 defendant Boughey Elizabeth widow 587633 587633 Boughey, Elizabeth, of Stony Stratford, Bucks, widow 0
4124000 2068883 2068883 defendant Bowghey Thomas merchant 587633 587633 Bowghey, Thomas, of Stony Stratford, Bucks, merchant 0
4150274 2078227 2078227 defendant Carne Thomas innholder 587633 587633 Carne, Thomas, of Stony Stratford, Bucks, innholder 0
4205672 2097534 2097534 defendant Addamson John yeoman 587633 587633 Addamson, John, of Stony Stratford, Bucks, yeoman 1
4212143 2099795 2099795 defendant Mylner Martha spinster 587633 587633 Mylner, Martha, of Stony Stratford, Bucks, spinster 1
4264941 2117910 2117910 defendant Haycocke Robert baker 587633 587633 Haycocke, Robert, of Stony Stratford, Bucks, baker 0
4268923 2119201 2119201 defendant Charles Tutcher yeoman 587633 587633 Charles, Tutcher, of Stony Stratford, Bucks, yeoman 5
4277122 2121932 2121932 defendant Cox Christopher weaver 587633 587633 Cox, Christopher, of Stony Stratford, Bucks, weaver 0
4281400 2123400 2123400 defendant Tylcocke Thomas ostler 587633 587633 Tylcocke, Thomas, of Stony Stratford, Bucks, ostler 0
4299914 2130062 2130062 defendant Charles Tutcher yeoman 587633 587633 Charles, Tutcher, of Stony Stratford, Bucks, yeoman 0
4300880 2130414 2130414 defendant Hartley Robert mercer 587633 587633 Hartley, Robert, of Stony Stratford, Bucks, mercer 0
4308110 2132982 2132982 defendant Royle or Royles Thomas innholder 587633 587633 Royle or Royles, Thomas, of Stony Stratford, Bucks, innholder 0
4312111 2134375 2134375 defendant Tylcocke Thomas hosteler 587633 587633 Tylcocke, Thomas, of Stony Stratford, Bucks, hosteler 2
4316597 2135923 2135923 defendant Hull Francis butcher 587633 587633 Hull, Francis, of Stony Stratford, Bucks, butcher 2
4327134 2139406 2139406 defendant Michill Edward baker 587633 587633 Michill, Edward, of Stony Stratford, Bucks, baker 0
4353745 2148531 2148531 defendant Waterhous Charles gent 587633 587633 Waterhous, Charles, of Stony Stratford, Bucks, gent 0
4353845 2148566 2148566 defendant Evens Henry victualer 587633 587633 Evens, Henry, of Stony Stratford, Bucks, victualer 2
4354016 2148632 2148632 defendant Hull Francis butcher 587633 587633 Hull, Francis, of Stony Stratford, Bucks, butcher 1
4728167 2274057 2274057 defendant Brasyer John chapman 587633 587633 Brasyer, John, of Stony Stratford, Bucks, chapman 1
4731128 2274934 2274934 defendant Vessy John ironmonger 587633 587633 Vessy, John, of Stony Stratford, Bucks, ironmonger 3
4731593 2275072 2275072 defendant Vessy John   587633 587633 Vessy, John, of Stony Stratford, Bucks, iron monger 2
4737710 2276899 2276899 defendant Goodrych Andrew yeoman 587633 587633 Goodrych, Andrew, of Stony Stratford, Bucks, yeoman 0
4760858 2283735 2283735 defendant Berell John, sen chapman 587633 587633 Berell, John, sen, of Stony Stratford, Bucks, chapman 0
4770233 2286664 2286664 defendant Brere John chapman 587633 587633 Brere, John, of Stony Stratford, Bucks, chapman 3
4776553 2288661 2288661 defendant Tryklowe Simon woolman 587633 587633 Tryklowe, Simon, of Stony Stratford, Bucks, woolman 0
4792422 2293714 2293714 defendant Bolde John brasier 587633 587633 Bolde, John, of Stony Stratford, Bucks, brasier 0
4809798 2299226 2299226 defendant Caunvyle William barber 587633 587633 Caunvyle, William, of Stony Stratford, Bucks, barber 2
4819927 2302309 2302309 defendant Trilove Simon   587633 587633 Trilove, Simon, of Stony Stratford, Bucks, wool man 0
4819929 2302310 2302310 defendant Tryklove Simon   587633 587633 Tryklove, Simon, of Stony Stratford, Bucks, wool man 0
4839709 2308334 2308334 defendant Tryklove Simon husbandman 587633 587633 Tryklove, Simon, of Stony Stratford, Bucks, husbandman 0
4852050 2312072 2312072 defendant Shrove Henry smith 587633 587633 Shrove, Henry, of Stony Stratford, Bucks, smith 2
4852054 2312073 2312073 defendant Shrove Henry smith 587633 587633 Shrove, Henry, of Stony Stratford, Bucks, smith 2
4941024 2339211 2339211 defendant Fuller William fuller 587633 587633 Fuller, William, of Stony Stratford, Bucks, fuller 3
4942384 2339605 2339605 defendant Trykkelove John woolman 587633 587633 Trykkelove, John, of Stony Stratford, Bucks, woolman 1
4949001 2341675 2341675 defendant Chapman William chapman 587633 587633 Chapman, William, of Stony Stratford, Bucks, chapman 0
5016306 2361659 2361659 defendant Edy John gent 587633 587633 Edy, John, of Stony Stratford, Bucks, gent 0
5029445 2365485 2365485 defendant Brydde William chapman 587633 587633 Brydde, William, of Stony Stratford, Bucks, chapman 0
5036798 2367640 2367640 defendant Jamys William cordwainer 587633 587633 Jamys, William, of Stony Stratford, Bucks, cordwainer 1
5080136 2380545 2380545 defendant Fortho Thomas yeoman 587633 587633 (Fortho, Thomas, of Stony Stratford, Bucks, yeoman 2
5084389 2381841 2381841 defendant Chapell Nicholas ostler 587633 587633 Chapell, Nicholas, of Stony Stratford, Bucks, ostler 0
5095496 2385100 2385100 defendant Raynford Thomas butcher 587633 587633 Raynford, Thomas, of Stony Stratford, Bucks, butcher 0
5097053 2385570 2385570 defendant Thirnyng alias Bailly William yeoman 587633 587633 Thirnyng alias Bailly, William, of Stony Stratford, Bucks, yeoman 1
5099380 2386247 2386247 defendant Edy John gent 587633 587633 (Edy, John, of Stony Stratford, Bucks, gent 1
5099822 2386387 2386387 defendant Wheler John, junior husbandman 587633 587633 Wheler, John, junior, of Stony Stratford, Bucks, husbandman 7
5111308 2389697 2389697 defendant Hayle John butcher 587633 587633 Hayle, John, of Stony Stratford, Bucks, butcher 1
5123679 2393384 2393384 defendant Wheler John, junior husbandman 587633 587633 Wheler, John, junior, of Stony Stratford, Bucks, husbandman 7
5132502 2395997 2395997 defendant Bunne Walter yeoman 587633 587633 Bunne, Walter, of Stony Stratford, Bucks, yeoman 2
5152264 2401791 2401791 defendant Bunne Walter yeoman 587633 587633 Bunne, Walter, of Stony Stratford, Bucks, yeoman 2
5164001 2405211 2405211 defendant Smythe Henry chapman 587633 587633 Smythe, Henry, of Stony Stratford, Bucks, chapman 1
5184932 2411341 2411341 defendant Turny William draper 587633 587633 Turny, William, of Stony Stratford, Bucks, draper 0
5200473 2415899 2415899 defendant Smythe Henry chapman 587633 587633 Smythe, Henry, of Stony Stratford, Bucks, chapman 1
5200790 2415991 2415991 defendant Smyth Henry chapman 587633 587633 Smyth, Henry, of Stony Stratford, Bucks, chapman 1
5204604 2417093 2417093 defendant Turvy William draper 587633 587633 Turvy, William, of Stony Stratford, Bucks, draper 0
5217023 2420718 2420718 defendant Lawe Richard husbandman 587633 587633 Lawe, Richard, of Stony Stratford, Bucks, husbandman 1
5230322 2424485 2424485 defendant Lawe Richard yeoman 587633 587633 Lawe, Richard, of Stony Stratford, Bucks, yeoman 0
5230327 2424486 2424486 defendant Lawe Richard husbandman 587633 587633 Lawe, Richard, of Stony Stratford, Bucks, husbandman 0
5237022 2426410 2426410 defendant Smyth John gent 587633 587633 Smyth, John, of Stony Stratford, Bucks, gent 0
5237024 2426411 2426411 defendant Smyth John gent 587633 587633 Smyth, John, of Stony Stratford, Bucks, gent 0
5248581 2429708 2429708 defendant Ikelyng John osteler 587633 587633 Ikelyng, John, of Stony Stratford, Bucks, osteler 0
5248590 2429709 2429709 defendant Kelyng John osteler 587633 587633 Kelyng, John, of Stony Stratford, Bucks, osteler 2
5268961 2436027 2436027 defendant Chese Thomas butcher 587633 587633 Chese, Thomas, of Stony Stratford, Bucks, butcher 2
5271535 2436769 2436769 plaintiff Haill John, senior   587633 587633 Haill, John, senior, of Stony Stratford, Bucks 0
5272168 2436940 2436940 defendant Lawe Richard yeoman 587633 587633 Lawe, Richard, of Stony Stratford, Bucks, yeoman 4
5283769 2440294 2440294 defendant Capon John husbandman 587633 587633 Capon, John, of Stony Stratford, Bucks, husbandman 1
5286077 2440936 2440936 plaintiff Hayll John, senior   587633 587633 Hayll, John, senior, of Stony Stratford, Bucks 0
5293529 2443075 2443075 defendant Carter John butcher 587633 587633 Carter, John, of Stony Stratford, Bucks, butcher 4
5308484 2447573 2447573 defendant Carter John butcher 587633 587633 Carter, John, of Stony Stratford, Bucks, butcher 3
5309476 2447872 2447872 defendant Carter John butcher 587633 587633 Carter, John, of Stony Stratford, Bucks, butcher 3
5323086 2451989 2451989 defendant Muscote John gent 587633 587633 Muscote, John, of Stony Stratford, Bucks, gent 0
5351292 2460499 2460499 defendant Hayle John butcher 587633 587633 Hayle, John, of Stony Stratford, Bucks, butcher 0
5355135 2461675 2461675 defendant Seyman Walter clerk 587633 587633 Seyman, Walter, of Stony Stratford, Bucks, clerk 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);