names

230 rows where place_id = 654978

✎ 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
3934485 2001829 2001829 defendant Cotton Robert chapman 654978 654978 Cotton, Robert, of Leicester, Leics, chapman 2
3934491 2001832 2001832 defendant Lambard Christopher chapman 654978 654978 Lambard, Christopher, of Leicester, Leics, chapman 0
3942192 2004408 2004408 defendant Clough William chapman 654978 654978 Clough, William, of Leicester, Leics, chapman 0
4675761 2258026 2258026 defendant Lewyn Thomas   654978 654978 Lewyn, Thomas, of Leicester, Leics, attorney 0
4684195 2260659 2260659 defendant Sturgeys William draper 654978 654978 Sturgeys, William, of Leicester, Leics, draper 1
4687883 2261774 2261774 defendant Couper William cooper 654978 654978 Couper, William, of Leicester, Leics, cooper 0
4688503 2261968 2261968 defendant Mounses Robert chapman 654978 654978 Mounses, Robert, of Leicester, Leics, chapman 2
4693400 2263437 2263437 defendant Holand Richard chapman 654978 654978 Holand, Richard, of Leicester, Leics, chapman 2
4694756 2263854 2263854 defendant Lokton Robert chapman 654978 654978 Lokton, Robert, of Leicester, Leics, chapman 0
4700270 2265501 2265501 defendant Barbour Roger   654978 654978 Barbour, Roger, of Leicester, Leics, sergeant 0
4703974 2266620 2266620 defendant Lewyn Thomas gent 654978 654978 Lewyn, Thomas, of Leicester, Leics, gent 0
4706513 2267417 2267417 defendant Caumbrygge John cutler 654978 654978 Caumbrygge, John, of Leicester, Leics, cutler 0
4706515 2267418 2267418 defendant Caumbrygge John cutler 654978 654978 Caumbrygge, John, of Leicester, Leics, cutler 0
4706712 2267484 2267484 defendant Bower Thomas   654978 654978 Bower, Thomas, of Leicester, Leics, bow maker 1
4706847 2267520 2267520 defendant Goodeyer Henry   654978 654978 Goodeyer, Henry, of Leicester, Leics, brass worker 0
4706852 2267522 2267522 defendant Goodeyer Henry   654978 654978 Goodeyer, Henry, of Leicester, Leics, brass worker 0
4706860 2267525 2267525 defendant Willowly Roger   654978 654978 Willowly, Roger, of Leicester, Leics, canon of St Mary's church, new work 0
4706863 2267526 2267526 defendant Gudyere Henry   654978 654978 Gudyere, Henry, of Leicester, Leics, brass worker 0
4706971 2267562 2267562 defendant Gudyere Henry   654978 654978 Gudyere, Henry, of Leicester, Leics, brass worker 0
4711096 2268823 2268823 defendant Selby Robert   654978 654978 Selby, Robert, of Leicester, Leics, iron monger 0
4711098 2268824 2268824 defendant Selby William   654978 654978 Selby, William, of Leicester, Leics, iron monger 0
4718470 2271118 2271118 defendant Forster Henry esq 654978 654978 Forster, Henry, of Leicester, Leics, esq 3
4719380 2271404 2271404 defendant Smyth Nicholas fishmonger 654978 654978 Smyth, Nicholas, of Leicester, Leics, fishmonger 0
4724607 2272995 2272995 defendant Belgrave John yeoman 654978 654978 Belgrave, John, of Leicester, Leics, yeoman 0
4726713 2273624 2273624 defendant Saltfletby William yeoman 654978 654978 Saltfletby, William, of Leicester, Leics, yeoman 2
4730253 2274666 2274666 defendant Aslaby William clerk 654978 654978 Aslaby, William, of Leicester, Leics, clerk 0
4734248 2275888 2275888 defendant Godeyer Henry   654978 654978 Godeyer, Henry, of Leicester, Leics, brass worker 0
4744670 2278961 2278961 defendant Belgrave John yeoman 654978 654978 Belgrave, John, of Leicester, Leics, yeoman 0
4744672 2278962 2278962 defendant Belgrave John yeoman 654978 654978 Belgrave, John, of Leicester, Leics, yeoman 0
4746494 2279466 2279466 defendant Nobull William   654978 654978 Nobull, William, of Leicester, Leics, bell yettere or bell founder 0
4750163 2280521 2280521 defendant London John chapman 654978 654978 London, John, of Leicester, Leics, chapman 3
4751862 2281038 2281038 defendant Sadyngton William   654978 654978 Sadyngton, William, of Leicester, Leics, abbot of the Monastery of St Mary de Pratis 0
4754601 2281823 2281823 defendant Chernok John yeoman 654978 654978 Chernok, John, of Leicester, Leics, yeoman 0
4759828 2283407 2283407 defendant (illegible) Thomas merchant 654978 654978 _, Thomas, of Leicester, Leics, merchant 0
4763886 2284697 2284697 defendant Chaundeler John chapman 654978 654978 Chaundeler, John, of Leicester, Leics, chapman 1
4764372 2284851 2284851 defendant Chernok John yeoman 654978 654978 Chernok, John, of Leicester, Leics, yeoman 0
4767262 2285747 2285747 defendant Rygmayden William gent 654978 654978 Rygmayden, William, of Leicester, Leics, gent 0
4772488 2287359 2287359 defendant Gaddesby Thomas sadler 654978 654978 Gaddesby, Thomas, of Leicester, Leics, sadler 2
4774014 2287856 2287856 defendant Geddesby Thomas chapman 654978 654978 Geddesby, Thomas, of Leicester, Leics, chapman 1
4775636 2288374 2288374 defendant Forster Henry husbandman 654978 654978 Forster, Henry, of Leicester, Leics, husbandman 0
4775858 2288450 2288450 defendant Rygmayden William gent 654978 654978 Rygmayden, William, of Leicester, Leics, gent 0
4804300 2297531 2297531 defendant Sherman William sheerman 654978 654978 Sherman, William, of Leicester, Leics, sheerman 1
4806154 2298132 2298132 defendant Wynger William merchant 654978 654978 Wynger, William, of Leicester, Leics, merchant 0
4806530 2298256 2298256 defendant Whytyngton Thomas fuller 654978 654978 Whytyngton, Thomas, of Leicester, Leics, fuller 0
4807700 2298598 2298598 defendant Wynger William merchant 654978 654978 Wynger, William, of Leicester, Leics, merchant 0
4809190 2299050 2299050 defendant Hatton Thomas dyer 654978 654978 Hatton, Thomas, of Leicester, Leics, dyer 2
4809821 2299234 2299234 defendant Wyther Anne   654978 654978 Wyther, Anne, of Leicester, Leics, widow, sometime wife of John Wyther 0
4810357 2299385 2299385 defendant Lofwyk Richard husbandman 654978 654978 Lofwyk, Richard, of Leicester, Leics, husbandman 0
4810910 2299530 2299530 defendant Browederer John merchant 654978 654978 Browederer, John, of Leicester, Leics, merchant 0
4811263 2299631 2299631 defendant Pykewell John woolman 654978 654978 (Pykewell, John, of Leicester, Leics, woolman 2
4811349 2299660 2299660 defendant Whityngton Thomas walker 654978 654978 Whityngton, Thomas, of Leicester, Leics, walker 0
4814996 2300800 2300800 defendant Deyster John dyer 654978 654978 Deyster, John, of Leicester, Leics, dyer 0
4818591 2301896 2301896 defendant Goodyere Henry   654978 654978 Goodyere, Henry, of Leicester, Leics, brass worker 0
4818720 2301943 2301943 defendant Goodyere Henry   654978 654978 Goodyere, Henry, of Leicester, Leics, brass worker 0
4819514 2302182 2302182 defendant Gaddesby Thomas sadler 654978 654978 Gaddesby, Thomas, of Leicester, Leics, sadler 0
4819918 2302305 2302305 defendant Quenby Thomas   654978 654978 Quenby, Thomas, of Leicester, Leics, parchement maker 0
4821416 2302782 2302782 defendant Dextere John, junior   654978 654978 Dextere, John, junior, of Leicester, Leics, dyer, staying near the Westgate 0
4821770 2302886 2302886 defendant Covyntre John baker 654978 654978 Covyntre, John, of Leicester, Leics, baker 0
4823519 2303445 2303445 defendant Dyester John dyer 654978 654978 Dyester, John, of Leicester, Leics, dyer 0
4823522 2303446 2303446 defendant Dyester John dyer 654978 654978 Dyester, John, of Leicester, Leics, dyer 0
4824642 2303756 2303756 defendant Howeton Robert chapman 654978 654978 Howeton, Robert, of Leicester, Leics, chapman 0
4824646 2303756 2303756 defendant Gyldenhed John chapman 654978 654978 Gyldenhed, John, of Leicester, Leics, chapman 4
4824651 2303757 2303757 defendant Howeton Robert chapman 654978 654978 Howeton, Robert, of Leicester, Leics, chapman 0
4824655 2303757 2303757 defendant Gyldenhed John chapman 654978 654978 Gyldenhed, John, of Leicester, Leics, chapman 4
4824660 2303758 2303758 defendant Howeton Robert chapman 654978 654978 Howeton, Robert, of Leicester, Leics, chapman 0
4824664 2303758 2303758 defendant Gildenhed John chapman 654978 654978 Gildenhed, John, of Leicester, Leics, chapman 4
4825903 2304134 2304134 defendant Broune John yeoman 654978 654978 Broune, John, of Leicester, Leics, yeoman 0
4826872 2304443 2304443 defendant Highton John chapman 654978 654978 Highton, John, of Leicester, Leics, chapman 0
4827270 2304579 2304579 defendant Hyghton John chapman 654978 654978 Hyghton, John, of Leicester, Leics, chapman 0
4828140 2304843 2304843 defendant Benet Richard gent 654978 654978 Benet, Richard, of Leicester, Leics, gent 1
4828382 2304919 2304919 defendant Wade Richard chapman 654978 654978 Wade, Richard, of Leicester, Leics, chapman 2
4829000 2305113 2305113 defendant Wade Richard chapman 654978 654978 Wade, Richard, of Leicester, Leics, chapman 2
4829403 2305236 2305236 defendant Lincoln Richard   654978 654978 Lincoln, Richard, of Leicester, Leics, shoe maker 3
4829550 2305283 2305283 defendant Baylle Nicholas merchant 654978 654978 Baylle, Nicholas, of Leicester, Leics, merchant 1
4831504 2305885 2305885 defendant dure Thomas   654978 654978 dure, Thomas, of Leicester, Leics, cart wright 1
4831536 2305896 2305896 defendant Wymondeswell John gent 654978 654978 Wymondeswell, John, of Leicester, Leics, gent 1
4831539 2305897 2305897 defendant Wymondeswold John gent 654978 654978 Wymondeswold, John, of Leicester, Leics, gent 1
4834027 2306648 2306648 defendant Noble William   654978 654978 Noble, William, of Leicester, Leics, bell maker 0
4840422 2308544 2308544 defendant Chaumburleyn _em   654978 654978 Chaumburleyn, _em, of Leicester, Leics, brass worker 0
4840436 2308546 2308546 defendant Innocent William potter 654978 654978 Innocent, William, of Leicester, Leics, potter 1
4840570 2308591 2308591 defendant Lantermake Thomas   654978 654978 Lantermake, Thomas, of Leicester, Leics, tracle maker 0
4841689 2308935 2308935 defendant Dyer John dyer 654978 654978 Dyer, John, of Leicester, Leics, dyer 0
4842915 2309325 2309325 defendant Hardewyn Thomas gent 654978 654978 Hardewyn, Thomas, of Leicester, Leics, gent 0
4842917 2309326 2309326 defendant Hardewyn Thomas gent 654978 654978 Hardewyn, Thomas, of Leicester, Leics, gent 0
4844990 2309950 2309950 defendant Richemond William salter 654978 654978 Richemond, William, of Leicester, Leics, salter 0
4845712 2310170 2310170 defendant Lyons Thomas barber 654978 654978 Lyons, Thomas, of Leicester, Leics, barber 0
4847644 2310753 2310753 defendant Wymondesowld John gent 654978 654978 Wymondesowld, John, of Leicester, Leics, gent 0
4849644 2311367 2311367 defendant Godespede John   654978 654978 Godespede, John, of Leicester, Leics, brass worker 4
4851413 2311888 2311888 defendant Beby John mercer 654978 654978 Beby, John, of Leicester, Leics, mercer 0
4851414 2311888 2311888 defendant Hosyer William draper 654978 654978 Hosyer, William, of Leicester, Leics, draper 1
4851993 2312056 2312056 defendant Spede John   654978 654978 Spede, John, of Leicester, Leics, brass worker 3
4853077 2312381 2312381 defendant Ray Adam glover & burgess 654978 654978 Ray, Adam, of Leicester, Leics, glover & burgess 0
4853081 2312382 2312382 defendant Racy Adam   654978 654978 Racy, Adam, of Leicester, Leics, burgess & glove maker 0
4908488 2329209 2329209 defendant Herbert Geoffrey   654978 654978 Herbert, Geoffrey, of Leicester, Leics, bow maker 0
4911874 2330217 2330217 defendant Drewe Robert chapman 654978 654978 Drewe, Robert, of Leicester, Leics, chapman 0
4919270 2332537 2332537 defendant Matheu John shoemaker 654978 654978 Matheu, John, of Leicester, Leics, shoemaker 0
4920773 2333011 2333011 defendant West John butcher 654978 654978 West, John, of Leicester, Leics, butcher 0
4920785 2333014 2333014 defendant Palmer William gent 654978 654978 Palmer, William, of Leicester, Leics, gent 1
4923349 2333731 2333731 defendant Hoton Robert mercer 654978 654978 Hoton, Robert, of Leicester, Leics, mercer 0
4923356 2333732 2333732 defendant Hoton Robert mercer 654978 654978 Hoton, Robert, of Leicester, Leics, 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);