Counting Wrecks: Visualizing T.A. Scott’s salvage work, 1879-1902

This summer I updated my database of T.A. Scott’s rescue and salvage work for the period between 1879 and 1902. After not thinking much about this data set for three years, I plunged back into historical newspaper databases (much expanded and improved in just a couple of years) and added more than 50 events to the database. I’m sure there are more Scott salvage jobs still hiding in obscure newspapers, but I’m feeling pretty confident I found the vast majority. All told, the database includes 247 separate rescue or salvage events. It’s not clear how many he personally supervised (contemporaries often seemed to conflate Scott the man with Scott the salvage company), but I think it safe to say he was personally involved in most. The database includes the month, year, type of vessel involved in the incident, the vessel’s name, the type of wreck (founding, stranding, ice, fire, damaged), and whether or not it was recovered or repaired. After cleaning up the database with OpenRefine, I used Excel and Tableau Public to create the initial visualizations below. I’m working up some fancier ways to display this data… look for those soon.

The first two graphs show the annual and seasonal variation in Scott’s salvage work. Marine salvage was anything but steady and the wide variation in salvage work belies just how important non-salvage activities must have been to the T.A. Scott Company. Winter and spring were his busiest salvage seasons. Summer activity was slower because there were fewer wrecks and because he focused resources on lucrative (and relatively steady) marine construction jobs. I want to plot Scott’s work against the number of reported incidents in eastern Long Island Sound to see if there is any correlation between number of wrecks/incidents and his salvage activity.

scott-wrecksperyearscott-wreckspermonth

Other trends emerge as we dig into the data. Most notably, the bulk of Scott’s salvage work involved stranded schooners. Steamers and barges were tied for a distant second and an eclectic mix 13 other vessel types took up the remainder. Second, we have large gaps in the data — we do not know, for example, the “type” of wreck for 67 incidents. Possibly with further research we’ll be able to fill in these blanks. (to explore the graphs click here and here.)

screen-shot-2016-09-12-at-12-14-22-pmscreen-shot-2016-09-12-at-12-15-13-pm

More to come soon…

Advertisements

Leave a comment

Filed under Notes from the Field

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s