names

19 rows where place_id = 660712

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3935961 2002343 2002343 defendant ap Jeyn Thomas   660712 660712 ap Jeyn, Thomas, of Penhowe, mason 0
3935962 2002343 2002343 defendant ap Morgan Thomas   660712 660712 ap Morgan, Thomas, of Penhowe, mason 1
3957576 2009711 2009711 defendant William Richard yeoman 660712 660712 William, Richard, of Penhowe, yeoman 1
3964175 2012078 2012078 plaintiff ap Richard Henry yeoman 660712 660712 ap Richard, Henry, of Penhowe, yeoman 0
3985321 2019506 2019506 defendant Morgan William Powell yeoman 660712 660712 Morgan, William Powell, of Penhowe, yeoman 1
3985465 2019562 2019562 defendant ap Rychard Walter yeoman 660712 660712 ap Rychard, Walter, of Penhowe, yeoman 4
4004661 2026442 2026442 defendant vergh Morgan Gwenlliana widow 660712 660712 vergh Morgan, Gwenlliana, of Penhowe, widow 0
4036941 2037887 2037887 defendant Wyllym Howell yeoman 660712 660712 Wyllym, Howell, of Penhowe, yeoman 2
4036942 2037887 2037887 defendant Myryck Roger John David yeoman 660712 660712 Myryck, Roger John David, of Penhowe, yeoman 3
4053476 2043618 2043618 defendant ap Howell Jevan yeoman 660712 660712 ap Howell, Jevan, of Penhowe, yeoman 0
4074301 2051108 2051108 defendant Lluwellen John William yeoman 660712 660712 Lluwellen, John William, of Penhowe, yeoman 1
4099970 2060315 2060315 defendant Jones Morgan clerk 660712 660712 Jones, Morgan, of Penhowe, clerk 1
4100014 2060333 2060333 defendant Robert David gent 660712 660712 Robert, David, of Penhowe, gent 0
4109467 2063648 2063648 defendant Rychard Henry yeoman 660712 660712 Rychard, Henry, of Penhowe, yeoman 0
4140249 2074756 2074756 defendant Wylliam Howell yeoman 660712 660712 Wylliam, Howell, of Penhowe, yeoman 1
4152131 2078858 2078858 defendant Lluwellen John William yeoman 660712 660712 Lluwellen, John William, of Penhowe, yeoman 0
4152132 2078858 2078858 defendant Rychard Walter yeoman 660712 660712 Rychard, Walter, of Penhowe, yeoman 1
4280575 2123111 2123111 defendant Morgan Lewis husbandman 660712 660712 Morgan, Lewis, of Penhowe, husbandman 3
4364986 2152530 2152530 defendant Morgan Lewis yeoman 660712 660712 Morgan, Lewis, of Penhowe, yeoman 3

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