Department of Commerce in Missouri

A thin Commerce file on Missouri

Department of Commerce as awarding agency, Missouri as place-of-performance: 158 records summing to $1,877,996,967.88. A Department of Commerce award coded outside MO is out. An award in Missouri from a different awarding agency is out even if the topic sounds related. Missouri (MO) excludes Kansas, Illinois, Iowa, Arkansas, Kentucky, Tennessee, Nebraska, and Oklahoma. A Kansas City, Kansas-coded award is KS.

One hundred fifty-eight awards against $1,877,996,967.88 is a thin, high-mean Commerce file. A few vehicles can mint most of the dollars. Unique recipients are unpublished. Do not read 158 as 158 unique exporters, Census jobs, or NOAA stations. The overlay Department of Commerce in Missouri is the both-keys table. Missouri federal spending is the all-agency state hub. Department of Commerce is the agency book without an MO filter. All spending ties lists other joins.

St. Louis and Kansas City are unpublished. Do not treat 158 as two metro project lists glued together. Correlation is not causation: Missouri did not cause $1,877,996,967.88 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 013 × MO only.

Not a two-city exporter ranking

$1,877,996,967.88 does not measure exporters, Census jobs, or NOAA stations. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 013 and an MO place-of-performance tag.

Do not treat 158 awards as a census of exporters, Census jobs, or NOAA stations. Parent hubs are supposed to be larger than this pair. If Missouri federal spending or Department of Commerce matched $1,877,996,967.88 and 158, the join would be pointless. Use the overlay when both keys must stay on. Kansas, Illinois, and Arkansas Commerce joins are other pairs, not addends.

Questions

How much has the Department of Commerce obligated in Missouri?

USAspending.gov records $1,877,996,967.88 across 158 awards with awarding agency 013 and a Missouri tag. That is an obligation join, not an outlay and not a count of exporters, Census jobs, or NOAA stations. Department of Commerce in Missouri is the live overlay for this pair. Keep both keys when quoting $1,877,996,967.88.

Is $1,877,996,967.88 a measure of exporters, Census jobs, or NOAA stations?

No. The packet publishes $1,877,996,967.88 and 158 awards for agency 013 inside MO 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 158 awards?

That is the award-record count for 013 × MO. Combined with $1,877,996,967.88, the average is about $11.89 million. Modifications and repeat instruments add rows. 158 is not unique exporters, Census jobs, or NOAA stations. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live Commerce–Missouri table?

Department of Commerce in Missouri is the overlay. Missouri 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,877,996,967.88. USAspending.gov is the source. Obligations are not outlays. Place of performance is MO.