Farm-to-Store Crop Traceability Log

This dataset provides detailed, end-to-end traceability for crop batches from small farms to local stores, recording harvests, handling events, responsible parties, and delivery details. It enables food safety audits, recall management, and supply chain optimization, making it ideal for regulatory compliance, consumer transparency, and logistics analytics.

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

Food safety and recall management

Sample rows

preview · 8 of 120 rows · all 33 columns
batch_idstringresponsible_party_rolestringquantity_deliveredfloatcrop_typestringvarietystringharvest_datedatefarm_idstringfarm_namestringfarm_street_addressstringfarm_citystringfarm_statestringfarm_postal_codestringfarm_countrystringquantity_harvestedfloatunitstringhandling_event_idstringhandling_typestringhandling_datetimedatetimeresponsible_party_idstringresponsible_party_namestringdelivery_idstringdelivery_datetimedatetimestore_idstringstore_namestringstore_street_addressstringstore_citystringstore_statestringstore_postal_codestringstore_countrystringdelivery_conditionstringrecall_flagbooleanrecall_reasonstringtraceability_statusstring
TOM_2024A_01farm_manager218.3tomatoesRoma2024-06-01FARM01Green Valley Farms101 Country LaneMadisonWI53703USA220.5kgHEVNT_00001washing2024-06-01T09:12:00EMP001Amanda GrantDEL_00001_012024-06-02T14:20:00STR001FreshMarket Downtown445 State StMadisonWI53703USAfreshfalseblankcomplete
LTT_2024B_02packer143.7lettuceButterhead2024-06-03FARM02Sunrise Acres77 Spring RdEau ClaireWI54701USA145kgHEVNT_00002cooling2024-06-03T10:45:00EMP002Daniel LeeDEL_00002_022024-06-04T13:00:00STR002Local Grocers West1205 Clairemont AveEau ClaireWI54701USAfreshfalseblankcomplete
CRR_2024C_03packer119.1carrotsNantes2024-06-05FARM03Fieldstone Produce823 Harvest AveWausauWI54401USA120kgHEVNT_00003packing2024-06-05T11:10:00EMP003Samantha BrooksDEL_00003_032024-06-06T15:30:00STR003Farm Fresh21 River StWausauWI54401USAfreshfalseblankcomplete
SPR_2024D_04farm_manager69.8spinachSavoy2024-06-08FARM04Willow Bend Organics312 Willow RdLa CrosseWI54601USA70.2kgHEVNT_00004cooling2024-06-08T09:48:00EMP004Tina McCarthyDEL_00004_042024-06-09T14:00:00STR004Organic Grocers400 Main StLa CrosseWI54601USAfreshfalseblankcomplete
TOM_2024E_05packer89.6tomatoesCherry2024-06-10FARM05Hillside Gardens154 Garden WayAppletonWI54911USA90kgHEVNT_00005packing2024-06-10T10:23:00EMP005Kyle JohnsonDEL_00005_052024-06-11T13:22:00STR005Neighborhood Foods200 Apple StAppletonWI54911USAfreshfalseblankcomplete
CRR_2024F_06farm_manager104.9carrotsImperator2024-06-12FARM06Prairie View2022 Prairie DrKenoshaWI53140USA105.8kgHEVNT_00006washing2024-06-12T08:10:00EMP006Linda TorresDEL_00006_062024-06-13T14:40:00STR006Pure Foods Market81 Market StKenoshaWI53140USAfreshfalseblankcomplete
LTT_2024G_07packer129.8lettuceIceberg2024-06-14FARM07Springbrook Farms56 Brook StOshkoshWI54901USA130.6kgHEVNT_00007cooling2024-06-14T09:00:00EMP007Peter WangDEL_00007_072024-06-15T13:19:00STR007Oshkosh Foods300 Jackson StOshkoshWI54901USAfreshfalseblankcomplete
SPR_2024H_08packer85.2spinachFlat Leaf2024-06-16FARM08Riverbend Growers300 River RdFond du LacWI54935USA85.5kgHEVNT_00008packing2024-06-16T10:15:00EMP008Rachel KimDEL_00008_082024-06-17T14:45:00STR008Fond du Lac Market122 Main StFond du LacWI54935USAfreshfalseblankcomplete

What the 120 rows show

from the 120-row sample

Inspector (responsible party role) stands out: mean quantity_delivered is 63.3, against 119.6 for the rest.

  • 98.8median quantity_delivered
  • 4units
  • 6handling types
  • 17farm states
  • 17store states
  • 99.2median quantity_harvested
Mean quantity_delivered by responsible_party_role120 rows
0100200118.4farm_…38 rows58.6driver4 rows63.3inspe…16 rows126.3packer53 rows97.0grocer5 rows131.7cooli…4 rows
quantity_delivered120 rows, in bands of 50
0255018433316701110250450quantity_delivered →

Median 98.8, from 23.5 to 418.0.

crop_type120 rows · top 10 of 32 values
  1. lettuce20
  2. tomatoes17
  3. carrots17
  4. spinach17
  5. kale4
  6. beets4
  7. potatoes3
  8. zucchini3
  9. cabbage3
  10. radishes3
33 columns by typefrom the column list below
  • string 27
  • float 2
  • date 1
  • datetime 2
  • boolean 1

Columns

33 columns in four groups
blueprint · 33 columns
columntypedescriptionexample
Text 27 columns
batch_idstringUnique identifier for the crop batch harvesteduniqueTOM_2024A_01
crop_typestringType of crop (e.g., tomatoes, lettuce, carrots)tomatoes
varietystringSpecific variety or cultivar of the cropoptionalRoma
farm_idstringUnique identifier for the farm where the crop was grownFARM01
farm_namestringName of the farm where the crop was grownGreen Valley Farms
farm_street_addressstringStreet address of the farm101 Country Lane
farm_citystringCity where the farm is locatedMadison
farm_statestringState or province where the farm is locatedWI
farm_postal_codestringPostal code of the farm53703
farm_countrystringCountry where the farm is locatedUSA
unitstringUnit of measurement for the quantity (e.g., kg, lbs, crates)kg · lbs · crates · boxeskg
handling_event_idstringUnique identifier for the handling eventuniqueHEVNT_00001
handling_typestringType of handling event (e.g., washing, packing, cooling, transport)6 valueswashing
responsible_party_idstringUnique identifier for the person or organization responsible for the handling eventEMP001
responsible_party_namestringName of the responsible party for the handling eventAmanda Grant
responsible_party_rolestringRole of the responsible party (e.g., farm manager, driver, inspector)farm_manager · driver · inspector · packer · grocerfarm_manager
delivery_idstringUnique identifier for the delivery eventuniqueDEL_00001_01
store_idstringUnique identifier for the store receiving the crop batchSTR001
store_namestringName of the store receiving the crop batchFreshMarket Downtown
store_street_addressstringStreet address of the store445 State St
store_citystringCity where the store is locatedMadison
store_statestringState or province where the store is locatedWI
store_postal_codestringPostal code of the store53703
store_countrystringCountry where the store is locatedUSA
delivery_conditionstringCondition of the crop upon delivery (e.g., fresh, damaged, wilted)fresh · damaged · wilted · spoiled · optionalfresh
recall_reasonstringReason for recall if applicableoptional
traceability_statusstringStatus of traceability for the batch (e.g., complete, partial, missing)complete · partial · missingcomplete
Numbers 2 columns
quantity_harvestedfloatTotal quantity harvested (in kilograms)0 or more220.5
quantity_deliveredfloatQuantity of crop delivered to the store (in kilograms)0 or more218.3
Dates and times 3 columns
harvest_datedateDate the crop batch was harvested2024-06-01
handling_datetimedatetimeDate and time of the handling event2024-06-01T09:12:00
delivery_datetimedatetimeDate and time the batch was delivered to the store2024-06-02T14:20:00
True or false 1 column
recall_flagbooleanIndicates if the batch is under recallfalse

Use it for

  • median quantit…98.8120 rowsmean quantity deliver…118.4farm…58.6driv…63.3insp…126.3pack…

    An agriculture dashboard

    Quantity_delivered by responsible_party_role and a breakdown of crop_type. Excel, Power BI or Tableau.

  • Why do the 16 inspector rows have a mean quantity_delivered of 63.3?

    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 batches with crop_type, variety and harvest_date to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 33 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 rows33 columns
Yours1,000 rows33 columnsfarm_street_address: UK only

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

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 33 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 entry represents a discrete crop batch movement or handling event.
  • Batches are uniquely identified and include harvest date, crop type, and originating farm.
  • All logistic stops (packing, cooling, distribution, store arrival) are timestamped in sequential order.
  • Handlers (person or entity) are recorded for every step for accountability.
  • Quality checks and relevant compliance notes are included where applicable.
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-crop-traceability-log

More in Agriculture

Browse all
Also in AgricultureAgricultural Product Traceability RecordsFarm Equipment Telemetry and Fault CodesAgri-Food Blockchain Traceability LogAll 1,958 datasets

What should your data show?

Preview 20 rows free
No signup. No card.