names

170 rows where place_id = 594470

✎ 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
3616244 1872722 1872722 defendant Stanley Lionel yeoman 594470 594470 Stanley, Lionel, of Suthwerk, Surrey, yeoman 0
3628510 1903786 1903786 defendant Michell Robert   594470 594470 Michell, Robert, of Suthwerk, Surrey, parson of Warbylton 0
3680556 1920000 1920000 defendant Clerke Richard yeoman 594470 594470 Clerke, Richard, of Suthwerk, Surrey, yeoman 0
3685223 1921530 1921530 defendant Couper John vintner 594470 594470 Couper, John, of Suthwerk, Surrey, vintner 1
3871824 1980814 1980814 defendant Barwyk John tailor 594470 594470 Barwyk, John, of Suthwerk, Surrey, tailor 0
4448521 2184466 2184466 defendant Stauunard Geoffrey   594470 594470 Stauunard, Geoffrey, of Suthwerk, Surrey 0
4603226 2232215 2232215 plaintiff Wilton Thomas   594470 594470 Wilton, Thomas, of Suthwerk, Surrey 0
4662799 2249823 2249823 defendant Credy Richard ostler 594470 594470 Credy, Richard, of Suthwerk, Surrey, ostler 0
4677515 2258581 2258581 defendant Reve John master of St Thomas' hospital 594470 594470 Reve, John, of Suthwerk, Surrey, master of St Thomas' hospital 0
4695078 2263953 2263953 defendant Ferrour Adam smith 594470 594470 Ferrour, Adam, of Suthwerk, Surrey, smith 1
4699941 2265413 2265413 defendant Cassous or Cassons John esq 594470 594470 Cassous or Cassons, John, of Suthwerk, Surrey, esq 2
4699958 2265415 2265415 defendant Cassons John esq 594470 594470 Cassons, John, of Suthwerk, Surrey, esq 2
4704130 2266670 2266670 defendant Quykke John tailor 594470 594470 Quykke, John, of Suthwerk, Surrey, tailor 0
4704870 2266901 2266901 defendant Russell John husbandman 594470 594470 Russell, John, of Suthwerk, Surrey, husbandman 0
4710381 2268602 2268602 plaintiff Pyndere Richard   594470 594470 Pyndere, Richard, of Suthwerk, Surrey 0
4718161 2271018 2271018 defendant Caldewell John yeoman 594470 594470 Caldewell, John, of Suthwerk, Surrey, yeoman 2
4720171 2271653 2271653 defendant Barton Thomas esq 594470 594470 Barton, Thomas, of Suthwerk, Surrey, esq 0
4721726 2272132 2272132 defendant Potenam Walter   594470 594470 Potenam, Walter, of Suthwerk, Surrey, girdle maker 1
4722446 2272339 2272339 defendant Segrave Walter   594470 594470 Segrave, Walter, of Suthwerk, Surrey 0
4730178 2274638 2274638 defendant Chaumbre Alice esq 594470 594470 Chaumbre, Alice, of Suthwerk, Surrey, gentlewoman, sometime wife of Roger Chaumbre, of Lyllyngston, Oxon, esq 0
4731636 2275088 2275088 defendant Eton John steweman 594470 594470 Eton, John, of Suthwerk, Surrey, steweman 0
4733453 2275637 2275637 defendant Tyler Richard gent 594470 594470 Tyler, Richard, of Suthwerk, Surrey, gent 1
4733911 2275791 2275791 defendant Poule John clerk 594470 594470 Poule, John, of Suthwerk, Surrey, clerk 0
4737538 2276853 2276853 defendant Berd Robert gent 594470 594470 Berd, Robert, of Suthwerk, Surrey, gent 2
4737577 2276861 2276861 defendant Berd Robert gent 594470 594470 Berd, Robert, of Suthwerk, Surrey, gent 2
4757909 2282850 2282850 defendant Knyght William   594470 594470 Knyght, William, of Suthwerk, Surrey, shoe maker 0
4759539 2283325 2283325 defendant Cristofre Thomas esq 594470 594470 Cristofre, Thomas, of Suthwerk, Surrey, esq 2
4764963 2285018 2285018 defendant Kelyngburn Nicholas hosteler 594470 594470 Kelyngburn, Nicholas, of Suthwerk, Surrey, hosteler 0
4765273 2285121 2285121 defendant Tunbrigge Richard dyer 594470 594470 Tunbrigge, Richard, of Suthwerk, Surrey, dyer 0
4772234 2287288 2287288 defendant Barton Thomas gent 594470 594470 Barton, Thomas, of Suthwerk, Surrey, gent 0
4774559 2288029 2288029 defendant Segarve Walter   594470 594470 Segarve, Walter, of Suthwerk, Surrey, wood monger 0
4775435 2288314 2288314 defendant Hastyngg Edward   594470 594470 Hastyngg, Edward, of Suthwerk, Surrey 0
4778686 2289316 2289316 defendant Asteley Thomas esq 594470 594470 Asteley, Thomas, of Suthwerk, Surrey, esq 1
4780694 2289959 2289959 defendant Pulford alias Idulford Margery spinner 594470 594470 Pulford alias Idulford, Margery, of Suthwerk, Surrey, or of Coventry, spinner 0
4797546 2295401 2295401 defendant Ku John   594470 594470 Ku, John, of Suthwerk, Surrey, soap maker 0
4834425 2306774 2306774 defendant Gargrave William merchant 594470 594470 Gargrave, William, of Suthwerk, Surrey, chapman, alias of York, merchant 0
4838052 2307824 2307824 defendant Pynnowe Alice   594470 594470 Pynnowe, Alice, of Suthwerk, Surrey, widow, formerly wife of Michael Pynnowe 1
4859273 2314274 2314274 defendant Howe William skinner 594470 594470 Howe, William, of Suthwerk, Surrey, skinner 0
4864792 2315962 2315962 defendant Cassons John esq 594470 594470 Cassons, John, of Suthwerk, Surrey, esq 0
4947923 2341337 2341337 defendant Hewes Thomas fellmonger 594470 594470 Hewes, Thomas, of Suthwerk, Surrey, fellmonger 0
4947925 2341338 2341338 defendant Hewes Thomas fellmonger 594470 594470 Hewes, Thomas, of Suthwerk, Surrey, fellmonger 0
4961464 2345390 2345390 defendant Gairgrave John esq 594470 594470 Gairgrave, John, of Suthwerk, Surrey, esq 0
4961593 2345429 2345429 defendant Bernard John yeoman 594470 594470 Bernard, John, of Suthwerk, Surrey, yeoman 0
4985632 2352618 2352618 defendant Braunte Richard vintner 594470 594470 Braunte, Richard, of Suthwerk, Surrey, vintner 0
4988851 2353617 2353617 defendant (not given) Henry prior of Werkworth 594470 594470 Werkworth, Henry, of Suthwerk, Surrey, prior of St Mary's church 0
4991604 2354371 2354371 defendant Lovette Nicholas goldsmith 594470 594470 Lovette, Nicholas, of Suthwerk, Surrey, goldsmith 0
4994049 2355095 2355095 plaintiff Fairfeld Robert   594470 594470 Fairfeld, Robert, of Suthwerk, Surrey 0
4994052 2355096 2355096 plaintiff Fairfeld Robert   594470 594470 Fairfeld, Robert, of Suthwerk, Surrey 0
4994053 2355096 2355096 defendant Northfolke Edward yeoman 594470 594470 Northfolke, Edward, of Suthwerk, Surrey, yeoman 0
4994055 2355097 2355097 plaintiff Fairfeld Robert   594470 594470 Fairfeld, Robert, of Suthwerk, Surrey 0
4994056 2355097 2355097 defendant Northfolke Edward yeoman 594470 594470 Northfolke, Edward, of Suthwerk, Surrey, yeoman 0
4998328 2356372 2356372 defendant Kyrketon William gent 594470 594470 Kyrketon, William, of Suthwerk, Surrey, gent 1
5000438 2356996 2356996 defendant Hewe Thomas fellmonger 594470 594470 Hewe, Thomas, of Suthwerk, Surrey, fellmonger 0
5000441 2356997 2356997 defendant Hewe Thomas fellmonger 594470 594470 Hewe, Thomas, of Suthwerk, Surrey, fellmonger 0
5003052 2357797 2357797 defendant Wenlok John gent 594470 594470 Wenlok, John, of Suthwerk, Surrey, gent 0
5004479 2358208 2358208 defendant Downe Henry   594470 594470 Downe, Henry, of Suthwerk, Surrey, servant 4
5005689 2358560 2358560 defendant Stephenson William   594470 594470 Stephenson, William, of Suthwerk, Surrey, servant 0
5006427 2358778 2358778 defendant Malpas William brewer 594470 594470 (Malpas, William, of Suthwerk, Surrey, brewer 1
5009189 2359575 2359575 defendant Ewer Joan widow 594470 594470 Ewer, Joan, of Suthwerk, Surrey, widow 0
5009692 2359716 2359716 defendant Myddelton John barber 594470 594470 Myddelton, John, of Suthwerk, Surrey, barber 0
5009694 2359717 2359717 defendant Hayward William yeoman 594470 594470 Hayward, William, of Suthwerk, Surrey, yeoman 0
5009698 2359719 2359719 defendant Wynchecombe Thomas yeoman 594470 594470 Wynchecombe, Thomas, of Suthwerk, Surrey, yeoman 0
5011009 2360081 2360081 defendant Creke John butcher 594470 594470 Creke, John, of Suthwerk, Surrey, butcher 0
5011238 2360145 2360145 defendant Baker John husbandman 594470 594470 Baker, John, of Suthwerk, Surrey, brewer, Ryall, Robert, of Water Lambhith, Surrey, husbandman 0
5011242 2360146 2360146 defendant Baker John husbandman 594470 594470 Baker, John, of Suthwerk, Surrey, brewer, Rycall, Robert, of Water Lambehith, Surrey, husbandman 0
5051583 2372093 2372093 defendant Wadyngham William yeoman 594470 594470 Wadyngham, William, of Suthwerk, Surrey, yeoman 2
5055737 2373286 2373286 defendant Bulter Roger fuller 594470 594470 Bulter, Roger, of Suthwerk, Surrey, fuller 1
5064674 2375974 2375974 defendant Gyl- Robert yeoman 594470 594470 Gyl-, Robert, of Suthwerk, Surrey, yeoman 1
5065874 2376314 2376314 defendant Rose Walter carpenter 594470 594470 Rose, Walter, of Suthwerk, Surrey, carpenter 0
5089784 2383387 2383387 defendant Putoft Everard armorer 594470 594470 Putoft, Everard, of Suthwerk, Surrey, armorer 1
5096357 2385366 2385366 defendant Gargrave John esq 594470 594470 Gargrave, John, of Suthwerk, Surrey, esq 0
5098370 2385953 2385953 defendant Butte Thomas husbandman 594470 594470 Butte, Thomas, of Suthwerk, Surrey, husbandman 1
5146172 2400007 2400007 defendant Miller William draper 594470 594470 Miller, William, of Suthwerk, Surrey, draper 0
5148425 2400670 2400670 defendant Fayreford Alexander gent 594470 594470 Fayreford, Alexander, of Suthwerk, Surrey, gent 0
5149392 2400954 2400954 defendant Ponynges Robert esq 594470 594470 Ponynges, Robert, of Suthwerk, Surrey, esq 0
5149394 2400955 2400955 defendant Ponynges Robert esq 594470 594470 Ponynges, Robert, of Suthwerk, Surrey, esq 0
5150958 2401418 2401418 defendant Fayreford Alexander esq 594470 594470 Fayreford, Alexander, of Suthwerk, Surrey, esq 0
5151141 2401474 2401474 defendant Claysson John tailor 594470 594470 Claysson, John, of Suthwerk, Surrey, tailor 2
5153612 2402208 2402208 defendant Fayreford Alexander esq 594470 594470 Fayreford, Alexander, of Suthwerk, Surrey, esq 0
5153722 2402248 2402248 defendant Falmay George fellmonger 594470 594470 Falmay, George, of Suthwerk, Surrey, fellmonger 0
5154439 2402451 2402451 defendant Port William esq 594470 594470 Port, William, of Suthwerk, Surrey, esq 3
5154441 2402452 2402452 plaintiff Levelord Robert gent 594470 594470 Levelord, Robert, of Suthwerk, Surrey, gent 0
5157112 2403221 2403221 defendant Merssheman John sadler 594470 594470 Merssheman, John, of Suthwerk, Surrey, sadler 0
5157117 2403222 2403222 defendant Merssheman John sadler 594470 594470 Merssheman, John, of Suthwerk, Surrey, sadler 0
5157707 2403383 2403383 defendant Byrge Richard butcher 594470 594470 Byrge, Richard, of Suthwerk, Surrey, butcher 0
5157717 2403386 2403386 defendant Byrge Richard butcher 594470 594470 Byrge, Richard, of Suthwerk, Surrey, butcher 0
5159227 2403816 2403816 defendant Bradcok John carpenter 594470 594470 Bradcok, John, of Suthwerk, Surrey, carpenter 1
5159230 2403817 2403817 defendant Bradook John carpenter 594470 594470 Bradook, John, of Suthwerk, Surrey, carpenter 1
5163488 2405052 2405052 defendant Smyth John cardmaker 594470 594470 Smyth, John, of Suthwerk, Surrey, cardmaker 4
5164834 2405446 2405446 defendant atte Stone John butcher 594470 594470 atte Stone, John, of Suthwerk, Surrey, butcher 0
5165401 2405628 2405628 defendant Bekley Thomas yeoman 594470 594470 Bekley, Thomas, of Suthwerk, Surrey, yeoman 2
5169398 2406784 2406784 defendant Claysson John tailor 594470 594470 Claysson, John, of Suthwerk, Surrey, tailor 0
5170950 2407226 2407226 defendant Fayreford Alexander esq 594470 594470 Fayreford, Alexander, of Suthwerk, Surrey, esq 0
5170953 2407227 2407227 defendant Fayreford Alexander gent 594470 594470 Fayreford, Alexander, of Suthwerk, Surrey, gent 0
5173511 2407955 2407955 defendant Byrge Richard butcher 594470 594470 Byrge, Richard, of Suthwerk, Surrey, butcher 0
5174267 2408178 2408178 defendant Cardyffe Thomas brewer 594470 594470 Cardyffe, Thomas, of Suthwerk, Surrey, brewer 0
5174449 2408229 2408229 defendant Bradcok John carpenter 594470 594470 Bradcok, John, of Suthwerk, Surrey, carpenter 1
5174999 2408382 2408382 defendant Chambre Thomas yeoman 594470 594470 Chambre, Thomas, of Suthwerk, Surrey, yeoman 1
5177127 2409001 2409001 defendant Smyth John cardmaker 594470 594470 Smyth, John, of Suthwerk, Surrey, cardmaker 4
5177131 2409002 2409002 defendant Smyth John cardmaker 594470 594470 Smyth, John, of Suthwerk, Surrey, cardmaker 2

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