Database Update: Reached the end of the war

With my laser focus on just adding sailors on and off the boston, I have reached September 1945 when the war ended. Given the gaps on the records and the readable records this will take a while to completely clean up, but I have 2,363 records to date in the database with some form of sailor ID, First Name, Last Name and many with enlistment place and date records. Currently, I need to add 1,466 records of sailors departures after the war was over, we’ve already have 5,713 records of arrivals and departures. I also have about 22 records where a sailor left the ship without arriving, arrived or departed twice in succession (which is obviously an error!), I have about 7 orphan records where I have Sailor information and no add or received records (this happens when I find an error in the navy ID and fix it in the sailor record and forget to fix the on/off records). Given my original records from Frank Studenski’s diary I expect to add an additional 127 sailors who I believe have been missed due to unreadable records.

One interesting data point which I’d like to analyze further is the number of sailors who went to the hospital after the ship arrived in San Pedro in May of 1945 looks very high. My plan is to do a separate Hospital analysis.

We’ve recorded a few deaths, during the records, but I’d like to correlate these with the Deck Log to find out exactly what happened. The few I know about were from natural causes and one was electrocution.

As I said before, Since april-may of 1945 I’ve lost enlistment data for new sailors added in 1945, the data simply wasn’t recorded because it looks like the navy was preparating for computerized records and decided they no longer had to record where each sailor enlist and the enlistment date for every record. I’ll have to fix the display for these sailor records, because it says they enlisted at “,” which looks dumb. I’ve processed 985 pages of records for sailors coming on off the boston, I have 187 pages left to process.

I’ve made a decision that since this blog is about the BOSTON in World War II AND I’m not going to add sailors who joined the boston after the war was actually over. If you disagree with me let me know and we can discuss it, just hit the contact button and let me know.

thanks,
Bill