names

10 rows where place_id = 865929

✎ 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
5265192 2434872 2434872 defendant Gladwyn John husbandman 865929 865929 Gladwyn, John, of Freron Barnet, husbandman 7
5265193 2434872 2434872 defendant Gladwyn Richard laborer 865929 865929 Gladwyn, Richard, of Freron Barnet, laborer 8
5265194 2434872 2434872 defendant Petyr John collier 865929 865929 Petyr, John, of Freron Barnet, collier 9
5265195 2434872 2434872 defendant Dogget Richard laborer 865929 865929 Dogget, Richard, of Freron Barnet, laborer 10
5265196 2434872 2434872 defendant Prat John yeoman 865929 865929 Prat, John, of Freron Barnet, yeoman 11
5265316 2434908 2434908 defendant Gladwyn John husbandman 865929 865929 Gladwyn, John, of Freron Barnet, husbandman 5
5265317 2434908 2434908 defendant Gladwyn Richard   865929 865929 Gladwyn, Richard, of Freron Barnet 6
5265318 2434908 2434908 defendant Petyr John collier 865929 865929 Petyr, John, of Freron Barnet, collier 7
5265319 2434908 2434908 defendant Dogget Richard laborer 865929 865929 Dogget, Richard, of Freron Barnet, laborer 8
5265320 2434908 2434908 defendant Prat John yeoman 865929 865929 Prat, John, of Freron Barnet, yeoman 9

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);