The Civil War Soldiers and Sailors Database

As a lead-in to a more analytical article I plan on posting here toward the end of the month (hopefully), I thought it’d be useful to highlight this wonderful tool. The National Park Service’s Civil War Soldiers and Sailors Database (CWSS) is a thing of beauty. With a little info on a relative or subject of interest (say, a surname, a state, and on what side the subject fought), one can find service data on anyone who fought in the US Civil War. This includes what regiment they fought with, what company assigned to, rank in, and rank out. For me, it probably helped that “Greenberry Shanks” is a fairly unique name, because the CWSS immediately gave me the right data.


Then, to add context to this service, one can follow the link to the regiment. This leads to a fantastic summary of major engagements, such as this for the 11th Kentucky Cavalry.


You’ll note that many of these engagements are themselves hyperlinked to even more detail. I selected the first conflict at Saltsville:


The other kind of cool functionality that has one massively frustrating limitation, at least for researchers interested in unit data, is the link under the regiment’s history, View Battle Unit’s Soldiers. This brings you to a page where soldiers are listed alphabetically. That’s okay, if you’re unsure of how a name was spelled and need to page through 20 soldiers at a time.

Soldier List

I first discovered the CWSS through a blog post from another Civil War blog (Dead Confederates). In his post, which was published a couple of years ago, he highlighted another fantastic capability: there was an export button that allowed you to download an excel spreadsheet of the entire regiment. This was very exciting to me, since I’m currently taking a close look at the people who made up the regiment that my ancestor belonged to. So it was pretty aggravating when I went to the CWSS last year and discovered that this feature had been removed for some reason. I searched everywhere, and even emailed the site administrators and the NPS, but unfortunately never heard back.

Well, I was determined to get this data one way or another. I started scouring the National Archives and the farthest reaches of my search engines for anyone who may have stored it somewhere. All I found were broken links. On May 4 of this year, however, I had a breakthrough. After searching the corners of the Google-verse, I eventually turned up the data files used by the CWSS. The search was maddening, at least for me, as it was quite hard to find. I don’t even remember how I finally found it. I just tried to find it again, and the only way I could was to go back into my browser history and locate the download address. Here it is, if you’re interested:

Keep in mind, this is the raw data, over 800 MB of historical goodness, but not anything that is quickly used. Fortunately, I have a little background in SQL and excel, so I converted the data into a SQL table, and now I’m able to query the data in a number of ways. I’m trying to figure out how I can make this data available on my website, but I’m not sure this blog is the right medium. Until I crack that nut, feel free to ask for regimental soldier queries, as I’d be happy to help.

Speaking of which, my next article will be on Company A of the 11the Kentucky Cavalry. I’m using the CWSS data as a starting point to give me the name and rank of each member of the company, and then cross referencing those names in Fold3. Using that, I’m adding additional data to the names: their ages, the county where they’re from, occupations (if known), casualty data, and a few more data points.

My Spreadsheet
Example of cross referencing CWSS Data with other sources (e.g. Fold3). 

This will allow me to get a feel for the men who made up the company, as well as how they fared throughout the conflict. I’m almost a third of the way through the Company A roster (I’m trying to finish one company per month), and I’ve been fascinated with what I’ve learned so far. I look forward to sharing it with you.