Food Supply Chain Traceability

This dataset provides comprehensive traceability records for food items as they move from origin to retail, including batch identifiers, location history, certification, and recall status. It enables robust compliance checks, supply chain transparency, and rapid response to safety incidents, making it invaluable for food safety, regulatory reporting, and operational analytics.

  • opened 8 times
  • last updated 21 Aug 2025
  • by GoMask
The brief that made it

Regulatory compliance and reporting for food safety

Sample rows

preview · 8 of 200 rows · all 37 columns
trace_idstringcertification_typestringquantityfloatrecall_flagbooleanretail_location_countrystringitem_idstringitem_namestringitem_categorystringorigin_typestringorigin_namestringorigin_street_addressstringorigin_citystringorigin_statestringorigin_postal_codestringorigin_countrystringproduction_datedatebatch_numberstringunitstringcurrent_location_typestringcurrent_location_namestringcurrent_location_street_addressstringcurrent_location_citystringcurrent_location_statestringcurrent_location_postal_codestringcurrent_location_countrystringarrival_datedatedeparture_datedateretail_location_namestringretail_location_street_addressstringretail_location_citystringretail_location_statestringretail_location_postal_codestringretail_arrival_datedateexpiration_datedatecertification_numberstringlast_updateddatetimerecall_reasonstring
TRC20240001organic520.4falseUSAAPL-101Gala ApplesproducefarmSun Valley Orchards1200 Orchard LaneYakimaWA98901USA2024-03-04FRM-WA-20240304kgwarehouseFreshProduce Distribution Hub890 Market StSeattleWA98107USA2024-03-062024-03-10Healthy Foods Supermarket1567 Pine AveSeattleWA981012024-03-122024-04-02ORG-9402012024-03-13T09:01:28blank
TRC20240002HACCP950.8falseUSAMLK-203Whole MilkdairymanufacturerDairyGold Foods Inc.122 Dairy DriveFresnoCA93706USA2024-02-27MFG-CA-20240227-AG01litersdistributorGolden State Distribution2000 Commerce StSan JoseCA95131USA2024-02-282024-03-03Bay Area Grocers3507 Monterey BlvdSan JoseCA951172024-03-042024-03-21HCP-3842002024-03-04T14:44:02blank
TRC20240003ISO 22000120falseSwitzerlandCHS-301Swiss Cheese WheelsdairymanufacturerSwiss Gourmet AG18 KäseplatzBernBern3011Switzerland2024-01-20MFG-Bern-20240120-SWZkgwarehouseEuroCheese Import Warehouse4100 Importer WayGenevaGeneva1201Switzerland2024-01-232024-02-10Gourmet Delights Market28 Rue de FranceGenevaGeneva12022024-02-122024-08-20ISO-22000-0052024-02-13T17:51:10blank
TRC20240004MSC1320.7falseCanadaTRT-450Atlantic Trout FilletsseafoodfisheryNorth Atlantic Fisheries210 Harbor RoadHalifaxNSB3H 1R6Canada2023-12-13FSH-NS-20231213kgwarehouseMaritime Seafood Storage163 Ocean Park BlvdHalifaxNSB3H 2J7Canada2023-12-142023-12-20Atlantic Fish Market812 Water StHalifaxNSB3H 4K22023-12-232024-03-05MSC-4210982023-12-24T10:35:44blank
TRC20240005organic800.2falseUSABNN-102Organic BananasproducefarmGreen Valley Farms1300 Banana Grove RdHomesteadFL33030USA2024-03-12FRM-FL-20240312kgdistributorSunshine Produce Distributors501 Citrus BlvdMiamiFL33101USA2024-03-142024-03-16South Florida Market1121 Ocean AveMiamiFL331392024-03-172024-04-04ORG-1043222024-03-18T08:50:17blank
TRC20240006HACCP210.5falseUSABTR-880Salted ButterdairymanufacturerCreamy Farms Ltd.221 Creamery RdMadisonWI53703USA2024-02-17MFG-WI-20240217-BTRkgwarehouseMidwest Dairy Storage1450 Dairy LaneMilwaukeeWI53202USA2024-02-182024-03-01Great Lakes Market2901 Lake StMilwaukeeWI532122024-03-032024-05-05HCP-5512342024-03-04T16:21:03blank
TRC20240007ISO 220001200falseItalyBRC-111Whole Wheat BreadbakerymanufacturerBaker's Choice Ltd.800 Bakery LaneNaplesCampania80100Italy2024-02-07MFG-CAMP-20240207-BRCpiecestransporterEuroLogistics34 Via MilanoNaplesCampania80122Italy2024-02-082024-02-10Napoli Supermercato40 Via RomaNaplesCampania801282024-02-112024-02-23ISO-22000-0112024-02-11T18:45:56blank
TRC20240008organic800falseUSAEGG-210Free Range EggsproducefarmSunny Hen Ranch350 Farm RoadAustinTX78732USA2024-03-01FRM-TX-20240301-EGGpieceswarehouseTexas Fresh Food Storage2000 Storage DrDallasTX75201USA2024-03-032024-03-06Hill Country Market4001 River BlvdAustinTX787042024-03-082024-03-24ORG-2108752024-03-09T07:12:37blank

What the 200 rows show

from the 200-row sample

MSC (certification type) stands out: mean quantity is 10,654, against 2,461 for the rest.

  • 3%recall_flag = true
  • 1,063median quantity
  • 3current location types
  • 5origin types
  • 6units
  • 8item categories
Mean quantity by certification_type180 rows
010k20k933.4organic76 rows4,333ISO 2200056 rows2,823HACCP31 rows10,654MSC17 rows
quantity200 rows, in bands of 5,000
085170169127435015k30kquantity →

Median 1,063, from 0.12 to 30,000.

retail_location_country183 rows with a value · 17 left blank
  1. USA106
  2. Switzerland17
  3. Italy16
  4. Australia16
  5. Singapore8
  6. Canada7
  7. Greece7
  8. France2
  9. Austria1
  10. Denmark1
37 columns by typefrom the column list below
  • string 29
  • float 1
  • date 5
  • datetime 1
  • boolean 1

Columns

37 columns in four groups
blueprint · 37 columns
columntypedescriptionexample
Text 29 columns
trace_idstringUnique identifier for each traceability record of a food item through the supply chain.uniqueTRC20240001
item_idstringUnique identifier for the food item or batch being tracked.APL-101
item_namestringCommon or commercial name of the food item.Gala Apples
item_categorystringCategory of the food item (e.g., produce, dairy, meat, seafood, packaged goods).8 valuesproduce
origin_typestringType of source where the food item originated (e.g., farm, fishery, manufacturer).6 valuesfarm
origin_namestringName of the source entity (e.g., farm name, manufacturer name).Sun Valley Orchards
origin_street_addressstringStreet address of the source entity.optional1200 Orchard Lane
origin_citystringCity of the source entity.optionalYakima
origin_statestringState or region of the source entity.optionalWA
origin_postal_codestringPostal code of the source entity.optional98901
origin_countrystringCountry of the source entity.12 countriesUSA
batch_numberstringBatch or lot number assigned to the food item for traceability.FRM-WA-20240304
unitstringUnit of measurement for the quantity (e.g., kg, lbs, liters, pieces).7 valueskg
current_location_typestringType of entity currently handling the item (e.g., processor, distributor, warehouse, retailer).6 valueswarehouse
current_location_namestringName of the current entity handling the item.Maritime Seafood Storage
current_location_street_addressstringStreet address of the current entity.optional890 Market St
current_location_citystringCity of the current entity.optionalSeattle
current_location_statestringState or region of the current entity.optionalWA
current_location_postal_codestringPostal code of the current entity.optional98107
current_location_countrystringCountry of the current entity.12 countriesUSA
retail_location_namestringName of the retail location where the item is sold (if applicable).optionalBay Area Grocers
retail_location_street_addressstringStreet address of the retail location.optional1567 Pine Ave
retail_location_citystringCity of the retail location.optionalSeattle
retail_location_statestringState or region of the retail location.optionalWA
retail_location_postal_codestringPostal code of the retail location.optional98101
retail_location_countrystringCountry of the retail location.12 countries · optionalUSA
recall_reasonstringReason for recall, if applicable.optionalPossible contamination de…
certification_typestringType of food safety or quality certification (e.g., organic, HACCP, ISO).4 types · optionalorganic
certification_numberstringCertification number or code.optionalORG-940201
Numbers 1 column
quantityfloatQuantity of the food item in the batch (in standardized units).0 or more520.4
Dates and times 6 columns
production_datedateDate the food item was produced, harvested, or manufactured.2024-03-04
arrival_datedateDate the food item arrived at the current location.2024-03-06
departure_datedateDate the food item departed from the current location (if applicable).optional2024-03-10
retail_arrival_datedateDate the food item arrived at the retail location.optional2024-03-12
expiration_datedateExpiration or best-before date of the food item.optional2024-04-02
last_updateddatetimeTimestamp of the last update to this traceability record.2024-03-13T09:01:28
True or false 1 column
recall_flagbooleanIndicates if the food item/batch is subject to a recall.false

Use it for

  • recall flag3%5 of 200 rowsmean quantity by cert…933.4orga…4.3kISO …2.8kHACCP10.7kMSC

    A logistics dashboard

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

  • Why do the 17 MSC rows have a mean quantity of 10,654?

    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 traces with item_id, item_name and item_category to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 37 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 dataset200 rows37 columns
Yours1,000 rows37 columnsorigin_street_address: UK only

blueprint · food-supply-chain-traceability

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 37 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
  • Stage: farm, processing, transport, retail
  • Unique batch ID assigned per item
  • Temperature logged at each stage
  • Timestamp progression strictly chronological
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
food-supply-chain-traceability

More in Logistics

Browse all
Also in LogisticsGaming Merchandise Supply Chain LogsWarehouse Inventory Flow DatasetPharmaceutical Inventory Supply ChainsAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.