names

127 rows where place_id = 588412

✎ 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
3594396 1865881 1865881 defendant Bolcompe Thomas turner 588412 588412 Bolcompe, Thomas, of Westwell, turner 0
3594398 1865882 1865882 defendant Bolcompe Thomas turner 588412 588412 Bolcompe, Thomas, of Westwell, turner 0
3600571 1867824 1867824 defendant Amys William yeoman 588412 588412 Amys, William, of Westwell, yeoman 0
3602710 1868510 1868510 defendant Mucche William tailor 588412 588412 Mucche, William, of Westwell, tailor 0
3605151 1869274 1869274 defendant Carewe John butcher 588412 588412 Carewe, John, of Westwell, butcher 0
3610496 1870946 1870946 defendant Iden Thomas yeoman 588412 588412 Iden, Thomas, of Westwell, yeoman 3
3617969 1873245 1873245 defendant Alcher Henry yeoman 588412 588412 Alcher, Henry, of Westwell, yeoman 1
3618026 1873258 1873258 defendant Gotley Simon husbandman 588412 588412 Gotley, Simon, of Westwell, husbandman 1
3618030 1873260 1873260 defendant Breche Richard husbandman 588412 588412 Breche, Richard, of Westwell, husbandman 0
3633297 1905230 1905230 defendant Fuller John smith 588412 588412 Fuller, John, of Westwell, smith 3
3687062 1922126 1922126 defendant Baldok Gilbert yeoman 588412 588412 Baldok, Gilbert, of Westwell, yeoman 0
3687064 1922127 1922127 defendant Baldok Gilbert yeoman 588412 588412 Baldok, Gilbert, of Westwell, yeoman 0
3696675 1925185 1925185 defendant Questod Robert yeoman 588412 588412 Questod, Robert, of Westwell, yeoman 2
3743702 1939911 1939911 defendant A More John laborer 588412 588412 A More, John, of Westwell, laborer 4
3765159 1946764 1946764 defendant Harrys Simon husbandman 588412 588412 Harrys, Simon, of Westwell, husbandman 0
3775472 1950072 1950072 defendant Atwell Augustine yeoman 588412 588412 Atwell, Augustine, of Westwell, yeoman 0
3820948 1964446 1964446 defendant Talbott Brian yeoman 588412 588412 Talbott, Brian, of Westwell, yeoman 1
3820954 1964448 1964448 defendant Talbott Brenn yeoman 588412 588412 Talbott, Brenn, of Westwell, yeoman 2
3846298 1972398 1972398 defendant Raynard Nicholas yeoman 588412 588412 Raynard, Nicholas, of Westwell, yeoman 0
3864714 1978393 1978393 defendant Harry John husbandman 588412 588412 Harry, John, of Westwell, husbandman 0
3864938 1978477 1978477 defendant at Well Augustine yeoman 588412 588412 at Well, Augustine, of Westwell, yeoman 0
3874719 1981761 1981761 defendant Goteley Alice widow 588412 588412 Goteley, Alice, of Westwell, widow 0
3874720 1981761 1981761 defendant Goteley Simon husbandman 588412 588412 Goteley, Simon, of Westwell, husbandman 1
3898813 1989805 1989805 defendant Baldocke William husbandman 588412 588412 Baldocke, William, of Westwell, husbandman 1
3945165 2005403 2005403 defendant Well or Welles Thomas yeoman 588412 588412 Well or Welles, Thomas, of Westwell, yeoman 0
3985342 2019515 2019515 defendant Rasell Thomas yeoman 588412 588412 Rasell, Thomas, of Westwell, yeoman 0
3996528 2023519 2023519 plaintiff Deale Anthony yeoman 588412 588412 Deale, Anthony, of Westwell, yeoman 0
3998652 2024256 2024256 defendant Rigden John yeoman 588412 588412 Rigden, John, of Westwell, yeoman 0
4023476 2033104 2033104 defendant Crane Adrian yeoman 588412 588412 Crane, Adrian, of Westwell, yeoman 1
4029585 2035218 2035218 defendant Whytfyld Cuthbert husbandman 588412 588412 Whytfyld, Cuthbert, of Westwell, husbandman 1
4033905 2036778 2036778 defendant Halom Ralph (legal representative) 588412 588412 Halom, Ralph, of Westwell, yeoman, executors of 0
4045738 2040920 2040920 defendant Crane William husbandman 588412 588412 Crane, William, of Westwell, or of Hardyngham, husbandman 1
4045741 2040921 2040921 defendant Cranem William or of Hardyngham, Norf, husbandman 588412 588412 Cranem William, of Westwell, or of Hardyngham, Norf, husbandman 1
4087164 2055698 2055698 defendant Newstrete John clothier 588412 588412 Newstrete, John, of Westwell, clothier 1
4130879 2071357 2071357 defendant Rassall Robert yeoman 588412 588412 Rassall, Robert, of Westwell, yeoman 0
4277835 2122173 2122173 defendant (not given) David rector of Ryce 588412 588412 Ryce, David, of Westwell, rector of Westwell, Oxon 0
4290573 2126686 2126686 defendant Rasell Robert husbandman 588412 588412 Rasell, Robert, of Westwell, husbandman 3
4322784 2138038 2138038 defendant Austen Nicholas yeoman 588412 588412 Austen, Nicholas, of Westwell, yeoman 0
4324665 2138641 2138641 defendant Millen Robert yeoman 588412 588412 Millen, Robert, of Westwell, yeoman 0
4429799 2174103 2174103 defendant Dekessone Adam   588412 588412 Dekessone, Adam, of Westwell 0
4487083 2196683 2196683 defendant Bakere Roger skinner 588412 588412 Bakere, Roger, of Westwell, skinner 0
4518729 2206233 2206233 defendant Burgeys John   588412 588412 Burgeys, John, of Westwell 0
4518733 2206233 2206233 defendant Saundre John   588412 588412 Saundre, John, of Westwell 4
4543573 2213881 2213881 defendant atte Leghe Richard   588412 588412 atte Leghe, Richard, of Westwell 1
4592159 2228903 2228903 defendant Stodham William   588412 588412 Stodham, William, of Westwell 0
4597545 2230478 2230478 defendant Gybbes John   588412 588412 Gybbes, John, of Westwell 0
4599669 2231111 2231111 defendant Symon Richard   588412 588412 Symon, Richard, of Westwell 0
4613564 2235258 2235258 defendant Southeye William   588412 588412 Southeye, William, of Westwell 0
4613570 2235259 2235259 defendant Southeye William   588412 588412 Southeye, William, of Westwell 0
4696353 2264339 2264339 defendant Clerk John smith 588412 588412 Clerk, John, of Westwell, smith 1
4696354 2264339 2264339 defendant Ram John smith 588412 588412 Ram, John, of Westwell, smith 2
4721525 2272064 2272064 defendant Carowey John smith 588412 588412 Carowey, John, of Westwell, smith 1
4759159 2283209 2283209 defendant Syflete Richard smith 588412 588412 Syflete, Richard, of Westwell, smith 0
4765579 2285224 2285224 defendant Idenne William gent 588412 588412 Idenne, William, of Westwell, gent 0
4806280 2298171 2298171 defendant Kynee John yeoman 588412 588412 Kynee, John, of Westwell, yeoman 0
4811246 2299627 2299627 defendant Gayndon John   588412 588412 Gayndon, John, of Westwell, nail worker 0
4819944 2302314 2302314 defendant Sedelyde Richard smith 588412 588412 Sedelyde, Richard, of Westwell, smith 0
4824357 2303681 2303681 defendant atte wode Thomas laborer 588412 588412 atte wode, Thomas, of Westwell, laborer 0
4855968 2313240 2313240 defendant Sandyr Nicholas   588412 588412 Sandyr, Nicholas, of Westwell, woollen weaver 0
4874059 2318827 2318827 defendant Northbury Robert laborer 588412 588412 Northbury, Robert, of Westwell, laborer 0
4893800 2324756 2324756 defendant Sandre Nicholas weaver 588412 588412 Sandre, Nicholas, of Westwell, weaver 0
4902219 2327301 2327301 defendant Chapman John tanner 588412 588412 Chapman, John, of Westwell, tanner 0
4911130 2329993 2329993 defendant Gotle William laborer 588412 588412 Gotle, William, of Westwell, laborer 0
4912432 2330393 2330393 defendant Sander Nicholas weaver 588412 588412 Sander, Nicholas, of Westwell, weaver 0
4916970 2331811 2331811 defendant Benynden John laborer 588412 588412 Benynden, John, of Westwell, laborer 0
4917999 2332144 2332144 defendant Breche John laborer 588412 588412 Breche, John, of Westwell, laborer 0
4931992 2336395 2336395 plaintiff Webbe Thomas   588412 588412 Webbe, Thomas, of Westwell, 0
4931993 2336395 2336395 defendant Mylon William husbandman 588412 588412 Mylon, William, of Westwell, husbandman 0
4931994 2336395 2336395 defendant Mylon Walter laborer 588412 588412 Mylon, Walter, of Westwell, laborer 1
4932424 2336535 2336535 defendant Benet John fuller 588412 588412 Benet, John, of Westwell, fuller 1
4935798 2337587 2337587 defendant Maltstare Nicholas   588412 588412 Maltstare, Nicholas, of Westwell, servant 1
4959211 2344721 2344721 defendant Kyngeslond Simon husbandman 588412 588412 Kyngeslond, Simon, of Westwell, husbandman 0
4978819 2350617 2350617 defendant Buns Thomas farmer 588412 588412 Buns, Thomas, of Westwell, farmer 0
4980351 2351067 2351067 defendant Bret Thomas butcher 588412 588412 Bret, Thomas, of Westwell, butcher 1
4999119 2356614 2356614 defendant Rokke John husbandman 588412 588412 Rokke, John, of Westwell, husbandman 0
5027524 2364928 2364928 defendant Hacche Richard husbandman 588412 588412 Hacche, Richard, of Westwell, husbandman 3
5028269 2365144 2365144 defendant Martyll Richard chaplain 588412 588412 Martyll, Richard, of Westwell, chaplain 0
5061659 2375078 2375078 defendant Pikerell Thomas husbandman 588412 588412 Pikerell, Thomas, of Westwell, husbandman 0
5061660 2375078 2375078 defendant Norbury Robert husbandman 588412 588412 Norbury, Robert, of Westwell, husbandman 1
5061929 2375166 2375166 plaintiff Hamton John   588412 588412 Hamton, John, of Westwell 1
5061930 2375166 2375166 defendant Iden William gent 588412 588412 Iden, William, of Westwell, gent 0
5063031 2375477 2375477 defendant Norbery Robert laborer 588412 588412 Norbery, Robert, of Westwell, laborer 0
5063982 2375757 2375757 defendant Norbury Robert husbandman 588412 588412 Norbury, Robert, of Westwell, husbandman 0
5078239 2379977 2379977 defendant atte Water John tanner 588412 588412 atte Water, John, of Westwell, tanner 4
5080821 2380755 2380755 defendant Jurd- John butcher 588412 588412 Jurd-, John, of Westwell, butcher 0
5087261 2382654 2382654 defendant Pykerell Thomas husbandman 588412 588412 Pykerell, Thomas, of Westwell, husbandman 0
5096776 2385488 2385488 defendant Crouche Stephen miller 588412 588412 Crouche, Stephen, of Westwell, miller 0
5109797 2389296 2389296 defendant Prat William husbandman 588412 588412 Prat, William, of Westwell, husbandman 1
5145351 2399784 2399784 defendant Webbe Richard laborer 588412 588412 Webbe, Richard, of Westwell, laborer 0
5145353 2399785 2399785 defendant Webbe Thomas smith 588412 588412 Webbe, Thomas, of Westwell, smith 0
5150471 2401271 2401271 defendant Webbe Thomas smith 588412 588412 Webbe, Thomas, of Westwell, smith 2
5168984 2406656 2406656 defendant Webbe Thomas smith 588412 588412 Webbe, Thomas, of Westwell, smith 2
5223411 2422540 2422540 defendant Webbe Thomas husbandman 588412 588412 Webbe, Thomas, of Westwell, husbandman 0
5271049 2436627 2436627 defendant Hampton John husbandman 588412 588412 Hampton, John, of Westwell, husbandman 0
5301971 2445544 2445544 defendant Amys William yeoman 588412 588412 Amys, William, of Westwell, yeoman 0
5301972 2445544 2445544 defendant Gybbe William husbandman 588412 588412 Gybbe, William, of Westwell, husbandman 1
5317765 2450399 2450399 defendant Brette John butcher 588412 588412 Brette, John, of Westwell, butcher 0
5317766 2450399 2450399 defendant Cullyng William   588412 588412 Cullyng, William, of Westwell, coverlet weaver 1
5325333 2452664 2452664 defendant Wylles John husbandman 588412 588412 Wylles, John, of Westwell, husbandman 0
5348108 2459552 2459552 defendant Stranton or Strauton John smith 588412 588412 Stranton or Strauton, John, of Westwell, smith 1

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