Welcome to the FracFocus Database Query Tool
The current database is a restore of an January 11, 2016 backup of the FracFocus database available at https://fracfocus.org/data-download.
This data has not been modified or subjected to any quality control measures, except for the following: ingredient names have been converted to lower case and leading zeros have been removed from ingredient CAS numbers.
If you have any questions about this site or need help, please email firstname.lastname@example.org for assistance.
While substantial efforts are made to ensure the accuracy of data and documentation, complete accuracy of data sets cannot be guaranteed. All data are made available "as is". The AirWaterGas SRN shall not be liable for damages resulting from any use or misinterpretation of data sets. Data users should be aware that we periodically update data sets. View Data Use and Availability Policy.
This data dictionary defines each attribute found in the FracFocusRegistry database backup which includes all disclosures locatable through the FracFocus 'Find a Well' search.
Table Name: Uploads
Job Start Date - The date on which the hydraulic fracturing job was initiated. Does not include site preparation or setup.
Job End Date - The date on which the hydraulic fracturing job was completed. Does not include site teardown.
API Number - The American Petroleum Institute well identification number formatted as follows xx-xxx-xxxxx0000 Where: First two digits represent the state, second three digits represent the county, third 5 digits represent the well.
State Number - The first two digits of the API number. Range is from 01-50.
County Number - The 3 digit county code.
Operator Name - The name of the operator.
Well Name - The name of the well.
Latitude - The lines that circle the earth horizontally, running side to side at equal distances apart on the earth. Latitude is typically expressed in degrees North/ South. In the FracFocus system these lines are shown in decimal degrees and must be between 15 and 75.
Longitude - The lines that circle the earth vertically, running top to bottom that are equal distances apart at the equator and merge at the geographic top and bottom of the earth. Longitude is typically expressed in degrees East/ West. In the FracFocus system the number representing these lines are shown in decimal degrees and must be between -180 and -163 Note: Longitude number must be preceded by a negative sign.
Projection - The geographic coordinate system to which the latitude and longitude are related. In the FracFocus system the projection systems allowed are NAD (North American Datum) 27 or 83 and UTM (Universal Transverse Mercator).
TVD - The vertical distance from a point in the well (usually the current or final depth) to a point at the surface, usually the elevation of the rotary kelly bushing.
Total Base Water Volume - The total volume of water used as a carrier fluid for the hydraulic fracturing job (in gallons).
Total Base Non Water Volume - The total volume of non water components used as a carrier fluid for the hydraulic fracturing job (in gallons)
State Name - The name of the state where the surface location of the well resides. Calculated from the API number.
County Name - The name of the county were the surface location of the well resides. Calculated from the API number.
FFVersion - A key which designates which version of FracFocus was used when the disclosure was submitted.
FederalWell - True = Yes, False = No.
Table Name: Upload Purposes
Upload Id - Foreign key linking to the Uploads table.
Trade Name - The name of the product as defined by the supplier.
Supplier - The name of the company that supplied the product for the hydraulic fracturing job (Usually the service company).
Purpose - The reason the product was used (e.g. Surfactant, Biocide, Proppant).
Table Name: Upload Ingredients
Purpose Id - Foreign key linking to the Upload Purposes table.
Ingredient Name - Name of the chemical or for Trade Secret chemicals the chemical family name.
CAS Number - The Chemical Abstract Service identification number.
Percent High Additive - The percent of the ingredient in the Trade Name product in % (Top of the range from MSDS).
Percent HF Job - The amount of the ingredient in the total hydraulic fracturing volume in % by Mass.
Ingredient Comment - Any comments related to the specific ingredient.