names

385 rows where place_id = 586422

✎ 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
3588685 1864105 1864105 defendant Gwynne William husbandman 586422 586422 Gwynne, William, of Lynton, husbandman 1
3588686 1864105 1864105 defendant Serche Richard husbandman 586422 586422 Serche, Richard, of Lynton, husbandman 2
3590561 1864688 1864688 defendant Roger Thomas husbandman 586422 586422 Roger, Thomas, of Lynton, husbandman 1
3591763 1865043 1865043 defendant Hunte John husbandman 586422 586422 Hunte, John, of Lynton, husbandman 3
3602794 1868542 1868542 defendant Burfourd William husbandman 586422 586422 Burfourd, William, of Lynton, husbandman 0
3608456 1870306 1870306 defendant Burghford Michael yeoman 586422 586422 Burghford, Michael, of Lynton, yeoman 1
3609457 1870623 1870623 defendant Burghford William yeoman 586422 586422 Burghford, William, of Lynton, yeoman 0
3615886 1872607 1872607 defendant Burghford William yeoman 586422 586422 Burghford, William, of Lynton, yeoman 0
3616489 1872794 1872794 defendant Burford William yeoman 586422 586422 Burford, William, of Lynton, yeoman 0
3617928 1873231 1873231 defendant Kellog Thomas, senior husbandman 586422 586422 Kellog, Thomas, senior, of Lynton, husbandman 0
3617929 1873231 1873231 defendant Kellog Thomas, junior husbandman 586422 586422 Kellog, Thomas, junior, of Lynton, husbandman 1
3620813 1874078 1874078 defendant Hunt Thomas yeoman 586422 586422 Hunt, Thomas, of Lynton, yeoman 0
3622827 1874671 1874671 defendant Bacheler Reginald husbandman 586422 586422 Bacheler, Reginald, of Lynton, husbandman 2
3623184 1874775 1874775 defendant Burford William yeoman 586422 586422 Burford, William, of Lynton, yeoman 0
3630403 1904345 1904345 plaintiff Eton Thomas   586422 586422 Eton, Thomas, of Lynton 0
3630406 1904345 1904345 defendant Amy Richard husbandman 586422 586422 Amy, Richard, of Lynton, husbandman 2
3630407 1904345 1904345 defendant Fulwell Stephen husbandman 586422 586422 Fulwell, Stephen, of Lynton, husbandman 3
3630408 1904346 1904346 plaintiff Eton Thomas   586422 586422 Eton, Thomas, of Lynton 0
3630410 1904346 1904346 defendant Pate Nicholas husbandman 586422 586422 Pate, Nicholas, of Lynton, husbandman 1
3630411 1904346 1904346 defendant Amy Richard husbandman 586422 586422 Amy, Richard, of Lynton, husbandman 2
3630412 1904346 1904346 defendant Fulwell Stephen husbandman 586422 586422 Fulwell, Stephen, of Lynton, husbandman 3
3630419 1904348 1904348 defendant Amy Richard husbandman 586422 586422 Amy, Richard, of Lynton, husbandman 3
3630420 1904348 1904348 defendant Fulwell Stephen husbandman 586422 586422 Fulwell, Stephen, of Lynton, husbandman 4
3630421 1904349 1904349 plaintiff Eton Thomas gent 586422 586422 Eton, Thomas, of Lynton, gent 0
3630500 1904372 1904372 plaintiff Eyton Thomas gent 586422 586422 Eyton, Thomas, of Lynton, gent 0
3631794 1904750 1904750 defendant Smyth Robert miller 586422 586422 Smyth, Robert, of Lynton, miller 0
3631795 1904750 1904750 defendant Waltham William yeoman 586422 586422 Waltham, William, of Lynton, yeoman 1
3631796 1904750 1904750 defendant Fulwell Richard husbandman 586422 586422 Fulwell, Richard, of Lynton, husbandman 2
3635873 1906019 1906019 defendant Taylour Thomas husbandman 586422 586422 Taylour, Thomas, of Lynton, husbandman 0
3644440 1908678 1908678 defendant Tayllour Thomas husbandman 586422 586422 Tayllour, Thomas, of Lynton, husbandman 4
3644446 1908679 1908679 defendant Tayllour Thomas husbandman 586422 586422 Tayllour, Thomas, of Lynton, husbandman 4
3647637 1909646 1909646 defendant Dubber William husbandman 586422 586422 Dubber, William, of Lynton, husbandman 2
3667941 1915913 1915913 plaintiff Achebye William   586422 586422 Achebye, William, of Lynton 0
3674326 1918014 1918014 defendant Tayllour Thomas husbandman 586422 586422 Tayllour, Thomas, of Lynton, husbandman 0
3674328 1918014 1918014 defendant Fulwell Richard maltman 586422 586422 Fulwell, Richard, of Lynton, maltman 2
3697644 1925487 1925487 defendant A Barnes Thomas, junior husbandman 586422 586422 A Barnes, Thomas, junior, of Lynton, husbandman 0
3702092 1926911 1926911 defendant Bocher Thomas carpenter 586422 586422 Bocher, Thomas, of Lynton, carpenter 2
3702097 1926912 1926912 defendant Bocher Thomas carpenter 586422 586422 Bocher, Thomas, of Lynton, carpenter 2
3705939 1928143 1928143 defendant Milsent Thomas husbandman 586422 586422 Milsent, Thomas, of Lynton, husbandman 0
3712112 1930105 1930105 defendant Dyer David husbandman 586422 586422 Dyer, David, of Lynton, husbandman 0
3727315 1934818 1934818 defendant Dyer David husbandman 586422 586422 Dyer, David, of Lynton, husbandman 0
3736003 1937500 1937500 defendant Gull John smith 586422 586422 Gull, John, of Lynton, smith 0
3745841 1940603 1940603 defendant Tayler Thomas   586422 586422 Tayler, Thomas, of Lynton, husbandman, administrators of 0
3745843 1940603 1940603 defendant Myllycent Thomas yeoman 586422 586422 Myllycent, Thomas, of Lynton, yeoman 2
3746060 1940672 1940672 defendant Hokley John butcher 586422 586422 Hokley, John, of Lynton, butcher 0
3758813 1944745 1944745 defendant Tayler Thomas (legal representative) 586422 586422 Tayler, Thomas, of Lynton, husbandman, executors of 0
3758815 1944745 1944745 defendant Millecent Thomas husbandman 586422 586422 Millecent, Thomas, of Lynton, husbandman 2
3766989 1947342 1947342 defendant Monkton Richard gent 586422 586422 Monkton, Richard, of Lynton, gent 0
3777940 1950810 1950810 defendant Robynson Richard yeoman 586422 586422 Robynson, Richard, of Lynton, yeoman 0
3806143 1959849 1959849 defendant Gybson William glover 586422 586422 Gybson, William, of Lynton, glover 1
3806153 1959852 1959852 defendant Gybson William glover 586422 586422 Gybson, William, of Lynton, glover 2
3808578 1960560 1960560 defendant Meyryk Thomas husbandman 586422 586422 Meyryk, Thomas, of Lynton, husbandman 0
3808579 1960560 1960560 defendant Abadam Henry husbandman 586422 586422 Abadam, Henry, of Lynton, husbandman 1
3808580 1960560 1960560 defendant Taylour Hugh husbandman 586422 586422 Taylour, Hugh, of Lynton, husbandman 2
3808581 1960560 1960560 defendant Davyes John husbandman 586422 586422 Davyes, John, of Lynton, husbandman 3
3809151 1960745 1960745 defendant Fulwell Stephen yeoman 586422 586422 Fulwell, Stephen, of Lynton, yeoman 0
3809155 1960746 1960746 defendant Fulwell Stephen yeoman 586422 586422 Fulwell, Stephen, of Lynton, yeoman 0
3817204 1963295 1963295 defendant Helyar John butcher 586422 586422 (Helyar, John, of Lynton, butcher 1
3826215 1966046 1966046 defendant Malton John beer brewer 586422 586422 Malton, John, of Lynton, beer brewer 0
3829129 1966992 1966992 defendant Bery John, senior husbandman 586422 586422 Bery, John, senior, of Lynton, husbandman 1
3829130 1966992 1966992 defendant Dyer John husbandman 586422 586422 Dyer, John, of Lynton, husbandman 2
3830074 1967302 1967302 defendant Fulwell Robert maltman 586422 586422 Fulwell, Robert, of Lynton, maltman 0
3844471 1971816 1971816 defendant Fulwell Robert husbandman 586422 586422 Fulwell, Robert, of Lynton, husbandman 4
3882676 1984471 1984471 defendant Fulwell Stephen yeoman 586422 586422 Fulwell, Stephen, of Lynton, yeoman 0
3888111 1986281 1986281 defendant Elsmare Richard husbandman 586422 586422 Elsmare, Richard, of Lynton, husbandman 0
3890247 1986982 1986982 defendant Phelpys Thomas husbandman 586422 586422 Phelpys, Thomas, of Lynton, husbandman 1
3890248 1986982 1986982 defendant Hyll Thomas husbandman 586422 586422 Hyll, Thomas, of Lynton, husbandman 2
3890249 1986982 1986982 defendant Tege Richard husbandman 586422 586422 Tege, Richard, of Lynton, husbandman 3
3904203 1991651 1991651 defendant Phelypps Thomas husbandman 586422 586422 Phelypps, Thomas, of Lynton, husbandman 0
3904204 1991651 1991651 defendant Hill Thomas husbandman 586422 586422 Hill, Thomas, of Lynton, husbandman 1
3904205 1991651 1991651 defendant Tege Richard husbandman 586422 586422 Tege, Richard, of Lynton, husbandman 2
3911430 1994138 1994138 defendant Gurnell William yeoman 586422 586422 Gurnell, William, of Lynton, yeoman 0
3911431 1994138 1994138 defendant Holred Alexander yeoman 586422 586422 Holred, Alexander, of Lynton, yeoman 1
3919686 1996920 1996920 defendant White Robert husbandman 586422 586422 White, Robert, of Lynton, husbandman 0
3923390 1998130 1998130 defendant Stertout Michael yeoman 586422 586422 Stertout, Michael, of Lynton, yeoman 3
3932818 2001276 2001276 defendant Rychardes John husbandman 586422 586422 Rychardes, John, of Lynton, husbandman 12
3932829 2001276 2001276 defendant Jones Nicholas yeoman 586422 586422 Jones, Nicholas, of Lynton, yeoman 23
3933126 2001370 2001370 defendant Fulwell Alice widow 586422 586422 Fulwell, Alice, of Lynton, widow 0
3955479 2008983 2008983 defendant Howford or Howvard John husbandman 586422 586422 Howford or Howvard, John, of Lynton, husbandman 0
3955497 2008991 2008991 defendant Howford or Howvard John husbandman 586422 586422 Howford or Howvard, John, of Lynton, husbandman 0
3956555 2009358 2009358 defendant Ellesworth Christopher yeoman 586422 586422 Ellesworth, Christopher, of Lynton, yeoman 0
3956556 2009358 2009358 defendant Johnson Thomas yeoman 586422 586422 Johnson, Thomas, of Lynton, yeoman 1
3965545 2012561 2012561 plaintiff Beale John yeoman 586422 586422 Beale, John, of Lynton, yeoman 0
3967167 2013141 2013141 defendant Weldysshe Francis gent 586422 586422 Weldysshe, Francis, of Lynton, gent 0
3987730 2020360 2020360 defendant Vavasoure William gent 586422 586422 Vavasoure, William, of Lynton, gent 0
3991908 2021864 2021864 defendant Nethersole George gent 586422 586422 Nethersole, George, of Lynton, gent 0
3996051 2023340 2023340 plaintiff Dakyns Arthur esq 586422 586422 Dakyns, Arthur, of Lynton, esq 0
4005314 2026679 2026679 defendant Felpes Daniel yeoman 586422 586422 Felpes, Daniel, of Lynton, yeoman 1
4018756 2031440 2031440 defendant Kelynge John weaver 586422 586422 Kelynge, John, of Lynton, weaver 0
4018762 2031442 2031442 defendant Kelynge John weaver 586422 586422 Kelynge, John, of Lynton, weaver 0
4020800 2032165 2032165 defendant Kelynge John weaver 586422 586422 Kelynge, John, of Lynton, weaver 0
4045659 2040900 2040900 defendant Nethersole George gent 586422 586422 Nethersole, George, of Lynton, gent 0
4049523 2042273 2042273 defendant Nethersole George gent 586422 586422 Nethersole, George, of Lynton, gent 0
4062899 2047031 2047031 defendant Somer John weaver 586422 586422 Somer, John, of Lynton, weaver 0
4062901 2047031 2047031 defendant Stone alias Swayne Robert butcher 586422 586422 Stone alias Swayne, Robert, of Lynton, butcher 2
4066589 2048346 2048346 plaintiff Horseley Edmund yeoman 586422 586422 Horseley, Edmund, of Lynton, yeoman 0
4079110 2052830 2052830 defendant Cole Walter Herefs, yeoman 586422 586422 Cole. Walter, of Lynton, Herefs, yeoman 1
4112873 2064873 2064873 defendant Baylye John weaver 586422 586422 Baylye, John, of Lynton, weaver 0
4112874 2064873 2064873 defendant Knyght William husbandman 586422 586422 Knyght, William, of Lynton, husbandman 1
4112876 2064874 2064874 defendant Baylye John weaver 586422 586422 Baylye, John, of Lynton, weaver 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);