names

26 rows where place_id = 666405

✎ 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
3980899 2017930 2017930 plaintiff Powell or ap Hoell Walter gent 666405 666405 Powell or ap Hoell, Walter, of Llantrissen, gent 0
4001729 2025394 2025394 defendant Gryffyth Walter William yeoman 666405 666405 Gryffyth, Walter William, of Llantrissen, yeoman 1
4001732 2025395 2025395 defendant Gryffyth Walter William yeoman 666405 666405 Gryffyth, Walter William, of Llantrissen, yeoman 1
4001735 2025396 2025396 defendant Gryffyth Walter William yeoman 666405 666405 Gryffyth, Walter William, of Llantrissen, yeoman 1
4066543 2048328 2048328 defendant Rosser Thomas yeoman 666405 666405 Rosser, Thomas, of Llantrissen, yeoman 1
4199423 2095346 2095346 defendant John Howell yeoman 666405 666405 John, Howell, of Llantrissen, yeoman 0
4204666 2097180 2097180 defendant John Edward yeoman 666405 666405 John, Edward, of Llantrissen, yeoman 1
4217152 2101493 2101493 defendant David Llewellyn yeoman 666405 666405 David, Llewellyn, of Llantrissen, yeoman 0
4217154 2101493 2101493 defendant Edward Lewis (legal representative) 666405 666405 Edward, Lewis, of Llantrissen, yeoman, administratrix of 2
4217155 2101493 2101493 defendant William Maud widow 666405 666405 William, Maud, of Llantrissen, widow 3
4219020 2102148 2102148 defendant Miricke Roger John yeoman 666405 666405 Miricke, Roger John, of Llantrissen, yeoman 0
4219021 2102148 2102148 defendant Rinold John yeoman 666405 666405 Rinold, John, of Llantrissen, yeoman 1
4220410 2102642 2102642 defendant William John Thomas yeoman 666405 666405 William, John Thomas, of Llantrissen, yeoman 2
4220411 2102642 2102642 defendant ap Powell Thomas yeoman 666405 666405 ap Powell, Thomas, of Llantrissen, yeoman 3
4277495 2122051 2122051 defendant Mirick Roger John yeoman 666405 666405 Mirick, Roger John, of Llantrissen, yeoman 0
4277496 2122051 2122051 defendant Thomas John yeoman 666405 666405 Thomas, John, of Llantrissen, yeoman 1
4277497 2122051 2122051 defendant John Howell Reignold yeoman 666405 666405 John, Howell Reignold, of Llantrissen, yeoman 2
4279964 2122904 2122904 defendant Thomas Reginald yeoman 666405 666405 together with Thomas, Reginald, of Llantrissen, yeoman 1
4279975 2122908 2122908 defendant Howell Lewis yeoman 666405 666405 Howell, Lewis, of Llantrissen, yeoman 0
4279976 2122908 2122908 defendant Howell Reginald yeoman 666405 666405 Howell, Reginald, of Llantrissen, yeoman 1
4282850 2123900 2123900 defendant Rynold John yeoman 666405 666405 Rynold, John, of Llantrissen, yeoman 0
4372999 2155412 2155412 defendant William Walter yeoman 666405 666405 William, Walter, of Llantrissen, yeoman 1
4375981 2156474 2156474 defendant Thomas William yeoman 666405 666405 Thomas, William, of Llantrissen, yeoman 0
4376104 2156516 2156516 defendant Rinald John yeoman 666405 666405 Rinald, John, of Llantrissen, yeoman 0
4380594 2158168 2158168 defendant Reynold Howell gent 666405 666405 Reynold, Howell, of Llantrissen, gent 0
4380598 2158169 2158169 defendant John Philip yeoman 666405 666405 John, Philip, of Llantrissen, yeoman 1

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