Department of Defense in Utah

Defense awards tagged to Utah

The pair is 097 × UT. $30,838,312,367.20 is the obligation sum. 18,073 is the award count. Eighteen thousand records under $30.84 billion produces a mean near $1.71 million. That mean mixes vehicles. Ranking Utah against Colorado or Nevada would require other packets.

The join does not identify ranges, depots, or contractors. Those nouns are not in the facts.

Repeat the pair until it sticks: $30,838,312,367.20 on 18,073 awards, both keys required. Drop the state and the agency hub takes over. Drop the agency and the state hub takes over. This page is the remainder after both filters.

Agency 097 versus Utah’s full mix

The Department of Defense hub without Utah will not equal $30,838,312,367.20. The Utah hub without 097 includes civilian awarding agencies. Overlay /states/ut/agencies/097/ is the both-keys table for 18,073 awards.

The architecture is simple. One hub is the agency without geography. One hub is the geography without this agency. One overlay is both. $30,838,312,367.20 and 18,073 belong to the overlay. The hubs answer different questions.

Questions

How much has DoD obligated in Utah?

USAspending records $30,838,312,367.20 in obligations for agency 097 with Utah place of performance, on 18,073 awards. That is an obligation join, not an outlay total. The pair is awarding agency 097 (Department of Defense) and place-of-performance Utah. It is not Department of Defense nationwide and not Utah from every awarding agency.

What is the average award?

About $1.71 million ($30,838,312,367.20 ÷ 18,073). The mean mixes vehicles and is not a typical contract. That ratio uses only $30,838,312,367.20 and 18,073 from the packet. A mean hides mix: a few large instruments can sit beside many smaller ones.

Does this include Colorado or Nevada?

No. Place of performance is Utah only. Other states are outside $30,838,312,367.20 and outside the 18,073 awards. Only place-of-performance Utah plus awarding agency 097 (Department of Defense) enter $30,838,312,367.20. Adjacent state codes are other filters, if they exist as ties at all.

Does the total list installations?

No. The facts are agency 097 and state UT. Installation names are not in the aggregate. The $30,838,312,367.20 total follows those two fields. The facts are agency 097 and place-of-performance Utah totaling $30,838,312,367.20 on 18,073 awards. Program names, sites, and mission splits are not in this aggregate and are not assigned shares of $30,838,312,367.20.