US crop condition intelligence (weekly)
Weekly US crop condition intelligence from the keyless USDA NASS Crop Progress releases (ESMIS, fixed-width text tables): one row per (week-ending Sunday, state, crop) with the five published acreage-rating percentages (very poor/poor/fair/good/excellent), the headline good+excellent and poor+very-poor aggregates, a documented 1-5 acreage-weighted condition index, fixed-band condition tiers (excellent/good/fair/poor/critical), and the week-over-week change in good+excellent. Covers the full growing season (winter wheat and oats from April; corn, soybeans, cotton, sorghum, peanuts, rice, barley, spring wheat mid-season; pasture & range throughout). Method: parse each week's prog<WW><YY>.txt positional tables, resolve states to USPS/ISO codes, enforce the publisher's sum-to-100 identity and the file-name/week-ending consistency gate, recompute week-over-week moves from consecutive weekly files. Caveats: '-' is a published zero; '(NA)' is kept as an honest null (rows with any (NA) skip the sum gate and the index); state coverage varies by crop (the 'These N States' bracket is recorded per row); ratings are enumerator assessments, not measured yields. Sources: USDA NASS Crop Progress (public domain, 17 U.S.C. 105) via ESMIS.
- Rows
- 2,860
- Columns
- 21
- Source cadence
- Weekly
- Last refreshed
- Sep 30, 2026
- Theme
- agriculture
| Column | Type | Description |
|---|---|---|
| week_ending | string | Week-ending Sunday of the NASS Crop Progress release (each release covers the week ending the prior Sunday). (unit: ISO date) |
| state_code | string | USPS postal abbreviation; the join key for state-level panels. |
| state_name | string | Canonical state name. |
| iso_3166_2 | string | ISO 3166-2 subdivision code (US-AL ... US-WY). (unit: ISO 3166-2) |
| country_code | string | ISO alpha-3 country code (USA for every row). (unit: ISO 3166-1 alpha-3) |
| crop | string | Canonical crop name (Corn, Soybeans, Cotton, Sorghum, Peanuts, Rice, Winter Wheat, Spring Wheat, Barley, Oats, Pasture and Range). Publisher singulars canonicalized (Soybean->Soybeans, Peanut->Peanuts, Oat->Oats). |
| very_poor_pct | float | Share of the state's rated acreage in 'very poor' condition. '-' in the source is a published zero; '(NA)' is an honest null. (unit: percent) |
| poor_pct | float | Share rated 'poor'. (unit: percent) |
| fair_pct | float | Share rated 'fair'. (unit: percent) |
| good_pct | float | Share rated 'good'. (unit: percent) |
| excellent_pct | float | Share rated 'excellent'. (unit: percent) |
| ratings_complete_flag | integer | 1 when all five ratings are present (the sum-to-100 identity is then enforced); 0 when any is (NA). (unit: binary) |
| good_excellent_pct | float | Good + excellent share — the headline number commodity analysts quote. Null when a component is (NA). (unit: percent) |
| poor_very_poor_pct | float | Very poor + poor share (the stress side of the ledger). (unit: percent) |
| condition_index | float | Acreage-weighted 1-5 score: (1*VP + 2*P + 3*F + 4*G + 5*E)/100. Null unless all five ratings are present. (unit: 1-5 index) |
| condition_tier | string | Fixed bands on good_excellent_pct: excellent (>=75), good (>=60), fair (>=40), poor (>=25), critical (<25). |
| wow_good_excellent_pp | float | Week-over-week change in good_excellent_pct (percentage points) vs the week-ending exactly 7 days earlier for the same state and crop; null at the panel start or when a week is missing. (unit: percentage points) |
| states_reporting | float | The publisher's own '[These N States ...]' coverage count for this crop and week (null for pasture, where NASS gives no count). (unit: count) |
| source_url | string | Exact ESMIS URL of the weekly prog<WW><YY>.txt file this row was parsed from (per-row provenance). (unit: URL) |
| as_of | string | Fetch date in UTC (snapshot vintage). (unit: ISO date) |
| row_hash | string | Deterministic 16-hex row hash of week_ending|state_code|crop (idempotency). |
First 10 sample rows — a preview, not the complete dataset.
| week_ending | state_code | state_name | iso_3166_2 | country_code | crop | very_poor_pct | poor_pct | fair_pct | good_pct | excellent_pct | ratings_complete_flag | good_excellent_pct | poor_very_poor_pct | condition_index | condition_tier | wow_good_excellent_pp | states_reporting | source_url | as_of | row_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2025-11-16 | AR | Arkansas | US-AR | USA | Winter Wheat | 1 | 3 | 42 | 49 | 5 | 1 | 54 | 4 | 3.54 | fair | — | 18 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 25a7bded8bc498c0 |
| 2025-11-16 | CA | California | US-CA | USA | Winter Wheat | 0 | 0 | 5 | 35 | 60 | 1 | 95 | 0 | 4.55 | excellent | — | 18 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 9d4d2d424271b537 |
| 2025-11-16 | CO | Colorado | US-CO | USA | Winter Wheat | 6 | 9 | 17 | 50 | 18 | 1 | 68 | 15 | 3.65 | good | — | 18 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 872ca7589a078503 |
| 2025-11-16 | ID | Idaho | US-ID | USA | Winter Wheat | 0 | 0 | 45 | 50 | 5 | 1 | 55 | 0 | 3.6 | fair | — | 18 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 76839d02e941f80b |
| 2025-11-16 | IL | Illinois | US-IL | USA | Winter Wheat | 9 | 9 | 29 | 43 | 10 | 1 | 53 | 18 | 3.36 | fair | — | 18 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | dfb49ea9beaa87a7 |
| 2025-11-16 | IN | Indiana | US-IN | USA | Winter Wheat | 2 | 4 | 25 | 58 | 11 | 1 | 69 | 6 | 3.72 | good | — | 18 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 1aaa70e7f37c7fbf |
| 2025-11-16 | KS | Kansas | US-KS | USA | Winter Wheat | 4 | 6 | 34 | 48 | 8 | 1 | 56 | 10 | 3.5 | fair | — | 18 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 3828277c2dcfaf82 |
| 2025-11-16 | MI | Michigan | US-MI | USA | Winter Wheat | 0 | 5 | 37 | 48 | 10 | 1 | 58 | 5 | 3.63 | fair | — | 18 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | e51f6c39d616a0ae |
| 2025-11-16 | MO | Missouri | US-MO | USA | Winter Wheat | 0 | 2 | 34 | 62 | 2 | 1 | 64 | 2 | 3.64 | good | — | 18 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 900be545a4d7223c |
| 2025-11-16 | MT | Montana | US-MT | USA | Winter Wheat | 1 | 28 | 65 | 5 | 1 | 1 | 6 | 29 | 2.77 | critical | — | 18 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 67789e61dfc1bb17 |
- Current
20260930T120940Z-8c20c6281b90 · sha256 8c20c6281b90…
2,860 rows · first snapshot
Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).
curl "https://datazimuts.com/v1/datasets/usda_crop_condition_intel/us_crop_condition_weekly" | jq '{title, rows, columns_count, license}'import requests
ds = requests.get("https://datazimuts.com/v1/datasets/usda_crop_condition_intel/us_crop_condition_weekly").json()
print(ds["title"], ds["rows"], "rows")
# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
print(row)API endpoint: https://datazimuts.com/v1/datasets/usda_crop_condition_intel/us_crop_condition_weekly
Tip: fetch /llms.txt for the full machine-readable catalog.
Where this data comes from and what was made from it. Other people's work shows as counts; only shared projects are named.
Cite this snapshot
Pinned to snapshot 20260930T120940Z-8c20c6281b90 and its content hash, so readers get exactly the data you used.
. (2026). US crop condition intelligence (weekly) [Data set, snapshot 20260930T120940Z-8c20c6281b90, sha256 8c20c6281b90]. Datazimuts. Retrieved 2026-09-30, from https://datazimuts.com/en/datasets/usda_crop_condition_intel/us_crop_condition_weekly?snapshot=20260930T120940Z-8c20c6281b90
@misc{dz_usda_crop_condition_intel_us_crop_condit_8c20c628,
title = {{US crop condition intelligence (weekly)}},
author = {{}},
year = {2026},
publisher = {Datazimuts},
howpublished = {\url{https://datazimuts.com/en/datasets/usda_crop_condition_intel/us_crop_condition_weekly?snapshot=20260930T120940Z-8c20c6281b90}},
note = {Snapshot 20260930T120940Z-8c20c6281b90, sha256 8c20c6281b90e080d1008f63cd564b6b2bb654285fcc841709ceebe5e52c1789; accessed 2026-09-30}
}Embed a table or a chart
Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.
<iframe src="https://datazimuts.com/embed/chart?dataset=usda_crop_condition_intel%2Fus_crop_condition_weekly&lang=en&theme=auto&snapshot=20260930T120940Z-8c20c6281b90&x=week_ending&y=very_poor_pct&agg=avg" title="US crop condition intelligence (weekly)" width="100%" height="380" style="border:0" loading="lazy"></iframe>
Ask about this dataset. Answers come only from its catalog record, measured profile and change history, and list the facts they used.