names

50 rows where place_id = 597003

✎ 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
3626890 1903262 1903262 defendant Glanfyld Richard   597003 597003 Glanfyld, Richard, of South Tawton, groom 0
3626891 1903262 1903262 defendant Glanfeld John   597003 597003 Glanfeld, John, of South Tawton, groom 1
3626892 1903262 1903262 defendant Hoo Thomas husbandman 597003 597003 Hoo, Thomas, of South Tawton, husbandman 2
3673472 1917726 1917726 defendant Frynde Thomas tanner 597003 597003 Frynde, Thomas, of South Tawton, tanner 0
3674965 1918201 1918201 defendant Batshill John gent 597003 597003 Batshill, John, of South Tawton, gent 0
3705943 1928145 1928145 defendant Bowde William husbandman 597003 597003 Bowde, William, of South Tawton, husbandman 0
3711731 1929983 1929983 defendant Bowde William weaver 597003 597003 Bowde, William, of South Tawton, weaver 0
3711732 1929983 1929983 defendant Gydelegh Henry husbandman 597003 597003 Gydelegh, Henry, of South Tawton, husbandman 1
3711733 1929983 1929983 defendant Moche Thomas laborer 597003 597003 Moche, Thomas, of South Tawton, laborer 2
3712687 1930284 1930284 defendant Boche alias Bowd- William husbandman 597003 597003 Boche alias Bowd-, William, of South Tawton, husbandman 0
3712688 1930284 1930284 defendant Hole Richard husbandman 597003 597003 Hole, Richard, of South Tawton, husbandman 1
3728393 1935125 1935125 defendant Wykes Richard clerk 597003 597003 Wykes, Richard, of South Tawton, clerk 0
3770071 1948302 1948302 defendant Bowde William yeoman 597003 597003 Bowde, William, of South Tawton, yeoman 0
3782684 1952326 1952326 defendant Batyshall John husbandman 597003 597003 Batyshall, John, of South Tawton, husbandman 0
3791369 1955137 1955137 defendant Wolston Robert husbandman 597003 597003 Wolston, Robert, of South Tawton, husbandman 0
3808626 1960578 1960578 defendant Burrowe Thomas husbandman 597003 597003 Burrowe, Thomas, of South Tawton, husbandman 0
3830730 1967495 1967495 defendant Sloman William husbandman 597003 597003 Sloman, William, of South Tawton, husbandman 0
3834231 1968647 1968647 defendant Kellond Thomas husbandman 597003 597003 (Kellond, Thomas, of South Tawton, husbandman 1
3858968 1976492 1976492 defendant Wodeman alias Gydlegh Henry yeoman 597003 597003 Wodeman alias Gydlegh, Henry, of South Tawton, yeoman 0
3889083 1986586 1986586 defendant Gere Oliver painter 597003 597003 Gere, Oliver, of South Tawton, painter 6
3934210 2001735 2001735 defendant Brock Robert husbandman 597003 597003 Brock, Robert, of South Tawton, husbandman 4
3949595 2006934 2006934 defendant Mylford George husbandman 597003 597003 Mylford, George, of South Tawton, husbandman 0
3949596 2006934 2006934 defendant Bocher John laborer 597003 597003 Bocher, John, of South Tawton, laborer 1
3949597 2006934 2006934 defendant Lyveton Walter laborer 597003 597003 Lyveton, Walter, of South Tawton, laborer 2
3956716 2009416 2009416 defendant Verneworthy William yeoman 597003 597003 Verneworthy, William, of South Tawton, yeoman 0
3963790 2011937 2011937 defendant Clarke Henry tanner 597003 597003 Clarke, Henry, of South Tawton, tanner 2
3963794 2011938 2011938 defendant Clarke Henry tanner 597003 597003 Clarke, Henry, of South Tawton, tanner 2
3977167 2016583 2016583 defendant Saunder William dyer 597003 597003 Saunder, William, of South Tawton, dyer 0
3977622 2016743 2016743 plaintiff Loveley Robert   597003 597003 Loveley, Robert, of South Tawton, groom 0
3980693 2017857 2017857 defendant Weck Richard husbandman 597003 597003 Weck, Richard, of South Tawton, husbandman 0
4041669 2039509 2039509 defendant Hole William innholder 597003 597003 Hole, William, of South Tawton, innholder 11
4041689 2039510 2039510 defendant Lebbett Robert yeoman 597003 597003 Lebbett, Robert, of South Tawton, yeoman 13
4043423 2040109 2040109 defendant Baron Richard husbandman 597003 597003 Baron, Richard, of South Tawton, husbandman 0
4054945 2044162 2044162 defendant Veneycombe George husbandman 597003 597003 Veneycombe, George, of South Tawton, husbandman 0
4061064 2046365 2046365 defendant Gerde William husbandman 597003 597003 Gerde, William, of South Tawton, husbandman 0
4061315 2046450 2046450 defendant Wycke John esq 597003 597003 Wycke, John, of South Tawton, esq 0
4072390 2050429 2050429 defendant Gerde William husbandman 597003 597003 Gerde, William, of South Tawton, husbandman 0
4133847 2072442 2072442 defendant Smalridge John husbandman 597003 597003 Smalridge, John, of South Tawton, husbandman 0
4196963 2094489 2094489 defendant Burnell John husbandman 597003 597003 Burnell, John, of South Tawton, husbandman 1
4202091 2096275 2096275 defendant Weakes John yeoman 597003 597003 Weakes, John, of South Tawton, yeoman 2
4244795 2111247 2111247 defendant Weare John husbandman 597003 597003 Weare, John, of South Tawton, husbandman 0
4251660 2113539 2113539 defendant Downe Simon tanner 597003 597003 Downe, Simon, of South Tawton, tanner 1
4268777 2119151 2119151 defendant Ware John husbandman 597003 597003 Ware, John, of South Tawton, husbandman 0
5012331 2360460 2360460 defendant Bateshyll Richard husbandman 597003 597003 Bateshyll, Richard, of South Tawton, husbandman 0
5012332 2360460 2360460 defendant Strange John husbandman 597003 597003 Strange, John, of South Tawton, husbandman 1
5038187 2368055 2368055 defendant Wylman John husbandman 597003 597003 together with Wylman, John, of South Tawton, husbandman 1
5038188 2368055 2368055 defendant Colebere William husbandman 597003 597003 Colebere, William, of South Tawton, husbandman 2
5103078 2387326 2387326 defendant Wyke Richard, senior gent 597003 597003 Wyke, Richard, senior, of South Tawton, gent 0
5597958 2534263 2534263 defendant Taillour Margaret widow 597003 597003 Taillour, Margaret, of South Tawton, widow 1
5598476 2534409 2534409 defendant Battyshyll John gent 597003 597003 Battyshyll, John, of South Tawton, gent 0

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