GAR Data Prep

GAR Gen Lyon Post 2 Roster, 1889 Data Prep

1. The booklet images downloaded from MoHist and merged into a PDF using ImageMagick
2. Google AI Studio was used with the prompt

transcribe pages 5 to 13 of this PDF and save as a CSV file with packet as "post2" as column 1, File Page Number as Scan in column 2, "ROLL NO" as column 3, Status ‡ if in NAME or † if in NAME or § if in NAME or * if in NAME, Sentence case Surname from NAME, Sentence case Given Name from NAME with no ".", "RANK, COMPANY, ETC" as Unit with quotes, "OCCUPATION AND RESIDENCE" as "Occupation Residence" with quotes

3. The output CSV processed for ingest into the Society’s database.
 

GAR Col Hassendeubel Post 13 Roster, 1890 Data Prep

1. The booklet images downloaded from MoHist and merged into a PDF using ImageMagick
2. Google AI Studio was used with the prompt

transcribe this PDF starting at page 18 and save as a CSV file with packet as "post13" as column 1, Scan column 2 of File Page Number, NO as column 3, Status ‡ if in NAME or † if in NAME or * if in NAME, Surname from NAME, Given Name from NAME with no ".", CO, REGIMENT, OCCUPATION, Residence or Business Address

3. The output CSV processed for ingest into the Society’s database.
 

GAR Harry P. Harding Post 107 Roster, 1901 Data Prep

1. The booklet images downloaded from MoHist and merged into a PDF using ImageMagick
2. Google AI Studio was used with the prompt

transcribe this PDF starting at page 18 and save as a CSV file with packet as "post13" as column 1, Scan column 2 of File Page Number, NO as column 3, transcribe pages 16 to 19 of this PDF and save as a CSV file with packet as "post107" as column 1, File Page Number as Scan in column 2, Surname from NAME, Given Name from NAME with no ".", "CO and REGIMENT" as Unit with quotes and "Co " in front, RESIDENCE as "Residence Occupation" with quotes

3. The output CSV processed for ingest into the Society’s database.
 

GAR Ransom Post 131 Members Data Prep

1. The charter image downloaded from MoHist.
2. For the name with death date records Google AI Studio was used with the prompt

transcribe pages 1 to 4 of this PDF and save as a CSV file with packet as "131_ransom_members" as column 1, File Page Number as Scan in column 2, Surname from NAME, Given Name from NAME with no ".", DEATH year as "Death Date"

3. For the name with unit and state Google AI Studio was used with the prompt

transcribe pages 8 to 11 of this PDF and save as a CSV file with packet as "131_ransom_members" as column 1, "File Page Number" as Scan in column 2, Surname from NAME, Given Name from NAME with no ".", "Company,Regiment" as Unit which quotes in column 5, Sentence case State in column 6

4. The two CSVs were merged and alphabetically sorted to create the final CSV.
5. The output CSV processed for ingest into the Society’s database.
 

GAR Julius P. Garesche Post 193 Charter Members, 1884 Data Prep

1. The charter from the Missouri Sons of Union Veterans of the Civil War PDF was downloaded.
2. Google AI Studio was used with the prompt

Transcribe the names and save as CSV Surname in column 1 and Given Name in column 2

3. The output CSV processed for ingest into the Society’s database.
 

GAR Missouri Death Rolls Index Data Prep

1. Downloaded the Proceedings of the Annual Encampments of the Department of Missouri, Grand Army of the Republic dated from 1882-1940 images at State Historical Society of Missouri
2. Merge the images into 19 seperate PDF files using Imagemagick.
3. Google AI Studio was used with the prompts

Transcribe all pages as text, prepend each row with File Page Number plus 1551 and ","

4. Using a custom script the text was split into a CSV file that was loaded into the Society’s database.

Last modified: 09-Mar-2026 13:35