names

14 rows where case_id = 2039782

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4042462 2039782 2039782 plaintiff Parry John gent, attorney of the bench   Parry, John, gent, attorney of the bench 0
4042463 2039782 2039782 defendant Jenkyn Thomas yeoman 680857 680857 Jenkyn, Thomas, of Langattock juxta Crickhowell, Brecon, yeoman 0
4042464 2039782 2039782 defendant Vaughan Gladis widow 680858 680858 Vaughan, Gladis, of Tretowre, Brecon, widow 1
4042465 2039782 2039782 defendant verch Rychard Jeneta, of Llangeney, Brecon, widow   verch, Rychard, Jeneta, of Llangeney, Brecon, widow 2
4042466 2039782 2039782 defendant Walbyf John esq 680859 680859 Walbyf, John, of Llanhamalyhe, Brecon, esq 3
4042467 2039782 2039782 defendant Myle Evan yeoman 647570 647570 Myle, Evan, of Haye, Brecon, yeoman 4
4042468 2039782 2039782 defendant ap Rosser Walter gent 680860 680860 ap Rosser, Walter, of Llanseroin, Monmouth, gent 5
4042469 2039782 2039782 defendant ap William William yeoman 680856 680856 ap William, William, of St John Evangelist, Brecon, yeoman 6
4042470 2039782 2039782 defendant Gytto James yeoman 678650 678650 Gytto, James, of Peterchirche, yeoman 7
4042471 2039782 2039782 defendant Seybon Thomas yeoman 592031 592031 Seybon, Thomas, of Madley, yeoman 8
4042472 2039782 2039782 defendant Roo Richard yeoman 646648 646648 Roo, Richard, of Clyfford, yeoman 9
4042473 2039782 2039782 defendant Walker John fishmonger 586208 586208 Walker, John, of Hereford, fishmonger 10
4042474 2039782 2039782 defendant Leyd Hugh yeoman 680861 680861 Leyd, Hugh, of Presteme, Radnor, yeoman 11
4042475 2039782 2039782 defendant Hall John butcher 588373 588373 Hall, John, of Rosse, butcher 12

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