names

150 rows where place_id = 646648

✎ 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
3803361 1958950 1958950 defendant Turner John husbandman 646648 646648 Turner, John, of Clyfford Chamberer, husbandman 0
3892170 1987636 1987636 defendant Dogan Robert ap Rees yeoman 646648 646648 Dogan, Robert ap Rees, of Clyfford, yeoman 1
3911532 1994174 1994174 defendant ap Jenn William ap Rees ap Thomas husbandman 646648 646648 ap Jenn, William ap Rees ap Thomas, of Clyfford, husbandman 1
3912657 1994568 1994568 defendant ap John Thomas John husbandman 646648 646648 ap John, Thomas John, of Clyfford, husbandman 0
3912659 1994568 1994568 defendant Water John ap Roger husbandman 646648 646648 Water, John ap Roger, of Clyfford, husbandman 2
3912660 1994568 1994568 defendant ap Ryce William tailor 646648 646648 ap Ryce, William, of Clyfford, tailor 3
3912661 1994568 1994568 defendant Morys John husbandman 646648 646648 Morys, John, of Clyfford, husbandman 4
3912662 1994568 1994568 defendant Hyggyn Walter John laborer 646648 646648 Hyggyn, Walter John, of Clyfford, laborer 5
3925215 1998744 1998744 defendant Whytney Thomas gent 646648 646648 Whytney, Thomas, of Clyfford, gent 0
3927353 1999493 1999493 defendant ap Parry Simon yeoman 646648 646648 ap Parry, Simon, of Clyfford, yeoman 0
3927354 1999493 1999493 defendant ap John Nycoll Griffith husbandman 646648 646648 ap John Nycoll, Griffith, of Clyfford, husbandman 1
3942067 2004362 2004362 defendant Whytney James gent 646648 646648 Whytney, James, of Clyfford, gent 0
3956477 2009330 2009330 defendant Thomas Robert husbandman 646648 646648 Thomas, Robert, of Clyfford, husbandman 0
3989211 2020881 2020881 defendant Taylor Robert yeoman 646648 646648 Taylor, Robert, of Clyfford, or of Bredwardyn, yeoman 0
3989214 2020882 2020882 defendant Taylor Robert yeoman 646648 646648 Taylor, Robert, of Clyfford, or of Bredwardyn, yeoman 0
4018489 2031346 2031346 defendant Vaughan Robert yeoman 646648 646648 Vaughan, Robert, of Clyfford, yeoman 0
4020283 2031976 2031976 defendant Roo Richard yeoman 646648 646648 Roo, Richard, of Clyfford, yeoman 0
4020284 2031976 2031976 defendant David Lewis ap Jevan yeoman 646648 646648 David, Lewis ap Jevan, of Clyfford, yeoman 1
4020285 2031976 2031976 defendant ap Hughe William yeoman 646648 646648 ap Hughe, William, of Clyfford, yeoman 2
4030478 2035556 2035556 defendant William Edward   646648 646648 William, Edward, of Clyfford, surgeon 1
4034470 2036998 2036998 defendant Hughe Lewis John yeoman 646648 646648 Hughe, Lewis John, of Clyfford, yeoman 0
4034472 2036999 2036999 defendant Hughe Lewis Johon yeoman 646648 646648 Hughe, Lewis Johon, of Clyfford, yeoman 0
4042458 2039781 2039781 defendant Roo Richard yeoman 646648 646648 Roo, Richard, of Clyfford, yeoman 9
4042472 2039782 2039782 defendant Roo Richard yeoman 646648 646648 Roo, Richard, of Clyfford, yeoman 9
4042481 2039783 2039783 defendant Powell Adam yeoman 646648 646648 Powell, Adam, of Clyfford, yeoman 4
4042494 2039784 2039784 defendant Powell Adam yeoman 646648 646648 Powell, Adam, of Clyfford, yeoman 4
4051231 2042880 2042880 defendant Roo Richard yeoman 646648 646648 Roo, Richard, of Clyfford, yeoman 0
4051232 2042880 2042880 defendant Hughes William yeoman 646648 646648 Hughes, William, of Clyfford, yeoman 1
4051234 2042881 2042881 defendant Roo Richard yeoman 646648 646648 Roo, Richard, of Clyfford, yeoman 0
4051235 2042881 2042881 defendant Hughes William yeoman 646648 646648 Hughes, William, of Clyfford, yeoman 1
4051236 2042882 2042882 plaintiff Whytney Eustace gent 646648 646648 Whytney, Eustace, of Clyfford, gent 0
4051239 2042883 2042883 plaintiff Whytney Eustace gent 646648 646648 Whytney, Eustace, of Clyfford, gent 0
4051242 2042884 2042884 plaintiff Whytney Eustace gent 646648 646648 Whytney, Eustace, of Clyfford, gent 0
4053538 2043640 2043640 defendant Reene or Reeve John ap Jevan ap Howell yeoman 646648 646648 Reene or Reeve, John ap Jevan ap Howell, of Clyfford, yeoman 0
4053540 2043641 2043641 defendant Reene or Reeve John ap Jevan ap Howell yeoman 646648 646648 Reene or Reeve, John ap Jevan ap Howell, of Clyfford, yeoman 0
4067336 2048620 2048620 defendant Willyams Jenkin walker 646648 646648 Willyams, Jenkin, of Clyfford, walker 1
4070832 2049865 2049865 defendant ap Jevan John yeoman 646648 646648 ap Jevan, John, of Clyfford, yeoman 0
4071016 2049934 2049934 defendant Williams Thomas yeoman 646648 646648 Williams, Thomas, of Clyfford, yeoman 0
4071017 2049934 2049934 defendant ap Jevan John yeoman 646648 646648 ap Jevan, John, of Clyfford, yeoman 1
4071018 2049934 2049934 defendant Hyggyns Richard yeoman 646648 646648 Hyggyns, Richard, of Clyfford, yeoman 2
4081680 2053750 2053750 defendant Gorwey Anthony husbandman 646648 646648 Gorwey, Anthony, of Clyfford, husbandman 0
4103943 2061685 2061685 defendant Whytney James gent 646648 646648 Whytney, James, of Clyfford, gent 2
4103955 2061688 2061688 defendant Whytney James gent 646648 646648 Whytney, James, of Clyfford, gent 1
4108374 2063251 2063251 defendant Madye Lewis William yeoman 646648 646648 Madye, Lewis William, of Clyfford, yeoman 0
4108378 2063252 2063252 defendant Madye Lewis William yeoman 646648 646648 Madye, Lewis William, of Clyfford, yeoman 0
4117411 2066524 2066524 defendant William Joan John widow 646648 646648 William, Joan John, of Clyfford, widow 1
4119589 2067294 2067294 defendant Hughe Lewis John yeoman 646648 646648 Hughe, Lewis John, of Clyfford, yeoman 2
4119590 2067294 2067294 defendant Lewes David yeoman 646648 646648 Lewes, David, of Clyfford, yeoman 3
4140260 2074760 2074760 defendant Lewys David yeoman 646648 646648 Lewys, David, of Clyfford, yeoman 1
4141080 2075040 2075040 defendant Philip Thomas John yeoman 646648 646648 Philip, Thomas John, of Clyfford, yeoman 0
4142585 2075575 2075575 defendant Harper John husbandman 646648 646648 Harper, John, of Clyfford, husbandman 1
4142586 2075575 2075575 defendant ap Rees Watkin Thomas husbandman 646648 646648 ap Rees, Watkin Thomas, of Clyfford, husbandman 2
4142587 2075575 2075575 defendant Philip Robert husbandman 646648 646648 Philip, Robert, of Clyfford, husbandman 3
4142589 2075576 2075576 defendant ap Owen Walter husbandman 646648 646648 ap Owen, Walter, of Clyfford, husbandman 0
4142590 2075576 2075576 defendant Harper John husbandman 646648 646648 Harper, John, of Clyfford, husbandman 1
4142591 2075576 2075576 defendant ap Rees Watkin Thomas husbandman 646648 646648 ap Rees, Watkin Thomas, of Clyfford, husbandman 2
4142592 2075576 2075576 defendant Philip Robert husbandman 646648 646648 Philip, Robert, of Clyfford, husbandman 3
4159642 2081440 2081440 defendant Whytney James gent 646648 646648 Whytney, James, of Clyfford, gent 1
4159881 2081523 2081523 defendant Harper John yeoman 646648 646648 Harper, John, of Clyfford, yeoman 0
4159885 2081524 2081524 defendant Harper John yeoman 646648 646648 Harper, John, of Clyfford, yeoman 0
4164564 2083115 2083115 defendant Whytney Thomas gent 646648 646648 Whytney, Thomas, of Clyfford, gent 1
4164565 2083115 2083115 defendant Watkyn Howell gent 646648 646648 Watkyn, Howell, of Clyfford, gent 2
4165099 2083300 2083300 defendant Lewes David husbandman 646648 646648 Lewes, David, of Clyfford, husbandman 2
4165890 2083570 2083570 defendant Philip Thomas John yeoman 646648 646648 Philip, Thomas John, of Clyfford, yeoman 0
4166921 2083927 2083927 defendant ap David Hugh laborer 646648 646648 ap David, Hugh, of Clyfford, laborer 4
4167473 2084122 2084122 defendant ap Adam James husbandman 646648 646648 ap Adam, James, of Clyfford, husbandman 1
4167474 2084122 2084122 defendant Sante Ellen widow 646648 646648 Sante, Ellen, of Clyfford, widow 2
4176619 2087297 2087297 defendant Knyght Thomas husbandman 646648 646648 Knyght, Thomas, of Clyfford, husbandman 0
4180779 2088757 2088757 defendant Hughe Lewis John yeoman 646648 646648 Hughe, Lewis John, of Clyfford, yeoman 1
4180780 2088757 2088757 defendant ap Robert William yeoman 646648 646648 ap Robert, William, of Clyfford, yeoman 2
4180784 2088758 2088758 defendant Hugh Lewis John yeoman 646648 646648 Hugh, Lewis John, of Clyfford, yeoman 1
4180785 2088758 2088758 defendant ap Robert William yeoman 646648 646648 ap Robert, William, of Clyfford, yeoman 2
4188738 2091541 2091541 defendant John Watkin weaver 646648 646648 John, Watkin, of Clyfford, weaver 0
4188739 2091541 2091541 defendant Watkyns Thomas laborer 646648 646648 Watkyns, Thomas, of Clyfford, laborer 1
4188740 2091541 2091541 defendant Weythe Thomas joiner 646648 646648 Weythe, Thomas, of Clyfford, joiner 2
4188741 2091541 2091541 defendant David Hugh laborer 646648 646648 David, Hugh, of Clyfford, laborer 3
4188743 2091542 2091542 defendant John Watkyn weaver 646648 646648 John, Watkyn, of Clyfford, weaver 0
4188744 2091542 2091542 defendant Watkyns Thomas laborer 646648 646648 Watkyns, Thomas, of Clyfford, laborer 1
4188745 2091542 2091542 defendant Weythe Thomas joiner 646648 646648 Weythe, Thomas, of Clyfford, joiner 2
4188746 2091542 2091542 defendant ap David Hugh laborer 646648 646648 ap David, Hugh, of Clyfford, laborer 3
4215314 2100851 2100851 defendant Whitney Thomas gent 646648 646648 Whitney, Thomas, of Clyfford, gent 0
4218419 2101943 2101943 defendant Owen Thomas husbandman 646648 646648 Owen, Thomas, of Clyfford, husbandman 1
4224739 2104123 2104123 defendant Whytney Thomas gent 646648 646648 Whytney, Thomas, of Clyfford, gent 0
4224740 2104123 2104123 defendant Philips alias Bayly George yeoman 646648 646648 Philips alias Bayly, George, of Clyfford, yeoman 1
4224741 2104123 2104123 defendant Thomas John   646648 646648 Thomas, John, of Clyfford, surgeon 2
4246060 2111662 2111662 defendant Whytney James gent 646648 646648 Whytney, James, of Clyfford, gent 2
4247987 2112314 2112314 defendant Harry William yeoman 646648 646648 Harry, William, of Clyfford, yeoman 0
4247988 2112314 2112314 defendant Kedward alias Colcombe Henry yeoman 646648 646648 Kedward alias Colcombe, Henry, of Clyfford, yeoman 1
4247989 2112314 2112314 defendant Lloyd John yeoman 646648 646648 Lloyd, John, of Clyfford, yeoman 2
4247992 2112315 2112315 defendant ap David Lewis yeoman 646648 646648 ap David, Lewis, of Clyfford, yeoman 1
4247993 2112315 2112315 defendant George Watkin yeoman 646648 646648 George, Watkin, of Clyfford, yeoman 2
4247994 2112315 2112315 defendant ap David William yeoman 646648 646648 ap David, William, of Clyfford, yeoman 3
4300808 2130386 2130386 defendant ap George Simon yeoman 646648 646648 ap George, Simon, of Clyfford, yeoman 1
4300809 2130386 2130386 defendant ap David Lewis yeoman 646648 646648 ap David, Lewis, of Clyfford, yeoman 2
4308904 2133265 2133265 defendant Jenkyn Thomas husbandman 646648 646648 Jenkyn, Thomas, of Clyfford, husbandman 0
4313111 2134703 2134703 defendant Parry William yeoman 646648 646648 Parry, William, of Clyfford, yeoman 0
4386184 2160059 2160059 defendant Hill Randolph gent 646648 646648 Hill, Randolph, of Clyfford, gent 0
4386185 2160059 2160059 defendant Hill William gent 646648 646648 Hill, William, of Clyfford, gent 1
4386186 2160059 2160059 defendant Hill Elizabeth spinster 646648 646648 Hill, Elizabeth, of Clyfford, spinster 2
4480087 2194432 2194432 defendant Flesshewer John   646648 646648 Flesshewer, John, of Clyfford, son of William, of Colyngham 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);