names

175 rows where place_id = 586039

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587758 1863817 1863817 defendant Argate John husbandman 586039 586039 Argate, John, of Whaplod, husbandman 1
3593271 1865528 1865528 defendant Daweson Gilbert, senior husbandman 586039 586039 Daweson, Gilbert, senior, of Whaplod, husbandman 3
3593272 1865528 1865528 defendant Johnson William yeoman 586039 586039 Johnson, William, of Whaplod, yeoman 4
3605010 1869230 1869230 defendant Dawson Gilbert husbandman 586039 586039 Dawson, Gilbert, of Whaplod, husbandman 1
3631160 1904569 1904569 defendant Takker John husbandman 586039 586039 Takker, John, of Whaplod, husbandman 2
3636544 1906225 1906225 defendant Byller William husbandman 586039 586039 Byller, William, of Whaplod, husbandman 0
3641348 1907747 1907747 defendant Bell Elizabeth widow 586039 586039 Bell, Elizabeth, of Whaplod, widow 0
3641350 1907747 1907747 defendant Bukley William husbandman 586039 586039 Bukley, William, of Whaplod, husbandman 2
3645066 1908865 1908865 defendant Maryot Richard husbandman 586039 586039 Maryot, Richard, of Whaplod, husbandman 1
3698829 1925852 1925852 defendant Wynter Thomas husbandman 586039 586039 Wynter, Thomas, of Whaplod, husbandman 0
3711024 1929758 1929758 defendant Stokes John husbandman 586039 586039 Stokes, John, of Whaplod, husbandman 0
3722084 1933168 1933168 defendant Durlove Robert husbandman 586039 586039 Durlove, Robert, of Whaplod, husbandman 0
3795796 1956553 1956553 defendant Frewer Nicholas husbandman 586039 586039 Frewer, Nicholas, of Whaplod, husbandman 0
3795797 1956553 1956553 defendant Wright Robert husbandman 586039 586039 Wright, Robert, of Whaplod, husbandman 1
3826294 1966073 1966073 defendant Smyth William carpenter 586039 586039 Smyth, William, of Whaplod, carpenter 0
3826295 1966073 1966073 defendant Waren William husbandman 586039 586039 Waren, William, of Whaplod, husbandman 1
3828410 1966758 1966758 plaintiff Chapman Henry (legal representative) 586039 586039 Chapman, Henry, of Whaplod, executor of 0
3832226 1967991 1967991 defendant Carter John, senior husbandman 586039 586039 Carter, John, senior, of Whaplod, husbandman 0
3836137 1969215 1969215 defendant Byrde Hugh husbandman 586039 586039 Byrde, Hugh, of Whaplod, husbandman 0
3856682 1975719 1975719 defendant Stokes John husbandman 586039 586039 Stokes, John, of Whaplod, husbandman 0
3864534 1978337 1978337 defendant Campyon Gilbert husbandman 586039 586039 Campyon, Gilbert, of Whaplod, husbandman 3
3866588 1979052 1979052 defendant Bukley John, junior yeoman 586039 586039 Bukley, John, junior, of Whaplod, yeoman 0
3876940 1982527 1982527 defendant Shepard William husbandman 586039 586039 Shepard, William, of Whaplod, husbandman 1
3880589 1983769 1983769 defendant Newerk Robert husbandman 586039 586039 Newerk, Robert, of Whaplod, husbandman 0
3880591 1983770 1983770 defendant Hogeman Thomas yeoman 586039 586039 Hogeman, Thomas, of Whaplod, yeoman 0
3881188 1983976 1983976 defendant Pulvertoft Thomas gent 586039 586039 Pulvertoft, Thomas, of Whaplod, gent 0
3883854 1984869 1984869 defendant Wynsley Geoffrey tailor 586039 586039 Wynsley, Geoffrey, of Whaplod, tailor 0
3883856 1984870 1984870 defendant Wynsley Geoffrey tailor 586039 586039 Wynsley, Geoffrey, of Whaplod, tailor 0
3892832 1987852 1987852 defendant Scott Robert husbandman 586039 586039 Scott, Robert, of Whaplod, husbandman 1
3899320 1989985 1989985 defendant White William husbandman 586039 586039 White, William, of Whaplod, husbandman 0
3900519 1990403 1990403 defendant Herby Simon husbandman 586039 586039 Herby, Simon, of Whaplod, husbandman 0
3913332 1994792 1994792 defendant Johnson Adam husbandman 586039 586039 Johnson, Adam, of Whaplod, husbandman 0
3914403 1995161 1995161 defendant Iden Thomas (legal representative) 586039 586039 Iden, Thomas, of Whaplod, executor of 0
3921895 1997669 1997669 plaintiff Pynder William yeoman 586039 586039 Pynder, William, of Whaplod, yeoman 0
3923295 1998102 1998102 defendant Williamson Richard yeoman 586039 586039 Williamson, Richard, of Whaplod, yeoman 0
3924679 1998569 1998569 defendant Storkys alias Pye Robert fisher 586039 586039 Storkys alias Pye, Robert, of Whaplod, fisher 0
3929515 2000219 2000219 defendant Grome William husbandman 586039 586039 Grome, William, of Whaplod, husbandman 1
3934101 2001700 2001700 defendant Harve Godfrey husbandman 586039 586039 Harve, Godfrey, of Whaplod, husbandman 0
3939612 2003555 2003555 defendant Anderton Thomas husbandman 586039 586039 Anderton, Thomas, of Whaplod, husbandman 0
3940997 2003994 2003994 defendant Moyne Thomas fisher 586039 586039 Moyne, Thomas, of Whaplod, fisher 4
3942471 2004491 2004491 defendant Okey Robert fisher 586039 586039 Okey, Robert, of Whaplod, fisher 0
3955416 2008961 2008961 defendant Bawdre Thomas, senior husbandman 586039 586039 Bawdre, Thomas, senior, of Whaplod, husbandman 0
3965178 2012431 2012431 defendant Marten Thomas yeoman 586039 586039 Marten, Thomas, of Whaplod, yeoman 1
3970826 2014380 2014380 defendant Dysney Lawrence yeoman 586039 586039 Dysney, Lawrence, of Whaplod, yeoman 8
3970827 2014380 2014380 defendant Marton John yeoman 586039 586039 Marton, John, of Whaplod, yeoman 9
3971554 2014611 2014611 defendant Dysney Lawrence yeoman 586039 586039 Dysney, Lawrence, of Whaplod, yeoman 0
3982528 2018526 2018526 defendant Wyldman Leonard husbandman 586039 586039 Wyldman, Leonard, of Whaplod, husbandman 0
3992954 2022237 2022237 defendant Groune or Grove William husbandman 586039 586039 Groune or Grove, William, of Whaplod, husbandman 0
3994727 2022867 2022867 defendant Wensley Roger yeoman 586039 586039 Wensley, Roger, of Whaplod, yeoman 0
3994733 2022869 2022869 defendant Pulvertoft Robert gent 586039 586039 Pulvertoft, Robert, of Whaplod, gent 2
3995333 2023072 2023072 defendant Wensley Roger yeoman 586039 586039 Wensley, Roger, of Whaplod, yeoman 0
3995334 2023072 2023072 defendant Metcalf John husbandman 586039 586039 Metcalf, John, of Whaplod, husbandman 1
3995337 2023073 2023073 defendant Pulvertoft Robert gent 586039 586039 Pulvertoft, Robert, of Whaplod, gent 1
3995380 2023091 2023091 defendant Wensley Roger yeoman 586039 586039 Wensley, Roger, of Whaplod, yeoman 0
3995381 2023091 2023091 defendant Metcalf John husbandman 586039 586039 Metcalf, John, of Whaplod, husbandman 1
4004524 2026391 2026391 defendant Metcalf John yeoman 586039 586039 Metcalf, John, of Whaplod, yeoman 3
4018306 2031274 2031274 defendant Pulvertoft Robert gent 586039 586039 Pulvertoft, Robert, of Whaplod, gent 0
4050062 2042449 2042449 defendant Pulvertoft Robert gent 586039 586039 Pulvertoft, Robert, of Whaplod, gent 1
4087418 2055794 2055794 defendant Perey William carpenter 586039 586039 Perey, William, of Whaplod, carpenter 0
4170656 2085236 2085236 defendant Glover William yeoman 586039 586039 Glover, William, of Whaplod, yeoman 0
4195603 2094011 2094011 defendant Pulvertofte Robert gent 586039 586039 Pulvertofte, Robert, of Whaplod, gent 0
4197992 2094848 2094848 defendant Pulvertofte Robert gent 586039 586039 Pulvertofte, Robert, of Whaplod, gent 0
4207102 2098027 2098027 defendant Stanhope William yeoman 586039 586039 Stanhope, William, of Whaplod, yeoman 1
4224670 2104102 2104102 defendant Bratherike Edward   586039 586039 Bratherike, Edward, of Whaplod, or of Newark on Trent, Notts yeoman 0
4224674 2104103 2104103 defendant Yonge Edward husbandman 586039 586039 Yonge, Edward, of Whaplod, or of Abbott Rypton, Hunts, husbandman 0
4224677 2104104 2104104 defendant Yonge Edward husbandman 586039 586039 Yonge, Edward, of Whaplod, or of Abbott Rypton, Hunts, husbandman 0
4224680 2104105 2104105 defendant Bratherycke Edward   586039 586039 Bratherycke, Edward, of Whaplod, or of Newark on Trent, Notts yeoman 0
4228473 2105442 2105442 defendant Martyn Richard (legal representative) 586039 586039 Martyn, Richard, of Whaplod, yeoman, administrator of 0
4228474 2105442 2105442 defendant Mason William husbandman 586039 586039 Mason, William, of Whaplod, husbandman 1
4231676 2106580 2106580 defendant Sowe William yeoman 586039 586039 Sowe, William, of Whaplod, yeoman 0
4234765 2107708 2107708 defendant Welby Thomas gent 586039 586039 Welby, Thomas, of Whaplod, or of Halsteade, gent 1
4235430 2107960 2107960 defendant Emmerson William victualer 586039 586039 Emmerson, William, of Whaplod, victualer 2
4243362 2110771 2110771 defendant Welbye Thomas gent 586039 586039 Welbye, Thomas, of Whaplod, or of Halsteade, gent 1
4244070 2110998 2110998 defendant Emmerson William victualer 586039 586039 Emmerson, William, of Whaplod, victualer 1
4267521 2118772 2118772 defendant Marten Richard yeoman 586039 586039 Marten, Richard, of Whaplod, yeoman 0
4270432 2119691 2119691 defendant Wells William yeoman 586039 586039 Wells, William, of Whaplod, or of Molton, yeoman 0
4279610 2122786 2122786 defendant Richerdson Henry yeoman 586039 586039 Richerdson, Henry, of Whaplod, yeoman 0
4665391 2250654 2250654 defendant Athelard John gent 586039 586039 Athelard, John, of Whaplod, gent 6
4895186 2325156 2325156 defendant Palfreman Gilbert husbandman 586039 586039 Palfreman, Gilbert, of Whaplod, husbandman 0
4895187 2325156 2325156 defendant Pynder John husbandman 586039 586039 Pynder, John, of Whaplod, husbandman 1
4895188 2325156 2325156 defendant Pynder Robert husbandman 586039 586039 Pynder, Robert, of Whaplod, husbandman 2
4895191 2325156 2325156 defendant Broun Thomas husbandman 586039 586039 Broun, Thomas, of Whaplod, husbandman 5
4918122 2332187 2332187 defendant Horn William husbandman 586039 586039 Horn, William, of Whaplod, husbandman 0
4926375 2334671 2334671 defendant Coker John husbandman 586039 586039 Coker, John, of Whaplod, husbandman 0
4926376 2334671 2334671 defendant Gamull Simon, junior husbandman 586039 586039 Gamull, Simon, junior, of Whaplod, husbandman 1
4927782 2335126 2335126 defendant Everard John husbandman 586039 586039 Everard, John, of Whaplod, husbandman 2
4951547 2342440 2342440 defendant Palfrayman Gilbert, senior husbandman 586039 586039 Palfrayman, Gilbert, senior, of Whaplod, husbandman 5
4961410 2345384 2345384 defendant Ak Simon husbandman 586039 586039 Ak, Simon, of Whaplod, husbandman 0
4963742 2346066 2346066 defendant Coker John husbandman 586039 586039 Coker, John, of Whaplod, husbandman 1
4968428 2347524 2347524 defendant Welby Beatrice widow 586039 586039 Welby, Beatrice, of Whaplod, widow 1
4968610 2347578 2347578 defendant Hobard John husbandman 586039 586039 Hobard, John, of Whaplod, husbandman 1
4974636 2349380 2349380 defendant Fyssher Robert husbandman 586039 586039 Fyssher, Robert, of Whaplod, husbandman 0
4980321 2351058 2351058 defendant Randes Robert husbandman 586039 586039 Randes, Robert, of Whaplod, husbandman 0
5013024 2360639 2360639 defendant Hoberd John husbandman 586039 586039 Hoberd, John, of Whaplod, husbandman 5
5014508 2361105 2361105 defendant Mannar John husbandman 586039 586039 Mannar, John, of Whaplod, husbandman 3
5014509 2361105 2361105 defendant Spendluff Thomas husbandman 586039 586039 Spendluff, Thomas, of Whaplod, husbandman 4
5017318 2361952 2361952 defendant Male Richard husbandman 586039 586039 Male, Richard, of Whaplod, husbandman 0
5029537 2365508 2365508 defendant Manner John husbandman 586039 586039 Manner, John, of Whaplod, husbandman 0
5030932 2365918 2365918 plaintiff Prowet Robert   586039 586039 Prowet, Robert, of Whaplod 0
5036821 2367645 2367645 defendant Wryght Henry husbandman 586039 586039 Wryght, Henry, of Whaplod, husbandman 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);