Department of Homeland Security federal obligations in Illinois

A thin DHS file on Illinois

Department of Homeland Security as awarding agency, Illinois as place-of-performance: 975 records summing to $3,726,605,199.58. A Department of Homeland Security award coded outside IL is out. An award in Illinois from a different awarding agency is out even if the topic sounds related. Illinois (IL) excludes Wisconsin, Indiana, Kentucky, Missouri, and Iowa. A St. Louis-coded award is Missouri.

Nine hundred seventy-five awards against $3,726,605,199.58 is a thin, high-mean DHS pattern. One restatement can move the mean quickly. Unique recipients are unpublished. Do not read 975 as 975 unique disaster declarations, border crossings, or named FEMA events. The overlay Department of Homeland Security in Illinois is the both-keys table. Illinois federal spending is the all-agency state hub. Department of Homeland Security is the agency book without an IL filter. All spending ties lists other joins.

O’Hare and the Port of Chicago are not named in the facts. Do not assign $3,726,605,199.58 to a facility. Correlation is not causation: Illinois did not “cause” $3,726,605,199.58 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 070 × IL only.

975 rows are not 975 disasters

$3,726,605,199.58 does not measure disaster declarations, border crossings, or named FEMA events. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 070 and an IL place-of-performance tag.

Do not treat 975 awards as a census of disaster declarations, border crossings, or named FEMA events. Parent hubs are supposed to be larger than this pair. If Illinois federal spending or Department of Homeland Security matched $3,726,605,199.58 and 975, the join would be pointless. Use the overlay when both keys must stay on. Indiana, Wisconsin, and Missouri DHS joins are other pairs, not addends.

Illinois, not a Great Lakes DHS rollup

Place of performance IL is a geography tag on the award, not a metro list and not a commuting zone. Illinois (IL) excludes Wisconsin, Indiana, Kentucky, Missouri, and Iowa. A St. Louis-coded award is Missouri. Recipient address can differ from that state tag.

O’Hare and the Port of Chicago are not named in the facts. Do not assign $3,726,605,199.58 to a facility. This packet does not split $3,726,605,199.58 by city, county, or named facility. 975 awards stay statewide. A county table would be a different extract.

High-mean vehicles versus cash already paid

Even a thick or thin file records obligations, not necessarily outlays. $3,726,605,199.58 can include amounts that pay on a later schedule. Citing it as cash already sent in Illinois confuses two concepts. Deobligations and upward adjustments both move the total.

Illinois’s own budget is a different ledger. Mixing it with the 975-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 $3,726,605,199.58.

Citing DHS in Illinois

Cite USAspending.gov: Department of Homeland Security (agency 070) obligated $3,726,605,199.58 on 975 awards coded to Illinois. Name both sides. Keep “obligations.” Do not relabel the total as disaster declarations, border crossings, or named FEMA events.

Prefer Department of Homeland Security in Illinois if the overlay has refreshed after an ingest. Illinois federal spending still includes every other awarding agency tagged to IL. Department of Homeland Security is the 070 parent without the IL filter. All spending ties indexes other pairs. Do not add those parents into $3,726,605,199.58.

A usable footnote names Department of Homeland Security, Illinois, $3,726,605,199.58, and 975. The compact headline $3.73 billion is that same dollar total rounded. It is not a second extract. The implied mean near $3.82 million is $3,726,605,199.58 divided by 975. Means are not medians. USAspending.gov remains the originating system.

Questions

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

USAspending.gov records $3,726,605,199.58 across 975 awards with awarding agency 070 and an Illinois tag. That is an obligation join, not an outlay and not a count of disaster declarations, border crossings, or named FEMA events. Department of Homeland Security in Illinois is the live overlay for this pair. Keep both keys when quoting $3,726,605,199.58.

Is $3,726,605,199.58 a measure of disaster declarations, border crossings, or named FEMA events?

No. The packet publishes $3,726,605,199.58 and 975 awards for agency 070 inside IL 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 975 awards?

That is the award-record count for 070 × IL. Combined with $3,726,605,199.58, the average is about $3.82 million. Modifications and repeat instruments add rows. 975 is not unique disaster declarations, border crossings, or named FEMA events. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Homeland Security in Illinois is the overlay. Illinois 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 $3,726,605,199.58. USAspending.gov is the source. Obligations are not outlays.