names

148 rows where place_id = 587182

✎ 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
3590694 1864732 1864732 defendant Doke Henry husbandman 587182 587182 Doke, Henry, of Blakeney, husbandman 0
3603640 1868806 1868806 defendant Hagon William yeoman 587182 587182 Hagon, William, of Blakeney, yeoman 1
3620476 1873981 1873981 defendant Shepard Henry husbandman 587182 587182 Shepard, Henry, of Blakeney, husbandman 0
3673117 1917602 1917602 defendant Breteyn John husbandman 587182 587182 Breteyn, John, of Blakeney, husbandman 2
3674687 1918131 1918131 defendant Thornham James raffman 587182 587182 Thornham, James, of Blakeney, raffman 0
3675909 1918502 1918502 plaintiff Holtyn Thomas   587182 587182 Holtyn, Thomas, of Blakeney 0
3712591 1930253 1930253 plaintiff Whight William   587182 587182 Whight, William, of Blakeney 0
3723263 1933547 1933547 defendant Akers John mariner 587182 587182 Akers, John, of Blakeney, mariner 3
3739127 1938445 1938445 defendant Akers John mariner 587182 587182 Akers, John, of Blakeney, mariner 3
3750168 1941969 1941969 defendant Frende Robert yeoman 587182 587182 Frende, Robert, of Blakeney, yeoman 3
3750169 1941969 1941969 defendant Broune Walter yeoman 587182 587182 Broune, Walter, of Blakeney, yeoman 4
3763165 1946113 1946113 defendant Vewter Robert merchant 587182 587182 Vewter, Robert, of Blakeney, merchant 0
3772844 1949200 1949200 defendant Michell John mariner 587182 587182 Michell, John, of Blakeney, mariner 0
3815436 1962744 1962744 defendant Baker Henry shoemaker 587182 587182 Baker, Henry, of Blakeney, shoemaker 0
3820271 1964212 1964212 defendant Smert John weaver 587182 587182 Smert, John, of Blakeney, weaver 1
3848036 1972959 1972959 defendant Peern Christopher gent 587182 587182 Peern, Christopher, of Blakeney, gent 0
3848409 1973078 1973078 defendant Whyte Richard mariner 587182 587182 Whyte, Richard, of Blakeney, mariner 1
3851316 1974010 1974010 defendant Bartylmewe John   587182 587182 Bartylmewe, John, of Blakeney, ship master 0
3857879 1976104 1976104 plaintiff Bartillmewe John mariner 587182 587182 Bartillmewe, John, of Blakeney, mariner 0
3860194 1976903 1976903 defendant Cressy Robert husbandman 587182 587182 Cressy, Robert, of Blakeney, husbandman 2
3862763 1977738 1977738 defendant Pawe John yeoman 587182 587182 Pawe, John, of Blakeney, yeoman 2
3863272 1977913 1977913 defendant Peern Christopher gent 587182 587182 Peern, Christopher, of Blakeney, gent 0
3884656 1985141 1985141 defendant Henry William mariner 587182 587182 Henry, William, of Blakeney, mariner 0
3890283 1986996 1986996 defendant Trewe John tailor 587182 587182 Trewe, John, of Blakeney, tailor 1
3911777 1994265 1994265 defendant Awdeley John yeoman 587182 587182 Awdeley, John, of Blakeney, yeoman 2
3956232 2009243 2009243 defendant Snellyng Thomas yeoman 587182 587182 Snellyng, Thomas, of Blakeney, yeoman 7
3967155 2013137 2013137 plaintiff Bryght Simon mariner 587182 587182 Bryght, Simon, of Blakeney, mariner 0
3970961 2014401 2014401 defendant Snellyng Thomas butcher 587182 587182 Snellyng, Thomas, of Blakeney, yeoman, or of Est Dereham, butcher 1
3984245 2019132 2019132 defendant Clarke George tailor 587182 587182 Clarke, George, of Blakeney, tailor 1
4005113 2026615 2026615 defendant Shyllyng John butcher 587182 587182 Shyllyng, John, of Blakeney, butcher 1
4026681 2034188 2034188 defendant Gorlyng John yeoman 587182 587182 Gorlyng, John, of Blakeney, yeoman 3
4082539 2054061 2054061 defendant Barker William mariner 587182 587182 Barker, William, of Blakeney, mariner 1
4102536 2061207 2061207 defendant Bett John gent 587182 587182 Bett, John, of Blakeney, gent 0
4105358 2062197 2062197 defendant Mann John miller 587182 587182 Mann, John, of Blakeney, miller 1
4114340 2065413 2065413 defendant Rampton Cuthbert yeoman 587182 587182 Rampton, Cuthbert, of Blakeney, yeoman 0
4116197 2066084 2066084 defendant Barker William mariner 587182 587182 Barker, William, of Blakeney, mariner 2
4131402 2071550 2071550 defendant Clarke Thomas yeoman 587182 587182 Clarke, Thomas, of Blakeney, yeoman 0
4131403 2071550 2071550 defendant Clarke George yeoman 587182 587182 Clarke, George, of Blakeney, yeoman 1
4131404 2071550 2071550 defendant Mawfreys Richard yeoman 587182 587182 Mawfreys, Richard, of Blakeney, yeoman 2
4131405 2071550 2071550 defendant key William husbandman 587182 587182 key, William, of Blakeney, husbandman 3
4143180 2075785 2075785 defendant Clarke George yeoman 587182 587182 Clarke, George, of Blakeney, yeoman 0
4158358 2080995 2080995 defendant Barker Peter gent 587182 587182 Barker, Peter, of Blakeney, gent 0
4164936 2083243 2083243 defendant Bryge Thomas shoemaker 587182 587182 Bryge, Thomas, of Blakeney, shoemaker 0
4172634 2085888 2085888 defendant Barker William yeoman 587182 587182 Barker, William, of Blakeney, yeoman 0
4194400 2093593 2093593 defendant Barker William husbandman 587182 587182 Barker, William, of Blakeney, husbandman 1
4194401 2093593 2093593 defendant Paron Thomas husbandman 587182 587182 Paron, Thomas, of Blakeney, husbandman 2
4212154 2099797 2099797 defendant Brigg Thomas shoemaker 587182 587182 Brigg, Thomas, of Blakeney, shoemaker 1
4215956 2101074 2101074 defendant Chambers William   587182 587182 Chambers, William, of Blakeney, sailor 1
4219192 2102209 2102209 defendant Clarke Jerome yeoman 587182 587182 Clarke, Jerome, of Blakeney, yeoman 0
4244500 2111141 2111141 defendant Mond Henry husbandman 587182 587182 Mond, Henry, of Blakeney, husbandman 0
4244503 2111142 2111142 defendant Mond Henry husbandman 587182 587182 Mond, Henry, of Blakeney, husbandman 0
4256117 2115027 2115027 defendant Armynger Christopher   587182 587182 Armynger, Christopher, of Blakeney, sailor 1
4256234 2115064 2115064 defendant Woodward Marmaduke husbandman 587182 587182 Woodward, Marmaduke, of Blakeney, husbandman 2
4261121 2116689 2116689 defendant Mund Henry grocer 587182 587182 Mund, Henry, of Blakeney, grocer 0
4277525 2122063 2122063 plaintiff Mound Henry grocer 587182 587182 Mound, Henry, of Blakeney, grocer 1
4327765 2139610 2139610 defendant Barker Peter gent 587182 587182 Barker, Peter, of Blakeney, gent 1
4329448 2140156 2140156 defendant Poynter James clerk 587182 587182 Poynter, James, of Blakeney, clerk 0
4331825 2140936 2140936 defendant Powncer Francis chapman 587182 587182 Powncer, Francis, of Blakeney, chapman 1
4352633 2148154 2148154 defendant Wyley George mariner 587182 587182 Wyley, George, of Blakeney, mariner 2
4387395 2160428 2160428 defendant Clarke George yeoman 587182 587182 Clarke, George, of Blakeney, yeoman 2
4404758 2166158 2166158 defendant Pounser Francis   587182 587182 Pounser, Francis, of Blakeney, sailor 0
4511061 2203910 2203910 defendant Bonyse William   587182 587182 Bonyse, William, of Blakeney 3
4524499 2208000 2208000 plaintiff Holtman John   587182 587182 Holtman, John, of Blakeney 0
4544840 2214305 2214305 defendant Bonyff Waillim   587182 587182 Bonyff, Waillim, of Blakeney 1
4544843 2214306 2214306 defendant Bonys William   587182 587182 Bonys, William, of Blakeney 1
4609486 2234071 2234071 plaintiff Bulwere Simon   587182 587182 Bulwere, Simon, of Blakeney 0
4609488 2234072 2234072 plaintiff Bulwere Simon   587182 587182 Bulwere, Simon, of Blakeney 0
4627025 2239401 2239401 defendant Moy Mathewe   587182 587182 Moy, Mathewe, of Blakeney 3
4683518 2260447 2260447 defendant Wilmot Walter butcher 587182 587182 Wilmot, Walter, of Blakeney, butcher 0
4693565 2263490 2263490 defendant Baron John yeoman 587182 587182 Baron, John, of Blakeney, yeoman 1
4706547 2267425 2267425 defendant Cheventeyn John husbandman 587182 587182 Cheventeyn, John, of Blakeney, husbandman 0
4735977 2276398 2276398 defendant Spoo John   587182 587182 Spoo, John, of Blakeney, franklin 0
4745141 2279084 2279084 defendant Sefrey Benedict   587182 587182 Sefrey, Benedict, of Blakeney, mason 0
4745146 2279085 2279085 defendant Sefrey Benedict   587182 587182 Sefrey, Benedict, of Blakeney, mason 0
4752071 2281090 2281090 defendant Spoo John yeoman 587182 587182 Spoo, John, of Blakeney, yeoman 6
4758070 2282896 2282896 defendant Frank John   587182 587182 Frank, John, of Blakeney, parson 0
4775840 2288444 2288444 plaintiff Hoggys Richard   587182 587182 Hoggys, Richard, of Blakeney 1
4804058 2297454 2297454 plaintiff Berbrewer Gilbert   587182 587182 Berbrewer, Gilbert, of Blakeney 0
4808519 2298833 2298833 defendant Anre Nicholas husbandman 587182 587182 Anre, Nicholas, of Blakeney, husbandman 0
4812595 2300056 2300056 plaintiff Smyth John   587182 587182 Smyth, John, of Blakeney 1
4833994 2306639 2306639 defendant Awere Nicholas   587182 587182 Awere, Nicholas, of Blakeney, bailiff 0
4844878 2309920 2309920 defendant Reyner Simon husbandman 587182 587182 Reyner, Simon, of Blakeney, husbandman 3
4865404 2316149 2316149 defendant Baxster Roger baker 587182 587182 Baxster, Roger, of Blakeney, baker 1
4882919 2321577 2321577 defendant Berebrewer Timon beer brewer 587182 587182 Berebrewer, Timon, of Blakeney, beer brewer 0
4885109 2322234 2322234 defendant Baron John beer brewer 587182 587182 Baron, John, of Blakeney, beer brewer 0
4886932 2322764 2322764 defendant Hogges Richard husbandman 587182 587182 Hogges, Richard, of Blakeney, husbandman 3
4897917 2326006 2326006 defendant Reyner Simon shipman 587182 587182 Reyner, Simon, of Blakeney, shipman 0
4900123 2326667 2326667 defendant Gysbryght Tumund beer brewer 587182 587182 Gysbryght, Tumund, of Blakeney, beer brewer 0
4935682 2337547 2337547 defendant Burwell Edmund yeoman 587182 587182 Burwell, Edmund, of Blakeney, yeoman 1
4957587 2344243 2344243 defendant Wroo Thomas yeoman 587182 587182 Wroo, Thomas, of Blakeney, yeoman 0
4957916 2344338 2344338 defendant Hoggys Robert husbandman 587182 587182 Hoggys, Robert, of Blakeney, husbandman 1
4968473 2347538 2347538 defendant Tyler William tiler 587182 587182 Tyler, William, of Blakeney, tiler 3
4980886 2351219 2351219 defendant Andrewe James yeoman 587182 587182 Andrewe, James, of Blakeney, yeoman 0
4985877 2352693 2352693 defendant Baron John (legal representative) 587182 587182 Baron, John, of Blakeney, executors of 0
5014919 2361240 2361240 defendant Stepyng William yeoman 587182 587182 Stepyng, William, of Blakeney, yeoman 2
5041592 2369087 2369087 defendant Wryght John shipman 587182 587182 Wryght, John, of Blakeney, shipman 0
5079710 2380416 2380416 defendant Cotton James husbandman 587182 587182 Cotton, James, of Blakeney, husbandman 1
5081029 2380828 2380828 defendant atte Hill Hugh yeoman 587182 587182 atte Hill, Hugh, of Blakeney, yeoman 1
5081032 2380829 2380829 defendant atte Hill Hugh yeoman 587182 587182 atte Hill, Hugh, of Blakeney, yeoman 1
5087277 2382660 2382660 defendant Dalle John merchant 587182 587182 Dalle, John, of Blakeney, merchant 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);