names

947 rows where place_id = 589460

✎ 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
3597699 1866905 1866905 defendant Smyth Thomas yeoman 589460 589460 Smyth, Thomas, of Spaldyng, yeoman 3
3597709 1866906 1866906 defendant Smyth Thomas yeoman 589460 589460 Smyth, Thomas, of Spaldyng, yeoman 3
3605009 1869230 1869230 defendant Grene William husbandman 589460 589460 Grene, William, of Spaldyng, husbandman 0
3605011 1869230 1869230 defendant Swagge Richard waterman 589460 589460 Swagge, Richard, of Spaldyng, waterman 2
3611502 1871270 1871270 defendant Derby William draper 589460 589460 Derby, William, of Spaldyng, draper 0
3618979 1873548 1873548 defendant Richardson Henry glover 589460 589460 Richardson, Henry, of Spaldyng, glover 0
3618981 1873548 1873548 defendant Benet John yeoman 589460 589460 Benet, John, of Spaldyng, yeoman 2
3621854 1874376 1874376 defendant Jakes John yeoman 589460 589460 Jakes, John, of Spaldyng, yeoman 0
3624773 1875283 1875283 defendant Appultofte Simon tailor 589460 589460 Appultofte, Simon, of Spaldyng, tailor 1
3631161 1904569 1904569 defendant Garnet Thomas   589460 589460 Garnet, Thomas, of Spaldyng, millwright 3
3631162 1904569 1904569 defendant Rasour John husbandman 589460 589460 Rasour, John, of Spaldyng, husbandman 4
3639779 1907251 1907251 defendant Burnston Robert fisher 589460 589460 Burnston, Robert, of Spaldyng, fisher 0
3649447 1910218 1910218 defendant Doland William gent 589460 589460 Doland, William, of Spaldyng, gent 0
3649817 1910306 1910306 defendant Barbour Thomas yeoman 589460 589460 Barbour, Thomas, of Spaldyng, yeoman 0
3653881 1911478 1911478 plaintiff (not given) Robert prior of -- 589460 589460 --, Robert, of Spaldyng, prior of the Monastery of the Blessed Mary & St Nicholas 0
3655104 1911857 1911857 defendant Wolryche Nicholas fisher 589460 589460 Wolryche, Nicholas, of Spaldyng, fisher 0
3655402 1911949 1911949 plaintiff (not given) Robert prior of Boston 589460 589460 Boston, Robert, of Spaldyng, prior of the Monastery of the Blessed Mary & St Nicholas 0
3655404 1911950 1911950 plaintiff (not given) Robert prior of Boston 589460 589460 Boston, Robert, of Spaldyng, prior of the Monastery of the Blessed Mary & St Nicholas 0
3657547 1912622 1912622 defendant Arnolod Alexander laborer 589460 589460 Arnolod, Alexander, of Spaldyng, laborer 0
3657855 1912706 1912706 plaintiff Deye Thomas   589460 589460 Deye, Thomas, of Spaldyng, wax maker 0
3663892 1914647 1914647 defendant Whyte John fisher 589460 589460 Whyte, John, of Spaldyng, fisher 0
3669856 1916517 1916517 defendant Appultoft Nicholas tailor 589460 589460 Appultoft, Nicholas, of Spaldyng, tailor 1
3672457 1917385 1917385 plaintiff Daland William gent 589460 589460 Daland, William, of Spaldyng, gent 0
3680384 1919946 1919946 defendant Knoppe Robert laborer 589460 589460 Knoppe, Robert, of Spaldyng, laborer 0
3686102 1921813 1921813 defendant White Ralph   589460 589460 White, Ralph, of Spaldyng, flax chapman 2
3693063 1924038 1924038 plaintiff Loke William   589460 589460 Loke, William, of Spaldyng 0
3700490 1926393 1926393 defendant Saunderson John, junior fisher 589460 589460 Saunderson, John, junior, of Spaldyng, fisher 0
3700491 1926393 1926393 defendant Page William fisher 589460 589460 Page, William, of Spaldyng, fisher 1
3700492 1926393 1926393 defendant Hode Robert laborer 589460 589460 Hode, Robert, of Spaldyng, laborer 2
3700493 1926393 1926393 defendant Burre Hugh laborer 589460 589460 Burre, Hugh, of Spaldyng, laborer 3
3717615 1931806 1931806 defendant Dey Robert, senior husbandman 589460 589460 Dey, Robert, senior, of Spaldyng, husbandman 0
3725606 1934299 1934299 defendant Trouth Richard yeoman 589460 589460 Trouth, Richard, of Spaldyng, yeoman 1
3727498 1934878 1934878 defendant Colson Robert husbandman 589460 589460 Colson, Robert, of Spaldyng, husbandman 0
3729443 1935454 1935454 defendant Worlych Nicholas husbandman 589460 589460 Worlych, Nicholas, of Spaldyng, husbandman 0
3731848 1936190 1936190 defendant Russhe Ambrose fisher 589460 589460 Russhe, Ambrose, of Spaldyng, fisher 0
3731849 1936190 1936190 defendant Mollet Richard butcher 589460 589460 Mollet, Richard, of Spaldyng, butcher 1
3732183 1936301 1936301 defendant Brunson or Brimson Thomas husbandman 589460 589460 Brunson or Brimson, Thomas, of Spaldyng, husbandman 0
3732184 1936301 1936301 defendant Eyston John laborer 589460 589460 Eyston, John, of Spaldyng, laborer 1
3732185 1936301 1936301 defendant Fraunces David laborer 589460 589460 Fraunces, David, of Spaldyng, laborer 2
3733654 1936767 1936767 defendant Boswell Robert barber 589460 589460 Boswell, Robert, of Spaldyng, barber 0
3738987 1938399 1938399 defendant Hert William tanner 589460 589460 Hert, William, of Spaldyng, tanner 0
3742117 1939403 1939403 plaintiff Thomson Thomas (legal representative) 589460 589460 Thomson, Thomas, of Spaldyng, executor of 0
3742119 1939403 1939403 defendant Dey William shoemaker 589460 589460 Dey, William, of Spaldyng, shoemaker 0
3750804 1942175 1942175 defendant Storre Oswold cordwainer 589460 589460 Storre, Oswold, of Spaldyng, cordwainer 0
3753614 1943074 1943074 defendant Crispe John smith 589460 589460 Crispe, John, of Spaldyng, smith 0
3758726 1944722 1944722 defendant Trouthe Richard husbandman 589460 589460 Trouthe, Richard, of Spaldyng, husbandman 4
3760434 1945267 1945267 plaintiff Daldon James (legal representative) 589460 589460 Daldon, James, of Spaldyng, yeoman, executor of 0
3760436 1945267 1945267 defendant Clerk Oliver (legal representative) 589460 589460 Clerk, Oliver, of Spaldyng, butcher, executrix of 0
3760437 1945267 1945267 defendant Clerk Alice widow 589460 589460 Clerk, Alice, of Spaldyng, widow 1
3767950 1947612 1947612 defendant Whyte Ralph husbandman 589460 589460 Whyte, Ralph, of Spaldyng, husbandman 1
3767953 1947613 1947613 plaintiff Horner John   589460 589460 Horner, John, of Spaldyng 1
3770748 1948538 1948538 defendant Wheteley Robert yeoman 589460 589460 Wheteley, Robert, of Spaldyng, yeoman 1
3770749 1948538 1948538 defendant Spensthorp Stephen fisher 589460 589460 Spensthorp, Stephen, of Spaldyng, fisher 2
3770970 1948606 1948606 defendant Shawe Richard yeoman 589460 589460 Shawe, Richard, of Spaldyng, yeoman 0
3774906 1949881 1949881 defendant Crokedake Thomas beer brewer 589460 589460 Crokedake, Thomas, of Spaldyng, beer brewer 0
3776281 1950329 1950329 plaintiff Brownswyne William   589460 589460 Brownswyne, William, of Spaldyng, waterman, administrators of 0
3776847 1950497 1950497 defendant Cheney William draper 589460 589460 Cheney, William, of Spaldyng, draper 0
3776947 1950533 1950533 defendant Gonnell Robert yeoman 589460 589460 Gonnell, Robert, of Spaldyng, yeoman 1
3778513 1950996 1950996 defendant Roos Thomas woolman 589460 589460 Roos, Thomas, of Spaldyng, woolman 0
3782761 1952354 1952354 plaintiff Jacson William   589460 589460 Jacson, William, of Spaldyng, coverlet weaver 0
3804726 1959424 1959424 defendant Wilson George laborer 589460 589460 Wilson, George, of Spaldyng, laborer 0
3805689 1959723 1959723 plaintiff Tomson Thomas tanner 589460 589460 Tomson Thomas, of Spaldyng, tanner, executor of 0
3808742 1960612 1960612 defendant Ogyll Richard gent 589460 589460 Ogyll, Richard, of Spaldyng, gent 4
3813681 1962193 1962193 defendant Boswell Robert barber 589460 589460 Boswell, Robert, of Spaldyng, barber 0
3817219 1963301 1963301 defendant Gall Thomas husbandman 589460 589460 Gall, Thomas, of Spaldyng, husbandman 0
3818591 1963717 1963717 defendant Storre Oswald cordwainer 589460 589460 Storre, Oswald, of Spaldyng, cordwainer 0
3822176 1964833 1964833 defendant Tothe John husbandman 589460 589460 Tothe, John, of Spaldyng, husbandman 0
3823220 1965176 1965176 plaintiff Tomson Thomas (legal representative) 589460 589460 Tomson, Thomas, of Spaldyng, tanner, executor of 0
3827092 1966332 1966332 defendant Belward John husbandman 589460 589460 Belward, John, of Spaldyng, husbandman 0
3828444 1966770 1966770 defendant Grene John fisher 589460 589460 Grene, John, of Spaldyng, fisher 0
3832061 1967928 1967928 defendant Goll Thomas husbandman 589460 589460 Goll, Thomas, of Spaldyng, husbandman 0
3832065 1967930 1967930 defendant Corby Thomas husbandman 589460 589460 Corby, Thomas, of Spaldyng, husbandman 0
3832919 1968221 1968221 defendant Pyttrell John, senior husbandman 589460 589460 Pyttrell, John, senior, of Spaldyng, husbandman 0
3832920 1968221 1968221 defendant Pyttrell Roland laborer 589460 589460 Pyttrell, Roland, of Spaldyng, laborer 1
3837526 1969646 1969646 defendant Barbour Thomas husbandman 589460 589460 Barbour, Thomas, of Spaldyng, husbandman 0
3853566 1974742 1974742 defendant Imyngham Thomas yeoman 589460 589460 Imyngham, Thomas, of Spaldyng, yeoman 0
3859598 1976704 1976704 defendant Dalaund William gent 589460 589460 Dalaund, William, of Spaldyng, gent 0
3859599 1976704 1976704 defendant Savage Richard laborer 589460 589460 Savage, Richard, of Spaldyng, laborer 1
3864043 1978157 1978157 defendant Harrys Thomas husbandman 589460 589460 Harrys, Thomas, of Spaldyng, husbandman 0
3864051 1978160 1978160 defendant Ryng Robert tailor 589460 589460 Ryng, Robert, of Spaldyng, tailor 0
3864150 1978197 1978197 defendant Daland William gent 589460 589460 Daland, William, of Spaldyng, gent 0
3865866 1978814 1978814 defendant Rudde Hugh tanner 589460 589460 Rudde, Hugh, of Spaldyng, tanner 0
3868011 1979535 1979535 defendant Symson Edmund butcher 589460 589460 Symson, Edmund, of Spaldyng, butcher 0
3868535 1979718 1979718 defendant Kytton William husbandman 589460 589460 Kytton, William, of Spaldyng, husbandman 0
3868573 1979727 1979727 defendant Whyte Ralph butcher 589460 589460 Whyte, Ralph, of Spaldyng, butcher 0
3873732 1981433 1981433 defendant Dalaund William gent 589460 589460 Dalaund, William, of Spaldyng, gent 0
3873733 1981433 1981433 defendant Savage Richard laborer 589460 589460 Savage, Richard, of Spaldyng, laborer 1
3873734 1981433 1981433 defendant Duckyn Anthony laborer 589460 589460 Duckyn, Anthony, of Spaldyng, laborer 2
3875453 1982035 1982035 defendant Nedam William waterman 589460 589460 Nedam, William, of Spaldyng, waterman 0
3878241 1982971 1982971 defendant Daland William gent 589460 589460 Daland, William, of Spaldyng, gent 0
3884891 1985219 1985219 defendant Cangood William fisher 589460 589460 Cangood, William, of Spaldyng, fisher 0
3890081 1986917 1986917 plaintiff Hart John   589460 589460 Hart, John, of Spaldyng 0
3898543 1989723 1989723 defendant Crossedale Christopher waterman 589460 589460 Crossedale, Christopher, of Spaldyng, waterman 0
3901622 1990771 1990771 plaintiff Crokedale Thomas (legal representative) 589460 589460 Crokedale, Thomas, of Spaldyng, beer brewer, executors of 0
3904624 1991800 1991800 defendant Coke Robert husbandman 589460 589460 Coke, Robert, of Spaldyng, husbandman 0
3905052 1991952 1991952 defendant Assheton Christopher draper 589460 589460 Assheton, Christopher, of Spaldyng, draper 0
3905295 1992038 1992038 defendant Ambre John husbandman 589460 589460 Ambre, John, of Spaldyng, husbandman 0
3907196 1992697 1992697 defendant Stanwell John fisher 589460 589460 Stanwell, John, of Spaldyng, fisher 1
3907197 1992697 1992697 defendant Hell Henry fisher 589460 589460 Hell, Henry, of Spaldyng, fisher 2
3907201 1992698 1992698 defendant Gune John husbandman 589460 589460 Gune, John, of Spaldyng, husbandman 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);