names

81 rows where place_id = 662176

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3964045 2012034 2012034 defendant Rosser William yeoman 662176 662176 Rosser, William, of Shernewton, yeoman 0
3964176 2012078 2012078 defendant Griffeth John William yeoman 662176 662176 Griffeth, John William, of Shernewton, yeoman 0
3964177 2012078 2012078 defendant Rosser William yeoman 662176 662176 Rosser, William, of Shernewton, yeoman 1
3982014 2018328 2018328 plaintiff Rosser William yeoman 662176 662176 Rosser, William, of Shernewton, yeoman 0
4001490 2025313 2025313 plaintiff Harbert Walter gent 662176 662176 Harbert, Walter, of Shernewton, gent 0
4001491 2025313 2025313 defendant Gryffyth John William yeoman 662176 662176 Gryffyth, John William, of Shernewton, yeoman 0
4001492 2025313 2025313 defendant ap Jevan Thomas husbandman 662176 662176 ap Jevan, Thomas, of Shernewton, husbandman 1
4002464 2025650 2025650 defendant Robert Morgan husbandman 662176 662176 Robert, Morgan, of Shernewton, husbandman 2
4002465 2025650 2025650 defendant William Robert husbandman 662176 662176 William, Robert, of Shernewton, husbandman 3
4002470 2025652 2025652 defendant Perbert Thomas butcher 662176 662176 Perbert, Thomas, of Shernewton, butcher 0
4002474 2025653 2025653 plaintiff Herbert Walter gent 662176 662176 Herbert, Walter, of Shernewton, gent 0
4002475 2025653 2025653 defendant Gryffyth John William yeoman 662176 662176 Gryffyth, John William, of Shernewton, yeoman 0
4002476 2025653 2025653 defendant ap Ivan Thomas husbandman 662176 662176 ap Ivan, Thomas, of Shernewton, husbandman 1
4066517 2048316 2048316 defendant Wylym Philip Howell yeoman 662176 662176 Wylym, Philip Howell, of Shernewton, yeoman 0
4073669 2050875 2050875 defendant Herbert Walter gent 662176 662176 together with Herbert, Walter, of Shernewton, gent 1
4073673 2050876 2050876 defendant Herbert Walter gent 662176 662176 Herbert, Walter, of Shernewton, gent 0
4073674 2050876 2050876 defendant Rosser William yeoman 662176 662176 Rosser, William, of Shernewton, yeoman 1
4074026 2051001 2051001 defendant Roger William yeoman 662176 662176 Roger, William, of Shernewton, yeoman 1
4075737 2051628 2051628 defendant Herbert Walter gent 662176 662176 Herbert, Walter, of Shernewton, gent 1
4075738 2051628 2051628 defendant Steven Roger yeoman 662176 662176 Steven, Roger, of Shernewton, yeoman 2
4075739 2051628 2051628 defendant ao Ryce Richard yeoman 662176 662176 ao Ryce, Richard, of Shernewton, yeoman 3
4081671 2053747 2053747 defendant ap Jevan William John yeoman 662176 662176 ap Jevan, William John, of Shernewton, yeoman 2
4104633 2061939 2061939 defendant John alias Saer David yeoman 662176 662176 John alias Saer, David, of Shernewton, yeoman 0
4110137 2063888 2063888 defendant Rosser William   662176 662176 Rosser, William, of Shernewton yeoman 0
4110358 2063964 2063964 defendant Stevyn Roger yeoman 662176 662176 Stevyn, Roger, of Shernewton, yeoman 1
4130693 2071289 2071289 defendant Watkyne William yeoman 662176 662176 Watkyne, William, of Shernewton, yeoman 0
4130694 2071289 2071289 defendant David Robert yeoman 662176 662176 David, Robert, of Shernewton, yeoman 1
4136417 2073366 2073366 defendant Lewys Philip John yeoman 662176 662176 Lewys, Philip John, of Shernewton, yeoman 0
4152133 2078858 2078858 defendant Rychard Philip yeoman 662176 662176 Rychard, Philip, of Shernewton, yeoman 2
4152134 2078858 2078858 defendant Gillam Reginald yeoman 662176 662176 Gillam, Reginald, of Shernewton, yeoman 3
4153325 2079262 2079262 defendant Rosser William yeoman 662176 662176 Rosser, William, of Shernewton, yeoman 0
4153326 2079262 2079262 defendant Prichard Philip yeoman 662176 662176 Prichard, Philip, of Shernewton, yeoman 1
4154405 2079632 2079632 defendant Rosser William yeoman 662176 662176 Rosser, William, of Shernewton, yeoman 0
4157106 2080565 2080565 defendant David John husbandman 662176 662176 David, John, of Shernewton, husbandman 2
4160724 2081828 2081828 defendant Lewys alias Powell John yeoman 662176 662176 Lewys alias Powell, John, of Shernewton, yeoman 0
4165917 2083578 2083578 defendant David George husbandman 662176 662176 David, George, of Shernewton, husbandman 2
4181171 2088892 2088892 defendant Nicholas David yeoman 662176 662176 Nicholas, David, of Shernewton, yeoman 0
4182837 2089478 2089478 defendant Wyllym Reginald yeoman 662176 662176 Wyllym, Reginald, of Shernewton, yeoman 0
4193808 2093405 2093405 defendant Lewys William Watkin gent 662176 662176 Lewys, William Watkin, of Shernewton, gent 0
4193809 2093405 2093405 defendant David George yeoman 662176 662176 David, George, of Shernewton, yeoman 1
4193818 2093407 2093407 defendant Rosser William gent 662176 662176 Rosser, William, of Shernewton, gent 0
4193821 2093407 2093407 defendant Wyllim Lewis Richard yeoman 662176 662176 Wyllim, Lewis Richard, of Shernewton, yeoman 3
4193823 2093408 2093408 defendant Welym Reginald yeoman 662176 662176 Welym, Reginald, of Shernewton, yeoman 0
4199425 2095347 2095347 defendant Wyllym Reginald yeoman 662176 662176 Wyllym, Reginald, of Shernewton, yeoman 0
4199426 2095347 2095347 defendant Rosser William yeoman 662176 662176 Rosser, William, of Shernewton, yeoman 1
4201970 2096235 2096235 defendant Morgan William yeoman 662176 662176 Morgan, William, of Shernewton, yeoman 0
4205891 2097603 2097603 defendant Taylor Jevan yeoman 662176 662176 Taylor, Jevan, of Shernewton, yeoman 0
4206466 2097806 2097806 defendant William Reginald yeoman 662176 662176 William, Reginald, of Shernewton, yeoman 0
4208154 2098406 2098406 defendant Wyllym Jenkin yeoman 662176 662176 Wyllym, Jenkin, of Shernewton, yeoman 3
4218476 2101960 2101960 defendant ap John John yeoman 662176 662176 ap John, John, of Shernewton, yeoman 0
4219039 2102154 2102154 defendant Blethyn William gent 662176 662176 Blethyn, William, of Shernewton, gent 1
4220479 2102665 2102665 defendant Morgan William yeoman 662176 662176 Morgan, William, of Shernewton, yeoman 0
4220480 2102665 2102665 defendant Jones Thomas yeoman 662176 662176 Jones, Thomas, of Shernewton, yeoman 1
4222583 2103393 2103393 defendant ap John David husbandman 662176 662176 ap John, David, of Shernewton, husbandman 1
4222584 2103393 2103393 defendant Morgan Jenkin husbandman 662176 662176 Morgan, Jenkin, of Shernewton, husbandman 2
4275681 2121440 2121440 defendant ap Adam William John yeoman 662176 662176 ap Adam, William John, of Shernewton, yeoman 1
4278074 2122265 2122265 defendant Morgan William gent 662176 662176 Morgan, William, of Shernewton, gent 0
4278076 2122266 2122266 defendant Morgan William gent 662176 662176 Morgan, William, of Shernewton, gent 0
4278792 2122520 2122520 defendant Williams Thomas yeoman 662176 662176 Williams, Thomas, of Shernewton, yeoman 0
4278793 2122520 2122520 defendant Gwillam Reginald yeoman 662176 662176 Gwillam, Reginald, of Shernewton, yeoman 1
4279956 2122902 2122902 defendant Wrenche Francis yeoman 662176 662176 Wrenche, Francis, of Shernewton, yeoman 0
4279957 2122902 2122902 defendant Herbert William gent 662176 662176 together with Herbert, William, of Shernewton, gent 1
4280931 2123235 2123235 defendant Blethyn William gent 662176 662176 Blethyn, William, of Shernewton, gent 0
4281262 2123356 2123356 defendant William Reginald yeoman 662176 662176 William, Reginald, of Shernewton, yeoman 1
4281433 2123411 2123411 defendant Jones Philip yeoman 662176 662176 Jones, Philip, of Shernewton, yeoman 2
4358624 2150255 2150255 defendant William Thomas yeoman 662176 662176 William, Thomas, of Shernewton, yeoman 0
4358625 2150255 2150255 defendant Thomas William   662176 662176 Thomas, William, of Shernewton, yeoman, his son 1
4364983 2152530 2152530 defendant Morgan William gent 662176 662176 Morgan, William, of Shernewton, gent 0
4366626 2153111 2153111 defendant David Henry yeoman 662176 662176 David, Henry, of Shernewton, yeoman 0
4369828 2154264 2154264 defendant Lewys Robert husbandman 662176 662176 Lewys, Robert, of Shernewton, husbandman 0
4369829 2154264 2154264 defendant Wrenche Henry husbandman 662176 662176 Wrenche, Henry, of Shernewton, husbandman 1
4374788 2156038 2156038 defendant Herbert William gent 662176 662176 Herbert, William, of Shernewton, gent 0
4378035 2157215 2157215 defendant Morgan Jenkin husbandman 662176 662176 Morgan, Jenkin, of Shernewton, husbandman 0
4378036 2157215 2157215 defendant David George yeoman 662176 662176 David, George, of Shernewton, yeoman 1
4378037 2157215 2157215 defendant ap John Thomas yeoman 662176 662176 ap John, Thomas, of Shernewton, yeoman 2
4378038 2157215 2157215 defendant Nycolas John yeoman 662176 662176 Nycolas, John, of Shernewton, yeoman 3
4378052 2157218 2157218 defendant Blethyn William gent 662176 662176 Blethyn, William, of Shernewton, gent 2
4378053 2157218 2157218 defendant William Jenkin yeoman 662176 662176 William, Jenkin, of Shernewton, yeoman 3
4379207 2157645 2157645 defendant William Philip yeoman 662176 662176 William, Philip, of Shernewton, yeoman 3
4379873 2157902 2157902 defendant Morgan Howell Thomas yeoman 662176 662176 Morgan, Howell Thomas, of Shernewton, or of Kilgorrock, yeoman 0
4381486 2158484 2158484 defendant Rice William husbandman 662176 662176 Rice, William, of Shernewton, husbandman 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);