names

213 rows where place_id = 602351

✎ 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
3649754 1910286 1910286 defendant Walwyn Leonard gent 602351 602351 (Walwyn, Leonard, of Stretton, gent 1
3688380 1922522 1922522 defendant Newman John laborer 602351 602351 Newman, John, of Stretton, laborer 1
3690711 1923263 1923263 defendant Bromley John yeoman 602351 602351 Bromley, John, of Stretton, yeoman 0
3692967 1924000 1924000 defendant Bromley Johnm yeoman 602351 602351 Bromley, Johnm, of Stretton, yeoman 1
3701092 1926588 1926588 defendant Tedryngton William   602351 602351 Tedryngton, William, of Stretton clerk 0
3704227 1927620 1927620 defendant Mounford Walter   602351 602351 Mounford, Walter, of Stretton, minstrel 3
3705595 1928030 1928030 defendant Bytheford John husbandman 602351 602351 Bytheford, John, of Stretton, husbandman 4
3710706 1929668 1929668 defendant Bromley John yeoman 602351 602351 Bromley, John, of Stretton, yeoman 2
3710707 1929668 1929668 defendant Carles John yeoman 602351 602351 Carles, John, of Stretton, yeoman 3
3734900 1937155 1937155 defendant Tomkyns John yeoman 602351 602351 Tomkyns, John, of Stretton, yeoman 0
3735366 1937297 1937297 defendant Carles John husbandman 602351 602351 Carles, John, of Stretton, husbandman 5
3762877 1946025 1946025 defendant Hawkyns Ralph husbandman 602351 602351 Hawkyns, Ralph, of Stretton, husbandman 0
3762878 1946025 1946025 defendant Tomkyns John husbandman 602351 602351 Tomkyns, John, of Stretton, husbandman 1
3780118 1951506 1951506 defendant Crosse Richard yeoman 602351 602351 Crosse, Richard, of Stretton, yeoman 0
3803688 1959069 1959069 defendant Watkynson Thomas husbandman 602351 602351 Watkynson, Thomas, of Stretton, husbandman 1
3808363 1960489 1960489 defendant Tedderyngton William clerk 602351 602351 Tedderyngton, William, of Stretton, clerk 0
3810216 1961089 1961089 defendant Kyte John husbandman 602351 602351 Kyte, John, of Stretton, husbandman 0
3810217 1961089 1961089 defendant Leche John husbandman 602351 602351 Leche, John, of Stretton, husbandman 1
3818046 1963555 1963555 defendant Tetheryngton William clerk 602351 602351 Tetheryngton, William, of Stretton, clerk 0
3829793 1967211 1967211 defendant Typpar Richard husbandman 602351 602351 Typpar, Richard, of Stretton, husbandman 1
3833418 1968378 1968378 defendant Coke John husbandman 602351 602351 Coke, John, of Stretton, husbandman 1
3849426 1973419 1973419 defendant Carlios or Carlies John yeoman 602351 602351 Carlios or Carlies, John, of Stretton, yeoman 0
3861789 1977409 1977409 defendant Habrehale Thomas gent 602351 602351 Habrehale, Thomas, of Stretton, gent 1
3882618 1984451 1984451 defendant Meredyth Roger gent 602351 602351 Meredyth, Roger, of Stretton, gent 0
3882621 1984451 1984451 defendant Alston Thomas yeoman 602351 602351 Alston, Thomas, of Stretton, yeoman 3
3883266 1984667 1984667 defendant Phelippis Thomas   602351 602351 Phelippis, Thomas, of Stretton, minstrel 0
3886149 1985620 1985620 plaintiff Broke Francis gent 602351 602351 Broke, Francis, of Stretton, gent 0
3919914 1996995 1996995 defendant Meredyth Roger gent 602351 602351 Meredyth, Roger, of Stretton, gent 0
3932816 2001276 2001276 defendant Crose Hugh husbandman 602351 602351 Crose, Hugh, of Stretton, husbandman 10
3945669 2005560 2005560 plaintiff Bright Richard   602351 602351 Bright, Richard, of Stretton 1
3965364 2012501 2012501 defendant Knappe Henry clerk 602351 602351 Knappe, Henry, of Stretton, clerk 3
3966827 2013033 2013033 plaintiff Broke Francis gent 602351 602351 Broke, Francis, of Stretton, gent 0
3976131 2016219 2016219 defendant Sawnder Robert shoemaker 602351 602351 Sawnder, Robert, of Stretton, shoemaker 1
3976132 2016219 2016219 defendant Saundry John husbandman 602351 602351 Saundry, John, of Stretton, husbandman 2
3986744 2020000 2020000 defendant Whassyngborough Elizabeth widow 602351 602351 Whassyngborough, Elizabeth, of Stretton, widow 0
4006904 2027244 2027244 defendant Sharpe Nicholas husbandman 602351 602351 Sharpe, Nicholas, of Stretton, husbandman 1
4036984 2037900 2037900 defendant Ensall Hugh yeoman 602351 602351 Ensall, Hugh, of Stretton, yeoman 2
4036985 2037900 2037900 defendant Ensall Roger yeoman 602351 602351 Ensall, Roger, of Stretton, yeoman 3
4050098 2042464 2042464 defendant Stalward John (legal representative) 602351 602351 Stalward, John, of Stretton, yeoman, executor of 0
4050099 2042464 2042464 defendant Stalward Robert yeoman 602351 602351 Stalward, Robert, of Stretton, yeoman 1
4059164 2045677 2045677 defendant Hethyn Thomas cordwainer 602351 602351 Hethyn, Thomas, of Stretton, cordwainer 0
4059165 2045677 2045677 defendant Barker Bedus or Bede butcher 602351 602351 Barker, Bedus or Bede, of Stretton, butcher 1
4059169 2045678 2045678 defendant Barker Bedus or Bede butcher 602351 602351 Barker, Bedus or Bede, of Stretton, butcher 1
4065477 2047944 2047944 defendant Kyte John yeoman 602351 602351 Kyte, John, of Stretton, yeoman 0
4065478 2047944 2047944 defendant Brighte John yeoman 602351 602351 Brighte, John, of Stretton, yeoman 1
4065479 2047944 2047944 defendant Harryngton John yeoman 602351 602351 Harryngton, John, of Stretton, yeoman 2
4065480 2047944 2047944 defendant James William yeoman 602351 602351 James, William, of Stretton, yeoman 3
4070042 2049573 2049573 defendant Rocke Thomas butcher 602351 602351 Rocke, Thomas, of Stretton, butcher 0
4091157 2057126 2057126 defendant Congreave Francis esq 602351 602351 Congreave, Francis, of Stretton, esq 1
4097129 2059295 2059295 defendant Acton Robert weaver 602351 602351 Acton, Robert, of Stretton, weaver 0
4100037 2060343 2060343 defendant Ensill Roger husbandman 602351 602351 Ensill, Roger, of Stretton, husbandman 0
4110308 2063947 2063947 defendant Abrahall Hugh miller 602351 602351 Abrahall, Hugh, of Stretton, husbandman, miller 1
4116608 2066231 2066231 defendant Kytchyn Thomas, senior cordwainer 602351 602351 Kytchyn, Thomas, senior, of Stretton, cordwainer 0
4138755 2074230 2074230 defendant Congreve John gent 602351 602351 Congreve, John, of Stretton, gent 0
4146274 2076845 2076845 defendant Andrew Prudence widow 602351 602351 Andrew, Prudence, of Stretton, widow 2
4146661 2076985 2076985 defendant Lee George yeoman 602351 602351 Lee, George, of Stretton, yeoman 0
4147880 2077395 2077395 defendant Congreve Francis esq 602351 602351 Congreve, Francis, of Stretton, esq 0
4147881 2077395 2077395 defendant Congreve John gent 602351 602351 Congreve, John, of Stretton, gent 1
4172823 2085949 2085949 defendant Congreve Francis esq 602351 602351 Congreve, Francis, of Stretton, esq 0
4178975 2088125 2088125 defendant Yorothe Philip yeoman 602351 602351 Yorothe, Philip, of Stretton, yeoman 2
4201650 2096120 2096120 defendant Lovell Eleanor widow 602351 602351 Lovell, Eleanor, of Stretton, widow 0
4217592 2101647 2101647 defendant Colly Thomas joiner 602351 602351 Colly, Thomas, of Stretton, joiner 2
4218209 2101872 2101872 defendant Abrahall John gent 602351 602351 Abrahall, John, of Stretton, gent 0
4218219 2101876 2101876 defendant Yerworth Philip yeoman 602351 602351 Yerworth, Philip, of Stretton, yeoman 0
4220654 2102722 2102722 defendant Badger John tanner 602351 602351 Badger, John, of Stretton, tanner, son of Thomas Badger, of Stretton in le Dale, tanner 0
4227458 2105085 2105085 defendant Abrahall John gent 602351 602351 Abrahall, John, of Stretton, gent 0
4227460 2105086 2105086 defendant Yerworthe Philip   602351 602351 Yerworthe, Philip, of Stretton yeoman 0
4242023 2110326 2110326 defendant Abrahall John gent 602351 602351 Abrahall, John, of Stretton, gent 1
4242799 2110582 2110582 defendant Monson Ambrose tailor 602351 602351 Monson, Ambrose, of Stretton, tailor 1
4245788 2111570 2111570 defendant Cole Richard yeoman 602351 602351 Cole, Richard, of Stretton, yeoman 0
4245789 2111570 2111570 defendant Home George yeoman 602351 602351 Home, George, of Stretton, yeoman 1
4245791 2111571 2111571 defendant Sayer Robert yeoman 602351 602351 Sayer, Robert, of Stretton, yeoman 0
4246083 2111670 2111670 defendant Moore Edward yeoman 602351 602351 Moore, Edward, of Stretton, yeoman 1
4276136 2121599 2121599 defendant Hawle James weaver 602351 602351 Hawle, James, of Stretton, weaver 3
4277665 2122113 2122113 defendant Smythe Christopher husbandman 602351 602351 Smythe, Christopher, of Stretton, husbandman 0
4278045 2122255 2122255 defendant Hayle John gent 602351 602351 Hayle, John, of Stretton, gent 0
4279425 2122724 2122724 defendant Breynton John esq 602351 602351 Breynton, John, of Stretton, esq 0
4288531 2125949 2125949 defendant Breynton John esq 602351 602351 Breynton, John, of Stretton, esq 0
4294644 2128170 2128170 defendant Amery Henry husbandman 602351 602351 Amery, Henry, of Stretton, husbandman 0
4308737 2133207 2133207 defendant Braylisford Francis yeoman 602351 602351 Braylisford, Francis, of Stretton, yeoman 0
4316656 2135942 2135942 defendant Rogers Hugh yeoman 602351 602351 Rogers, Hugh, of Stretton, yeoman 0
4334090 2141682 2141682 defendant Hughes Thomas yeoman 602351 602351 Hughes, Thomas, of Stretton, yeoman 2
4334894 2141932 2141932 defendant Collye Elizabeth widow 602351 602351 Collye, Elizabeth, of Stretton, widow 0
4371322 2154809 2154809 defendant Phillipps Richard yeoman 602351 602351 Phillipps, Richard, of Stretton, yeoman 0
4382537 2158867 2158867 defendant Birrnett George husbandman 602351 602351 Birrnett, George, of Stretton, husbandman 0
4382538 2158867 2158867 defendant Burrnett Joan widow 602351 602351 Burrnett, Joan, of Stretton, widow 1
4382539 2158867 2158867 defendant Bayly William husbandman 602351 602351 Bayly, William, of Stretton, husbandman 2
4382541 2158868 2158868 defendant Burnett George husbandman 602351 602351 Burnett, George, of Stretton, husbandman 0
4382542 2158868 2158868 defendant Burnett Joan widow 602351 602351 Burnett, Joan, of Stretton, widow 1
4382543 2158868 2158868 defendant Bayly William husbandman 602351 602351 Bayly, William, of Stretton, husbandman 2
4389637 2161164 2161164 defendant Bole Redigo widow 602351 602351 Bole, Redigo, of Stretton, widow 1
4394445 2162739 2162739 defendant Jule or Juell Gyomon cordwainer 602351 602351 Jule or Juell, Gyomon, of Stretton, cordwainer 0
4397667 2163798 2163798 defendant Lovell John yeoman 602351 602351 Lovell, John, of Stretton, yeoman 2
4411105 2168301 2168301 defendant Congreave Francis gent 602351 602351 Congreave, Francis, of Stretton, gent 0
4412081 2168633 2168633 defendant Hayle John gent 602351 602351 Hayle, John, of Stretton, gent 0
4414553 2169455 2169455 defendant Mayn Ralph   602351 602351 Mayn, Ralph, of Stretton on Dunnesmor 0
4414744 2169512 2169512 defendant Wylkynns William   602351 602351 Wylkynns, William, of Stretton 1
4421163 2171512 2171512 plaintiff Rynghelty Richard   602351 602351 Rynghelty, Richard, of Stretton 2
4424510 2172503 2172503 defendant Wyllyumes William   602351 602351 Wyllyumes, William, of Stretton 1
4429450 2174013 2174013 defendant Cryk John   602351 602351 Cryk, John, of Stretton 13

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);