names

196 rows where place_id = 587248

✎ 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
3590904 1864782 1864782 defendant Beamounde John yeoman 587248 587248 Beamounde, John, of Wynchecombe, yeoman 0
3595070 1866091 1866091 defendant Hawekeslowe John gent 587248 587248 Hawekeslowe, John, of Wynchecombe, gent 0
3595073 1866092 1866092 defendant Hawkeslowe John gent 587248 587248 Hawkeslowe, John, of Wynchecombe, gent 0
3602118 1868327 1868327 defendant Justyce Joan widow 587248 587248 Justyce, Joan, of Wynchecombe, widow 0
3625136 1875396 1875396 defendant Alman Robert cordwainer 587248 587248 Alman, Robert, of Wynchecombe, cordwainer 1
3625138 1875396 1875396 defendant Tanner Richard tanner 587248 587248 Tanner, Richard, of Wynchecombe, tanner 3
3629426 1904059 1904059 defendant Spycer William spicer 587248 587248 Spycer, William, of Wynchecombe, spicer 0
3645930 1909119 1909119 defendant Coke William yeoman 587248 587248 Coke, William, of Wynchecombe, yeoman 0
3646458 1909289 1909289 defendant Palmer John tailor 587248 587248 Palmer, John, of Wynchecombe, tailor 0
3646460 1909290 1909290 defendant Palmer John tailor 587248 587248 Palmer, John, of Wynchecombe, tailor 0
3675686 1918427 1918427 defendant Hopkyns John husbandman 587248 587248 Hopkyns, John, of Wynchecombe, husbandman 0
3692578 1923865 1923865 defendant Mariman Richard husbandman 587248 587248 Mariman, Richard, of Wynchecombe, husbandman 0
3692579 1923865 1923865 defendant Coke William husbandman 587248 587248 Coke, William, of Wynchecombe, husbandman 1
3692580 1923865 1923865 defendant Bocher William butcher 587248 587248 Bocher, William, of Wynchecombe, butcher 2
3692581 1923865 1923865 defendant Palmer John tailor 587248 587248 Palmer, John, of Wynchecombe, tailor 3
3692582 1923865 1923865 defendant Abynden John husbandman 587248 587248 Abynden, John, of Wynchecombe, husbandman 4
3714620 1930869 1930869 defendant Barkerdale Henry tanner 587248 587248 Barkerdale, Henry, of Wynchecombe, tanner 0
3727059 1934729 1934729 defendant Stok Thomas clerk 587248 587248 Stok, Thomas, of Wynchecombe, clerk 1
3738045 1938115 1938115 defendant Hammes William sherman 587248 587248 Hammes, William, of Wynchecombe, sherman 0
3748815 1941565 1941565 plaintiff Hannyes William tucker 587248 587248 Hannyes, William, of Wynchecombe, tucker 0
3788301 1954139 1954139 plaintiff Smyth John laborer 587248 587248 Smyth, John, of Wynchecombe, laborer 0
3788302 1954139 1954139 defendant Dolfyn Robert shoemaker 587248 587248 Dolfyn, Robert, of Wynchecombe, shoemaker 0
3788303 1954139 1954139 defendant Coke William laborer 587248 587248 Coke, William, of Wynchecombe, laborer 1
3804554 1959365 1959365 plaintiff Smyth John laborer 587248 587248 Smyth, John, of Wynchecombe, laborer 0
3804555 1959365 1959365 defendant Dolfyn Robert shoemaker 587248 587248 Dolfyn, Robert, of Wynchecombe, shoemaker 0
3804556 1959365 1959365 defendant Coke William laborer 587248 587248 Coke, William, of Wynchecombe, laborer 1
3804557 1959366 1959366 plaintiff Smyth John laborer 587248 587248 Smyth, John, of Wynchecombe, laborer 0
3804558 1959366 1959366 defendant Dolfyn Robert shoemaker 587248 587248 Dolfyn, Robert, of Wynchecombe, shoemaker 0
3804559 1959366 1959366 defendant Coke William laborer 587248 587248 Coke, William, of Wynchecombe, laborer 1
3832530 1968092 1968092 defendant Brugeman John laborer 587248 587248 Brugeman, John, of Wynchecombe, laborer 0
3833643 1968456 1968456 defendant Reglan Thomas gent 587248 587248 Reglan, Thomas, of Wynchecombe, gent 2
3905569 1992131 1992131 defendant Barkysdale alias Tanner Henry tanner 587248 587248 Barkysdale alias Tanner, Henry, of Wynchecombe, tanner 0
3918665 1996570 1996570 defendant Stratford John, junior gent 587248 587248 Stratford, John, junior, of Wynchecombe, gent 0
3919257 1996771 1996771 defendant Orpyn Henry clothier 587248 587248 Orpyn, Henry, of Wynchecombe, clothier 0
3925182 1998733 1998733 defendant Holester Nicholas yeoman 587248 587248 Holester, Nicholas, of Wynchecombe, yeoman 0
3974868 2015774 2015774 defendant Mace Thomas yeoman 587248 587248 Mace, Thomas, of Wynchecombe, yeoman 0
3974869 2015774 2015774 defendant Smythe Thomas yeoman 587248 587248 Smythe, Thomas, of Wynchecombe, yeoman 1
3999717 2024660 2024660 defendant Clementon Richard yeoman 587248 587248 Clementon, Richard, of Wynchecombe, yeoman 3
4027181 2034367 2034367 defendant Nicoll Henry laborer 587248 587248 Nicoll, Henry, of Wynchecombe, laborer 1
4027182 2034367 2034367 defendant Clement Henry laborer 587248 587248 Clement, Henry, of Wynchecombe, laborer 2
4044381 2040444 2040444 defendant Hunte Thomas yeoman 587248 587248 Hunte, Thomas, of Wynchecombe, yeoman 0
4044383 2040445 2040445 defendant Hunte Thomas yeoman 587248 587248 Hunte, Thomas, of Wynchecombe, yeoman 0
4092686 2057695 2057695 defendant Moy John husbandman 587248 587248 Moy, John, of Wynchecombe, husbandman 2
4107595 2062999 2062999 defendant Bollar Alice widow 587248 587248 Bollar, Alice, of Wynchecombe, widow 0
4121854 2068113 2068113 defendant Pryckett William tailor 587248 587248 Pryckett, William, of Wynchecombe, tailor 0
4125631 2069452 2069452 defendant Pryckett Edward yeoman 587248 587248 Pryckett, Edward, of Wynchecombe, yeoman 1
4130178 2071101 2071101 defendant Turner Simon yeoman 587248 587248 Turner, Simon, of Wynchecombe, yeoman 0
4148843 2077716 2077716 defendant Pryckett Edward yeoman 587248 587248 Pryckett, Edward, of Wynchecombe, yeoman 1
4154543 2079681 2079681 defendant Stumer Reginald yeoman 587248 587248 Stumer, Reginald, of Wynchecombe, yeoman 3
4170056 2085021 2085021 defendant Borton William yeoman 587248 587248 Borton, William, of Wynchecombe, yeoman 1
4180197 2088555 2088555 defendant Stratford Edward gent 587248 587248 Stratford, Edward, of Wynchecombe, gent 3
4183147 2089586 2089586 defendant Powell Richard gent 587248 587248 Powell, Richard, of Wynchecombe, gent 1
4194699 2093702 2093702 defendant Dyke Augustine gent 587248 587248 Dyke, Augustine, of Wynchecombe, gent 0
4240333 2109743 2109743 defendant Hurste Henry yeoman 587248 587248 Hurste, Henry, of Wynchecombe, yeoman 1
4240336 2109744 2109744 defendant Hurste Henry yeoman 587248 587248 Hurste, Henry, of Wynchecombe, yeoman 1
4281176 2123323 2123323 defendant Tyler Guy husbandman 587248 587248 Tyler, Guy, of Wynchecombe, husbandman 0
4298744 2129651 2129651 defendant Blake William gent 587248 587248 Blake, William, of Wynchecombe, gent 0
4305629 2132104 2132104 defendant Burton William yeoman 587248 587248 Burton, William, of Wynchecombe, yeoman 0
4320891 2137400 2137400 defendant Baylies Robert mercer 587248 587248 Baylies, Robert, of Wynchecombe, yeoman, mercer 1
4321698 2137680 2137680 defendant Snowe John weaver 587248 587248 Snowe, John, of Wynchecombe, weaver 2
4330959 2140655 2140655 defendant Turnor Simon tailor 587248 587248 Turnor, Simon, of Wynchecombe, tailor 0
4330961 2140655 2140655 defendant Burton Thomas tailor 587248 587248 Burton, Thomas, of Wynchecombe, tailor 2
4413229 2169009 2169009 plaintiff atte Wode John   587248 587248 atte Wode, John, of Wynchecombe, junior 0
4485225 2196083 2196083 plaintiff Punchard Walter   587248 587248 Punchard, Walter, of Wynchecombe 0
4495241 2199190 2199190 defendant Neweman John   587248 587248 Neweman, John, of Wynchecombe 5
4504662 2202000 2202000 defendant Boteler Henry   587248 587248 Boteler, Henry, of Wynchecombe 3
4510435 2203721 2203721 defendant Stanbroke Robert   587248 587248 Stanbroke, Robert, of Wynchecombe 0
4510513 2203753 2203753 defendant Skynner Walter   587248 587248 Skynner, Walter, of Wynchecombe 0
4523260 2207599 2207599 defendant Skynnere Walter   587248 587248 Skynnere, Walter, of Wynchecombe 1
4523265 2207601 2207601 defendant Turnour William   587248 587248 Turnour, William, of Wynchecombe 1
4523267 2207601 2207601 defendant Skynnere Walter   587248 587248 Skynnere, Walter, of Wynchecombe 3
4523605 2207707 2207707 defendant Bakere Robert   587248 587248 Bakere, Robert, of Wynchecombe 0
4523607 2207708 2207708 defendant Bakere Robert   587248 587248 Bakere, Robert, of Wynchecombe 0
4541877 2213352 2213352 defendant Tornour William   587248 587248 Tornour, William, of Wynchecombe 0
4541878 2213352 2213352 defendant Bloxsam William   587248 587248 Bloxsam, William, of Wynchecombe 1
4546855 2214945 2214945 defendant Baker Robert   587248 587248 Baker, Robert, of Wynchecombe 0
4550596 2216131 2216131 defendant Chamburleyn Stephen   587248 587248 Chamburleyn, Stephen, of Wynchecombe 1
4565913 2220894 2220894 defendant Chamburleyn Stephen   587248 587248 Chamburleyn, Stephen, of Wynchecombe 1
4571157 2222550 2222550 defendant Walker Henry   587248 587248 Walker, Henry, of Wynchecombe 0
4589070 2227960 2227960 defendant Jay William   587248 587248 Jay, William, of Wynchecombe 1
4609831 2234168 2234168 plaintiff Busshe John   587248 587248 Busshe, John, of Wynchecombe 0
4620407 2237362 2237362 defendant Dyer Thomas   587248 587248 Dyer, Thomas, of Wynchecombe 1
4633253 2241271 2241271 plaintiff Warre John   587248 587248 Warre, John, of Wynchecombe 0
4637083 2242402 2242402 defendant Maryner William   587248 587248 Maryner, William, of Wynchecombe 0
4669795 2256254 2256254 plaintiff Bradeley William   587248 587248 Bradeley, William, of Wynchecombe, abbot & brother 0
4677442 2258560 2258560 defendant Neweman John husbandman 587248 587248 Neweman, John, of Wynchecombe, husbandman 2
4691329 2262810 2262810 defendant Baker Richard husbandman 587248 587248 Baker, Richard, of Wynchecombe, husbandman 0
4709179 2268236 2268236 defendant Boteler Henry yeoman 587248 587248 Boteler, Henry, of Wynchecombe, yeoman 3
4717047 2270660 2270660 defendant Stoke John   587248 587248 Stoke, John, of Wynchecombe, mason 0
4725209 2273180 2273180 defendant Smale Henry yeoman 587248 587248 Smale, Henry, of Wynchecombe, yeoman 0
4746364 2279434 2279434 defendant Eyse William chaplain 587248 587248 Eyse, William, of Wynchecombe, chaplain 0
4746365 2279434 2279434 defendant Put John laborer 587248 587248 Put, John, of Wynchecombe, laborer 1
4781429 2290199 2290199 defendant Scot Thomas husbandman 587248 587248 Scot, Thomas, of Wynchecombe, husbandman 0
4792858 2293856 2293856 defendant Peyntour John yeoman 587248 587248 Peyntour, John, of Wynchecombe, yeoman 1
4800665 2296390 2296390 plaintiff Webbe William   587248 587248 Webbe, William, of Wynchecombe 0
4809608 2299168 2299168 defendant Glover Thomas glover 587248 587248 Glover, Thomas, of Wynchecombe, glover 2
4814800 2300742 2300742 defendant Shapster Rose widow 587248 587248 Shapster, Rose, of Wynchecombe, widow 0
4847678 2310766 2310766 defendant Kempe William husbandman 587248 587248 Kempe, William, of Wynchecombe, husbandman 0
4852190 2312113 2312113 defendant Kempe William chapman 587248 587248 Kempe, William, of Wynchecombe, chapman 0
4863302 2315488 2315488 defendant Mason John   587248 587248 Mason, John, of Wynchecombe, mason 4

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