names

42 rows where place_id = 611718

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3689779 1922960 1922960 defendant Walpole Henry gent 611718 611718 Walpole, Henry, of Harpley, gent 0
3698410 1925723 1925723 defendant Fellowe Thomas woolman 611718 611718 Fellowe, Thomas, of Harpley, woolman 1
3813903 1962259 1962259 defendant Walpole Henry gent 611718 611718 Walpole, Henry, of Harpley, gent 2
3847601 1972819 1972819 defendant Frost Giles yeoman 611718 611718 Frost, Giles, of Harpley, yeoman 2
3853003 1974560 1974560 defendant Dowse Arthur husbandman 611718 611718 Dowse, Arthur, of Harpley, husbandman 0
3853004 1974560 1974560 defendant Mudde Robert husbandman 611718 611718 Mudde, Robert, of Harpley, husbandman 1
3853097 1974586 1974586 defendant Frost George husbandman 611718 611718 Frost, George, of Harpley, husbandman 0
3853098 1974586 1974586 defendant Frost Giles yeoman 611718 611718 Frost, Giles, of Harpley, yeoman 1
3869441 1980021 1980021 defendant Frost Giles husbandman 611718 611718 Frost, Giles, of Harpley, husbandman 0
3869442 1980021 1980021 defendant Dowe Arthur husbandman 611718 611718 Dowe, Arthur, of Harpley, husbandman 1
3872864 1981140 1981140 defendant Frost Giles husbandman 611718 611718 Frost, Giles, of Harpley, husbandman 0
3877113 1982586 1982586 defendant Salter Ralph gent 611718 611718 Salter, Ralph, of Harpley, gent 4
3896777 1989134 1989134 plaintiff Walpole Henry gent 611718 611718 Walpole, Henry, of Harpley, gent 0
3911119 1994046 1994046 plaintiff Walpole Henry gent 611718 611718 Walpole, Henry, of Harpley, gent 0
3957013 2009516 2009516 plaintiff Partricke George   611718 611718 Partricke, George, of Harpley 0
3959468 2010401 2010401 defendant Dysplyn Thomas husbandman 611718 611718 Dysplyn, Thomas, of Harpley, husbandman 0
3979424 2017390 2017390 defendant Gogg Robert husbandman 611718 611718 Gogg, Robert, of Harpley, husbandman 1
3982145 2018374 2018374 defendant Fellowe Thomas husbandman 611718 611718 Fellowe, Thomas, of Harpley, husbandman 0
4035232 2037280 2037280 defendant Fowle Ralph yeoman 611718 611718 Fowle, Ralph, of Harpley, yeoman 0
4035235 2037281 2037281 defendant Fowle Ralph yeoman 611718 611718 Fowle, Ralph, of Harpley, yeoman 0
4035237 2037281 2037281 defendant House John husbandman 611718 611718 House, John, of Harpley, husbandman 2
4063333 2047176 2047176 defendant Cobbes John   611718 611718 Cobbes, John, of Harpley, shepherd 2
4081878 2053822 2053822 defendant Dower John   611718 611718 Dower, John, of Harpley, husbandman, his son 1
4217704 2101682 2101682 defendant Kenyon Robert clerk 611718 611718 Kenyon, Robert, of Harpley, clerk 1
4243928 2110949 2110949 defendant Kenyon Robert clerk 611718 611718 Kenyon, Robert, of Harpley, clerk 2
4277046 2121905 2121905 defendant Mychell Robert husbandman 611718 611718 Mychell, Robert, of Harpley, husbandman 0
4283795 2124242 2124242 defendant Syddall Lawrence husbandman 611718 611718 Syddall, Lawrence, of Harpley, husbandman 0
4309438 2133463 2133463 defendant Peerson Robert husbandman 611718 611718 Peerson, Robert, of Harpley, husbandman 0
4313697 2134897 2134897 defendant Mychell Richard husbandman 611718 611718 Mychell, Richard, of Harpley, husbandman 0
4323630 2138318 2138318 defendant Ingoldewe Edward husbandman 611718 611718 Ingoldewe, Edward, of Harpley, husbandman 2
4510854 2203849 2203849 defendant Drewe John   611718 611718 Drewe, John, of Harpley, parson 5
5305100 2446526 2446526 defendant Martyn John husbandman 611718 611718 Martyn, John, of Harpley, husbandman 0
5310436 2448158 2448158 defendant Fouldon Alexander husbandman 611718 611718 Fouldon, Alexander, of Harpley, husbandman 0
5310437 2448158 2448158 defendant Walden John husbandman 611718 611718 Walden, John, of Harpley, husbandman 1
5338157 2456501 2456501 defendant Geynes John husbandman 611718 611718 Geynes, John, of Harpley, husbandman 3
5516531 2509999 2509999 defendant Cobbe William husbandman 611718 611718 Cobbe, William, of Harpley, husbandman 0
5516535 2510001 2510001 defendant Wylly Thomas husbandman 611718 611718 Wylly, Thomas, of Harpley, husbandman 0
5546920 2519100 2519100 defendant Sporle William husbandman 611718 611718 Sporle, William, of Harpley, husbandman 0
5553110 2520948 2520948 defendant Anger or Auger Clement yeoman 611718 611718 Anger or Auger, Clement, of Harpley, yeoman 0
5558471 2522422 2522422 defendant Frost Thomas yeoman 611718 611718 Frost, Thomas, of Harpley, yeoman 0
5573996 2526956 2526956 defendant Anger or Auger Clement gent 611718 611718 Anger or Auger, Clement, of Harpley, gent 0
5574927 2527240 2527240 defendant Anger Clement husbandman 611718 611718 Anger, Clement, of Harpley, husbandman 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);