names

344 rows where place_id = 780398

✎ 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
4667783 2255631 2255631 defendant Brygge Thomas de   780398 780398 Brygge, Thomas de, of Bishop's Lenn, Norf, burgess & merchant 0
4667787 2255632 2255632 defendant Brygge Thomas de merchant 780398 780398 Brygge, Thomas de, of Bishop's Lenn, Norf, merchant 0
4671515 2256736 2256736 defendant Brygge Thomas yeoman 780398 780398 Brygge, Thomas, of Bishop's Lenn, Norf, yeoman 0
4675190 2257852 2257852 defendant Fremle John yeoman 780398 780398 Fremle, John, of Bishop's Lenn, Norf, yeoman 0
4675193 2257853 2257853 defendant Fremel John yeoman 780398 780398 Fremel, John, of Bishop's Lenn, Norf, yeoman 0
4679751 2259283 2259283 defendant Bylneye John   780398 780398 Bylneye, John, of Bishop's Lenn, Norf, burgess 0
4680896 2259647 2259647 defendant Baret William merchant 780398 780398 Baret, William, of Bishop's Lenn, Norf, merchant 0
4691658 2262925 2262925 defendant Clyr Edmund dyer 780398 780398 Clyr, Edmund, of Bishop's Lenn, Norf, dyer 0
4695944 2264217 2264217 defendant Walpoll John merchant 780398 780398 Walpoll, John, of Bishop's Lenn, Norf, merchant 1
4697599 2264737 2264737 defendant Couche John goldsmith 780398 780398 Couche, John, of Bishop's Lenn, Norf, goldsmith 0
4698970 2265155 2265155 defendant Lukwyke William glasier 780398 780398 Lukwyke, William, of Bishop's Lenn, Norf, glasier 0
4707066 2267594 2267594 defendant Knyght Stephen merchant 780398 780398 Knyght, Stephen, of Bishop's Lenn, Norf, merchant 0
4717632 2270850 2270850 defendant Staunford John husbandman 780398 780398 Staunford, John, of Bishop's Lenn, Norf, husbandman 0
4718222 2271039 2271039 defendant Grygge Thomas   780398 780398 Grygge, Thomas, of Bishop's Lenn, Norf, burgess 0
4720881 2271864 2271864 defendant Walsoken Adam draper 780398 780398 Walsoken, Adam, of Bishop's Lenn, Norf, draper 2
4722498 2272354 2272354 defendant Couche John goldsmith 780398 780398 Couche, John, of Bishop's Lenn, Norf, goldsmith 0
4723841 2272760 2272760 defendant Paynot Thomas   780398 780398 Paynot, Thomas, of Bishop's Lenn, Norf, wool man 1
4725855 2273373 2273373 defendant Sisterne John merchant 780398 780398 Sisterne, John, of Bishop's Lenn, Norf, merchant 3
4729686 2274496 2274496 defendant Bedyngham William merchant 780398 780398 Bedyngham, William, of Bishop's Lenn, Norf, merchant 0
4730672 2274792 2274792 defendant Collys Henry chandler 780398 780398 Collys, Henry, of Bishop's Lenn, Norf, chandler 0
4734809 2276042 2276042 defendant Frank Nicholas brewer 780398 780398 Frank, Nicholas, of Bishop's Lenn, Norf, brewer 1
4737181 2276748 2276748 defendant atte Wode John chapman 780398 780398 atte Wode, John, of Bishop's Lenn, Norf, chapman 3
4737186 2276749 2276749 defendant atte Wode John chapman 780398 780398 atte Wode, John, of Bishop's Lenn, Norf, chapman 3
4739308 2277380 2277380 defendant Badyngham Ralph merchant 780398 780398 Badyngham, Ralph, of Bishop's Lenn, Norf, merchant 4
4741924 2278132 2278132 defendant Fokes William yeoman 780398 780398 Fokes, William, of Bishop's Lenn, Norf, yeoman 1
4743437 2278610 2278610 defendant Amy John   780398 780398 Amy, John, of Bishop's Lenn, Norf, chaplain, formerly of Bury 1
4747656 2279821 2279821 defendant Warnere John vintner 780398 780398 Warnere, John, of Bishop's Lenn, Norf, vintner 0
4750579 2280655 2280655 defendant Clyffe Simon dyer 780398 780398 Clyffe, Simon, of Bishop's Lenn, Norf, dyer 0
4752024 2281085 2281085 defendant Dentry Roger yeoman 780398 780398 Dentry, Roger, of Bishop's Lenn, Norf, yeoman 4
4760441 2283619 2283619 defendant Godewyn John husbandman 780398 780398 Godewyn, John, of Bishop's Lenn, Norf, husbandman 1
4762386 2284218 2284218 defendant Whyte Thomas   780398 780398 Whyte, Thomas, of Bishop's Lenn, Norf, parson of the church of Swepston, Lincoln diocese 1
4764344 2284844 2284844 defendant Konys or Lonys Thomas chaplain 780398 780398 Konys or Lonys, Thomas, of Bishop's Lenn, Norf, chaplain 1
4767713 2285883 2285883 defendant Fouldon Denis ostler 780398 780398 Fouldon, Denis, of Bishop's Lenn, Norf, ostler 1
4768906 2286255 2286255 defendant Braunche William esq 780398 780398 Braunche, William, of Bishop's Lenn, Norf, esq 0
4773047 2287541 2287541 defendant Wych William yeoman 780398 780398 Wych, William, of Bishop's Lenn, Norf, yeoman 2
4803958 2297420 2297420 defendant Taverner Richard merchant 780398 780398 Taverner, Richard, of Bishop's Lenn, Norf, merchant 0
4804809 2297704 2297704 defendant Tylney Robert   780398 780398 Tylney, Robert, of Bishop's Lenn, Norf, burgess 0
4805458 2297918 2297918 defendant Kyverton William chapman 780398 780398 Kyverton, William, of Bishop's Lenn, Norf, chapman 0
4810378 2299393 2299393 defendant Morley John merchant 780398 780398 Morley, John, of Bishop's Lenn, Norf, merchant 0
4810804 2299503 2299503 defendant Chestyrfeld John shipman 780398 780398 Chestyrfeld, John, of Bishop's Lenn, Norf, shipman 0
4811437 2299687 2299687 defendant Bulwer William   780398 780398 Bulwer, William, of Bishop's Lenn, Norf, coverlet weaver 0
4814332 2300589 2300589 defendant Kelle John dyer 780398 780398 Kelle, John, of Bishop's Lenn, Norf, dyer 0
4814338 2300592 2300592 defendant Gresseman Peter   780398 780398 Gresseman, Peter, of Bishop's Lenn, Norf, patyn maker 0
4814966 2300791 2300791 defendant Frenshhman Roger toller 780398 780398 Frenshhman, Roger, of Bishop's Lenn, Norf, toller 0
4814971 2300792 2300792 defendant Goolde William   780398 780398 Goolde, William, of Bishop's Lenn, Norf, toll man 0
4817727 2301631 2301631 defendant Brod Robert   780398 780398 Brod, Robert, of Bishop's Lenn, Norf, burgess & glasier 0
4822048 2302972 2302972 defendant Walsokyn Adam draper 780398 780398 Walsokyn, Adam, of Bishop's Lenn, Norf, draper 0
4824308 2303667 2303667 defendant Wirmyngey John yeoman 780398 780398 Wirmyngey, John, of Bishop's Lenn, Norf, yeoman 0
4824312 2303668 2303668 defendant Wyrmyngey John yeoman 780398 780398 Wyrmyngey, John, of Bishop's Lenn, Norf, yeoman 0
4824372 2303684 2303684 defendant Wyghtfeld Walter shoemaker 780398 780398 Wyghtfeld, Walter, of Bishop's Lenn, Norf, shoemaker 1
4826445 2304307 2304307 defendant Pynder Robert butcher 780398 780398 Pynder, Robert, of Bishop's Lenn, Norf, butcher 0
4827302 2304586 2304586 defendant Morley John merchant 780398 780398 Morley, John, of Bishop's Lenn, Norf, merchant 0
4828161 2304850 2304850 defendant Crosse William merchant 780398 780398 Crosse, William, of Bishop's Lenn, Norf, merchant 0
4829362 2305223 2305223 defendant Storm William husbandman 780398 780398 Storm, William, of Bishop's Lenn, Norf, husbandman 0
4830268 2305503 2305503 defendant Mollesworth William merchant 780398 780398 Mollesworth, William, of Bishop's Lenn, Norf, merchant 0
4834379 2306759 2306759 defendant Coker John   780398 780398 Coker, John, of Bishop's Lenn, Norf, mechant 1
4836220 2307309 2307309 defendant Fakes Richard   780398 780398 Fakes, Richard, of Bishop's Lenn, Norf 4
4836525 2307396 2307396 defendant Feltwelle John dyer 780398 780398 Feltwelle, John, of Bishop's Lenn, Norf, dyer 0
4837570 2307684 2307684 defendant Spensere Thomas shipman 780398 780398 Spensere, Thomas, of Bishop's Lenn, Norf, shipman 1
4844281 2309719 2309719 defendant Kynnorton John merchant 780398 780398 Kynnorton, John, of Bishop's Lenn, Norf, merchant 1
4907632 2328952 2328952 defendant Franke Richard merchant & burgess 780398 780398 Franke, Richard, of Bishop's Lenn, Norf, merchant & burgess 0
4911772 2330182 2330182 defendant Impyngham John yeoman 780398 780398 Impyngham, John, of Bishop's Lenn, Norf, yeoman 1
4912048 2330271 2330271 defendant Flete John   780398 780398 Flete, John, of Bishop's Lenn, Norf, brass worker 0
4914190 2330952 2330952 defendant Mollesworth William merchant 780398 780398 Mollesworth, William, of Bishop's Lenn, Norf, merchant 0
4914192 2330953 2330953 defendant Herman William merchant & burgess 780398 780398 Herman, William, of Bishop's Lenn, Norf, merchant & burgess 0
4914205 2330957 2330957 defendant Mollesworth William merchant 780398 780398 Mollesworth, William, of Bishop's Lenn, Norf, merchant 0
4914207 2330958 2330958 defendant Herman William merchant & burgess 780398 780398 Herman, William, of Bishop's Lenn, Norf, merchant & burgess 0
4914209 2330959 2330959 defendant Herman William merchant & burgess 780398 780398 Herman, William, of Bishop's Lenn, Norf, merchant & burgess 0
4914776 2331138 2331138 defendant fyssher John fisher 780398 780398 fyssher, John, of Bishop's Lenn, Norf, fisher 1
4914810 2331146 2331146 defendant Mollesworth William merchant 780398 780398 Mollesworth, William, of Bishop's Lenn, Norf, merchant 0
4914814 2331147 2331147 defendant Mollesworth William merchant 780398 780398 Mollesworth, William, of Bishop's Lenn, Norf, merchant 0
4915511 2331350 2331350 defendant Frere Thomas vintner 780398 780398 Frere, Thomas, of Bishop's Lenn, Norf, vintner 0
4918218 2332217 2332217 plaintiff Greyne John weaver 780398 780398 Greyne, John, of Bishop's Lenn, Norf, weaver 0
4919840 2332712 2332712 defendant Frank Richard merchant 780398 780398 Frank, Richard, of Bishop's Lenn, Norf, merchant 0
4923516 2333788 2333788 defendant Smyth William clerk 780398 780398 Smyth, William, of Bishop's Lenn, Norf, clerk 0
4924652 2334147 2334147 defendant Paschelee Robert merchant 780398 780398 Paschelee, Robert, of Bishop's Lenn, Norf, merchant 0
4924747 2334175 2334175 defendant Flete---- John   780398 780398 Flete----, John, of Bishop's Lenn, Norf, brass worker 0
4927528 2335046 2335046 defendant Barle Robert chapman 780398 780398 (Barle, Robert, of Bishop's Lenn, Norf, chapman 1
4927532 2335047 2335047 defendant Barle Robert chapman 780398 780398 (Barle, Robert, of Bishop's Lenn, Norf, chapman 1
4927533 2335047 2335047 defendant Coteler Henry cutler 780398 780398 Coteler, Henry, of Bishop's Lenn, Norf, cutler 2
4928104 2335222 2335222 defendant Frere Thomas merchant 780398 780398 Frere, Thomas, of Bishop's Lenn, Norf, merchant 0
4928110 2335223 2335223 defendant Frere Thomas merchant 780398 780398 Frere, Thomas, of Bishop's Lenn, Norf, merchant 0
4930313 2335880 2335880 defendant Mellesworth William merchant 780398 780398 Mellesworth, William, of Bishop's Lenn, Norf, merchant 0
4930457 2335926 2335926 defendant Belt Robert gent 780398 780398 Belt, Robert, of Bishop's Lenn, Norf, gent 3
4930927 2336069 2336069 defendant Methewold John solder 780398 780398 Methewold, John, of Bishop's Lenn, Norf, solder 0
4931157 2336131 2336131 defendant Brandon Robert merchant 780398 780398 Brandon, Robert, of Bishop's Lenn, Norf, merchant 2
4931180 2336136 2336136 defendant Brandon Robert merchant 780398 780398 Brandon, Robert, of Bishop's Lenn, Norf, merchant 2
4987036 2353064 2353064 defendant Wylly Roger mariner 780398 780398 Wylly, Roger, of Bishop's Lenn, Norf, mariner 2
4988292 2353468 2353468 defendant Aleyn Stephen merchant 780398 780398 Aleyn, Stephen, of Bishop's Lenn, Norf, merchant 0
4990319 2354013 2354013 defendant Fraunsham John baker 780398 780398 Fraunsham, John, of Bishop's Lenn, Norf, baker 3
4990326 2354014 2354014 defendant Fraunsham John baker 780398 780398 Fraunsham, John, of Bishop's Lenn, Norf, baker 3
4991295 2354283 2354283 defendant Lawnde John merchant 780398 780398 Lawnde, John, of Bishop's Lenn, Norf, merchant 1
4993456 2354912 2354912 defendant Palmer Nicholas shoemaker 780398 780398 Palmer, Nicholas, of Bishop's Lenn, Norf, shoemaker 0
4996100 2355692 2355692 defendant Freman Thomas chapman 780398 780398 Freman, Thomas, of Bishop's Lenn, Norf, chapman 1
4998839 2356537 2356537 defendant Derby Thomas   780398 780398 Derby, Thomas, of Bishop's Lenn, Norf, bell founder 0
4999972 2356872 2356872 defendant Colchestre John merchant 780398 780398 (Colchestre, John, of Bishop's Lenn, Norf, merchant 1
4999976 2356873 2356873 defendant Colchestre John merchant 780398 780398 (Colchestre, John, of Bishop's Lenn, Norf, merchant 1
5000798 2357109 2357109 defendant Bouchier John   780398 780398 Bouchier, John, of Bishop's Lenn, Norf, burgess & merchant 0
5002060 2357504 2357504 defendant Topclyff Thomas vyntner 780398 780398 Topclyff, Thomas, of Bishop's Lenn, Norf, vyntner 1
5002078 2357507 2357507 defendant Scarlet Edmund   780398 780398 Scarlet, Edmund, of Bishop's Lenn, Norf, spice man 4

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