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.
Sample rows
preview · 8 of 120 rows · all 20 columns| event_idstring | unit_of_measurestring | quantityfloat | location_citystring | product_idstring | batch_idstring | event_typestring | timestampdatetime | actor_idstring | actor_rolestring | location_namestring | location_street_addressstring | location_statestring | location_postal_codestring | location_countrystring | certification_typestring | certification_idstring | previous_event_idstring | blockchain_tx_hashstring | event_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EVT-harvest-001A | kg | 980.5 | Yakima | PROD-APPLE-2024A | BATCH-APPLE-20240601-A | harvest | 2024-06-01T08:21:00-07:00 | ACT-farmer-001 | farmer | Yakima Valley Orchard | 124 Orchard Rd | WA | 98901 | USA | organic | ORG-USA-2024-0001 | blank | a1b2c3d4e5f60123456789abcdef0123456789abcdef0123456789abcdef0123 | Harvest completed with optimal weather, organic standards met. |
| EVT-processing-001A | kg | 945.2 | Yakima | PROD-APPLE-2024A | BATCH-APPLE-20240601-A | processing | 2024-06-01T12:15:00-07:00 | ACT-processor-004 | processor | Yakima Fruit Processing | 212 Packing Ln | WA | 98902 | USA | iso | ISO-9001-USA-2024-0002 | EVT-harvest-001A | b2c3d4e5f60123456789abcdef0123456789abcdef0123456789abcdef0123a1 | Processing under ISO9001 standards; minor bruising detected. |
| EVT-packaging-001A | cases | 900 | Yakima | PROD-APPLE-2024A | BATCH-APPLE-20240601-A | packaging | 2024-06-01T15:36:00-07:00 | ACT-processor-004 | processor | Yakima Packing Facility | 212 Packing Ln | WA | 98902 | USA | iso | ISO-9001-USA-2024-0003 | EVT-processing-001A | c3d4e5f60123456789abcdef0123456789abcdef0123456789abcdef0123a1b2 | Packaged in cases, post-inspection for quality. |
| EVT-transport-001A | cases | 900 | Yakima | PROD-APPLE-2024A | BATCH-APPLE-20240601-A | transport | 2024-06-01T18:10:00-07:00 | ACT-transporter-001 | transporter | Yakima Distribution Hub | 500 Logistics Pkwy | WA | 98903 | USA | none | blank | EVT-packaging-001A | d4e5f60123456789abcdef0123456789abcdef0123456789abcdef0123a1b2c3 | Loaded for transport to Seattle warehouse. |
| EVT-inspection-001A | blank | blank | Seattle | PROD-APPLE-2024A | BATCH-APPLE-20240601-A | inspection | 2024-06-02T08:00:00-07:00 | ACT-inspector-001 | inspector | Seattle Distribution Center | 1200 Distribution Ave | WA | 98101 | USA | gap | GAP-USA-WA-2024-0001 | EVT-transport-001A | e5f60123456789abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4 | Inspection passed, GAP compliance verified. |
| EVT-harvest-002B | tons | 13.5 | Santos | PROD-COFFEE-2024B | BATCH-COFFEE-20240602-B | harvest | 2024-06-02T06:12:00-03:00 | ACT-farmer-002 | farmer | Santos Coffee Cooperative | 35 Fazenda Rd | SP | 11000-010 | Brazil | fair_trade | FT-2024-Brazil-SP-0021 | blank | f60123456789abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5 | Hand-picked beans, fair trade certified. |
| EVT-processing-002B | tons | 12.9 | Santos | PROD-COFFEE-2024B | BATCH-COFFEE-20240602-B | processing | 2024-06-02T10:30:00-03:00 | ACT-processor-010 | processor | Santos Coffee Mill | 35 Fazenda Rd | SP | 11000-010 | Brazil | gap | GAP-Brazil-SP-2024-0012 | EVT-harvest-002B | 123456789abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f6 | Wet mill processing, GAP standards met. |
| EVT-packaging-002B | tons | 12.6 | Santos | PROD-COFFEE-2024B | BATCH-COFFEE-20240602-B | packaging | 2024-06-02T13:45:00-03:00 | ACT-processor-010 | processor | Santos Coffee Mill | 35 Fazenda Rd | SP | 11000-010 | Brazil | fair_trade | FT-2024-Brazil-SP-0022 | EVT-processing-002B | 23456789abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f601 | Packaged in sacks, fair trade label applied. |
| EVT-inspection-002B | blank | blank | Santos | PROD-COFFEE-2024B | BATCH-COFFEE-20240602-B | inspection | 2024-06-02T16:00:00-03:00 | ACT-inspector-005 | inspector | Port of Santos Inspection | blank | SP | blank | Brazil | gap | GAP-Brazil-SP-2024-0013 | EVT-packaging-002B | 3456789abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f6012 | Inspection passed, ready for export. |
| EVT-harvest-003C | tons | 4.7 | Salinas | PROD-LETTUCE-2024C | BATCH-LETTUCE-20240603-C | harvest | 2024-06-03T07:05:00-07:00 | ACT-farmer-005 | farmer | Salinas Valley Farm | 77 Valley Rd | CA | 93901 | USA | organic | ORG-USA-2024-0033 | blank | 456789abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f60123 | Harvested early morning for freshness. |
| EVT-packaging-003C | cases | 700 | Salinas | PROD-LETTUCE-2024C | BATCH-LETTUCE-20240603-C | packaging | 2024-06-03T10:03:00-07:00 | ACT-processor-014 | processor | Salinas Valley Packing | 77 Valley Rd | CA | 93901 | USA | iso | ISO-22000-USA-2024-0033 | EVT-harvest-003C | 56789abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f601234 | Packaged for retail distribution, ISO certified. |
| EVT-transport-003C | cases | 700 | Salinas | PROD-LETTUCE-2024C | BATCH-LETTUCE-20240603-C | transport | 2024-06-03T14:30:00-07:00 | ACT-transporter-007 | transporter | Salinas Logistics Hub | 99 Transport Ave | CA | 93905 | USA | none | blank | EVT-packaging-003C | 6789abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f6012345 | Transport to Bay Area distributor scheduled. |
| EVT-recall-003C | blank | blank | San Francisco | PROD-LETTUCE-2024C | BATCH-LETTUCE-20240603-C | recall | 2024-06-03T18:00:00-07:00 | ACT-distributor-003 | distributor | Bay Area Distribution | 3200 Market St | CA | 94103 | USA | none | blank | EVT-transport-003C | 789abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f60123456 | Recall initiated due to cold chain breach. |
| EVT-harvest-004D | tons | 19.8 | Wagga Wagga | PROD-WHEAT-2024D | BATCH-WHEAT-20240604-D | harvest | 2024-06-04T06:00:00+10:00 | ACT-farmer-008 | farmer | Riverina Plains Farm | 184 Main Hwy | NSW | 2650 | Australia | gap | GAP-Australia-NSW-2024-0024 | blank | 89abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f601234567 | Harvested using mechanical combine, GAP standards. |
| EVT-inspection-004D | blank | blank | Wagga Wagga | PROD-WHEAT-2024D | BATCH-WHEAT-20240604-D | inspection | 2024-06-04T09:15:00+10:00 | ACT-inspector-009 | inspector | Riverina Storage Facility | 184 Main Hwy | NSW | 2650 | Australia | gap | GAP-Australia-NSW-2024-0025 | EVT-harvest-004D | 9abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f6012345678 | Inspection for pest/disease passed. |
| EVT-harvest-005E | units | 7900 | Davao City | PROD-BANANA-2024E | BATCH-BANANA-20240605-E | harvest | 2024-06-05T09:10:00+08:00 | ACT-farmer-012 | farmer | Davao Banana Plantation | 12 Plantation Rd | Davao del Sur | 8000 | Philippines | organic | ORG-Philippines-2024-0123 | blank | abcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f60123456789 | Harvested under organic cultivation practices. |
| EVT-storage-005E | units | 7800 | Davao City | PROD-BANANA-2024E | BATCH-BANANA-20240605-E | storage | 2024-06-05T13:20:00+08:00 | ACT-warehouse-001 | warehouse | Davao Cold Storage | 14 Storage Ave | Davao del Sur | 8000 | Philippines | none | blank | EVT-harvest-005E | bcdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f60123456789a | Stored in cold room at optimal humidity. |
| EVT-harvest-006F | kg | 11240 | Amritsar | PROD-RICE-2024F | BATCH-RICE-20240606-F | harvest | 2024-06-06T08:05:00+05:30 | ACT-farmer-017 | farmer | Punjab Rice Fields | 56 Green Rd | Punjab | 143001 | India | gap | GAP-India-Punjab-2024-0017 | blank | cdef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f60123456789ab | Monsoon delayed, harvest yield moderate. |
| EVT-inspection-006F | blank | blank | Amritsar | PROD-RICE-2024F | BATCH-RICE-20240606-F | inspection | 2024-06-06T11:15:00+05:30 | ACT-inspector-014 | inspector | Punjab Rice Storage | 56 Green Rd | Punjab | 143001 | India | gap | GAP-India-Punjab-2024-0018 | EVT-harvest-006F | def0123456789abcdef0123456789abcdef0123a1b2c3d4e5f60123456789abc | Inspection for moisture content and pest control passed. |
| EVT-harvest-007G | units | 8900 | Seville | PROD-ORANGE-2024G | BATCH-ORANGE-20240607-G | harvest | 2024-06-07T08:20:00+01:00 | ACT-farmer-020 | farmer | Seville Citrus Farm | 22 Grove St | Andalusia | 41001 | UK | iso | ISO-22000-UK-2024-0101 | blank | ef0123456789abcdef0123456789abcdef0123a1b2c3d4e5f60123456789abcd | Harvested at peak ripeness, ISO certified. |
What the 120 rows show
from the 120-row sample- 820.0median quantity
- 5certification types
- 7actor roles
- 8event types
- 8location countries
- 21location states
Median 820.0, from 0.0 to 100,000,000.
- string 18
- float 1
- datetime 1
Columns
20 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 18 columns | |||
event_id | string | Unique identifier for each blockchain traceability eventunique | EVT-harvest-001A |
product_id | string | Unique identifier for the agricultural product being tracked | PROD-APPLE-2024A |
batch_id | string | Identifier for the product batch (lot number) | BATCH-APPLE-20240601-A |
event_type | string | Type of supply chain event (e.g., harvest, processing, transport, inspection, delivery)9 values | harvest |
actor_id | string | Unique identifier for the organization or individual responsible for the event | ACT-farmer-001 |
actor_role | string | Role of the actor in the supply chain (e.g., farmer, processor, transporter, inspector, retailer)8 values | farmer |
location_name | string | Name or description of the location where the event occurred | Yakima Valley Orchard |
location_street_address | string | Street address of the event locationoptional | 124 Orchard Rd |
location_city | string | City where the event took placeoptional | Yakima |
location_state | string | State or province of the event locationoptional | WA |
location_postal_code | string | Postal code of the event locationoptional | 98901 |
location_country | string | Country where the event occurred8 countries | USA |
unit_of_measure | string | Unit of measure for the quantity (e.g., kg, tons, liters, units)6 values · optional | kg |
certification_type | string | Type of certification or compliance relevant to the event (e.g., organic, fair trade, GAP, ISO)organic · fair_trade · gap · iso · none · optional | organic |
certification_id | string | Identifier for the certification document or recordoptional | ORG-USA-2024-0001 |
blockchain_tx_hash | string | Hash of the blockchain transaction recording this eventunique | a1b2c3d4e5f60123456789abc… |
previous_event_id | string | Reference to the previous event in the product's traceability chainoptional | EVT-harvest-001A |
event_notes | string | Additional notes or comments about the eventoptional | Harvest completed with op… |
| Numbers 1 column | |||
quantity | float | Quantity of product involved in the event (in standardized units)0 or more · optional | 980.5 |
| Dates and times 1 column | |||
timestamp | datetime | Date and time when the event was recorded on the blockchain | 2024-06-09T09:00:00Z |
Use it for
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.
- Events120EVT-harvest-001A980.5kgEVT-processing-001A945.2kgEVT-packaging-001A900cases
A software demo
Believable events with product_
id, batch_ id and event_ type to fill a screen in front of a buyer.
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.
- 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)
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