names

364 rows where place_id = 586941

✎ 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
3590042 1864525 1864525 defendant Bensty Thomas barker 586941 586941 Bensty, Thomas, of Boxford, barker 0
3596543 1866554 1866554 defendant Tylle Thomas husbandman 586941 586941 Tylle, Thomas, of Boxford, husbandman 0
3604028 1868925 1868925 defendant Chevyngton James husbandman 586941 586941 Chevyngton, James, of Boxford, husbandman 0
3614457 1872172 1872172 plaintiff Brond William   586941 586941 Brond, William, of Boxford, administrators of 0
3614460 1872172 1872172 defendant Crosse William yeoman 586941 586941 Crosse, William, of Boxford, yeoman 0
3614461 1872172 1872172 defendant Kerver Thomas husbandman 586941 586941 Kerver, Thomas, of Boxford, husbandman 1
3614462 1872172 1872172 defendant Aubyr or Aubyn John laborer 586941 586941 Aubyr or Aubyn, John, of Boxford, laborer 2
3617377 1873054 1873054 defendant Cokyr Thomas husbandman 586941 586941 Cokyr, Thomas, of Boxford, husbandman 1
3620027 1873836 1873836 defendant Garrold Thomas weaver 586941 586941 Garrold, Thomas, of Boxford, weaver 1
3624319 1875140 1875140 defendant Lovell John smith 586941 586941 Lovell, John, of Boxford, smith 0
3631292 1904602 1904602 defendant Gosenold Thomas smith 586941 586941 Gosenold, Thomas, of Boxford, smith 0
3640632 1907512 1907512 defendant Spryngold John shoemaker 586941 586941 Spryngold, John, of Boxford, shoemaker 0
3640635 1907512 1907512 defendant Baker Thomas shoemaker 586941 586941 Baker, Thomas, of Boxford, shoemaker 3
3647017 1909467 1909467 plaintiff Skynner John   586941 586941 (Skynner, John, of Boxford 1
3647617 1909639 1909639 defendant Herde John carpenter 586941 586941 Herde, John, of Boxford, carpenter 0
3647619 1909639 1909639 defendant Cowper Walter weaver 586941 586941 Cowper, Walter, of Boxford, weaver 2
3657910 1912724 1912724 defendant Reynold John   586941 586941 Reynold, John, of Boxford, cloth maker 1
3660422 1913518 1913518 defendant Stekell William weaver 586941 586941 Stekell, William, of Boxford, weaver 1
3661504 1913869 1913869 defendant Fakon Ralph sheerman 586941 586941 Fakon, Ralph, of Boxford, sheerman 0
3664548 1914864 1914864 defendant Sharpe Thursten sheer man 586941 586941 Sharpe, Thursten, of Boxford, sheer man 1
3672823 1917511 1917511 defendant Tyll John weaver 586941 586941 Tyll, John, of Boxford, weaver 0
3674591 1918105 1918105 plaintiff Grene John   586941 586941 Grene, John, of Boxford 0
3676063 1918549 1918549 defendant Spryngold Nicholas shoemaker 586941 586941 Spryngold, Nicholas, of Boxford, shoemaker 0
3684417 1921258 1921258 defendant Cowper William carrier 586941 586941 Cowper, William, of Boxford, carrier 0
3684620 1921322 1921322 defendant Hall John husbandman 586941 586941 Hall, John, of Boxford, husbandman 0
3691749 1923579 1923579 defendant Newton John clothman 586941 586941 Newton, John, of Boxford, clothman 0
3694943 1924628 1924628 defendant Derman John weaver 586941 586941 Derman, John, of Boxford, weaver 1
3698573 1925772 1925772 defendant Slade Thomas husbandman 586941 586941 Slade, Thomas, of Boxford, husbandman 1
3698574 1925772 1925772 defendant Hall John husbandman 586941 586941 Hall, John, of Boxford, husbandman 2
3704756 1927776 1927776 defendant Clerk John fuller 586941 586941 Clerk, John, of Boxford, fuller 0
3708207 1928861 1928861 defendant Golias Alice widow 586941 586941 Golias, Alice, of Boxford, widow 0
3710603 1929639 1929639 defendant Todde Edmund sherman 586941 586941 Todde, Edmund, of Boxford, sherman 3
3711473 1929895 1929895 defendant Slade Thomas weaver 586941 586941 Slade, Thomas, of Boxford, weaver 0
3712841 1930336 1930336 defendant Cowper Walter clothier 586941 586941 Cowper, Walter, of Boxford, clothier 3
3712842 1930336 1930336 defendant Blade Thomas clothier 586941 586941 Blade, Thomas, of Boxford, clothier 4
3716515 1931462 1931462 defendant Wyllymot John clothmaker 586941 586941 Wyllymot, John, of Boxford, clothmaker 1
3718732 1932136 1932136 defendant Bredge John tailor 586941 586941 Bredge, John, of Boxford, tailor 2
3720486 1932691 1932691 defendant Cowper William husbandman 586941 586941 Cowper, William, of Boxford, husbandman 0
3729247 1935398 1935398 defendant Cabyll John sherman 586941 586941 Cabyll, John, of Boxford, sherman 0
3732085 1936269 1936269 defendant Wyllymot John clothmaker 586941 586941 Wyllymot, John, of Boxford, clothmaker 2
3738867 1938361 1938361 defendant Cavyll John sherman 586941 586941 Cavyll, John, of Boxford, sherman 4
3747879 1941260 1941260 defendant Kyng John clothmaker 586941 586941 Kyng, John, of Boxford, clothmaker 0
3750721 1942149 1942149 defendant Reynold John clerk 586941 586941 (Reynold, John, of Boxford, clerk 1
3759228 1944875 1944875 defendant Wyllymott John clothmaker 586941 586941 Wyllymott, John, of Boxford, clothmaker 0
3761506 1945609 1945609 defendant Craknell John tanner 586941 586941 Craknell, John, of Boxford, tanner 0
3761508 1945609 1945609 defendant Cavyll John sherman 586941 586941 Cavyll, John, of Boxford, sherman 2
3761843 1945713 1945713 defendant Kyng John clothier 586941 586941 Kyng, John, of Boxford, clothier 0
3763849 1946336 1946336 defendant Clarke John clothmaker 586941 586941 Clarke, John, of Boxford, clothmaker 3
3765108 1946753 1946753 defendant Colman John husbandman 586941 586941 Colman, John, of Boxford, husbandman 0
3765109 1946753 1946753 defendant Tyll John husbandman 586941 586941 Tyll, John, of Boxford, husbandman 1
3765110 1946753 1946753 defendant Carter Richard laborer 586941 586941 Carter, Richard, of Boxford, laborer 2
3765111 1946753 1946753 defendant Cokerell John laborer 586941 586941 Cokerell, John, of Boxford, laborer 3
3765285 1946807 1946807 defendant Chevyngton Thomas   586941 586941 Chevyngton, Thomas, of Boxford, horse courser 0
3765594 1946903 1946903 defendant Vyncent John weaver 586941 586941 Vyncent, John, of Boxford, weaver 0
3774378 1949710 1949710 defendant Baker Thomas shoemaker 586941 586941 Baker, Thomas, of Boxford, shoemaker 0
3777153 1950606 1950606 defendant Wyllymott John clothmaker 586941 586941 Wyllymott, John, of Boxford, clothmaker 1
3777564 1950734 1950734 defendant Stowe John clothmaker 586941 586941 Stowe, John, of Boxford, clothmaker 4
3778788 1951082 1951082 defendant Gryge Robert clothmaker 586941 586941 Gryge, Robert, of Boxford, clothmaker 0
3780332 1951580 1951580 defendant Esty William husbandman 586941 586941 Esty, William, of Boxford, husbandman 1
3780354 1951588 1951588 defendant Gryg Robert   586941 586941 Gryg, Robert, of Boxford 1
3780398 1951604 1951604 defendant Trott William husbandman 586941 586941 Trott, William, of Boxford, husbandman 1
3781611 1951987 1951987 defendant Hall Thomas clothmaker 586941 586941 Hall, Thomas, of Boxford, clothmaker 2
3786862 1953690 1953690 defendant Vyncent John weaver 586941 586941 Vyncent, John, of Boxford, weaver 0
3788057 1954056 1954056 defendant Restall Thomas butcher 586941 586941 Restall, Thomas, of Boxford, butcher 1
3795347 1956413 1956413 defendant Fen Peter butcher 586941 586941 Fen, Peter, of Boxford, butcher 0
3795351 1956414 1956414 defendant Fen Peter butcher 586941 586941 Fen, Peter, of Boxford, butcher 0
3799493 1957760 1957760 defendant Hall Robert   586941 586941 Hall, Robert, of Boxford, woad setter 0
3803642 1959053 1959053 defendant Todde Edmund sherman 586941 586941 Todde, Edmund, of Boxford, sherman 0
3803940 1959147 1959147 defendant Todde Edmund sherman 586941 586941 Todde, Edmund, of Boxford, sherman 0
3822258 1964865 1964865 defendant Broddysshe John smith 586941 586941 Broddysshe, John, of Boxford, smith 0
3825162 1965736 1965736 defendant Kyng John yeoman 586941 586941 Kyng, John, of Boxford, yeoman 0
3825163 1965736 1965736 defendant Heth Thomas yeoman 586941 586941 Heth, Thomas, of Boxford, yeoman 1
3839004 1970126 1970126 defendant Symond Thomas butcher 586941 586941 Symond, Thomas, of Boxford, butcher 2
3839007 1970126 1970126 defendant Stykall William weaver 586941 586941 Stykall, William, of Boxford, weaver 5
3839997 1970437 1970437 defendant Chapman Robert clothmaker 586941 586941 Chapman, Robert, of Boxford, clothmaker 0
3841117 1970798 1970798 defendant Dogett Robert clothmaker 586941 586941 Dogett, Robert, of Boxford, clothmaker 2
3852836 1974495 1974495 defendant Todde Edmund sherman 586941 586941 Todde, Edmund, of Boxford, sherman 2
3854131 1974929 1974929 defendant Cowper Walter yeoman 586941 586941 Cowper, Walter, of Boxford, yeoman 3
3862031 1977488 1977488 defendant Reynold John clerk 586941 586941 Reynold, John, of Boxford, clerk 0
3868876 1979832 1979832 defendant Meller Thomas sherman 586941 586941 Meller, Thomas, of Boxford, sherman 0
3880293 1983662 1983662 defendant Hynde John glover 586941 586941 Hynde, John, of Boxford, glover 2
3881768 1984155 1984155 defendant Mychell William sherman 586941 586941 Mychell, William, of Boxford, sherman 0
3893034 1987916 1987916 defendant Bronde Richard clothier 586941 586941 Bronde, Richard, of Boxford, clothier 1
3896627 1989082 1989082 defendant Chapman Robert weaver 586941 586941 Chapman, Robert, of Boxford, weaver 0
3899038 1989884 1989884 defendant Tod Edward clothmaker 586941 586941 Tod, Edward, of Boxford, clothmaker 0
3909472 1993469 1993469 defendant Michell William sherman 586941 586941 Michell, William, of Boxford, sherman 0
3916147 1995786 1995786 defendant Miller Thomas clothier 586941 586941 Miller, Thomas, of Boxford, clothier 1
3922550 1997857 1997857 defendant Albright Alice widow 586941 586941 Albright, Alice, of Boxford, widow 0
3922551 1997857 1997857 defendant Yong Thomas yeoman 586941 586941 Yong, Thomas, of Boxford, yeoman 1
3927567 1999561 1999561 defendant Brande William clothier 586941 586941 Brande, William, of Boxford, clothier 3
3931279 2000753 2000753 defendant Holden Thomas   586941 586941 Holden, Thomas, of Boxford, inn holder 1
3935080 2002040 2002040 defendant Sowter John clothier 586941 586941 Sowter, John, of Boxford, clothier 1
3935081 2002040 2002040 defendant Brand William clothier 586941 586941 Brand, William, of Boxford, clothier 2
3946144 2005728 2005728 defendant Luskyn Thomas clothier 586941 586941 Luskyn, Thomas, of Boxford, clothier 0
3949342 2006840 2006840 defendant Porter Robert husbandman 586941 586941 Porter, Robert, of Boxford, husbandman 2
3991520 2021725 2021725 defendant Durrant George clothier 586941 586941 Durrant, George, of Boxford, clothier 1
3994853 2022913 2022913 plaintiff Coo William   586941 586941 Coo, William, of Boxford clothier 0
3994855 2022914 2022914 plaintiff Coo William clothier 586941 586941 Coo, William, of Boxford, clothier 0
3999570 2024612 2024612 plaintiff Gale John clothier 586941 586941 Gale, John, of Boxford, clothier 0
4018129 2031205 2031205 defendant Ferrer John woodsetter 586941 586941 Ferrer, John, of Boxford, woodsetter 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);