###################################### Fox (1898) battle casualties (revised) ###################################### :name: fox_forces :path: fox_forces.csv :format: csv Data from William F. Fox *Regimental Losses in the American Civil War, 1861-1865: A Treatise on the extent and nature of the mortuary losses in the Union regiments, with full and exhaustive statistics compiled from the official records on file in the state military bureaus and at Washington*, Chapter 14 "The Greatest Battles of the War, list of victories and defeats, chronological list of battles with loss in each, Union and Confederate", p. 543--. Available from `Perseus `__. The unit of observation is the force (battle, belligerent), because the reporting of casualties for durations and locations differs between the Union and Confederate forces. This data is similar to :doc:`fox_forces`, but differs in some revisions, which largely come from the notes in the souce table. - removed aggregate rows for Union casualties in Atlanta Campaign and Seven Day's Battle - fn 8. Split Chancellorsville into casualties for Chancellorsville (VA032) and VA033 VA034 - fn 24. Split Chattanooga into Orchard's Knob on 11/23, Lookout Mountain on 11/24 and Missionary Ridge on 11/25. The footnote only gives total casualties for 11/23 and 11/24, so I assume a constant proportion of K/W/M for all days. - fn 25. Split Atlanta Campaign into the components in the footnote. Remainder is assigned to "Lattimore's Mill; Powder Springs, etc". - fn 27. Split Atlanta Campaign into the components in the footnote. It's unclear which entries to assign to the Marietta Operations. - fn 28. Split Atlanta campaign into the components in the footnote. Remainder assigned to the Siege of Atlanta. I'm not sure what the Siege of Atlanta refers to so I assign it to the Jonesboro (GA020) and Lovejoy Station (GA021) - Split Spotsylvania into the components in the footnote. - fn 29. The note says Jonesboro and Lovejoy Station, but Jonesboro happened on Aug 20, so it cannot be included in this row. - fn 70. Split Seven Days Battle into the component battles. - fn 74. Added the 90 casualties from White's battalion. Fox lists alternate casualty figures for Confederates at Gettysburg that I don't use. The records on file at Washington bear the names of 6,802 wounded, and 5,425 unwounded Confederates captured at Gettysburg. The official reports of Longstreet, Ewell, Hill, and Stuart indicate a loss (after making necessary deductions) of 2,701 killed, 12,739 wounded, 7,528 missing; total, 22,968. See :doc:`fox_forces` for more detail on the Fox data. - Union and Confederate casualties for Front Royal and Winchester, Va. (1862-5-23 to 1862-5-25) combines the battles of Front Royal (1862-5-23) and Winchester I (1862-5-25) - Union and Confederate casualties for Manassas, Va. (1862-8-16 to 1862-8-31) combines battles from Rappahannock through - Union entry for Marye's Heights and Salem Church (1863-5-3 to 1863-5-4) combines the battles of Fredericksburg II and Salem Church - Union casualties are given for the entire Siege of Suffolk, Va. (1863-4-11 to 1863-4-30) which includes VA030 and VA031 - For Vicksburg, Union casualties are divided into - Assault on Vicksburg, Miss. (1863-5-19) - Assault on Vicksburg, Miss. (1863-5-22) - Vicksburg Trenches, Miss. (1863-5-23 to 1863-7-4) - For Port Hudson, Union casualties are divided into - Assault on Port Hudson, La. (1863-5-27) - Assault on Port Hudson, La. (1863-6-14) - Port Hudson Trenches, La. (1863-5-26 to 1863-7-9) - Morgan's Raid, Ky. (1863-7-2 to 1863-7-26) includes several battles - U120: Siege of Fort Wagner, S. C. (1863-7-1 to 1863-7-31) does not quite correspond to any of the CWSAC Charleston battles. - Union casualties for Spotsylvania Court house are given for the entire battle: and on separate days. - Spotsylvania, Va. (1864-5-8 to 1864-5-21) - Alsop's Farm (Spotsylvania) (1864-5-8) - Po River, Laurel Hill, and Upton's Charge (Spotsylvania) (1864-5-10) - Hancock's Assault, the "Angle", and general attack of May 12 (Spotsylvania) (1864-5-12) - Spotsylvania (Spotsylvania) (1864-5-18) - Fredericksburg Pike (Spotsylvania) (1864-5-19) - Todd's Tavern; Corbin's Bridge; Ny River; Guinea Station etc. (Spotsylvania) (1864-5-8 to 1864-5-21) - Wilson's Raid, Va. (1864-6-22 to 1864-6-29) includes several battles - Union casualties for Smithfield Crossing (WV015) are given for separate days. Battles of Halltown, VA on Aug 24 and Aug 26 may also be part of this battle, but it is unclear if they are the same engagement. - Union casualties for Wilmington (NC016) is split into - Sugar Loaf Battery, N. C. (1865-2-11) - Town Creek, N. C. (1865-2-20) - Union Casualties for Fort Stedman, VA (1865-03-25) [VA084] is split into - Fort Stedman, Va. (1865-3-25) - Petersburg, Va. (1865-3-25) - Union casualties for Chattanooga III, TN (1863-11-23 to 1863-11-25) [VA024] is split into - Missionary Ridge (Chattanooga, Tenn) (1863-11-25) - Orchard Knob (Chattanooga, Tenn) (1863-11-23) - Lookout Mountain (Chattanooga, Tenn) (1863-11-24 to 1865-11-24) - Confederate casualties for Maryland Campaign, Md (1862-9-12 to 1862-9-20) combines several battles. - Confederate casualties for Corinth, Miss. (1862-10-3 to 1862-10-5) includes both Corinth [MS002], and the battle of Hatchie's Bridge [TN007] on Oct 5th. These Union casualties only includes the Battle of Corinth (Oct 3-4, 1862). - Confederate casualties for Springfield; Hartsville, Mo. (1863-1-2 to 1863-1-11) combines the battles of Springfield (Jan 8) [MO018] and Hatville (Jan 9-11) [MO019]. Union casualties are given separately for each battle. Sources: [fox1898regimental]_ Schema ====== :Primary Key: ['battle_id'] ================== ======= ================== battle_id string Battle Id. belligerent string belligerent battle_name string Battle name start_date date start_date end_date date end_date state string State killed integer Killed wounded integer wounded missing integer missing casualties integer casualties aggregates_battles boolean aggregates_battles comment string comment from_footnote boolean from_footnote ================== ======= ================== battle_id --------- :title: Battle Id. :type: string :constraints: :pattern: [UC][1-9]+[A-Z]? Unique battle identifier. belligerent ----------- :title: belligerent :type: string :format: default :constraints: :enum: ['Confederate', 'US'] battle_name ----------- :title: Battle name :type: string :format: default start_date ---------- :title: start_date :type: date :format: default Start date of the battle end_date -------- :title: end_date :type: date :format: default End date of the battle state ----- :title: State :type: string :format: default :constraints: :minLength: 2 :maxLength: 2 :pattern: [A-Z]{2} State in which the battle took place. killed ------ :title: Killed :type: integer :format: default :constraints: :minimum: 0 Number killed wounded ------- :title: wounded :type: integer :format: default :constraints: :minimum: 0 Number wounded missing ------- :title: missing :type: integer :format: default :constraints: :minimum: 0 Number missing casualties ---------- :title: casualties :type: integer :format: default :constraints: :minimum: 0 Number of casualties (killed, wounded, and missing) aggregates_battles ------------------ :title: aggregates_battles :type: boolean :format: default comment ------- :title: comment :type: string :format: default Comments attached to the observation. These are generally footnotes from the original source. from_footnote ------------- :title: from_footnote :type: boolean :format: default Was this observation derived from notes in a footnotes?