names

15 rows where place_id = 778935

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4657698 2248294 2248294 defendant Hay Richard fisher 778935 778935 Hay, Richard, of Boreford, Oxon, fisher 1
4669128 2256052 2256052 defendant Eydere Edmund dyer 778935 778935 Eydere, Edmund, of Boreford, Oxon, dyer 0
4712033 2269074 2269074 defendant Hulle John gent 778935 778935 (Hulle, John, of Boreford, Oxon, gent 1
4712034 2269074 2269074 defendant Pomoter John chapman 778935 778935 Pomoter, John, of Boreford, Oxon, chapman 2
4722631 2272393 2272393 defendant Derham Robert husbandman 778935 778935 Derham, Robert, of Boreford, Oxon, husbandman 1
4723505 2272660 2272660 plaintiff Derham Robert chapman 778935 778935 Derham, Robert, of Boreford, Oxon, chapman 0
4734568 2275976 2275976 defendant Hulle John gent 778935 778935 Hulle, John, of Boreford, Oxon, gent 0
4734569 2275976 2275976 defendant Punte John chapman 778935 778935 Punte, John, of Boreford, Oxon, chapman 1
4778079 2289131 2289131 defendant Punter John chapman 778935 778935 (Punter, John, of Boreford, Oxon, chapman 2
4896146 2325451 2325451 defendant Punter John, senior husbandman 778935 778935 Punter, John, senior, of Boreford, Oxon, husbandman 0
4901726 2327145 2327145 defendant Punter John husbandman 778935 778935 Punter, John, of Boreford, Oxon, husbandman 0
4923482 2333777 2333777 plaintiff Maylard William   778935 778935 Maylard, William, of Boreford, Oxon, mason 0
4995805 2355591 2355591 defendant Lavyngton Richard   778935 778935 Lavyngton, Richard, of Boreford, Oxon, wool man 0
5104021 2387601 2387601 defendant Smyth Richard yeoman 778935 778935 Smyth, Richard, of Boreford, Oxon, yeoman 0
5626419 2552233 2552233 defendant Howes Isabel   778935 778935 Howes, Isabel, of Boreford, Oxon, "dey" 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);