names

2,060 rows where place_id = 586697

✎ 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
3589394 1864322 1864322 defendant Pontesbury William merchant 586697 586697 Pontesbury, William, of Shrewsbury, merchant 0
3591494 1864967 1864967 defendant Pykke Alice widow 586697 586697 Pykke, Alice, of Shrewsbury, widow 2
3593762 1865685 1865685 plaintiff Horde John (legal representative) 586697 586697 Horde, John, of Shrewsbury, esq, executrix of 0
3595274 1866156 1866156 defendant Goldyng Thomas   586697 586697 Goldyng, Thomas, of Shrewsbury chapman 0
3595277 1866156 1866156 defendant Fyssher John draper 586697 586697 Fyssher, John, of Shrewsbury, draper 3
3597501 1866839 1866839 defendant Jonys Geoffrey cordwainer 586697 586697 Jonys, Geoffrey, of Shrewsbury, cordwainer 0
3598986 1867314 1867314 defendant Grace Thomas merchant 586697 586697 Grace, Thomas, of Shrewsbury, merchant 0
3599083 1867350 1867350 defendant Forster Roger draper 586697 586697 Forster, Roger, of Shrewsbury, draper 0
3599084 1867350 1867350 defendant Forster John draper 586697 586697 Forster, John, of Shrewsbury, draper 1
3599393 1867452 1867452 defendant Syttyns David yeoman 586697 586697 Syttyns, David, of Shrewsbury, yeoman 0
3599981 1867649 1867649 defendant Foster Richard draper 586697 586697 Foster, Richard, of Shrewsbury, draper 0
3599989 1867650 1867650 defendant Gynson William chapman 586697 586697 Gynson, William, of Shrewsbury, chapman 4
3601098 1868008 1868008 defendant Walker John chapman 586697 586697 Walker, John, of Shrewsbury, chapman 1
3602372 1868402 1868402 defendant Fryser William sherman 586697 586697 Fryser, William, of Shrewsbury, sherman 0
3602374 1868403 1868403 defendant Howell John   586697 586697 Howell, John, of Shrewsbury, pouch maker 0
3602376 1868404 1868404 defendant Howell John   586697 586697 Howell, John, of Shrewsbury, pouch maker 0
3602377 1868404 1868404 defendant Friser William sherman 586697 586697 Friser, William, of Shrewsbury, sherman 1
3604613 1869105 1869105 defendant Egge Richard gent 586697 586697 Egge, Richard, of Shrewsbury, gent 2
3604811 1869172 1869172 defendant Bayle Thomas chapman 586697 586697 Bayle, Thomas, of Shrewsbury, chapman 0
3604815 1869173 1869173 defendant Bayle Thomas chapman 586697 586697 Bayle, Thomas, of Shrewsbury, chapman 0
3606317 1869645 1869645 plaintiff More John   586697 586697 More, John, of Shrewsbury 0
3607928 1870129 1870129 defendant Hanwode Robert chapman 586697 586697 Hanwode, Robert, of Shrewsbury, chapman 0
3607930 1870129 1870129 defendant Mayn William chapman 586697 586697 Mayn, William, of Shrewsbury, chapman 2
3607931 1870129 1870129 defendant Mason Roger chapman 586697 586697 Mason, Roger, of Shrewsbury, chapman 3
3612815 1871657 1871657 defendant Fleccher Richard draper 586697 586697 Fleccher, Richard, of Shrewsbury, draper 3
3612820 1871658 1871658 defendant Fleccher Richard draper 586697 586697 Fleccher, Richard, of Shrewsbury, draper 2
3614084 1872071 1872071 defendant Dycher Humphrey bowyer 586697 586697 Dycher, Humphrey, of Shrewsbury, bowyer 0
3614085 1872071 1872071 defendant Smyth William butcher 586697 586697 Smyth, William, of Shrewsbury, butcher 1
3614086 1872071 1872071 defendant Jankyn Thomas butcher 586697 586697 Jankyn, Thomas, of Shrewsbury, butcher 2
3614087 1872071 1872071 defendant Adams Roger butcher 586697 586697 Adams, Roger, of Shrewsbury, butcher 3
3617735 1873172 1873172 defendant Goldyng Thomas mercer 586697 586697 Goldyng, Thomas, of Shrewsbury, mercer 0
3617736 1873172 1873172 defendant Hanwode Robert mercer 586697 586697 Hanwode, Robert, of Shrewsbury, mercer 1
3617738 1873172 1873172 defendant Emondys Richard mercer 586697 586697 Emondys, Richard, of Shrewsbury, mercer 3
3618546 1873424 1873424 defendant Wiche Thomas chapman or mercer 586697 586697 Wiche, Thomas, of Shrewsbury, chapman or mercer 1
3621213 1874175 1874175 defendant Whytfeld Thomas bowyer 586697 586697 Whytfeld, Thomas, of Shrewsbury, bowyer 0
3623557 1874896 1874896 defendant Willyams William fishmonger 586697 586697 Willyams, William, of Shrewsbury, fishmonger 4
3625789 1875604 1875604 defendant Bailly John merchant 586697 586697 (Bailly, John, of Shrewsbury, merchant 1
3625806 1875608 1875608 defendant Bailly John merchant 586697 586697 (Bailly, John, of Shrewsbury, merchant 1
3631991 1904820 1904820 defendant Gyttyns or Gyttyng John Loytt draper 586697 586697 Gyttyns or Gyttyng, John Loytt, of Shrewsbury, draper 1
3632288 1904917 1904917 defendant Gyttons or Gyttyng John Loytt draper 586697 586697 Gyttons or Gyttyng, John Loytt, of Shrewsbury, draper 1
3632694 1905043 1905043 defendant Waryngys Christine widow 586697 586697 Waryngys, Christine, of Shrewsbury, widow 0
3634076 1905456 1905456 defendant Mehen Ralph fishmonger 586697 586697 Mehen, Ralph, of Shrewsbury, fishmonger 0
3634077 1905456 1905456 defendant Parstowe George sherman 586697 586697 Parstowe, George, of Shrewsbury, sherman 1
3634078 1905456 1905456 defendant Purselowe Oliver draper 586697 586697 Purselowe, Oliver, of Shrewsbury, draper 2
3639210 1907077 1907077 defendant Steche William chapman 586697 586697 Steche, William, of Shrewsbury, chapman 1
3640117 1907354 1907354 defendant Colle Robert mercer 586697 586697 Colle, Robert, of Shrewsbury, mercer 0
3640774 1907560 1907560 defendant Kynaston Thomas   586697 586697 Kynaston, Thomas, of Shrewsbury, knight 1
3640932 1907607 1907607 defendant Doon Roger draper 586697 586697 Doon, Roger, of Shrewsbury, draper 2
3640938 1907608 1907608 defendant Doon Roger draper 586697 586697 Doon, Roger, of Shrewsbury, draper 2
3641535 1907810 1907810 defendant Lister Richard gent 586697 586697 Lister, Richard, of Shrewsbury, gent 1
3645790 1909086 1909086 defendant Gyttyns John Lloyd draper 586697 586697 Gyttyns, John Lloyd, of Shrewsbury, draper 0
3654201 1911575 1911575 defendant Ravyn Adam   586697 586697 Ravyn, Adam, of Shrewsbury 1
3654204 1911576 1911576 defendant Ravyn Adam yeoman 586697 586697 Ravyn, Adam, of Shrewsbury, yeoman 1
3656489 1912277 1912277 defendant Philippys Roger draper 586697 586697 Philippys, Roger, of Shrewsbury, draper 0
3658653 1912960 1912960 defendant Copland John   586697 586697 Copland, John, of Shrewsbury, cord wainer 3
3661462 1913855 1913855 defendant Dyer John yeoman 586697 586697 Dyer, John, of Shrewsbury, yeoman 0
3668458 1916087 1916087 defendant Daneley Thomas baker 586697 586697 Daneley, Thomas, of Shrewsbury, baker 0
3673028 1917572 1917572 defendant Hyggyns Richard tanner 586697 586697 Hyggyns, Richard, of Shrewsbury, tanner 0
3673685 1917794 1917794 defendant Copland John cordwainer 586697 586697 Copland, John, of Shrewsbury, cordwainer 2
3674545 1918091 1918091 defendant Knyght Richard gent 586697 586697 Knyght, Richard, of Shrewsbury, gent 1
3675265 1918303 1918303 defendant Foster John draper 586697 586697 Foster, John, of Shrewsbury, draper 0
3675266 1918303 1918303 defendant Foster John, junior draper 586697 586697 Foster, John, junior, of Shrewsbury, draper 1
3677385 1918976 1918976 defendant Screven Thomas esq 586697 586697 Screven, Thomas, of Shrewsbury, esq 0
3677568 1919025 1919025 defendant Trentham Thomas gent 586697 586697 Trentham, Thomas, of Shrewsbury, gent 6
3678491 1919330 1919330 defendant Foster John draper 586697 586697 Foster, John, of Shrewsbury, draper 0
3678494 1919331 1919331 defendant Foster John draper 586697 586697 Foster, John, of Shrewsbury, draper 1
3678495 1919331 1919331 defendant Hochynson William draper 586697 586697 Hochynson, William, of Shrewsbury, draper 2
3679416 1919627 1919627 defendant Pontisbury William (legal representative) 586697 586697 Pontisbury, William, of Shrewsbury, vintner, executrix of 0
3679417 1919627 1919627 defendant Pontisbury Elizabeth widow 586697 586697 Pontisbury, Elizabeth, of Shrewsbury, widow 1
3679420 1919628 1919628 defendant Pontisbury William (legal representative) 586697 586697 Pontisbury, William, of Shrewsbury, vintner, executrix of 0
3679421 1919628 1919628 defendant Pontisbury Elizabeth widow 586697 586697 Pontisbury, Elizabeth, of Shrewsbury, widow 1
3679615 1919692 1919692 plaintiff Pole John gent 586697 586697 Pole, John, of Shrewsbury, gent 0
3679617 1919692 1919692 defendant ap Gyttyn Hugh ap Jenin yeoman 586697 586697 ap Gyttyn, Hugh ap Jenin, of Shrewsbury, yeoman 1
3679621 1919693 1919693 plaintiff Pole John gent 586697 586697 Pole, John, of Shrewsbury, gent 0
3681031 1920143 1920143 defendant Clebury Richard saddler 586697 586697 Clebury, Richard, of Shrewsbury, saddler 0
3683162 1920851 1920851 defendant Peplowe William laborer 586697 586697 Peplowe, William, of Shrewsbury, laborer 0
3685116 1921491 1921491 defendant Daneley Thomas baker 586697 586697 Daneley, Thomas, of Shrewsbury, baker 0
3685134 1921498 1921498 defendant Daneley Thomas baker 586697 586697 Daneley, Thomas, of Shrewsbury, baker 0
3693036 1924026 1924026 defendant Screven Thomas esq 586697 586697 Screven, Thomas, of Shrewsbury, esq 0
3693044 1924030 1924030 defendant Gryffyth Hugh yeoman 586697 586697 Gryffyth, Hugh, of Shrewsbury, yeoman 0
3700077 1926255 1926255 defendant Wyldyng John cordwainer 586697 586697 Wyldyng, John, of Shrewsbury, cordwainer 0
3700078 1926255 1926255 defendant Stone William glover 586697 586697 Stone, William, of Shrewsbury, glover 1
3700082 1926257 1926257 defendant Wyldyng John cordwainer 586697 586697 Wyldyng, John, of Shrewsbury, cordwainer 0
3700083 1926257 1926257 defendant Stone William glover 586697 586697 Stone, William, of Shrewsbury, glover 1
3702033 1926889 1926889 defendant Knyght Richard gent 586697 586697 Knyght, Richard, of Shrewsbury, gent 2
3702034 1926889 1926889 defendant Cole Edmund gent 586697 586697 Cole, Edmund, of Shrewsbury, gent 3
3704203 1927613 1927613 defendant Harbroun George gent 586697 586697 Harbroun, George, of Shrewsbury, gent 0
3704224 1927620 1927620 defendant Watkyns John husbandman 586697 586697 Watkyns, John, of Shrewsbury, husbandman 0
3706054 1928185 1928185 defendant Bayly William draper 586697 586697 Bayly, William, of Shrewsbury, draper 0
3706055 1928185 1928185 defendant Foke William yeoman 586697 586697 Foke, William, of Shrewsbury, yeoman 1
3706057 1928186 1928186 defendant Bayly William draper 586697 586697 Bayly, William, of Shrewsbury, draper 0
3706058 1928186 1928186 defendant Foke William yeoman 586697 586697 Foke, William, of Shrewsbury, yeoman 1
3707539 1928651 1928651 defendant Baugh alias Skynner Lewis skinner 586697 586697 Baugh alias Skynner, Lewis, of Shrewsbury, skinner 1
3707542 1928652 1928652 defendant Bough alias Skynner Lewis skinner 586697 586697 Bough alias Skynner, Lewis, of Shrewsbury, skinner 1
3708394 1928920 1928920 defendant ap Owen David draper 586697 586697 ap Owen, David, of Shrewsbury, draper 1
3709480 1929267 1929267 defendant Whoode John mercer 586697 586697 Whoode, John, of Shrewsbury, mercer 3
3709481 1929267 1929267 defendant Charmell John mercer 586697 586697 Charmell, John, of Shrewsbury, mercer 4
3719071 1932242 1932242 defendant Wotton Robert draper 586697 586697 Wotton, Robert, of Shrewsbury, draper 0
3720613 1932730 1932730 plaintiff Ireland David merchant 586697 586697 Ireland, David, of Shrewsbury, merchant 0
3721383 1932996 1932996 defendant Pontesbury Leonard clerk 586697 586697 Pontesbury, Leonard, of Shrewsbury, clerk 1

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