names

82 rows where place_id = 586920

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3589988 1864510 1864510 plaintiff Clerk John   586920 586920 Clerk, John, of Kyngston 0
3601468 1868113 1868113 defendant Quynt Walter husbandman 586920 586920 Quynt, Walter, of Kyngston, husbandman 1
3613568 1871891 1871891 defendant Russell John yeoman 586920 586920 Russell, John, of Kyngston, yeoman 0
3614575 1872208 1872208 defendant Russell John husbandman 586920 586920 Russell, John, of Kyngston, husbandman 1
3614578 1872209 1872209 defendant Russell John husbandman 586920 586920 Russell, John, of Kyngston, husbandman 1
3625694 1875573 1875573 defendant Russell John husbandman 586920 586920 Russell, John, of Kyngston, husbandman 1
3638576 1906881 1906881 defendant Browne Robert clerk 586920 586920 Browne, Robert, of Kyngston Seymer, clerk 0
3650084 1910395 1910395 defendant Frode Thomas husbandman 586920 586920 Frode, Thomas, of Kyngston, husbandman 0
3650085 1910395 1910395 defendant Whytyng Richard miller 586920 586920 Whytyng, Richard, of Kyngston, miller 1
3650086 1910395 1910395 defendant Evelyng Nicholas yeoman 586920 586920 Evelyng, Nicholas, of Kyngston, yeoman 2
3668162 1915988 1915988 defendant Nethersole Richard husbandman 586920 586920 Nethersole, Richard, of Kyngston, husbandman 2
3697217 1925349 1925349 defendant Decan John husbandman 586920 586920 Decan, John, of Kyngston, husbandman 1
3697218 1925349 1925349 defendant Knyght Richard husbandman 586920 586920 Knyght, Richard, of Kyngston, husbandman 2
3713711 1930585 1930585 defendant Penyngton Stephen yeoman 586920 586920 Penyngton, Stephen, of Kyngston, yeoman 1
3742901 1939635 1939635 defendant Rogers Edward yeoman 586920 586920 Rogers, Edward, of Kyngston, yeoman 0
3746811 1940921 1940921 defendant Gardener Nicholas husbandman 586920 586920 Gardener, Nicholas, of Kyngston, husbandman 2
3795895 1956579 1956579 defendant Ranche Richard yeoman 586920 586920 Ranche, Richard, of Kyngston, yeoman 1
3796066 1956633 1956633 defendant Benny David husbandman 586920 586920 Benny, David, of Kyngston, husbandman 0
3796067 1956633 1956633 defendant Benny Thomas husbandman 586920 586920 Benny, Thomas, of Kyngston, husbandman 1
3802959 1958823 1958823 defendant Lewkenor Edward (legal representative) 586920 586920 Lewkenor, Edward, of Kyngston, esq, executrix of 0
3802960 1958823 1958823 defendant Lewkenor Margaret widow 586920 586920 Lewkenor, Margaret, of Kyngston, widow 1
3829186 1967010 1967010 defendant Culberwyll Henry clerk 586920 586920 Culberwyll, Henry, of Kyngston, clerk 0
3832679 1968146 1968146 defendant Short Walter chaplain 586920 586920 Short, Walter, of Kyngston, chaplain 0
3885368 1985363 1985363 defendant Symondys Thomas husbandman 586920 586920 Symondys, Thomas, of Kyngston, husbandman 0
3891776 1987505 1987505 defendant Cornysshe Robert husbandman 586920 586920 Cornysshe, Robert, of Kyngston, husbandman 1
3896482 1989029 1989029 defendant Mylward John husbandman 586920 586920 Mylward, John, of Kyngston, husbandman 1
3904765 1991852 1991852 defendant Hourde George husbandman 586920 586920 Hourde, George, of Kyngston, husbandman 0
3921342 1997481 1997481 defendant Arthure Thomas gent 586920 586920 Arthure, Thomas, of Kyngston Seymer, gent 0
3926443 1999173 1999173 defendant Womnam John butcher 586920 586920 Womnam, John, of Kyngston, butcher 1
3938371 2003173 2003173 defendant Vawtard John husbandman 586920 586920 Vawtard, John, of Kyngston, husbandman 0
3944796 2005280 2005280 plaintiff Belson Richard   586920 586920 Belson, Richard, of Kyngston 0
3947555 2006214 2006214 defendant Urrey Robert yeoman 586920 586920 Urrey, Robert, of Kyngston, yeoman 4
3947556 2006214 2006214 defendant True Robert yeoman 586920 586920 True, Robert, of Kyngston, yeoman 5
3957495 2009687 2009687 defendant Marshe Richard husbandman 586920 586920 Marshe, Richard, of Kyngston, husbandman 0
3963686 2011908 2011908 defendant Marten Thomas husbandman 586920 586920 Marten, Thomas, of Kyngston, husbandman 3
3972052 2014783 2014783 defendant Towson John smith 586920 586920 Towson, John, of Kyngston, smith 0
4003542 2026030 2026030 defendant A Rudge Walter husbandman 586920 586920 A Rudge, Walter, of Kyngston, husbandman 0
4003543 2026030 2026030 defendant A Rudge Henry husbandman 586920 586920 A Rudge, Henry, of Kyngston, husbandman 1
4050278 2042529 2042529 plaintiff Warre John gent 586920 586920 Warre, John, of Kyngston, gent 0
4067875 2048820 2048820 defendant Duppa Henry yeoman 586920 586920 Duppa, Henry, of Kyngston, yeoman 2
4068625 2049066 2049066 defendant Huntfyld Richard clerk 586920 586920 Huntfyld, Richard, of Kyngston, clerk 2
4090783 2056992 2056992 defendant Lykyer Richard yeoman 586920 586920 Lykyer, Richard, of Kyngston, yeoman 1
4096988 2059250 2059250 defendant Warr John gent 586920 586920 Warr, John, of Kyngston, gent 2
4096994 2059251 2059251 defendant Wynslade Thomas yeoman 586920 586920 Wynslade, Thomas, of Kyngston, yeoman 3
4108716 2063373 2063373 defendant Baye John, junior yeoman 586920 586920 Baye, John, junior, of Kyngston, yeoman 0
4109189 2063541 2063541 defendant Welsheman William yeoman 586920 586920 Welsheman, William, of Kyngston, yeoman 0
4109487 2063655 2063655 defendant Mascall John husbandman 586920 586920 Mascall, John, of Kyngston Seymer, husbandman 0
4143079 2075747 2075747 defendant Lillyngton Richard clerk 586920 586920 Lillyngton, Richard, of Kyngston, clerk 0
4159847 2081511 2081511 defendant Harte William husbandman 586920 586920 Harte, William, of Kyngston, husbandman 2
4181363 2088962 2088962 defendant Brewer Walter plumber 586920 586920 Brewer, Walter, of Kyngston, yeoman, or of Anderston, plumber 1
4207243 2098081 2098081 defendant Grene William chapman 586920 586920 Grene, William, of Kyngston, chapman 3
4212490 2099916 2099916 defendant Laver Morgan yeoman 586920 586920 Laver, Morgan, of Kyngston, yeoman 1
4226904 2104881 2104881 defendant Adams John husbandman 586920 586920 Adams, John, of Kyngston, husbandman 0
4231767 2106607 2106607 defendant Popkyn Richard yeoman 586920 586920 Popkyn, Richard, of Kyngston, yeoman 1
4231768 2106607 2106607 defendant Popkyn James husbandman 586920 586920 Popkyn, James, of Kyngston, husbandman 2
4235985 2108160 2108160 defendant Mathowes Henry yeoman 586920 586920 Mathowes, Henry, of Kyngston, yeoman 1
4268521 2119073 2119073 defendant Popkyn Richard yeoman 586920 586920 Popkyn, Richard, of Kyngston, yeoman 0
4271124 2119919 2119919 defendant Babyngton Francis esq 586920 586920 Babyngton, Francis, of Kyngston, esq 0
4276451 2121707 2121707 defendant Symons John yeoman 586920 586920 Symons, John, of Kyngston, yeoman 0
4276452 2121707 2121707 defendant Symons Thomas husbandman 586920 586920 Symons, Thomas, of Kyngston, husbandman 1
4285951 2125031 2125031 defendant Symons John yeoman 586920 586920 Symons, John, of Kyngston, yeoman 0
4285952 2125031 2125031 defendant Symons Thomas husbandman 586920 586920 Symons, Thomas, of Kyngston, husbandman 1
4288215 2125830 2125830 defendant Graye Christopher esq 586920 586920 Graye, Christopher, of Kyngston, esq 0
4289407 2126270 2126270 defendant Symons John yeoman 586920 586920 Symons, John, of Kyngston, yeoman 0
4302245 2130901 2130901 defendant Cole John husbandman 586920 586920 Cole, John, of Kyngston, husbandman 0
4302247 2130902 2130902 defendant Cole John, senior husbandman 586920 586920 Cole, John, senior, of Kyngston, husbandman 0
4304521 2131718 2131718 defendant Phillippes John husbandman 586920 586920 Phillippes, John, of Kyngston Seymer, husbandman 0
4360728 2151009 2151009 defendant Kynge John husbandman 586920 586920 Kynge, John, of Kyngston Seymer, husbandman 0
4360863 2151053 2151053 defendant Potterye Richard husbandman 586920 586920 Potterye, Richard, of Kyngston Seymer, husbandman 0
4362859 2151776 2151776 defendant Cole George yeoman 586920 586920 Cole, George, of Kyngston, yeoman 0
4362861 2151777 2151777 defendant Cole George yeoman 586920 586920 Cole, George, of Kyngston, yeoman 0
4378476 2157373 2157373 defendant Kynge John husbandman 586920 586920 Kynge, John, of Kyngston Seymer, husbandman 0
4386400 2160131 2160131 defendant Pottery John husbandman 586920 586920 Pottery, John, of Kyngston Seymer, husbandman 0
4839035 2308137 2308137 defendant Redmere Thomas merchant 586920 586920 Redmere, Thomas, of Kyngston, merchant 2
5146191 2400014 2400014 defendant Hynson Elizabeth   586920 586920 Hynson, Elizabeth, of Kyngston, widow, formerly wife of William 0
5239121 2427032 2427032 defendant Heysand William merchant 586920 586920 Heysand, William, of Kyngston, merchant 0
5277111 2438394 2438394 defendant Pernell William husbandman 586920 586920 Pernell, William, of Kyngston, husbandman 1
5383962 2470499 2470499 defendant Clementson John husbandman 586920 586920 Clementson, John, of Kyngston, husbandman 1
5395772 2473874 2473874 defendant Clementson John husbandman 586920 586920 Clementson, John, of Kyngston, husbandman 1
5459354 2492709 2492709 defendant Hert John husbandman 586920 586920 Hert, John, of Kyngston, husbandman 1
5471029 2496273 2496273 defendant Hert John husbandman 586920 586920 Hert, John, of Kyngston, husbandman 1
5521934 2511676 2511676 defendant Coke Philip husbandman 586920 586920 Coke, Philip, of Kyngston, 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);