Farm-to-Market Crop Traceability

This dataset provides comprehensive traceability for perishable crop shipments from farm to market, including detailed route, timing, environmental conditions, spoilage tracking, and compliance with food safety and sustainability standards. It empowers agri-tech startups and logistics teams to optimize supply chains, minimize spoilage, and fulfill ESG reporting requirements.

  • last updated 9 Dec 2025
  • by GoMask
The brief that made it

End-to-end crop traceability for regulatory and consumer transparency

Sample rows

preview · 8 of 120 rows · all 35 columns
shipment_idstringtransport_modestringtemperature_min_cfloatspoilage_detectedbooleandestination_statestringcrop_typestringcrop_varietystringquantity_kgfloatharvest_datedatefarm_idstringfarm_namestringfarm_street_addressstringfarm_citystringfarm_statestringfarm_postal_codestringfarm_countrystringdestination_idstringdestination_namestringdestination_street_addressstringdestination_citystringdestination_postal_codestringdestination_countrystringdeparture_datetimedatetimearrival_datetimedatetimecarrier_namestringvehicle_idstringroute_plannedstringactual_routestringtemperature_max_cfloathumidity_avg_percentfloatspoilage_quantity_kgfloatesg_certifiedbooleanfood_safety_certificationstringsustainability_scorefloatnotesstring
SHP0001truck2.7falseCAlettuceIceberg85.22024-06-07FARM001Green Valley Farms1208 Valley RoadDavisCA95616USADST0001Sacramento Fresh Market430 Central AveSacramento95814USA2024-06-07T10:15:002024-06-07T12:40:00WestCoast LogisticsVEH1001Davis -> Woodland -> SacramentoDavis -> Sacramento6.994.10trueGAP92.4blank
SHP0002truck7.2falseCAtomatoesRoma340.52024-06-06FARM002Sunrise Acre2125 Orchard LaneStocktonCA95207USADST0002Bay Area Produce Hub98 Market WayOakland94607USA2024-06-06T13:10:002024-06-06T16:30:00GoldenGate TransportVEH1002Stockton -> Tracy -> OaklandStockton -> Oakland12.189.80trueHACCP87.7Route optimized for traffic
SHP0003ship19trueEnglandriceBasmati195002024-05-30FARM003Punjab Estates92 Canal RoadAmritsarPunjab143001IndiaDST0003UK Rice Import Hub340 Dockside BlvdLondonE16 2QYUK2024-06-01T09:00:002024-06-06T22:00:00GlobalSea LogisticsVEH1003Amritsar -> Mumbai Port -> London (sea)Amritsar -> Mumbai Port -> Rotterdam -> London (sea)29.857.3480.7trueHACCP74.2Container flooding reported
SHP0004ship12.4falseONbananasCavendish82502024-06-02FARM004Tropical Grove17 Palm DriveLimonLimon70101Costa RicaDST0004Toronto Fruit Center211 Freshwater RdTorontoM5V 1C9Canada2024-06-03T07:30:002024-06-07T13:55:00Caribbean Export LtdVEH1004Limon -> Montreal Port -> Toronto (sea)Limon -> Montreal Port -> Toronto (sea)18.285.90trueGAP81.8blank
SHP0005rail11.2falseMNcornSweet15502024-06-05FARM005Prairie Farms3986 Miller RoadFargoND58102USADST0005Twin Cities Market800 North StMinneapolis55401USA2024-06-06T06:45:002024-06-06T15:05:00Northern Rail FreightVEH1005Fargo -> Grand Forks -> MinneapolisFargo -> Minneapolis18.559.70trueGAP79.6blank
SHP0006other9.1falseILpotatoesblank0.042024-06-07FARM006Urban Sprout Farm650 Market StreetChicagoIL60607USADST0006Chicago Local Foods1121 West LoopChicago60607USA2024-06-07T08:00:002024-06-07T08:45:00UrbanCycle DeliveryVEH1006Chicago LoopChicago Loop12.385.30falsenone7.6Edge case: minimum allowed quantity shipment
SHP0007truck4.6falseWAapplesFuji6502024-06-05FARM007Orchard Hill Estates1842 Maple LaneYakimaWA98901USADST0007Seattle Fruit Hub5212 Pike StreetSeattle98101USA2024-06-05T15:00:002024-06-05T18:20:00Cascade ExpressVEH1007Yakima -> Ellensburg -> SeattleYakima -> Seattle10.2890trueGAP88.3blank
SHP0008truck3.5falseONcucumbersEnglish72.82024-06-06FARM008Riverbend Gardens563 Elm StreetOshawaONL1G 3V4CanadaDST0008Toronto Green Market900 Queen St WTorontoM6J 1G6Canada2024-06-06T09:30:002024-06-06T11:00:00MapleLeaf LogisticsVEH1008Oshawa -> TorontoOshawa -> Toronto8.497.20trueGAP93.8blank

What the 120 rows show

from the 120-row sample

Truck (transport mode) stands out: mean temperature_min_c is 4.1, against 15.9 for the rest.

  • 23%spoilage_detected = true
  • 5.5median temperature_min_c
  • 3food safety certifications
  • 5destination countries
  • 10farm countries
  • 18crop types
Mean temperature_min_c by transport_mode120 rows
010204.1truck74 rows16.2rail19 rows15.4air1 rows18.1ship19 rows9.1other7 rows
temperature_min_c120 rows, in bands of 5
03060532811206201530temperature_min_c →

Median 5.5, from 1.5 to 27.8.

destination_state120 rows · top 10 of 32 values
  1. CA31
  2. WA9
  3. TX9
  4. ON8
  5. FL7
  6. BC6
  7. NY5
  8. OR5
  9. IL4
  10. England3
35 columns by typefrom the column list below
  • string 24
  • float 6
  • date 1
  • datetime 2
  • boolean 2

Columns

35 columns in four groups
blueprint · 35 columns
columntypedescriptionexample
Text 24 columns
shipment_idstringUnique identifier for each crop shipmentuniqueSHP0001
crop_typestringType of crop being shipped (e.g., tomatoes, lettuce)lettuce
crop_varietystringSpecific variety of the crop (e.g., Roma, Iceberg)optionalIceberg
farm_idstringUnique identifier for the originating farmFARM001
farm_namestringName of the farm where the crop was grownGreen Valley Farms
farm_street_addressstringStreet address of the farm1208 Valley Road
farm_citystringCity where the farm is locatedDavis
farm_statestringState or province where the farm is locatedCA
farm_postal_codestringPostal code of the farm location95616
farm_countrystringCountry where the farm is located10 countriesUSA
destination_idstringUnique identifier for the shipment destinationDST0001
destination_namestringName of the destination facility or marketSacramento Fresh Market
destination_street_addressstringStreet address of the destination430 Central Ave
destination_citystringCity of the destinationSacramento
destination_statestringState or province of the destinationCA
destination_postal_codestringPostal code of the destination95814
destination_countrystringCountry of the destination5 countriesUSA
transport_modestringMode of transportation used (e.g., truck, rail, air)truck · rail · air · ship · othertruck
carrier_namestringName of the logistics carrier or companyWestCoast Logistics
vehicle_idstringIdentifier for the vehicle used for transportoptionalVEH1001
route_plannedstringPlanned route description or major waypointsoptionalChicago Loop
actual_routestringActual route taken, if different from plannedoptionalDavis -> Sacramento
food_safety_certificationstringType of food safety certification (e.g., GAP, HACCP)3 certifications · optionalGAP
notesstringAdditional notes or comments about the shipmentoptionalCross-border shipment
Numbers 6 columns
quantity_kgfloatTotal quantity of crop in kilograms0.01 or more85.2
temperature_min_cfloatMinimum temperature recorded during shipment (Celsius)optional2.7
temperature_max_cfloatMaximum temperature recorded during shipment (Celsius)optional6.9
humidity_avg_percentfloatAverage humidity percentage during shipment0 to 100 · optional94.1
spoilage_quantity_kgfloatQuantity of crop spoiled during shipment (kg)0 or more · optional0
sustainability_scorefloatScore indicating sustainability performance (0-100)0 to 100 · optional92.4
Dates and times 3 columns
harvest_datedateDate when the crop was harvested2024-06-07
departure_datetimedatetimeDate and time when the shipment leaves the farm2024-06-07T10:15:00
arrival_datetimedatetimeDate and time when the shipment arrives at the destination2024-06-07T12:40:00
True or false 2 columns
spoilage_detectedbooleanIndicates if spoilage was detected during shipmentoptionalfalse
esg_certifiedbooleanIndicates if the shipment meets ESG (Environmental, Social, Governance) standardsoptionaltrue

Use it for

  • spoilage detec…23%27 of 120 rowsmean temperature min …4.1truck16.2rail15.4air18.1ship

    An agriculture dashboard

    The spoilage_detected rate, temperature_min_c by transport_mode and a breakdown of destination_state. Excel, Power BI or Tableau.

  • Why do the 74 truck rows have a mean temperature_min_c of 4.1?

    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 shipments with crop_type, crop_variety and quantity_kg to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 35 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 dataset120 rows35 columns
Yours1,000 rows35 columnsfarm_street_address: UK only

blueprint · farm-to-market-crop-traceability

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 35 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
  • Each shipment must include unique batch and crop type identifiers.
  • Track temperature and humidity readings from IoT sensors at each transport checkpoint.
  • Log handling events (harvest, loading, offloading, delivery) with timestamps.
  • Flag shipments exceeding recommended transit time for perishables.
  • Include farm location, destination, carrier ID, and shipment status.
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
farm-to-market-crop-traceability

More in Agriculture

Browse all
Also in AgricultureAgri-Product IoT Traceability LogsAgriTech Equipment Telemetry DatasetIoT Crop Health MonitoringAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.