names

145 rows where place_id = 650537

✎ 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
3912646 1994563 1994563 defendant Baker Richard, senior baker 650537 650537 Baker, Richard, senior, of Bergevenny, baker 0
3950812 2007353 2007353 defendant Harbert William gent 650537 650537 Harbert, William, of Bergevenny, gent 1
3953549 2008312 2008312 defendant ap Richard alias Baker Adam yeoman 650537 650537 ap Richard alias Baker, Adam, of Bergevenny, yeoman 0
3953604 2008337 2008337 defendant Kynvyn Walter smith 650537 650537 Kynvyn, Walter, of Bergevenny, smith 0
3957606 2009720 2009720 defendant William alias Uloyske Thomas tucker 650537 650537 William alias Uloyske, Thomas, of Bergevenny, tucker 0
3961707 2011195 2011195 defendant John Hoskyn Guillam yeoman 650537 650537 John, Hoskyn Guillam, of Bergevenny, yeoman 0
3963645 2011896 2011896 defendant vergh William Margaret widow 650537 650537 vergh William, Margaret, of Bergevenny, widow 0
3963646 2011896 2011896 defendant Lewys Henry husbandman 650537 650537 Lewys, Henry, of Bergevenny, husbandman 1
3963647 2011896 2011896 defendant Griffith Philip husbandman 650537 650537 Griffith, Philip, of Bergevenny, husbandman 2
3970853 2014383 2014383 defendant Meredith John yeoman 650537 650537 Meredith, John, of Bergevenny, yeoman 0
3970890 2014386 2014386 defendant ap Richard Edward chapman 650537 650537 ap Richard, Edward, of Bergevenny, chapman 4
3970891 2014386 2014386 defendant Thomas John shoemaker 650537 650537 Thomas, John, of Bergevenny, shoemaker 5
3975937 2016147 2016147 defendant verch David Jeneta widow 650537 650537 verch David, Jeneta, of Bergevenny, widow 0
3980560 2017812 2017812 defendant ap John William David gent 650537 650537 ap John, William David, of Bergevenny, gent 0
3982021 2018330 2018330 defendant ap Griffith Thomas butcher 650537 650537 ap Griffith, Thomas, of Bergevenny, butcher 0
3982023 2018330 2018330 defendant Phelipp Thomas William yeoman 650537 650537 Phelipp, Thomas William, of Bergevenny, yeoman 2
3982026 2018331 2018331 defendant Griffith John Jenkin David yeoman 650537 650537 Griffith, John Jenkin David, of Bergevenny, yeoman 1
3982027 2018331 2018331 defendant Harrye Philip tucker 650537 650537 Harrye, Philip, of Bergevenny, tucker 2
3985930 2019734 2019734 plaintiff Watkyns Henry gent 650537 650537 Watkyns, Henry, of Bergevenny, gent 0
3995171 2023019 2023019 defendant Corser David Howell shoemaker 650537 650537 Corser, David Howell, of Bergevenny, shoemaker 3
3995172 2023019 2023019 defendant ap Jenkyn John gent 650537 650537 ap Jenkyn, John, of Bergevenny, gent 4
3995174 2023019 2023019 defendant Ivan John shoemaker 650537 650537 Ivan, John, of Bergevenny, shoemaker 6
3995175 2023019 2023019 defendant ap Jenkyn Lewis ap John gent 650537 650537 ap Jenkyn, Lewis ap John, of Bergevenny, gent 7
3995176 2023019 2023019 defendant Lewys Jenkin yeoman 650537 650537 Lewys, Jenkin, of Bergevenny, yeoman 8
3995177 2023019 2023019 defendant Fletcher Griffin fletcher 650537 650537 Fletcher, Griffin, of Bergevenny, fletcher 9
3995178 2023019 2023019 defendant Powell Thomas glover 650537 650537 Powell, Thomas, of Bergevenny, glover 10
4000913 2025097 2025097 defendant Llewellyn James yeoman 650537 650537 Llewellyn, James, of Bergevenny, yeoman 0
4000914 2025097 2025097 defendant Fletcher Griffin yeoman 650537 650537 Fletcher, Griffin, of Bergevenny, yeoman 1
4000915 2025097 2025097 defendant Harbert William gent 650537 650537 Harbert, William, of Bergevenny, gent 2
4000917 2025098 2025098 defendant Llewelyn James yeoman 650537 650537 Llewelyn, James, of Bergevenny, yeoman 0
4000918 2025098 2025098 defendant Fletcher Griffin yeoman 650537 650537 Fletcher, Griffin, of Bergevenny, yeoman 1
4000919 2025098 2025098 defendant Herbert William gent 650537 650537 Herbert, William, of Bergevenny, gent 2
4004546 2026398 2026398 defendant Lewys John William yeoman 650537 650537 Lewys, John William, of Bergevenny, yeoman 0
4006591 2027136 2027136 defendant Edward William butcher 650537 650537 Edward, William, of Bergevenny, butcher 0
4006592 2027136 2027136 defendant Baker William baker 650537 650537 Baker, William, of Bergevenny, baker 1
4006593 2027136 2027136 defendant Vaughan Thomas Watkin yeoman 650537 650537 Vaughan, Thomas Watkin, of Bergevenny, yeoman 2
4006594 2027136 2027136 defendant Lloyd Morgan yeoman 650537 650537 Lloyd, Morgan, of Bergevenny, yeoman 3
4006595 2027136 2027136 defendant ap John John gent 650537 650537 ap John, John, of Bergevenny, gent 4
4011842 2028969 2028969 defendant Meredith John, junior gent 650537 650537 Meredith, John, junior, of Bergevenny, gent 0
4011846 2028970 2028970 defendant Meredith John, junior gent 650537 650537 Meredith, John, junior, of Bergevenny, gent 0
4021113 2032274 2032274 defendant Tanner Richard yeoman 650537 650537 Tanner, Richard, of Bergevenny, yeoman 0
4021121 2032276 2032276 defendant Gor Meredith David gent 650537 650537 Gor, Meredith David, of Bergevenny, gent 0
4022206 2032673 2032673 defendant Gor Meredith David yeoman 650537 650537 Gor, Meredith David, of Bergevenny, yeoman 0
4022207 2032673 2032673 defendant William David yeoman 650537 650537 William, David, of Bergevenny, yeoman 1
4022216 2032675 2032675 defendant Herbert William gent 650537 650537 Herbert, William, of Bergevenny, gent 0
4022217 2032675 2032675 defendant ap Philip George yeoman 650537 650537 ap Philip, George, of Bergevenny, yeoman 1
4022219 2032675 2032675 defendant Thomas Hugh William yeoman 650537 650537 Thomas, Hugh William, of Bergevenny, yeoman 3
4022223 2032676 2032676 defendant Mason Richard Thomas yeoman 650537 650537 Mason, Richard Thomas, of Bergevenny, yeoman 2
4037304 2038006 2038006 defendant William David gent 650537 650537 William, David, of Bergevenny, gent 0
4037318 2038008 2038008 defendant Gor Meredith David gent 650537 650537 Gor, Meredith David, of Bergevenny, gent 0
4041418 2039422 2039422 defendant Bannor John Philip yeoman 650537 650537 Bannor, John Philip, of Bergevenny, yeoman 0
4041419 2039422 2039422 defendant Jenkyn Howell yeoman 650537 650537 Jenkyn, Howell, of Bergevenny, yeoman 1
4053434 2043604 2043604 defendant Lewes John William yeoman 650537 650537 Lewes, John William, of Bergevenny, yeoman 0
4053435 2043604 2043604 defendant ap Howell Hopkyn yeoman 650537 650537 ap Howell, Hopkyn, of Bergevenny, yeoman 1
4053647 2043679 2043679 defendant ap Harry Richard tailor 650537 650537 ap Harry, Richard, of Bergevenny, tailor 0
4060474 2046150 2046150 plaintiff David Richard smith 650537 650537 David, Richard, of Bergevenny, smith 0
4060475 2046150 2046150 defendant Prychard Thomas yeoman 650537 650537 Prychard, Thomas, of Bergevenny, yeoman 0
4065704 2048026 2048026 defendant Tomson William   650537 650537 Tomson, William, of Bergevenny, card maker 0
4065713 2048030 2048030 defendant Lloyd Morgan yeoman 650537 650537 Lloyd, Morgan, of Bergevenny, yeoman 0
4067073 2048522 2048522 defendant Phillipp Richard tanner 650537 650537 Phillipp, Richard, of Bergevenny, tanner 0
4067074 2048522 2048522 defendant William Meredith yeoman 650537 650537 William, Meredith, of Bergevenny, yeoman 1
4067919 2048835 2048835 defendant Gillam David Howell David yeoman 650537 650537 Gillam, David Howell David, of Bergevenny, yeoman 1
4067921 2048836 2048836 defendant ap Rychard Thomas tucker 650537 650537 ap Rychard, Thomas, of Bergevenny, tucker 0
4067922 2048836 2048836 defendant Howell David yeoman 650537 650537 Howell, David, of Bergevenny, yeoman 1
4067923 2048836 2048836 defendant ap Jevan Thomas tucker 650537 650537 ap Jevan, Thomas, of Bergevenny, tucker 2
4069369 2049329 2049329 defendant ap Harry Richard tailor 650537 650537 ap Harry, Richard, of Bergevenny, tailor 0
4069383 2049333 2049333 defendant ap Rees John Thomas tanner 650537 650537 ap Rees, John Thomas, of Bergevenny, tanner 3
4069469 2049362 2049362 defendant Williams Hugh clothier 650537 650537 Williams, Hugh, of Bergevenny, clothier 0
4069470 2049362 2049362 defendant Grenowe John laborer 650537 650537 Grenowe, John, of Bergevenny, laborer 1
4069471 2049362 2049362 defendant ap Rychard Jenetta Thomas spinster 650537 650537 ap Rychard, Jenetta Thomas, of Bergevenny, spinster 2
4069473 2049363 2049363 defendant Williams Hugh clothier 650537 650537 Williams, Hugh, of Bergevenny, clothier 0
4069474 2049363 2049363 defendant Grenowe John laborer 650537 650537 Grenowe, John, of Bergevenny, laborer 1
4069475 2049363 2049363 defendant ap Rychard Jenetta Thomas spinster 650537 650537 ap Rychard, Jenetta Thomas, of Bergevenny, spinster 2
4074013 2050996 2050996 defendant Lewys David tucker 650537 650537 Lewys, David, of Bergevenny, tucker 0
4078788 2052708 2052708 defendant Tucker Watkin William tucker 650537 650537 Tucker, Watkin William, of Bergevenny, tucker 0
4079484 2052961 2052961 defendant William Jenkin (legal representative) 650537 650537 William, Jenkin, of Bergevenny, weaver, executrix of 0
4079485 2052961 2052961 defendant verch Jevan Margaret widow 650537 650537 verch Jevan, Margaret, of Bergevenny, widow 1
4080613 2053381 2053381 defendant Phillipp alias Gwayth Jenkin weaver 650537 650537 Phillipp alias Gwayth, Jenkin, of Bergevenny, weaver 0
4080614 2053381 2053381 defendant Lloyd Lewis   650537 650537 Lloyd, Lewis, of Bergevenny, administrators of 1
4082892 2054181 2054181 defendant ap Howell Hopkin yeoman 650537 650537 ap Howell, Hopkin, of Bergevenny, yeoman 0
4096107 2058935 2058935 defendant Tucker John Lewis tucker 650537 650537 Tucker, John Lewis, of Bergevenny, tucker 0
4096108 2058935 2058935 defendant Lawrence Roger weaver 650537 650537 Lawrence, Roger, of Bergevenny, weaver 1
4096109 2058935 2058935 defendant Howell Henry yeoman 650537 650537 Howell, Henry, of Bergevenny, yeoman 2
4102461 2061178 2061178 defendant ap Rychard Howell carpenter 650537 650537 ap Rychard, Howell, of Bergevenny, carpenter 3
4102462 2061178 2061178 defendant ap John John cordwainer 650537 650537 ap John, John, of Bergevenny, cordwainer 4
4102463 2061178 2061178 defendant Rycard alias Mason David yeoman 650537 650537 Rycard alias Mason, David, of Bergevenny, yeoman 5
4102464 2061178 2061178 defendant Taylor Howell John yeoman 650537 650537 Taylor, Howell John, of Bergevenny, yeoman 6
4102465 2061178 2061178 defendant Watkyn David William yeoman 650537 650537 Watkyn, David William, of Bergevenny, yeoman 7
4104608 2061928 2061928 defendant Apowell William yeoman 650537 650537 Apowell, William, of Bergevenny, yeoman 0
4105755 2062347 2062347 defendant Lloyd Morgan yeoman 650537 650537 Lloyd, Morgan, of Bergevenny, yeoman 0
4110316 2063950 2063950 defendant Powell Thomas gent 650537 650537 Powell, Thomas, of Bergevenny, gent 0
4114194 2065360 2065360 defendant Lewys David yeoman 650537 650537 Lewys, David, of Bergevenny, yeoman 0
4116134 2066064 2066064 defendant Watkyn Howell cordwainer 650537 650537 Watkyn, Howell, of Bergevenny, cordwainer 0
4117371 2066513 2066513 defendant Baker Jenkin yeoman 650537 650537 Baker, Jenkin, of Bergevenny, yeoman 0
4117372 2066513 2066513 defendant Howell Henry yeoman 650537 650537 Howell, Henry, of Bergevenny, yeoman 1
4124843 2069176 2069176 defendant David Richard smith 650537 650537 David, Richard, of Bergevenny, smith 2
4131829 2071698 2071698 defendant ap Jevan John weaver 650537 650537 ap Jevan, John, of Bergevenny, weaver 1
4131830 2071698 2071698 defendant Lluwellen William laborer 650537 650537 Lluwellen, William, of Bergevenny, laborer 2
4142619 2075586 2075586 defendant Watkyn George yeoman 650537 650537 Watkyn, George, of Bergevenny, yeoman 0
4155468 2080000 2080000 defendant Lloyd Watkin Lewys yeoman 650537 650537 Lloyd, Watkin Lewys, of Bergevenny, yeoman 1

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