names

267 rows where place_id = 591749

✎ 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
3605454 1869371 1869371 defendant Barneclyf Robert merchant 591749 591749 Barneclyf, Robert, of South Molton, merchant 0
3605457 1869372 1869372 defendant Barneclyff Robert merchant 591749 591749 Barneclyff, Robert, of South Molton, merchant 0
3630782 1904451 1904451 defendant Thorne Roger yeoman 591749 591749 Thorne, Roger, of South Molton, yeoman 1
3649938 1910347 1910347 defendant Clotworthy Robert tucker 591749 591749 Clotworthy, Robert, of South Molton, tucker 0
3651495 1910828 1910828 defendant Smyth Richard merchant 591749 591749 Smyth, Richard, of South Molton, merchant 0
3661910 1914015 1914015 defendant Legh Thomas fuller of cloth 591749 591749 Legh, Thomas, of South Molton, fuller of cloth 0
3671479 1917062 1917062 defendant Smyth Richard mercer 591749 591749 Smyth, Richard, of South Molton, mercer 0
3674213 1917974 1917974 defendant Byllyng John tucker 591749 591749 Byllyng, John, of South Molton, tucker 0
3676144 1918580 1918580 plaintiff Hunt John tucker 591749 591749 Hunt, John, of South Molton, tucker 0
3676152 1918583 1918583 plaintiff Hunt Robert   591749 591749 Hunt, Robert, of South Molton 0
3694798 1924578 1924578 defendant Burnard John husbandman 591749 591749 Burnard, John, of South Molton, husbandman 8
3696666 1925182 1925182 defendant Comer William dyer 591749 591749 Comer, William, of South Molton, dyer 0
3705279 1927938 1927938 plaintiff Hache Thomas   591749 591749 Hache, Thomas, of South Molton 0
3706037 1928178 1928178 defendant Herneman John husbandman 591749 591749 Herneman, John, of South Molton, husbandman 3
3720144 1932576 1932576 defendant Herneman John husbandman 591749 591749 Herneman, John, of South Molton, husbandman 3
3720266 1932616 1932616 defendant Clotworthe Alice widow 591749 591749 Clotworthe, Alice, of South Molton, widow 0
3733296 1936647 1936647 defendant Grene Robert merchant 591749 591749 Grene, Robert, of South Molton, merchant 0
3733936 1936860 1936860 defendant Grene Robert clothier 591749 591749 Grene, Robert, of South Molton, clothier 0
3735850 1937450 1937450 defendant Herneman John husbandman 591749 591749 Herneman, John, of South Molton, husbandman 3
3748090 1941326 1941326 defendant Smyth Thomas mercer 591749 591749 Smyth, Thomas, of South Molton, mercer 0
3749553 1941773 1941773 defendant Grene Robert tucker 591749 591749 Grene, Robert, of South Molton, tucker 2
3751340 1942340 1942340 defendant Clotworthi Christopher tucker 591749 591749 Clotworthi, Christopher, of South Molton, tucker 3
3751342 1942340 1942340 defendant Rondon William shoemaker 591749 591749 Rondon, William, of South Molton, shoemaker 5
3751457 1942373 1942373 plaintiff Noll Henry   591749 591749 Noll, Henry, of South Molton 0
3753074 1942900 1942900 defendant Bowde William yeoman 591749 591749 Bowde, William, of South Molton, yeoman 0
3772180 1948987 1948987 defendant Hunt Robert yeoman 591749 591749 Hunt, Robert, of South Molton, yeoman 0
3775835 1950192 1950192 defendant Grene Robert tucker 591749 591749 Grene, Robert, of South Molton, tucker 0
3780372 1951594 1951594 defendant Grene Robert merchant 591749 591749 Grene, Robert, of South Molton, merchant 0
3780374 1951595 1951595 defendant Grene Robert merchant 591749 591749 Grene, Robert, of South Molton, merchant 0
3782574 1952292 1952292 defendant Grene Robert tucker 591749 591749 Grene, Robert, of South Molton, tucker 0
3783755 1952684 1952684 plaintiff Legh Thomas (legal representative) 591749 591749 Legh, Thomas, of South Molton, executor of 0
3815335 1962712 1962712 defendant Harwode John yeoman 591749 591749 Harwode, John, of South Molton, yeoman 0
3815337 1962713 1962713 defendant Harwode John yeoman 591749 591749 Harwode, John, of South Molton, yeoman 0
3820298 1964222 1964222 defendant Grene Robert (legal representative) 591749 591749 Grene, Robert, of South Molton, merchant, administratrix of 0
3820299 1964222 1964222 defendant Grene Julia widow 591749 591749 Grene, Julia, of South Molton, widow 1
3822743 1965014 1965014 defendant Smyth Thomas mercer 591749 591749 Smyth, Thomas, of South Molton, mercer 0
3832588 1968114 1968114 plaintiff Hunt Robert merchant 591749 591749 Hunt, Robert, of South Molton, merchant 0
3835959 1969159 1969159 defendant Pytte John husbandman 591749 591749 Pytte, John, of South Molton, husbandman 2
3835960 1969159 1969159 defendant Huysshe Jaketta widow 591749 591749 Huysshe, Jaketta, of South Molton, widow 3
3839838 1970391 1970391 defendant Gunter John dyer 591749 591749 Gunter, John, of South Molton, dyer 0
3848264 1973026 1973026 plaintiff Hunt John   591749 591749 Hunt, John, of South Molton 0
3861403 1977283 1977283 defendant Bolehed Robert chaplain 591749 591749 Bolehed, Robert, of South Molton, chaplain 3
3862275 1977569 1977569 defendant Waterhowse Richard butcher 591749 591749 Waterhowse, Richard, of South Molton, butcher 0
3867942 1979512 1979512 defendant Helyer Robert clothier 591749 591749 Helyer, Robert, of South Molton, clothier 0
3875511 1982051 1982051 defendant Bolehed Robert clerk 591749 591749 Bolehed, Robert, of South Molton, clerk 3
3887157 1985967 1985967 defendant Smyth Thomas chapman 591749 591749 Smyth, Thomas, of South Molton, chapman 4
3890189 1986959 1986959 plaintiff Hayne Henry clothier 591749 591749 Hayne, Henry, of South Molton, clothier 0
3890292 1987001 1987001 plaintiff Heynoll Henry   591749 591749 Heynoll, Henry, of South Molton 0
3890294 1987002 1987002 plaintiff Heynoll Henry   591749 591749 Heynoll, Henry, of South Molton 0
3892229 1987652 1987652 defendant Smyth Thomas merchant 591749 591749 Smyth, Thomas, of South Molton, merchant 1
3892758 1987828 1987828 defendant Bodegood Richard tailor 591749 591749 Bodegood, Richard, of South Molton, tailor 0
3902143 1990950 1990950 defendant Hypper William butcher 591749 591749 Hypper, William, of South Molton, butcher 0
3924886 1998641 1998641 defendant Rugge Robert smith 591749 591749 Rugge, Robert, of South Molton, smith 0
3934892 2001973 2001973 defendant Hayne alias Haynell Henry clothier 591749 591749 Hayne alias Haynell, Henry, of South Molton, clothier 0
3965007 2012366 2012366 defendant Harrys William yeoman 591749 591749 Harrys, William, of South Molton, yeoman 0
3973687 2015370 2015370 defendant Cowle John yeoman 591749 591749 Cowle, John, of South Molton, yeoman 0
3973688 2015370 2015370 defendant Northman or Norman Roger miller 591749 591749 Northman or Norman, Roger, of South Molton, miller 1
3973689 2015370 2015370 defendant Northman or Norman Nicholas husbandman 591749 591749 Northman or Norman, Nicholas, of South Molton, husbandman 2
3973690 2015370 2015370 defendant Coll James laborer 591749 591749 Coll, James, of South Molton, laborer 3
3974062 2015497 2015497 defendant Grene George weaver 591749 591749 Grene, George, of South Molton, weaver 0
3974063 2015497 2015497 defendant Trowte Thomas weaver 591749 591749 Trowte, Thomas, of South Molton, weaver 1
3974064 2015497 2015497 defendant Carder John weaver 591749 591749 Carder, John, of South Molton, weaver 2
3977069 2016548 2016548 defendant Pyncombe John merchant 591749 591749 Pyncombe, John, of South Molton, merchant 0
3978392 2017028 2017028 defendant More Thomas weaver 591749 591749 More, Thomas, of South Molton, weaver 0
3981029 2017976 2017976 defendant Clotworthye Thomas gent 591749 591749 Clotworthye, Thomas, of South Molton, gent 0
3994206 2022683 2022683 plaintiff Clotworthye Anthony gent 591749 591749 Clotworthye, Anthony, of South Molton, gent 0
3994342 2022728 2022728 defendant Dychett John, junior shoemaker 591749 591749 Dychett, John, junior, of South Molton, shoemaker 0
4008426 2027780 2027780 defendant Sprage William tucker 591749 591749 Sprage, William, of South Molton, tucker 0
4010937 2028690 2028690 defendant Badcocke Hugh tailor 591749 591749 Badcocke, Hugh, of South Molton, tailor 0
4010938 2028690 2028690 defendant Sutton Ralph weaver 591749 591749 Sutton, Ralph, of South Molton, weaver 1
4024307 2033387 2033387 defendant Dolbery John vicrualer 591749 591749 Dolbery, John, of South Molton, vicrualer 0
4024313 2033388 2033388 defendant Dolbery John victualer 591749 591749 Dolbery, John, of South Molton, victualer 0
4034874 2037150 2037150 defendant Draper John husbandman 591749 591749 Draper, John, of South Molton, husbandman 0
4034961 2037183 2037183 defendant Chapman Walter weaver 591749 591749 Chapman, Walter, of South Molton, weaver 0
4035005 2037202 2037202 defendant Mowre Thomas yeoman 591749 591749 Mowre, Thomas, of South Molton, yeoman 0
4040092 2038956 2038956 plaintiff Maye Christopher draper 591749 591749 Maye, Christopher, of South Molton, draper 0
4040093 2038956 2038956 defendant Dytchett John husbandman 591749 591749 Dytchett, John, of South Molton, husbandman 0
4040121 2038968 2038968 plaintiff Maye William draper 591749 591749 Maye, William, of South Molton, draper 0
4040123 2038969 2038969 plaintiff Maye William draper 591749 591749 Maye, William, of South Molton, draper 0
4040569 2039122 2039122 defendant Sprage William tucker 591749 591749 Sprage, William, of South Molton, tucker 0
4054398 2043962 2043962 defendant Paule John husbandman or shoemaker 591749 591749 Paule, John, of South Molton, husbandman or shoemaker 2
4054409 2043965 2043965 defendant Sutton Augustine yeoman 591749 591749 Sutton, Augustine, of South Molton, yeoman 1
4059805 2045900 2045900 defendant Clotworthy Robert husbandman 591749 591749 Clotworthy, Robert, of South Molton, husbandman 0
4074610 2051222 2051222 plaintiff Rayssheleigh Thomas clothier 591749 591749 Rayssheleigh, Thomas, of South Molton, clothier 0
4074612 2051223 2051223 plaintiff Rayssheleigh Thomas clothier 591749 591749 Rayssheleigh, Thomas, of South Molton, clothier 0
4074867 2051312 2051312 defendant Peter alias Gryffyn John chapman 591749 591749 Peter alias Gryffyn, John, of South Molton, chapman 0
4078754 2052698 2052698 defendant Hatche Thomas esq 591749 591749 Hatche, Thomas, of South Molton, or of Aller, esq 0
4084476 2054724 2054724 defendant Whytheare William, junior   591749 591749 Whytheare, William, junior, of South Molton, yeoman, his son 1
4119682 2067326 2067326 defendant Hobbes Thomas yeoman 591749 591749 Hobbes, Thomas, of South Molton, yeoman 0
4135904 2073172 2073172 defendant Rausheleighe Peter clothier 591749 591749 Rausheleighe, Peter, of South Molton, clothier 0
4137499 2073761 2073761 defendant Hatche Thomas esq 591749 591749 Hatche, Thomas, of South Molton, or of Aller, esq 0
4142741 2075632 2075632 defendant Hobbes Thomas yeoman 591749 591749 Hobbes, Thomas, of South Molton, yeoman 0
4171321 2085431 2085431 defendant Sutton John weaver 591749 591749 Sutton, John, of South Molton, weaver 2
4185543 2090449 2090449 defendant Jennynges Thomas weaver 591749 591749 Jennynges, Thomas, of South Molton, weaver 1
4187176 2091007 2091007 defendant Webber Richard shoemaker 591749 591749 Webber, Richard, of South Molton, shoemaker 0
4191151 2092467 2092467 defendant Hobbes Thomas yeoman 591749 591749 Hobbes, Thomas, of South Molton, yeoman 0
4203861 2096907 2096907 defendant Gefferye John fuller 591749 591749 Gefferye, John, of South Molton, fuller 0
4210342 2099173 2099173 defendant Woode alias Jule Walter husbandman 591749 591749 Woode alias Jule, Walter, of South Molton, husbandman 0
4216621 2101305 2101305 defendant Clotsworthye Alice widow 591749 591749 Clotsworthye, Alice, of South Molton, widow 0
4216624 2101306 2101306 defendant Clotworthye Alice widow 591749 591749 Clotworthye, Alice, of South Molton, widow 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);