names

38 rows where place_id = 608208

✎ 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
3672628 1917438 1917438 defendant Gardiner Lawrence clerk 608208 608208 Gardiner, Lawrence, of Newnam, clerk 0
3672629 1917438 1917438 defendant Gardiner Thomas husbandman 608208 608208 Gardiner, Thomas, of Newnam, husbandman 1
3672630 1917438 1917438 defendant Gardiner John husbandman 608208 608208 Gardiner, John, of Newnam, husbandman 2
3701367 1926673 1926673 defendant Dowman Christopher yeoman 608208 608208 Dowman, Christopher, of Newnam, yeoman 0
3701369 1926674 1926674 defendant Dowman Christopher yeoman 608208 608208 Dowman, Christopher, of Newnam, yeoman 0
3743250 1939753 1939753 defendant Dowman Christopher gent 608208 608208 Dowman, Christopher, of Newnam, gent 0
3751813 1942487 1942487 defendant Parkys Thomas husbandman 608208 608208 Parkys, Thomas, of Newnam, husbandman 1
3752283 1942637 1942637 defendant Strowde Richard esq 608208 608208 Strowde, Richard, of Newnam, esq 0
3768960 1947945 1947945 defendant Strowde Richard esq 608208 608208 Strowde, Richard, of Newnam, esq 0
3780137 1951511 1951511 defendant Plummer John husbandman 608208 608208 Plummer, John, of Newnam, husbandman 0
3786758 1953655 1953655 defendant Strowde Richard esq 608208 608208 Strowde, Richard, of Newnam, esq 0
3802676 1958732 1958732 defendant Strowde Richard esq 608208 608208 Strowde, Richard, of Newnam, esq 0
3806526 1959955 1959955 defendant Born James yeoman 608208 608208 Born, James, of Newnam, yeoman 0
3809973 1961005 1961005 defendant Dowman Christopher yeoman 608208 608208 Dowman, Christopher, of Newnam, yeoman 0
3842059 1971070 1971070 defendant Phelyp John husbandman 608208 608208 Phelyp, John, of Newnam, husbandman 0
3844914 1971952 1971952 defendant Felyp John husbandman 608208 608208 Felyp, John, of Newnam, husbandman 0
3849513 1973446 1973446 defendant Shepard Roger husbandman 608208 608208 Shepard, Roger, of Newnam, husbandman 2
3858274 1976245 1976245 defendant Dowman Christopher yeoman 608208 608208 Dowman, Christopher, of Newnam, yeoman 0
3859100 1976533 1976533 defendant Dowman Christopher yeoman 608208 608208 Dowman, Christopher, of Newnam, yeoman 0
3903016 1991235 1991235 plaintiff Foster Elizabeth widow of Richard Foster 608208 608208 Foster, Elizabeth, of Newnam, widow of Richard Foster 0
3903018 1991236 1991236 plaintiff Foster Elizabeth widow of Richard Foster 608208 608208 Foster, Elizabeth, of Newnam, widow of Richard Foster 0
3903020 1991237 1991237 plaintiff Foster Elizabeth widow of Richard Foster 608208 608208 Foster, Elizabeth, of Newnam, widow of Richard Foster 0
3917913 1996354 1996354 defendant Whytcombe William   608208 608208 Whytcombe, William, of Newnam, yeoman, son of Whytcombe, William 0
3949154 2006769 2006769 defendant South William yeoman 608208 608208 South, William, of Newnam, yeoman 0
3962026 2011301 2011301 defendant Goodman Henry   608208 608208 Goodman, Henry, of Newnam, husbandman, executrox of 2
3962027 2011301 2011301 defendant Goodman Elizabeth widow 608208 608208 Goodman, Elizabeth, of Newnam, widow 3
3964502 2012185 2012185 defendant Burleye Richard weaver 608208 608208 Burleye, Richard, of Newnam, weaver 4
3973878 2015432 2015432 defendant Reve James husbandman 608208 608208 Reve, James, of Newnam, husbandman 0
3998847 2024343 2024343 defendant Forster Thomas gent 608208 608208 Forster, Thomas, of Newnam, gent 0
4143547 2075900 2075900 defendant Hopswood George yeoman 608208 608208 Hopswood, George, of Newnam, yeoman 0
4181004 2088833 2088833 defendant Mott William clerk 608208 608208 Mott, William, of Newnam, clerk 3
4191890 2092723 2092723 defendant Hopswood George yeoman 608208 608208 Hopswood, George, of Newnam, yeoman 0
4327849 2139637 2139637 defendant Plomer John yeoman 608208 608208 Plomer, John, of Newnam, yeoman 0
4334780 2141902 2141902 defendant Goodman Henry husbandman 608208 608208 Goodman, Henry, of Newnam, husbandman 0
4389669 2161175 2161175 defendant Chynn Walter yeoman 608208 608208 Chynn, Walter, of Newnam, yeoman 0
4400833 2164871 2164871 defendant Forman Peter butcher 608208 608208 Forman, Peter, of Newnam, butcher 1
4406636 2166783 2166783 defendant Aylewey Maurice yeoman 608208 608208 Aylewey, Maurice, of Newnam, yeoman 2
4923149 2333657 2333657 defendant Stucley Thomas gent 608208 608208 Stucley, Thomas, of Newnam, 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);