names

9 rows where place_id = 685931

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4064609 2047625 2047625 plaintiff Gyrdler John gent 685931 685931 Gyrdler, John, of Clacke, gent 0
4125846 2069529 2069529 defendant Persivall Nicholas weaver 685931 685931 Persivall, Nicholas, of Clacke, weaver 0
4149046 2077787 2077787 defendant Persivall Nicholas weaver 685931 685931 Persivall, Nicholas, of Clacke, weaver 0
4149048 2077788 2077788 defendant Persivall Nicholas weaver 685931 685931 Persivall, Nicholas, of Clacke, weaver 0
4177909 2087747 2087747 defendant Archer Henry clothier 685931 685931 Archer, Henry, of Clacke, clothier 0
4634992 2241791 2241791 defendant Hoper William   685931 685931 Hoper, William, of Clacke 2
4701309 2265808 2265808 plaintiff Fysshere William   685931 685931 Fysshere, William, of Clacke 0
5002621 2357680 2357680 defendant Mylle Robert husbandman 685931 685931 Mylle, Robert, of Clacke, husbandman 0
5002622 2357680 2357680 defendant Blakeman John butcher 685931 685931 Blakeman, John, of Clacke, butcher 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);