names

352 rows where place_id = 588755

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3595477 1866220 1866220 defendant Tyler William husbandman 588755 588755 Tyler, William, of Teryngton, husbandman 1
3597461 1866825 1866825 plaintiff Russell Robert   588755 588755 Russell, Robert, of Teryngton 0
3597463 1866826 1866826 plaintiff Russell Robert   588755 588755 Russell, Robert, of Teryngton 0
3597465 1866827 1866827 plaintiff Russell Robert   588755 588755 Russell, Robert, of Teryngton 0
3604357 1869029 1869029 defendant Russell Robert yeoman 588755 588755 Russell, Robert, of Teryngton, yeoman 1
3613551 1871886 1871886 defendant Marshall William yeoman 588755 588755 Marshall, William, of Teryngton, yeoman 0
3613603 1871900 1871900 defendant Baldyng alias Faux John yeoman 588755 588755 Baldyng alias Faux, John, of Teryngton, yeoman 0
3613617 1871903 1871903 defendant Russell Robert yeoman 588755 588755 Russell, Robert, of Teryngton, yeoman 0
3621387 1874229 1874229 defendant Cuttyng Richard husbandman 588755 588755 Cuttyng, Richard, of Teryngton, husbandman 1
3624439 1875178 1875178 defendant Warner Nicholas husbandman 588755 588755 Warner, Nicholas, of Teryngton, husbandman 2
3626995 1903303 1903303 plaintiff Bek William (legal representative) 588755 588755 Bek, William, of Teryngton, executor of 0
3626996 1903303 1903303 plaintiff Dekon Thomas   588755 588755 Dekon, Thomas, of Teryngton 1
3626997 1903303 1903303 defendant Lynghoke Walter (legal representative) 588755 588755 Lynghoke, Walter, of Teryngton, executor of Lynghoke, Simon, of Tylney, husbandman, executors of 0
3626998 1903303 1903303 defendant Skutt John husbandman 588755 588755 (Skutt, John, of Teryngton, husbandman 1
3628298 1903713 1903713 defendant Dykon Thomas yeoman 588755 588755 Dykon, Thomas, of Teryngton, yeoman 0
3628300 1903714 1903714 defendant Hardy John yeoman 588755 588755 Hardy, John, of Teryngton, yeoman 0
3629565 1904105 1904105 defendant Marshall William yeoman 588755 588755 Marshall, William, of Teryngton, yeoman 0
3629566 1904105 1904105 defendant Bentley Edmund yeoman 588755 588755 Bentley, Edmund, of Teryngton, yeoman 1
3631765 1904743 1904743 defendant Lynghoke Robert   588755 588755 Lynghoke, Robert, of Teryngton, shepherd 1
3631766 1904743 1904743 defendant Boston Robert husbandman 588755 588755 Boston, Robert, of Teryngton, husbandman 2
3631767 1904743 1904743 defendant Baldyng John husbandman 588755 588755 Baldyng, John, of Teryngton, husbandman 3
3631768 1904743 1904743 defendant Godard Thomas husbandman 588755 588755 Godard, Thomas, of Teryngton, husbandman 4
3631769 1904743 1904743 defendant Leke William husbandman 588755 588755 Leke, William, of Teryngton, husbandman 5
3631770 1904743 1904743 defendant Lynghoke William husbandman 588755 588755 Lynghoke, William, of Teryngton, husbandman 6
3634133 1905475 1905475 defendant Feltwell Reginald husbandman 588755 588755 Feltwell, Reginald, of Teryngton, husbandman 0
3637937 1906683 1906683 defendant Thompson Thomas husbandman 588755 588755 Thompson, Thomas, of Teryngton, husbandman 0
3637938 1906683 1906683 defendant Baldyng Henry husbandman 588755 588755 Baldyng, Henry, of Teryngton, husbandman 1
3646425 1909277 1909277 defendant Ketylborn Peter yeoman 588755 588755 Ketylborn, Peter, of Teryngton, yeoman 1
3649888 1910328 1910328 defendant Baldyng Henry husbandman 588755 588755 Baldyng, Henry, of Teryngton, husbandman 0
3658772 1912999 1912999 defendant Deynys John husbandman 588755 588755 Deynys, John, of Teryngton, husbandman 1
3659895 1913352 1913352 defendant Feltwell Reginald husbandman 588755 588755 Feltwell, Reginald, of Teryngton, husbandman 0
3672523 1917408 1917408 defendant Godard John husbandman 588755 588755 Godard, John, of Teryngton, husbandman 1
3672524 1917408 1917408 defendant Aylewyn Emma widow 588755 588755 Aylewyn, Emma, of Teryngton, widow 2
3683559 1920990 1920990 defendant Laxham David husbandman 588755 588755 Laxham, David, of Teryngton, husbandman 0
3706766 1928401 1928401 defendant Knyght John chaplain 588755 588755 Knyght, John, of Teryngton, chaplain 0
3706768 1928402 1928402 defendant Knyght John chaplain 588755 588755 Knyght, John, of Teryngton, chaplain 0
3709104 1929146 1929146 defendant Lynghoke John yeoman 588755 588755 Lynghoke, John, of Teryngton, yeoman 0
3711064 1929771 1929771 defendant Stevenson William (legal representative) 588755 588755 Stevenson, William, of Teryngton, husbandman, executors of 3
3711065 1929771 1929771 defendant Smyth Edmund laborer 588755 588755 (Smyth, Edmund, of Teryngton, laborer 4
3714042 1930691 1930691 defendant Byntree John   588755 588755 Byntree, John, of Teryngton, minstrel 0
3715627 1931175 1931175 defendant Bethe Thomas husbandman 588755 588755 Bethe, Thomas, of Teryngton, husbandman 0
3728771 1935240 1935240 defendant Wryght Walter husbandman 588755 588755 Wryght, Walter, of Teryngton, husbandman 0
3732279 1936336 1936336 defendant Walbot Thomas husbandman 588755 588755 Walbot, Thomas, of Teryngton, husbandman 0
3732281 1936337 1936337 defendant Wryght Walter husbandman 588755 588755 Wryght, Walter, of Teryngton, husbandman 0
3737370 1937926 1937926 defendant Benethegayte Thomas laborer 588755 588755 Benethegayte, Thomas, of Teryngton, laborer 0
3737757 1938031 1938031 plaintiff Lynghoke John yeoman 588755 588755 Lynghoke, John, of Teryngton, yeoman 0
3765675 1946929 1946929 defendant Proude Thomas husbandman 588755 588755 Proude, Thomas, of Teryngton, husbandman 3
3779642 1951362 1951362 defendant Gelyn Robert thatcher 588755 588755 Gelyn, Robert, of Teryngton, thatcher 0
3795946 1956594 1956594 defendant Russell Robert (legal representative) 588755 588755 Russell, Robert, of Teryngton, yeoman, executor of 0
3797909 1957244 1957244 defendant Baldyng Henry husbandman 588755 588755 Baldyng, Henry, of Teryngton, husbandman 1
3817399 1963356 1963356 defendant Lacy Richard yeoman 588755 588755 Lacy, Richard, of Teryngton, yeoman 0
3846478 1972452 1972452 defendant Pekket Thomas yeoman 588755 588755 Pekket, Thomas, of Teryngton, yeoman 0
3848991 1973280 1973280 defendant Lacy Richard husbandman 588755 588755 Lacy, Richard, of Teryngton, husbandman 0
3849038 1973294 1973294 defendant Lynghoke Richard husbandman 588755 588755 Lynghoke, Richard, of Teryngton, husbandman 0
3849040 1973294 1973294 defendant Baldyng John butcher 588755 588755 Baldyng, John, of Teryngton, butcher 2
3862435 1977630 1977630 defendant Andrewe Gilbert husbandman 588755 588755 Andrewe, Gilbert, of Teryngton, husbandman 2
3864769 1978412 1978412 defendant Chapell Robert weaver 588755 588755 Chapell, Robert, of Teryngton, weaver 0
3878272 1982982 1982982 defendant Baldyng John butcher 588755 588755 Baldyng, John, of Teryngton, butcher 0
3878273 1982982 1982982 defendant Talpe William husbandman 588755 588755 Talpe, William, of Teryngton, husbandman 1
3878401 1983023 1983023 defendant Hedlam Richard gent 588755 588755 Hedlam, Richard, of Teryngton, gent 3
3883693 1984817 1984817 defendant Pekett Thomas husbandman 588755 588755 Pekett, Thomas, of Teryngton, husbandman 0
3884617 1985127 1985127 defendant Grafton Thomas, junior butcher 588755 588755 Grafton, Thomas, junior, of Teryngton, butcher 2
3885093 1985273 1985273 defendant Fardyng John, senior husbandman 588755 588755 Fardyng, John, senior, of Teryngton, husbandman 0
3885096 1985274 1985274 defendant Talpe Walter yeoman 588755 588755 Talpe, Walter, of Teryngton, yeoman 1
3885097 1985274 1985274 defendant Talpe John yeoman 588755 588755 Talpe, John, of Teryngton, yeoman 2
3889447 1986702 1986702 defendant Brakenbery Richard yeoman 588755 588755 Brakenbery, Richard, of Teryngton, yeoman 2
3889451 1986702 1986702 defendant Archylle John husbandman 588755 588755 Archylle, John, of Teryngton, husbandman 6
3901789 1990821 1990821 defendant Massam William husbandman 588755 588755 Massam, William, of Teryngton, husbandman 0
3901790 1990821 1990821 defendant Pekett Thomas husbandman 588755 588755 Pekett, Thomas, of Teryngton, husbandman 1
3901791 1990821 1990821 defendant Snowball John husbandman 588755 588755 Snowball, John, of Teryngton, husbandman 2
3901792 1990821 1990821 defendant Prowde Thomas husbandman 588755 588755 Prowde, Thomas, of Teryngton, husbandman 3
3903913 1991547 1991547 defendant Baker Cecilia widow 588755 588755 Baker, Cecilia, of Teryngton, widow 0
3905921 1992264 1992264 defendant Lynghoke Richard husbandman 588755 588755 Lynghoke, Richard, of Teryngton, husbandman 0
3908207 1993043 1993043 defendant Nelle alias Baker Richard (legal representative) 588755 588755 Nelle alias Baker, Richard, of Teryngton, gent, executrix of 0
3908208 1993043 1993043 defendant Nelle alias Baker Cecilia widow 588755 588755 Nelle alias Baker, Cecilia, of Teryngton, widow 1
3909929 1993628 1993628 defendant Godard Henry husbandman 588755 588755 Godard, Henry, of Teryngton, husbandman 0
3909930 1993628 1993628 defendant Smyth Stephen husbandman 588755 588755 Smyth, Stephen, of Teryngton, husbandman 1
3909931 1993628 1993628 defendant Johnson John husbandman 588755 588755 Johnson, John, of Teryngton, husbandman 2
3910371 1993788 1993788 plaintiff Tharold Robert chaplain 588755 588755 Tharold, Robert, of Teryngton, chaplain 0
3919896 1996987 1996987 defendant Baker alias Nele Cecilia widow 588755 588755 Baker alias Nele, Cecilia, of Teryngton, widow 0
3923777 1998257 1998257 defendant Stevynson John husbandman 588755 588755 Stevynson, John, of Teryngton, husbandman 0
3923782 1998258 1998258 defendant Godard Henry husbandman 588755 588755 Godard, Henry, of Teryngton, husbandman 0
3928032 1999711 1999711 defendant Denyson John yeoman 588755 588755 Denyson, John, of Teryngton, yeoman 1
3929072 2000062 2000062 defendant Smith John husbandman 588755 588755 Smith, John, of Teryngton, husbandman 0
3929073 2000062 2000062 defendant Tompson Lawrence husbandman 588755 588755 Tompson, Lawrence, of Teryngton, husbandman 1
3931324 2000768 2000768 defendant Hunt Ambrose husbandman 588755 588755 Hunt, Ambrose, of Teryngton, husbandman 0
3933194 2001397 2001397 defendant Mene Robert yeoman 588755 588755 Mene, Robert, of Teryngton, yeoman 0
3933196 2001398 2001398 defendant Nixson Thomas yeoman 588755 588755 Nixson, Thomas, of Teryngton, yeoman 0
3956470 2009327 2009327 defendant Dennyson John husbandman 588755 588755 Dennyson, John, of Teryngton, husbandman 0
3956472 2009328 2009328 defendant Denyson John husbandman 588755 588755 Denyson, John, of Teryngton, husbandman 0
3958858 2010181 2010181 defendant Lawson Augustine yeoman 588755 588755 Lawson, Augustine, of Teryngton, yeoman 0
3959399 2010371 2010371 plaintiff Sheryng John yeoman 588755 588755 Sheryng, John, of Teryngton, yeoman 0
3959401 2010371 2010371 defendant Gyrden John yeoman 588755 588755 Gyrden, John, of Teryngton, yeoman 1
3989733 2021073 2021073 defendant Whynk John yeoman 588755 588755 Whynk, John, of Teryngton, yeoman 0
3996067 2023346 2023346 defendant Suterbye Nicholas husbandman 588755 588755 Suterbye, Nicholas, of Teryngton, husbandman 1
4018769 2031446 2031446 plaintiff Walbott Katherine   588755 588755 Walbott, Katherine, of Teryngton, widow, administrators of 0
4038159 2038288 2038288 plaintiff Ladd alias Baker Richard gent 588755 588755 Ladd alias Baker, Richard, of Teryngton, gent 0
4045981 2041009 2041009 defendant Sutterby Henry husbandman 588755 588755 Sutterby, Henry, of Teryngton, husbandman 1
4047203 2041450 2041450 plaintiff Stallon Thomas (legal representative) 588755 588755 Stallon, Thomas, of Teryngton, yeoman, executrix of 0
4092930 2057781 2057781 defendant Rychers John yeoman 588755 588755 Rychers, John, of Teryngton, yeoman 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);