Department of Energy federal obligations in Iowa

A thin Energy file on Iowa

Department of Energy as awarding agency, Iowa as place-of-performance: 109 records summing to $1,518,723,084.18. A Department of Energy award coded outside IA is out. An award in Iowa from a different awarding agency is out even if the topic sounds related. Iowa (IA) excludes Illinois, Minnesota, Missouri, Nebraska, Wisconsin, and South Dakota. A Quad Cities Illinois tag is IL.

One hundred nine awards against $1,518,723,084.18 is a thin Energy file. The implied mean is large and is not a typical weatherization grant. Unique recipients are unpublished. Do not read 109 as 109 unique named labs, megawatts, or unique contractors. The overlay Department of Energy in Iowa is the both-keys table. Iowa federal spending is the all-agency state hub. Department of Energy is the agency book without an IA filter. All spending ties lists other joins.

Ames folklore is not a packet split. This page does not isolate EERE, a national lab, or a loan office inside $1,518,723,084.18. Correlation is not causation: Iowa did not cause $1,518,723,084.18 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 089 × IA only.

Not wind farms, Ames Lab, or a kWh census

$1,518,723,084.18 does not measure named labs, megawatts, or unique contractors. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 089 and an IA place-of-performance tag.

Do not treat 109 awards as a census of named labs, megawatts, or unique contractors. Parent hubs are supposed to be larger than this pair. If Iowa federal spending or Department of Energy matched $1,518,723,084.18 and 109, the join would be pointless. Use the overlay when both keys must stay on. Illinois, Minnesota, and Nebraska Energy joins are other pairs, not addends.

Iowa, not a Corn Belt energy rollup

Place of performance IA is a geography tag on the award, not a metro list and not a commuting zone. Iowa (IA) excludes Illinois, Minnesota, Missouri, Nebraska, Wisconsin, and South Dakota. A Quad Cities Illinois tag is IL. Recipient address can differ from that state tag.

Ames folklore is not a packet split. This page does not isolate EERE, a national lab, or a loan office inside $1,518,723,084.18. This packet does not split $1,518,723,084.18 by city, county, or named facility. 109 awards stay statewide. A county table would be a different extract.

Few rows, large implied mean

Even a thick or thin file records obligations, not necessarily outlays. $1,518,723,084.18 can include amounts that pay on a later schedule. Citing it as cash already sent in Iowa confuses two concepts. Deobligations and upward adjustments both move the total.

Iowa’s own budget is a different ledger. Mixing it with the 109-award USAspending file leaves this series. No fiscal year is published in this packet, so this page does not invent one. Keep the obligation label on $1,518,723,084.18.

Citing Energy in Iowa

Cite USAspending.gov: Department of Energy (agency 089) obligated $1,518,723,084.18 on 109 awards coded to Iowa. Name both sides. Keep “obligations.” Do not relabel the total as named labs, megawatts, or unique contractors.

Prefer Department of Energy in Iowa if the overlay has refreshed after an ingest. Iowa federal spending still includes every other awarding agency tagged to IA. Department of Energy is the 089 parent without the IA filter. All spending ties indexes other pairs. Do not add those parents into $1,518,723,084.18.

A usable footnote names Department of Energy, Iowa, $1,518,723,084.18, and 109. The compact headline $1.52 billion is that same dollar total rounded. It is not a second extract. The implied mean near $13.93 million is $1,518,723,084.18 divided by 109. Means are not medians. USAspending.gov remains the originating system.

Questions

How much has the Department of Energy obligated in Iowa?

USAspending.gov records $1,518,723,084.18 across 109 awards with awarding agency 089 and an Iowa tag. That is an obligation join, not an outlay and not a count of named labs, megawatts, or unique contractors. Department of Energy in Iowa is the live overlay for this pair. Keep both keys when quoting $1,518,723,084.18.

Is $1,518,723,084.18 a measure of named labs, megawatts, or unique contractors?

No. The packet publishes $1,518,723,084.18 and 109 awards for agency 089 inside IA 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 Energy file have 109 awards?

That is the award-record count for 089 × IA. Combined with $1,518,723,084.18, the average is about $13.93 million. Modifications and repeat instruments add rows. 109 is not unique named labs, megawatts, or unique contractors. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live Energy–Iowa table?

Department of Energy in Iowa is the overlay. Iowa 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 $1,518,723,084.18. USAspending.gov is the source. Obligations are not outlays. Place of performance is IA.