General Services Administration in Tennessee

HUD awards tagged to Tennessee

Department of Housing and Urban Development as awarding agency, Tennessee as place-of-performance: 18,908 records summing to $3,439,716,933.27. A Department of Housing and Urban Development award coded outside TN is out. An award in Tennessee from a different awarding agency is out even if the topic sounds related. Tennessee (TN) excludes Kentucky, Virginia, North Carolina, Georgia, Alabama, Mississippi, Arkansas, and Missouri. A Memphis, Mississippi-coded row is not this cell.

Eighteen thousand nine hundred eight awards is a high-count HUD file. Recurring assistance can thicken a list without each row being a new building. Unique recipients are unpublished. Do not read 18,908 as 18,908 unique housing units, unique PHAs, or voucher households. The overlay Department of Housing and Urban Development in Tennessee is the both-keys table. Tennessee federal spending is the all-agency state hub. Department of Housing and Urban Development is the agency book without a TN filter. All spending ties lists other joins.

Nashville, Memphis, and Knoxville are unpublished geography. $3,439,716,933.27 stays on 086 × TN. Correlation is not causation: Tennessee did not “cause” $3,439,716,933.27 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 086 × TN only.

18,908 rows are not 18,908 units

$3,439,716,933.27 does not measure housing units, unique PHAs, or voucher households. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 086 and a TN place-of-performance tag.

Do not treat 18,908 awards as a census of housing units, unique PHAs, or voucher households. Parent hubs are supposed to be larger than this pair. If Tennessee federal spending or Department of Housing and Urban Development matched $3,439,716,933.27 and 18,908, the join would be pointless. Use the overlay when both keys must stay on. Kentucky, Alabama, and Arkansas HUD joins are other pairs, not addends.

Questions

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

USAspending.gov records $3,439,716,933.27 across 18,908 awards with awarding agency 086 and a Tennessee tag. That is an obligation join, not an outlay and not a count of housing units, unique PHAs, or voucher households. Department of Housing and Urban Development in Tennessee is the live overlay for this pair. Keep both keys when quoting $3,439,716,933.27.

Is $3,439,716,933.27 a measure of housing units, unique PHAs, or voucher households?

No. The packet publishes $3,439,716,933.27 and 18,908 awards for agency 086 inside TN 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,908 awards?

That is the award-record count for 086 × TN. Combined with $3,439,716,933.27, the average is about $181,919. Modifications and repeat instruments add rows. 18,908 is not unique housing units, unique PHAs, or voucher households. 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 Tennessee is the overlay. Tennessee 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 $3,439,716,933.27. USAspending.gov is the source. Obligations are not outlays.