names

444 rows where place_id = 586834

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589764 1864438 1864438 defendant Underhay William joiner 586834 586834 Underhay, William, of Plymmouth, joiner 0
3593016 1865443 1865443 plaintiff Hamelyn Stephen   586834 586834 Hamelyn, Stephen, of Plymmouth 0
3602043 1868299 1868299 defendant Kerswyll Anastacia widow 586834 586834 Kerswyll, Anastacia, of Plymmouth, widow 0
3608452 1870305 1870305 plaintiff Thikpeny William gent 586834 586834 Thikpeny, William, of Plymmouth, gent 0
3609564 1870657 1870657 defendant Salerman Edward yeoman 586834 586834 Salerman, Edward, of Plymmouth, yeoman 1
3615892 1872609 1872609 defendant Grysby John husbandman 586834 586834 Grysby, John, of Plymmouth, husbandman 0
3627341 1903402 1903402 defendant Carre Thomas merchant 586834 586834 Carre, Thomas, of Plymmouth, merchant 0
3628929 1903925 1903925 defendant Greyslyng Peter merchant 586834 586834 Greyslyng, Peter, of Plymmouth, merchant 0
3630779 1904450 1904450 defendant Gyll John yeoman 586834 586834 Gyll, John, of Plymmouth, yeoman 4
3636116 1906089 1906089 defendant Thomas Richard merchant 586834 586834 Thomas, Richard, of Plymmouth, merchant 0
3639551 1907179 1907179 plaintiff White Henry merchant 586834 586834 White, Henry, of Plymmouth, merchant 0
3639960 1907311 1907311 defendant Annys William merchant 586834 586834 Annys, William, of Plymmouth, merchant 1
3641974 1907938 1907938 plaintiff Brune John merchant 586834 586834 Brune, John, of Plymmouth, merchant 0
3643420 1908368 1908368 plaintiff Croppe Thomas merchant 586834 586834 Croppe, Thomas, of Plymmouth, merchant 0
3647783 1909699 1909699 defendant Gyll John merchant 586834 586834 Gyll, John, of Plymmouth, merchant 0
3647804 1909707 1909707 defendant Creswell Edward yeoman of the crown 586834 586834 Creswell, Edward, of Plymmouth, yeoman of the crown 1
3649017 1910081 1910081 plaintiff Paynton John merchant 586834 586834 Paynton, John, of Plymmouth, merchant 0
3649019 1910082 1910082 plaintiff Payntour John merchant 586834 586834 Payntour, John, of Plymmouth, merchant 0
3649022 1910083 1910083 plaintiff Payntour John merchant 586834 586834 Payntour, John, of Plymmouth, merchant 0
3652395 1911084 1911084 defendant Anys of Avys William merchant 586834 586834 Anys of Avys, William, of Plymmouth, merchant 0
3652396 1911084 1911084 defendant Cowstoke Richard merchant 586834 586834 Cowstoke, Richard, of Plymmouth, merchant 1
3653011 1911272 1911272 plaintiff White Henry   586834 586834 White, Henry, of Plymmouth, merchant, eadministrators of 0
3660019 1913397 1913397 defendant Clowter Thomas husbandman 586834 586834 Clowter, Thomas, of Plymmouth, husbandman 0
3671953 1917228 1917228 defendant Norton John carpenter 586834 586834 Norton, John, of Plymmouth, carpenter 3
3671958 1917229 1917229 defendant Norton John carpenter 586834 586834 Norton, John, of Plymmouth, carpenter 2
3672581 1917423 1917423 defendant Croppe Thomas (legal representative) 586834 586834 Croppe, Thomas, of Plymmouth, merchant, executors of 0
3672582 1917423 1917423 defendant Huntyngdon Richard clerk 586834 586834 (Huntyngdon, Richard, of Plymmouth, clerk 1
3672583 1917423 1917423 defendant Bykport John gent 586834 586834 Bykport, John, of Plymmouth, gent 2
3672584 1917423 1917423 defendant Ley Henry gent 586834 586834 Ley, Henry, of Plymmouth, gent 3
3674132 1917948 1917948 defendant Bulwycke John goldsmith 586834 586834 Bulwycke, John, of Plymmouth, goldsmith 0
3675308 1918319 1918319 defendant Thomas Richard merchant 586834 586834 Thomas, Richard, of Plymmouth, merchant 1
3675991 1918527 1918527 defendant Bull William gent 586834 586834 Bull, William, of Plymmouth, gent 0
3677665 1919059 1919059 defendant Gyll John cordwainer 586834 586834 Gyll, John, of Plymmouth, cordwainer 0
3677666 1919059 1919059 defendant Mores John cordwainer 586834 586834 Mores, John, of Plymmouth, cordwainer 1
3679329 1919596 1919596 plaintiff Paynter John, senior   586834 586834 Paynter, John, senior, of Plymmouth 0
3688009 1922410 1922410 defendant Dyver or Dyner alias Radysshe John   586834 586834 Dyver or Dyner alias Radysshe, John, of Plymmouth, "bryggynmaker" 0
3688010 1922410 1922410 defendant Dyver or Dyner alias Radysshe Richard husbandman 586834 586834 Dyver or Dyner alias Radysshe, Richard, of Plymmouth, husbandman 1
3693265 1924103 1924103 defendant Thomas John merchant 586834 586834 Thomas, John, of Plymmouth, merchant 2
3702410 1927012 1927012 defendant Hampton Robert brewer 586834 586834 Hampton, Robert, of Plymmouth, brewer 0
3702944 1927190 1927190 defendant Sowte John fisher 586834 586834 Sowte, John, of Plymmouth, fisher 0
3705823 1928101 1928101 defendant Horswell James gent 586834 586834 Horswell, James, of Plymmouth, gent 0
3706200 1928226 1928226 defendant Paynter John, junior merchant 586834 586834 Paynter, John, junior, of Plymmouth, merchant 0
3707490 1928634 1928634 defendant Thomas Richard merchant 586834 586834 Thomas, Richard, of Plymmouth, merchant 0
3712256 1930147 1930147 defendant Radysshe alias Dyner or Dyver John husbandman 586834 586834 Radysshe alias Dyner or Dyver, John, of Plymmouth, husbandman 2
3712258 1930147 1930147 defendant Bykham Henry husbandman 586834 586834 Bykham, Henry, of Plymmouth, husbandman 4
3715880 1931252 1931252 defendant Bykeport John gent 586834 586834 Bykeport, John, of Plymmouth, gent 0
3723528 1933630 1933630 plaintiff Paynter John   586834 586834 Paynter, John, of Plymmouth, senior 0
3730780 1935854 1935854 defendant Paynter John, junior merchant 586834 586834 Paynter, John, junior, of Plymmouth, merchant 0
3734113 1936917 1936917 defendant Wyght Thomas laborer 586834 586834 Wyght, Thomas, of Plymmouth, laborer 15
3739382 1938525 1938525 plaintiff Paynter John merchant 586834 586834 Paynter, John, of Plymmouth, merchant 0
3739385 1938526 1938526 plaintiff Paynter John, senior   586834 586834 Paynter, John, senior, of Plymmouth 0
3739387 1938527 1938527 plaintiff Paynter John, senior   586834 586834 Paynter, John, senior, of Plymmouth 0
3757189 1944230 1944230 defendant Frynk Richard husbandman 586834 586834 Frynk, Richard, of Plymmouth, husbandman 0
3765390 1946836 1946836 defendant Borne John   586834 586834 Borne, John, of Plymmouth, franklin 0
3770219 1948353 1948353 plaintiff Seyer Thomas   586834 586834 Seyer, Thomas, of Plymmouth 0
3771472 1948769 1948769 defendant Bovy John gent 586834 586834 Bovy, John, of Plymmouth, gent 0
3788014 1954043 1954043 plaintiff Seyer Thomas   586834 586834 Seyer, Thomas, of Plymmouth 0
3796929 1956918 1956918 defendant Pyers Stephen merchant 586834 586834 Pyers, Stephen, of Plymmouth, merchant 0
3797425 1957082 1957082 defendant Clowe John merchant 586834 586834 Clowe, John, of Plymmouth, merchant 1
3811909 1961629 1961629 defendant Bull Thomas merchant 586834 586834 Bull, Thomas, of Plymmouth, merchant 0
3815193 1962668 1962668 defendant Herford Henry gent 586834 586834 Herford, Henry, of Plymmouth, gent 1
3827226 1966381 1966381 defendant Cokys Edward merchant 586834 586834 Cokys, Edward, of Plymmouth, merchant 1
3837874 1969759 1969759 defendant Dwayne John husbandman 586834 586834 Dwayne, John, of Plymmouth, husbandman 5
3844141 1971715 1971715 defendant Holmes William smith 586834 586834 Holmes, William, of Plymmouth, smith 0
3849140 1973328 1973328 defendant Gebbyns William merchant 586834 586834 Gebbyns, William, of Plymmouth, merchant 1
3851976 1974208 1974208 defendant Pounde John tanner 586834 586834 Pounde, John, of Plymmouth, tanner 0
3851981 1974208 1974208 defendant Mill John carpenter 586834 586834 Mill, John, of Plymmouth, carpenter 5
3858892 1976462 1976462 defendant Charleton John (legal representative) 586834 586834 Charleton, John, of Plymmouth, mercer, executors of 0
3858893 1976462 1976462 defendant Gybbons William yeoman 586834 586834 (Gybbons, William, of Plymmouth, yeoman 1
3858902 1976466 1976466 defendant Horsewell James alias John gent 586834 586834 Horsewell, James alias John, of Plymmouth, gent 0
3859431 1976644 1976644 defendant Tanner Robert (legal representative) 586834 586834 Tanner, Robert, of Plymmouth, executors of 0
3859432 1976644 1976644 defendant Elyott John gent 586834 586834 (Elyott, John, of Plymmouth, gent 1
3863494 1977987 1977987 defendant Tasse John merchant 586834 586834 Tasse, John, of Plymmouth, merchant 0
3863495 1977987 1977987 defendant Dunkyn John merchant 586834 586834 Dunkyn, John, of Plymmouth, merchant 1
3867072 1979224 1979224 defendant Sachefyld William, junior gent 586834 586834 Sachefyld, William, junior, of Plymmouth, gent 3
3867110 1979239 1979239 defendant Buller William merchant 586834 586834 Buller, William, of Plymmouth, merchant 0
3876600 1982420 1982420 defendant Hamlyn Thomas husbandman 586834 586834 Hamlyn, Thomas, of Plymmouth, husbandman 0
3920289 1997123 1997123 defendant Collyn John husbandman 586834 586834 Collyn, John, of Plymmouth, husbandman 0
3920322 1997137 1997137 defendant Ayshelegh William merchant 586834 586834 Ayshelegh, William, of Plymmouth, merchant 0
4030078 2035405 2035405 defendant Horswyll John husbandman 586834 586834 Horswyll, John, of Plymmouth, husbandman 0
4486549 2196505 2196505 plaintiff Sampson John   586834 586834 Sampson, John, of Plymmouth 0
4547496 2215147 2215147 defendant Judde Robert   586834 586834 Judde, Robert, of Plymmouth 1
4778387 2289220 2289220 plaintiff Benalva Thomas   586834 586834 Benalva, Thomas, of Plymmouth 0
4778388 2289220 2289220 defendant Pyke Walter merchant 586834 586834 Pyke, Walter, of Plymmouth, merchant 0
4782018 2290378 2290378 defendant Judde Thomas gent 586834 586834 Judde, Thomas, of Plymmouth, gent 0
4782114 2290405 2290405 defendant Bonde John merchant 586834 586834 Bonde, John, of Plymmouth, merchant 0
4785176 2291379 2291379 defendant Monthecombe John gent 586834 586834 Monthecombe, John, of Plymmouth, gent 0
4787430 2292139 2292139 defendant Gordyn William shoemaker 586834 586834 Gordyn, William, of Plymmouth, shoemaker 1
4788624 2292499 2292499 plaintiff Herward John   586834 586834 Herward, John, of Plymmouth 0
4794372 2294385 2294385 plaintiff Pollard William merchant 586834 586834 Pollard, William, of Plymmouth, merchant 0
4796672 2295111 2295111 defendant Bentle William merchant 586834 586834 Bentle, William, of Plymmouth, merchant 1
4796674 2295111 2295111 defendant Whitle John husbandman 586834 586834 Whitle, John, of Plymmouth, husbandman 3
4798951 2295843 2295843 defendant Cok John saddler 586834 586834 Cok, John, of Plymmouth, saddler 0
4858347 2313982 2313982 defendant Smyth Ralph yeoman 586834 586834 Smyth, Ralph, of Plymmouth, yeoman 0
4861682 2315029 2315029 defendant Rocheford Walter merchant 586834 586834 Rocheford, Walter, of Plymmouth, merchant 2
4864899 2315996 2315996 defendant Bovele or Bonele Thomas yeoman 586834 586834 Bovele or Bonele, Thomas, of Plymmouth, yeoman 2
4867436 2316783 2316783 plaintiff Hille John   586834 586834 Hille, John, of Plymmouth 0
4868496 2317120 2317120 defendant Racheford Walter merchant 586834 586834 Racheford, Walter, of Plymmouth, merchant 0
4872307 2318299 2318299 defendant Yonge Richard skinner 586834 586834 Yonge, Richard, of Plymmouth, skinner 0
4872309 2318300 2318300 defendant Yonge Richard skinner 586834 586834 Yonge, Richard, of Plymmouth, skinner 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);