names

103 rows where place_id = 612586

✎ 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
3694045 1924342 1924342 defendant Clevelode John yeoman 612586 612586 Clevelode, John, of Bekyngton, yeoman 1
3735378 1937301 1937301 defendant Bayer Thomas husbandman 612586 612586 Bayer, Thomas, of Bekyngton, husbandman 0
3776485 1950399 1950399 defendant Compton John merchant 612586 612586 Compton, John, of Bekyngton, merchant 0
3779079 1951183 1951183 defendant Clevelode John miller 612586 612586 Clevelode, John, of Bekyngton, miller 1
3791924 1955319 1955319 defendant Mannyng Thomas husbandman 612586 612586 Mannyng, Thomas, of Bekyngton, husbandman 0
3829909 1967246 1967246 defendant Clevelode John miller 612586 612586 Clevelode, John, of Bekyngton, miller 1
3861880 1977432 1977432 defendant Sheperd John miller 612586 612586 Sheperd, John, of Bekyngton, miller 0
3863926 1978111 1978111 defendant Reynoll John butcher 612586 612586 Reynoll, John, of Bekyngton, butcher 0
3887957 1986222 1986222 defendant Thomas William clerk 612586 612586 Thomas, William, of Bekyngton, clerk 0
3982840 2018636 2018636 defendant Major Nicholas laborer 612586 612586 Major, Nicholas, of Bekyngton, laborer 0
4020398 2032017 2032017 defendant Longe William (legal representative) 612586 612586 Longe, William, of Bekyngton, clothier, executor of 0
4041683 2039510 2039510 defendant Fletcher Thomas yeoman 612586 612586 Fletcher, Thomas, of Bekyngton, yeoman 7
4062289 2046802 2046802 defendant Parkyns Alexander yeoman 612586 612586 Parkyns, Alexander, of Bekyngton, yeoman 0
4515743 2205351 2205351 plaintiff Clerk Thomas   612586 612586 Clerk, Thomas, of Bekyngton 0
4516593 2205601 2205601 defendant Wikyns John   612586 612586 Wikyns, John, of Bekyngton 0
4516594 2205601 2205601 defendant Ropere Robert   612586 612586 Ropere, Robert, of Bekyngton 1
4518060 2206022 2206022 defendant Dorlegh Edward   612586 612586 Dorlegh, Edward, of Bekyngton 2
4535069 2211247 2211247 defendant Dawe John   612586 612586 Dawe, John, of Bekyngton 0
4535070 2211247 2211247 defendant Wilkyns John   612586 612586 Wilkyns, John, of Bekyngton 1
4537017 2211845 2211845 defendant Wilkyns John   612586 612586 Wilkyns, John, of Bekyngton 0
4552550 2216749 2216749 defendant Dyer Richard   612586 612586 Dyer, Richard, of Bekyngton 4
4565519 2220785 2220785 defendant Toteyate William   612586 612586 Toteyate, William, of Bekyngton 0
4594886 2229654 2229654 plaintiff Purneour or Purveour Lawrence   612586 612586 Purneour or Purveour, Lawrence, of Bekyngton 0
4594887 2229654 2229654 defendant Brewere John   612586 612586 Brewere, John, of Bekyngton 0
4609645 2234112 2234112 defendant Purveour Lawrence   612586 612586 Purveour, Lawrence, of Bekyngton 0
4625958 2239073 2239073 defendant Pylk John merchant 612586 612586 Pylk, John, of Bekyngton, merchant 0
4641793 2243699 2243699 defendant Compton Adam   612586 612586 Compton, Adam, of Bekyngton 0
4646487 2245037 2245037 defendant Stert John   612586 612586 Stert, John, of Bekyngton 0
4671983 2256881 2256881 defendant Pylk John   612586 612586 Pylk, John, of Bekyngton 1
4672558 2257062 2257062 defendant Dawe John clothmaker 612586 612586 Dawe, John, of Bekyngton, clothmaker 2
4677219 2258495 2258495 defendant Purneour Lawrence merchant 612586 612586 Purneour, Lawrence, of Bekyngton, merchant 0
4684632 2260792 2260792 defendant Toteyet Wilaim butcher 612586 612586 Toteyet, Wilaim, of Bekyngton, butcher 1
4688770 2262044 2262044 defendant Purveour Lawrence weaver 612586 612586 Purveour, Lawrence, of Bekyngton, weaver 0
4698789 2265102 2265102 defendant Brynkele Walter weaver 612586 612586 Brynkele, Walter, of Bekyngton, weaver 0
4698836 2265116 2265116 defendant Brynkele Walter weaver 612586 612586 Brynkele, Walter, of Bekyngton, weaver 0
4707483 2267714 2267714 defendant Bosse William ostler 612586 612586 Bosse, William, of Bekyngton, ostler 2
4707484 2267714 2267714 defendant Bosse Walter weaver 612586 612586 Bosse, Walter, of Bekyngton, weaver 3
4707485 2267714 2267714 defendant Bosse Henry husbandman 612586 612586 Bosse, Henry, of Bekyngton, husbandman 4
4710265 2268564 2268564 defendant Muleward John weaver 612586 612586 Muleward, John, of Bekyngton, weaver 0
4712261 2269151 2269151 defendant Dawe John, junior weaver 612586 612586 Dawe, John, junior, of Bekyngton, weaver 2
4712673 2269279 2269279 defendant Compton Adam weaver 612586 612586 Compton, Adam, of Bekyngton, weaver 0
4712674 2269279 2269279 defendant Patryk Richard husbandman 612586 612586 Patryk, Richard, of Bekyngton, husbandman 1
4721807 2272154 2272154 plaintiff Pylke John, sen   612586 612586 Pylke, John, sen, of Bekyngton 1
4726676 2273613 2273613 defendant Purveour Richard husbandman 612586 612586 Purveour, Richard, of Bekyngton, husbandman 2
4784999 2291322 2291322 defendant Whyte John chaplain 612586 612586 Whyte, John, of Bekyngton, chaplain 0
4785267 2291411 2291411 defendant Hunte Richard shoemaker 612586 612586 Hunte, Richard, of Bekyngton, shoemaker 0
4794973 2294570 2294570 plaintiff Pylk John (legal representative) 612586 612586 Pylk, John, of Bekyngton, executrix of 0
4802329 2296919 2296919 defendant Cary Philip esq 612586 612586 Cary, Philip, of Bekyngton, esq 0
4825102 2303893 2303893 defendant Lucas Thomas weaver 612586 612586 Lucas, Thomas, of Bekyngton, weaver 0
4827160 2304540 2304540 defendant Gaweter John husbandman 612586 612586 Gaweter, John, of Bekyngton, husbandman 0
4829453 2305253 2305253 defendant Coffyn or Cossyn John chapman 612586 612586 Coffyn or Cossyn, John, of Bekyngton, chapman 4
4868002 2316961 2316961 defendant Hereford Walter weaver 612586 612586 Hereford, Walter, of Bekyngton, weaver 0
4868003 2316961 2316961 defendant Aysswell John weaver 612586 612586 Aysswell, John, of Bekyngton, weaver 1
4890295 2323733 2323733 plaintiff Gysby Elias (legal representative) 612586 612586 Gysby, Elias, of Bekyngton, draper, executors of 0
4897680 2325939 2325939 defendant Prynce John weaver 612586 612586 Prynce, John, of Bekyngton, weaver 0
4897681 2325940 2325940 plaintiff Gysby Elias (legal representative) 612586 612586 Gysby, Elias, of Bekyngton, draper, executors of 0
4905005 2328170 2328170 defendant Hamelyn John, senior weaver 612586 612586 Hamelyn, John, senior, of Bekyngton, weaver 0
4911784 2330188 2330188 defendant Lane John draper 612586 612586 Lane, John, of Bekyngton, draper 0
4924038 2333957 2333957 defendant Godyng John clerk 612586 612586 Godyng, John, of Bekyngton, clerk 0
4934268 2337106 2337106 defendant Plusshe John husbandman 612586 612586 Plusshe, John, of Bekyngton, husbandman 0
4934269 2337106 2337106 defendant Pylke John weaver 612586 612586 Pylke, John, of Bekyngton, weaver 1
4937343 2338046 2338046 defendant Lane John draper 612586 612586 Lane, John, of Bekyngton, draper 0
4938660 2338477 2338477 defendant Wheler Thomas weaver 612586 612586 Wheler, Thomas, of Bekyngton, weaver 0
4957704 2344276 2344276 defendant Touker Philip ploughman 612586 612586 Touker, Philip, of Bekyngton, ploughman 0
4976378 2349896 2349896 defendant Prynce John weaver 612586 612586 Prynce, John, of Bekyngton, weaver 0
4984709 2352355 2352355 defendant Brant Thomas husbandman 612586 612586 Brant, Thomas, of Bekyngton, husbandman 0
4984712 2352355 2352355 defendant Lane John husbandman 612586 612586 Lane, John, of Bekyngton, husbandman 3
4984713 2352355 2352355 defendant Herward Walter husbandman 612586 612586 Herward, Walter, of Bekyngton, husbandman 4
4984723 2352358 2352358 defendant Walkeleyn William laborer 612586 612586 Walkeleyn, William, of Bekyngton, laborer 0
5024190 2363988 2363988 defendant Bayly Edward weaver 612586 612586 Bayly, Edward, of Bekyngton, weaver 0
5024191 2363988 2363988 defendant Trappe Lawrence weaver 612586 612586 Trappe, Lawrence, of Bekyngton, weaver 1
5027704 2364977 2364977 defendant Godyng John clerk 612586 612586 Godyng, John, of Bekyngton, clerk 0
5028285 2365151 2365151 defendant Ganter or Gauter John, senior   612586 612586 Ganter or Gauter, John, senior, of Bekyngton 0
5031481 2366066 2366066 defendant Grenelane Thomas husbandman 612586 612586 Grenelane, Thomas, of Bekyngton, husbandman 0
5034059 2366826 2366826 defendant Boteler Adam weaver 612586 612586 Boteler, Adam, of Bekyngton, weaver 0
5034060 2366826 2366826 defendant Spryng Thomas husbandman 612586 612586 Spryng, Thomas, of Bekyngton, husbandman 1
5034065 2366828 2366828 defendant Boteler Adam weaver 612586 612586 together with Boteler, Adam, of Bekyngton, weaver 1
5034066 2366828 2366828 defendant Spryng Thomas husbandman 612586 612586 Spryng, Thomas, of Bekyngton, husbandman 2
5035595 2367272 2367272 defendant Grenelane Thomas husbandman 612586 612586 Grenelane, Thomas, of Bekyngton, husbandman 1
5035602 2367273 2367273 defendant Grenelane Thomas husbandman 612586 612586 Grenelane, Thomas, of Bekyngton, husbandman 1
5036470 2367527 2367527 defendant Ganter John weaver 612586 612586 Ganter, John, of Bekyngton, weaver 0
5036471 2367527 2367527 defendant Boteler Adam weaver 612586 612586 Boteler, Adam, of Bekyngton, weaver 1
5036472 2367527 2367527 defendant Spryng Thomas husbandman 612586 612586 Spryng, Thomas, of Bekyngton, husbandman 2
5049573 2371501 2371501 defendant Grenlane Thomas husbandman 612586 612586 Grenlane, Thomas, of Bekyngton, husbandman 0
5066139 2376396 2376396 defendant Trappe Thomas weaver 612586 612586 Trappe, Thomas, of Bekyngton, weaver 0
5066140 2376396 2376396 defendant Grenelane Thomas husbandman 612586 612586 Grenelane, Thomas, of Bekyngton, husbandman 1
5073183 2378467 2378467 defendant Nede John clothier 612586 612586 Nede, John, of Bekyngton, clothier 2
5102060 2387028 2387028 defendant Broun Thomas yeoman 612586 612586 Broun, Thomas, of Bekyngton, yeoman 0
5102063 2387028 2387028 defendant Plesaunce William weaver 612586 612586 Plesaunce, William, of Bekyngton, weaver 3
5196843 2414829 2414829 defendant Broun William husbandman 612586 612586 Broun, William, of Bekyngton, husbandman 3
5209845 2418614 2418614 defendant Broun William husbandman 612586 612586 Broun, William, of Bekyngton, husbandman 3
5239626 2427176 2427176 defendant Sherwyn John weaver 612586 612586 Sherwyn, John, of Bekyngton, weaver 3
5257530 2432475 2432475 defendant Clerke Philip clerk 612586 612586 Clerke, Philip, of Bekyngton, clerk 1
5271217 2436675 2436675 defendant Roger John carpenter 612586 612586 Roger, John, of Bekyngton, carpenter 0
5280745 2439443 2439443 defendant Fabell Roger clerk 612586 612586 Fabell, Roger, of Bekyngton, clerk 0
5280750 2439444 2439444 defendant Fabell Roger clerk 612586 612586 Fabell, Roger, of Bekyngton, clerk 0
5332181 2454700 2454700 defendant Warlegh William chandler 612586 612586 Warlegh, William, of Bekyngton, chandler 0
5604084 2536139 2536139 defendant Loves William gent 612586 612586 Loves, William, of Bekyngton, gent 0
5622765 2551050 2551050 plaintiff Wattes Ralph   612586 612586 Wattes, Ralph, of Bekyngton, parson 0
5626566 2552280 2552280 defendant Tutteyate William yeoman 612586 612586 Tutteyate, William, of Bekyngton, yeoman 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);