Agtech Crop Yield Prediction

This dataset provides comprehensive field-level crop yield records, including agronomic, environmental, and management features such as soil properties, fertilizer and pesticide usage, irrigation type, and weather data. Designed for agtech product development and predictive modeling, it enables robust analysis of yield drivers, optimization strategies, and spatial variability across agricultural regions.

  • opened 13 times
  • last updated 20 Aug 2025
  • by GoMask
The brief that made it

Crop yield prediction and modeling

Sample rows

preview · 8 of 200 rows · all 21 columns
field_idstringsoil_typestringsoil_organic_matter_pctfloatcrop_typestringplanting_datedateharvest_datedateyield_kg_per_hectarefloatfield_area_hectaresfloatsoil_phfloatirrigation_typestringfertilizer_typestringfertilizer_amount_kg_per_hectarefloatpesticide_typestringpesticide_amount_liters_per_hectarefloatavg_temperature_cfloattotal_precipitation_mmfloatfield_latitudefloatfield_longitudefloatfield_elevation_metersfloatfield_ownerstringnotesstring
F001-2024Aloam3.2corn2024-03-252024-09-208700.515.36.4dripNPK150herbicide2.522.351041.5967-93.6053287AgriMax FarmsExcellent emergence, no flooding.
F002-2024Bsilt2.9wheat2023-10-052024-06-18690022.17.1sprinklerorganic95.5fungicide1.416.742037.2164-100.2556768Golden Valley GroupLate spring frost, moderate weed pressure.
F003-2024Cclay4.1soybeans2024-05-032024-10-123700.810.75.8rainfedNPK110none021.2610.640.8965-89.6247142Midwest Soy Inc.No pest outbreaks recorded.
F004-2024Dpeat8.8rice2024-04-172024-09-309600.29.26.9floodNPK180insecticide226.8730.229.896791.20551.2Louisiana Rice Co.Flooding in May, high yields expected.
F005-2024Echalk2.5barley2024-03-302024-07-1454005.47.7rainfedorganic82herbicide1.114.2350.851.0582-1.3123112Barley Bros Ltd.Dry spring, average yield.
F006-2024Fsandy1.8cotton2024-04-022024-10-051650.3205.4sprinklerNPK95insecticide2.329.121033.7456-84.3241305CottonFields LLCEarly pest pressure, controlled by June.
F007-2024Gloam3.5corn2024-04-102024-09-189500.717.16.7dripNPK162fungicide2.923.759042.7845-92.9334301AgriMax FarmsHigh yield, no disease pressure.
F008-2024Hsilt3.7soybeans2024-05-132024-10-243150.512.36.2rainfedorganic70herbicide1.519.6620.539.7889-94.7942204Midwest Soy Inc.Weed control successful.

What the 200 rows show

from the 200-row sample

Peat (soil type) stands out: mean soil_organic_matter_pct is 10.6, against 3.2 for the rest.

  • 3.3median soil_organic_matter_pct
  • 4fertilizer types
  • 5irrigation types
  • 5pesticide types
  • 4,924median yield_kg_per_hectare
  • 16.2median field_area_hectares
Mean soil_organic_matter_pct by soil_type200 rows
010203.7loam44 ro…3.4clay27 ro…2.2sandy31 ro…3.6silt36 ro…10.6peat32 ro…2.2chalk27 ro…8.2other3 rows
soil_organic_matter_pct200 rows, in bands of 2
055110291042951313520816soil_organic_matter_pct →

Median 3.3, from 0.90 to 14.5.

crop_type200 rows · 7 values
  1. corn38
  2. rice33
  3. cotton33
  4. wheat32
  5. barley31
  6. soybeans30
  7. other3
21 columns by typefrom the column list below
  • string 8
  • float 11
  • date 2

Columns

21 columns in three groups
blueprint · 21 columns
columntypedescriptionexample
Text 8 columns
field_idstringUnique identifier for the agricultural field or plotuniqueF001-2024A
crop_typestringType of crop grown in the field (e.g., corn, wheat, soybeans)7 valuescorn
soil_typestringDominant soil type in the field (e.g., loam, clay, sandy)7 valuesloam
irrigation_typestringType of irrigation used (e.g., drip, sprinkler, flood, rainfed)drip · sprinkler · flood · rainfed · otherdrip
fertilizer_typestringType of fertilizer applied (e.g., NPK, organic, none)NPK · organic · none · other · optionalNPK
pesticide_typestringType of pesticide applied (e.g., herbicide, insecticide, fungicide, none)herbicide · insecticide · fungicide · none · other · optionalherbicide
field_ownerstringName or identifier of the field owner or manageroptionalAgriMax Farms
notesstringAdditional notes or observations about the field or crop seasonoptionalWeed control successful.
Numbers 11 columns
yield_kg_per_hectarefloatMeasured crop yield in kilograms per hectare0 or more8700.5
field_area_hectaresfloatSize of the field in hectares0.01 or more15.3
soil_phfloatMeasured soil pH value3.5 to 9.5 · optional6.4
soil_organic_matter_pctfloatPercentage of organic matter in the soil0 to 100 · optional3.2
fertilizer_amount_kg_per_hectarefloatAmount of fertilizer applied per hectare0 or more · optional150
pesticide_amount_liters_per_hectarefloatAmount of pesticide applied per hectare0 or more · optional2.5
avg_temperature_cfloatAverage temperature during the growing season (Celsius)-20 to 50 · optional22.3
total_precipitation_mmfloatTotal precipitation during the growing season (millimeters)0 or more · optional510
field_latitudefloatLatitude coordinate of the field center-90 to 9041.5967
field_longitudefloatLongitude coordinate of the field center-180 to 180-93.6053
field_elevation_metersfloatElevation of the field above sea level (meters)-400 to 9,000 · optional287
Dates and times 2 columns
planting_datedateDate when the crop was planted2024-03-25
harvest_datedateDate when the crop was harvestedoptional2024-09-20

15 SQL practice questions for the Agtech Crop Yield Prediction

Written for this data and checked against it: 12 SQL and 3 Power BI exercises from beginner to advanced. Try the first three free; the practice kit has all 15, a starter .sql file and an answer key with every expected result.

  1. 01BeginnerFreeSELECT · WHERE · ORDER BY

    High-yield corn fields

    Return field_id, yield_kg_per_hectare and field_owner for corn fields (crop_type = 'corn') whose yield_kg_per_hectare is above 8000. Order the results by yield_kg_per_hectare from highest to lowest, then by field_id ascending.

    Tables: agtech_crop_yield_prediction · your result: 3 columns, 29 rows
  2. 02BeginnerFreeDISTINCT · ORDER BY

    Distinct irrigation types

    Return each distinct irrigation_type found in the data, sorted alphabetically. The result should have a single column named irrigation_type.

    Tables: agtech_crop_yield_prediction · your result: 1 columns, 5 rows
  3. 03BeginnerFreeGROUP BY · COUNT

    Fields per crop

    Count the fields for each crop_type. Return crop_type and field_count, ordered by field_count from highest to lowest, then by crop_type ascending.

    Tables: agtech_crop_yield_prediction · your result: 2 columns, 7 rows
  1. 04Average yield by soil typeBeginner
  2. 05Total area by irrigation typePower BI
  3. 06Crops with high average yieldIntermediate
  4. 07Soil pH bucketsIntermediate
  5. 08Fields above overall average yieldIntermediate
  6. 09Yield by planting year with a CTEIntermediate
  7. 10Fertilizer vs overall average gapPower BI
  8. 11Rank fields within cropAdvanced
  9. 12Percent of total area by cropAdvanced
  10. 13Yield change between planting datesAdvanced
  11. 14Running area total by yearAdvanced
  12. 15Yield anomalies within cropPower BI

Get the practice kit: the full dataset, all 15 exercises, a starter .sql and the answer key. One-time $3.99.

Get the practice kit · $3.99

Use it for

  • median soil or…3.3200 rowsmean soil organic mat…3.7loam3.4clay2.2sandy3.6silt

    An agriculture dashboard

    Soil_organic_matter_pct by soil_type and a breakdown of crop_type. Excel, Power BI or Tableau.

  • Why do the 32 peat rows have a mean soil_organic_matter_pct of 10.6?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable fields with crop_type, planting_date and harvest_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 21 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows21 columns
Yours1,000 rows21 columns

blueprint · agtech-crop-yield-prediction

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 21 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
  • Include crop type and location
  • Track yield per hectare
  • Segment by fertilizer usage
  • Flag yield anomalies
Rows
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
agtech-crop-yield-prediction

What should your data show?

Preview 20 rows free
No signup. No card.