names

385 rows where place_id = 596906

✎ 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
3599292 1867422 1867422 defendant Fursselond William yeoman 596906 596906 Fursselond, William, of Newton Abbot, yeoman 0
3599293 1867422 1867422 defendant Draper William husbandman 596906 596906 Draper, William, of Newton Abbot, husbandman 1
3605460 1869373 1869373 defendant Tapplyn Henry merchant 596906 596906 Tapplyn, Henry, of Newton Abbot, merchant 0
3626600 1903172 1903172 defendant Blomvyle Ralph esq 596906 596906 Blomvyle, Ralph, of Newton, esq 0
3635378 1905860 1905860 defendant Lewryche Thomas husbandman 596906 596906 Lewryche, Thomas, of Newton, husbandman 0
3638306 1906798 1906798 defendant Cayston Michael chaplain 596906 596906 Cayston, Michael, of Newton, chaplain 1
3639724 1907232 1907232 defendant Rawlyn Richard husbandman 596906 596906 Rawlyn, Richard, of Newton, husbandman 1
3644992 1908842 1908842 defendant Mylner Richard chaplain 596906 596906 Mylner, Richard, of Newton, chaplain 1
3646796 1909406 1909406 defendant Wagster William glover 596906 596906 Wagster, William, of Newton Flotman, glover 0
3647343 1909555 1909555 plaintiff Lee William (legal representative) 596906 596906 Lee, William, of Newton Flotman, executors of 0
3649439 1910215 1910215 defendant Thornburgh William clerk 596906 596906 Thornburgh, William,of Newton, clerk 1
3649442 1910216 1910216 defendant Thornburgh William clerk 596906 596906 Thornburgh, William, of Newton, clerk 1
3649445 1910217 1910217 defendant Thornburgh William clerk 596906 596906 Thornburgh, William, of Newton, clerk 1
3650074 1910390 1910390 defendant Stowford Thomas husbandman 596906 596906 Stowford, Thomas, of Newton St Peter, husbandman 2
3652233 1911038 1911038 defendant Wyrthe Robert husbandman 596906 596906 Wyrthe, Robert, of Newton, husbandman 4
3653931 1911494 1911494 defendant Alisaunder Thomas laborer 596906 596906 Alisaunder, Thomas, of Newton Flatman, laborer 1
3661081 1913740 1913740 defendant Wynne Thomas yeoman 596906 596906 Wynne, Thomas, of Newton, yeoman, Lame, John, of Newton, yeoman 0
3661082 1913740 1913740 defendant Liones Christopher yeoman 596906 596906 Liones, Christopher, of Newton, yeoman 1
3661249 1913794 1913794 defendant Polglas Robert yeoman 596906 596906 Polglas, Robert, of Newton, yeoman 4
3662026 1914057 1914057 defendant Babbe William butcher 596906 596906 Babbe, William, of Newton Abbot, butcher 0
3662932 1914319 1914319 defendant Yngley Thomas husbandman 596906 596906 Yngley, Thomas, of Newton, husbandman 1
3663743 1914596 1914596 defendant Scope Henry yeoman 596906 596906 Scope, Henry, of newton, Abbot, yeoman 0
3669251 1916320 1916320 defendant Stawe Christopher yeoman 596906 596906 Stawe, Christopher, of Newton, yeoman 2
3669598 1916429 1916429 defendant Byrde Edmund laborer 596906 596906 Byrde, Edmund, of Newton, laborer 2
3669602 1916430 1916430 defendant Byrde Edmund laborer 596906 596906 Byrde, Edmund, of Newton, laborer 2
3670240 1916638 1916638 defendant Hawke William husbandman 596906 596906 Hawke, William, of Newton, husbandman 0
3673481 1917730 1917730 defendant Hawkyns Henry smith 596906 596906 Hawkyns, Henry, of Newton Abbot, smith 0
3674567 1918097 1918097 defendant Tyler William clerk 596906 596906 Tyler, William, of Newton, clerk 1
3679808 1919750 1919750 defendant Wetherby John husbandman 596906 596906 Wetherby, John, of Newton, husbandman 3
3679813 1919751 1919751 defendant Wetherby John husbandman 596906 596906 Wetherby, John, of Newton, husbandman 3
3680375 1919943 1919943 defendant Hawke John yeoman 596906 596906 Hawke, John, of Newton, yeoman 0
3681616 1920344 1920344 defendant Coote William (legal representative) 596906 596906 Coote, William, of Newton, gent, executors of 0
3681617 1920344 1920344 defendant Deryke Robert gent 596906 596906 (Deryke, Robert, of Newton, gent 1
3685031 1921461 1921461 defendant Moreys Thomas husbandman 596906 596906 Moreys, Thomas, of Newton, husbandman 1
3685058 1921469 1921469 defendant Smyth John husbandman 596906 596906 Smyth, John, of Newton, husbandman 0
3685756 1921701 1921701 defendant Stawe Christopher yeoman 596906 596906 Stawe, Christopher, of Newton, yeoman 2
3685760 1921702 1921702 defendant Stawe Christopher yeoman 596906 596906 Stawe, Christopher, of Newton, yeoman 2
3687744 1922334 1922334 defendant Wryght John   596906 596906 Wryght, John, of Newton, freemason 1
3687745 1922334 1922334 defendant Plafote Ralph husbandman 596906 596906 Plafote, Ralph, of Newton, husbandman 2
3688203 1922459 1922459 defendant Platfott Ralph husbandman 596906 596906 Platfott, Ralph, of Newton, husbandman 2
3699413 1926040 1926040 plaintiff Wryght John   596906 596906 Wryght, John, of Newton, freemason 0
3700090 1926260 1926260 defendant Heynes William yeoman 596906 596906 Heynes, William, of Newton, yeoman 0
3700884 1926522 1926522 defendant Downe John tucker 596906 596906 Downe, John, of Newton Abbot, tucker 2
3701732 1926785 1926785 defendant Hyllay William butcher 596906 596906 Hyllay, William, of Newton Abbot, butcher 0
3702090 1926911 1926911 defendant Hanke or Hauke William yeoman 596906 596906 Hanke or Hauke, William, of Newton, yeoman 0
3702095 1926912 1926912 defendant Hanke or Hauke William yeoman 596906 596906 Hanke or Hauke, William, of Newton, yeoman 0
3702632 1927089 1927089 defendant Mannyng Thomas yeoman 596906 596906 Mannyng, Thomas, of Newton, yeoman 2
3702661 1927101 1927101 defendant Wynyff John husbandman 596906 596906 Wynyff, John, of Newton, husbandman 2
3703181 1927268 1927268 defendant Hawkys William husbandman 596906 596906 Hawkys, William, of Newton, husbandman 0
3703182 1927268 1927268 defendant Reymond John husbandman 596906 596906 Reymond, John, of Newton, husbandman 1
3703185 1927269 1927269 defendant Reymond John husbandman 596906 596906 Reymond, John, of Newton, husbandman 0
3707318 1928578 1928578 defendant Lyncoln Richard husbandman 596906 596906 Lyncoln, Richard, of Newton, husbandman 0
3709561 1929298 1929298 defendant Bee John husbandman 596906 596906 Bee, John, of Newton, husbandman 0
3713004 1930390 1930390 defendant Harvy John yeoman 596906 596906 Harvy, John, of Newton Abbot, yeoman 0
3713005 1930390 1930390 defendant Gele John yeoman 596906 596906 Gele, John, of Newton Abbot, yeoman 1
3717369 1931716 1931716 defendant Cokke John yeoman 596906 596906 Cokke, John, of Newton Abbot, yeoman 0
3717370 1931716 1931716 defendant Herwode Joahn yeoman 596906 596906 Herwode, Joahn, of Newton Abbot, yeoman 1
3719683 1932422 1932422 defendant Hawke William yeoman 596906 596906 Hawke, William, of Newton, yeoman 0
3722993 1933456 1933456 defendant Hawke William yeoman 596906 596906 Hawke, William, of Newton, yeoman 0
3722994 1933456 1933456 defendant Hawke Robert husbandman 596906 596906 Hawke, Robert, of Newton, husbandman 1
3731568 1936100 1936100 defendant Mordyng John yeoman 596906 596906 Mordyng, John, of Newton, Cumber, yeoman 0
3731569 1936100 1936100 defendant Coldale William yeoman 596906 596906 Coldale, William, of Newton, yeoman 1
3731570 1936100 1936100 defendant Elyson Thomas yeoman 596906 596906 Elyson, Thomas, of Newton, yeoman 2
3731612 1936114 1936114 defendant Hawke William husbandman 596906 596906 Hawke, William, of Newton, husbandman 0
3731614 1936115 1936115 defendant Hawke William husbandman 596906 596906 Hawke, William, of Newton, husbandman 0
3734605 1937071 1937071 defendant Cook John husbandman 596906 596906 Cook, John, of Newton, or of Beauchamp Otton, Essex, husbandman 0
3735448 1937324 1937324 defendant Hawke William, senior husbandman 596906 596906 Hawke, William, senior, of Newton, husbandman 0
3744332 1940127 1940127 defendant Basse Richard husbandman 596906 596906 Basse, Richard, of Newton, husbandman 1
3744812 1940277 1940277 defendant Hawke William husbandman 596906 596906 Hawke, William, of Newton, husbandman 0
3744814 1940278 1940278 defendant Hawke William, senior yeoman 596906 596906 Hawke, William, senior, of Newton, yeoman 0
3744815 1940278 1940278 defendant Hawke William, junior yeoman 596906 596906 Hawke, William, junior, of Newton, yeoman 1
3746737 1940895 1940895 defendant Hawkyns John laborer 596906 596906 Hawkyns, John, of Newton, laborer 0
3746738 1940895 1940895 defendant Chestyre Thomas husbandman 596906 596906 Chestyre, Thomas, of Newton, husbandman 1
3746778 1940910 1940910 defendant Hawkys William husbandman 596906 596906 Hawkys, William, of Newton, husbandman 0
3747063 1940996 1940996 defendant Hanke William husbandman 596906 596906 Hanke, William, of Newton, husbandman 0
3748494 1941463 1941463 defendant Hawke William, senior husbandman 596906 596906 Hawke, William, senior, of Newton, husbandman 0
3748495 1941463 1941463 defendant Hawke William, junior husbandman 596906 596906 Hawke, William, junior, of Newton, husbandman 1
3752076 1942572 1942572 defendant More Thomas butcher 596906 596906 More, Thomas, of Newton, butcher 0
3758106 1944521 1944521 plaintiff Hulyns John husbandman 596906 596906 Hulyns, John, of Newton, husbandman 1
3759745 1945040 1945040 defendant Aleyn Roger yeoman 596906 596906 Aleyn, Roger, of Newton, yeoman 1
3760191 1945189 1945189 defendant Hawkys William husbandman 596906 596906 Hawkys, William, of Newton, husbandman 0
3760506 1945291 1945291 defendant Hanke or Hauke William husbandman 596906 596906 Hanke or Hauke, William, of Newton, husbandman 0
3761784 1945697 1945697 defendant Mannyng Richard draper 596906 596906 Mannyng, Richard, of Newton Abbot, draper 1
3765620 1946911 1946911 plaintiff Lawes Thomas   596906 596906 Lawes, Thomas, of Newton 0
3768231 1947703 1947703 defendant Alen Roger yeoman 596906 596906 Alen, Roger, of Newton, yeoman 0
3772570 1949112 1949112 defendant Alisaunder Thomas husbandman 596906 596906 Alisaunder, Thomas, of Newton Flotman, husbandman 1
3773868 1949538 1949538 defendant Alston John husbandman 596906 596906 Alston, John, of Newton, husbandman 3
3773869 1949538 1949538 defendant Aleyn Roger husbandman 596906 596906 Aleyn, Roger, of Newton, husbandman 4
3776268 1950323 1950323 defendant Wright Richard (legal representative) 596906 596906 Wright, Richard, of Newton, glasier, executrix of 3
3778581 1951013 1951013 defendant Hanke or Hauke William husbandman 596906 596906 Hanke or Hauke, William, of Newton, husbandman 0
3780177 1951525 1951525 defendant Barton William husbandman 596906 596906 Barton, William, of Newton, husbandman 0
3780399 1951604 1951604 defendant Seborowe John husbandman 596906 596906 Seborowe, John, of Newton, husbandman 2
3785202 1953159 1953159 defendant David Thomas ap Gwelym yeoman 596906 596906 David, Thomas ap Gwelym, of Newton, yeoman 0
3785367 1953210 1953210 defendant Hawte William, senior husbandman 596906 596906 Hawte, William, senior, of Newton, husbandman 0
3791844 1955295 1955295 plaintiff Alexander Thomas yeoman 596906 596906 Alexander, Thomas, of Newton Flotman, yeoman 0
3792865 1955622 1955622 defendant Hawke William, senior husbandman 596906 596906 Hawke, William, senior, of Newton, husbandman 0
3794241 1956071 1956071 defendant Hawk William yeoman 596906 596906 Hawk, William, of Newton, yeoman 0
3805334 1959615 1959615 defendant Swan John sawyer 596906 596906 Swan, John, of Newton, sawyer 3
3809108 1960731 1960731 defendant Smyth Thomas husbandman 596906 596906 Smyth, Thomas, of Newton, husbandman 3
3812331 1961749 1961749 defendant More Thomas butcher 596906 596906 More, Thomas, of Newton, butcher 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);