names

88 rows where place_id = 595677

✎ 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
3621442 1874244 1874244 defendant Androis John merchant 595677 595677 Androis, John, of Totnes, Devon, merchant 1
3666301 1915409 1915409 defendant Garlond Richard gent 595677 595677 Garlond, Richard, of Totnes, Devon, gent 0
3666523 1915469 1915469 defendant Wattes Bernard merchant 595677 595677 Wattes, Bernard, of Totnes, Devon, merchant 0
3678220 1919242 1919242 defendant Paret Gilbert yeoman 595677 595677 Paret, Gilbert, of Totnes, Devon, yeoman 1
3703674 1927429 1927429 defendant Nosworthe William chapman 595677 595677 Nosworthe, William, of Totnes, Devon, chapman 3
3777614 1950749 1950749 defendant Clove John chapman 595677 595677 Clove, John, of Totnes, Devon, chapman 4
3888553 1986430 1986430 defendant Lee Robert chapman 595677 595677 Lee, Robert, of Totnes, Devon, chapman 3
3931868 2000958 2000958 defendant Nosworthy Nicholas chapman & merchant 595677 595677 Nosworthy, Nicholas, of Totnes, Devon, chapman & merchant 0
3961774 2011219 2011219 defendant Mortymer Richard chapman 595677 595677 Mortymer, Richard, of Totnes, Devon, chapman 0
3973626 2015347 2015347 plaintiff Gyles William (legal representative) 595677 595677 Gyles, William, of Totnes, Devon, merchant, executor of 0
3975412 2015965 2015965 defendant Wotton John chapman 595677 595677 Wotton, John, of Totnes, Devon, chapman 1
3975417 2015967 2015967 defendant Wotton Gilbert chapman 595677 595677 Wotton, Gilbert, of Totnes, Devon, chapman 0
3975421 2015968 2015968 defendant Wotton Gilbert chapman 595677 595677 Wotton, Gilbert, of Totnes, Devon, chapman 0
3981189 2018031 2018031 defendant Avery William chapman 595677 595677 Avery, William, of Totnes, Devon, chapman 0
3981191 2018032 2018032 defendant Blackaller Walter chapman 595677 595677 Blackaller, Walter, of Totnes, Devon, chapman 0
4006657 2027159 2027159 defendant Mortymer Richard chapman 595677 595677 Mortymer, Richard, of Totnes, Devon, chapman 0
4011572 2028894 2028894 defendant Savery Nicholas gent 595677 595677 Savery, Nicholas, of Totnes, Devon, gent 1
4027056 2034322 2034322 defendant Clyfford Nicholas chapman 595677 595677 Clyfford, Nicholas, of Totnes, Devon, chapman 0
4036146 2037610 2037610 defendant Smythe Bernard merchant 595677 595677 Smythe, Bernard, of Totnes, Devon, merchant 0
4036148 2037611 2037611 defendant Smythe Bernard merchant 595677 595677 Smythe, Bernard, of Totnes, Devon, merchant 0
4039870 2038880 2038880 plaintiff Martyn Thomas merchant 595677 595677 Martyn, Thomas, of Totnes, Devon, merchant 0
4051934 2043112 2043112 defendant Saverye Stephen merchant 595677 595677 Saverye, Stephen, of Totnes, Devon, merchant 0
4064818 2047702 2047702 defendant Saverye Richard gent 595677 595677 Saverye, Richard, of Totnes, Devon, gent 0
4068959 2049187 2049187 defendant Savery Nicholas   595677 595677 Savery, Nicholas, of Totnes, Devon, gent, son of Richard Savery of Totnes 0
4080043 2053167 2053167 defendant Cosen Thomas glover 595677 595677 Cosen, Thomas, of Totnes, Devon, glover 0
4088045 2056021 2056021 defendant Grenewaye John chapman 595677 595677 Grenewaye, John, of Totnes, Devon, chapman 3
4097885 2059574 2059574 defendant Trevor David yeoman 595677 595677 Trevor, David, of Totnes, Devon, yeoman 0
4110952 2064166 2064166 defendant Trevore David merchant 595677 595677 Trevore, David, of Totnes, Devon, merchant 0
4117569 2066578 2066578 defendant Pottell Thomas yeoman 595677 595677 Pottell, Thomas, of Totnes, Devon, yeoman 2
4126215 2069667 2069667 defendant Style John merchant 595677 595677 Style, John, of Totnes, Devon, merchant 0
4127302 2070059 2070059 defendant Adames William merchant 595677 595677 Adames, William, of Totnes, Devon, merchant 1
4140667 2074902 2074902 defendant Mortymer Richard, junior merchant 595677 595677 Mortymer, Richard, junior, of Totnes, Devon, merchant 0
4144741 2076323 2076323 defendant Sheare Philip merchant 595677 595677 Sheare, Philip, of Totnes, Devon, merchant 0
4162404 2082409 2082409 defendant Grenewaye John chapman 595677 595677 Grenewaye, John, of Totnes, Devon, chapman 1
4167587 2084159 2084159 defendant Hoggard alias Vyvyan William yepman 595677 595677 Hoggard alias Vyvyan, William, of Totnes, Devon, yepman 0
4191124 2092460 2092460 defendant Hoggard alias Vyvyan William yeoman 595677 595677 Hoggard alias Vyvyan, William, of Totnes, Devon, yeoman 0
4191314 2092527 2092527 defendant Shute Stephen haberdasher 595677 595677 Shute, Stephen, of Totnes, Devon, haberdasher 0
4193887 2093424 2093424 defendant Leigh Nicholas chapman 595677 595677 Leigh, Nicholas, of Totnes, Devon, chapman 0
4194783 2093733 2093733 defendant Treavor David gent 595677 595677 Treavor, David, of Totnes, Devon, gent 1
4198532 2095039 2095039 defendant Page Nicholas merchant 595677 595677 Page, Nicholas, of Totnes, Devon, merchant 1
4204428 2097095 2097095 defendant Kettingall John merchant 595677 595677 Kettingall, John, of Totnes, Devon, merchant 1
4204867 2097244 2097244 defendant Mortymer Richard merchant 595677 595677 Mortymer, Richard, of Totnes, Devon, merchant 0
4207780 2098284 2098284 defendant Adams Barnard chapman 595677 595677 Adams, Barnard, of Totnes, Devon, chapman 0
4211628 2099617 2099617 defendant Hackewell Richard merchant 595677 595677 (Hackewell, Richard, of Totnes, Devon, merchant 1
4225667 2104442 2104442 defendant Blackhall or Blackhaller Leonard merchant 595677 595677 Blackhall or Blackhaller, Leonard, of Totnes, Devon, merchant 0
4225669 2104443 2104443 defendant Blackhall or Blackaller Leonard merchant 595677 595677 Blackhall or Blackaller, Leonard, of Totnes, Devon, merchant 0
4240684 2109867 2109867 defendant Knyght John gent 595677 595677 Knyght, John, of Totnes, Devon, gent 1
4256539 2115156 2115156 defendant Englishe Walter merchant 595677 595677 Englishe, Walter, of Totnes, Devon, merchant 0
4278518 2122421 2122421 defendant Everye Henry merchant 595677 595677 Everye, Henry, of Totnes, Devon, merchant 0
4287818 2125690 2125690 defendant Everye Henry merchant 595677 595677 Everye, Henry, of Totnes, Devon, merchant 0
4289922 2126456 2126456 defendant Savery Frideswide widow 595677 595677 Savery, Frideswide, of Totnes, Devon, widow 1
4294367 2128066 2128066 defendant Russell William merchant 595677 595677 Russell, William, of Totnes, Devon, merchant 0
4295840 2128606 2128606 defendant Nyle or Neaylle John mercer 595677 595677 Nyle or Neaylle, John, of Totnes, Devon, draper, mercer 0
4295842 2128607 2128607 defendant Nyle or Nell John draper 595677 595677 Nyle or Nell, John, of Totnes, Devon, draper 0
4308406 2133094 2133094 defendant Knight John gent 595677 595677 Knight, John, of Totnes, Devon, gent 1
4332014 2141004 2141004 defendant Russell William merchant 595677 595677 Russell, William, of Totnes, Devon, merchant 0
4350383 2147397 2147397 defendant Everye Henry merchant 595677 595677 Everye, Henry, of Totnes, Devon, merchant 0
4355500 2149145 2149145 defendant Nyle John draper 595677 595677 Nyle, John, of Totnes, Devon, draper 0
4355958 2149302 2149302 defendant Blackhall Leonard merchant 595677 595677 Blackhall, Leonard, of Totnes, Devon, merchant 0
4355961 2149303 2149303 defendant Blackhall Leonard merchant 595677 595677 Blackhall, Leonard, of Totnes, Devon, merchant 0
4359159 2150436 2150436 defendant Cunnynge Humphrey gent 595677 595677 Cunnynge, Humphrey, of Totnes, Devon, gent 0
4366766 2153162 2153162 defendant Every Henry merchant 595677 595677 Every, Henry, of Totnes, Devon, merchant 0
4368827 2153904 2153904 defendant Lepie Zachary merchant 595677 595677 Lepie, Zachary, of Totnes, Devon, merchant 0
4369742 2154235 2154235 defendant Adams William merchant 595677 595677 Adams, William, of Totnes, Devon, merchant 0
4377285 2156952 2156952 defendant Russell William merchant 595677 595677 Russell, William, of Totnes, Devon, merchant 0
4380084 2157980 2157980 defendant Blackhall Leonard merchant 595677 595677 Blackhall, Leonard, of Totnes, Devon, merchant 0
4408983 2167606 2167606 defendant Crappe Henry merchant 595677 595677 Crappe, Henry, of Totnes, Devon, merchant 0
4411970 2168598 2168598 defendant Saverye Christopher gent 595677 595677 Saverye, Christopher, of Totnes, Devon, gent 1
4700419 2265545 2265545 defendant Serle Walter butcher 595677 595677 Serle, Walter, of Totnes, Devon, butcher 0
4700422 2265546 2265546 defendant Serle Walter butcher 595677 595677 Serle, Walter, of Totnes, Devon, butcher 0
4744559 2278932 2278932 defendant Symondes John   595677 595677 Symondes, John, of Totnes, Devon 0
4763737 2284647 2284647 defendant Dybbe Thomas mercer 595677 595677 Dybbe, Thomas, of Totnes, Devon, mercer 1
4768957 2286270 2286270 defendant Harris Robert   595677 595677 Harris, Robert, of Totnes, Devon, chapman, alias Robert Harris, of Sarre, on the Isle of Thanet, Kent 3
4768966 2286271 2286271 defendant Goloffer_ Richard chapman 595677 595677 Goloffer_, Richard, of Totnes, Devon, chapman 4
4893318 2324616 2324616 defendant Quyk Nicholas draper 595677 595677 Quyk, Nicholas, of Totnes, Devon, draper 1
4983216 2351882 2351882 defendant Lombe Stephen cordwainer 595677 595677 Lombe, Stephen, of Totnes, Devon, cordwainer 2
5006673 2358849 2358849 defendant Bythewater William merchant 595677 595677 Bythewater, William, of Totnes, Devon, merchant 0
5132542 2396012 2396012 defendant Touker Richard merchant 595677 595677 Touker, Richard, of Totnes, Devon, merchant 0
5139449 2398025 2398025 defendant Boughton Robert gent 595677 595677 Boughton, Robert, of Totnes, Devon, gent 0
5151677 2401648 2401648 defendant Touker Richard merchant 595677 595677 Touker, Richard, of Totnes, Devon, merchant 0
5152346 2401818 2401818 defendant Touker Richard merchant 595677 595677 Touker, Richard, of Totnes, Devon, merchant 0
5160433 2404143 2404143 defendant Boughton Robert gent 595677 595677 Boughton, Robert, of Totnes, Devon, gent 0
5214433 2419954 2419954 defendant Cole Roger schoolmaster 595677 595677 Cole, Roger, of Totnes, Devon, schoolmaster 2
5342533 2457865 2457865 defendant Hokemore William merchant 595677 595677 Hokemore, William, of Totnes, Devon, merchant 0
5498437 2504489 2504489 defendant Seret John chapman 595677 595677 Seret, John, of Totnes, Devon, chapman 1
5550095 2520064 2520064 defendant Hyllyer William chapman 595677 595677 Hyllyer, William, of Totnes, Devon, chapman 3
5550115 2520067 2520067 defendant Hyllyer William chapman 595677 595677 Hyllyer, William, of Totnes, Devon, chapman 2
5557024 2522012 2522012 defendant Helyer William chapman 595677 595677 Helyer, William, of Totnes, Devon, chapman 3

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);