Department of Agriculture in Kansas

An extreme-count USDA file on Kansas

Department of Agriculture as awarding agency, Kansas as place-of-performance: 451,839 records summing to $5,571,935,594.18. A Department of Agriculture award coded outside KS is out. An award in Kansas from a different awarding agency is out even if the topic sounds related. Kansas (KS) excludes Missouri, Nebraska, Oklahoma, Colorado, and Arkansas. A Kansas City, Missouri-coded award is MO.

Four hundred fifty-one thousand eight hundred thirty-nine awards is an extreme-count USDA file. A low implied mean is the arithmetic of a huge denominator, not a typical payment. Unique recipients are unpublished. Do not read 451,839 as 451,839 unique farms, wheat acres, or unique producers. The overlay Department of Agriculture in Kansas is the both-keys table. Kansas federal spending is the all-agency state hub. Department of Agriculture is the agency book without a KS filter. All spending ties lists other joins.

Nutrition and farm-program rows can share 012. This packet does not say which mint the 451,839 actions. Correlation is not causation: Kansas did not “cause” $5,571,935,594.18 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 012 × KS only.

451,839 rows are not 451,839 farms

$5,571,935,594.18 does not measure farms, wheat acres, or unique producers. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 012 and a KS place-of-performance tag.

Do not treat 451,839 awards as a census of farms, wheat acres, or unique producers. Parent hubs are supposed to be larger than this pair. If Kansas federal spending or Department of Agriculture matched $5,571,935,594.18 and 451,839, the join would be pointless. Use the overlay when both keys must stay on. Missouri, Nebraska, and Oklahoma USDA joins are other pairs, not addends.

Questions

How much has the Department of Agriculture obligated in Kansas?

USAspending.gov records $5,571,935,594.18 across 451,839 awards with awarding agency 012 and a Kansas tag. That is an obligation join, not an outlay and not a count of farms, wheat acres, or unique producers. Department of Agriculture in Kansas is the live overlay for this pair. Keep both keys when quoting $5,571,935,594.18.

Is $5,571,935,594.18 a measure of farms, wheat acres, or unique producers?

No. The packet publishes $5,571,935,594.18 and 451,839 awards for agency 012 inside KS 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 451,839 awards?

That is the award-record count for 012 × KS. Combined with $5,571,935,594.18, the average is about $12,332. Modifications and repeat instruments add rows. 451,839 is not unique farms, wheat 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 Kansas is the overlay. Kansas 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 $5,571,935,594.18. USAspending.gov is the source. Obligations are not outlays.