names

18 rows where case_id = 2379716

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5077314 2379716 2379716 plaintiff Birton Elias     Birton, Elias 0
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
5077318 2379716 2379716 defendant Shawe Thomas   843680 843680 Shawe, Thomas, of Hodresfeld, scholar 3
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
5077324 2379716 2379716 defendant Broke William son of Broke, Richard, of Hodresfeld, yeoman   Broke, William, son of Broke, Richard, of Hodresfeld, yeoman 9
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
5077328 2379716 2379716 defendant Crosland Richard yeoman 597132 597132 Crosland, Richard, of Crosland, yeoman 13
5077329 2379716 2379716 defendant Lokwode John yeoman 597347 597347 Lokwode, John, of Lokwode, yeoman 14
5077330 2379716 2379716 defendant Hanson Thomas husbandman 597347 597347 Hanson, Thomas, of Lokwode, husbandman 15
5077331 2379716 2379716 defendant Fyrth Thomas yeoman 597347 597347 Fyrth, Thomas, of Lokwode, yeoman 16

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