names

155 rows where place_id = 656891

✎ 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
3942175 2004403 2004403 defendant Chambers William   656891 656891 Chambers, William, of Stratford upon Avon, wheel wright 0
3942180 2004404 2004404 defendant Turner George husbandman 656891 656891 Turner, George, of Stratford upon Avon, husbandman 0
3942183 2004404 2004404 defendant Parker Richard smith 656891 656891 Parker, Richard, of Stratford upon Avon, smith 3
4413086 2168966 2168966 plaintiff atte Corne Robert   656891 656891 atte Corne, Robert, of Stratford upon Avon 0
4413087 2168966 2168966 defendant Frere John   656891 656891 Frere, John, of Stratford upon Avon 0
4413681 2169173 2169173 defendant Deystere Simon le   656891 656891 Deystere, Simon le, of Stratford upon Avon 0
4416776 2170115 2170115 plaintiff Page Joan   656891 656891 Page, Joan, of Stratford upon Avon, formerly wife of John Page, son of William Page 0
4420154 2171204 2171204 defendant Deystere Simon le   656891 656891 Deystere, Simon le, of Stratford upon Avon 0
4440125 2181841 2181841 defendant Sa-- Nicholas   656891 656891 Sa--, Nicholas, of Stratford upon Avon 0
4449493 2184788 2184788 defendant Bury William   656891 656891 Bury, William, of Stratford upon Avon 0
4452114 2185648 2185648 plaintiff Ilymndon Richard   656891 656891 Ilymndon, Richard, of Stratford upon Avon, linen draper 0
4452115 2185648 2185648 defendant Smyth John butcher 656891 656891 Smyth, John, of Stratford upon Avon, butcher 0
4482384 2195196 2195196 defendant Mayell John   656891 656891 Mayell, John, of Stratford upon Avon 1
4482391 2195197 2195197 defendant Mayell John   656891 656891 Mayell, John, of Stratford upon Avon 1
4482395 2195197 2195197 defendant Mayell William   656891 656891 Mayell, William, of Stratford upon Avon 5
4486595 2196520 2196520 plaintiff Saucer Nicholas   656891 656891 Saucer, Nicholas, of Stratford upon Avon 0
4486597 2196521 2196521 plaintiff Saucer Nicholas, senior   656891 656891 Saucer, Nicholas, senior, of Stratford upon Avon 0
4495745 2199353 2199353 plaintiff Chapman John   656891 656891 Chapman, John, of Stratford upon Avon 0
4495746 2199353 2199353 defendant Chorleford John, junior   656891 656891 Chorleford, John, junior, of Stratford upon Avon 0
4503547 2201682 2201682 plaintiff Peyntour Robert   656891 656891 Peyntour, Robert, of Stratford upon Avon 0
4511429 2204016 2204016 defendant Vyncent Thomas   656891 656891 Vyncent, Thomas, of Stratford upon Avon 0
4516597 2205603 2205603 plaintiff Compton Thomas, sen   656891 656891 Compton, Thomas, sen, of Stratford upon Avon 0
4522138 2207268 2207268 defendant Torpley Thomas   656891 656891 Torpley, Thomas, of Stratford upon Avon 0
4535422 2211351 2211351 plaintiff Skynnere Nicholas   656891 656891 Skynnere, Nicholas, of Stratford upon Avon 0
4535423 2211351 2211351 defendant Stone Thomas skinner 656891 656891 Stone, Thomas, of Stratford upon Avon, skinner 0
4541338 2213188 2213188 defendant Chilcote Roger   656891 656891 Chilcote, Roger, of Stratford upon Avon 0
4547589 2215181 2215181 defendant Compton Thomas, sen   656891 656891 Compton, Thomas, sen, of Stratford upon Avon 0
4548003 2215308 2215308 defendant James John, sen   656891 656891 James, John, sen, of Stratford upon Avon 0
4568538 2221736 2221736 plaintiff Vyncent Thomas   656891 656891 Vyncent, Thomas, of Stratford upon Avon 0
4570573 2222370 2222370 defendant Besseford John carpenter 656891 656891 Besseford, John, of Stratford upon Avon, carpenter 0
4579083 2224939 2224939 plaintiff Colyer John   656891 656891 Colyer, John, of Stratford upon Avon 0
4597400 2230430 2230430 defendant Taillour William   656891 656891 Taillour, William, of Stratford upon Avon 0
4599693 2231120 2231120 defendant Godechep John   656891 656891 Godechep, John, of Stratford upon Avon 0
4608705 2233828 2233828 defendant Pounde John   656891 656891 Pounde, John, of Stratford upon Avon 0
4641946 2243749 2243749 defendant Brasier William   656891 656891 Brasier, William, of Stratford upon Avon 4
4671979 2256880 2256880 defendant Pound John butcher 656891 656891 Pound, John, of Stratford upon Avon, butcher 0
4678961 2259027 2259027 defendant Pound John butcher 656891 656891 Pound, John, of Stratford upon Avon, butcher 0
4689350 2262230 2262230 defendant Ippesley John elyman or oil maker 656891 656891 Ippesley, John, of Stratford upon Avon, elyman or oil maker 0
4701772 2265953 2265953 defendant Filkes John husbandman 656891 656891 Filkes, John, of Stratford upon Avon, husbandman 0
4709884 2268451 2268451 defendant Halle Richard gent 656891 656891 Halle, Richard, of Stratford upon Avon, gent 0
4722145 2272255 2272255 defendant Salford Hugh yeoman 656891 656891 Salford, Hugh, of Stratford upon Avon, yeoman 0
4726862 2273668 2273668 defendant Power Otswellus gent 656891 656891 Power, Otswellus, of Stratford upon Avon, gent 0
4732452 2275323 2275323 defendant Clyfford John ironmonger 656891 656891 Clyfford, John, of Stratford upon Avon, ironmonger 2
4740216 2277649 2277649 defendant Benet William butcher 656891 656891 Benet, William, of Stratford upon Avon, butcher 0
4741297 2277951 2277951 defendant Blamform Margaret   656891 656891 Blamform, Margaret, of Stratford upon Avon, sheep shearer, & formerly wife of Edmund Blamform 0
4744528 2278925 2278925 defendant Smyth John smith 656891 656891 Smyth, John, of Stratford upon Avon, smith 0
4746692 2279525 2279525 defendant Shepherd Richard husbandman 656891 656891 Shepherd, Richard, of Stratford upon Avon, husbandman 0
4750169 2280523 2280523 defendant Thorp Simon de chapman 656891 656891 Thorp, Simon de, of Stratford upon Avon, chapman 0
4770865 2286868 2286868 plaintiff Rokesley William master of a Guild 656891 656891 Rokesley, William, of Stratford upon Avon, master of a Guild 0
4775223 2288245 2288245 defendant Fretter Thomas butcher 656891 656891 Fretter, Thomas, of Stratford upon Avon, butcher 4
4809963 2299277 2299277 defendant Rokesley William (legal representative) 656891 656891 Rokesley, William, of Stratford upon Avon, executors of 0
4811635 2299749 2299749 defendant Norton Thomas butcher 656891 656891 Norton, Thomas, of Stratford upon Avon, butcher 1
4811638 2299750 2299750 defendant Norton Thomas butcher 656891 656891 Norton, Thomas, of Stratford upon Avon, butcher 1
4817543 2301578 2301578 defendant Kynget John butcher 656891 656891 Kynget, John, of Stratford upon Avon, butcher 0
4817544 2301578 2301578 defendant Beley John yeoman 656891 656891 Beley, John, of Stratford upon Avon, yeoman 1
4817552 2301580 2301580 defendant Madil or Maell John tanner 656891 656891 Madil or Maell, John, of Stratford upon Avon, tanner 0
4824208 2303642 2303642 defendant Smyth Thomas (legal representative) 656891 656891 Smyth, Thomas, of Stratford upon Avon, executors of 4
4827106 2304523 2304523 defendant Taillour Edward tailor 656891 656891 Taillour, Edward, of Stratford upon Avon, tailor 0
4827110 2304524 2304524 defendant Tayllour Edward tailor 656891 656891 Tayllour, Edward, of Stratford upon Avon, tailor 0
4827111 2304524 2304524 defendant Thorppley Richard laborer 656891 656891 Thorppley, Richard, of Stratford upon Avon, laborer 1
4827163 2304541 2304541 defendant Halle Richard gent 656891 656891 Halle, Richard, of Stratford upon Avon, gent 0
4827164 2304541 2304541 defendant Salford Hugh gent 656891 656891 Salford, Hugh, of Stratford upon Avon, gent 1
4830365 2305530 2305530 plaintiff Bid Henry   656891 656891 Bid, Henry, of Stratford upon Avon 0
4831120 2305765 2305765 defendant Mayell Nicholas hosier 656891 656891 Mayell, Nicholas, of Stratford upon Avon, hosier 1
4831780 2305958 2305958 defendant Bole Richard husbandman 656891 656891 Bole, Richard, of Stratford upon Avon, husbandman 2
4831781 2305958 2305958 defendant Brule John tanner 656891 656891 Brule, John, of Stratford upon Avon, tanner 3
4840943 2308701 2308701 defendant Brasyer John butcher 656891 656891 Brasyer, John, of Stratford upon Avon, butcher 3
4852037 2312069 2312069 defendant Bryd Henry salter 656891 656891 Bryd, Henry, of Stratford upon Avon, salter 0
4909319 2329457 2329457 defendant Brag Robert weaver 656891 656891 Brag, Robert, of Stratford upon Avon, weaver 0
4924495 2334100 2334100 defendant Lee John butcher 656891 656891 Lee, John, of Stratford upon Avon, butcher 0
4926000 2334562 2334562 defendant Bryan William chapman 656891 656891 Bryan, William, of Stratford upon Avon, chapman 2
4927213 2334947 2334947 defendant Fox Richard tanner 656891 656891 Fox, Richard, of Stratford upon Avon, tanner 2
4928281 2335272 2335272 defendant Hore Thomas husbandman 656891 656891 Hore, Thomas, of Stratford upon Avon, husbandman 2
4928711 2335404 2335404 defendant Blamford John glover 656891 656891 Blamford, John, of Stratford upon Avon, glover 0
4929728 2335716 2335716 defendant Mayell Thomas draper 656891 656891 (Mayell, Thomas, of Stratford upon Avon, draper 1
4932033 2336407 2336407 defendant Marnham Richard glover 656891 656891 Marnham, Richard, of Stratford upon Avon, glover 0
4932353 2336516 2336516 defendant Brasyer William tanner 656891 656891 Brasyer, William, of Stratford upon Avon, tanner 0
4998911 2356557 2356557 plaintiff Kynges John   656891 656891 Kynges, John, of Stratford upon Avon 0
4998912 2356557 2356557 defendant Gilbert William husbandman 656891 656891 Gilbert, William, of Stratford upon Avon, husbandman 0
5051218 2371980 2371980 defendant Fyssher John elymaker 656891 656891 Fyssher, John, of Stratford upon Avon, elymaker 0
5127753 2394597 2394597 defendant Haunys John   656891 656891 Haunys, John, of Stratford upon Avon 0
5135965 2397031 2397031 defendant Holandon John yeoman 656891 656891 Holandon, John, of Stratford upon Avon, yeoman 3
5150704 2401352 2401352 defendant Welottes William tanner 656891 656891 Welottes, William, of Stratford upon Avon, tanner 3
5150712 2401353 2401353 defendant Welottes William tanner 656891 656891 Welottes, William, of Stratford upon Avon, tanner 3
5153714 2402244 2402244 defendant Handes John woolman 656891 656891 Handes, John, of Stratford upon Avon, woolman 0
5156242 2402986 2402986 defendant Holandon John yeoman 656891 656891 Holandon, John, of Stratford upon Avon, yeoman 1
5156252 2402987 2402987 defendant Holandon John yeoman 656891 656891 Holandon, John, of Stratford upon Avon, yeoman 1
5156264 2402988 2402988 defendant Holandon John yeoman 656891 656891 Holandon, John, of Stratford upon Avon, yeoman 3
5161113 2404350 2404350 defendant Mordok Roger shoemaker 656891 656891 Mordok, Roger, of Stratford upon Avon, shoemaker 0
5168839 2406616 2406616 defendant Welettes William tanner 656891 656891 Welettes, William, of Stratford upon Avon, tanner 3
5171022 2407249 2407249 defendant Handes John woolman 656891 656891 Handes, John, of Stratford upon Avon, woolman 0
5175626 2408556 2408556 defendant M_dok Roger   656891 656891 M_dok, Roger, of Stratford upon Avon, shoe maker 0
5194162 2414026 2414026 defendant Bocher Roger butcher 656891 656891 Bocher, Roger, of Stratford upon Avon, butcher 0
5208588 2418241 2418241 defendant Bocher Roger butcher 656891 656891 Bocher, Roger, of Stratford upon Avon, butcher 0
5213532 2419691 2419691 defendant Milleward Robert yeoman 656891 656891 Milleward, Robert, of Stratford upon Avon, yeoman 0
5213533 2419691 2419691 defendant Bocher Robert yeoman 656891 656891 Bocher, Robert, of Stratford upon Avon, yeoman 1
5297896 2444393 2444393 defendant Hope Robert tailor 656891 656891 Hope, Robert, of Stratford upon Avon, tailor 0
5297897 2444393 2444393 defendant Pryket Robert   656891 656891 Pryket, Robert, of Stratford upon Avon, wheel wright 1
5300714 2445177 2445177 defendant Bery William gent 656891 656891 Bery, William, of Stratford upon Avon, gent 0
5307907 2447381 2447381 defendant Yong John yeoman 656891 656891 Yong, John, of Stratford upon Avon, yeoman 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);