names

13 rows where place_id = 626927

✎ 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
3773181 1949319 1949319 defendant Elwode John yeoman 626927 626927 Elwode, John, of Sturmyster Newton Castell, yeoman 0
3869963 1980196 1980196 defendant Amars Cuthbert yeoman 626927 626927 Amars, Cuthbert, of Sturmyster Newton Castell, yeoman 0
3894056 1988228 1988228 defendant Pope Thomas husbandman 626927 626927 Pope, Thomas, of Sturmyster Newton Castell, husbandman 0
3910381 1993791 1993791 defendant Webber Robert husbandman 626927 626927 Webber, Robert, of Sturmyster Newton Castell, husbandman 0
3910382 1993791 1993791 defendant Peny John husbandman 626927 626927 Peny, John, of Sturmyster Newton Castell, husbandman 1
3914179 1995086 1995086 defendant Whyffyn Richard yeoman 626927 626927 Whyffyn, Richard, of Sturmyster Newton Castell, yeoman 0
3914184 1995087 1995087 defendant Whyffyn Richard husbandman 626927 626927 Whyffyn, Richard, of Sturmyster Newton Castell, husbandman 0
3917180 1996108 1996108 defendant Constans Stephen husbandman 626927 626927 Constans, Stephen, of Sturmyster Newton Castell, husbandman 0
3978696 2017125 2017125 defendant Keynell Thomas husbandman 626927 626927 Keynell, Thomas, of Sturmyster Newton Castell, husbandman 0
4069853 2049502 2049502 defendant Belvyn George shoemaker 626927 626927 Belvyn, George, of Sturmyster Newton Castell, shoemaker 0
4069855 2049503 2049503 defendant Lambert Jerome yeoman 626927 626927 Lambert, Jerome, of Sturmyster Newton Castell, yeoman 0
4090059 2056729 2056729 defendant Roden alias Halle William yeoman 626927 626927 Roden alias Halle, William, of Sturmyster Newton Castell, yeoman 0
5499789 2504883 2504883 defendant Pope Walter husbandman 626927 626927 Pope, Walter, of Sturmyster Newton Castell, husbandman 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);