names

9 rows where place_id = 662555

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3965387 2012510 2012510 defendant Hallydaye Richard saddler 662555 662555 Hallydaye, Richard, of Downham Markett, Norf, saddler 0
3983129 2018739 2018739 defendant Illarye Robert yeoman 662555 662555 Illarye, Robert, of Downham Markett, Norf, yeoman 0
4000958 2025113 2025113 defendant Style James yeoman 662555 662555 Style, James, of Downham Markett, Norf, yeoman 0
4043305 2040073 2040073 plaintiff Plantrose John (legal representative) 662555 662555 Plantrose, John, of Downham Markett, Norf, husbandman, executors of 0
4243223 2110725 2110725 defendant Style Richard, senior yeoman 662555 662555 Style, Richard, senior, of Downham Markett, Norf, yeoman 0
4248408 2112457 2112457 defendant Weston David saddler 662555 662555 Weston, David, of Downham Markett, Norf, saddler 2
4266744 2118518 2118518 defendant Style Richard, senior yeoman 662555 662555 Style, Richard, senior, of Downham Markett, Norf, yeoman 0
4274027 2120859 2120859 defendant Stile Richard yeoman 662555 662555 Stile, Richard, of Downham Markett, Norf, yeoman 0
4305112 2131928 2131928 defendant Jenner William clothier 662555 662555 Jenner, William, of Downham Markett, Norf, clothier 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);