names

599 rows where place_id = 589001

✎ 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
3590922 1864787 1864787 defendant Broune William   589001 589001 Broune, William, of Maydeston, parish clerk 3
3596226 1866448 1866448 defendant Vidyan Andrew cordwainer 589001 589001 Vidyan, Andrew, of Maydeston, cordwainer 0
3596228 1866448 1866448 defendant Plomerden Walter husbandman 589001 589001 Plomerden, Walter, of Maydeston, husbandman 2
3596230 1866448 1866448 defendant Vydyan Robert laborer 589001 589001 Vydyan, Robert, of Maydeston, laborer 4
3596231 1866448 1866448 defendant Vydyan John husbandman 589001 589001 Vydyan, John, of Maydeston, husbandman 5
3599680 1867542 1867542 plaintiff Vedian Andrew cordwainer or yeoman 589001 589001 Vedian, Andrew, of Maydeston, cordwainer or yeoman 0
3599684 1867543 1867543 plaintiff Vedyan Andrew cordwainer 589001 589001 Vedyan, Andrew, of Maydeston, cordwainer 0
3600752 1867893 1867893 defendant Pyers John husbandman 589001 589001 Pyers, John, of Maydeston, husbandman 0
3607664 1870051 1870051 defendant Mistelyn Thomas laborer 589001 589001 Mistelyn, Thomas, of Maydeston, laborer 3
3612412 1871510 1871510 plaintiff Brown Alice (legal representative) 589001 589001 Brown, Alice, of Maydeston, widow, executor of 0
3612414 1871510 1871510 defendant Fuller John husbandman 589001 589001 Fuller, John, of Maydeston, husbandman 0
3612415 1871510 1871510 defendant Hunte John husbandman 589001 589001 Hunte, John, of Maydeston, husbandman 1
3612416 1871510 1871510 defendant Ingam Thomas laborer 589001 589001 Ingam, Thomas, of Maydeston, laborer 2
3613172 1871774 1871774 defendant Travers Henry husbandman 589001 589001 Travers, Henry, of Maydeston, husbandman 1
3615656 1872540 1872540 defendant Grene William miller 589001 589001 Grene, William, of Maydeston, miller 0
3617966 1873244 1873244 defendant Audeley John   589001 589001 Audeley, John, of Maydeston, tallow chandler 0
3620787 1874073 1874073 defendant Lymden John fuller 589001 589001 Lymden, John, of Maydeston, fuller 2
3621446 1874245 1874245 defendant Slepynden Edmund laborer 589001 589001 Slepynden, Edmund, of Maydeston, laborer 0
3621447 1874245 1874245 defendant Snepp Richard tailor 589001 589001 Snepp, Richard, of Maydeston, tailor 1
3621564 1874285 1874285 defendant Water William (legal representative) 589001 589001 Water, William, of Maydeston, yeoman, executrix of 0
3621565 1874285 1874285 defendant Water Christine widow 589001 589001 Water, Christine, of Maydeston, widow 1
3622743 1874641 1874641 defendant Masse John, junior chapman 589001 589001 Masse, John, junior, of Maydeston, chapman 0
3630999 1904516 1904516 defendant Yate Thomas cutler 589001 589001 Yate, Thomas, of Maydeston, cutler 0
3632099 1904856 1904856 defendant Girdeler John   589001 589001 Girdeler, John, of Maydeston, mason 0
3632239 1904900 1904900 defendant Lucas John clothmaker 589001 589001 Lucas, John, of Maydeston, clothmaker 0
3633536 1905299 1905299 defendant Umfrey Richard cutler 589001 589001 Umfrey, Richard, of Maydeston, cutler 1
3638762 1906943 1906943 plaintiff Tylden Roger (legal representative) 589001 589001 Tylden, Roger, of Maydeston, draper, executrix of 0
3639832 1907271 1907271 defendant Grey Thomas pardoner 589001 589001 Grey, Thomas, of Maydeston, pardoner 1
3639833 1907271 1907271 defendant Yate Thomas saddler 589001 589001 Yate, Thomas, of Maydeston, saddler 2
3648372 1909891 1909891 defendant Lorkyn Thomas carpenter 589001 589001 Lorkyn, Thomas, of Maydeston, carpenter 0
3648421 1909907 1909907 defendant Hertregge Thomas hosier 589001 589001 Hertregge, Thomas, of Maydeston, hosier 0
3656378 1912241 1912241 defendant Vinfry John tinker 589001 589001 Vinfry, John, of Maydeston, tinker 0
3656380 1912241 1912241 defendant Yatte William cutler 589001 589001 Yatte, William, of Maydeston, cutler 2
3657239 1912527 1912527 defendant Coveney John dyer 589001 589001 Coveney, John, of Maydeston, dyer 0
3660355 1913500 1913500 defendant Eluit William fuller 589001 589001 Eluit, William, of Maydeston, fuller 1
3665445 1915141 1915141 defendant Alsew or Alfew John fuller 589001 589001 Alsew or Alfew, John, of Maydeston, fuller 1
3666447 1915456 1915456 defendant Basse Richard dyer 589001 589001 Basse, Richard, of Maydeston, dyer 0
3666448 1915456 1915456 defendant Dene Richard butcher 589001 589001 Dene, Richard, of Maydeston, butcher 1
3666842 1915572 1915572 defendant Tobye Thomas (legal representative) 589001 589001 Tobye, Thomas, of Maydeston, yeoman, executrix of 0
3666843 1915572 1915572 defendant Tobye Christiane widow 589001 589001 Tobye, Christiane, of Maydeston, widow 1
3666921 1915598 1915598 defendant Kyng William tailor 589001 589001 Kyng, William, of Maydeston, tailor 0
3672669 1917455 1917455 defendant Kyng William tailor 589001 589001 Kyng, William, of Maydeston, tailor 0
3672702 1917464 1917464 defendant Kyng William tailor 589001 589001 Kyng, William,of Maydeston, tailor 2
3673862 1917857 1917857 defendant Maister Robert husbandman 589001 589001 Maister, Robert, of Maydeston, husbandman 0
3675612 1918408 1918408 defendant Fysshecok John fuller 589001 589001 Fysshecok, John, of Maydeston, fuller 0
3676426 1918671 1918671 defendant Gardyner Alexander glover 589001 589001 Gardyner, Alexander, of Maydeston, glover 0
3676427 1918671 1918671 defendant A Nore Robert laborer 589001 589001 A Nore, Robert, of Maydeston, laborer 1
3676428 1918671 1918671 defendant Jacobbe John smith 589001 589001 Jacobbe, John, of Maydeston, smith 2
3676429 1918671 1918671 defendant Hygham Robert laborer 589001 589001 Hygham, Robert, of Maydeston, laborer 3
3676430 1918671 1918671 defendant Cotys Ellen widow 589001 589001 Cotys, Ellen, of Maydeston, widow 4
3676475 1918687 1918687 defendant Phyllyp Henry laborer 589001 589001 Phyllyp, Henry, of Maydeston, laborer 1
3676478 1918688 1918688 defendant Lylly John draper 589001 589001 Lylly, John, of Maydeston, draper 1
3678866 1919456 1919456 defendant Cotys Ellen widow 589001 589001 Cotys, Ellen, of Maydeston, widow 0
3679674 1919709 1919709 defendant Kyng William tailor 589001 589001 Kyng, William, of Maydeston, tailor 0
3682938 1920776 1920776 defendant Payn John shoemaker 589001 589001 Payn, John, of Maydeston, shoemaker 1
3686296 1921869 1921869 defendant Harre John plumber 589001 589001 Harre, John, of Maydeston, plumber 1
3687404 1922237 1922237 defendant Wreske John smith 589001 589001 Wreske, John, of Maydeston, smith 0
3688135 1922441 1922441 defendant Kyng William yeoman 589001 589001 Kyng, William, of Maydeston, yeoman 0
3688136 1922441 1922441 defendant Parker Thomas gent 589001 589001 Parker, Thomas, of Maydeston, gent 1
3688596 1922593 1922593 defendant Elnott William sherman 589001 589001 Elnott, William, of Maydeston, sherman 0
3688597 1922593 1922593 defendant Norwode John   589001 589001 Norwode, John, of Maydeston, mason 1
3688598 1922593 1922593 defendant Clerk John smith 589001 589001 Clerk, John, of Maydeston, smith 2
3688599 1922593 1922593 defendant Gardyner Alexander glover 589001 589001 Gardyner, Alexander, of Maydeston, glover 3
3688600 1922593 1922593 defendant Brydyn Thomas laborer 589001 589001 Brydyn, Thomas, of Maydeston, laborer 4
3690164 1923081 1923081 defendant Westborough Thomas yeoman 589001 589001 Westborough, Thomas, of Maydeston, yeoman 0
3691321 1923446 1923446 defendant Miller Thomas chandler 589001 589001 Miller, Thomas, of Maydeston, chandler 0
3691322 1923446 1923446 defendant Benett Richard butcher 589001 589001 Benett, Richard, of Maydeston, butcher 1
3691323 1923446 1923446 defendant Seton Robert   589001 589001 Seton, Robert, of Maydeston, mason 2
3692340 1923774 1923774 defendant Jacobbe John smith 589001 589001 Jacobbe, John, of Maydeston, smith 0
3692342 1923775 1923775 defendant Lylly John draper 589001 589001 Lylly, John, of Maydeston, draper 0
3693199 1924083 1924083 defendant Basse Richard dyer 589001 589001 Basse, Richard, of Maydeston, dyer 2
3693200 1924083 1924083 defendant Colyer Robert collier 589001 589001 Colyer, Robert, of Maydeston, collier 3
3693201 1924083 1924083 defendant Lylly John yeoman 589001 589001 Lylly, John, of Maydeston, yeoman 4
3693427 1924160 1924160 defendant Wyndon Richard glover 589001 589001 Wyndon, Richard, of Maydeston, glover 1
3695578 1924845 1924845 defendant Palmer Henry weaver 589001 589001 Palmer, Henry, of Maydeston, weaver 2
3696907 1925253 1925253 defendant Toby or Tovy Christine widow 589001 589001 Toby or Tovy, Christine, of Maydeston, widow 1
3697645 1925487 1925487 defendant Batherst Thomas husbandman 589001 589001 Batherst, Thomas, of Maydeston, husbandman 1
3697651 1925489 1925489 defendant Netter John   589001 589001 Netter, John, of Maydeston, mason 0
3699375 1926025 1926025 defendant Hilles John, senior husbandman 589001 589001 Hilles, John, senior, of Maydeston, husbandman 0
3702391 1927008 1927008 plaintiff Chirche Richard (legal representative) 589001 589001 Chirche, Richard, of Maydeston, executors of 0
3702393 1927008 1927008 defendant Wreske alias Smyth John smith 589001 589001 Wreske alias Smyth, John, of Maydeston, smith 0
3703467 1927356 1927356 defendant Elnott William sherman 589001 589001 Elnott, William, of Maydeston, sherman 2
3703469 1927356 1927356 defendant Cristmasse John carpenter 589001 589001 Cristmasse, John, of Maydeston, carpenter 4
3705148 1927899 1927899 defendant Fyssher John, junior gent 589001 589001 Fyssher, John, junior, of Maydeston, gent 0
3705819 1928100 1928100 plaintiff Herenden Walter gent 589001 589001 Herenden, Walter, of Maydeston, gent 0
3707304 1928572 1928572 defendant Hartrygge Thomas yeoman 589001 589001 Hartrygge, Thomas, of Maydeston, yeoman 0
3712289 1930159 1930159 defendant Hed Thomas gent 589001 589001 Hed, Thomas, of Maydeston, gent 0
3712290 1930159 1930159 defendant Lorkyn Thomas yeoman 589001 589001 Lorkyn, Thomas, of Maydeston, yeoman 1
3712291 1930159 1930159 defendant Crystmas John yeoman 589001 589001 Crystmas, John, of Maydeston, yeoman 2
3712906 1930357 1930357 defendant Hylles John, senior husbandman 589001 589001 Hylles, John, senior, of Maydeston, husbandman 0
3714581 1930857 1930857 defendant Harre John plumber 589001 589001 Harre, John, of Maydeston, plumber 0
3714583 1930858 1930858 defendant Hoo Thomas laborer 589001 589001 Hoo, Thomas, of Maydeston, laborer 0
3717766 1931857 1931857 defendant Miller Thomas   589001 589001 Miller, Thomas, of Maydeston, wax chandler 0
3718988 1932217 1932217 defendant Ippyngbery John pewterer 589001 589001 Ippyngbery, John, of Maydeston, pewterer 7
3719193 1932288 1932288 defendant Fyssher John, junior gent 589001 589001 Fyssher, John, junior, of Maydeston, gent 0
3724544 1933962 1933962 defendant Harreys William cutler 589001 589001 Harreys, William, of Maydeston, cutler 3
3732531 1936404 1936404 defendant Kyng William tailor 589001 589001 Kyng, William, of Maydeston, tailor 1
3732532 1936404 1936404 defendant Hertregge Thomas tailor 589001 589001 Hertregge, Thomas, of Maydeston, tailor 2
3734969 1937173 1937173 defendant Fyssher John, junior gent 589001 589001 Fyssher, John, junior, of Maydeston, gent 0
3736989 1937815 1937815 defendant Averey Thomas butcher 589001 589001 Averey, Thomas, of Maydeston, butcher 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);