names

349 rows where place_id = 589505

✎ 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
3597815 1866934 1866934 defendant ap Hopkyn John yeoman 589505 589505 ap Hopkyn, John, of Kyngeston, yeoman 0
3604678 1869125 1869125 defendant Nethersole Roger yeoman 589505 589505 Nethersole, Roger, of Kyngeston, yeoman 1
3609137 1870515 1870515 defendant (not given) John rector of Cokke 589505 589505 Cokke, John, of Kyngeston, rector of St Gerendi, Cornw 0
3609313 1870571 1870571 defendant (not given) John rector of Cokke 589505 589505 Cokke, John, of Kyngeston, rector of St Gerendi, Cornw 0
3612317 1871486 1871486 defendant Milward John husbandman 589505 589505 Milward, John, of Kyngeston, husbandman 1
3618874 1873514 1873514 defendant Depden John gent 589505 589505 Depden, John, of Kyngeston, gent 0
3629238 1904013 1904013 defendant Aston Nicholas yeoman 589505 589505 Aston, Nicholas, of Kyngeston, yeoman 0
3632921 1905112 1905112 defendant Scudamore John gent 589505 589505 Scudamore, John, of Kyngeston, gent 2
3642394 1908065 1908065 defendant Grene Richard husbandman 589505 589505 Grene, Richard, of Kyngeston, husbandman 3
3661927 1914020 1914020 defendant Lode Edward   589505 589505 Lode, Edward, of Kyngeston, yeoman, son & heir apparent of Edith, late wife of John Stanlynche 0
3668160 1915988 1915988 defendant Busshe John husbandman 589505 589505 Busshe, John, of Kyngeston, husbandman 0
3668255 1916017 1916017 defendant Webbe Henry husbandman 589505 589505 Webbe, Henry, of Kyngeston, husbandman 0
3668256 1916017 1916017 defendant Webbe Richard husbandman 589505 589505 Webbe, Richard, of Kyngeston, husbandman 1
3668257 1916017 1916017 defendant ap rees David husbandman 589505 589505 ap rees, David, of Kyngeston, husbandman 2
3672999 1917564 1917564 plaintiff Clerke Richard   589505 589505 Clerke, Richard, of Kyngeston 1
3674226 1917978 1917978 defendant Cornowe Richard husbandman 589505 589505 Cornowe, Richard, of Kyngeston, husbandman 1
3683486 1920964 1920964 defendant Den Thomas yeoman 589505 589505 Den, Thomas, of Kyngeston, yeoman 0
3683487 1920964 1920964 defendant Brownyng John yeoman 589505 589505 Brownyng, John, of Kyngeston, yeoman 1
3683488 1920964 1920964 defendant Croydon John yeoman 589505 589505 Croydon, John, of Kyngeston, yeoman 2
3691060 1923366 1923366 defendant Walker Clement husbandman 589505 589505 Walker, Clement, of Kyngeston, husbandman 2
3691065 1923367 1923367 defendant Walker Clement husbandman 589505 589505 Walker, Clement, of Kyngeston, husbandman 2
3696811 1925227 1925227 defendant Chamberleyn Elizabeth widow 589505 589505 Chamberleyn, Elizabeth, of Kyngeston, widow 3
3697303 1925378 1925378 defendant Aldworthe John husbandman 589505 589505 Aldworthe, John, of Kyngeston, husbandman 0
3706673 1928371 1928371 defendant Chamberleyn Elizabeth widow 589505 589505 Chamberleyn, Elizabeth, of Kyngeston, widow 0
3712048 1930089 1930089 defendant Grove or Grene Richard husbandman 589505 589505 Grove or Grene, Richard, of Kyngeston, husbandman 0
3713408 1930509 1930509 defendant Robert John chaplain 589505 589505 Robert, John, of Kyngeston, chaplain 0
3722447 1933279 1933279 defendant Austen William husbandman 589505 589505 Austen, William, of Kyngeston, husbandman 4
3724050 1933806 1933806 defendant Hylder Richard laborer 589505 589505 Hylder, Richard, of Kyngeston, laborer 1
3736348 1937610 1937610 defendant Pykombe John husbandman 589505 589505 Pykombe, John, of Kyngeston, husbandman 0
3739812 1938666 1938666 defendant Copden Robert husbandman 589505 589505 Copden, Robert, of Kyngeston, husbandman 0
3741094 1939078 1939078 defendant Chamberleyn Elizabeth widow 589505 589505 Chamberleyn, Elizabeth, of Kyngeston, widow 0
3745011 1940345 1940345 defendant ap Gwyllym Howell husbandman 589505 589505 ap Gwyllym, Howell, of Kyngeston, husbandman 1
3755887 1943794 1943794 defendant Kyng John laborer 589505 589505 Kyng, John, of Kyngeston, laborer 0
3771088 1948647 1948647 plaintiff Sterkey Nicholas yeoman 589505 589505 Sterkey, Nicholas, of Kyngeston, yeoman 0
3773411 1949394 1949394 defendant Adam John husbandman 589505 589505 Adam, John, of Kyngeston, husbandman 1
3823675 1965302 1965302 defendant Grenowe Richard husbandman 589505 589505 Grenowe, Richard, of Kyngeston, husbandman 0
3834818 1968827 1968827 defendant Delve John husbandman 589505 589505 Delve, John, of Kyngeston, husbandman 0
3859420 1976640 1976640 defendant Chapell Roger husbandman 589505 589505 Chapell, Roger, of Kyngeston, husbandman 0
3879957 1983554 1983554 defendant Roger William husbandman 589505 589505 Roger, William, of Kyngeston, husbandman 0
3888628 1986453 1986453 defendant Dolwyn William (legal representative) 589505 589505 Dolwyn, William, of Kyngeston, carpenter, executors of 0
3890727 1987166 1987166 defendant Hyll Thomas gent 589505 589505 Hyll, Thomas, of Kyngeston, gent 1
3892212 1987645 1987645 plaintiff Matteson William yeoman 589505 589505 Matteson, William, of Kyngeston, yeoman 0
3893434 1988032 1988032 defendant ap Robert John husbandman 589505 589505 ap Robert, John, of Kyngeston, husbandman 0
3894641 1988414 1988414 plaintiff Sall Richard merchant 589505 589505 Sall, Richard, of Kyngeston, merchant 0
3896896 1989174 1989174 defendant Smyth Richard husbandman 589505 589505 Smyth, Richard, of Kyngeston, husbandman 0
3896897 1989174 1989174 defendant ap Hopkyn Thomas husbandman 589505 589505 ap Hopkyn, Thomas, of Kyngeston, husbandman 1
3906259 1992382 1992382 defendant Baye John husbandman 589505 589505 Baye, John, of Kyngeston, husbandman 0
3923819 1998274 1998274 defendant Harvy Richard mariner 589505 589505 Harvy, Richard, of Kyngeston, mariner 0
3929684 2000272 2000272 defendant Morrys Richard husbandman 589505 589505 Morrys, Richard, of Kyngeston, husbandman 0
3929685 2000272 2000272 defendant Appoplyn Thomas husbandman 589505 589505 Appoplyn, Thomas, of Kyngeston, husbandman 1
3929686 2000272 2000272 defendant Day John husbandman 589505 589505 Day, John, of Kyngeston, husbandman 2
3929687 2000272 2000272 defendant Duppa Henry husbandman 589505 589505 Duppa, Henry, of Kyngeston, husbandman 3
3929693 2000272 2000272 defendant Pytt Thomas yeoman 589505 589505 Pytt, Thomas, of Kyngeston, yeoman 9
3936505 2002534 2002534 defendant Mayryke William husbandman 589505 589505 Mayryke, William, of Kyngeston, husbandman 0
3936733 2002613 2002613 plaintiff Merysshe Nicholas (legal representative) 589505 589505 Merysshe, Nicholas, of Kyngeston, clerk, executor of 0
3936736 2002614 2002614 plaintiff Merysshe Nicholas (legal representative) 589505 589505 Merysshe, Nicholas, of Kyngeston, clerk, executor of 0
3948699 2006610 2006610 defendant Blauncheflower Thomas husbandman 589505 589505 Blauncheflower, Thomas, of Kyngeston, husbandman 0
3960639 2010822 2010822 defendant Symes John yeoman 589505 589505 Symes, John, of Kyngeston Seymer, yeoman 0
3972050 2014782 2014782 defendant Towson Anne widow 589505 589505 Towson, Anne, of Kyngeston, widow 0
3975857 2016118 2016118 defendant Howell Thomas merchant 589505 589505 Howell, Thomas, of Kyngeston, merchant 0
3985034 2019406 2019406 defendant Yebbysley James husbandman 589505 589505 Yebbysley, James, of Kyngeston, husbandman 1
3986761 2020007 2020007 defendant Roo John husbandman 589505 589505 Roo, John, of Kyngeston, husbandman 1
4000781 2025047 2025047 defendant Gwelyn John yeoman 589505 589505 Gwelyn, John, of Kyngeston, yeoman 0
4000782 2025047 2025047 defendant Cox Richard yeoman 589505 589505 Cox, Richard, of Kyngeston, yeoman 1
4003546 2026031 2026031 defendant A Rudge William husbandman 589505 589505 A Rudge, William, of Kyngeston, husbandman 0
4013517 2029571 2029571 plaintiff Rowe John, senior   589505 589505 Rowe, John, senior, of Kyngeston, esq, Rowe, John, his son 0
4013519 2029572 2029572 plaintiff Rowe John, senior   589505 589505 Rowe, John, senior, of Kyngeston, esq, Rowe, John, his son 0
4026865 2034258 2034258 defendant Marshe Richard yeoman 589505 589505 Marshe, Richard, of Kyngeston, yeoman 0
4032425 2036252 2036252 defendant Baye John yeoman 589505 589505 Baye, John, of Kyngeston, yeoman 1
4032444 2036253 2036253 defendant Baye John yeoman 589505 589505 Baye, John, of Kyngeston, yeoman 2
4045102 2040701 2040701 plaintiff Rotsey John   589505 589505 Rotsey, John, of Kyngeston 0
4051270 2042893 2042893 defendant Foliambe Henry   589505 589505 (Foliambe, Henry, of Kyngeston 1
4063504 2047235 2047235 plaintiff Gillim John yeoman 589505 589505 Gillim, John, of Kyngeston, yeoman 0
4065727 2048035 2048035 defendant Mason Robert   589505 589505 Mason, Robert, of Kyngeston, mason 4
4073747 2050904 2050904 defendant Lane Henry yeoman 589505 589505 Lane, Henry, of Kyngeston, yeoman 1
4073748 2050904 2050904 defendant Gullafer Henry yeoman 589505 589505 Gullafer, Henry, of Kyngeston, yeoman 2
4074061 2051016 2051016 defendant Acton William husbandman 589505 589505 Acton, William, of Kyngeston, husbandman 2
4143205 2075793 2075793 defendant Baye John yeoman 589505 589505 Baye, John, of Kyngeston, yeoman 0
4161622 2082133 2082133 defendant Crompe Robert carpenter 589505 589505 Crompe, Robert, of Kyngeston, carpenter 3
4176660 2087305 2087305 defendant Baye John, senior yeoman 589505 589505 Baye, John, senior, of Kyngeston, yeoman 2
4178006 2087778 2087778 defendant Hill Richard gent 589505 589505 Hill, Richard, of Kyngeston, gent 0
4181925 2089158 2089158 defendant Manley John clothier 589505 589505 Manley, John, of Kyngeston, clothier 0
4207220 2098073 2098073 defendant Graye Walter gent 589505 589505 Graye, Walter, of Kyngeston, gent 0
4210780 2099327 2099327 defendant Gwyllym John yeoman 589505 589505 Gwyllym, John, of Kyngeston, yeoman 1
4217396 2101580 2101580 defendant Symond Richard yeoman 589505 589505 Symond, Richard, of Kyngeston, yeoman 0
4220401 2102640 2102640 defendant Symond Richard yeoman 589505 589505 Symond, Richard, of Kyngeston, yeoman 0
4220402 2102640 2102640 defendant Symond John yeoman 589505 589505 Symond, John, of Kyngeston, yeoman 1
4226577 2104772 2104772 defendant Symond Richard yeoman 589505 589505 Symond, Richard, of Kyngeston, yeoman 0
4231770 2106608 2106608 defendant Symond Richard yeoman 589505 589505 Symond, Richard, of Kyngeston, yeoman 0
4231771 2106608 2106608 defendant Symond John yeoman 589505 589505 Symond, John, of Kyngeston, yeoman 1
4235988 2108161 2108161 defendant Popkyn Richard yeoman 589505 589505 Popkyn, Richard, of Kyngeston, yeoman 1
4238078 2108921 2108921 defendant Spenser John husbandman 589505 589505 Spenser, John, of Kyngeston, husbandman 0
4240002 2109628 2109628 defendant Graye Christopher esq 589505 589505 Graye, Christopher, of Kyngeston, esq 2
4241896 2110281 2110281 defendant Symond Richard husbandman 589505 589505 Symond, Richard, of Kyngeston, husbandman 2
4241897 2110281 2110281 defendant Popkyn Richard husbandman 589505 589505 Popkyn, Richard, of Kyngeston, husbandman 3
4242487 2110486 2110486 defendant Popkyn James husbandman 589505 589505 Popkyn, James, of Kyngeston, husbandman 0
4248247 2112404 2112404 defendant Graye Christopher esq 589505 589505 Graye, Christopher, of Kyngeston, esq 2
4256635 2115188 2115188 defendant More William clerk 589505 589505 More, William, of Kyngeston, clerk 1
4280433 2123064 2123064 defendant Symons John yeoman 589505 589505 Symons, John, of Kyngeston, yeoman 0
4280434 2123064 2123064 defendant Symons Lawrence husbandman 589505 589505 Symons, Lawrence, of Kyngeston, husbandman 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);