names

13 rows where case_id = 2039783

✎ 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
4042476 2039783 2039783 plaintiff Parry John   679456 679456 Parry, John, of Dulas, gent, attorney of the bench 0
4042477 2039783 2039783 defendant ap Gwatkyn Howell gent 680863 680863 ap Gwatkyn, Howell, of Penvydyll, Monmouth, gent 0
4042478 2039783 2039783 defendant William Watkin John yeoman 680864 680864 William, Watkin John, of Penvydyll, yeoman 1
4042479 2039783 2039783 defendant Blunte John gent 629099 629099 Blunte, John, of Byrche Morton, Worcs, gent 2
4042480 2039783 2039783 defendant ap Ryce Thomas yeoman 663339 663339 ap Ryce, Thomas, of Comyoye, yeoman 3
4042481 2039783 2039783 defendant Powell Adam yeoman 646648 646648 Powell, Adam, of Clyfford, yeoman 4
4042482 2039783 2039783 defendant Ogan Thomas capper 586208 586208 Ogan, Thomas, of Hereford, capper 5
4042483 2039783 2039783 defendant ap Rychard John Watkyn tailor 649903 649903 ap Rychard, John Watkyn, of Ewias Harold, tailor 6
4042484 2039783 2039783 defendant ap Harry Lewis ap Rees yeoman 655905 655905 ap Harry, Lewis ap Rees, of Clodock, yeoman 7
4042485 2039783 2039783 defendant Barrowe Richard gent 680865 680865 Barrowe, Richard, of Bullynghope Inferior, gent 8
4042486 2039783 2039783 defendant Whytney Thomas gent 663045 663045 Whytney, Thomas, of Castleton, gent 9
4042487 2039783 2039783 defendant ap Rosser Hugh yeoman 590541 590541 ap Rosser, Hugh, of Howton, yeoman 10
4042488 2039783 2039783 defendant Gillam Gwenlliana widow 600182 600182 Gillam, Gwenlliana, 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);