Chemical Index

An interactive and searchable index into the chemicals used in FracFocus. Includes summary statistics and links to in-depth analysis of each material's use.

Chemical synonyms

This searchable table lists alternative names for the chemicals published in FracFocus. Although it is not an exhaustive set (around 100,000 synonyms for about 1400 compounds published in FracFocus and other fracking data sources), it may help you find alternative names for a given CAS number or possible CAS numbers for a given name

CAS-Ing pairs

This interactive table helps the user see how the raw FracFocus fields CASNumber and IngredientName were curated into the Open-FF bgCAS values. This curation is necessary because there are many correctable mistakes that, once fixed, give us a more complete record of chemical use.

States and Counties

State summaries

Data are summarized by state and county. (in development)

Companies and their products

Company name table

The raw FracFocus data for company names is not standardized. A single company may be named by dozens of labels in the data. Without correcting this proliferation of names, searching the data is very tedious. Open-FF uses a hand-curated translation table to translate the numerous versions into a single name. The two FracFocus fields that are the 'input' for this table are OperatorName and Supplier. The three Open-FF fields that use the output of the table are bgOperatorName, bgSupplier and primarySupplier.

TradeNames Index

This experimental table lists all tradenames and the bgCAS numbers associated with them. Use this table to find what is reported in a particular product or to find which products a particular chemical ends up in. You can also use the table to look for variations in how a particular product is reported. (in development)


What is Open-FF?

A brief description of the Open-FF project.

Scope of FracFocus

A big-picture summary of FracFocus data, including links to summary data sets.(in development)


Data Dictionary

This dictionary has three tables: The first table describes the fields in the original FracFocus bulk downloads and the generated fields in the Open-FF data sets. The other tables provide information about the process of identifying the carrier records in disclosures.

Other data sets

The data sets described here are related to the main bulk download set, but for various reasons, are not directly connected. For example, chemical records for the 2011-2013 period that were scraped from FracFocus's PDF files are summarized here.

Many tables are interactive. You can: