names

249 rows where place_id = 587983

✎ 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
3593031 1865448 1865448 defendant Byrd Richard glover 587983 587983 Byrd, Richard, of Chepyng Wycombe, glover 1
3599122 1867362 1867362 defendant Cary Richard gent 587983 587983 Cary, Richard, of Chepyng Wycombe, gent 0
3600798 1867910 1867910 defendant Watson Christopher fuller 587983 587983 Watson, Christopher, of Chepyng Wycombe, fuller 0
3607256 1869933 1869933 defendant Barnard Richard yeoman or tanner 587983 587983 Barnard, Richard, of Chepyng Wycombe, yeoman or tanner 0
3609346 1870584 1870584 defendant Barre Richard husbandman 587983 587983 Barre, Richard, of Chepyng Wycombe, husbandman 0
3609347 1870584 1870584 defendant West John tailor 587983 587983 West, John, of Chepyng Wycombe, tailor 1
3609349 1870585 1870585 defendant Tyngewyke Richard yeoman 587983 587983 Tyngewyke, Richard, of Chepyng Wycombe, yeoman 0
3613223 1871789 1871789 defendant Shrympton William husbandman 587983 587983 Shrympton, William, of Chepyng Wycombe, husbandman 2
3619927 1873806 1873806 defendant Peytener John weaver 587983 587983 Peytener, John, of Chepyng Wycombe, weaver 0
3619928 1873806 1873806 defendant West John tailor 587983 587983 West, John, of Chepyng Wycombe, tailor 1
3619929 1873806 1873806 defendant Russell William carpenter 587983 587983 Russell, William, of Chepyng Wycombe, carpenter 2
3619935 1873809 1873809 defendant West John tailor 587983 587983 West, John, of Chepyng Wycombe, tailor 0
3619936 1873809 1873809 defendant Russell William carpenter 587983 587983 Russell, William, of Chepyng Wycombe, carpenter 1
3619937 1873809 1873809 defendant Peytener John weaver 587983 587983 Peytener, John, of Chepyng Wycombe, weaver 2
3625631 1875550 1875550 defendant Lawson Henry tailor 587983 587983 Lawson, Henry, of Chepyng Wycombe, tailor 1
3633242 1905212 1905212 defendant Wytney Stephen laborer 587983 587983 Wytney, Stephen, of Chepyng Wycombe, laborer 1
3636978 1906361 1906361 defendant Baven Thomas tailor 587983 587983 Baven, Thomas, of Chepyng Wycombe, tailor 1
3636979 1906361 1906361 defendant Aley William yeoman 587983 587983 Aley, William, of Chepyng Wycombe, yeoman 2
3636980 1906361 1906361 defendant Brassebrygge John clothier 587983 587983 Brassebrygge, John, of Chepyng Wycombe, clothier 3
3636981 1906361 1906361 defendant Aloye Thomas yeoman 587983 587983 Aloye, Thomas, of Chepyng Wycombe, yeoman 4
3638807 1906958 1906958 defendant Gybson Christopher baker 587983 587983 Gybson, Christopher, of Chepyng Wycombe, baker 0
3639405 1907134 1907134 defendant Londesdale George sawyer 587983 587983 Londesdale, George, of Chepyng Wycombe, sawyer 1
3654369 1911628 1911628 plaintiff Astbroke Robert   587983 587983 Astbroke, Robert, of Chepyng Wycombe 0
3668414 1916072 1916072 defendant Tomson alias Wyse William tailor 587983 587983 Tomson alias Wyse, William, of Chepyng Wycombe, tailor 0
3668419 1916074 1916074 defendant Cokk Walter alias William miller 587983 587983 Cokk, Walter alias William, of Chepyng Wycombe, miller 1
3670111 1916597 1916597 defendant Wellysburn Thomas baker 587983 587983 Wellysburn, Thomas, of Chepyng Wycombe, baker 0
3674927 1918188 1918188 plaintiff Gybson Christopher (legal representative) 587983 587983 Gybson, Christopher, of Chepyng Wycombe, executors of 0
3681005 1920137 1920137 defendant Bysshop Geoffrey husbandman 587983 587983 Bysshop, Geoffrey, of Chepyng Wycombe, husbandman 0
3681006 1920137 1920137 defendant Wise William tailor 587983 587983 Wise, William, of Chepyng Wycombe, tailor 1
3686091 1921810 1921810 defendant Astbroke William butcher 587983 587983 Astbroke, William, of Chepyng Wycombe, butcher 0
3698836 1925854 1925854 defendant Standysshe Henry hosteler 587983 587983 Standysshe, Henry, of Chepyng Wycombe, hosteler 0
3698837 1925854 1925854 defendant Sauntes Thomas baker 587983 587983 Sauntes, Thomas, of Chepyng Wycombe, baker 1
3698838 1925854 1925854 defendant Cok Walter miller 587983 587983 Cok, Walter, of Chepyng Wycombe, miller 2
3698839 1925854 1925854 defendant Broun John sawyer 587983 587983 Broun, John, of Chepyng Wycombe, sawyer 3
3701466 1926705 1926705 defendant Harryson John yeoman 587983 587983 Harryson, John, of Chepyng Wycombe, yeoman 0
3705466 1928000 1928000 defendant Hamond Thomas glover 587983 587983 Hamond, Thomas, of Chepyng Wycombe, glover 0
3706692 1928378 1928378 defendant Smyth Richard tanner 587983 587983 Smyth, Richard, of Chepyng Wycombe, tanner 0
3706693 1928378 1928378 defendant Serle William sherman 587983 587983 Serle, William, of Chepyng Wycombe, sherman 1
3709100 1929145 1929145 defendant Harryson John yeoman 587983 587983 Harryson, John, of Chepyng Wycombe, yeoman 0
3709101 1929145 1929145 defendant Pusey Christopher husbandman 587983 587983 Pusey, Christopher, of Chepyng Wycombe, husbandman 1
3723732 1933698 1933698 defendant Pusey Christopher husbandman 587983 587983 Pusey, Christopher, of Chepyng Wycombe, husbandman 0
3731238 1935996 1935996 defendant Chalfount William gent 587983 587983 Chalfount, William, of Chepyng Wycombe, gent 1
3731554 1936095 1936095 defendant Adams Thomas glover 587983 587983 Adams, Thomas, of Chepyng Wycombe, glover 0
3731555 1936095 1936095 defendant Standysshe John innholder 587983 587983 Standysshe, John, of Chepyng Wycombe, innholder 1
3731556 1936095 1936095 defendant Russell William miller 587983 587983 Russell, William, of Chepyng Wycombe, miller 2
3733210 1936619 1936619 defendant Smyth Richard tanner 587983 587983 Smyth, Richard, of Chepyng Wycombe, tanner 1
3736730 1937739 1937739 defendant Wynkyll John laborer 587983 587983 Wynkyll, John, of Chepyng Wycombe, laborer 0
3743191 1939734 1939734 defendant Tyler John laborer 587983 587983 Tyler, John, of Chepyng Wycombe, laborer 2
3743192 1939734 1939734 defendant Bysshop Geoffrey laborer 587983 587983 Bysshop, Geoffrey, of Chepyng Wycombe, laborer 3
3744232 1940092 1940092 defendant Wytnall alias Elys William miller 587983 587983 Wytnall alias Elys, William, of Chepyng Wycombe, miller 1
3744233 1940093 1940093 plaintiff Astbroke Robert   587983 587983 Astbroke, Robert, of Chepyng Wycombe 0
3745693 1940561 1940561 plaintiff Byrche Richard   587983 587983 Byrche, Richard, of Chepyng Wycombe 0
3745694 1940561 1940561 defendant Hanson John capper 587983 587983 Hanson, John, of Chepyng Wycombe, capper 0
3750347 1942026 1942026 defendant Scherle William fuller 587983 587983 Scherle, William, of Chepyng Wycombe, fuller 0
3758685 1944710 1944710 defendant Goodson John tanner 587983 587983 Goodson, John, of Chepyng Wycombe, tanner 0
3774361 1949703 1949703 defendant Bysshop Geoffrey husbandman 587983 587983 Bysshop, Geoffrey, of Chepyng Wycombe, husbandman 0
3783102 1952470 1952470 defendant Alsey Richard tailor 587983 587983 Alsey, Richard, of Chepyng Wycombe, tailor 0
3788598 1954235 1954235 defendant Shrympton John fisher 587983 587983 Shrympton, John, of Chepyng Wycombe, fisher 0
3788599 1954235 1954235 defendant Hakker John laborer 587983 587983 Hakker, John, of Chepyng Wycombe, laborer 1
3788600 1954235 1954235 defendant Mersham alias Gravett John laborer 587983 587983 Mersham alias Gravett, John, of Chepyng Wycombe, laborer 2
3799677 1957819 1957819 defendant Alsey Thomas tailor 587983 587983 Alsey, Thomas, of Chepyng Wycombe, tailor 1
3804849 1959462 1959462 defendant Shrympton John   587983 587983 Shrympton, John, of Chepyng Wycombe, tallow chandler 0
3804850 1959462 1959462 defendant Hekker John laborer 587983 587983 Hekker, John, of Chepyng Wycombe, laborer 1
3804851 1959462 1959462 defendant Marsham alias Grevet John laborer 587983 587983 Marsham alias Grevet, John, of Chepyng Wycombe, laborer 2
3811504 1961489 1961489 defendant Flye John smith 587983 587983 Flye, John, of chepyng Wycombe, smith 0
3827194 1966369 1966369 defendant Lysteney John fuller 587983 587983 Lysteney, John, of Chepyng Wycombe, fuller 0
3827196 1966370 1966370 defendant Lysteney John fuller 587983 587983 Lysteney, John, of Chepyng Wycombe, fuller 0
3834192 1968635 1968635 defendant Shrympton John   587983 587983 Shrympton, John, of Chepyng Wycombe, tallow chandler 3
3856866 1975777 1975777 defendant Raunce John husbandman 587983 587983 Raunce, John, of Chepyng Wycombe, husbandman 0
3870413 1980347 1980347 defendant Carber Cuthbert joiner 587983 587983 Carber, Cuthbert, of Chepyng Wycombe, joiner 2
3878016 1982891 1982891 defendant Holdurne Philip tanner 587983 587983 Holdurne, Philip, of Chepyng Wycombe, tanner 0
3883550 1984770 1984770 defendant Coke John maltman 587983 587983 Coke, John, of Chepyng Wycombe, maltman 0
3884234 1984991 1984991 defendant Purwen William yeoman 587983 587983 Purwen, William, of Chepyng Wycombe, yeoman 0
3884853 1985206 1985206 plaintiff Astbroke Robert (legal representative) 587983 587983 Astbroke, Robert, of Chepyng Wycombe, executor of 0
3895561 1988720 1988720 defendant Duffe Richard sawyer 587983 587983 Duffe, Richard, of Chepyng Wycombe, sawyer 0
3905510 1992112 1992112 defendant Okeley John laborer 587983 587983 Okeley, John, of Chepyng Wycombe, laborer 1
3917342 1996158 1996158 defendant Wynche William tanner 587983 587983 Wynche, William, of Chepyng Wycombe, tanner 0
3981413 2018118 2018118 defendant Shrympton John, senior husbandman 587983 587983 Shrympton, John, senior, of Chepyng Wycombe, husbandman 2
3981415 2018118 2018118 defendant Sexten Christopher husbandman 587983 587983 Sexten, Christopher, of Chepyng Wycombe, husbandman 4
3981416 2018118 2018118 defendant Gybbes Robert husbandman 587983 587983 Gybbes, Robert, of Chepyng Wycombe, husbandman 5
3981417 2018118 2018118 defendant Ratclyff Thomas fuller 587983 587983 Ratclyff, Thomas, of Chepyng Wycombe, fuller 6
3981418 2018118 2018118 defendant Holte Isabel widow 587983 587983 Holte, Isabel, of Chepyng Wycombe, widow 7
3989410 2020951 2020951 defendant Waley John yeoman 587983 587983 Waley, John, of Chepyng Wycombe, yeoman 1
4009026 2027993 2027993 defendant Newman Walter laborer 587983 587983 Newman, Walter, of Chepyng Wycombe, laborer 0
4009027 2027993 2027993 defendant Newman Roger laborer 587983 587983 Newman, Roger, of Chepyng Wycombe, laborer 1
4154438 2079644 2079644 defendant Raunce Robert, senior gent 587983 587983 Raunce, Robert, senior, of Chepyng Wycombe, gent 0
4154439 2079644 2079644 defendant Mundey William clothier 587983 587983 Mundey, William, of Chepyng Wycombe, clothier 1
4171165 2085382 2085382 defendant Mundey William clothier 587983 587983 Mundey, William, of Chepyng Wycombe, clothier 0
4203325 2096710 2096710 defendant Kempe Thomas mercer 587983 587983 Kempe, Thomas, of Chepyng Wycombe, mercer 0
4209214 2098775 2098775 defendant Smythe John yeoman 587983 587983 Smythe, John, of Chepyng Wycombe, yeoman 0
4209215 2098775 2098775 defendant Wynchester alias Moyer Thomas laborer 587983 587983 Wynchester alias Moyer, Thomas, of Chepyng Wycombe, laborer 1
4248231 2112399 2112399 defendant Raunce Robert gent 587983 587983 Raunce, Robert, of Chepyng Wycombe, gent 0
4826428 2304303 2304303 plaintiff Wellisbourne John   587983 587983 Wellisbourne, John, of Chepyng Wycombe, on his own account 0
5091021 2383771 2383771 defendant Fyssher Walter fletcher 587983 587983 Fyssher, Walter, of Chepyng Wycombe, fletcher 0
5114550 2390660 2390660 defendant Benford Hugh husbandman 587983 587983 Benford, Hugh, of Chepyng Wycombe, husbandman 0
5114551 2390660 2390660 defendant Bisshop Henry yeoman 587983 587983 Bisshop, Henry, of Chepyng Wycombe, yeoman 1
5118009 2391696 2391696 defendant Benford Hugh miller 587983 587983 Benford, Hugh, of Chepyng Wycombe, miller 0
5118010 2391696 2391696 defendant Streteley John miller 587983 587983 Streteley, John, of Chepyng Wycombe, miller 1
5118011 2391696 2391696 defendant Michell Thomas miller 587983 587983 Michell, Thomas, of Chepyng Wycombe, miller 2
5148186 2400615 2400615 defendant Colyns Robert butcher 587983 587983 Colyns, Robert, of Chepyng Wycombe, butcher 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);