names

144 rows where place_id = 592390

✎ 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
3607562 1870023 1870023 defendant Revet Stephen husbandman 592390 592390 Revet, Stephen, of Dysse, Norf, husbandman 0
3619079 1873569 1873569 defendant Dobbys Thomas husbandman 592390 592390 Dobbys, Thomas, of Dysse, Norf, husbandman 2
3633280 1905227 1905227 defendant Colet Thomas chapman 592390 592390 Colet, Thomas, of Dysse, Norf, chapman 1
3634755 1905667 1905667 defendant Couper Stephen mercer 592390 592390 Couper, Stephen, of Dysse, Norf, mercer 0
3634757 1905668 1905668 defendant Colett Thomas mercer 592390 592390 Colett, Thomas, of Dysse, Norf, mercer 0
3636414 1906178 1906178 defendant Colett Thomas mercer 592390 592390 Colett, Thomas, of Dysse, Norf, mercer 1
3654044 1911528 1911528 defendant Skelton John clerk 592390 592390 Skelton, John, of Dysse, Norf, clerk 0
3654047 1911529 1911529 defendant Skelton John clerk 592390 592390 Skelton, John, of Dysse, Norf, clerk 0
3657960 1912741 1912741 defendant Froxmer Katherine widow 592390 592390 Froxmer, Katherine, of Dysse, Norf, widow 0
3659435 1913211 1913211 defendant Grene John dyer 592390 592390 Grene, John, of Dysse, Norf, dyer 1
3674463 1918061 1918061 defendant Persy George gent 592390 592390 Persy, George, of Dysse, Norf, gent 2
3687517 1922276 1922276 defendant Mably Robert draper 592390 592390 Mably, Robert, of Dysse, Norf, draper 0
3695986 1924984 1924984 defendant Wheler John miller 592390 592390 Wheler, John, of Dysse, Norf, miller 1
3708501 1928956 1928956 defendant Cowper Stephen mercer 592390 592390 Cowper, Stephen, of Dysse, Norf, mercer 3
3709646 1929326 1929326 defendant Coke Thomas mercer 592390 592390 Coke, Thomas, of Dysse, Norf, mercer 0
3721026 1932872 1932872 defendant Chapman Thomas courser 592390 592390 Chapman, Thomas, of Dysse, Norf, courser 2
3820182 1964192 1964192 defendant Chapman Thomas husbandman 592390 592390 Chapman, Thomas, of Dysse, Norf, husbandman 1
3840333 1970543 1970543 defendant Sharpe Edward chapman 592390 592390 Sharpe, Edward, of Dysse, Norf, chapman 3
3855190 1975256 1975256 defendant Ersham Robert mercer 592390 592390 Ersham, Robert, of Dysse, Norf, mercer 2
3855363 1975318 1975318 defendant Chapman John courser 592390 592390 Chapman, John, of Dysse, Norf, courser 2
3859619 1976710 1976710 defendant Bokyngham Thomas husbandman 592390 592390 Bokyngham, Thomas, of Dysse, Norf, husbandman 0
3869339 1979988 1979988 defendant Assy William husbandman 592390 592390 Assy, William, of Dysse, Norf, husbandman 0
3873961 1981514 1981514 defendant Cowper Francis gent 592390 592390 Cowper, Francis, of Dysse, Norf, gent 0
3876503 1982389 1982389 defendant Davy William husbandman 592390 592390 Davy, William, of Dysse, Norf, husbandman 0
3881285 1984009 1984009 defendant Cowper Francis chapman 592390 592390 Cowper, Francis, of Dysse, Norf, chapman 0
3894256 1988297 1988297 defendant Folser John tanner 592390 592390 Folser, John, of Dysse, Norf, tanner 1
3914833 1995307 1995307 defendant Harwyn John yeoman 592390 592390 Harwyn, John, of Dysse, Norf, yeoman 0
3914850 1995314 1995314 defendant Harwyn John yeoman 592390 592390 Harwyn, John, of Dysse, Norf, yeoman 0
3944599 2005208 2005208 defendant Folser John, junior tanner 592390 592390 Folser, John, junior, of Dysse, Norf, tanner 0
3952908 2008088 2008088 defendant Harowld John innholder 592390 592390 Harowld, John, of Dysse, Norf, innholder 1
3956742 2009425 2009425 defendant Reade Marmaduke saddler 592390 592390 Reade, Marmaduke, of Dysse, Norf, saddler 0
3961016 2010948 2010948 defendant Blomfyld William mercer 592390 592390 Blomfyld, William, of Dysse, Norf, mercer 0
3963393 2011800 2011800 defendant Hersham Robert armorer 592390 592390 Hersham, Robert, of Dysse, Norf, armorer 1
3965160 2012424 2012424 defendant Fulcher Thomas innkeeper 592390 592390 Fulcher, Thomas, of Dysse, Norf, innkeeper 0
3969168 2013825 2013825 defendant Hunt Lawrence butcher 592390 592390 Hunt, Lawrence, of Dysse, Norf, butcher 0
3969171 2013826 2013826 defendant Browen or Broun Thomas yeoman 592390 592390 Browen or Broun, Thomas, of Dysse, Norf, yeoman 0
3984427 2019187 2019187 defendant Cowper William bowyer 592390 592390 Cowper, William, of Dysse, Norf, bowyer 1
3984431 2019188 2019188 defendant Cowper William bowyer 592390 592390 Cowper, William, of Dysse, Norf, bowyer 1
3995039 2022972 2022972 defendant Elsmore William   592390 592390 Elsmore, William, of Dysse, Norf, woollen draper 0
4010220 2028422 2028422 plaintiff Owles John draper 592390 592390 Owles, John, of Dysse, Norf, draper 0
4014583 2029937 2029937 defendant Ellesmore William tailor 592390 592390 Ellesmore, William, of Dysse, Norf, tailor 0
4015603 2030278 2030278 defendant Berkweye Robert blacksmith 592390 592390 Berkweye, Robert, of Dysse, Norf, blacksmith 0
4046167 2041070 2041070 defendant Broun George butcher 592390 592390 Broun, George, of Dysse, Norf, butcher 0
4046169 2041070 2041070 defendant Goddard John husbandman 592390 592390 Goddard, John, of Dysse, Norf, husbandman 2
4072932 2050617 2050617 defendant Buckenham William yeoman 592390 592390 Buckenham, William, of Dysse, Norf, yeoman 1
4078977 2052780 2052780 defendant Fuller alias Garbesham Andrew butcher 592390 592390 Fuller alias Garbesham, Andrew, of Dysse, Norf, butcher 1
4093960 2058165 2058165 defendant Hendry or Henry Robert butcher 592390 592390 Hendry or Henry, Robert, of Dysse, Norf, butcher 0
4093962 2058166 2058166 defendant Hendry Robert butcher 592390 592390 Hendry, Robert, of Dysse, Norf, butcher 0
4100994 2060671 2060671 defendant Estowe John draper 592390 592390 Estowe, John, of Dysse, Norf, draper 0
4125441 2069380 2069380 defendant Estaughe or Escaughe John yeoman 592390 592390 Estaughe or Escaughe, John, of Dysse, Norf, yeoman 0
4136160 2073277 2073277 defendant Davye William scrivener 592390 592390 Davye, William, of Dysse, Norf, scrivener 0
4140633 2074889 2074889 defendant Davye William chapman 592390 592390 Davye, William, of Dysse, Norf, chapman 0
4157295 2080617 2080617 defendant Burman John yeoman 592390 592390 Burman, John, of Dysse, Norf, yeoman 1
4161682 2082153 2082153 defendant Foulser Robert, junior butcher 592390 592390 Foulser, Robert, junior, of Dysse, Norf, butcher 0
4161686 2082154 2082154 defendant Buckenham William, senior yeoman 592390 592390 Buckenham, William, senior, of Dysse, Norf, yeoman 0
4161690 2082155 2082155 defendant Folser Robert, junior butcher 592390 592390 Folser, Robert, junior, of Dysse, Norf, butcher 0
4163545 2082772 2082772 defendant Snese John cooper 592390 592390 Snese, John, of Dysse, Norf, cooper 1
4177976 2087770 2087770 defendant Fuller alias Garblessham or Garlesam Robert yeoman 592390 592390 Fuller alias Garblessham or Garlesam, Robert, of Dysse, Norf, yeoman 2
4198740 2095119 2095119 defendant Sherman Richard fishmonger 592390 592390 Sherman, Richard, of Dysse, Norf, gent, or of London, fishmonger 0
4200649 2095786 2095786 defendant Thwaytes William yeoman 592390 592390 Thwaytes, William, of Dysse, Norf, yeoman 3
4203677 2096844 2096844 defendant Goodwyn Richard chapman 592390 592390 Goodwyn, Richard, of Dysse, Norf, chapman 1
4205767 2097566 2097566 defendant Manynge Thomas vintner 592390 592390 Manynge, Thomas, of Dysse, Norf, vintner 0
4209622 2098917 2098917 defendant Aldred Thomas cooper 592390 592390 Aldred, Thomas, of Dysse, Norf, cooper 1
4210701 2099300 2099300 defendant Buckenham William tanner 592390 592390 Buckenham, William, of Dysse, Norf, tanner 1
4226848 2104862 2104862 defendant Wyseman Avery blacksmith 592390 592390 Wyseman, Avery, of Dysse, Norf, blacksmith 0
4226850 2104863 2104863 defendant Wyseman William blacksmith 592390 592390 Wyseman, William, of Dysse, Norf, blacksmith 0
4232376 2106832 2106832 defendant Maninge Thomas innholder 592390 592390 Maninge, Thomas, of Dysse, Norf, innholder 2
4257113 2115356 2115356 defendant Remyngton Anthony chapman 592390 592390 Remyngton, Anthony, of Dysse, Norf, chapman 0
4257116 2115357 2115357 defendant Rymyngton Anthony chapman 592390 592390 Rymyngton, Anthony, of Dysse, Norf, chapman 0
4276784 2121813 2121813 defendant Hunt John tailor 592390 592390 Hunt, John, of Dysse, Norf, tailor 2
4276818 2121821 2121821 defendant Tybnam Thomas weaver 592390 592390 Tybnam, Thomas, of Dysse, Norf, weaver 0
4306282 2132336 2132336 defendant Blaby John tailor 592390 592390 Blaby, John, of Dysse, Norf, tailor 1
4318277 2136500 2136500 defendant Eldred Henry draper 592390 592390 Eldred, Henry, of Dysse, Norf, draper 2
4335087 2142008 2142008 defendant Shuckforthe Roger brewer 592390 592390 Shuckforthe, Roger, of Dysse, Norf, brewer 0
4341476 2144296 2144296 defendant Tbnham Thomas   592390 592390 Tbnham, Thomas, of Dysse, Norf, linen weaver 0
4343121 2144865 2144865 defendant Thursbie Simon tailor 592390 592390 Thursbie, Simon, of Dysse, Norf, tailor 2
4348776 2146831 2146831 defendant Coxe Richard clerk 592390 592390 Coxe, Richard, of Dysse, Norf, clerk 1
4349260 2147004 2147004 defendant Mannynge Thomas yeoman 592390 592390 Mannynge, Thomas, of Dysse, Norf, yeoman 0
4353228 2148356 2148356 defendant Ithell Hugh gent 592390 592390 Ithell, Hugh, of Dysse, Norf, or of Billesdon, Leics, gent 3
4363149 2151885 2151885 defendant Cutler Nicholas gent 592390 592390 Cutler, Nicholas, of Dysse, Norf, gent 0
4363688 2152081 2152081 defendant Cutler Nicholas gent 592390 592390 Cutler, Nicholas, of Dysse, Norf, or of Eye, Suff, gent 0
4363690 2152082 2152082 defendant Cutler Charles   592390 592390 Cutler, Charles, of Dysse, Norf, gent, son of Nicholas 0
4387259 2160386 2160386 defendant Leggede John cooper 592390 592390 Leggede, John, of Dysse, Norf, cooper 2
4399037 2164260 2164260 defendant Reede Robert gent 592390 592390 Reede, Robert, of Dysse, Norf, gent 0
4407566 2167096 2167096 defendant Turnor John, senior brasier 592390 592390 Turnor, John, senior, of Dysse, Norf, brasier 0
4803243 2297206 2297206 defendant Clerk John tailor 592390 592390 Clerk, John, of Dysse, Norf, tailor 0
4886921 2322761 2322761 defendant Lytewyn John husbandman 592390 592390 Lytewyn, John, of Dysse, Norf, husbandman 2
4912642 2330458 2330458 defendant Purchase Richard spicer 592390 592390 Purchase, Richard, of Dysse, Norf, spicer 0
4931140 2336126 2336126 defendant Sillete William dyer 592390 592390 Sillete, William, of Dysse, Norf, dyer 0
4931979 2336389 2336389 defendant Spyser Richard spicer 592390 592390 Spyser, Richard, of Dysse, Norf, spicer 1
5002064 2357505 2357505 defendant Purchace Richard spicer 592390 592390 Purchace, Richard, of Dysse, Norf, spicer 0
5002069 2357506 2357506 defendant Purchace Richard spicer 592390 592390 Purchace, Richard, of Dysse, Norf, spicer 0
5036773 2367630 2367630 defendant Spycer Richard spicer 592390 592390 Spycer, Richard, of Dysse, Norf, spicer 0
5041721 2369124 2369124 defendant Davy John   592390 592390 Davy, John, of Dysse, Norf, husb 5
5042207 2369276 2369276 defendant Hervy John husbandman 592390 592390 Hervy, John, of Dysse, Norf, husbandman 1
5045025 2370145 2370145 defendant Purchase Richard spicer 592390 592390 Purchase, Richard, of Dysse, Norf, spicer 0
5070151 2377567 2377567 defendant Smyth John smith 592390 592390 Smyth, John, of Dysse, Norf, smith 0
5073857 2378670 2378670 defendant Coterell Richard yeoman 592390 592390 Coterell, Richard, of Dysse, Norf, yeoman 0
5082193 2381169 2381169 defendant Spycer Edmund yeoman 592390 592390 Spycer, Edmund, of Dysse, Norf, yeoman 6
5082281 2381191 2381191 defendant Spycer Edmund yeoman 592390 592390 Spycer, Edmund, of Dysse, Norf, yeoman 6

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