names

165 rows where place_id = 586160

✎ 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
3588055 1863915 1863915 defendant Smyth Henry chapman 586160 586160 Smyth, Henry, of Henley, chapman 3
3588056 1863915 1863915 defendant Clerk Robert (legal representative) 586160 586160 Clerk, Robert, of Henley, executrix of 4
3622795 1874660 1874660 defendant Blount Thomas chaplain 586160 586160 Blount, Thomas, of Henley, chaplain 1
3627255 1903370 1903370 defendant Oveot Agnes widow 586160 586160 Oveot, Agnes, of Henley, widow 1
3631309 1904602 1904602 defendant Whitman Richard husbandman 586160 586160 Whitman, Richard, of Henley, husbandman 17
3631310 1904602 1904602 defendant Hacche Nicholas husbandman 586160 586160 Hacche, Nicholas, of Henley, husbandman 18
3637485 1906534 1906534 defendant Shymmyng Robert husbandman 586160 586160 Shymmyng, Robert, of Henley, husbandman 0
3642639 1908143 1908143 defendant Tanner James tanner 586160 586160 Tanner, James, of Henley, tanner 0
3649687 1910275 1910275 defendant Stokeley Nicholas cooper 586160 586160 Stokeley, Nicholas, of Henley, cooper 0
3649688 1910275 1910275 defendant Berde William turner 586160 586160 Berde, William, of Henley, turner 1
3659896 1913353 1913353 plaintiff Halys Thomas gent 586160 586160 Halys, Thomas, of Henley, gent 0
3660820 1913649 1913649 defendant Fowle John fuller 586160 586160 Fowle, John, of Henley, fuller 2
3669617 1916435 1916435 defendant Whyghtman William husbandman 586160 586160 Whyghtman, William, of Henley, husbandman 0
3669619 1916436 1916436 defendant Wyghtman William husbandman 586160 586160 Wyghtman, William, of Henley, husbandman 0
3670431 1916708 1916708 defendant Herper John, senior yeoman 586160 586160 Herper, John, senior, of Henley, yeoman 0
3670432 1916708 1916708 defendant Heall Thomas yeoman 586160 586160 Heall, Thomas, of Henley, yeoman 1
3670433 1916708 1916708 defendant Heall John yeoman 586160 586160 Heall, John, of Henley, yeoman 2
3676232 1918613 1918613 defendant Redford William carpenter 586160 586160 Redford, William, of Henley, carpenter 0
3679557 1919674 1919674 defendant Whitman William husbandman 586160 586160 Whitman, William, of Henley, husbandman 3
3691205 1923410 1923410 defendant Baker William baker 586160 586160 Baker, William, of Henley, baker 0
3746045 1940667 1940667 defendant Robynson John yeoman 586160 586160 Robynson, John, of Henley, yeoman 3
3746046 1940667 1940667 defendant Harrys Robert butcher 586160 586160 Harrys, Robert, of Henley, butcher 4
3762714 1945978 1945978 defendant Chybnester Richard tanner 586160 586160 Chybnester, Richard, of Henley, tanner 0
3816965 1963212 1963212 defendant Sterke William tailor 586160 586160 Sterke, William, of Henley, tailor 1
3830295 1967369 1967369 defendant Hemyng Richard yeoman 586160 586160 Hemyng, Richard, of Henley, yeoman 0
3845453 1972136 1972136 defendant Hemyng Richard yeoman 586160 586160 Hemyng, Richard, of Henley, yeoman 0
3849137 1973327 1973327 defendant Harys Robert butcher 586160 586160 Harys, Robert, of Henley, butcher 4
3871260 1980639 1980639 defendant Stone Thomas   586160 586160 Stone, Thomas, of Henley, wax chandler 0
3871261 1980639 1980639 defendant Heynes Thomas tanner 586160 586160 Heynes, Thomas, of Henley, tanner 1
3931806 2000942 2000942 defendant Somer William husbandman 586160 586160 Somer, William, of Henley, husbandman 1
3977106 2016563 2016563 defendant Fruen or Frewen Richard husbandman 586160 586160 Fruen or Frewen, Richard, of Henley, or of Checkers, Oxon, husbandman 1
3980097 2017643 2017643 defendant Bragge Richard husbandman 586160 586160 Bragge, Richard, of Henley, husbandman 0
3983928 2019020 2019020 defendant Graunger Thomas yeoman 586160 586160 Graunger, Thomas, of Henley, yeoman 0
3983929 2019020 2019020 defendant Tewe John husbandman 586160 586160 Tewe, John, of Henley, husbandman 1
4016005 2030418 2030418 plaintiff Rockoule John yeoman 586160 586160 Rockoule, John, of Henley, yeoman 1
4028024 2034675 2034675 defendant Mason John husbandman 586160 586160 Mason, John, of Henley, husbandman 3
4037396 2038034 2038034 defendant Sunderland John miller 586160 586160 Sunderland, John, of Henley, miller 0
4047838 2041675 2041675 defendant Cooke Thomas husbandman 586160 586160 Cooke, Thomas, of Henley, husbandman 0
4059101 2045652 2045652 defendant Greneway John husbandman 586160 586160 Greneway, John, of Henley, or of Cheltenam, Glos, husbandman 0
4068331 2048973 2048973 defendant Smyth Roland shoemaker 586160 586160 Smyth, Roland, of Henley, shoemaker 1
4087223 2055721 2055721 defendant Barrett Henry bargeman 586160 586160 Barrett, Henry, of Henley, bargeman 2
4117660 2066612 2066612 defendant Frewen John yeoman 586160 586160 Frewen, John, of Henley, yeoman 1
4142047 2075392 2075392 defendant Barnehurst alias Banester John husbandman 586160 586160 Barnehurst alias Banester, John, of Henley, husbandman 0
4146321 2076861 2076861 defendant Bodkyn William badger 586160 586160 Bodkyn, William, of Henley, badger 0
4161559 2082110 2082110 defendant Suter Henry yeoman 586160 586160 Suter, Henry, of Henley, yeoman 3
4274707 2121098 2121098 defendant Farrowe Richard yeoman 586160 586160 Farrowe, Richard, of Henley, or of Hurley, Berks, yeoman 0
4304422 2131684 2131684 defendant Smythe Richard husbandman 586160 586160 Smythe, Richard, of Henley, husbandman 1
4306894 2132552 2132552 defendant Frelove Edmund yeoman 586160 586160 Frelove, Edmund, of Henley, yeoman 2
4407955 2167227 2167227 defendant Poole William haberdasher 586160 586160 Poole, William, of Henley, haberdasher 0
4460823 2188447 2188447 defendant Fifhide William   586160 586160 Fifhide, William, of Henley 0
4496584 2199606 2199606 plaintiff Creweley John   586160 586160 Creweley, John, of Henley 0
4511065 2203912 2203912 defendant Merser John   586160 586160 Merser, John, of Henley 0
4522310 2207324 2207324 plaintiff Gratele John   586160 586160 Gratele, John, of Henley 0
4525330 2208264 2208264 plaintiff Ive Geoffrey   586160 586160 Ive, Geoffrey, of Henley 0
4541584 2213262 2213262 plaintiff Wyberd Nicholas   586160 586160 Wyberd, Nicholas, of Henley 0
4541585 2213262 2213262 defendant Walker Thomas   586160 586160 Walker, Thomas, of Henley 0
4542403 2213516 2213516 plaintiff Yve John   586160 586160 Yve, John, of Henley 0
4552351 2216688 2216688 plaintiff Felton Simon   586160 586160 Felton, Simon, of Henley 0
4553176 2216928 2216928 plaintiff Fyssher William   586160 586160 Fyssher, William, of Henley 0
4553541 2217037 2217037 defendant Wedon Robert   586160 586160 Wedon, Robert, of Henley 0
4554937 2217472 2217472 defendant Bratele John   586160 586160 Bratele, John, of Henley 1
4555454 2217642 2217642 plaintiff Hereford Thomas   586160 586160 Hereford, Thomas, of Henley 0
4555746 2217732 2217732 defendant Leyburn William dyer 586160 586160 Leyburn, William, of Henley, dyer 1
4556030 2217827 2217827 defendant Fultoner Simon   586160 586160 Fultoner, Simon, of Henley 0
4570563 2222367 2222367 defendant Walker Thomas   586160 586160 Walker, Thomas, of Henley 0
4571512 2222668 2222668 defendant More William   586160 586160 More, William, of Henley 0
4573406 2223214 2223214 plaintiff Barker William   586160 586160 Barker, William, of Henley 0
4573407 2223214 2223214 defendant Barker John   586160 586160 Barker, John, of Henley 0
4582779 2226051 2226051 plaintiff Felton Simon   586160 586160 Felton, Simon, of Henley 0
4584124 2226456 2226456 defendant Donsepe John   586160 586160 Donsepe, John, of Henley 0
4584125 2226456 2226456 defendant Hasting John   586160 586160 Hasting, John, of Henley 1
4584126 2226456 2226456 defendant Donsepe Robert   586160 586160 Donsepe, Robert, of Henley 2
4584127 2226456 2226456 defendant Derneford John   586160 586160 Derneford, John, of Henley 3
4584129 2226456 2226456 defendant Swetebred John   586160 586160 Swetebred, John, of Henley 5
4584132 2226456 2226456 defendant Cardemaker Thomas   586160 586160 Cardemaker, Thomas, of Henley 8
4584133 2226456 2226456 defendant Skynner John   586160 586160 Skynner, John, of Henley 9
4587771 2227582 2227582 defendant Pacwode William   586160 586160 Pacwode, William, of Henley 0
4587773 2227582 2227582 defendant Tyler Henry   586160 586160 Tyler, Henry, of Henley 2
4587775 2227582 2227582 defendant Scolard John   586160 586160 Scolard, John, of Henley 4
4612556 2234994 2234994 defendant atte Welle William   586160 586160 atte Welle, William, of Henley 2
4613740 2235311 2235311 defendant Brigges Nicholas   586160 586160 Brigges, Nicholas, of Henley 0
4624439 2238628 2238628 defendant Pelton Thomas   586160 586160 Pelton, Thomas, of Henley 3
4624998 2238786 2238786 defendant Pulton Thomas   586160 586160 Pulton, Thomas, of Henley 0
4624999 2238786 2238786 defendant Hosier John   586160 586160 Hosier, John, of Henley 1
4663238 2249970 2249970 defendant Benet John husbandman 586160 586160 Benet, John, of Henley, husbandman 0
4668082 2255722 2255722 defendant Pulton Thomas draper 586160 586160 Pulton, Thomas, of Henley, draper 0
4668084 2255723 2255723 defendant Pulton Thomas draper 586160 586160 Pulton, Thomas, of Henley, draper 0
4676311 2258201 2258201 defendant Syngulton Robert chaplain 586160 586160 Syngulton, Robert, of Henley, chaplain 0
4695244 2263993 2263993 defendant Hopton William yeoman 586160 586160 Hopton, William, of Henley, yeoman 0
4704444 2266766 2266766 plaintiff Illage John   586160 586160 Illage, John, of Henley 0
4711619 2268961 2268961 defendant Skyhuan Thomas yeoman 586160 586160 Skyhuan, Thomas, of Henley, yeoman 4
4712563 2269247 2269247 plaintiff Smyth Richard   586160 586160 Smyth, Richard, of Henley 0
4712564 2269247 2269247 defendant Walker Thomas yeoman 586160 586160 Walker, Thomas, of Henley, yeoman 0
4723216 2272569 2272569 defendant Leyburn William dyer 586160 586160 Leyburn, William, of Henley, dyer 0
4727869 2273959 2273959 defendant Webbe William weaver 586160 586160 Webbe, William, of Henley, weaver 0
4738093 2277017 2277017 defendant Cokkes John tanner 586160 586160 Cokkes, John, of Henley, tanner 1
4741874 2278122 2278122 plaintiff Broun Thomas   586160 586160 Broun, Thomas, of Henley, vicar 0
4746822 2279572 2279572 plaintiff Hosyer Robert   586160 586160 Hosyer, Robert, of Henley 0
4749513 2280337 2280337 defendant West John draper 586160 586160 West, John, of Henley, draper 1
4774352 2287958 2287958 defendant Walton Geoffrey   586160 586160 Walton, Geoffrey, of Henley, servant 1

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