Department of Homeland Security in Michigan

DHS awards tagged to Michigan

Department of Homeland Security as awarding agency, Michigan as place-of-performance: 896 records summing to $2,931,727,963.22. A Department of Homeland Security 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 Illinois. A Toledo-coded award is Ohio even if the crew works a Michigan shoreline.

Eight hundred ninety-six awards is a thin-to-mid DHS file: fewer rows than a thick HUD assistance book, more than a handful of oversized Energy awards. Unique recipients are unpublished. Do not read 896 as 896 unique disaster declarations, FEMA applicants, or border crossings. The overlay Department of Homeland Security in Michigan is the both-keys table. Michigan federal spending is the all-agency state hub. Department of Homeland Security is the agency book without an MI filter. All spending ties lists other joins.

Detroit-versus-Upper-Peninsula folklore is unpublished. The join stays statewide under awarding-agency 070. Correlation is not causation: Michigan did not “cause” $2,931,727,963.22 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 070 × MI only.

Not a disaster-declaration ledger

$2,931,727,963.22 does not measure disaster declarations, FEMA applicants, or border crossings. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 070 and an MI place-of-performance tag.

Do not treat 896 awards as a census of disaster declarations, FEMA applicants, or border crossings. Parent hubs are supposed to be larger than this pair. If Michigan federal spending or Department of Homeland Security matched $2,931,727,963.22 and 896, the join would be pointless. Use the overlay when both keys must stay on. Ohio, Indiana, and Wisconsin DHS joins are other pairs, not addends.

Questions

How much has the Department of Homeland Security obligated in Michigan?

USAspending.gov records $2,931,727,963.22 across 896 awards with awarding agency 070 and a Michigan tag. That is an obligation join, not an outlay and not a count of disaster declarations, FEMA applicants, or border crossings. Department of Homeland Security in Michigan is the live overlay for this pair. Keep both keys when quoting $2,931,727,963.22.

Is $2,931,727,963.22 a measure of disaster declarations, FEMA applicants, or border crossings?

No. The packet publishes $2,931,727,963.22 and 896 awards for agency 070 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 DHS file have 896 awards?

That is the award-record count for 070 × MI. Combined with $2,931,727,963.22, the average is about $3.27 million. Modifications and repeat instruments add rows. 896 is not unique disaster declarations, FEMA applicants, or border crossings. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Homeland Security in Michigan is the overlay. Michigan federal spending and Department of Homeland Security are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $2,931,727,963.22. USAspending.gov is the source. Obligations are not outlays.