Logistics
28 columns
110 rows
8 formats

Nonprofit Supply Chain Tracking Metrics

This dataset provides end-to-end tracking metrics for nonprofit supply chain operations, detailing every shipment of donated goods, partner performance, and environmental impact. It enables organizations to identify bottlenecks, monitor lead times, prevent stockouts, and optimize donation utilization, supporting data-driven decision-making and operational efficiency.

last updated 4 Dec 2025
by GoMask

The brief that made it

Monitor and optimize nonprofit supply chain operations

Sample rows

preview · 8 of 110 rows · all 28 columns

shipment_idstring	shipment_statusstring	utilization_ratefloat	stockout_flagboolean	partner_namestring	donation_idstring	donor_namestring	donation_typestring	donation_quantityfloat	donation_unitstring	partner_idstring	partner_typestring	shipment_origin_streetstring	shipment_origin_citystring	shipment_origin_statestring	shipment_origin_postal_codestring	shipment_origin_countrystring	shipment_destination_streetstring	shipment_destination_citystring	shipment_destination_statestring	shipment_destination_postal_codestring	shipment_destination_countrystring	shipment_departure_datetimedatetime	shipment_arrival_datetimedatetime	lead_time_hoursfloat	bottleneck_flagboolean	environmental_impact_co2_kgfloat	shipment_notesstring
SHIP_1A3B7C	delivered	97.2	false	AmeriTrans Logistics	DON2024_001	Global Giving Trust	food	5302.17	kg	PRT001	carrier	890 Maple Ave	Houston	TX	77002	USA	120 Oak Blvd	Dallas	TX	75201	USA	2024-04-06T08:35:00Z	2024-04-06T17:55:00Z	9.33	false	410.8	Shipment delivered on time. Temperature checks performed at both ends.
SHPMNT_2B4D5E	delivered	95.5	false	NorCan Warehousing	DON2024_002	Helping Hands Foundation	clothing	670	pieces	PRT002	warehouse	14 King St	Toronto	ON	M5H2Y2	Canada	55 St. Laurent Blvd	Montreal	QC	H2Y1C6	Canada	2024-04-08T11:00:00Z	2024-04-08T19:30:00Z	8.5	false	28.2	Recipient provided positive feedback on clothing quality.
SHP-3C5F8G	delivered	84.1	true	TransAsia Carriers	DON2024_003	Mercy Medical Relief	medical supplies	4200	boxes	PRT003	carrier	17 West St	Chengdu	Sichuan	610041	China	201 Oak Lane	Kigali	Kigali	11001	Rwanda	2024-04-12T09:10:00Z	2024-04-13T11:25:00Z	26.25	true	956.7	Customs bottleneck at destination caused minor delay.
SHIP_4H2J8K	delivered	90.7	false	Delhi Express	DON2024_004	Fresh Start Initiative	hygiene products	987.4	pieces	PRT004	local distributor	92 MG Road	Delhi	DL	110001	India	34 Park View	Mumbai	MH	400001	India	2024-04-09T07:00:00Z	2024-04-09T19:35:00Z	12.58	false	19.7	Urgent hygiene delivery for local shelters.
SHPMNT_5K7L9M	delivered	88.6	false	EuroLocal Logistics	DON2024_005	Eco Support Group	other	1123.16	kg	PRT005	local distributor	41 Berlin Str	Berlin	BE	10115	Germany	18 Nelson Ave	Cape Town	WC	8001	South Africa	2024-04-13T13:24:00Z	2024-04-14T18:18:00Z	28.9	false	122.3	Eco-friendly shipment, paperwork processed smoothly.
SHP_6N8P1Q	delivered	81.9	true	AmeriTrans Logistics	DON2024_006	US Food Relief	food	7248.68	kg	PRT001	carrier	789 Lincoln Blvd	Chicago	IL	60616	USA	18 Market St	St. Louis	MO	63101	USA	2024-04-07T07:30:00Z	2024-04-07T18:45:00Z	11.25	false	335.2	Partial stockout reported at destination.
SHIP_7R2S4T	delivered	98.2	false	SWI Logistics AG	DON2024_007	Bright Horizons Org	clothing	1054	pieces	PRT006	warehouse	12 Bahnhofstrasse	Zurich	ZH	8001	Switzerland	88 Rue de la Paix	Geneva	GE	1201	Switzerland	2024-04-10T14:10:00Z	2024-04-10T21:30:00Z	7.33	false	9.8	Delivered to Geneva central warehouse.
SHPMNT_8U3V6W	delivered	83.6	true	MedTrans Africa	DON2024_008	Doctors Unite	medical supplies	2250	pieces	PRT007	carrier	14 Nile Rd	Cairo	Cairo	11511	Egypt	56 Gaborone St	Gaborone	SE	00000	South Africa	2024-04-12T06:25:00Z	2024-04-12T21:30:00Z	15.08	false	215.5	Stockout due to customs delay at border.
SHP_9X5Y7Z	delivered	99.1	false	London Storage Ltd	DON2024_009	Compassion Clothing	clothing	345	piece	PRT008	warehouse	23 Regent St	London	ENG	SW1A2DX	UK	77 George St	Manchester	ENG	M13PL	UK	2024-04-08T10:50:00Z	2024-04-08T19:10:00Z	8.33	false	12.4	Clothing delivered, recipient satisfaction reported.
SHIP_10A2B3C	delivered	94.3	false	AustPacific Shipping	DON2024_010	Hopeful Hearts Society	food	1203.5	kg	PRT009	carrier	44 Pitt St	Sydney	NSW	2000	Australia	98 Swanston St	Melbourne	VIC	3000	Australia	2024-04-05T09:20:00Z	2024-04-05T19:50:00Z	10.5	false	51.2	On-time delivery of perishable food supplies.
SHPMNT_11D4E5F	delivered	99.7	false	Nordic Relief	DON2024_011	Hygiene for All	hygiene products	1199.99	kg	PRT010	local distributor	16 Karl Johans gate	Oslo	OSLO	0154	Norway	42 Storgata	Tromsø	TRO	9008	Norway	2024-04-13T08:10:00Z	2024-04-13T21:05:00Z	12.92	false	16.9	Shipment handled with care, hygiene items distributed in full.
SHP_12G6H8J	delivered	96.4	false	FreshFleet Logistics	DON2024_012	Nourish Communities	food	307.82	kg	PRT011	carrier	301 Cherry Lane	Seattle	WA	98109	USA	121 Pine St	Portland	OR	97205	USA	2024-04-11T07:15:00Z	2024-04-11T14:55:00Z	7.67	false	21.7	All food items arrived fresh and intact.
SHPMNT_13K9L1M	delivered	82.5	true	IndoMed Carriers	DON2024_013	Wellness Medical	medical supplies	5378	boxes	PRT012	carrier	91 Residency Rd	Bangalore	KA	560025	India	13 Lotus St	Chennai	TN	600002	India	2024-04-14T06:00:00Z	2024-04-14T17:55:00Z	11.92	true	1100.6	Bottleneck at recipient hospital, partial delivery.
SHP_14N2P4Q	delivered	100	false	Warehaus Canada	DON2024_014	Relief Clothing Inc.	clothing	108	pieces	PRT013	warehouse	210 Yonge St	Toronto	ON	M5B2H1	Canada	89 Laurier Ave	Ottawa	ON	K1P1J1	Canada	2024-04-09T08:40:00Z	2024-04-09T13:10:00Z	4.5	false	4.2	Quick shipment for seasonal clothing emergency.
SHPMNT_15R6S8T	delivered	86.9	false	USAgri Freight	DON2024_015	Food4All Network	food	8675.39	kg	PRT014	carrier	456 Main St	Denver	CO	80202	USA	78 14th Ave	Phoenix	AZ	85007	USA	2024-04-08T09:30:00Z	2024-04-08T21:45:00Z	12.25	false	748.6	Timely delivery, all items checked for temperature.
SHP_16U3V5W	delayed	72.5	true	MedTrans Africa	DON2024_016	African Relief Network	medical supplies	1982	pieces	PRT015	carrier	17 Kigali Rd	Kigali	Kigali	11001	Rwanda	22 Nelson Mandela St	Cape Town	WC	8001	South Africa	2024-04-15T08:00:00Z	2024-04-17T08:30:00Z	48.5	true	529.3	Bottleneck due to customs paperwork; delay reported.
SHIP_17X6Y8Z	delayed	76.4	true	TransAsia Carriers	DON2024_017	Global Health Connect	medical supplies	8000	boxes	PRT016	carrier	22 Xinhua Rd	Shanghai	SH	200080	China	111 Victoria St	Delhi	DL	110001	India	2024-04-14T10:10:00Z	2024-04-16T14:40:00Z	52.5	true	975.6	Surge in demand caused extended delivery time.
SHPMNT_18A2B4C	in transit	blank	false	Warehaus Canada	DON2024_018	Clothes For Change	clothing	450	pieces	PRT017	warehouse	33 Wellington St	Winnipeg	MB	R3C1J9	Canada	78 Granville St	Vancouver	BC	V6C1T2	Canada	2024-04-12T09:15:00Z	blank	blank	false	blank	Expected arrival in two days.
SHP_19D5E7F	in transit	0	false	AmeriTrans Logistics	DON2024_019	Nutrition Now	food	3500.5	kg	PRT018	carrier	18 Walnut St	Philadelphia	PA	19103	USA	61 Main St	Baltimore	MD	21201	USA	2024-04-11T06:20:00Z	blank	blank	false	blank	Shipment in progress, all goods refrigerated.
SHIP_20G1H3I	in transit	0	false	Delhi Express	DON2024_020	Care Hygiene	hygiene products	501.4	pieces	PRT019	local distributor	101 Connaught Place	Delhi	DL	110001	India	28 MG Road	Hyderabad	TG	500081	India	2024-04-13T05:00:00Z	blank	blank	false	blank	Long-distance delivery in progress.

What the 110 rows show

from the 110-row sample

In transit (shipment status) stands out: mean utilization_rate is 0.0, against 84.5 for the rest.

19%stockout_flag = true
92.1median utilization_rate
3partner types
5donation types
5donation units
13shipment destination countries

Mean utilization_rate by shipment_status85 rows

utilization_rate85 rows, in bands of 10

Median 92.1, from 0.0 to 100.0.

partner_name110 rows · top 10 of 38 values

AmeriTrans Logistics6
MedTrans Africa6
Nordic Relief5
IndoMed Carriers5
EuroLocal Logistics4
London Storage Ltd4
Warehaus Canada4
SwiftWay Logistics LLC4
Harbor International4
TransAsia Carriers3

28 columns by typefrom the column list below

string 20
float 4
datetime 2
boolean 2

Columns

28 columns in four groups

blueprint · 28 columns
column	type	description	example
Text 20 columns
`shipment_id`	string	Unique identifier for each shipment of donated goods.unique	SHIP_1A3B7C
`donation_id`	string	Unique identifier for the donation associated with the shipment.	DON2024_001
`donor_name`	string	Name of the individual or organization donating goods.	Global Giving Trust
`donation_type`	string	Type of donated goods (e.g., food, clothing, medical supplies).5 values	food
`donation_unit`	string	Unit of measurement for the donated goods (e.g., kg, pieces, liters).5 units	kg
`partner_id`	string	Unique identifier for the logistics/distribution partner.	PRT001
`partner_name`	string	Name of the logistics/distribution partner.	AmeriTrans Logistics
`partner_type`	string	Type of partner (e.g., carrier, warehouse, local distributor).carrier · warehouse · local distributor · other	carrier
`shipment_status`	string	Current status of the shipment.pending · in transit · delivered · delayed · cancelled	delivered
`shipment_origin_street`	string	Street address where the shipment originates.	890 Maple Ave
`shipment_origin_city`	string	City where the shipment originates.	Houston
`shipment_origin_state`	string	State or province where the shipment originates.	TX
`shipment_origin_postal_code`	string	Postal code of the shipment origin.	77002
`shipment_origin_country`	string	Country of the shipment origin.	USA
`shipment_destination_street`	string	Street address where the shipment is delivered.	120 Oak Blvd
`shipment_destination_city`	string	City where the shipment is delivered.	Dallas
`shipment_destination_state`	string	State or province where the shipment is delivered.	TX
`shipment_destination_postal_code`	string	Postal code of the shipment destination.	75201
`shipment_destination_country`	string	Country of the shipment destination.	USA
`shipment_notes`	string	Additional notes or comments about the shipment or supply chain process.optional	Awaiting pickup.
Numbers 4 columns
`donation_quantity`	float	Quantity of goods donated, measured in standardized units.0.01 or more	5302.17
`lead_time_hours`	float	Total time taken for the shipment from departure to arrival, in hours.0 or more · optional	9.33
`utilization_rate`	float	Percentage of donated goods successfully distributed and utilized (0-100).0 to 100 · optional	97.2
`environmental_impact_co2_kg`	float	Estimated CO2 emissions (in kg) associated with the shipment.0 or more · optional	410.8
Dates and times 2 columns
`shipment_departure_datetime`	datetime	Date and time when the shipment departs from the origin.	2024-04-06T08:35:00Z
`shipment_arrival_datetime`	datetime	Date and time when the shipment arrives at the destination.optional	2024-04-06T17:55:00Z
True or false 2 columns
`stockout_flag`	boolean	Indicates whether a stockout occurred for this shipment at the destination.	false
`bottleneck_flag`	boolean	Indicates whether a bottleneck was identified in the supply chain for this shipment.	false

Use it for

A logistics dashboard
The stockout_flag rate, utilization_rate by shipment_status and a breakdown of partner_name. Excel, Power BI or Tableau.
Why do the 11 in transit rows have a mean utilization_rate of 0.0?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Shipments110
SHIP_1A3B7C97.2delivered
SHP-3C5F8G84.1delivered
SHP_6N8P1Q81.9delivered
A software demo
Believable shipments with donation_id, donor_name and donation_type to fill a screen in front of a buyer.

This dataset110 rows28 columns

Yours1,000 rows28 columnsshipment_origin_city: UK only

blueprint · nonprofit-supply-chain-tracking-metrics

Behind this dataset

Same schema. As many rows as you need.

These 110 rows came out of a blueprint — 28 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 shipment record must have a unique ID.
Partner delivery efficiency is calculated as percentage on-time deliveries.
Stockout events are flagged when inventory falls below minimum threshold.
Donation utilization is tracked as a ratio of items distributed versus received.
Lead time must include contributions from all supply chain stages.

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: nonprofit-supply-chain-tracking-metrics

What should your data show?

No signup. No card.

Sample rows

What the 110 rows show

Columns

Use it for

A logistics dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Logistics

What should your data show?