Department of Commerce federal obligations in Michigan

A thin Commerce file on a Michigan tag

Department of Commerce as awarding agency, Michigan as place-of-performance: 362 records summing to $2,176,737,116.90. A Department of Commerce award coded outside MI is out. An award in Michigan from a different awarding agency is out even if the topic sounds related. Michigan (MI) excludes Ohio, Indiana, Wisconsin, Illinois, and Minnesota. A Toledo-coded award is OH, not this cell. Census, NOAA, NIST, EDA, and other Commerce bureaus are unpublished splits inside awarding agency 013.

Three hundred sixty-two awards against $2,176,737,116.90 is a thin, high-mean file. A handful of vehicles can dominate the dollar total. Unique recipients are unpublished. Do not read 362 as 362 unique auto-plant counts, unique firms, or named Census/NOAA facilities. The overlay Department of Commerce in Michigan is the both-keys table. Michigan federal spending is the all-agency state hub. Department of Commerce is the agency book without an MI filter. All spending ties lists other joins.

Detroit, Grand Rapids, and Ann Arbor are unpublished. Do not fold a motor-vehicle NAICS cell into awarding agency 013. Correlation is not causation: Michigan did not “cause” $2,176,737,116.90 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 013 × MI only.

Auto NAICS codes are a different join

$2,176,737,116.90 does not measure auto-plant counts, unique firms, or named Census/NOAA facilities. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 013 and an MI place-of-performance tag. Census, NOAA, NIST, EDA, and other Commerce bureaus are unpublished splits inside awarding agency 013.

Do not treat 362 awards as a census of auto-plant counts, unique firms, or named Census/NOAA facilities. Parent hubs are supposed to be larger than this pair. If Michigan federal spending or Department of Commerce matched $2,176,737,116.90 and 362, the join would be pointless. Use the overlay when both keys must stay on. Ohio, Indiana, and Wisconsin Commerce joins are other pairs, not addends.

Michigan statewide, not a Detroit-metro map

Place of performance MI is a geography tag on the award, not a metro list and not a commuting zone. Michigan (MI) excludes Ohio, Indiana, Wisconsin, Illinois, and Minnesota. A Toledo-coded award is OH, not this cell. Recipient address can differ from that state tag. Detroit, Grand Rapids, Ann Arbor, and the rest of the counties share one MI stamp.

Detroit, Grand Rapids, and Ann Arbor are unpublished. Do not fold a motor-vehicle NAICS cell into awarding agency 013. This packet does not split $2,176,737,116.90 by city, county, or named facility. 362 awards stay statewide. A county table would be a different extract.

Few rows, still obligations

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

Michigan’s own budget is a different ledger. Mixing it with the 362-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 $2,176,737,116.90.

Citing Commerce in Michigan

Cite USAspending.gov: Department of Commerce (agency 013) obligated $2,176,737,116.90 on 362 awards coded to Michigan. Name both sides. Keep “obligations.” Do not relabel the total as auto-plant counts, unique firms, or named Census/NOAA facilities.

Prefer Department of Commerce in Michigan if the overlay has refreshed after an ingest. Michigan federal spending still includes every other awarding agency tagged to MI. Department of Commerce is the 013 parent without the MI filter. All spending ties indexes other pairs. Do not add those parents into $2,176,737,116.90. A usable footnote names Department of Commerce, Michigan, $2,176,737,116.90, and 362. The compact headline $2.18 billion is that same dollar total rounded. It is not a second extract. The implied mean near $6.01 million is $2,176,737,116.90 divided by 362. Means are not medians. USAspending.gov remains the originating system.

Questions

How much has the Department of Commerce obligated in Michigan?

USAspending.gov records $2,176,737,116.90 across 362 awards with awarding agency 013 and a Michigan tag. That is an obligation join, not an outlay and not a count of auto-plant counts, unique firms, or named Census/NOAA facilities. Department of Commerce in Michigan is the live overlay for this pair. Keep both keys when quoting $2,176,737,116.90.

Is $2,176,737,116.90 a measure of auto-plant counts, unique firms, or named Census/NOAA facilities?

No. The packet publishes $2,176,737,116.90 and 362 awards for agency 013 inside MI 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 Commerce file have 362 awards?

That is the award-record count for 013 × MI. Combined with $2,176,737,116.90, the average is about $6.01 million. Modifications and repeat instruments add rows. 362 is not unique auto-plant counts, unique firms, or named Census/NOAA facilities. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live Commerce–Michigan table?

Department of Commerce in Michigan is the overlay. Michigan federal spending and Department of Commerce are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $2,176,737,116.90. USAspending.gov is the source. Obligations are not outlays.