names

191 rows where place_id = 587960

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592962 1865421 1865421 defendant Croke Nicholas chapman 587960 587960 Croke, Nicholas, of Bannebury, chapman 0
3592973 1865426 1865426 defendant Croke Nicholas chapman 587960 587960 Croke, Nicholas, of Bannebury, chapman 0
3643605 1908431 1908431 plaintiff Danvers Anne widow 587960 587960 Danvers, Anne, of Bannebury, widow 0
4439612 2181655 2181655 defendant Haukyns William   587960 587960 Haukyns, William, of Bannebury 0
4446731 2183894 2183894 plaintiff Diestere John   587960 587960 Diestere, John, of Bannebury 0
4454397 2186386 2186386 plaintiff Lyndraper Emma   587960 587960 Lyndraper, Emma, of Bannebury, formerly wife of Roger 0
4483946 2195670 2195670 defendant Dyssher Richard   587960 587960 Dyssher, Richard, of Bannebury 0
4495897 2199396 2199396 plaintiff Chyry Nicholas   587960 587960 Chyry, Nicholas, of Bannebury, on his own account 0
4495899 2199396 2199396 defendant Dyster John   587960 587960 Dyster, John, of Bannebury 1
4496206 2199488 2199488 plaintiff Coke Simon   587960 587960 Coke, Simon, of Bannebury, on his own account 0
4496208 2199489 2199489 plaintiff Coke Simon   587960 587960 Coke, Simon, of Bannebury, on his own account 0
4496209 2199489 2199489 defendant Walssheman Reginald   587960 587960 Walssheman, Reginald, of Bannebury 0
4496530 2199589 2199589 defendant Scot John   587960 587960 Scot, John, of Bannebury 0
4498120 2200066 2200066 defendant Cardemaker John   587960 587960 Cardemaker, John, of Bannebury 0
4501687 2201130 2201130 plaintiff Lyndraper William   587960 587960 Lyndraper, William, of Bannebury 0
4505175 2202154 2202154 defendant Bocher John   587960 587960 Bocher, John, of Bannebury 0
4505249 2202172 2202172 plaintiff Smyth John   587960 587960 Smyth, John, of Bannebury, on his own account 0
4505250 2202172 2202172 defendant Carpenter Thomas tailor 587960 587960 Carpenter, Thomas, of Bannebury, tailor 0
4538989 2212460 2212460 defendant Cook Henry   587960 587960 Cook, Henry, of Bannebury 0
4545175 2214413 2214413 plaintiff Bernes John, sen   587960 587960 Bernes, John, sen, of Bannebury 0
4548508 2215476 2215476 defendant Purcas John   587960 587960 Purcas, John, of Bannebury 0
4571327 2222616 2222616 defendant Haynes Richard   587960 587960 Haynes, Richard, of Bannebury 0
4653298 2246971 2246971 defendant Spycer John spicer 587960 587960 Spycer, John, of Bannebury, spicer 0
4654954 2247433 2247433 defendant Spycer John   587960 587960 Spycer, John, of Bannebury 0
4656926 2248060 2248060 defendant Scyff Robert butcher 587960 587960 Scyff, Robert, of Bannebury, butcher 0
4657605 2248270 2248270 plaintiff Coke William   587960 587960 Coke, William, of Bannebury 0
4657607 2248271 2248271 plaintiff Coke William   587960 587960 Coke, William, of Bannebury 0
4657609 2248272 2248272 plaintiff Coke William   587960 587960 Coke, William, of Bannebury 0
4657610 2248272 2248272 defendant Whityng John cordwainer 587960 587960 Whityng, John, of Bannebury, cordwainer 0
4659089 2248712 2248712 plaintiff Danners or Danvers Richard   587960 587960 Danners or Danvers, Richard, of Bannebury 0
4659094 2248714 2248714 defendant Whityng John shoemaker 587960 587960 Whityng, John, of Bannebury, shoemaker 0
4659095 2248714 2248714 defendant Darset Margaret spinster 587960 587960 Darset, Margaret, of Bannebury, spinster 1
4660995 2249263 2249263 defendant Boydon John hosier 587960 587960 Boydon, John, of Bannebury, hosier 0
4665602 2250714 2250714 defendant Impyngham William skinner 587960 587960 Impyngham, William, of Bannebury, skinner 0
4666719 2255318 2255318 defendant Napton John husbandman 587960 587960 Napton, John, of Bannebury, husbandman 0
4667939 2255675 2255675 plaintiff Baker Roger   587960 587960 Baker, Roger, of Bannebury 0
4667941 2255676 2255676 plaintiff Baker Roger   587960 587960 Baker, Roger, of Bannebury 0
4674592 2257660 2257660 plaintiff Eddon John brasier 587960 587960 Eddon, John, of Bannebury, brasier 0
4674593 2257660 2257660 defendant Helmynden William chapman 587960 587960 Helmynden, William, of Bannebury, chapman 0
4675813 2258044 2258044 defendant Juddys John dyer 587960 587960 Juddys, John, of Bannebury, dyer 0
4686694 2261450 2261450 defendant Swalclyff John   587960 587960 Swalclyff, John, of Bannebury 0
4724348 2272913 2272913 defendant Hull Robert chapman 587960 587960 Hull, Robert, of Bannebury, chapman 0
4724362 2272917 2272917 defendant Hull Robert husbandman 587960 587960 Hull, Robert, of Bannebury, husbandman 0
4730049 2274600 2274600 plaintiff Ludlowe Richard   587960 587960 Ludlowe, Richard, of Bannebury 0
4730724 2274808 2274808 defendant Hervy Thomas husbandman 587960 587960 Hervy, Thomas, of Bannebury, husbandman 0
4748166 2279972 2279972 defendant Fretewell John   587960 587960 Fretewell, John, of Bannebury, bailiff 3
4748490 2280061 2280061 defendant Pleystowe John   587960 587960 Pleystowe, John, of Bannebury, husbandman & son of Thomas Pleystowe of Grymmesbury, Nhants 1
4787457 2292147 2292147 defendant Mason Roger laborer 587960 587960 Mason, Roger, of Bannebury, laborer 1
4787463 2292149 2292149 defendant Mason Roger laborer 587960 587960 Mason, Roger, of Bannebury, laborer 1
4797285 2295325 2295325 defendant Maryot John tinker 587960 587960 Maryot, John, of Bannebury, tinker 1
4801726 2296721 2296721 defendant Coke Thomas   587960 587960 Coke, Thomas, of Bannebury, pie baker 0
4801727 2296721 2296721 defendant Beltham William carpenter 587960 587960 Beltham, William, of Bannebury, carpenter 1
4801729 2296721 2296721 defendant Smale John shoemaker 587960 587960 Smale, John, of Bannebury, shoemaker 3
4802317 2296915 2296915 plaintiff Aleyn William husbandman 587960 587960 Aleyn, William, of Bannebury, husbandman, on his own account 0
4802318 2296915 2296915 defendant Kyrkeby John weaver 587960 587960 Kyrkeby, John, of Bannebury, weaver 0
4807877 2298649 2298649 defendant Wythed Thomas gent 587960 587960 Wythed, Thomas, of Bannebury, gent 0
4812335 2299971 2299971 defendant Kyrkeby John weaver 587960 587960 Kyrkeby, John, of Bannebury, weaver 0
4812337 2299972 2299972 defendant Hawekes Richard gent 587960 587960 Hawekes, Richard, of Bannebury, gent 0
4812994 2300179 2300179 defendant Cheswyk William glover 587960 587960 Cheswyk, William, of Bannebury, glover 0
4813017 2300188 2300188 plaintiff Hawekes Richard   587960 587960 Hawekes, Richard, of Bannebury 0
4816880 2301383 2301383 defendant Ewyk Henry hosier 587960 587960 Ewyk, Henry, of Bannebury, hosier 1
4827322 2304592 2304592 defendant Broun Hugh butcher 587960 587960 Broun, Hugh, of Bannebury, butcher 2
4866930 2316619 2316619 defendant Tempul John spicer 587960 587960 Tempul, John, of Bannebury, spicer 0
4866931 2316619 2316619 defendant Harreys John fuller 587960 587960 Harreys, John, of Bannebury, fuller 1
4866932 2316619 2316619 defendant Smyth William   587960 587960 Smyth, William, of Bannebury, shepherd 2
4866934 2316619 2316619 defendant Kyrkeby Thomas weaver 587960 587960 Kyrkeby, Thomas, of Bannebury, weaver 4
4866935 2316620 2316620 plaintiff Hawekys Richard   587960 587960 Hawekys, Richard, of Bannebury 0
4873349 2318620 2318620 defendant Tascar Richard cordwainer 587960 587960 Tascar, Richard, of Bannebury, cordwainer 0
4873350 2318620 2318620 defendant Roger Ralph cordwainer 587960 587960 Roger, Ralph, of Bannebury, cordwainer 1
4880783 2320896 2320896 defendant Blakenale John dyer 587960 587960 Blakenale, John, of Bannebury, dyer 0
4880784 2320896 2320896 defendant Kirkeby John   587960 587960 Kirkeby, John, of Bannebury, weaver, son of Kyrkeby, John 1
4880786 2320897 2320897 defendant Blakenale John dyer 587960 587960 Blakenale, John, of Bannebury, dyer 0
4880787 2320897 2320897 defendant Kyrkeby John weaver 587960 587960 Kyrkeby, John, of Bannebury, weaver 1
4881675 2321167 2321167 plaintiff Danvers John esq 587960 587960 Danvers, John, of Bannebury, esq 1
4886883 2322751 2322751 defendant Broune Hugh butcher 587960 587960 Broune, Hugh, of Bannebury, butcher 0
4886884 2322751 2322751 defendant Broune Simon butcher 587960 587960 Broune, Simon, of Bannebury, butcher 1
4886885 2322751 2322751 defendant Swanlond Thomas painter 587960 587960 Swanlond, Thomas, of Bannebury, painter 2
4886888 2322751 2322751 defendant Sadeler Henry husbandman 587960 587960 Sadeler, Henry, of Bannebury, husbandman 5
4886889 2322751 2322751 defendant Sadeler Walter saddler 587960 587960 Sadeler, Walter, of Bannebury, saddler 6
4887336 2322873 2322873 defendant Kyng John hosier 587960 587960 Kyng, John, of Bannebury, hosier 0
4899973 2326631 2326631 defendant Glover William   587960 587960 Glover, William, of Bannebury, servant 0
4900944 2326923 2326923 defendant Whithed Thomas gent 587960 587960 Whithed, Thomas, of Bannebury, gent 3
4905486 2328312 2328312 defendant Kyrkeby Robert weaver 587960 587960 Kyrkeby, Robert, of Bannebury, weaver 0
4905492 2328314 2328314 defendant Skynner Hugh skinner 587960 587960 Skynner, Hugh, of Bannebury, skinner 1
4909259 2329439 2329439 defendant Broun William butcher 587960 587960 Broun, William, of Bannebury, butcher 1
4940060 2338919 2338919 plaintiff Danvers John   587960 587960 Danvers, John, of Bannebury 0
4946743 2340983 2340983 plaintiff Kyrkeby Thomas weaver 587960 587960 Kyrkeby, Thomas, of Bannebury, weaver 0
4946747 2340983 2340983 defendant Baret John husbandman 587960 587960 Baret, John, of Bannebury, husbandman 2
4946748 2340983 2340983 defendant Floures John fishmonger 587960 587960 Floures, John, of Bannebury, fishmonger 3
4949670 2341892 2341892 plaintiff Norcote Lawrence   587960 587960 Norcote, Lawrence, of Bannebury 0
4949672 2341893 2341893 plaintiff Norcote Lawrence   587960 587960 Norcote, Lawrence, of Bannebury 0
4951573 2342449 2342449 defendant Penred John mercer 587960 587960 Penred, John, of Bannebury, mercer 0
4957374 2344169 2344169 defendant Kyrkeby Thomas chapman 587960 587960 Kyrkeby, Thomas, of Bannebury, chapman 1
4959818 2344899 2344899 defendant Lyons Robert joiner 587960 587960 Lyons, Robert, of Bannebury, joiner 3
4959819 2344899 2344899 defendant Marche John fuller 587960 587960 Marche, John, of Bannebury, fuller 4
4963440 2345978 2345978 plaintiff Capron William draper 587960 587960 Capron, William, of Bannebury, draper 0
4963441 2345978 2345978 defendant Rode Richard fuller 587960 587960 Rode, Richard, of Bannebury, fuller 0
4983014 2351825 2351825 defendant Askell John cordwainer 587960 587960 Askell, John, of Bannebury, cordwainer 0
4983015 2351825 2351825 defendant Chamberleyn John cordwainer 587960 587960 Chamberleyn, John, of Bannebury, cordwainer 1
4984343 2352244 2352244 defendant Fuller John fuller 587960 587960 Fuller, John, of Bannebury, fuller 2

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);