names

12 rows where place_id = 843679

✎ 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
5077315 2379716 2379716 defendant Marshall William smith 843679 843679 Marshall, William, of Hodresfeld, smith 0
5077316 2379716 2379716 defendant Hermytage Thomas husbandman 843679 843679 Hermytage, Thomas, of Hodresfeld, husbandman 1
5077317 2379716 2379716 defendant Blakburn William husbandman 843679 843679 Blakburn, William, of Hodresfeld, husbandman 2
5077319 2379716 2379716 defendant Horsfall Richard yeoman 843679 843679 Horsfall, Richard, of Hodresfeld, yeoman 4
5077320 2379716 2379716 defendant Broke Edmund yeoman 843679 843679 Broke, Edmund, of Hodresfeld, yeoman 5
5077321 2379716 2379716 defendant Boderode John yeoman 843679 843679 Boderode, John, of Hodresfeld, yeoman 6
5077322 2379716 2379716 defendant Woderode William husbandman 843679 843679 Woderode, William, of Hodresfeld, husbandman 7
5077323 2379716 2379716 defendant Boderode Richard yeoman 843679 843679 Boderode, Richard, of Hodresfeld, yeoman 8
5077325 2379716 2379716 defendant France John yeoman 843679 843679 France, John, of Hodresfeld, yeoman 10
5077326 2379716 2379716 defendant Shawe Thomas smith 843679 843679 Shawe, Thomas, of Hodresfeld, smith 11
5077327 2379716 2379716 defendant Hanson Richard weaver 843679 843679 Hanson, Richard, of Hodresfeld, weaver 12
5250677 2430321 2430321 defendant Thurgurland Richard yeoman 843679 843679 Thurgurland, Richard, of Hodresfeld, 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);