Document Type

Dataset

Publication Date

2023

Description

1 data file in CSV as the primary download. Also includes supplemental content in zip format of data from 2015 and 2018.

Abstract

Data to support the "Mapping the Second Ku Klux Klan, 1919-1940" project. The data provides a rough timeline of the rise of the second Ku Klux Klan between 1915 and 1940. 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

Research compiled by Dr. John Kneebone. Database export and quality assurance from 2015 by Shariq Torres. 2023 updates include significant contributions regarding Alabama from Dr. Kenneth C. Barnes, Professor of History, University of Central Arkansas.

The 2023 data includes the following fields

  • ID: unique identifier for each klavern (a local unit of the Ku Klux Klan) in the dataset

  • State: U.S. State in which klavern was located

  • City: City in which klavern was located

  • Klan_number: Number of klavern (in each state these were sequentially assigned as each new klavern was established)

  • Nickname: klavern nickname if noted in sources

  • Notes: notes on klavern from researchers

  • Latitude: latitude of the city (Geospatial coordinates are approximate town/city centers as found through Google Maps and/or Wikipedia)

  • Longitude: longitude of the city (Geospatial coordinates are approximate town/city centers as found through Google Maps and/or Wikipedia)

  • Year: Year founded by. Estimated by presence of klavern in sources and relation to other klavern founding dates assuming that each klavern was numbered sequentially.

  • Sources: Sources documenting each klavern. Multiple sources delimited by a pipe “|”

Last data update: 2023-12-06. The initial files published in 2015 and an update from 2018 are included here as supplementary zip files.

The zip download file contains 3 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.

The geospatial coordinates are approximate town/city centers as dictated by found through Google Maps and/or Wikipedia.

Useful SQL queries:

Query to return all klThe geospatial coordinates are approximate town/city centers as dictated by found through Google Maps and/or Wikipedia.averns 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 =

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

12-14-2023

klan_data_2015.zip (215 kB)
Klan Data (2015 version)

2018_Klan_data.zip (158 kB)
Klan data (2018 version)

Included in

History Commons

Share

 
COinS