names

349 rows where place_id = 589377

✎ 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
3597426 1866814 1866814 defendant Goldyng William cutler 589377 589377 Goldyng, William, of Thaxsted, cutler 3
3597428 1866814 1866814 defendant Tanne Katherine widow 589377 589377 Tanne, Katherine, of Thaxsted, widow 5
3602344 1868395 1868395 defendant Damery Richard yeoman 589377 589377 Damery, Richard, of Thaxsted, yeoman 0
3607104 1869887 1869887 defendant Damary Richard yeoman 589377 589377 Damary, Richard, of Thaxsted, yeoman 0
3608978 1870466 1870466 defendant Spylman John yeoman 589377 589377 Spylman, John, of Thaxsted, yeoman 0
3613571 1871892 1871892 defendant Damery Richard yeoman 589377 589377 Damery, Richard, of Thaxsted, yeoman 0
3614394 1872151 1872151 defendant Neweman henry grocer 589377 589377 Neweman, henry, of Thaxsted, grocer 0
3615747 1872566 1872566 defendant John John yeoman 589377 589377 John, John, of Thaxsted, yeoman 0
3630540 1904382 1904382 defendant Wrest William, senior cutler 589377 589377 Wrest, William, senior, of Thaxsted, cutler 1
3630541 1904382 1904382 defendant Reynold Thomas tanner 589377 589377 Reynold, Thomas, of Thaxsted, tanner 2
3633225 1905206 1905206 defendant Pateshale Walter gent 589377 589377 Pateshale, Walter, of Thaxsted, gent 0
3635527 1905912 1905912 plaintiff Pateshale Walter gent 589377 589377 Pateshale, Walter, of Thaxsted, gent 0
3642729 1908172 1908172 defendant Wales John husbandman 589377 589377 Wales, John, of Thaxsted, husbandman 0
3658506 1912912 1912912 defendant Freman John husbandman 589377 589377 Freman, John, of Thaxsted, husbandman 1
3665588 1915187 1915187 defendant Fame John tanner 589377 589377 Fame, John, of Thaxsted, tanner 0
3665589 1915187 1915187 defendant Busshe John pewterer 589377 589377 Busshe, John, of Thaxsted, pewterer 1
3665590 1915187 1915187 defendant Harvy William tailor 589377 589377 Harvy, William, of Thaxsted, tailor 2
3665591 1915187 1915187 defendant Wake John laborer 589377 589377 Wake, John, of Thaxsted, laborer 3
3665592 1915187 1915187 defendant Bavour or Banour Thomas sheer man 589377 589377 Bavour or Banour, Thomas, of Thaxsted, sheer man 4
3665727 1915228 1915228 defendant Fannery John tanner 589377 589377 Fannery, John, of Thaxsted, tanner 0
3665728 1915228 1915228 defendant Busshe John pewterer 589377 589377 Busshe, John, of Thaxsted, pewterer 1
3665729 1915228 1915228 defendant Harvy William tailor 589377 589377 Harvy, William, of Thaxsted, tailor 2
3665730 1915228 1915228 defendant Wale John laborer 589377 589377 Wale, John, of Thaxsted, laborer 3
3665731 1915228 1915228 defendant Banour Thomas sheer man 589377 589377 Banour, Thomas, of Thaxsted, sheer man 4
3670004 1916564 1916564 defendant Rychardys alias Richardson William husbandman 589377 589377 Rychardys alias Richardson, William, of Thaxsted, husbandman 0
3670005 1916564 1916564 defendant Rychardys alias Richardson Thomas husbandman 589377 589377 Rychardys alias Richardson, Thomas, of Thaxsted, husbandman 1
3671472 1917059 1917059 defendant Appulford John draper 589377 589377 Appulford, John, of Thaxsted, draper 0
3674327 1918014 1918014 defendant Spylman John butcher 589377 589377 Spylman, John, of Thaxsted, butcher 1
3675567 1918394 1918394 defendant Appulforth John yeoman 589377 589377 Appulforth, John, of Thaxsted, yeoman 0
3681017 1920140 1920140 defendant Bygode Robert dyer 589377 589377 Bygode, Robert, of Thaxsted, dyer 0
3682813 1920730 1920730 defendant Bygode Robert dyer 589377 589377 Bygode, Robert, of Thaxsted, dyer 0
3695175 1924713 1924713 plaintiff Petyton William tanner 589377 589377 Petyton, William, of Thaxsted, tanner 0
3695176 1924713 1924713 defendant Johnson Thomas shoemaker 589377 589377 Johnson, Thomas, of Thaxsted, shoemaker 0
3698126 1925640 1925640 defendant Pygg John hosier 589377 589377 Pygg, John, of Thaxsted, hosier 0
3698130 1925640 1925640 defendant Freman John husbandman 589377 589377 Freman, John, of Thaxsted, husbandman 4
3700901 1926528 1926528 defendant Seward John husbandman 589377 589377 Seward, John, of Thaxsted, husbandman 0
3700903 1926528 1926528 defendant Glover John husbandman 589377 589377 Glover, John, of Thaxsted, husbandman 2
3700905 1926529 1926529 defendant Sewarde John husbandman 589377 589377 Sewarde, John, of Thaxsted, husbandman 0
3700907 1926529 1926529 defendant Glover John husbandman 589377 589377 Glover, John, of Thaxsted, husbandman 2
3706872 1928435 1928435 defendant Johnson Thomas shoemaker 589377 589377 Johnson, Thomas, of Thaxsted, shoemaker 0
3707004 1928475 1928475 defendant Masham Thomas pardoner 589377 589377 Masham, Thomas, of Thaxsted, pardoner 0
3711043 1929765 1929765 plaintiff Steke John gent 589377 589377 Steke, John, of Thaxsted, gent 0
3711825 1930014 1930014 defendant Pygge John husbandman 589377 589377 Pygge, John, of Thaxsted, husbandman 0
3711826 1930014 1930014 defendant Freman John husbandman 589377 589377 Freman, John, of Thaxsted, husbandman 1
3716732 1931525 1931525 defendant Vaughan Hugh tailor 589377 589377 Vaughan, Hugh, of Thaxsted, tailor 0
3723455 1933604 1933604 defendant Harrys Robert laborer 589377 589377 Harrys, Robert, of Thaxsted, laborer 1
3723456 1933604 1933604 defendant Overall William husbandman 589377 589377 Overall, William, of Thaxsted, husbandman 2
3725227 1934177 1934177 defendant Brynkeley Thomas tailor 589377 589377 Brynkeley, Thomas, of Thaxsted, tailor 1
3726133 1934438 1934438 defendant Hert John, senior butcher 589377 589377 Hert, John, senior, of Thaxsted, butcher 0
3726134 1934438 1934438 defendant Spylman John butcher 589377 589377 Spylman, John, of Thaxsted, butcher 1
3729054 1935337 1935337 defendant Thomlynson Thomas dyer 589377 589377 Thomlynson, Thomas, of Thaxsted, dyer 3
3735565 1937359 1937359 defendant Pediton William tanner 589377 589377 Pediton, William, of Thaxsted, tanner 1
3739679 1938623 1938623 defendant Hart John, junior butcher 589377 589377 Hart, John, junior, of Thaxsted, butcher 1
3746215 1940724 1940724 defendant Appullford John, senior yeoman 589377 589377 Appullford, John, senior, of Thaxsted, yeoman 0
3747599 1941167 1941167 defendant Smyth Robert tailor 589377 589377 Smyth, Robert, of Thaxsted, tailor 0
3747600 1941167 1941167 defendant Starkyn Ralph tanner 589377 589377 Starkyn, Ralph, of Thaxsted, tanner 1
3747601 1941167 1941167 defendant Pomfrett Thomas butcher 589377 589377 Pomfrett, Thomas, of Thaxsted, butcher 2
3751078 1942266 1942266 defendant Chapman John husbandman 589377 589377 Chapman, John, of Thaxsted, husbandman 0
3751627 1942425 1942425 defendant Sewetok Thomas shoemaker 589377 589377 Sewetok, Thomas, of Thaxsted, shoemaker 0
3756052 1943848 1943848 defendant Maykyn Richard fuller 589377 589377 Maykyn, Richard, of Thaxsted, fuller 0
3756155 1943882 1943882 defendant Spylman John butcher 589377 589377 Spylman, John, of Thaxsted, butcher 0
3756284 1943927 1943927 defendant Roche Simon husbandman 589377 589377 Roche, Simon, of Thaxsted, husbandman 1
3765921 1947007 1947007 defendant Appulford William yeoman 589377 589377 Appulford, William, of Thaxsted, yeoman 0
3768392 1947759 1947759 defendant Petyton William tanner 589377 589377 Petyton, William, of Thaxsted, tanner 1
3772325 1949030 1949030 defendant Roche Simon husbandman 589377 589377 Roche, Simon, of Thaxsted, husbandman 1
3778990 1951150 1951150 defendant Pomfrett William butcher 589377 589377 Pomfrett, William, of Thaxsted, butcher 0
3779615 1951353 1951353 defendant Pompfrett Thomas butcher 589377 589377 Pompfrett, Thomas, of Thaxsted, butcher 3
3779616 1951353 1951353 defendant Maynford Edmund miller 589377 589377 Maynford, Edmund, of Thaxsted, miller 4
3783869 1952726 1952726 defendant Fanne Richard yeoman 589377 589377 Fanne, Richard, of Thaxsted, yeoman 0
3784086 1952804 1952804 defendant Wylcon Thomas cooper 589377 589377 Wylcon, Thomas, of Thaxsted, cooper 0
3785071 1953114 1953114 defendant Spylman John butcher 589377 589377 Spylman, John, of Thaxsted, butcher 2
3785276 1953182 1953182 defendant More William yeoman 589377 589377 More, William, of Thaxsted, yeoman 0
3786546 1953585 1953585 defendant Dowe Richard blacksmith 589377 589377 Dowe, Richard, of Thaxsted, blacksmith 0
3786550 1953587 1953587 defendant Dowe Richard blacksmith 589377 589377 Dowe, Richard, of Thaxsted, blacksmith 0
3789116 1954404 1954404 defendant Spylman John butcher 589377 589377 Spylman, John, of Thaxsted, butcher 0
3791722 1955256 1955256 plaintiff Aburford John, junior draper 589377 589377 Aburford, John, junior, of Thaxsted, draper 0
3793654 1955877 1955877 defendant Abarforth John yeoman 589377 589377 Abarforth, John, of Thaxsted, yeoman 1
3793693 1955892 1955892 defendant Thorton Robert chaplain 589377 589377 Thorton, Robert, of Thaxsted, chaplain 0
3796610 1956815 1956815 plaintiff Fan John, senior tanner 589377 589377 Fan, John, senior, of Thaxsted, tanner 0
3796611 1956815 1956815 defendant Goodhyne John haberdasher 589377 589377 Goodhyne, John, of Thaxsted, haberdasher 0
3796612 1956815 1956815 defendant Hamond John tailor 589377 589377 Hamond, John, of Thaxsted, tailor 1
3796613 1956815 1956815 defendant Juste Stephen   589377 589377 Juste, Stephen, of Thaxsted, bellows maker 2
3796614 1956815 1956815 defendant Perse John cutler 589377 589377 Perse, John, of Thaxsted, cutler 3
3797134 1956986 1956986 defendant Pygott Thomas yeoman 589377 589377 Pygott, Thomas, of Thaxsted, yeoman 0
3799748 1957842 1957842 defendant Ewan William laborer 589377 589377 Ewan, William, of Thaxsted, laborer 0
3799749 1957842 1957842 defendant Harte John butcher 589377 589377 Harte, John, of Thaxsted, butcher 1
3799751 1957843 1957843 plaintiff Keye James husbandman 589377 589377 Keye, James, of Thaxsted, husbandman 0
3799752 1957843 1957843 defendant Spylman John, senior butcher 589377 589377 Spylman, John, senior, of Thaxsted, butcher 0
3799754 1957843 1957843 defendant Wale William cutler 589377 589377 Wale, William, of Thaxsted, cutler 2
3799755 1957843 1957843 defendant Kyng William mercer 589377 589377 Kyng, William, of Thaxsted, mercer 3
3800326 1958018 1958018 defendant Fanne Richard yeoman 589377 589377 Fanne, Richard, of Thaxsted, yeoman 0
3800589 1958092 1958092 defendant Wilton John cooper 589377 589377 Wilton, John, of Thaxsted, cooper 0
3801333 1958347 1958347 defendant Ewen William, senior husbandman 589377 589377 Ewen, William, senior, of Thaxsted, husbandman 0
3801334 1958347 1958347 defendant Ewen John husbandman 589377 589377 Ewen, John, of Thaxsted, husbandman 1
3801772 1958450 1958450 plaintiff Netherstrett John husbandman 589377 589377 Netherstrett, John, of Thaxsted, husbandman 0
3801773 1958450 1958450 defendant Smyth Thomas husbandman 589377 589377 Smyth, Thomas, of Thaxsted, husbandman 0
3802443 1958661 1958661 plaintiff Pateshall Walter (legal representative) 589377 589377 Pateshall, Walter, of Thaxsted, executrix of 0
3804514 1959351 1959351 defendant Appulforth John, junior yeoman 589377 589377 Appulforth, John, junior, of Thaxsted, yeoman 0
3809577 1960882 1960882 defendant Fen John yeoman 589377 589377 Fen, John, of Thaxsted, yeoman 0
3811766 1961579 1961579 defendant Appylford John, senior yeoman 589377 589377 Appylford, John, senior, of Thaxsted, yeoman 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);