This is the Github repository for our article on abandoned wells in New York State. This is a forked version of the original repository created by my reporting partner, Ilena Peng (link here). The contents of this repo have been updated and reanalyzed as of March 25, 2022. Contents include:
NYS Wells 1860 - Present.ipynb & Orphaned wells in NYS.ipynb: The script for our data analysis
graphics: Charts included in the article and the R script for generating them
The data for this repo was last downloaded on 3/25/22. All CSVs and data folders have been labeled with '32522' to reflect the download date.
data_32522: Raw data for this analysis from the New York State Department of Environmental Conservation, Division of Mineral Resources via Open Data NY
-
- wells_1860_32522.csv — Oil, Gas, & Other Regulated Wells: Beginning 1860. Is updated daily, our download is from March 25, 2022.
- orphaned_wells_32522.csv — Orphaned Wells. Is updated annually, documents abandoned and unplugged oil & gas wells. On the date of download, this data was last updated on Dec. 16, 2021.
-
data_processed_32522: CSVs we generated from the raw data
- timespan_32522.csv (NYS Wells 1860 - Present.ipynb) — Used to generate violin plot, time between the dates a well was completed and plugged
- timespan_summ_32522.csv (NYS Wells 1860 - Present.ipynb) — Summary statistics by county, for time between the dates a well was completed and plugged
- plug_abdn_32522.csv (NYS Wells 1860 - Present.ipynb) — Number of abandoned and plugged wells in each county
- active_32522.csv (NYS Wells 1860 - Present.ipynb) — Number of active wells in each county
- unplug_orphaned_32522.csv (Orphaned wells in NYS.ipynb) — Number of abandoned and unplugged wells in each county