usda_ag_query
Query USDA agricultural data to analyze crop yields, livestock inventories, production statistics, and commodity prices using customizable filters for commodities, states, years, and survey types.
Instructions
Custom query to USDA NASS QuickStats — any combination of filters. Max 50,000 records. Use usda_ag_count first for large queries.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| commodity_desc | No | Commodity: CORN, WHEAT, CATTLE, etc. | |
| source_desc | No | SURVEY or CENSUS | |
| sector_desc | No | CROPS, ANIMALS & PRODUCTS, ECONOMICS, ENVIRONMENTAL | |
| statisticcat_desc | No | AREA PLANTED, PRODUCTION, YIELD, PRICE RECEIVED, INVENTORY | |
| state_alpha | No | State code: IA, IL, CA or US for national | |
| year | No | Year | |
| agg_level_desc | No | NATIONAL, STATE, COUNTY | |
| freq_desc | No | ANNUAL, MONTHLY, WEEKLY |