names

17 rows where case_id = 1908642

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3644290 1908642 1908642 plaintiff Ernele John     Ernele, John 0
3644291 1908642 1908642 defendant Horton Robert gent 601197 601197 Horton, Robert, of Staunton, Worcs, gent 0
3644292 1908642 1908642 defendant Whitington Robert gent 601198 601198 Whitington, Robert, of Pauntley, gent 1
3644293 1908642 1908642 defendant Wodley Humphrey yeoman 601199 601199 Wodley, Humphrey, of Rydmerley, Worcs, yeoman 2
3644294 1908642 1908642 defendant Cokkes Richard yeoman 601198 601198 Cokkes, Richard, of Pauntley, yeoman 3
3644295 1908642 1908642 defendant Pulton Roger yeoman 601198 601198 Pulton, Roger, of Pauntley, yeoman 4
3644296 1908642 1908642 defendant Phippes William yeoman 593513 593513 Phippes, William, of Staunton, yeoman 5
3644297 1908642 1908642 defendant Reynold John yeoman 593513 593513 Reynold, John, of Staunton, yeoman 6
3644298 1908642 1908642 defendant Zelye William yeoman 593513 593513 Zelye, William, of Staunton, yeoman 7
3644299 1908642 1908642 defendant Dekyns Thomas yeoman 601200 601200 Dekyns, Thomas, of Cors, yeoman 8
3644300 1908642 1908642 defendant Brayne Geoffrey yeoman 601200 601200 Brayne, Geoffrey, of Cors, yeoman 9
3644301 1908642 1908642 defendant A Rodge John laborer 601200 601200 A Rodge, John, of Cors, laborer 10
3644302 1908642 1908642 defendant Saunders Thomas yeoman 591041 591041 Saunders, Thomas, of Hanley, Worcs, yeoman 11
3644303 1908642 1908642 defendant Smyth Thomas yeoman 593245 593245 Smyth, Thomas, of Hanley, yeoman 12
3644304 1908642 1908642 defendant Monmouth William tailor 601198 601198 Monmouth, William, of Pauntley, tailor 13
3644305 1908642 1908642 defendant Tyler Thomas husbandman 601201 601201 Tyler, Thomas, of Trymley, husbandman 14
3644306 1908642 1908642 defendant Marden Thomas yeoman 601202 601202 Marden, Thomas, of Trylley, yeoman 15

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