names

40 rows where place_id = 629275

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3787300 1953820 1953820 defendant Bryan John, junior husbandman 629275 629275 Bryan, John, junior, of Newchurche, husbandman 1
3896158 1988918 1988918 defendant Madok Robert husbandman 629275 629275 Madok, Robert, of Newchurche, husbandman 4
3902167 1990960 1990960 plaintiff Donett William   629275 629275 Donett, William, of Newchurche 0
3955894 2009130 2009130 defendant Morys William Lewis yeoman 629275 629275 Morys, William Lewis, of Newchurche, yeoman 3
3957572 2009710 2009710 defendant Moris William Lewis yeoman 629275 629275 Moris, William Lewis, of Newchurche, yeoman 3
3970328 2014218 2014218 defendant ap Howell Stephen John gent 629275 629275 ap Howell, Stephen John, of Newchurche, gent 0
3970330 2014219 2014219 defendant ap Howell Stephen John gent 629275 629275 ap Howell, Stephen John, of Newchurche, gent 0
3982016 2018328 2018328 defendant ap John Stephen yeoman 629275 629275 ap John, Stephen, of Newchurche, yeoman 1
4001493 2025313 2025313 defendant Steaven Morgan yeoman 629275 629275 Steaven, Morgan, of Newchurche, yeoman 2
4001494 2025313 2025313 defendant Llewellen Philip William yeoman 629275 629275 Llewellen, Philip William, of Newchurche, yeoman 3
4002462 2025650 2025650 defendant ap Powell Stephen John husbandman 629275 629275 ap Powell, Stephen John, of Newchurche, husbandman 0
4002463 2025650 2025650 defendant David William laborer 629275 629275 David William, of Newchurche, laborer 1
4002477 2025653 2025653 defendant Steven Morgan yeoman 629275 629275 Steven, Morgan, of Newchurche, yeoman 2
4002478 2025653 2025653 defendant Lluwellen Philip William yeoman 629275 629275 Lluwellen, Philip William, of Newchurche, yeoman 3
4011851 2028971 2028971 defendant ap Howell Stephen John yeoman 629275 629275 ap Howell, Stephen John, of Newchurche, yeoman 1
4011856 2028972 2028972 defendant Apowell Stephen John yeoman 629275 629275 Apowell, Stephen John, of Newchurche, yeoman 1
4015733 2030320 2030320 defendant Stephyn Morgan yeoman 629275 629275 Stephyn, Morgan, of Newchurche, yeoman 0
4015734 2030320 2030320 defendant William Philip yeoman 629275 629275 William, Philip, of Newchurche, yeoman 1
4015735 2030320 2030320 defendant William David yeoman 629275 629275 William, David, of Newchurche, yeoman 2
4015765 2030326 2030326 defendant Stephyn Morgan yeoman 629275 629275 Stephyn, Morgan, of Newchurche, yeoman 0
4015766 2030326 2030326 defendant William Philip yeoman 629275 629275 William, Philip, of Newchurche, yeoman 1
4015767 2030326 2030326 defendant William David yeoman 629275 629275 William, David, of Newchurche, yeoman 2
4035087 2037229 2037229 defendant Apowell Philip John yeoman 629275 629275 Apowell, Philip John, of Newchurche, yeoman 1
4083052 2054233 2054233 defendant David Philip yeoman 629275 629275 David, Philip, of Newchurche, yeoman 0
4097119 2059292 2059292 defendant Taylor Lewis Thomas husbandman 629275 629275 Taylor, Lewis Thomas, of Newchurche, husbandman 0
4110357 2063964 2063964 defendant Stevyn Morgan yeoman 629275 629275 Stevyn, Morgan, of Newchurche, yeoman 0
4128211 2070374 2070374 defendant Steven John yeoman 629275 629275 Steven, John, of Newchurche, yeoman 3
4140255 2074758 2074758 defendant Taylor Lewis Thomas yeoman 629275 629275 Taylor, Lewis Thomas, of Newchurche, yeoman 0
4142406 2075516 2075516 defendant Rychard John laborer 629275 629275 Rychard, John, of Newchurche, laborer 0
4159028 2081225 2081225 defendant Thomas David John yeoman 629275 629275 Thomas, David John, of Newchurche, yeoman 3
4203519 2096781 2096781 defendant Taylor Lewis Thomas yeoman 629275 629275 Taylor, Lewis Thomas, of Newchurche, yeoman 2
4203520 2096781 2096781 defendant Herbert Thomas yeoman or gent 629275 629275 Herbert, Thomas, of Newchurche, yeoman or gent 3
4222538 2103375 2103375 defendant Herbert Henry gent 629275 629275 Herbert, Henry, of Newchurche, gent 0
4222580 2103392 2103392 defendant William David yeoman 629275 629275 William, David, of Newchurche, yeoman 0
4278864 2122543 2122543 defendant Lewys Edward William yeoman 629275 629275 Lewys, Edward William, of Newchurche, yeoman 0
4278945 2122570 2122570 defendant Hughes John William yeoman 629275 629275 Hughes, John William, of Newchurche, yeoman 1
4373068 2155435 2155435 defendant Thomas alias Rosser Alice widow 629275 629275 Thomas alias Rosser, Alice, of Newchurche, widow 0
4373069 2155435 2155435 defendant William Roger yeoman 629275 629275 William, Roger, of Newchurche, yeoman 1
4375383 2156251 2156251 defendant Hopkyn James David husbandman 629275 629275 Hopkyn, James David, of Newchurche, husbandman 0
4375616 2156337 2156337 defendant William David yeoman 629275 629275 William, David, of Newchurche, yeoman 0

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