names

18 rows where place_id = 718864

✎ 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
4226964 2104905 2104905 defendant Dyer alias Lawrence Richard dyer 718864 718864 Dyer alias Lawrence, Richard, of Stowey, dyer 0
4321109 2137476 2137476 defendant Dier Thomas clothier 718864 718864 Dier, Thomas, of Stowey, clothier 1
4367824 2153543 2153543 defendant Caple Hugh potter 718864 718864 Caple, Hugh, of Stowey, potter 1
4399277 2164342 2164342 defendant Reade Lancelot husbandman 718864 718864 Reade, Lancelot, of Stowey, husbandman 1
4495733 2199349 2199349 plaintiff Chapel William   718864 718864 Chapel, William, of Stowey 0
4615814 2235941 2235941 defendant Daungervyle John   718864 718864 Daungervyle, John, of Stowey 0
4615817 2235942 2235942 defendant Daungervyle John   718864 718864 Daungervyle, John, of Stowey 0
4692737 2263239 2263239 defendant Hukker John laborer 718864 718864 Hukker, John, of Stowey, laborer 2
4748423 2280044 2280044 defendant Hunt John husbandman 718864 718864 Hunt, John, of Stowey, husbandman 1
4789041 2292626 2292626 defendant Candell John gent 718864 718864 Candell, John, of Stowey, gent 1
4832773 2306274 2306274 defendant Dole Robert husbandman 718864 718864 Dole, Robert, of Stowey, husbandman 0
4888031 2323060 2323060 defendant Hosyer Robert hosier 718864 718864 Hosyer, Robert, of Stowey, hosier 2
4959571 2344821 2344821 defendant Laurence John dyer 718864 718864 Laurence, John, of Stowey, dyer 0
4986178 2352791 2352791 defendant Laurence John dyer 718864 718864 Laurence, John, of Stowey, dyer 0
5159401 2403867 2403867 defendant fitz Richard john gent 718864 718864 fitz Richard, john, of Stowey, gent 0
5500247 2505023 2505023 defendant Moris William clerk 718864 718864 Moris, William, of Stowey, clerk 1
5515045 2509550 2509550 defendant Hethe John husbandman 718864 718864 Hethe, John, of Stowey, husbandman 0
5543852 2518187 2518187 defendant Andrewes Henry tucker 718864 718864 Andrewes, Henry, of Stowey, tucker 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);