Doc: AMR national orphan well data dictionary
Status: Complete local compilation, source precision preserved
Owner: Rene
Last verified: 2026-11-14
Depends on: evidence-contract.json, sources/source-ledger.json, analysis.py

The contribution is a complete national program accounting comparison, all 27 state award recipients, all 18 labels on the Tribal award map, federal recipient targets and a dated inventory/output dictionary. The files do not establish national cleanup completion or average cost.

| File | Row unit and interpretation |
|---|---|
| program-funding-ledger.csv | Four program rows plus source total, original printed financial cells. M is million USD, B is billion USD. |
| original-allocations.csv | Four original allocations in USD, before wildfire and administrative deductions. |
| state-awards.csv | One of 27 state recipients. Initial, Formula, Matching and Total are reported USD. share_of_state_awards_percent uses the reported total of 1,862,875,009 USD. rank_by_reported_awards ranks award authority only. |
| state-grant-composition.csv | One of three grant categories; exact source USD divided by exact total, multiplied by 100. |
| state-award-concentration.csv | Defined largest recipient groups; exact USD sums and shares of the complete state table. |
| federal-recipient-targets.csv | One of five recipient descriptions, rounded USD million and intended wells, not completed outputs. |
| tribal-map-awards.csv | One of all 18 published map labels, USD million at the source's two decimal display precision. |
| documented-inventory-vintages.csv | Source descriptions of documented unplugged inventories, editions and coverage preserved. |
| plugging-reporting-windows.csv | Count, program, measure and cutoff remain attached. Catalog rows count submissions received; report rows count cumulative plugging. |
| source-reconciliation.csv | AMR arithmetic comparison, with explicit meaning and limitations, not a claim of error or missing money. |
| measure-dictionary.csv | Definition, valid question and excluded interpretation, not additional measurement. |
| restoration-accounting.csv | Reported area includes estimates where acreage was not submitted. |
| state-awards-figure.csv | Plot inputs, seven largest recipients and remaining 20 combined. Complete recipient data remain in state-awards.csv. |

The literal '-' in source CSV means a printed source dash, not a verified zero. Empty Formula and Matching fields for Utah are genuinely empty in the printed table. Article tables say 'Not shown' or 'Blank in source'. No missing or dashed value becomes an observed USD 0. Arithmetic totals sum the reported numeric cells only, then independently compare that result with every printed source row and column total. Where a component has no numeric source value, the stacked plot draws no component segment, and makes no assertion that a zero award was measured. This distinction is preserved in the figure note and parent HTML notes.

Money uses Decimal or exact integers. Percentages use Decimal division, multiplied by 100 and ROUND_HALF_UP to two decimals. Independently rounded grant shares add to 100.01%. Inventory differences subtract identified database vintages, not abandonment events. Financial values with different printed precision are never forced into exact balances. FY is a U.S. fiscal year; September 30, 2026 is the end of FY 2026. A report publication date differs from its evidence cutoff.

analysis.py reads only the pinned inputs in reproduction-inputs.json. It regenerates all analytical CSVs, tests every state numeric cell against the independently extracted PDF text and checks every row and column. Figures.py uses those output CSVs and saves its briefs before rendering. The originals, full text and hash ledger remain separate from AMR derivations.

The local original-source archive preserves producer attribution and rights. The article's reuse license applies to AMR original compilation and calculations, not to third party source content.


State Program cutoff precision: DOI p11 states through June2026. The machine-readable State Program cutoff is 2026-06, preserving month precision. National and Federal Program June30 dates remain exact where explicitly sourced.
