Department of Agriculture in North Dakota

A thick USDA file on North Dakota

Department of Agriculture as awarding agency, North Dakota as place-of-performance: 111,777 records summing to $4,127,796,995.34. A Department of Agriculture 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 Minnesota, South Dakota, and Montana. A Moorhead-coded award is Minnesota even if the farm sits on the Red River.

One hundred eleven thousand seven hundred seventy-seven awards is a high-count USDA file. Volume can rise on recurring assistance without each row being a new farm. Unique recipients are unpublished. Do not read 111,777 as 111,777 unique farms, planted acres, or unique producers. The overlay Department of Agriculture in North Dakota is the both-keys table. North Dakota federal spending is the all-agency state hub. Department of Agriculture is the agency book without an ND filter. All spending ties lists other joins.

The implied mean is pulled down by volume. It is a concentration statistic, not a typical North Dakota USDA payment. Correlation is not causation: North Dakota did not “cause” $4,127,796,995.34 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 012 × ND only.

Wheat, oilseed, and missing commodity fields

$4,127,796,995.34 does not measure farms, planted acres, or unique producers. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 012 and an ND place-of-performance tag.

Do not treat 111,777 awards as a census of farms, planted acres, or unique producers. Parent hubs are supposed to be larger than this pair. If North Dakota federal spending or Department of Agriculture matched $4,127,796,995.34 and 111,777, the join would be pointless. Use the overlay when both keys must stay on. Minnesota, South Dakota, and Montana USDA joins are other pairs, not addends.

Questions

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

USAspending.gov records $4,127,796,995.34 across 111,777 awards with awarding agency 012 and a North Dakota tag. That is an obligation join, not an outlay and not a count of farms, planted acres, or unique producers. Department of Agriculture in North Dakota is the live overlay for this pair. Keep both keys when quoting $4,127,796,995.34.

Is $4,127,796,995.34 a measure of farms, planted acres, or unique producers?

No. The packet publishes $4,127,796,995.34 and 111,777 awards for agency 012 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 USDA file have 111,777 awards?

That is the award-record count for 012 × ND. Combined with $4,127,796,995.34, the average is about $36,929. Modifications and repeat instruments add rows. 111,777 is not unique farms, planted acres, or unique producers. Later ingests can revise the count. Prefer the overlay if the table moved.

Where is the live table?

Department of Agriculture in North Dakota is the overlay. North Dakota federal spending and Department of Agriculture are the parents, not addends. All spending ties lists other pairs. Keep both sides of the join when citing $4,127,796,995.34. USAspending.gov is the source. Obligations are not outlays.