General Services Administration in Missouri

A high-count HUD file on Missouri

Department of Housing and Urban Development as awarding agency, Missouri as place-of-performance: 18,878 records summing to $2,714,728,303.23. A Department of Housing and Urban Development 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.

Eighteen thousand eight hundred seventy-eight records is a high-count HUD file. Volume can rise on recurring assistance without each row being a new household. Unique recipients are unpublished. Do not read 18,878 as 18,878 unique housing units, voucher households, or named public housing authorities. The overlay Department of Housing and Urban Development in Missouri is the both-keys table. Missouri federal spending is the all-agency state hub. Department of Housing and Urban Development is the agency book without an MO filter. All spending ties lists other joins.

St. Louis and Kansas City are unpublished. Do not treat the award count as two metro lists glued together. Correlation is not causation: Missouri did not “cause” $2,714,728,303.23 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 086 × MO only.

Award rows are not unique households

$2,714,728,303.23 does not measure housing units, voucher households, or named public housing authorities. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 086 and an MO place-of-performance tag.

Do not treat 18,878 awards as a census of housing units, voucher households, or named public housing authorities. Parent hubs are supposed to be larger than this pair. If Missouri federal spending or Department of Housing and Urban Development matched $2,714,728,303.23 and 18,878, the join would be pointless. Use the overlay when both keys must stay on. Kansas, Illinois, and Arkansas HUD joins are other pairs, not addends.

Questions

How much has the Department of Housing and Urban Development obligated in Missouri?

USAspending.gov records $2,714,728,303.23 across 18,878 awards with awarding agency 086 and a Missouri tag. That is an obligation join, not an outlay and not a count of housing units, voucher households, or named public housing authorities. Department of Housing and Urban Development in Missouri is the live overlay for this pair. Keep both keys when quoting $2,714,728,303.23.

Is $2,714,728,303.23 a measure of housing units, voucher households, or named public housing authorities?

No. The packet publishes $2,714,728,303.23 and 18,878 awards for agency 086 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 HUD file have 18,878 awards?

That is the award-record count for 086 × MO. Combined with $2,714,728,303.23, the average is about $143,804. Modifications and repeat instruments add rows. 18,878 is not unique housing units, voucher households, or named public housing authorities. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Housing and Urban Development in Missouri is the overlay. Missouri federal spending and Department of Housing and Urban Development are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $2,714,728,303.23. USAspending.gov is the source. Obligations are not outlays.