Department of Commerce in Oregon

A thin Commerce file on an Oregon tag

Department of Commerce as awarding agency, Oregon as place-of-performance: 475 records summing to $1,982,555,744.72. A Department of Commerce 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, Nevada, and Idaho. A Vancouver, Washington-coded award is WA even if a Portland office later invoices it. Census, NOAA, NIST, EDA, and other Commerce bureaus are unpublished splits inside awarding agency 013.

Four hundred seventy-five awards against $1,982,555,744.72 is a thin, high-mean file. A handful of vehicles can dominate the dollar total. Unique recipients are unpublished. Do not read 475 as 475 unique port TEUs, unique firms, or named Census/NOAA facilities. The overlay Department of Commerce in Oregon is the both-keys table. Oregon federal spending is the all-agency state hub. Department of Commerce is the agency book without an OR filter. All spending ties lists other joins.

Portland, Salem, and Eugene are unpublished. Assigning $1,982,555,744.72 to a named port is a new extract. Correlation is not causation: Oregon did not “cause” $1,982,555,744.72 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 013 × OR only.

Not a Portland-port or NOAA station ledger

$1,982,555,744.72 does not measure port TEUs, unique firms, or named Census/NOAA facilities. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 013 and an OR place-of-performance tag. Census, NOAA, NIST, EDA, and other Commerce bureaus are unpublished splits inside awarding agency 013.

Do not treat 475 awards as a census of port TEUs, unique firms, or named Census/NOAA facilities. Parent hubs are supposed to be larger than this pair. If Oregon federal spending or Department of Commerce matched $1,982,555,744.72 and 475, the join would be pointless. Use the overlay when both keys must stay on. Washington, California, and Idaho Commerce joins are other pairs, not addends.

Questions

How much has the Department of Commerce obligated in Oregon?

USAspending.gov records $1,982,555,744.72 across 475 awards with awarding agency 013 and an Oregon tag. That is an obligation join, not an outlay and not a count of port TEUs, unique firms, or named Census/NOAA facilities. Department of Commerce in Oregon is the live overlay for this pair. Keep both keys when quoting $1,982,555,744.72.

Is $1,982,555,744.72 a measure of port TEUs, unique firms, or named Census/NOAA facilities?

No. The packet publishes $1,982,555,744.72 and 475 awards for agency 013 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 Commerce file have 475 awards?

That is the award-record count for 013 × OR. Combined with $1,982,555,744.72, the average is about $4.17 million. Modifications and repeat instruments add rows. 475 is not unique port TEUs, unique firms, or named Census/NOAA facilities. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live Commerce–Oregon table?

Department of Commerce in Oregon is the overlay. Oregon federal spending and Department of Commerce are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $1,982,555,744.72. USAspending.gov is the source. Obligations are not outlays.