names

1,052 rows where place_id = 590061

✎ 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
3594295 1865851 1865851 defendant Cleseby Thomas husbandman 590061 590061 Cleseby, Thomas, of Barton on Humber, husbandman 2
3594304 1865852 1865852 defendant Cleseby Thomas husbandman 590061 590061 Cleseby, Thomas, of Barton on Humber, husbandman 5
3594891 1866031 1866031 defendant Alanson Richard (legal representative) 590061 590061 Alanson, Richard, of Barton on Humber, tanner, executors of 0
3594893 1866031 1866031 defendant Ferybe John yeoman 590061 590061 Ferybe, John, of Barton on Humber, yeoman 2
3594894 1866031 1866031 defendant Hyndshawe Thomas yeoman 590061 590061 Hyndshawe, Thomas, of Barton on Humber, yeoman 3
3594897 1866032 1866032 defendant Alanson Richard (legal representative) 590061 590061 Alanson, Richard, of Barton on Humber, tanner, executors of 0
3594899 1866032 1866032 defendant God Robert yeoman 590061 590061 God, Robert, of Barton on Humber, yeoman 2
3594900 1866032 1866032 defendant Hyndshawe Thomas yeoman 590061 590061 Hyndshawe, Thomas, of Barton on Humber, yeoman 3
3599747 1867564 1867564 defendant Salter Richard husbandman 590061 590061 Salter, Richard, of Barton, husbandman 2
3600173 1867706 1867706 defendant Sharlton William husbandman 590061 590061 Sharlton, William, of Barton on Humber, husbandman 1
3600183 1867707 1867707 defendant Wright Robert yeoman 590061 590061 Wright, Robert, of Barton on Humber, yeoman 4
3604729 1869143 1869143 defendant Brewes Thomas yeoman 590061 590061 (Brewes, Thomas, of Barton, yeoman 1
3604730 1869143 1869143 defendant Breuys Agnes widow 590061 590061 Breuys, Agnes, of Barton, widow 2
3610678 1871006 1871006 defendant Assheton John yeoman 590061 590061 Assheton, John, of Barton, yeoman 1
3622804 1874663 1874663 defendant Barton Thomas butcher 590061 590061 Barton, Thomas, of Barton on Humber, butcher 0
3622805 1874663 1874663 defendant Farnell or Farvell Thomas butcher 590061 590061 Farnell or Farvell, Thomas, of Barton on Humber, butcher 1
3623013 1874725 1874725 defendant Crede Henry yeoman 590061 590061 Crede, Henry, of Barton, yeoman 0
3624298 1875134 1875134 defendant Marley Thomas merchant 590061 590061 Marley, Thomas, of Barton on Humber, merchant 1
3629511 1904087 1904087 defendant Wulcy Richard husbandman 590061 590061 Wulcy, Richard, of Barton, husbandman 0
3630595 1904398 1904398 defendant Jakson John husbandman 590061 590061 Jakson, John, of Barton on Humber, husbandman 1
3631532 1904678 1904678 defendant Marley Richard merchant of the staple 590061 590061 Marley, Richard, of Barton on Humber, merchant of the staple 0
3633209 1905200 1905200 defendant Crowche John butcher 590061 590061 Crowche, John, of Barton, butcher 0
3640352 1907412 1907412 plaintiff A Dene Thomas   590061 590061 A Dene, Thomas, of Barton 0
3643151 1908297 1908297 defendant Bryan Robert (legal representative) 590061 590061 Bryan, Robert, of Barton on Humber, executors of 0
3643153 1908297 1908297 defendant Bryan Elizabeth widow 590061 590061 Bryan, Elizabeth, of Barton on Humber, widow 2
3643688 1908453 1908453 defendant Alsunder William, senior weaver 590061 590061 Alsunder, William, senior, of Barton, weaver 0
3643689 1908453 1908453 defendant Alsunder John, junior laborer 590061 590061 Alsunder, John, junior, of Barton, laborer 1
3645922 1909115 1909115 defendant Sterre William husbandman 590061 590061 Sterre, William, of Barton, husbandman 0
3646782 1909402 1909402 defendant Skypton Thomas husbandman 590061 590061 Skypton, Thomas, of Barton, husbandman 1
3646785 1909402 1909402 defendant Goldsmyth John husbandman 590061 590061 Goldsmyth, John, of Barton, husbandman 4
3648891 1910043 1910043 defendant Colbyng William husbandman 590061 590061 Colbyng, William, of Barton, husbandman 1
3648892 1910043 1910043 defendant Smythson Richard husbandman 590061 590061 Smythson, Richard, of Barton, husbandman 2
3648893 1910043 1910043 defendant Bossall Conand husbandman 590061 590061 Bossall, Conand, of Barton, husbandman 3
3648894 1910043 1910043 defendant Hughle Robert husbandman 590061 590061 Hughle, Robert, of Barton, husbandman 4
3648895 1910043 1910043 defendant Loocok Henry husbandman 590061 590061 Loocok, Henry, of Barton, husbandman 5
3652436 1911095 1911095 defendant Brande Edmund husbandman 590061 590061 Brande, Edmund, of Barton, husbandman 1
3652908 1911235 1911235 defendant Stanyforth Richard yeoman 590061 590061 Stanyforth, Richard, of Barton, yeoman 0
3656199 1912185 1912185 defendant Dorssettour John husbandman 590061 590061 Dorssettour, John, of Barton, husbandman 4
3657609 1912643 1912643 defendant Dosseter John yeoman 590061 590061 Dosseter, John, of Barton, yeoman 1
3657618 1912644 1912644 defendant Dosseter John yeoman 590061 590061 Dosseter, John, of Barton, yeoman 1
3658722 1912982 1912982 defendant Gibson Robert husbandman 590061 590061 Gibson, Robert, of Barton, husbandman 2
3668504 1916105 1916105 plaintiff Awdelet John esq 590061 590061 Awdelet, John, of Barton, esq 0
3668806 1916182 1916182 defendant Besse Richard yeoman 590061 590061 Besse, Richard, of Barton, yeoman 0
3668807 1916182 1916182 defendant Robynson John husbandman 590061 590061 Robynson, John, of Barton, husbandman 1
3668808 1916182 1916182 defendant Valiande Simon husbandman 590061 590061 Valiande, Simon, of Barton, husbandman 2
3668809 1916182 1916182 defendant Peirson Robert husbandman 590061 590061 Peirson, Robert, of Barton, husbandman 3
3668810 1916182 1916182 defendant Grethede Richard husbandman 590061 590061 Grethede, Richard, of Barton, husbandman 4
3668811 1916182 1916182 defendant Thomson John laborer 590061 590061 Thomson, John, of Barton, laborer 5
3668812 1916182 1916182 defendant Wyseman James laborer 590061 590061 Wyseman, James, of Barton, laborer 6
3668813 1916182 1916182 defendant Henne Richard weaver 590061 590061 Henne, Richard, of Barton, weaver 7
3668814 1916182 1916182 defendant Ottryngton Robert laborer 590061 590061 Ottryngton, Robert, of Barton, laborer 8
3668815 1916182 1916182 defendant Robynson Thomas laborer 590061 590061 Robynson, Thomas, of Barton, laborer 9
3668816 1916182 1916182 defendant Taillour Robert laborer 590061 590061 Taillour, Robert, of Barton, laborer 10
3668817 1916182 1916182 defendant Peirson William laborer 590061 590061 Peirson, William, of Barton, laborer 11
3668818 1916182 1916182 defendant Smyth Hugh smith 590061 590061 Smyth, Hugh, of Barton, smith 12
3672588 1917424 1917424 defendant Repton Richard yeoman 590061 590061 Repton, Richard, of Barton, yeoman 2
3672589 1917424 1917424 defendant Penyfather Thomas yeoman 590061 590061 Penyfather, Thomas, of Barton, yeoman 3
3678465 1919319 1919319 defendant Richardson Thomas butcher 590061 590061 Richardson, Thomas, of Barton on Humber, butcher 0
3685193 1921520 1921520 plaintiff Audelett John esq 590061 590061 Audelett, John, of Barton, esq 0
3685196 1921521 1921521 plaintiff Audelett John esq 590061 590061 Audelett, John, of Barton, esq 0
3685199 1921522 1921522 plaintiff Audelett John esq 590061 590061 Audelett, John, of Barton, esq 0
3685242 1921538 1921538 plaintiff Awdelet John esq 590061 590061 Awdelet, John, of Barton, esq 0
3686346 1921888 1921888 defendant Hill John maltman 590061 590061 Hill, John, of Barton, maltman 1
3686574 1921952 1921952 defendant Aunger Richard husbandman 590061 590061 Aunger, Richard, of Barton, husbandman 0
3689260 1922802 1922802 defendant Kylner Richard tailor 590061 590061 Kylner, Richard, of Barton, tailor 0
3691477 1923490 1923490 defendant Dasseter John husbandman 590061 590061 Dasseter, John, of Barton, husbandman 0
3701096 1926589 1926589 defendant Russell John husbandman 590061 590061 Russell, John, of Barton, husbandman 2
3701736 1926787 1926787 defendant Dover or Doner John husbandman 590061 590061 Dover or Doner, John, of Barton on Humber, husbandman 0
3702201 1926944 1926944 defendant Whityng John husbandman 590061 590061 Whityng, John, of Barton under Nedewode, husbandman 0
3702202 1926944 1926944 defendant Heyward Thomas husbandman 590061 590061 Heyward, Thomas, of Barton under Nedewode, husbandman 1
3705087 1927882 1927882 defendant Couper Thomas husbandman 590061 590061 Couper, Thomas, of Barton under Nedewode, husbandman 0
3705088 1927882 1927882 defendant Walker Richard cooper 590061 590061 Walker, Richard, of Barton under Nedewode, cooper 1
3705089 1927882 1927882 defendant Holland Ralph yeoman 590061 590061 Holland, Ralph, of Barton under Nedewode, yeoman 2
3725967 1934392 1934392 defendant Dossetour John husbandman 590061 590061 Dossetour, John, of Barton, husbandman 0
3725968 1934392 1934392 defendant Cokke John husbandman 590061 590061 Cokke, John, of Barton, husbandman 1
3726599 1934578 1934578 defendant Marley William merchant of the staple 590061 590061 Marley, William, of Barton on Humber, merchant of the staple 0
3727236 1934791 1934791 defendant Whytyng Richard husbandman 590061 590061 Whytyng, Richard, of Barton under Nedewode, husbandman 0
3727433 1934853 1934853 defendant Ferneley Robert yeoman 590061 590061 Ferneley, Robert, of Barton, yeoman 0
3745055 1940361 1940361 defendant Knolles William draper 590061 590061 Knolles, William, of Barton on Humber, draper 0
3751156 1942287 1942287 defendant Russell Thomas husbandman 590061 590061 Russell, Thomas, of Barton, husbandman 0
3751158 1942288 1942288 defendant Russell Thomas husbandman 590061 590061 Russell, Thomas, of Barton, husbandman 0
3752207 1942616 1942616 defendant Snellegar John husbandman 590061 590061 Snellegar, John, of Barton, husbandman 1
3754434 1943344 1943344 defendant Brian Walter (legal representative) 590061 590061 Brian, Walter, of Barton, gent, administratrix of 0
3754435 1943344 1943344 defendant Brian Eleanor widow 590061 590061 Brian, Eleanor, of Barton on Humber, widow 1
3757690 1944385 1944385 defendant Wolcy Richard   590061 590061 Wolcy, Richard, of Barton, worsted weaver 1
3762946 1946043 1946043 defendant Amys Christopher yeoman 590061 590061 Amys, Christopher, of Barton, yeoman 1
3766300 1947112 1947112 defendant Holond Thomas yeoman 590061 590061 Holond, Thomas, of Barton under Nedewode, yeoman 0
3766301 1947112 1947112 defendant Whityngall alias Whityng Ralph yeoman 590061 590061 Whityngall alias Whityng, Ralph, of Barton under Nedewode, yeoman 1
3766416 1947152 1947152 defendant Straunge Robert yeoman 590061 590061 Straunge, Robert, of Barton on Humber, yeoman 0
3770160 1948334 1948334 defendant Edward Andrew husbandman 590061 590061 Edward, Andrew, of Barton, husbandman 2
3771713 1948853 1948853 defendant Brian Walter (legal representative) 590061 590061 Brian, Walter, of Barton, gent, administratrix of 0
3771714 1948853 1948853 defendant Bryan Eleanor widow 590061 590061 Bryan, Eleanor, of Barton on Humber, widow 1
3775883 1950209 1950209 defendant Goldsmyth James husbandman 590061 590061 Goldsmyth, James, of Barton, husbandman 0
3776321 1950341 1950341 defendant Thomas Richard (legal representative) 590061 590061 Thomas, Richard, of Barton on Humber, yeoman, executors of 0
3776323 1950341 1950341 defendant Thomas Joan widow 590061 590061 Thomas, Joan, of Barton on Humber, widow 2
3778066 1950854 1950854 defendant Dawbeney John husbandman 590061 590061 Dawbeney, John, of Barton on Humber, husbandman 0
3783301 1952528 1952528 defendant Amys William grocer 590061 590061 Amys, William, of Barton, grocer 0
3785110 1953130 1953130 defendant Strange Robert husbandman 590061 590061 Strange, Robert, of Barton on Humber, husbandman 0
3785579 1953281 1953281 defendant Marley William merchant 590061 590061 Marley, William, of Barton on Humber, merchant 0
3792218 1955420 1955420 plaintiff Awdelett John esq 590061 590061 Awdelett, John, of Barton, esq 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);