names

178 rows where place_id = 592820

✎ 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
3609047 1870486 1870486 defendant Freman Robert smith 592820 592820 Freman, Robert, of Dunwich, smith 0
3626873 1903256 1903256 defendant Philyp Richard baker 592820 592820 Philyp, Richard, of Dunwich, baker 0
3649241 1910151 1910151 defendant Rabet William gent 592820 592820 Rabet, William, of Dunwich, gent 0
3669444 1916382 1916382 defendant Broke Edmund mariner 592820 592820 Broke, Edmund, of Dunwich, mariner 0
3669658 1916449 1916449 defendant Worsley Thomas yeoman 592820 592820 Worsley, Thomas, of Dunwich, yeoman 0
3675600 1918404 1918404 defendant Bery William mariner 592820 592820 Bery, William, of Dunwich, mariner 0
3683313 1920905 1920905 defendant Bery William mariner 592820 592820 Bery, William, of Dunwich, mariner 0
3694744 1924560 1924560 defendant Coppyng George draper 592820 592820 Coppyng, George, of Dunwich, draper 2
3694745 1924560 1924560 defendant Kyng Robert merchant 592820 592820 Kyng, Robert, of Dunwich, merchant 3
3729360 1935436 1935436 plaintiff Baldewyn Nicholas merchant 592820 592820 Baldewyn, Nicholas, of Dunwich, merchant 0
3760712 1945350 1945350 defendant Tryppe Thomas mariner 592820 592820 Tryppe, Thomas, of Dunwich, mariner 0
3760713 1945350 1945350 defendant Ogram William mariner 592820 592820 Ogram, William, of Dunwich, mariner 1
3820917 1964438 1964438 defendant Flete John innkeeper 592820 592820 Flete, John, of Dunwich, innkeeper 0
3820918 1964438 1964438 defendant Flete William laborer 592820 592820 Flete, William, of Dunwich, laborer 1
3820919 1964438 1964438 defendant Coppyng George yeoman 592820 592820 Coppyng, George, of Dunwich, yeoman 2
3930394 2000512 2000512 plaintiff Coppych Robert   592820 592820 Coppych, Robert, of Dunwich 0
3930395 2000512 2000512 plaintiff Waller George   592820 592820 Waller, George, of Dunwich 1
3930397 2000512 2000512 defendant Shappe George mariner 592820 592820 Shappe, George, of Dunwich, mariner 1
3930398 2000513 2000513 plaintiff Coppyng Robert   592820 592820 Coppyng, Robert, of Dunwich 0
3930401 2000513 2000513 defendant Shappe George mariner 592820 592820 Shappe, George, of Dunwich, mariner 1
3933744 2001580 2001580 defendant Cryspe John mariner 592820 592820 Cryspe, John, of Dunwich, mariner 3
3939292 2003446 2003446 defendant Garrard John mariner 592820 592820 Garrard, John, of Dunwich, mariner 0
3939293 2003446 2003446 defendant Waller Robert butcher 592820 592820 Waller, Robert, of Dunwich, butcher 1
3939294 2003446 2003446 defendant Harryson George mariner 592820 592820 Harryson, George, of Dunwich, mariner 2
3939295 2003446 2003446 defendant Hasbrough Nicholas mariner 592820 592820 Hasbrough, Nicholas, of Dunwich, mariner 3
3946170 2005738 2005738 defendant Seman George gent 592820 592820 Seman, George, of Dunwich, gent 0
3959152 2010286 2010286 defendant Munforth Edmund butcher 592820 592820 Munforth, Edmund, of Dunwich, tailor Skett, Bartholomew, of Mendham, Suff, butcher 1
3961720 2011199 2011199 defendant Hugman or Hogman Robert husbandman 592820 592820 Hugman or Hogman, Robert, of Dunwich, husbandman 1
3961724 2011201 2011201 defendant Hugman or Hogman Robert husbandman or yeoman 592820 592820 Hugman or Hogman, Robert, of Dunwich, husbandman or yeoman 0
3965635 2012595 2012595 defendant Jenney Christopher gent 592820 592820 Jenney, Christopher, of Dunwich, gent 0
3965642 2012598 2012598 defendant Jenny Christopher gent 592820 592820 Jenny, Christopher, of Dunwich, gent 0
3976874 2016483 2016483 defendant Butler Robert (legal representative) 592820 592820 Butler, Robert, of Dunwich, mariner, executors of 0
3980379 2017751 2017751 defendant Hasborowe Nicholas merchant 592820 592820 Hasborowe, Nicholas, of Dunwich, merchant 2
3982498 2018518 2018518 plaintiff Saxmundham George   592820 592820 Saxmundham, George, of Dunwich 0
4022048 2032616 2032616 plaintiff Anderson Anthony mariner 592820 592820 Anderson, Anthony, of Dunwich, mariner 0
4034933 2037170 2037170 defendant Aleyn John gent 592820 592820 Aleyn, John, of Dunwich, gent 0
4041100 2039308 2039308 defendant Boutall or Bontall James yeoman 592820 592820 Boutall or Bontall, James, of Dunwich, yeoman 0
4077759 2052339 2052339 plaintiff Stone Richard mercer 592820 592820 Stone, Richard, of Dunwich, mercer 0
4094558 2058390 2058390 defendant Cryspe Robert turner 592820 592820 Cryspe, Robert, of Dunwich, turner 0
4094559 2058390 2058390 defendant Wardell William miller 592820 592820 Wardell, William, of Dunwich, miller 1
4111746 2064449 2064449 defendant Jentylman John merchant 592820 592820 Jentylman, John, of Dunwich, merchant 0
4111906 2064506 2064506 defendant Hasborowe John   592820 592820 Hasborowe, John, of Dunwich, Suff, sailor 1
4125061 2069252 2069252 defendant Coppyn Martin (legal representative) 592820 592820 Coppyn, Martin, of Dunwich, merchant, executors of 0
4125063 2069252 2069252 defendant Coppyn Petronilla widow 592820 592820 Coppyn, Petronilla, of Dunwich, widow 2
4128725 2070569 2070569 defendant Thewe Amos mariner 592820 592820 Thewe, Amos, of Dunwich, mariner 0
4129314 2070787 2070787 defendant Gyrdeler Niholas (legal representative) 592820 592820 Gyrdeler, Niholas, of Dunwich, fisherman, executors of 0
4129315 2070787 2070787 defendant Comberland John mariner 592820 592820 (Comberland, John, of Dunwich, mariner 1
4136972 2073571 2073571 defendant Coppyn Martin (legal representative) 592820 592820 Coppyn, Martin, of Dunwich, merchant, executors of 1
4136974 2073571 2073571 defendant Coppyn Petronilla widow 592820 592820 Coppyn, Petronilla, of Dunwich, widow 3
4150921 2078454 2078454 defendant Gatheroold George husbandman 592820 592820 Gatheroold George, of Dunwich, husbandman 0
4150922 2078454 2078454 defendant Howard Margaret widow 592820 592820 Howard, Margaret, of Dunwich, widow 1
4165776 2083530 2083530 defendant Cooke Robert mariner 592820 592820 Cooke, Robert, of Dunwich, mariner 0
4174694 2086619 2086619 defendant Waller George yeoman 592820 592820 Waller, George, of Dunwich, yeoman 1
4182427 2089332 2089332 defendant Dwight Otwell laborer 592820 592820 Dwight, Otwell, of Dunwich, laborer 0
4182428 2089332 2089332 defendant Blobbold Jonah husbandman 592820 592820 Blobbold, Jonah, of Dunwich, husbandman 1
4195056 2093835 2093835 defendant Thackwery Thomas clerk 592820 592820 Thackwery, Thomas, of Dunwich, clerk 0
4196466 2094308 2094308 defendant Coffyn Martin (legal representative) 592820 592820 Coffyn, Martin, of Dunwich, merchant, executors of 0
4196468 2094308 2094308 defendant Coffyn Petronilla widow 592820 592820 Coffyn, Petronilla, of Dunwich, widow 2
4197004 2094505 2094505 defendant Thackwary Thomas clerk 592820 592820 Thackwary, Thomas, of Dunwich, clerk 0
4197005 2094505 2094505 defendant Collett Francis merchant 592820 592820 Collett, Francis, of Dunwich, merchant 1
4197006 2094505 2094505 defendant Mayor Thomas grocer 592820 592820 Mayor, Thomas, of Dunwich, grocer 2
4204745 2097205 2097205 defendant Ryvett John chapman 592820 592820 Ryvett, John, of Dunwich, chapman 0
4216196 2101155 2101155 defendant Hasborough Robert yeoman 592820 592820 Hasborough, Robert, of Dunwich, yeoman 1
4226004 2104564 2104564 defendant Hasboroughe Robert yeoman 592820 592820 Hasboroughe, Robert, of Dunwich, yeoman 0
4239428 2109411 2109411 defendant Allyn Nicholas merchant 592820 592820 Allyn, Nicholas, of Dunwich, merchant 0
4246756 2111891 2111891 defendant Pyckeringe Lancelot yeoman 592820 592820 Pyckeringe, Lancelot, of Dunwich, yeoman 3
4248424 2112460 2112460 defendant Watkynson Robert clerk 592820 592820 Watkynson, Robert, of Dunwich, clerk 3
4254503 2114495 2114495 defendant Wake Samuel tailor 592820 592820 Wake, Samuel, of Dunwich, tailor 2
4254504 2114495 2114495 defendant Mayho William carpenter 592820 592820 Mayho, William, of Dunwich, carpenter 3
4325006 2138748 2138748 defendant Watkynson Robert clerk 592820 592820 Watkynson, Robert, of Dunwich, clerk 0
4327513 2139523 2139523 defendant Chamber John yeoman 592820 592820 Chamber, John, of Dunwich, or of Porwiche, Norf, yeoman 1
4342326 2144591 2144591 defendant Trasye John mariner 592820 592820 Trasye, John, of Dunwich, mariner 2
4348489 2146722 2146722 defendant Chambers John fishmonger 592820 592820 Chambers, John, of Dunwich, fishmonger 1
4348490 2146722 2146722 defendant Dey John husbandman 592820 592820 Dey, John, of Dunwich, husbandman 2
4348491 2146722 2146722 defendant Smythe James husbandman 592820 592820 Smythe, James, of Dunwich, husbandman 3
4349990 2147256 2147256 defendant Watson Alan brewer 592820 592820 Watson, Alan, of Dunwich, brewer 2
4361007 2151109 2151109 defendant Watkynson Robert clerk 592820 592820 Watkynson, Robert, of Dunwich, clerk 0
4411276 2168357 2168357 defendant Meane Edmund laborer 592820 592820 Meane, Edmund, of Dunwich, laborer 1
4411879 2168567 2168567 defendant Watkynson Robert clerk 592820 592820 Watkynson, Robert, of Dunwich, clerk 0
4411887 2168569 2168569 defendant Watkynson Robert clerk 592820 592820 Watkynson, Robert, of Dunwich, clerk 0
4472271 2191998 2191998 plaintiff Codum Peter   592820 592820 Codum, Peter, of Dunwich 0
4475118 2192887 2192887 defendant Runton John de   592820 592820 (Runton, John de, of Dunwich 1
4515732 2205346 2205346 defendant Morys William   592820 592820 Morys, William, of Dunwich 3
4522631 2207417 2207417 plaintiff Gryston Richard   592820 592820 Gryston, Richard, of Dunwich 0
4523693 2207741 2207741 defendant Bettes Roger chaplain 592820 592820 Bettes, Roger, of Dunwich, chaplain 0
4544186 2214098 2214098 plaintiff Barker (illegible)   592820 592820 Barker, _, of Dunwich 0
4553817 2217119 2217119 defendant Thorp Hugh de   592820 592820 Thorp, Hugh de, of Dunwich 0
4578680 2224821 2224821 plaintiff Codon Pater   592820 592820 Codon, Pater, of Dunwich 0
4599571 2231082 2231082 plaintiff Randesson John   592820 592820 Randesson, John, of Dunwich 1
4610520 2234359 2234359 defendant Genewe Robert   592820 592820 Genewe, Robert, of Dunwich 6
4622085 2237887 2237887 defendant Wynk Thomas   592820 592820 Wynk, Thomas, of Dunwich 0
4622086 2237887 2237887 defendant Wychyngham John   592820 592820 Wychyngham, John, of Dunwich 1
4622087 2237887 2237887 defendant Wychynham William   592820 592820 Wychynham, William, of Dunwich 2
4622088 2237887 2237887 defendant Furbisshour John   592820 592820 Furbisshour, John, of Dunwich 3
4669459 2256152 2256152 defendant James Thomas yeoman 592820 592820 James, Thomas, of Dunwich, yeoman 1
4695936 2264214 2264214 defendant Codon Peter husbandman 592820 592820 Codon, Peter, of Dunwich, husbandman 3
4697395 2264671 2264671 defendant Melton Richard husbandman 592820 592820 Melton, Richard, of Dunwich, husbandman 0
4698475 2265000 2265000 defendant Helmeth Peter yeoman 592820 592820 Helmeth, Peter, of Dunwich, yeoman 4
4701200 2265777 2265777 plaintiff Fullere Nicholas   592820 592820 Fullere, Nicholas, of Dunwich, parson of the church of St John Baptist 0
4701202 2265778 2265778 plaintiff Fullere Nicholas   592820 592820 Fullere, Nicholas, of Dunwich, parson of the church of St John the Baptist 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);