names

250 rows where place_id = 586516

✎ 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
3588939 1864193 1864193 defendant Buschop Edmund husbandman 586516 586516 Buschop, Edmund, of Marsham, husbandman 0
3607659 1870050 1870050 defendant Busshop Edmund yeoman 586516 586516 Busshop, Edmund, of Marsham, yeoman 0
3609238 1870553 1870553 defendant Tegge William butcher 586516 586516 Tegge, William, of Marsham, butcher 0
3633110 1905167 1905167 defendant Harvy Henry   586516 586516 Harvy, Henry, of Marsham, worsted weaver 1
3637100 1906403 1906403 defendant Harvy Henry   586516 586516 Harvy, Henry, of Marsham, worsted weaver 0
3640133 1907360 1907360 defendant Hervy Henry   586516 586516 Hervy, Henry, of Marsham, worsted weaver 0
3646138 1909193 1909193 defendant Bateman Robert   586516 586516 Bateman, Robert, of Marsham, worsted weaver 1
3648613 1909953 1909953 defendant Marsham John pedder 586516 586516 Marsham, John, of Marsham, pedder 4
3650568 1910545 1910545 defendant Camplyon Robert shoemaker 586516 586516 Camplyon, Robert, of Marsham, shoemaker 0
3650569 1910545 1910545 defendant Camplyon William   586516 586516 Camplyon, William, of Marsham, worsted weaver 1
3654824 1911768 1911768 defendant Camplyn Robert husbandman 586516 586516 Camplyn, Robert, of Marsham, husbandman 0
3660159 1913436 1913436 defendant Waltham Robert husbnadman 586516 586516 Waltham, Robert, of Marsham, husbnadman 4
3684315 1921229 1921229 defendant Lawes William   586516 586516 (Lawes, William, of Marsham, notary 2
3684321 1921230 1921230 defendant Lawes William   586516 586516 Lawes, William, of Marsham, notary 2
3730972 1935919 1935919 defendant Hill Thomas tanner 586516 586516 Hill, Thomas, of Marsham, tanner 2
3732355 1936356 1936356 defendant Smyth William   586516 586516 Smyth, William, of Marsham, worsted weaver 0
3737760 1938032 1938032 defendant Harvy Henry   586516 586516 Harvy, Henry, of Marsham, worsted weaver 0
3737763 1938032 1938032 defendant Harvy Robert   586516 586516 Harvy, Robert, of Marsham, worsted weaver 3
3743872 1939968 1939968 defendant Busshop Robert husbandman 586516 586516 Busshop, Robert, of Marsham, husbandman 0
3749591 1941784 1941784 defendant Hyll Thomas tanner 586516 586516 Hyll, Thomas, of Marsham, tanner 3
3752013 1942552 1942552 defendant Haylys William   586516 586516 Haylys, William, of Marsham, worsted weaver 1
3754060 1943216 1943216 defendant Smyth William   586516 586516 Smyth, William, of Marsham, worsted weaver 1
3761568 1945633 1945633 plaintiff Feryarre Anabile (legal representative) 586516 586516 Feryarre, Anabile, of Marsham, widow, executors of 0
3763985 1946377 1946377 defendant Harvy Henry   586516 586516 Harvy, Henry, of Marsham, worsted weaver 0
3770811 1948561 1948561 defendant Skarbroke Edmund   586516 586516 Skarbroke, Edmund, of Marsham, minstrel 0
3789737 1954621 1954621 defendant Carbrige Edmund husbandman 586516 586516 Carbrige, Edmund, of Marsham, husbandman 0
3794946 1956284 1956284 defendant Hyll Thomas tanner 586516 586516 Hyll, Thomas, of Marsham, tanner 0
3796008 1956613 1956613 defendant Smythe William   586516 586516 Smythe, William, of Marsham, worsted weaver 0
3816047 1962919 1962919 defendant Farror Thomas husbandman 586516 586516 Farror, Thomas, of Marsham, husbandman 0
3826555 1966152 1966152 defendant Pykard Joan widow 586516 586516 Pykard, Joan, of Marsham, widow 4
3826557 1966153 1966153 defendant Marsham Edward   586516 586516 Marsham, Edward, of Marsham, worsted weaver 0
3826558 1966153 1966153 defendant Harvy Robert   586516 586516 Harvy, Robert, of Marsham, worsted weaver 1
3830301 1967371 1967371 defendant Harvy Henry, senior   586516 586516 Harvy, Henry, senior, of Marsham, worsted weaver 1
3830303 1967371 1967371 defendant Smyth William husbandman 586516 586516 Smyth, William, of Marsham, husbandman 3
3833748 1968488 1968488 defendant Harvy Robert   586516 586516 Harvy, Robert, of Marsham, worsted weaver 0
3841082 1970784 1970784 defendant Tucke Simon   586516 586516 Tucke, Simon, of Marsham, worsted weaver 2
3846950 1972586 1972586 defendant Bustyng John   586516 586516 Bustyng, John, of Marsham, worsted weaver 1
3851371 1974029 1974029 defendant Sklater William yeoman 586516 586516 Sklater, William, of Marsham, yeoman 4
3851372 1974029 1974029 defendant Loge John yeoman 586516 586516 Loge, John, of Marsham, yeoman 5
3851377 1974031 1974031 defendant Parker William yeoman 586516 586516 Parker, William, of Marsham, yeoman 0
3851382 1974031 1974031 defendant Sklater William yeoman 586516 586516 Sklater, William, of Marsham, yeoman 5
3851383 1974031 1974031 defendant Longe John yeoman 586516 586516 Longe, John, of Marsham, yeoman 6
3851388 1974032 1974032 defendant Parker William laborer 586516 586516 Parker, William, of Marsham, laborer 3
3853970 1974879 1974879 defendant Smyth William   586516 586516 Smyth, William, of Marsham, worsted weaver 2
3857767 1976066 1976066 defendant Harvy Robert   586516 586516 Harvy, Robert, of Marsham, worsted weaver 2
3863396 1977953 1977953 defendant Tobe Simon   586516 586516 Tobe, Simon, of Marsham, worsted weaver 3
3863397 1977953 1977953 defendant Kebyte Robert husbandman 586516 586516 Kebyte, Robert, of Marsham, husbandman 4
3866918 1979174 1979174 defendant Howson Robert gent 586516 586516 Howson, Robert, of Marsham, gent 0
3870869 1980509 1980509 defendant Mors Alan   586516 586516 Mors, Alan, of Marsham, worsted weaver 1
3873197 1981250 1981250 plaintiff Bury John clerk 586516 586516 Bury, John, of Marsham, clerk 0
3875200 1981944 1981944 defendant Harvy Robert, senior   586516 586516 Harvy, Robert, senior, of Marsham, worsted weaver 0
3878601 1983091 1983091 defendant Marsham Edmund   586516 586516 Marsham, Edmund, of Marsham, worsted weaver 3
3878602 1983091 1983091 defendant Toke Simon   586516 586516 Toke, Simon, of Marsham, worsted weaver 4
3882685 1984475 1984475 plaintiff Toke alias Tucke Simon   586516 586516 Toke alias Tucke, Simon, of Marsham 0
3890563 1987106 1987106 defendant Carbroke Edward   586516 586516 Carbroke, Edward, of Marsham, minstrel 2
3893213 1987967 1987967 defendant Port Andrew husbandman 586516 586516 Port, Andrew, of Marsham, husbandman 1
3895661 1988752 1988752 defendant Hobson Andrew husbandman 586516 586516 Hobson, Andrew, of Marsham, husbandman 3
3903796 1991503 1991503 defendant Best Peter husbandman 586516 586516 Best, Peter, of Marsham, husbandman 0
3906399 1992429 1992429 defendant Harvye Robert   586516 586516 Harvye, Robert, of Marsham, worsted weaver 0
3908336 1993086 1993086 defendant Caryer Richard husbandman 586516 586516 Caryer, Richard, of Marsham, husbandman 2
3908341 1993087 1993087 defendant Caryer Richard husbandman 586516 586516 Caryer, Richard, of Marsham, husbandman 2
3909888 1993614 1993614 defendant Bulward John   586516 586516 Bulward, John, of Marsham, worsted weaver 1
3920097 1997056 1997056 defendant Gyles John husbandman 586516 586516 Gyles, John, of Marsham, husbandman 0
3922051 1997711 1997711 defendant Bulward John   586516 586516 Bulward, John, of Marsham, worsted weaver 0
3924590 1998540 1998540 plaintiff Tybenham William   586516 586516 Tybenham, William, of Marsham 0
3924591 1998540 1998540 defendant Hewett Robert warrner 586516 586516 Hewett, Robert, of Marsham, warrner 0
3960872 2010901 2010901 defendant Skott John   586516 586516 Skott, John, of Marsham, worsted weaver 0
3960887 2010906 2010906 defendant Berye Richard husbandman 586516 586516 Berye, Richard, of Marsham, husbandman 0
3965428 2012520 2012520 defendant Dixson Nicholas clerk 586516 586516 Dixson, Nicholas, of Marsham, clerk 1
3977814 2016812 2016812 defendant Dixon Richard clerk 586516 586516 Dixon, Richard, of Marsham, clerk 0
3983313 2018803 2018803 defendant Bery Robert clerk 586516 586516 Bery, Robert, of Marsham, clerk 2
3994995 2022955 2022955 defendant Grygbie Alexander gent 586516 586516 Grygbie, Alexander, of Marsham, or of Lynton, Kent, gent 1
3996726 2023592 2023592 plaintiff Dewyng John carpenter 586516 586516 Dewyng, John, of Marsham, carpenter 0
3996727 2023592 2023592 plaintiff Bustyng Robert   586516 586516 Bustyng, Robert, of Marsham, worsted weaver 1
4000819 2025062 2025062 defendant Smythe Michael yeoman 586516 586516 Smythe, Michael, of Marsham, yeoman 0
4017337 2030907 2030907 defendant Bury Robert clerk 586516 586516 Bury, Robert, of Marsham, clerk 0
4017733 2031048 2031048 defendant Louth John cooper 586516 586516 Louth, John, of Marsham, cooper 0
4042997 2039970 2039970 defendant Sower Robert husbandman 586516 586516 Sower, Robert, of Marsham, husbandman 2
4047532 2041569 2041569 defendant Lowthe John yeoman 586516 586516 Lowthe, John, of Marsham, yeoman 0
4047534 2041570 2041570 defendant Lowthe John yeoman 586516 586516 Lowthe, John, of Marsham, yeoman 0
4047538 2041571 2041571 defendant Lowthe Nicholas husbandman 586516 586516 Lowthe, Nicholas, of Marsham, husbandman 0
4087295 2055747 2055747 defendant Sowgate Roger husbandman 586516 586516 Sowgate, Roger, of Marsham, husbandman 1
4088821 2056303 2056303 defendant Browne John gent 586516 586516 Browne, John, of Marsham, gent 0
4095285 2058638 2058638 defendant Lowthe John yeoman 586516 586516 Lowthe, John, of Marsham, yeoman 0
4095286 2058638 2058638 defendant Marsham Robert yeoman 586516 586516 Marsham, Robert, of Marsham, yeoman 1
4095287 2058638 2058638 defendant Bridgham Thomas cooper 586516 586516 Bridgham, Thomas, of Marsham, cooper 2
4151645 2078690 2078690 defendant Lowth John cooper 586516 586516 Lowth, John, of Marsham, yeoman, cooper 0
4151647 2078691 2078691 defendant Lowthe John cooper 586516 586516 Lowthe, John, of Marsham, yeoman, cooper 0
4171734 2085580 2085580 defendant Hall Richard yeoman 586516 586516 Hall, Richard, of Marsham, yeoman 0
4171744 2085581 2085581 defendant Hall Richard yeoman 586516 586516 Hall, Richard, of Marsham, yeoman 0
4171754 2085582 2085582 defendant Hall Richard yeoman 586516 586516 Hall, Richard, of Marsham, yeoman 0
4183489 2089706 2089706 defendant Lowthe John yeoman 586516 586516 Lowthe, John, of Marsham, yeoman 0
4193050 2093137 2093137 defendant Lowthe John husbandman 586516 586516 Lowthe, John, of Marsham, husbandman 0
4193051 2093137 2093137 defendant Pye Richard yeoman 586516 586516 Pye, Richard, of Marsham, yeoman 1
4193052 2093137 2093137 defendant Marsham George husbandman 586516 586516 Marsham, George, of Marsham, husbandman 2
4193053 2093137 2093137 defendant Marsham Edward husbandman 586516 586516 Marsham, Edward, of Marsham, husbandman 3
4207134 2098039 2098039 defendant Halle Richard yeoman 586516 586516 Halle, Richard, of Marsham, yeoman 0
4207135 2098039 2098039 defendant Gedney William yeoman 586516 586516 Gedney, William, of Marsham, yeoman 1
4223895 2103843 2103843 defendant Conebye alias Coningham John husbandman 586516 586516 Conebye alias Coningham, John, of Marsham, husbandman 3
4250499 2113155 2113155 defendant Bustyng John husbandman 586516 586516 Bustyng, John, of Marsham, 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);