names

13 rows where case_id = 2039784

✎ 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
4042489 2039784 2039784 plaintiff Parry John   688015 688015 Parry, John, of Dules, gent, attorney of the bench 0
4042490 2039784 2039784 defendant ap Gwatkyn Howell gent 680867 680867 ap Gwatkyn, Howell, of Pendydyll, Monmouth, gent 0
4042491 2039784 2039784 defendant William Watkin John yeoman 680868 680868 William, Watkin John, of Pendydyll, yeoman 1
4042492 2039784 2039784 defendant Blunte John gent 629099 629099 Blunte, John, of Byrche Morton, Worcs, gent 2
4042493 2039784 2039784 defendant ap Ryce Thomas yeoman 663339 663339 ap Ryce, Thomas, of Comyoye, yeoman 3
4042494 2039784 2039784 defendant Powell Adam yeoman 646648 646648 Powell, Adam, of Clyfford, yeoman 4
4042495 2039784 2039784 defendant Ogan Thomas capper 586208 586208 Ogan, Thomas, of Hereford, capper 5
4042496 2039784 2039784 defendant ap Rychard John Watkin tailor 680869 680869 ap Rychard, John Watkin, of Ewtas Harold, tailor 6
4042497 2039784 2039784 defendant ap Harry Lewis ap Rice yeoman 655905 655905 ap Harry, Lewis ap Rice, of Clodock, yeoman 7
4042498 2039784 2039784 defendant Barrowe Richard gent 680865 680865 Barrowe, Richard, of Bullynghope Inferior, gent 8
4042499 2039784 2039784 defendant Whytney Thomas gent 663045 663045 Whytney, Thomas, of Castleton, gent 9
4042500 2039784 2039784 defendant ap Rosser Hugh Thomas yeoman 590541 590541 ap Rosser, Hugh Thomas, of Howton, yeoman 10
4042501 2039784 2039784 defendant Gillam Gwelliana widow 600182 600182 Gillam, Gwelliana, of Dorston, widow 11

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