names

3,421 rows where place_id = 586286

✎ 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
3588361 1864010 1864010 defendant Wylslay alias Sadiller John saddler 586286 586286 Wylslay alias Sadiller, John, of Boston, saddler 0
3589340 1864306 1864306 defendant Banke Thomas gent 586286 586286 Banke, Thomas, of Boston, gent 5
3589490 1864348 1864348 defendant Osse William mercer 586286 586286 Osse, William, of Boston, mercer 2
3591915 1865084 1865084 defendant Bankes Thomas gent 586286 586286 Bankes, Thomas, of Boston, gent 3
3594540 1865922 1865922 defendant Tymer John mercer 586286 586286 Tymer, John, of Boston, mercer 0
3595154 1866115 1866115 defendant Chaweney William merchant 586286 586286 Chaweney, William, of Boston, merchant 0
3595156 1866116 1866116 defendant Chaweney William merchant or barker 586286 586286 Chaweney, William, of Boston, merchant or barker 0
3596991 1866686 1866686 defendant Kerver alias Baxster Peter husbandman or carver 586286 586286 Kerver alias Baxster, Peter, of Boston, husbandman or carver 0
3596992 1866686 1866686 defendant Baxster John carver 586286 586286 Baxster, John, of Boston, carver 1
3597838 1866942 1866942 defendant Radclyff John gent 586286 586286 Radclyff, John, of Boston, gent 0
3598793 1867250 1867250 defendant Bellam John baker 586286 586286 Bellam, John, of Boston, baker 4
3600186 1867707 1867707 defendant Haby or Havy John pewterer 586286 586286 Haby or Havy, John, of Boston, pewterer 7
3601034 1867990 1867990 plaintiff Abry John pewterer 586286 586286 Abry, John, of Boston, pewterer 0
3601462 1868112 1868112 defendant Tymer William merchant 586286 586286 Tymer, William, of Boston, merchant 0
3603577 1868788 1868788 defendant Goodyn Richard gent 586286 586286 Goodyn, Richard, of Boston, gent 1
3606384 1869664 1869664 defendant Worsley John merchant 586286 586286 Worsley, John, of Boston, merchant 0
3607265 1869936 1869936 plaintiff Reede Thomas merchant of the staple 586286 586286 Reede, Thomas, of Boston, merchant of the staple 0
3608237 1870232 1870232 plaintiff Stoyle John merchant 586286 586286 Stoyle, John, of Boston, merchant 0
3611115 1871151 1871151 defendant Boleyn Thomas yeoman 586286 586286 Boleyn, Thomas, of Boston, yeoman 1
3613656 1871917 1871917 defendant Boleyn Thomas yeoman 586286 586286 Boleyn, Thomas, of Boston, yeoman 0
3614006 1872040 1872040 defendant Ogill William (legal representative) 586286 586286 Ogill, William, of Boston, yeoman, executor of 0
3614018 1872043 1872043 defendant Robynson William draper 586286 586286 Robynson, William, of Boston, draper 0
3614487 1872178 1872178 plaintiff Broun Alan gent 586286 586286 Broun, Alan, of Boston, gent 0
3614489 1872179 1872179 plaintiff Broun Alan gent 586286 586286 Broun, Alan, of Boston, gent 0
3616006 1872640 1872640 defendant Tatsall John laborer 586286 586286 Tatsall, John, of Boston, laborer 1
3616974 1872930 1872930 defendant Pygge Thomas (legal representative) 586286 586286 Pygge, Thomas, of Boston, executor of 0
3617753 1873177 1873177 defendant Tylney Robert esq 586286 586286 Tylney, Robert, of Boston, esq 0
3621876 1874384 1874384 defendant Webster Robert weaver 586286 586286 Webster, Robert, of Boston, weaver 0
3621877 1874384 1874384 defendant Acley John weaver 586286 586286 Acley, John, of Boston, weaver 1
3621878 1874384 1874384 defendant Fynk- John carpenter 586286 586286 Fynk-, John, of Boston, carpenter 2
3621975 1874416 1874416 plaintiff Payn John mercer 586286 586286 Payn, John, of Boston, mercer 0
3622562 1874592 1874592 defendant Pygge John esq 586286 586286 Pygge, John, of Boston, esq 3
3622867 1874680 1874680 plaintiff Robynson William draper 586286 586286 Robynson, William, of Boston, draper 0
3622869 1874681 1874681 plaintiff Robynson William draper 586286 586286 Robynson, William, of Boston, draper 0
3626629 1903178 1903178 defendant Trollop John merchant of Calais 586286 586286 Trollop, John, of Boston, or of Westminster, merchant of Calais 0
3628126 1903652 1903652 defendant Abrey Erma widow 586286 586286 Abrey, Erma, of Boston, widow 0
3632218 1904893 1904893 plaintiff Hawnby Thomas   586286 586286 Hawnby, Thomas, of Boston 0
3632373 1904944 1904944 defendant Pynchebek Leonard gent 586286 586286 Pynchebek, Leonard, of Boston, gent 0
3632374 1904944 1904944 defendant Cony or Covy William mercer 586286 586286 Cony or Covy, William, of Boston, mercer 1
3632375 1904944 1904944 defendant Hole Thomas mercer 586286 586286 Hole, Thomas, of Boston, mercer 2
3633700 1905351 1905351 plaintiff Lawpage Edward draper 586286 586286 Lawpage, Edward, of Boston, draper 0
3635382 1905862 1905862 defendant Bukland Robert yeoman 586286 586286 Bukland, Robert, of Boston, yeoman 0
3635815 1906002 1906002 defendant Hunt George husbandman 586286 586286 Hunt, George, of Boston, husbandman 1
3641083 1907654 1907654 defendant Wyllyamson Robert (legal representative) 586286 586286 Wyllyamson, Robert, of Boston, merchant, executrix of 0
3641091 1907657 1907657 defendant Wyllyamson Robert (legal representative) 586286 586286 Wyllyamson, Robert, of Boston, merchant, executrix of 0
3642785 1908191 1908191 defendant White Richard yeoman 586286 586286 White, Richard, of Boston, yeoman 1
3647807 1909708 1909708 defendant Sybsey George merchant of the staple 586286 586286 Sybsey, George, of Boston, gent, merchant of the staple 0
3647809 1909709 1909709 defendant Sybsey George merchant of the staple 586286 586286 Sybsey, George, of Boston, gent, merchant of the staple 0
3651981 1910966 1910966 defendant Howeson Nicholas merchant of the staple 586286 586286 Howeson, Nicholas, of Boston, merchant of the staple 0
3656597 1912317 1912317 defendant Whyte Robert yeoman 586286 586286 Whyte, Robert, of Boston, yeoman 2
3656704 1912349 1912349 plaintiff Hochynson John   586286 586286 Hochynson, John, of Boston 1
3669169 1916294 1916294 plaintiff Bawtrey Edward merchant 586286 586286 Bawtrey, Edward, of Boston, merchant 0
3669710 1916469 1916469 defendant Quadryng John gent 586286 586286 Quadryng, John, of Boston, gent 0
3669881 1916524 1916524 defendant Palmer Thomas gent 586286 586286 Palmer, Thomas, of Boston, gent 0
3673806 1917838 1917838 defendant Pynchebek Leonard gent 586286 586286 Pynchebek, Leonard, of Boston, gent 0
3690277 1923121 1923121 plaintiff Gayton John   586286 586286 Gayton, John, of Boston 0
3691005 1923350 1923350 defendant Percy John painter 586286 586286 Percy, John, of Boston, painter 0
3691006 1923350 1923350 defendant Rychardys John pinner 586286 586286 Rychardys, John, of Boston, pinner 1
3692456 1923821 1923821 defendant Wesenam Thomas butcher 586286 586286 Wesenam, Thomas, of Boston, butcher 0
3692458 1923822 1923822 defendant Wesenam Thomas butcher 586286 586286 Wesenam, Thomas, of Boston, butcher 0
3694314 1924427 1924427 defendant Worlton Robert cordwainer 586286 586286 Worlton, Robert, of Boston, cordwainer 0
3695061 1924666 1924666 plaintiff Penyngton Adam esq 586286 586286 Penyngton, Adam, of Boston, esq 0
3695095 1924680 1924680 defendant Penyngton Adam gent 586286 586286 Penyngton, Adam, of Boston, gent 0
3695757 1924902 1924902 defendant Markby John chaplain 586286 586286 Markby, John, of Boston, chaplain 0
3696503 1925134 1925134 defendant Totheby Richard merchant 586286 586286 Totheby, Richard, of Boston, merchant 2
3697416 1925411 1925411 defendant Broune Nicholas merchant venturer 586286 586286 Broune, Nicholas, of Boston, merchant venturer 0
3697417 1925411 1925411 defendant Glover Thomas brewer 586286 586286 Glover, Thomas, of Boston, brewer 1
3697533 1925450 1925450 defendant Hubberd Adlard mercer 586286 586286 Hubberd, Adlard, of Boston, mercer 0
3697981 1925593 1925593 defendant Waltham Thomas baker 586286 586286 Waltham, Thomas, of Boston, baker 0
3698504 1925751 1925751 defendant Pape John draper 586286 586286 Pape, John, of Boston, draper 2
3699185 1925958 1925958 defendant Pulvertoft Robert gent 586286 586286 Pulvertoft, Robert, of Boston, gent 1
3699188 1925959 1925959 defendant Pulvertoft Robert gent 586286 586286 Pulvertoft, Robert, of Boston, gent 1
3706267 1928247 1928247 plaintiff Hubberd Adelard merchant of the staple 586286 586286 Hubberd, Adelard, of Boston, merchant of the staple 0
3706269 1928247 1928247 defendant Bothomsell Thomas laborer 586286 586286 Bothomsell, Thomas, of Boston, laborer 1
3706845 1928428 1928428 defendant Alcok Richard yeoman 586286 586286 Alcok, Richard, of Boston, yeoman 0
3706851 1928430 1928430 defendant Sybsay George gent 586286 586286 Sybsay, George, of Boston, gent 0
3708690 1929017 1929017 defendant Halyfeld Edward laborer 586286 586286 Halyfeld, Edward, of Boston, laborer 0
3708691 1929017 1929017 defendant Atherton Mathew carver 586286 586286 Atherton, Mathew, of Boston, carver 1
3708693 1929018 1929018 defendant Walker William husbandman 586286 586286 Walker, William, of Boston, husbandman 0
3716141 1931337 1931337 defendant Pakker William fishmonger 586286 586286 Pakker, William, of Boston, fishmonger 0
3716142 1931337 1931337 defendant Spynke William merchant of the staple 586286 586286 Spynke, William, of Boston, merchant of the staple 1
3721413 1933005 1933005 defendant Lyynd Robert chaplain 586286 586286 Lyynd, Robert, of Boston, chaplain 2
3725524 1934272 1934272 defendant Harcastell John   586286 586286 Harcastell, John, of Boston, mercer, gaol warden 0
3727705 1934934 1934934 defendant Polvertoft Robert gent 586286 586286 Polvertoft, Robert, of Boston, gent 1
3730414 1935744 1935744 defendant Wedall Edward yeoman 586286 586286 Wedall, Edward, of Boston, yeoman 2
3730415 1935744 1935744 defendant Penyman John husbandman 586286 586286 Penyman, John, of Boston, husbandman 3
3730417 1935745 1935745 defendant Wedall Edward yeoman 586286 586286 Wedall, Edward, of Boston, yeoman 0
3730418 1935745 1935745 defendant Penyman John husbandman 586286 586286 Penyman, John, of Boston, husbandman 1
3730855 1935876 1935876 defendant Conseyt John clerk 586286 586286 Conseyt, John, of Boston, clerk 0
3731377 1936035 1936035 defendant Frenche John glover 586286 586286 Frenche, John, of Boston, glover 0
3731381 1936036 1936036 defendant Totheby Nicholas merchant of the staple 586286 586286 Totheby, Nicholas, of Boston, merchant of the staple 0
3731390 1936039 1936039 defendant Frenche John glover 586286 586286 Frenche, John, of Boston, glover 0
3733653 1936767 1936767 plaintiff Etwell William, senior mercer 586286 586286 Etwell, William, senior, of Boston, mercer 0
3734486 1937030 1937030 defendant Hykkys Richard mercer 586286 586286 Hykkys, Richard, of Boston, mercer 0
3734487 1937030 1937030 defendant Gray Nicholas draper 586286 586286 Gray, Nicholas, of Boston, draper 1
3735151 1937230 1937230 defendant Hikkis Richard mercer 586286 586286 Hikkis, Richard, of Boston, mercer 0
3735152 1937230 1937230 defendant Gray Nicholas draper 586286 586286 Gray, Nicholas, of Boston, draper 1
3736424 1937637 1937637 defendant Feld Nicholas merchant of the staple 586286 586286 Feld, Nicholas, of Boston, merchant of the staple 0
3737011 1937822 1937822 defendant Raser Thomas draper 586286 586286 Raser, Thomas, of Boston, draper 0
3737016 1937823 1937823 defendant Raser Thomas draper 586286 586286 Raser, Thomas, of Boston, draper 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);