names

14 rows where case_id = 2039781

✎ 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
4042448 2039781 2039781 plaintiff Parry John gent, attorney of the bench   Parry, John, gent, attorney of the bench 0
4042449 2039781 2039781 defendant Jenkyn Robert yeoman 680852 680852 Jenkyn, Robert, of Llangattock juxta Clychoell, Brecon, yeoman 0
4042450 2039781 2039781 defendant Vaughan Gladis widow 680853 680853 Vaughan, Gladis, of Tretowre, Brcon, widow 1
4042451 2039781 2039781 defendant vergh Rychard Jenetta widow 658617 658617 vergh Rychard, Jenetta, of Llangeney, Brecon, widow 2
4042452 2039781 2039781 defendant Walbyff John esq 680854 680854 Walbyff, John, of Llanhamalghe, Brecon, esq 3
4042453 2039781 2039781 defendant Myle Jevan John yeoman 647570 647570 Myle, Jevan John, of Haye, Brecon, yeoman 4
4042454 2039781 2039781 defendant ap Rosser Walter yeoman 680855 680855 ap Rosser, Walter, of Llansertyn, Monmouth, yeoman 5
4042455 2039781 2039781 defendant ap William William yeoman 680856 680856 ap William, William, of St John Evangelist, Brecon, yeoman 6
4042456 2039781 2039781 defendant Gytto James yeoman 601480 601480 Gytto, James, of Peterchurche, yeoman 7
4042457 2039781 2039781 defendant Geybon Thomas yeoman 592031 592031 Geybon, Thomas, of Madley, yeoman 8
4042458 2039781 2039781 defendant Roo Richard yeoman 646648 646648 Roo, Richard, of Clyfford, yeoman 9
4042459 2039781 2039781 defendant Walker John fishmonger 586208 586208 Walker, John, of Hereford, fishmonger 10
4042460 2039781 2039781 defendant Leyd Hugh yeoman 657435 657435 Leyd, Hugh, of Presteyne, Radnor, yeoman 11
4042461 2039781 2039781 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);