Department of Transportation in Oklahoma

DOT awards tagged to Oklahoma

Department of Transportation as awarding agency, Oklahoma as place-of-performance: 4,300 records summing to $5,823,760,634.73. A Department of Transportation award coded outside OK is out. An award in Oklahoma from a different awarding agency is out even if the topic sounds related. Oklahoma (OK) excludes Texas, Kansas, Arkansas, Missouri, Colorado, and New Mexico. A Dallas-coded award is Texas.

Four thousand three hundred awards is a thicker DOT file. Modifications and formula instruments can add rows without each row being a new construction project. Unique recipients are unpublished. Do not read 4,300 as 4,300 unique turnpike miles, freight tonnage, or unique contractors. The overlay Department of Transportation in Oklahoma is the both-keys table. Oklahoma federal spending is the all-agency state hub. Department of Transportation is the agency book without an OK filter. All spending ties lists other joins.

Oklahoma City and Tulsa are unpublished metro shares of $5,823,760,634.73. Correlation is not causation: Oklahoma did not “cause” $5,823,760,634.73 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 069 × OK only.

Not turnpike miles or a crash ranking

$5,823,760,634.73 does not measure turnpike miles, freight tonnage, or unique contractors. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 069 and an OK place-of-performance tag.

Do not treat 4,300 awards as a census of turnpike miles, freight tonnage, or unique contractors. Parent hubs are supposed to be larger than this pair. If Oklahoma federal spending or Department of Transportation matched $5,823,760,634.73 and 4,300, the join would be pointless. Use the overlay when both keys must stay on. Texas, Kansas, and Arkansas DOT joins are other pairs, not addends.

Questions

How much has the Department of Transportation obligated in Oklahoma?

USAspending.gov records $5,823,760,634.73 across 4,300 awards with awarding agency 069 and an Oklahoma tag. That is an obligation join, not an outlay and not a count of turnpike miles, freight tonnage, or unique contractors. Department of Transportation in Oklahoma is the live overlay for this pair. Keep both keys when quoting $5,823,760,634.73.

Is $5,823,760,634.73 a measure of turnpike miles, freight tonnage, or unique contractors?

No. The packet publishes $5,823,760,634.73 and 4,300 awards for agency 069 inside OK 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 DOT file have 4,300 awards?

That is the award-record count for 069 × OK. Combined with $5,823,760,634.73, the average is about $1.35 million. Modifications and repeat instruments add rows. 4,300 is not unique turnpike miles, freight tonnage, or unique contractors. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Transportation in Oklahoma is the overlay. Oklahoma federal spending and Department of Transportation are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $5,823,760,634.73. USAspending.gov is the source. Obligations are not outlays.