7 data files in CSV and SQL format, presented in a zip file as the primary download and individually as supplemental content.
Data to support the "Mapping the Second Ku Klux Klan, 1919-1940" project.
The article, "Publicity and Prejudice: The New York World’s Exposé of 1921 and the History of the Second Ku Klux Klan", provides additional context to the data:
The zip download file contains 4 CSV (comma separated value) files and 3 SQL (structured query language) files that will help researchers recreate the project database that was compiled from the research notes of Dr. John Kneebone.
The CSV files can be opened using any spreadsheet software including Microsoft Excel. The SQL files can be opened using Excel or database software such as Microsoft Access.
For a quick analysis, the list of all Klaverns, minus the data sources, can be found in klaverns_all_sans_sources.csv. To recreate the full database structure, use the remaining CSV or SQL files.
The geospatial coordinates are approximate town/city centers as dictated by Google Maps and/or Wikipedia.
Useful SQL queries:
Query to return all klaverns by state:
Query to return all klaverns founded by a certain year:
SELECT * FROM `klavern` WHERE klavern.year =
Research compiled by Dr. John Kneebone. Database export and quality assurance by Shariq Torres.
Last data update: 12/1/2015
CC BY-NC-SA 3.0 https://creativecommons.org/licenses/by-nc-sa/3.0/
Is Part Of
VCU History Data
Date of Submission