Doc: U.S. venting and flaring data dictionary
Status: Source checked, local review asset
Owner: Rene
Last verified: 2026-11-14
Depends on: Pinned EIA Annual PDFs, evidence-contract.json, analysis.py

The core panel uses the completed 2024 Natural Gas Annual edition, released November 28, 2025 and reissued February 6, 2026, with 2020 through 2024 data. All values are reported source quantities, which may carry E estimated or R revised presentation flags. They are not asserted to be directly metered observations. The source cell ledger retains the original extracted row text, including those flags. Numeric input tokens remove commas and presentation flags only for calculation; NA, W, threshold and not applicable markers remain distinct.

| Field | Definition and treatment |
| --- | --- |
| year | Calendar year described by the quantity, not publication or retrieval year. |
| area | Exact state name, District of Columbia, United States or normalized Federal offshore Gulf. Historic Gulf of Mexico and current Gulf of America source labels describe the offshore source region; the raw source row and source URL retain original wording. |
| geography_type | state, district, offshore_region or national. National totals and subnational rows must never be added together. |
| gross_withdrawals_mmcf | EIA full well stream gas, including plant liquids and nonhydrocarbon gases, excluding lease condensate, in million cubic feet. Numeric zero is a source zero. |
| vented_flared_mmcf | EIA combined vented and flared volume, million cubic feet, not a flaring only or methane emissions measure. Blank is nonnumeric, never zero. |
| vented_flared_source_marker | Source token, including 0, NA, --, W or * when applicable. NA is not available, -- not applicable, W withheld, * below the stated reporting threshold. |
| vented_flared_status | reported_positive, reported_zero, not_available, not_applicable, below_reporting_threshold or withheld, derived solely from the published marker. |
| vented_flared_pct_gross | 100 times the combined volume divided by same geography and year gross withdrawals. Decimal arithmetic, six decimal places, round half up. Undefined for missing or zero denominator, remains blank. |
| volume_rank | Competition rank among numeric state observations with a positive gross denominator in the stated year. Equal numeric source quantities share a rank. Offshore Gulf is not a state. |
| rate_rank | Competition rank among the same eligible state observations, using integer cross multiplication on unrounded source fractions. Equal fractions share a rank. |
| share_of_reported_us_vented_flared_pct | 100 times state combined volume divided by EIA's published national combined total for that year. This is not a completeness estimate for actual emissions or unreported state disposal. |
| change_vented_flared_mmcf | End quantity less beginning quantity for identical geography and the fixed core edition. |
| change_vented_flared_pct | 100 times quantity change divided by beginning quantity, undefined when beginning is zero. |
| change_rate_percentage_points | End share of gross less beginning share. A percentage point change is not a relative percent change. |
| relative_rate_change_pct | 100 times end share divided by beginning share, less 100. Undefined when beginning share is zero. |
| *_rounding_residual_mmcf | Published total less exact sum of independently rounded components, or the explicitly named accounting identity. Signed differences are preserved. |
| source_file, source_table | Pinned original publication and table. Full source hashes and original URLs are in sources/source-manifest.json. |
| source_row_text | Extracted original PDF row, preserving displayed E and R flags and source availability markers. PDF page is one based. |
| series_sheet, series_cell, series_key | XLS sheet, one based Excel cell reference and exact source series key. The source ledger uses the shorter sheet and cell field names. |
| vintage | Publication edition, separate from the observation year. Archived 2012 through 2019 Table 3 snapshots are separate as published records, not a joined current history. |

One billion cubic feet equals 1,000 million cubic feet. One trillion cubic feet equals 1,000,000 million cubic feet. Percentages use same unit numerator and denominator before division. No energy, cash, household or emissions conversion is made.

The core panel has 53 geography records per year: 50 states, one district, one federal offshore Gulf region and one national total. This is complete transcription of the defined source geography universe, not complete measured venting coverage. In 2024, only 13 producing states have both numeric combined disposal and positive gross withdrawals. Ten report positive disposal and Idaho, Kansas and South Dakota report zero. Other nonproducing state summaries can also show zero disposal, but a zero gross denominator has no defined share.

Archived snapshots can differ from subsequently revised history. The audit compares like named numeric quantities and distinguishes numeric_revision, annual_NA_series_zero, availability_difference and no_series_cell. Source NA always governs the Annual based analysis. The audit is not a correction to EIA or a new estimate of unavailable gas.

Reproduction: run `python3 analysis.py`, then `python3 figures.py` in this asset directory. Both use only Python's standard library and pinned CSV inputs. Optional `prepare.py` reextracts the original PDF text; `extract_workbooks.py` requires xlrd to reproduce the workbook cell ledger. Large original PDFs remain in the local source archive. The lightweight reproduction input list is in reproduction-inputs.json.
