Department of Agriculture in Arkansas

A thick USDA file on Arkansas

Department of Agriculture as awarding agency, Arkansas as place-of-performance: 92,970 records summing to $6,292,094,150.46. A Department of Agriculture award coded outside AR is out. An award in Arkansas from a different awarding agency is out even if the topic sounds related. Arkansas (AR) excludes Missouri, Tennessee, Mississippi, Louisiana, Texas, and Oklahoma. Place of performance is AR, not a crop region.

Ninety-two thousand nine hundred seventy 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 92,970 as 92,970 unique rice acres, poultry houses, or unique producers. The overlay Department of Agriculture in Arkansas is the both-keys table. Arkansas federal spending is the all-agency state hub. Department of Agriculture is the agency book without an AR filter. All spending ties lists other joins.

The implied mean is much lower than thin Energy cells. Dollars and row counts tell different stories on the same join. Correlation is not causation: Arkansas did not “cause” $6,292,094,150.46 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 012 × AR only.

Rice, poultry, and missing commodity fields

$6,292,094,150.46 does not measure rice acres, poultry houses, or unique producers. Those series are not USAspending fields on this aggregate. The cell sums award obligations with awarding-agency code 012 and an AR place-of-performance tag.

Do not treat 92,970 awards as a census of rice acres, poultry houses, or unique producers. Parent hubs are supposed to be larger than this pair. If Arkansas federal spending or Department of Agriculture matched $6,292,094,150.46 and 92,970, the join would be pointless. Use the overlay when both keys must stay on. Missouri, Mississippi, and Texas USDA joins are other pairs, not addends.

Questions

How much has the Department of Agriculture obligated in Arkansas?

USAspending.gov records $6,292,094,150.46 across 92,970 awards with awarding agency 012 and an Arkansas tag. That is an obligation join, not an outlay and not a count of rice acres, poultry houses, or unique producers. Department of Agriculture in Arkansas is the live overlay for this pair. Keep both keys when quoting $6,292,094,150.46.

Is $6,292,094,150.46 a measure of rice acres, poultry houses, or unique producers?

No. The packet publishes $6,292,094,150.46 and 92,970 awards for agency 012 inside AR 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 92,970 awards?

That is the award-record count for 012 × AR. Combined with $6,292,094,150.46, the average is about $67,679. Modifications and repeat instruments add rows. 92,970 is not unique rice acres, poultry houses, 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 Arkansas is the overlay. Arkansas 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 $6,292,094,150.46. USAspending.gov is the source. Obligations are not outlays.