Document Type

Dataset

Publication Date

2015

Description

7 data files in CSV and SQL format, presented in a zip file as the primary download and individually as supplemental content.

Abstract

Data to support the "Mapping the Second Ku Klux Klan, 1919-1940" project.

http://labs.library.vcu.edu/klan/

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:

http://scholarscompass.vcu.edu/hist_pubs/12/

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:

SELECT * FROM `klavern` JOIN sources ON klavern.id = sources.klavern_id JOIN states ON states.id = klavern.state_id WHERE states.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

File Format

CSV, SQL

Rights

CC BY-NC-SA 3.0 https://creativecommons.org/licenses/by-nc-sa/3.0/

Is Part Of

VCU History Data

Date of Submission

11-2015

klaverns_all_sans_sources.csv (153 kB)
Klaverns All Sans Sources

klavern.csv (151 kB)
Klavern

klavern.sql (267 kB)
Klavern

sources.csv (151 kB)
Sources

sources.sql (260 kB)
Sources

states.csv (1 kB)
States

states.sql (3 kB)
States

Included in

History Commons

Share

 
COinS