names

128 rows where place_id = 662065

✎ 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
3663559 1914531 1914531 plaintiff Pentecost alias Rowland Thomas   662065 662065 Pentecost alias Rowland, Thomas, of Abingdon, abbot of the Monastery of St Mary 0
3963700 2011913 2011913 plaintiff Alcok William gent 662065 662065 Alcok, William, of Abingdon, gent 0
3963703 2011914 2011914 plaintiff Alcok William   662065 662065 Alcok, William, of Abingdon, gent, under-sheriff of Berkshire 0
3963704 2011914 2011914 defendant Harvy Hugh innholder 662065 662065 Harvy, Hugh, of Abingdon, innholder 0
3963707 2011914 2011914 defendant Shepard Thomas glover 662065 662065 Shepard, Thomas, of Abingdon, glover 3
3963708 2011914 2011914 defendant Honor Richard saddler 662065 662065 Honor, Richard, of Abingdon, saddler 4
4073239 2050720 2050720 defendant Hide Edward   662065 662065 Hide, Edward, of Abingdon, woollen draper 1
4090766 2056986 2056986 plaintiff Coxwell Anne widow 662065 662065 Anne his wife, formerly Anne Styleman, of Abingdon, widow 1
4108327 2063236 2063236 defendant Large Richard chandler 662065 662065 Large, Richard, of Abingdon, chandler 1
4151870 2078766 2078766 defendant Qwelche Richard chapman 662065 662065 Qwelche, Richard, of Abingdon, chapman 2
4221184 2102909 2102909 defendant Ives William yeoman 662065 662065 Ives, William, of Abingdon, yeoman 0
4283408 2124101 2124101 defendant Harte William gent 662065 662065 Harte, William, of Abingdon, gent 0
4301670 2130704 2130704 defendant Foster alias Smyth Richard yeoman 662065 662065 Foster alias Smyth, Richard, of Abingdon, yeoman 0
4303414 2131323 2131323 defendant Ryng Thomas mercer 662065 662065 Ryng, Thomas, of Abingdon, mercer 0
4303415 2131323 2131323 defendant Ryng Leonard mercer 662065 662065 Ryng, Leonard, of Abingdon, mercer 1
4303416 2131323 2131323 defendant Townesend Ralph mercer 662065 662065 Townesend, Ralph, of Abingdon, mercer 2
4335075 2142003 2142003 defendant Boldes Humphrey cordwainer 662065 662065 Boldes, Humphrey, of Abingdon, cordwainer 0
4335077 2142004 2142004 defendant Boldes Humphrey cordwainer 662065 662065 Boldes, Humphrey, of Abingdon, cordwainer 0
4336937 2142644 2142644 defendant Sellarr Thomas innholder 662065 662065 Sellarr, Thomas, of Abingdon, innholder 0
4337744 2142948 2142948 defendant Fysher John, junior innholder 662065 662065 Fysher, John, junior, of Abingdon, innholder 0
4339030 2143410 2143410 defendant Sadler Ralph yeoman 662065 662065 Sadler, Ralph, of Abingdon, yeoman 0
4339031 2143410 2143410 defendant Wrighte Richard yeoman 662065 662065 Wrighte, Richard, of Abingdon, cordwainer, yeoman 1
4339033 2143411 2143411 defendant Sadler Ralph yeoman 662065 662065 Sadler, Ralph, of Abingdon, yeoman 0
4339034 2143411 2143411 defendant Wrighte Richard yeoman 662065 662065 Wrighte, Richard, of Abingdon, cordwainer, yeoman 1
4390716 2161504 2161504 defendant Cleevely William hosier 662065 662065 Cleevely, William, of Abingdon, hosier 0
4393740 2162508 2162508 defendant Boales Robert tanner 662065 662065 Boales, Robert, of Abingdon, tanner 0
4396787 2163492 2163492 defendant Wrothe William butcher 662065 662065 Wrothe, William, of Abingdon, or of Fyfeild, butcher 1
4402202 2165321 2165321 defendant Welling James yeoman 662065 662065 Welling, James, of Abingdon, yeoman 0
4402206 2165323 2165323 defendant Welling James yeoman 662065 662065 Welling, James, of Abingdon, yeoman 0
4410718 2168175 2168175 defendant Rithe Robert esq 662065 662065 Rithe, Robert, of Abingdon, or of Lincolns Inn, Middx, esq 0
4441565 2182293 2182293 defendant Mussenden John   662065 662065 Mussenden, John, of Abingdon 7
4669890 2256279 2256279 defendant (not given) Richard vicar of Beel 662065 662065 Beel, Richard, of Abingdon, vicar of St Helen's church 0
4691832 2262981 2262981 plaintiff Alford John   662065 662065 Alford, John, of Abingdon, wool monger 0
4691833 2262981 2262981 defendant Chapman Richard chapman 662065 662065 Chapman, Richard, of Abingdon, chapman 0
4694305 2263717 2263717 defendant Bryghtwell Henry chapman 662065 662065 Bryghtwell, Henry, of Abingdon, chapman 0
4699248 2265232 2265232 plaintiff Dorsete John   662065 662065 Dorsete, John, of Abingdon, abbot 0
4699249 2265232 2265232 defendant Longe John   662065 662065 Longe, John, of Abingdon, corsour 0
4699250 2265232 2265232 defendant Parker John   662065 662065 Parker, John, of Abingdon, corsour 1
4699251 2265232 2265232 defendant Huber John   662065 662065 Huber, John, of Abingdon, corsour 2
4699252 2265232 2265232 defendant Assyngden Thomas   662065 662065 Assyngden, Thomas, of Abingdon, corsour 3
4699484 2265293 2265293 defendant Wolmonger Giles chapman 662065 662065 Wolmonger, Giles, of Abingdon, chapman 0
4703958 2266616 2266616 defendant Tanner Nicholas tanner 662065 662065 Tanner, Nicholas, of Abingdon, tanner 0
4705390 2267054 2267054 defendant Dyer Robert weaver 662065 662065 Dyer, Robert, of Abingdon, weaver 3
4706446 2267398 2267398 plaintiff Lydyerd John   662065 662065 Lydyerd, John, of Abingdon 0
4706448 2267398 2267398 defendant Eton William chapman 662065 662065 Eton, William, of Abingdon, chapman 1
4706449 2267398 2267398 defendant Fyssher William fishmonger 662065 662065 Fyssher, William, of Abingdon, fishmonger 2
4708940 2268165 2268165 plaintiff Palmer John   662065 662065 Palmer, John, of Abingdon 0
4710074 2268506 2268506 plaintiff Pounston John   662065 662065 Pounston, John, of Abingdon 0
4713602 2269577 2269577 plaintiff Sutton Walter   662065 662065 Sutton, Walter, of Abingdon 0
4716483 2270474 2270474 defendant Swetemouth John   662065 662065 Swetemouth, John, of Abingdon, bailiff 1
4716661 2270531 2270531 plaintiff Wodestoke John   662065 662065 Wodestoke, John, of Abingdon 0
4716707 2270546 2270546 plaintiff Wollemonger Thomas   662065 662065 Wollemonger, Thomas, of Abingdon 0
4716709 2270546 2270546 defendant Smalcombe John weaver 662065 662065 Smalcombe, John, of Abingdon, weaver 1
4716712 2270546 2270546 defendant Osteler Thomas husbandman 662065 662065 Osteler, Thomas, of Abingdon, husbandman 4
4738657 2277179 2277179 defendant Perneys Robert chapman 662065 662065 Perneys, Robert, of Abingdon, chapman 0
4738978 2277280 2277280 defendant Aldeworth Willai husbandman 662065 662065 Aldeworth, Willai, of Abingdon, husbandman 0
4739154 2277338 2277338 defendant Perneys Robert husbandman 662065 662065 Perneys, Robert, of Abingdon, husbandman 0
4739408 2277409 2277409 defendant Baker Henry baker 662065 662065 Baker, Henry, of Abingdon, baker 0
4754953 2281931 2281931 defendant Faukener William butcher 662065 662065 Faukener, William, of Abingdon, butcher 0
4755909 2282232 2282232 defendant Dyer Thomas dyer 662065 662065 Dyer, Thomas, of Abingdon, dyer 1
4757372 2282676 2282676 defendant Mathon John husbandman 662065 662065 Mathon, John, of Abingdon, husbandman 2
4760970 2283774 2283774 defendant Apperley William chapman 662065 662065 Apperley, William, of Abingdon, chapman 1
4760971 2283774 2283774 defendant Petre John   662065 662065 Petre, John, of Abingdon, wire drawer 2
4762174 2284148 2284148 defendant Dounton Thomas yeoman 662065 662065 Dounton, Thomas, of Abingdon, yeoman 2
4763637 2284614 2284614 defendant Perveys Robert yeoman 662065 662065 Perveys, Robert, of Abingdon, yeoman 0
4772419 2287341 2287341 defendant Fullere Edward fuller 662065 662065 Fullere, Edward, of Abingdon, fuller 0
4775584 2288357 2288357 defendant Sutton Walter husbandman 662065 662065 Sutton, Walter, of Abingdon, husbandman 0
4775585 2288357 2288357 defendant Parysprest Thomas chaplain 662065 662065 Parysprest, Thomas, of Abingdon, chaplain 1
4775590 2288359 2288359 defendant More John cutler 662065 662065 More, John, of Abingdon, cutler 0
4775592 2288360 2288360 defendant More John cutler 662065 662065 More, John, of Abingdon, cutler 0
4836902 2307500 2307500 defendant Wyttenham John   662065 662065 Wyttenham, John, of Abingdon, shoe maker 0
4837117 2307561 2307561 defendant Ferman Robert butcher 662065 662065 Ferman, Robert, of Abingdon, butcher 0
4843457 2309472 2309472 plaintiff Marston John   662065 662065 Marston, John, of Abingdon 0
4845851 2310211 2310211 defendant Assyngdene Thomas husbandman 662065 662065 Assyngdene, Thomas, of Abingdon, husbandman 1
4845854 2310212 2310212 defendant appurley John weaver 662065 662065 appurley, John, of Abingdon, weaver 1
4845855 2310212 2310212 defendant Bocher Richard butcher 662065 662065 Bocher, Richard, of Abingdon, butcher 2
4847356 2310678 2310678 defendant Seman John   662065 662065 Seman, John, of Abingdon, glove maker 0
4849444 2311301 2311301 defendant Player Thomas husbandman 662065 662065 Player, Thomas, of Abingdon, husbandman 2
4849619 2311359 2311359 plaintiff Stokes John   662065 662065 Stokes, John, of Abingdon 0
4907659 2328963 2328963 defendant Halman John husbandman 662065 662065 Halman, John, of Abingdon, husbandman 1
4917055 2331842 2331842 plaintiff Freman Robert   662065 662065 Freman, Robert, of Abingdon, on his own account 0
4987597 2353249 2353249 defendant Willys John fuller 662065 662065 Willys, John, of Abingdon, fuller 0
5008618 2359417 2359417 defendant Corveser Arunlphum shoemaker 662065 662065 Corveser, Arunlphum, of Abingdon, shoemaker 0
5011698 2360271 2360271 plaintiff Wodelef William   662065 662065 Wodelef, William, of Abingdon 0
5040083 2368631 2368631 defendant Bray Thomas   662065 662065 Bray, Thomas, of Abingdon, tallow chandler 0
5050083 2371647 2371647 defendant Bagge John spicer 662065 662065 Bagge, John, of Abingdon, spicer 0
5135885 2397011 2397011 defendant Daune Richard draper 662065 662065 Daune, Richard, of Abingdon, draper 0
5143361 2399197 2399197 defendant Gaunte Nicholas chandler 662065 662065 Gaunte, Nicholas, of Abingdon, chandler 0
5144626 2399586 2399586 defendant Bagge John mercer 662065 662065 Bagge, John, of Abingdon, mercer 1
5144627 2399586 2399586 defendant Appurle John   662065 662065 Appurle, John, of Abingdon, kersey man 2
5148957 2400824 2400824 defendant Appurley John   662065 662065 Appurley, John, of Abingdon, kersey man 0
5151257 2401515 2401515 plaintiff Goslyn Thomas   662065 662065 Goslyn, Thomas, of Abingdon 0
5151258 2401515 2401515 defendant Somerseet William chapman 662065 662065 Somerseet, William, of Abingdon, chapman 0
5151259 2401515 2401515 defendant Bysshop John butcher 662065 662065 Bysshop, John, of Abingdon, butcher 1
5160265 2404097 2404097 defendant Abyndon William   662065 662065 Abyndon, William, of Abingdon 0
5161244 2404384 2404384 plaintiff Stokes John (legal representative) 662065 662065 Stokes, John, of Abingdon, executors of 0
5161245 2404384 2404384 plaintiff Southwyk Thomas esq 662065 662065 (Southwyk, Thomas, of Abingdon, esq 1
5161250 2404385 2404385 plaintiff Stokes John (legal representative) 662065 662065 Stokes, John, of Abingdon, merchant, diocese of Salisbury, executors of 0
5161738 2404536 2404536 plaintiff Tanner Nicholas yeoman 662065 662065 Tanner, Nicholas, of Abingdon, yeoman 0
5162202 2404678 2404678 defendant Wenneman Henry gent 662065 662065 Wenneman, Henry, of Abingdon, gent 3

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