Agri-Food Blockchain Traceability Log

This dataset provides a comprehensive, event-level log of agricultural product movements and transformations across the supply chain, secured by blockchain technology. It enables supply chain managers, auditors, and regulators to verify product authenticity, trace disruptions, and ensure compliance with food safety and sustainability standards. Each record links product batches, actors, locations, and certifications for robust end-to-end traceability.

  • opened 5 times
  • last updated 16 Dec 2025
  • by GoMask
The brief that made it

End-to-end traceability of agricultural products for food safety audits

Sample rows

preview · 8 of 120 rows · all 20 columns
event_idstringunit_of_measurestringquantityfloatlocation_citystringproduct_idstringbatch_idstringevent_typestringtimestampdatetimeactor_idstringactor_rolestringlocation_namestringlocation_street_addressstringlocation_statestringlocation_postal_codestringlocation_countrystringcertification_typestringcertification_idstringprevious_event_idstringblockchain_tx_hashstringevent_notesstring
EVT-harvest-001Akg980.5YakimaPROD-APPLE-2024ABATCH-APPLE-20240601-Aharvest2024-06-01T08:21:00-07:00ACT-farmer-001farmerYakima Valley Orchard124 Orchard RdWA98901USAorganicORG-USA-2024-0001blanka1b2c3d4e5f60123456789abcdef0123456789abcdef0123456789abcdef0123Harvest completed with optimal weather, organic standards met.
EVT-processing-001Akg945.2YakimaPROD-APPLE-2024ABATCH-APPLE-20240601-Aprocessing2024-06-01T12:15:00-07:00ACT-processor-004processorYakima Fruit Processing212 Packing LnWA98902USAisoISO-9001-USA-2024-0002EVT-harvest-001Ab2c3d4e5f60123456789abcdef0123456789abcdef0123456789abcdef0123a1Processing under ISO9001 standards; minor bruising detected.
EVT-packaging-001Acases900YakimaPROD-APPLE-2024ABATCH-APPLE-20240601-Apackaging2024-06-01T15:36:00-07:00ACT-processor-004processorYakima Packing Facility212 Packing LnWA98902USAisoISO-9001-USA-2024-0003EVT-processing-001Ac3d4e5f60123456789abcdef0123456789abcdef0123456789abcdef0123a1b2Packaged in cases, post-inspection for quality.
EVT-transport-001Acases900YakimaPROD-APPLE-2024ABATCH-APPLE-20240601-Atransport2024-06-01T18:10:00-07:00ACT-transporter-001transporterYakima Distribution Hub500 Logistics PkwyWA98903USAnoneblankEVT-packaging-001Ad4e5f60123456789abcdef0123456789abcdef0123456789abcdef0123a1b2c3Loaded for transport to Seattle warehouse.
EVT-inspection-001AblankblankSeattlePROD-APPLE-2024ABATCH-APPLE-20240601-Ainspection2024-06-02T08:00:00-07:00ACT-inspector-001inspectorSeattle Distribution Center1200 Distribution AveWA98101USAgapGAP-USA-WA-2024-0001EVT-transport-001Ae5f60123456789abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4Inspection passed, GAP compliance verified.
EVT-harvest-002Btons13.5SantosPROD-COFFEE-2024BBATCH-COFFEE-20240602-Bharvest2024-06-02T06:12:00-03:00ACT-farmer-002farmerSantos Coffee Cooperative35 Fazenda RdSP11000-010Brazilfair_tradeFT-2024-Brazil-SP-0021blankf60123456789abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5Hand-picked beans, fair trade certified.
EVT-processing-002Btons12.9SantosPROD-COFFEE-2024BBATCH-COFFEE-20240602-Bprocessing2024-06-02T10:30:00-03:00ACT-processor-010processorSantos Coffee Mill35 Fazenda RdSP11000-010BrazilgapGAP-Brazil-SP-2024-0012EVT-harvest-002B123456789abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f6Wet mill processing, GAP standards met.
EVT-packaging-002Btons12.6SantosPROD-COFFEE-2024BBATCH-COFFEE-20240602-Bpackaging2024-06-02T13:45:00-03:00ACT-processor-010processorSantos Coffee Mill35 Fazenda RdSP11000-010Brazilfair_tradeFT-2024-Brazil-SP-0022EVT-processing-002B23456789abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f601Packaged in sacks, fair trade label applied.

What the 120 rows show

from the 120-row sample
  • 820.0median quantity
  • 5certification types
  • 7actor roles
  • 8event types
  • 8location countries
  • 21location states
unit_of_measure96 rows by value
0153025kg21%28tons23%3liters3%13units11%27cases23%
quantity96 rows, in bands of 10M
05010095000000001050M100Mquantity →

Median 820.0, from 0.0 to 100,000,000.

location_city118 rows with a value · 2 left blank
  1. Yakima12
  2. Varginha12
  3. Salinas11
  4. Parma8
  5. Davao City6
  6. Seattle5
  7. Santos4
  8. Chelan4
  9. Wenatchee4
  10. Medford4
20 columns by typefrom the column list below
  • string 18
  • float 1
  • datetime 1

Columns

20 columns in three groups
blueprint · 20 columns
columntypedescriptionexample
Text 18 columns
event_idstringUnique identifier for each blockchain traceability eventuniqueEVT-harvest-001A
product_idstringUnique identifier for the agricultural product being trackedPROD-APPLE-2024A
batch_idstringIdentifier for the product batch (lot number)BATCH-APPLE-20240601-A
event_typestringType of supply chain event (e.g., harvest, processing, transport, inspection, delivery)9 valuesharvest
actor_idstringUnique identifier for the organization or individual responsible for the eventACT-farmer-001
actor_rolestringRole of the actor in the supply chain (e.g., farmer, processor, transporter, inspector, retailer)8 valuesfarmer
location_namestringName or description of the location where the event occurredYakima Valley Orchard
location_street_addressstringStreet address of the event locationoptional124 Orchard Rd
location_citystringCity where the event took placeoptionalYakima
location_statestringState or province of the event locationoptionalWA
location_postal_codestringPostal code of the event locationoptional98901
location_countrystringCountry where the event occurred8 countriesUSA
unit_of_measurestringUnit of measure for the quantity (e.g., kg, tons, liters, units)6 values · optionalkg
certification_typestringType of certification or compliance relevant to the event (e.g., organic, fair trade, GAP, ISO)organic · fair_trade · gap · iso · none · optionalorganic
certification_idstringIdentifier for the certification document or recordoptionalORG-USA-2024-0001
blockchain_tx_hashstringHash of the blockchain transaction recording this eventuniquea1b2c3d4e5f60123456789abc…
previous_event_idstringReference to the previous event in the product's traceability chainoptionalEVT-harvest-001A
event_notesstringAdditional notes or comments about the eventoptionalHarvest completed with op…
Numbers 1 column
quantityfloatQuantity of product involved in the event (in standardized units)0 or more · optional980.5
Dates and times 1 column
timestampdatetimeDate and time when the event was recorded on the blockchain2024-06-09T09:00:00Z

Use it for

  • median quantity820.096 rowsmean quantity by unit…8.3kkg14.3tons33.3Mlite…8.7kunits

    An agriculture dashboard

    Quantity by unit_of_measure and a breakdown of location_city. Excel, Power BI or Tableau.

  • What pattern can you find in 120 rows?

    A class exercise

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

  • A software demo

    Believable events with product_id, batch_id and event_type to fill a screen in front of a buyer.

Not quite right?

Make it yours.

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

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset120 rows20 columns
Yours10,000 rows20 columnslocation_name: UK only

blueprint · agri-food-blockchain-traceability-log

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 20 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 must represent a unique supply chain event (harvest, transport, processing, delivery, recall)
  • Include timestamp, location, product batch ID, and responsible party for each event
  • Log must indicate whether the event has a verified blockchain hash
  • Flag events with missing verification or compliance data
  • Traceability must support multi-level product aggregation (e.g., lots into shipments)
Rows
Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports
CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence
yours to use, including commercially
API slug
agri-food-blockchain-traceability-log

What should your data show?

Preview 20 rows free
No signup. No card.