names

160 rows where place_id = 641901

✎ 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
3662221 1914101 1914101 defendant (not given) Walter vicar of Pyers 641901 641901 Pyers, Walter, of Uske, perpetual vicar of the church of the Blessed Mary 1
3864537 1978338 1978338 defendant ap Gwillam William Thomas Llewellan   641901 641901 ap Gwillam, William Thomas Llewellan, of Uske, burgess 1
3864538 1978338 1978338 defendant Daker Thomas yeoman 641901 641901 Daker, Thomas, of Uske, yeoman 2
3864540 1978339 1978339 defendant ap Yoroth Edward John David yeoman 641901 641901 ap Yoroth, Edward John David, of Uske, yeoman 0
3864541 1978339 1978339 defendant Gryffyth Hugh yeoman 641901 641901 Gryffyth, Hugh, of Uske, yeoman 1
3864542 1978339 1978339 defendant Hughe Maurice yeoman 641901 641901 Hughe, Maurice, of Uske, yeoman 2
3864548 1978341 1978341 defendant Johns William gent 641901 641901 Johns, William, of USke, gent 1
3884711 1985162 1985162 defendant Hughes Maurice   641901 641901 Hughes, Maurice, of Uske 0
3894497 1988367 1988367 defendant Hughes Maurice gent 641901 641901 Hughes, Maurice, of Uske, gent 0
3906749 1992551 1992551 defendant ap Yeroth Thomas David yeoman 641901 641901 ap Yeroth, Thomas David, of Uske, yeoman 0
3906750 1992551 1992551 defendant Yeroth Gllm Thomas yeoman 641901 641901 Yeroth, Gllm Thomas, of Uske, yeoman 1
3906751 1992551 1992551 defendant Rychard Henry John laborer 641901 641901 Rychard, Henry John, of Uske, laborer 2
3906752 1992551 1992551 defendant Lauraunce John laborer 641901 641901 Lauraunce, John, of Uske, laborer 3
3948571 2006561 2006561 defendant John William husbandman 641901 641901 John, William, of Uske, husbandman 0
3948572 2006561 2006561 defendant John David husbandman 641901 641901 John, David, of Uske, husbandman 1
3948573 2006561 2006561 defendant ap Jenkyn John husbandman 641901 641901 ap Jenkyn, John, of Uske, husbandman 2
3948626 2006579 2006579 defendant Edward Maurice husbandman 641901 641901 Edward, Maurice, of Uske, husbandman 0
3948627 2006579 2006579 defendant William Gwenlliana widow 641901 641901 William, Gwenlliana, of Uske, widow 1
3948628 2006579 2006579 defendant Edward Howel yeoman 641901 641901 Edward, Howel, of Uske, yeoman 2
3948629 2006579 2006579 defendant Tanner Philip yeoman 641901 641901 Tanner, Philip, of Uske, yeoman 3
3948630 2006579 2006579 defendant Watkyn John Thomas yeoman 641901 641901 Watkyn, John Thomas, of Uske, yeoman 4
3948631 2006579 2006579 defendant Sare Thomas William John yeoman 641901 641901 Sare, Thomas William John, of Uske, yeoman 5
3950733 2007331 2007331 defendant Jamys Howel William yeoman 641901 641901 Jamys, Howel William, of Uske, yeoman 0
3950734 2007331 2007331 defendant Gryffyth William shoemaker 641901 641901 Gryffyth, William, of Uske, shoemaker 1
3953679 2008364 2008364 defendant Philipp alias Ewyn William gent 641901 641901 Philipp alias Ewyn, William, of Uske, gent 0
3962851 2011599 2011599 plaintiff Williams Walter gent 641901 641901 Williams, Walter, of Uske, gent 0
3974590 2015677 2015677 defendant Edward Howell yeoman 641901 641901 Edward, Howell, of Uske, yeoman 5
3975324 2015937 2015937 defendant ap Morgan John tanner 641901 641901 ap Morgan, John, of Uske, tanner 0
3980902 2017931 2017931 defendant ap John John yeoman 641901 641901 ap John, John, of Uske, yeoman 0
3982000 2018325 2018325 defendant Lawrens Thomas yeoman 641901 641901 Lawrens, Thomas, of Uske, yeoman 2
3985926 2019732 2019732 plaintiff Watkyn William gent 641901 641901 Watkyn, William, of Uske, gent 0
3985927 2019732 2019732 defendant ap Gillam or William William Thomas Llewellen yeoman 641901 641901 ap Gillam or William, William Thomas Llewellen, of Uske, yeoman 0
3985928 2019733 2019733 plaintiff Watkyn William gent 641901 641901 Watkyn, William, of Uske, gent 0
3988290 2020559 2020559 defendant Jeyne Reginald William gent 641901 641901 Jeyne, Reginald William, of Uske, gent 0
3988428 2020604 2020604 defendant Ryce Roger carpenter 641901 641901 Ryce, Roger, of Uske, carpenter 2
3999999 2024764 2024764 defendant Thomas Reginald William yeoman 641901 641901 Thomas, Reginald William, of Uske, yeoman 1
4005650 2026795 2026795 defendant Hughes Walter gent 641901 641901 Hughes, Walter, of Uske, gent 3
4011864 2028973 2028973 defendant Hopkyn John William John, senior weaver 641901 641901 Hopkyn, John William John, senior, of Uske, weaver 4
4011865 2028973 2028973 defendant Hopkyn John William John, junior weaver 641901 641901 Hopkyn, John William John, junior, of Uske, weaver 5
4011871 2028974 2028974 defendant Hopkyn John William John, senior weaver 641901 641901 Hopkyn, John William John, senior, of Uske, weaver: Hopkyn, John William John, junior, of Uske, weaver 4
4012025 2029030 2029030 defendant Gryffyth Nicholas William yeoman 641901 641901 Gryffyth, Nicholas William, of Uske, yeoman 1
4012026 2029030 2029030 defendant Thomas Reginald William yeoman 641901 641901 Thomas, Reginald William, of Uske, yeoman 2
4020429 2032030 2032030 plaintiff William Nicholas cordwainer 641901 641901 William, Nicholas, of Uske, cordwainer 0
4020430 2032030 2032030 defendant Jones Thomas gent 641901 641901 Jones, Thomas, of Uske, gent 0
4020431 2032030 2032030 defendant Philip William weaver 641901 641901 Philip, William, of Uske, weaver 1
4034431 2036986 2036986 defendant ap John John yeoman 641901 641901 ap John, John, of Uske, yeoman 0
4038815 2038504 2038504 defendant Williams Reginald gent 641901 641901 Williams, Reginald, of Uske, gent 0
4040900 2039235 2039235 defendant John Reginald yeoman 641901 641901 John, Reginald, of Uske, yeoman 0
4040901 2039235 2039235 defendant Philip Maurice husbandman 641901 641901 Philip, Maurice, of Uske, husbandman 1
4043778 2040230 2040230 defendant Gryffythe Nicholas William yeoman 641901 641901 Gryffythe, Nicholas William, of Uske, yeoman 1
4045221 2040748 2040748 plaintiff Rumsey John   641901 641901 Rumsey, John, of Uske 0
4045226 2040749 2040749 plaintiff Rumsey John   641901 641901 Rumsey, John, of Uske 0
4045454 2040825 2040825 plaintiff Saer or Sayer Thomas William John yeoman 641901 641901 Saer or Sayer, Thomas William John, of Uske, yeoman 0
4045630 2040890 2040890 plaintiff Sayer Thomas William John yeoman 641901 641901 Sayer, Thomas William John, of Uske, yeoman 0
4065117 2047809 2047809 defendant William Thomas yeoman 641901 641901 William, Thomas, of Uske, yeoman 6
4065133 2047815 2047815 defendant Adam John Harry yeoman 641901 641901 Adam, John Harry, of Uske, yeoman 1
4065696 2048022 2048022 defendant Probert Thomas gent 641901 641901 Probert, Thomas, of Uske, gent 1
4069480 2049365 2049365 defendant Apowell James gent 641901 641901 Apowell, James, of Uske, gent 1
4071376 2050061 2050061 defendant ap Jevan Sander yeoman 641901 641901 ap Jevan, Sander, of Uske, yeoman 0
4071925 2050258 2050258 defendant Jenkyn John tanner 641901 641901 Jenkyn, John, of Uske, tanner 0
4072704 2050533 2050533 defendant Wyllymn alias Baker Edmund John baker 641901 641901 Wyllymn alias Baker, Edmund John, of Uske, baker 0
4072706 2050534 2050534 defendant Wylyn alias Baker Edmund John baker 641901 641901 Wylyn alias Baker, Edmund John, of Uske, baker 0
4078766 2052702 2052702 defendant Edward Maurice tanner 641901 641901 Edward, Maurice, of Uske, tanner 0
4078767 2052702 2052702 defendant Moryce Thomas yeoman 641901 641901 Moryce, Thomas, of Uske, yeoman 1
4078768 2052702 2052702 defendant David Philip tanner 641901 641901 David, Philip, of Uske, tanner 2
4078769 2052702 2052702 defendant Howell Morgan tanner 641901 641901 Howell, Morgan, of Uske, tanner 3
4078770 2052702 2052702 defendant David Giles laborer 641901 641901 David, Giles, of Uske, laborer 4
4086223 2055347 2055347 defendant Morys Anne widow 641901 641901 Morys, Anne, of Uske, widow 1
4092894 2057770 2057770 defendant Thomas Reginald William yeoman 641901 641901 Thomas, Reginald William, of Uske, yeoman 1
4093111 2057855 2057855 defendant ap John John yeoman 641901 641901 ap John, John, of Uske, yeoman 0
4093114 2057855 2057855 defendant Baker Edmund baker 641901 641901 Baker, Edmund, of Uske, baker 3
4093115 2057855 2057855 defendant Reynold Thomas yeoman 641901 641901 Reynold, Thomas, of Uske, yeoman 4
4093116 2057855 2057855 defendant Hughe William Morys yeoman 641901 641901 Hughe, William Morys, of Uske, yeoman 5
4093117 2057855 2057855 defendant Pembroke Richard husbandman 641901 641901 Pembroke, Richard, of Uske, husbandman 6
4095138 2058590 2058590 defendant William Thomas John yeoman 641901 641901 William, Thomas John, of Uske, yeoman 2
4097205 2059321 2059321 defendant Rosser Rithergh yeoman 641901 641901 Rosser, Rithergh, of Uske, yeoman 1
4104627 2061937 2061937 defendant Base alias David Roger laborer 641901 641901 Base alias David, Roger, of Uske, laborer 1
4104629 2061937 2061937 defendant Edward Howell yeoman 641901 641901 Edward, Howell, of Uske, yeoman 3
4107947 2063116 2063116 defendant Gryffyth Rice yeoman 641901 641901 Gryffyth, Rice, of Uske, yeoman 1
4107952 2063117 2063117 defendant Smyth Jenkin smith 641901 641901 Smyth, Jenkin, of Uske, smith 3
4108215 2063204 2063204 defendant Jones Thomas gent 641901 641901 Jones, Thomas, of Uske, gent 0
4130707 2071292 2071292 defendant Hughe Reginald yeoman 641901 641901 Hughe, Reginald, of Uske, yeoman 0
4130712 2071294 2071294 defendant Rynold William (legal representative) 641901 641901 Rynold, William, of Uske, executrix of 1
4130713 2071294 2071294 defendant Herbert Mary widow 641901 641901 Herbert, Mary, of Uske, widow 2
4130715 2071295 2071295 defendant Hughe Reginald yeoman 641901 641901 Hughe, Reginald, of Uske, yeoman 0
4130717 2071296 2071296 defendant Powell John yeoman 641901 641901 Powell, John, of Uske, yeoman 0
4130719 2071297 2071297 defendant Powell John yeoman 641901 641901 Powell, John, of Uske, yeoman 0
4133180 2072191 2072191 defendant Jeyne John Edward yeoman 641901 641901 Jeyne, John Edward, of Uske, yeoman 0
4138946 2074300 2074300 defendant Thomas Thomas John shoemaker 641901 641901 Thomas, Thomas John, of Uske, shoemaker 0
4138947 2074300 2074300 defendant Taylor James William tailor 641901 641901 Taylor, James William, of Uske, tailor 1
4138948 2074300 2074300 defendant Goche William John yeoman 641901 641901 Goche, William John, of Uske, yeoman 2
4138949 2074300 2074300 defendant Gyles Roger tanner 641901 641901 Gyles, Roger, of Uske, tanner 3
4141097 2075045 2075045 defendant ap Adam John yeoman 641901 641901 ap Adam, John, of Uske, yeoman 2
4141113 2075051 2075051 defendant Hughe Reginald gent 641901 641901 Hughe, Reginald, of Uske, gent 0
4141114 2075051 2075051 defendant Morgan William yeoman 641901 641901 Morgan, William, of Uske, yeoman 1
4142067 2075398 2075398 defendant William Charles yeoman 641901 641901 William, Charles, of Uske, yeoman 2
4148086 2077461 2077461 defendant Baker Edmund baker 641901 641901 Baker, Edmund, of Uske, baker 0
4151830 2078752 2078752 defendant Hopkyn Howell yeoman 641901 641901 Hopkyn, Howell, of Uske, yeoman 2
4153350 2079270 2079270 defendant Myller David miller 641901 641901 Myller, David, of Uske, miller 1
4153351 2079270 2079270 defendant Hawkyn Howell yeoman 641901 641901 Hawkyn, Howell, of Uske, yeoman 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);