names

249 rows where place_id = 596973

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3626789 1903225 1903225 defendant Aprice Richard yeoman 596973 596973 Aprice, Richard, of Newport, yeoman 2
3633467 1905281 1905281 defendant Leke John mercer 596973 596973 Leke, John, of Newport, mercer 1
3641828 1907893 1907893 defendant Bronde Margery widow 596973 596973 Bronde, Margery, of Newport, widow 0
3641831 1907894 1907894 defendant Bronde Margery widow 596973 596973 Bronde, Margery, of Newport, widow 0
3643262 1908317 1908317 defendant Tether Ellen widow 596973 596973 Tether, Ellen, of Newport, widow 4
3647690 1909668 1909668 defendant Woresley Alexander husbandman 596973 596973 Woresley, Alexander, of Newport, husbandman 1
3657819 1912696 1912696 defendant Bryne John laborer 596973 596973 Bryne, John, of Newport, laborer 0
3661692 1913934 1913934 defendant Buttre Nicholas laborer 596973 596973 Buttre, Nicholas, of Newport, laborer 0
3667621 1915816 1915816 defendant Austen Thomas clothier 596973 596973 Austen, Thomas, of Newport, clothier 0
3667623 1915817 1915817 defendant Austen Thomas clothier 596973 596973 Austen, Thomas, of Newport, clothier 0
3671420 1917039 1917039 defendant Clerke John mercer 596973 596973 Clerke, John, of Newport, mercer 1
3673517 1917743 1917743 defendant Gere Richard husbandman 596973 596973 Gere, Richard, of Newport, husbandman 0
3678429 1919308 1919308 defendant Benett John tailor 596973 596973 Benett, John, of Newport, tailor 0
3686674 1921987 1921987 defendant Bocher Katherine widow 596973 596973 Bocher, Katherine, of Newport, widow 0
3694136 1924371 1924371 defendant Benet John tailor 596973 596973 Benet, John, of Newport, tailor 0
3735631 1937376 1937376 defendant Kyng John butcher 596973 596973 Kyng, John, of Newport, butcher 4
3767939 1947609 1947609 defendant Gybyns Thomas husbandman 596973 596973 Gybyns, Thomas, of Newport, husbandman 1
3770726 1948528 1948528 defendant Gryffyth Robert gent 596973 596973 Gryffyth, Robert, of Newport, gent 0
3775268 1950002 1950002 defendant Powterell Richard yeoman 596973 596973 Powterell, Richard, of Newport, yeoman 0
3777652 1950759 1950759 defendant Barker Robert yeoman 596973 596973 Barker, Robert, of Newport, yeoman 0
3779338 1951260 1951260 defendant Rynger William gent 596973 596973 Rynger, William, of Newport, gent 0
3783878 1952729 1952729 defendant Bocher John yeoman 596973 596973 Bocher, John, of Newport, yeoman 1
3799303 1957699 1957699 defendant Benet Richard yeoman 596973 596973 Benet, Richard, of Newport, yeoman 1
3799542 1957778 1957778 plaintiff Johnson Henry   596973 596973 Johnson, Henry, of Newport 0
3804191 1959243 1959243 plaintiff Seriaunt John (legal representative) 596973 596973 Seriaunt, John, of Newport, executors of 0
3805323 1959612 1959612 defendant Dore John glover 596973 596973 Dore, John, of Newport, glover 0
3808699 1960601 1960601 defendant Eynesdale John glover 596973 596973 Eynesdale, John, of Newport, glover 0
3828801 1966885 1966885 defendant Pynner William butcher 596973 596973 (Pynner, William, of Newport, butcher 1
3831648 1967795 1967795 defendant Bonham Thomas   596973 596973 Bonham, Thomas, of Newport Paynell, innholder, son of Bonham, Thomas, of Cerlton, Beds 0
3834812 1968826 1968826 plaintiff Offeley Thomas draper 596973 596973 Offeley, Thomas, of Newport, draper 0
3834814 1968826 1968826 defendant Bowres John shoemaker 596973 596973 (Bowres, John, of Newport, shoemaker 1
3834815 1968826 1968826 defendant Tyder William mercer 596973 596973 Tyder, William, of Newport, mercer 2
3849952 1973572 1973572 plaintiff Mariff Richard yeoman 596973 596973 Mariff, Richard, of Newport, yeoman 0
3863184 1977890 1977890 defendant Spycer Robert mercer 596973 596973 Spycer, Robert, of Newport, mercer 1
3870440 1980358 1980358 defendant Walford John husbandman 596973 596973 Walford, John, of Newport, husbandman 0
3875304 1981982 1981982 defendant Tayllour Robert tanner 596973 596973 Tayllour, Robert, of Newport, tanner 2
3884686 1985153 1985153 plaintiff ap Howell Katherine widow 596973 596973 ap Howell, Katherine, of Newport, widow 0
3884719 1985164 1985164 defendant Bradshaw John innholder 596973 596973 Bradshaw, John, of Newport, innholder 2
3894495 1988366 1988366 defendant ap Howell Richard gent 596973 596973 ap Howell, Richard, of Newport, gent 0
3898409 1989680 1989680 plaintiff ap Howell Katherine widow 596973 596973 ap Howell, Katherine, of Newport, widow 0
3898411 1989681 1989681 plaintiff ap Howell Morgan   596973 596973 ap Howell, Morgan, of Newport 0
3898412 1989681 1989681 defendant ap Rees John Gllm gent 596973 596973 ap Rees, John Gllm, of Newport, gent 0
3902342 1991014 1991014 defendant Eccles Ralph shoemaker 596973 596973 Eccles, Ralph, of Newport, shoemaker 0
3909723 1993561 1993561 defendant Guson alias Harper John butcher 596973 596973 Guson alias Harper, John, of Newport, butcher 0
3909724 1993561 1993561 defendant Sotherne John shoemaker 596973 596973 Sotherne, John, of Newport, shoemaker 1
3909725 1993561 1993561 defendant Reve Christopher fishmonger 596973 596973 Reve, Christopher, of Newport, fishmonger 2
3909726 1993561 1993561 defendant Brabyn George shoemaker 596973 596973 Brabyn, George, of Newport, shoemaker 3
3909727 1993561 1993561 defendant Pygott John stringer 596973 596973 Pygott, John, of Newport, stringer 4
3927883 1999664 1999664 defendant Reve Christopher   596973 596973 Reve, Christopher, of Newport, fish monger 1
3942383 2004466 2004466 plaintiff Garrat Thomas   596973 596973 Garrat, Thomas, of Newport 1
3953693 2008367 2008367 defendant vergh Rees Gwenilliana widow 596973 596973 vergh Rees, Gwenilliana, of Newport, widow 5
3953825 2008411 2008411 defendant vergh Rees Gwenilliana widow 596973 596973 vergh Rees, Gwenilliana, of Newport, widow 5
3953836 2008412 2008412 defendant vergh Rees Gwenilliana widow 596973 596973 vergh Rees, Gwenilliana, of Newport, widow 5
3964111 2012054 2012054 plaintiff ap Morgan Giles esq 596973 596973 ap Morgan, Giles, of Newport, esq 0
3964112 2012054 2012054 defendant Willye Thomas yeoman 596973 596973 Willye, Thomas, of Newport, yeoman 0
3971701 2014663 2014663 defendant FitzJones William yeoman 596973 596973 FitzJones, William, of Newport, yeoman 0
3975949 2016151 2016151 defendant Thomas Lewis yeoman 596973 596973 Thomas, Lewis, of Newport, yeoman 1
4007119 2027323 2027323 defendant Aspeley John mercer 596973 596973 Aspeley, John, of Newport, mercer 0
4009643 2028218 2028218 defendant Annesley George gent 596973 596973 Annesley, George, of Newport, ,gent 0
4017390 2030925 2030925 defendant Jenkyn Rice husbandman 596973 596973 Jenkyn, Rice, of Newport, husbandman 4
4023329 2033053 2033053 plaintiff Barnefeld Ellen widow 596973 596973 Barnefeld, Ellen, of Newport, widow 0
4048189 2041791 2041791 plaintiff Symons John, junior draper 596973 596973 Symons, John, junior, of Newport, draper 0
4048196 2041793 2041793 plaintiff Symons Roger dyer 596973 596973 Symons, Roger, of Newport, dyer 0
4054729 2044080 2044080 plaintiff Barry Felicia   596973 596973 Felicia his wife, formerly Felicia Thomas alias Colmes, of Newport 1
4054730 2044080 2044080 defendant Holyst John mercer 596973 596973 Holyst, John, of Newport, mercer 0
4054731 2044080 2044080 defendant Baker John David yeoman 596973 596973 Baker, John David, of Newport, yeoman 1
4055366 2044316 2044316 defendant Staunton William Salop, husbandman 596973 596973 Staunton William, of Newport, Salop, husbandman 4
4059922 2045945 2045945 defendant Chaundler John glover 596973 596973 Chaundler, John, of Newport, glover 1
4060011 2045977 2045977 defendant Waynewright William butcher 596973 596973 Waynewright, William, of Newport, butcher 0
4065701 2048025 2048025 plaintiff Herbert George esq 596973 596973 Herbert, George, of Newport, esq 0
4066806 2048427 2048427 defendant Chaundler John glover 596973 596973 Chaundler, John, of Newport, glover 0
4067635 2048737 2048737 defendant Herbert Miles esq 596973 596973 Herbert, Miles, of Newport, esq 1
4068158 2048916 2048916 defendant West William yeoman 596973 596973 West, William, of Newport, yeoman 0
4068199 2048929 2048929 defendant Apowell James yeoman 596973 596973 Apowell, James, of Newport, yeoman 2
4071221 2050011 2050011 defendant Kemes or Kemmes Edmund gent 596973 596973 Kemes or Kemmes, Edmund, of Newport, gent 0
4071924 2050258 2050258 plaintiff Nicholas Maurice   596973 596973 Nicholas, Maurice, of Newport 0
4071927 2050258 2050258 defendant Philipe William gent 596973 596973 Philipe, William, of Newport, gent 2
4075857 2051665 2051665 defendant Cranmer Thomas blacksmith 596973 596973 Cranmer, Thomas, of Newport, blacksmith 0
4076476 2051883 2051883 defendant Harper alias Henson John butcher 596973 596973 Harper alias Henson, John, of Newport, butcher 2
4078332 2052551 2052551 plaintiff Symons Roger dyer 596973 596973 Symons, Roger, of Newport, dyer 0
4084473 2054723 2054723 defendant Henley Richard tanner or butcher 596973 596973 Henley, Richard, of Newport, tanner or butcher 0
4084479 2054725 2054725 defendant Downes Anthony cooper 596973 596973 Downes, Anthony, of Newport, cooper 1
4091170 2057131 2057131 defendant Coope Thomas cordwainer 596973 596973 Coope, Thomas, of Newport, cordwainer 0
4096711 2059153 2059153 defendant Kemys Giles gent 596973 596973 Kemys, Giles, of Newport, gent 0
4097606 2059471 2059471 defendant Pidgen Thomas husbandman 596973 596973 Pidgen, Thomas, of Newport, husbandman 0
4100453 2060487 2060487 defendant Kemys Giles gent 596973 596973 Kemys, Giles, of Newport, gent 0
4104571 2061914 2061914 defendant Thomas Lewis gent 596973 596973 Thomas, Lewis, of Newport, gent 0
4104613 2061931 2061931 defendant Kemys Giles gent 596973 596973 Kemys, Giles, of Newport, gent 0
4106666 2062675 2062675 defendant Barnefield Robert gent 596973 596973 Barnefield, Robert, of Newport, gent 0
4143449 2075869 2075869 defendant Sambroke John yeoman 596973 596973 Sambroke, John, of Newport, or of Pickstocke, yeoman 0
4143450 2075869 2075869 defendant Baylye John husbandman 596973 596973 Baylye, John, of Newport, or of Wilderley, husbandman 1
4143451 2075869 2075869 defendant Baylye Roland, junior husbandman 596973 596973 Baylye, Roland, junior, of Newport, or of Wilderley, husbandman 2
4143452 2075869 2075869 defendant Baylye William husbandman 596973 596973 Baylye, William, of Newport, or of Cuthercote, husbandman 3
4146620 2076971 2076971 defendant Amery Ralph yeoman 596973 596973 Amery, Ralph, of Newport, or of Whitchurche, yeoman 0
4146623 2076972 2076972 defendant Kynnaston Edward chapman 596973 596973 Kynnaston, Edward, of Newport, yeoman, or of Elsemear, Salop, chapman 0
4151088 2078512 2078512 defendant Sandeford Thomas gent 596973 596973 Sandeford, Thomas, of Newport, or of Woodhowsen, gent 0
4151128 2078523 2078523 defendant Bould John chapman 596973 596973 Bould, John, of Newport, chapman 2
4151142 2078526 2078526 defendant Yonge John gent 596973 596973 Yonge, John, of Newport, gent 1
4156632 2080398 2080398 defendant Boycott John laborer 596973 596973 Boycott, John, of Newport, laborer 0
4157085 2080557 2080557 defendant Kemys Giles gent 596973 596973 Kemys, Giles, of Newport, gent 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);