Department of Energy in West Virginia

A thin Energy file on a West Virginia tag

Department of Energy as awarding agency, West Virginia as place-of-performance: 259 records summing to $2,704,903,611.23. A Department of Energy award coded outside WV is out. An award in West Virginia from a different awarding agency is out even if the topic sounds related. West Virginia (WV) excludes Pennsylvania, Ohio, Kentucky, Virginia, and Maryland. A Pittsburgh-coded award is Pennsylvania.

Two hundred fifty-nine awards is a thin Energy file with a large implied mean. Few rows against a multi-billion dollar stock is the arithmetic. Unique recipients are unpublished. Do not read 259 as 259 unique lab employees, megawatts, or named national laboratories. The overlay Department of Energy in West Virginia is the both-keys table. West Virginia federal spending is the all-agency state hub. Department of Energy is the agency book without a WV filter. All spending ties lists other joins.

This packet does not name a plant, a lab, or a fossil-energy earmark. Unique recipients are unpublished. Correlation is not causation: West Virginia did not “cause” $2,704,903,611.23 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 089 × WV only.

Not a coal, gas, or lab-headcount series

$2,704,903,611.23 does not measure lab employees, megawatts, or named national laboratories. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 089 and a WV place-of-performance tag.

Do not treat 259 awards as a census of lab employees, megawatts, or named national laboratories. Parent hubs are supposed to be larger than this pair. If West Virginia federal spending or Department of Energy matched $2,704,903,611.23 and 259, the join would be pointless. Use the overlay when both keys must stay on. Pennsylvania, Ohio, and Kentucky Energy joins are other pairs, not addends.

Questions

How much has the Department of Energy obligated in West Virginia?

USAspending.gov records $2,704,903,611.23 across 259 awards with awarding agency 089 and a West Virginia tag. That is an obligation join, not an outlay and not a count of lab employees, megawatts, or named national laboratories. Department of Energy in West Virginia is the live overlay for this pair. Keep both keys when quoting $2,704,903,611.23.

Is $2,704,903,611.23 a measure of lab employees, megawatts, or named national laboratories?

No. The packet publishes $2,704,903,611.23 and 259 awards for agency 089 inside WV coding. Those other series are unpublished here. Unique recipients are unpublished. Quote the dollar total and the award count together. Obligations are not outlays.

Why does this DOE file have 259 awards?

That is the award-record count for 089 × WV. Combined with $2,704,903,611.23, the average is about $10.44 million. Modifications and repeat instruments add rows. 259 is not unique lab employees, megawatts, or named national laboratories. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Energy in West Virginia is the overlay. West Virginia federal spending and Department of Energy are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $2,704,903,611.23. USAspending.gov is the source. Obligations are not outlays.