Sunday, February 20, 2011

Military Records of Civil War Vet Madison Lewis

I discovered Madison Lewis’ Civil War service record and pension index card through research on a few weeks ago. Madison enlisted in the 1st Regiment, United States Colored Cavalry, Company B on December 22, 1863 at Camp Hamilton located in Hampton, VA. Later I searched the database on the Civil War Soldiers and Sailor System where I located the names of other soldiers in Madison’s regiment as well as a regiment history. Since these discoveries, I have been studying and analyzing these records.

Additionally I also typed up a timeline of events in Microsoft Excel from the service record and regiment history in order to make some sense of the military career of Madison Lewis. I use Microsoft Excel often for these type of research project because of the ability to sort and filter the data. Any spreadsheet software or table in word processing software would assist in analyzing genealogical data.

Typing up a timeline in Microsoft Excel with regiment and service record dates and events helps me to understand the military career of Madison Lewis.

I look forward to looking at the pension records of Madison Lewis soon. I’m sure this record will contain genealogy gems that will take me on a new research trial. Maybe, if I’m lucky, there will be a tin type photo of Madison in his file.


  1. Dru,
    I really like how you used Excel for your timeline. I think I'm going to give that a try with the next one I do. (I might need your help!)

    Keep up the good work!


  2. I'm enjoying following along. I told Angela that the two of you almost have me convinced to adopt my own solider.