Agriculture
31 columns
126 rows
8 formats

Agricultural Product Traceability Records

This dataset provides end-to-end traceability for agricultural products, capturing detailed records from farm origin, harvest, and processing, to final delivery. It supports compliance, safety, and sustainability reporting, making it invaluable for agtech startups and local farms seeking transparency and optimization in fresh produce supply chains.

last updated 4 Dec 2025
by GoMask

The brief that made it

End-to-end product traceability for food safety and recalls

Sample rows

preview · 8 of 126 rows · all 31 columns

traceability_idstring	certification_typestring	sustainability_scorefloat	farm_countrystring	product_namestring	crop_typestring	batch_numberstring	farm_idstring	farm_namestring	farm_street_addressstring	farm_citystring	farm_statestring	farm_postal_codestring	harvest_datedate	quantity_harvestedfloat	certification_idstring	processor_idstring	processor_namestring	processing_datedate	destination_idstring	destination_namestring	destination_street_addressstring	destination_citystring	destination_statestring	destination_postal_codestring	destination_countrystring	delivery_datedate	transportation_modestring	transportation_companystring	compliance_statusstring	notesstring
TRC-1A3B9C2D	Organic	92.5	USA	Roma Tomato	Solanum lycopersicum	RT2024-001	FRM-8XQ4WZ01	Sunny Acres Farm	1500 Maple Drive	Woodland	CA	95695	2024-05-05	340.2	ORG-CA-0001	PROC-1234A78	FreshPack Foods	2024-05-06	DST-9F2A4XJ0	Green Market Grocers	725 Pine Lane	Fresno	CA	93722	USA	2024-05-10	Truck	AgriHaul Express	Compliant	blank
TRC-2B4C8D1E	Fair Trade	74.1	India	Basmati Rice	Oryza sativa	BR2024-011	FRM-5JH3VQ12	Royal Fields Estate	22 Canal Road	Karnal	HR	132001	2024-04-25	4300	FT-IN-5412	blank	blank	blank	DST-2K8L4ZQ2	Global Rice Imports	44 Riverfront Ave	Mumbai	MH	400023	India	2024-05-05	Ship	Oceanic Freight	Compliant	blank
TRC-3C5D7E2F	GAP	88.2	USA	Blueberry	Vaccinium corymbosum	BB2024-009	FRM-2FD7TQ99	Riverbend Farms	889 Orchard Way	Blaine	WA	98230	2024-05-15	305.8	GAP-US-1003	PROC-9221FG8	BerryFresh Co.	2024-05-16	DST-3J6M2R7L	Sunrise Foods Distribution	910 Harvest St	Seattle	WA	98108	USA	2024-05-18	Truck	Northwest Logistics	Compliant	blank
TRC-4D6E8F3A	Organic	76.4	Peru	Quinoa	Chenopodium quinoa	QN2024-031	FRM-3LW6BZ21	Andes Valley Agro	1045 Vista Grande	Cusco	CU	08002	2024-03-20	5700.6	ORG-PE-1100	blank	blank	blank	DST-4V7S9FQ2	Healthy Choice Markets	1200 Market Sq	Lima	LI	15046	Peru	2024-03-29	Rail	Peru Rail Freight	Compliant	blank
TRC-5E7F9A4B	Organic	96.9	USA	Purple Carrot	Daucus carota	PC2024-015	FRM-4AQ8JK32	Rainbow Roots Farm	356 Willow Ave	Madison	WI	53703	2024-04-18	190.5	ORG-WI-0023	blank	blank	blank	DST-5T0K2P8R	Local Veggie Mart	47 Spruce Blvd	Milwaukee	WI	53202	USA	2024-04-22	Truck	Midwest Vegetable Movers	Compliant	blank
TRC-6F8A0B5C	Fair Trade	62	Ecuador	Green Banana	Musa acuminata	GB2024-008	FRM-5LE3HZ45	Tropical Fields Growers	29 Coastal Road	Machala	ECU	070201	2024-02-10	8010.3	FT-EC-2319	blank	blank	blank	DST-6G2M5V9K	Banana World Exporters	76 Port Street	Guayaquil	GU	090514	Ecuador	2024-02-18	Ship	Oceanic Freight	Compliant	blank
TRC-7G9B1C6D	GAP	71.8	USA	Golden Corn	Zea mays	GC2024-012	FRM-6RC2PW56	Cornfield Harvesters	810 Prairie Lane	Omaha	NE	68106	2024-07-11	980.7	GAP-NE-0056	PROC-5647GH2	Midwest Grain Processing	2024-07-12	DST-7P5K2H1T	Heartland Foods	1450 Corn St	Lincoln	NE	68502	USA	2024-07-18	Rail	Nebraska Rail Transit	Compliant	blank
TRC-8H0C2D7E	None	0	USA	Red Apple	Malus domestica	RA2024-004	FRM-7QM3XJ67	Apple Hill Orchards	123 Orchard Lane	Yakima	WA	98902	2024-09-10	0	blank	blank	blank	blank	DST-8F9Q1P3W	Yakima Fruit Coop	340 Apple Ave	Seattle	WA	98109	USA	2024-09-13	Truck	Northwest Logistics	Non-Compliant	Batch failed due to pest damage; no usable yield.
TRC-9I1D3E8F	GAP	63.2	USA	Green Peas	Pisum sativum	GP2024-003	FRM-8SN4LK78	Spring Meadows	554 Pea Lane	Davenport	IA	52806	2024-03-15	450.3	GAP-IA-0032	blank	blank	blank	DST-9H2M5Q1Z	Midwest Fresh Produce	61 Elm St	Des Moines	IA	50309	USA	2024-03-20	Truck	AgriHaul Express	Compliant	blank
TRC-0J2E4F9G	GAP	54.7	USA	Fingerling Potato	Solanum tuberosum	FP2024-020	FRM-9LK5TR89	Potato Ridge Farms	198 Tuber Trail	Boise	ID	83702	2024-06-12	1350.7	GAP-ID-0011	PROC-6742JH1	Idaho Potato Processors	2024-06-13	DST-0J8G6N2V	Mountain Grocery	321 Hilltop St	Salt Lake City	UT	84111	USA	2024-06-19	Rail	InterMountain Rail	Compliant	blank
TRC-1K3F5G0H	None	8.7	USA	White Onion	Allium cepa	WO2024-007	FRM-0ML6EN90	Onion Valley	2316 Valley Road	Merced	CA	95340	2024-07-05	5	blank	blank	blank	blank	DST-1V3M7B9T	Merced Wholesale	990 Onion Ave	Fresno	CA	93721	USA	2024-07-07	Truck	AgriHaul Express	Pending	Low yield due to excessive rainfall; pending review.
TRC-2L4G6H1I	Fair Trade	71.2	Mexico	Mango	Mangifera indica	MG2024-014	FRM-1NB7JQ11	Tropical Orchard	1123 Mango Lane	Mérida	YU	97000	2024-04-08	3200.9	FT-MX-3012	blank	blank	blank	DST-2L9Q2P3S	MexFruit Distributors	310 Avenida Central	Cancún	QR	77500	Mexico	2024-04-15	Ship	MexMaritime Cargo	Compliant	blank
TRC-3M5H7I2J	None	19.8	USA	Sunchoke	Helianthus tuberosus	SC2024-005	FRM-2PO8ZL22	Prairie Root Farm	785 Sunflower Rd	Tulsa	OK	74104	2024-03-06	104.2	blank	blank	blank	blank	DST-3K6J2M9L	Tulsa Farmers Coop	45 Sunchoke Blvd	Oklahoma City	OK	73120	USA	2024-03-10	Other	blank	Pending	Awaiting pesticide residue analysis.
TRC-4N6I8J3K	GAP	27.6	Belize	Sugarcane	Saccharum officinarum	SG2024-013	FRM-3US9PL33	Sweet Fields Estate	100 Cane Road	Belmopan	BZ	10105	2024-01-21	210.5	GAP-BZ-0017	blank	blank	blank	DST-4L8N2S3T	Belize Sugar Export	220 Export Lane	Belize City	BZ	10406	Belize	2024-01-28	Ship	Caribbean Cargo	Pending	Pending audit of water use.
TRC-5O7J9K4L	None	0	Philippines	Purple Yam	Dioscorea alata	PY2024-001	FRM-4QV0RM44	Highland Tubers	66 Tuber Terrace	Baguio	CAR	2600	2024-02-19	86.9	blank	blank	blank	blank	DST-5M2P8B6Q	Manila Tubers Export	103 Yam Street	Manila	NCR	1000	Philippines	2024-02-22	Air	PhilAir Cargo	Non-Compliant	Failed environmental compliance; batch rejected.
TRC-6P8K0L5M	Organic	82.3	Canada	Red Cabbage	Brassica oleracea	RC2024-018	FRM-5TR1BM55	Green Valley Farms	602 Cabbage Lane	Montreal	QC	H3B 2Y5	2024-06-21	410.6	ORG-CA-9901	PROC-8123MN5	Montreal Veg Processing	2024-06-22	DST-6G2N4Q8S	Canadian Farm Markets	255 Maple Ave	Toronto	ON	M5H 2N2	Canada	2024-06-29	Rail	Canadian Pacific Rail	Compliant	blank
TRC-7Q9L1M6N	Organic	91.1	USA	Yellow Bell Pepper	Capsicum annuum	YBP2024-022	FRM-6VS2JN66	Pepper Patch	345 Bell Blvd	San Diego	CA	92115	2024-08-18	295.2	ORG-CA-0032	blank	blank	blank	DST-7J9L2M3N	San Diego Fresh	1098 Market Road	Los Angeles	CA	90015	USA	2024-08-21	Truck	CalVeg Transport	Compliant	blank
TRC-8R0M2N7O	Fair Trade	65.1	Vietnam	Green Tea	Camellia sinensis	GT2024-006	FRM-7WK3MC77	Mountain Leaf Estate	234 Tea Garden	Da Lat	VT	670000	2024-03-29	3700.9	FT-VN-4402	PROC-9234VN6	Vietnam Tea Corp	2024-03-30	DST-8D9F3G4H	Asia Beverage Importers	900 Lotus Ave	Hanoi	HN	100000	Vietnam	2024-04-03	Ship	AsiaMaritime Group	Compliant	blank
TRC-9S1N3O8P	Organic	89.5	Peru	Asparagus	Asparagus officinalis	AS2024-010	FRM-8XP4AS88	Spring Shoots Farm	777 Green Road	Trujillo	LA	13001	2024-04-02	188.3	ORG-PE-1204	blank	blank	blank	DST-9G2F7H1J	Lima Agro Foods	421 Shoots Lane	Lima	LI	15047	Peru	2024-04-07	Rail	Peru Rail Freight	Compliant	blank
TRC-0T2O4P9Q	Organic	56.1	Mexico	Black Bean	Phaseolus vulgaris	BBN2024-003	FRM-9ZQ5BN99	Beanfield Collective	321 Bean Lane	Veracruz	VE	91700	2024-05-12	1550.4	ORG-MX-8842	PROC-5456MX8	MexBean Processors	2024-05-13	DST-0W9F6E3R	Mexican Food Distributors	1100 Black Bean Ave	Mexico City	DF	01020	Mexico	2024-05-17	Rail	MexRail Cargo	Compliant	blank

What the 126 rows show

from the 126-row sample

None (certification type) stands out: mean sustainability_score is 12.5, against 67.8 for the rest.

63.8median sustainability_score
3compliance statuses
5transportation modes
10destination countries
427.9median quantity_harvested

Mean sustainability_score by certification_type126 rows

sustainability_score126 rows, in bands of 10

Median 63.8, from 0.0 to 97.2.

farm_country126 rows · 10 values

USA58
India12
Canada12
Ecuador8
Mexico8
Peru7
Belize7
Vietnam6
Kenya5
Philippines3

31 columns by typefrom the column list below

string 26
float 2
date 3

Columns

31 columns in three groups

blueprint · 31 columns
column	type	description	example
Text 26 columns
`traceability_id`	string	Unique identifier for each traceability recordunique	TRC-1A3B9C2D
`product_name`	string	Common name of the agricultural product (e.g., Roma Tomato)	Roma Tomato
`crop_type`	string	Type or species of crop (e.g., Solanum lycopersicum)	Solanum lycopersicum
`batch_number`	string	Batch or lot number assigned by the farm or processor	RT2024-001
`farm_id`	string	Unique identifier for the originating farm	FRM-8XQ4WZ01
`farm_name`	string	Name of the farm where the crop was grown	Sunny Acres Farm
`farm_street_address`	string	Street address of the farm	1500 Maple Drive
`farm_city`	string	City where the farm is located	Woodland
`farm_state`	string	State or province where the farm is located	CA
`farm_postal_code`	string	Postal code of the farm	95695
`farm_country`	string	Country where the farm is located10 countries	USA
`certification_type`	string	Type of certification (e.g., Organic, GAP, Fair Trade)Organic · GAP · Fair Trade · None · optional	Organic
`certification_id`	string	Certification identifier or numberoptional	ORG-CA-0001
`processor_id`	string	Unique identifier for the processing facility (if applicable)optional	PROC-1234A78
`processor_name`	string	Name of the processing facility (if applicable)optional	FreshPack Foods
`destination_id`	string	Unique identifier for the delivery destination (e.g., retailer, distributor)	DST-9F2A4XJ0
`destination_name`	string	Name of the delivery destination	Green Market Grocers
`destination_street_address`	string	Street address of the delivery destination	725 Pine Lane
`destination_city`	string	City of the delivery destination	Fresno
`destination_state`	string	State or province of the delivery destination	CA
`destination_postal_code`	string	Postal code of the delivery destination	93722
`destination_country`	string	Country of the delivery destination10 countries	USA
`transportation_mode`	string	Mode of transportation used for delivery (e.g., Truck, Rail, Air)Truck · Rail · Air · Ship · Other	Truck
`transportation_company`	string	Name of the transportation companyoptional	AgriHaul Express
`compliance_status`	string	Compliance status for safety and regulatory requirementsCompliant · Non-Compliant · Pending	Compliant
`notes`	string	Additional notes or remarks about the traceability recordoptional	Batch failed due to pest …
Numbers 2 columns
`quantity_harvested`	float	Total quantity harvested (in kilograms)0 or more	340.2
`sustainability_score`	float	Score indicating sustainability practices (0-100 scale)0 to 100 · optional	92.5
Dates and times 3 columns
`harvest_date`	date	Date when the crop was harvested	2024-05-05
`processing_date`	date	Date when the crop was processed (if applicable)optional	2024-05-06
`delivery_date`	date	Date when the product was delivered to the destination	2024-05-10

Use it for

An agriculture dashboard
Sustainability_score by certification_type and a breakdown of farm_country. Excel, Power BI or Tableau.
Why do the 22 None rows have a mean sustainability_score of 12.5?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Traceabilities126
TRC-1A3B9C2D92.5Organic
TRC-2B4C8D1E74.1Fair Tra…
TRC-3C5D7E2F88.2GAP
A software demo
Believable traceabilities with product_name, crop_type and batch_number to fill a screen in front of a buyer.

This dataset126 rows31 columns

Yours1,000 rows31 columnsfarm_street_address: UK only

blueprint · agricultural-product-traceability-records

Behind this dataset

Same schema. As many rows as you need.

These 126 rows came out of a blueprint — 31 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 product batch must have a unique traceability identifier
Entries must include farm origin, transport checkpoints, and final destination
Cold chain status must be logged at each checkpoint
Compliance status reviewed for each batch before final delivery
Sustainability score assigned per batch based on farm practices

Rows1,000 rows10,000 rows100,000 rows1,000,000 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: agricultural-product-traceability-records

What should your data show?

No signup. No card.

Sample rows

What the 126 rows show

Columns

Use it for

An agriculture dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Agriculture

What should your data show?