names

32 rows where place_id = 614300

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3702988 1927208 1927208 defendant Nucombe Alice widow 614300 614300 Nucombe, Alice, of North Tawton, widow 2
3725785 1934352 1934352 defendant Bocher John merchant 614300 614300 Bocher, John, of North Tawton, merchant 0
3732442 1936380 1936380 defendant Newcombe Alice widow 614300 614300 Newcombe, Alice, of North Tawton, widow 0
3827556 1966481 1966481 defendant Wode Alexander esq 614300 614300 Wode, Alexander, of North Tawton, esq 2
3842245 1971119 1971119 defendant Woode Alexander esq 614300 614300 Woode, Alexander, of North Tawton, esq 2
3860852 1977122 1977122 defendant Seyntleger Thomas clerk 614300 614300 Seyntleger, Thomas, of North Tawton, clerk 0
3890683 1987149 1987149 defendant Slader Mark gent 614300 614300 Slader, Mark, of North Tawton, gent 2
3904920 1991906 1991906 defendant Slader Mark gent 614300 614300 Slader, Mark, of North Tawton, gent 1
3923262 1998091 1998091 defendant Heywood Dunstan husbandman 614300 614300 Heywood, Dunstan, of North Tawton, husbandman 0
3927465 1999530 1999530 defendant Slader Mark esq 614300 614300 Slader, Mark, of North Tawton, esq 0
3935364 2002140 2002140 defendant Ludlowe Hugh husbandman 614300 614300 Ludlowe, Hugh, of North Tawton, husbandman 0
3943900 2004976 2004976 defendant Martyn Humphrey husbandman 614300 614300 Martyn, Humphrey, of North Tawton, husbandman 0
3943901 2004976 2004976 defendant Smythe William husbandman 614300 614300 Smythe, William, of North Tawton, husbandman 1
3953232 2008197 2008197 defendant Marten Thomas husbandman 614300 614300 Marten, Thomas, of North Tawton, husbandman 0
3976357 2016304 2016304 defendant Woode Richard esq 614300 614300 Woode, Richard, of North Tawton, esq 0
3978773 2017153 2017153 defendant Estbrucke Marcisus husbandman 614300 614300 Estbrucke, Marcisus, of North Tawton, husbandman 0
3978774 2017153 2017153 defendant Barbabyn William husbandman 614300 614300 Barbabyn, William, of North Tawton, husbandman 1
4021859 2032546 2032546 defendant Haywood Robert husbandman 614300 614300 Haywood, Robert, of North Tawton, husbandman 7
4021868 2032547 2032547 defendant Heywoode Robert husbandman 614300 614300 Heywoode, Robert, of North tawton, husbandman 7
4046390 2041158 2041158 plaintiff Slader Mark esq 614300 614300 Slader, Mark, of North Tawton, esq 0
4103864 2061657 2061657 defendant Slader Hamvale gent 614300 614300 Slader, Hamvale, of North Tawton, gent 2
4140412 2074814 2074814 defendant Shore John husbandman 614300 614300 Shore, John, of North Tawton, husbandman 4
4152161 2078866 2078866 defendant Slader Mark esq 614300 614300 Slader, Mark, of North Tawton, esq 0
4165826 2083545 2083545 defendant Wikes William   614300 614300 Wikes, William, of North Tawton, groom 0
4218606 2102005 2102005 defendant Pasford Edmund husbandman 614300 614300 Pasford, Edmund, of North Tawton, husbandman 0
4218607 2102005 2102005 defendant Wilcockes Roger husbandman 614300 614300 Wilcockes, Roger, of North Tawton, husbandman 1
4284526 2124513 2124513 defendant Heywood John yeoman 614300 614300 Heywood, John, of North Tawton, yeoman 3
5113612 2390372 2390372 defendant Westcote Peter yeoman 614300 614300 Westcote, Peter, of North Tawton, yeoman 1
5507046 2507112 2507112 defendant Nordon John husbandman 614300 614300 Nordon, John, of North Tawton, husbandman 4
5507047 2507112 2507112 defendant Westcote Giles husbandman 614300 614300 Westcote, Giles, of North Tawton, husbandman 5
5507048 2507112 2507112 defendant Wodeman Richard husbandman 614300 614300 Wodeman, Richard, of North Tawton, husbandman 6
5604649 2536317 2536317 defendant Thorne John yeoman 614300 614300 Thorne, John, of North Tawton, yeoman 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);