names

96 rows where place_id = 700160

✎ 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
3698387 1925717 1925717 defendant Bytheway John tanner 700160 700160 Bytheway, John, of Soke juxta Winchester, tanner 0
4132204 2071829 2071829 defendant Hopkyns John butcher 700160 700160 Hopkyns, John, of Soke of Winchester, butcher 1
4161833 2082207 2082207 defendant Bassett Thomas (legal representative) 700160 700160 Bassett, Thomas, of Soke of Winchester, gent, executrix of 2
4188503 2091451 2091451 defendant Flemynge Thomas esq 700160 700160 Flemynge, Thomas, of Soke by Winchester, or of Lincolns Inn, Middx, esq 0
4234928 2107767 2107767 defendant Smythe Nicholas yeoman 700160 700160 Smythe, Nicholas, of Soke of Winchester, yeoman 3
4238376 2109035 2109035 defendant Lawes William yeoman 700160 700160 Lawes, William, of Soke of Winchester, yeoman 0
4240208 2109696 2109696 defendant Gunner Richard yeoman 700160 700160 Gunner, Richard, of Soke of Winchester, yeoman 3
4280921 2123231 2123231 defendant Crooke Cuthbert yeoman 700160 700160 Crooke, Cuthbert, of Soke of Winchester, yeoman 0
4282396 2123742 2123742 defendant Crooke James clothier 700160 700160 Crooke, James, of Soke of Winchester, clothier 0
4468842 2190929 2190929 defendant Broun John   700160 700160 Broun, John, of Soke 3
4655701 2247666 2247666 defendant Pollard Thomas tanner 700160 700160 Pollard, Thomas, of Soke of Winchester, tanner 3
4778808 2289345 2289345 plaintiff Pollard Thomas   700160 700160 Pollard, Thomas, of Soke of Winchester 2
4796914 2295191 2295191 defendant Wellere William soaper 700160 700160 Wellere, William, of Soke of Winchester, soaper 0
4859900 2314467 2314467 defendant Toky Roger   700160 700160 Toky, Roger, of Soke of Winchester, lime burner 0
4875894 2319419 2319419 defendant Malpas Hugh hosteler 700160 700160 Malpas, Hugh, of Soke of Winchester, hosteler 0
4876214 2319520 2319520 defendant Sharp William husbandman 700160 700160 Sharp, William, of Soke of Winchester, husbandman 1
4895748 2325347 2325347 plaintiff Captrygh Peter   700160 700160 Captrygh, Peter, of Soke of Winchester 0
4900329 2326738 2326738 defendant Grenestrete Gilbert cordwainer 700160 700160 Grenestrete, Gilbert, of Soke, cordwainer 1
4938669 2338480 2338480 defendant Belyfaunt Philip tailor 700160 700160 Belyfaunt, Philip, of Soke of Winchester, tailor 2
4940644 2339103 2339103 defendant Belifaunt Philip husbandman 700160 700160 Belifaunt, Philip, of Soke of Winchester, husbandman 0
4959225 2344727 2344727 defendant Brydde John skinner 700160 700160 Brydde, John, of Soke of Winchester, skinner 0
4984674 2352344 2352344 defendant Frere John   700160 700160 Frere, John, of Soke of Winchester, servant 0
5013426 2360762 2360762 defendant Tystede John husbandman 700160 700160 Tystede, John, of Soke of Winchester, husbandman 0
5013432 2360765 2360765 defendant Grene William dyer 700160 700160 Grene, William, of Soke of Winchester, dyer 0
5013433 2360765 2360765 defendant Sharp Walter fuller 700160 700160 Sharp, Walter, of Soke of Winchester, fuller 1
5014577 2361131 2361131 plaintiff Bere Thomas   700160 700160 Bere, Thomas, of Soke of Winchester, mason 0
5015346 2361371 2361371 defendant Stoby William yeoman 700160 700160 Stoby, William, of Soke of Winchester, yeoman 0
5015954 2361557 2361557 defendant Wodecok John merchant 700160 700160 Wodecok, John, of Soke of Winchester, merchant 0
5016270 2361648 2361648 defendant Welynowe Philip husbandman 700160 700160 Welynowe, Philip, of Soke of Winchester, husbandman 1
5028597 2365242 2365242 defendant Goldesmyth John   700160 700160 Goldesmyth, John, of Soke of Winchester 1
5036370 2367491 2367491 defendant Versey John sawyer 700160 700160 Versey, John, of Soke of Winchester, sawyer 0
5052976 2372483 2372483 defendant Bolyfaunt John   700160 700160 Bolyfaunt, John, of Soke of Winchester, bailiff 0
5057080 2373696 2373696 defendant atte Mere Thomas husbandman 700160 700160 atte Mere, Thomas, of Soke of Winchester, husbandman 2
5057081 2373696 2373696 defendant Tanner James husbandman 700160 700160 Tanner, James, of Soke of Winchester, husbandman 3
5065750 2376280 2376280 defendant Aleyn William husbandman 700160 700160 Aleyn, William, of Soke of Winchester, husbandman 0
5065751 2376280 2376280 defendant Fraye John husbandman 700160 700160 Fraye, John, of Soke of Winchester, husbandman 1
5068094 2376962 2376962 defendant Stobyngton William carter 700160 700160 Stobyngton, William, of Soke of Winchester, carter 0
5068095 2376962 2376962 defendant Leche John butcher 700160 700160 Leche, John, of Soke of Winchester, butcher 1
5072364 2378220 2378220 defendant Tangmer James helyer or roofer 700160 700160 Tangmer, James, of Soke of Winchester, helyer or roofer 1
5072365 2378220 2378220 defendant Scutte Robert husbandman 700160 700160 Scutte, Robert, of Soke of Winchester, husbandman 2
5074633 2378915 2378915 defendant Bryd John, junior weaver 700160 700160 Bryd, John, junior, of Soke of Winchester, weaver 0
5074634 2378915 2378915 defendant Corsyly John weaver 700160 700160 Corsyly, John, of Soke of Winchester, weaver 1
5081236 2380893 2380893 defendant Wolstone Ralph skinner 700160 700160 Wolstone, Ralph, of Soke of Winchester, skinner 0
5082760 2381346 2381346 defendant Stobyngdon William brewer 700160 700160 Stobyngdon, William, of Soke of Winchester, brewer 3
5085201 2382072 2382072 defendant Wolstone Ralph skinner 700160 700160 Wolstone, Ralph, of Soke of Worcester, skinner 0
5090307 2383546 2383546 defendant Tryme Gregory   700160 700160 Tryme, Gregory, of Soke of Winchester, groom 0
5099001 2386138 2386138 defendant Warnere Alice widow 700160 700160 Warnere, Alice, of Soke of Winchester, widow 0
5099037 2386149 2386149 defendant Grene William dyer 700160 700160 Grene, William, of Soke of Winchester, dyer 0
5099038 2386149 2386149 defendant Twalybaly John yeoman 700160 700160 Twalybaly, John, of Soke of Winchester, yeoman 1
5099039 2386149 2386149 defendant Romsey William yeoman 700160 700160 Romsey, William, of Soke of Winchester, yeoman 2
5101403 2386824 2386824 defendant Hunt John   700160 700160 Hunt, John, of Soke of Winchester, cook 0
5106650 2388374 2388374 plaintiff Dalton Richard   700160 700160 Dalton, Richard, of Soke of Winchester, 0
5106651 2388374 2388374 defendant Bonefaunt Philip yeoman 700160 700160 Bonefaunt, Philip, of Soke of Winchester, yeoman 0
5110665 2389523 2389523 defendant Bolyfaunt Philip tailor 700160 700160 Bolyfaunt, Philip, of Soke of Winchester, tailor 0
5110946 2389594 2389594 defendant Sewale Thomas weaver 700160 700160 Sewale, Thomas, of Soke of Winchester, weaver 0
5112437 2390025 2390025 defendant Bonefaunte or Bolyfaunte Philip tailor 700160 700160 Bonefaunte or Bolyfaunte, Philip, of Soke of Winchester, tailor 0
5112438 2390025 2390025 defendant Huby Peter baker 700160 700160 Huby, Peter, of Soke of Winchester, baker 1
5115093 2390834 2390834 defendant Wolston Ralph skinner 700160 700160 Wolston, Ralph, of Soke of Winchester, skinner 2
5117360 2391510 2391510 defendant Wolstone Ralph skinner 700160 700160 Wolstone, Ralph, of Soke of Winchester, skinner 0
5117361 2391510 2391510 defendant Bore William smith 700160 700160 Bore, William, of Soke of Winchester, smith 1
5117362 2391510 2391510 defendant Bonefaunt Philip yeoman 700160 700160 Bonefaunt, Philip, of Soke of Winchester, yeoman 2
5123279 2393247 2393247 defendant Bere Thomas   700160 700160 Bere, Thomas, of Soke of Winchester, mason 0
5123281 2393248 2393248 defendant Bere Thomas   700160 700160 Bere, Thomas, of Soke of Winchester, mason 0
5217217 2420771 2420771 defendant Tympany John tailor 700160 700160 Tympany, John, of Soke of Winchester, tailor 0
5224154 2422734 2422734 defendant Talton Richard yeoman 700160 700160 Talton, Richard, of Soke of Winchester, yeoman 0
5224156 2422735 2422735 defendant Tauton Richard yeoman 700160 700160 Tauton, Richard, of Soke of Winchester, yeoman 0
5226335 2423369 2423369 defendant Umfray John cordwainer 700160 700160 Umfray, John, of Soke of Winchester, cordwainer 0
5246917 2429262 2429262 defendant Dowce Richard gent 700160 700160 Dowce, Richard, of Soke Winchester, gent 1
5277828 2438600 2438600 defendant Bore William smith 700160 700160 Bore, William, of Soke of Winchester, smith 0
5277830 2438600 2438600 defendant Maydelone or Maydelove John tanner 700160 700160 Maydelone or Maydelove, John, of Soke of Winchester, tanner 2
5277991 2438650 2438650 defendant Morefeld Robert tailor 700160 700160 Morefeld, Robert, of Soke of Winchester, tailor 0
5277992 2438650 2438650 defendant Leny or Levy John tailor 700160 700160 Leny or Levy, John, of Soke of Winchester, tailor 1
5277993 2438650 2438650 defendant Person William barber 700160 700160 Person, William, of Soke of Winchester, barber 2
5289819 2442030 2442030 defendant Bokelond John miller 700160 700160 Bokelond, John, of Soke of Winchester, miller 2
5289828 2442032 2442032 defendant Dunnyng John yeoman 700160 700160 Dunnyng, John, of Soke of Winchester, yeoman 0
5291048 2442384 2442384 plaintiff Pekke John   700160 700160 Pekke, John, of Soke of Winchester 0
5293638 2443103 2443103 defendant Hawys Robert yeoman 700160 700160 Hawys, Robert, of Soke of Winchester, yeoman 0
5293741 2443130 2443130 defendant Tympany John tailor 700160 700160 Tympany, John, of Soke of Winchester, tailor 0
5293742 2443130 2443130 defendant Smyth John tailor 700160 700160 Smyth, John, of Soke of Winchester, tailor 1
5295397 2443644 2443644 defendant Iryssh John smith 700160 700160 Iryssh, John, of Soke of Winchester, smith 0
5312774 2448853 2448853 defendant Morfeld Robert tailor 700160 700160 Morfeld, Robert, of Soke of Winchester, tailor 3
5313588 2449093 2449093 defendant Caarde Mathew yeoman 700160 700160 Caarde, Mathew, of Soke of Winchester, yeoman 0
5324878 2452516 2452516 defendant Dregge John yeoman 700160 700160 Dregge, John, of Soke of Winchester, yeoman 0
5327471 2453285 2453285 defendant Cahard Mathew yeoman 700160 700160 Cahard, Mathew, of Soke of Winchester, yeoman 0
5327472 2453285 2453285 defendant Skynner William yeoman 700160 700160 Skynner, William, of Soke of Winchester, yeoman 1
5339945 2457063 2457063 defendant Bayly John dyer 700160 700160 Bayly, John, of Soke of Winchester, dyer 1
5345402 2458733 2458733 defendant Bayly John dyer 700160 700160 Bayly, John, of Soke of Winchester, dyer 0
5349577 2460002 2460002 defendant Fesaunt John gent 700160 700160 Fesaunt, John, of Soke, Winchester, gent 0
5352838 2460975 2460975 defendant Boys Richard husbandman 700160 700160 Boys, Richard, of Soke Gummer, husbandman 1
5353212 2461080 2461080 defendant George Robert yeoman 700160 700160 George, Robert, of Soke, Winchester, yeoman 0
5436042 2485720 2485720 defendant Skynner William yeoman 700160 700160 Skynner, William, of Soke by Winchester, yeoman 2
5452324 2490567 2490567 defendant Vyncent John fuller 700160 700160 Vyncent, John, of Soke by Winchester, fuller 3
5458368 2492396 2492396 defendant Lisse Roger yeoman 700160 700160 Lisse, Roger, of Soke of Winchester, yeoman 1
5469994 2495946 2495946 defendant Lisse Roger yeoman 700160 700160 Lisse, Roger, of Soke of Winchester, yeoman 1
5624391 2551571 2551571 defendant Wordelyche John husbandman 700160 700160 Wordelyche, John, of soke of Winchester, husbandman 0
5624393 2551572 2551572 defendant Wordelyche John husbandman 700160 700160 Wordelyche, John, of soke of Winchester, husbandman 0

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