Department of Homeland Security federal obligations in Colorado

A thin DHS file on Colorado

Department of Homeland Security as awarding agency, Colorado as place-of-performance: 501 records summing to $3,439,737,162.56. A Department of Homeland Security award coded outside CO is out. An award in Colorado from a different awarding agency is out even if the topic sounds related. Colorado (CO) excludes Wyoming, Nebraska, Kansas, Oklahoma, New Mexico, Arizona, and Utah. A Cheyenne-coded award is Wyoming.

Five hundred one awards against $3,439,737,162.56 is a thin, high-mean DHS pattern. Few rows can carry large fiscal vehicles. Unique recipients are unpublished. Do not read 501 as 501 unique disaster declarations, border crossings, or named FEMA events. The overlay Department of Homeland Security in Colorado is the both-keys table. Colorado federal spending is the all-agency state hub. Department of Homeland Security is the agency book without a CO filter. All spending ties lists other joins.

Denver International and FEMA Region VIII folklore are not packet fields. Do not assign $3,439,737,162.56 to a facility. Correlation is not causation: Colorado did not “cause” $3,439,737,162.56 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 070 × CO only.

501 rows are not 501 declarations

$3,439,737,162.56 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 a CO place-of-performance tag.

Do not treat 501 awards as a census of disaster declarations, border crossings, or named FEMA events. Parent hubs are supposed to be larger than this pair. If Colorado federal spending or Department of Homeland Security matched $3,439,737,162.56 and 501, the join would be pointless. Use the overlay when both keys must stay on. Wyoming, New Mexico, and Utah DHS joins are other pairs, not addends.

Colorado, not a Front Range DHS rollup

Place of performance CO is a geography tag on the award, not a metro list and not a commuting zone. Colorado (CO) excludes Wyoming, Nebraska, Kansas, Oklahoma, New Mexico, Arizona, and Utah. A Cheyenne-coded award is Wyoming. Recipient address can differ from that state tag.

Denver International and FEMA Region VIII folklore are not packet fields. Do not assign $3,439,737,162.56 to a facility. This packet does not split $3,439,737,162.56 by city, county, or named facility. 501 awards stay statewide. A county table would be a different extract.

High-mean vehicles versus outlays

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

Colorado’s own budget is a different ledger. Mixing it with the 501-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,439,737,162.56.

Citing DHS in Colorado

Cite USAspending.gov: Department of Homeland Security (agency 070) obligated $3,439,737,162.56 on 501 awards coded to Colorado. 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 Colorado if the overlay has refreshed after an ingest. Colorado federal spending still includes every other awarding agency tagged to CO. Department of Homeland Security is the 070 parent without the CO filter. All spending ties indexes other pairs. Do not add those parents into $3,439,737,162.56.

A usable footnote names Department of Homeland Security, Colorado, $3,439,737,162.56, and 501. The compact headline $3.44 billion is that same dollar total rounded. It is not a second extract. The implied mean near $6.87 million is $3,439,737,162.56 divided by 501. Means are not medians. USAspending.gov remains the originating system.

Questions

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

USAspending.gov records $3,439,737,162.56 across 501 awards with awarding agency 070 and a Colorado 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 Colorado is the live overlay for this pair. Keep both keys when quoting $3,439,737,162.56.

Is $3,439,737,162.56 a measure of disaster declarations, border crossings, or named FEMA events?

No. The packet publishes $3,439,737,162.56 and 501 awards for agency 070 inside CO 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 501 awards?

That is the award-record count for 070 × CO. Combined with $3,439,737,162.56, the average is about $6.87 million. Modifications and repeat instruments add rows. 501 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 Colorado is the overlay. Colorado 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,439,737,162.56. USAspending.gov is the source. Obligations are not outlays.