names

200 rows where place_id = 588273

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593913 1865734 1865734 defendant Page Robert yeoman 588273 588273 Page, Robert, of Stowmarket, yeoman 1
3615922 1872619 1872619 defendant Myrtyn John husbandman 588273 588273 Myrtyn, John, of Stowmarket, husbandman 0
3627588 1903488 1903488 plaintiff Bradwey Robert   588273 588273 Bradwey, Robert, of Stowmarket 0
3627590 1903488 1903488 defendant Kebyll John yeoman 588273 588273 Kebyll, John, of Stowmarket, yeoman 1
3629194 1904000 1904000 defendant Brook John alias Richard husbandman 588273 588273 Brook, John alias Richard, of Stowmarket, husbandman 0
3629195 1904000 1904000 defendant Brook John husbandman 588273 588273 Brook, John, of Stowmarket, husbandman 1
3630112 1904266 1904266 defendant Sparowe John husbandman 588273 588273 Sparowe, John, of Stowmarket, husbandman 1
3631296 1904602 1904602 defendant Russhbroke Robert clothmaker 588273 588273 Russhbroke, Robert, of Stowmarket, clothmaker 4
3632104 1904857 1904857 defendant Kebyll Thomas butcher 588273 588273 Kebyll, Thomas, of Stowmarket, butcher 3
3638870 1906979 1906979 defendant Hamond Roger barker 588273 588273 Hamond, Roger, of Stowmarket, barker 0
3639004 1907022 1907022 defendant Thyng Thomas husbandman 588273 588273 Thyng, Thomas, of Stowmarket, husbandman 0
3639005 1907022 1907022 defendant Borowe Roger husbandman 588273 588273 Borowe, Roger, of Stowmarket, husbandman 1
3639006 1907022 1907022 defendant Kelam Roger smith 588273 588273 Kelam, Roger, of Stowmarket, smith 2
3641273 1907722 1907722 defendant Jenor alias Peyntor Thomas husbandman 588273 588273 Jenor alias Peyntor, Thomas, of Stowmarket, husbandman 0
3644088 1908581 1908581 defendant Newport William fuller 588273 588273 Newport, William, of Stowmarket, fuller 2
3647202 1909514 1909514 defendant Padnall John husbandman 588273 588273 Padnall, John, of Stowmarket, husbandman 0
3647203 1909514 1909514 defendant Brygys John husbandman 588273 588273 Brygys, John, of Stowmarket, husbandman 1
3652229 1911038 1911038 defendant Smarte John husbandman 588273 588273 Smarte, John, of Stowmarket, husbandman 0
3652230 1911038 1911038 defendant Symonde Richard sherman 588273 588273 Symonde, Richard, of Stowmarket, sherman 1
3652232 1911038 1911038 defendant Best Thomas laborer 588273 588273 Best, Thomas, of Stowmarket, laborer 3
3662047 1914064 1914064 defendant Newport William husbandman 588273 588273 Newport, William, of Stowmarket, husbandman 3
3678990 1919499 1919499 defendant Austen John weaver 588273 588273 Austen, John, of Stowmarket, weaver 0
3681510 1920308 1920308 defendant Austyn John husbandman 588273 588273 Austyn, John, of Stowmarket, husbandman 0
3684701 1921347 1921347 defendant Page Robert husbandman 588273 588273 Page, Robert, of Stowmarket, husbandman 1
3686656 1921981 1921981 plaintiff Bryggys Joan widow 588273 588273 Bryggys, Joan, of Stowmarket, widow 0
3687972 1922399 1922399 defendant Cotyngham John yeoman 588273 588273 Cotyngham, John, of Stowmarket, yeoman 1
3688741 1922640 1922640 defendant Austen John beer brewer 588273 588273 Austen, John, of Stowmarket, beer brewer 3
3693444 1924165 1924165 defendant Page Robert husbandman 588273 588273 Page, Robert, of Stowmarket, husbandman 0
3693445 1924165 1924165 defendant Padnall John butcher 588273 588273 Padnall, John, of Stowmarket, butcher 1
3694206 1924391 1924391 defendant Trust John   588273 588273 Trust, John, of Stowmarket, "odsetter" 4
3695840 1924934 1924934 defendant Benson Thomas tailor 588273 588273 Benson, Thomas, of Stowmarket, tailor 0
3696096 1925003 1925003 defendant Benson Thomas innkeeper 588273 588273 Benson, Thomas, of Stowmarket, innkeeper 0
3696252 1925049 1925049 defendant Thorp John yeoman 588273 588273 Thorp, John, of Stowmarket, yeoman 2
3696742 1925206 1925206 defendant Newport John dyer 588273 588273 Newport, John, of Stowmarket, dyer 1
3696747 1925208 1925208 defendant Symond Richard dyer 588273 588273 Symond, Richard, of Stowmarket, dyer 0
3697751 1925519 1925519 defendant Prykke Edward fuller 588273 588273 Prykke, Edward, of Stowmarket, fuller 0
3697817 1925536 1925536 defendant Wage John carpenter 588273 588273 Wage, John, of Stowmarket, carpenter 0
3697818 1925536 1925536 defendant Wynde John weaver 588273 588273 Wynde, John, of Stowmarket, weaver 1
3697819 1925536 1925536 defendant Kelon John smith 588273 588273 Kelon, John, of Stowmarket, smith 2
3697821 1925536 1925536 defendant Benson Thomas innholder 588273 588273 Benson, Thomas, of Stowmarket, innholder 4
3698648 1925792 1925792 defendant Pytman Richard sherman 588273 588273 Pytman, Richard, of Stowmarket, sherman 0
3698653 1925794 1925794 defendant Pytman Richard sherman 588273 588273 Pytman, Richard, of Stowmarket, sherman 1
3699182 1925957 1925957 defendant Terell James esq 588273 588273 Terell, James, of Stowmarket, esq 0
3702883 1927173 1927173 defendant Cotyngham John yeoman 588273 588273 Cotyngham, John, of Stowmarket, yeoman 0
3707588 1928669 1928669 defendant Pannell John butcher 588273 588273 Pannell, John, of Stowmarket, butcher 1
3708222 1928865 1928865 defendant Truste John   588273 588273 Truste, John, of Stowmarket, wood setter 2
3709738 1929358 1929358 defendant Benson Thomas tailor 588273 588273 Benson, Thomas, of Stowmarket, tailor 0
3709934 1929421 1929421 defendant Benson Thomas innkeeper 588273 588273 Benson, Thomas, of Stowmarket, innkeeper 0
3710046 1929452 1929452 defendant Cotyngham John husbandman 588273 588273 Cotyngham, John, of Stowmarket, husbandman 1
3711345 1929855 1929855 defendant Bacon Robert laborer 588273 588273 Bacon, Robert, of Stowmarket, laborer 0
3711346 1929855 1929855 defendant Padnall John butcher 588273 588273 Padnall, John, of Stowmarket, butcher 1
3711347 1929855 1929855 defendant Kelton John smith 588273 588273 Kelton, John, of Stowmarket, smith 2
3711348 1929855 1929855 defendant Wynde John weaver 588273 588273 Wynde, John, of Stowmarket, weaver 3
3716822 1931548 1931548 defendant Bacon Robert husbandman 588273 588273 Bacon, Robert, of Stowmarket, husbandman 0
3719559 1932382 1932382 defendant Thorpe John innholder 588273 588273 Thorpe, John, of Stowmarket, innholder 0
3720359 1932645 1932645 defendant Page Robert baker 588273 588273 Page, Robert, of Stowmarket, baker 0
3723413 1933589 1933589 defendant Thorpe John husbandman 588273 588273 Thorpe, John, of Stowmarket, husbandman 0
3725251 1934185 1934185 defendant Tornour Richard sherman 588273 588273 Tornour, Richard, of Stowmarket, sherman 3
3726424 1934533 1934533 plaintiff Thorp William clothman 588273 588273 Thorp, William, of Stowmarket, clothman 0
3726425 1934533 1934533 defendant Turnour Philip fuller 588273 588273 Turnour, Philip, of Stowmarket, fuller 0
3728546 1935179 1935179 defendant Page Robert baker 588273 588273 Page, Robert, of Stowmarket, baker 0
3734616 1937074 1937074 defendant Cotyngham John yeoman 588273 588273 Cotyngham, John, of Stowmarket, yeoman 1
3737895 1938072 1938072 defendant Revet Thomas gent 588273 588273 Revet, Thomas, of Stowmarket, gent 0
3740598 1938919 1938919 defendant Thorp John husbandman 588273 588273 Thorp, John, of Stowmarket, husbandman 0
3740724 1938963 1938963 defendant Symond Richard dyer 588273 588273 Symond, Richard, of Stowmarket, dyer 0
3742172 1939418 1939418 defendant Garrard Thomas sherman 588273 588273 Garrard, Thomas, of Stowmarket, sherman 1
3745200 1940405 1940405 defendant Newport John husbandman 588273 588273 Newport, John, of Stowmarket, husbandman 0
3745658 1940549 1940549 defendant Newport John husbandman 588273 588273 Newport, John, of Stowmarket, husbandman 0
3747060 1940995 1940995 defendant Wage John yeoman 588273 588273 Wage, John, of Stowmarket, yeoman 0
3747061 1940995 1940995 defendant Thorp John yeoman 588273 588273 Thorp, John, of Stowmarket, yeoman 1
3752475 1942697 1942697 defendant Andrewe John clothmaker 588273 588273 Andrewe, John, of Stowmarket, clothmaker 0
3752477 1942698 1942698 defendant Andrewe Thomas yeoman 588273 588273 Andrewe, Thomas, of Stowmarket, yeoman 0
3756340 1943950 1943950 defendant Andrewe Thomas   588273 588273 Andrewe, Thomas, of Stowmarket, pedlar 0
3756777 1944092 1944092 defendant Taylour Thomas miller 588273 588273 Taylour, Thomas, of Stowmarket, miller 0
3758795 1944740 1944740 defendant Newport John husbandman 588273 588273 Newport, John, of Stowmarket, husbandman 0
3760422 1945262 1945262 defendant Newport John husbandman 588273 588273 Newport, John, of Stowmarket, husbandman 0
3762066 1945778 1945778 defendant Rede Thomas husbandman 588273 588273 Rede, Thomas, of Stowmarket, husbandman 1
3766359 1947133 1947133 defendant Thorp John mercer 588273 588273 Thorp, John, of Stowmarket, mercer 0
3766361 1947133 1947133 defendant Newport John husbandman 588273 588273 Newport, John, of Stowmarket, husbandman 2
3766362 1947133 1947133 defendant Benson Leonard smith 588273 588273 Benson, Leonard, of Stowmarket, smith 3
3767519 1947478 1947478 defendant Benston Leonard smith 588273 588273 Benston, Leonard, of Stowmarket, smith 0
3769902 1948242 1948242 defendant Newport John husbandman 588273 588273 Newport, John, of Stowmarket, husbandman 0
3771460 1948766 1948766 defendant Turner Richard clothmaker 588273 588273 Turner, Richard, of Stowmarket, clothmaker 0
3771462 1948766 1948766 defendant Newporte John husbandman 588273 588273 Newporte, John, of Stowmarket, husbandman 2
3771632 1948826 1948826 plaintiff Terell James esq 588273 588273 Terell, James, of Stowmarket, esq 0
3771633 1948826 1948826 defendant Newport John yeoman 588273 588273 Newport, John, of Stowmarket, yeoman 0
3771634 1948826 1948826 defendant Sharpe John teoman 588273 588273 Sharpe, John, of Stowmarket, teoman 1
3775846 1950197 1950197 defendant Studde Richard yeoman 588273 588273 Studde, Richard, of Stowmarket, yeoman 0
3779075 1951182 1951182 defendant Newport John yeoman 588273 588273 Newport, John, of Stowmarket, yeoman 0
3785382 1953216 1953216 plaintiff Newport John   588273 588273 Newport, John, of Stowmarket 0
3788142 1954087 1954087 defendant Willise Thomas carpenter 588273 588273 Willise, Thomas, of Stowmarket, carpenter 1
3788143 1954087 1954087 defendant Fystevyn Roger pedder 588273 588273 Fystevyn, Roger, of Stowmarket, pedder 2
3789428 1954518 1954518 defendant Wellys John husbandman 588273 588273 Wellys, John, of Stowmarket, husbandman 0
3789429 1954518 1954518 defendant Beton William laborer 588273 588273 Beton, William, of Stowmarket, laborer 1
3790221 1954759 1954759 defendant Newport John husbandman 588273 588273 Newport, John, of Stowmarket, husbandman 2
3790243 1954764 1954764 defendant Instaunce William husbandman 588273 588273 Instaunce, William, of Stowmarket, husbandman 2
3795615 1956513 1956513 defendant Thorp John mercer 588273 588273 Thorp, John, of Stowmarket, mercer 0
3800859 1958178 1958178 defendant Mundy Joan   588273 588273 Mundy, Joan, of Stowmarket, widow of Mundy, John 0
3803044 1958854 1958854 defendant Newport John yeoman 588273 588273 Newport, John, of Stowmarket, yeoman 0
3806779 1960022 1960022 defendant Newporte John dyer 588273 588273 Newporte, John, of Stowmarket, dyer 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);