Department of Commerce in Illinois

A thin Commerce file on Illinois

Department of Commerce as awarding agency, Illinois as place-of-performance: 279 records summing to $1,551,602,959.73. A Department of Commerce award coded outside IL is out. An award in Illinois from a different awarding agency is out even if the topic sounds related. Illinois (IL) excludes Indiana, Wisconsin, Iowa, Missouri, and Kentucky. A Gary-coded award is Indiana even if the labor market is Chicago.

Two hundred seventy-nine awards against $1,551,602,959.73 is a thin Commerce book. The implied mean is large. Unique recipients are unpublished. Do not read 279 as 279 unique exporters, Census jobs, or unique EDA grantees. The overlay Department of Commerce in Illinois is the both-keys table. Illinois federal spending is the all-agency state hub. Department of Commerce is the agency book without an IL filter. All spending ties lists other joins.

Chicago, Downstate, and the Metro East share one IL stamp. Do not fold a Wisconsin or Indiana Commerce cell into this total. Correlation is not causation: Illinois did not cause $1,551,602,959.73 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 013 × IL only.

Not a Chicago exporter or NOAA census

$1,551,602,959.73 does not measure exporters, Census jobs, or unique EDA grantees. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 013 and an IL place-of-performance tag.

Do not treat 279 awards as a census of exporters, Census jobs, or unique EDA grantees. Parent hubs are supposed to be larger than this pair. If Illinois federal spending or Department of Commerce matched $1,551,602,959.73 and 279, the join would be pointless. Use the overlay when both keys must stay on. Indiana, Wisconsin, and Missouri Commerce joins are other pairs, not addends.

Questions

How much has the Department of Commerce obligated in Illinois?

USAspending.gov records $1,551,602,959.73 across 279 awards with awarding agency 013 and an Illinois tag. That is an obligation join, not an outlay and not a count of exporters, Census jobs, or unique EDA grantees. Department of Commerce in Illinois is the live overlay for this pair. Keep both keys when quoting $1,551,602,959.73.

Is $1,551,602,959.73 a measure of exporters, Census jobs, or unique EDA grantees?

No. The packet publishes $1,551,602,959.73 and 279 awards for agency 013 inside IL 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 279 awards?

That is the award-record count for 013 × IL. Combined with $1,551,602,959.73, the average is about $5.56 million. Modifications and repeat instruments add rows. 279 is not unique exporters, Census jobs, or unique EDA grantees. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live Commerce–Illinois table?

Department of Commerce in Illinois is the overlay. Illinois 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 $1,551,602,959.73. USAspending.gov is the source. Obligations are not outlays. Place of performance is IL.