names

224 rows where place_id = 592185

✎ 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
3606871 1869814 1869814 defendant Spycer alias Mercer Henry yeoman 592185 592185 Spycer alias Mercer, Henry, of Sheryngham, yeoman 0
3616821 1872889 1872889 defendant Stevyns Robert shipman 592185 592185 Stevyns, Robert, of Sheryngham, shipman 2
3633109 1905167 1905167 defendant Norwode Joan widow 592185 592185 Norwode, Joan, of Sheryngham, widow 0
3639945 1907306 1907306 defendant Sawnder Richard husbandman 592185 592185 Sawnder, Richard, of Sheryngham, husbandman 1
3639946 1907306 1907306 defendant Anderson Magnus singleman 592185 592185 Anderson, Magnus, of Sheryngham, singleman 2
3646673 1909363 1909363 defendant Iryngson John loader 592185 592185 Iryngson, John, of Sheryngham, loader 1
3669174 1916296 1916296 defendant Hecson Robert   592185 592185 Hecson, Robert, of Sheryngham, rough mason 0
3692267 1923752 1923752 defendant Loose Andrew mercer 592185 592185 Loose, Andrew, of Sheryngham, mercer 0
3694870 1924604 1924604 defendant Lose Andrew mercer 592185 592185 Lose, Andrew, of Sheryngham, mercer 0
3700670 1926456 1926456 defendant Hykson Robert   592185 592185 Hykson, Robert, of Sheryngham, mason 1
3702272 1926967 1926967 defendant Denny William mariner 592185 592185 Denny, William, of Sheryngham, mariner 2
3702274 1926967 1926967 defendant Coke Robert laborer 592185 592185 Coke, Robert, of Sheryngham, laborer 4
3703387 1927335 1927335 plaintiff Davy Richard mariner 592185 592185 Davy, Richard, of Sheryngham, mariner 0
3703388 1927335 1927335 plaintiff Bartylmewe Peter mariner 592185 592185 Bartylmewe, Peter, of Sheryngham, mariner 1
3703390 1927336 1927336 plaintiff Davy Richard mariner 592185 592185 Davy, Richard, of Sheryngham, mariner 0
3703391 1927336 1927336 plaintiff Bartylmewe Peter mariner 592185 592185 Bartylmewe, Peter, of Sheryngham, mariner 1
3705640 1928045 1928045 defendant Lowthe alias Loose Andrew mercer 592185 592185 Lowthe alias Loose, Andrew, of Sheryngham, mercer 0
3706573 1928341 1928341 defendant Lowth Andrew mercer 592185 592185 Lowth, Andrew, of Sheryngham, mercer 0
3706579 1928343 1928343 defendant Louthe Andrew mercer 592185 592185 Louthe, Andrew, of Sheryngham, mercer 0
3707080 1928502 1928502 defendant Jory Robert husbandman 592185 592185 Jory, Robert, of Sheryngham, husbandman 2
3709608 1929313 1929313 defendant Harrison John husbandman 592185 592185 Harrison, John, of Sheryngham, husbandman 4
3709872 1929402 1929402 plaintiff Roke Simon   592185 592185 Roke, Simon, of Sheryngham 0
3713106 1930416 1930416 defendant Mors John mariner 592185 592185 Mors, John, of Sheryngham, mariner 0
3724403 1933921 1933921 plaintiff Roke Simon   592185 592185 Roke, Simon, of Sheryngham 0
3729016 1935323 1935323 defendant Pylgryme Thomas mariner 592185 592185 Pylgryme, Thomas, of Sheryngham, mariner 0
3734781 1937124 1937124 defendant Elsy Robert mariner 592185 592185 Elsy, Robert, of Sheryngham, mariner 0
3734782 1937124 1937124 defendant Bartram Robert mariner 592185 592185 Bartram, Robert, of Sheryngham, mariner 1
3734783 1937124 1937124 defendant Kyngys John mariner 592185 592185 Kyngys, John, of Sheryngham, mariner 2
3734784 1937124 1937124 defendant Holden William mariner 592185 592185 Holden, William, of Sheryngham, mariner 3
3734785 1937124 1937124 defendant Spryngolde John mariner 592185 592185 Spryngolde, John, of Sheryngham, mariner 4
3734786 1937124 1937124 defendant Samner or Sammer Reginald mariner 592185 592185 Samner or Sammer, Reginald, of Sheryngham, mariner 5
3734943 1937164 1937164 defendant Fuller John (legal representative) 592185 592185 Fuller, John, of Sheryngham, yeoman, executors of 4
3748472 1941454 1941454 defendant Hooke Isabel widow 592185 592185 Hooke, Isabel, of Sheryngham, widow 4
3758966 1944795 1944795 defendant Lame or Laine Robert mariner 592185 592185 Lame or Laine, Robert, of Sheryngham, mariner 1
3759721 1945033 1945033 defendant Denny William mariner 592185 592185 Denny, William, of Sheryngham, mariner 1
3762520 1945921 1945921 defendant Wode Robert brewer 592185 592185 Wode, Robert, of Sheryngham, brewer 3
3770533 1948467 1948467 defendant Jory Robert husbandman 592185 592185 Jory, Robert, of Sheryngham, husbandman 1
3780726 1951705 1951705 defendant Wodeforth Robert husbandman 592185 592185 Wodeforth, Robert, of Sheryngham, husbandman 0
3780728 1951706 1951706 defendant Woodforth Robert husbandman 592185 592185 Woodforth, Robert, of Sheryngham, husbandman 0
3782078 1952149 1952149 defendant Lame Robert mariner 592185 592185 Lame, Robert, of Sheryngham, mariner 1
3796719 1956860 1956860 defendant Churche John tailor 592185 592185 Churche, John, of Sheryngham, tailor 3
3811706 1961558 1961558 defendant Barker Adam mariner 592185 592185 Barker, Adam, of Sheryngham, mariner 1
3836284 1969258 1969258 defendant Newman Nicholas chapman 592185 592185 Newman, Nicholas,of Sheryngham, chapman 1
3836290 1969259 1969259 defendant Newman Nicholas chapman 592185 592185 Newman, Nicholas, of Sheryngham, chapman 1
3836445 1969306 1969306 defendant Heygfeld John mariner 592185 592185 Heygfeld, John, of Sheryngham, mariner 0
3843418 1971477 1971477 defendant Barett Robert mariner 592185 592185 Barett, Robert, of Sheryngham, mariner 0
3843420 1971477 1971477 defendant Heyfeld John mariner 592185 592185 Heyfeld, John, of Sheryngham, mariner 2
3846529 1972472 1972472 defendant Spryngeld Thomas, senior mariner 592185 592185 Spryngeld, Thomas, senior, of Sheryngham, mariner 0
3846531 1972472 1972472 defendant Hows John mariner 592185 592185 Hows, John, of Sheryngham, mariner 2
3846532 1972472 1972472 defendant Dake Thomas mariner 592185 592185 Dake, Thomas, of Sheryngham, mariner 3
3847933 1972931 1972931 plaintiff Hooke Robert   592185 592185 Hooke, Robert, of Sheryngham 0
3847935 1972932 1972932 plaintiff Hooke Robert   592185 592185 Hooke, Robert, of Sheryngham 0
3848224 1973012 1973012 defendant Julot or Inlot Edmund clerk 592185 592185 Julot or Inlot, Edmund, of Sheryngham, clerk 1
3848225 1973012 1973012 defendant Belwer Nicholas husbandman 592185 592185 Belwer, Nicholas, of Sheryngham, husbandman 2
3854638 1975095 1975095 defendant Pechet John mercer 592185 592185 Pechet, John, of Sheryngham, mercer 0
3854639 1975095 1975095 defendant Lowse Andrew husbandman 592185 592185 Lowse, Andrew, of Sheryngham, husbandman 1
3863715 1978047 1978047 defendant Pechet John mercer 592185 592185 Pechet, John, of Sheryngham, mercer 0
3863729 1978049 1978049 defendant Pechett John mercer 592185 592185 Pechett, John, of Sheryngham, mercer 0
3871911 1980840 1980840 defendant Grene Thomas yeoman 592185 592185 Grene, Thomas, of Sheryngham, yeoman 0
3877394 1982685 1982685 plaintiff Hooke Robert (legal representative) 592185 592185 Hooke, Robert, of Sheryngham, executors of 0
3885265 1985324 1985324 plaintiff Tompson Thomas   592185 592185 Tompson, Thomas, of Sheryngham 1
3885266 1985324 1985324 defendant Baker John mariner 592185 592185 Baker, John, of Sheryngham, mariner 0
3910096 1993684 1993684 defendant Sturgeys Robert gent 592185 592185 Sturgeys, Robert, of Sheryngham, gent 1
3913071 1994701 1994701 plaintiff Barber Thomas barker 592185 592185 Barber, Thomas, of Sheryngham, barker 0
3917642 1996257 1996257 defendant Yong Thomas warrener 592185 592185 Yong, Thomas, of Sheryngham, warrener 0
3919268 1996775 1996775 plaintiff Kynge John   592185 592185 Kynge, John, of Sheryngham, shop master 0
3944097 2005044 2005044 defendant Burges John cooper 592185 592185 Burges, John, of Sheryngham, cooper 3
3959354 2010353 2010353 defendant Kynge Thomas mariner 592185 592185 Kynge, Thomas, of Sheryngham, mariner 1
3959357 2010354 2010354 defendant Kynge Thomas mariner 592185 592185 Kynge, Thomas, of Sheryngham, mariner 1
3970710 2014344 2014344 defendant Sparke George (legal representative) 592185 592185 Sparke, George, of Sheryngham, innholder, executors of 0
3980244 2017700 2017700 defendant Ulffe John cordwainer 592185 592185 Ulffe, John, of Sheryngham, cordwainer 0
3993291 2022342 2022342 defendant Rokkett Walter shoemaker 592185 592185 Rokkett, Walter, of Sheryngham, shoemaker 2
4065054 2047788 2047788 defendant Lacy John shipmaster 592185 592185 Lacy, John, of Sheryngham, shipmaster 0
4065055 2047788 2047788 defendant Espyn William mariner 592185 592185 Espyn, William, of Sheryngham, mariner 1
4065056 2047788 2047788 defendant Hope Nicholas mariner 592185 592185 Hope, Nicholas, of Sheryngham, mariner 2
4066498 2048309 2048309 defendant Squytche Thomas yeoman 592185 592185 Squytche, Thomas, of Sheryngham, yeoman 1
4077616 2052280 2052280 defendant Kyrk Robert innkeeper 592185 592185 Kyrk, Robert, of Sheryngham, innkeeper 3
4095640 2058770 2058770 defendant Bishoppe William yeoman 592185 592185 Bishoppe, William, of Sheryngham, yeoman 1
4098541 2059809 2059809 defendant Cutche Thomas husbandman 592185 592185 Cutche, Thomas, of Sheryngham, husbandman 0
4102663 2061253 2061253 defendant Hyllyngton William mariner 592185 592185 Hyllyngton, William, of Sheryngham, mariner 0
4106206 2062513 2062513 defendant Wulover William mariner 592185 592185 Wulover, William, of Sheryngham, mariner 0
4109365 2063611 2063611 defendant Hyllyngton William mariner 592185 592185 Hyllyngton, William, of Sheryngham, mariner 0
4111783 2064463 2064463 defendant Bysshoppe William yeoman 592185 592185 Bysshoppe, William, of Sheryngham, yeoman 2
4111786 2064464 2064464 defendant Sturgis Robert gent 592185 592185 Sturgis, Robert, of Sheryngham, gent 0
4142964 2075710 2075710 defendant Hooke John   592185 592185 Hooke, John, of Sheryngham, ship master 2
4147115 2077134 2077134 defendant Grene Edmund mariner or shipmaster 592185 592185 Grene, Edmund, of Sheryngham, mariner or shipmaster 0
4150081 2078166 2078166 defendant Munford Simon yeoman 592185 592185 Munford, Simon, of Sheryngham, yeoman 1
4150082 2078166 2078166 defendant Peretree John mariner 592185 592185 Peretree, John, of Sheryngham, mariner 2
4150083 2078166 2078166 defendant Ussher Simon   592185 592185 Ussher, Simon, of Sheryngham Hythe, sailor 3
4150238 2078214 2078214 defendant Munford Robert mariner 592185 592185 Munford, Robert, of Sheryngham, mariner 2
4150239 2078214 2078214 defendant Burnes John clerk 592185 592185 Burnes, John, of Sheryngham, clerk 3
4152329 2078924 2078924 defendant Yong John husbandman 592185 592185 Yong, John, of Sheryngham, husbandman 3
4155304 2079949 2079949 defendant Shepard Thomas butcher 592185 592185 Shepard, Thomas, of Sheryngham, butcher 0
4155308 2079950 2079950 defendant Sheparde Thomas butcher 592185 592185 Sheparde, Thomas, of Sheryngham, butcher 0
4157833 2080816 2080816 defendant Kyrke Robert mariner 592185 592185 Kyrke, Robert, of Sheryngham, mariner 1
4158210 2080940 2080940 defendant Hooke John mariner 592185 592185 Hooke, John, of Sheryngham, mariner 3
4160787 2081850 2081850 defendant Bysshoppe William scrivener 592185 592185 Bysshoppe, William, of Sheryngham, scrivener 1
4160788 2081850 2081850 defendant Hyllyngton William mariner 592185 592185 Hyllyngton, William, of Sheryngham, mariner 2
4175453 2086886 2086886 defendant Walker John cordwainer 592185 592185 Walker, John, of Sheryngham, cordwainer 0
4179824 2088419 2088419 defendant Elam John (legal representative) 592185 592185 Elam, John, of Sheryngham, shipmaster, executor of 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);