gold_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, primarily from FracFocus. |
proppant_lbs |
float64 | yes | Total proppant mass in pounds, aggregated from the chemical registry. |
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, the well register's operator stands in where we can resolve one, which for an older treatment 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 the well register's operator where one resolves. |
proppant_lbs_source |
string | yes | Which source reported proppant_lbs: fracfocus, completion_report, or sundry_notice. State filings win over FracFocus when both report. NULL exactly when proppant_lbs is NULL.
Values: fracfocus · completion_report · sundry_notice. |
total_water_gal_source |
string | yes | Which source reported total_water_gal: fracfocus, completion_report, or sundry_notice. State filings win over FracFocus when both report. 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.