Department of Homeland Security 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.

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.