Department of Transportation in Alabama

DOT awards tagged to Alabama

Department of Transportation as awarding agency, Alabama as place-of-performance: 3,175 records summing to $5,905,823,501.27. A Department of Transportation award coded outside AL is out. An award in Alabama from a different awarding agency is out even if the topic sounds related. Alabama (AL) excludes Mississippi, Tennessee, Georgia, and Florida. A Mobile-adjacent Mississippi award is MS, not this cell.

Three thousand one hundred seventy-five awards is a mid-count DOT file: more rows than a thin lab-style cell, fewer than a USDA assistance flood. Unique recipients are unpublished. Do not read 3,175 as 3,175 unique lane-miles, bridge ratings, or traffic fatalities. The overlay Department of Transportation in Alabama is the both-keys table. Alabama federal spending is the all-agency state hub. Department of Transportation is the agency book without an AL filter. All spending ties lists other joins.

I-65 and I-20 folklore is not a packet split. $5,905,823,501.27 stays statewide on 069 × AL. Correlation is not causation: Alabama did not “cause” $5,905,823,501.27 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 069 × AL only.

Not a bridge census or a traffic ranking

$5,905,823,501.27 does not measure lane-miles, bridge ratings, or traffic fatalities. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 069 and an AL place-of-performance tag.

Do not treat 3,175 awards as a census of lane-miles, bridge ratings, or traffic fatalities. Parent hubs are supposed to be larger than this pair. If Alabama federal spending or Department of Transportation matched $5,905,823,501.27 and 3,175, the join would be pointless. Use the overlay when both keys must stay on. Mississippi, Georgia, and Tennessee DOT joins are other pairs, not addends.

Questions

How much has the Department of Transportation obligated in Alabama?

USAspending.gov records $5,905,823,501.27 across 3,175 awards with awarding agency 069 and an Alabama tag. That is an obligation join, not an outlay and not a count of lane-miles, bridge ratings, or traffic fatalities. Department of Transportation in Alabama is the live overlay for this pair. Keep both keys when quoting $5,905,823,501.27.

Is $5,905,823,501.27 a measure of lane-miles, bridge ratings, or traffic fatalities?

No. The packet publishes $5,905,823,501.27 and 3,175 awards for agency 069 inside AL 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,175 awards?

That is the award-record count for 069 × AL. Combined with $5,905,823,501.27, the average is about $1.86 million. Modifications and repeat instruments add rows. 3,175 is not unique lane-miles, bridge ratings, or traffic fatalities. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Transportation in Alabama is the overlay. Alabama 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,905,823,501.27. USAspending.gov is the source. Obligations are not outlays.