names

1,837 rows where place_id = 586070

✎ 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
3587854 1863850 1863850 plaintiff Ayers Richard tiler 586070 586070 Ayers, Richard, of Beverley, tiler 0
3588347 1864006 1864006 plaintiff Bekwyth William (legal representative) 586070 586070 Bekwyth, William, of Beverley, executors of 0
3590341 1864620 1864620 defendant Gryffynm John yeoman 586070 586070 Gryffynm John, of Beverley, yeoman 1
3590484 1864669 1864669 defendant Swanne William weaver 586070 586070 Swanne, William, of Beverley, weaver 6
3593545 1865616 1865616 plaintiff Hillyard Agnes widow 586070 586070 Hillyard, Agnes, of Beverley, widow 0
3593547 1865617 1865617 plaintiff Hillyerd Agnes widow 586070 586070 Hillyerd, Agnes, of Beverley, widow 0
3593549 1865618 1865618 plaintiff Hillyerd Agnes widow 586070 586070 Hillyerd, Agnes, of Beverley, widow 0
3593551 1865619 1865619 plaintiff Hillyerd Agnes widow 586070 586070 Hillyerd, Agnes, of Beverley, widow 0
3593553 1865620 1865620 plaintiff Hillyerd Agnes widow 586070 586070 Hillyerd, Agnes, of Beverley, widow 0
3593555 1865621 1865621 plaintiff Hillyerd Agnes widow 586070 586070 Hillyerd, Agnes, of Beverley, widow 0
3594182 1865823 1865823 defendant Pynk Stephen clerk 586070 586070 Pynk, Stephen, of Beverley, clerk 0
3594183 1865823 1865823 defendant Marshall Thomas gent 586070 586070 Marshall, Thomas, of Beverley, gent 1
3594187 1865824 1865824 defendant Ayers Richard tiler 586070 586070 Ayers, Richard, of Beverley, tiler 2
3594587 1865939 1865939 defendant Witton Henry laborer 586070 586070 Witton, Henry, of Beverley, laborer 0
3596182 1866436 1866436 defendant Syllystorn John mercer 586070 586070 Syllystorn, John, of Beverley, mercer 0
3596183 1866436 1866436 defendant Dakers Robert weaver 586070 586070 Dakers, Robert, of Beverley, weaver 1
3596184 1866436 1866436 defendant Basse Elias dyer 586070 586070 Basse, Elias, of Beverley, dyer 2
3596185 1866436 1866436 defendant Spaldyng John baker 586070 586070 Spaldyng, John, of Beverley, baker 3
3598237 1867080 1867080 defendant Barnard Henry (legal representative) 586070 586070 Barnard, Henry, of Beverley, clerk, executors of 0
3598238 1867080 1867080 defendant Hundesley William chaplain 586070 586070 (Hundesley, William, of Beverley, chaplain 1
3598239 1867080 1867080 defendant Sqwirry Richard chaplain 586070 586070 Sqwirry, Richard, of Beverley, chaplain 2
3598240 1867080 1867080 defendant Watkyn John butcher 586070 586070 Watkyn, John, of Beverley, butcher 3
3599628 1867526 1867526 defendant Rumthwate John bowyer 586070 586070 Rumthwate, John, of Beverley, bowyer 0
3602783 1868537 1868537 defendant Hardy Thomas yeoman 586070 586070 (Hardy, Thomas, of Beverley, yeoman 1
3603928 1868899 1868899 defendant Gryme John yeoman 586070 586070 Gryme, John, of Beverley, yeoman 1
3605471 1869377 1869377 plaintiff Johnson William gent 586070 586070 Johnson, William, of Beverley, gent 0
3605473 1869377 1869377 defendant Wylson Richard merchant 586070 586070 Wylson, Richard, of Beverley, merchant 1
3606949 1869836 1869836 defendant Shaklok John laborer 586070 586070 Shaklok, John, of Beverley, laborer 0
3607966 1870142 1870142 plaintiff Smyth John chaplain 586070 586070 Smyth, John, of Beverley, chaplain 0
3618294 1873350 1873350 defendant Gatys Stephen dyer 586070 586070 Gatys, Stephen, of Beverley, dyer 0
3618772 1873487 1873487 defendant Middelton Edward merchant 586070 586070 Middelton, Edward, of Beverley, merchant 0
3619897 1873799 1873799 defendant Clerk John   586070 586070 Clerk, John, of Beverley, mercer, administrators of 0
3619898 1873799 1873799 defendant Sergeauntson William yeoman 586070 586070 (Sergeauntson, William, of Beverley, yeoman 1
3622950 1874706 1874706 defendant Kelle Thomas gent 586070 586070 Kelle, Thomas, of Beverley, gent 1
3624485 1875192 1875192 defendant More Thomas laborer 586070 586070 More, Thomas, of Beverley, laborer 2
3627098 1903337 1903337 defendant Thomson Robert tanner 586070 586070 Thomson, Robert, of Beverley, tanner 0
3627099 1903337 1903337 defendant Hawford Thomas smith 586070 586070 Hawford, Thomas, of Beverley, smith 1
3628779 1903878 1903878 defendant Armestrang Henry fuller 586070 586070 Armestrang, Henry, of Beverley, fuller 1
3628780 1903878 1903878 defendant Armestrong Thomas dyer 586070 586070 Armestrong, Thomas, of Beverley, dyer 2
3629037 1903959 1903959 defendant Settryngton William butcher 586070 586070 Settryngton, William, of Beverley, butcher 1
3631230 1904590 1904590 defendant Beryer John tanner 586070 586070 Beryer, John, of Beverley, tanner 0
3637396 1906503 1906503 defendant White Robert mercer 586070 586070 White, Robert, of Beverley, mercer 0
3637401 1906503 1906503 defendant White Nicholas   586070 586070 White, Nicholas, of Beverley, sanctuary man 5
3642765 1908186 1908186 defendant Forster Lancelot dyer 586070 586070 Forster, Lancelot, of Beverley, dyer 0
3651572 1910845 1910845 defendant Wynseley John merchant 586070 586070 (Wynseley, John, of Beverley, merchant 1
3662314 1914127 1914127 defendant Colier William yeoman 586070 586070 Colier, William, of Beverley, yeoman 1
3667641 1915823 1915823 plaintiff Wylkynson John   586070 586070 Wylkynson, John, of Beverley 0
3667643 1915824 1915824 plaintiff Wylkynson John   586070 586070 Wylkynson, John, of Beverley 0
3671509 1917071 1917071 defendant Copyndale Edmund gent 586070 586070 Copyndale, Edmund, of Beverley, gent 0
3672186 1917301 1917301 plaintiff Crawe Peter   586070 586070 Crawe, Peter, of Beverley 0
3682983 1920790 1920790 defendant Smyth John grocer 586070 586070 Smyth, John, of Beverley, grocer 3
3703282 1927300 1927300 defendant Hogeson Robert yeoman 586070 586070 Hogeson, Robert, of Beverley, yeoman 0
3712463 1930215 1930215 plaintiff Wenslay John gent 586070 586070 Wenslay, John, of Beverley, gent 0
3724429 1933927 1933927 defendant Rokeby James gent 586070 586070 Rokeby, James, of Beverley, gent 0
3731790 1936173 1936173 defendant Creyk Robert esq 586070 586070 Creyk, Robert, of Beverley, esq 1
3743597 1939874 1939874 defendant Lorymer Hugh goldsmith 586070 586070 Lorymer, Hugh, of Beverley, goldsmith 0
3756832 1944110 1944110 defendant Hagard Thomas chaplain 586070 586070 Hagard, Thomas, of Beverley, chaplain 0
3785484 1953250 1953250 defendant Raffyls Robert pewterer 586070 586070 Raffyls, Robert, of Beverley, pewterer 0
3785485 1953250 1953250 defendant Grey Robert merchant 586070 586070 Grey, Robert, of Beverley, merchant 1
3785486 1953250 1953250 defendant Dawson John glover 586070 586070 Dawson, John, of Beverley, glover 2
3811881 1961619 1961619 defendant Creyke Robert esq 586070 586070 Creyke, Robert, of Beverley, esq 1
3826826 1966240 1966240 defendant Crawe Thomas barker 586070 586070 Crawe, Thomas, of Beverley, barker 0
3826827 1966240 1966240 defendant Grasyn William barker 586070 586070 Grasyn, William, of Beverley, barker 1
3826828 1966240 1966240 defendant Abbut Robert barker 586070 586070 Abbut, Robert, of Beverley, barker 2
3826829 1966240 1966240 defendant Thanners William barker 586070 586070 Thanners, William, of Beverley, barker 3
3827207 1966374 1966374 defendant Thomson Robert barker 586070 586070 Thomson, Robert, of Beverley, barker 1
3827208 1966374 1966374 defendant Thomson John barker 586070 586070 Thomson, John, of Beverley, barker 2
3834035 1968584 1968584 defendant Eckeswell Robert yeoman 586070 586070 Eckeswell, Robert, of Beverley, yeoman 5
3839630 1970319 1970319 plaintiff Woodde Richard merchant 586070 586070 Woodde, Richard, of Beverley, merchant 0
3848218 1973010 1973010 defendant Hudson Christopher dyer 586070 586070 Hudson, Christopher, of Beverley, dyer 0
3848246 1973019 1973019 defendant Barnby James potter 586070 586070 Barnby, James, of Beverley, potter 0
3850281 1973674 1973674 defendant Farrar Christopher merchant of the staple 586070 586070 Farrar, Christopher, of Beverley, merchant of the staple 5
3852744 1974467 1974467 defendant Fowle Richard merchant 586070 586070 Fowle, Richard, of Beverley, merchant 0
3853376 1974679 1974679 defendant Spaldyng Alexander waterman 586070 586070 Spaldyng, Alexander, of Beverley, waterman 0
3854316 1974988 1974988 defendant Cropshon Robert   586070 586070 Cropshon, Robert, of Beverley, card maker 0
3856405 1975626 1975626 plaintiff Wright John   586070 586070 Wright, John, of Beverley 0
3881125 1983957 1983957 defendant Burley James clerk 586070 586070 Burley, James, of Beverley, clerk 0
3881128 1983958 1983958 defendant Burley James clerk 586070 586070 Burley, James, of Beverley, clerk 0
3890387 1987038 1987038 defendant Barton Thomas gent 586070 586070 Barton, Thomas, of Beverley, gent 0
3890417 1987051 1987051 defendant Barton Thomas gent 586070 586070 Barton, Thomas, of Beverley, gent 0
3904635 1991805 1991805 defendant Barton Thomas gent 586070 586070 Barton, Thomas, of Beverley, gent 0
3913479 1994845 1994845 defendant Standevyn John yeoman 586070 586070 Standevyn, John, of Beverley, yeoman 0
3929095 2000072 2000072 plaintiff Browne Robert (legal representative) 586070 586070 Browne, Robert, of Beverley, draper, executor of 0
3945836 2005618 2005618 defendant Fayreclyff Isabel spinster 586070 586070 (Fayreclyff, Isabel, of Beverley, spinster 1
3945837 2005618 2005618 defendant Fayreclyff Mary spinster 586070 586070 Fayreclyff, Mary, of Beverley, spinster 2
3945838 2005618 2005618 defendant Perecy Robert yeoman 586070 586070 Perecy, Robert, of Beverley, yeoman 3
3948395 2006503 2006503 defendant Mayne Christopher gent 586070 586070 Mayne, Christopher, of Beverley, gent 0
3952486 2007938 2007938 defendant Mayn Christopher gent 586070 586070 Mayn, Christopher, of Beverley, gent 0
3954403 2008609 2008609 defendant Lamer Nicholas innkeeper 586070 586070 Lamer, Nicholas, of Beverley, innkeeper 0
3954404 2008609 2008609 defendant Wrytt William innkeeper 586070 586070 Wrytt, William, of Beverley, innkeeper 1
3959031 2010240 2010240 defendant Ardyngton Nicholas chapman 586070 586070 Ardyngton, Nicholas, of Beverley, chapman 1
3962561 2011496 2011496 defendant Elles Thomas smith 586070 586070 Elles, Thomas, of Beverley, smith 2
3976977 2016513 2016513 defendant Hardye Robert butcher 586070 586070 Hardye, Robert, of Beverley, butcher 0
3977541 2016715 2016715 defendant Hardy Robert butcher 586070 586070 Hardy, Robert, of Beverley, butcher 0
3990744 2021444 2021444 defendant Clarke George chapman 586070 586070 Clarke, George, of Beverley, chapman 1
3991543 2021735 2021735 defendant Mayne Christopher esq 586070 586070 Mayne, Christopher, of Beverley, esq 0
3991545 2021736 2021736 defendant Mayne Christopher esq 586070 586070 Mayne, Christopher, of Beverley, esq 0
3993127 2022290 2022290 plaintiff Carleton alias Walker Margaret daughter of Ralph Knowles, cordwainer 586070 586070 Margaret his wife, daughter of Ralph Knowles, of Beverley, cordwainer 1
3993128 2022290 2022290 defendant Robynson John cordwainer 586070 586070 Robynson, John, of Beverley, cordwainer 0
3996497 2023506 2023506 defendant Spence Roger yeoman 586070 586070 Spence, Roger, of Beverley, yeoman 3

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