names

13 rows where case_id = 1987713

✎ 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
3892407 1987713 1987713 plaintiff Morgan John Philip     Morgan, John Philip 0
3892408 1987713 1987713 defendant ap Jenn Philip ap Howell yeoman 646692 646692 ap Jenn, Philip ap Howell, of Llandewey, yeoman 0
3892409 1987713 1987713 defendant ap John William Lewys yeoman 646692 646692 ap John, William Lewys, of Llandewey, yeoman 1
3892410 1987713 1987713 defendant Jenkun David ap John yeoman 646693 646693 Jenkun, David ap John, of Llanarthe, yeoman 2
3892411 1987713 1987713 defendant ap Jenkyn Thomas yeoman 646694 646694 ap Jenkyn, Thomas, of Llansey, yeoman 3
3892412 1987713 1987713 defendant ap Howell Thomas Lluwellan yeoman 646695 646695 ap Howell, Thomas Lluwellan, of Llangeby, yeoman 4
3892413 1987713 1987713 defendant Ress William yeoman 646696 646696 Ress, William, of Treygarn, yeoman 5
3892414 1987713 1987713 defendant ap Price Howell ap John yeoman 646697 646697 ap Price, Howell ap John, of Llanthangell, yeoman 6
3892415 1987713 1987713 defendant Bedin William David yeoman 646698 646698 Bedin, William David, of Llangatte, yeoman 7
3892416 1987713 1987713 defendant Pavell William yeoman 646699 646699 Pavell, William, of EnglissheStewton, yeoman 8
3892417 1987713 1987713 defendant Sawyer William yeoman 646700 646700 Sawyer, William, of Karwent, yeoman 9
3892418 1987713 1987713 defendant ap Philip thomas ap Keyney clerk 646701 646701 ap Philip, thomas ap Keyney, of Llanvapley, clerk 10
3892419 1987713 1987713 defendant Watkyn Jenkyn   646702 646702 Watkyn, Jenkyn, of Aburgeyveny, et al 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);