names

183 rows where place_id = 591076

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603263 1868692 1868692 defendant Breton John butcher 591076 591076 Breton, John, of Est Bergholt, butcher 3
3605013 1869231 1869231 defendant Hall Richard husbandman 591076 591076 Hall, Richard, of Est Bergholt, husbandman 0
3617386 1873056 1873056 defendant Ryngalde Thomas clothmaker 591076 591076 Ryngalde, Thomas, of Est Bergholt, clothmaker 0
3617387 1873056 1873056 defendant Peverelle John, senior clothmaker 591076 591076 Peverelle, John, senior, of Est Bergholt, clothmaker 1
3617388 1873056 1873056 defendant Peverelle Robert fuller 591076 591076 Peverelle, Robert, of Est Bergholt, fuller 2
3626445 1903126 1903126 defendant Dey Robert clothmaker 591076 591076 Dey, Robert, of Est Bergholt, clothmaker 0
3626446 1903126 1903126 defendant Cole Robert clothmaker 591076 591076 Cole, Robert, of Est Bergholt, clothmaker 1
3651946 1910954 1910954 defendant Markys Robert clothmaker 591076 591076 Markys, Robert, of Est Bergholt, clothmaker 0
3651947 1910954 1910954 defendant Cosyn William clothmaker 591076 591076 Cosyn, William, of Est Bergholt, clothmaker 1
3665089 1915029 1915029 defendant Breton John   591076 591076 Breton, John, of East Bergholt, cloth maker 2
3665090 1915029 1915029 defendant Wodward John sheer man 591076 591076 Wodward, John, of East Bergholt, sheer man 3
3788571 1954223 1954223 defendant Branston John clothmaker 591076 591076 Branston, John, of Est Bergholt, clothmaker 0
3821117 1964499 1964499 defendant Raynold George   591076 591076 Raynold, George, of Est Bergholt, Suff clerk 0
3885252 1985321 1985321 defendant Downes William mercer 591076 591076 Downes, William, of Est Bergholt, mercer 1
3886136 1985614 1985614 defendant Syday Richard tanner 591076 591076 Syday, Richard, of Est Bergholt, tanner 0
3899956 1990204 1990204 defendant Syday Richard tanner 591076 591076 Syday, Richard, of Est Bergholt, tanner 0
3901252 1990644 1990644 defendant Syday Richard tanner 591076 591076 Syday, Richard, of Est Bergholt, tanner 0
3954292 2008576 2008576 defendant Clarke James butcher 591076 591076 Clarke, James, of Est Bergholt, laborer Labborn aloas Labie, Thomas, of Est Bergholt, butcher 1
3957700 2009752 2009752 plaintiff Profett Richard   591076 591076 Profett, Richard, of Est Bergholt 0
3976931 2016493 2016493 defendant Barwicke John clothier 591076 591076 Barwicke, John, of Est Bergholt, clothier 16
3989595 2021025 2021025 defendant Coke Robert butcher 591076 591076 Coke, Robert, of Est Bergholt, butcher 0
4029127 2035060 2035060 defendant Woofward Thomas sherman 591076 591076 Woofward, Thomas, of Est Bergholt, sherman 0
4045675 2040905 2040905 defendant Mark William clothier 591076 591076 Mark, William, of Est Bergholt, clothier 3
4052265 2043234 2043234 plaintiff Wylys Robert clothier 591076 591076 Wylys, Robert, of Est Bergholt, clothier 0
4081985 2053857 2053857 defendant Hedge Augustine clothier 591076 591076 Hedge, Augustine, of Est Bergholt, clothier 0
4094830 2058483 2058483 defendant Lincoln Stephen clothier 591076 591076 Lincoln, Stephen, of Est Bergholt, clothier 0
4094831 2058483 2058483 defendant Hedge Richard clothier 591076 591076 Hedge, Richard, of Est Bergholt, clothier 1
4121015 2067805 2067805 defendant Markes Edward clothier 591076 591076 Markes, Edward, of Est Bergholt, clothier 0
4121016 2067805 2067805 defendant Anger William yeoman 591076 591076 Anger, William, of Est Bergholt, yeoman 1
4127659 2070184 2070184 defendant Manser Anthony clothier 591076 591076 Manser, Anthony, of Est Bergholt, clothier 0
4127660 2070184 2070184 defendant Denham Thomas clothier 591076 591076 Denham, Thomas, of Est Bergholt, clothier 1
4127661 2070184 2070184 defendant Lewes Elias clothier 591076 591076 Lewes, Elias, of Est Bergholt, clothier 2
4127662 2070184 2070184 defendant Dawson Robert clothier 591076 591076 Dawson, Robert, of Est Bergholt, clothier 3
4133840 2072440 2072440 defendant Reynold John yeoman 591076 591076 Reynold, John, of Est Bergholt, yeoman 0
4137832 2073889 2073889 defendant Reynould William clothier 591076 591076 Reynould, William, of Est Bergholt, clothier 1
4137833 2073889 2073889 defendant Reynould John clothier 591076 591076 Reynould, John, of Est Bergholt, clothier 2
4139068 2074342 2074342 defendant Fryer John tailor 591076 591076 Fryer, John, of Est Bergholt, tailor 0
4144452 2076222 2076222 defendant Manser Anthony clothier 591076 591076 Manser, Anthony, of Est Bergholt, clothier 0
4146470 2076917 2076917 defendant Fryer John tailor 591076 591076 Fryer, John, of Est Bergholt, tailor 0
4159727 2081470 2081470 defendant Markes William gent 591076 591076 Markes, William, of Est Bergholt, gent 1
4203072 2096623 2096623 defendant Debnam John weaver 591076 591076 Debnam, John, of Est Bergholt, weaver 0
4203073 2096623 2096623 defendant Nelson Robert carrier 591076 591076 Nelson, Robert, of Est Bergholt, carrier 1
4203074 2096623 2096623 defendant Martyn John husbandman 591076 591076 Martyn, John, of Est Bergholt, husbandman 2
4210847 2099352 2099352 defendant Nelson Robert carrier 591076 591076 Nelson, Robert, of Est Bergholt, carrier 0
4210848 2099352 2099352 defendant Beckwyth Thomas shoemaker 591076 591076 Beckwyth, Thomas, of Est Bergholt, shoemaker 1
4233841 2107362 2107362 defendant Osmonde Robert clothier 591076 591076 Osmonde, Robert, of Est Bergholt, clothier 3
4233927 2107397 2107397 defendant Dowe Michael clothier 591076 591076 Dowe, Michael, of Est Bergholt, clothier 1
4233933 2107397 2107397 defendant Rayner Robert husbandman 591076 591076 Rayner, Robert, of Est Bergholt, husbandman 7
4236540 2108353 2108353 defendant Markes William tanner 591076 591076 Markes, William, of Est Bergholt, tanner 1
4241657 2110196 2110196 defendant Pod Adam   591076 591076 Pod, Adam, of Est Bergholt yeoman 0
4241658 2110196 2110196 defendant Poyken Edward yeoman 591076 591076 Poyken, Edward, of Est Bergholt, yeoman 1
4241965 2110303 2110303 defendant Lyncolne Stephen sherman 591076 591076 Lyncolne, Stephen, of East Bergholt, sherman 2
4245219 2111385 2111385 defendant Garnett Henry clothier 591076 591076 Garnett, Henry, of Est Bergholt, clothier 1
4245220 2111385 2111385 defendant Garnett Robert clothier 591076 591076 Garnett, Robert, of Est Bergholt, clothier 2
4303153 2131228 2131228 defendant Spenser Edmund husbandman 591076 591076 Spenser, Edmund, of East Bergholt, husbandman 9
4305828 2132175 2132175 defendant Branston John clothier 591076 591076 Branston, John, of Est Bergholt, clothier 3
4314420 2135156 2135156 defendant Manser Anthony clothier 591076 591076 Manser, Anthony, of Est Bergholt, clothier 0
4333326 2141429 2141429 defendant Good John butcher 591076 591076 Good, John, of Est Bergholt, butcher 0
4339743 2143673 2143673 defendant Tezard William clothier 591076 591076 Tezard, William, of Est Bergholt, clothier 3
4347531 2146382 2146382 defendant Bretten Nicholas sherman 591076 591076 Bretten, Nicholas, of Est Bergholt, sherman 1
4352837 2148221 2148221 defendant Pascall William tailor 591076 591076 Pascall, William, of East Bergholt, tailor 0
4354957 2148950 2148950 defendant Goffe Robert yeoman 591076 591076 Goffe, Robert, of Est Bergholt, yeoman 0
4355777 2149242 2149242 defendant Mosse John clothier 591076 591076 Mosse, John, of East Bergholt, clothier 1
4355782 2149243 2149243 defendant Clerke Edward clothier 591076 591076 Clerke, Edward, of East Bergholt, clothier 1
4355783 2149243 2149243 defendant Garnett Robert weaver 591076 591076 Garnett, Robert, of East Bergholt, weaver 2
4355784 2149243 2149243 defendant Norden John yeoman 591076 591076 Norden, John, of East Bergholt, yeoman 3
4371761 2154960 2154960 defendant Culpacke Joshua   591076 591076 Culpacke, Joshua, of Est Bergholt, Suff, clothier, coverlet maker 0
4371762 2154960 2154960 defendant Manser Anthony clothier 591076 591076 Manser, Anthony, of Est Bergholt, clothier 1
4385879 2159970 2159970 defendant Huberd George clothier 591076 591076 Huberd, George, of Est Bergholt, clothier 1
4385880 2159970 2159970 defendant Aldham Christopher clothier 591076 591076 Aldham, Christopher, of Est Bergholt, clothier 2
4385881 2159970 2159970 defendant Manser Elias clothier 591076 591076 Manser, Elias, of Est Bergholt, clothier 3
4408947 2167595 2167595 defendant Goffe John yeoman 591076 591076 Goffe, John, of Est Bergholt, yeoman 0
4452184 2185666 2185666 defendant Bysshop John   591076 591076 Bysshop, John, of East Bergholt 1
4541274 2213167 2213167 defendant Corton John   591076 591076 Corton, John, of East Bergholt 0
4541276 2213168 2213168 defendant Corton John   591076 591076 Corton, John, of East Bergholt 0
4568638 2221770 2221770 defendant Sherwynd John   591076 591076 Sherwynd, John, of East Bergholt 0
4596644 2230187 2230187 defendant Cukhoke Adam   591076 591076 Cukhoke, Adam, of East Bergholt 1
4625815 2239025 2239025 defendant Walden John   591076 591076 Walden, John, of East Bergholt 4
4645848 2244853 2244853 defendant Quarham Andrew   591076 591076 Quarham, Andrew, of East Bergholt 0
4648215 2245542 2245542 defendant Quarram Richard   591076 591076 Quarram, Richard, of East Bergholt 4
4679991 2259344 2259344 defendant Leme Stephen tailor 591076 591076 Leme, Stephen, of East Bergholt, tailor 1
4709288 2268275 2268275 defendant Quarrem Isabel widow 591076 591076 Quarrem, Isabel, of East Bergholt, widow 0
4709289 2268275 2268275 defendant Prat Rose spinster 591076 591076 Prat, Rose, of East Bergholt, spinster 1
4768439 2286102 2286102 defendant Florete John yeoman 591076 591076 Florete, John, of East Bergholt, yeoman 0
4795763 2294826 2294826 defendant Brooke William yeoman 591076 591076 Brooke, William, of Est Bergholt, yeoman 0
4799786 2296119 2296119 plaintiff Tynte Simon   591076 591076 Tynte, Simon, of Est Bergholt 0
4799788 2296119 2296119 defendant Wodehove John husbandman 591076 591076 Wodehove, John, of Est Bergholt, husbandman 1
4799791 2296119 2296119 defendant Pykerell Robert ploughman 591076 591076 (Pykerell, Robert, of Est Bergholt, ploughman 4
4799792 2296119 2296119 defendant Wodehoushervy John ploughman 591076 591076 Wodehoushervy, John, of Est Bergholt, ploughman 5
4802996 2297125 2297125 defendant Leme Stephen yeoman 591076 591076 Leme, Stephen, of East Bergholt, yeoman 0
4802998 2297125 2297125 defendant Sherwynd William yeoman 591076 591076 Sherwynd, William, of East Bergholt, yeoman 2
4812626 2300066 2300066 defendant White William glover 591076 591076 White, William, of East Bergholt, glover 0
4819931 2302311 2302311 defendant Graverner Thomas husbandman 591076 591076 Graverner, Thomas, of East Bergholt, husbandman 0
4819932 2302311 2302311 defendant Turnour John husbandman 591076 591076 Turnour, John, of East Bergholt, husbandman 1
4819933 2302311 2302311 defendant Leme Stephen husbandman 591076 591076 Leme, Stephen, of East Bergholt, husbandman 2
4819934 2302311 2302311 defendant Andrewre Joan widow 591076 591076 Andrewre, Joan, of East Bergholt, widow 3
4851639 2311947 2311947 defendant Onarham Andrew husbandman 591076 591076 Onarham, Andrew, of East Bergholt, husbandman 0
4855987 2313245 2313245 defendant Rigelache Thomas butcher 591076 591076 Rigelache, Thomas, of Est Bergholt, butcher 0
4862758 2315339 2315339 defendant Jakes Robert husbandman 591076 591076 Jakes, Robert, of Est Bergholt, husbandman 0
4862759 2315339 2315339 defendant Coke William husbandman 591076 591076 Coke, William, of Est Bergholt, husbandman 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);