names

133 rows where place_id = 593996

✎ 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
3614108 1872076 1872076 defendant Croke William yeoman 593996 593996 Croke, William, of Credyton, yeoman 0
3632624 1905021 1905021 defendant Gregson Edward clerk 593996 593996 Gregson, Edward, of Credyton, clerk 0
3635263 1905818 1905818 defendant Arture Henry   593996 593996 Arture, Henry, of Credyton 0
3714682 1930890 1930890 plaintiff Bodlegh John, senior   593996 593996 Bodlegh, John, senior, of Credyton 0
3714684 1930890 1930890 defendant Helyer John, junior weaver 593996 593996 Helyer, John, junior, of Credyton, weaver 1
3729116 1935355 1935355 defendant Holcombe William yeoman 593996 593996 Holcombe, William, of Credyton, yeoman 0
3741689 1939267 1939267 defendant Gatour Nicholas husbandman 593996 593996 Gatour, Nicholas, of Credyton, husbandman 2
3741690 1939267 1939267 defendant West William husbandman 593996 593996 West, William, of Credyton, husbandman 3
3741691 1939267 1939267 defendant Mortymer Roger husbandman 593996 593996 Mortymer, Roger, of Credyton, husbandman 4
3741692 1939267 1939267 defendant Pytwode Henry husbandman 593996 593996 Pytwode, Henry, of Credyton,husbandman 5
3741693 1939267 1939267 defendant Hawkyn Thomas laborer 593996 593996 Hawkyn, Thomas, of Credyton, laborer 6
3741694 1939267 1939267 defendant Wrayford Nicholas laborer 593996 593996 Wrayford, Nicholas, of Credyton, laborer 7
3753993 1943200 1943200 defendant Gatour Nicholas husbandman 593996 593996 Gatour, Nicholas, of Credyton, husbandman 2
3753994 1943200 1943200 defendant West William husbandman 593996 593996 West, William, of Credyton, husbandman 3
3753995 1943200 1943200 defendant Mortymer Roger husbandman 593996 593996 Mortymer, Roger, of Credyton, husbandman 4
3753996 1943200 1943200 defendant Pytwode Henry husbandman 593996 593996 Pytwode, Henry, of Credyton, husbandman 5
3753997 1943200 1943200 defendant Hawkyn Thomas laborer 593996 593996 Hawkyn, Thomas, of Credyton, laborer 6
3753998 1943200 1943200 defendant Wrayford Nicholas laborer 593996 593996 Wrayford, Nicholas, of Credyton, laborer 7
3760883 1945408 1945408 defendant Mortymer James husbandman 593996 593996 Mortymer, James, of Credyton, husbandman 0
3764699 1946622 1946622 defendant Budde John yeoman 593996 593996 Budde, John, of Credyton, yeoman 0
3771220 1948688 1948688 defendant Gatour Nicholas husbandman 593996 593996 Gatour, Nicholas, of Credyton, husbandman 2
3771221 1948688 1948688 defendant West William husbandman 593996 593996 West, William, of Credyton, husbandman 3
3771222 1948688 1948688 defendant Morten Roger husbandman 593996 593996 Morten, Roger, of Credyton, husbandman 4
3771223 1948688 1948688 defendant Pytwode Henry husbandman 593996 593996 Pytwode, Henry, of Credyton, husbandman 5
3771224 1948688 1948688 defendant Hawkyn Thomas laborer 593996 593996 Hawkyn, Thomas, of Credyton, laborer 6
3771225 1948688 1948688 defendant Wrayford Nicholas laborer 593996 593996 Wrayford, Nicholas, of Credyton, laborer 7
3798761 1957527 1957527 defendant Hoke Robert weaver 593996 593996 Hoke, Robert, of Credyton, weaver 0
3798763 1957528 1957528 defendant Hoke Robert weaver 593996 593996 Hoke, Robert, of Credyton, weaver 0
3811989 1961657 1961657 defendant Bokenham Thomas weaver 593996 593996 Bokenham, Thomas, of Credyton, weaver 1
3815632 1962806 1962806 defendant Skere John weaver 593996 593996 Skere, John, of Credyton, weaver 0
3819927 1964113 1964113 defendant Tokfelde William butcher 593996 593996 Tokfelde, William, of Credyton, butcher 0
3837892 1969765 1969765 defendant Bodlegh John gent 593996 593996 Bodlegh, John, of Credyton, gent 0
3840676 1970647 1970647 defendant Monke Stephen smith 593996 593996 Monke, Stephen, of Credyton, smith 0
3840677 1970647 1970647 defendant Boyer John laborer 593996 593996 Boyer, John, of Credyton, laborer 1
3844142 1971715 1971715 defendant Roberd John butcher 593996 593996 Roberd, John, of Credyton, butcher 1
3844631 1971862 1971862 plaintiff Davy Robert clothman 593996 593996 Davy, Robert, of Credyton, clothman 0
3844633 1971863 1971863 plaintiff Davy Robert clothman 593996 593996 Davy, Robert, of Credyton, clothman 0
3845088 1972019 1972019 defendant Grauntlond Thomas laborer 593996 593996 Grauntlond, Thomas, of Credyton, laborer 0
3847791 1972884 1972884 defendant Pope John tailor 593996 593996 Pope, John, of Credyton, tailor 0
3849420 1973417 1973417 defendant Frost Robert husbandman 593996 593996 Frost, Robert, of Credyton, husbandman 0
3850474 1973736 1973736 defendant Dert Hugh butcher 593996 593996 Dert, Hugh, of Credyton, butcher 0
3860505 1977007 1977007 plaintiff Davy Robert clothman 593996 593996 Davy, Robert, of Credyton, clothman 0
3862603 1977687 1977687 defendant Busshe John, junior husbandman 593996 593996 Busshe, John, junior, of Credyton, husbandman 0
3866062 1978881 1978881 defendant Crosse John gent 593996 593996 Crosse, John, of Credyton, gent 4
3876847 1982497 1982497 defendant Busshe John, junior husbandman 593996 593996 Busshe, John, junior, of Credyton, husbandman 0
3887269 1986007 1986007 defendant Bodeley at Ridge John husbandman 593996 593996 Bodeley at Ridge, John, of Credyton, husbandman 0
3896444 1989016 1989016 defendant Ryche Robert tailor 593996 593996 Ryche, Robert, of Credyton, tailor 0
3918321 1996464 1996464 defendant Delve John butcher 593996 593996 Delve, John,of Credyton, butcher 0
3918322 1996464 1996464 defendant Roger Nicholas weaver 593996 593996 Roger, Nicholas, of Credyton, weaver 1
3928522 1999878 1999878 defendant Harrys Gilbert yeoman 593996 593996 Harrys, Gilbert, of Credyton, yeoman 1
3930686 2000612 2000612 defendant Bodlegh John gent 593996 593996 Bodlegh, John, of Credyton, gent 0
3931332 2000772 2000772 defendant Brodemeade Simon husbandman 593996 593996 Brodemeade, Simon, of Credyton, husbandman 0
3948895 2006679 2006679 plaintiff Dodlegh John (legal representative) 593996 593996 Dodlegh, John, of Credyton, esq, executors of 0
3957958 2009847 2009847 defendant Ullacott John husbandman 593996 593996 Ullacott, John, of Credyton, husbandman 0
3959013 2010234 2010234 defendant Payne William husbandman 593996 593996 Payne, William, of Credyton, husbandman 0
3959014 2010234 2010234 defendant Nott John husbandman 593996 593996 Nott, John, of Credyton, husbandman 1
3967267 2013181 2013181 defendant Delve Peter husbandman 593996 593996 Delve, Peter, of Credyton, husbandman 0
3969350 2013885 2013885 defendant Lybbett John husbandman 593996 593996 Lybbett, John, of Credyton, husbandman 0
3972328 2014890 2014890 defendant Bodley John gent 593996 593996 Bodley, John, of Credyton, or of Kyrton, gent 0
3972888 2015090 2015090 defendant Dunscombe John gent 593996 593996 Dunscombe, John, of Credyton, gent 0
3975584 2016026 2016026 defendant Halse alias Brock William yeoman 593996 593996 Halse alias Brock, William, of Credyton, yeoman 1
3988962 2020792 2020792 defendant Delve John husbandman 593996 593996 Delve, John, of Credyton, husbandman 1
3988963 2020792 2020792 defendant Delve Walter husbandman 593996 593996 Delve, Walter, of Credyton, husbandman 2
3988968 2020793 2020793 defendant Delve Walter husbandman 593996 593996 Delve, Walter, of Credyton, husbandman 1
4003088 2025866 2025866 defendant Edberie John husbandman 593996 593996 Edberie, John, of Credyton, husbandman 0
4003089 2025866 2025866 defendant Lee Walter husbandman 593996 593996 Lee, Walter, of Credyton, husbandman 1
4003090 2025866 2025866 defendant Gullocke William husbandman 593996 593996 Gullocke, William, of Credyton, husbandman 2
4005348 2026693 2026693 plaintiff Kingewell William gent 593996 593996 Kingewell, William, of Credyton, gent 0
4005350 2026694 2026694 plaintiff Kingwell William gent 593996 593996 Kingwell, William, of Credyton, gent 0
4008817 2027914 2027914 defendant Hempton Hugh weaver 593996 593996 Hempton, Hugh, of Credyton, weaver 1
4025346 2033727 2033727 defendant White Faith widow 593996 593996 White, Faith, of Credyton, widow 0
4025347 2033727 2033727 defendant Ponchard Richard husbandman 593996 593996 Ponchard, Richard, of Credyton, husbandman 1
4025776 2033872 2033872 defendant Kingewell William huasbandman 593996 593996 Kingewell, William, of Credyton, huasbandman 0
4025777 2033872 2033872 defendant Kingewell John   593996 593996 Kingewell, John, of Credyton, husbandman, son of William 1
4027701 2034556 2034556 defendant Lee Walter yeoman 593996 593996 Lee, Walter, of Credyton, yeoman 0
4033721 2036709 2036709 defendant Combe William weaver 593996 593996 Combe, William, of Credyton, or of Gunston, Devon, weaver 0
4035587 2037401 2037401 defendant Venycombe John, junior weaver 593996 593996 Venycombe, John, junior, of Credyton, weaver 0
4071313 2050044 2050044 defendant Delse or Delfe Peter husbandman 593996 593996 Delse or Delfe, Peter, of Credyton, husbandman 2
4170423 2085148 2085148 defendant Heard George husbandman 593996 593996 Heard, George, of Credyton, husbandman 1
4223272 2103631 2103631 defendant Atwill Richard   593996 593996 Atwill, Richard, of Credyton, yeoman, his son 1
4224776 2104134 2104134 defendant Dunscombe Walter husbandman 593996 593996 Dunscombe, Walter, of Credyton, husbandman 0
4224777 2104134 2104134 defendant Cann Elias husbandman 593996 593996 Cann, Elias, of Credyton, husbandman 1
4234664 2107670 2107670 defendant Furse John, junior gent 593996 593996 Furse, John, junior, of Credyton, Devon gent, son of John Furse, of Crediton, gent 0
4256027 2114996 2114996 defendant Payne William yeoman 593996 593996 Payne, William, of Credyton, yeoman 0
4256028 2114996 2114996 defendant Graclyff alias Roger John weaver 593996 593996 Graclyff alias Roger, John, of Credyton, weaver 1
4259803 2116251 2116251 defendant Roger alias Gratley John weaver 593996 593996 Roger alias Gratley, John, of Credyton, weaver 0
4259804 2116251 2116251 defendant Lee John tailor 593996 593996 Lee, John, of Credyton, tailor 1
4259805 2116251 2116251 defendant Hunt John yeoman 593996 593996 Hunt, John, of Credyton, yeoman 2
4318307 2136511 2136511 defendant Sulley Richard husbandman 593996 593996 Sulley, Richard, of Credyton, or of Chipstaple, Soms, husbandman 0
4318308 2136511 2136511 defendant Sulley John husbandman 593996 593996 Sulley, John, of Credyton, or of Chipstable, husbandman 1
4366508 2153067 2153067 defendant Venecomb Giles yeoman 593996 593996 Venecomb, Giles, of Credyton, yeoman 0
4678164 2258779 2258779 defendant Andelmakere John smith 593996 593996 Andelmakere, John, of Credyton, smith 0
5061256 2374948 2374948 defendant Morys John yeoman 593996 593996 Morys, John, of Credyton, yeoman 2
5081997 2381111 2381111 defendant Wynterbourne William husbandman 593996 593996 Wynterbourne, William, of Credyton, husbandman 0
5081998 2381111 2381111 defendant Davy Robert baker 593996 593996 Davy, Robert, of Credyton, baker 1
5081999 2381111 2381111 defendant Stephen John carrier 593996 593996 Stephen, John, of Credyton, carrier 2
5082000 2381111 2381111 defendant Hokker John carrier 593996 593996 Hokker, John, of Credyton, carrier 3
5239948 2427260 2427260 defendant Harepath William weaver 593996 593996 Harepath, William, of Credyton, weaver 0
5239949 2427260 2427260 defendant Davy Robert baker 593996 593996 Davy, Robert, of Credyton, baker 1
5239950 2427260 2427260 defendant Gueme Lawrence brasier 593996 593996 Gueme, Lawrence, of Credyton, brasier 2

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