names

92 rows where place_id = 603840

✎ 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
3655944 1912109 1912109 plaintiff Bunny Alice widow 603840 603840 Bunny, Alice, of Bungay, widow 0
3664913 1914971 1914971 defendant Foster Thomas husbandman 603840 603840 Foster, Thomas, of Bungay, husbandman 1
3664916 1914972 1914972 defendant Foster Thomas husbandman 603840 603840 Foster, Thomas, of Bungay, husbandman 1
3730551 1935791 1935791 defendant Brodfote John husbandman 603840 603840 Brodfote, John, of Bungay, husbandman 0
3745247 1940422 1940422 plaintiff Brende John baker 603840 603840 Brende, John, of Bungay, baker 0
3745253 1940423 1940423 defendant Barewell Nicholas cordwainer 603840 603840 Barewell, Nicholas, of Bungay, cordwainer 1
3747449 1941117 1941117 defendant Vynys John merchant 603840 603840 Vynys, John, of Bungay, merchant 0
3882248 1984321 1984321 plaintiff Stubbe Andrew gent 603840 603840 Stubbe, Andrew, of Bungay, gent 0
3892061 1987596 1987596 defendant Gyrlyng Thomas glover 603840 603840 Gyrlyng, Thomas, of Bungay, glover 3
3938499 2003219 2003219 defendant Massy John yeoman 603840 603840 Massy, John, of Bungay, yeoman 0
3946372 2005804 2005804 plaintiff Button Nicholas   603840 603840 Button, Nicholas, of Bungay, tanner, administrators of 0
3947481 2006192 2006192 defendant Moore Thomas tailor 603840 603840 Moore, Thomas, of Bungay, or of Ersham, Norf, tailor 0
3949206 2006791 2006791 defendant Gryme Thomas husbandman 603840 603840 Gryme, Thomas, of Bungay, husbandman 0
3957725 2009762 2009762 plaintiff Pryckett Robert tanner 603840 603840 Pryckett, Robert, of Bungay, tanner 0
3958185 2009935 2009935 defendant Ade Joan widow 603840 603840 Ade, Joan, of Bungay, widow 1
3986472 2019905 2019905 plaintiff Wharton Christine widow 603840 603840 Wharton, Christine, of Bungay, widow 0
3996978 2023686 2023686 defendant Leake John clerk 603840 603840 Leake, John, of Bungay, clerk 3
4057558 2045082 2045082 plaintiff Button Edward (legal representative) 603840 603840 Button, Edward, of Bungay, merchant, administratrix of 0
4058667 2045490 2045490 defendant Strowger John sherman 603840 603840 Strowger John, of Bungay, sherman 1
4169828 2084944 2084944 defendant Machett Francis yeoman 603840 603840 Machett, Francis, of Bungay, yeoman 1
4177938 2087756 2087756 defendant Neve Robert weaver 603840 603840 Neve, Robert, of Bungay, weaver 3
4205660 2097530 2097530 defendant Seles Ralph shoemaker 603840 603840 Seles, Ralph, of Bungay, shoemaker 1
4209877 2099015 2099015 defendant Brodebank Ralph sherman 603840 603840 Brodebank, Ralph, of Bungay, sherman 1
4241505 2110140 2110140 defendant Bray Richard butcher 603840 603840 Bray, Richard, of Bungay, butcher 1
4241506 2110140 2110140 defendant Bodham William husbandman 603840 603840 Bodham, William, of Bungay, husbandman 2
4242434 2110464 2110464 defendant Gayme Andrew gent 603840 603840 Gayme, Andrew, of Bungay, gent 0
4246489 2111803 2111803 defendant Brodbent Ralph clothworker 603840 603840 Brodbent, Ralph, of Bungay, clothworker 1
4246490 2111803 2111803 defendant Childes John   603840 603840 Childes, John, of Bungay, mason 2
4247524 2112160 2112160 defendant Stannard John laborer 603840 603840 Stannard, John, of Bungay, laborer 1
4261118 2116688 2116688 defendant Manne Thomas chapman 603840 603840 Manne, Thomas, of Bungay, chapman 1
4261154 2116700 2116700 defendant Prickett Robert tanner 603840 603840 Prickett, Robert, of Bungay, tanner 1
4274361 2120977 2120977 defendant Turrell Thomas shoemaker 603840 603840 Turrell, Thomas, of Bungay, shoemaker 1
4276104 2121589 2121589 defendant Creake Robert butcher 603840 603840 Creake, Robert, of Bungay, butcher 0
4276105 2121589 2121589 defendant Goothe Robert shoemaker 603840 603840 Goothe, Robert, of Bungay, shoemaker 1
4283405 2124100 2124100 defendant Palmer Henry draper 603840 603840 Palmer, Henry, of Bungay, draper 0
4283406 2124100 2124100 defendant Armiger John draper 603840 603840 Armiger John, of Bungay, draper 1
4293228 2127643 2127643 defendant Palmer Henry chapman 603840 603840 Palmer, Henry, of Bungay, chapman 1
4306196 2132304 2132304 defendant Caverne James saddler 603840 603840 Caverne, James, of Bungay, saddler 2
4309800 2133583 2133583 defendant Norton William gent 603840 603840 Norton, William, of Bungay, gent 2
4325676 2138965 2138965 defendant Folkard George yeoman 603840 603840 Folkard, George, of Bungay, yeoman 3
4327281 2139451 2139451 defendant Thurkettell John, junior yeoman 603840 603840 Thurkettell, John, junior, of Bungay, yeoman 0
4327282 2139451 2139451 defendant Thurkettell John, senior yeoman 603840 603840 Thurkettell, John, senior, of Bungay, yeoman 1
4327932 2139667 2139667 defendant Fayreclowte Robert yeoman 603840 603840 Fayreclowte, Robert, of Bungay, yeoman 1
4331763 2140918 2140918 defendant Pomfett or Pomsett alias Ireson John blacksmith 603840 603840 Pomfett or Pomsett alias Ireson, John, of Bungay, blacksmith 0
4331764 2140918 2140918 defendant Stannerd Thomas husbandman 603840 603840 Stannerd, Thomas, of Bungay, husbandman 1
4331765 2140918 2140918 defendant Sparke William tanner 603840 603840 Sparke, William, of Bungay, tanner 2
4331766 2140918 2140918 defendant Newson Tristan glover 603840 603840 Newson, Tristan, of Bungay, glover 3
4333105 2141359 2141359 defendant Austyn Richard butcher 603840 603840 Austyn, Richard, of Bungay, butcher 1
4349590 2147117 2147117 defendant Wake George glover 603840 603840 Wake, George, of Bungay, glover 1
4349591 2147117 2147117 defendant Bull Henry yeoman 603840 603840 Bull, Henry, of Bungay, yeoman 2
4350078 2147286 2147286 defendant Manne Anthony tanner 603840 603840 Manne, Anthony, of Bungay, tanner 0
4366506 2153066 2153066 defendant Bulwer Thomas gent 603840 603840 Bulwer, Thomas, of Bungay, gent 1
4385302 2159774 2159774 defendant Creake Robert butcher 603840 603840 Creake, Robert, of Bungay, butcher 0
4385303 2159774 2159774 defendant Childes John   603840 603840 Childes, John, of Bungay, "ryppier" or fishmonger 1
4385304 2159774 2159774 defendant Mallerey John husbandman 603840 603840 Mallerey, John, of Bungay, husbandman 2
4389585 2161145 2161145 defendant Kinge Thomas painter stainer 603840 603840 Kinge, Thomas, of Bungay, painter stainer 1
4393280 2162356 2162356 defendant Bodham William husbandman 603840 603840 Bodham, William, of Bungay, husbandman 0
4393281 2162356 2162356 defendant Wake George glover 603840 603840 Wake, George, of Bungay, glover 1
4393283 2162356 2162356 defendant Poynter Simon joiner 603840 603840 Poynter, Simon, of Bungay, joiner 3
4393370 2162384 2162384 defendant Nightingale Thomas laborer 603840 603840 Nightingale, Thomas, of Bungay, laborer 1
4393371 2162384 2162384 defendant Huggen Thomas laborer 603840 603840 Huggen, Thomas, of Bungay, laborer 2
4393670 2162484 2162484 defendant Inghold Robert joimer 603840 603840 Inghold, Robert, of Bungay, joimer 2
4398712 2164149 2164149 defendant Cooke John tailor 603840 603840 Cooke, John, of Bungay, tailor 0
4399899 2164554 2164554 defendant Reve John yeoman 603840 603840 Reve, John, of Bungay, yeoman 3
4399962 2164576 2164576 defendant Fytton Robert cordwainer 603840 603840 Fytton, Robert, of Bungay, cordwainer 0
4400454 2164746 2164746 defendant Bulwer Thomas gent 603840 603840 Bulwer, Thomas, of Bungay, gent 2
4402335 2165364 2165364 defendant Cooke Robert yeoman 603840 603840 Cooke, Robert, of Bungay, yeoman 2
4407781 2167168 2167168 defendant Richardson James cooper 603840 603840 Richardson, James, of Bungay, cooper 1
4407964 2167229 2167229 defendant Bull Henry yeoman 603840 603840 Bull, Henry, of Bungay, yeoman 1
4407965 2167229 2167229 defendant Flower Augustine butcher 603840 603840 Flower, Augustine, of Bungay, butcher 2
4408307 2167350 2167350 defendant Creake Robert butcher 603840 603840 Creake, Robert, of Bungay, butcher 0
4409578 2167801 2167801 defendant Gooche Clement yeoman 603840 603840 Gooche, Clement, of Bungay, yeoman 0
4409579 2167801 2167801 defendant Otley William yeoman 603840 603840 Otley, William, of Bungay, yeoman 1
4410240 2168025 2168025 defendant Cooke John tailor 603840 603840 Cooke, John, of Bungay, tailor 0
4471388 2191715 2191715 defendant Canel Henry   603840 603840 Canel, Henry, of bungay 6
4507992 2202967 2202967 defendant Budde Robert   603840 603840 Budde, Robert, of Bungay 0
4583655 2226306 2226306 plaintiff (not given) John vicar of Heerde 603840 603840 (Heerde, John, of Bungay, vicar of Holy Trinity church 1
4583660 2226307 2226307 plaintiff (not given) John vicar of Heerde 603840 603840 (Heerde, John, of Bungay, vicar of Holy Trinity church 1
4602166 2231897 2231897 defendant Bele Clement   603840 603840 Bele, Clement, of Bungay 2
4752015 2281084 2281084 defendant Plowme Thomas yeoman 603840 603840 Plowme, Thomas, of Bungay, yeoman 3
4879934 2320639 2320639 defendant Smyth Richard yeoman 603840 603840 Smyth, Richard, of Bungay, yeoman 0
5094083 2384670 2384670 defendant Anketell Robert husbandman 603840 603840 Anketell, Robert, of Bungay, husbandman 1
5277187 2438414 2438414 defendant Chapman Henry yeoman 603840 603840 Chapman, Henry, of Bungay, yeoman 3
5363971 2464384 2464384 defendant Holton John barker 603840 603840 Holton, John, of Bungay, barker 1
5407692 2477273 2477273 defendant Webster Richard   603840 603840 Webster, Richard, of Bungay, parchment maker 0
5420693 2481114 2481114 defendant Webster Richard   603840 603840 Webster, Richard, of Bungay, parchment maker 0
5453338 2490882 2490882 defendant Webster Richard   603840 603840 Webster, Richard, of Bungay, parchment maker 0
5499439 2504775 2504775 defendant Olton John barker 603840 603840 Olton, John, of Bungay, barker 0
5499440 2504775 2504775 defendant Hunne Robert smith 603840 603840 Hunne, Robert, of Bungay, smith 1
5549773 2519968 2519968 plaintiff Brende Robert   603840 603840 Brende, Robert, of Bungay 0
5553550 2521070 2521070 plaintiff Gorom Geoffrey husbandman 603840 603840 Gorom, Geoffrey, of Bungay, husbandman 0
5573296 2526746 2526746 defendant Gyles William glover 603840 603840 Gyles, William, of Bungay, glover 0

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