names

142 rows where place_id = 596683

✎ 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
3625743 1875591 1875591 plaintiff Wyset Robert   596683 596683 Wyset, Robert, of Berton 0
3628147 1903659 1903659 defendant Janyng Thomas husbandman 596683 596683 Janyng, Thomas, of Berton, husbandman 0
3665954 1915286 1915286 defendant Cok William yeoman 596683 596683 Cok, William, of Berton, yeoman 0
3701913 1926849 1926849 defendant Whyte William husbandman 596683 596683 Whyte, William, of Berton, husbandman 1
3798801 1957539 1957539 plaintiff Holder Robert yeoman 596683 596683 Holder, Robert, of Berton, yeoman 0
3802165 1958573 1958573 defendant Amys William husbandman 596683 596683 Amys, William, of Berton, husbandman 0
3846723 1972531 1972531 defendant Russell Richard husbandman 596683 596683 Russell, Richard, of Berton under Nedewode, husbandman 0
3867279 1979290 1979290 defendant Page William husbandman 596683 596683 Page, William, of Berton, husbandman 0
3884627 1985130 1985130 defendant Bekker Robert butcher 596683 596683 Bekker, Robert, of Berton, butcher 0
3895316 1988640 1988640 defendant Alen Robert husbandman 596683 596683 Alen, Robert, of Berton, husbandman 0
4202979 2096589 2096589 defendant Deathe Anthony gent 596683 596683 Deathe, Anthony, of Berton, gent 0
4450297 2185051 2185051 defendant Martyn John   596683 596683 Martyn, John, of Berton 0
4454010 2186268 2186268 defendant Ankersmyth John   596683 596683 Ankersmyth, John, of Berton 7
4458226 2187612 2187612 defendant Gouty John   596683 596683 Gouty, John, of Berton 0
4465044 2189729 2189729 defendant Kent John de   596683 596683 Kent, John de, of Berton 0
4469703 2191193 2191193 defendant Burre Henry weaver 596683 596683 Burre, Henry, of Berton, weaver 0
4491097 2197904 2197904 defendant Marchall William clerk 596683 596683 Marchall, William, of Berton, clerk 0
4497604 2199897 2199897 defendant Wright William   596683 596683 Wright, William, of Berton 0
4500035 2200654 2200654 defendant Abell William   596683 596683 Abell, William, of Berton 0
4503109 2201542 2201542 defendant Swaldale John smith 596683 596683 Swaldale, John, of Berton, smith 0
4504264 2201887 2201887 defendant atte Fan Robert   596683 596683 atte Fan, Robert, of Berton 1
4504265 2201887 2201887 defendant Outlawe Robert   596683 596683 Outlawe, Robert, of Berton 2
4504457 2201952 2201952 plaintiff Royver or Royner John   596683 596683 Royver or Royner, John, of Berton, on his own account 0
4504458 2201952 2201952 defendant Outlawe Robert   596683 596683 Outlawe, Robert, of Berton 0
4521662 2207105 2207105 defendant Selet Adam   596683 596683 Selet, Adam, of Berton 0
4521663 2207105 2207105 defendant Couper William   596683 596683 Couper, William, of Berton 1
4531403 2210094 2210094 plaintiff Pegge Thomas   596683 596683 Pegge, Thomas, of Berton 0
4533335 2210688 2210688 plaintiff Reyner John   596683 596683 Reyner, John, of Berton 0
4533337 2210689 2210689 plaintiff Reyner John   596683 596683 Reyner, John, of Berton 0
4535508 2211375 2211375 defendant Fultowe William   596683 596683 Fultowe, William, of Berton 1
4540381 2212889 2212889 defendant Dickes Robert   596683 596683 Dickes, Robert, of Berton 0
4551336 2216355 2216355 defendant Boteler William   596683 596683 Boteler, William, of Berton 0
4563349 2220109 2220109 defendant Outlawe John   596683 596683 Outlawe, John, of Berton 1
4566145 2220973 2220973 defendant Botiller William   596683 596683 Botiller, William, of Berton 0
4591174 2228597 2228597 defendant Bargayne William   596683 596683 Bargayne, William, of Berton 0
4592602 2229036 2229036 defendant Reyner John   596683 596683 Reyner, John, of Berton 0
4627677 2239589 2239589 plaintiff Rothewell John   596683 596683 Rothewell, John, of Berton 0
4629516 2240162 2240162 plaintiff Southwode John   596683 596683 Southwode, John, of Berton 0
4645614 2244788 2244788 defendant atte Thirne Thomas   596683 596683 atte Thirne, Thomas, of Berton 0
4649811 2245968 2245968 defendant Bayly Nicholas   596683 596683 Bayly, Nicholas, of Berton 0
4657278 2248167 2248167 defendant Syer Thomas husbandman 596683 596683 Syer, Thomas, of Berton, husbandman 0
4683024 2260304 2260304 defendant Walker Thomas laborer 596683 596683 Walker, Thomas, of Berton, laborer 1
4691803 2262969 2262969 plaintiff Aleyn Henry   596683 596683 Aleyn, Henry, of Berton 0
4691804 2262969 2262969 defendant Atkyn John   596683 596683 Atkyn, John, of Berton 0
4693485 2263463 2263463 defendant Smyth Henry smith 596683 596683 Smyth, Henry, of Berton, smith 2
4694912 2263897 2263897 defendant Gilberd Nicholas yeoman 596683 596683 Gilberd, Nicholas, of Berton, yeoman 0
4713140 2269433 2269433 defendant Sutton John skinner 596683 596683 Sutton, John, of Berton on Humber, skinner 0
4735909 2276382 2276382 defendant Wynde William yeoman 596683 596683 Wynde, William, of Berton, yeoman 2
4737723 2276902 2276902 defendant Toly William husbandman 596683 596683 Toly, William, of Berton, husbandman 0
4740600 2277765 2277765 defendant Clerk William yeoman 596683 596683 Clerk, William, of Berton, yeoman 1
4740651 2277782 2277782 defendant Candeler or Caudeler Thomas chaplain 596683 596683 Candeler or Caudeler, Thomas, of Berton, chaplain 2
4751236 2280838 2280838 defendant Moosshe John husbandman 596683 596683 Moosshe, John, of Berton, husbandman 0
4751237 2280838 2280838 defendant Lane William husbandman 596683 596683 Lane, William, of Berton, husbandman 1
4751238 2280838 2280838 defendant Dyke Richard husbandman 596683 596683 Dyke, Richard, of Berton, husbandman 2
4751239 2280838 2280838 defendant Badcok John husbandman 596683 596683 Badcok, John, of Berton, husbandman 3
4751240 2280838 2280838 defendant Newynton John laborer 596683 596683 Newynton, John, of Berton, laborer 4
4756063 2282275 2282275 defendant Corbyn Robert husbandman 596683 596683 Corbyn, Robert, of Berton, husbandman 5
4762906 2284381 2284381 plaintiff Gatele Thomas   596683 596683 Gatele, Thomas, of Berton 0
4763178 2284469 2284469 defendant Halle Richard husbandman 596683 596683 Halle, Richard, of Berton Abbot, by Gloucester, husbandman 1
4783037 2290712 2290712 defendant Hache John farmer 596683 596683 Hache, John, of Berton, farmer 4
4786631 2291871 2291871 plaintiff Gatele Thomas   596683 596683 Gatele, Thomas, of Berton 0
4789395 2292749 2292749 defendant Almote William husbandman 596683 596683 Almote, William, of Berton, husbandman 0
4789696 2292845 2292845 defendant Reyner John husbandman 596683 596683 Reyner, John, of Berton, husbandman 1
4795471 2294735 2294735 defendant Flexman John laborer 596683 596683 Flexman, John, of Berton, laborer 0
4812868 2300140 2300140 defendant Birton Richard yeoman 596683 596683 Birton, Richard, of Berton, yeoman 2
4812870 2300140 2300140 defendant Senyour Robert yeoman 596683 596683 Senyour, Robert, of Berton, yeoman 4
4834184 2306702 2306702 defendant Ongere (illegible) husbandman 596683 596683 Ongere, _, of Berton, husbandman 0
4846996 2310566 2310566 defendant Barnaby John gent 596683 596683 Barnaby, John, of Berton, gent 0
4849611 2311355 2311355 defendant Chirche Benedict   596683 596683 Chirche, Benedict, of Berton, parson 0
4858257 2313955 2313955 plaintiff Brightfeld John   596683 596683 Brightfeld, John, of Berton 0
4859167 2314242 2314242 defendant Selot Roger   596683 596683 Selot, Roger, of Berton, wright 0
4859168 2314242 2314242 defendant Sewede John, junior husbandman 596683 596683 Sewede, John, junior, of Berton, husbandman 1
4859169 2314242 2314242 defendant Fox Nicholas   596683 596683 Fox, Nicholas, of Berton, worsted weaver 2
4859170 2314242 2314242 defendant Couper Richard laborer 596683 596683 Couper, Richard, of Berton, laborer 3
4859171 2314242 2314242 defendant Bustyng John laborer 596683 596683 Bustyng, John, of Berton, laborer 4
4859172 2314242 2314242 defendant Smyth Thomas smith 596683 596683 Smyth, Thomas, of Berton, smith 5
4874594 2319000 2319000 defendant Chaunter Stbil widow 596683 596683 Chaunter, Stbil, of Berton Strete, Gloucester, widow 1
4874595 2319000 2319000 defendant Drewe John husbandman 596683 596683 Drewe, John, of Berton Strete, Gloucester, husbandman 2
4885088 2322229 2322229 defendant Hedyrsete William husbandman 596683 596683 Hedyrsete, William, of Berton, husbandman 1
4885379 2322312 2322312 defendant Marchall Robert butcher 596683 596683 Marchall, Robert, of Berton, butcher 1
4900086 2326658 2326658 defendant Hedyrsete William husbandman 596683 596683 Hedyrsete, William, of Berton, husbandman 1
4906471 2328608 2328608 defendant Gatle Henry yeoman 596683 596683 Gatle, Henry, of Berton, yeoman 11
4908657 2329263 2329263 defendant Aunger Nicholas, junior husbandman 596683 596683 Aunger, Nicholas, junior, of Berton, husbandman 2
4930526 2335948 2335948 defendant Reynell William husbandman 596683 596683 Reynell, William, of Berton, husbandman 0
4939462 2338725 2338725 defendant Stanford John gent 596683 596683 Stanford, John, of Berton, gent 0
4943440 2339916 2339916 defendant Clerk John husbandman 596683 596683 Clerk, John, of Berton, husbandman 8
4956394 2343876 2343876 defendant Stanford John gent 596683 596683 Stanford, John, of Berton, gent 3
4966250 2346838 2346838 defendant Dike Richard husbandman 596683 596683 Dike, Richard, of Berton, husbandman 0
4966253 2346839 2346839 defendant Dyke Richard husbandman 596683 596683 Dyke, Richard, of Berton, husbandman 0
5006464 2358789 2358789 defendant Clerk William gent 596683 596683 Clerk, William, of Berton, gent 0
5054142 2372829 2372829 defendant Johnson Henry husbandman 596683 596683 Johnson, Henry, of Berton, husbandman 0
5060211 2374625 2374625 defendant Howys John husbandman 596683 596683 Howys, John, of Berton, husbandman 3
5060212 2374625 2374625 defendant Howys Robert husbandman 596683 596683 Howys, Robert, of Berton, husbandman 4
5075996 2379313 2379313 defendant Clerk John yeoman 596683 596683 Clerk, John, of Berton, yeoman 2
5096365 2385367 2385367 defendant Duffeld Thomas gent 596683 596683 Duffeld, Thomas, of Berton on Humber, gent 6
5133609 2396323 2396323 plaintiff Iwyn John   596683 596683 Iwyn, John, of Berton 0
5144613 2399583 2399583 plaintiff Bertram Andrew   596683 596683 Bertram, Andrew, of Berton 0
5221820 2422080 2422080 defendant Crede Thomas yeoman 596683 596683 Crede, Thomas, of Berton, yeoman 1
5248667 2429730 2429730 plaintiff Symond William   596683 596683 Symond, William, of Berton 0
5296193 2443878 2443878 defendant Barbour John butcher 596683 596683 Barbour, John, of Berton on Humber, butcher 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);