names

180 rows where place_id = 615601

✎ 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
3628496 1903782 1903782 defendant Muddys William   615601 615601 Muddys, William, of Gorleston, ploughwright 0
3709697 1929345 1929345 defendant Adams William yeoman 615601 615601 Adams, William, of Gorleston, yeoman 1
3709698 1929345 1929345 defendant Spachet Henry yeoman 615601 615601 Spachet, Henry, of Gorleston, yeoman 2
3709700 1929345 1929345 defendant Bache Richard baker 615601 615601 Bache, Richard, of Gorleston, baker 4
3709701 1929345 1929345 defendant Cornys John yeoman 615601 615601 Cornys, John, of Gorleston, yeoman 5
3719214 1932295 1932295 defendant Toppys John husbandman 615601 615601 Toppys, John, of Gorleston, husbandman 0
3728849 1935270 1935270 defendant Roket Nicholas   615601 615601 Roket, Nicholas, of Gorleston, plough wright 0
3739223 1938488 1938488 defendant Gornys Thomas mariner 615601 615601 Gornys, Thomas, of Gorleston, mariner 1
3748523 1941471 1941471 defendant Holme Richard yeoman 615601 615601 Holme, Richard, of Gorleston, yeoman 0
3803237 1958915 1958915 defendant Wynston William husbandman 615601 615601 Wynston, William, of Gorleston, husbandman 0
3807968 1960383 1960383 plaintiff Wynston William   615601 615601 Wynston, William, of Gorleston 0
3830755 1967503 1967503 plaintiff Fysshe John (legal representative) 615601 615601 Fysshe, John, of Gorleston, executrix of 0
3830757 1967503 1967503 defendant Sewall Thomas smith 615601 615601 Sewall, Thomas, of Gorleston, smith 0
3831316 1967682 1967682 defendant Roket John clerk 615601 615601 Roket, John, of Gorleston, clerk 0
3831317 1967682 1967682 defendant Tompson Robert husbandman 615601 615601 Tompson, Robert, of Gorleston, husbandman 1
3870594 1980406 1980406 plaintiff Wynston William yeoman 615601 615601 Wynston, William, of Gorleston, yeoman 0
3870597 1980407 1980407 plaintiff Wynston William yeoman 615601 615601 Wynston, William, of Gorleston, yeoman 0
3888585 1986441 1986441 defendant Daldy John tanner 615601 615601 Daldy, John, of Gorleston, tanner 0
3901952 1990881 1990881 plaintiff Dawdy John   615601 615601 Dawdy, John, of Gorleston 0
3934282 2001763 2001763 defendant Hollywell Robert husbandman 615601 615601 Hollywell, Robert, of Gorleston, husbandman 0
3938965 2003365 2003365 defendant Olderyng Richard butcher 615601 615601 Olderyng, Richard, of Gorleston, butcher 0
3947221 2006094 2006094 defendant Fullwood John merchant 615601 615601 Fullwood, John, of Gorleston, merchant 1
3952322 2007882 2007882 defendant Stokes John husbandman 615601 615601 Stokes, John, of Gorleston, husbandman 1
3969672 2013998 2013998 defendant Gunvyle Henry gent 615601 615601 Gunvyle, Henry, of Gorleston, gent 0
3969673 2013998 2013998 defendant Fok John   615601 615601 Fok, John, of Gorleston, shepherd 1
3984554 2019233 2019233 defendant Broun Thomas innholder 615601 615601 Broun, Thomas, of Gorleston, innholder 0
4002383 2025628 2025628 plaintiff Hemsby Richard yeoman 615601 615601 Hemsby, Richard, of Gorleston, yeoman 0
4006705 2027177 2027177 defendant Wyggar Robert husbandman 615601 615601 Wyggar, Robert, of Gorleston, husbandman 0
4017634 2031016 2031016 defendant Wygger Robert husbandman 615601 615601 Wygger, Robert, of Gorleston, husbandman 0
4017635 2031016 2031016 defendant Frende Lawrence husbandman 615601 615601 Frende, Lawrence, of Gorleston, husbandman 1
4017648 2031021 2031021 defendant Wygger Robert husbandman 615601 615601 Wygger, Robert, of Gorleston, husbandman 2
4018402 2031314 2031314 defendant Wyggar Robert husbandman 615601 615601 Wyggar, Robert, of Gorleston, husbandman 1
4021010 2032239 2032239 defendant Davy Nicholas yeoman 615601 615601 Davy, Nicholas, of Gorleston, yeoman 2
4033103 2036490 2036490 plaintiff Goodall Richard yeoman 615601 615601 Goodall, Richard, of Gorleston, yeoman 0
4033748 2036722 2036722 plaintiff Gunvile Henry gent 615601 615601 Gunvile, Henry, of Gorleston, gent 0
4048602 2041949 2041949 defendant Ferror alias Dane Thomas mariner 615601 615601 Ferror alias Dane, Thomas, of Gorleston, mariner 0
4063349 2047182 2047182 defendant Edward Charles miller 615601 615601 Edward, Charles, of Gorleston, miller 0
4063350 2047182 2047182 defendant Gylbart Robert yeoman 615601 615601 Gylbart, Robert, of Gorleston, yeoman 1
4063351 2047182 2047182 defendant Sharples Thomas tailor 615601 615601 Sharples, Thomas, of Gorleston, tailor 2
4067017 2048501 2048501 defendant Fytchett Johm mariner 615601 615601 Fytchett, Johm, of Gorleston, mariner 0
4074920 2051332 2051332 defendant Calf John husbandman 615601 615601 Calf, John, of Gorleston, husbandman 0
4079081 2052818 2052818 defendant Blomfeild Jerome   615601 615601 Blomfeild, Jerome, of Gorleston, Suff gent 0
4087710 2055896 2055896 defendant Goldsmyth alias Flower Thomas weaver 615601 615601 Goldsmyth alias Flower, Thomas, of Gorleston, weaver 0
4096955 2059242 2059242 defendant More Thomas   615601 615601 More, Thomas, of Gorleston, merchant, administrators of 0
4096956 2059242 2059242 defendant Woodgate Richard merchant 615601 615601 (Woodgate, Richard, of Gorleston, merchant 1
4096957 2059242 2059242 defendant Sherwood Henry merchant 615601 615601 Sherwood, Henry, of Gorleston, merchant 2
4097245 2059335 2059335 defendant Calff John husbandman 615601 615601 Calff, John, of Gorleston, husbandman 0
4097246 2059335 2059335 defendant Huggons William husbandman 615601 615601 Huggons, William, of Gorleston, husbandman 1
4113540 2065122 2065122 defendant Greane William brewer 615601 615601 Greane, William, of Gorleston, brewer 0
4113541 2065122 2065122 defendant Sykerfam Richard tailor 615601 615601 Sykerfam, Richard, of Gorleston, tailor 1
4113543 2065123 2065123 defendant Grene William brewer 615601 615601 Grene, William, of Gorleston, brewer 0
4121661 2068043 2068043 defendant Stevenson John husbandman 615601 615601 Stevenson, John, of Gorleston, husbandman 0
4121664 2068044 2068044 defendant Stevenson John husbandman 615601 615601 Stevenson, John, of Gorleston, husbandman 0
4125740 2069489 2069489 defendant Myngey Robert cooper 615601 615601 Myngey, Robert, of Gorleston, cooper 2
4128301 2070405 2070405 defendant Braunche John tailor 615601 615601 Braunche, John, of Gorleston, tailor 3
4147433 2077243 2077243 defendant Stockes Kphn   615601 615601 Stockes, Kphn, of Gorleston, Suff, sailor 1
4147436 2077244 2077244 defendant Stockes John   615601 615601 Stockes, John, of Gorleston, Suff, sailor 1
4204030 2096962 2096962 defendant Grene William yeoman 615601 615601 Grene, William, of Gorleston, yeoman 0
4204031 2096962 2096962 defendant Wilson Anthony thatcher 615601 615601 Wilson, Anthony, of Gorleston, thatcher 1
4221251 2102931 2102931 defendant Glover William yeoman 615601 615601 Glover, William, of Gorleston, yeoman 2
4222202 2103257 2103257 defendant Gylbert Robert yeoman 615601 615601 Gylbert, Robert, of Gorleston, yeoman 0
4231086 2106373 2106373 defendant Grene William beer brewer 615601 615601 Grene, William, of Gorleston, yeoman, beer brewer 0
4243416 2110790 2110790 defendant Ives John mariner 615601 615601 Ives, John, of Gorleston, mariner 1
4243417 2110790 2110790 defendant Shynn or Shynner John husbandman 615601 615601 Shynn or Shynner, John, of Gorleston, husbandman 2
4243418 2110790 2110790 defendant Nepe Hugh husbandman 615601 615601 Nepe, Hugh, of Gorleston, husbandman 3
4244245 2111061 2111061 defendant Vincent William carpenter 615601 615601 Vincent, William, of Gorleston, carpenter 0
4244362 2111091 2111091 defendant Nepe Hugh husbandman 615601 615601 Nepe, Hugh, of Gorleston, husbandman 3
4244367 2111092 2111092 defendant Nepe Hugh husbandman 615601 615601 Nepe, Hugh, of Gorleston, husbandman 3
4250977 2113307 2113307 defendant Chaplyn John innholder 615601 615601 Chaplyn, John, of Gorleston, innholder 1
4262626 2117168 2117168 defendant Grene William beer brewer 615601 615601 Grene, William, of Gorleston, yeoman, beer brewer 0
4275860 2121506 2121506 defendant Jurden Robert husbandman 615601 615601 Jurden, Robert, of Gorleston, husbandman 1
4278815 2122529 2122529 defendant Gedge John yeoman 615601 615601 Gedge, John, of Gorleston, yeoman 0
4278816 2122529 2122529 defendant Ives John   615601 615601 Ives, John, of Gorleston, sailor 1
4278817 2122529 2122529 defendant Botwright John   615601 615601 Botwright, John, of Gorleston, sailor 2
4278827 2122531 2122531 defendant Ives John   615601 615601 Ives, John, of Gorleston, sailor 2
4278835 2122534 2122534 defendant Wolward Richard   615601 615601 Wolward, Richard, of Gorleston, sailor 0
4278836 2122534 2122534 defendant Byrde Thomas   615601 615601 Byrde, Thomas, of Gorleston, sailor 1
4278837 2122534 2122534 defendant Dyverse John   615601 615601 Dyverse, John, of Gorleston, sailor 2
4280668 2123142 2123142 defendant Rooke John tailor 615601 615601 Rooke, John, of Gorleston, tailor 0
4307124 2132628 2132628 defendant Warde William innholder 615601 615601 Warde, William, of Gorleston, innholder 0
4307125 2132628 2132628 defendant Gilbarte Robert innholder 615601 615601 Gilbarte, Robert, of Gorleston, innholder 1
4311725 2134243 2134243 defendant Ives John   615601 615601 Ives, John, of Gorleston, or of Lowestoft, sailor 0
4334432 2141794 2141794 defendant Greene William beer brewer 615601 615601 Greene, William, of Gorleston, beer brewer 1
4347729 2146452 2146452 defendant Brothers Robert innkeeper 615601 615601 Brothers, Robert, of Gorleston, innkeeper 3
4386611 2160198 2160198 defendant Baxter Thomas yeoman 615601 615601 Baxter, Thomas, of Gorleston, yeoman 3
4389285 2161044 2161044 defendant Thacker John husbandman 615601 615601 Thacker, John, of Gorleston, husbandman 0
4399428 2164396 2164396 defendant Swayne William butcher 615601 615601 Swayne, William, of Gorleston, butcher 2
4400456 2164747 2164747 defendant Sweyne William butcher 615601 615601 Sweyne, William, of Gorleston, butcher 0
4409450 2167757 2167757 defendant Rooke or Rocke John tailor 615601 615601 Rooke or Rocke, John, of Gorleston, tailor 1
4451922 2185584 2185584 defendant Welewryght John   615601 615601 Welewryght, John, of Gorleston 1
4451923 2185584 2185584 defendant Mellere Denis   615601 615601 Mellere, Denis, of Gorleston 2
4485617 2196208 2196208 defendant Clerk John shipman 615601 615601 Clerk, John, of Gorleston, shipman 0
4492993 2198508 2198508 defendant Sybbesson Thomas   615601 615601 Sybbesson, Thomas, of Gorleston 0
4492994 2198508 2198508 defendant Hercol John   615601 615601 Hercol, John, of Gorleston 1
4494367 2198932 2198932 plaintiff Bonkes William   615601 615601 Bonkes, William, of Gorleston, on his own account 0
4494368 2198932 2198932 defendant Underwode William   615601 615601 Underwode, William, of Gorleston 0
4499228 2200409 2200409 defendant Holdelyn Geoffrey   615601 615601 Holdelyn, Geoffrey, of Gorleston 0
4519337 2206407 2206407 defendant Jeet John   615601 615601 Jeet, John, of Gorleston 0
4542492 2213537 2213537 defendant Assheman William   615601 615601 Assheman, William, of Gorleston 0
4567604 2221434 2221434 defendant Bokes William chapman 615601 615601 Bokes, William, of Gorleston, chapman 2

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