names

86 rows where place_id = 655905

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3938039 2003054 2003054 defendant Gylbert alias Nycoll William gent 655905 655905 Gylbert alias Nycoll, William, of Clodock, gent 0
3956974 2009502 2009502 defendant Philip Margery John widow 655905 655905 Philip, Margery John, of Clodock, widow 0
3964182 2012080 2012080 defendant Harry Griffin yeoman 655905 655905 Harry, Griffin, of Clodock, yeoman 0
3988354 2020582 2020582 defendant Lewys David Gillam yeoman 655905 655905 Lewys, David Gillam, of Clodock, yeoman 0
3999731 2024663 2024663 defendant Lewys Lewis Thomas yeoman 655905 655905 Lewys, Lewis Thomas, of Clodock, yeoman 3
3999986 2024759 2024759 defendant Scudamore Thomas ap Richard husbandman 655905 655905 Scudamore, Thomas ap Richard, of Clodock, husbandman 0
4000988 2025124 2025124 defendant Morgan William yeoman 655905 655905 Morgan, William, of Clodock, yeoman 0
4001007 2025133 2025133 defendant David Morgan yeoman 655905 655905 David, Morgan, of Clodock, yeoman 0
4008701 2027875 2027875 defendant Landon Rice yeoman 655905 655905 Landon, Rice, of Clodock, yeoman 0
4010590 2028564 2028564 defendant Scudamore John ap Richard yeoman 655905 655905 Scudamore, John ap Richard, of Clodock, yeoman 3
4010599 2028564 2028564 defendant ap Rychard John Thomas yeoman 655905 655905 ap Rychard, John Thomas, of Clodock, yeoman 12
4011873 2028975 2028975 defendant Morran Philip Edward husbandman 655905 655905 Morran, Philip Edward, of Clodock, husbandman 0
4022300 2032698 2032698 defendant Hughe Griffin ap Richard husbandman 655905 655905 Hughe, Griffin ap Richard, of Clodock, husbandman 0
4022301 2032698 2032698 defendant Hughe Howell ap Richard yeoman 655905 655905 Hughe, Howell ap Richard, of Clodock, yeoman 1
4022390 2032732 2032732 defendant Prychard Philip Gillam or William yeoman 655905 655905 Prychard, Philip Gillam or William, of Clodock, yeoman 0
4022393 2032733 2032733 defendant Prychard Philip Gillam yeoman 655905 655905 Prychard, Philip Gillam, of Clodock, yeoman 0
4029578 2035216 2035216 defendant Phylyp Henry yeoman 655905 655905 Phylyp, Henry, of Clodock, yeoman 0
4029579 2035216 2035216 defendant Philip Rice Harry yeoman 655905 655905 Philip, Rice Harry, of Clodock, yeoman 1
4032424 2036252 2036252 defendant Lewys Lewis Thomas yeoman 655905 655905 Lewys, Lewis Thomas, of Clodock, yeoman 0
4032430 2036252 2036252 defendant Scudamor John Richard yeoman 655905 655905 Scudamor, John Richard, of Clodock, yeoman 6
4032442 2036253 2036253 defendant Lewys Lewis Thomas yeoman 655905 655905 Lewys, Lewis Thomas, of Clodock, yeoman 0
4032450 2036253 2036253 defendant Scudamor John Richard yeoman 655905 655905 Scudamor, John Richard, of Clodock, yeoman 8
4042484 2039783 2039783 defendant ap Harry Lewis ap Rees yeoman 655905 655905 ap Harry, Lewis ap Rees, of Clodock, yeoman 7
4042497 2039784 2039784 defendant ap Harry Lewis ap Rice yeoman 655905 655905 ap Harry, Lewis ap Rice, of Clodock, yeoman 7
4052532 2043328 2043328 defendant Hughe Griffin ap Richard husbandman 655905 655905 Hughe, Griffin ap Richard, of Clodock, husbandman 0
4052533 2043328 2043328 defendant Hughe Howell ap Richard yeoman 655905 655905 Hughe, Howell ap Richard, of Clodock, yeoman 1
4052686 2043392 2043392 defendant Richard Henry yeoman 655905 655905 Richard, Henry, of Clodock, yeoman 0
4052687 2043392 2043392 defendant ap Jevan Thomas yeoman 655905 655905 ap Jevan, Thomas, of Clodock, yeoman 1
4053500 2043627 2043627 defendant Lewys John ap Harry yeoman 655905 655905 Lewys, John ap Harry, of Clodock, yeoman 3
4063214 2047136 2047136 defendant Harry Watkin Jevan yeoman 655905 655905 Harry, Watkin Jevan, of Clodock, yeoman 8
4067473 2048677 2048677 defendant Lewys John Harry yeoman 655905 655905 Lewys, John Harry, of Clodock, or of Longetowne, yeoman 0
4067475 2048678 2048678 defendant Philip John Harry yeoman 655905 655905 Philip, John Harry, of Clodock, yeoman 0
4069337 2049318 2049318 defendant ap Jevan Thomas yeoman 655905 655905 ap Jevan, Thomas, of Clodock, yeoman 1
4073753 2050905 2050905 defendant Powell or ap Howell James yeoman 655905 655905 Powell or ap Howell, James, of Clodock, yeoman 0
4073755 2050905 2050905 defendant Lewys Lewis John yeoman 655905 655905 Lewys, Lewis John, of Clodock, yeoman 2
4073756 2050905 2050905 defendant Prychard Lewis Philip yeoman or smith 655905 655905 Prychard, Lewis Philip, of Clodock, yeoman or smith 3
4075273 2051461 2051461 defendant Brace Robert husbandman 655905 655905 Brace, Robert, of Clodock, husbandman 0
4075274 2051461 2051461 defendant Gillam Thomas Richard husbandman 655905 655905 Gillam, Thomas Richard, of Clodock, husbandman 1
4078576 2052638 2052638 defendant John Thomas Philip yeoman 655905 655905 John, Thomas Philip, of Clodock, yeoman 0
4078592 2052644 2052644 defendant Myle Alice spinster 655905 655905 Myle, Alice, of Clodock, spinster 0
4081631 2053733 2053733 defendant James Thomas John yeoman 655905 655905 James, Thomas John, of Clodock, yeoman 0
4081632 2053733 2053733 defendant Philip Henry Thomas husbandman 655905 655905 Philip, Henry Thomas, of Clodock, husbandman 1
4081633 2053733 2053733 defendant Ohilip Joan widow 655905 655905 Ohilip Joan, of Clodock, widow 2
4082915 2054189 2054189 defendant Rychard Henry yeoman 655905 655905 Rychard, Henry, of Clodock, yeoman 0
4091505 2057252 2057252 defendant Barry Philip Jenkin tailor 655905 655905 Barry, Philip Jenkin, of Clodock, tailor 1
4093848 2058123 2058123 defendant Bannor Thomas Lewis yeoman 655905 655905 Bannor, Thomas Lewis, of Clodock, yeoman 1
4103055 2061383 2061383 defendant Madock Thomas David yeoman 655905 655905 Madock, Thomas David, of Clodock, yeoman 0
4103056 2061383 2061383 defendant Powell David yeoman 655905 655905 Powell, David, of Clodock, yeoman 1
4103057 2061383 2061383 defendant Morgan William yeoman 655905 655905 Morgan, William, of Clodock, yeoman 2
4104084 2061735 2061735 defendant Lloyde Robert   655905 655905 Lloyde, Robert, of Clodock, mason 2
4133426 2072281 2072281 defendant Madocke Treharon husbandman 655905 655905 Madocke, Treharon, of Clodock, husbandman 1
4133427 2072281 2072281 defendant Lewes William husbandman 655905 655905 Lewes, William, of Clodock, husbandman 2
4142941 2075703 2075703 defendant James Thomas yeoman 655905 655905 James, Thomas, of Clodock, yeoman 1
4144556 2076256 2076256 defendant Apparry Thomas yeoman 655905 655905 Apparry, Thomas, of Clodock, yeoman 0
4154125 2079537 2079537 defendant David Richard yeoman 655905 655905 David, Richard, of Clodock, yeoman 0
4165106 2083302 2083302 defendant Watkyns William gent 655905 655905 Watkyns, William, of Clodock, gent 1
4179650 2088356 2088356 defendant Madock Philip John husbandman 655905 655905 Madock, Philip John, of Clodock, husbandman 1
4183150 2089588 2089588 defendant William Henry yeoman 655905 655905 William, Henry, of Clodock, yeoman 0
4204555 2097141 2097141 defendant Powell Thomas Powell yeoman 655905 655905 Powell, Thomas Powell, of Clodock, yeoman 0
4220309 2102610 2102610 defendant Powell Owen yeoman 655905 655905 Powell, Owen, of Clodock, yeoman 1
4297707 2129286 2129286 defendant William John Thomas yeoman 655905 655905 William, John Thomas, of Clodock, or of Llanveyno, Herefs, yeoman 0
4297708 2129286 2129286 defendant Winston William gent 655905 655905 Winston, William, of Clodock, gent 1
4297710 2129287 2129287 defendant ap Rees Rice gent 655905 655905 ap Rees, Rice, of Clodock, gent 0
4297711 2129287 2129287 defendant Jenkyn John yeoman 655905 655905 Jenkyn, John, of Clodock, yeoman 1
4297712 2129287 2129287 defendant Morgan John yeoman 655905 655905 Morgan, John, of Clodock, yeoman 2
4298125 2129433 2129433 defendant Wynston William gent 655905 655905 Wynston, William, of Clodock, gent 1
4298126 2129433 2129433 defendant John Thomas Phillipp yeoman 655905 655905 John, Thomas Phillipp, of Clodock, yeoman 2
4306233 2132317 2132317 defendant ap Rees Rice gent 655905 655905 ap Rees, Rice, of Clodock, gent 0
4315023 2135366 2135366 defendant Wynter Richard yeoman 655905 655905 Wynter, Richard, of Clodock, yeoman 1
4316243 2135792 2135792 defendant Gwyn John yeoman 655905 655905 Gwyn, John, of Clodock, yeoman 0
4319047 2136777 2136777 defendant Howell Katherine widow 655905 655905 Howell, Katherine, of Clodock, widow 2
4320277 2137193 2137193 defendant Harry Thomas David yeoman 655905 655905 Harry, Thomas David, of Clodock, yeoman 0
4320278 2137193 2137193 defendant David David Harry yeoman 655905 655905 David, David Harry, of Clodock, yeoman 1
4322462 2137926 2137926 defendant Harry Thomas David yeoman 655905 655905 Harry, Thomas David, of Clodock, yeoman 0
4330083 2140361 2140361 defendant Powell Owen gent 655905 655905 Powell, Owen, of Clodock, gent 0
4330084 2140361 2140361 defendant David Thomas William yeoman 655905 655905 David, Thomas William, of Clodock, yeoman 1
4330085 2140361 2140361 defendant Price David Thomas yeoman 655905 655905 Price, David Thomas, of Clodock, yeoman 2
4358587 2150242 2150242 defendant Harry Thomas David yeoman 655905 655905 Harry, Thomas David, of Clodock, yeoman 0
4358588 2150242 2150242 defendant Madock Henry David yeoman 655905 655905 Madock, Henry David, of Clodock, yeoman 1
4380584 2158164 2158164 defendant John Thomas Philip yeoman 655905 655905 John, Thomas Philip, of Clodock, yeoman 0
4399853 2164539 2164539 defendant David John Harry yeoman 655905 655905 David, John Harry, of Clodock, yeoman 1
4399854 2164539 2164539 defendant verch John Gwenlliana widow 655905 655905 verch John, Gwenlliana, of Clodock, widow 2
4399855 2164539 2164539 defendant Price Jevan yeoman 655905 655905 Price, Jevan, of Clodock, yeoman 3
4401439 2165076 2165076 defendant Scudamore John Richard laborer 655905 655905 Scudamore, John Richard, of Clodock, laborer 0
4402743 2165501 2165501 defendant Price William yeoman 655905 655905 Price, William, of Clodock, yeoman 3
4409216 2167682 2167682 defendant Lewys John yeoman 655905 655905 Lewys, John, of Clodock, 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);