names

35 rows where place_id = 649664

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3907852 1992915 1992915 plaintiff Phyllypps Thomas husbandman 649664 649664 Phyllypps, Thomas, of Easton, husbandman 0
3909066 1993331 1993331 defendant Dansay Thomas gent 649664 649664 Dansay, Thomas, of Easton, gent 0
3909068 1993332 1993332 defendant Dansay Thomas gent 649664 649664 Dansay, Thomas, of Easton, gent 0
3921572 1997558 1997558 plaintiff Phyllyppys Thomas husbandman 649664 649664 Phyllyppys, Thomas, of Easton, husbandman 0
4008285 2027728 2027728 plaintiff Meres Henry yeoman 649664 649664 Meres, Henry, of Easton, yeoman 0
4034100 2036858 2036858 defendant Plantying John husbandman 649664 649664 Plantying, John, of Easton, husbandman 0
4068170 2048919 2048919 defendant Clesbye Astulphus gent 649664 649664 Clesbye, Astulphus, of Easton, Gent, gent 0
4076487 2051886 2051886 defendant Tredway Robert gent 649664 649664 Tredway, Robert, of Easton, gent 0
4095888 2058861 2058861 defendant Cooke Robert husbandman 649664 649664 Cooke, Robert, of Easton, husbandman 3
4169145 2084709 2084709 defendant Jeffreyson John husbandman 649664 649664 Jeffreyson, John, of Easton, husbandman 1
4169153 2084712 2084712 defendant Stricland William gent 649664 649664 Stricland, William, of Easton, gent 0
4169154 2084712 2084712 defendant Jeffreyson John husbandman 649664 649664 Jeffreyson, John, of Easton, husbandman 1
4169155 2084712 2084712 defendant Jeffreyson William husbandman 649664 649664 Jeffreyson, William, of Easton, husbandman 2
4169156 2084712 2084712 defendant Whelpdale Henry husbandman 649664 649664 Whelpdale, Henry, of Easton, husbandman 3
4190011 2092008 2092008 defendant Smythe alias Hulinne Humphrey husbandman 649664 649664 Smythe alias Hulinne, Humphrey, of Easton, husbandman 0
4198243 2094933 2094933 defendant Vincent Thomas gent 649664 649664 Vincent, Thomas, of Easton, gent 0
4214303 2100520 2100520 defendant Clarke Mathew clerk 649664 649664 Clarke, Mathew, of Easton, clerk 0
4216436 2101243 2101243 defendant Booty Francis cooper 649664 649664 Booty, Francis, of Easton, cooper 2
4232864 2106999 2106999 defendant Bill William clerk 649664 649664 Bill, William, of Easton, clerk 0
4242410 2110458 2110458 defendant Jacobbe William husbandman 649664 649664 Jacobbe, William, of Easton, husbandman 2
4242415 2110459 2110459 defendant Jacobbe William husbandman 649664 649664 Jacobbe, William, of Easton, husbandman 2
4246261 2111725 2111725 defendant Newman William husbandman 649664 649664 Newman, William, of Easton, husbandman 0
4304746 2131794 2131794 defendant Randes William yeoman 649664 649664 Randes, William, of Easton, yeoman 0
4313091 2134698 2134698 defendant Wrenche William yeoman 649664 649664 Wrenche, William, of Easton, yeoman 0
4313323 2134767 2134767 defendant Wrenche William yeoman 649664 649664 Wrenche, William, of Easton, yeoman 0
4318971 2136750 2136750 defendant Wrenche William yeoman 649664 649664 Wrenche, William, of Easton, yeoman 0
4343727 2145085 2145085 defendant Atkyns Thomas maltster 649664 649664 Atkyns, Thomas, of Easton, maltster 1
4354532 2148820 2148820 defendant Farthing Clement husbandman 649664 649664 Farthing, Clement, of Easton, husbandman 0
4354558 2148828 2148828 defendant Garvrey or Garbrey George gent 649664 649664 Garvrey or Garbrey, George, of Easton, gent 0
4385632 2159878 2159878 defendant Warne John yeoman 649664 649664 Warne, John, of Easton, yeoman 1
4396034 2163249 2163249 defendant Wade Francis yeoman 649664 649664 Wade, Francis, of Easton, yeoman 1
4399019 2164253 2164253 defendant Wade Francis yeoman 649664 649664 Wade, Francis, of Easton, yeoman 1
4399022 2164254 2164254 defendant Wade Francis yeoman 649664 649664 Wade, Francis, of Easton, yeoman 1
4458313 2187638 2187638 defendant Gilbert Thomas   649664 649664 Gilbert, Thomas, of Easton 1
5571133 2526119 2526119 defendant Hawes William husbandman 649664 649664 Hawes, William, of Easton, husbandman 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);