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
Region codes: ab, ak, al, ar, argentina, bc, ca, co, ks, la, ms, mt, nd, nm, oh, ok, pa, tx, ut, wv, wy
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; in Texas and New Mexico the operator column then carries a name stood in from the well itself, and 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, or sundry_notice. 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. NULL exactly when proppant_lbs is NULL.
Values: fracfocus · completion_report · sundry_notice. |
total_water_gal_source |
string | yes | Which source supplied total_water_gal: fracfocus, completion_report, or sundry_notice. 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. NULL exactly when total_water_gal is NULL.
Values: fracfocus · completion_report · sundry_notice. |
frac_stages_source |
string | yes | Which source reported frac_stages: fracfocus, completion_report, or sundry_notice. FracFocus rarely reports stages; state filings usually do. NULL exactly when frac_stages is NULL.
Values: fracfocus · completion_report · sundry_notice. |
How these numbers are built is on methodology; the machine twin of this page is data-dictionary.json.