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

Oregon, not a Pacific Northwest DHS rollup

Place of performance OR is a geography tag on the award, not a metro list and not a commuting zone. Oregon (OR) excludes Washington, Idaho, Nevada, and California. A Vancouver, Washington-coded award is WA. Recipient address can differ from that state tag.

Port of Portland folklore is not named in the facts. Do not assign $3,042,687,110.12 to a facility. This packet does not split $3,042,687,110.12 by city, county, or named facility. 491 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,042,687,110.12 can include amounts that pay on a later schedule. Citing it as cash already sent in Oregon confuses two concepts. Deobligations and upward adjustments both move the total.

Oregon’s own budget is a different ledger. Mixing it with the 491-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,042,687,110.12.

Citing DHS in Oregon

Cite USAspending.gov: Department of Homeland Security (agency 070) obligated $3,042,687,110.12 on 491 awards coded to Oregon. Name both sides. Keep “obligations.” Do not relabel the total as disaster declarations, wildfire counts, or named FEMA events.

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

A usable footnote names Department of Homeland Security, Oregon, $3,042,687,110.12, and 491. The compact headline $3.04 billion is that same dollar total rounded. It is not a second extract. The implied mean near $6.20 million is $3,042,687,110.12 divided by 491. Means are not medians. USAspending.gov remains the originating system.

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.