names

24 rows where place_id = 612325

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3692674 1923897 1923897 defendant Stretton John yeoman 612325 612325 Stretton, John, of Uttoxator, yeoman 3
3741957 1939351 1939351 defendant Paver John husbandman 612325 612325 Paver, John, of Uttoxator, husbandman 1
3747410 1941103 1941103 defendant Mynars Richard esq 612325 612325 Mynars, Richard, of Uttoxator, esq 2
3845593 1972165 1972165 defendant Heth Henry yeoman 612325 612325 Heth, Henry, of Uttoxator, yeoman 1
3845594 1972165 1972165 defendant Tayler Richard yeoman 612325 612325 Tayler, Richard, of Uttoxator, yeoman 2
3845595 1972165 1972165 defendant Starton John yeoman 612325 612325 Starton, John, of Uttoxator, yeoman 3
3879291 1983326 1983326 defendant More William butcher 612325 612325 More, William, of Uttoxator, butcher 1
3896039 1988879 1988879 defendant Deye William shoemaker 612325 612325 Deye, William, of Uttoxator, shoemaker 0
3920701 1997271 1997271 defendant Roodes John yeoman 612325 612325 Roodes, John, of Uttoxator, yeoman 1
3936781 2002631 2002631 defendant Salte Richard capper 612325 612325 Salte, Richard, of Uttoxator, capper 0
3952584 2007974 2007974 defendant Bott John yeoman 612325 612325 Bott, John, of Uttoxator, yeoman 0
3963032 2011668 2011668 defendant Rodderam John butcher 612325 612325 Rodderam, John, of Uttoxator, butcher 0
4026226 2034029 2034029 defendant Starton Richard butcher 612325 612325 Starton, Richard, of Uttoxator, butcher 0
4133483 2072303 2072303 defendant Lynacre Anthony yeoman 612325 612325 Lynacre, Anthony, of Uttoxator, yeoman 0
4144694 2076305 2076305 defendant Salte Richard yeoman 612325 612325 Salte, Richard, of Uttoxator, yeoman 0
4154658 2079723 2079723 defendant Startyn Richard butcher 612325 612325 Startyn, Richard, of Uttoxator, yeoman, butcher 1
4156884 2080486 2080486 defendant Norenton Edward butcher 612325 612325 Norenton, Edward, of Uttoxator, yeoman, butcher 1
4217302 2101548 2101548 defendant Wright John painter 612325 612325 Wright, John, of Uttoxator, painter 0
4217737 2101693 2101693 defendant Greves Edward carpenter 612325 612325 Greves, Edward, of Uttoxator, carpenter 0
4231638 2106567 2106567 defendant Harryson John yeoman 612325 612325 Harryson, John, of Uttoxator, or of Sutton, Derbs, yeoman 0
4269919 2119524 2119524 defendant Moore Humphrey yeoman 612325 612325 Moore, Humphrey, of Uttoxator, yeoman 4
4330626 2140536 2140536 defendant Rabon William tanner 612325 612325 Rabon, William, of Uttoxator, tanner 0
4332163 2141053 2141053 defendant Scott Henry   612325 612325 Scott, Henry, of Uttoxator, shoemaker, administrators of 0
4332164 2141053 2141053 defendant Abell Edward husbandman 612325 612325 (Abell, Edward, of Uttoxator, 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);