7 min read

Lost Cargo in Wisconsin Shipwrecks


wordcloud
Lumber was the word that appeared with the greatest frequency.

View raw source for this post

Summary

The Wisconsin Historical Society created a database of shipwrecks in its waters. The shipwrecks occurred between the years 1679 and 1981. The total number of observations with location data was 615. A text field was included describing the cargo of the ships. A wordcloud of the most frequently used words is created from the text field.

Table of Contents

Figure 1: A wordcloud of the most frequently used words in the cargo description.

Overview

The data for this project comes from wisconsinshipwrecks.org. Once put into a “tidy” format, there were twenty-nine variables.[1] One of the more interesting–and probably difficult to construct for the researchers–was a field entitled cargo_description. I was unsure what to do with it, but there were so much narrative that provides a look into shipping in the late 1800s and early 1900s.

Background

This post, How to Generate Word Clouds in R, was successfully followed and resulted in the ouput above. It is rare for me to be able to duplicate the methodology of another post without any problems, but it occurred here. I ended up using the wordcloud2 package to create the output which is a widget.

Analysis

The different elements in the cargo_description file contained brief descriptions of the contents of each ship and many were either blank or “NA.” 76.42% of the observations contained some text. The cargo_description variable was arranged in descending order by the number of characters within the field. The five longest are displayed below:

names sunk cargo_description length
Manistee (1867) 1883 10,000 bushels of oats, 90 tons of mill feed, 1,254 barrels of flour, 9 tons of furniture and mercanhadise, a large quantity doors and sashes, and a handful of passengers who were transferred to the Dulurth before she left Bayfield. "“Persistent rumors concerning the Manistee’s”“other”" cargo abound, and warrant mention. On board there were allegedly 100 tons of pure copper bars, plus a large quantity of gold and silver in the ship’s strongbox. The weight of the copper, some locals speculated, was obviously a factor in the Manistee’s list - if that is what happened. This "“secret”" cargo was never definitely proven."" The Unholy Apostles by James Keller. 668
Lakeland (1887) 1924 Nash, Kissel and one Rollin Motor car and a stationary steam engine. At the time of the sinking the exact number of vehicles was not clear. Reports varied from "“40 Nash and Kissel cars”" to 50 automobiles to "“her decks were full of new automobiles”". Other sources claimed that there was between 19 and 50 vehicles. In actuality, at least twenty-two 1925 Nash, Kissel and the one Rollin cars have been verified by divers. The freighter was capable of carrying 250 cars. Her gross carrying capacity was rated at 1,878.1 tons; 1,773.61 under deck and 94.49 tons within the cabin space on the upper deck. 611
Milwaukee (1903) 1929 Passengers and 25 loaded train cars. The train cars were loaded with the following: 2 train cars of lumber, 3 cars of barley, 7 cars of feed, 2 cars of peas, 1 car of grits, 1 car of corn, 3 cars of salt, 1 car of butter, 1 car of veneer, 2 cars of bathtubs, 1 car of cheese, and 1 car with 3 automobiles. The cargo was valued at $100,000 and the train cars themselves were valued at $63,500. 395
Phoenix (1845) 1847 When the Phoenix cleared Buffalo she had on board 23 officers and crewmen, 186 passengers (mainly immigrants from Holland), household goods, molasses, sugar, coffee,hardware and chains destined for Chicago. The Phoenix possibly could have added some American passengers at her scheduled stops at Cleveland and Detroit. Record keeping was poor and the ship’s papers were lost in the fire. 389
George Hanson (1847) 1857 The vessel was either light with only stone ballast bound from Chicago to Dutchman’s Point (northern Illinois) for a cargo of wood or the George Hanson had already picked up a cargo of lumber from either Kenosha or Racine when she capsized. 240

Special Note

The “Phoenix” bears the infamous record of most fatalities in the Wisconsin shipwrecks database. Total deaths in the shipwreck database are 823. To understand the magnitude the tradgedy, the chart below shows the number of lives lost by ship. According to a wikipedia article, the number of lives lost on the Phoenix was estimated to be much higher than the 190 reported.

names sunk lives
Phoenix (1845) 1847 190
Niagara (1845) 1856 60
Vernon (1886) 1887 48
Milwaukee (1903) 1929 46
Toledo (1854) 1856 40

References

[1]
Wisconsin Historical Society, “Wisconsin Shipwrecks.” 2014 [Online]. Available: https://geodata.wisc.edu/catalog/35EC573E-282C-40DD-8512-CE14E033F989
[2]
R Core Team, R: A language and environment for statistical computing. Vienna, Austria: R Foundation for Statistical Computing, 2020 [Online]. Available: https://www.R-project.org/
[3]
Y. Xie, C. Dervieux, and A. Presmanes Hill, Blogdown: Create blogs and websites with r markdown. 2021 [Online]. Available: https://CRAN.R-project.org/package=blogdown
[4]
I. Feinerer and K. Hornik, Tm: Text mining package. 2020 [Online]. Available: http://tm.r-forge.r-project.org/
[5]
I. Fellows, Wordcloud: Word clouds. 2018 [Online]. Available: https://CRAN.R-project.org/package=wordcloud
[6]
D. Lang and G. Chien, wordcloud2: Create word cloud by htmlwidget. 2018 [Online]. Available: https://github.com/lchiffon/wordcloud2

Disclaimer

The views, analysis and conclusions presented within this paper represent the author’s alone and not of any other person, organization or government entity. While I have made every reasonable effort to ensure that the information in this article was correct, it will nonetheless contain errors, inaccuracies and inconsistencies. It is a working paper subject to revision without notice as additional information becomes available. Any liability is disclaimed as to any party for any loss, damage, or disruption caused by errors or omissions, whether such errors or omissions result from negligence, accident, or any other cause. The author(s) received no financial support for the research, authorship, and/or publication of this article.

Reproducibility

─ Session info ───────────────────────────────────────────────────────────────────────────────────────────────────────
 setting  value                       
 version  R version 3.6.3 (2020-02-29)
 os       macOS Catalina 10.15.7      
 system   x86_64, darwin15.6.0        
 ui       X11                         
 language (EN)                        
 collate  en_US.UTF-8                 
 ctype    en_US.UTF-8                 
 tz       America/Chicago             
 date     2021-03-20                  

─ Packages ───────────────────────────────────────────────────────────────────────────────────────────────────────────
 package     * version date       lib source        
 assertthat    0.2.1   2019-03-21 [1] CRAN (R 3.6.0)
 blogdown    * 1.2     2021-03-04 [1] CRAN (R 3.6.3)
 bookdown      0.21    2020-10-13 [1] CRAN (R 3.6.3)
 bslib         0.2.4   2021-01-25 [1] CRAN (R 3.6.2)
 cachem        1.0.4   2021-02-13 [1] CRAN (R 3.6.2)
 callr         3.5.1   2020-10-13 [1] CRAN (R 3.6.2)
 cli           2.3.1   2021-02-23 [1] CRAN (R 3.6.3)
 codetools     0.2-18  2020-11-04 [1] CRAN (R 3.6.2)
 colorspace    2.0-0   2020-11-11 [1] CRAN (R 3.6.2)
 crayon        1.4.1   2021-02-08 [1] CRAN (R 3.6.2)
 DBI           1.1.1   2021-01-15 [1] CRAN (R 3.6.2)
 desc          1.3.0   2021-03-05 [1] CRAN (R 3.6.3)
 devtools    * 2.3.2   2020-09-18 [1] CRAN (R 3.6.2)
 digest        0.6.27  2020-10-24 [1] CRAN (R 3.6.2)
 dplyr         1.0.5   2021-03-05 [1] CRAN (R 3.6.3)
 ellipsis      0.3.1   2020-05-15 [1] CRAN (R 3.6.2)
 evaluate      0.14    2019-05-28 [1] CRAN (R 3.6.0)
 fansi         0.4.2   2021-01-15 [1] CRAN (R 3.6.2)
 farver        2.1.0   2021-02-28 [1] CRAN (R 3.6.3)
 fastmap       1.1.0   2021-01-25 [1] CRAN (R 3.6.2)
 fs            1.5.0   2020-07-31 [1] CRAN (R 3.6.2)
 generics      0.1.0   2020-10-31 [1] CRAN (R 3.6.2)
 ggplot2     * 3.3.3   2020-12-30 [1] CRAN (R 3.6.2)
 ggthemes    * 4.2.4   2021-01-20 [1] CRAN (R 3.6.2)
 glue          1.4.2   2020-08-27 [1] CRAN (R 3.6.2)
 gtable        0.3.0   2019-03-25 [1] CRAN (R 3.6.0)
 highr         0.8     2019-03-20 [1] CRAN (R 3.6.0)
 htmltools     0.5.1.1 2021-01-22 [1] CRAN (R 3.6.2)
 jquerylib     0.1.3   2020-12-17 [1] CRAN (R 3.6.2)
 jsonlite      1.7.2   2020-12-09 [1] CRAN (R 3.6.2)
 knitr         1.31    2021-01-27 [1] CRAN (R 3.6.2)
 labeling      0.4.2   2020-10-20 [1] CRAN (R 3.6.2)
 lifecycle     1.0.0   2021-02-15 [1] CRAN (R 3.6.2)
 magrittr      2.0.1   2020-11-17 [1] CRAN (R 3.6.2)
 memoise       2.0.0   2021-01-26 [1] CRAN (R 3.6.2)
 munsell       0.5.0   2018-06-12 [1] CRAN (R 3.6.0)
 pillar        1.5.1   2021-03-05 [1] CRAN (R 3.6.3)
 pkgbuild      1.2.0   2020-12-15 [1] CRAN (R 3.6.2)
 pkgconfig     2.0.3   2019-09-22 [1] CRAN (R 3.6.0)
 pkgload       1.2.0   2021-02-23 [1] CRAN (R 3.6.3)
 prettyunits   1.1.1   2020-01-24 [1] CRAN (R 3.6.0)
 processx      3.4.5   2020-11-30 [1] CRAN (R 3.6.2)
 ps            1.6.0   2021-02-28 [1] CRAN (R 3.6.3)
 purrr         0.3.4   2020-04-17 [1] CRAN (R 3.6.2)
 R6            2.5.0   2020-10-28 [1] CRAN (R 3.6.2)
 remotes       2.2.0   2020-07-21 [1] CRAN (R 3.6.2)
 rlang         0.4.10  2020-12-30 [1] CRAN (R 3.6.2)
 rmarkdown     2.7     2021-02-19 [1] CRAN (R 3.6.3)
 rprojroot     2.0.2   2020-11-15 [1] CRAN (R 3.6.2)
 sass          0.3.1   2021-01-24 [1] CRAN (R 3.6.2)
 scales        1.1.1   2020-05-11 [1] CRAN (R 3.6.2)
 sessioninfo   1.1.1   2018-11-05 [1] CRAN (R 3.6.0)
 stringi       1.5.3   2020-09-09 [1] CRAN (R 3.6.2)
 stringr       1.4.0   2019-02-10 [1] CRAN (R 3.6.0)
 testthat      3.0.2   2021-02-14 [1] CRAN (R 3.6.2)
 tibble        3.1.0   2021-02-25 [1] CRAN (R 3.6.3)
 tidyselect    1.1.0   2020-05-11 [1] CRAN (R 3.6.2)
 usethis     * 2.0.1   2021-02-10 [1] CRAN (R 3.6.2)
 utf8          1.1.4   2018-05-24 [1] CRAN (R 3.6.0)
 vctrs         0.3.6   2020-12-17 [1] CRAN (R 3.6.2)
 withr         2.4.1   2021-01-26 [1] CRAN (R 3.6.2)
 xfun          0.21    2021-02-10 [1] CRAN (R 3.6.2)
 yaml          2.2.1   2020-02-01 [1] CRAN (R 3.6.0)

[1] /Library/Frameworks/R.framework/Versions/3.6/Resources/library