Department of Housing and Urban Development federal obligations in Michigan

An extreme-count HUD file on Michigan

Department of Housing and Urban Development as awarding agency, Michigan as place-of-performance: 347,361 records summing to $5,425,944,225.61. A Department of Housing and Urban Development 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, and Ontario (which is not a USAspending state key). A Toledo-coded award is Ohio.

Three hundred forty-seven thousand three hundred sixty-one awards is an extreme-count HUD file. A low implied mean is the arithmetic of that huge denominator, not a typical voucher. Unique recipients are unpublished. Do not read 347,361 as 347,361 unique households, unique landlords, or a rent index. The overlay Department of Housing and Urban Development in Michigan is the both-keys table. Michigan federal spending is the all-agency state hub. Department of Housing and Urban Development is the agency book without an MI filter. All spending ties lists other joins.

Detroit, Grand Rapids, and Upper Peninsula PHAs are unpublished. Do not treat the count as a census of people. Correlation is not causation: Michigan did not “cause” $5,425,944,225.61 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 086 × MI only.

347,361 rows are not 347,361 households

$5,425,944,225.61 does not measure households, unique landlords, or a rent index. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 086 and an MI place-of-performance tag.

Do not treat 347,361 awards as a census of households, unique landlords, or a rent index. Parent hubs are supposed to be larger than this pair. If Michigan federal spending or Department of Housing and Urban Development matched $5,425,944,225.61 and 347,361, the join would be pointless. Use the overlay when both keys must stay on. Ohio, Indiana, and Wisconsin HUD joins are other pairs, not addends.

Michigan, not a Detroit-only ledger

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, and Ontario (which is not a USAspending state key). A Toledo-coded award is Ohio. Recipient address can differ from that state tag.

Detroit, Grand Rapids, and Upper Peninsula PHAs are unpublished. Do not treat the count as a census of people. This packet does not split $5,425,944,225.61 by city, county, or named facility. 347,361 awards stay statewide. A county table would be a different extract.

Assistance-row volume still means obligations

Even a thick or thin file records obligations, not necessarily outlays. $5,425,944,225.61 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 347,361-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 $5,425,944,225.61.

Citing HUD in Michigan

Cite USAspending.gov: Department of Housing and Urban Development (agency 086) obligated $5,425,944,225.61 on 347,361 awards coded to Michigan. Name both sides. Keep “obligations.” Do not relabel the total as households, unique landlords, or a rent index.

Prefer Department of Housing and Urban Development in Michigan if the overlay has refreshed after an ingest. Michigan federal spending still includes every other awarding agency tagged to MI. Department of Housing and Urban Development is the 086 parent without the MI filter. All spending ties indexes other pairs. Do not add those parents into $5,425,944,225.61.

A usable footnote names Department of Housing and Urban Development, Michigan, $5,425,944,225.61, and 347,361. The compact headline $5.43 billion is that same dollar total rounded. It is not a second extract. The implied mean near $15,620 is $5,425,944,225.61 divided by 347,361. Means are not medians. USAspending.gov remains the originating system.

Questions

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

USAspending.gov records $5,425,944,225.61 across 347,361 awards with awarding agency 086 and a Michigan tag. That is an obligation join, not an outlay and not a count of households, unique landlords, or a rent index. Department of Housing and Urban Development in Michigan is the live overlay for this pair. Keep both keys when quoting $5,425,944,225.61.

Is $5,425,944,225.61 a measure of households, unique landlords, or a rent index?

No. The packet publishes $5,425,944,225.61 and 347,361 awards for agency 086 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 HUD file have 347,361 awards?

That is the award-record count for 086 × MI. Combined with $5,425,944,225.61, the average is about $15,620. Modifications and repeat instruments add rows. 347,361 is not unique households, unique landlords, or a rent index. 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 Michigan is the overlay. Michigan 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 $5,425,944,225.61. USAspending.gov is the source. Obligations are not outlays.