names

151 rows where place_id = 588397

✎ 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
3594354 1865866 1865866 defendant Cottys Nicholas yeoman 588397 588397 Cottys, Nicholas, of Thorpe, yeoman 2
3630975 1904508 1904508 defendant Thorpe John gent 588397 588397 Thorpe, John, of Thorpe, gent 0
3683868 1921090 1921090 defendant Thorpe John gent 588397 588397 Thorpe, John, of Thorpe, gent 0
3683869 1921090 1921090 defendant Gamyll John husbandman 588397 588397 Gamyll, John, of Thorpe, husbandman 1
3688064 1922430 1922430 defendant Blakman John carpenter 588397 588397 Blakman, John, of Thorpe, carpenter 0
3691044 1923363 1923363 plaintiff Assheton John   588397 588397 Assheton, John, of Thorpe 1
3698192 1925662 1925662 defendant Sawer William husbandman 588397 588397 Sawer, William, of Thorpe, husbandman 0
3698193 1925662 1925662 defendant Dowe John husbandman 588397 588397 Dowe, John, of Thorpe, husbandman 1
3728437 1935142 1935142 defendant Spycer William gent 588397 588397 Spycer, William, of Thorpe Hawker, gent 0
3737004 1937820 1937820 defendant Sawer William husbandman 588397 588397 Sawer, William, of Thorpe, husbandman 0
3737005 1937820 1937820 defendant Symson Richard husbandman 588397 588397 Symson, Richard, of Thorpe, husbandman 1
3746609 1940855 1940855 defendant Dey Thomas yeoman 588397 588397 Dey, Thomas, of Thorpe, yeoman 0
3759935 1945102 1945102 defendant Tatersall George clerk 588397 588397 Tatersall, George, of Thorpe, clerk 0
3772536 1949100 1949100 defendant Cokayn John gent 588397 588397 Cokayn, John, of Thorpe, gent 2
3799111 1957631 1957631 defendant Balle William husbandman 588397 588397 Balle, William, of Thorpe, husbandman 0
3801042 1958241 1958241 defendant Balle William husbandman 588397 588397 Balle, William, of Thorpe, husbandman 2
3804539 1959359 1959359 defendant Sadler Reginald chaplain 588397 588397 Sadler, Reginald, of Thorpe, chaplain 0
3818580 1963713 1963713 defendant Balle William husbandman 588397 588397 Balle, William, of Thorpe, husbandman 2
3819603 1964008 1964008 defendant Halle Michael yeoman 588397 588397 Halle, Michael, of Thorpe, yeoman 0
3822992 1965099 1965099 defendant Richardson Thomas laborer 588397 588397 Richardson, Thomas, of Thorpe, laborer 1
3822993 1965099 1965099 defendant Richardson Richard laborer 588397 588397 Richardson, Richard, of Thorpe, laborer 2
3822994 1965099 1965099 defendant Richardson Peter laborer 588397 588397 Richardson, Peter, of Thorpe, laborer 3
3857547 1975995 1975995 defendant Peerson Christopher yeoman 588397 588397 Peerson, Christopher, of Thorpe St Peter, yeoman 0
3865014 1978499 1978499 defendant Balle William husbandman 588397 588397 Balle, William, of Thorpe, husbandman 1
3880448 1983717 1983717 defendant Hewe John husbandman 588397 588397 Hewe, John, of Thorpe, husbandman 4
3904861 1991889 1991889 defendant Balley William laborer 588397 588397 Balley, William, of Thorpe, laborer 1
3922983 1997995 1997995 defendant Kettyn Nicholas laborer 588397 588397 Kettyn, Nicholas, of Thorpe, laborer 2
3924299 1998434 1998434 defendant Jakson Richard husbandman 588397 588397 Jakson, Richard, of Thorpe, husbandman 1
3924799 1998612 1998612 defendant Pye William husbandman 588397 588397 Pye, William, of Thorpe, husbandman 1
3932588 2001190 2001190 defendant Jackson John mariner 588397 588397 Jackson, John, of Thorpe, mariner 0
3940270 2003765 2003765 defendant Toune Francis husbandman 588397 588397 Toune, Francis, of thorpe, husbandman 1
3940271 2003765 2003765 defendant Clarke John   588397 588397 Clarke, John, of Thorpe, shoe maker 2
3942051 2004356 2004356 defendant Sallowe John laborer 588397 588397 Sallowe, John, of Thorpe, laborer 0
3945981 2005672 2005672 defendant Hasell John blacksmith 588397 588397 Hasell, John, of Thorpe, blacksmith 3
3960423 2010743 2010743 defendant Sowter alias Warde Robert husbandman 588397 588397 Sowter alias Warde, Robert, of Thorpe, husbandman 1
3973473 2015291 2015291 plaintiff Welche Thomas haberdasher 588397 588397 Welche, Thomas, of Thorpe, haberdasher 2
3984588 2019245 2019245 defendant Kynge Robert husbandman 588397 588397 Kynge, Robert, of Thorpe, husbandman 0
3984590 2019245 2019245 defendant Robynson Henry laborer 588397 588397 Robynson, Henry, of Thorpe, laborer 2
3984591 2019245 2019245 defendant Wraye William laborer 588397 588397 Wraye, William, of Thorpe, laborer 3
3999696 2024654 2024654 defendant Thorpe William esq 588397 588397 Thorpe, William, of Thorpe, esq 1
4016961 2030767 2030767 defendant Cottyngham John yeoman 588397 588397 Cottyngham, John, of Thorpe, yeoman 1
4026556 2034149 2034149 defendant Neysome James layer servant to Master Foxe of Thorpe 588397 588397 Neysome, James, of Thorpe, yeoman, layer servant to Master Foxe of Thorpe 0
4028939 2034994 2034994 defendant Homan William yepman 588397 588397 Homan, William, of Thorpe, yepman 0
4028940 2034994 2034994 defendant Banbrook William clerk 588397 588397 Banbrook, William, of Thorpe, clerk 1
4034342 2036954 2036954 defendant Howde Thomas mariner 588397 588397 Howde, Thomas, of Thorpe, mariner 2
4038177 2038293 2038293 defendant Mall Thomas clothier 588397 588397 Mall, Thomas, of Thorpe, clothier 7
4038201 2038296 2038296 defendant Mall Thomas clothier 588397 588397 Mall, Thomas, of Thorpe, clothier 6
4038411 2038378 2038378 defendant Chamber John   588397 588397 Chamber, John, of Thorpe, patchment maker 0
4040761 2039189 2039189 defendant Burdens of Burdny Robert yeoman 588397 588397 Burdens of Burdny, Robert, of Thorpe, yeoman 0
4052207 2043211 2043211 defendant Whighte John husbandman 588397 588397 Whighte, John, of Thorpe, husbandman 0
4056275 2044630 2044630 defendant Rodinge John hatter 588397 588397 Rodinge, John, of Thorpe, hatter 0
4056276 2044630 2044630 defendant Baughtell James tailor 588397 588397 Baughtell, James, of Thorpe, tailor 1
4056277 2044630 2044630 defendant Harte Henry yeoman 588397 588397 Harte, Henry, of Thorpe, yeoman 2
4058396 2045389 2045389 defendant Sawer William yeoman 588397 588397 Sawer, William, of Thorpe, yeoman 0
4058831 2045552 2045552 defendant Harryson John, junior husbandman 588397 588397 Harryson, John, junior, of Thorpe, husbandman 0
4061011 2046347 2046347 defendant Gooden Richard pedder 588397 588397 Gooden, Richard, of Thorpe, pedder 1
4062636 2046935 2046935 plaintiff Foxe Thomas gent 588397 588397 Foxe, Thomas, of Thorpe, gent 0
4063703 2047308 2047308 defendant Wythes Anthony husbandman 588397 588397 Wythes, Anthony, of Thorpe, husbandman 0
4066286 2048233 2048233 defendant Harte Henry innholder 588397 588397 Harte, Henry, of Thorpe, innholder 0
4066287 2048233 2048233 defendant Lucke William merchant tailor 588397 588397 Lucke, William, of Thorpe, merchant tailor 1
4067060 2048517 2048517 defendant Bear Robert husbandman 588397 588397 Bear, Robert, of Thorpe, husbandman 0
4077524 2052252 2052252 plaintiff Stannyvett Richard tanner 588397 588397 Stannyvett, Richard, of Thorpe, tanner 0
4078429 2052581 2052581 defendant Nayler Robert laborer 588397 588397 Nayler, Robert, of Thorpe, laborer 0
4082246 2053963 2053963 defendant Page Henry yeoman 588397 588397 Page, Henry, of Thorpe, or of Balsam, Cams, yeoman 0
4088616 2056230 2056230 defendant Waterhouse Thomas nailer 588397 588397 Waterhouse, Thomas, of Thorpe, nailer 1
4091892 2057395 2057395 defendant Brome John mariner 588397 588397 Brome, John, of Thorpe, mariner 0
4092009 2057436 2057436 defendant Fryar Heorge yeoman 588397 588397 Fryar, Heorge, of Thorpe, yeoman 0
4104950 2062046 2062046 defendant Goodinge Richard   588397 588397 Goodinge, Richard, of Thorpe, "ryppier" or fishmonger 2
4107276 2062894 2062894 defendant Hayle William tanner 588397 588397 Hayle, William, of Thorpe, tanner 0
4114057 2065309 2065309 defendant Wrathes William husbandman 588397 588397 Wrathes, William, of Thorpe, husbandman 1
4114058 2065309 2065309 defendant Perte Miles husbandman 588397 588397 Perte, Miles, of Thorpe, husbandman 2
4119452 2067250 2067250 defendant Rysbye William gent 588397 588397 Rysbye, William, of Thorpe, gent 0
4123896 2068846 2068846 defendant Sawer William yeoman 588397 588397 Sawer, William, of Thorpe, yeoman 1
4131122 2071448 2071448 defendant Missing Richard   588397 588397 Missing, Richard, of Thorpe, linen draper 3
4132847 2072077 2072077 defendant Cordell Reginald mariner 588397 588397 Cordell, Reginald, of Thorpe, mariner 1
4135944 2073188 2073188 defendant Gryme John husbandman 588397 588397 Gryme, John, of Thorpe, husbandman 2
4137351 2073710 2073710 defendant Bulman John yeoman 588397 588397 Bulman, John, of Thorpe, yeoman 1
4138725 2074217 2074217 defendant Ibotson John sherman 588397 588397 Ibotson, John, of Thorpe, sherman 2
4152479 2078979 2078979 defendant Sparre John tanner 588397 588397 Sparre, John, of Thorpe, tanner 1
4165598 2083468 2083468 defendant Woodwarde Humphrey husbandman 588397 588397 Woodwarde, Humphrey, of Thorpe, husbandman 0
4169528 2084845 2084845 defendant Hall Simon yeoman 588397 588397 Hall, Simon, of Thorpe, yeoman 1
4169676 2084884 2084884 defendant Tayler William   588397 588397 Tayler, William, of Thorpe, sailor 2
4201845 2096187 2096187 defendant Howlman William husbandman 588397 588397 Howlman, William, of Thorpe, husbandman 0
4213444 2100221 2100221 defendant Gyldyngwater John tailor 588397 588397 Gyldyngwater, John, of Thorpe, tailor 0
4220370 2102630 2102630 defendant Colpes James laborer 588397 588397 Colpes, James, of Thorpe, laborer 1
4225699 2104453 2104453 defendant Sysmer John yeoman 588397 588397 Sysmer, John, of Thorpe by Water, yeoman 0
4228070 2105296 2105296 defendant Allyn John carpenter 588397 588397 Allyn, John, of Thorpe, carpenter 0
4231441 2106498 2106498 defendant Watson William yeoman 588397 588397 Watson, William, of Thorpe, yeoman 0
4231442 2106498 2106498 defendant Watson John husbandman 588397 588397 Watson, John, of Thorpe, husbandman 1
4231443 2106498 2106498 defendant Johnson William husbandman 588397 588397 Johnson, William, of Thorpe, husbandman 2
4231444 2106498 2106498 defendant Burnett Richard husbandman 588397 588397 Burnett, Richard, of Thorpe, husbandman 3
4231445 2106498 2106498 defendant Newton George husbandman 588397 588397 together with Newton, George, of Thorpe, husbandman 4
4231446 2106498 2106498 defendant Watson Ralph husbandman 588397 588397 Watson, Ralph, of Thorpe, husbandman 5
4231447 2106498 2106498 defendant Sharrowe William husbandman 588397 588397 Sharrowe, William, of Thorpe, husbandman 6
4231448 2106498 2106498 defendant Allanson Wilfred husbandman 588397 588397 Allanson, Wilfred, of Thorpe, husbandman 7
4238138 2108948 2108948 defendant Watter Lawrence yeoman 588397 588397 Watter, Lawrence, of Thorpe, yeoman 0
4241859 2110270 2110270 defendant Roodinge John yeoman 588397 588397 Roodinge, John, of Thorpe, yeoman 0
4245038 2111324 2111324 defendant Allen John carpenter 588397 588397 Allen, John, of Thorpe, carpenter 0
4252967 2113986 2113986 defendant Burnett Richard yeoman 588397 588397 Burnett, Richard, of Thorpe, yeoman 0
4252968 2113986 2113986 defendant Brathait Vincent yeoman 588397 588397 Brathait, Vincent, of Thorpe, yeoman 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);