Oil Spills Impacting US Waterways

Data

The data came from the Bureau of Transportation Statistics. Only the pollution incidents where the Coast Guard investigated as the lead agency are included in this dataset. Data on spills where the Environmental Protection Agency or any of the state authorities are the lead agency is not included. These are mostly offshore spills as the EPA usually handles inshore spills. These statistics cover yearly gallons spilled, number of incidents, and source type from 1985, 1990, 1995-2020.

Vessel, Non-Vessel, and Mystery Sources

Gallons Spilled

“On April 20, 2010, the oil drilling rig Deepwater Horizon, operating in the Macondo Prospect in the Gulf of Mexico, exploded and sank resulting in the death of 11 workers on the Deepwater Horizon and the largest spill of oil in the history of marine oil drilling operations.”

Incidents

Source, Incidents, and Gallons Spilled

References

• unpivotr

• behead function

• tidyxl

• range slider

Reflections

• Wilke: stacked vs grouped bar charts and the implications of connecting dots with lines

• wrangling - double header excel data (code)

• Improvements: double y-axis? tree-map or ribbon plot, more user interactivity - button that switches from stacked bar plot to grouped bar plot