names

134 rows where place_id = 591275

✎ 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
3603912 1868895 1868895 defendant Garard John dyer 591275 591275 Garard, John, of Stowe Market, dyer 3
3603919 1868896 1868896 defendant Garrard John dyer 591275 591275 Garrard, John, of Stowe Market, dyer 3
3603984 1868912 1868912 defendant Baldry William mercer 591275 591275 Baldry, William, of Stowe Market, mercer 3
3604250 1868992 1868992 defendant Page Robert (legal representative) 591275 591275 Page, Robert, of Stowe Market, executrix of 5
3604251 1868992 1868992 defendant Page Margery widow 591275 591275 Page, Margery, of Stowe Market, widow 6
3605519 1869391 1869391 defendant Thorpe William merchant 591275 591275 Thorpe, William, of Stowe Market, merchant 0
3607273 1869937 1869937 defendant Borough Thomas husbandman 591275 591275 Borough, Thomas, of Stowe Market, husbandman 5
3610005 1870799 1870799 defendant Grene Robert butcher 591275 591275 Grene, Robert, of Stowe Market, butcher 0
3612470 1871532 1871532 defendant Turnour Philip sherman 591275 591275 Turnour, Philip, of Stowe Market, sherman 0
3657581 1912632 1912632 defendant Trusts John dyer 591275 591275 Trusts, John, of Stowe Market, dyer 0
3680561 1920002 1920002 defendant Patman Richard   591275 591275 Patman, Richard, of Stowe Market, "whodsetter" 0
3822180 1964835 1964835 defendant Coke John weaver 591275 591275 Coke, John, of Stowe Market, weaver 0
3829847 1967226 1967226 defendant Gildenslee Thomas laborer 591275 591275 Gildenslee, Thomas, of Stowe Market, laborer 1
4045688 2040908 2040908 defendant Brydges Thomas yeoman 591275 591275 Brydges, Thomas, of Stowe Market, yeoman 1
4127089 2069979 2069979 defendant Lyllye Stephen chapman 591275 591275 Lyllye, Stephen, of Stowe Market, chapman 2
4282743 2123868 2123868 defendant Parker Robert, senior tailor 591275 591275 Parker, Robert, senior, of Stowe Market, tailor 0
4450792 2185210 2185210 defendant Lystere John   591275 591275 Lystere, John, of Stowe Market 1
4452325 2185716 2185716 plaintiff Jeneye Thomas   591275 591275 Jeneye, Thomas, of Stowe Market 0
4479785 2194340 2194340 defendant Jankyn John   591275 591275 Jankyn, John, of Stowe Market, pedlar 3
4479792 2194341 2194341 defendant Jankyn John pedder 591275 591275 Jankyn, John, of Stowe Market, pedder 5
4509264 2203377 2203377 defendant Barbour Walter   591275 591275 Barbour, Walter, of Stowe Market 0
4509272 2203378 2203378 defendant Barbour Walter   591275 591275 together with Barbour, Walter, of Stowe Market 2
4514384 2204919 2204919 defendant Eston William   591275 591275 Eston, William, of Stowe Market 0
4517175 2205774 2205774 defendant Clement John   591275 591275 Clement, John, of Stowe market 2
4557611 2218315 2218315 defendant Nene Edmund   591275 591275 Nene, Edmund, of Stowe Market 1
4622732 2238084 2238084 defendant Hyngham Thomas dyer 591275 591275 Hyngham, Thomas, of Stowe Market, dyer 0
4643473 2244191 2244191 defendant Ingham Thomas   591275 591275 Ingham, Thomas, of Stowe Market, wood man 1
4670644 2256502 2256502 plaintiff Buntyng John   591275 591275 Buntyng, John, of Stowe Market 0
4671664 2256784 2256784 defendant Magges Richard butcher 591275 591275 Magges, Richard, of Stowe Market, butcher 0
4671666 2256784 2256784 defendant Whethereld John yeoman 591275 591275 Whethereld, John, of Stowe Market, yeoman 2
4673794 2257426 2257426 defendant Hyngham Thomas dyer 591275 591275 Hyngham, Thomas, of Stowe Market, dyer 0
4673796 2257427 2257427 defendant Whethereld John husbandman 591275 591275 Whethereld, John, of Stowe Market, husbandman 0
4677556 2258593 2258593 defendant Wethereld John husbandman 591275 591275 Wethereld, John, of Stowe Market, husbandman 0
4722381 2272319 2272319 plaintiff Whedereld John   591275 591275 Whedereld, John, of Stowe Market 1
4722385 2272320 2272320 plaintiff Whedereld John   591275 591275 Whedereld, John, of Stowe Market 1
4725297 2273202 2273202 defendant Bishop Godwin chandler 591275 591275 Bishop, Godwin, of Stowe Market, chandler 3
4727827 2273946 2273946 defendant Fullere John fuller 591275 591275 Fullere, John, of Stowe Market, fuller 3
4775911 2288468 2288468 defendant H_ William barber 591275 591275 H_, William, of Stowe Market, barber 0
4784177 2291050 2291050 defendant Venyour John butcher 591275 591275 Venyour, John, of Stowe Market, butcher 2
4810509 2299432 2299432 defendant Dallyng Thomas chapman 591275 591275 Dallyng, Thomas, of Stowe Market, chapman 0
4826309 2304264 2304264 defendant Whethereld Edmund yeoman 591275 591275 Whethereld, Edmund, of Stowe Market, yeoman 0
4841735 2308953 2308953 defendant Dallyng Thomas husbandman 591275 591275 Dallyng, Thomas, of Stowe Market, husbandman 0
4841736 2308953 2308953 defendant Sylverwode John husbandman 591275 591275 Sylverwode, John, of Stowe Market, husbandman 1
4844323 2309731 2309731 defendant Sylverwode John mercer 591275 591275 Sylverwode, John, of Stowe Market, mercer 0
4847453 2310705 2310705 defendant Plombe John yeoman 591275 591275 Plombe, John, of Stowe Market, yeoman 2
4847454 2310705 2310705 defendant Draper John weaver 591275 591275 Draper, John, of Stowe Market, weaver 3
4848321 2310946 2310946 plaintiff Sengelton Thomas esq 591275 591275 Sengelton, Thomas, of Stowe Market, esq 0
4848328 2310947 2310947 plaintiff Sengelton Thomas esq 591275 591275 Sengelton, Thomas, of Stowe Market, esq 0
4894988 2325097 2325097 defendant Dallyng Thomas merchant 591275 591275 Dallyng, Thomas, of Stowe Market, merchant 0
4896865 2325675 2325675 defendant Dallyng Thomas merchant 591275 591275 Dallyng, Thomas, of Stowe Market, merchant 0
4912118 2330291 2330291 defendant Sengylton Agnes widow 591275 591275 (Sengylton, Agnes, of Stowe market, widow 1
4912120 2330291 2330291 defendant Asshe Thomas gent 591275 591275 Asshe, Thomas, of Stowe Market, gent 3
4953813 2343101 2343101 defendant Thorn John husbandman 591275 591275 Thorn, John, of Stowe Market, husbandman 0
4962933 2345830 2345830 defendant Dallyng Thomas mercer 591275 591275 Dallyng, Thomas, of Stowe Market, mercer 0
4963055 2345858 2345858 defendant Wolman John husbandman 591275 591275 Wolman, John, of Stowe Market, husbandman 1
4981075 2351271 2351271 defendant Dallyng Thomas chapman 591275 591275 Dallyng, Thomas, of Stowe Market, chapman 0
4984555 2352310 2352310 defendant Colman Nicholas husbandman 591275 591275 Colman, Nicholas, of Stowe Market, husbandman 0
4985671 2352629 2352629 defendant Sengelton Thomas (legal representative) 591275 591275 Sengelton, Thomas, of Stowe Market, executors of 0
4985673 2352629 2352629 defendant Assh Thomas gent 591275 591275 Assh, Thomas, of Stowe Market, gent 2
4991802 2354432 2354432 defendant Neve John yeoman 591275 591275 Neve, John, of Stowe Market, yeoman 0
4992469 2354633 2354633 defendant Couper Thomas yeoman 591275 591275 Couper, Thomas, of Stowe Market, yeoman 4
4995668 2355546 2355546 defendant Pure John smith 591275 591275 Pure, John, of Stowe market, smith 2
4995670 2355546 2355546 defendant Dunyng Thomas smith 591275 591275 Dunyng, Thomas, of Stowe market, smith 4
5003692 2357972 2357972 defendant Cowpere Thomas husbandman 591275 591275 Cowpere, Thomas, of Stowe Market, husbandman 3
5005863 2358614 2358614 defendant Wage John spicer 591275 591275 Wage, John, of Stowe Market, spicer 0
5009560 2359675 2359675 defendant Ppage John tailor 591275 591275 Ppage, John, of Stowe Market, tailor 0
5013659 2360838 2360838 defendant Dallyng Thomas husbandman 591275 591275 Dallyng, Thomas, of Stowe Market, husbandman 0
5016817 2361814 2361814 defendant Hotoft Robert esq 591275 591275 Hotoft, Robert, of Stowe Market, esq 0
5066482 2376502 2376502 defendant Michell John butcher 591275 591275 Michell, John, of Stowe Market, butcher 0
5093056 2384357 2384357 defendant Spark Thomas husbandman 591275 591275 Spark, Thomas, of Stowe Market, husbandman 2
5093774 2384577 2384577 defendant Denys John husbandman 591275 591275 Denys, John, of Stowe Market, husbandman 0
5102027 2387019 2387019 defendant Thistildene Robert dyer 591275 591275 Thistildene, Robert, of Stowe Market, dyer 0
5102833 2387246 2387246 defendant Purse John laborer 591275 591275 Purse, John, of Stowe Market, laborer 0
5117447 2391537 2391537 defendant Denys John husbandman 591275 591275 Denys, John, of Stowe Market, husbandman 0
5117448 2391537 2391537 defendant Thystylden Robert husbandman 591275 591275 Thystylden, Robert, of Stowe Market, husbandman 1
5127360 2394484 2394484 defendant Hotot Robert esq 591275 591275 Hotot, Robert, of Stowe Market, esq 0
5134019 2396447 2396447 defendant Thistilden Robert clothmaker 591275 591275 Thistilden, Robert, of Stowe Market, clothmaker 1
5135202 2396793 2396793 defendant Wulvard John husbandman 591275 591275 Wulvard, John, of Stowe Market, husbandman 2
5141448 2398614 2398614 defendant Wodward Thomas fuller 591275 591275 Wodward, Thomas, of Stowe Market, fuller 0
5146247 2400032 2400032 defendant Hotot Robert esq 591275 591275 Hotot, Robert, of Stowe Market, esq 0
5152448 2401849 2401849 defendant Coke Robert dyer 591275 591275 Coke, Robert, of Stowe Market, dyer 0
5153078 2402042 2402042 defendant Ive Robert gent 591275 591275 Ive, Robert, of Stowe Market, gent 0
5153081 2402042 2402042 defendant Laweman Thomas   591275 591275 Laweman, Thomas, of Stowe Market, servant 3
5155300 2402700 2402700 defendant Wulnard John husbandman 591275 591275 Wulnard, John, of Stowe Market, husbandman 2
5162771 2404829 2404829 defendant atte Wode Thomas laborer 591275 591275 atte Wode, Thomas, of Stowe Market, laborer 0
5164352 2405308 2405308 defendant Thystylden Robert dyer 591275 591275 Thystylden, Robert, of Stowe Market, dyer 3
5164357 2405309 2405309 defendant Thystylden Robert dyer 591275 591275 Thystylden, Robert, of Stowe Market, dyer 3
5169972 2406951 2406951 defendant Wodward Thomas fuller 591275 591275 Wodward, Thomas, of Stowe Market, fuller 0
5170629 2407129 2407129 defendant Ive Robert gent 591275 591275 Ive, Robert, of Stowe Market, gent 0
5170632 2407129 2407129 defendant Laweman Thomas   591275 591275 Laweman, Thomas, of Stowe Market, servant 3
5171990 2407522 2407522 defendant Wulnard John husbandman 591275 591275 Wulnard, John, of Stowe Market, husbandman 2
5174914 2408360 2408360 plaintiff Sengelton Thomas (legal representative) 591275 591275 Sengelton, Thomas, of Stowe Market, esq, executors of 0
5176689 2408865 2408865 defendant atte Wode Thomas laborer 591275 591275 atte Wode, Thomas, of Stowe Market, laborer 0
5178563 2409444 2409444 defendant Wetherard John   591275 591275 Wetherard, John, of Stowe market, administrators of 1
5183935 2411037 2411037 defendant Purs John laborer 591275 591275 Purs, John, of Stowe Market, laborer 3
5192318 2413492 2413492 plaintiff Neve John   591275 591275 Neve, John, of Stowe Market 0
5194812 2414224 2414224 defendant Neve John yeoman 591275 591275 Neve, John, of Stowe Market, yeoman 1
5196452 2414713 2414713 defendant Dowe John fuller 591275 591275 Dowe, John, of Stowe Market, fuller 0
5206053 2417501 2417501 defendant Laweman Thomas   591275 591275 Laweman, Thomas, of Stowe Market, servant 3
5216591 2420582 2420582 defendant Yakysle Robert chapman 591275 591275 Yakysle, Robert, of Stowe Market, chapman 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);