names

137 rows where place_id = 649392

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3906464 1992456 1992456 defendant Lewes Thomas gent 649392 649392 Lewes, Thomas, of Carmarthen, gent 0
3918806 1996614 1996614 defendant Edward Henry merchant tailor 649392 649392 Edward, Henry, of Carmarthen, merchant tailor 2
3925422 1998815 1998815 defendant Draper John chapman 649392 649392 Draper, John, of Carmarthen, chapman 3
3951359 2007545 2007545 defendant Ponten alias Pontiff David yeoman 649392 649392 Ponten alias Pontiff, David, of Carmarthen, yeoman 0
3957197 2009581 2009581 defendant Holland Richard merchant 649392 649392 Holland, Richard, of Carmarthen, merchant 0
3957199 2009582 2009582 defendant Holland Richard merchant 649392 649392 Holland, Richard, of Carmarthen, merchant 0
3957201 2009583 2009583 defendant Holland Richard merchant 649392 649392 Holland, Richard, of Carmarthen, merchant 0
3957203 2009584 2009584 defendant Holland Richard merchant 649392 649392 Holland, Richard, of Carmarthen, merchant 0
3957205 2009585 2009585 defendant Holland Richard merchant 649392 649392 Holland, Richard, of Carmarthen, merchant 0
3957211 2009588 2009588 defendant Holland Richard merchant 649392 649392 Holland, Richard, of Carmarthen, merchant 0
3957212 2009588 2009588 defendant Davy Lewis merchant 649392 649392 Davy, Lewis, of Carmarthen, merchant 1
3961683 2011187 2011187 defendant Hoddon Philip husbandman 649392 649392 Hoddon, Philip, of Carmarthen, husbandman 1
3967642 2013318 2013318 plaintiff Byrte Robert merchant 649392 649392 Byrte, Robert, of Carmarthen, merchant 0
3976844 2016472 2016472 defendant Bygges John chapman 649392 649392 Bygges, John, of Carmarthen, chapman 0
3976845 2016472 2016472 defendant ap Llewellin John Rice chapman 649392 649392 ap Llewellin, John Rice, of Carmarthen, chapman 1
3980420 2017765 2017765 defendant Penton Griffin chapman 649392 649392 Penton, Griffin, of Carmarthen, chapman 2
3981214 2018042 2018042 defendant Phillip Jenkin Devid ap Evan chapman 649392 649392 Phillip, Jenkin Devid ap Evan, of Carmarthen, chapman 0
3981215 2018042 2018042 defendant Gruffeth John chapman 649392 649392 Gruffeth, John, of Carmarthen, chapman 1
3981216 2018042 2018042 defendant Toye Humphrey chapman 649392 649392 Toye, Humphrey, of Carmarthen, chapman 2
3981217 2018042 2018042 defendant Moran or Amorganne John gent 649392 649392 Moran or Amorganne, John, of Carmarthen, gent 3
3981648 2018193 2018193 defendant Bygges John merchant 649392 649392 Bygges, John, of Carmarthen, merchant 0
3981649 2018193 2018193 defendant Williams Hugh merchant 649392 649392 Williams, Hugh, of Carmarthen, merchant 1
3999724 2024662 2024662 defendant Toye Humphrey merchant 649392 649392 Toye, Humphrey, of Carmarthen, merchant 0
3999725 2024662 2024662 defendant Hopkyn Richard Lewis merchant 649392 649392 Hopkyn, Richard Lewis, of Carmarthen, merchant 1
4000162 2024827 2024827 defendant Gryffythe John merchant 649392 649392 Gryffythe, John, of Carmarthen, merchant 1
4005743 2026831 2026831 defendant Bigge John (legal representative) 649392 649392 Bigge, John, of Carmarthen, chapman, executors of 0
4005744 2026831 2026831 defendant Tracke John   649392 649392 Tracke, John, of Carmarthen, chapman, Jane his wife 1
4018015 2031159 2031159 defendant ap Gyvan Griffin merchant 649392 649392 ap Gyvan, Griffin, of Carmarthen, merchant 0
4018018 2031160 2031160 defendant Hollande Richard merchant 649392 649392 Hollande, Richard, of Carmarthen, merchant 0
4018021 2031161 2031161 defendant Rede David John gent 649392 649392 Rede, David John, of Carmarthen, gent 0
4018027 2031163 2031163 defendant Parry David merchant 649392 649392 Parry, David, of Carmarthen, merchant 0
4018492 2031348 2031348 plaintiff Vaughan John esq 649392 649392 Vaughan, John, of Carmarthen, esq 0
4018496 2031349 2031349 plaintiff Vaughan John gent 649392 649392 Vaughan, John, of Carmarthen, gent 0
4021014 2032241 2032241 defendant Gryffyth John gent 649392 649392 Gryffyth, John, of Carmarthen, gent 0
4024092 2033321 2033321 defendant Vaughan Walter gent 649392 649392 Vaughan, Walter, of Carmarthen, gent 1
4024095 2033322 2033322 defendant Vaughan Walter gent 649392 649392 Vaughan, Walter, of Carmarthen, gent 1
4029545 2035204 2035204 defendant Kyste John merchant 649392 649392 Kyste, John, of Carmarthen, merchant 0
4029546 2035204 2035204 defendant Vaugham John esq 649392 649392 Vaugham, John, of Carmarthen, esq 1
4039153 2038631 2038631 defendant Jenyng Richard chapman 649392 649392 Jenyng, Richard, of Carmarthen, chapman 1
4039158 2038632 2038632 defendant Jenyng Richard chapman 649392 649392 Jenyng, Richard, of Carmarthen, chapman 1
4058106 2045279 2045279 defendant ap Richarde Griffin gent 649392 649392 ap Richarde, Griffin, of Carmarthen, gent 2
4058109 2045280 2045280 defendant Morgan Henry gent 649392 649392 Morgan, Henry, of Carmarthen, gent 1
4058110 2045280 2045280 defendant Reade Richard gent 649392 649392 Reade, Richard, of Carmarthen, gent 2
4067940 2048843 2048843 defendant Birtte John gent 649392 649392 Birtte, John, of Carmarthen, gent 0
4067941 2048843 2048843 defendant David Lewis Philip merchant 649392 649392 David, Lewis Philip, of Carmarthen, merchant 1
4073102 2050670 2050670 defendant Hopkyns Richard Lewis chapman 649392 649392 Hopkyns, Richard Lewis, of Carmarthen, chapman 0
4073106 2050672 2050672 defendant Williams David Lewis merchant 649392 649392 Williams, David Lewis, of Carmarthen, merchant 0
4073107 2050672 2050672 defendant Hopkyn Richard Lewis merchant 649392 649392 Hopkyn, Richard Lewis, of Carmarthen, merchant 1
4073109 2050673 2050673 defendant Wyllyams David Lewis merchant 649392 649392 Wyllyams, David Lewis, of Carmarthen, merchant 0
4073110 2050673 2050673 defendant Hopkyn Richard Lewis merchant 649392 649392 Hopkyn, Richard Lewis, of Carmarthen, merchant 1
4073112 2050674 2050674 defendant Williams Lewis chapman 649392 649392 Williams, Lewis, of Carmarthen, chapman 0
4075205 2051438 2051438 defendant Walter Philip gent 649392 649392 Walter, Philip, of Carmarthen, gent 1
4075985 2051708 2051708 defendant Lewes Richard alias Richard Lewis Hopkyns merchant 649392 649392 Lewes, Richard alias Richard Lewis Hopkyns, of Carmarthen, merchant 0
4078557 2052630 2052630 defendant Cotton John yeoman 649392 649392 Cotton, John, of Carmarthen, yeoman 0
4079254 2052883 2052883 plaintiff Toye Robert merchant 649392 649392 Toye, Robert, of Carmarthen, merchant 0
4079256 2052884 2052884 plaintiff Toye Robert merchant 649392 649392 Toye, Robert, of Carmarthen, merchant 0
4083116 2054251 2054251 defendant Phillipps Henry tanner 649392 649392 Phillipps, Henry, of Carmarthen, tanner 2
4083631 2054421 2054421 defendant Kyste John vintner 649392 649392 Kyste, John, of Carmarthen, vintner 1
4083644 2054424 2054424 defendant David Lewis Philip alderman 649392 649392 David, Lewis Philip, of Carmarthen, alderman 2
4088427 2056157 2056157 defendant Morgan Henry gent 649392 649392 Morgan, Henry, of Carmarthen, gent 0
4088431 2056159 2056159 defendant Reade Richard gent 649392 649392 Reade, Richard, of Carmarthen, gent 0
4088441 2056164 2056164 defendant ap Richard Griffin gent 649392 649392 ap Richard, Griffin, of Carmarthen, gent 0
4100413 2060476 2060476 defendant Kyffe John merchant 649392 649392 Kyffe, John, of Carmarthen, merchant 1
4100496 2060503 2060503 defendant Byrt John gent 649392 649392 Byrt, John, of Carmarthen, gent 0
4107179 2062863 2062863 defendant Parry Richard chapman 649392 649392 Parry, Richard, of Carmarthen, chapman 0
4107182 2062864 2062864 defendant Tyler Thomas chapman 649392 649392 Tyler, Thomas, of Carmarthen, chapman 0
4108714 2063372 2063372 defendant Roche Nicholas mariner 649392 649392 Roche, Nicholas, of Carmarthen, mariner 0
4130570 2071244 2071244 defendant Parry Richard gent 649392 649392 Parry, Richard, of Carmarthen, gent 0
4130571 2071244 2071244 defendant Morgan Henry gent 649392 649392 Morgan, Henry, of Carmarthen, gent 1
4131923 2071730 2071730 defendant Parrye David (legal representative) 649392 649392 Parrye, David, of Carmarthen, merchant, executor of 0
4131926 2071731 2071731 defendant Phillippe David merchant 649392 649392 Phillippe, David, of Carmarthen, merchant 0
4150580 2078337 2078337 defendant Thomas William yeoman 649392 649392 Thomas, William, of Carmarthen, yeoman 0
4161416 2082070 2082070 defendant Bamton Thomas merchant 649392 649392 Bamton, Thomas, of Carmarthen, merchant 1
4182013 2089190 2089190 defendant Owen John chapman 649392 649392 Owen, John, of Carmarthen, chapman 0
4182016 2089191 2089191 defendant Sparke Peter chapman 649392 649392 Sparke, Peter, of Carmarthen, chapman 0
4183940 2089878 2089878 defendant Vizar Henry haberdasher 649392 649392 Vizar, Henry, of Carmarthen, haberdasher 0
4185785 2090525 2090525 defendant Toye Robert chapman 649392 649392 Toye, Robert, of Carmarthen, chapman 2
4190334 2092138 2092138 defendant Owen John chapman 649392 649392 Owen, John, of Carmarthen, chapman 0
4192538 2092954 2092954 defendant Polefletcher William clothier 649392 649392 Polefletcher, William, of Carmarthen, clothier 0
4203459 2096763 2096763 defendant Reade Jenkin yeoman 649392 649392 Reade, Jenkin, of Carmarthen, yeoman 1
4203460 2096763 2096763 defendant Morgan William yeoman 649392 649392 Morgan, William, of Carmarthen, yeoman 2
4203461 2096763 2096763 defendant Morgan Thomas yeoman 649392 649392 Morgan, Thomas, of Carmarthen, yeoman 3
4203462 2096763 2096763 defendant Ryce Griffin yeoman 649392 649392 Ryce, Griffin, of Carmarthen, yeoman 4
4203463 2096763 2096763 defendant Howell Lewis yeoman 649392 649392 Howell, Lewis, of Carmarthen, yeoman 5
4203525 2096783 2096783 defendant Edward David gent 649392 649392 Edward, David, of Carmarthen, gent 0
4204569 2097145 2097145 defendant Reade Jenkin yeoman 649392 649392 Reade, Jenkin, of Carmarthen, yeoman 1
4204570 2097145 2097145 defendant Morgan William yeoman 649392 649392 Morgan, William, of Carmarthen, yeoman 2
4204571 2097145 2097145 defendant Morgan Thomas yeoman 649392 649392 Morgan, Thomas, of Carmarthen, yeoman 3
4204572 2097145 2097145 defendant Ryce Griffin yeoman 649392 649392 Ryce, Griffin, of Carmarthen, yeoman 4
4204573 2097145 2097145 defendant Howell Lewis yeoman 649392 649392 Howell, Lewis, of Carmarthen, yeoman 5
4211552 2099591 2099591 defendant Evett Nicholas merchant 649392 649392 Evett, Nicholas, of Carmarthen, merchant 0
4236529 2108350 2108350 defendant William David Lewis merchant 649392 649392 William, David Lewis, of Carmarthen, merchant 2
4236530 2108350 2108350 defendant Havard David gent 649392 649392 Havard, David, of Carmarthen, gent 3
4236534 2108351 2108351 defendant William David Lewys merchant 649392 649392 William, David Lewys, of Carmarthen, merchant 2
4236535 2108351 2108351 defendant Havard David gent 649392 649392 Havard, David, of Carmarthen, gent 3
4259758 2116235 2116235 defendant verch Rethergh Agnes (legal representative) 649392 649392 verch Rethergh, Agnes, of Carmarthen, widow, executors of 0
4259759 2116235 2116235 defendant Phillipps David gent 649392 649392 (Phillipps, David, of Carmarthen, gent 1
4259760 2116235 2116235 defendant ap Owen Robert gent 649392 649392 ap Owen, Robert, of Carmarthen, gent 2
4263795 2117550 2117550 defendant Lloyd Mourice gent 649392 649392 Lloyd, Mourice, of Carmarthen, gent 0
4267568 2118785 2118785 defendant Davys Rice chapman 649392 649392 Davys, Rice, of Carmarthen, chapman 2

Next page

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