Proposed Database Structure
Individuals Participating in the
War Between the States
This is a
proposed database structure designed to accommodate many
It should serve as a tool for identifying and indexing Confederate soldiers, sailors,
marines and citizens participating in the War Between the States.
At least 35
fields have been assigned for the collection of data.
Not all fields will necessarily be used for every individual.
With universally common fields, entries from various sources,
using a common format, this database will allow cataloging
and combining of data, allowing the creation of a much more
comprehensive knowledge-base. All suggestions and comments are solicited.
The first test of this database will be a
collection of CSA military who died in Union prisons
Proposed fields (28 Jun 2003) are listed here:
01 - Pre-assigned cemetery code or National Park Service #
02 - State-USPS code
03 - Last Name (abbreviate as necessary)
04 - Lirst Name (abbreviate as necessary)
05 - Service, CSA, CSN, CSN Marine, etc.
06 - Branch; Inf, Cav, H Arty, L Arty, etc.
07 - Rank - at beginning of enlistment; Pvt. Cpl, Sgt, MSgt, 1 Lt, B Gen, etc
08 - Rank - at end of enlistment
09 - CSA or CSN unit; ex: 13
10 - State (+ description, as needed - ex: NC JR, SR, HG)
11 - Death date (mm/dd/yyyy). (Leading space available for code)
12 - Cemetery code or description
13 - Grave #; either assigned # or cemetery code
14 - Interment date (Leading space available for code)
15 - Terms of enlistment-90d, war, CONscription
16 - Enlistment place 17 - Enlistment date (mm/dd/yyyy)
18 - Age at enlistment 19 - Wounded/Hospitalized
20 - Killed/Died (from wounds or disease), Accidental death, Shot as deserter.
21 - Cause of death
22 - Prisoner (P) Deserter (D)
23 - Location of prison (if confined)
24 - Location of prison (STate)
25 - Birth Date
26 - Birth Place
27 - Birth State
28 - Pension #
29 - State pension issued
30 - Pension Beneficiary
31 - Parents
32 - AFN/ID number (do we want a # used by on-line GEDs and LDS #'s?)
33 - Reference(s)
34 - Notes
35 - Military Record (database-not incl. on spreadsheets)
View sample data format.