Department of Agriculture in Vermont

A thick USDA file on Vermont

Department of Agriculture as awarding agency, Vermont as place-of-performance: 6,825 records summing to $1,377,908,530.18. A Department of Agriculture award coded outside VT is out. An award in Vermont from a different awarding agency is out even if the topic sounds related. Vermont (VT) excludes New Hampshire, New York, and Massachusetts. A New York-coded award is NY even if the farm sits on the lake.

Six thousand eight hundred twenty-five awards is a thick assistance-style USDA file. Volume can rise on recurring nutrition and farm rows without each row being a new producer. Unique recipients are unpublished. Do not read 6,825 as 6,825 unique farms, planted acres, or unique producers. The overlay Department of Agriculture in Vermont is the both-keys table. Vermont federal spending is the all-agency state hub. Department of Agriculture is the agency book without a VT filter. All spending ties lists other joins.

Nutrition, conservation, forest, and farm instruments can share 012. This packet does not say which dominate $1,377,908,530.18. Correlation is not causation: Vermont did not cause $1,377,908,530.18 by existing as a large or small place. Population and outcome scores are not packet facts. The join is 012 × VT only.

Dairy and maple are not packet fields

$1,377,908,530.18 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 a VT place-of-performance tag.

Do not treat 6,825 awards as a census of farms, planted acres, or unique producers. Parent hubs are supposed to be larger than this pair. If Vermont federal spending or Department of Agriculture matched $1,377,908,530.18 and 6,825, the join would be pointless. Use the overlay when both keys must stay on. New Hampshire, New York, and Massachusetts USDA joins are other pairs, not addends.

Questions

How much has the Department of Agriculture obligated in Vermont?

USAspending.gov records $1,377,908,530.18 across 6,825 awards with awarding agency 012 and a Vermont tag. That is an obligation join, not an outlay and not a count of farms, planted acres, or unique producers. Department of Agriculture in Vermont is the live overlay for this pair. Keep both keys when quoting $1,377,908,530.18.

Is $1,377,908,530.18 a measure of farms, planted acres, or unique producers?

No. The packet publishes $1,377,908,530.18 and 6,825 awards for agency 012 inside VT 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 6,825 awards?

That is the award-record count for 012 × VT. Combined with $1,377,908,530.18, the average is about $201,891. Modifications and repeat instruments add rows. 6,825 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 Vermont is the overlay. Vermont 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 $1,377,908,530.18. USAspending.gov is the source. Obligations are not outlays.