Department of Homeland Security in Wisconsin

DHS awards tagged to Wisconsin

Department of Homeland Security as awarding agency, Wisconsin as place-of-performance: 739 records summing to $1,405,924,131.25. A Department of Homeland Security award coded outside WI is out. An award in Wisconsin from a different awarding agency is out even if the topic sounds related. Wisconsin (WI) excludes Minnesota, Illinois, Michigan, and Iowa. A Chicago-coded award is Illinois even if a port sits on the lake.

Seven hundred thirty-nine awards against $1,405,924,131.25 is a mid-count DHS file, not a thin headquarters-only list. Unique recipients are unpublished. Do not read 739 as 739 unique unique grants, disaster declarations, or named components. The overlay Department of Homeland Security in Wisconsin is the both-keys table. Wisconsin federal spending is the all-agency state hub. Department of Homeland Security is the agency book without a WI filter. All spending ties lists other joins.

FEMA, CBP, and Coast Guard labels are unpublished. This packet does not say which dominate $1,405,924,131.25. Correlation is not causation: Wisconsin did not cause $1,405,924,131.25 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 070 × WI only.

Not FEMA declarations or a component headcount

$1,405,924,131.25 does not measure unique grants, disaster declarations, or named components. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 070 and a WI place-of-performance tag.

Do not treat 739 awards as a census of unique grants, disaster declarations, or named components. Parent hubs are supposed to be larger than this pair. If Wisconsin federal spending or Department of Homeland Security matched $1,405,924,131.25 and 739, the join would be pointless. Use the overlay when both keys must stay on. Minnesota, Illinois, and Michigan DHS joins are other pairs, not addends.

Questions

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

USAspending.gov records $1,405,924,131.25 across 739 awards with awarding agency 070 and a Wisconsin tag. That is an obligation join, not an outlay and not a count of unique grants, disaster declarations, or named components. Department of Homeland Security in Wisconsin is the live overlay for this pair. Keep both keys when quoting $1,405,924,131.25.

Is $1,405,924,131.25 a measure of unique grants, disaster declarations, or named components?

No. The packet publishes $1,405,924,131.25 and 739 awards for agency 070 inside WI 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 739 awards?

That is the award-record count for 070 × WI. Combined with $1,405,924,131.25, the average is about $1.90 million. Modifications and repeat instruments add rows. 739 is not unique unique grants, disaster declarations, or named components. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Homeland Security in Wisconsin is the overlay. Wisconsin 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 $1,405,924,131.25. USAspending.gov is the source. Obligations are not outlays.