Farm-to-Store Produce Traceability Log

This dataset provides comprehensive traceability logs for fresh produce, detailing its journey from small farms to retail stores. It includes batch-level data, transport conditions, quality assessments, and recall flags, enabling agri-tech startups and supply chain analysts to ensure food safety compliance, optimize logistics, and rapidly identify supply chain gaps.

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

End-to-end produce traceability for food safety compliance

Sample rows

preview · 8 of 80 rows · all 31 columns
trace_idstringproduce_quality_gradestringquantityfloatrecall_flagbooleanproduce_varietystringproduce_typestringharvest_datedatefarm_idstringfarm_namestringfarm_street_addressstringfarm_citystringfarm_statestringfarm_postal_codestringfarm_countrystringbatch_idstringtransport_idstringdeparture_datedatetimearrival_datedatetimetransport_conditions_temperaturefloattransport_conditions_humidityfloattransport_conditions_notesstringstore_idstringstore_namestringstore_street_addressstringstore_citystringstore_statestringstore_postal_codestringstore_countrystringreceived_bystringrecall_reasonstringlast_updateddatetime
TRC-1A2B3C4DA412.7falseRomaTomato2024-04-02FM-101Green Valley Farms123 Country RdModestoCA95350USABATCH-001TRANS-90012024-04-03T08:25:002024-04-04T10:12:007.573.2Smooth transportSTR-2001Fresh Mart Modesto456 Market BlvdModestoCA95350USAEmily Carterblank2024-04-04T11:00:00
TRC-5E6F7G8HA230.2falseButterheadLettuce2024-04-05FM-102Sunny Acres789 Farm LaneSalinasCA93901USABATCH-002TRANS-90022024-04-05T14:10:002024-04-06T09:35:003.285.6blankSTR-2002Grocery Central Salinas321 Main StSalinasCA93901USALuis Ramirezblank2024-04-06T10:15:00
TRC-9J0K1L2MA80.6falseAlbionStrawberry2024-03-31FM-103Berry Patch Co12 Orchard AveWatsonvilleCA95076USABATCH-003TRANS-90032024-04-01T07:50:002024-04-01T12:30:004.888Minor delay due to trafficSTR-2003SuperMart Watsonville98 Commerce RoadWatsonvilleCA95076USASandra Leeblank2024-04-01T13:00:00
TRC-3N4O5P6QB55.9falseBloomsdaleSpinach2024-04-07FM-104Leafy Greens Farm100 Harvest WayDavisCA95616USABATCH-004TRANS-90042024-04-08T08:05:002024-04-08T11:45:002.392.7blankSTR-2004Davis Naturals200 Fifth AveDavisCA95616USAMark Chenblank2024-04-08T12:05:00
TRC-7R8S9T0UA145.3falseEnglishCucumber2024-04-02FM-105Riverbend Produce50 Creekside DrSacramentoCA95814USABATCH-005TRANS-90052024-04-03T09:30:002024-04-03T13:55:005.167.4blankSTR-2005Sacramento Fresh999 Green StSacramentoCA95814USAAva Brooksblank2024-04-03T14:20:00
TRC-1V2W3X4YA100.8falseCherryTomato2024-03-28FM-106Sunshine Farms66 Sunrise BlvdBakersfieldCA93307USABATCH-006TRANS-90062024-03-29T07:45:002024-03-29T12:10:008.682.3blankSTR-2006Bakersfield Market77 Union AveBakersfieldCA93307USAJacob Hallblank2024-03-29T12:30:00
TRC-5Z6A7B8CB289falseRomaineLettuce2024-04-04FM-101Green Valley Farms123 Country RdModestoCA95350USABATCH-007TRANS-90072024-04-05T06:30:002024-04-05T11:15:002.790.2Delayed loadingSTR-2007Modesto Organics500 Oak StModestoCA95350USAKevin Whiteblank2024-04-05T11:45:00
TRC-9D0E1F2GA220.4trueBeefsteakTomato2024-04-09FM-107Red Barn Farms101 Barn RdFresnoCA93722USABATCH-008TRANS-90082024-04-10T13:00:002024-04-11T09:30:009.169blankSTR-2008Fresno Grocery32 Valley StFresnoCA93722USARosa MartinezSuspected contamination2024-04-11T10:05:00

What the 80 rows show

from the 80-row sample
  • 6%recall_flag = true
  • 113.3median quantity
  • 8farm states
  • 8store states
  • 14farm cities
  • 15produce types
produce_quality_grade80 rows by value
0306059A74%20B25%1C1%
quantity80 rows, in bands of 50
015305281711872020250450quantity →

Median 113.3, from 39.4 to 412.7.

produce_variety80 rows · top 10 of 29 values
  1. Butterhead7
  2. Albion6
  3. Romaine6
  4. Savoy6
  5. Bloomsdale5
  6. English5
  7. Seascape5
  8. Roma4
  9. Cherry4
  10. Beefsteak4
31 columns by typefrom the column list below
  • string 23
  • float 3
  • date 1
  • datetime 3
  • boolean 1

Columns

31 columns in four groups
blueprint · 31 columns
columntypedescriptionexample
Text 23 columns
trace_idstringUnique identifier for each produce traceability recorduniqueTRC-1A2B3C4D
produce_typestringType of produce being tracked (e.g., tomato, lettuce)Tomato
produce_varietystringSpecific variety of the produce (e.g., Roma, Cherry for tomatoes)optionalRoma
farm_idstringUnique identifier for the farm where produce was grownFM-101
farm_namestringName of the farmGreen Valley Farms
farm_street_addressstringStreet address of the farm123 Country Rd
farm_citystringCity where the farm is locatedModesto
farm_statestringState or region where the farm is located8 statesCA
farm_postal_codestringPostal code of the farm location95350
farm_countrystringCountry where the farm is locatedUSA
batch_idstringIdentifier for the batch of produceBATCH-001
transport_idstringUnique identifier for the transport vehicle or shipmentTRANS-9001
transport_conditions_notesstringAdditional notes about transport conditions (e.g., incidents, delays)optionalSmooth transport
store_idstringUnique identifier for the retail storeSTR-2001
store_namestringName of the retail storeFresh Mart Modesto
store_street_addressstringStreet address of the retail store456 Market Blvd
store_citystringCity where the retail store is locatedModesto
store_statestringState or region where the retail store is located8 statesCA
store_postal_codestringPostal code of the retail store location95350
store_countrystringCountry where the retail store is locatedUSA
received_bystringName or ID of the store employee who received the produceoptionalEmily Carter
produce_quality_gradestringQuality grade assigned to produce upon arrival (e.g., A, B, C)A · B · C · Rejected · optionalA
recall_reasonstringReason for recall, if applicableoptionalSuspected contamination
Numbers 3 columns
quantityfloatQuantity of produce in the batch (in kilograms)0.01 or more412.7
transport_conditions_temperaturefloatAverage temperature during transport (in Celsius)-30 to 50 · optional7.5
transport_conditions_humidityfloatAverage humidity during transport (percentage)0 to 100 · optional73.2
Dates and times 4 columns
harvest_datedateDate the produce was harvested2024-04-02
departure_datedatetimeDate and time when produce left the farm2024-04-03T08:25:00
arrival_datedatetimeDate and time when produce arrived at the retail store2024-04-04T10:12:00
last_updateddatetimeTimestamp of the last update to this record2024-04-04T11:00:00
True or false 1 column
recall_flagbooleanIndicates if the batch is subject to a recallfalse

Use it for

  • recall flag6%5 of 80 rowsmean quantity by prod…143.2A143.0B84.9C

    An agriculture dashboard

    The recall_flag rate, quantity by produce_quality_grade and a breakdown of produce_variety. Excel, Power BI or Tableau.

  • Why do 5 of 80 rows have recall_flag = true?

    A class exercise

    Hand out the rows and one question. Everyone works from the same 80 rows.

  • A software demo

    Believable traces with produce_type, produce_variety and harvest_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 31 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 dataset80 rows31 columns
Yours1,000 rows31 columnsfarm_street_address: UK only

blueprint · farm-to-store-produce-traceability-log

Behind this dataset

Same schema. As many rows as you need.

These 80 rows came out of a blueprint — 31 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 row represents a unique shipment batch from origin to destination.
  • Log must include timestamps for all transfer points (farm, aggregator, distribution, retail).
  • Temperature and humidity readings are recorded at each transfer.
  • Include unique identifiers for farm, transport carrier, and receiving store.
  • Flag shipments exceeding threshold temperature or delayed beyond SLA.
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-store-produce-traceability-log

More in Agriculture

Browse all
Also in AgricultureFarm-to-Market Crop TraceabilitySynthetic Plant Disease DiagnosisAgriculture Field Sensor ReadingsAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.