Agricultural Yield Data By Region
This dataset provides detailed agricultural yield records by region, crop type, and growing season, including quantitative harvest data, land area, and contextual information such as irrigation and organic certification. It is designed for ESG reporting, risk assessment, and supply chain optimization, enabling granular analysis of crop production trends and sustainability metrics.
Sample rows
preview · 8 of 200 rows · all 16 columns| yield_idstring | yield_unitstring | area_harvestedfloat | irrigationboolean | growing_seasonstring | region_idstring | region_namestring | countrystring | crop_typestring | planting_datedate | harvest_datedate | yield_quantityfloat | organic_certifiedboolean | reporting_datedate | weather_summarystring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| YLD001-US_IA-WHEAT | bushels | 120.6 | false | Spring 2022 | US_IA | Iowa | USA | wheat | 2022-03-15 | 2022-07-12 | 185.4 | false | 2022-07-18 | Mild spring, average rainfall, no major events | Standard yield, no issues reported. |
| YLD002-IN_WB-JUTE | tons | 35.2 | true | Kharif 2021 | IN_WB | West Bengal | India | jute | 2021-06-01 | 2021-10-15 | 67.5 | true | 2021-10-19 | High humidity, adequate rainfall, mild pest pressure | Certified organic. Lower yield due to certification standards. |
| YLD003-CA_SK-WHEAT | metric tons | 150.4 | false | Q2 2023 | CA_SK | Saskatchewan | Canada | wheat | 2023-04-20 | 2023-08-25 | 210.2 | false | 2023-08-29 | Cool spring, some hail events, adequate moisture | blank |
| YLD004-CN_HB-RICE | kilograms | 220.3 | true | Autumn 2022 | CN_HB | Hebei | China | rice | 2022-05-12 | 2022-09-30 | 310000 | false | 2022-10-06 | Hot summer, heavy irrigation required | High yield supported by irrigation. |
| YLD005-DE_BY-HOPS | kilograms | 19.5 | false | Q3 2021 | DE_BY | Bavaria | Germany | hops | 2021-04-16 | 2021-09-05 | 12500 | false | 2021-09-08 | Warm summer, mild pest pressure, no storms | Premium export grade, standard yield. |
| YLD006-BR_SP-COFFEE | kilograms | 27.8 | true | Q2 2022 | BR_SP | Sao Paulo | Brazil | coffee | 2022-03-01 | 2022-07-01 | 25000 | false | 2022-07-04 | Dry spell, irrigation necessary during flowering | Yield supported by efficient irrigation. |
| YLD007-FR_IDF-WHEAT | metric tons | 17.3 | false | Spring 2023 | FR_IDF | Île-de-France | France | wheat | 2023-03-10 | 2023-07-05 | 36 | true | 2023-07-08 | Cool, wet spring, mild mildew outbreak | Certified organic, mildew affected yield. |
| YLD008-PL_MZ-BUCKWHEAT | tons | 4.5 | false | Q3 2022 | PL_MZ | Mazovia | Poland | buckwheat | 2022-05-22 | 2022-08-20 | 9.7 | false | 2022-08-22 | Sunny summer, low rainfall, no storms | blank |
| YLD009-US_CA-ALMOND | tons | 28.1 | true | Spring 2021 | US_CA | California | USA | almond | 2021-02-25 | 2021-07-20 | 47.2 | true | 2021-07-22 | Drought conditions, heavy irrigation applied | Certified organic. Lower yield due to drought. |
| YLD010-IN_PB-RICE | kilograms | 14.2 | true | Rabi 2023 | IN_PB | Punjab | India | rice | 2023-11-01 | 2024-03-10 | 9100 | false | 2024-03-15 | Normal winter, adequate irrigation | Good yield, no major pest pressure. |
| YLD011-CA_ON-CORN | metric tons | 99.2 | false | Q3 2022 | CA_ON | Ontario | Canada | corn | 2022-04-18 | 2022-09-03 | 152.8 | false | 2022-09-07 | Wet spring, warm summer, no major events | blank |
| YLD012-CN_SC-RICE | kilograms | 210 | true | Q2 2021 | CN_SC | Sichuan | China | rice | 2021-04-05 | 2021-08-10 | 275000 | false | 2021-08-16 | Monsoon rains, brief flooding, rapid recovery | Yield unaffected by brief flooding. |
| YLD013-KE_NRB-MAIZE | metric tons | 0.8 | true | Q2 2022 | KE_NRB | Nairobi | Kenya | maize | 2022-03-10 | 2022-06-20 | 1.9 | false | 2022-06-22 | Experimental greenhouse, controlled conditions | Experimental plot, high yield per area. |
| YLD014-US_AK-BARLEY | metric tons | 0 | false | Q3 2023 | US_AK | Alaska | USA | barley | 2023-05-10 | 2023-09-01 | 0 | false | 2023-09-02 | Late frost, crop failure reported | Crop failure due to frost. |
| YLD015-IN_TN-COTTON | tons | 3.2 | true | Q4 2021 | IN_TN | Tamil Nadu | India | cotton | 2021-07-05 | 2021-12-16 | 9.8 | false | 2021-12-20 | High rainfall, mild pest outbreak | Yield reduced by pest outbreak. |
| YLD016-CA_MB-WHEAT | metric tons | 140.6 | false | Spring 2024 | CA_MB | Manitoba | Canada | wheat | 2024-04-14 | 2024-08-18 | 215.7 | false | 2024-08-23 | Warm spring, no major events | blank |
| YLD017-US_NE-CORN | bushels | 99.7 | false | Q2 2023 | US_NE | Nebraska | USA | corn | 2023-04-10 | 2023-09-15 | 202.6 | false | 2023-09-20 | Dry summer, limited rainfall, no storms | Dry conditions slightly reduced yield. |
| YLD018-CN_JS-RICE | kilograms | 175.2 | true | Q3 2022 | CN_JS | Jiangsu | China | rice | 2022-06-05 | 2022-10-01 | 299500 | false | 2022-10-07 | Hot, humid summer, heavy irrigation needed | blank |
| YLD019-FR_NA-ALMOND | tons | 13.1 | false | Spring 2022 | FR_NA | Nouvelle-Aquitaine | France | almond | 2022-03-18 | 2022-07-20 | 28.4 | true | 2022-07-25 | Wet spring, fungal disease mild | Certified organic, fungal disease affected yield. |
| YLD020-BR_MG-COFFEE | kilograms | 25.7 | true | Q2 2023 | BR_MG | Minas Gerais | Brazil | coffee | 2023-03-20 | 2023-07-06 | 23000 | false | 2023-07-10 | Dry, irrigation essential, pest pressure minimal | blank |
What the 200 rows show
from the 200-row sampleBushels (yield unit) stands out: mean area_
- 49%irrigation = true
- 28.0median area_
harvested - 10countries
- 13crop types
- 312.4median yield_
quantity
Median 28.0, from 0.0 to 230.0.
- string 9
- float 2
- date 3
- boolean 2
Columns
16 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 9 columns | |||
yield_id | string | Unique identifier for each crop yield recordunique | YLD001-US_IA-WHEAT |
region_id | string | Unique identifier for the region where the crop was grown | US_IA |
region_name | string | Name of the region (e.g., state, province, district) | Iowa |
country | string | Country where the region is located10 countries | USA |
crop_type | string | Type of crop (e.g., wheat, corn, rice) | wheat |
growing_season | string | Name or code for the growing season (e.g., Spring 2023, 2022-Q4) | Spring 2022 |
yield_unit | string | Unit of measurement for yield (e.g., metric tons, bushels, kilograms)metric tons · bushels · kilograms · tons | bushels |
weather_summary | string | Summary of weather conditions during the growing seasonoptional | Warm summer, dry spells |
notes | string | Additional notes or comments about the yield recordoptional | Standard yield, no issues… |
| Numbers 2 columns | |||
yield_quantity | float | Total amount of crop harvested (in metric tons)0 or more | 185.4 |
area_harvested | float | Area of land harvested for this crop (in hectares)0 or more | 120.6 |
| Dates and times 3 columns | |||
planting_date | date | Date when the crop was plantedoptional | 2022-03-15 |
harvest_date | date | Date when the crop was harvestedoptional | 2022-07-12 |
reporting_date | date | Date the yield data was reported or entered | 2022-07-18 |
| True or false 2 columns | |||
irrigation | boolean | Indicates if irrigation was used during the growing seasonoptional | false |
organic_certified | boolean | Indicates if the crop is certified organicoptional | false |
Use it for
An agriculture dashboard
The irrigation rate, area_
harvested by yield_ unit and a breakdown of growing_ season. Excel, Power BI or Tableau. Why do the 20 bushels rows have a mean area_
harvested of 141.7? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Yields200YLD001-US_IA-WHEAT120.6bushelsYLD002-IN_WB-JUTE35.2tonsYLD004-CN_HB-RICE220.3kilograms
A software demo
Believable yields with region_
id, region_ name and country to fill a screen in front of a buyer.
This dataset200 rows16 columns
Yours1,000 rows16 columnsregion_id: UK only
blueprint · agricultural-yield-data-by-region
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 16 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Region geocode and crop type required.
- Yield measured in metric tons/hectare.
- Includes climate anomaly flags.
- Data reported for three years minimum.
- Non-zero yield only for active farms.
Open the blueprint in Data Factory
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- agricultural-yield-data-by-region