Department of Defense federal obligations 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.

Pennsylvania as place of performance

Pennsylvania is USAspending state code PA. Performance in Philadelphia County, a recipient in Allegheny County, and a record that only stamps PA can all sit inside $108,775,220,703.47. Awards tagged NJ, OH, MD, or NY stay on those ties. The join does not isolate the Delaware River.

Statewide Pennsylvania federal spending is the parent. Agency 097 is one awarding agency there. $108.8 billion is not Pennsylvania’s complete federal footprint.

An $85,800 mean is the arithmetic result of more than a million rows under $108.8 billion. Alabama’s Defense cell has similar dollars on 124,343 awards and a much higher mean. Row count moves the average.

Why the mean is about $85,800

Average obligation is about $85,800 ($108,775,220,703.47 ÷ 1,268,333). Alabama’s Defense mean is about $945,000 on 124,343 awards. Pennsylvania’s much thicker file pulls the mean down. Neither mean is a typical prime contract.

Net obligations can include downward adjustments. This page reports $108,775,220,703.47 as given. Treat 1,268,333 as award records in the aggregate, not as 1,268,333 companies.

One million two hundred sixty-eight thousand three hundred thirty-three records are not 1,268,333 contractors. Multiple actions can belong to one recipient. The packet has no unique-recipient count.

What the Pennsylvania–DoD pair is not

A shared state tag does not mean Pennsylvania selected these awards, and it does not mean Defense outlays equal $108,775,220,703.47 inside the state. FEC donations do not fund this cell. Correlation is not causation.

Continue from Department of Defense in Pennsylvania for the overlay table, Pennsylvania federal spending for all agencies, Department of Defense for agency 097 nationally, and All spending ties for other pairs.

A million rows is a systems fact

Pennsylvania Defense at $108,775,220,703.47 on 1,268,333 awards is the row-count outlier in this harvest. DoD procurement systems often emit one record per action. Reading 1.27 million as unique contractors is the error this page exists to block.

The $85,800 mean follows from that thickness. Alabama’s similar dollars on 124,343 awards produce a higher mean. Neither mean is a typical prime. Shipyard names are not in the facts. The tag is PA.

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.