names

649 rows where place_id = 586981

✎ 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
3590132 1864550 1864550 defendant Smyth Joan widow 586981 586981 Smyth, Joan, of Louth, widow 1
3596951 1866677 1866677 defendant Alforth William butcher 586981 586981 Alforth, William, of Louth, butcher 6
3599711 1867554 1867554 defendant Jakson Edmund yeoman 586981 586981 Jakson, Edmund, of Louth, yeoman 0
3607185 1869913 1869913 defendant Johnson Richard dyer 586981 586981 Johnson, Richard, of Louth, dyer 2
3607186 1869913 1869913 defendant Lytster Thomas dyer 586981 586981 Lytster, Thomas, of Louth, dyer 3
3607911 1870124 1870124 defendant Bunsan William thatcher 586981 586981 Bunsan, William, of Louth, thatcher 0
3612668 1871604 1871604 defendant Spenser John husbandman 586981 586981 Spenser, John, of Louth, husbandman 0
3618088 1873280 1873280 defendant Boteler William merchant 586981 586981 Boteler, William, of Louth, merchant 1
3618327 1873361 1873361 defendant Bradley William shoemaker 586981 586981 Bradley, William, of Louth, shoemaker 1
3623011 1874724 1874724 defendant Johnson alias Lyster Richard dyer 586981 586981 Johnson alias Lyster, Richard, of Louth, dyer 0
3624288 1875132 1875132 defendant Welles Hugh yeoman 586981 586981 Welles, Hugh, of Louth, yeoman 1
3624305 1875136 1875136 defendant Welles Hugh yeoman 586981 586981 Welles, Hugh, of Louth, yeoman 0
3624777 1875284 1875284 defendant Welles Hugh yeoman 586981 586981 Welles, Hugh, of Louth, yeoman 2
3628166 1903665 1903665 defendant Turnour George butcher 586981 586981 Turnour, George, of Louth, butcher 0
3631232 1904591 1904591 defendant Smyth Robert butcher 586981 586981 Smyth, Robert, of Louth, butcher 0
3633863 1905402 1905402 defendant Richerdson Alexander cordwainer 586981 586981 Richerdson, Alexander, of Louth, cordwainer 0
3636604 1906239 1906239 defendant Smyth Robert tanner 586981 586981 Smyth, Robert, of Louth, tanner 0
3636606 1906240 1906240 defendant Smyth Thomas butcher 586981 586981 Smyth, Thomas, of Louth, butcher 0
3636950 1906352 1906352 defendant Wyse Richard dyer 586981 586981 Wyse, Richard, of Louth, dyer 0
3637379 1906497 1906497 defendant Smyth Robert butcher 586981 586981 Smyth, Robert, of Louth, butcher 0
3649984 1910362 1910362 plaintiff Richardson Alexander shoemaker 586981 586981 Richardson, Alexander, of Louth, shoemaker 0
3651731 1910896 1910896 plaintiff Tayllour Thomas draper 586981 586981 Tayllour, Thomas, of Louth, draper 0
3664022 1914695 1914695 defendant Broune William yeoman 586981 586981 Broune, William, of Louth, yeoman 0
3666274 1915399 1915399 defendant Wyes Richard dyer 586981 586981 Wyes, Richard, of Louth, dyer 0
3673313 1917668 1917668 defendant Hill Robert cordwainer 586981 586981 Hill, Robert, of Louth, cordwainer 0
3682274 1920554 1920554 defendant Lincoln Simon (legal representative) 586981 586981 Lincoln, Simon, of Louth, merchant of the staple, executor of 0
3682926 1920772 1920772 defendant Purcell John yeoman 586981 586981 Purcell, John, of Louth, yeoman 0
3686317 1921877 1921877 defendant Tyler Thomas husbandman 586981 586981 Tyler, Thomas, of Louth, husbandman 1
3697829 1925540 1925540 defendant Worsley William goldsmith 586981 586981 Worsley, William, of Louth, goldsmith 0
3697873 1925555 1925555 defendant Kyrk Thomas chaplain 586981 586981 Kyrk, Thomas, of Louth, chaplain 0
3697875 1925556 1925556 defendant Maltby Simon chaplain 586981 586981 Maltby, Simon, of Louth, chaplain 0
3699974 1926225 1926225 defendant Tregold Robert gent 586981 586981 Tregold, Robert, of Louth, gent 0
3704778 1927785 1927785 defendant Tregold Robert gent 586981 586981 Tregold, Robert, of Louth, gent 0
3712825 1930331 1930331 plaintiff Wollerby Thomas mercer 586981 586981 Wollerby, Thomas, of Louth, mercer 0
3713487 1930530 1930530 defendant Tregold Robert yeoman 586981 586981 Tregold, Robert, of Louth, yeoman 0
3713854 1930635 1930635 defendant Tompson John saddler 586981 586981 Tompson, John, of Louth, saddler 0
3713855 1930635 1930635 defendant Otter Robert   586981 586981 Otter, Robert, of Louth, cartwright 1
3749852 1941867 1941867 defendant Tregold Robert (legal representative) 586981 586981 Tregold, Robert, of Louth, yeoman, executor of 0
3786283 1953506 1953506 plaintiff Perpount Robert (legal representative) 586981 586981 Perpount, Robert, of Louth, executors of 0
3789708 1954611 1954611 defendant Scisson John   586981 586981 Scisson, John, of Louth, freemason 0
3789713 1954612 1954612 defendant Scisson John   586981 586981 Scisson, John, of Louth, freemason 0
3792321 1955458 1955458 defendant Browne Robert yeoman 586981 586981 Browne, Robert, of Louth, yeoman 0
3795304 1956399 1956399 defendant Nelson John glover 586981 586981 Nelson, John, of Louth, glover 0
3795803 1956554 1956554 defendant Willyngham William fishmonger 586981 586981 Willyngham, William, of Louth, fishmonger 1
3810497 1961178 1961178 defendant Worsley William goldsmith 586981 586981 Worsley, William, of Louth, goldsmith 0
3813339 1962082 1962082 plaintiff Dughtie Robert gent 586981 586981 Dughtie, Robert, of Louth, gent 0
3813340 1962082 1962082 defendant Clerk Richard capper 586981 586981 Clerk, Richard, of Louth, capper 0
3813341 1962083 1962083 plaintiff Dughtie Robert gent 586981 586981 Dughtie, Robert, of Louth, gent 0
3823996 1965381 1965381 defendant Bradley Thomas merchant of the staple 586981 586981 Bradley, Thomas, of Louth, merchant of the staple 0
3827718 1966535 1966535 defendant Worsley William goldsmith 586981 586981 Worsley, William, of Louth, goldsmith 0
3832268 1968007 1968007 defendant Colynson William butcher 586981 586981 Colynson, William, of Louth, butcher 1
3833232 1968325 1968325 defendant Wright John husbandman 586981 586981 Wright, John, of Louth, husbandman 0
3837619 1969674 1969674 plaintiff Spylsby George   586981 586981 Spylsby, George, of Louth 0
3841130 1970802 1970802 plaintiff Barnard William (legal representative) 586981 586981 Barnard, William, of Louth, executors of 0
3844899 1971948 1971948 plaintiff Doughty Robert   586981 586981 Doughty, Robert, of Louth 0
3844958 1971971 1971971 defendant Rychemond Henry butcher 586981 586981 Rychemond, Henry, of Louth, butcher 0
3845761 1972222 1972222 defendant Yonge Robert   586981 586981 Yonge, Robert, of Louth, draper, administrators of 0
3845763 1972222 1972222 defendant Claxton Bartholomew saddler 586981 586981 Claxton, Bartholomew, of Louth, saddler 2
3850456 1973732 1973732 plaintiff Moore Agnes widow 586981 586981 Moore, Agnes, of Louth, widow 0
3853379 1974680 1974680 defendant Whalley William mercer 586981 586981 Whalley, William, of Louth, mercer 1
3863087 1977854 1977854 defendant Colynson William butcher 586981 586981 Colynson, William, of Louth, butcher 2
3867817 1979468 1979468 defendant Lorymouth John glover 586981 586981 Lorymouth, John, of Louth, glover 0
3884151 1984966 1984966 defendant Whalley William mercer 586981 586981 Whalley, William, of Louth, mercer 0
3888319 1986357 1986357 defendant Hopton John yeoman 586981 586981 Hopton, John, of Louth, yeoman 0
3888321 1986357 1986357 defendant Cheker Thomas yeoman 586981 586981 Cheker, Thomas, of Louth, yeoman 2
3895235 1988614 1988614 defendant Boswell Edward tailor 586981 586981 Boswell, Edward, of Louth, tailor 0
3899103 1989907 1989907 defendant Kellom Simon laborer 586981 586981 Kellom, Simon, of Louth, laborer 0
3899187 1989933 1989933 defendant Elwold Anne   586981 586981 Elwold, Anne, of Louth, "votissam" 0
3902436 1991047 1991047 defendant Marlyngys John gent 586981 586981 Marlyngys, John, of Louth, gent 0
3906319 1992399 1992399 defendant Belloo John glover 586981 586981 Belloo, John, of Louth, glover 3
3908478 1993133 1993133 defendant Kirkman Robert cordwainer 586981 586981 Kirkman, Robert, of Louth, cordwainer 0
3916858 1996002 1996002 defendant Colyngwood Robert yeoman 586981 586981 Colyngwood, Robert, of Louth, yeoman 0
3916909 1996021 1996021 plaintiff Brown Richard yeoman 586981 586981 Brown, Richard, of Louth, yeoman 1
3919736 1996940 1996940 defendant Curson Richard yeoman 586981 586981 Curson, Richard, of Louth, yeoman 1
3919994 1997027 1997027 defendant Nelson William glover 586981 586981 Nelson, William, of Louth, glover 0
3919995 1997027 1997027 defendant Overay John   586981 586981 Overay, John, of Louth, wool winder 1
3923448 1998148 1998148 plaintiff Smythe John yeoman 586981 586981 Smythe, John, of Louth, yeoman 0
3923503 1998168 1998168 defendant Jakson Robert shoemaker 586981 586981 Jakson, Robert, of Louth, shoemaker 0
3931766 2000927 2000927 defendant Barnard William drover & butcher 586981 586981 Barnard, William, of Louth, drover & butcher 0
3934868 2001965 2001965 defendant Lyngard William tailor 586981 586981 Lyngard, William, of Louth, tailor 1
3936529 2002541 2002541 defendant Thorneby John tailor 586981 586981 Thorneby, John, of Louth, tailor 3
3941743 2004252 2004252 defendant Pelson Thomas mercer 586981 586981 Pelson, Thomas, of Louth, mercer 1
3941744 2004252 2004252 defendant Goodall John gent 586981 586981 Goodall, John, of Louth, gent 2
3941747 2004253 2004253 defendant Pelson Thomas mercer 586981 586981 Pelson, Thomas, of Louth, mercer 1
3941748 2004253 2004253 defendant Goodale John gent 586981 586981 Goodale, John, of Louth, gent 2
3942537 2004515 2004515 defendant Barnard William gent 586981 586981 Barnard, William, of Louth, gent 0
3951133 2007465 2007465 defendant Barnard William drover 586981 586981 Barnard, William, of Louth, drover 0
3956902 2009484 2009484 defendant Barnard William drover 586981 586981 Barnard, William, of Louth, drover 0
3960335 2010712 2010712 defendant Collyngwood Stephen weaver 586981 586981 Collyngwood, Stephen, of Louth, weaver 0
3960336 2010712 2010712 defendant Spaldyng John husbandman 586981 586981 Spaldyng, John, of Louth, husbandman 1
3960337 2010712 2010712 defendant Crosseland William weaver 586981 586981 Crosseland, William, of Louth, weaver 2
3960454 2010755 2010755 plaintiff Stutte Roger mercer 586981 586981 Stutte, Roger, of Louth, mercer 0
3968733 2013696 2013696 defendant Allott Robert (legal representative) 586981 586981 Allott, Robert, of Louth, gent, executors of 0
3968813 2013719 2013719 defendant Jones John gent 586981 586981 Jones, John, of Louth, or of Bowmarys, Anglesey, gent 0
3972369 2014909 2014909 plaintiff Fysshe John yeoman 586981 586981 Fysshe, John, of Louth, yeoman 0
3974507 2015661 2015661 defendant Bernarde William yeoman 586981 586981 Bernarde, William, of Louth, yeoman 3
3984321 2019156 2019156 defendant Bernerde William yeoman 586981 586981 Bernerde, William, of Louth, yeoman 1
3992079 2021930 2021930 plaintiff Buck Stephen draper 586981 586981 Buck, Stephen, of Louth, draper 0
3992081 2021930 2021930 defendant Argram Thomas   586981 586981 Argram, Thomas, of Louth, yeoman, son of Edward Argram, of Louth 1
3994267 2022701 2022701 defendant Hudson John butcher 586981 586981 Hudson, John, of Louth, butcher 2

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