names

277 rows where place_id = 589604

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598153 1867051 1867051 defendant Martyn Lawrence yeoman 589604 589604 Martyn, Lawrence, of Broughton, yeoman 0
3611360 1871226 1871226 defendant Moule or Monle John butcher 589604 589604 Moule or Monle, John, of Broughton, butcher 0
3611363 1871227 1871227 defendant Moule John butcher 589604 589604 Moule, John, of Broughton, butcher 0
3612110 1871431 1871431 defendant Mershe John, junior husbandman 589604 589604 Mershe, John, junior, of Broughton, husbandman 0
3612971 1871705 1871705 defendant Cockys Stephen husbandman 589604 589604 Cockys, Stephen, of Broughton, husbandman 0
3624265 1875122 1875122 defendant Cokkys Stephen husbandman 589604 589604 Cokkys, Stephen, of Broughton, husbandman 0
3646811 1909408 1909408 defendant Broughton William yeoman 589604 589604 Broughton, William, of Broughton, yeoman 3
3647963 1909762 1909762 defendant Penbrikke Nicholas husbandman 589604 589604 Penbrikke, Nicholas, of Broughton, husbandman 0
3709134 1929154 1929154 defendant Westley Henry tailor 589604 589604 Westley, Henry, of Broughton, tailor 2
3713776 1930607 1930607 defendant Pers John yeoman 589604 589604 Pers, John, of Broughton, yeoman 0
3720606 1932728 1932728 defendant Pachet John husbandman 589604 589604 Pachet, John, of Broughton, husbandman 0
3722956 1933445 1933445 defendant Sheylard John husbandman 589604 589604 Sheylard, John, of Broughton, husbandman 0
3750665 1942130 1942130 defendant Pedler Henry husbandman 589604 589604 Pedler, Henry, of Broughton, husbandman 0
3750756 1942158 1942158 defendant Evan John husbandman 589604 589604 Evan, John, of Broughton, husbandman 0
3755747 1943758 1943758 defendant Browne Anthony husbandman 589604 589604 Browne, Anthony, of Broughton, husbandman 5
3760346 1945238 1945238 defendant Penbroke Nicholas husbandman 589604 589604 Penbroke, Nicholas, of Broughton, husbandman 3
3766556 1947199 1947199 defendant Pedler Henry husbandman 589604 589604 Pedler, Henry, of Broughton, husbandman 0
3770641 1948503 1948503 defendant Cuffe William husbandman 589604 589604 Cuffe, William, of Broughton, husbandman 0
3772967 1949246 1949246 defendant Heth George husbandman 589604 589604 Heth, George, of Broughton, husbandman 3
3772968 1949246 1949246 defendant Taverner Richard husbandman 589604 589604 Taverner, Richard, of Broughton, husbandman 4
3779728 1951392 1951392 defendant Frankelen Edmund husbandman 589604 589604 Frankelen, Edmund, of Broughton, husbandman 1
3781261 1951879 1951879 defendant Chamber John husbandman 589604 589604 Chamber, John, of Broughton Abbot, husbandman 0
3805506 1959660 1959660 defendant Tempest Roger gent 589604 589604 Tempest, Roger, of Broughton, gent 0
3810512 1961182 1961182 defendant Badcoke alias Wayfote Thomas husbandman 589604 589604 Badcoke alias Wayfote, Thomas, of Broughton, husbandman 1
3810515 1961182 1961182 defendant Wheels John husbandman 589604 589604 Wheels, John, of Broughton, husbandman 4
3816539 1963075 1963075 defendant Penyngton Nicholas husbandman 589604 589604 Penyngton, Nicholas, of Broughton, husbandman 0
3816540 1963075 1963075 defendant Carter Mathew yeoman 589604 589604 Carter, Mathew, of Broughton, yeoman 1
3816542 1963075 1963075 defendant Adeson Johm husbandman 589604 589604 Adeson, Johm, of Broughton, husbandman 3
3828542 1966802 1966802 defendant Newell Henry clerk 589604 589604 Newell, Henry, of Broughton, clerk 0
3833763 1968493 1968493 defendant Wroughton Thomas esq 589604 589604 Wroughton, Thomas, of Broughton, esq 0
3848313 1973045 1973045 defendant Man Thomas smith 589604 589604 Man, Thomas, of Broughton, smith 1
3849785 1973520 1973520 defendant Hastofte Henry yeoman 589604 589604 Hastofte, Henry, of Broughton, yeoman 1
3852074 1974242 1974242 defendant Wroughton Thomas gent 589604 589604 Wroughton, Thomas, of Broughton, gent 0
3852075 1974242 1974242 defendant Harrys Edward gent 589604 589604 Harrys, Edward, of Broughton, gent 1
3852076 1974242 1974242 defendant Holwey William yeoman 589604 589604 Holwey, William, of Broughton, yeoman 2
3854071 1974909 1974909 defendant Robynson William yeoman 589604 589604 Robynson, William, of Broughton, yeoman 0
3854072 1974909 1974909 defendant Hugill Robert laborer 589604 589604 Hugill, Robert, of Broughton, laborer 1
3854073 1974909 1974909 defendant Saddertwhayt Christopher yeoman 589604 589604 Saddertwhayt, Christopher, of Broughton, yeoman 2
3862548 1977668 1977668 defendant Lee William laborer 589604 589604 Lee, William, of Broughton, laborer 1
3865251 1978586 1978586 defendant Ryng William (legal representative) 589604 589604 Ryng, William, of Broughton, pulter, administrator of 0
3874223 1981601 1981601 defendant Pedder Henry husbandman 589604 589604 Pedder, Henry, of Broughton, husbandman 2
3882331 1984349 1984349 defendant Robynson William yeoman 589604 589604 Robynson, William, of Broughton, yeoman 0
3882332 1984349 1984349 defendant Hugyll Robert laborer 589604 589604 Hugyll, Robert, of Broughton, laborer 1
3882333 1984349 1984349 defendant Sadderthwaytt Christopher yeoman 589604 589604 Sadderthwaytt, Christopher, of Broughton, yeoman 2
3915975 1995724 1995724 defendant Johns Edward gent 589604 589604 Johns, Edward, of Broughton, gent 1
3918251 1996437 1996437 defendant Warren Richard husbandman 589604 589604 Warren, Richard, of Broughton, husbandman 0
3919522 1996861 1996861 defendant Kene Henry husbandman 589604 589604 Kene, Henry, of Broughton, husbandman 0
3926142 1999063 1999063 plaintiff Broughton Richard gent 589604 589604 Broughton, Richard, of Broughton, gent 0
3927345 1999489 1999489 defendant Johns Robert gent 589604 589604 Johns, Robert, of Broughton, gent 0
3927387 1999505 1999505 defendant Pedder Henry husbandman 589604 589604 Pedder, Henry, of Broughton, husbandman 0
3930934 2000686 2000686 plaintiff Daste William   589604 589604 Daste, William, of Broughton 0
3937414 2002847 2002847 defendant Symondes alias Symons Griffith chapman 589604 589604 Symondes alias Symons, Griffith, of Broughton, chapman 2
3941223 2004069 2004069 defendant Harryson Anthony yeoman 589604 589604 Harryson, Anthony, of Broughton, yeoman 0
3949413 2006867 2006867 defendant Jones Edward gent 589604 589604 Jones, Edward, of Broughton, gent 0
3949414 2006867 2006867 defendant Gawen John yeoman 589604 589604 Gawen, John, of Broughton, yeoman 1
3953999 2008469 2008469 defendant Jones alias Broughton Robert   589604 589604 Jones alias Broughton, Robert, of Broughton, Salop gent 1
3976158 2016227 2016227 defendant Tempest Henry gent 589604 589604 Tempest, Henry, of Broughton, gent 0
4008879 2027940 2027940 defendant Mylnes Michael husbandman 589604 589604 Mylnes, Michael, of Broughton, husbandman 0
4017987 2031149 2031149 defendant Lymbryke Sybil widow 589604 589604 Lymbryke, Sybil, of Broughton, widow 1
4053835 2043749 2043749 defendant Bell John husbandman 589604 589604 Bell, John, of Broughton, husbandman 1
4053836 2043749 2043749 defendant Foster John husbandman 589604 589604 Foster, John, of Broughton, husbandman 2
4094281 2058292 2058292 plaintiff Freman Henry merchant of the staple 589604 589604 Freman, Henry, of Broughton, merchant of the staple 0
4125383 2069362 2069362 defendant Croft Thomas (legal representative) 589604 589604 Croft, Thomas, of Broughton, yeoman, executors of 0
4125594 2069438 2069438 defendant Sandeford Thomas husbandman 589604 589604 Sandeford, Thomas, of Broughton, husbandman 0
4147619 2077307 2077307 defendant Grene John husbandman 589604 589604 Grene, John, of Broughton, husbandman 0
4220235 2102581 2102581 defendant Wetnall Ambrose yeoman 589604 589604 Wetnall, Ambrose, of Broughton, yeoman 0
4252580 2113853 2113853 defendant Edmondes John yeoman 589604 589604 Edmondes, John, of Broughton, yeoman 1
4252583 2113854 2113854 defendant Edmondes John yeoman 589604 589604 Edmondes, John, of Broughton, yeoman 1
4265275 2118028 2118028 defendant Shugborow Jane widow 589604 589604 Shugborow, Jane, of Broughton, widow 2
4278514 2122419 2122419 defendant Edmond alias Holowaye Edith widow 589604 589604 Edmond alias Holowaye, Edith, of Broughton, widow 1
4279225 2122665 2122665 defendant Langwith William yeoman 589604 589604 Langwith, William, of Broughton, yeoman 2
4280236 2122992 2122992 defendant Wood John gent 589604 589604 Wood, John, of Broughton, gent 1
4296736 2128929 2128929 defendant Key Eleanor widow 589604 589604 Key, Eleanor, of Broughton, widow 1
4296958 2129010 2129010 defendant Langwithe Edward yeoman 589604 589604 Langwithe, Edward, of Broughton, yeoman 0
4309802 2133584 2133584 defendant Conyers Richard gent 589604 589604 Conyers, Richard, of Broughton, gent 0
4313233 2134738 2134738 defendant Frowde John husbandman 589604 589604 Frowde, John, of Broughton, husbandman 0
4313234 2134738 2134738 defendant Browne John husbandman 589604 589604 Browne, John, of Broughton, husbandman 1
4313235 2134738 2134738 defendant Dyper William husbandman 589604 589604 Dyper, William, of Broughton, husbandman 2
4313236 2134738 2134738 defendant Tayler Thomas husbandman 589604 589604 Tayler, Thomas, of Broughton, husbandman 3
4317681 2136296 2136296 defendant Cuffe Michael gent 589604 589604 Cuffe, Michael, of Broughton, gent 0
4334261 2141738 2141738 defendant Doverdale Richard yeoman 589604 589604 Doverdale, Richard, of Broughton, yeoman 0
4343231 2144905 2144905 defendant Horton Jeremy gent 589604 589604 Horton, Jeremy, of Broughton, gent 1
4352923 2148249 2148249 defendant Gawen William yeoman 589604 589604 Gawen, William, of Broughton, yeoman 0
4357926 2150013 2150013 defendant Yonge Thomas clerk 589604 589604 Yonge, Thomas, of Broughton, clerk 0
4363036 2151844 2151844 defendant Hogert Christopher husbandman 589604 589604 Hogert, Christopher, of Broughton, husbandman 0
4366859 2153196 2153196 defendant Savage Robert husbandman 589604 589604 Savage, Robert, of Broughton, husbandman 1
4381644 2158544 2158544 defendant Rasinge Marmaduke gent 589604 589604 Rasinge, Marmaduke, of Broughton, gent 0
4390839 2161550 2161550 defendant Rasinge Marmaduke gent 589604 589604 Rasinge, Marmaduke, of Broughton, gent 0
4422863 2172011 2172011 plaintiff Flemmyng Simon   589604 589604 Flemmyng, Simon, of Broughton 0
4422864 2172011 2172011 defendant Person Mabel daughter of William 589604 589604 Person, Mabel, of Broughton, daughter of William 0
4447134 2184010 2184010 defendant Gedyngton Henry de   589604 589604 Gedyngton, Henry de, of Broughton, parson 0
4487783 2196894 2196894 defendant Palmer Thomas   589604 589604 Palmer, Thomas, of Broughton 4
4499788 2200565 2200565 defendant Shephurd John   589604 589604 Shephurd, John, of Broughton 3
4512717 2204410 2204410 defendant Smith Thomas   589604 589604 Smith, Thomas, of Broughton 3
4531517 2210136 2210136 defendant Hunte John   589604 589604 Hunte, John, of Broughton 0
4531518 2210136 2210136 defendant Bastard William   589604 589604 Bastard, William, of Broughton 1
4578297 2224705 2224705 defendant Bocher Nicholas   589604 589604 Bocher, Nicholas, of Broughton 0
4586328 2227139 2227139 plaintiff Herryes John   589604 589604 Herryes, John, of Broughton 0
4591102 2228574 2228574 defendant Shepherd Clement   589604 589604 Shepherd, Clement, of Broughton 0
4605734 2232911 2232911 plaintiff Wolf Edmund   589604 589604 Wolf, Edmund, of Broughton, parson 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);