Farm-to-Market Produce Trace Log

This dataset provides end-to-end traceability for agricultural produce, capturing every stage from harvest at the farm, through distribution nodes, to final market delivery. It includes detailed location, timing, quality, and compliance data, enabling stakeholders to monitor supply chain transparency, identify bottlenecks, and ensure food safety and regulatory compliance.

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

Supply chain transparency and traceability for food safety investigations

Sample rows

preview · 8 of 140 rows · all 42 columns
trace_log_idstringmarket_countrystringquantityfloatquality_check_passedbooleandistribution_node_statestringproduce_idstringproduce_typestringvarietystringquantity_unitstringharvest_datedatefarm_idstringfarm_namestringfarm_street_addressstringfarm_citystringfarm_statestringfarm_postal_codestringfarm_countrystringdistribution_node_idstringdistribution_node_namestringdistribution_node_street_addressstringdistribution_node_citystringdistribution_node_postal_codestringdistribution_node_countrystringarrival_at_distribution_nodedatetimedeparture_from_distribution_nodedatetimetransportation_modestringtransporter_idstringtransporter_namestringmarket_idstringmarket_namestringmarket_street_addressstringmarket_citystringmarket_statestringmarket_postal_codestringarrival_at_marketdatetimequality_issuesstringcompliance_certificationsstringtemperature_log_minfloattemperature_log_maxfloathumidity_log_minfloathumidity_log_maxfloatnotesstring
TL000001USA1380.75trueCAPRD10001TomatoRomakg2023-08-12FARM001Sunrise Valley Farms412 Maple DrModestoCA95350USADN1001Central Ag Co-op1880 Elm StModesto95351USA2023-08-12T13:20:002023-08-12T16:20:00truckTSP3001Golden State LogisticsMKT1001FreshMart Downtown200 River RdSacramentoCA958182023-08-13T09:15:00blankorganic9.519.35782Delivered on time; no visible spoilage.
TL000002USA6.5trueIDPRD10002PotatoYukon Goldtons2023-08-15FARM002Evergreen Acres90 Country LaneBoiseID83716USADN1002Northwest Cold Storage3540 Park AveBoise83715USA2023-08-15T15:10:002023-08-15T21:05:00railTSP3002IdaRail LogisticsMKT1002Harvest Foods1200 Orchard BlvdSpokaneWA992022023-08-16T08:40:00blankgap, fair-trade5.413.76891blank
TL000003USA1120trueAZPRD10003LettuceIcebergcrates2023-08-17FARM003GreenSprout Farm845 Spruce RdYumaAZ85365USADN1003Southwest Ag Hub1427 Valley HwyYuma85366USA2023-08-17T14:10:002023-08-17T18:00:00truckTSP3003Borderline CarriersMKT1003QuickStop Grocers100 Main StPhoenixAZ850032023-08-18T07:10:00blankgap2.27.87397Handled with extra care for heat.
TL000004USA815falseWAPRD10004ApplesHoneycrispboxes2023-09-01FARM004Orchard Blossom12 Apple WayYakimaWA98901USADN1004Valley Distribution201 Packard StYakima98902USA2023-09-01T12:15:002023-09-01T17:00:00truckTSP3004Pacific NW MoversMKT1004Market Basket88 4th AveSeattleWA981012023-09-02T06:30:0010% bruising in top layer boxesorganic, usda7.1226084Minor bruising reported; cause investigated.
TL000005USA950trueCAPRD10005StrawberryAlbionlbs2023-06-05FARM005Berry Fields Forever42 Redberry LnWatsonvilleCA95076USADN1005NorCal Ag Storage310 Wharf RdWatsonville95077USA2023-06-05T11:00:002023-06-05T14:15:00truckTSP3005Santa Cruz HaulageMKT1005Sunrise Market250 Bay AveSan JoseCA951122023-06-06T08:35:00blankorganic26.78998Excellent condition; high sugar content.
TL000006USA1210.5trueCOPRD10006CarrotNanteskg2023-07-29FARM006Rooted Harvest700 Willow CtGreeleyCO80631USADN1006Front Range Hub555 Silo DrGreeley80632USA2023-07-29T15:00:002023-07-29T19:00:00truckTSP3006Colorado FreightMKT1006Healthwise Organics3218 10th StDenverCO802042023-07-30T07:00:00blankblank3.5117088Slightly above avg. size.
TL000007USA825trueMIPRD10007CucumberEnglishboxes2023-09-10FARM007Riverside Greens510 Greenhouse RdHollandMI49423USADN1007Great Lakes Ag1210 Harbor BlvdHolland49424USA2023-09-10T12:55:002023-09-10T16:20:00truckTSP3007Lakefront HaulersMKT1007Midwest Fresh88 Barton AveChicagoIL606082023-09-11T06:45:00blankgap4.714.26485No issues.
TL000008USA7.3falseGAPRD10008OnionYellow Sweettons2023-08-25FARM008Circle O Farms800 Golden RdVidaliaGA30474USADN1008Peach State Distribution514 Market LoopVidalia30475USA2023-08-25T11:10:002023-08-25T17:00:00railTSP3008Georgia Rail ExpressMKT1008Southern Foods901 Peach StAtlantaGA303032023-08-26T08:10:00Signs of sprouting in 2 boxesblank8.424.15575Quality issue: sprouting.

What the 140 rows show

from the 140-row sample
  • 91%quality_check_passed = true
  • 750.0median quantity
  • 4distribution node countries
  • 5quantity units
  • 5farm countries
  • 5transportation modes
market_country140 rows by value
070140134USA96%5Canada4%1Puerto Rico1%
quantity140 rows, in bands of 2,000
065130125122000108,00014kquantity →

Median 750.0, from 5.2 to 12,500.

distribution_node_state71 rows with a value · 69 left blank
  1. CA19
  2. WA8
  3. OR8
  4. CO5
  5. ID3
  6. GA3
  7. IL2
  8. MS2
  9. NE2
  10. IA2
42 columns by typefrom the column list below
  • string 32
  • float 5
  • date 1
  • datetime 3
  • boolean 1

Columns

42 columns in four groups
blueprint · 42 columns
columntypedescriptionexample
Text 32 columns
trace_log_idstringUnique identifier for each produce trace log entryuniqueTL000001
produce_idstringUnique identifier for the produce batchPRD10001
produce_typestringType or name of the agricultural produce (e.g., tomatoes, potatoes)Tomato
varietystringProduce variety or cultivar (if applicable)optionalRoma
quantity_unitstringUnit of measurement for quantity (e.g., kg, tons, crates)kg · tons · crates · boxes · lbskg
farm_idstringUnique identifier for the originating farmFARM001
farm_namestringName of the originating farmSunrise Valley Farms
farm_street_addressstringStreet address of the farmoptional412 Maple Dr
farm_citystringCity where the farm is locatedoptionalModesto
farm_statestringState or region where the farm is locatedoptionalCA
farm_postal_codestringPostal code of the farmoptional95350
farm_countrystringCountry where the farm is located5 countriesUSA
distribution_node_idstringUnique identifier for the distribution or logistics nodeoptionalDN1001
distribution_node_namestringName of the distribution node (e.g., warehouse, co-op, aggregator)optionalCentral Ag Co-op
distribution_node_street_addressstringStreet address of the distribution nodeoptional1880 Elm St
distribution_node_citystringCity where the distribution node is locatedoptionalModesto
distribution_node_statestringState or region of the distribution nodeoptionalCA
distribution_node_postal_codestringPostal code of the distribution nodeoptional95351
distribution_node_countrystringCountry of the distribution node4 countries · optionalUSA
transportation_modestringMode of transportation used between nodes (e.g., truck, rail, ship)truck · rail · ship · air · other · optionaltruck
transporter_idstringUnique identifier for the transporter or logistics provideroptionalTSP3001
transporter_namestringName of the transporter or logistics provideroptionalGolden State Logistics
market_idstringUnique identifier for the end-market or retailerMKT1001
market_namestringName of the end-market or retailerFreshMart Downtown
market_street_addressstringStreet address of the end-marketoptional200 River Rd
market_citystringCity where the end-market is locatedoptionalSacramento
market_statestringState or region of the end-marketoptionalCA
market_postal_codestringPostal code of the end-marketoptional95818
market_countrystringCountry of the end-market3 countriesUSA
quality_issuesstringDescription of any quality issues identified at the marketoptionalSigns of wilting
compliance_certificationsstringComma-separated list of compliance certifications (e.g., organic, fair-trade)10 certificationses · optionalorganic
notesstringAdditional notes or comments about the trace log entryoptionalNo issues.
Numbers 5 columns
quantityfloatQuantity of produce in the batch0 or more1380.75
temperature_log_minfloatMinimum temperature recorded during transit (Celsius)optional9.5
temperature_log_maxfloatMaximum temperature recorded during transit (Celsius)optional19.3
humidity_log_minfloatMinimum humidity recorded during transit (%)0 to 100 · optional57
humidity_log_maxfloatMaximum humidity recorded during transit (%)0 to 100 · optional82
Dates and times 4 columns
harvest_datedateDate when the produce was harvested2023-08-12
arrival_at_distribution_nodedatetimeTimestamp when produce arrived at the distribution nodeoptional2023-08-12T13:20:00
departure_from_distribution_nodedatetimeTimestamp when produce departed from the distribution nodeoptional2023-08-12T16:20:00
arrival_at_marketdatetimeTimestamp when produce arrived at the end-market2023-08-13T09:15:00
True or false 1 column
quality_check_passedbooleanIndicates if the produce passed quality checks at the marketoptionaltrue

Use it for

  • quality check …91%127 of 140 rowsmean quantity by mark…1kUSA950.4Canada920.0Puerto…

    An agriculture dashboard

    The quality_check_passed rate, quantity by market_country and a breakdown of distribution_node_state. Excel, Power BI or Tableau.

  • Why do 127 of 140 rows have quality_check_passed = true?

    A class exercise

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

  • A software demo

    Believable trace logs with produce_id, produce_type and variety to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 42 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 dataset140 rows42 columns
Yours1,000 rows42 columnsfarm_street_address: UK only

blueprint · farm-to-market-produce-trace-log

Behind this dataset

Same schema. As many rows as you need.

These 140 rows came out of a blueprint — 42 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 produce shipment batch and its traced journey.
  • Log must include at least three touchpoints: farm, intermediary (e.g., processor, wholesaler), and market.
  • Timestamp and condition checks are required at each touchpoint.
  • Any discrepancies in route, temperature deviation, or delays must be flagged.
  • Batch must include a unique identifier for full traceability.
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-produce-trace-log

More in Agriculture

Browse all
Also in AgricultureFarm-to-Store Crop Traceability LogAgri-Food Blockchain Traceability LogPrecision Farming Drone ImageryAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.