names

38 rows where place_id = 605995

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3663628 1914557 1914557 defendant Toker Thomas chaplain 605995 605995 Toker, Thomas, of Dewstowe, chaplain 0
3663629 1914557 1914557 defendant Nycoll Thomas yeoman 605995 605995 Nycoll, Thomas, of Dewstowe, yeoman 1
3760866 1945401 1945401 defendant Juylle or Inylle John husbandman 605995 605995 Juylle or Inylle, John, of Dewstowe, husbandman 1
3805815 1959758 1959758 defendant Rodde John clerk 605995 605995 Rodde, John, of Dewstowe, clerk 7
3896373 1988993 1988993 defendant Ivell or Inell John husbandman 605995 605995 Ivell or Inell, John, of Dewstowe, husbandman 0
3921017 1997376 1997376 defendant Jule William husbandman 605995 605995 Jule, William, of Dewstowe, husbandman 1
3945694 2005569 2005569 defendant Holman John husbandman 605995 605995 Holman, John, of Dewstowe, husbandman 5
3957140 2009562 2009562 plaintiff Peers John   605995 605995 Peers, John, of Dewstowe 0
4010703 2028600 2028600 defendant Jule John miller 605995 605995 Jule, John, of Dewstowe, miller 0
4010704 2028600 2028600 defendant Towker John husbandman 605995 605995 Towker, John, of Dewstowe, husbandman 1
4010705 2028600 2028600 defendant Vyctory John husbandman 605995 605995 Vyctory, John, of Dewstowe, husbandman 2
4010829 2028648 2028648 defendant Gylberd Henry husbandman 605995 605995 Gylberd, Henry, of Dewstowe, husbandman 0
4010830 2028648 2028648 defendant Glyver Richard husbandman 605995 605995 Glyver, Richard, of Dewstowe, husbandman 1
4010831 2028648 2028648 defendant Garland Alice widow 605995 605995 Garland, Alice, of Dewstowe, widow 2
4010832 2028648 2028648 defendant Donacombe Thomasine widow 605995 605995 Donacombe, Thomasine, of Dewstowe, widow 3
4018702 2031423 2031423 defendant Bate Richard husbandman 605995 605995 Bate, Richard, of Dewstowe, husbandman 0
4028065 2034687 2034687 defendant John John tailor 605995 605995 John, John, of Dewstowe, tailor 3
4046970 2041368 2041368 defendant Tredwen John husbandman 605995 605995 Tredwen, John, of Dewstowe, husbandman 0
4046973 2041368 2041368 defendant Hydon John husbandman 605995 605995 Hydon, John, of Dewstowe, husbandman 3
4074993 2051358 2051358 defendant David Jenkin husbandman 605995 605995 David, Jenkin, of Dewstowe, husbandman 1
4083698 2054441 2054441 defendant Marten John gent 605995 605995 Marten, John, of Dewstowe, gent 0
4083699 2054441 2054441 defendant Marten William youngman 605995 605995 Marten, William, of Dewstowe, groom, youngman 1
4091658 2057308 2057308 defendant Baughe Morgan William husbandman 605995 605995 Baughe, Morgan William, of Dewstowe, husbandman 2
4097954 2059597 2059597 defendant Wotton John esq 605995 605995 Wotton, John, of Dewstowe, gent, or of Ingeborne, Devon, esq 0
4105014 2062066 2062066 defendant Pears Thomas   605995 605995 Pears, Thomas, of Dewstowe, groom 2
4105015 2062066 2062066 defendant Bodye John husbandman 605995 605995 Bodye, John, of Dewstowe, husbandman 3
4153067 2079174 2079174 defendant Banycke Nicholas husbandman 605995 605995 Banycke, Nicholas, of Dewstowe, husbandman 2
4155865 2080129 2080129 defendant Martyn John clerk 605995 605995 Martyn, John, of Dewstowe, clerk 0
4155866 2080129 2080129 defendant Pears John husbandman 605995 605995 Pears, John, of Dewstowe, husbandman 1
4155867 2080129 2080129 defendant Pyne Mark husbandman 605995 605995 Pyne, Mark, of Dewstowe, husbandman 2
4180356 2088606 2088606 defendant Bodye John husbandman 605995 605995 Bodye, John, of Dewstowe, husbandman 2
4180371 2088610 2088610 defendant Parson William husbandman 605995 605995 Parson, William, of Dewstowe, husbandman 0
4180372 2088610 2088610 defendant Parson Joan widow 605995 605995 Parson, Joan, of Dewstowe, widow 1
4268655 2119108 2119108 defendant Marten John clerk 605995 605995 Marten, John, of Dewstowe, clerk 0
4268656 2119108 2119108 defendant Marten Francis   605995 605995 Marten, Francis, of Dewstowe, groom 1
4268657 2119108 2119108 defendant Veale John yeoman 605995 605995 Veale, John, of Dewstowe, yeoman 2
4286493 2125210 2125210 defendant Jewell Robert husbandman 605995 605995 Jewell, Robert, of Dewstowe, husbandman 0
4298318 2129500 2129500 defendant Mertyn William yeoman 605995 605995 Mertyn, William, of Dewstowe, yeoman 1

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