names

700 rows where place_id = 586057

✎ 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
3587825 1863838 1863838 defendant Leman John husbandman 586057 586057 Leman, John, of Walpole, husbandman 0
3589984 1864508 1864508 defendant Hoste Edward   586057 586057 Hoste, Edward, of Walpole, wood broker 0
3593775 1865689 1865689 defendant Grysle Robert carter 586057 586057 Grysle, Robert, of Walpole, carter 3
3605433 1869365 1869365 defendant Cryspe John smith 586057 586057 Cryspe, John, of Walpole, smith 2
3616376 1872759 1872759 defendant Dyxson Adam husbandman 586057 586057 Dyxson, Adam, of Walpole, husbandman 6
3616524 1872804 1872804 defendant Thurston Edmund husbandman 586057 586057 Thurston, Edmund, of Walpole, husbandman 2
3616528 1872805 1872805 defendant Thurston Edmund husbandman 586057 586057 Thurston, Edmund, of Walpole, husbandman 2
3626289 1903078 1903078 defendant Boocher George butcher 586057 586057 Boocher, George, of Walpole, butcher 2
3630256 1904312 1904312 defendant Bocher George husbandman 586057 586057 Bocher, George, of Walpole, husbandman 0
3631771 1904743 1904743 defendant Nele Nicholas husbandman 586057 586057 Nele, Nicholas, of Walpole, husbandman 7
3631772 1904743 1904743 defendant Howlett William husbandman 586057 586057 Howlett, William, of Walpole, husbandman 8
3632317 1904928 1904928 plaintiff Herryson John (legal representative) 586057 586057 Herryson, John, of Walpole, executor of 0
3632318 1904928 1904928 plaintiff Nycholson Robert   586057 586057 Nycholson, Robert, of Walpole 1
3632319 1904928 1904928 defendant Goche Peter yeoman 586057 586057 Goche, Peter, of Walpole, yeoman 0
3633790 1905383 1905383 defendant Whelpdale William yeoman 586057 586057 Whelpdale, William, of Walpole, yeoman 0
3634136 1905476 1905476 defendant Mayour John husbandman 586057 586057 Mayour, John, of Walpole, husbandman 0
3641224 1907706 1907706 plaintiff Benet John   586057 586057 Benet, John, of Walpole 0
3645264 1908926 1908926 defendant Reppes John husbandman 586057 586057 Reppes, John, of Walpole, husbandman 0
3645265 1908926 1908926 defendant Kynne Richard butcher 586057 586057 Kynne, Richard, of Walpole, butcher 1
3650545 1910538 1910538 plaintiff Howlett William   586057 586057 Howlett, William, of Walpole 1
3655013 1911832 1911832 defendant Whelpdale William brewer 586057 586057 Whelpdale, William, of Walpole, brewer 0
3655015 1911833 1911833 defendant Whelpdale William brewer 586057 586057 Whelpdale, William, of Walpole, brewer 0
3656096 1912159 1912159 defendant Odyerne William husbandman 586057 586057 Odyerne, William, of Walpole, husbandman 0
3656109 1912163 1912163 defendant Odyern William husbandman 586057 586057 Odyern, William, of Walpole, husbandman 0
3658769 1912998 1912998 defendant Shepherd John husbandman 586057 586057 Shepherd, John, of Walpole, husbandman 2
3658771 1912999 1912999 defendant Nele William husbandman 586057 586057 Nele, William, of Walpole, husbandman 0
3658773 1912999 1912999 defendant shepherd John husbandman 586057 586057 shepherd, John, of Walpole, husbandman 2
3658774 1912999 1912999 defendant Lowthe William husbandman 586057 586057 Lowthe, William, of Walpole, husbandman 3
3659752 1913303 1913303 defendant Male William hsubandman 586057 586057 Male, William, of Walpole, hsubandman 1
3659755 1913304 1913304 defendant Male William husbandman 586057 586057 Male, William, of Walpole, husbandman 1
3659760 1913306 1913306 defendant Shepherd John husbandman 586057 586057 Shepherd, John, of Walpole, husbandman 1
3676949 1918827 1918827 defendant Austeyn Walter husbandman 586057 586057 Austeyn, Walter, of Walpole, husbandman 0
3676950 1918827 1918827 defendant Plome Katherine widow 586057 586057 Plome, Katherine, of Walpole, widow 1
3676955 1918829 1918829 defendant Gyrlyng Simon husbandman 586057 586057 Gyrlyng, Simon, of Walpole, husbandman 1
3680101 1919843 1919843 defendant Snellyng John husbandman 586057 586057 Snellyng, John, of Walpole, husbandman 2
3680103 1919844 1919844 defendant Gunnell William husbandman 586057 586057 Gunnell, William, of Walpole, husbandman 0
3680105 1919844 1919844 defendant Algor Thomas husbandman 586057 586057 Algor, Thomas, of Walpole, husbandman 2
3681480 1920297 1920297 defendant Smyth John yeoman 586057 586057 Smyth, John, of Walpole, yeoman 0
3683558 1920990 1920990 plaintiff Smyth John   586057 586057 Smyth, John, of Walpole 1
3686180 1921840 1921840 defendant orgar John husbandman 586057 586057 orgar, John, of Walpole, husbandman 4
3693306 1924118 1924118 defendant Googe Peter husbandman 586057 586057 Googe, Peter, of Walpole, husbandman 0
3700872 1926518 1926518 defendant Parker George husbandman or cart driver 586057 586057 Parker, George, of Walpole, husbandman or cart driver 2
3705199 1927911 1927911 defendant Avyer Thomas husbandman 586057 586057 Avyer, Thomas, of Walpole, husbandman 3
3710679 1929660 1929660 defendant Whelpdale William yeoman 586057 586057 Whelpdale, William, of Walpole, yeoman 0
3719224 1932298 1932298 defendant Whelpdale William yeoman 586057 586057 Whelpdale, William, of Walpole, yeoman 0
3719227 1932299 1932299 defendant Wrygth John husbandman 586057 586057 Wrygth, John, of Walpole, husbandman 0
3719228 1932299 1932299 defendant Fallowfote Thomas husbandman 586057 586057 Fallowfote, Thomas, of Walpole, husbandman 1
3719231 1932299 1932299 defendant Whelpedale Gilbert husbandman 586057 586057 Whelpedale, Gilbert, of Walpole, husbandman 4
3720455 1932679 1932679 plaintiff Hunston Henry gent 586057 586057 Hunston, Henry, of Walpole, gent 0
3722088 1933170 1933170 defendant Odyern William husbandman 586057 586057 Odyern, William, of Walpole, husbandman 0
3728140 1935061 1935061 defendant Teste John husbandman 586057 586057 Teste, John, of Walpole, husbandman 0
3728142 1935062 1935062 defendant Smyth John yeoman 586057 586057 Smyth, John, of Walpole, yeoman 0
3728905 1935289 1935289 defendant Marten William, senior husbandman 586057 586057 Marten, William, senior, of Walpole, husbandman 0
3728906 1935289 1935289 defendant Rawlyn William husbandman 586057 586057 Rawlyn, William, of Walpole, husbandman 1
3728907 1935289 1935289 defendant Neale Simon husbandman 586057 586057 Neale, Simon, of Walpole, husbandman 2
3728908 1935289 1935289 defendant Marten William, junior husbandman 586057 586057 Marten, William, junior, of Walpole, husbandman 3
3728909 1935289 1935289 defendant Stephynson John, senior husbandman 586057 586057 Stephynson, John, senior, of Walpole, husbandman 4
3728986 1935312 1935312 defendant Nycolson Robert husbandman 586057 586057 Nycolson, Robert, of Walpole, husbandman 1
3728987 1935312 1935312 defendant Gyrdeyn Thomas husbandman 586057 586057 Gyrdeyn, Thomas, of Walpole, husbandman 2
3733284 1936643 1936643 plaintiff Smyth John   586057 586057 Smyth, John, of Walpole 2
3737371 1937926 1937926 defendant Tompson George butcher 586057 586057 Tompson, George, of Walpole, butcher 1
3737372 1937926 1937926 defendant Conok Thomas laborer 586057 586057 Conok, Thomas, of Walpole, laborer 2
3748317 1941403 1941403 defendant Akyrs John husbandman 586057 586057 Akyrs, John, of Walpole, husbandman 0
3763027 1946068 1946068 defendant Johnson Walter husbandman 586057 586057 Johnson, Walter, of Walpole, husbandman 0
3763028 1946068 1946068 defendant Hardyng Hugh husbandman 586057 586057 Hardyng, Hugh, of Walpole, husbandman 1
3763033 1946070 1946070 defendant Inman Robert husbandman 586057 586057 Inman, Robert, of Walpole, husbandman 0
3763034 1946070 1946070 defendant Pope Simon husbandman 586057 586057 Pope, Simon, of Walpole, husbandman 1
3764275 1946485 1946485 defendant Whelpdale William husbandman 586057 586057 Whelpdale, William, of Walpole, husbandman 0
3764276 1946485 1946485 defendant Sutton Andrew husbandman 586057 586057 Sutton, Andrew, of Walpole, husbandman 1
3764277 1946485 1946485 defendant Tovy John laborer 586057 586057 Tovy, John, of Walpole, laborer 2
3765782 1946963 1946963 defendant Whelpdale Gilbert husbandman 586057 586057 Whelpdale, Gilbert, of Walpole, husbandman 0
3765783 1946963 1946963 defendant Smetheson James husbandman 586057 586057 Smetheson, James, of Walpole, husbandman 1
3765784 1946963 1946963 defendant Yorke Edmund husbandman 586057 586057 Yorke, Edmund, of Walpole, husbandman 2
3765785 1946963 1946963 defendant Farthyng William husbandman 586057 586057 Farthyng, William, of Walpole, husbandman 3
3769501 1948123 1948123 defendant Peerson William husbandman 586057 586057 Peerson, William, of Walpole, husbandman 0
3770692 1948515 1948515 defendant Whelpdale William yeoman 586057 586057 Whelpdale, William, of Walpole, yeoman 0
3774900 1949879 1949879 defendant Masten Thomas husbandman 586057 586057 Masten, Thomas, of Walpole, husbandman 0
3774901 1949879 1949879 defendant Stephynson Thomas husbandman 586057 586057 Stephynson, Thomas, of Walpole, husbandman 1
3774902 1949879 1949879 defendant Watson Thomas husbandman 586057 586057 Watson, Thomas, of Walpole, husbandman 2
3791982 1955343 1955343 defendant Wright John husbandman 586057 586057 Wright, John, of Walpole, husbandman 0
3792246 1955428 1955428 defendant Wryght John husbandman 586057 586057 Wryght, John, of Walpole, husbandman, son of Wryght, Thomas, of Walpole, husbandman 2
3792247 1955428 1955428 defendant Grayton John, senior husbandman 586057 586057 Grayton, John, senior, of Walpole, husbandman 3
3804717 1959420 1959420 defendant Maydewell John carpenter 586057 586057 Maydewell, John, of Walpole, carpenter 0
3804718 1959420 1959420 defendant Browne John husbandman 586057 586057 Browne, John, of Walpole, husbandman 1
3808472 1960528 1960528 defendant Folyfote Robert husbandman 586057 586057 Folyfote, Robert, of Walpole, husbandman 1
3808473 1960528 1960528 defendant Wylson William tailor 586057 586057 Wylson, William, of Walpole, tailor 2
3808475 1960529 1960529 defendant Marten John husbandman 586057 586057 Marten, John, of Walpole, husbandman 0
3808476 1960529 1960529 defendant Watson Thomas husbandman 586057 586057 Watson, Thomas, of Walpole, husbandman 1
3808477 1960529 1960529 defendant Bayly Lambert husbandman 586057 586057 Bayly, Lambert, of Walpole, husbandman 2
3808646 1960584 1960584 defendant Bayley Lambert husbandman 586057 586057 Bayley, Lambert, of Walpole, husbandman 2
3808650 1960585 1960585 defendant Bayley Lambert husbandman 586057 586057 Bayley, Lambert, of Walpole, husbandman 2
3808853 1960649 1960649 defendant Johnson Walter thatcher 586057 586057 Johnson, Walter, of Walpole, thatcher 1
3813927 1962265 1962265 defendant Wylkynson Henry laborer 586057 586057 Wylkynson, Henry, of Walpole, laborer 0
3817400 1963356 1963356 defendant Whelpdale Gilbert husbandman 586057 586057 Whelpdale, Gilbert, of Walpole, husbandman 1
3817403 1963356 1963356 defendant Andrewe Richard husbandman 586057 586057 Andrewe, Richard, of Walpole, husbandman 4
3820094 1964161 1964161 defendant Nicholson Robert husbandman 586057 586057 Nicholson, Robert, of Walpole, husbandman 0
3820869 1964421 1964421 defendant Burtur Henry yeoman 586057 586057 Burtur, Henry, of Walpole, yeoman 0
3820870 1964421 1964421 defendant West Simon yeoman 586057 586057 West, Simon, of Walpole, yeoman 1
3831410 1967711 1967711 defendant Andrew William husbandman 586057 586057 Andrew, William, of Walpole, husbandman 3
3843634 1971543 1971543 defendant Jonson John butcher 586057 586057 Jonson, John, of Walpole, butcher 1

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