Department of Transportation in Tennessee

DOT awards tagged to Tennessee

Department of Transportation as awarding agency, Tennessee as place-of-performance: 3,228 records summing to $5,431,264,021.18. A Department of Transportation award coded outside TN is out. An award in Tennessee from a different awarding agency is out even if the topic sounds related. Tennessee (TN) excludes Kentucky, Virginia, North Carolina, Georgia, Alabama, Mississippi, Arkansas, and Missouri. A Memphis, Arkansas-coded award is AR.

Three thousand two hundred twenty-eight awards is a mid-count DOT file. Similar DOT counts elsewhere are not a ranking of road quality. Unique recipients are unpublished. Do not read 3,228 as 3,228 unique lane-miles, freight tonnage, or unique contractors. The overlay Department of Transportation in Tennessee is the both-keys table. Tennessee federal spending is the all-agency state hub. Department of Transportation is the agency book without a TN filter. All spending ties lists other joins.

Nashville, Memphis, and Knoxville are unpublished. $5,431,264,021.18 stays statewide. Correlation is not causation: Tennessee did not “cause” $5,431,264,021.18 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 069 × TN only.

Not I-40 folklore or a freight score

$5,431,264,021.18 does not measure lane-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 a TN place-of-performance tag.

Do not treat 3,228 awards as a census of lane-miles, freight tonnage, or unique contractors. Parent hubs are supposed to be larger than this pair. If Tennessee federal spending or Department of Transportation matched $5,431,264,021.18 and 3,228, the join would be pointless. Use the overlay when both keys must stay on. Kentucky, Alabama, and Georgia DOT joins are other pairs, not addends.

Questions

How much has the Department of Transportation obligated in Tennessee?

USAspending.gov records $5,431,264,021.18 across 3,228 awards with awarding agency 069 and a Tennessee tag. That is an obligation join, not an outlay and not a count of lane-miles, freight tonnage, or unique contractors. Department of Transportation in Tennessee is the live overlay for this pair. Keep both keys when quoting $5,431,264,021.18.

Is $5,431,264,021.18 a measure of lane-miles, freight tonnage, or unique contractors?

No. The packet publishes $5,431,264,021.18 and 3,228 awards for agency 069 inside TN 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 3,228 awards?

That is the award-record count for 069 × TN. Combined with $5,431,264,021.18, the average is about $1.68 million. Modifications and repeat instruments add rows. 3,228 is not unique lane-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 Tennessee is the overlay. Tennessee 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,431,264,021.18. USAspending.gov is the source. Obligations are not outlays.