names

2,425 rows where place_id = 585933

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587528 1863748 1863748 plaintiff Albon William   585933 585933 Albon, William, of Great Yarmouth 0
3590408 1864644 1864644 defendant Lame or Laine Robert yeoman 585933 585933 Lame or Laine, Robert, of Great Yarmouth, yeoman 0
3590409 1864644 1864644 defendant Redessen or Redeffen Nicholas yeoman 585933 585933 Redessen or Redeffen, Nicholas, of Great Yarmouth, yeoman 1
3590410 1864644 1864644 defendant Howse Robert yeoman 585933 585933 Howse, Robert, of Great Yarmouth, yeoman 2
3590411 1864644 1864644 defendant Coweper Edmund yeoman 585933 585933 Coweper, Edmund, of Great Yarmouth, yeoman 3
3590412 1864644 1864644 defendant Swell Alice widow 585933 585933 Swell, Alice, of Great Yarmouth, widow 4
3590494 1864672 1864672 defendant Moye Christopher merchant 585933 585933 Moye, Christopher, of Great Yarmouth, merchant 0
3591899 1865080 1865080 defendant Thorysby Edmund (legal representative) 585933 585933 Thorysby, Edmund, of Great Yarmouth, merchant, executor of 0
3591900 1865080 1865080 defendant Moye Christopher merchant 585933 585933 Moye, Christopher, of Great Yarmouth, merchant 1
3592147 1865163 1865163 defendant Moy Christopher merchant 585933 585933 Moy, Christopher, of Great Yarmouth, merchant 0
3592583 1865298 1865298 plaintiff Goode Petronilla (legal representative) 585933 585933 Goode, Petronilla, of Great Yarmouth, widow of Goode, John, of Assch, gent, executor of 0
3592584 1865298 1865298 plaintiff Herun William   585933 585933 Herun, William, of Great Yarmouth 1
3592587 1865299 1865299 plaintiff Goode Petronilla (legal representative) 585933 585933 Goode, Petronilla, of Great Yarmouth, widow of Goode, John, of Assch, gent, executor of 0
3592588 1865299 1865299 plaintiff Herun William   585933 585933 Herun, William, of Great Yarmouth 1
3592590 1865300 1865300 plaintiff Goode Petronilla (legal representative) 585933 585933 Goode, Petronilla, of Great Yarmouth, widow of Goode, John, of Assh, gent, executor of 0
3592591 1865300 1865300 plaintiff Herun William   585933 585933 Herun, William, of Great Yarmouth 1
3592594 1865301 1865301 plaintiff Goode Petronilla (legal representative) 585933 585933 Goode, Petronilla, of Great Yarmouth, widow of Goode, John, of Assh, gent, executor of 0
3592595 1865301 1865301 plaintiff Herun William   585933 585933 Herun, William, of Great Yarmouth 1
3601114 1868011 1868011 plaintiff Albon Robert   585933 585933 Albon, Robert, of Great Yarmouth 0
3601444 1868110 1868110 defendant Perys John merchant 585933 585933 Perys, John, of Great Yarmouth, merchant 1
3602135 1868332 1868332 defendant Byddyng William merchant 585933 585933 Byddyng, William, of Great Yarmouth, merchant 0
3602136 1868332 1868332 defendant Covyn Seman merchant 585933 585933 Covyn, Seman, of Great Yarmouth, merchant 1
3603913 1868895 1868895 defendant Beverley John draper 585933 585933 Beverley, John, of Great Yarmouth, draper 4
3604305 1869011 1869011 plaintiff Gloys Thomas   585933 585933 Gloys, Thomas, of Great Yarmouth 0
3604473 1869066 1869066 defendant Pullet Thomas (legal representative) 585933 585933 Pullet, Thomas, of Great Yarmouth, chaplain, executors of 7
3604474 1869066 1869066 defendant Gloys Thomas merchant 585933 585933 (Gloys, Thomas, of Great Yarmouth, merchant 8
3604475 1869066 1869066 defendant Cappe Roger yeoman 585933 585933 Cappe, Roger, of Great Yarmouth, yeoman 9
3604672 1869124 1869124 defendant Moy Christopher merchant 585933 585933 Moy, Christopher, of Great Yarmouth, merchant 0
3604674 1869124 1869124 defendant Peers Edmund merchant 585933 585933 Peers, Edmund, of Great Yarmouth, merchant 2
3605396 1869355 1869355 plaintiff Jamys John   585933 585933 Jamys, John, of Great Yarmouth 0
3608092 1870183 1870183 defendant Swelle Robert (legal representative) 585933 585933 Swelle, Robert, of Great Yarmouth, yeoman, administratrix of 0
3608093 1870183 1870183 defendant Swelle Alice widow 585933 585933 Swelle, Alice, of Great Yarmouth, widow 1
3608309 1870256 1870256 defendant Boyden John merchant 585933 585933 Boyden, John, of Great Yarmouth, merchant 1
3608972 1870463 1870463 defendant Albon Robert merchant 585933 585933 Albon, Robert, of Great Yarmouth, merchant 5
3609274 1870561 1870561 defendant Albon Robert merchant 585933 585933 Albon, Robert, of Great Yarmouth, merchant 4
3609280 1870562 1870562 defendant Albon Robert merchant 585933 585933 Albon, Robert, of Great Yarmouth, merchant 4
3609356 1870586 1870586 defendant Ilberd Henry dyer 585933 585933 Ilberd, Henry, of Great Yarmouth, dyer 1
3612949 1871696 1871696 defendant Manne Robert cordwainer 585933 585933 Manne, Robert, of Great Yarmouth, cordwainer 0
3613371 1871827 1871827 defendant Perys John merchant 585933 585933 Perys, John, of Great Yarmouth, merchant 0
3614780 1872274 1872274 plaintiff Buxston William   585933 585933 Buxston, William, of Great Yarmouth 0
3615007 1872337 1872337 defendant Elmam or Elinam John innholder 585933 585933 Elmam or Elinam, John, of Great Yarmouth, innholder 0
3615817 1872588 1872588 plaintiff Couper Edmund merchant 585933 585933 Couper, Edmund, of Great Yarmouth, merchant 0
3615917 1872618 1872618 defendant Medylton John yeoman 585933 585933 Medylton, John, of Great Yarmouth, yeoman 2
3615965 1872627 1872627 defendant Couper Edmund yeoman 585933 585933 Couper, Edmund, of Great Yarmouth, yeoman 0
3619993 1873823 1873823 defendant Drye John yeoman 585933 585933 Drye, John, of Great Yarmouth, yeoman 4
3620290 1873925 1873925 defendant Woldwarde Robert mariner 585933 585933 Woldwarde, Robert, of Great Yarmouth, mariner 2
3620291 1873925 1873925 defendant Waller Thomas yeoman 585933 585933 Waller, Thomas, of Great Yarmouth, yeoman 3
3622238 1874490 1874490 defendant Thurston Robert merchant 585933 585933 Thurston, Robert, of Great Yarmouth, merchant 1
3622365 1874531 1874531 defendant Thurston Robert merchant 585933 585933 Thurston, Robert, of Great Yarmouth, merchant 1
3623247 1874799 1874799 defendant Rokesby Osbert merchant 585933 585933 Rokesby, Osbert, of Great Yarmouth, merchant 0
3623248 1874799 1874799 defendant Thurston Robert merchant 585933 585933 Thurston, Robert, of Great Yarmouth, merchant 1
3623250 1874800 1874800 defendant Rokysby Osbart merchant 585933 585933 Rokysby, Osbart, of Great Yarmouth, merchant 0
3623251 1874800 1874800 defendant Thurston Robert merchant 585933 585933 Thurston, Robert, of Great Yarmouth, merchant 1
3623253 1874801 1874801 defendant Rokysby Osbert merchant 585933 585933 Rokysby, Osbert, of Great Yarmouth, merchant 0
3623254 1874801 1874801 defendant Thurston Robert merchant 585933 585933 Thurston, Robert, of Great Yarmouth, merchant 1
3623671 1874936 1874936 defendant Lambe William barker 585933 585933 Lambe, William, of Great Yarmouth, barker 0
3623672 1874936 1874936 defendant Thurward William cooper 585933 585933 Thurward, William, of Great Yarmouth, cooper 1
3623673 1874936 1874936 defendant Skarbourgh William yeoman 585933 585933 Skarbourgh, William, of Great Yarmouth, yeoman 2
3623674 1874936 1874936 defendant Note John smith 585933 585933 Note, John, of Great Yarmouth, smith 3
3624023 1875047 1875047 defendant Wattys Mathew mariner 585933 585933 Wattys, Mathew, of Great Yarmouth, mariner 0
3624261 1875121 1875121 plaintiff Tanne John   585933 585933 Tanne, John, of Great Yarmouth 0
3628285 1903707 1903707 defendant Breese Abram butcher 585933 585933 Breese, Abram, of Great Yarmouth, butcher 0
3630347 1904330 1904330 defendant Bayneard Thomas gent 585933 585933 Bayneard, Thomas, of Great Yarmouth, gent 8
3631187 1904578 1904578 defendant Pays Margaret widow 585933 585933 Pays Margaret, of Great Yarmouth, widow 1
3631301 1904602 1904602 defendant Ufford Thomas merchant 585933 585933 Ufford, Thomas, of Great Yarmouth, merchant 9
3635369 1905858 1905858 plaintiff Palmer John gent 585933 585933 Palmer, John, of Great Yarmouth, gent 0
3635495 1905898 1905898 defendant Mynne John   585933 585933 Mynne, John, of Great Yarmouth, paten maker 2
3636602 1906238 1906238 defendant Beamount Henry merchant 585933 585933 Beamount, Henry, of Great Yarmouth, merchant 0
3640432 1907439 1907439 plaintiff Aldyreche William   585933 585933 Aldyreche, William, of Great Yarmouth 0
3641211 1907702 1907702 plaintiff Belle William (legal representative) 585933 585933 Belle, William, of Great Yarmouth, carpenter, executrix of 0
3641214 1907703 1907703 plaintiff Belle William (legal representative) 585933 585933 Belle, William, of Great Yarmouth, carpenter, executrix of 0
3642481 1908092 1908092 defendant Wryght John merchant 585933 585933 Wryght, John, of Great Yarmouth, merchant 2
3642518 1908101 1908101 defendant Wright John merchant 585933 585933 Wright, John, of Great Yarmouth, merchant 1
3645537 1909002 1909002 defendant Palmer Richard merchant 585933 585933 Palmer, Richard, of Great Yarmouth, merchant 0
3646677 1909365 1909365 plaintiff Jamys Isabel widow 585933 585933 Jamys, Isabel, of Great Yarmouth, widow 0
3647244 1909524 1909524 plaintiff Larke William (legal representative) 585933 585933 Larke, William, of Great Yarmouth, carpenter, executrix of 0
3647323 1909549 1909549 defendant Godfrey John shoemaker 585933 585933 (Godfrey, John, of Great Yarmouth, shoemaker 1
3647858 1909727 1909727 defendant Broune Christopher yeoman 585933 585933 Broune, Christopher, of Great Yarmouth, yeoman 0
3647864 1909728 1909728 defendant Wryght John chapman 585933 585933 Wryght, John, of Great Yarmouth, chapman 4
3648240 1909847 1909847 defendant Watson Henry scrivener 585933 585933 Watson, Henry, of Great Yarmouth, scrivener 0
3648855 1910030 1910030 defendant Halyday William husbandman 585933 585933 Halyday, William, of Great Yarmouth, husbandman 2
3648856 1910031 1910031 plaintiff Palmer John gent 585933 585933 Palmer, John, of Great Yarmouth, gent 0
3648858 1910032 1910032 plaintiff Palmer John gent 585933 585933 Palmer, John, of Great Yarmouth, gent 0
3649025 1910084 1910084 plaintiff Pays Margaret widow 585933 585933 Pays, Margaret, of Great Yarmouth, widow 1
3650255 1910452 1910452 defendant Pere Robert yeoman 585933 585933 Pere, Robert, of Great Yarmouth, yeoman 1
3651931 1910951 1910951 defendant Curson Thomas clerk 585933 585933 Curson, Thomas, of Great Yarmouth, clerk 0
3656099 1912161 1912161 plaintiff Bysshop Robert merchant 585933 585933 Bysshop, Robert, of Great Yarmouth, merchant 0
3656596 1912317 1912317 defendant Hilbert Henry dyer 585933 585933 Hilbert, Henry, of Great Yarmouth, dyer 1
3659759 1913306 1913306 defendant Palmer Richard merchant 585933 585933 Palmer, Richard, of Great Yarmouth, merchant 0
3660987 1913709 1913709 defendant Bettys Thomas haberdasher 585933 585933 Bettys, Thomas, of Great Yarmouth, haberdasher 0
3660994 1913712 1913712 defendant Deynys Thomas merchant 585933 585933 Deynys, Thomas, of Great Yarmouth, merchant 0
3663622 1914554 1914554 defendant Eynglysh Richard   585933 585933 Eynglysh, Richard, of Great Yarmouth, mason 0
3665263 1915088 1915088 defendant James John (legal representative) 585933 585933 James, John, of Great Yarmouth, merchant, executrix of 1
3665560 1915179 1915179 plaintiff Sterlyng James   585933 585933 Sterlyng, James, of Great Yarmouth 0
3665594 1915188 1915188 defendant Lynsey John mariner 585933 585933 Lynsey, John, of Great Yarmouth, mariner 0
3665596 1915188 1915188 defendant Persse Robert merchant 585933 585933 Persse, Robert, of Great Yarmouth, merchant 2
3665908 1915274 1915274 defendant Alexander Robert yeoman 585933 585933 Alexander, Robert, of Great Yarmouth, yeoman 0
3665910 1915274 1915274 defendant Couper Edmund merchant 585933 585933 Couper, Edmund, of Great Yarmouth, merchant 2
3670986 1916899 1916899 defendant Prente Thomas smith 585933 585933 Prente, Thomas, of Great Yarmouth, smith 0
3671424 1917041 1917041 defendant Hyberd Henry dyer 585933 585933 Hyberd, Henry, of Great Yarmouth, dyer 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);