Department of Homeland Security in Oregon

A thin DHS file on Oregon

Department of Homeland Security as awarding agency, Oregon as place-of-performance: 491 records summing to $3,042,687,110.12. A Department of Homeland Security award coded outside OR is out. An award in Oregon from a different awarding agency is out even if the topic sounds related. Oregon (OR) excludes Washington, Idaho, Nevada, and California. A Vancouver, Washington-coded award is WA.

Four hundred ninety-one awards against $3,042,687,110.12 is a thin, high-mean DHS pattern. Few rows can carry large fiscal vehicles. Unique recipients are unpublished. Do not read 491 as 491 unique disaster declarations, wildfire counts, or named FEMA events. The overlay Department of Homeland Security in Oregon is the both-keys table. Oregon federal spending is the all-agency state hub. Department of Homeland Security is the agency book without an OR filter. All spending ties lists other joins.

Port of Portland folklore is not named in the facts. Do not assign $3,042,687,110.12 to a facility. Correlation is not causation: Oregon did not “cause” $3,042,687,110.12 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 070 × OR only.

491 rows are not 491 declarations

$3,042,687,110.12 does not measure disaster declarations, wildfire counts, 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 OR place-of-performance tag.

Do not treat 491 awards as a census of disaster declarations, wildfire counts, or named FEMA events. Parent hubs are supposed to be larger than this pair. If Oregon federal spending or Department of Homeland Security matched $3,042,687,110.12 and 491, the join would be pointless. Use the overlay when both keys must stay on. Washington, California, and Idaho DHS joins are other pairs, not addends.

Questions

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

USAspending.gov records $3,042,687,110.12 across 491 awards with awarding agency 070 and an Oregon tag. That is an obligation join, not an outlay and not a count of disaster declarations, wildfire counts, or named FEMA events. Department of Homeland Security in Oregon is the live overlay for this pair. Keep both keys when quoting $3,042,687,110.12.

Is $3,042,687,110.12 a measure of disaster declarations, wildfire counts, or named FEMA events?

No. The packet publishes $3,042,687,110.12 and 491 awards for agency 070 inside OR 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 491 awards?

That is the award-record count for 070 × OR. Combined with $3,042,687,110.12, the average is about $6.20 million. Modifications and repeat instruments add rows. 491 is not unique disaster declarations, wildfire counts, 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 Oregon is the overlay. Oregon 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,042,687,110.12. USAspending.gov is the source. Obligations are not outlays.