names

396 rows where place_id = 586364

✎ 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
3588528 1864056 1864056 defendant Thorn John butcher 586364 586364 Thorn, John, of Long Stratton, butcher 0
3591288 1864901 1864901 plaintiff Drake Thomas   586364 586364 Drake, Thomas, of Long Stratton 0
3592814 1865365 1865365 defendant Clerk John yeoman 586364 586364 Clerk, John, of Long Stratton, yeoman 1
3597901 1866965 1866965 defendant Wryght Peter husbandman 586364 586364 Wryght, Peter, of Long Stratton, husbandman 0
3599139 1867367 1867367 plaintiff Thorn John   586364 586364 Thorn, John, of Long Stratton 0
3600299 1867739 1867739 defendant Thorn John butcher 586364 586364 Thorn, John, of Long Stratton, butcher 0
3601869 1868238 1868238 defendant Thorne John butcher 586364 586364 Thorne, John, of Long Stratton, butcher 2
3605117 1869265 1869265 defendant Hobberd John scrivener 586364 586364 Hobberd, John, of Long Stratton, scrivener 3
3605118 1869265 1869265 defendant Hobberd Robert scrivener 586364 586364 Hobberd, Robert, of Long Stratton, scrivener 4
3612788 1871651 1871651 defendant Thorn John butcher 586364 586364 Thorn, John, of Long Stratton, butcher 0
3613838 1871982 1871982 defendant Thorn John husbandman 586364 586364 Thorn, John, of Long Stratton, husbandman 3
3615916 1872618 1872618 defendant Calffe John husbandman 586364 586364 Calffe, John, of Long Stratton, husbandman 1
3632367 1904943 1904943 defendant Sexten Robert husbandman 586364 586364 Sexten, Robert, of Long Stratton, husbandman 1
3632368 1904943 1904943 defendant Heth William husbandman 586364 586364 Heth, William, of Long Stratton, husbandman 2
3637200 1906435 1906435 plaintiff Sexteyn John   586364 586364 Sexteyn, John, of Long Stratton 0
3641907 1907923 1907923 plaintiff Browne William   586364 586364 Browne, William, of Long Stratton 0
3643279 1908322 1908322 defendant Bery Richard husbandman 586364 586364 Bery, Richard, of Long Stratton, husbandman 0
3645511 1908995 1908995 defendant Sendell Simon yeoman 586364 586364 Sendell, Simon, of Long Stratton, yeoman 7
3649826 1910309 1910309 defendant Hunte John husbandman 586364 586364 Hunte, John, of Long Stratton, husbandman 1
3654143 1911558 1911558 defendant Turnour Geoffrey husbandman 586364 586364 Turnour, Geoffrey, of Long Stratton, husbandman 1
3655750 1912057 1912057 defendant Lannam James husbandman 586364 586364 Lannam, James, of Long Stratton, husbandman 2
3664105 1914725 1914725 defendant Hunte John husbandman 586364 586364 Hunte, John, of Long Stratton, husbandman 1
3665331 1915112 1915112 defendant Levald John husbandman 586364 586364 Levald, John, of Long Stratton, husbandman 1
3668354 1916049 1916049 defendant Laneman James, senior husbandman 586364 586364 Laneman, James, senior, of Long Stratton, husbandman 3
3670412 1916702 1916702 plaintiff Browne William butcher 586364 586364 Browne, William, of Long Stratton, butcher 0
3672263 1917324 1917324 defendant Sexten George pewterer 586364 586364 Sexten, George, of Long Stratton, pewterer 1
3672264 1917324 1917324 defendant Sexten William pewterer 586364 586364 Sexten, William, of Long Stratton, pewterer 2
3674616 1918112 1918112 defendant Broun William innholder 586364 586364 Broun, William, of Long Stratton, innholder 0
3674618 1918113 1918113 defendant Brown William innholder 586364 586364 Brown, William, of Long Stratton, innholder 0
3680200 1919879 1919879 defendant Hunte John husbandman 586364 586364 Hunte, John, of Long Stratton, husbandman 2
3683411 1920934 1920934 plaintiff Warde Thomas chaplain 586364 586364 Warde, Thomas, of Long Stratton, chaplain 0
3683412 1920934 1920934 defendant Broune William butcher 586364 586364 Broune, William, of Long Stratton, butcher 0
3684182 1921190 1921190 defendant Stevynson John yeoman 586364 586364 Stevynson, John, of Long Stratton, yeoman 0
3684183 1921190 1921190 defendant Grene John butcher 586364 586364 Grene, John, of Long Stratton, butcher 1
3687464 1922257 1922257 defendant Bery Richard husbandman 586364 586364 Bery, Richard, of Long Stratton, husbandman 2
3694449 1924469 1924469 defendant Sendell Simon yeoman 586364 586364 Sendell, Simon, of Long Stratton, yeoman 1
3694452 1924470 1924470 defendant Sendell Simon yeoman 586364 586364 Sendell, Simon, of Long Stratton, yeoman 1
3704100 1927571 1927571 defendant Den Thomas husbandman 586364 586364 (Den, Thomas, of Long Stratton, husbandman 1
3704101 1927571 1927571 defendant Norton William laborer 586364 586364 Norton, William, of Long Stratton, laborer 2
3704459 1927690 1927690 defendant Hunt John husbandman 586364 586364 Hunt, John, of Long Stratton, husbandman 2
3706910 1928447 1928447 defendant Warde Thomas chaplain 586364 586364 Warde, Thomas, of Long Stratton, chaplain 2
3706911 1928447 1928447 defendant Sendell Simon husbandman 586364 586364 Sendell, Simon, of Long Stratton, husbandman 3
3712322 1930171 1930171 plaintiff Wawen Richard tailor 586364 586364 Wawen, Richard, of Long Stratton, tailor 0
3712326 1930171 1930171 defendant Turnour Geoffrey butcher 586364 586364 Turnour, Geoffrey, of Long Stratton, butcher 3
3716619 1931495 1931495 defendant Harward Richard smith 586364 586364 Harward, Richard, of Long Stratton, smith 1
3729063 1935340 1935340 defendant Goolde John husbandman 586364 586364 Goolde, John, of Long Stratton, husbandman 0
3731718 1936150 1936150 defendant Broun William butcher 586364 586364 Broun, William, of Long Stratton, butcher 0
3737883 1938068 1938068 defendant Wyllott Richard pewterer 586364 586364 Wyllott, Richard, of Long Stratton, pewterer 1
3737886 1938069 1938069 defendant Wyllott Richard pewterer 586364 586364 Wyllott, Richard, of Long Stratton, pewterer 1
3738453 1938231 1938231 defendant Wright Peter husbandman 586364 586364 Wright, Peter, of Long Stratton, husbandman 3
3744752 1940256 1940256 defendant Gall Thomas husbandman 586364 586364 Gall, Thomas, of Long Stratton, husbandman 0
3749588 1941784 1941784 defendant Malden Alexander showmaker 586364 586364 Malden, Alexander, of Long Stratton, showmaker 0
3750245 1941994 1941994 defendant Kyryson William butcher 586364 586364 Kyryson, William, of Long Stratton, butcher 0
3751930 1942520 1942520 defendant Parson John clerk 586364 586364 Parson, John, of Long Stratton, clerk 0
3754799 1943458 1943458 defendant Maget Robert husbandman 586364 586364 Maget, Robert, of Long Stratton, husbandman 0
3754800 1943458 1943458 defendant Swayne John husbandman 586364 586364 Swayne, John, of Long Stratton, husbandman 1
3757225 1944243 1944243 defendant Gall Thomas husbandman 586364 586364 Gall, Thomas, of Long Stratton, husbandman 0
3759371 1944919 1944919 defendant Gery Richard pedder 586364 586364 Gery, Richard, of Long Stratton, pedder 3
3759415 1944933 1944933 defendant Bery Richard husbandman 586364 586364 Bery, Richard, of Long Stratton, husbandman 4
3763997 1946381 1946381 defendant Stevynson Richard husbandman 586364 586364 Stevynson, Richard, of Long Stratton, husbandman 0
3781008 1951791 1951791 defendant Heth William husbandman 586364 586364 Heth, William, of Long Stratton, husbandman 0
3783295 1952527 1952527 defendant Warde Thomas clerk 586364 586364 Warde, Thomas, of Long Stratton, clerk 0
3785278 1953183 1953183 defendant Castelten Robert husbandman 586364 586364 Castelten, Robert, of Long Stratton, husbandman 0
3787954 1954025 1954025 defendant Sparham John yeoman 586364 586364 Sparham, John, of Long Stratton, yeoman 0
3788193 1954105 1954105 defendant Rysyng Robert mercer 586364 586364 Rysyng, Robert, of Long Stratton, mercer 0
3791667 1955238 1955238 defendant Mere Thomas husbandman 586364 586364 Mere, Thomas, of Long Stratton, husbandman 1
3791668 1955238 1955238 defendant Stevynson Richard husbandman 586364 586364 Stevynson, Richard, of Long Stratton, husbandman 2
3793836 1955938 1955938 defendant Castelton Nicholas butcher 586364 586364 Castelton, Nicholas, of Long Stratton, butcher 1
3797286 1957038 1957038 defendant Colman Robert butcher 586364 586364 Colman, Robert, of Long Stratton, butcher 0
3797287 1957038 1957038 defendant Brown William butcher 586364 586364 Brown, William, of Long Stratton, butcher 1
3797288 1957038 1957038 defendant Colman William husbandman 586364 586364 Colman, William, of Long Stratton, husbandman 2
3798616 1957474 1957474 defendant Greve Thomas butcher 586364 586364 Greve, Thomas, of Long Stratton, butcher 0
3800773 1958154 1958154 defendant Mere Thomas husbandman 586364 586364 Mere, Thomas, of Long Stratton, husbandman 1
3800777 1958156 1958156 defendant Wyllet Richard husbandman 586364 586364 Wyllet, Richard, of Long Stratton, husbandman 0
3800778 1958156 1958156 defendant Mere Thomas husbandman 586364 586364 Mere, Thomas, of Long Stratton, husbandman 1
3800779 1958156 1958156 defendant Stevynson Richard husbandman 586364 586364 Stevynson, Richard, of Long Stratton, husbandman 2
3802169 1958575 1958575 defendant Castelton Nicholas butcher 586364 586364 Castelton, Nicholas, of Long Stratton, butcher 0
3803530 1959011 1959011 defendant Castelton Nicholas butcher 586364 586364 Castelton, Nicholas, of Long Stratton, butcher 0
3803548 1959016 1959016 defendant Johnson John husbandman 586364 586364 Johnson, John, of Long Stratton, husbandman 4
3806474 1959939 1959939 defendant Armyard John yeoman 586364 586364 Armyard, John, of Long Stratton, yeoman 0
3808598 1960568 1960568 defendant Stevynson Richard yeoman 586364 586364 Stevynson, Richard, of Long Stratton, yeoman 0
3809463 1960842 1960842 defendant Stephenson Richard husbandman 586364 586364 Stephenson, Richard, of Long Stratton, husbandman 0
3816329 1963015 1963015 defendant Stevenson Richard yeoman 586364 586364 Stevenson, Richard, of Long Stratton, yeoman 1
3816762 1963149 1963149 defendant Sendell Simon husbandman 586364 586364 Sendell, Simon, of Long Stratton, husbandman 0
3817020 1963234 1963234 defendant Castelyn Robert butcher 586364 586364 Castelyn, Robert, of Long Stratton, butcher 0
3819955 1964122 1964122 defendant Casleyn Robert butcher 586364 586364 Casleyn, Robert, of Long Stratton, butcher 1
3826923 1966271 1966271 defendant Erle William husbandman 586364 586364 Erle, William, of Long Stratton, husbandman 1
3830537 1967428 1967428 defendant Castelten Robert butcher 586364 586364 Castelten, Robert, of Long Stratton, butcher 0
3836970 1969470 1969470 defendant Caslen alias Cassylton Robert butcher 586364 586364 Caslen alias Cassylton, Robert, of Long Stratton, butcher 0
3840758 1970675 1970675 defendant Holland Richard tailor 586364 586364 Holland, Richard, of Long Stratton, tailor 0
3841436 1970901 1970901 defendant Wylsher William husbandman 586364 586364 Wylsher, William, of Long Stratton, husbandman 0
3841439 1970901 1970901 defendant Johnson John, junior laborer 586364 586364 Johnson, John, junior, of Long Stratton, laborer 3
3842175 1971101 1971101 defendant Rysyng Robert raffman 586364 586364 Rysyng, Robert, of Long Stratton, raffman 2
3846553 1972479 1972479 defendant Stanton Nicholas yeoman 586364 586364 Stanton, Nicholas, of of Long Stratton, yeoman 1
3851579 1974081 1974081 defendant Casleyn Robert butcher 586364 586364 Casleyn, Robert, of Long Stratton, butcher 0
3852466 1974378 1974378 defendant Casselyng Robert butcher 586364 586364 Casselyng, Robert, of Long Stratton, butcher 0
3852668 1974441 1974441 defendant Rysyng Robert mercer 586364 586364 Rysyng, Robert, of Long Stratton, mercer 2
3853836 1974831 1974831 defendant Shwayne alias Wayne John husbandman 586364 586364 Shwayne alias Wayne, John, of Long Stratton, husbandman 1
3853837 1974831 1974831 defendant Levold John husbandman 586364 586364 Levold, John, of Long Stratton, husbandman 2
3857364 1975938 1975938 plaintiff Armygerd John husbandman 586364 586364 Armygerd, John, of Long Stratton, 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);