Department of Defense in Oregon

A high-count DOD file on Oregon

Department of Defense as awarding agency, Oregon as place-of-performance: 17,876 records summing to $4,013,642,258.23. A Department of Defense 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, California, Idaho, and Nevada. A Joint Base Lewis-McChord story is Washington, not this cell.

Seventeen thousand eight hundred seventy-six awards is a high-count Defense file. Modifications add rows; unique contractors are unpublished. Unique recipients are unpublished. Do not read 17,876 as 17,876 unique active-duty headcount, named installations, or jobs created. The overlay Department of Defense in Oregon is the both-keys table. Oregon federal spending is the all-agency state hub. Department of Defense is the agency book without an OR filter. All spending ties lists other joins.

This packet does not isolate Guard from active-component offices. $4,013,642,258.23 stays 097 × OR. Correlation is not causation: Oregon did not “cause” $4,013,642,258.23 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 097 × OR only.

Not troops, Guard billets, or named bases

$4,013,642,258.23 does not measure active-duty headcount, named installations, or jobs created. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 097 and an OR place-of-performance tag.

Do not treat 17,876 awards as a census of active-duty headcount, named installations, or jobs created. Parent hubs are supposed to be larger than this pair. If Oregon federal spending or Department of Defense matched $4,013,642,258.23 and 17,876, the join would be pointless. Use the overlay when both keys must stay on. Washington, California, and Idaho DOD joins are other pairs, not addends.

Questions

How much has the Department of Defense obligated in Oregon?

USAspending.gov records $4,013,642,258.23 across 17,876 awards with awarding agency 097 and an Oregon tag. That is an obligation join, not an outlay and not a count of active-duty headcount, named installations, or jobs created. Department of Defense in Oregon is the live overlay for this pair. Keep both keys when quoting $4,013,642,258.23.

Is $4,013,642,258.23 a measure of active-duty headcount, named installations, or jobs created?

No. The packet publishes $4,013,642,258.23 and 17,876 awards for agency 097 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 DOD file have 17,876 awards?

That is the award-record count for 097 × OR. Combined with $4,013,642,258.23, the average is about $224,527. Modifications and repeat instruments add rows. 17,876 is not unique active-duty headcount, named installations, or jobs created. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Defense in Oregon is the overlay. Oregon federal spending and Department of Defense are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $4,013,642,258.23. USAspending.gov is the source. Obligations are not outlays.