Battle level data combining the National Park Services reports: preliminary CWSAC reports in the AAD (1990-1993), CWSAC Report battle summaries (1997), Civil War Soldiers and Sailors (CWSS) database, and the CWSAC Report Updates (2009-2013).
This table combines data from those various sources in a consistent manner.
Schema
cwsac_id |
string |
CWSAC Id. |
battle_name |
string |
battle_name |
start_date |
date |
Start date |
end_date |
date |
End date |
theater_code |
string |
theater_code |
campaign_code |
string |
campaign_code |
result |
string |
result |
cwss_url |
string |
CWSS URL |
partof_cwss |
boolean |
Part of CWSS |
operation |
boolean |
operation |
forces_text |
string |
Forces text |
casualties_text |
string |
Casualties text |
results_text |
string |
Results text |
preservation |
string |
preservation |
significance |
string |
significance |
cwsac_url |
string |
cwsac_url |
other_names |
string |
other_names |
partof_cwsac |
boolean |
Part of CWSAC |
cws2_url |
string |
cws2_url |
study_area |
number |
Study Area |
core_area |
number |
Core Area |
potnr_boundary |
number |
potnr_boundary |
partof_cws2 |
boolean |
partof_cws2 |
interpretive_political |
integer |
interpretive_political |
interpretive_commander_loss |
integer |
interpretive_commander_loss |
interpretive_casualties |
integer |
interpretive_casualties |
interpretive_tactics_strategy |
integer |
interpretive_tactics_strategy |
interpretive_public_mind |
integer |
interpretive_public_mind |
interpretive_combat_arm |
integer |
interpretive_combat_arm |
interpretive_military_firsts |
integer |
interpretive_military_firsts |
interpretive_minority_troops |
integer |
interpretive_minority_troops |
interpretive_economic |
integer |
interpretive_economic |
interpretive_archaelolgical |
integer |
interpretive_archaelolgical |
interpretive_logistics |
integer |
interpretive_logistics |
interpretive_individual_bravery |
integer |
interpretive_individual_bravery |
interpretive_group_behavior |
integer |
interpretive_group_behavior |
interpretive_joint_ops |
integer |
interpretive_joint_ops |
interpretive_coop_armies |
integer |
interpretive_coop_armies |
interpretive_naval |
integer |
interpretive_naval |
significance_jim |
string |
significance_jim |
significance_ed |
string |
significance_ed |
significance_bill |
string |
significance_bill |
aad_url |
string |
aad_url |
battle_type |
string |
Battle Type |
partof_aad |
boolean |
partof_aad |
lat |
number |
Latitude |
long |
number |
Longitude |
state |
string |
State |
strength |
number |
Strength |
casualties_kwm |
number |
Casualties |
cwsac_id
title: | CWSAC Id.
|
type: | string
|
format: | default
|
constraints: |
minLength: | 5 |
maxLength: | 6 |
pattern: | [A-Z]{2}[0-9]{3}[A-Z]? |
|
CWSAC battle identifier
battle_name
title: | battle_name |
type: | string |
format: | default |
start_date
title: | Start date |
type: | date |
format: | default |
end_date
title: | End date |
type: | date |
format: | default |
theater_code
title: | theater_code
|
type: | string
|
format: | default
|
constraints: |
enum: | [‘LS’, ‘ME’, ‘MW’, ‘PC’, ‘TM’] |
|
CWSS theater code. See NPS combined data battle data: theaters for descriptions of the theaters.
campaign_code
title: | campaign_code
|
type: | string
|
format: | default
|
constraints: |
pattern: | (LS|ME|MW|PC|TM)[0-9]{3}-[0-9]{2} |
|
CWSS campaign code. See NPS combined data battle data: campaigns for descriptions of the campaigns.
result
title: | result
|
type: | string
|
format: | default
|
constraints: |
enum: | [‘Union’, ‘Confederate’, ‘Indecisive’] |
|
Result of the battle: Union victory, Confederate victory, or Indecisive.
cwss_url
title: | CWSS URL |
type: | string |
format: | url |
URL of the battle’s page in the Civil War Soldiers and Sailors website.
partof_cwss
title: | Part of CWSS |
type: | boolean |
format: | default |
Was this battle included in the CWSS.
operation
title: | operation |
type: | boolean |
format: | default |
Was this battle an operation (multiple battles)? In the data, Manasas Station Operations and Marietta Operations are classified as operations.
forces_text
title: | Forces text |
type: | string |
format: | default |
Description of the forces engaged in the battle, from the CWSAC.
casualties_text
title: | Casualties text |
type: | string |
format: | default |
Description of the casualties of the forces engaged in the battle, from the CWSAC.
results_text
title: | Results text |
type: | string |
format: | default |
Description of the result of the battle, from the CWSAC. This will sometimes include more information about the results, including whether it was a strategic or tactical victory, or if the battle’s result differed from the result of the campaign.
significance
title: | significance
|
type: | string
|
format: | default
|
constraints: |
enum: | [‘A’, ‘B’, ‘C’, ‘D’] |
|
The military significance of the battle, from A ” having a decisive influence on a campaign and a direct impact on the course of the war” to D “having a limited influence on the outcome of their campaign or operation but achieving or affecting important local objectives”. This determined by the National Part Service CWSAC Report with input from Edwin C. Bearss, William J. Cooper, and James McPherson.
cwsac_url
title: | cwsac_url |
type: | string |
format: | url |
URL of the battle summary on the CWSAC Battle Summaries <http://www.nps.gov/abpp/battles/bystate.htm> website.
other_names
title: | other_names |
type: | string |
format: | default |
partof_cwsac
title: | Part of CWSAC |
type: | boolean |
format: | default |
Was this battle included in the 1993 CWSAC Report.
cws2_url
title: | cws2_url |
type: | string |
format: | default |
URL of the report including the battle in the Draft State by State Updates to the Civil War Sites Advisory Commission Report <http://www.nps.gov/abpp/CWSII/CWSIIStateReports.htm>.
potnr_boundary
title: | potnr_boundary |
type: | number |
format: | default |
partof_cws2
title: | partof_cws2 |
type: | boolean |
format: | default |
aad_url
title: | aad_url |
type: | string |
format: | URL |
URL of the initial battle’s report for the CWSAC as archived by the AAD.
battle_type
title: | Battle Type
|
type: | string
|
constraints: |
enum: | [‘Action’, ‘Attack’, ‘Naval Operations’, ‘Demonstration’, ‘Siege & Capture’, ‘Engagement’, ‘Battle’, ‘Skirmish’, ‘Bombardment’, ‘Operation’, ‘Naval’, ‘Combat’, ‘Assault’, ‘Massacre’, ‘Siege’, ‘Bombardment & Capture’, ‘Occupation’, ‘Capture’, ‘Advance & Siege’, ‘Expedition’, ‘Recapture’] |
|
Type of battle. Both the AAD and CWSS provide battle type categories. However, the AAD is more complete and so is the one used.
partof_aad
title: | partof_aad |
type: | boolean |
format: | default |
lat
title: | Latitude |
type: | number |
format: | default |
Latittude of the battle. This is roughly the midpoint of the core area of the battle as indicated in the CWSAC II report maps.
long
title: | Longitude |
type: | number |
format: | default |
Latittude of the battle. This is roughly the midpoint of the core area of the battle as indicated in the CWSAC II report maps.
state
title: | State
|
type: | string
|
format: | default
|
constraints: |
|
strength
title: | Strength
|
type: | number
|
format: | default
|
constraints: |
|
Total (Confederate and Union) personnel engaged in the battle. This combines data from the CWSS, CWSAC, and CWSAC II sources. For some battle the total personnel is given, even though the individual Confederate and Union values are missing.
casualties_kwm
title: | Casualties
|
type: | number
|
format: | default
|
constraints: |
|
Total (Confederate and Union) casualties in the battle. This combines data from the CWSS and CWSAC sources. For some battle the total personnel is given, even though the individual Confederate and Union values are missing.