names

17 rows where case_id = 1987714

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3892420 1987714 1987714 plaintiff Morgan John Philip     Morgan, John Philip 0
3892421 1987714 1987714 defendant ap Morgan Jenn yeoman 646703 646703 ap Morgan, Jenn, of Llanware, yeoman 0
3892422 1987714 1987714 defendant Hoskyn Yereth yeoman 646704 646704 Hoskyn, Yereth, of Caldycott, yeoman 1
3892423 1987714 1987714 defendant Burley James clerk 646705 646705 Burley, James, of Dyxton, clerk 2
3892424 1987714 1987714 defendant Watte John fisher 594816 594816 Watte, John, of Monmouth, fisher 3
3892425 1987714 1987714 defendant Davys Richard fusher 594816 594816 Davys, Richard, of Monmouth, fusher 4
3892426 1987714 1987714 defendant Thomas William yeoman 646706 646706 Thomas, William, of Penkoyde, yeoman 5
3892427 1987714 1987714 defendant Madock William David yeoman 646707 646707 Madock, William David, of Aburgeneyveny, yeoman 6
3892428 1987714 1987714 defendant ap Madock Watkyn Thomas yeoman 646708 646708 ap Madock, Watkyn Thomas, of Aburgeveney, yeoman 7
3892429 1987714 1987714 defendant Madock Edward David   646708 646708 Madock, Edward David, of Aburgeveney 8
3892430 1987714 1987714 defendant ap Parry Howell David yeoman 646708 646708 ap Parry, Howell David, of Aburgeveney, yeoman 9
3892431 1987714 1987714 defendant Vachan David Powell yeoman 646709 646709 Vachan, David Powell, of Lanyhangell, yeoman 10
3892432 1987714 1987714 defendant ap David Howell yeoman 646710 646710 ap David, Howell, of Lanyangell, yeoman 11
3892433 1987714 1987714 defendant ap Price Rawlyng     ap Price, Rawlyng 12
3892434 1987714 1987714 defendant Williams Thomas     Williams, Thomas 13
3892435 1987714 1987714 defendant Jeny Richard     Jeny, Richard 14
3892436 1987714 1987714 defendant ap Jeny David     ap Jeny, David 15

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