Department of Transportation in Arizona

DOT awards tagged to Arizona

Department of Transportation as awarding agency, Arizona as place-of-performance: 1,948 records summing to $6,277,462,219.40. A Department of Transportation award coded outside AZ is out. An award in Arizona from a different awarding agency is out even if the topic sounds related. Arizona (AZ) excludes California, Nevada, Utah, Colorado, and New Mexico. A San Diego-coded award is California.

One thousand nine hundred forty-eight awards is a mid-thin DOT file: more than a few-hundred lab-style cell, fewer than a USDA assistance flood. Unique recipients are unpublished. Do not read 1,948 as 1,948 unique lane-miles, transit ridership, or traffic fatalities. The overlay Department of Transportation in Arizona is the both-keys table. Arizona federal spending is the all-agency state hub. Department of Transportation is the agency book without an AZ filter. All spending ties lists other joins.

Phoenix and Tucson are not published splits of $6,277,462,219.40. I-10 folklore is not a packet field. Correlation is not causation: Arizona did not “cause” $6,277,462,219.40 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 069 × AZ only.

Not a highway-mile or crash ranking

$6,277,462,219.40 does not measure lane-miles, transit ridership, or traffic fatalities. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 069 and an AZ place-of-performance tag.

Do not treat 1,948 awards as a census of lane-miles, transit ridership, or traffic fatalities. Parent hubs are supposed to be larger than this pair. If Arizona federal spending or Department of Transportation matched $6,277,462,219.40 and 1,948, the join would be pointless. Use the overlay when both keys must stay on. California, New Mexico, and Nevada DOT joins are other pairs, not addends.

Questions

How much has the Department of Transportation obligated in Arizona?

USAspending.gov records $6,277,462,219.40 across 1,948 awards with awarding agency 069 and an Arizona tag. That is an obligation join, not an outlay and not a count of lane-miles, transit ridership, or traffic fatalities. Department of Transportation in Arizona is the live overlay for this pair. Keep both keys when quoting $6,277,462,219.40.

Is $6,277,462,219.40 a measure of lane-miles, transit ridership, or traffic fatalities?

No. The packet publishes $6,277,462,219.40 and 1,948 awards for agency 069 inside AZ 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 1,948 awards?

That is the award-record count for 069 × AZ. Combined with $6,277,462,219.40, the average is about $3.22 million. Modifications and repeat instruments add rows. 1,948 is not unique lane-miles, transit ridership, 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 Arizona is the overlay. Arizona 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 $6,277,462,219.40. USAspending.gov is the source. Obligations are not outlays.