FracFocus machine-readable data now available!
FracFocus is pleased to announce the release of disclosure data to the public in machine-readable SQL and CSV formats.
By clicking on a link below you may download a ZIP file that contains a copy of the disclosure database.
This download will be updated 5 days a week with the latest disclosures submitted. The backups contain the same public disclosure information available through the FracFocus ‘Find a Well’ search. Also included in the data release is a data dictionary detailing each attribute found in the backups.
The SQL backup was created using Microsoft SQL Server 2012. You may download a free copy of Microsoft SQL Server Express & Management Studio from the Microsoft website. FracFoucs user support does not include support beyond the download and validation of the backup files.
LIMITATIONS OF THE DATABASE
Disclosures submitted using the FracFocus 1.0 format (January, 2011 to May 31, 2013) will contain only header data. Disclosures submitted using the FracFocus 2.0 format (November 2012 to present) will contain both header and chemical data. NOTE: Between November, 2012 and May 31, 2013 disclosures in both 1.0 and 2.0 formats were submitted to the system. After May 31, 2013 only disclosures submitted in the 2.0 format were accepted.
The database contains information as reported to FracFocus, and the data displayed on the disclosure PDF files. Updates may be applied when corrections are identified to validation submission routines are identified. Any corrections are approved by the State Agencies requiring the submission of disclosures to FracFocus.
SQL DATA DOWNLOAD STRUCTURE
Each FracFocus record is composed of three parts stored in a separate database table:
- The header which describes the well, its location, the date of the treatment, and the total volume of base fluids.
- Another piece of the record set is a list of the additives used. These are listed by the additive name, supplier and the purpose of the additive.
- Last is another list of the chemical ingredients added to the base fluids; these may be listed be by each additive or the cumulative amount from all of the additives. Each chemical will be listed by name; its chemical abstract number (CAS); if it has a Material Safety Data Sheet (MSDS) to describe safety procedures and exposure treatment; it’s concentration in the additive, if broken down that way, by percent of mass; and it’s concentration by percent of the total mass.
To properly combine the dataset we suggest you use the join structure shown below for creating any queries. With the addition of the Systems Approach to disclosure submissions in FracFocus 3.0 this update is required:
SELECT * From FracFocusRegistry.dbo.RegistryUpload ru Join FracFocusRegistry.[dbo].[RegistryUploadIngredients] ri on ru.pkey=ri.pKeyDisclosure Left JOIN FracFocusRegistry.dbo.RegistryUploadPurpose rp on ri.pKeyPurpose = rp.pKey Where (ri.pKeyPurpose is null or ru.pkey = ri.pKeyDisclosure)
The readme located in the data download contains a data dictionary that details the data attributes for the following tables:
This table contains each disclosure’s header information such as the job date, API number, location, base water volume, and total vertical depth.
This table contains each disclosure’s additive names, suppliers, and the purposes for the additives used.
This table contains each disclosure’s chemical information, where available, such as the CAS number and the maximum percentages in which they are found in the additive and job.
To proceed, you must agree to the terms and conditions.
- Disclosures submitted using the FracFocus 1.0 format (January, 2011 to May 31, 2013) will contain only header data. Disclosures submitted using the FracFocus 2.0 format (November 2012 to present) will contain both header and chemical data. NOTE: Between November, 2012 and May 31, 2013 disclosures in both 1.0 and 2.0 formats were submitted to the system. After May 31, 2013 only disclosures submitted in the 2.0 format were accepted.
- Data submitted appears as it was submitted by the operator or operator’s authorized agent. FracFocus does not warrant the data in any way.
- Downloaded data may be aggregated or combined with other datasets.
- The FracFocus data may not be altered in any way.
- Data downloaded from the FracFocus site may be used without restriction.
- FracFocus does not provide end user support for the downloading or analysis of the data.
- You agree to abide by the website terms and conditions of use.