CommoVision

See the future in real time

← All tables

gold_well_disposition

Monthly gas and oil disposition per well: where the produced volume went (sold, flared, vented, reinjected, used as lease or plant fuel), one row per well per month. NULL means the source didn't report that split; 0 is a reported zero. Each disposition column carries its own paired _origin column (reported at well grain vs allocated from lease-level filings). Together with monthly production this gives gross-to-marketed reconciliation and flaring intensity at well grain.

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: well_id, date
Region codes: gom, la, nd, nm, tx, wy

Columns

ColumnTypeNullableDescription
well_id string no Join key to the well register. Always populated. Same well-month grain as the monthly production series; join on (well_id, date) to compare disposition against produced volumes.
date date no Disposition month, always the first day of the month, matching the production series.
year int16 no Calendar year of the disposition month (equals the year of date). Provided for fast year-level filtering and partition pruning.
gas_sold int32 yes Marketed/delivered gas in MCF: gas sold off-lease to a gatherer or purchaser. Within a month, sold can lag produced (tank and line-pack stock), so reconcile sold against produced cumulatively, not month by month; the gap between gross produced gas and this column is what you see comparing our gross series to marketed-gas series such as EIA's. NULL = the source did not report sold separately.
gas_flared int32 yes Gas burned (flared) at the lease, in MCF. Kept separate from gas_vented because the split matters for emissions analysis (vented methane is far more potent than flared CO2). A source that reports only a combined figure populates gas_flared_vented instead, never a lossy split. NULL = not reported separately.
gas_vented int32 yes Gas released unburned (vented) at the lease, in MCF. NULL = not reported separately.
gas_flared_vented int32 yes Combined flared plus vented gas in MCF, for sources that report the two under a single code and cannot split them (e.g. the Texas RRC "vented or flared" code). A region that reports the split populates gas_flared and gas_vented and keeps this NULL; a region that reports only the combined figure populates this and keeps the split columns NULL, never a lossy split into one of them. NULL = no combined figure reported.
gas_reinjected int32 yes Gas reinjected for pressure maintenance, cycling, gas lift, or enhanced recovery, in MCF. Large in Permian gas wells, and a major reason marketed gas runs far below gross. Can exceed the well's own produced gas (recycled gas-lift, purchased makeup gas, or allocation grain), so exclude it when balancing sold against produced.
gas_lease_fuel int32 yes Gas consumed on-lease as fuel (engines, heaters, compressors), in MCF.
gas_plant_fuel int32 yes Gas consumed as fuel at the processing plant, in MCF. Sparse, populated only where the source natively reports it.
oil_sold int32 yes Marketed/sold oil plus condensate, in BBL. Only the sold split is carried for oil; other oil disposition (lease use, tank stock change) is noise at monthly grain. Oil includes condensate, matching the production series.
gas_sold_origin string yes How gas_sold was derived: reported = the source reported this value at well-month grain; lease_allocated = the source reported it at lease/unit level and we split it to wells using the same allocation weights as the monthly production series, so values roll up exactly to the lease total. A lease_allocated value is the well's share of its unit's volume and can exceed the well's own production where the unit handled more than this well, so compare sold vs produced at the unit level, not per single well. NULL exactly when gas_sold is NULL. Values: reported · lease_allocated.
gas_flared_origin string yes How gas_flared was derived, same values as gas_sold_origin. NULL exactly when gas_flared is NULL. New Mexico reports flaring at well grain, the cleanest flaring data. Values: reported · lease_allocated.
gas_vented_origin string yes How gas_vented was derived, same values as gas_sold_origin. NULL exactly when gas_vented is NULL. Values: reported · lease_allocated.
gas_flared_vented_origin string yes How gas_flared_vented was derived, same values as gas_sold_origin. NULL exactly when gas_flared_vented is NULL. Texas reports the combined figure at lease grain; well values are allocated. Values: reported · lease_allocated.
gas_reinjected_origin string yes How gas_reinjected was derived, same values as gas_sold_origin. NULL exactly when gas_reinjected is NULL. Values: reported · lease_allocated.
gas_lease_fuel_origin string yes How gas_lease_fuel was derived, same values as gas_sold_origin. NULL exactly when gas_lease_fuel is NULL. Values: reported · lease_allocated.
gas_plant_fuel_origin string yes How gas_plant_fuel was derived, same values as gas_sold_origin. NULL exactly when gas_plant_fuel is NULL. Values: reported · lease_allocated.
oil_sold_origin string yes How oil_sold was derived, same values as gas_sold_origin. NULL exactly when oil_sold is NULL. Values: reported · lease_allocated.

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