well_fracs

One row per hydraulic-fracturing job, reconciled across FracFocus and state filings so one physical treatment appears exactly once. Carries treatment dates, total proppant and water volumes, fluid-system classification, and stage count. Where FracFocus and the state disagree, we keep the better value and say which source supplied it: each key measurement carries its own paired _source column (proppant_lbs_source, total_water_gal_source, frac_stages_source).

Access tier: portal Portal. These rows are well-level or producing-unit-level data, or our modelled output at cohort or grid grain. They open with a Portal, Pro or Enterprise plan. The website shows aggregates built from them, never the rows.
Primary key: frac_id
Regions: Alberta, Alaska, Alabama, Arkansas, Argentina, British Columbia, California, Colorado, Kansas, Louisiana, Mississippi, Montana, North Dakota, New Mexico, Ohio, Oklahoma, Pennsylvania, Texas, Utah, West Virginia, Wyoming

Columns

Column	Type	Nullable	Description
frac_id	string	no	Globally unique frac-treatment identifier (opaque string) - this table's primary key. One physical treatment appears exactly once, reconciled across FracFocus and state filings. Never parse substrings out of it.
well_id	string	no	Join key to the well register.
completion_id	string	yes	Join key to the completion register - the completion event this treatment belongs to. NULL when no completion could be matched.
frac_start_date	date	no	Start of the treatment.
frac_end_date	date	yes	End of the treatment. NULL when the source reports only a start date. Always on or after frac_start_date.
total_water_gal	float64	yes	Total base water volume in gallons, from the source named in total_water_gal_source (state filings preferred over FracFocus).
proppant_lbs	float64	yes	Total proppant mass in pounds, from the source named in proppant_lbs_source (state filings preferred over FracFocus).
proppant_type	string	yes	Proppant classification: sand, ceramic, resin_coated, or mixed. Derived from the chemical registry. Values: sand · ceramic · resin_coated · mixed.
frac_type	string	yes	Treatment fluid classification: slickwater, hybrid, gel, or acid. Derived from the FracFocus chemical registry. Values: slickwater · hybrid · gel · acid.
frac_stages	int16	yes	Number of frac stages. Often from state filings - FracFocus rarely reports it.
operator	string	yes	The operator responsible for this treatment, as a canonical company name. Where the frac filing names an operator, this is the operator at the time of the treatment - a point-in-time fact. Where the filing names none, we stand in the operator the well itself was filed under: the company that originally drilled it, or where no name was ever filed for the well, the company its production was most recently reported under. Neither stand-in is carried forward through later mergers, so for an older treatment it can name a company other than the one that performed the job.
operator_entity	string	yes	Raw entity name from the frac filing, preserved without normalization. NULL where the filing names no operator; where the operator column carries a name stood in from the well itself, this column stays NULL to mark that.
reported_operator_id	string	yes	Stable company identifier for the frac filing's own operator (operator_entity), with no merger succession applied. NULL where the filing names no operator or the name is not yet mapped to a registered organization.
proppant_lbs_source	string	yes	Which source supplied proppant_lbs: fracfocus, completion_report, sundry_notice, fracfocus_estimated, or epa_fracfocus10, or comma_reading. State filings are preferred over FracFocus; a value that fails our plausibility screen is passed over rather than published, the screen reaching each region with its next fracs update. fracfocus values are served as the operator submitted them; fracfocus_estimated means we derived the mass ourselves from the disclosure's own figures (its proppant percentages and base water volume, or its products' stated composition) because the submitted mass was missing, inconsistent with them, or counted the same proppant more than once. epa_fracfocus10 means the mass is our estimate from EPA's archive of FracFocus 1.0 disclosures. comma_reading means the filed figure's own comma grouping was misprinted and we publish the reading its commas support, used only when no other source reports the job's mass. NULL exactly when proppant_lbs is NULL. Values: fracfocus · completion_report · sundry_notice · fracfocus_estimated · epa_fracfocus10 · comma_reading.
total_water_gal_source	string	yes	Which source supplied total_water_gal: fracfocus, completion_report, sundry_notice, or epa_fracfocus10. State filings are preferred over FracFocus; a value that fails our plausibility screen is passed over rather than published, the screen reaching each region with its next fracs update. epa_fracfocus10 means the volume is EPA's quality-checked figure from its archive of FracFocus 1.0 disclosures. NULL exactly when total_water_gal is NULL. Values: fracfocus · completion_report · sundry_notice · epa_fracfocus10.
frac_stages_source	string	yes	Which source reported frac_stages: fracfocus, completion_report, sundry_notice, or scout_report (the operator's daily log in the state's scout records). FracFocus rarely reports stages; state filings usually do. NULL exactly when frac_stages is NULL. Values: fracfocus · completion_report · sundry_notice · scout_report.

How these numbers are built is on methodology; the machine twin of this page is data-dictionary.json.