names

27 rows where place_id = 598612

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3633306 1905232 1905232 defendant Asten John butcher 598612 598612 Asten, John, of Gowdherst, butcher 1
3636542 1906224 1906224 defendant Bratyll John cutler 598612 598612 Bratyll, John, of Gowdherst, cutler 0
3644068 1908575 1908575 defendant Rode Edward   598612 598612 Rode, Edward, of Gowdherst, scythe maker 0
3949648 2006952 2006952 defendant Tuttye Robert butcher 598612 598612 Tuttye, Robert, of Gowdherst, butcher 0
3990181 2021245 2021245 defendant Wymsherst John wheeler 598612 598612 Wymsherst, John, of Gowdherst, wheeler 2
3995339 2023074 2023074 defendant Austen Richard clothier 598612 598612 Austen, Richard, of Gowdherst, clothier 0
4047465 2041544 2041544 defendant Austen Richard clothier 598612 598612 Austen, Richard, of Gowdherst, clothier 0
4136520 2073405 2073405 defendant Morrys John tailor 598612 598612 Morrys, John, of Gowdherst, tailor 0
4168027 2084304 2084304 defendant Mason William husbandman 598612 598612 Mason, William, of Gowdherst, husbandman 4
4168028 2084304 2084304 defendant Fuller Stephen husbandman 598612 598612 Fuller, Stephen, of Gowdherst, husbandman 5
4168029 2084304 2084304 defendant Rogers Nicholas husbandman 598612 598612 Rogers, Nicholas, of Gowdherst, husbandman 6
4229913 2105945 2105945 defendant Fawkner John weaver 598612 598612 Fawkner, John, of Gowdherst, weaver 1
4266184 2118329 2118329 defendant Pattenden Henry   598612 598612 Pattenden, Henry, of Gowdherst yeoman, son of Henry Pattenden, of Gowtherst 1
4310014 2133659 2133659 defendant Jarvyce Thomas blacksmith 598612 598612 Jarvyce, Thomas, of Gowdherst, blacksmith 1
4313308 2134761 2134761 defendant Daye Richard yeoman 598612 598612 Daye, Richard, of Gowdherst, yeoman 0
4317106 2136099 2136099 defendant Besbeche Thomas butcher 598612 598612 Besbeche, Thomas, of Gowdherst, butcher 0
4320105 2137137 2137137 defendant Reaves Thomas yeoman 598612 598612 Reaves Thomas, of Gowdherst, yeoman 1
4362032 2151465 2151465 defendant Sab or Sabbe Samuel yeoman 598612 598612 Sab or Sabbe, Samuel, of Gowdherst, yeoman 0
4362040 2151469 2151469 defendant Parson William clothier 598612 598612 Parson, William, of Gowdherst, clothier 0
4366558 2153088 2153088 defendant Pattenden Henry yeoman 598612 598612 Pattenden, Henry, of Gowdherst, yeoman 0
4366559 2153088 2153088 defendant Besbitch George yeoman 598612 598612 Besbitch, George, of Gowdherst, yeoman 1
4366561 2153089 2153089 defendant Pattenden Henry yeoman 598612 598612 Pattenden, Henry, of Gowdherst, yeoman 0
4366562 2153089 2153089 defendant Besbitch George yeoman 598612 598612 Besbitch, George, of Gowdherst, yeoman 1
4373375 2155544 2155544 defendant Parson William husbandman 598612 598612 Parson, William, of Gowdherst, husbandman 2
5567394 2525044 2525044 defendant Rodde Edward smith 598612 598612 Rodde, Edward, of Gowdherst, smith 0
5592465 2532629 2532629 defendant Boycott Henry carpenter 598612 598612 Boycott, Henry, of Gowdherst, carpenter 0
5604521 2536276 2536276 defendant Benskyn John weaver 598612 598612 Benskyn, John, of Gowdherst, weaver 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);