names

181 rows where place_id = 591328

✎ 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
3594226 1865835 1865835 defendant Wrenne Adam yeoman 591328 591328 Wrenne, Adam, of Pakefeld, or of Kyrkeley, Suff, yeoman 0
3604083 1868944 1868944 defendant Feyth John mariner 591328 591328 Feyth, John, of Pakefeld, mariner 2
3605416 1869361 1869361 defendant Smyth Roger yeoman 591328 591328 Smyth, Roger, of Pakefeld, yeoman 0
3606224 1869615 1869615 defendant Neve John husbandman 591328 591328 Neve, John, of Pakefeld, husbandman 3
3606822 1869804 1869804 defendant Colyn Henry mariner 591328 591328 Colyn, Henry, of Pakefeld, mariner 0
3613606 1871901 1871901 defendant Swyft Robert fisherman 591328 591328 Swyft, Robert, of Pakefeld, fisherman 1
3613607 1871901 1871901 defendant Maddy John fisherman 591328 591328 Maddy, John, of Pakefeld, fisherman 2
3686413 1921905 1921905 defendant Yongys Robert butcher 591328 591328 Yongys, Robert, of Pakefeld, butcher 0
3691564 1923519 1923519 plaintiff Colby William   591328 591328 Colby, William, of Pakefeld 3
3702899 1927179 1927179 defendant Neve Miles shoemaker 591328 591328 Neve, Miles, of Pakefeld, shoemaker 0
3705681 1928059 1928059 plaintiff Colby William   591328 591328 Colby, William, of Pakefeld 2
3728408 1935131 1935131 defendant Langley John mariner 591328 591328 Langley, John, of Pakefeld, mariner 0
3734868 1937147 1937147 defendant Aradon Stephen mariner 591328 591328 Aradon, Stephen, of Pakefeld, mariner 1
3802050 1958538 1958538 defendant Brown Thomas mariner 591328 591328 Brown, Thomas, of Pakefeld, mariner 2
3816786 1963157 1963157 defendant Brown Thomas yeoman 591328 591328 Brown, Thomas, of Pakefeld, yeoman 0
3820861 1964417 1964417 defendant Brown Thomas mariner 591328 591328 Brown, Thomas, of Pakefeld, mariner 0
3828154 1966673 1966673 defendant Yonger Robert butcher 591328 591328 Yonger, Robert, of Pakefeld, butcher 1
3896128 1988908 1988908 defendant Rypyng Geoffrey laborer 591328 591328 Rypyng, Geoffrey, of Pakefeld, laborer 2
3901015 1990567 1990567 defendant Langley Michael husbandman 591328 591328 Langley, Michael, of Pakefeld, husbandman 0
3901592 1990758 1990758 defendant Bury Richard yeoman 591328 591328 Bury, Richard, of Pakefeld, yeoman 0
3901593 1990758 1990758 defendant Hardyng Edward laborer 591328 591328 Hardyng, Edward, of Pakefeld, laborer 1
3901594 1990758 1990758 defendant Rypyng Richard husbandman 591328 591328 Rypyng, Richard, of Pakefeld, husbandman 2
3911399 1994127 1994127 defendant Andrewes John husbandman 591328 591328 Andrewes, John, of Pakefeld, husbandman 0
3911400 1994127 1994127 defendant Gunner William mariner 591328 591328 Gunner, William, of Pakefeld, mariner 1
3935347 2002135 2002135 defendant Plowman William husbandman 591328 591328 Plowman, William, of Pakefeld, husbandman 1
3943411 2004811 2004811 defendant Johnson Christopher mariner 591328 591328 Johnson, Christopher, of Pakefeld, mariner 1
3968548 2013633 2013633 defendant Deryng Edmund   591328 591328 Deryng, Edmund, of Pakefeld, mason 1
4026793 2034229 2034229 defendant Porter Robert husbandman 591328 591328 Porter, Robert, of Pakefeld, husbandman 0
4071532 2050112 2050112 defendant West Robert husbandman 591328 591328 West, Robert, of Pakefeld, husbandman 1
4208502 2098526 2098526 defendant Burrye Robert husbandman 591328 591328 Burrye, Robert, of Pakefeld, husbandman 1
4397813 2163846 2163846 defendant Skete Robert innholder 591328 591328 Skete, Robert, of Pakefeld, innholder 1
4465634 2189926 2189926 defendant Peronel John   591328 591328 Peronel, John, of Pakefeld 1
4511715 2204112 2204112 defendant Bocher Thomas   591328 591328 Bocher, Thomas, of Pakefeld 1
4522318 2207327 2207327 plaintiff Boof John   591328 591328 Boof, John, of Pakefeld 1
4531672 2210169 2210169 plaintiff Person Geoffrey   591328 591328 Person, Geoffrey, of Pakefeld 0
4545322 2214459 2214459 defendant Esterlyng Henry   591328 591328 Esterlyng, Henry, of Pakefeld 3
4554589 2217363 2217363 defendant del Wode Thomas butcher 591328 591328 del Wode, Thomas, of Pakefeld, butcher 0
4556073 2217841 2217841 defendant del Wode Thomas butcher 591328 591328 del Wode, Thomas, of Pakefeld, butcher 0
4559253 2218849 2218849 defendant Faireweder Henry shipman 591328 591328 Faireweder, Henry, of Pakefeld, shipman 0
4559273 2218852 2218852 defendant Faireweder Henry shipman 591328 591328 Faireweder, Henry, of Pakefeld, shipman 4
4577205 2224386 2224386 defendant Brunham Hugh   591328 591328 Brunham, Hugh, of Pakefeld 1
4591558 2228721 2228721 defendant Bocher John   591328 591328 Bocher, John, of Pakefeld 0
4642642 2243965 2243965 defendant Smyth Roger   591328 591328 Smyth, Roger, of Pakefeld 1
4663052 2249909 2249909 defendant Bocher Thomas husbandman 591328 591328 Bocher, Thomas, of Pakefeld, husbandman 3
4664957 2250520 2250520 defendant Longe Walter husbandman 591328 591328 Longe, Walter, of Pakefeld, husbandman 5
4682851 2260252 2260252 plaintiff On the hill Robert   591328 591328 On the hill, Robert, of Pakefeld 0
4682855 2260253 2260253 plaintiff on the Hill Robert   591328 591328 on the Hill, Robert, of Pakefeld 0
4704296 2266720 2266720 plaintiff Hunte Walter   591328 591328 Hunte, Walter, of Pakefeld 0
4705284 2267025 2267025 plaintiff Koyth Geoffrey   591328 591328 Koyth, Geoffrey, of Pakefeld 0
4721819 2272156 2272156 defendant Smyth Geoffrey yeoman 591328 591328 Smyth, Geoffrey, of Pakefeld, yeoman 0
4739058 2277308 2277308 defendant Sewale Ralph yeoman 591328 591328 Sewale, Ralph, of Pakefeld, yeoman 1
4745417 2279166 2279166 defendant Gyle Thomas butcher 591328 591328 Gyle, Thomas, of Pakefeld, butcher 4
4747343 2279726 2279726 defendant Cutman Robert shipman 591328 591328 Cutman, Robert, of Pakefeld, shipman 0
4747344 2279726 2279726 defendant Cutman John shipman & son of Robert 591328 591328 Cutman, John, of Pakefeld, shipman & son of Robert 1
4758541 2283051 2283051 defendant Brunham Hugh husbandman 591328 591328 Brunham, Hugh, of Pakefeld, husbandman 0
4763782 2284661 2284661 defendant Cressy Thomas yeoman 591328 591328 Cressy, Thomas, of Pakefeld, yeoman 0
4769328 2286381 2286381 defendant Sewale Ralph husbandman 591328 591328 Sewale, Ralph, of Pakefeld, husbandman 0
4781761 2290309 2290309 defendant Gerveys John clerk 591328 591328 Gerveys, John, of Pakefeld, clerk 2
4787513 2292166 2292166 defendant Cressy Thomas yeoman 591328 591328 Cressy, Thomas, of Pakefeld, yeoman 0
4795267 2294668 2294668 defendant Fraunt Henry clerk 591328 591328 Fraunt, Henry, of Pakefeld, clerk 0
4820413 2302456 2302456 defendant Pye John gent 591328 591328 Pye, John, of Pakefeld, gent 0
4866895 2316608 2316608 defendant Norman Robert baker 591328 591328 Norman, Robert, of Pakefeld, baker 0
4868105 2316997 2316997 defendant Jerveys John clerk 591328 591328 Jerveys, John, of Pakefeld, clerk 0
4868106 2316997 2316997 defendant Jerveys John sherman 591328 591328 Jerveys, John, of Pakefeld, sherman 1
4874243 2318889 2318889 plaintiff Pye John   591328 591328 Pye, John, of Pakefeld 0
4878411 2320191 2320191 defendant Sparwe or Sparowe John yeoman 591328 591328 Sparwe or Sparowe, John, of Pakefeld, yeoman 0
4904656 2328064 2328064 defendant Profete Thomas butcher 591328 591328 Profete, Thomas, of Pakefeld, butcher 1
4933986 2337011 2337011 defendant Busgar John husbandman 591328 591328 Busgar, John, of Pakefeld, husbandman 0
4933990 2337011 2337011 defendant Mason Richard husbandman 591328 591328 Mason, Richard, of Pakefeld, husbandman 4
4944034 2340103 2340103 defendant Prophete Thomas butcher 591328 591328 Prophete, Thomas, of Pakefeld, butcher 0
4968099 2347406 2347406 defendant Graunt Henry clerk 591328 591328 Graunt, Henry, of Pakefeld, clerk 0
4986766 2352979 2352979 defendant Garveys John husbandman 591328 591328 Garveys, John, of Pakefeld, husbandman 1
5021947 2363314 2363314 defendant Hykkys Thomas shipman 591328 591328 Hykkys, Thomas, of Pakefeld, shipman 0
5022518 2363487 2363487 defendant Rothenhale William husbandman 591328 591328 Rothenhale, William, of Pakefeld, husbandman 0
5025720 2364426 2364426 defendant Eykle or Jygyll John mariner 591328 591328 Eykle or Jygyll, John, of Pakefeld, mariner 0
5025721 2364426 2364426 defendant Jygyll William mariner 591328 591328 Jygyll, William, of Pakefeld, mariner 1
5033595 2366712 2366712 plaintiff Spaurhall Roger   591328 591328 Spaurhall, Roger, of Pakefeld 0
5092435 2384166 2384166 defendant Coyte Geoffrey (legal representative) 591328 591328 Coyte, Geoffrey, of Pakefeld, executors of 0
5092436 2384166 2384166 defendant Coyte Joan widow 591328 591328 (Coyte, Joan, of Pakefeld, widow 1
5092439 2384166 2384166 defendant Chirche Agnes widow 591328 591328 Chirche, Agnes, of Pakefeld, widow 4
5117815 2391640 2391640 defendant Rothenhale Henry yeoman 591328 591328 Rothenhale, Henry, of Pakefeld, yeoman 1
5118922 2391965 2391965 defendant Gyle Thomas butcher 591328 591328 Gyle, Thomas, of Pakefeld, butcher 2
5127541 2394535 2394535 defendant Clerk John butcher 591328 591328 Clerk, John, of Pakefeld, butcher 1
5166968 2406071 2406071 plaintiff Cheston Thomas   591328 591328 Cheston, Thomas, of Pakefeld 0
5170709 2407154 2407154 defendant Kemster Alice widow 591328 591328 Kemster, Alice, of Pakefeld, widow 2
5196749 2414797 2414797 defendant Kemster Alice widow 591328 591328 Kemster, Alice, of Pakefeld, widow 2
5203232 2416710 2416710 plaintiff Cheston Thomas   591328 591328 Cheston, Thomas, of Pakefeld 0
5222982 2422441 2422441 plaintiff Neve John husbandman 591328 591328 Neve, John, of Pakefeld, husbandman 0
5222983 2422441 2422441 defendant Spencer Waren shipman 591328 591328 Spencer, Waren,of Pakefeld, shipman 0
5225685 2423183 2423183 defendant Marshall Thomas mariner 591328 591328 Marshall, Thomas, of Pakefeld, mariner 0
5276856 2438314 2438314 defendant Swyft John mariner 591328 591328 Swyft, John, of Pakefeld, mariner 1
5280035 2439233 2439233 defendant Swyft Simon mariner 591328 591328 Swyft, Simon, of Pakefeld, mariner 0
5284899 2440605 2440605 defendant Soleny John mriner 591328 591328 Soleny, John, of Pakefeld, mriner 0
5284900 2440605 2440605 defendant Standard Goffrey chandler 591328 591328 Standard, Goffrey, of Pakefeld, chandler 1
5293340 2443034 2443034 defendant Coleyn John shipman 591328 591328 Coleyn, John, of Pakefeld, shipman 1
5293341 2443034 2443034 defendant Swyft John shipman 591328 591328 Swyft, John, of Pakefeld, shipman 2
5293358 2443038 2443038 defendant Wrenne Adam mariner 591328 591328 Wrenne, Adam, of Pakefeld, mariner 0
5294953 2443515 2443515 defendant Hykelyng John   591328 591328 Hykelyng, John, of Pakefeld, mariner, son of Hykelyng, Nicholas 0
5298501 2444540 2444540 defendant Chyldrews John husbandman 591328 591328 Chyldrews, John, of Pakefeld, husbandman 1
5298502 2444540 2444540 defendant Hyklyng John husbandman 591328 591328 Hyklyng, John, of Pakefeld, husbandman 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);