Nonprofit Donation Supply Chain Trace
This dataset provides a comprehensive, end-to-end trace of donated goods as they move through nonprofit supply chains. It includes detailed information on donors, partners, recipients, item categories, quantities, statuses, and delivery addresses, enabling transparency, bottleneck identification, and operational optimization for humanitarian logistics.
Sample rows
preview · 8 of 120 rows · all 29 columns| donation_idstring | item_categorystring | quantityinteger | delivery_address_statestring | donor_idstring | donor_namestring | donation_datedate | unitstring | current_statusstring | last_update_datetimedatetime | origin_partner_idstring | origin_partner_namestring | destination_partner_idstring | destination_partner_namestring | recipient_idstring | recipient_namestring | delivery_expected_datedate | delivery_actual_datedate | pickup_address_streetstring | pickup_address_citystring | pickup_address_statestring | pickup_address_postal_codestring | pickup_address_countrystring | delivery_address_streetstring | delivery_address_citystring | delivery_address_postal_codestring | delivery_address_countrystring | item_descriptionstring | routing_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| D1001 | food | 2400 | OH | U1001 | Harvest Foods Cooperative | 2024-03-10 | kg | delivered | 2024-03-16T15:23:00 | P1001 | Central Food Distribution Center | P1021 | Hope Community Shelter | R1001 | Hope Community Shelter | 2024-03-16 | 2024-03-16 | 213 Main Street | Columbus | OH | 43215 | USA | 342 Shelter Ave | Columbus | 43215 | USA | Bulk rice bags for shelter pantries | Delivered as scheduled, minor traffic delay. |
| D1002 | clothing | 38 | IL | U1002 | Green Valley Parish | 2024-04-05 | pieces | delivered | 2024-04-11T10:45:00 | P1002 | Local Clothing Bank | P1022 | Shelter for All | R1002 | Shelter for All Residents | 2024-04-11 | 2024-04-11 | 88 Parish Lane | Chicago | IL | 60616 | USA | 500 Hope Dr | Chicago | 60616 | USA | Assorted spring jackets for families | Direct drop-off, sizing checked. |
| D1003 | medical | 2500 | blank | U1003 | LifeCare Medical Supplies | 2024-05-02 | masks | in_transit | 2024-05-07T14:10:00 | P1003 | City Medical Warehouse | P1023 | St. Anne Hospital Foundation | blank | blank | 2024-05-12 | blank | 421 Health Blvd | Newark | NJ | 07102 | USA | blank | blank | blank | blank | Disposable surgical masks for hospital | Delayed at customs checkpoint. |
| D1004 | electronics | 16 | blank | U1004 | Sunrise Outreach Group | 2024-03-23 | units | delayed | 2024-03-29T09:35:00 | P1004 | Rural Support Hub | P1024 | Village Education Project | blank | blank | 2024-04-03 | blank | 302 Green Road | Bhopal | Madhya Pradesh | 462001 | India | blank | blank | blank | blank | Solar powered lanterns for village school | Weather delays affecting delivery route. |
| D1005 | hygiene | 44 | GA | U1005 | Bright Futures Foundation | 2024-02-15 | packs | delivered | 2024-02-22T16:15:00 | P1005 | Family Services Center | P1025 | Rural Community Center | R1003 | Rural Community Center Families | 2024-02-22 | 2024-02-22 | 211 Maple St | Atlanta | GA | 30303 | USA | 77 Community Rd | Atlanta | 30303 | USA | Children's hygiene kits for rural families | Delivered successfully, route optimized. |
| D1006 | medical | 100 | blank | U1006 | Helping Hands NGO | 2024-05-18 | kits | lost | 2024-05-25T13:05:00 | P1006 | Medical Outreach Hub | P1026 | Partner Health Clinic | blank | blank | 2024-05-26 | blank | 98 Delhi Road | Delhi | Delhi | 110001 | India | blank | blank | blank | blank | Emergency medical kits for partner clinics | Shipment lost during international transit. |
| D1007 | electronics | 25 | England | U1007 | Tech4Good | 2024-06-02 | pieces | received | 2024-06-08T11:30:00 | P1007 | Urban Youth Center | P1027 | Digital Inclusion Project | R1004 | Digital Inclusion Youth | 2024-06-09 | blank | 27 Tech Avenue | London | England | EC1A 9HB | UK | 112 Youth St | London | EC1A 9HB | UK | Refurbished laptops for youth program | Received by partner, awaiting distribution. |
| D1008 | food | 600 | TX | U1008 | Wellspring Community Org | 2024-04-20 | cans | delivered | 2024-04-25T14:18:00 | P1008 | Regional Food Bank | P1028 | Neighborhood Soup Kitchen | R1005 | Neighborhood Soup Kitchen | 2024-04-25 | 2024-04-25 | 470 Oak Lane | Dallas | TX | 75202 | USA | 900 Kitchen Rd | Dallas | 75202 | USA | Assorted canned vegetables for soup kitchen | Early delivery, efficient logistics. |
| D1009 | other | 90 | Berlin | U1009 | Anonymous Donor | 2024-03-30 | boxes | at_partner | 2024-04-02T13:40:00 | P1009 | Rapid Response Center | P1029 | Emergency Relief Project | R1006 | Emergency Relief Team | 2024-04-07 | blank | 44 Relief St | Berlin | Berlin | 10115 | Germany | 22 Emergency Rd | Berlin | 10115 | Germany | Miscellaneous items for emergency relief | Awaiting further sorting at partner hub. |
| D1010 | hygiene | 24 | blank | U1010 | Northside Community | 2024-05-12 | bars | returned | 2024-05-14T11:18:00 | P1010 | Family Support Network | P1030 | Shelter Aid Initiative | blank | blank | 2024-05-15 | blank | 201 Elm St | Houston | TX | 77002 | USA | blank | blank | blank | blank | Children’s soap bars for families in need | Batch error, unsuitable for distribution. |
| D1011 | other | 55 | Central Region | U1011 | Global Aid Network | 2024-03-17 | filters | received | 2024-03-22T09:30:00 | P1011 | Global Outreach Center | P1031 | Village Development Group | R1007 | Village Water Project | 2024-03-25 | blank | 19 Aid St | Kampala | Central Region | 00256 | Uganda | 27 River Rd | Kampala | 00256 | Uganda | Water filters for remote village | Received by partner, urgent need addressed. |
| D1012 | food | 1800 | PA | U1012 | Riverbend Foods | 2024-05-21 | bags | delivered | 2024-05-28T12:11:00 | P1012 | Metro Food Bank | P1032 | Urban Shelter Collective | R1008 | Urban Shelter Collective | 2024-05-28 | 2024-05-28 | 201 River Rd | Philadelphia | PA | 19103 | USA | 35 Shelter Blvd | Philadelphia | 19103 | USA | Bulk grain sacks for city shelters | Delivered without incident. |
| D1013 | clothing | 52 | WA | U1013 | Compassionate Hearts | 2024-04-08 | pieces | delivered | 2024-04-12T09:48:00 | P1013 | Winter Relief Fund | P1033 | Shelter Care Network | R1009 | Shelter Care Network | 2024-04-12 | 2024-04-12 | 113 Pine St | Seattle | WA | 98101 | USA | 51 Shelter Lane | Seattle | 98101 | USA | Assorted sweaters for winter relief | Delivered, batch verified for quality. |
| D1014 | medical | 750 | blank | U1014 | Health4All Supplies | 2024-02-01 | boxes | in_transit | 2024-02-05T10:10:00 | P1014 | Health Distribution Center | P1034 | CityCare Hospital | blank | blank | 2024-02-10 | blank | 39 Wellness Rd | Mumbai | Maharashtra | 400001 | India | blank | blank | blank | blank | Sterile gloves for hospital partners | Delayed at port, customs processing. |
| D1015 | food | 1200 | NY | U1015 | Community Food Exchange | 2024-03-27 | cans | delivered | 2024-04-02T12:40:00 | P1015 | City Food Bank | P1035 | Hope Kitchen | R1010 | Hope Kitchen | 2024-04-03 | 2024-04-02 | 63 Broad St | New York | NY | 10005 | USA | 99 Hope Ave | New York | 10005 | USA | Canned beans for city food pantries | On time, no issues reported. |
| D1016 | clothing | 20 | blank | U1016 | Giving Tree | 2024-04-17 | pairs | returned | 2024-04-19T15:20:00 | P1016 | Youth Services Center | P1036 | Family Shelter Foundation | blank | blank | 2024-04-22 | blank | 16 Oak Dr | Boston | MA | 02108 | USA | blank | blank | blank | blank | Children’s socks for spring donations | Sizing error, returned to origin. |
| D1017 | food | 3000 | CA | U1017 | EatWell Foods | 2024-01-10 | kg | delivered | 2024-01-16T16:50:00 | P1017 | Metro Food Distribution | P1037 | School Nutrition Program | R1011 | School Nutrition Program | 2024-01-16 | 2024-01-16 | 244 Main Ave | San Jose | CA | 95112 | USA | 89 School Rd | San Jose | 95112 | USA | Bulk flour sacks for school lunches | Delivered after brief weather delay. |
| D1018 | medical | 150 | blank | U1018 | CareCircle NGO | 2024-02-18 | boxes | in_transit | 2024-02-20T09:12:00 | P1018 | Rural Medical Hub | P1038 | Remote Clinic Aid | blank | blank | 2024-02-26 | blank | 88 Clinic Rd | Kathmandu | Bagmati | 44600 | Nepal | blank | blank | blank | blank | Sterile wound dressings for village clinic | Delay due to fuel shortage. |
| D1019 | hygiene | 80 | Istanbul | U1019 | Outreach Partners | 2024-03-04 | packs | delivered | 2024-03-09T14:37:00 | P1019 | Refugee Aid Center | P1039 | Global Refugee Project | R1012 | Global Refugee Project | 2024-03-10 | 2024-03-10 | 18 Camp Rd | Istanbul | Istanbul | 34000 | Turkey | 90 Refugee St | Istanbul | 34000 | Turkey | Assorted hygiene packs for refugee camp | Delivered, distribution ongoing. |
| D1020 | hygiene | 32 | CA | U1020 | FreshStart Initiative | 2024-05-06 | bars | delivered | 2024-05-11T13:05:00 | P1020 | Shelter Support Group | P1040 | Urban Homeless Shelter | R1013 | Urban Homeless Shelter | 2024-05-11 | 2024-05-11 | 183 Shelter St | Los Angeles | CA | 90012 | USA | 55 Urban Rd | Los Angeles | 90012 | USA | Laundry detergent bars for shelter | Delivered, no issues encountered. |
What the 120 rows show
from the 120-row sampleFood (item category) stands out: mean quantity is 2,023, against 288.5 for the rest.
- 80median quantity
- 7current statuses
- 14units
- 15delivery address countries
- 18pickup address countries
Median 80, from 10 to 4,100.
- string 24
- integer 1
- date 3
- datetime 1
Columns
29 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 24 columns | |||
donation_id | string | Unique identifier for each donated goods batch or item.unique | D1001 |
donor_id | string | Unique identifier for the donor organization or individual. | U1001 |
donor_name | string | Name of the donor organization or individual. | Green Valley Parish |
item_description | string | Description of the donated goods (e.g., clothing, food, medical supplies). | Bulk rice bags for shelte… |
item_category | string | Category of the donated item (e.g., food, clothing, medical, hygiene, electronics).6 values | food |
unit | string | Unit of measurement for the quantity (e.g., pieces, boxes, kg, liters). | kg |
current_status | string | Current status of the donation in the supply chain.7 values | delivered |
origin_partner_id | string | Unique identifier for the nonprofit partner where the donation originated or was first received. | P1001 |
origin_partner_name | string | Name of the nonprofit partner where the donation originated. | Local Clothing Bank |
destination_partner_id | string | Unique identifier for the current or final nonprofit partner destination. | P1021 |
destination_partner_name | string | Name of the current or final nonprofit partner destination. | Hope Community Shelter |
recipient_id | string | Unique identifier for the recipient organization or individual (if applicable).optional | R1001 |
recipient_name | string | Name of the recipient organization or individual (if applicable).optional | Hope Community Shelter |
routing_notes | string | Notes regarding routing decisions, bottlenecks, or delays.optional | Delivered on schedule. |
pickup_address_street | string | Street address where the donation was picked up.optional | 213 Main Street |
pickup_address_city | string | City of the pickup address.optional | Columbus |
pickup_address_state | string | State or region of the pickup address.optional | OH |
pickup_address_postal_code | string | Postal code of the pickup address.optional | 43215 |
pickup_address_country | string | Country of the pickup address.optional | USA |
delivery_address_street | string | Street address where the donation was delivered.optional | 342 Shelter Ave |
delivery_address_city | string | City of the delivery address.optional | Columbus |
delivery_address_state | string | State or region of the delivery address.optional | OH |
delivery_address_postal_code | string | Postal code of the delivery address.optional | 43215 |
delivery_address_country | string | Country of the delivery address.optional | USA |
| Numbers 1 column | |||
quantity | integer | Number of units donated in this batch.1 or more | 2400 |
| Dates and times 4 columns | |||
donation_date | date | Date the donation was made or received by the first nonprofit partner. | 2024-03-10 |
last_update_datetime | datetime | Timestamp of the most recent status update. | 2024-03-16T15:23:00 |
delivery_expected_date | date | Expected delivery date for the donation at the destination partner or recipient.optional | 2024-03-16 |
delivery_actual_date | date | Actual delivery date for the donation at the destination partner or recipient.optional | 2024-03-16 |
Use it for
A logistics dashboard
Quantity by item_
category and a breakdown of delivery_ address_ state. Excel, Power BI or Tableau. Why do the 32 food rows have a mean quantity of 2,023?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Donations120D10012400foodD100238clothingD10032500medical
A software demo
Believable donations with donor_
id, donor_ name and donation_ date to fill a screen in front of a buyer.
blueprint · nonprofit-donation-supply-chain-trace
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 29 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 donation must have a unique tracking ID.
- Status updates must be timestamped for every transit event.
- Partner handoffs are logged with responsible contact details.
- Lost or delayed items are flagged and require resolution notes.
- Final delivery confirmation must include recipient type.
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-donation-supply-chain-trace