Department of Defense in North Dakota

A thicker DoD file on a North Dakota tag

Department of Defense as awarding agency, North Dakota as place-of-performance: 4,630 records summing to $2,065,792,435.76. A Department of Defense award coded outside ND is out. An award in North Dakota from a different awarding agency is out even if the topic sounds related. North Dakota (ND) excludes South Dakota, Minnesota, Montana, and the Canadian border as a USAspending state key. A Minot story still shares the ND stamp with Grand Forks. Army, Navy, Air Force, and other DoD components are unpublished splits inside awarding agency 097.

Four thousand six hundred thirty awards sits in a thicker DoD band than the South Dakota Defense cell in this slice. Modifications can add rows without each row being a new contract. Unique recipients are unpublished. Do not read 4,630 as 4,630 unique active-duty headcount, named installations, or unique contractors. The overlay Department of Defense in North Dakota is the both-keys table. North Dakota federal spending is the all-agency state hub. Department of Defense is the agency book without an ND filter. All spending ties lists other joins.

Minot and Grand Forks are ordinary speech, not published shares of $2,065,792,435.76. Unique recipients are unpublished. Correlation is not causation: North Dakota did not “cause” $2,065,792,435.76 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 097 × ND only.

Not Minot folklore or a troop roster

$2,065,792,435.76 does not measure active-duty headcount, named installations, or unique contractors. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 097 and an ND place-of-performance tag. Army, Navy, Air Force, and other DoD components are unpublished splits inside awarding agency 097.

Do not treat 4,630 awards as a census of active-duty headcount, named installations, or unique contractors. Parent hubs are supposed to be larger than this pair. If North Dakota federal spending or Department of Defense matched $2,065,792,435.76 and 4,630, the join would be pointless. Use the overlay when both keys must stay on. South Dakota, Minnesota, and Montana DoD joins are other pairs, not addends.

Questions

How much has the Department of Defense obligated in North Dakota?

USAspending.gov records $2,065,792,435.76 across 4,630 awards with awarding agency 097 and a North Dakota tag. That is an obligation join, not an outlay and not a count of active-duty headcount, named installations, or unique contractors. Department of Defense in North Dakota is the live overlay for this pair. Keep both keys when quoting $2,065,792,435.76.

Is $2,065,792,435.76 a measure of active-duty headcount, named installations, or unique contractors?

No. The packet publishes $2,065,792,435.76 and 4,630 awards for agency 097 inside ND 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 DoD file have 4,630 awards?

That is the award-record count for 097 × ND. Combined with $2,065,792,435.76, the average is about $446,175. Modifications and repeat instruments add rows. 4,630 is not unique active-duty headcount, named installations, or unique contractors. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live DoD–North Dakota table?

Department of Defense in North Dakota is the overlay. North Dakota federal spending and Department of Defense are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $2,065,792,435.76. USAspending.gov is the source. Obligations are not outlays.