names

560 rows where place_id = 586005

✎ 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
3587678 1863790 1863790 defendant Wynne William husbandman 586005 586005 Wynne, William, of Upton, husbandman 0
3588819 1864151 1864151 defendant Ewegeley William husbandman 586005 586005 Ewegeley, William, of Upton, husbandman 0
3591011 1864814 1864814 defendant Beamond Robert yeoman 586005 586005 Beamond, Robert, of Upton, yeoman 0
3594102 1865797 1865797 defendant Beamond Robert   586005 586005 Beamond, Robert, of Upton 0
3594104 1865798 1865798 defendant Bemond Robert husbandman 586005 586005 Bemond, Robert, of Upton, husbandman 0
3598359 1867118 1867118 defendant Whyte John husbandman 586005 586005 Whyte, John, of Upton, husbandman 1
3602657 1868496 1868496 defendant Ewegeley William yeoman 586005 586005 Ewegeley, William, of Upton, yeoman 1
3603337 1868718 1868718 defendant Beamond Robert husbandman 586005 586005 Beamond, Robert, of Upton, husbandman 0
3603338 1868718 1868718 defendant Beamond John laborer 586005 586005 Beamond, John, of Upton, laborer 1
3603726 1868836 1868836 defendant Jaye John tailor 586005 586005 Jaye, John, of Upton, tailor 1
3605724 1869452 1869452 defendant Amys William husbandman 586005 586005 Amys, William, of Upton, husbandman 3
3607421 1869980 1869980 defendant Lone or Love John husbandman 586005 586005 Lone or Love, John, of Upton, husbandman 1
3609409 1870605 1870605 plaintiff Wynne William   586005 586005 Wynne, William, of Upton 0
3610905 1871084 1871084 defendant Hyde Robert husbandman 586005 586005 Hyde, Robert, of Upton, husbandman 0
3610907 1871085 1871085 defendant Hyde Robert husbandman 586005 586005 Hyde, Robert, of Upton, husbandman 0
3614206 1872110 1872110 defendant Steyn John cordwainer 586005 586005 Steyn, John, of Upton, cordwainer 4
3616440 1872778 1872778 defendant Wattys Thomas husbandman 586005 586005 Wattys, Thomas, of Upton, husbandman 2
3618926 1873529 1873529 defendant Hendry Thomas husbandman 586005 586005 Hendry, Thomas, of Upton, husbandman 0
3627087 1903332 1903332 defendant Edwardys Thomas husbandman 586005 586005 Edwardys, Thomas, of Upton, husbandman 0
3627507 1903461 1903461 defendant Rychemond Thomas husbandman 586005 586005 Rychemond, Thomas, of Upton, husbandman 0
3631964 1904810 1904810 defendant Fenne John husbandman 586005 586005 Fenne, John, of Upton, husbandman 0
3634742 1905662 1905662 plaintiff Mosse Thomas   586005 586005 Mosse, Thomas, of Upton 0
3637074 1906396 1906396 plaintiff Sclatter Thomas yeoman 586005 586005 Sclatter, Thomas, of Upton, yeoman 0
3641200 1907699 1907699 defendant Upton Edmund yeoman 586005 586005 Upton, Edmund, of Upton, yeoman 0
3641422 1907772 1907772 defendant Richemond John husbandman 586005 586005 Richemond, John, of Upton, husbandman 2
3644164 1908609 1908609 defendant Upton Edmund yeoman 586005 586005 Upton, Edmund, of Upton, yeoman 0
3644522 1908703 1908703 defendant Dorant John husbandman 586005 586005 Dorant, John, of Upton, husbandman 0
3653700 1911420 1911420 defendant Richeman John, senior husbandman 586005 586005 Richeman, John, senior, of Upton, husbandman 0
3659492 1913227 1913227 defendant Norys Edward husbandman 586005 586005 Norys, Edward, of Upton, husbandman 2
3660204 1913453 1913453 defendant Mosse Thomas husbandman 586005 586005 Mosse, Thomas, of Upton, husbandman 0
3660810 1913646 1913646 defendant Horton William yeoman 586005 586005 Horton, William, of Upton, yeoman 0
3668770 1916169 1916169 defendant Wyn Ralph husbandman 586005 586005 Wyn, Ralph, of Upton, husbandman 0
3668946 1916219 1916219 defendant Colyn Thomas husbandman 586005 586005 Colyn, Thomas, of Upton, husbandman 0
3670195 1916625 1916625 defendant Benstelyn Alice widow 586005 586005 Benstelyn, Alice, of Upton, widow 0
3674234 1917981 1917981 defendant Shell John husbandman 586005 586005 Shell, John, of Upton, husbandman 0
3677237 1918926 1918926 defendant Richeman John grasier 586005 586005 Richeman, John, of Upton, grasier 2
3677699 1919072 1919072 defendant Palmer William husbandman 586005 586005 Palmer, William, of Upton, husbandman 2
3678487 1919329 1919329 plaintiff Mosse Thomas   586005 586005 Mosse, Thomas, of Upton 0
3678507 1919336 1919336 defendant Herryson Richard   586005 586005 Herryson, Richard, of Upton, shepherd 0
3680815 1920081 1920081 defendant FitzHerbert Nicholas gent 586005 586005 FitzHerbert, Nicholas, of Upton, gent 0
3693302 1924117 1924117 defendant Mathove Edmund husbandman 586005 586005 Mathove, Edmund, of Upton, husbandman 2
3696414 1925104 1925104 defendant Fytzherbert Nicholas gent 586005 586005 Fytzherbert, Nicholas, of Upton, gent 0
3699561 1926094 1926094 defendant Rycheman John husbandman 586005 586005 Rycheman, John, of Upton, husbandman 0
3700741 1926484 1926484 defendant Wellys Robert yeoman 586005 586005 Wellys, Robert, of Upton, yeoman 1
3706503 1928317 1928317 defendant Cresset Thomas   586005 586005 Cresset, Thomas, of Upton, esq, administrators of 0
3706504 1928317 1928317 defendant Cresset Thomas gent 586005 586005 (Cresset, Thomas, of Upton, gent 1
3706786 1928407 1928407 defendant Canon John husbandman 586005 586005 Canon, John, of Upton, husbandman 0
3706787 1928407 1928407 defendant Canon William, senior husbandman 586005 586005 Canon, William, senior, of Upton, husbandman 1
3710086 1929465 1929465 defendant Cowper John yeoman 586005 586005 Cowper, John, of Upton, yeoman 0
3725487 1934260 1934260 defendant Wellys Robert yeoman 586005 586005 Wellys, Robert, of Upton, yeoman 0
3725489 1934260 1934260 defendant Wyn Richard yeoman 586005 586005 Wyn, Richard, of Upton, yeoman 2
3726197 1934459 1934459 defendant Cressett Thomas gent 586005 586005 Cressett, Thomas, of Upton, gent 0
3726199 1934460 1934460 defendant Cressett Thomas gent 586005 586005 Cressett, Thomas, of Upton, gent 0
3726200 1934460 1934460 defendant Corveser Thomas yeoman 586005 586005 Corveser, Thomas, of Upton, yeoman 1
3730946 1935908 1935908 defendant Corbett William gent 586005 586005 Corbett, William, of Upton, gent 0
3731850 1936191 1936191 plaintiff Clerke William   586005 586005 Clerke, William, of Upton 0
3732219 1936314 1936314 defendant Wyn Ralph husbandman 586005 586005 Wyn, Ralph, of Upton, husbandman 0
3736974 1937811 1937811 defendant Richardson Henry yeoman 586005 586005 Richardson, Henry, of Upton, yeoman 0
3736975 1937811 1937811 defendant Jaye Stephen laborer 586005 586005 Jaye, Stephen, of Upton, laborer 1
3736976 1937811 1937811 defendant Gildon Thomas laborer 586005 586005 Gildon, Thomas, of Upton, laborer 2
3737699 1938014 1938014 defendant Porter William husbandman 586005 586005 Porter, William, of Upton, husbandman 0
3737700 1938014 1938014 defendant Steyn John husbandman 586005 586005 Steyn, John, of Upton, husbandman 1
3737703 1938014 1938014 defendant FitzHerbert Nicholas gent 586005 586005 FitzHerbert, Nicholas, of Upton, gent 4
3740665 1938942 1938942 defendant Marbury George gent 586005 586005 Marbury, George, of Upton, gent 0
3740667 1938943 1938943 defendant Marbury George gent 586005 586005 Marbury, George, of Upton, gent 0
3741961 1939353 1939353 defendant Cresset Thomas gent 586005 586005 Cresset, Thomas, of Upton, gent 0
3741962 1939353 1939353 defendant Corveser Thomas yeoman 586005 586005 Corveser, Thomas, of Upton, yeoman 1
3743799 1939945 1939945 plaintiff Wyn Richard   586005 586005 Wyn, Richard, of Upton 0
3744623 1940213 1940213 defendant Mychell John weaver 586005 586005 Mychell, John, of Upton, weaver 0
3748345 1941413 1941413 defendant Harrold John husbandman 586005 586005 Harrold, John, of Upton, husbandman 1
3755783 1943766 1943766 defendant Harrold John husbandman 586005 586005 Harrold, John, of Upton, husbandman 3
3755784 1943766 1943766 defendant Preston John husbandman 586005 586005 Preston, John, of Upton, husbandman 4
3755785 1943766 1943766 defendant Cowper John husbandman 586005 586005 Cowper, John, of Upton, husbandman 5
3757988 1944481 1944481 defendant Phelyppys John husbandman 586005 586005 Phelyppys, John, of Upton, husbandman 0
3759258 1944886 1944886 defendant Heyne Robert husbandman 586005 586005 Heyne, Robert, of Upton, husbandman 0
3761633 1945651 1945651 defendant Packet Henry husbandman 586005 586005 Packet, Henry, of Upton, husbandman 0
3762641 1945952 1945952 defendant Harrold John husbandman 586005 586005 Harrold, John, of Upton, husbandman 0
3765868 1946992 1946992 defendant Felby Richard husbandman 586005 586005 Felby, Richard, of Upton, husbandman 0
3765869 1946992 1946992 defendant Wodde William husbandman 586005 586005 Wodde, William, of Upton, husbandman 1
3765870 1946992 1946992 defendant Pytte John husbandman 586005 586005 Pytte, John, of Upton, husbandman 2
3765871 1946992 1946992 defendant Thedam Robert husbandman 586005 586005 Thedam, Robert, of Upton, husbandman 3
3765872 1946992 1946992 defendant Pytte Walter husbandman 586005 586005 Pytte, Walter, of Upton, husbandman 4
3765873 1946992 1946992 defendant Bartlott William husbandman 586005 586005 Bartlott, William, of Upton, husbandman 5
3766047 1947046 1947046 defendant Steyn John husbandman 586005 586005 Steyn, John, of Upton, husbandman 3
3770008 1948279 1948279 defendant Marbury George gent 586005 586005 Marbury, George, of Upton, gent 0
3778008 1950833 1950833 plaintiff Corbet William gent 586005 586005 Corbet, William, of Upton, gent 0
3779813 1951418 1951418 defendant Pachet Henry husbandman 586005 586005 Pachet, Henry, of Upton, husbandman 0
3779815 1951419 1951419 defendant Pachet Henry husbandman 586005 586005 Pachet, Henry, of Upton, husbandman 0
3780656 1951677 1951677 defendant Cowper John husbandman 586005 586005 Cowper, John, of Upton, husbandman 0
3792488 1955510 1955510 defendant Collyn John husbandman 586005 586005 Collyn, John, of Upton, husbandman 0
3792489 1955510 1955510 defendant Collyn Thomas husbandman 586005 586005 Collyn, Thomas, of Upton, husbandman 1
3794193 1956056 1956056 defendant Wellys Robert yeoman 586005 586005 Wellys, Robert, of Upton, yeoman 0
3794682 1956213 1956213 defendant Hogekys Thomas husbandman 586005 586005 Hogekys, Thomas, of Upton under Hamon, husbandman 0
3794683 1956213 1956213 defendant Hogekys John husbandman 586005 586005 Hogekys, John, of Upton under Hamon, husbandman 1
3795329 1956407 1956407 defendant Wyatt Richard husbandman 586005 586005 Wyatt, Richard, of Upton, husbandman 0
3795330 1956407 1956407 defendant Danderych Thomas husbandman 586005 586005 Danderych, Thomas, of Upton, husbandman 1
3801709 1958429 1958429 defendant Wyatt Richard husbandman 586005 586005 Wyatt, Richard, of Upton, husbandman 0
3808366 1960490 1960490 defendant Sparke William husbandman 586005 586005 Sparke, William, of Upton, husbandman 1
3809444 1960836 1960836 defendant Wellys Robert yeoman 586005 586005 Wellys, Robert, of Upton, yeoman 0
3810708 1961248 1961248 defendant Danrige Thomas husbandman 586005 586005 Danrige, Thomas, of Upton, 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);