US soil moisture & fieldwork intelligence (weekly)
Weekly US soil-moisture intelligence from the keyless USDA NASS Crop Progress releases (ESMIS, fixed-width text tables): one row per (week-ending Sunday, state, soil layer) with the four published acreage-moisture percentages (very short / short / adequate / surplus) for topsoil and subsoil, the drought-stress headline deficit_pct (very short + short), a documented 1-4 acreage-weighted moisture_index, fixed-band drought tiers (critical/severe/watch/normal), the week-over-week change in deficit, and the current-week days suitable for fieldwork denormalized from the same release (plus its week-over-week change). 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, and require the fieldwork table's last date column to equal the moisture tables' week-ending Sunday. Caveats: '-' is a published zero; '(NA)' is kept as an honest null (rows with any (NA) skip the sum gate and the index); moisture tables cover 48 states; ratings are enumerator assessments, not probe measurements. Sources: USDA NASS Crop Progress (public domain, 17 U.S.C. 105) via ESMIS.
- Rows
- 2,688
- 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. (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) |
| layer | string | Soil layer: 'topsoil' (surface moisture, planting and germination signal) or 'subsoil' (root-zone moisture, crop-health signal). |
| very_short_pct | float | Share of the state's rated acreage with 'very short' moisture. '-' in the source is a published zero; '(NA)' is an honest null. (unit: percent) |
| short_pct | float | Share rated 'short'. (unit: percent) |
| adequate_pct | float | Share rated 'adequate'. (unit: percent) |
| surplus_pct | float | Share rated 'surplus'. (unit: percent) |
| ratings_complete_flag | integer | 1 when all four moisture ratings are present (the sum-to-100 identity is then enforced); 0 when any is (NA). (unit: binary) |
| deficit_pct | float | Very short + short share — the drought-stress headline. Null when a component is (NA). (unit: percent) |
| moisture_index | float | Acreage-weighted 1-4 score: (1*VS + 2*S + 3*A + 4*Su)/100 (3.0 = fully adequate). Null unless all four ratings are present. (unit: 1-4 index) |
| drought_tier | string | Fixed bands on deficit_pct: critical (>=60), severe (>=40), watch (>=20), normal (<20). |
| wow_deficit_pp | float | Week-over-week change in deficit_pct (percentage points) vs the week-ending exactly 7 days earlier for the same state and layer; null at the panel start or when a week is missing. (unit: percentage points) |
| days_suitable_fieldwork | float | Current-week days suitable for fieldwork from the same release (cropland-acreage-weighted), denormalized onto both layer rows. (unit: days) |
| wow_days_suitable_pp | float | Week-over-week change in days_suitable_fieldwork (days) vs the week-ending exactly 7 days earlier; null at the panel start or when a week is missing. (unit: days) |
| states_reporting | integer | Number of states parsed for this (week, layer) — the moisture tables' coverage 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|layer (idempotency). |
First 10 sample rows — a preview, not the complete dataset.
| week_ending | state_code | state_name | iso_3166_2 | country_code | layer | very_short_pct | short_pct | adequate_pct | surplus_pct | ratings_complete_flag | deficit_pct | moisture_index | drought_tier | wow_deficit_pp | days_suitable_fieldwork | wow_days_suitable_pp | states_reporting | source_url | as_of | row_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2025-11-16 | AL | Alabama | US-AL | USA | subsoil | 14 | 46 | 38 | 2 | 1 | 60 | 2.28 | critical | — | 6.6 | — | 48 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | da2e9f8ab525a0fb |
| 2025-11-16 | AR | Arkansas | US-AR | USA | subsoil | 8 | 28 | 63 | 1 | 1 | 36 | 2.57 | watch | — | 6.8 | — | 48 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | d7804a1fd62ae7bb |
| 2025-11-16 | AZ | Arizona | US-AZ | USA | subsoil | 14 | 12 | 64 | 10 | 1 | 26 | 2.7 | watch | — | 7 | — | 48 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 2e13795119fd65cf |
| 2025-11-16 | CA | California | US-CA | USA | subsoil | 0 | 15 | 80 | 5 | 1 | 15 | 2.9 | normal | — | 6.5 | — | 48 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 930ec4e520bdf05b |
| 2025-11-16 | CO | Colorado | US-CO | USA | subsoil | 19 | 26 | 51 | 4 | 1 | 45 | 2.4 | severe | — | 6.8 | — | 48 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | b4769dafd8eae081 |
| 2025-11-16 | CT | Connecticut | US-CT | USA | subsoil | 0 | 8 | 92 | 0 | 1 | 8 | 2.92 | normal | — | 5 | — | 48 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 6756e4093915f753 |
| 2025-11-16 | DE | Delaware | US-DE | USA | subsoil | 16 | 38 | 46 | 0 | 1 | 54 | 2.3 | severe | — | 6.5 | — | 48 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | aaeffc2f9851def1 |
| 2025-11-16 | FL | Florida | US-FL | USA | subsoil | 14 | 29 | 56 | 1 | 1 | 43 | 2.44 | severe | — | 6.7 | — | 48 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 0b1d46df5a625392 |
| 2025-11-16 | GA | Georgia | US-GA | USA | subsoil | 34 | 43 | 23 | 0 | 1 | 77 | 1.89 | critical | — | 6.4 | — | 48 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 285ac761d9a27631 |
| 2025-11-16 | IA | Iowa | US-IA | USA | subsoil | 6 | 27 | 63 | 4 | 1 | 33 | 2.65 | watch | — | 6.4 | — | 48 | https://esmis.nal.usda.gov/sites/default/release-files/795651/prog4625_1.txt | 2026-09-30 | 634caa8278652c78 |
Profiled Sep 30, 2026 from snapshot 20260930T124423Z-fbc38d5537cc
Measured- Completeness
- 99.3%
- Rows
- 2,688
- Columns
- 21
- Columns with gaps
- 2
| Column | Missing | Distinct | Range | Distribution |
|---|---|---|---|---|
| week_endingvarchar | 0% | 24 | — |
|
| state_codevarchar | 0% | 52 | — |
|
| state_namevarchar | 0% | 55 | — |
|
| iso_3166_2varchar | 0% | 53 | — |
|
| country_codevarchar | 0% | 1 | — |
|
| layervarchar | 0% | 2 | — |
|
| very_short_pctdouble | 0% | 86 | 0 → 81median 10 | 21 outside 1st–99th percentile |
| short_pctdouble | 0% | 93 | 0 → 100median 29 | 25 outside 1st–99th percentile |
| adequate_pctdouble | 0% | 134 | 0 → 100median 52.5 | 23 outside 1st–99th percentile |
| surplus_pctdouble | 0% | 65 | 0 → 100median 2 | 27 outside 1st–99th percentile |
| ratings_complete_flagbigint | 0% | 1 | 1 → 1median 1 | |
| deficit_pctdouble | 0% | 134 | 0 → 100median 43 | 26 outside 1st–99th percentile |
| moisture_indexdouble | 0% | 218 | 1.22 → 4median 2.49 | 50 outside 1st–99th percentile |
| drought_tiervarchar | 0% | 4 | — |
|
| wow_deficit_ppdouble | 7.1% | 93 | -80 → 90median 0 | 49 outside 1st–99th percentile |
| days_suitable_fieldworkdouble | 0% | 60 | 0.5 → 7median 6 | 26 outside 1st–99th percentile |
| wow_days_suitable_ppdouble | 7.1% | 160 | -5 → 4median 0 | 48 outside 1st–99th percentile |
| states_reportingbigint | 0% | 1 | 48 → 48median 48 | |
| source_urlvarchar | 0% | 33 | — |
|
| as_ofvarchar | 0% | 1 | — |
|
| row_hashvarchar | 0% | 2,673 | — |
|
- Current
20260930T124423Z-fbc38d5537cc · sha256 fbc38d5537cc…
2,688 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_soil_moisture_intel/us_soil_moisture_weekly" | jq '{title, rows, columns_count, license}'import requests
ds = requests.get("https://datazimuts.com/v1/datasets/usda_soil_moisture_intel/us_soil_moisture_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_soil_moisture_intel/us_soil_moisture_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 20260930T124423Z-fbc38d5537cc and its content hash, so readers get exactly the data you used.
. (2026). US soil moisture & fieldwork intelligence (weekly) [Data set, snapshot 20260930T124423Z-fbc38d5537cc, sha256 fbc38d5537cc]. Datazimuts. Retrieved 2026-09-30, from https://datazimuts.com/en/datasets/usda_soil_moisture_intel/us_soil_moisture_weekly?snapshot=20260930T124423Z-fbc38d5537cc
@misc{dz_usda_soil_moisture_intel_us_soil_moistur_fbc38d55,
title = {{US soil moisture \& fieldwork intelligence (weekly)}},
author = {{}},
year = {2026},
publisher = {Datazimuts},
howpublished = {\url{https://datazimuts.com/en/datasets/usda_soil_moisture_intel/us_soil_moisture_weekly?snapshot=20260930T124423Z-fbc38d5537cc}},
note = {Snapshot 20260930T124423Z-fbc38d5537cc, sha256 fbc38d5537cc05cc441864e3eb6d88c7b510230ede777a4c3dae290f06596d10; 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_soil_moisture_intel%2Fus_soil_moisture_weekly&lang=en&theme=auto&snapshot=20260930T124423Z-fbc38d5537cc&x=week_ending&y=very_short_pct&agg=avg" title="US soil moisture & fieldwork 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.