names

45 rows where place_id = 595460

✎ 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
3620557 1874005 1874005 defendant Wade Richard husbandman 595460 595460 Wade, Richard, of Thorverton, husbandman 0
3657998 1912754 1912754 defendant Nycoll David husbandman 595460 595460 Nycoll, David, of Thorverton, husbandman 0
3676279 1918626 1918626 defendant Denys John butcher 595460 595460 Denys, John, of Thorverton, butcher 4
3702703 1927117 1927117 defendant Cadbury Robert cordwainer 595460 595460 Cadbury, Robert, of Thorverton, cordwainer 0
3721960 1933133 1933133 defendant Pedler William tucker 595460 595460 Pedler, William, of Thorverton, tucker 0
3721961 1933133 1933133 defendant Pyne John tailor 595460 595460 Pyne, John, of Thorverton, tailor 1
3806170 1959856 1959856 defendant Wilston John husbandman 595460 595460 Wilston, John, of Thorverton, husbandman 1
3813088 1962001 1962001 defendant Wall Nicholas fuller 595460 595460 Wall, Nicholas, of Thorverton, fuller 0
3823929 1965355 1965355 defendant Wilson John husbandman 595460 595460 Wilson, John, of Thorverton, husbandman 1
3851401 1974037 1974037 defendant Wyllys Alice widow 595460 595460 Wyllys, Alice, of Thorverton, widow 0
3901894 1990860 1990860 defendant Orchard Walter butcher 595460 595460 Orchard, Walter, of Thorverton, butcher 0
3902307 1991003 1991003 defendant Orcharde Walter butcher 595460 595460 Orcharde, Walter, of Thorverton, butcher 2
3930444 2000529 2000529 defendant Orchard Walter butcher 595460 595460 Orchard, Walter, of Thorverton, butcher 0
3932608 2001199 2001199 defendant Chacher John husbandman 595460 595460 Chacher, John, of Thorverton, husbandman 0
3969536 2013956 2013956 defendant Adams alias Holmes Thomas husbandman 595460 595460 Adams alias Holmes, Thomas, of Thorverton, husbandman 0
3969537 2013956 2013956 defendant Denrydge Henry miller 595460 595460 Denrydge, Henry, of Thorverton, miller 1
4017683 2031034 2031034 defendant Passmore John husbandman 595460 595460 Passmore, John, of Thorverton, husbandman 0
4035585 2037400 2037400 defendant Furse John gent 595460 595460 Furse, John, of Thorverton, or of Raddon, Devon, gent 0
4044162 2040366 2040366 defendant Furse John gent 595460 595460 Furse, John, of Thorverton, gent 0
4064705 2047665 2047665 defendant Shere Michael merchant 595460 595460 Shere, Michael, of Thorverton, merchant 0
4099799 2060250 2060250 defendant Gathell or Gachell John yeoman 595460 595460 Gathell or Gachell, John, of Thorverton, yeoman 0
4115503 2065832 2065832 defendant Hunt Richard husbandman 595460 595460 Hunt, Richard, of Thorverton, husbandman 0
4188294 2091409 2091409 plaintiff Wade Richard   595460 595460 Wade, Richard, of Thorverton 0
4215163 2100799 2100799 defendant Weekes Henry husbandman 595460 595460 Weekes, Henry, of Thorverton, husbandman 1
4289625 2126357 2126357 defendant Gatchall John husbandman 595460 595460 Gatchall, John, of Thorverton, husbandman 0
4360615 2150965 2150965 defendant Turner John yeoman 595460 595460 Turner, John, of Thorverton, yeoman 1
4934439 2337164 2337164 defendant Eyre William miller 595460 595460 Eyre, William, of Thorverton, miller 0
4945703 2340637 2340637 defendant Mille Stephen husbandman 595460 595460 Mille, Stephen, of Thorverton, husbandman 0
4946813 2341007 2341007 defendant Raddon John husbandman 595460 595460 Raddon, John, of Thorverton, husbandman 1
4997946 2356246 2356246 defendant Wade John husbandman 595460 595460 Wade, John, of Thorverton, husbandman 1
5106081 2388217 2388217 defendant Tounesende John husbandman 595460 595460 Tounesende, John, of Thorverton, husbandman 1
5106082 2388217 2388217 defendant Brounston Thomas husbandman 595460 595460 Brounston, Thomas, of Thorverton, husbandman 2
5106083 2388217 2388217 defendant Drake John, junior husbandman 595460 595460 Drake, John, junior, of Thorverton, husbandman 3
5106084 2388217 2388217 defendant Brounston John husbandman 595460 595460 Brounston, John, of Thorverton, husbandman 4
5106085 2388217 2388217 defendant Srake John, senior husbandman 595460 595460 Srake, John, senior, of Thorverton, husbandman 5
5106089 2388218 2388218 defendant Tounesende John husbandman 595460 595460 Tounesende, John, of Thorverton, husbandman 2
5106090 2388218 2388218 defendant Brounston Thomas husbandman 595460 595460 Brounston, Thomas, of Thorverton, husbandman 3
5106091 2388218 2388218 defendant Drake John, junior husbandman 595460 595460 Drake, John, junior, of Thorverton, husbandman 4
5106092 2388218 2388218 defendant Brounston John husbandman 595460 595460 Brounston, John, of Thorverton, husbandman 5
5106093 2388218 2388218 defendant Srake John, senior husbandman 595460 595460 Srake, John, senior, of Thorverton, husbandman 6
5283507 2440228 2440228 defendant Wade Richard husbandman 595460 595460 Wade, Richard, of Thorverton, husbandman 6
5283508 2440228 2440228 defendant Mersshehay John husbandman 595460 595460 Mersshehay, John, of Thorverton, husbandman 7
5283509 2440228 2440228 defendant Wytherawe John husbandman 595460 595460 Wytherawe, John, of Thorverton, husbandman 8
5317156 2450212 2450212 defendant Hobbe Richard   595460 595460 Hobbe, Richard, of Thorverton, groom 0
5364105 2464431 2464431 defendant Say Richard yeoman 595460 595460 Say, Richard, of Thorverton, 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);