names

107 rows where place_id = 588149

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3593519 1865606 1865606 defendant Rooge Walter clothman 588149 588149 Rooge, Walter, of Clare, Suff, clothman 1
3599171 1867377 1867377 defendant Stokes Thomas clerk 588149 588149 Stokes, Thomas, of Clare, Suff, clerk 1
3601774 1868212 1868212 defendant Hadley John clothman 588149 588149 Hadley, John, of Clare, Suff, clothman 0
3613436 1871850 1871850 defendant Rowege Walter clothman 588149 588149 Rowege, Walter, of Clare, Suff, clothman 0
3627803 1903555 1903555 defendant Danyell Hugh gent 588149 588149 Danyell, Hugh, of Clare, Suff, gent 0
3654084 1911540 1911540 defendant Decks John chapman 588149 588149 Decks, John, of Clare, suff, chapman 0
3683039 1920808 1920808 defendant Barker John yeoman 588149 588149 Barker, John, of Clare, Suff, yeoman 0
3683041 1920809 1920809 defendant Barker John yeoman 588149 588149 Barker, John, of Clare, Suff, yeoman 0
3685601 1921649 1921649 defendant Skynner William fuller 588149 588149 Skynner, William, of Clare, Suff, fuller 0
3714551 1930849 1930849 defendant Danyell Hugh yeoman 588149 588149 Danyell, Hugh, of Clare, Suff, yeoman 0
3714555 1930851 1930851 defendant Danyell Hugh yeoman 588149 588149 Danyell, Hugh, of Clare, Suff, yeoman 0
3829549 1967132 1967132 defendant Gylbert William clothmaker 588149 588149 Gylbert, William, of Clare, Suff, clothmaker 0
3844468 1971816 1971816 defendant Kytteryche William smith 588149 588149 Kytteryche, William, of Clare, Suff, smith 1
3875945 1982208 1982208 defendant Danyell George gent 588149 588149 Danyell, George, of Clare, Suff, gent 0
3881984 1984234 1984234 defendant Gylberd William clothier 588149 588149 Gylberd, William, of Clare, Suff, clothier 0
3974273 2015569 2015569 defendant Frear John gent 588149 588149 Frear, John, of Clare, Suff, gent 0
3975603 2016031 2016031 defendant Chapman Thomas clerk 588149 588149 Chapman, Thomas, of Clare, Suff, clerk 0
3976728 2016426 2016426 defendant Fryer William gent 588149 588149 Fryer, William, of Clare, Suff, gent 0
3981301 2018079 2018079 defendant Norffolke John yeoman 588149 588149 Norffolke, John, of Clare, Suff, yeoman 0
3986629 2019957 2019957 defendant Fryer William gent 588149 588149 Fryer, William, of Clare, Suff, gent 1
4025765 2033869 2033869 defendant Fryer William gent 588149 588149 Fryer, William, of Clare, Suff, gent 1
4047880 2041686 2041686 defendant Crysall John chapman 588149 588149 Crysall, John, of Clare, Suff, chapman 1
4062500 2046878 2046878 defendant Beale Thomas mercer 588149 588149 Beale, Thomas, of Clare, Suff, mercer 0
4072636 2050518 2050518 defendant Fryer William gent 588149 588149 Fryer, William, of Clare, Suff, gent 0
4136106 2073255 2073255 defendant Malbon Miles cooper 588149 588149 Malbon, Miles, of Clare, Suff, cooper 3
4156063 2080195 2080195 defendant Freere John gent 588149 588149 Freere, John, of Clare, Suff, gent 0
4194159 2093509 2093509 defendant Johnson Thomas chapman 588149 588149 Johnson, Thomas, of Clare, Suff, chapman 0
4239852 2109574 2109574 defendant Frend Elizabeth (legal representative) 588149 588149 Frend, Elizabeth, of Clare, Suff, widow, executor of 0
4243729 2110888 2110888 defendant Harryson or Harris Thomas yeoman 588149 588149 Harryson or Harris, Thomas, of Clare, Suff, yeoman 0
4267341 2118713 2118713 defendant Harrys Thomas miller 588149 588149 Harrys, Thomas, of Clare, Suff, miller 0
4268744 2119140 2119140 defendant Gouldynge Thomas yeoman 588149 588149 Gouldynge, Thomas, of Clare, Suff, yeoman 0
4268749 2119141 2119141 defendant Gouldynge Thomas yeoman 588149 588149 Gouldynge, Thomas, of Clare, Suff, yeoman 0
4277340 2121999 2121999 defendant Goldinge Thomas yeoman 588149 588149 Goldinge, Thomas, of Clare, Suff, yeoman 0
4280665 2123141 2123141 defendant Lenard Edward   588149 588149 Lenard, Edward, of Clare, Suff, mason 0
4287270 2125504 2125504 defendant Gosse Henry clothier 588149 588149 Gosse, Henry, of Clare, Suff, clothier 0
4290577 2126687 2126687 defendant Pottall John butcher 588149 588149 Pottall, John, of Clare, Suff, butcher 2
4293734 2127827 2127827 defendant Frende Richard (legal representative) 588149 588149 Frende, Richard, of Clare, Suff, gent, executor of 0
4295380 2128434 2128434 defendant Gosse Henry clothier 588149 588149 Gosse, Henry, of Clare, Suff, clothier 0
4311586 2134193 2134193 defendant Frende Richard (legal representative) 588149 588149 Frende, Richard, of Clare, Suff, gent, executor of 0
4336191 2142390 2142390 defendant Lancaster Henry joiner 588149 588149 Lancaster, Henry, of Clare, Suff, joiner 0
4338699 2143289 2143289 defendant Evens Thomas chapman 588149 588149 Evens, Thomas, of Clare, Suff, chapman 0
4341849 2144424 2144424 defendant Golding George yeoman 588149 588149 Golding, George, of Clare, Suff, yeoman 0
4341851 2144425 2144425 defendant Golding Thomas yeoman 588149 588149 Golding, Thomas, of Clare, Suff, yeoman 0
4350741 2147512 2147512 defendant Johnson Thomas mercer 588149 588149 Johnson, Thomas, of Clare, Suff, mercer 0
4351935 2147913 2147913 defendant Sexten John glover 588149 588149 Sexten, John, of Clare, Suff, glover 3
4362055 2151474 2151474 defendant Evens Thomas chapman 588149 588149 Evens, Thomas, of Clare, Suff, chapman 0
4365450 2152710 2152710 defendant Lennard Edward yeoman 588149 588149 Lennard, Edward, of Clare, Suff, yeoman 0
4408257 2167331 2167331 defendant Lennard Margaret widow 588149 588149 Margaret his wife, alias Margaret Beale, of Clare, Suff, widow 1
4411217 2168337 2168337 defendant Hardye John sherman 588149 588149 Hardye, John, of Clare, Suff, sherman 3
4651354 2246424 2246424 defendant Skynnere John   588149 588149 Skynnere, John, of Clare, Suff 1
4661439 2249406 2249406 defendant Fullere John merchant 588149 588149 Fullere, John, of Clare, Suff, merchant 0
4690556 2262600 2262600 defendant Keynyngton William chapman 588149 588149 Keynyngton, William, of Clare, Suff, chapman 0
4705000 2266938 2266938 defendant Warderobe William tanner 588149 588149 Warderobe, William, of Clare, Suff, tanner 0
4803204 2297193 2297193 defendant Clement John husbandman 588149 588149 Clement, John, of Clare, Suff, husbandman 0
4814334 2300590 2300590 defendant Berymell John dyer 588149 588149 Berymell, John, of Clare, Suff, dyer 0
4821107 2302680 2302680 defendant Forde John yeoman 588149 588149 Forde, John, of Clare, Suff, yeoman 2
4821116 2302682 2302682 defendant Forde John yeoman 588149 588149 Forde, John, of Clare, Suff, yeoman 2
4824558 2303731 2303731 defendant Barker William husbandman 588149 588149 Barker, William, of Clare, Suff, husbandman 0
4824562 2303733 2303733 defendant Milde Thomas esq 588149 588149 Milde, Thomas, of Clare, Suff, esq 0
4824572 2303736 2303736 defendant Mylde Thomas esq 588149 588149 Mylde, Thomas, of Clare, Suff, esq 0
4825026 2303867 2303867 defendant Rilfes or Ralfes Thomas gent 588149 588149 Rilfes or Ralfes, Thomas, of Clare, Suff, gent 0
4829335 2305214 2305214 defendant Clement John husbandman 588149 588149 Clement, John, of Clare, Suff, husbandman 1
4857754 2313801 2313801 defendant Hogge James yeoman 588149 588149 Hogge, James, of Clare, Suff, yeoman 0
4859396 2314318 2314318 defendant Smythe William chapman 588149 588149 Smythe, William, of Clare, Suff, chapman 0
4883435 2321742 2321742 defendant Wykis Peter merchant 588149 588149 Wykis, Peter, of Clare, Suff, merchant 2
4888134 2323094 2323094 defendant Berymyll John, senior dyer 588149 588149 Berymyll, John, senior, of Clare, Suff, dyer 0
4889227 2323416 2323416 defendant Wykys Peter merchant 588149 588149 Wykys, Peter, of Clare, Suff, merchant 2
4908555 2329232 2329232 defendant Horrold John weaver & mercer 588149 588149 Horrold, John, of Clare, Suff, weaver & mercer 3
4908571 2329236 2329236 defendant Horold John weaver 588149 588149 Horold, John, of Clare, Suff, weaver 3
4909881 2329613 2329613 defendant Hennysman John shoemaker 588149 588149 Hennysman, John, of Clare, Suff, shoemaker 4
4912441 2330396 2330396 defendant Forthe John gent 588149 588149 Forthe, John, of Clare, Suff, gent 1
4928018 2335197 2335197 defendant Berymyll John   588149 588149 Berymyll, John, of Clare, Suff, dyer St George, William, of Hungry Hatle, Cambs, knight 0
4928654 2335390 2335390 defendant Forde John yeoman 588149 588149 Forde, John, of Clare, Suff, yeoman 2
4928660 2335391 2335391 defendant Forde John yeoman 588149 588149 Forde, John, of Clare, Suff, yeoman 2
4930455 2335926 2335926 defendant Bernard Thomas gent 588149 588149 Bernard, Thomas, of Clare, Suff, gent 1
4936293 2337751 2337751 defendant Barker Richard yeoman 588149 588149 Barker, Richard, of Clare, Suff, yeoman 2
4936333 2337759 2337759 defendant Barker Richard yeoman 588149 588149 Barker, Richard, of Clare, Suff, yeoman 2
4950207 2342030 2342030 defendant Hogge John yeoman 588149 588149 Hogge, John, of Clare, Suff, yeoman 0
4950221 2342033 2342033 defendant Horold John yeoman 588149 588149 Horold, John, of Clare, Suff, yeoman 3
4954223 2343235 2343235 defendant Tryklove or Tryklone Robert woolman 588149 588149 Tryklove or Tryklone, Robert, of Clare, Suff, woolman 2
4980563 2351127 2351127 defendant Tryklove Robert husbandman 588149 588149 Tryklove, Robert, of Clare, Suff, husbandman 2
4981080 2351272 2351272 defendant Beremyll Thomas dyer 588149 588149 Beremyll, Thomas, of Clare, Suff, dyer 3
5017485 2362000 2362000 defendant Horold John weaver 588149 588149 Horold, John, of Clare, Suff, weaver 0
5017489 2362001 2362001 defendant Horold John weaver 588149 588149 Horold, John, of Clare, Suff, weaver 0
5082471 2381257 2381257 defendant Hog William baker 588149 588149 Hog, William, of Clare, Suff, baker 0
5082474 2381258 2381258 defendant Hog William barker 588149 588149 Hog, William, of Clare, Suff, barker 0
5082477 2381259 2381259 defendant Hog William barker 588149 588149 Hog, William, of Clare, Suff, barker 0
5095947 2385245 2385245 defendant Borymelle John wooder 588149 588149 Borymelle, John, of Clare, Suff, wooder 0
5148976 2400828 2400828 defendant Mild Thomas esq 588149 588149 together with Mild, Thomas, of Clare, Suff, esq 2
5152548 2401884 2401884 defendant Melton John   588149 588149 Melton, John, of Clare, Suff, knight 0
5152549 2401884 2401884 defendant fys William Edmund esq 588149 588149 fys William, Edmund, of Clare, Suff, esq 1
5170277 2407037 2407037 defendant Melton John   588149 588149 Melton, John, of Clare, Suff, knight 0
5257162 2432375 2432375 defendant Barker Henry clothmaker 588149 588149 Barker, Henry, of Clare, Suff, clothmaker 2
5257166 2432376 2432376 defendant Barker Henry clothmaker 588149 588149 Barker, Henry, of Clare, Suff, clothmaker 2
5257170 2432378 2432378 defendant Cokeshale William yeoman 588149 588149 Cokeshale, William, of Clare, Suff, yeoman 0
5278249 2438736 2438736 defendant Clerk Richard husbandman 588149 588149 Clerk, Richard, of Clare, Suff, husbandman 1
5291148 2442417 2442417 defendant Hilles William fuller 588149 588149 Hilles, William, of Clare, Suff, fuller 1
5291152 2442418 2442418 defendant Hilles William fuller 588149 588149 Hilles, William, of Clare, Suff, fuller 1
5295229 2443597 2443597 defendant Holden William, senior smith 588149 588149 Holden, William, senior, of Clare, Suff, smith 1
5307888 2447375 2447375 defendant Coksale William yeoman 588149 588149 Coksale, William, of Clare, Suff, yeoman 2

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);