names

111 rows where place_id = 625712

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3697991 1925597 1925597 defendant Carkeke William   625712 625712 Carkeke, William, of St Clere, franklin 0
3711759 1929992 1929992 defendant Carkeke William   625712 625712 Carkeke, William, of St Clere, franklin 0
3765797 1946966 1946966 defendant Slepe Nicholas chaplain 625712 625712 Slepe, Nicholas, of St Clere, chaplain 4
3783797 1952699 1952699 defendant Carkyke William gent 625712 625712 Carkyke, William, of St Clere, gent 0
3783805 1952703 1952703 defendant Carkyke William gent 625712 625712 Carkyke, William, of St Clere, gent 0
3813515 1962144 1962144 defendant Trubody William yeoman 625712 625712 Trubody, William, of St Clere, yeoman 1
3838526 1969973 1969973 defendant Hunt Thomas laborer 625712 625712 Hunt, Thomas, of St Clere, laborer 4
3840788 1970685 1970685 defendant Hunt Thomas husbandman 625712 625712 Hunt, Thomas, of St Clere, husbandman 0
3840806 1970692 1970692 defendant Hunt Thomas husbandman 625712 625712 Hunt, Thomas, of St Clere, husbandman 0
3854676 1975107 1975107 defendant Stevyn Thomas husbandman 625712 625712 Stevyn, Thomas, of St Clere, husbandman 0
3858586 1976357 1976357 defendant Hornabroke Roger husbandman 625712 625712 Hornabroke, Roger, of St Clere, husbandman 0
3875848 1982177 1982177 defendant John Richard fuller 625712 625712 John, Richard, of St Clere, fuller 0
3876849 1982498 1982498 defendant Brent Richard husbandman 625712 625712 Brent, Richard, of St Clere, husbandman 0
3877197 1982614 1982614 defendant John John husbandman 625712 625712 John, John, of St Clere, husbandman 0
3878524 1983061 1983061 defendant Carkyke William gent 625712 625712 Carkyke, William, of St Clere, gent 0
3881701 1984128 1984128 defendant Peter Thomas husbandman 625712 625712 Peter, Thomas, of St Clere, husbandman 1
3887219 1985991 1985991 defendant Blanchard John husbandman 625712 625712 Blanchard, John, of St Clere, husbandman 0
3904396 1991715 1991715 defendant Ludderd James husbandman 625712 625712 Ludderd, James, of St Clere, husbandman 0
3904397 1991715 1991715 defendant Ludderd Thomas husbandman 625712 625712 Ludderd, Thomas, of St Clere, husbandman 1
3904398 1991715 1991715 defendant Ludderd Margaret spinster 625712 625712 Ludderd, Margaret, of St Clere, spinster 2
3904399 1991715 1991715 defendant Hey Robert husbandman 625712 625712 Hey, Robert, of St Clere, husbandman 3
3913577 1994881 1994881 defendant Hamett John laborer 625712 625712 Hamett, John, of St Clere, laborer 2
3913578 1994881 1994881 defendant John William laborer 625712 625712 John, William, of St Clere, laborer 3
3919825 1996967 1996967 defendant Keyste John, senior husbandman 625712 625712 Keyste, John, senior, of St Clere, husbandman 0
3919826 1996967 1996967 defendant Keyste John, junior laborer 625712 625712 Keyste, John, junior, of St Clere, laborer 1
3919827 1996967 1996967 defendant Keyste William laborer 625712 625712 Keyste, William, of St Clere, laborer 2
3919828 1996967 1996967 defendant Gedye John, senior laborer 625712 625712 Gedye, John, senior, of St Clere, laborer 3
3919829 1996967 1996967 defendant Gedye John, junior laborer 625712 625712 Gedye, John, junior, of St Clere, laborer 4
3928806 1999971 1999971 defendant John John   625712 625712 John, John, of St Clere 1
3941453 2004151 2004151 defendant Cole John gent 625712 625712 Cole, John, of St Clere, gent 0
3945983 2005673 2005673 defendant Dawe Edward husbandman 625712 625712 Dawe, Edward, of St Clere, husbandman 0
3945984 2005673 2005673 defendant Dawe Stephen husbandman 625712 625712 Dawe, Stephen, of St Clere, husbandman 1
3945985 2005673 2005673 defendant Dawe Richard husbandman 625712 625712 Dawe, Richard, of St Clere, husbandman 2
3945986 2005673 2005673 defendant Dawe John, senior husbandman 625712 625712 Dawe, John, senior, of St Clere, husbandman 3
3945987 2005673 2005673 defendant Dawe John, junior husbandman 625712 625712 Dawe, John, junior, of St Clere, husbandman 4
3969915 2014077 2014077 defendant Every John husbandman 625712 625712 Every, John, of St Clere, husbandman 0
3969916 2014077 2014077 defendant Every Joan spinster 625712 625712 together with Every, Joan, of St Clere, spinster 1
3974350 2015600 2015600 defendant Every John husbandman 625712 625712 Every, John, of St Clere, husbandman 0
3974351 2015600 2015600 defendant Pennarth Joan spinster 625712 625712 Pennarth, Joan, of St Clere, spinster 1
3974352 2015600 2015600 defendant Every Edward laborer 625712 625712 Every, Edward, of St Clere, laborer 2
3974353 2015600 2015600 defendant Every John laborer 625712 625712 Every, John, of St Clere, laborer 3
3974357 2015602 2015602 defendant Every John husbandman 625712 625712 Every, John, of St Clere, husbandman 0
3974358 2015602 2015602 defendant Every Joan spinster 625712 625712 together with Every, Joan, of St Clere, spinster 1
4022903 2032917 2032917 defendant Hatche Stephen tailor 625712 625712 Hatche, Stephen, of St Clere, tailor 0
4028019 2034674 2034674 defendant Woo John weaver 625712 625712 Woo, John, of St Clere, weaver 0
4033215 2036533 2036533 defendant Jey Thomas husbandman 625712 625712 Jey, Thomas, of St Clere, husbandman 0
4043804 2040238 2040238 defendant Coll John, junior gent 625712 625712 Coll, John, junior, of St Clere, gent 7
4043825 2040241 2040241 defendant Coll John gent 625712 625712 Coll, John, of St Clere, gent 6
4049202 2042159 2042159 defendant Hatche Stephen tailor 625712 625712 Hatche, Stephen, of St Clere, tailor 0
4070911 2049896 2049896 defendant Dowe Richard, senior husbandman 625712 625712 Dowe, Richard, senior, of St Clere, husbandman 0
4070912 2049896 2049896 defendant Dowe Richard, junior husbandman 625712 625712 Dowe, Richard, junior, of St Clere, husbandman 1
4070913 2049896 2049896 defendant Dowe William, senior husbandman 625712 625712 Dowe, William, senior, of St Clere, husbandman 2
4070914 2049896 2049896 defendant Dowe William, junior husbandman 625712 625712 Dowe, William, junior, of St Clere, husbandman 3
4079377 2052927 2052927 defendant Downynge John husbandman 625712 625712 Downynge, John, of St Clere, husbandman 0
4130777 2071317 2071317 defendant Trussell John husbandman 625712 625712 Trussell, John, of St Clere, husbandman 0
4171878 2085625 2085625 defendant Onghe or Oughe Martin husbandman 625712 625712 Onghe or Oughe, Martin, of St Clere, husbandman 0
4174546 2086566 2086566 defendant Coll John, junior gent 625712 625712 Coll, John, junior, of St Clere, gent 0
4182753 2089445 2089445 defendant Dirrye Richard husbandman 625712 625712 Dirrye, Richard, of St Clere, husbandman 0
4206356 2097767 2097767 defendant Dyrrye Richard husbandman 625712 625712 Dyrrye, Richard, of St Clere, husbandman 0
4222314 2103294 2103294 defendant Collyng John yeoman 625712 625712 Collyng, John, of St Clere, yeoman 1
4222640 2103410 2103410 defendant Daryte John gent 625712 625712 Daryte, John, of St Clere, gent 0
4222642 2103411 2103411 defendant Daryte Peter yeoman 625712 625712 Daryte, Peter, of St Clere, yeoman 0
4226699 2104810 2104810 defendant Keise Robert, senior husbandman 625712 625712 Keise, Robert, senior, of St Clere, husbandman 0
4244038 2110988 2110988 defendant Lyone Ralph husbandman 625712 625712 Lyone, Ralph, of St Clere, husbandman 1
4244040 2110989 2110989 defendant Lyon Richard, junior husbandman 625712 625712 Lyon, Richard, junior, of St Clere, husbandman 0
4244041 2110989 2110989 defendant Burry John husbandman 625712 625712 Burry, John, of St Clere, husbandman 1
4244042 2110989 2110989 defendant Score Pascasius husbandman 625712 625712 Score, Pascasius, of St Clere, husbandman 2
4244043 2110989 2110989 defendant Score Peter husbandman 625712 625712 Score, Peter, of St Clere, husbandman 3
4247806 2112251 2112251 defendant Collynge John yeoman 625712 625712 Collynge, John, of St Clere, yeoman 1
4294063 2127955 2127955 defendant Dirry Richard husbandman 625712 625712 Dirry, Richard, of St Clere, husbandman 1
4310210 2133726 2133726 defendant Daryte John gent 625712 625712 Daryte, John, of St Clere, gent 1
4310211 2133726 2133726 defendant Darye Peter   625712 625712 Darye, Peter, of St Clere, gent, son of John 2
4384740 2159582 2159582 defendant Daryte Peter husbandman 625712 625712 Daryte, Peter, of St Clere, husbandman 0
4391776 2161869 2161869 defendant Lyon Thomas yeoman 625712 625712 Lyon, Thomas, of St Clere, yeoman 1
4406293 2166671 2166671 defendant Coll John, senior gent 625712 625712 Coll, John, senior, of St Clere, gent 0
4406294 2166671 2166671 defendant Coll John, junior   625712 625712 Coll, John, junior, of St Clere, gent, his son 1
4503206 2201568 2201568 defendant atte Wode John   625712 625712 atte Wode, John, of St Clere 4
4536779 2211774 2211774 defendant Loyt Walter   625712 625712 Loyt, Walter, of St Clere 0
4770315 2286686 2286686 defendant Drewe William smith 625712 625712 Drewe, William, of St Clere, smith 2
4795026 2294585 2294585 defendant Drewe Thomas smith 625712 625712 Drewe, Thomas, of St Clere, smith 2
4825188 2303919 2303919 defendant Bugge John husbandman 625712 625712 (Bugge, John, of St Clere, husbandman 1
4825192 2303920 2303920 defendant Bugge John husbandman 625712 625712 (Bugge, John, of St Clere, husbandman 1
4982587 2351707 2351707 defendant Clouter John husbandman 625712 625712 Clouter, John, of St Clere, husbandman 0
4982588 2351707 2351707 defendant Clouter Robert husbandman 625712 625712 Clouter, Robert, of St Clere, husbandman 1
4982591 2351707 2351707 defendant Hamond Richard husbandman 625712 625712 Hamond, Richard, of St Clere, husbandman 4
4982592 2351707 2351707 defendant Grega John husbandman 625712 625712 Grega, John, of St Clere, husbandman 5
4982593 2351707 2351707 defendant Gilla John husbandman 625712 625712 Gilla, John, of St Clere, husbandman 6
4982594 2351707 2351707 defendant Grega Vincent husbandman 625712 625712 Grega, Vincent, of St Clere, husbandman 7
4982595 2351707 2351707 defendant Daryght Ralph husbandman 625712 625712 Daryght, Ralph, of St Clere, husbandman 8
4982596 2351707 2351707 defendant Dykyn Walter husbandman 625712 625712 Dykyn, Walter, of St Clere, husbandman 9
4982597 2351707 2351707 defendant Nicoll Isabel widow 625712 625712 Nicoll, Isabel, of St Clere, widow 10
4982598 2351707 2351707 defendant Warn Thomas tailor 625712 625712 Warn, Thomas, of St Clere, tailor 11
5009311 2359613 2359613 defendant Trote Henry yeoman 625712 625712 Trote, Henry, of St Clere, yeoman 3
5015195 2361330 2361330 defendant Payn Thomas husbandman 625712 625712 Payn, Thomas, of St Clere, husbandman 5
5096532 2385419 2385419 defendant Polglasse Thomas husbandman 625712 625712 Polglasse, Thomas, of St Clere, husbandman 1
5096533 2385419 2385419 defendant Prythen John husbandman 625712 625712 Prythen, John, of St Clere, husbandman 2
5096534 2385419 2385419 defendant Jon Thomas husbandman 625712 625712 Jon, Thomas, of St Clere, husbandman 3
5096535 2385419 2385419 defendant Cloweter John husbandman 625712 625712 Cloweter, John, of St Clere, husbandman 4
5096537 2385419 2385419 defendant Gregge Richard husbandman 625712 625712 Gregge, Richard, of St Clere, husbandman 6
5096538 2385419 2385419 defendant Bray William husbandman 625712 625712 Bray, William, of St Clere, husbandman 7

Next page

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