names

9 rows where place_id = 789694

✎ 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
4714663 2269917 2269917 defendant Edward John husbandman 789694 789694 Edward, John, of Menke, husbandman 4
4737048 2276717 2276717 defendant Menke Nicholas husbandman 789694 789694 Menke, Nicholas, of Menke, husbandman 3
4737049 2276717 2276717 defendant Menke Richard   789694 789694 Menke, Richard, of Menke, groom 4
4737051 2276717 2276717 defendant Mende Drew   789694 789694 Mende, Drew, of Menke, tin worker 6
4737068 2276720 2276720 defendant Menk Nicholas husbandman 789694 789694 Menk, Nicholas, of Menke, husbandman 9
4737069 2276720 2276720 defendant Menke Richard   789694 789694 Menke, Richard, of Menke, groom 10
4737071 2276720 2276720 defendant Menke Drew tinner 789694 789694 Menke, Drew, of Menke, tinner 12
4737084 2276722 2276722 defendant Menke Nicholas husbandman 789694 789694 Menke, Nicholas, of Menke, husbandman 6
4737085 2276722 2276722 defendant Menke Richard   789694 789694 Menke, Richard, of Menke, groom 7

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