Salem Witchcraft Dataset
Explore and visualize the Salem witchcraft trials
@kaggle.rtatman_salem_witchcraft_dataset
Explore and visualize the Salem witchcraft trials
@kaggle.rtatman_salem_witchcraft_dataset
Few events in American history are better known than the Salem witchcraft trials of 1692. Its popularity is doubtless attributable to a number of things: a persistent fascination with the occult; a perverse pleasure to expose the underbelly of an American culture that boasts of toleration, social harmony, and progress; and an appreciation for a compelling, dramatic narrative replete with heroes and villains. Skeptics, like the preeminent twentieth-century historian Perry Miller, question whether the Salem trials constituted anything more than an inconsequential episode in colonial history. But most historians consider Salem worthy of continuing investigation even if it was less than a major turning point in history. Indeed, Salem has been an unusually fertile field for historical research because it readily lends itself to new approaches, insights, and methodologies. To understand what happened in Salem, historians have profitably applied the perspectives of politics, anthropology, economic and social analysis, religion, social psychology, and demography. If the ultimate meaning of Salem is still elusive, these investigations have broadened and deepened our understanding of the 1692 witchcraft outbreak.
The Salem Witchcraft Website contains eight data sets. They provide only a small portion of the historical record about Salem. They do not contain transcripts of examinations or trials or contemporary narrative accounts, for example. Instead, they provide information, primarily of a quantitative nature, about three major aspects of the outbreak: its chronology, its geographic spread, and the social and economic divisions in Salem Village that shaped events. The data were derived primarily from four published sources: Paul Boyer and Stephen Nissenbaum's three-volume transcription of the legal records of the witchcraft trials, The Salem Witchcraft Papers; the new and now authoritative Records of the Salem Witch-Hunt, edited by Bernard Rosenthal, et. al.; Boyer and Nissenbaum's edited collection of documents, Salem-Village Witchcraft; and Salem Village's Book of Record, which contain tax records and other information relating to Salem Village. Photocopies of the original Salem Village record book and church records were examined at the Danvers Archival Center.
Users who copy, share, adapt, and re-publish any of the content in Salem Witchcraft Dataset should credit Professor Richard Latner of Tulane University for making this material available. More information and guided exercises can be found on this website.
CREATE TABLE accused_witches_data_set (
"accused_witch" VARCHAR,
"n__residence" VARCHAR -- Residence,
"month_of_accusation" BIGINT,
"month_of_execution" DOUBLE,
"sort" BIGINT
);
CREATE TABLE anti_parris_social_data_set (
"name" VARCHAR,
"identification" VARCHAR,
"sex" VARCHAR,
"sort" BIGINT
);
CREATE TABLE committee_list_data_set (
"committee_members" VARCHAR,
"petition" VARCHAR,
"social" VARCHAR,
"n_1685" DOUBLE -- 1685,
"n_1686" DOUBLE -- 1686,
"n_1687" DOUBLE -- 1687,
"n_1688" DOUBLE -- 1688,
"n_1689" DOUBLE -- 1689,
"n_1690" DOUBLE -- 1690,
"n_1691" DOUBLE -- 1691,
"n_1692" DOUBLE -- 1692,
"n_1693" DOUBLE -- 1693,
"n_1694" DOUBLE -- 1694,
"n_1695" DOUBLE -- 1695,
"n_1696" DOUBLE -- 1696,
"n_1697" DOUBLE -- 1697,
"n_1698" DOUBLE -- 1698,
"sort" BIGINT
);
CREATE TABLE committee_yearly_data_set (
"committee_1685" VARCHAR,
"petition" VARCHAR,
"social" VARCHAR,
"committee_1686" VARCHAR,
"petition_1" VARCHAR,
"social_1" VARCHAR,
"committee_1687" VARCHAR,
"petition_2" VARCHAR,
"social_2" VARCHAR,
"committee_1688" VARCHAR,
"petition_3" VARCHAR,
"social_3" VARCHAR,
"committee_1689" VARCHAR,
"petition_4" VARCHAR,
"social_4" VARCHAR,
"committee_1690" VARCHAR,
"petition_5" VARCHAR,
"social_5" VARCHAR,
"committee_1691" VARCHAR,
"petition_6" VARCHAR,
"social_6" VARCHAR,
"committee_1692" VARCHAR,
"petition_7" VARCHAR,
"social_7" VARCHAR,
"committee_1693" VARCHAR,
"petition_8" VARCHAR,
"social_8" VARCHAR,
"committee_1694" VARCHAR,
"petition_9" VARCHAR,
"social_9" VARCHAR,
"committee_1695" VARCHAR,
"petition_10" VARCHAR,
"social_10" VARCHAR,
"committee_1696" VARCHAR,
"petition_11" VARCHAR,
"social_11" VARCHAR,
"committee_1697" VARCHAR,
"petition_12" VARCHAR,
"social_12" VARCHAR,
"committee_1698" VARCHAR,
"petition_13" VARCHAR,
"social_13" VARCHAR
);
CREATE TABLE pro_parris_social_data_set (
"name" VARCHAR,
"identification" VARCHAR,
"sex" VARCHAR,
"sort" BIGINT
);
CREATE TABLE salem_village_data_set (
"name" VARCHAR,
"petition" VARCHAR,
"church_to_1696" VARCHAR,
"sort" BIGINT
);
CREATE TABLE tax_comparison_data_set (
"name" VARCHAR,
"petition" VARCHAR,
"n_1681" DOUBLE -- 1681,
"n_1690" DOUBLE -- 1690,
"n_1694" DOUBLE -- 1694,
"n_1695" DOUBLE -- 1695,
"n_1697" DOUBLE -- 1697,
"n_1700" DOUBLE -- 1700,
"sort" BIGINT
);
CREATE TABLE towns_data_set (
"bin" DOUBLE,
"n__amesbury" DOUBLE -- Amesbury,
"andover" BIGINT,
"beverly" DOUBLE,
"billerica" DOUBLE,
"boston" DOUBLE,
"boxford" DOUBLE,
"charlestown" DOUBLE,
"chelmsford" DOUBLE,
"gloucester" DOUBLE,
"haverhill" DOUBLE,
"ipswich" DOUBLE,
"lynn" DOUBLE,
"malden" DOUBLE,
"manchester" DOUBLE,
"marblehead" DOUBLE,
"piscataqua_maine" DOUBLE -- Piscataqua, Maine,
"reading" DOUBLE,
"rowley" DOUBLE,
"salem_town" DOUBLE,
"salem_village" DOUBLE,
"salisbury" DOUBLE,
"topsfield" DOUBLE,
"wells_maine" DOUBLE -- Wells, Maine,
"woburn" DOUBLE
);
Anyone who has the link will be able to view this.