names

186 rows where place_id = 586852

✎ 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
3589810 1864454 1864454 defendant Tyngewyke Henry husbandman 586852 586852 Tyngewyke, Henry, of Twyford, husbandman 0
3589812 1864454 1864454 defendant Creyton John husbandman 586852 586852 Creyton, John, of Twyford, husbandman 2
3592665 1865319 1865319 defendant Bland Thomas husbandman 586852 586852 Bland, Thomas, of Twyford, husbandman 0
3616219 1872714 1872714 defendant Craneworth alias Plumton John smith 586852 586852 Craneworth alias Plumton, John, of Twyford, smith 2
3619833 1873779 1873779 defendant Turner John, junior husbandman 586852 586852 Turner, John, junior, of Twyford, husbandman 1
3631142 1904562 1904562 defendant Mawndefyld John husbandman 586852 586852 Mawndefyld, John, of Twyford, husbandman 0
3643537 1908407 1908407 defendant Laueraunce Richard butcher 586852 586852 Laueraunce, Richard, of Twyford, butcher 0
3643539 1908408 1908408 defendant Laueraunce Richard butcher 586852 586852 Laueraunce, Richard, of Twyford, butcher 0
3647227 1909518 1909518 defendant Bayton Thomas miller 586852 586852 Bayton, Thomas, of Twyford, miller 5
3656643 1912330 1912330 defendant Atplouogh George   586852 586852 Atplouogh, George, of Twyford, inn holder 2
3658360 1912864 1912864 defendant Dale Robert salter 586852 586852 Dale, Robert, of Twyford, salter 0
3658362 1912864 1912864 defendant Wodward Thomas laborer 586852 586852 Wodward, Thomas, of Twyford, laborer 2
3658363 1912864 1912864 defendant Adams Reginald miller 586852 586852 Adams, Reginald, of Twyford, miller 3
3659052 1913094 1913094 defendant Gyfford Joan widow 586852 586852 Gyfford, Joan, of Twyford, widow 1
3697172 1925337 1925337 defendant Adams Reginald innholder 586852 586852 Adams, Reginald, of Twyford, innholder 0
3703598 1927402 1927402 defendant Godman William weaver 586852 586852 Godman, William, of Twyford, weaver 0
3761023 1945451 1945451 plaintiff Durrant John   586852 586852 Durrant, John, of Twyford 0
3761024 1945451 1945451 plaintiff Falowes Walter tailor 586852 586852 Falowes, Walter, of Twyford, tailor 1
3761025 1945451 1945451 defendant Asshby William gent 586852 586852 Asshby, William, of Twyford, gent 0
3765715 1946942 1946942 defendant Plough John butcher 586852 586852 Plough, John, of Twyford, butcher 0
3799985 1957918 1957918 defendant Plough John butcher 586852 586852 Plough, John, of Twyford, butcher 0
3832903 1968216 1968216 defendant Clerke Henry   586852 586852 Clerke, Henry, of Twyford, wheelwright 0
3853435 1974701 1974701 defendant Adams Reginald innholder 586852 586852 Adams, Reginald, of Twyford, innholder 0
3853439 1974702 1974702 defendant Adams Reginald innholder 586852 586852 Adams, Reginald, of Twyford, innholder 0
3859718 1976751 1976751 plaintiff Coke John gent 586852 586852 Coke, John, of Twyford, gent 0
3882116 1984276 1984276 defendant Hoker Nicholas clerk 586852 586852 Hoker, Nicholas, of Twyford, clerk 2
3882120 1984277 1984277 defendant Hoker Nicholas clerk 586852 586852 Hoker, Nicholas, of Twyford, clerk 2
3882316 1984343 1984343 defendant Touneshend Robert esq 586852 586852 Touneshend, Robert, of Twyford, esq 1
3886125 1985609 1985609 defendant Topleys Humphrey husbandman 586852 586852 Topleys, Humphrey, of Twyford, husbandman 1
3925821 1998954 1998954 defendant Yatys John husbandman 586852 586852 Yatys, John, of Twyford, husbandman 0
3925822 1998954 1998954 defendant Rogers John laborer 586852 586852 Rogers, John, of Twyford, laborer 1
3925823 1998954 1998954 defendant Tomlynson Richard tailor 586852 586852 Tomlynson, Richard, of Twyford, tailor 2
3925824 1998954 1998954 defendant Pryor Thomas husbandman 586852 586852 Pryor, Thomas, of Twyford, husbandman 3
3925825 1998954 1998954 defendant Chator John husbandman 586852 586852 Chator, John, of Twyford, husbandman 4
3938838 2003331 2003331 plaintiff Reynger Richard   586852 586852 Reynger, Richard, of Twyford 0
3964508 2012188 2012188 defendant Holwell John husbandman 586852 586852 Holwell, John, of Twyford, husbandman 0
3964509 2012188 2012188 defendant Tye William husbandman 586852 586852 Tye, William, of Twyford, husbandman 1
3964510 2012188 2012188 defendant Lowthe William husbandman 586852 586852 Lowthe, William, of Twyford, husbandman 2
3964511 2012188 2012188 defendant Topper Thomas laborer 586852 586852 Topper, Thomas, of Twyford, laborer 3
3984300 2019147 2019147 defendant Townesende Roger gent 586852 586852 Townesende, Roger, of Twyford, gent 0
4008551 2027823 2027823 plaintiff Moore Richard gent 586852 586852 Moore, Richard, of Twyford, gent 0
4016930 2030756 2030756 defendant Towneshend Roger gent 586852 586852 Towneshend, Roger, of Twyford, gent 0
4089034 2056373 2056373 defendant Tounsende Roger gent 586852 586852 Tounsende, Roger, of Twyford, gent 0
4105657 2062312 2062312 defendant Pynchbeck Richard gent 586852 586852 Pynchbeck, Richard, of Twyford, gent 1
4125070 2069255 2069255 defendant Sparke John husbandman 586852 586852 Sparke, John, of Twyford, husbandman 0
4127831 2070243 2070243 defendant Penney Richard yeoman 586852 586852 Penney, Richard, of Twyford, yeoman 1
4133064 2072154 2072154 defendant Wilkenson Francis gent 586852 586852 Wilkenson, Francis, of Twyford, or of Cheriton, gent 0
4151193 2078541 2078541 defendant Newlande Gregory husbandman 586852 586852 Newlande, Gregory, of Twyford, husbandman 2
4157053 2080545 2080545 defendant Wilkenson Francis gent 586852 586852 Wilkenson, Francis, of Twyford, or of Cheriton, gent 0
4160282 2081666 2081666 defendant Willm- James gent 586852 586852 Willm-, James, of Twyford, gent 1
4160283 2081666 2081666 defendant Churcher Robert yeoman 586852 586852 Churcher, Robert, of Twyford, yeoman 2
4160284 2081666 2081666 defendant Knowles Henry gent 586852 586852 Knowles, Henry, of Twyford, gent 3
4215335 2100860 2100860 defendant Cooke Thomas husbandman 586852 586852 Cooke, Thomas, of Twyford, husbandman 1
4241560 2110161 2110161 defendant Cocke Thomas husbandman 586852 586852 Cocke, Thomas, of Twyford, husbandman 1
4263245 2117374 2117374 defendant Tounesend Roger gent 586852 586852 Tounesend, Roger, of Twyford, gent 0
4278933 2122565 2122565 defendant Welsh John husbandman 586852 586852 Welsh, John, of Twyford, husbandman 1
4308648 2133175 2133175 defendant Watt Thomas husbandman 586852 586852 Watt, Thomas, of Twyford, husbandman 0
4323222 2138182 2138182 defendant Clarke Roger husbandman 586852 586852 Clarke, Roger, of Twyford, husbandman 0
4340573 2143971 2143971 defendant Coleman John, senior yeoman 586852 586852 Coleman, John, senior, of Twyford, yeoman 0
4369978 2154319 2154319 defendant Bulbeck Nicholas yeoman 586852 586852 Bulbeck, Nicholas, of Twyford, yeoman 0
4376398 2156628 2156628 defendant Raynold Thomas bricklayer 586852 586852 Raynold, Thomas, of Twyford, bricklayer 0
4415281 2169674 2169674 plaintiff Gyffard Nicholas   586852 586852 Gyffard, Nicholas, of Twyford, son of John 0
4426681 2173157 2173157 plaintiff Penne Roger de   586852 586852 Penne, Roger de, of Twyford, vicar 0
4433493 2175237 2175237 plaintiff Giffard John   586852 586852 Giffard, John, of Twyford, knight 0
4449197 2184698 2184698 plaintiff Gifford Thomas   586852 586852 Gifford, Thomas, of Twyford, knight, son of John Giffard 0
4449198 2184698 2184698 defendant Gifford Alice   586852 586852 Gifford, Alice, of Twyford, formerly wife of John 0
4455777 2186823 2186823 defendant Faunconer Robert   586852 586852 Faunconer, Robert, of Twyford 1
4482412 2195204 2195204 defendant Cloop Richard   586852 586852 Cloop, Richard, of Twyford, parson 0
4501114 2200954 2200954 plaintiff Large Richard   586852 586852 Large, Richard, of Twyford 0
4501115 2200954 2200954 defendant Kempson William   586852 586852 Kempson, William, of Twyford, son of Robert 0
4564571 2220479 2220479 defendant atte Boure Hugh   586852 586852 atte Boure, Hugh, of Twyford 0
4628890 2239965 2239965 defendant Twyford William   586852 586852 Twyford, William, of Twyford 0
4651340 2246419 2246419 defendant Hukkell Robert husbandman 586852 586852 Hukkell, Robert, of Twyford, husbandman 5
4651341 2246419 2246419 defendant Everard John husbandman 586852 586852 Everard, John, of Twyford, husbandman 6
4671643 2256776 2256776 defendant Hampton John husbandman 586852 586852 Hampton, John, of Twyford, husbandman 0
4678128 2258770 2258770 defendant Barker Geoffrey husbandman 586852 586852 Barker, Geoffrey, of Twyford, husbandman 1
4678835 2258984 2258984 defendant Halle William husbandman 586852 586852 Halle, William, of Twyford, husbandman 0
4696913 2264514 2264514 defendant Dey Henry husbandman 586852 586852 Dey, Henry, of Twyford, husbandman 0
4723610 2272688 2272688 defendant Hall William husbandman 586852 586852 Hall, William, of Twyford, husbandman 1
4732372 2275303 2275303 defendant Myst John husbandman 586852 586852 Myst, John, of Twyford, husbandman 0
4746513 2279472 2279472 defendant atte Halle Robert husbandman 586852 586852 atte Halle, Robert, of Twyford, husbandman 0
4748156 2279971 2279971 defendant Russhebrok John   586852 586852 Russhebrok, John, of Twyford, bailiff 1
4756694 2282458 2282458 defendant Fychet Henry husbandman 586852 586852 Fychet, Henry, of Twyford, husbandman 0
4756697 2282458 2282458 defendant Smyth William smith 586852 586852 together with Smyth, William, of Twyford, smith 3
4758493 2283036 2283036 defendant atte Halle Robert husbandman 586852 586852 atte Halle, Robert, of Twyford, husbandman 0
4763475 2284561 2284561 defendant Geffeson Robert laborer 586852 586852 Geffeson, Robert, of Twyford, laborer 1
4765338 2285143 2285143 defendant Halle William husbandman 586852 586852 Halle, William, of Twyford, husbandman 0
4767048 2285682 2285682 defendant Wyn_ele John clerk 586852 586852 Wyn_ele, John, of Twyford, clerk 5
4768556 2286145 2286145 plaintiff Neweman John   586852 586852 Neweman, John, of Twyford 0
4775759 2288415 2288415 defendant Twyford John husbandman 586852 586852 Twyford, John, of Twyford, husbandman 0
4783049 2290717 2290717 defendant Neweman John husbandman 586852 586852 Neweman, John, of Twyford, husbandman 0
4793170 2293960 2293960 defendant Bruchele John yeoman 586852 586852 Bruchele, John, of Twyford, yeoman 3
4814725 2300722 2300722 defendant Twyford John husbandman 586852 586852 Twyford, John, of Twyford, husbandman 0
4825237 2303933 2303933 defendant Lytell Richard husbandman 586852 586852 Lytell, Richard, of Twyford, husbandman 1
4825238 2303933 2303933 defendant Lytell Walter husbandman 586852 586852 Lytell, Walter, of Twyford, husbandman 2
4831108 2305761 2305761 defendant Twyford John husbandman 586852 586852 Twyford, John, of Twyford, husbandman 0
4864388 2315841 2315841 defendant Halle Robert yeoman 586852 586852 Halle, Robert, of Twyford, yeoman 0
4864854 2315982 2315982 defendant Halle Robert yeoman 586852 586852 Halle, Robert, of Twyford, yeoman 0
4876599 2319648 2319648 defendant Smyth Thomas husbandman 586852 586852 Smyth, Thomas, of Twyford, husbandman 0
4892479 2324386 2324386 defendant Waytegode Roger husbandman 586852 586852 Waytegode, Roger, of Twyford, husbandman 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);