names

12 rows where place_id = 658973

✎ 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
3950564 2007274 2007274 defendant Hunt Eleanor widow 658973 658973 Hunt, Eleanor, of Snodell, widow 13
3950582 2007275 2007275 defendant Hunt Eleanor widow 658973 658973 Hunt, Eleanor, of Snodell, widow 13
4080630 2053386 2053386 defendant ap Rees William tailor 658973 658973 ap Rees, William, of Snodell, tailor 0
4116768 2066296 2066296 defendant Byrde John tanner 658973 658973 Byrde, John, of Snodell, tanner 0
4116769 2066296 2066296 defendant Hoell John John laborer 658973 658973 Hoell, John John, of Snodell, laborer 1
4164561 2083114 2083114 defendant Ewyn Philip yeoman 658973 658973 Ewyn, Philip, of Snodell, yeoman 2
4214389 2100539 2100539 defendant Thomas Howell laborer 658973 658973 Thomas, Howell, of Snodell, laborer 1
4214390 2100539 2100539 defendant Rees Maud widow 658973 658973 Rees, Maud, of Snodell, widow 2
4217476 2101605 2101605 defendant Edmond Watkin laborer 658973 658973 Edmond, Watkin, of Snodell, laborer 3
4226665 2104799 2104799 defendant Edmond Watkin laborer 658973 658973 Edmond, Watkin, of Snodell, laborer 3
4312476 2134500 2134500 defendant Greene John tanner 658973 658973 Greene, John, of Snodell, tanner 0
4319172 2136819 2136819 defendant Jenkyn William weaver 658973 658973 Jenkyn, William, of Snodell, 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);