Department of Defense in Pennsylvania

A million-row Defense × Pennsylvania cell

Awarding agency 097 and place-of-performance PA define this join. The $108,775,220,703.47 obligation total is the sum on 1,268,333 records that hold both keys. Pennsylvania’s all-agency hub and Defense’s all-state hub are the parents.

One million two hundred sixty-eight thousand three hundred thirty-three awards is roughly ten times Alabama’s Defense row count at a similar dollar scale. DoD files often store modifications, delivery orders, and small actions as separate records. The join does not collapse them into primes.

Pennsylvania’s Defense cell is $108,775,220,703.47 on 1,268,333 awards. The million-row file is the distinctive fact in this harvest. DoD systems often store modifications and delivery orders as separate records. Collapsing them into unique primes is not something this aggregate does. Pennsylvania Defense is $108,775,220,703.47 on 1,268,333 awards. The million-row file is a procurement-systems fact: one record per action, including modifications. Reading 1.27 million as unique contractors is the error. The $85,800 mean follows from that thickness; Alabama’s similar dollars on 124,343 awards produce a higher mean. Shipyard and depot names are not in the facts. Philadelphia and Pittsburgh are not subtotals. New Jersey-, Ohio-, Maryland-, and New York-tagged awards stay on those ties. Obligations are not outlays.

Agency 097 without naming yards or depots

Code 097 is Department of Defense. Army, Navy, Air Force, and other components can all land in 097. The packet does not split them and does not name installations. Calling $108,775,220,703.47 “Navy Yard spending” would invent a geography the facts do not provide.

The national 097 hub drops the Pennsylvania filter. Facts here: obligation sum, 1,268,333 awards, state PA, code 097. No fiscal-year series is supplied.

Philadelphia, Pittsburgh, and the rest of the state share one PA tag. The join does not isolate the Navy Yard or any other site. Awards tagged NJ, OH, MD, or NY stay on those ties. Restating the pair does not collapse 1,268,333 records into unique contractors. Awarding agency 097 and place-of-performance PA produced $108,775,220,703.47. The $85,800 mean is the arithmetic of a million-row action file. Shipyard names are not in the facts. Philadelphia is not a subtotal. Obligations remain commitments, not outlays.

Questions

How much Defense funding is obligated in Pennsylvania?

USAspending records $108,775,220,703.47 in obligations for awarding agency 097 with Pennsylvania place of performance, covering 1,268,333 awards. That is an obligation aggregate for this pair, not outlays.

Why are there more than 1.2 million Defense awards in Pennsylvania?

DoD aggregates often store contract actions and modifications as separate records. This cell contains 1,268,333 award records summing to $108,775,220,703.47. The packet does not list those instruments.

What is the average Defense award in Pennsylvania?

Dividing $108,775,220,703.47 by 1,268,333 awards produces about $85,800 per award. That mean is pulled down by a very thick file; it is not a typical prime contract.

Does 1,268,333 awards mean 1,268,333 contractors?

No. The aggregate counts award records. Multiple actions can belong to the same recipient. The packet does not provide a unique-recipient count.