names

257 rows where place_id = 781524

✎ 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
4627820 2239627 2239627 defendant Newenton John   781524 781524 Newenton, John, of Coventry, of Warws 0
4673202 2257256 2257256 defendant West John draper 781524 781524 (West, John, of Coventry, Warws, draper 1
4674950 2257774 2257774 defendant Olney William chapman 781524 781524 Olney, William, of Coventry, Warws, chapman 1
4677511 2258580 2258580 defendant Stafford John pulter or skinner 781524 781524 Stafford, John, of Coventry, Warws, pulter or skinner 0
4687561 2261695 2261695 defendant Parker Alice widow 781524 781524 Parker, Alice, of Coventry, Warws, widow 4
4690142 2262472 2262472 defendant Bynley William butcher 781524 781524 Bynley, William, of Coventry, Warws, butcher 0
4690862 2262674 2262674 defendant Glyn William clerk 781524 781524 Glyn, William, of Coventry, Warws, clerk 0
4692046 2263044 2263044 defendant Smyth John smith 781524 781524 Smyth, John, of Coventry, Warws, smith 2
4693093 2263345 2263345 defendant Moreton William chaplain 781524 781524 (Moreton, William, of Coventry, Warws, chaplain 1
4693098 2263347 2263347 defendant Glyn William clerk 781524 781524 Glyn, William, of Coventry, Warws, clerk 0
4693227 2263381 2263381 defendant Appulby John   781524 781524 Appulby, John, of Coventry, Warws, cosour or horse dealer 0
4693743 2263545 2263545 defendant Savage William   781524 781524 Savage, William, of Coventry, Warws, mason 0
4694745 2263852 2263852 defendant Clarnece William chapman 781524 781524 Clarnece, William, of Coventry, Warws, chapman 0
4695888 2264199 2264199 plaintiff Burton John clerk 781524 781524 Burton, John, of Coventry, Warws, clerk 0
4695890 2264200 2264200 plaintiff Burton John clerk 781524 781524 Burton, John, of Coventry, Warws, clerk 0
4697879 2264831 2264831 defendant Spaldyng William mercer 781524 781524 Spaldyng, William, of Coventry, Warws, mercer 1
4697884 2264832 2264832 defendant Spaldyng William mercer 781524 781524 Spaldyng, William, of Coventry, Warws, mercer 1
4698603 2265039 2265039 defendant Stylle William husbandman 781524 781524 Stylle, William, of Coventry, Warws, husbandman 0
4700219 2265486 2265486 defendant Asclif Richard skinner 781524 781524 Asclif, Richard, of Coventry, Warws, skinner 2
4700756 2265636 2265636 defendant Peyntou Geoffrey dyer 781524 781524 Peyntou, Geoffrey, of Coventry, Warws, dyer 4
4702663 2266237 2266237 defendant Eton William draper 781524 781524 Eton, William, of Coventry, Warws, draper 0
4702678 2266239 2266239 defendant Eton William draper 781524 781524 Eton, William, of Coventry, Warws, draper 0
4702899 2266303 2266303 defendant Dymmok Henry chapman 781524 781524 Dymmok, Henry, of Coventry, Warws, chapman 0
4704089 2266657 2266657 defendant Harpersfeld Thomas mercer 781524 781524 Harpersfeld, Thomas, of Coventry, Warws, mercer 2
4704099 2266659 2266659 defendant Harpesfeld Thomas mercer 781524 781524 Harpesfeld, Thomas, of Coventry, Warws, mercer 3
4705104 2266970 2266970 defendant Clarens William mercer 781524 781524 Clarens, William, of Coventry, Warws, mercer 0
4705108 2266971 2266971 defendant Clarens William mercer 781524 781524 Clarens, William, of Coventry, Warws, mercer 0
4705290 2267027 2267027 defendant Lokenore John butcher 781524 781524 Lokenore, John, of Coventry, Warws, butcher 0
4705889 2267219 2267219 defendant Wodero William tanner 781524 781524 Wodero, William, of Coventry, Warws, tanner 0
4707533 2267727 2267727 defendant Gress_ John mercer 781524 781524 Gress_, John, of Coventry, Warws, mercer 1
4707576 2267732 2267732 defendant Cressy John mercer 781524 781524 Cressy, John, of Coventry, Warws, mercer 1
4710685 2268699 2268699 defendant Palmere John drover 781524 781524 Palmere, John, of Coventry, Warws, drover 4
4713229 2269463 2269463 defendant Knotte John dyer 781524 781524 Knotte, John, of Coventry, Warws, dyer 0
4713650 2269591 2269591 defendant Avynle John taverner 781524 781524 Avynle, John, of Coventry, Warws, taverner 0
4720312 2271695 2271695 defendant Palmer William   781524 781524 Palmer, William, of Coventry, Warws, husbandman, son of Richard 3
4722141 2272253 2272253 defendant Marchant John yeoman 781524 781524 Marchant, John, of Coventry, Warws, yeoman 0
4723022 2272509 2272509 defendant Runton John dubber 781524 781524 Runton, John, of Coventry, Warws, dubber 0
4723125 2272543 2272543 defendant Knot Henry dyer 781524 781524 Knot, Henry, of Coventry, Warws, dyer 0
4725414 2273243 2273243 defendant White Thomas chapman 781524 781524 White, Thomas, of Coventry, Warws, chapman 0
4726043 2273430 2273430 defendant Dylcok William merchant 781524 781524 Dylcok, William, of Coventry, Warws, merchant 0
4726656 2273609 2273609 defendant Somerton John gent 781524 781524 Somerton, John, of Coventry, Warws, gent 1
4726660 2273610 2273610 defendant Somerton John gent 781524 781524 Somerton, John, of Coventry, Warws, gent 1
4730409 2274707 2274707 defendant Kynge William chapman 781524 781524 Kynge, William, of Coventry, Warws, chapman 3
4730557 2274756 2274756 defendant Deyster Simon   781524 781524 Deyster, Simon, of Coventry, Warws, cook 3
4733204 2275565 2275565 defendant Repynton William   781524 781524 Repynton, William, of Coventry, Warws, gen 0
4733886 2275782 2275782 defendant Knotte John painter 781524 781524 Knotte, John, of Coventry, Warws, painter 0
4736186 2276452 2276452 defendant Alvynle John taverner of Leicester 781524 781524 Alvynle, John, of Coventry, Warws, taverner of Leicester 0
4739491 2277434 2277434 defendant Parkour John draper 781524 781524 Parkour, John, of Coventry, Warws, draper 0
4741990 2278156 2278156 defendant Of the Myre William cardmaker 781524 781524 Of the Myre, William, of Coventry, Warws, cardmaker 0
4742172 2278203 2278203 defendant Doughty John merchant 781524 781524 Doughty, John, of Coventry, Warws, merchant 0
4744710 2278970 2278970 defendant Harrys Thomas merchant 781524 781524 Harrys, Thomas, of Coventry, Warws, merchant 2
4745708 2279257 2279257 defendant Hichekyns John smith 781524 781524 Hichekyns, John, of Coventry, Warws, smith 2
4748102 2279955 2279955 defendant Walford Richard husbandman 781524 781524 Walford, Richard, of Coventry, Warws, husbandman 0
4748621 2280093 2280093 defendant Reggeley Hugh merchant 781524 781524 Reggeley, Hugh, of Coventry, Warws, merchant 1
4749639 2280381 2280381 defendant Graunt John skinner 781524 781524 Graunt, John, of Coventry, Warws, skinner 0
4749643 2280382 2280382 defendant Graunt John skinner 781524 781524 Graunt, John, of Coventry, Warws, skinner 0
4751656 2280974 2280974 defendant Dalby William woolman 781524 781524 Dalby, William, of Coventry, Warws, woolman 0
4755993 2282258 2282258 defendant Baunebury Henry painter 781524 781524 Baunebury, Henry, of Coventry, Warws, painter 0
4758152 2282923 2282923 defendant Myre William of the   781524 781524 Myre, William of the, of Coventry, Warws, card maker 0
4760932 2283760 2283760 defendant Nayleston John weaver 781524 781524 Nayleston, John, of Coventry, Warws, weaver 0
4761324 2283885 2283885 defendant (not given) William vicar of Glyn 781524 781524 Glyn, William, of Coventry, Warws, vicar of St Michael's church 3
4761819 2284040 2284040 defendant Fryth John smith 781524 781524 (Fryth, John, of Coventry, Warws, smith 1
4762429 2284234 2284234 defendant Wymondeswold William gent 781524 781524 Wymondeswold, William, of Coventry, Warws, gent 0
4763568 2284590 2284590 defendant Mare Peter de la vintner 781524 781524 Mare, Peter de la, of Coventry, Warws, vintner 0
4764898 2285001 2285001 defendant Hille Nicholas dyer 781524 781524 Hille, Nicholas, of Coventry, Warws, dyer 0
4765855 2285317 2285317 defendant Tudbery Richard chapman 781524 781524 Tudbery, Richard, of Coventry, Warws, chapman 1
4766484 2285509 2285509 defendant Staunton William dyer 781524 781524 Staunton, William, of Coventry, Warws, dyer 0
4767208 2285728 2285728 defendant Harrys Thomas mercer 781524 781524 Harrys, Thomas, of Coventry, Warws, mercer 0
4768044 2285973 2285973 defendant Burton John gent 781524 781524 Burton, John, of Coventry, Warws, gent 2
4768049 2285974 2285974 defendant Burton John gent 781524 781524 Burton, John, of Coventry, Warws, gent 2
4768707 2286191 2286191 defendant Bere Richard   781524 781524 Bere, Richard, of Coventry, Warws, gold smith 1
4768738 2286199 2286199 defendant Cawode William husbandman 781524 781524 Cawode, William, of Coventry, Warws, husbandman 2
4768965 2286271 2286271 defendant Wreyghter William chapman 781524 781524 Wreyghter, William, of Coventry, Warws, chapman 3
4769524 2286448 2286448 defendant Peyntour Geoffrey dyer 781524 781524 Peyntour, Geoffrey, of Coventry, Warws, dyer 0
4772624 2287407 2287407 defendant Palmer Nicholas merchant 781524 781524 Palmer, Nicholas, of Coventry, Warws, merchant 0
4773140 2287569 2287569 defendant Crosby Nicholas chaplain 781524 781524 Crosby, Nicholas, of Coventry, Warws, chaplain 0
4773141 2287569 2287569 defendant Bredon Ralph painter 781524 781524 Bredon, Ralph, of Coventry, Warws, painter 1
4775134 2288217 2288217 defendant Baker Simon dyer 781524 781524 Baker, Simon, of Coventry, Warws, dyer 0
4775258 2288254 2288254 plaintiff R_ William esq 781524 781524 R_, William, of Coventry, Warws, esq 1
4775260 2288255 2288255 plaintiff Repyngton William esq 781524 781524 Repyngton, William, of Coventry, Warws, esq 1
4775263 2288256 2288256 plaintiff Repyngton William esq 781524 781524 Repyngton, William, of Coventry, Warws, esq 1
4775614 2288368 2288368 defendant Carbonell Thomas pewterer 781524 781524 Carbonell, Thomas, of Coventry, Warws, pewterer 0
4775662 2288383 2288383 defendant Bedford William merchant 781524 781524 Bedford, William, of Coventry, Warws, merchant 0
4803273 2297215 2297215 defendant Jolypepre John yeoman 781524 781524 Jolypepre, John, of Coventry, Warws, yeoman 0
4803297 2297223 2297223 defendant Bere John chapman 781524 781524 Bere, John, of Coventry, Warws, chapman 1
4803700 2297340 2297340 defendant Paynell Thomas merchant 781524 781524 Paynell, Thomas, of Coventry, Warws, merchant 0
4805098 2297795 2297795 defendant Hache Robert yeoman 781524 781524 Hache, Robert, of Coventry, Warws, yeoman 1
4805674 2297983 2297983 defendant Samson Thomas shoemaker 781524 781524 Samson, Thomas, of Coventry, Warws, shoemaker 1
4805678 2297984 2297984 defendant Samson Thomas shoemaker 781524 781524 Samson, Thomas, of Coventry, Warws, shoemaker 1
4806884 2298359 2298359 defendant Bednull Roger butcher 781524 781524 Bednull, Roger, of Coventry, Warws, butcher 0
4806887 2298360 2298360 defendant Bedull Richard butcher 781524 781524 Bedull, Richard, of Coventry, Warws, butcher 0
4807702 2298598 2298598 defendant Hampton Richard plumber 781524 781524 Hampton, Richard, of Coventry, Warws, plumber 2
4808057 2298699 2298699 defendant Creke John skinner 781524 781524 Creke, John, of Coventry, Warws, skinner 0
4808892 2298951 2298951 defendant Brere John dyer 781524 781524 Brere, John, of Coventry, Warws, dyer 0
4808909 2298960 2298960 defendant Brere John dyer 781524 781524 Brere, John, of Coventry, Warws, dyer 0
4809171 2299046 2299046 defendant Barry William butcher 781524 781524 Barry, William, of Coventry, Warws, butcher 1
4809332 2299094 2299094 defendant Hornby Henry chapman 781524 781524 Hornby, Henry, of Coventry, Warws, chapman 0
4810380 2299394 2299394 defendant Parker Nicholas mercer 781524 781524 Parker, Nicholas, of Coventry, Warws, mercer 0
4810549 2299444 2299444 defendant Barbour William barber 781524 781524 Barbour, William, of Coventry, Warws, barber 1
4814477 2300635 2300635 defendant Bere John mercer 781524 781524 Bere, John, of Coventry, Warws, mercer 0

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