names

2,663 rows where place_id = 586848

✎ 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
3587831 1863840 1863840 plaintiff Austyne William (legal representative) 586848 586848 Austyne, William, of Northampton, executor of 0
3589800 1864451 1864451 defendant Hertyshorn Thomas butcher 586848 586848 Hertyshorn, Thomas, of Northampton, butcher 0
3590224 1864584 1864584 defendant Adams Thomas grasier 586848 586848 Adams, Thomas, of Northampton, grasier 0
3591301 1864907 1864907 defendant Manyngham William barber 586848 586848 Manyngham, William, of Northampton, barber 0
3591326 1864913 1864913 defendant Clerk William vintner 586848 586848 Clerk, William, of Northampton, vintner 1
3592661 1865318 1865318 defendant Hayre William chapman 586848 586848 Hayre, William, of Northampton, chapman 2
3592662 1865318 1865318 defendant Wellys John chapman 586848 586848 Wellys, John, of Northampton, chapman 3
3592895 1865395 1865395 defendant Halley Bartholomew gent 586848 586848 Halley, Bartholomew, of Northampton, gent 0
3593194 1865502 1865502 defendant Chaundeler Walter gent 586848 586848 Chaundeler, Walter, of Northampton, gent 0
3593341 1865550 1865550 defendant Pardon William clothmaker 586848 586848 Pardon, William, of Northampton, clothmaker 1
3593801 1865700 1865700 defendant Hardyng Philip butcher 586848 586848 Hardyng, Philip, of Northampton, butcher 0
3593915 1865735 1865735 defendant Pardon William mercer 586848 586848 Pardon, William, of Northampton, mercer 0
3595085 1866096 1866096 plaintiff Lynde William (legal representative) 586848 586848 Lynde, William, of Northampton, merchant of the straple, executors of 0
3595086 1866096 1866096 plaintiff Clerk John baker 586848 586848 (Clerk, John, of Northampton, baker 1
3595957 1866366 1866366 plaintiff Neweman Thomas merchant 586848 586848 Neweman, Thomas, of Northampton, merchant 0
3596496 1866535 1866535 defendant Hertyshorn Thomas butcher 586848 586848 Hertyshorn, Thomas, of Northampton, butcher 0
3596856 1866652 1866652 defendant Wode William fisher 586848 586848 Wode, William, of Northampton, fisher 3
3601861 1868236 1868236 defendant Stubbes Thomas chaplain 586848 586848 Stubbes, Thomas, of Northampton, chaplain 1
3602093 1868317 1868317 defendant Thwayte John stainer 586848 586848 Thwayte, John, of Northampton, stainer 0
3603095 1868634 1868634 defendant Adam Thomas butcher 586848 586848 Adam, Thomas, of Northampton, butcher 0
3604746 1869149 1869149 defendant Chaundeler Walter gent 586848 586848 Chaundeler, Walter, of Northampton, gent 0
3605566 1869408 1869408 defendant Lanfyle John   586848 586848 Lanfyle, John, of Northampton, knight 0
3605570 1869409 1869409 defendant Langfyld John   586848 586848 Langfyld, John, of Northampton, knight 0
3605877 1869503 1869503 defendant Chaundeler Walter gent 586848 586848 Chaundeler, Walter, of Northampton, gent 0
3605962 1869527 1869527 defendant Horne Joan widow 586848 586848 Horne, Joan, of Northampton, widow 0
3606452 1869687 1869687 plaintiff Neuman alias Wyseman Thomas merchant 586848 586848 Neuman alias Wyseman, Thomas, of Northampton, merchant 0
3606490 1869703 1869703 plaintiff Newman alias Wyseman Thomas merchant and dyer 586848 586848 Newman alias Wyseman, Thomas, of Northampton, merchant and dyer 0
3606509 1869708 1869708 defendant Smyth John fishmonger 586848 586848 Smyth, John, of Northampton, fishmonger 0
3606856 1869810 1869810 defendant Smyth John carrier 586848 586848 Smyth, John, of Northampton, carrier 0
3607793 1870089 1870089 plaintiff Shefford William (legal representative) 586848 586848 Shefford, William, of Northampton, goldsmith, executrix of 0
3607795 1870089 1870089 defendant Mounford John barber 586848 586848 Mounford, John, of Northampton, barber 0
3613228 1871791 1871791 defendant Redyng Christopher innholder 586848 586848 Redyng, Christopher, of Northampton, innholder 0
3613230 1871792 1871792 defendant Redyng Christopher innholder 586848 586848 Redyng, Christopher, of Northampton, innholder 0
3614282 1872130 1872130 defendant Morton Henry gent 586848 586848 Morton, Henry, of Northampton, gent 4
3617005 1872939 1872939 defendant Longvyle John   586848 586848 Longvyle, John, of Northampton, knight 0
3618729 1873480 1873480 defendant Hesylbeche John smith 586848 586848 Hesylbeche, John, of Northampton, smith 0
3618732 1873480 1873480 defendant Smyth John carter 586848 586848 Smyth, John, of Northampton, carter 3
3619720 1873738 1873738 defendant Pycard John fishmonger 586848 586848 Pycard, John, of Northampton, or of London, fishmonger 0
3621282 1874197 1874197 defendant Shefford William (legal representative) 586848 586848 Shefford, William, of Northampton, goldsmith, executors of 0
3621285 1874198 1874198 defendant Shefford William (legal representative) 586848 586848 Shefford, William, of Northampton, goldsmith, executors of 0
3621469 1874255 1874255 plaintiff Neweman alias Wyseman Thomas merchant 586848 586848 Neweman alias Wyseman, Thomas, of Northampton, merchant 0
3623159 1874765 1874765 defendant Butler John baker 586848 586848 Butler, John, of Northampton, baker 2
3623440 1874865 1874865 plaintiff Shefford Robert goldsmith 586848 586848 Shefford, Robert, of Northampton, goldsmith 0
3624640 1875241 1875241 defendant Standeland Thomas cordwainer 586848 586848 (Standeland, Thomas, of Northampton, cordwainer 1
3625155 1875402 1875402 defendant Man John butcher 586848 586848 Man, John, of Northampton, butcher 0
3625157 1875403 1875403 defendant Man John butcher 586848 586848 Man, John, of Northampton, butcher 0
3629475 1904073 1904073 plaintiff Cryspe Richard (legal representative) 586848 586848 Cryspe, Richard, of Northampton, mercer, executor of 0
3630121 1904269 1904269 defendant Pyckard John fishmonger 586848 586848 Pyckard, John, of Northampton, fishmonger 0
3630123 1904270 1904270 defendant Pychard John fishmonger 586848 586848 Pychard, John, of Northampton, fishmonger 0
3632133 1904867 1904867 plaintiff Haselwode Edmund gent 586848 586848 Haselwode, Edmund, of Northampton, gent 0
3635937 1906034 1906034 plaintiff Pope Agnes widow 586848 586848 Pope, Agnes, of Northampton, widow 0
3637255 1906454 1906454 plaintiff Shefford John goldsmith 586848 586848 Shefford, John, of Northampton, goldsmith 0
3637257 1906455 1906455 plaintiff Shefford Robert goldsmith 586848 586848 Shefford, Robert, of Northampton, goldsmith 0
3637259 1906456 1906456 plaintiff Shefford Robert goldsmith 586848 586848 Shefford, Robert, of Northampton, goldsmith 0
3637700 1906604 1906604 defendant Hertyshorne Thomas, junior butcher 586848 586848 Hertyshorne, Thomas, junior, of Northampton, butcher 0
3637701 1906604 1906604 defendant Michell William glover 586848 586848 Michell, William, of Northampton, glover 1
3637702 1906604 1906604 defendant Williamson Thomas weaver 586848 586848 Williamson, Thomas, of Northampton, weaver 2
3637703 1906604 1906604 defendant Chalender John baker 586848 586848 Chalender, John, of Northampton, baker 3
3639035 1907030 1907030 defendant Catesby John esq 586848 586848 Catesby, John, of Northampton, esq 0
3639283 1907098 1907098 defendant Wale John skinner 586848 586848 Wale, John, of Northampton, skinner 0
3639490 1907156 1907156 defendant Norys William (legal representative) 586848 586848 Norys, William, of Northampton, executors of 1
3639491 1907156 1907156 defendant Norres Margery widow 586848 586848 (Norres, Margery, of Northampton, widow 2
3639492 1907156 1907156 defendant Cokke William yeoman 586848 586848 Cokke, William, of Northampton, yeoman 3
3641885 1907915 1907915 defendant Webbe William butcher 586848 586848 Webbe, William, of Northampton, butcher 0
3641929 1907927 1907927 defendant Wellys Thomas yeoman 586848 586848 Wellys, Thomas, of Northampton, yeoman 1
3646372 1909258 1909258 defendant Alwarde William yeoman 586848 586848 (Alwarde, William, of Northampton, yeoman 1
3646393 1909266 1909266 defendant Swaynson Robert yeoman 586848 586848 Swaynson, Robert, of Northampton, yeoman 0
3649536 1910244 1910244 defendant Parker John pardoner 586848 586848 Parker, John, of Northampton, pardoner 0
3650324 1910475 1910475 defendant Cattisbe John gent 586848 586848 Cattisbe, John, of Northampton, gent 2
3656583 1912313 1912313 defendant Beneslower John pewterer 586848 586848 Beneslower, John, of Northampton, pewterer 4
3656666 1912335 1912335 defendant Aylmer John   586848 586848 Aylmer, John, of Northampton, inn holder 0
3656772 1912372 1912372 plaintiff Cockys Henry   586848 586848 Cockys, Henry, of Northampton, Abbot of the Monastery of St James the Apostle 0
3657056 1912468 1912468 plaintiff Cookys Henry   586848 586848 Cookys, Henry, of Northampton, abbot of the Monastery of St James 0
3657057 1912468 1912468 defendant Baron John mercer 586848 586848 Baron, John, of Northampton, mercer 0
3657058 1912469 1912469 plaintiff Cookys Henry   586848 586848 Cookys, Henry, of Northampton, abbot of the Monastery of St James the Apostle 0
3657060 1912470 1912470 plaintiff Cookys Henry   586848 586848 Cookys, Henry, of Northampton, abbot of the Monastery of St James the Apostle 0
3657188 1912514 1912514 defendant Benfflower John pewterer 586848 586848 Benfflower, John, of Northampton, pewterer 0
3657195 1912515 1912515 defendant Benfflower John pewterer 586848 586848 Benfflower, John, of Northampton, pewterer 0
3657349 1912558 1912558 defendant Benson Thomas   586848 586848 Benson, Thomas, of Northampton, gold smith 0
3657386 1912569 1912569 defendant Benson Thomas   586848 586848 Benson, Thomas, of Northampton, gold smith 0
3660843 1913659 1913659 plaintiff Huss Peter Master & Arch deacon 586848 586848 Huss, Peter, of Northampton, Master & Arch deacon 0
3660920 1913685 1913685 defendant Wedon Robert mercer 586848 586848 Wedon, Robert, of Northampton, mercer 0
3660921 1913685 1913685 defendant Nulyn Reginald yeoman 586848 586848 Nulyn, Reginald, of Northampton, yeoman 1
3660924 1913686 1913686 defendant Wedon Robert mercer 586848 586848 Wedon, Robert, of Northampton, mercer 0
3660925 1913686 1913686 defendant Nulyn Reginald yeoman 586848 586848 Nulyn, Reginald, of Northampton, yeoman 1
3661022 1913721 1913721 defendant Catesby John esq 586848 586848 Catesby, John, of Northampton, esq 0
3662851 1914297 1914297 defendant West John yeoman 586848 586848 West, John, of Northampton, yeoman 0
3663079 1914362 1914362 defendant Mariott William yeoman 586848 586848 Mariott, William, of Northampton, yeoman 0
3663663 1914569 1914569 defendant Cockys Henry   586848 586848 Cockys, Henry, of Northampton, Abbot of the Monastery of St James 0
3663980 1914677 1914677 defendant Aylemer John yeoman 586848 586848 Aylemer, John, of Northampton, yeoman 0
3664337 1914794 1914794 defendant Adams Thomas grasier 586848 586848 Adams, Thomas, of Northampton, grasier 0
3665068 1915023 1915023 plaintiff Smyth Gilbert clerk & arch deacon 586848 586848 Smyth, Gilbert, of Northampton, clerk & arch deacon 0
3665599 1915190 1915190 plaintiff Stock Clementina   586848 586848 Stock, Clementina, of Northampton, abbess of the Monastery of St Mary of Pratis 0
3665600 1915190 1915190 defendant Chatton Edward baker 586848 586848 Chatton, Edward, of Northampton, baker 0
3665601 1915191 1915191 plaintiff Stock Clementina   586848 586848 Stock, Clementina, of Northampton, abbess of the Monastery of St Mary of Pratis 0
3665602 1915191 1915191 defendant Chatton Edward baker 586848 586848 Chatton, Edward, of Northampton, baker 0
3665603 1915191 1915191 defendant Chatton John laborer 586848 586848 Chatton, John, of Northampton, laborer 1
3667105 1915643 1915643 defendant Chepley William chapman 586848 586848 Chepley, William, of Northampton, chapman 3
3667852 1915887 1915887 plaintiff (not given) Thomas prior of Yorke 586848 586848 Yorke, Thomas, of Northampton, prior of the monastery of St Andrew, William, of Northampton, prior & successor to 0
3668129 1915979 1915979 plaintiff Alward William   586848 586848 Alward, William, of Northampton 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);