names

70 rows where place_id = 654743

✎ 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
3933594 2001521 2001521 defendant Jones Philip gent 654743 654743 Jones, Philip, of Brecon, gent 3
3951128 2007463 2007463 defendant Williams alias Small Owen yeoman 654743 654743 Williams alias Small, Owen, of Brecon, yeoman 2
3953685 2008366 2008366 defendant Gryffyth Richard clerk 654743 654743 Gryffyth, Richard, of Brecon, clerk 0
3953686 2008366 2008366 defendant Griffith William David cordwainer 654743 654743 Griffith, William David, of Brecon, cordwainer 1
3957543 2009703 2009703 defendant Bobythe Thomas ap John mercer 654743 654743 Bobythe, Thomas ap John, of Brecon, mercer 0
3957545 2009704 2009704 defendant Bobythe Thomas ap John mercer 654743 654743 Bobythe, Thomas ap John, of Brecon, mercer 0
3957723 2009761 2009761 defendant ap Jevan Thomas yeoman 654743 654743 ap Jevan, Thomas, of Brecon, yeoman 0
3967614 2013308 2013308 defendant Vayne Thomas Pryce cordwainer 654743 654743 Vayne, Thomas Pryce, of Brecon, cordwainer 0
3967615 2013308 2013308 defendant William John cordwainer 654743 654743 William, John, of Brecon, cordwainer 1
3967616 2013308 2013308 defendant ap John Jevan cordwainer 654743 654743 ap John, Jevan, of Brecon, cordwainer 2
3970846 2014382 2014382 defendant Vayne Thomas ap Rees chapman 654743 654743 Vayne, Thomas ap Rees, of Brecknock, Brecon, chapman 2
3970870 2014385 2014385 defendant Wynter John gent 654743 654743 Wynter, John, of Brecknock, Brecon, gent 0
3970886 2014386 2014386 defendant Edwardes William vintner 654743 654743 Edwardes, William, of Brecknock, Brecon, vintner 0
3983130 2018740 2018740 plaintiff Smyth Agnes widow 654743 654743 Smyth, Agnes, of Brecon, widow 0
3991203 2021613 2021613 defendant Games or Gaines Thomas gent 654743 654743 Games or Gaines, Thomas, of Brecon, gent 0
3991206 2021614 2021614 defendant Havard Philip gent 654743 654743 Havard, Philip, of Brecon, gent 0
3997697 2023932 2023932 defendant ap Gwatkyn John Thomas gent 654743 654743 ap Gwatkyn, John Thomas, of Brecon, gent 0
3997701 2023934 2023934 defendant ap Howell John cordwainer 654743 654743 ap Howell, John, of Brecon, cordwainer 0
3997707 2023937 2023937 defendant Thomas Llewellen Morgan gent 654743 654743 Thomas, Llewellen Morgan, of Brecon, gent 0
4030763 2035665 2035665 defendant Games or Gaines Thomas gent 654743 654743 Games or Gaines, Thomas, of Brecon, gent 0
4038853 2038516 2038516 plaintiff Lewys Thomas gent 654743 654743 Lewys, Thomas, of Brecon, gent 0
4052642 2043370 2043370 defendant Williams Thomas chapman 654743 654743 Williams, Thomas, of Brecon, chapman 0
4069401 2049339 2049339 defendant Herbert John   654743 654743 Herbert, John, of Brecon gent 1
4069485 2049366 2049366 defendant ap thomas Thomas baker 654743 654743 ap thomas, Thomas, of Brecon, baker 0
4072697 2050530 2050530 defendant ap William William gent 654743 654743 ap William, William, of Brecon, gent 3
4085385 2055049 2055049 defendant ap Gwatkyn John Thomas gent 654743 654743 ap Gwatkyn, John Thomas, of Brecon, gent 1
4085391 2055050 2055050 defendant ap Gwatkyn John Thomas gent 654743 654743 ap Gwatkyn, John Thomas, of Brecon, gent 1
4093347 2057937 2057937 defendant Llyswen Thomas Jenkin clerk 654743 654743 Llyswen, Thomas Jenkin, of Brecon, clerk 3
4102485 2061184 2061184 defendant Havard Thomas ap John Lloyd gent 654743 654743 Havard, Thomas ap John Lloyd, of Brecon, gent 0
4102487 2061185 2061185 defendant Lloyd Thomas ap John gent 654743 654743 Lloyd, Thomas ap John, of Brecon, gent 0
4118713 2066983 2066983 defendant Wynter John gent 654743 654743 Wynter, John, of Brecon, gent 1
4118719 2066984 2066984 defendant Wynter John gent 654743 654743 Wynter, John, of Brecon, gent 1
4118724 2066985 2066985 defendant Dylwyn John William yeoman 654743 654743 Dylwyn, John William, of Brecon, yeoman 0
4118730 2066986 2066986 defendant Dylwyne William yeoman 654743 654743 Dylwyne, William, of Brecon, yeoman 0
4118731 2066986 2066986 defendant Games or Gaines John esq 654743 654743 Games or Gaines, John, of Brecon, esq 1
4134503 2072670 2072670 defendant ap Thomas Henry badger or pedlar 654743 654743 ap Thomas, Henry, of Brecon, badger or pedlar 2
4135720 2073103 2073103 defendant Phillippe Henry dyer 654743 654743 Phillippe, Henry, of Brecknock, Brecon, dyer 1
4155423 2079989 2079989 defendant Bedowe Thomas John William butcher 654743 654743 Bedowe, Thomas John William, of Brecon, butcher 0
4155424 2079989 2079989 defendant ap Rosser Thomas butcher 654743 654743 ap Rosser, Thomas, of Brecon, butcher 1
4155425 2079989 2079989 defendant Edmonde Meredith John yeoman 654743 654743 Edmonde, Meredith John, of Brecon, yeoman 2
4155428 2079990 2079990 defendant Watkyn Lluwellin weaver 654743 654743 Watkyn, Lluwellin, of Brecon, weaver 0
4155429 2079990 2079990 defendant Bedo Thomas John William butcher 654743 654743 Bedo, Thomas John William, of Brecon, butcher 1
4155430 2079990 2079990 defendant Lewes John David butcher 654743 654743 Lewes, John David, of Brecon, butcher 2
4155435 2079991 2079991 defendant Walter Howell gent 654743 654743 Walter, Howell, of Brecon, gent 1
4155457 2079996 2079996 defendant Watkyns Howell gent 654743 654743 Watkyns, Howell, of Brecon, gent 1
4158495 2081042 2081042 defendant ap Thomas Henry badger 654743 654743 ap Thomas, Henry, of Brecon, badger 2
4168732 2084554 2084554 defendant Morgan Thomas gent 654743 654743 Morgan, Thomas, of Brecon, gent 0
4183128 2089582 2089582 defendant Glover Owen glover 654743 654743 Glover, Owen, of Brecon, glover 2
4187194 2091012 2091012 defendant ap Thomas John Thomas baker 654743 654743 ap Thomas, John Thomas, of Brecon, baker 0
4187195 2091012 2091012 defendant Davies Jersom Master of Arts 654743 654743 Davies, Jersom, of Brecon, Master of Arts 1
4187199 2091013 2091013 defendant Lewes John gent 654743 654743 Lewes, John, of Brecon, gent 0
4200540 2095751 2095751 defendant Morgan Thomas gent 654743 654743 Morgan, Thomas, of Brecon, gent 0
4201939 2096223 2096223 defendant ap Morgan Thomas gent 654743 654743 ap Morgan, Thomas, of Brecon, gent 0
4204304 2097052 2097052 defendant Richard Philip capper 654743 654743 Richard, Philip, of Brecon, capper 0
4210786 2099330 2099330 defendant Lewes John gent 654743 654743 Lewes, John, of Brecon, gent 0
4222825 2103474 2103474 defendant ap Hoell Thomas gent 654743 654743 ap Hoell, Thomas, of Brecon, gent 0
4239890 2109587 2109587 defendant ap Hoell Thomas gent 654743 654743 ap Hoell, Thomas, of Brecon, gent 0
4257473 2115473 2115473 defendant Wynter John gent 654743 654743 Wynter, John, of Brecon, or of Llangoed, Brecon, gent 0
4257474 2115473 2115473 defendant Hoell Roger gent 654743 654743 Hoell, Roger, of Brecon, or of Gaer, Brecon, gent 1
4257478 2115474 2115474 defendant Wynter John gent 654743 654743 Wynter, John, of Brecon, or of Llangoed, Brecon, gent 0
4257479 2115474 2115474 defendant Howell Roger gent 654743 654743 Howell, Roger, of Brecon, or of Gaer, Brecon, gent 1
4297468 2129196 2129196 defendant Towers Mathew chapman 654743 654743 Towers, Mathew, of Brecon, chapman 0
4330395 2140465 2140465 defendant Towers Mathew chapman 654743 654743 Towers, Mathew, of Brecon, chapman 0
4334917 2141940 2141940 defendant Morgan Meredith Master of Arts 654743 654743 Morgan, Meredith, of Brecon, Master of Arts 2
4348021 2146560 2146560 defendant Charles David chapman 654743 654743 Charles, David, of Brecon, chapman 2
4351117 2147642 2147642 defendant Water William gent 654743 654743 Water, William, of Brecon, gent 0
4366360 2153008 2153008 defendant Doxen Robert yeoman 654743 654743 Doxen, Robert, of Brecon, yeoman 1
4366361 2153008 2153008 defendant Waters William gent 654743 654743 Waters, William, of Brecon, gent 2
4369990 2154322 2154322 defendant Herbert Walter gent 654743 654743 Herbert, Walter, of Brecon, gent 0
4399201 2164319 2164319 defendant Powell Thomas gent 654743 654743 Powell, Thomas, of Brecon, gent 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);