Please familiarize yourself with the metadata on this page before downloading:
This dataset contains information extracted from PDF files hosted on FracFocus.org, voluntary disclosure reports submitted by oil and gas drilling operators about the chemicals they used in hydraulic fracturing operations across the United Sates. This dataset represents all of the information included in each individual report - as submitted by industry operators. We have added one column which calculates if a chemical abstract service number (CAS #) is valid (the checksum is correct), invalid (the number appears to be a CAS # but the checksum is wrong), or other (blanks, NULL, or something else does not resemble a CAS #), and for all valid CAS numbers we run a script that standardizes the spacing and punctuation. We record when we obtained the report from FracFocus for the first time and assign it a unique ID, but otherwise, all the data in our database appears exactly as they is recorded on FracFocus.org: typos, "trade secrets," and all.
This database is provided free of charge for research and educational purposes. If you use this database to produce a published work, all we ask is that you acknowledge SkyTruth in your website/blogpost/report/paper.
We are refreshing these datasets monthly, available for download from the links below. Due to the dynamic nature and size of the database, we are offering the database as large zipped files (in tab separated value [.txt] format), updated monthly. We will update the current year links on the tenth of each month with a dataset that will encompass all reports that were submitted to FracFocus.org between January 1 and the last day of the preceding month. Prior years' data is archived by year. Be aware of the following issues with the data:
We are making available 3 datasets - Reports, Chemicals, and Blended - all in a zipped, tab-separated format [.txt.zip].
WARNING: The Chemicals and Blended datasets for a full year or more can contain over 1,000,000 records, which far exceeds what Microsoft Excel can handle - you must use Microsoft Access or other database managing software to work with the Chemical or Blended Dataset.
SkyTruth Fracking Chemical Database
All reports submitted to FracFocus through last month
Reports published in 2013 (through the latest complete month)
2013 Reports Data - Click to Download
2013 Chemicals Data - Click to Download
2013 Blended Data - Click to Download
Reports published in 2011 - 2012
2011- 2012 Reports Data - Click to Download
2011- 2012 Chemicals Data - Click to Download
2011- 2012 Blended Data - Click to Download