Department of Transportation in Colorado

DOT awards tagged to Colorado

Department of Transportation as awarding agency, Colorado as place-of-performance: 2,857 records summing to $4,593,394,293.93. A Department of Transportation award coded outside CO is out. An award in Colorado from a different awarding agency is out even if the topic sounds related. Colorado (CO) excludes Wyoming, Utah, New Mexico, Kansas, Nebraska, and Oklahoma. A Cheyenne-coded award is Wyoming.

Two thousand eight hundred fifty-seven awards sits in a moderate DOT band. Modifications can add rows without each row being a new construction project. Unique recipients are unpublished. Do not read 2,857 as 2,857 unique lane-miles, unique contractors, or named Interstates. The overlay Department of Transportation in Colorado is the both-keys table. Colorado federal spending is the all-agency state hub. Department of Transportation is the agency book without a CO filter. All spending ties lists other joins.

Denver International and mountain-pass folklore are unpublished. $4,593,394,293.93 stays statewide. Correlation is not causation: Colorado did not “cause” $4,593,394,293.93 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 069 × CO only.

Not an I-70 mountain-corridor census

$4,593,394,293.93 does not measure lane-miles, unique contractors, or named Interstates. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 069 and a CO place-of-performance tag.

Do not treat 2,857 awards as a census of lane-miles, unique contractors, or named Interstates. Parent hubs are supposed to be larger than this pair. If Colorado federal spending or Department of Transportation matched $4,593,394,293.93 and 2,857, the join would be pointless. Use the overlay when both keys must stay on. Wyoming, Utah, and New Mexico DOT joins are other pairs, not addends.

Questions

How much has the Department of Transportation obligated in Colorado?

USAspending.gov records $4,593,394,293.93 across 2,857 awards with awarding agency 069 and a Colorado tag. That is an obligation join, not an outlay and not a count of lane-miles, unique contractors, or named Interstates. Department of Transportation in Colorado is the live overlay for this pair. Keep both keys when quoting $4,593,394,293.93.

Is $4,593,394,293.93 a measure of lane-miles, unique contractors, or named Interstates?

No. The packet publishes $4,593,394,293.93 and 2,857 awards for agency 069 inside CO 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 2,857 awards?

That is the award-record count for 069 × CO. Combined with $4,593,394,293.93, the average is about $1.61 million. Modifications and repeat instruments add rows. 2,857 is not unique lane-miles, unique contractors, or named Interstates. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Transportation in Colorado is the overlay. Colorado 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 $4,593,394,293.93. USAspending.gov is the source. Obligations are not outlays.