names

19 rows where place_id = 612095

✎ 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
3691515 1923503 1923503 defendant Barker John husbandman 612095 612095 Barker, John, of Magna Dewchurche, husbandman 1
3909081 1993337 1993337 defendant Gruffith Philip yeoman 612095 612095 Gruffith, Philip, of Magna Dewchurche, yeoman 0
3909082 1993337 1993337 defendant ap Robert John husbandman 612095 612095 ap Robert, John, of Magna Dewchurche, husbandman 1
3911529 1994173 1994173 defendant Webbe Matthew husbandman 612095 612095 Webbe, Matthew, of Magna Dewchurche, husbandman 0
4117273 2066480 2066480 defendant Alye Elizabeth widow 612095 612095 Alye, Elizabeth, of Magna Dewchurche, widow 1
4219026 2102150 2102150 defendant Jenkyns David yeoman 612095 612095 Jenkyns, David, of Magna Dewchurche, yeoman 0
4220641 2102717 2102717 defendant Powell William yeoman 612095 612095 Powell, William, of Magna Dewchurche, yeoman 4
4228086 2105301 2105301 defendant Jenkyns David yeoman 612095 612095 Jenkyns, David, of Magna Dewchurche, yeoman 0
4229007 2105628 2105628 defendant Jenkyns Hugh husbandman 612095 612095 Jenkyns, Hugh, of Magna Dewchurche, husbandman 0
4233112 2107088 2107088 defendant Pritfote Henry yeoman 612095 612095 Pritfote, Henry, of Magna Dewchurche, or of Kevernoll, yeoman 0
4233113 2107088 2107088 defendant Prytfote Theophilus yeoman 612095 612095 Prytfote, Theophilus, of Magna Dewchurche, yeoman 1
4241728 2110219 2110219 defendant Prytfoote Henry yeoman 612095 612095 Prytfoote, Henry, of Magna Dewchurche, or of Kevernoll, yeoman 0
4241729 2110219 2110219 defendant Prytfoote Theophilus yeoman 612095 612095 Prytfoote, Theophilus, of Magna Dewchurche, yeoman 1
4296450 2128831 2128831 defendant Pigge Philip yeoman 612095 612095 Pigge, Philip, of Magna Dewchurche, yeoman 1
4366539 2153081 2153081 defendant David James Thomas yeoman 612095 612095 David, James Thomas, of Magna Dewchurche, yeoman 0
4384568 2159528 2159528 defendant Griffith Roger yeoman 612095 612095 Griffith, Roger, of Magna Dewchurche, yeoman 0
4384570 2159529 2159529 defendant Powell William weaver 612095 612095 Powell, William, of Magna Dewchurche, weaver 0
4398897 2164213 2164213 defendant Verryer alias Englishman John yeoman 612095 612095 Verryer alias Englishman, John, of Magna Dewchurche, yeoman 0
4411709 2168512 2168512 defendant Barrowe Richard gent 612095 612095 Barrowe, Richard, of Magna Dewchurche, or of Bullinghope, gent 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);