names

16 rows where place_id = 617551

✎ 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
3720071 1932551 1932551 defendant Chapman Nicholas yeoman 617551 617551 Chapman, Nicholas, of Howke, yeoman 1
3937663 2002927 2002927 defendant Jakson Charles yeoman 617551 617551 Jakson, Charles, of Howke, yeoman 2
4001148 2025188 2025188 defendant Hodgshon Richard miller 617551 617551 Hodgshon, Richard, of Howke, miller 0
4001150 2025189 2025189 defendant Wren Ralph husbandman 617551 617551 Wren, Ralph, of Howke, husbandman 0
4006049 2026933 2026933 defendant Emson Robert yeoman 617551 617551 Emson, Robert, of Howke, yeoman 1
4093656 2058053 2058053 defendant Dunforde William carpenter 617551 617551 Dunforde, William, of Howke, carpenter 0
4252933 2113976 2113976 defendant Balie William yeoman 617551 617551 Balie, William, of Howke, yeoman 0
4252934 2113976 2113976 defendant Nesse Richard yeoman 617551 617551 Nesse, Richard, of Howke, yeoman 1
4252935 2113976 2113976 defendant Smyth John yeoman 617551 617551 Smyth, John, of Howke, yeoman 2
4320209 2137169 2137169 defendant Cornewell Robert yeoman 617551 617551 Cornewell, Robert, of Howke, yeoman 2
4337443 2142832 2142832 defendant Baly John husbandman 617551 617551 Baly, John, of Howke, husbandman 0
4337444 2142832 2142832 defendant Baly Edward husbandman 617551 617551 Baly, Edward, of Howke, husbandman 1
4337445 2142832 2142832 defendant Baly Jenetta widow 617551 617551 Baly, Jenetta, of Howke, widow 2
4386162 2160052 2160052 defendant Balie John husbandman 617551 617551 Balie, John, of Howke, husbandman 0
4386163 2160052 2160052 defendant Balye Edward husbandman 617551 617551 Balye, Edward, of Howke, husbandman 1
4386164 2160052 2160052 defendant Baly Jenetta widow 617551 617551 Baly, Jenetta, of Howke, widow 2

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