Department of Defense in Maine

Defense and Maine as a two-field filter

Keep 097 and ME; sum obligations. The harvest shows $31,591,199,764.95 on 21,869 awards. Twenty-one thousand eight hundred sixty-nine records is fewer than many coastal Defense joins with six-figure award counts. Fewer records under a still-large dollar total lifts the mean to about $1.44 million.

The join does not name yards, bases, or contractors. Those proper names are not in the packet. Ranking Maine against New Hampshire or Massachusetts would require other facts.

Repeat the pair until it sticks: $31,591,199,764.95 on 21,869 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 without Maine

The Department of Defense hub drops the ME filter and will not equal $31,591,199,764.95. The Maine hub drops 097. Overlay /states/me/agencies/097/ is the both-keys table for 21,869 awards.

Quoting $31,591,199,764.95 from the agency hub would be a different filter. Quoting 21,869 from the state hub would mix other awarding agencies. The overlay is the only table that keeps both keys. That is why this tie cites those two facts together.

Questions

How much has DoD obligated in Maine?

USAspending records $31,591,199,764.95 in obligations for agency 097 with Maine place of performance, on 21,869 awards. That is an obligation join, not an outlay total. The pair is awarding agency 097 (Department of Defense) and place-of-performance Maine. It is not Department of Defense nationwide and not Maine from every awarding agency.

What is the average award?

About $1.44 million ($31,591,199,764.95 ÷ 21,869). Spreading the dollars across 21,869 records rather than a much larger file raises the mean. The mean is not a typical contract. That ratio uses only $31,591,199,764.95 and 21,869 from the packet. A mean hides mix: a few large instruments can sit beside many smaller ones.

Does this include New Hampshire?

No. Place of performance is Maine only. Other states are outside $31,591,199,764.95 and outside the 21,869 awards. Only place-of-performance Maine plus awarding agency 097 (Department of Defense) enter $31,591,199,764.95. Adjacent state codes are other filters, if they exist as ties at all.

Does the total name shipyards?

No. The facts are agency 097 and state ME. Facility names are not in the aggregate. The $31,591,199,764.95 total follows those two fields. The facts are agency 097 and place-of-performance Maine totaling $31,591,199,764.95 on 21,869 awards. Program names, sites, and mission splits are not in this aggregate and are not assigned shares of $31,591,199,764.95.