names

179 rows where place_id = 590794

✎ 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
3602337 1868393 1868393 defendant at Wode John yeoman 590794 590794 at Wode, John, of Stondon, yeoman 1
3602338 1868393 1868393 defendant Hamond William yeoman 590794 590794 Hamond, William, of Stondon, yeoman 2
3602339 1868393 1868393 defendant Grene Richard yeoman 590794 590794 Grene, Richard, of Stondon, yeoman 3
3602340 1868393 1868393 defendant Maister Thomas yeoman 590794 590794 Maister, Thomas, of Stondon, yeoman 4
3605228 1869303 1869303 defendant Clerk John butcher 590794 590794 Clerk, John, of Stondon, butcher 0
3614831 1872290 1872290 defendant Danyell William yeoman 590794 590794 Danyell, William, of Stondon, yeoman 0
3614833 1872291 1872291 defendant Danyell William yeoman 590794 590794 Danyell, William, of Stondon, yeoman 0
3653036 1911279 1911279 defendant Feld William husbandman 590794 590794 Feld, William, of Stondon, husbandman 0
3669074 1916259 1916259 defendant Campyon John maltman 590794 590794 Campyon, John, of Stondon, maltman 0
3670730 1916806 1916806 defendant Baker Joan widow 590794 590794 Baker, Joan, of Stondon, widow 1
3671192 1916962 1916962 defendant Grave Henry husbandman 590794 590794 Grave, Henry, of Stondon, husbandman 0
3673638 1917787 1917787 defendant Chapman Richard innholder 590794 590794 Chapman, Richard, of Stondon, innholder 0
3675904 1918500 1918500 defendant Barowe Geoffrey maltman 590794 590794 Barowe, Geoffrey, of Stondon, maltman 0
3676987 1918839 1918839 plaintiff Kyrkeby John   590794 590794 Kyrkeby, John, of Stondon 0
3678377 1919293 1919293 defendant Taverner John butcher 590794 590794 Taverner, John, of Stondon, butcher 0
3678379 1919293 1919293 defendant Hochyn Thomas maltman 590794 590794 Hochyn, Thomas, of Stondon, maltman 2
3684634 1921327 1921327 defendant Carpenter Thomas husbandman 590794 590794 Carpenter, Thomas, of Stondon, husbandman 0
3686275 1921860 1921860 defendant Barrey John husbandman 590794 590794 Barrey, John, of Stondon, husbandman 0
3692075 1923690 1923690 defendant Rutter William butcher 590794 590794 Rutter, William, of Stondon, butcher 4
3707447 1928624 1928624 defendant Reve Geoffrey husbandman 590794 590794 Reve, Geoffrey, of Stondon, husbandman 1
3707452 1928625 1928625 defendant Reve Geoffrey husbandman 590794 590794 Reve, Geoffrey, of Stondon, husbandman 1
3707457 1928626 1928626 defendant Reve Geoffrey husbandman 590794 590794 Reve, Geoffrey, of Stondon, husbandman 1
3713365 1930494 1930494 defendant Hochyn Thomas husbandman 590794 590794 Hochyn, Thomas, of Stondon, husbandman 0
3713366 1930494 1930494 defendant Waren John smith 590794 590794 Waren, John, of Stondon, smith 1
3721170 1932920 1932920 defendant Lame John clerk 590794 590794 Lame, John, of Stondon, clerk 0
3721173 1932921 1932921 defendant Lame John clerk 590794 590794 Lame, John, of Stondon, clerk 0
3721182 1932924 1932924 defendant Lame John clerk 590794 590794 Lame, John, of Stondon, clerk 0
3728836 1935266 1935266 defendant Hochyn Thomas husbandman 590794 590794 Hochyn, Thomas, of Stondon, husbandman 0
3728837 1935266 1935266 defendant Waren John smith 590794 590794 Waren, John, of Stondon, smith 1
3731259 1936001 1936001 defendant Barry John husbandman 590794 590794 Barry, John, of Stondon, husbandman 0
3732673 1936449 1936449 defendant Grene John laborer 590794 590794 Grene, John, of Stondon, laborer 2
3746775 1940909 1940909 defendant Chambleyn Thomas yeoman 590794 590794 Chambleyn, Thomas, of Stondon, yeoman 0
3749901 1941884 1941884 defendant Carpenter Thomas husbandman 590794 590794 Carpenter, Thomas, of Stondon, husbandman 0
3757943 1944466 1944466 defendant Bond John sawyer 590794 590794 Bond, John, of Stondon, sawyer 1
3759103 1944834 1944834 plaintiff Chamberleyn Thomas maltman 590794 590794 Chamberleyn, Thomas, of Stondon, maltman 0
3759106 1944834 1944834 defendant Ducke Robert   590794 590794 Ducke, Robert, of Stondon, parish clerk 2
3766655 1947232 1947232 defendant Bate Robert husbandman 590794 590794 Bate, Robert, of Stondon, husbandman 2
3766656 1947232 1947232 defendant Garsley John husbandman 590794 590794 Garsley, John, of Stondon, husbandman 3
3786587 1953601 1953601 defendant Reve Nicholas husbandman 590794 590794 Reve, Nicholas, of Stondon, husbandman 0
3787837 1953983 1953983 defendant Halle John yeoman 590794 590794 Halle, John, of Stondon, yeoman 0
3804041 1959184 1959184 defendant Hall John yeoman 590794 590794 Hall, John, of Stondon, yeoman 0
3816217 1962981 1962981 plaintiff Hogge Thomas yeoman 590794 590794 Hogge, Thomas, of Stondon, yeoman 0
3826674 1966190 1966190 defendant Speryng John wheeler 590794 590794 Speryng, John, of Stondon, wheeler 0
3833433 1968383 1968383 defendant Skyngyll John husbandman 590794 590794 Skyngyll, John, of Stondon, husbandman 0
3840833 1970702 1970702 defendant Jersey John maltman 590794 590794 Jersey, John, of Stondon, maltman 1
3841416 1970895 1970895 defendant Bassett John yeoman 590794 590794 Bassett, John, of Stondon, yeoman 0
3841417 1970895 1970895 defendant Rud John innholder 590794 590794 Rud, John, of Stondon, innholder 1
3841418 1970895 1970895 defendant Rawlyn Walter shoemaker 590794 590794 Rawlyn, Walter, of Stondon, shoemaker 2
3842178 1971102 1971102 defendant Buk Robert   590794 590794 Buk, Robert, of Stondon, parish clerk 0
3842179 1971102 1971102 defendant Lyndesey Thomas husbandman 590794 590794 Lyndesey, Thomas, of Stondon, husbandman 1
3842183 1971102 1971102 defendant Danyell John husbandman 590794 590794 Danyell, John, of Stondon, husbandman 5
3857030 1975832 1975832 defendant Bedell George yeoman 590794 590794 Bedell, George, of Stondon, yeoman 0
3868347 1979654 1979654 defendant Basset John yeoman 590794 590794 Basset, John, of Stondon, yeoman 0
3868348 1979654 1979654 defendant Rudde John innholder 590794 590794 Rudde, John, of Stondon, innholder 1
3868349 1979654 1979654 defendant Rawlyn Walter shoemaker 590794 590794 Rawlyn, Walter, of Stondon, shoemaker 2
3874436 1981679 1981679 defendant Pacyen Simon laborer 590794 590794 Pacyen, Simon, of Stondon, laborer 0
3882638 1984458 1984458 defendant Edwyn John husbandman 590794 590794 Edwyn, John, of Stondon, husbandman 0
3891403 1987390 1987390 defendant Parker Thomas tailor 590794 590794 Parker, Thomas, of Stondon, tailor 0
3891405 1987391 1987391 defendant Parker Thomas tailor 590794 590794 Parker, Thomas, of Stondon, tailor 0
3894079 1988235 1988235 defendant Rowenson Henry smith 590794 590794 Rowenson, Henry, of Stondon, smith 0
3898074 1989566 1989566 defendant Bylls James   590794 590794 Bylls, James, of Stondon, horse courser 1
3901629 1990773 1990773 defendant Bucke Robert yeoman 590794 590794 Bucke, Robert, of Stondon, yeoman 0
3904789 1991863 1991863 plaintiff Howe Thomas gent 590794 590794 Howe, Thomas, of Stondon, gent 0
3914176 1995085 1995085 defendant Abell William husbandman 590794 590794 Abell, William, of Stondon, husbandman 4
3920003 1997030 1997030 defendant Buk Robert yeoman 590794 590794 Buk, Robert, of Stondon, yeoman 0
3931721 2000911 2000911 defendant Warde John clothier 590794 590794 Warde, John, of Stondon, clothier 0
3931722 2000911 2000911 defendant Grave Nicholas husbandman 590794 590794 Grave, Nicholas, of Stondon, husbandman 1
3932683 2001229 2001229 plaintiff Fyssher Richard yeoman 590794 590794 Fyssher, Richard, of Stondon, yeoman 0
3944203 2005078 2005078 plaintiff Barfote William husbandman 590794 590794 Barfote, William, of Stondon, husbandman 0
3944205 2005078 2005078 defendant Brett Thomas yeoman 590794 590794 (Brett, Thomas, of Stondon, yeoman 1
3944206 2005078 2005078 defendant Brett William yeoman 590794 590794 Brett, William, of Stondon, yeoman 2
3950458 2007237 2007237 defendant Jacob Thomas husbandman 590794 590794 Jacob, Thomas, of Stondon, husbandman 1
3950459 2007237 2007237 defendant Feld Thomas maltman 590794 590794 Feld, Thomas, of Stondon, maltman 2
3951788 2007685 2007685 defendant Burman Thomas yeoman 590794 590794 Burman, Thomas, of Stondon, yeoman 0
3951789 2007685 2007685 defendant Eldred William yeoman 590794 590794 Eldred, William, of Stondon, yeoman 1
3952105 2007806 2007806 defendant Brett Thomas maltman 590794 590794 Brett, Thomas, of Stondon, maltman 0
3959984 2010591 2010591 defendant Brett John maltman 590794 590794 Brett, John, of Stondon, or of Hygh Crosse, maltman 0
3962468 2011465 2011465 defendant Brett Thomas maltman 590794 590794 Brett, Thomas, of Stondon, maltman 0
3962470 2011466 2011466 defendant Brett Thomas maltman 590794 590794 Brett, Thomas, of Stondon, maltman 0
3962471 2011466 2011466 defendant Brett John maltman 590794 590794 Brett, John, of Stondon, maltman 1
3962501 2011478 2011478 defendant Grave John husbandman 590794 590794 Grave, John, of Stondon, husbandman 1
3962502 2011478 2011478 defendant Grave Nicholas husbandman 590794 590794 Grave, Nicholas, of Stondon, husbandman 2
3970342 2014225 2014225 defendant Worland Richard tanner 590794 590794 Worland, Richard, of Stondon, tanner 0
4042303 2039728 2039728 defendant Derdes John yeoman or maltman 590794 590794 Derdes, John, of Stondon, yeoman or maltman 1
4067808 2048799 2048799 defendant Bastwick John husbandman 590794 590794 Bastwick, John, of Stondon, husbandman 0
4275438 2121345 2121345 defendant Poole Nicholas husbandman 590794 590794 Poole, Nicholas, of Stondon, husbandman 2
4336091 2142357 2142357 defendant Smyth Edmund yeoman 590794 590794 Smyth, Edmund, of Stondon, yeoman 1
4409378 2167732 2167732 defendant Taylor Walter maltman 590794 590794 Taylor, Walter, of Stondon, maltman 0
4409379 2167732 2167732 defendant Taylor John maltman 590794 590794 Taylor, John, of Stondon, maltman 1
4415855 2169849 2169849 defendant Sone John   590794 590794 Sone, John, of Stondon, son of Robert 0
4444888 2183375 2183375 defendant Pulter William   590794 590794 Pulter, William, of Stondon 2
4467526 2190524 2190524 defendant White John   590794 590794 White, John, of Stondon 0
4467527 2190524 2190524 defendant Oseberne John   590794 590794 Oseberne, John, of Stondon 1
4468857 2190935 2190935 defendant Faryndon Thomas   590794 590794 Faryndon, Thomas, of Stondon 0
4469270 2191056 2191056 defendant Berle William   590794 590794 Berle, #William, of Stondon 0
4469272 2191057 2191057 defendant Faryndon Thomas   590794 590794 Faryndon, Thomas, of Stondon 0
4497701 2199925 2199925 defendant Wryght John   590794 590794 Wryght, John, of Stondon 2
4501829 2201172 2201172 plaintiff Malters Robert   590794 590794 Malters, Robert, of Stondon 0
4503102 2201539 2201539 defendant Clerk Thomas   590794 590794 Clerk, Thomas, of Stondon, son of Gilbert 1
4503741 2201733 2201733 defendant Gondlak Robert   590794 590794 Gondlak, Robert, of Stondon 0

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);