names

377 rows where place_id = 587352

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591161 1864856 1864856 defendant Whytyng Richard husbandman 587352 587352 Whytyng, Richard, of Aston, husbandman 0
3597628 1866883 1866883 defendant Feylet John yeoman 587352 587352 Feylet, John, of Aston, yeoman 1
3610229 1870864 1870864 defendant Balgy Thomas, junior gent 587352 587352 Balgy, Thomas, junior, of Aston, gent 3
3610230 1870864 1870864 defendant Balgy Thomas, senior gent 587352 587352 Balgy, Thomas, senior, of Aston, gent 4
3623455 1874870 1874870 defendant Heyward John husbandman 587352 587352 Heyward, John, of Aston, husbandman 1
3632618 1905020 1905020 defendant West Richard chaplain 587352 587352 West, Richard, of Aston, chaplain 1
3632619 1905020 1905020 defendant Wythen Henry husbandman 587352 587352 Wythen, Henry, of Aston, husbandman 2
3632620 1905020 1905020 defendant Brandewode Henry husbandman 587352 587352 Brandewode, Henry, of Aston, husbandman 3
3646892 1909426 1909426 defendant Strode Alexander clerk 587352 587352 Strode, Alexander, of Aston, clerk 0
3646893 1909426 1909426 defendant Barton William chaplain 587352 587352 Barton, William, of Aston, chaplain 1
3646894 1909426 1909426 defendant Gyn William husbandman 587352 587352 Gyn, William, of Aston, husbandman 2
3646895 1909426 1909426 defendant Parker Thomas laborer 587352 587352 Parker, Thomas, of Aston, laborer 3
3646896 1909426 1909426 defendant Dowgate Gervase laborer 587352 587352 Dowgate, Gervase, of Aston, laborer 4
3656468 1912270 1912270 defendant Elyott John butcher 587352 587352 Elyott, John, of Aston, butcher 0
3668711 1916149 1916149 defendant Shepard Thomas husbandman 587352 587352 Shepard, Thomas, of Aston, husbandman 1
3672975 1917559 1917559 plaintiff Didley John esq 587352 587352 Didley, John, of Aston, esq 6
3673752 1917817 1917817 defendant Wodehouse Thomas bulker 587352 587352 Wodehouse, Thomas, of Aston, bulker 1
3674067 1917930 1917930 defendant Sympson William husbandman 587352 587352 Sympson, William, of Aston, husbandman 0
3676066 1918549 1918549 defendant Wydnall William husbandman 587352 587352 Wydnall, William, of Aston, husbandman 3
3681086 1920164 1920164 defendant Perkyns John laborer 587352 587352 Perkyns, John, of Aston, laborer 0
3690836 1923298 1923298 defendant Harvye William, junior husbandman 587352 587352 Harvye, William, junior, of Aston, husbandman 3
3693301 1924117 1924117 defendant Wodley Richard husbandman 587352 587352 Wodley, Richard, of Aston, husbandman 1
3693303 1924117 1924117 defendant Mayle John husbandman 587352 587352 Mayle, John, of Aston, husbandman 3
3712779 1930314 1930314 defendant Phylipot Thomas husbandman 587352 587352 Phylipot, Thomas, of Aston, husbandman 1
3712780 1930314 1930314 defendant Phylipot Henry husbandman 587352 587352 Phylipot, Henry, of Aston, husbandman 2
3722370 1933256 1933256 defendant Wodhouse Thomas husbandman 587352 587352 Wodhouse, Thomas, of Aston, husbandman 0
3757635 1944367 1944367 defendant Frensche Robert husbandman 587352 587352 Frensche, Robert, of Aston, husbandman 1
3757636 1944367 1944367 defendant Walwey William husbandman 587352 587352 Walwey, William, of Aston, husbandman 2
3758046 1944502 1944502 defendant Knotte Thomas husbandman 587352 587352 Knotte, Thomas, of Aston, husbandman 0
3760782 1945375 1945375 defendant Wyllys Thomas husbandman 587352 587352 Wyllys, Thomas, of Aston under Hill, husbandman 0
3762424 1945891 1945891 defendant Stucley Thomas   587352 587352 Stucley, Thomas, of Aston, knight 0
3775562 1950100 1950100 defendant Waters John yeoman 587352 587352 Waters, John, of Aston, yeoman 0
3775563 1950100 1950100 defendant Waters Anthony yeoman 587352 587352 Waters, Anthony, of Aston, yeoman 1
3782991 1952429 1952429 defendant Heywarde John husbandman 587352 587352 Heywarde, John, of Aston, husbandman 1
3783189 1952495 1952495 defendant Slade Richard husbandman 587352 587352 Slade, Richard, of Aston, husbandman 1
3809965 1961002 1961002 defendant Waters Anthony yeoman 587352 587352 Waters, Anthony, of Aston, yeoman 1
3816613 1963097 1963097 defendant Stucley Thomas   587352 587352 Stucley, Thomas, of Aston, knight 0
3831471 1967729 1967729 defendant Lambert John husbandman 587352 587352 Lambert, John, of Aston, husbandman 0
3838118 1969836 1969836 defendant Compton Thomas husbandman 587352 587352 Compton, Thomas, of Aston, husbandman 0
3839006 1970126 1970126 defendant Haskyn John weaver 587352 587352 Haskyn, John, of Aston, weaver 4
3848201 1973002 1973002 defendant Canon Thomas yeoman 587352 587352 Canon, Thomas, of Aston, yeoman 2
3849503 1973444 1973444 defendant More Humphrey yeoman 587352 587352 More, Humphrey, of Aston, yeoman 2
3870584 1980403 1980403 defendant Serche Thomas husbandman 587352 587352 Serche, Thomas, of Aston, husbandman 0
3870585 1980403 1980403 defendant Serche James husbandman 587352 587352 Serche, James, of Aston, husbandman 1
3870586 1980403 1980403 defendant Davyes Thomas husbandman 587352 587352 Davyes, Thomas, of Aston, husbandman 2
3885815 1985508 1985508 defendant Turner Edward husbandman 587352 587352 Turner, Edward, of Aston, husbandman 0
3885816 1985508 1985508 defendant Wriseley William laborer 587352 587352 Wriseley, William, of Aston, laborer 1
3899223 1989948 1989948 defendant Felpatte Joan widow 587352 587352 Felpatte, Joan, of Aston, widow 0
3919179 1996742 1996742 plaintiff Kent Thomas   587352 587352 Kent, Thomas, of Aston 0
3919182 1996743 1996743 plaintiff Kent Thomas   587352 587352 Kent, Thomas, of Aston 0
3922987 1997995 1997995 defendant Tompson John laborer 587352 587352 Tompson, John, of Aston, laborer 6
3940444 2003825 2003825 defendant Osborne Henry   587352 587352 Osborne, Henry, of Aston, bell maker 0
3944277 2005099 2005099 defendant Whyston John husbandman 587352 587352 Whyston, John, of Aston, husbandman 2
3959917 2010564 2010564 defendant Shepperd William maltman 587352 587352 Shepperd, William, of Aston, maltman 0
3959919 2010565 2010565 defendant Shepperd William maltman 587352 587352 Shepperd, William, of Aston, maltman 0
3976598 2016390 2016390 defendant Stukeley John esq 587352 587352 Stukeley, John, of Aston, esq 0
3977625 2016744 2016744 defendant Parkyns Thomas yeoman 587352 587352 Parkyns, Thomas, of Aston, yeoman 0
3978421 2017038 2017038 plaintiff Menlove William, senior   587352 587352 Menlove, William, senior, of Aston 0
3990230 2021260 2021260 defendant Watkys Thomas yeoman 587352 587352 Watkys, Thomas, of Aston, yeoman 0
3991688 2021784 2021784 defendant Brome William husbandman 587352 587352 Brome, William, of Aston, husbandman 1
4002235 2025584 2025584 plaintiff Heaton John cordwainer 587352 587352 Heaton, John, of Aston, cordwainer 0
4006778 2027200 2027200 defendant Vale John yeoman 587352 587352 Vale, John, of Aston, yeoman 0
4007804 2027574 2027574 plaintiff Mathewe Thomas husbandman 587352 587352 Mathewe, Thomas, of Aston, husbandman 0
4009844 2028297 2028297 defendant Davys John husbandman 587352 587352 Davys, John, of Aston, husbandman 1
4009845 2028297 2028297 defendant Worre William husbandman 587352 587352 Worre, William, of Aston, husbandman 2
4015571 2030266 2030266 defendant Shrobridge William husbandman 587352 587352 Shrobridge, William, of Aston, husbandman 1
4017579 2030994 2030994 defendant Farnell or Farvell Thomas clerk 587352 587352 Farnell or Farvell, Thomas, of Aston, clerk 0
4019441 2031686 2031686 plaintiff Wayte Thomas yeoman 587352 587352 Wayte, Thomas, of Aston, yeoman 0
4019442 2031686 2031686 plaintiff Fallowes John weaver 587352 587352 Fallowes, John, of Aston, weaver 1
4019445 2031686 2031686 defendant Taylor Robert yeoman 587352 587352 (Taylor, Robert, of Aston, yeoman 2
4020769 2032154 2032154 defendant Jaye Thomas laborer 587352 587352 Jaye, Thomas, of Aston, laborer 7
4023908 2033255 2033255 plaintiff Bell John servingman 587352 587352 Bell, John, of Aston, servingman 0
4028641 2034890 2034890 defendant Watkys William yeoman 587352 587352 Watkys, William, of Aston, yeoman 2
4035125 2037240 2037240 defendant Partryche Henry husbandman 587352 587352 Partryche, Henry, of Aston, husbandman 0
4035126 2037240 2037240 defendant Gyldyng John husbandman 587352 587352 Gyldyng, John, of Aston, husbandman 1
4035129 2037241 2037241 defendant Partryche Henry husbandman 587352 587352 Partryche, Henry, of Aston, husbandman 0
4035130 2037241 2037241 defendant Gyldyng John husbandman 587352 587352 Gyldyng, John, of Aston, husbandman 1
4043658 2040190 2040190 defendant Gyttyns Edmund yeoman 587352 587352 Gyttyns, Edmund, of Aston, yeoman 1
4044110 2040347 2040347 plaintiff Pytcheford Richard yeoman 587352 587352 Pytcheford, Richard, of Aston, yeoman 0
4044112 2040348 2040348 plaintiff Pytcheford Richard yeoman 587352 587352 Pytcheford, Richard, of Aston, yeoman 0
4044114 2040349 2040349 plaintiff Pytcheford Richard yeoman 587352 587352 Pytcheford, Richard, of Aston, yeoman 0
4045301 2040777 2040777 defendant Reynold Hugh yeoman 587352 587352 Reynold, Hugh, of Aston, yeoman 1
4046252 2041099 2041099 defendant Bowde John drover 587352 587352 Bowde, John, of Aston, drover 1
4046255 2041100 2041100 defendant Bowde John drover 587352 587352 Bowde, John, of Aston, drover 1
4052087 2043170 2043170 defendant Hullyns John yeoman 587352 587352 Hullyns, John, of Aston, yeoman 0
4052091 2043171 2043171 defendant Hullyns John yeoman 587352 587352 Hullyns, John, of Aston, yeoman 2
4070192 2049629 2049629 defendant Key William yeoman 587352 587352 Key, William, of Aston, yeoman 1
4074472 2051173 2051173 defendant Roper Leonard husbandman 587352 587352 Roper, Leonard, of Aston, husbandman 1
4075401 2051507 2051507 defendant Wygnall Simon laborer 587352 587352 Wygnall, Simon, of Aston, laborer 1
4075402 2051507 2051507 defendant Byker John laborer 587352 587352 Byker, John, of Aston, laborer 2
4075403 2051507 2051507 defendant Jefferis alias Russhen Thomas laborer 587352 587352 Jefferis alias Russhen, Thomas, of Aston, laborer 3
4075405 2051507 2051507 defendant Cooper Edward laborer 587352 587352 Cooper, Edward, of Aston, laborer 5
4075408 2051508 2051508 defendant Wygnall Simon laborer 587352 587352 Wygnall, Simon, of Aston, laborer 1
4075409 2051508 2051508 defendant Byker John laborer 587352 587352 Byker, John, of Aston, laborer 2
4075410 2051508 2051508 defendant Jefferys alias Russhen Thomas laborer 587352 587352 Jefferys alias Russhen, Thomas, of Aston, laborer 3
4075412 2051508 2051508 defendant Cooper Edward laborer 587352 587352 Cooper, Edward, of Aston, laborer 5
4080569 2053364 2053364 defendant Beamond Mathew gent 587352 587352 Beamond, Mathew, of Aston, gent 1
4092898 2057771 2057771 defendant Wycherley Thomas yeoman 587352 587352 Wycherley, Thomas, of Aston, yeoman 2
4096657 2059132 2059132 defendant Holcombe Tristram gent 587352 587352 Holcombe, Tristram, of Aston under Egge, gent 0
4096845 2059204 2059204 defendant Frenche John yeoman 587352 587352 Frenche, John, of Aston, 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);