Education
20 columns
68 rows
8 formats

School Meal Supply Chain Losses

This dataset provides detailed records of food waste and inefficiencies in school cafeteria meal supply chains, including loss types, quantities, costs, and corrective actions. It enables administrators and analysts to identify breakdowns, optimize food delivery processes, and implement sustainability initiatives for cost-effective school meal programs.

last updated 26 Oct 2025
by GoMask

The brief that made it

Pinpointing and reducing food waste in school meal programs

Sample rows

preview · 8 of 68 rows · all 20 columns

loss_idstring	loss_typestring	loss_quantityfloat	is_recurringboolean	school_idstring	school_namestring	school_address_streetstring	school_address_citystring	school_address_statestring	school_address_postal_codestring	school_address_countrystring	date_reporteddate	meal_typestring	supply_chain_stagestring	loss_costfloat	reported_bystring	corrective_action_takenstring	preventive_action_suggestedstring	recurrence_countinteger	cause_descriptionstring
L-1001	overproduction	15.8	true	SCH-001	Greenfield Elementary	125 Maple St	Springfield	IL	62704	USA	2024-03-12	lunch	preparation	98.6	jsmith	Adjusted forecasting method for future lunches.	Implement digital attendance tracking.	2	Too many meals prepared due to incorrect attendance forecast.
L-1002	spoilage	6.1	false	SCH-002	Lincoln Middle School	210 Lincoln Ave	Madison	WI	53703	USA	2024-02-28	breakfast	storage	45.3	acarter	Repaired fridge.	Install temperature monitoring system.	0	Milk cartons expired due to refrigeration failure.
L-1003	spillage	3.5	false	SCH-003	Oakridge High School	300 Oakridge Dr	Columbus	OH	43215	USA	2024-04-04	lunch	serving	29.1	bmartinez	Staff retrained on tray handling.	Introduce spill-proof trays.	0	Soup spilled during serving due to unsteady tray.
L-1004	delivery_delay	2	false	SCH-004	Riverbend Primary	500 Riverbend Rd	Portland	OR	97229	USA	2024-03-17	snack	transportation	14.5	dlee	Adjusted delivery route.	Monitor traffic reports.	0	Delivery truck delayed by road construction.
L-1005	contamination	8.2	true	SCH-001	Greenfield Elementary	125 Maple St	Springfield	IL	62704	USA	2024-04-10	lunch	preparation	52.4	jsmith	Staff retrained on washing protocols.	Use vegetable sanitizer.	1	Salad contaminated due to improper washing.
L-1006	expired	4.9	false	SCH-005	Sunset Elementary	80 Sunset Blvd	Tallahassee	FL	32301	USA	2024-03-05	breakfast	procurement	31	hroberts	Contacted supplier for fresher stock.	Order smaller batch sizes.	0	Eggs expired before use.
L-1007	spoilage	10.7	true	SCH-006	Maple Leaf Academy	60 Maple Leaf Ln	Toronto	ON	M6H 2T1	Canada	2024-02-20	lunch	storage	84.5	kpatel	Fridge maintenance scheduled.	Install automated temperature logs.	3	Meat not stored at correct temperature.
L-1008	overproduction	12	true	SCH-003	Oakridge High School	300 Oakridge Dr	Columbus	OH	43215	USA	2024-03-25	lunch	serving	72.2	bmartinez	Reduced production estimates.	Collect daily meal signups.	1	Fewer students attended than expected.
L-1009	spillage	1.2	false	SCH-007	Lakeside School	400 Lakeview Ave	Cleveland	OH	44108	USA	2024-04-01	snack	transportation	8.9	tnguyen	Used sturdier boxes.	Check packaging before transit.	0	Fruit cups spilled during delivery.
L-1010	spoilage	5.7	false	SCH-008	Hilltop Primary	720 Hilltop Rd	Vancouver	BC	V5K 1B7	Canada	2024-03-14	dinner	preparation	40.1	lchen	Prepared meals earlier.	Schedule timely meal prep.	0	Vegetables spoiled due to late preparation.
L-1011	expired	7.4	true	SCH-009	Prairie View Middle	110 Prairie View Dr	Winnipeg	MB	R3B 2K1	Canada	2024-02-27	lunch	storage	55.8	jwilson	Adjusted delivery schedule.	Monitor stock expiry dates.	2	Bread expired before use.
L-1012	contamination	2.6	true	SCH-010	Cedar Grove School	900 Cedar Grove Ln	Atlanta	GA	30318	USA	2024-03-29	lunch	serving	20.3	fwhite	Staff retrained on allergy protocols.	Separate utensils for allergens.	1	Cross-contamination with peanuts.
L-1013	delivery_delay	3.2	false	SCH-011	Northview Elementary	130 Northview St	Birmingham	AL	35209	USA	2024-03-21	breakfast	procurement	19.8	mgarcia	Found alternative supplier.	Diversify vendors.	0	Supplier delayed due to weather.
L-1014	spoilage	1.9	false	SCH-012	Starlight Academy	222 Starlight Ave	San Diego	CA	92115	USA	2024-02-16	snack	storage	12.9	jyoung	Reviewed storage protocols.	Staff refresher training.	0	Yogurt expired due to improper storage.
L-1015	overproduction	9.6	true	SCH-002	Lincoln Middle School	210 Lincoln Ave	Madison	WI	53703	USA	2024-04-05	lunch	preparation	66.7	acarter	Checked field trip confirmations before prep.	Improve communication between admin and kitchen.	2	Extra meals made for field trip that was canceled.
L-1016	spillage	2.7	false	SCH-013	Pinecrest School	400 Pinecrest Dr	Denver	CO	80204	USA	2024-04-09	dinner	serving	22.2	sanders	Supervised serving area.	Install spill mats.	0	Juice spilled by student.
L-1017	expired	5.5	true	SCH-005	Sunset Elementary	80 Sunset Blvd	Tallahassee	FL	32301	USA	2024-03-30	lunch	procurement	36.2	hroberts	Returned spoiled produce.	Require expiry dates on delivery notes.	1	Produce delivered past expiry.
L-1018	spoilage	3.3	false	SCH-014	River Valley School	170 River Valley Rd	Edmonton	AB	T5J 1G1	Canada	2024-02-14	snack	storage	24	eclark	Installed dehumidifier.	Monitor humidity regularly.	0	Crackers spoiled due to humidity.
L-1019	delivery_delay	6	true	SCH-006	Maple Leaf Academy	60 Maple Leaf Ln	Toronto	ON	M6H 2T1	Canada	2024-03-20	lunch	transportation	51.6	kpatel	Replaced delivery van.	Regular vehicle maintenance.	2	Meals arrived late due to vehicle breakdown.
L-1020	spillage	1.5	false	SCH-007	Lakeside School	400 Lakeview Ave	Cleveland	OH	44108	USA	2024-03-26	snack	serving	10.6	tnguyen	Supervised serving line.	Use smaller cartons.	0	Chocolate milk spilled by student.

What the 68 rows show

from the 68-row sample

Overproduction (loss type) stands out: mean loss_quantity is 8.6, against 4.6 for the rest.

44%is_recurring = true
4.7median loss_quantity
2school address countries
4meal types
6supply chain stages
26.0median loss_cost

Mean loss_quantity by loss_type68 rows

loss_quantity68 rows, in bands of 2

Median 4.7, from 1.0 to 15.8.

school_id68 rows · top 10 of 30 values

SCH-0013
SCH-0023
SCH-0053
SCH-0063
SCH-0103
SCH-0123
SCH-0143
SCH-1283
SCH-2013
SCH-0032

20 columns by typefrom the column list below

string 15
integer 1
float 2
date 1
boolean 1

Columns

20 columns in four groups

blueprint · 20 columns
column	type	description	example
Text 15 columns
`loss_id`	string	Unique identifier for each recorded supply chain loss eventunique	L-1001
`school_id`	string	Unique identifier for the school where the loss occurred	SCH-001
`school_name`	string	Name of the school where the loss occurred	Greenfield Elementary
`school_address_street`	string	Street address of the school	125 Maple St
`school_address_city`	string	City where the school is located	Springfield
`school_address_state`	string	State or province where the school is located	IL
`school_address_postal_code`	string	Postal code of the school's address	62704
`school_address_country`	string	Country where the school is located2 countries	USA
`meal_type`	string	Type of meal affected (e.g., breakfast, lunch, snack)breakfast · lunch · snack · dinner · other	lunch
`supply_chain_stage`	string	Stage in the supply chain where the loss occurred6 values	preparation
`loss_type`	string	Type of loss (e.g., spoilage, overproduction, spillage, delivery delay)7 values	overproduction
`reported_by`	string	Name or identifier of the staff member who reported the loss	jsmith
`cause_description`	string	Detailed description of the cause or circumstances of the lossoptional	Eggs expired before use.
`corrective_action_taken`	string	Description of any corrective action taken to address the lossoptional	Repaired fridge.
`preventive_action_suggested`	string	Suggested preventive action to avoid similar losses in the futureoptional	Monitor traffic reports.
Numbers 3 columns
`loss_quantity`	float	Amount of food lost (in kilograms)0 or more	15.8
`loss_cost`	float	Estimated monetary cost of the loss (in local currency)0 or more · optional	98.6
`recurrence_count`	integer	Number of times this type of loss has occurred at this school in the past year0 or more · optional	2
Dates and times 1 column
`date_reported`	date	Date when the supply chain loss was reported	2024-03-12
True or false 1 column
`is_recurring`	boolean	Indicates if this type of loss has occurred previously at this schooloptional	true

Use it for

An education dashboard
The is_recurring rate, loss_quantity by loss_type and a breakdown of school_id. Excel, Power BI or Tableau.
Why do the 11 overproduction rows have a mean loss_quantity of 8.6?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Losses68
L-100115.8overprod…
L-10026.1spoilage
L-10058.2contamin…
A software demo
Believable losses with school_id, school_name and school_address_street to fill a screen in front of a buyer.

This dataset68 rows20 columns

Yours1,000 rows20 columnsschool_address_street: UK only

blueprint · school-meal-supply-chain-losses

Behind this dataset

Same schema. As many rows as you need.

These 68 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 represents a single delivery event from supplier to school cafeteria.
Include columns for item type, quantity ordered, quantity delivered, loss reason, and delay status.
Capture both perishable and non-perishable items.
Record estimated monetary value of losses per event.
Document mitigation actions (if any) for each loss event.

Rows1,000 rows10,000 rows100,000 rows1,000,000 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: school-meal-supply-chain-losses

What should your data show?

No signup. No card.

Sample rows

What the 68 rows show

Columns

Use it for

An education dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Education

What should your data show?