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:
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:
From FracFocusRegistry.dbo.RegistryUpload ru
Join FracFocusRegistry.[dbo].[RegistryUploadIngredients] ri
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.