names

124 rows where place_id = 587665

✎ 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
3592083 1865139 1865139 defendant Skerne Robert (legal representative) 587665 587665 Skerne, Robert, of Kyngeston on Thames, esq, executrix of 0
3592084 1865139 1865139 defendant Skerne Agnes widow 587665 587665 Skerne, Agnes, of Kyngeston on Thames, widow 1
3604218 1868985 1868985 defendant Lamvale Thomas yeoman 587665 587665 Lamvale, Thomas, of Kyngeston on Thames, yeoman 0
3612927 1871690 1871690 defendant Orme Alice widow 587665 587665 Orme, Alice, of Kyngeston on Thames, widow 0
3625090 1875381 1875381 defendant Basset John gent 587665 587665 Basset, John, of Kyngeston on Thames, gent 3
3628244 1903692 1903692 defendant Parker George yeoman 587665 587665 Parker, George, of Kyngeston on Thames, yeoman 0
3629114 1903979 1903979 defendant Sterkey John gent 587665 587665 Sterkey, John, of Kyngeston on Thames, gent 0
3629115 1903979 1903979 defendant Virgo William yeoman 587665 587665 Virgo, William, of Kyngeston on Thames, yeoman 1
3629116 1903979 1903979 defendant Dyngley Robert yeoman 587665 587665 Dyngley, Robert, of Kyngeston on Thames, yeoman 2
3629128 1903982 1903982 defendant Vyrgo William yeoman 587665 587665 Vyrgo, William, of Kyngeston on Thames, yeoman 0
3633529 1905298 1905298 defendant Jope John butcher 587665 587665 Jope, John, of Kyngeston on Thames, butcher 0
3633530 1905298 1905298 defendant Standon Robert fisher 587665 587665 Standon, Robert, of Kyngeston on Thames, fisher 1
3633531 1905298 1905298 defendant Gaddysby John yeoman 587665 587665 Gaddysby John, of Kyngeston on Thames, yeoman 2
3633532 1905298 1905298 defendant Hipporn John painter 587665 587665 Hipporn, John, of Kyngeston on Thames, painter 3
3633533 1905298 1905298 defendant Fulkehorn Stephen baker 587665 587665 Fulkehorn, Stephen, of Kyngeston on Thames, baker 4
3637062 1906390 1906390 defendant Lutman Henry husbandman 587665 587665 Lutman, Henry, of Kyngeston on Thames, husbandman 0
3644756 1908764 1908764 plaintiff Ford Erasmus gent 587665 587665 Ford, Erasmus, of Kyngeston on Thames, gent 0
3644757 1908764 1908764 defendant Pollyn John husbandman 587665 587665 Pollyn, John, of Kyngeston on Thames, husbandman 0
3683710 1921039 1921039 defendant Myles William butcher 587665 587665 Myles, William, of Kyngeston on Thames, butcher 0
3687702 1922322 1922322 defendant Edmondes John draper 587665 587665 Edmondes, John, of Kyngeston on Thames, draper 0
3687703 1922322 1922322 defendant Smyth George tailor 587665 587665 Smyth, George, of Kyngeston on Thames, tailor 1
3687704 1922322 1922322 defendant Hayton John innholder 587665 587665 Hayton, John, of Kyngeston on Thames, innholder 2
3687706 1922323 1922323 defendant Edmondes John draper 587665 587665 Edmondes, John, of Kyngeston on Thames, draper 0
3687707 1922323 1922323 defendant Smyth George tailor 587665 587665 Smyth, George, of Kyngeston on Thames, tailor 1
3687708 1922323 1922323 defendant Hayton John innholder 587665 587665 Hayton, John, of Kyngeston on Thames, innholder 2
3696791 1925222 1925222 defendant Edmondes John yeoman 587665 587665 Edmondes, John, of Kyngeston on Thames, yeoman 0
3704301 1927645 1927645 defendant Bowrer William yeoman 587665 587665 Bowrer, William, of Kyngeston on Thames, yeoman 0
3705125 1927891 1927891 plaintiff Grover John draper 587665 587665 Grover, John, of Kyngeston on Thames, draper 0
3706722 1928387 1928387 defendant Walton Leonard yeoman 587665 587665 Walton, Leonard, of Kyngeston on Thames, yeoman 0
3706994 1928471 1928471 defendant Foster Ralph vintner 587665 587665 Foster, Ralph, of Kyngeston on Thames, vintner 0
3707216 1928549 1928549 defendant Thurland Edmund clerk 587665 587665 Thurland, Edmund, of Kyngeston on Thames, clerk 0
3707217 1928549 1928549 defendant Exfeld Robert butcher 587665 587665 Exfeld, Robert, of Kyngeston on Thames, butcher 1
3710353 1929557 1929557 plaintiff Shale alias Fryer William yeoman of the crown 587665 587665 Shale alias Fryer, William, of Kyngeston on Thames, yeoman of the crown 0
3713253 1930453 1930453 defendant Colyn Richard bargeman 587665 587665 Colyn, Richard, of Kyngeston on Thames, bargeman 0
3720416 1932665 1932665 defendant Flynt William baker 587665 587665 Flynt, William, of Kyngeston on Thames, baker 0
3744278 1940108 1940108 defendant Shale William   587665 587665 Shale, William, of Kyngeston on Thames 0
3745663 1940551 1940551 defendant Wynter Roger yeoman 587665 587665 Wynter, Roger, of Kyngeston on Thames, yeoman 0
3746457 1940812 1940812 defendant Snowne John butcher 587665 587665 Snowne, John, of Kyngeston on Thames, butcher 0
3750841 1942184 1942184 defendant Pynchester John yeoman 587665 587665 Pynchester, John, of Kyngeston on Thames, yeoman 0
3752399 1942672 1942672 defendant Shale alias Fryer William   587665 587665 Shale alias Fryer, William, of Kyngeston on Thames 0
3755409 1943645 1943645 defendant Elderton John brewer 587665 587665 Elderton, John, of Kyngeston on Thames, brewer 0
3761278 1945531 1945531 defendant Downe James pulter 587665 587665 Downe, James, of Kyngeston on Thames, pulter 0
3773154 1949311 1949311 defendant Elderton John brewer 587665 587665 Elderton, John, of Kyngeston on Thames, brewer 0
3787662 1953928 1953928 defendant Bonde William gent 587665 587665 Bonde, William, of Kyngeston on Thames, gent 0
3792606 1955547 1955547 defendant Balle Ralph husbandman 587665 587665 Balle, Ralph, of Kyngeston on Thames, husbandman 0
3792607 1955547 1955547 defendant Hall alias Andrewe John laborer 587665 587665 Hall alias Andrewe, John, of Kyngeston on Thames, laborer 1
3792855 1955617 1955617 defendant Benson Richard gent 587665 587665 Benson, Richard, of Kyngeston on Thames, gent 0
3805482 1959653 1959653 defendant Berd Henry yeoman 587665 587665 Berd, Henry, of Kyngeston on Thames, yeoman 0
3805483 1959653 1959653 defendant Matson William laborer 587665 587665 Matson, William, of Kyngeston on Thames, laborer 1
3805484 1959653 1959653 defendant Cobbe Thomas laborer 587665 587665 Cobbe, Thomas, of Kyngeston on Thames, laborer 2
3805485 1959653 1959653 defendant Lydold William laborer 587665 587665 Lydold, William, of Kyngeston on Thames, laborer 3
3805486 1959653 1959653 defendant Gyllott Thomas laborer 587665 587665 Gyllott, Thomas, of Kyngeston on Thames, laborer 4
3806660 1959979 1959979 defendant Evelyng John husbandman 587665 587665 Evelyng, John, of Kyngeston on Thames, husbandman 0
3806661 1959979 1959979 defendant Evelyn Robert laborer 587665 587665 Evelyn, Robert, of Kyngeston on Thames, laborer 1
3806663 1959980 1959980 defendant Thurlond Edmund   587665 587665 Thurlond, Edmund, of Kyngeston on Thames, clerk, master of St Mary Magdalene chapel, Norbeton 0
3818811 1963791 1963791 plaintiff Moorer William mercer 587665 587665 Moorer, William, of Kyngeston on Thames, mercer 0
3820606 1964330 1964330 defendant Elderton John beer brewer 587665 587665 Elderton, John, of Kyngeston on Thames, beer brewer 0
3820607 1964330 1964330 defendant Browne John laborer 587665 587665 Browne, John, of Kyngeston on Thames, laborer 1
3821579 1964642 1964642 defendant Sedall alias Smyth John waterman 587665 587665 Sedall alias Smyth, John, of Kyngeston on Thames, waterman 0
3844923 1971955 1971955 defendant Deane William yeoman 587665 587665 Deane, William, of Kyngeston on Thames, yeoman 0
3848310 1973044 1973044 defendant Waterman John husbandman 587665 587665 Waterman, John, of Kyngeston on Thames, husbandman 0
3854152 1974937 1974937 defendant Roser Stephen butcher 587665 587665 Roser, Stephen, of Kyngeston on Thames, butcher 0
3863824 1978075 1978075 plaintiff Jenyn John mercer 587665 587665 Jenyn, John, of Kyngeston on Thames, mercer 0
3868495 1979701 1979701 defendant Roser Stephen butcher 587665 587665 Roser, Stephen, of Kyngeston on Thames, butcher 2
3871938 1980848 1980848 defendant Balle Ralph husbandman 587665 587665 Balle, Ralph, of Kyngeston on Thames, husbandman 0
3875535 1982052 1982052 defendant Dollyng Abrea widow 587665 587665 Dollyng, Abrea, of Kyngeston on Thames, widow 0
3875537 1982053 1982053 defendant Dollyng Abrea widow 587665 587665 Dollyng, Abrea, of Kyngeston on Thames, widow 0
3886808 1985850 1985850 defendant Draper John butcher 587665 587665 Draper, John, of Kyngeston on Thames, butcher 0
3888630 1986453 1986453 defendant Dolwyn Thomas yeoman 587665 587665 Dolwyn, Thomas, of Kyngeston on Thames, yeoman 2
3888631 1986453 1986453 defendant Grove Richard yeoman 587665 587665 Grove, Richard, of Kyngeston on Thames, yeoman 3
3888632 1986453 1986453 defendant Mody Elias tailor 587665 587665 Mody, Elias, of Kyngeston on Thames, tailor 4
3899271 1989967 1989967 defendant Througood William tailor 587665 587665 Througood, William, of Kyngeston on Thames, tailor 0
3910431 1993805 1993805 defendant Burrowe Richard yeoman 587665 587665 Burrowe, Richard, of Kyngeston on Thames, yeoman 0
3910432 1993806 1993806 plaintiff Thorley Lawrence, junior chapman 587665 587665 Thorley, Lawrence, junior, of Kyngeston on Thames, chapman 0
3910434 1993807 1993807 plaintiff Thorley Lawrence, junior chapman 587665 587665 Thorley, Lawrence, junior, of Kyngeston on Thames, chapman 0
3946342 2005794 2005794 defendant Foster William fisher 587665 587665 Foster, William, of Kyngeston on Thames, fisher 0
4655421 2247589 2247589 defendant Cokerell John tailor 587665 587665 Cokerell, John, of Kyngeston on Thames, tailor 0
4655423 2247590 2247590 defendant Cokerell John tailor 587665 587665 Cokerell, John, of Kyngeston on Thames, tailor 0
4844174 2309686 2309686 defendant Bavell Richard   587665 587665 Bavell, Richard, of Kyngeston on Thames, tallow chandler 0
5068012 2376934 2376934 defendant Purvyour Thomas ostler 587665 587665 Purvyour, Thomas, of Kyngeston on Thames, ostler 0
5194477 2414112 2414112 defendant Merssh William husbandman 587665 587665 Merssh, William, of Kyngeston on Thames, husbandman 4
5224266 2422769 2422769 defendant Lamvale alias Namvale Richard husbandman or yeoman 587665 587665 Lamvale alias Namvale, Richard, of Kyngeston on Thames, husbandman or yeoman 1
5234712 2425738 2425738 defendant Forde William, senior gent 587665 587665 Forde, William, senior, of Kyngeston on Thames, gent 0
5241674 2427772 2427772 defendant Husey Nicholas chandler 587665 587665 Husey, Nicholas, of Kyngeston on Thames, chandler 0
5241950 2427842 2427842 defendant Wolf John yeoman 587665 587665 Wolf, John, of Kyngeston on Thames, yeoman 0
5328055 2453459 2453459 defendant Blaket Robert   587665 587665 Blaket, Robert, of Kyngeston on Thames, cook 0
5329165 2453800 2453800 defendant Hampton John gent 587665 587665 Hampton, John, of Kyngeston on Thames, gent 0
5330320 2454145 2454145 defendant Paxman John yeoman 587665 587665 Paxman, John, of Kyngeston on Thames, yeoman 0
5352474 2460870 2460870 defendant atte Lee Robert innholder 587665 587665 atte Lee, Robert, of Kyngeston on Thames, innholder 2
5352481 2460871 2460871 defendant atte Lee Robert innholder 587665 587665 atte Lee, Robert, of Kyngeston on Thames, innholder 3
5352488 2460872 2460872 defendant atte Lee Robert innholder 587665 587665 atte Lee, Robert, of Kyngeston on Thames, innholder 3
5352499 2460875 2460875 defendant Skerne Robert esq 587665 587665 Skerne, Robert, of Kyngeston on Thames, esq 0
5362233 2463853 2463853 plaintiff Huse Nicholas   587665 587665 (Huse, Nicholas, of Kyngeston on Thames 1
5481884 2499513 2499513 defendant Forde Walter (legal representative) 587665 587665 Forde, Walter, of Kyngeston on Thames, gent, executrix of 1
5481885 2499513 2499513 defendant Forde Margaret widow 587665 587665 Forde, Margaret, of Kyngeston on Thames, widow 2
5486985 2501003 2501003 defendant Broun John smith 587665 587665 Broun, John, of Kyngeston on Thames, smith 0
5486986 2501003 2501003 defendant Emery John ostler 587665 587665 Emery, John, of Kyngeston on Thames, ostler 1
5486988 2501003 2501003 defendant Merssh John husbandman 587665 587665 Merssh, John, of Kyngeston on Thames, husbandman 3
5494215 2503174 2503174 defendant Skerne Robert (legal representative) 587665 587665 Skerne, Robert, of Kyngeston on Thames, esq, executrix of 0
5494216 2503174 2503174 defendant Skerne Agnes widow 587665 587665 Skerne, Agnes, of Kyngeston on Thames, widow 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);