names

539 rows where place_id = 594621

✎ 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
3616869 1872908 1872908 plaintiff Ernesetill John merchant 594621 594621 Ernesetill, John, of Plymouth, merchant 0
3629436 1904064 1904064 plaintiff Croppe John merchant 594621 594621 Croppe, John, of Plymouth, merchant 0
3629474 1904072 1904072 defendant Curham John yeoman 594621 594621 Curham, John, of Plymouth, yeoman 0
3643422 1908369 1908369 plaintiff Croppe Thomas merchant 594621 594621 Croppe, Thomas, of Plymouth, merchant 0
3657409 1912576 1912576 plaintiff Croppe Thomas merchant 594621 594621 Croppe, Thomas, of Plymouth, merchant 0
3663141 1914387 1914387 defendant Gyll John merchant 594621 594621 Gyll, John, of Plymouth, merchant 0
3663470 1914501 1914501 plaintiff Paynter John, senior   594621 594621 Paynter, John, senior, of Plymouth, 0
3663836 1914625 1914625 plaintiff Pounde John merchant 594621 594621 Pounde, John, of Plymouth, merchant 0
3680065 1919828 1919828 defendant Ley Henry gent 594621 594621 (Ley, Henry, of Plymouth, gent 2
3687454 1922254 1922254 defendant Paynter John, junior merchant 594621 594621 Paynter, John, junior, of Plymouth, merchant 4
3702209 1926947 1926947 defendant Dikeporte John gent 594621 594621 Dikeporte, John, of Plymouth, gent 0
3705777 1928088 1928088 defendant Paynter John, junior gent 594621 594621 Paynter, John, junior, of Plymouth, gent 1
3719912 1932498 1932498 defendant Bovy John, junior weaver 594621 594621 Bovy, John, junior, of Plymouth, weaver 0
3719913 1932498 1932498 defendant Saunder Nicholas miller 594621 594621 Saunder, Nicholas, of Plymouth, miller 1
3732590 1936423 1936423 defendant Howell John merchant 594621 594621 Howell, John, of Plymouth, merchant 1
3744779 1940267 1940267 defendant Paynter John merchant 594621 594621 Paynter, John, of Plymouth, merchant 0
3751963 1942531 1942531 defendant Tasse John merchant 594621 594621 Tasse, John, of Plymouth, merchant 0
3752378 1942667 1942667 defendant Carewe John yeoman 594621 594621 Carewe, John, of Plymouth, yeoman 0
3753212 1942947 1942947 plaintiff Seyer Thomas   594621 594621 Seyer, Thomas, of Plymouth 0
3754051 1943213 1943213 defendant Ley Henry gent 594621 594621 Ley, Henry, of Plymouth, gent 0
3801232 1958309 1958309 defendant Coram John yeoman 594621 594621 Coram, John, of Plymouth, yeoman 0
3814180 1962339 1962339 defendant Pyers Stephen merchant 594621 594621 Pyers, Stephen, of Plymouth, merchant 0
3815828 1962857 1962857 defendant Aysteley John merchant 594621 594621 Aysteley, John, of Plymouth, merchant 0
3820615 1964333 1964333 defendant Carewe John yeoman 594621 594621 Carewe, John, of Plymouth, yeoman 0
3823197 1965168 1965168 defendant Bulwyke John merchant 594621 594621 Bulwyke, John, of Plymouth, merchant 0
3823199 1965168 1965168 defendant Cokkys Edward merchant 594621 594621 Cokkys, Edward, of Plymouth, merchant 2
3873461 1981340 1981340 defendant Aysshlegh William merchant 594621 594621 Aysshlegh, William, of Plymouth, merchant 1
3873464 1981341 1981341 defendant Horswell James merchant 594621 594621 Horswell, James, of Plymouth, merchant 0
3873465 1981341 1981341 defendant Asshelegh William merchant 594621 594621 Asshelegh, William, of Plymouth, merchant 1
3876763 1982470 1982470 plaintiff Hampton Robert   594621 594621 Hampton, Robert, of Plymouth 0
3900435 1990376 1990376 defendant Hawkyns William merchant 594621 594621 Hawkyns, William, of Plymouth, merchant 7
3901519 1990732 1990732 defendant Peryng John clerk 594621 594621 Peryng, John, of Plymouth, clerk 0
3901526 1990735 1990735 defendant Holmys William bellfounder 594621 594621 Holmys, William, of Plymouth, bellfounder 1
3910058 1993668 1993668 defendant Roger Thomas dyer 594621 594621 Roger, Thomas, of Plymouth, dyer 0
3910059 1993668 1993668 defendant Waldon William barber 594621 594621 Waldon, William, of Plymouth, barber 1
3931835 2000946 2000946 defendant Hamlyn Thomas husbandman 594621 594621 Hamlyn, Thomas, of Plymouth, husbandman 0
3931837 2000946 2000946 defendant Hamlyn Hugh husbandman 594621 594621 Hamlyn, Hugh, of Plymouth, husbandman 2
3931838 2000946 2000946 defendant Dystayne John husbandman 594621 594621 Dystayne, John, of Plymouth, husbandman 3
3931839 2000946 2000946 defendant Welsheman David husbandman 594621 594621 Welsheman, David, of Plymouth, husbandman 4
3933779 2001592 2001592 defendant Byckeford Nicholas merchant 594621 594621 Byckeford, Nicholas, of Plymouth, merchant 0
3933824 2001608 2001608 defendant Rawe William   594621 594621 Rawe, William, of Plymouth 0
3964417 2012159 2012159 plaintiff Arscott John (legal representative) 594621 594621 Arscott, John, of Plymouth, executors of 0
3964421 2012160 2012160 plaintiff Arscott John (legal representative) 594621 594621 Arscott, John, of Plymouth, executors of 0
3964425 2012160 2012160 defendant Lange Richard mariner 594621 594621 Lange, Richard, of Plymouth, mariner 1
3966031 2012741 2012741 defendant Hampton Thomas merchant 594621 594621 Hampton, Thomas, of Plymouth, merchant 1
3967171 2013143 2013143 defendant Brytnall Henry merchant 594621 594621 Brytnall, Henry, of Plymouth, merchant 0
3967546 2013281 2013281 plaintiff Byckford Nicholas merchant 594621 594621 Byckford, Nicholas, of Plymouth, merchant 0
3967548 2013282 2013282 plaintiff Byckforde Nicholas merchant 594621 594621 Byckforde, Nicholas, of Plymouth, merchant 0
3968868 2013739 2013739 plaintiff Coke Gregory merchant 594621 594621 Coke, Gregory, of Plymouth, merchant 0
3974987 2015813 2015813 plaintiff Hollewaye William gent 594621 594621 Hollewaye, William, of Plymouth, gent 0
3977749 2016788 2016788 defendant Dovell John yeoman 594621 594621 Dovell, John, of Plymouth, yeoman 0
3977750 2016788 2016788 defendant Dovell Joan   594621 594621 Joan his wife, alias Joan Andrewes, of Plymouth 1
3980400 2017761 2017761 plaintiff Peperell Walter merchant 594621 594621 Peperell, Walter, of Plymouth, merchant 0
3980686 2017854 2017854 defendant Hooper John gent 594621 594621 Hooper, John, of Plymouth, gent 0
3989954 2021163 2021163 defendant Ackworth George merchant 594621 594621 Ackworth, George, of Plymouth, gent, or of Barnystable, merchant 0
3993006 2022245 2022245 defendant Parkins Thomas yeoman 594621 594621 Parkins, Thomas, of Plymouth, yeoman 0
3993105 2022282 2022282 defendant Wyll William yeoman 594621 594621 Wyll, William, of Plymouth, yeoman 4
3995205 2023028 2023028 plaintiff Cottell Robert (legal representative) 594621 594621 Cottell, Robert, of Plymouth, administratrix of 0
3995211 2023029 2023029 plaintiff Cottell Robert (legal representative) 594621 594621 Cottell, Robert, of Plymouth, merchant, administratrix of 0
4002083 2025527 2025527 plaintiff Hawkins William gent 594621 594621 Hawkins, William, of Plymouth, gent 0
4002323 2025609 2025609 defendant Bondefeld Richard   594621 594621 Bondefeld, Richard, of Plymouth, gent, his son 1
4011578 2028894 2028894 defendant Derry John merchant 594621 594621 Derry, John, of Plymouth, merchant 7
4011611 2028898 2028898 defendant Harry John husbandman 594621 594621 Harry, John, of Plymouth, husbandman 9
4011642 2028904 2028904 defendant Holbeame Richard gent 594621 594621 Holbeame, Richard, of Plymouth, gent 4
4012320 2029127 2029127 defendant Beney Elizabeth widow 594621 594621 Beney, Elizabeth, of Plymouth, widow 2
4014138 2029786 2029786 defendant Cocke Luke merchant 594621 594621 Cocke, Luke, of Plymouth, merchant 0
4014140 2029786 2029786 defendant Tratt Alexander yeoman 594621 594621 Tratt, Alexander, of Plymouth, yeoman 2
4014142 2029787 2029787 defendant Cocke Luke merchant 594621 594621 Cocke, Luke, of Plymouth, yeoman, merchant 0
4014144 2029787 2029787 defendant Tratt Alexander yeoman 594621 594621 Tratt, Alexander, of Plymouth, yeoman 2
4031598 2035964 2035964 plaintiff Forde John merchant 594621 594621 Forde, John, of Plymouth, merchant 0
4031600 2035965 2035965 plaintiff Forde John merchant 594621 594621 Forde, John, of Plymouth, merchant 0
4034094 2036855 2036855 defendant Horswyll John husbandman 594621 594621 Horswyll, John, of Plymouth, husbandman 0
4036104 2037593 2037593 defendant Cole Thomas husbandman 594621 594621 Cole, Thomas, of Plymouth, husbandman 0
4044075 2040333 2040333 defendant Cottell Robert   594621 594621 Cottell, Robert, of Plymouth, Merchant, administrators of 0
4047412 2041530 2041530 defendant Battishill Walter merchant 594621 594621 Battishill, Walter, of Plymouth, merchant 0
4047422 2041532 2041532 defendant Rowe William blacksmith 594621 594621 Rowe, William, of Plymouth, blacksmith 0
4047432 2041534 2041534 defendant Battishill Walter merchant 594621 594621 Battishill, Walter, of Plymouth, merchant 0
4047442 2041536 2041536 defendant Rowe William blacksmith 594621 594621 Rowe, William, of Plymouth, blacksmith 0
4061188 2046409 2046409 defendant Cowsen John helyer or roofer 594621 594621 Cowsen, John, of Plymouth, helyer or roofer 0
4067223 2048575 2048575 defendant Bonevyll Richard gent 594621 594621 Bonevyll, Richard, of Plymouth, gent 1
4067224 2048576 2048576 plaintiff Hyll Leonard   594621 594621 Hyll, Leonard, of Plymouth, merchant, administrators of 0
4076577 2051921 2051921 plaintiff Skobble Vincent joiner 594621 594621 Skobble, Vincent, of Plymouth, joiner 0
4094613 2058410 2058410 defendant Baron George yeoman 594621 594621 Baron, George, of Plymouth, yeoman 1
4125834 2069524 2069524 defendant Will alias Ferneworthie William, senior yeoman 594621 594621 Will alias Ferneworthie, William, senior, of Plymouth, yeoman 0
4126395 2069730 2069730 defendant Ilcombe John Devon, gent 594621 594621 Ilcombe John, of Plymouth, Devon, gent, executor of 0
4130723 2071299 2071299 defendant White Martin yeoman 594621 594621 White, Martin, of Plymouth, yeoman 0
4138509 2074139 2074139 defendant Willes alas Farnored William gent 594621 594621 Willes alas Farnored, William, of Plymouth, gent 1
4154507 2079668 2079668 defendant Pepperell Walter merchant 594621 594621 Pepperell, Walter, of Plymouth, merchant 1
4184449 2090068 2090068 defendant Bickeford Nicholas merchant 594621 594621 Bickeford, Nicholas, of Plymouth, merchant 0
4184455 2090070 2090070 defendant Bickeford Nicholas merchant 594621 594621 Bickeford, Nicholas, of Plymouth, merchant 0
4185607 2090472 2090472 defendant Predieaux John merchant 594621 594621 Predieaux, John, of Plymouth, merchant 0
4194557 2093650 2093650 defendant Will alias Ferneworthe William, senior yeoman 594621 594621 Will alias Ferneworthe, William, senior, of Plymouth, yeoman 0
4194978 2093806 2093806 defendant Acworth George Devon, merchant 594621 594621 Acworth George, of Plymouth, Devon, merchant 1
4202000 2096243 2096243 defendant Clerke Richard yeoman 594621 594621 Clerke, Richard, of Plymouth, yeoman 0
4202001 2096243 2096243 defendant Conslen or Couslen Isaac husbandman 594621 594621 Conslen or Couslen, Isaac, of Plymouth, husbandman 1
4209204 2098771 2098771 defendant Harrys Oliver gent 594621 594621 Harrys, Oliver, of Plymouth, gent 0
4209206 2098772 2098772 defendant Harrys Oliver gent 594621 594621 Harrys, Oliver, of Plymouth, gent 0
4215561 2100939 2100939 defendant Plott Anthony gent 594621 594621 Plott, Anthony, of Plymouth, gent 0
4218185 2101861 2101861 defendant Weekes Lawrence husbandman 594621 594621 Weekes, Lawrence, of Plymouth, husbandman 0
4224915 2104183 2104183 defendant Tallant Roger mariner 594621 594621 Tallant, Roger, of Plymouth, mariner 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);