names

160 rows where place_id = 589650

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590208 1864580 1864580 plaintiff Colet Robert (legal representative) 589650 589650 Colet, Robert, of Long Melford, yeoman, executrix of 0
3598290 1867096 1867096 defendant Curson Thomas yeoman 589650 589650 Curson, Thomas, of Long Melford, yeoman 2
3598403 1867130 1867130 defendant Hall Thomas smith 589650 589650 Hall, Thomas, of Long Melford, smith 0
3603236 1868681 1868681 defendant Renet or Revet John smith 589650 589650 Renet or Revet, John, of Long Melford, smith 1
3633267 1905222 1905222 defendant Cowper Lawrence yeoman 589650 589650 Cowper, Lawrence, of Long Melford, yeoman 0
3634335 1905537 1905537 plaintiff Martyn Roger   589650 589650 Martyn, Roger, of Long Melford 0
3664689 1914908 1914908 plaintiff Clopton William gent 589650 589650 Clopton, William, of Long Melford, gent 1
3665148 1915052 1915052 plaintiff Smyth Thomas   589650 589650 Smyth, Thomas, of Long Melford, cloth man 0
3681613 1920343 1920343 plaintiff Smyth Thomas clothman 589650 589650 Smyth, Thomas, of Long Melford, clothman 0
3710048 1929452 1929452 defendant Dixe Robert clothmaker 589650 589650 Dixe, Robert, of Long Melford, clothmaker 3
3719188 1932286 1932286 defendant Barker Robert fuller 589650 589650 Barker, Robert, of Long Melford, fuller 0
3722684 1933360 1933360 plaintiff Mower Robert   589650 589650 Mower, Robert, of Long Melford 0
3725286 1934201 1934201 plaintiff Smyth Thomas clothman 589650 589650 Smyth, Thomas, of Long Melford, clothman 0
3728773 1935242 1935242 defendant Gawgeer Robert clothmaker 589650 589650 Gawgeer, Robert, of Long Melford, clothmaker 0
3734396 1936999 1936999 defendant Gawger Robert clothmaker 589650 589650 Gawger, Robert, of Long Melford, clothmaker 0
3738542 1938262 1938262 plaintiff Mower Robert   589650 589650 Mower, Robert, of Long Melford 0
3739969 1938720 1938720 defendant Gawger Robert clothmaker 589650 589650 Gawger, Robert, of Long Melford, clothmaker 0
3746285 1940748 1940748 defendant Kendall Thomas   589650 589650 Kendall, Thomas, of Long Melford, rough mason 0
3747275 1941070 1941070 plaintiff Dyke John clothmaker 589650 589650 Dyke, John, of Long Melford, clothmaker 0
3749860 1941869 1941869 defendant Assheford William husbandman 589650 589650 Assheford, William, of Long Melford, husbandman 1
3750727 1942151 1942151 plaintiff Martyn Roger gent 589650 589650 Martyn, Roger, of Long Melford, gent 0
3761061 1945462 1945462 defendant Howard John laborer 589650 589650 Howard, John, of Long Melford, laborer 0
3764383 1946521 1946521 defendant Stakeood Roger husbandman 589650 589650 Stakeood, Roger, of Long Melford, husbandman 1
3764386 1946522 1946522 plaintiff Howe Thomas tailor 589650 589650 Howe, Thomas, of Long Melford, tailor 0
3766528 1947190 1947190 plaintiff Martyn Roger esq 589650 589650 Martyn, Roger, of Long Melford, esq 0
3770553 1948474 1948474 plaintiff Smyth John (legal representative) 589650 589650 Smyth, John, of Long Melford, executors of 0
3779088 1951185 1951185 defendant Martyn Roger esq 589650 589650 Martyn, Roger, of Long Melford, esq 4
3796184 1956674 1956674 defendant Bukke Robert gent 589650 589650 Bukke, Robert, of Long Melford, gent 1
3796293 1956708 1956708 defendant Edward Thomas tailor 589650 589650 Edward, Thomas, of Long Melford, tailor 0
3797108 1956977 1956977 defendant Grene Elias clothmaker 589650 589650 Grene, Elias, of Long Melford, clothmaker 1
3812027 1961671 1961671 defendant Potter Roger husbandman 589650 589650 Potter, Roger, of Long Melford, husbandman 0
3812029 1961672 1961672 defendant Potter Roger husbandman 589650 589650 Potter, Roger, of Long Melford, husbandman 0
3814595 1962476 1962476 plaintiff Gawger John clothmaker 589650 589650 Gawger, John, of Long Melford, clothmaker 0
3816518 1963070 1963070 defendant Buk Robert gent 589650 589650 Buk, Robert, of Long Melford, gent 1
3822019 1964779 1964779 defendant Burton John husbandman 589650 589650 Burton, John, of Long Melford, husbandman 0
3833997 1968574 1968574 plaintiff Martyn Richard gent 589650 589650 Martyn, Richard, of Long Melford, gent 0
3838894 1970091 1970091 defendant Barker John (legal representative) 589650 589650 Barker, John, of Long Melford, yeoman, executor of 3
3838895 1970091 1970091 defendant Barker John yeoman 589650 589650 Barker, John, of Long Melford, yeoman 4
3843550 1971520 1971520 defendant Hokys alias Fermour John husbandman 589650 589650 Hokys alias Fermour, John, of Long Melford, husbandman 2
3843553 1971521 1971521 defendant Howky alias Fermour John husbandman 589650 589650 Howky alias Fermour, John, of Long Melford, husbandman 1
3844195 1971734 1971734 defendant Smyth Richard clothier 589650 589650 Smyth, Richard, of Long Melford, clothier 0
3844196 1971734 1971734 defendant Clerk Martin chaplain 589650 589650 Clerk, Martin, of Long Melford, chaplain 1
3844197 1971734 1971734 defendant Crowche William husbandman 589650 589650 Crowche, William, of Long Melford, husbandman 2
3844198 1971734 1971734 defendant Fuller John yeoman 589650 589650 Fuller, John, of Long Melford, yeoman 3
3855426 1975338 1975338 defendant Ellys Giles clothmaker 589650 589650 Ellys, Giles, of Long Melford, clothmaker 0
3855442 1975344 1975344 defendant Dyke John, senior yeoman 589650 589650 Dyke, John, senior, of Long Melford, yeoman 0
3864339 1978268 1978268 defendant Sawson Robert husbandman 589650 589650 Sawson, Robert, of Long Melford, husbandman 1
3878432 1983032 1983032 defendant Danson Robert chapman 589650 589650 Danson, Robert, of Long Melford, chapman 1
3883307 1984682 1984682 defendant Sergeant Hugh clothmaker 589650 589650 Sergeant, Hugh, of Long Melford, clothmaker 0
3883314 1984685 1984685 defendant Sergeant Hugh clothmaker 589650 589650 Sergeant, Hugh, of Long Melford, clothmaker 0
3892379 1987702 1987702 defendant Howe Richard husbandman 589650 589650 (Howe, Richard, of Long Melford, husbandman 1
3901287 1990656 1990656 defendant Colman Robert (legal representative) 589650 589650 Colman, Robert, of Long Melford, clothmaker, executor of 0
3902388 1991031 1991031 plaintiff Dyke William fishmonger 589650 589650 Dyke, William, of Long Melford, fishmonger 0
3944188 2005072 2005072 defendant Dasshe William innholder 589650 589650 Dasshe, William, of Long Melford, innholder 2
3958050 2009884 2009884 plaintiff Raven Roger grocer 589650 589650 Raven, Roger, of Long Melford, grocer 0
3961499 2011120 2011120 defendant Buckley William clothier 589650 589650 Buckley, William, of Long Melford, clothier 0
4033620 2036673 2036673 defendant Smyth Roger yeoman 589650 589650 Smyth, Roger, of Long Melford, yeoman 0
4033621 2036673 2036673 defendant Cricke Thomas smith 589650 589650 Cricke, Thomas, of Long Melford, smith 1
4074497 2051182 2051182 plaintiff Raven Roger mercer 589650 589650 Raven, Roger, of Long Melford, mercer 0
4199245 2095291 2095291 defendant Ford George husbandman 589650 589650 Ford, George, of Long Melford, husbandman 0
4233454 2107216 2107216 defendant Ellys Thomas clerk 589650 589650 Ellys, Thomas, of Long Melford, clerk 0
4242059 2110338 2110338 defendant Elles Thomas clerk 589650 589650 Elles, Thomas, of Long Melford, clerk 0
4242226 2110393 2110393 defendant Hatche Thomas clothier 589650 589650 Hatche, Thomas, of Long Melford, clothier 0
4244524 2111148 2111148 defendant Ellis Thomas Suff, clerk 589650 589650 Ellis Thomas, of Long Melford, Suff, clerk 1
4247817 2112255 2112255 defendant Goffe George laborer 589650 589650 Goffe, George, of Long Melford, laborer 0
4274582 2121053 2121053 defendant Everard Henry merchant 589650 589650 Everard, Henry, of Long Melford, merchant 0
4278266 2122336 2122336 defendant Cawston Thomas yeoman 589650 589650 Cawston, Thomas, of Long Melford, yeoman 0
4278267 2122336 2122336 defendant Sheppard Thomas singleman 589650 589650 Sheppard, Thomas, of Long Melford, singleman 1
4305236 2131969 2131969 defendant Crisall John yeoman 589650 589650 Crisall, John, of Long Melford, yeoman 0
4305672 2132121 2132121 defendant Kinge Roger yeoman 589650 589650 Kinge, Roger, of Long Melford, yeoman 2
4306752 2132500 2132500 defendant Wilbore Thomas clothier 589650 589650 Wilbore, Thomas, of Long Melford, clothier 0
4307584 2132790 2132790 defendant Ellys Thomas clerk 589650 589650 Ellys, Thomas, of Long Melford, clerk 2
4326508 2139228 2139228 defendant Bull John butcher 589650 589650 Bull, John, of Long Melford, butcher 0
4326509 2139228 2139228 defendant Bull William butcher 589650 589650 Bull, William, of Long Melford, butcher 1
4326778 2139309 2139309 defendant Allington Robert gent 589650 589650 Allington, Robert, of Long Melford, gent 0
4332492 2141155 2141155 defendant Crysall Peter clothier 589650 589650 Crysall, Peter, of Long Melford, clothier 1
4333345 2141434 2141434 defendant Bull John butcher 589650 589650 Bull, John, of Long Melford, butcher 0
4335236 2142058 2142058 defendant Crysall Peter clothier 589650 589650 Crysall, Peter, of Long Melford, clothier 1
4344199 2145250 2145250 defendant Grocer John   589650 589650 Grocer, John, of Long Melford, tallow chandler 0
4344200 2145250 2145250 defendant Hatche Thomas yeoman 589650 589650 Hatche, Thomas, of Long Melford, yeoman 1
4386043 2160018 2160018 defendant Wilbore William clothier 589650 589650 Wilbore, William, of Long Melford, clothier 1
4386044 2160018 2160018 defendant Shepperde Thomas husbandman 589650 589650 Shepperde, Thomas, of Long Melford, husbandman 2
4387812 2160560 2160560 defendant Allyn John yeoman 589650 589650 Allyn, John, of Long Melford, yeoman 0
4454775 2186503 2186503 defendant Lytel John   589650 589650 Lytel, John, of Long Melford 0
4499608 2200519 2200519 defendant fullere Richard   589650 589650 fullere, Richard, of Long Melford 1
4550780 2216182 2216182 defendant Style John   589650 589650 Style, John, of Long Melford 0
4747400 2279742 2279742 defendant Barker Gilbert tanner 589650 589650 Barker, Gilbert, of Long Melford, tanner 2
4855690 2313151 2313151 defendant atte Staple Thomas husbandman 589650 589650 atte Staple, Thomas, of Long Melford, husbandman 0
4865194 2316090 2316090 defendant Fouler Edmund laborer 589650 589650 Fouler, Edmund, of Long Melford, laborer 0
4865196 2316090 2316090 defendant Fouler Alexander laborer 589650 589650 Fouler, Alexander, of Long Melford, laborer 2
4865197 2316090 2316090 defendant Fouler Nicholas laborer 589650 589650 Fouler, Nicholas, of Long Melford, laborer 3
4910863 2329908 2329908 defendant Moryell Roger husbandman 589650 589650 Moryell, Roger, of Long Melford, husbandman 0
4910864 2329908 2329908 defendant atte Hoo William husbandman 589650 589650 atte Hoo, William, of Long Melford, husbandman 1
4910865 2329908 2329908 defendant Brewe Simon husbandman 589650 589650 Brewe, Simon, of Long Melford, husbandman 2
5045813 2370383 2370383 defendant Pylcreyk Walter husbandman 589650 589650 Pylcreyk, Walter, of Long Melford, husbandman 0
5045814 2370383 2370383 defendant Hoo Thomas husbandman 589650 589650 Hoo, Thomas, of Long Melford, husbandman 1
5056199 2373429 2373429 defendant Bolton John clothmaker 589650 589650 Bolton, John, of Long Melford, clothmaker 0
5056201 2373430 2373430 defendant Dunkle on Dunkisle William husbandman 589650 589650 Dunkle on Dunkisle, William, of Long Melford, husbandman 0
5056202 2373430 2373430 defendant Barker Rober fuller 589650 589650 Barker, Rober, of Long Melford, fuller 1
5085010 2382028 2382028 defendant Martyn Lawrence yeoman 589650 589650 Martyn, Lawrence, of Long Melford, 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);