names

81 rows where place_id = 601480

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3645549 1909005 1909005 defendant Delahaye Brian or Urian gent 601480 601480 Delahaye, Brian or Urian, of Peterchurche, gent 0
3855710 1975421 1975421 defendant Hunt Walter yeoman 601480 601480 Hunt, Walter, of Peterchurche, yeoman 0
3890844 1987205 1987205 defendant ap Jenkyn John Thomas David yeoman 601480 601480 ap Jenkyn, John Thomas David, of Peterchurche, yeoman 1
3897122 1989254 1989254 defendant Vaghan Thomas gent 601480 601480 Vaghan, Thomas, of Peterchurche, gent 0
3900709 1990466 1990466 defendant ap Robert Richard husbandman 601480 601480 ap Robert, Richard, of Peterchurche, husbandman 1
3925209 1998742 1998742 defendant Urrye Thomas gent 601480 601480 Urrye, Thomas, of Peterchurche, gent 0
3948635 2006581 2006581 defendant Jeffrey Richard yeoman 601480 601480 Jeffrey, Richard, of Peterchurche, yeoman 0
3949150 2006767 2006767 defendant Delahay Richard Ury gent 601480 601480 Delahay, Richard Ury, of Peterchurche, gent 2
3956966 2009501 2009501 defendant Kynvyll John clerk 601480 601480 Kynvyll, John, of Peterchurche, clerk 0
4016987 2030777 2030777 defendant Jenkyn Philip yeoman 601480 601480 Jenkyn, Philip, of Peterchurche, yeoman 0
4020958 2032225 2032225 defendant Vaughan Katherine widow 601480 601480 Vaughan, Katherine, of Peterchurche, widow 1
4022963 2032933 2032933 defendant Gytto James husbandman 601480 601480 Gytto, James, of Peterchurche, husbandman 0
4032434 2036252 2036252 defendant Jenkyn Philip yeoman 601480 601480 Jenkyn, Philip, of Peterchurche, yeoman 10
4036746 2037829 2037829 defendant ap Thomas Richard yeoman 601480 601480 ap Thomas, Richard, of Peterchurche, yeoman 1
4036749 2037830 2037830 defendant ap Thomas Richard yeoman 601480 601480 ap Thomas, Richard, of Peterchurche, yeoman 1
4042456 2039781 2039781 defendant Gytto James yeoman 601480 601480 Gytto, James, of Peterchurche, yeoman 7
4054274 2043918 2043918 defendant Smyth John smith 601480 601480 Smyth, John, of Peterchurche, smith 0
4063182 2047131 2047131 defendant Wynston Roger gent 601480 601480 Wynston, Roger, of Peterchurche, gent 1
4063183 2047131 2047131 defendant Nyccoll Philip yeoman 601480 601480 together with Nyccoll, Philip, of Peterchurche, yeoman 2
4063184 2047131 2047131 defendant Parry Thomas gent 601480 601480 Parry, Thomas, of Peterchurche, gent 3
4063187 2047132 2047132 defendant Nyccoll Philip yeoman 601480 601480 Nyccoll, Philip, of Peterchurche, yeoman 0
4063188 2047132 2047132 defendant Parry Thomas gent 601480 601480 Parry, Thomas, of Peterchurche, gent 1
4063190 2047132 2047132 defendant Wynston Roger gent 601480 601480 Wynston, Roger, of Peterchurche, gent 3
4067026 2048504 2048504 defendant Parry Thomas William husbandman 601480 601480 Parry, Thomas William, of Peterchurche, husbandman 1
4067718 2048766 2048766 defendant Jenkyn Philip yeoman 601480 601480 Jenkyn, Philip, of Peterchurche, yeoman 1
4067862 2048816 2048816 defendant Ball John husbandman 601480 601480 Ball, John, of Peterchurche, husbandman 1
4067863 2048816 2048816 defendant Gytto William yeoman 601480 601480 Gytto, William, of Peterchurche, yeoman 2
4072688 2050529 2050529 defendant Hunt Thomas Myles yeoman 601480 601480 Hunt, Thomas Myles, of Peterchurche, yeoman 0
4073278 2050734 2050734 defendant ap Jevan Elizabeth widow 601480 601480 ap Jevan, Elizabeth, of Peterchurche, widow 0
4073279 2050734 2050734 defendant ap Jevan George laborer 601480 601480 ap Jevan, George, of Peterchurche, laborer 1
4073287 2050736 2050736 defendant ap Jevan George laborer 601480 601480 ap Jevan, George, of Peterchurche, laborer 2
4080632 2053387 2053387 defendant Parry Thomas yeoman or gent 601480 601480 Parry, Thomas, of Peterchurche, yeoman or gent 0
4080940 2053496 2053496 defendant Mylehunt Thomas gent 601480 601480 Mylehunt, Thomas, of Peterchurche, gent 0
4080942 2053497 2053497 defendant Vaughan William gent 601480 601480 Vaughan, William, of Peterchurche, gent 0
4080953 2053501 2053501 defendant Delahaye Richard gent 601480 601480 Delahaye, Richard, of Peterchurche, gent 0
4080955 2053502 2053502 defendant Hunt Rice gent 601480 601480 Hunt, Rice, of Peterchurche, gent 0
4083059 2054235 2054235 defendant Taylor William husbandman 601480 601480 Taylor, William, of Peterchurche, husbandman 0
4083060 2054235 2054235 defendant Powell Richard   601480 601480 Powell, Richard, of Peterchurche 1
4083062 2054236 2054236 defendant Taylor William husbandman 601480 601480 Taylor, William, of Peterchurche, husbandman 0
4083063 2054236 2054236 defendant Powell Richard husbandman 601480 601480 Powell, Richard, of Peterchurche, husbandman 1
4084333 2054666 2054666 defendant Apparrye Thomas gent 601480 601480 Apparrye, Thomas, of Peterchurche, gent 0
4085374 2055047 2055047 defendant Pryse James yeoman 601480 601480 Pryse, James, of Peterchurche, yeoman 2
4085380 2055048 2055048 defendant Pryse James yeoman 601480 601480 Pryse, James, of Peterchurche, yeoman 2
4097117 2059291 2059291 defendant Hunt Thomas Miles gent 601480 601480 Hunt, Thomas Miles, of Peterchurche, gent 0
4098345 2059735 2059735 defendant Vaughan William gent 601480 601480 Vaughan, William, of Peterchurche, gent 1
4098350 2059736 2059736 defendant Vaughan William gent 601480 601480 Vaughan, William, of Peterchurche, gent 1
4101202 2060740 2060740 defendant ap Pryce James gent 601480 601480 ap Pryce, James, of Peterchurche, gent 0
4101206 2060741 2060741 defendant ap Pryce James husbandman 601480 601480 ap Pryce, James, of Peterchurche, husbandman 0
4101221 2060745 2060745 defendant de la Hay Richard gent 601480 601480 de la Hay, Richard, of Peterchurche, gent 2
4102852 2061313 2061313 defendant Morgan Rice William husbandman 601480 601480 Morgan, Rice William, of Peterchurche, husbandman 2
4102853 2061313 2061313 defendant Thomas Jevan husbandman 601480 601480 Thomas, Jevan, of Peterchurche, husbandman 3
4104611 2061930 2061930 defendant Parry Thomas Gillam yeoman 601480 601480 Parry, Thomas Gillam, of Peterchurche, yeoman 0
4104997 2062061 2062061 defendant Morgan Rice Gwyn laborer 601480 601480 Morgan, Rice Gwyn, of Peterchurche, laborer 0
4104998 2062061 2062061 defendant ap Rees John butcher 601480 601480 ap Rees, John, of Peterchurche, butcher 1
4104999 2062061 2062061 defendant Wynston Roger gent 601480 601480 Wynston, Roger, of Peterchurche, gent 2
4108375 2063251 2063251 defendant Watkyn Miles John yeoman 601480 601480 Watkyn, Miles John, of Peterchurche, yeoman 1
4108379 2063252 2063252 defendant Watkyn Miles John yeoman 601480 601480 Watkyn, Miles John, of Peterchurche, yeoman 1
4114162 2065346 2065346 defendant Philip alias Godwaye Thomas yeoman 601480 601480 Philip alias Godwaye, Thomas, of Peterchurche, yeoman 1
4118188 2066790 2066790 defendant ap Powell Thomas miller 601480 601480 ap Powell, Thomas, of Peterchurche, miller 0
4118770 2066994 2066994 defendant Vaughan William gent 601480 601480 Vaughan, William, of Peterchurche, gent 2
4118771 2066994 2066994 defendant Delahaye Richard gent 601480 601480 Delahaye, Richard, of Peterchurche, gent 3
4133425 2072281 2072281 defendant Smythe John blacksmith 601480 601480 Smythe, John, of Peterchurche, blacksmith 0
4135337 2072960 2072960 defendant Thomas Richard yeoman 601480 601480 Thomas, Richard, of Peterchurche, yeoman 0
4135338 2072960 2072960 defendant Lluwellen Philip husbandman 601480 601480 Lluwellen, Philip, of Peterchurche, husbandman 1
4138951 2074301 2074301 defendant Watkyn Miles John husbandman 601480 601480 Watkyn, Miles John, of Peterchurche, husbandman 0
4159008 2081219 2081219 defendant Thomas Howell laborer 601480 601480 Thomas, Howell, of Peterchurche, laborer 0
4167498 2084129 2084129 defendant Nicoll Philip yeoman 601480 601480 Nicoll, Philip, of Peterchurche, or of Llanveyno, yeoman 2
4167499 2084129 2084129 defendant Thomas Howell yeoman 601480 601480 Thomas, Howell, of Peterchurche, yeoman 3
4180168 2088544 2088544 defendant Richard Henry walker 601480 601480 Richard, Henry, of Peterchurche, walker 0
4217475 2101605 2101605 defendant Jenkyn Philip husbandman 601480 601480 Jenkyn, Philip, of Peterchurche, husbandman 2
4226664 2104799 2104799 defendant Jenkyn John husbandman 601480 601480 Jenkyn, John, of Peterchurche, husbandman 2
4235894 2108127 2108127 defendant Philips Thomas yeoman 601480 601480 Philips, Thomas, of Peterchurche, yeoman 0
4240970 2109963 2109963 defendant Mylehunt Thomas gent 601480 601480 Mylehunt, Thomas, of Peterchurche, gent 2
4326469 2139215 2139215 defendant Richard John husbandman 601480 601480 Richard, John, of Peterchurche, husbandman 0
4334379 2141776 2141776 defendant Thomas John Richard yeoman 601480 601480 Thomas, John Richard, of Peterchurche, or of Newton, yeoman 0
4371569 2154886 2154886 defendant ap Price James yeoman 601480 601480 ap Price, James, of Peterchurche, yeoman 0
4374192 2155843 2155843 defendant Meredethe William David yeoman 601480 601480 Meredethe, William David, of Peterchurche, yeoman 2
4394519 2162762 2162762 defendant Powell Thomas yeoman 601480 601480 Powell, Thomas, of Peterchurche, yeoman 2
4404221 2165982 2165982 defendant Andrewes or Androse William yeoman 601480 601480 Andrewes or Androse, William, of Peterchurche, yeoman 0
4404268 2165999 2165999 defendant Andrewes or Androse Wiliam yeoman 601480 601480 Andrewes or Androse, Wiliam, of Peterchurche, yeoman 0
4412715 2168845 2168845 defendant Smythe John husbandman 601480 601480 Smythe, John, of Peterchurche, 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);