names

15 rows where place_id = 764707

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4508704 2203205 2203205 defendant Barker John   764707 764707 Barker, John, of Hokenall 0
4508707 2203205 2203205 defendant Wryght Richard   764707 764707 Wryght, Richard, of Hokenall 3
4508708 2203205 2203205 defendant Carter Richard   764707 764707 Carter, Richard, of Hokenall 4
4508713 2203205 2203205 defendant Taillour Nicholas   764707 764707 Taillour, Nicholas, of Hokenall 9
4508714 2203205 2203205 defendant Mason John   764707 764707 Mason, John, of Hokenall 10
4508715 2203205 2203205 defendant Walker John   764707 764707 Walker, John, of Hokenall 11
4508724 2203205 2203205 defendant Taillour John   764707 764707 Taillour, John, of Hokenall 20
4508725 2203205 2203205 defendant Smyth John   764707 764707 Smyth, John, of Hokenall 21
4508731 2203205 2203205 defendant Fauconberd Robert   764707 764707 Fauconberd, Robert, of Hokenall 27
5248387 2429661 2429661 defendant Spycer John yeoman 764707 764707 Spycer, John, of Hokenall, yeoman 0
5248388 2429661 2429661 defendant Skalgresse Richard yeoman 764707 764707 Skalgresse, Richard, of Hokenall, yeoman 1
5248389 2429661 2429661 defendant Gemme John, senior husbandman 764707 764707 Gemme, John, senior, of Hokenall, husbandman 2
5248390 2429661 2429661 defendant Gemme John, junior husbandman 764707 764707 Gemme, John, junior, of Hokenall, husbandman 3
5248391 2429661 2429661 defendant Lytill Robert yeoman 764707 764707 Lytill, Robert, of Hokenall, yeoman 4
5626720 2552331 2552331 defendant Porter Thomas yeoman 764707 764707 Porter, Thomas, of Hokenall, yeoman 0

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