names

355 rows where place_id = 590243

✎ 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
3600353 1867755 1867755 defendant Toly John pedder 590243 590243 Toly, John, of Newmarket, pedder 0
3628235 1903689 1903689 defendant Balard Robert baker 590243 590243 Balard, Robert, of Newmarket, baker 2
3631234 1904592 1904592 defendant Barker John   590243 590243 Barker, John, of Newmarket 0
3631235 1904592 1904592 defendant Couper William   590243 590243 Couper, William, of Newmarket 1
3631236 1904592 1904592 defendant Holyngworth Robert   590243 590243 Holyngworth, Robert, of Newmarket 2
3631237 1904592 1904592 defendant Jurden Henry   590243 590243 Jurden, Henry, of Newmarket 3
3631238 1904592 1904592 defendant Whitwall John   590243 590243 Whitwall, John, of Newmarket 4
3631239 1904592 1904592 defendant Sadler Ralph   590243 590243 Sadler, Ralph, of Newmarket 5
3631240 1904592 1904592 defendant Teverham or Tenerham John   590243 590243 Teverham or Tenerham, John, of Newmarket 6
3631241 1904592 1904592 defendant Harrison John   590243 590243 Harrison, John, of Newmarket 7
3631242 1904592 1904592 defendant Love John, senior   590243 590243 Love, John, senior, of Newmarket 8
3631243 1904592 1904592 defendant Love John, junior   590243 590243 Love, John, junior, of Newmarket 9
3632714 1905049 1905049 defendant Myller William miller 590243 590243 Myller, William, of Newmarket, miller 2
3633487 1905287 1905287 defendant Charke John smith 590243 590243 Charke, John, of Newmarket, smith 2
3635557 1905925 1905925 defendant Ballard Robert baker 590243 590243 Ballard, Robert, of Newmarket, baker 0
3635558 1905925 1905925 defendant Trolle John fletcher 590243 590243 Trolle, John, of Newmarket, fletcher 1
3636371 1906165 1906165 defendant Jordon Henry fishmonger 590243 590243 Jordon, Henry, of Newmarket, fishmonger 1
3639566 1907184 1907184 defendant Folkys William husbandman 590243 590243 Folkys, William, of Newmarket, husbandman 1
3640783 1907563 1907563 defendant Harryes Robert yeoman 590243 590243 Harryes, Robert, of Newmarket, yeoman 1
3641805 1907886 1907886 defendant Couper William innholder 590243 590243 Couper, William, of Newmarket, innholder 0
3641921 1907925 1907925 defendant Papworth John pedder 590243 590243 Papworth, John, of Newmarket, pedder 6
3641923 1907925 1907925 defendant Whytall John pedder 590243 590243 Whytall, John, of Newmarket, pedder 8
3642172 1908000 1908000 defendant Horne Ralph shoemaker 590243 590243 Horne, Ralph, of Newmarket, shoemaker 0
3642174 1908001 1908001 defendant Horne Ralph shoemaker 590243 590243 Horne, Ralph, of Newmarket, shoemaker 0
3646359 1909255 1909255 defendant Jurdon Henry fishmonger 590243 590243 Jurdon, Henry, of Newmarket, fishmonger 1
3646365 1909256 1909256 defendant Jurden Henry fishmonger 590243 590243 Jurden, Henry, of Newmarket, fishmonger 1
3659149 1913118 1913118 defendant Porter Thomas   590243 590243 Porter, Thomas, of Newmarket, pedlar 0
3662066 1914065 1914065 defendant Horne Ralph carpenter 590243 590243 Horne, Ralph, of Newmarket, shoe maker, smyth, John, of Kersey, carpenter 8
3662086 1914066 1914066 defendant Horne Ralph carpenter 590243 590243 Horne, Ralph, of Newmarket, shoe maker, smyth, John, of Kersey, carpenter 9
3682514 1920633 1920633 defendant Tyllet William mercer 590243 590243 Tyllet, William, of Newmarket, mercer 0
3693456 1924165 1924165 defendant Gylmer Joan widow 590243 590243 Gylmer, Joan, of Newmarket, widow 12
3695775 1924909 1924909 defendant Holmehed Nicholas (legal representative) 590243 590243 Holmehed, Nicholas, of Newmarket, executrix of 0
3703008 1927215 1927215 plaintiff Couper alias Parmenter William   590243 590243 Couper alias Parmenter, William, of Newmarket 0
3703010 1927215 1927215 defendant Wynshippe William hosteler 590243 590243 Wynshippe, William, of Newmarket, hosteler 1
3703018 1927218 1927218 defendant Haryson Robert husbandman 590243 590243 Haryson, Robert, of Newmarket, husbandman 1
3703019 1927218 1927218 defendant Nyghtyngale William laborer 590243 590243 Nyghtyngale, William, of Newmarket, laborer 2
3706166 1928220 1928220 defendant Love alias Rider John husbandman 590243 590243 Love alias Rider, John, of Newmarket, husbandman 0
3706168 1928221 1928221 defendant Thrower Thomas yeoman 590243 590243 Thrower, Thomas, of Newmarket, yeoman 0
3720278 1932620 1932620 defendant Throwar Margaret widow 590243 590243 Throwar, Margaret, of Newmarket, widow 2
3723415 1933590 1933590 defendant Lilye John yeoman 590243 590243 Lilye, John, of Newmarket, yeoman 0
3726331 1934504 1934504 defendant Papworth John pedder 590243 590243 Papworth, John, of Newmarket, pedder 0
3742185 1939424 1939424 plaintiff Throwar Thomas husbandman 590243 590243 Throwar, Thomas, of Newmarket, husbandman 0
3742186 1939424 1939424 defendant Horne Ralph whitawer 590243 590243 Horne, Ralph, of Newmarket, whitawer 0
3742189 1939425 1939425 defendant Ray Robert husbandman 590243 590243 Ray, Robert, of Newmarket, husbandman 1
3757684 1944383 1944383 plaintiff Borowdale Thomas yeoman 590243 590243 Borowdale, Thomas, of Newmarket, yeoman 0
3761168 1945496 1945496 defendant Papeford John fishmonger 590243 590243 Papeford, John, of Newmarket, fishmonger 1
3770168 1948337 1948337 defendant Whytale John (legal representative) 590243 590243 Whytale, John, of Newmarket, yeoman, executrix of 0
3773510 1949426 1949426 defendant Gylberd John pedder 590243 590243 Gylberd, John, of Newmarket, pedder 0
3773712 1949495 1949495 defendant Trevy alias Tremyn John yeoman 590243 590243 Trevy alias Tremyn, John, of Newmarket, yeoman 0
3774590 1949779 1949779 defendant Treve John husbandman 590243 590243 Treve, John, of Newmarket, husbandman 1
3775364 1950036 1950036 defendant Kene John tailor 590243 590243 Kene, John, of Newmarket, tailor 0
3775365 1950036 1950036 defendant Troby John husbandman 590243 590243 Troby, John, of Newmarket, husbandman 1
3778397 1950959 1950959 defendant Treve John husbandman 590243 590243 Treve, John, of Newmarket, husbandman 3
3779384 1951274 1951274 defendant Paperford John fishmonger 590243 590243 Paperford, John, of Newmarket, fishmonger 1
3782556 1952286 1952286 defendant Treve John husbandman 590243 590243 Treve, John, of Newmarket, husbandman 0
3782558 1952287 1952287 defendant Treve John husbandman 590243 590243 Treve, John, of Newmarket, husbandman 0
3784069 1952798 1952798 defendant Chaundeler John husbandman 590243 590243 Chaundeler, John, of Newmarket, husbandman 0
3787087 1953756 1953756 defendant Trayvyn John yeoman 590243 590243 Trayvyn, John, of Newmarket, yeoman 0
3789614 1954582 1954582 defendant Thrower Thomas pedder 590243 590243 Thrower, Thomas, of Newmarket, pedder 0
3792269 1955434 1955434 defendant Treve John husbandman 590243 590243 Treve, John, of Newmarket, husbandman 2
3793236 1955744 1955744 defendant Turvey John yeoman 590243 590243 Turvey, John, of Newmarket, yeoman 0
3795491 1956470 1956470 defendant Chaundeler John baker 590243 590243 Chaundeler, John, of Newmarket, baker 0
3795492 1956470 1956470 defendant Trevy John husbandman 590243 590243 Trevy, John, of Newmarket, husbandman 1
3802623 1958716 1958716 defendant Beste John yeoman 590243 590243 Beste, John, of Newmarket, yeoman 0
3802628 1958717 1958717 defendant Chaundeler John bajer 590243 590243 Chaundeler, John, of Newmarket, bajer 0
3803363 1958951 1958951 defendant Traybyn John yeoman 590243 590243 Traybyn, John, of Newmarket, yeoman 0
3808746 1960613 1960613 defendant Albrey Nicholas rippier 590243 590243 Albrey, Nicholas, of Newmarket, rippier 0
3819035 1963845 1963845 defendant Walter alias Lorde Robert   590243 590243 Walter alias Lorde, Robert, of Newmarket, parchment maker 0
3835537 1969054 1969054 defendant Kyng William husbandman 590243 590243 Kyng, William, of Newmarket, husbandman 0
3844474 1971817 1971817 defendant Papworth John pedder 590243 590243 Papworth, John, of Newmarket, pedder 0
3854836 1975157 1975157 defendant Kyng William husbandman 590243 590243 Kyng, William, of Newmarket, husbandman 0
3854864 1975166 1975166 defendant Kynge William husbandman 590243 590243 Kynge, William, of Newmarket, husbandman 0
3854867 1975167 1975167 defendant Kyng William husbandman 590243 590243 Kyng, William, of Newmarket, husbandman 0
3857588 1976006 1976006 defendant Cherke John smith 590243 590243 Cherke, John, of Newmarket, smith 1
3858225 1976228 1976228 defendant Pryor Robert shoemaker 590243 590243 Pryor, Robert, of Newmarket, shoemaker 3
3874618 1981730 1981730 defendant Papworthe John pedder 590243 590243 Papworthe, John, of Newmarket, pedder 3
3880173 1983622 1983622 defendant Papworth John fishmonger 590243 590243 Papworth, John, of Newmarket, fishmonger 0
3884011 1984922 1984922 defendant Brian John barker 590243 590243 Brian, John, of Newmarket, barker 2
3885472 1985398 1985398 defendant Funston Henry yeoman 590243 590243 Funston, Henry, of Newmarket, yeoman 0
3902219 1990979 1990979 plaintiff Dowe Thomas   590243 590243 Dowe, Thomas, of Newmarket 0
3907128 1992675 1992675 defendant Kyng William   590243 590243 Kyng, William, of Newmarket, "pedder" 1
3913254 1994763 1994763 defendant Papworth Robert pedder 590243 590243 Papworth, Robert, of Newmarket, pedder 0
3954333 2008585 2008585 defendant Rychardson Thomas butcher 590243 590243 Rychardson, Thomas, of Newmarket, butcher 0
3986567 2019935 2019935 defendant Hudsone George shoemaker 590243 590243 Hudsone, George, of Newmarket, shoemaker 3
3986635 2019959 2019959 defendant Wryght John tailor 590243 590243 Wryght, John, of Newmarket, tailor 2
4020104 2031912 2031912 defendant Murdon or Mordon Mathew tailor 590243 590243 Murdon or Mordon, Mathew, of Newmarket, tailor 1
4020105 2031912 2031912 defendant Myddleditche John yeoman 590243 590243 Myddleditche, John, of Newmarket, yeoman 2
4025830 2033889 2033889 defendant Chaundeler William husbandman 590243 590243 Chaundeler, William, of Newmarket, husbandman 4
4027786 2034588 2034588 defendant Metcalfe John   590243 590243 Metcalfe, John, of Newmarket, wheelwright 0
4027787 2034588 2034588 defendant Morden Mathew tailor 590243 590243 Morden, Mathew, of Newmarket, tailor 1
4034983 2037193 2037193 defendant Mideldyche John yeoman 590243 590243 Mideldyche, John, of Newmarket, yeoman 0
4076025 2051723 2051723 defendant Kynge John yeoman 590243 590243 Kynge, John, of Newmarket, yeoman 0
4076026 2051723 2051723 defendant Stavers Thomas husbandman 590243 590243 Stavers, Thomas, of Newmarket, husbandman 1
4111207 2064258 2064258 defendant Buller Joseph poulter 590243 590243 Buller, Joseph, of Newmarket, poulter 0
4129822 2070976 2070976 defendant Ayers David yeoman 590243 590243 Ayers, David, of Newmarket, yeoman 0
4194090 2093487 2093487 defendant Jennyng John beer brewer 590243 590243 Jennyng, John, of Newmarket, beer brewer 1
4204785 2097218 2097218 defendant Wilson Robert fishmonger 590243 590243 Wilson, Robert, of Newmarket, fishmonger 3
4211891 2099707 2099707 defendant Kynge John yeoman 590243 590243 Kynge, John, of Newmarket, yeoman 0
4221699 2103079 2103079 defendant Midledich John gent 590243 590243 Midledich, John, of Newmarket, gent 1
4333048 2141340 2141340 defendant Pyckes John yeoman 590243 590243 Pyckes, John, of Newmarket, yeoman 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);