names

4,202 rows where place_id = 586036

✎ 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
3587748 1863813 1863813 defendant Wagot Richard gent 586036 586036 Wagot, Richard, of Exeter, gent 4
3588727 1864117 1864117 defendant Cowele Thomas fisher 586036 586036 Cowele, Thomas, of Exeter, fisher 0
3590510 1864676 1864676 defendant Walsheman John dyer 586036 586036 Walsheman, John, of Exeter, dyer 0
3590550 1864684 1864684 defendant Hervy Richard carpenter 586036 586036 Hervy, Richard, of Exeter, carpenter 2
3590690 1864730 1864730 defendant Calwodelegh Thomas esq 586036 586036 Calwodelegh, Thomas, of Exeter, esq 0
3590704 1864735 1864735 defendant Hamelyn John fisher 586036 586036 Hamelyn, John, of Exeter, fisher 1
3591382 1864929 1864929 defendant Lowe Richard schoolmaster 586036 586036 Lowe, Richard, of Exeter, schoolmaster 0
3592649 1865314 1865314 defendant Fitz Walter gent 586036 586036 Fitz, Walter, of Exeter, gent 0
3592866 1865385 1865385 defendant Cosyn John merchant 586036 586036 Cosyn, John, of Exeter, merchant 0
3593437 1865581 1865581 defendant Sayer John gent 586036 586036 Sayer, John, of Exeter, gent 0
3593993 1865760 1865760 defendant Wylle John plumber 586036 586036 Wylle, John, of Exeter, plumber 0
3594589 1865940 1865940 defendant Calwodley John gent 586036 586036 Calwodley, John, of Exeter, gent 0
3594601 1865941 1865941 defendant Calwodley John gent 586036 586036 Calwodley, John, of Exeter, gent 9
3594734 1865978 1865978 defendant Combes John clerk 586036 586036 Combes, John, of Exeter, clerk 0
3596279 1866466 1866466 plaintiff Parker John baker 586036 586036 Parker, John, of Exeter, baker 0
3596280 1866466 1866466 defendant Bonefaunt Robert merchant 586036 586036 Bonefaunt, Robert, of Exeter, merchant 0
3596471 1866525 1866525 defendant Raynyff Anthony barber 586036 586036 Raynyff, Anthony, of Exeter, barber 0
3596797 1866633 1866633 defendant Ralegh Elizabeth widow 586036 586036 Ralegh, Elizabeth, of Exeter, widow 1
3597509 1866843 1866843 defendant Netherton Henry yeoman 586036 586036 Netherton, Henry, of Exeter, yeoman 0
3597511 1866844 1866844 defendant Netherton Henry yeoman 586036 586036 Netherton, Henry, of Exeter, yeoman 0
3597726 1866909 1866909 defendant Harwode Peter chapman 586036 586036 Harwode, Peter, of Exeter, chapman 0
3597897 1866963 1866963 defendant Senclere Henry gent 586036 586036 Senclere, Henry, of Exeter, gent 0
3600104 1867684 1867684 defendant Longe William butcher 586036 586036 Longe, William, of Exeter, butcher 0
3600105 1867684 1867684 defendant Pany or Pavy Richard vintner 586036 586036 Pany or Pavy, Richard, of Exeter, vintner 1
3601198 1868038 1868038 defendant Harewode alias Faynt Peter merchant 586036 586036 Harewode alias Faynt, Peter, of Exeter, merchant 0
3601199 1868038 1868038 defendant Hewys Thomas merchant 586036 586036 Hewys, Thomas, of Exeter, merchant 1
3601200 1868038 1868038 defendant Hoker Robert merchant 586036 586036 Hoker, Robert, of Exeter, merchant 2
3601201 1868038 1868038 defendant Tanner John merchant 586036 586036 Tanner, John, of Exeter, merchant 3
3601303 1868073 1868073 defendant Brempton Thomas plumber 586036 586036 Brempton, Thomas, of Exeter, plumber 0
3601798 1868220 1868220 defendant Owen John yeoman 586036 586036 Owen, John, of Exeter, yeoman 0
3602101 1868321 1868321 defendant Quynterell John smith 586036 586036 Quynterell, John, of Exeter, smith 0
3602227 1868361 1868361 defendant Gernys or Gervys John tailor 586036 586036 Gernys or Gervys, John, of Exeter, tailor 0
3602539 1868455 1868455 defendant Scrope John   586036 586036 Scrope, John, of Exeter, knight 0
3602603 1868474 1868474 defendant Pudsey Ralph merchant 586036 586036 Pudsey, Ralph, of Exeter, merchant 0
3602605 1868475 1868475 defendant Ector John merchant 586036 586036 Ector, John, of Exeter, merchant 0
3603367 1868725 1868725 defendant Harwod alias Fant Peter merchant 586036 586036 Harwod alias Fant, Peter, of Exeter, merchant 0
3603709 1868831 1868831 defendant Bray Walter chaplain 586036 586036 Bray, Walter, of Exeter, chaplain 0
3604049 1868935 1868935 defendant Leboys Henry   586036 586036 Leboys, Henry, of Exeter, of yeoman 0
3604050 1868935 1868935 defendant Rychardysson Thomas chaplain 586036 586036 Rychardysson, Thomas, of Exeter, chaplain 1
3604052 1868935 1868935 defendant Lurdrake William chaplain 586036 586036 Lurdrake, William, of Exeter, chaplain 3
3605301 1869322 1869322 defendant Roland Henry goldsmith 586036 586036 Roland, Henry, of Exeter, goldsmith 1
3605316 1869328 1869328 defendant Bonefaunt John merchant 586036 586036 Bonefaunt, John, of Exeter, merchant 0
3605359 1869344 1869344 defendant Hewse Thomas merchant 586036 586036 Hewse, Thomas, of Exeter, merchant 0
3605448 1869369 1869369 defendant Bonyfaunt Robert merchant 586036 586036 Bonyfaunt, Robert, of Exeter, merchant 0
3605451 1869370 1869370 defendant Bonyfaunt Robert merchant 586036 586036 Bonyfaunt, Robert, of Exeter, merchant 0
3606438 1869681 1869681 defendant Luddre William   586036 586036 Luddre, William, of Exeter, franklin 0
3607000 1869854 1869854 plaintiff Predeaux John tailor 586036 586036 Predeaux, John, of Exeter, tailor 0
3607164 1869905 1869905 defendant Bray Walter chaplain 586036 586036 Bray, Walter, of Exeter, chaplain 0
3607537 1870015 1870015 defendant Sangewyn Richard baker 586036 586036 Sangewyn, Richard, of Exeter, baker 1
3608325 1870262 1870262 plaintiff Symon John merchant 586036 586036 Symon, John, of Exeter, merchant 0
3608745 1870398 1870398 defendant Nordon Richard merchant 586036 586036 Nordon, Richard, of Exeter, merchant 0
3609328 1870576 1870576 defendant Wilkyn Walter tailor 586036 586036 Wilkyn, Walter, of Exeter, tailor 0
3610067 1870816 1870816 defendant Faux Richard yeoman 586036 586036 Faux, Richard, of Exeter, yeoman 0
3610220 1870862 1870862 defendant Slugge John merchant 586036 586036 Slugge, John, of Exeter, merchant 0
3610221 1870862 1870862 defendant Godagge William laborer 586036 586036 Godagge, William, of Exeter, laborer 1
3611756 1871341 1871341 defendant Hacche Edmund yeoman 586036 586036 Hacche, Edmund, of Exeter, yeoman 0
3611757 1871341 1871341 defendant Carter Richard yeoman 586036 586036 Carter, Richard, of Exeter, yeoman 1
3612446 1871523 1871523 defendant Hulle John merchant 586036 586036 Hulle, John, of Exeter, merchant 0
3612466 1871530 1871530 defendant Burgh John clerk 586036 586036 Burgh, John, of Exeter, clerk 1
3612984 1871709 1871709 defendant Harewode alias Fayne Peter merchant 586036 586036 Harewode alias Fayne, Peter, of Exeter, merchant 0
3612985 1871709 1871709 defendant Hewys Thomas merchant 586036 586036 Hewys, Thomas, of Exeter, merchant 1
3612986 1871709 1871709 defendant Hoker Robert merchant 586036 586036 Hoker, Robert, of Exeter, merchant 2
3614138 1872087 1872087 defendant Wagot Richard merchant 586036 586036 Wagot, Richard, of Exeter, merchant 0
3614498 1872182 1872182 defendant Johnson John yeoman 586036 586036 Johnson, John, of Exeter, yeoman 1
3614504 1872184 1872184 defendant Johnson John yeoman 586036 586036 Johnson, John, of Exeter, yeoman 2
3615077 1872361 1872361 defendant Long William butcher 586036 586036 Long, William, of Exeter, butcher 0
3615078 1872361 1872361 defendant Downe John yeoman 586036 586036 Downe, John, of Exeter, yeoman 1
3615944 1872625 1872625 defendant Hoge John plumber 586036 586036 Hoge, John, of Exeter, plumber 0
3617024 1872946 1872946 defendant Waget Richard yeoman 586036 586036 Waget, Richard, of Exeter, yeoman 0
3617847 1873206 1873206 defendant Waget Richard merchant 586036 586036 Waget, Richard, of Exeter, merchant 1
3619521 1873672 1873672 defendant Bonyfaunt John merchant 586036 586036 Bonyfaunt, John, of Exeter, merchant 0
3620112 1873865 1873865 defendant Huysshe Thomas merchant 586036 586036 Huysshe, Thomas, of Exeter, merchant 0
3621443 1874244 1874244 defendant Danester or Davester John merchant 586036 586036 Danester or Davester, John, of Exeter, merchant 2
3621588 1874292 1874292 defendant Waget Richard merchant 586036 586036 Waget, Richard, of Exeter, merchant 0
3623112 1874750 1874750 defendant Damsell Thomas butcher 586036 586036 Damsell, Thomas, of Exeter, butcher 2
3625095 1875383 1875383 defendant Hayne William merchant 586036 586036 Hayne, William, of Exeter, merchant 1
3625833 1875614 1875614 plaintiff Yorke Walter mercer 586036 586036 Yorke, Walter, of Exeter, mercer 0
3625834 1875614 1875614 defendant Yeswen Anthony goldsmith 586036 586036 Yeswen, Anthony, of Exeter, goldsmith 0
3626406 1903116 1903116 defendant Lake John husbandman 586036 586036 Lake, John, of Exeter, husbandman 0
3628862 1903902 1903902 defendant Dolle John butcher 586036 586036 Dolle, John, of Exeter, butcher 0
3629247 1904016 1904016 defendant Calwodley John, senior gent 586036 586036 Calwodley, John, senior, of Exeter, gent 0
3629248 1904016 1904016 defendant Jane John miller 586036 586036 Jane, John, of Exeter, miller 1
3630453 1904359 1904359 defendant Calwodelegh John gent 586036 586036 Calwodelegh, John, of Exeter, gent 0
3630454 1904359 1904359 defendant Bulbroke John yeoman 586036 586036 Bulbroke, John, of Exeter, yeoman 1
3630460 1904360 1904360 defendant Dowell Richard bellfounder 586036 586036 Dowell, Richard, of Exeter, bellfounder 4
3630466 1904361 1904361 defendant Calwodelegh John, junior gent 586036 586036 Calwodelegh, John, junior, of Exeter, gent 4
3630468 1904362 1904362 defendant Dyxston Richard tucker 586036 586036 Dyxston, Richard, of Exeter, tucker 0
3630469 1904362 1904362 defendant Harryes Elias tailor 586036 586036 Harryes, Elias, of Exeter, tailor 1
3630835 1904464 1904464 defendant Stubbes Richard yeoman 586036 586036 Stubbes, Richard, of Exeter, yeoman 0
3631357 1904618 1904618 defendant Vetery John merchant 586036 586036 Vetery, John, of Exeter, merchant 0
3631484 1904661 1904661 defendant Calwodelegh John gent 586036 586036 Calwodelegh, John, of Exeter, gent 0
3631485 1904661 1904661 defendant Bulbroke John yeoman 586036 586036 Bulbroke, John, of Exeter, yeoman 1
3631825 1904760 1904760 defendant Bonefaunt John gent 586036 586036 Bonefaunt, John, of Exeter, or of Magna Totton, gent 0
3632386 1904949 1904949 defendant Currant Richard merchant 586036 586036 Currant, Richard, of Exeter, merchant 0
3632689 1905041 1905041 defendant Mefyll or Mesyll John yeoman 586036 586036 Mefyll or Mesyll, John, of Exeter, yeoman 0
3635005 1905747 1905747 defendant More John mercer 586036 586036 More, John, of Exeter, mercer 0
3635062 1905764 1905764 defendant Fychet John clerk 586036 586036 Fychet, John, of Exeter, clerk 1
3635079 1905769 1905769 defendant Polyng Richard carpenter 586036 586036 Polyng, Richard, of Exeter, carpenter 0
3635082 1905770 1905770 defendant Polyng Richard carpenter 586036 586036 Polyng, Richard, of Exeter, carpenter 0
3635265 1905819 1905819 defendant Courteys Thomas barker 586036 586036 Courteys, Thomas, of Exeter, barker 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);