names

219 rows where place_id = 607107

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3667651 1915826 1915826 defendant Vowell Thomas gent 607107 607107 Vowell, Thomas, of Plymouth, Devon, gent 0
3667653 1915827 1915827 defendant Carswell Edward   607107 607107 Carswell, Edward, of Plymouth, Devon, King's Crown valet 0
3667657 1915828 1915828 defendant Carswell Edward yeoman of the crown 607107 607107 Carswell, Edward, of Plymouth, Devon, yeoman of the Crown 0
3675084 1918240 1918240 defendant Bull William merchant 607107 607107 Bull, William, of Plymouth, Devon, merchant 0
3680063 1919828 1919828 defendant Fursdon John yeoman 607107 607107 Fursdon, John, of Plymouth, Devon, yeoman 0
3687453 1922254 1922254 defendant Anys William merchant 607107 607107 Anys, William, of Plymouth, Devon, merchant 3
3732589 1936423 1936423 defendant Gill John merchant 607107 607107 Gill, John, of Plymouth, Devon, merchant 0
3803155 1958889 1958889 defendant Horswell James gent 607107 607107 Horswell, James, of Plymouth, Devon, gent 0
3805590 1959690 1959690 defendant Caroo John yeoman 607107 607107 Caroo, John, of Plymouth, Devon, yeoman 1
3806614 1959969 1959969 defendant Dyghton Robert merchant 607107 607107 Dyghton, Robert, of Plymouth, Devon, merchant 0
3810986 1961336 1961336 defendant Fowell Thomas gent 607107 607107 Fowell, Thomas, of Plymouth, Devon, gent 0
3867066 1979223 1979223 defendant Sachefeld William, junior gent 607107 607107 Sachefeld, William, junior, of Plymouth, Devon, gent 2
3873460 1981340 1981340 defendant Horswell James merchant 607107 607107 Horswell, James, of Plymouth, devon, merchant 0
3929496 2000212 2000212 defendant Amadas William gent 607107 607107 Amadas, William, of Plymouth, Devon, gent 0
3934245 2001748 2001748 defendant Hawkyns William, junior merchant 607107 607107 Hawkyns, William, junior, of Plymouth, Devon, merchant 0
3934599 2001865 2001865 defendant Chaney alias Chance William merchant 607107 607107 Chaney alias Chance, William, of Plymouth, Devon, merchant 0
3943092 2004704 2004704 defendant Maynard Joan widow 607107 607107 Maynard, Joan, of Plymouth, Devon, widow 1
3943094 2004705 2004705 defendant Rubye John yeoman 607107 607107 Rubye, John, of Plymouth, Devon, yeoman 0
3945427 2005485 2005485 defendant Cocke John merchant 607107 607107 Cocke, John, of Plymouth, Devon, merchant 0
3966025 2012740 2012740 defendant Halle William chapman 607107 607107 Halle, William, of Plymouth, Devon, chapman 1
3966030 2012741 2012741 defendant Halle William merchant 607107 607107 Halle, William, of Plymouth, Devon, merchant 0
3966371 2012868 2012868 plaintiff Bountyng John (legal representative) 607107 607107 Bountyng, John, of Plymouth, Devon, executors of 0
3967626 2013312 2013312 defendant Bonevyell Edmund gent 607107 607107 Bonevyell, Edmund, of Plymouth, Devon, gent 0
3967628 2013313 2013313 defendant Bonevyell Edmund gent 607107 607107 Bonevyell, Edmund, of Plymouth, Devon, gent 0
3972142 2014817 2014817 defendant Bromhyll John merchant 607107 607107 Bromhyll, John, of Plymouth, Devon, merchant 0
3993104 2022282 2022282 defendant Battyshyll Walter merchant 607107 607107 Battyshyll, Walter, of Plymouth, Devon, merchant 3
4002317 2025608 2025608 defendant Bondefyld Richard   607107 607107 Bondefyld, Richard, of Plymouth, Devon, gent, son of Edmund 1
4007538 2027480 2027480 plaintiff Marten Christopher gent 607107 607107 Marten, Christopher, of Plymouth, Devon, gent 0
4011112 2028747 2028747 defendant Lighe John husbandman 607107 607107 Lighe, John, of Plymouth, Devon, husbandman 0
4011603 2028898 2028898 defendant Battyshill Walter merchant 607107 607107 Battyshill, Walter, of Plymouth, Devon, merchant 1
4011625 2028900 2028900 defendant Venner Thomas yeoman 607107 607107 Venner, Thomas, of Plymouth, Devon, yeoman 6
4012319 2029127 2029127 defendant Beny Oliver (legal representative) 607107 607107 Beny, Oliver, of Plymouth, Devon, merchant, administratrix of 1
4015364 2030188 2030188 defendant Hewett Roger merchant 607107 607107 Hewett, Roger, of Plymouth, Devon, merchant 0
4017898 2031115 2031115 defendant Simons Brendon yeoman 607107 607107 Simons, Brendon, of Plymouth, Devon, yeoman 0
4017900 2031116 2031116 defendant Simons William merchant 607107 607107 Simons, William, of Plymouth, Devon, merchant 0
4022440 2032751 2032751 defendant Banfeild Richard gent 607107 607107 Banfeild, Richard, of Plymouth, Devon, gent 0
4025461 2033767 2033767 defendant Bonevyll Richard   607107 607107 Bonevyll, Richard, of Plymouth, Devon, gent, son of Edmund 0
4025463 2033768 2033768 defendant Bonevylle Edmund gent 607107 607107 Bonevylle, Edmund, of Plymouth, Devon, gent 0
4027723 2034563 2034563 defendant Peperell Robert merchant 607107 607107 Peperell, Robert, of Plymouth, Devon, merchant 0
4029572 2035214 2035214 defendant Parker William merchant 607107 607107 Parker, William, of Plymouth, Devon, merchant 0
4031596 2035963 2035963 plaintiff Forde John merchant 607107 607107 Forde, John, of Plymouth, Devon, merchant 0
4034772 2037117 2037117 plaintiff Hawkins William gent 607107 607107 Hawkins, William, of Plymouth, Devon, gent 0
4051588 2042986 2042986 defendant Bonevylle Edmund gent 607107 607107 Bonevylle, Edmund, of Plymouth, Devon, gent 0
4051593 2042988 2042988 defendant Bonevylle Edmund gent 607107 607107 Bonevylle, Edmund, of Plymouth, Devon, gent 0
4054541 2044012 2044012 defendant Lymberye Thomas merchant 607107 607107 Lymberye, Thomas, of Plymouth, Devon, merchant 1
4061676 2046576 2046576 plaintiff Edmondes Thomas gent 607107 607107 Edmondes, Thomas, of Plymouth, Devon, gent 0
4061678 2046577 2046577 plaintiff Edmondes Thomas gent 607107 607107 Edmondes, Thomas, of Plymouth, Devon, gent 0
4067222 2048575 2048575 defendant Bonevyle Edmund gent 607107 607107 Bonevyle, Edmund, of Plymouth, Devon, gent 0
4092657 2057684 2057684 defendant Horswell John yeoman 607107 607107 Horswell, John, of Plymouth, Devon, yeoman 1
4094612 2058410 2058410 defendant Mayowe or Mayehowe Jerome esq 607107 607107 Mayowe or Mayehowe, Jerome, of Plymouth, Devon, esq 0
4095214 2058610 2058610 defendant Bodnam John chapman 607107 607107 Bodnam, John, of Plymouth, Devon, chapman 0
4099087 2060000 2060000 defendant Edmond Thomas gent 607107 607107 Edmond, Thomas, of Plymouth, Devon, gent 0
4099090 2060000 2060000 defendant Sylvester Peter merchant 607107 607107 Sylvester, Peter, of Plymouth, Devon, merchant 3
4111724 2064441 2064441 defendant Edmond Thomas gent 607107 607107 Edmond, Thomas, of Plymouth, Devon, gent 3
4111736 2064445 2064445 defendant Corbyn Robert merchant 607107 607107 Corbyn, Robert, of Plymouth, Devon, merchant 0
4112012 2064547 2064547 defendant Corbyn Robert merchant 607107 607107 Corbyn, Robert, of Plymouth, Devon, merchant 0
4112602 2064764 2064764 defendant Edmond Thomas gent 607107 607107 Edmond, Thomas, of Plymouth, Devon, gent 0
4113122 2064962 2064962 defendant Barford William merchant 607107 607107 Barford, William, of Plymouth, Devon, merchant 1
4113245 2065003 2065003 defendant Mayowe Jerome esq 607107 607107 Mayowe, Jerome, of Plymouth, Devon, esq 0
4115704 2065899 2065899 defendant Rycksforde James yeoman 607107 607107 Rycksforde, James, of Plymouth, Devon, yeoman 3
4123479 2068701 2068701 defendant Webber Nicholas merchant 607107 607107 Webber, Nicholas, of Plymouth, Devon, merchant 0
4124081 2068911 2068911 defendant Edmond Thomas merchant 607107 607107 Edmond, Thomas, of Plymouth, Devon, merchant 2
4134486 2072665 2072665 defendant Corbin Robert merchant 607107 607107 Corbin, Robert, of Plymouth, Devon, merchant 2
4138689 2074205 2074205 defendant Rogett William merchant 607107 607107 Rogett, William, of Plymouth, Devon, merchant 0
4141129 2075058 2075058 defendant Drake John gent 607107 607107 Drake, John, of Plymouth, Devon, gent 0
4151222 2078549 2078549 defendant Rotch or Roche Walter clerk 607107 607107 Rotch or Roche, Walter, of Plymouth, Devon, clerk 2
4153251 2079234 2079234 defendant Symons Brandon yeoman 607107 607107 Symons, Brandon, of Plymouth, Devon, yeoman 0
4155246 2079928 2079928 defendant Reason Robert fletcher 607107 607107 Reason, Robert, of Plymouth, Devon, fletcher 0
4167049 2083979 2083979 defendant Saunders John clerk 607107 607107 Saunders, John, of Plymouth, Devon, clerk 0
4182591 2089387 2089387 defendant Edmondes Thomas gent 607107 607107 Edmondes, Thomas, of Plymouth, Devon, gent 0
4187006 2090949 2090949 defendant Mayhoo Jerome esq 607107 607107 Mayhoo, Jerome, of Plymouth, Devon, esq 0
4191356 2092542 2092542 defendant Saunders John clerk 607107 607107 Saunders, John, of Plymouth, Devon, clerk 0
4200979 2095901 2095901 defendant Parke John chapman 607107 607107 Parke, John, of Plymouth, Devon, chapman 0
4206331 2097760 2097760 defendant Hoyle Zachary merchant 607107 607107 Hoyle, Zachary, of Plymouth, Devon, merchant 1
4208645 2098574 2098574 defendant Mayowe Jerome esq 607107 607107 Mayowe, Jerome, of Plymouth, Devon, esq 0
4220902 2102805 2102805 defendant Thake John shoemaker 607107 607107 (Thake, John, of Plymouth, Devon, shoemaker 1
4221810 2103124 2103124 defendant Bagg James merchant 607107 607107 Bagg, James, of Plymouth, Devon, merchant 0
4229662 2105857 2105857 defendant Thake John shoemaker 607107 607107 (Thake, John, of Plymouth, Devon, shoemaker 1
4231999 2106691 2106691 defendant Sparke William gent 607107 607107 Sparke, William, of Plymouth, Devon, gent 0
4232923 2107023 2107023 defendant Rogers William beer brewer 607107 607107 Rogers, William, of Plymouth, Devon, beer brewer 0
4234762 2107707 2107707 defendant Sperke William merchant 607107 607107 Sperke, William, of Plymouth, Devon, merchant 0
4235653 2108039 2108039 defendant Kyddy Charles joiner 607107 607107 Kyddy, Charles, of Plymouth, Devon, joiner 0
4235773 2108083 2108083 defendant Rogett William merchant 607107 607107 Rogett, William, of Plymouth, Devon, merchant 0
4244426 2111113 2111113 defendant Halffeacre Edward gent 607107 607107 Halffeacre, Edward, of Plymouth, Devon, gent 0
4245419 2111443 2111443 defendant Week John merchant 607107 607107 Week, John, of Plymouth, Devon, merchant 0
4247486 2112144 2112144 defendant Bagg John merchant 607107 607107 Bagg, John, of Plymouth, Devon, merchant 0
4249180 2112711 2112711 defendant Dabell William merchant 607107 607107 Dabell, William, of Plymouth, Devon, merchant 0
4250948 2113298 2113298 defendant Rogers William beer brewer 607107 607107 Rogers, William, of Plymouth, Devon, beer brewer 0
4252603 2113863 2113863 defendant Whyte Martin vintner 607107 607107 Whyte, Martin, of Plymouth, Devon, vintner 0
4252865 2113949 2113949 defendant Stutworthie Joan widow 607107 607107 Stutworthie, Joan, of Plymouth, Devon, widow 1
4253811 2114269 2114269 defendant Hawkyns Mary widow 607107 607107 Hawkyns, Mary, of Plymouth, Devon, widow 1
4255743 2114895 2114895 defendant Kyddy Charles joiner 607107 607107 Kyddy, Charles, of Plymouth, Devon, joiner 0
4257357 2115435 2115435 defendant Furbisher Groseus gent 607107 607107 Furbisher, Groseus, of Plymouth, Devon, gent 0
4257770 2115571 2115571 defendant Mayowe Katherine (legal representative) 607107 607107 Mayowe, Katherine, of Plymouth, Devon, widow, executor of 0
4260184 2116370 2116370 defendant Sperke William merchant 607107 607107 Sperke, William, of Plymouth, Devon, merchant 0
4265391 2118065 2118065 defendant Sparke William merchant 607107 607107 Sparke, William, of Plymouth, Devon, merchant 0
4265395 2118066 2118066 defendant Sparke William merchant 607107 607107 Sparke, William, of Plymouth, Devon, merchant 0
4269542 2119401 2119401 defendant Furbisher Eriseus gent 607107 607107 Furbisher, Eriseus, of Plymouth, Devon, gent 0
4269583 2119416 2119416 defendant Week John merchant 607107 607107 Week, John, of Plymouth, Devon, merchant 0
4270369 2119671 2119671 defendant Sparke William merchant 607107 607107 Sparke, William, of Plymouth, Devon, merchant 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);