Nonprofit Supply Distribution Traceability
This dataset provides end-to-end traceability for nonprofit supply shipments, detailing origins, checkpoints, bottlenecks, and delivery outcomes. It enables transparency for donors and partners, supports operational audits, and helps identify risks or delays in the supply chain. The data is ideal for impact measurement, compliance, and optimizing nonprofit logistics.
Sample rows
preview · 8 of 90 rows · all 29 columns| shipment_idstring | supply_typestring | quantityfloat | bottleneck_flagboolean | donor_idstring | nonprofit_idstring | nonprofit_namestring | origin_facility_namestring | origin_street_addressstring | origin_citystring | origin_statestring | origin_postal_codestring | origin_countrystring | destination_facility_namestring | destination_street_addressstring | destination_citystring | destination_statestring | destination_postal_codestring | destination_countrystring | unitsstring | shipment_departure_datetimedatetime | expected_delivery_datetimedatetime | actual_delivery_datetimedatetime | current_statusstring | last_checkpoint_namestring | last_checkpoint_datetimedatetime | donor_namestring | bottleneck_descriptionstring | impact_notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SHIP0001 | food | 1200.5 | false | DON-200 | NP-101 | Global Aid Network | Central Relief Warehouse | 123 Hope Ave | Dallas | TX | 75201 | USA | Austin Outreach Center | 200 Caring Blvd | Austin | TX | 73301 | USA | kg | 2024-03-01T08:00:00 | 2024-03-02T14:00:00 | 2024-03-02T13:45:00 | delivered | Houston Crossdock | 2024-03-02T06:15:00 | Feeding Futures Foundation | blank | Provided meals for 500 families in Austin. |
| SHIP0002 | medical | 240 | true | DON-201 | NP-102 | Medical Relief United | West Medical Storage | 789 Health Dr | Phoenix | AZ | 85001 | USA | Flagstaff Community Clinic | 400 Care St | Flagstaff | AZ | 86001 | USA | boxes | 2024-03-03T09:30:00 | 2024-03-03T18:00:00 | 2024-03-03T19:10:00 | delayed | Prescott Transfer Point | 2024-03-03T14:25:00 | HealthNow Corp | Route closed due to accident, rerouted. | Delivered critical medicine despite delay. |
| SHIP0003 | clothing | 900 | false | blank | NP-103 | Clothe the World | Midwest Apparel Depot | 555 Textile Lane | Chicago | IL | 60616 | USA | Detroit Family Center | 88 Unity St | Detroit | MI | 48201 | USA | pieces | 2024-03-05T07:45:00 | 2024-03-05T19:00:00 | blank | in_transit | Lansing Logistics Hub | 2024-03-05T13:30:00 | blank | blank | blank |
| SHIP0004 | food | 1500 | false | DON-202 | NP-101 | Global Aid Network | Central Relief Warehouse | 123 Hope Ave | Dallas | TX | 75201 | USA | San Antonio Food Bank | 300 Community Pkwy | San Antonio | TX | 78201 | USA | kg | 2024-03-06T06:30:00 | 2024-03-06T17:00:00 | 2024-03-06T16:45:00 | delivered | Waco Checkpoint | 2024-03-06T11:20:00 | Texan Philanthropy Fund | blank | Distributed food to local shelters. |
| SHIP0005 | water | 4000 | true | DON-203 | NP-104 | Water for Life | East Distribution Center | 222 River Rd | Atlanta | GA | 30303 | USA | Savannah Relief Point | 444 Rescue Ave | Savannah | GA | 31401 | USA | liters | 2024-03-08T10:00:00 | 2024-03-08T18:30:00 | 2024-03-08T18:50:00 | delayed | Macon Rest Area | 2024-03-08T13:35:00 | Clean Water Alliance | Traffic congestion due to highway construction. | Provided clean water for 2,000 individuals. |
| SHIP0006 | shelter | 75 | false | blank | NP-105 | Shelter Now | Pacific Storage | 101 Shelter Dr | San Francisco | CA | 94103 | USA | Oakland Emergency Housing | 501 Safe Haven Blvd | Oakland | CA | 94607 | USA | tents | 2024-03-09T12:00:00 | 2024-03-09T16:00:00 | 2024-03-09T15:55:00 | delivered | Berkeley Waypoint | 2024-03-09T13:40:00 | blank | blank | Temporary housing for 100 people. |
| SHIP0007 | educational | 650 | false | DON-204 | NP-106 | Education Forward | Learning Materials Hub | 800 Schoolhouse Ln | Boston | MA | 02108 | USA | Springfield Youth Center | 302 Future Rd | Springfield | MA | 01103 | USA | books | 2024-03-10T09:00:00 | 2024-03-10T15:30:00 | 2024-03-10T15:30:00 | delivered | Worcester Distribution | 2024-03-10T12:10:00 | Books for Kids Initiative | blank | Improved literacy for local children. |
| SHIP0008 | shelter | 120 | false | DON-205 | NP-105 | Shelter Now | Pacific Storage | 101 Shelter Dr | San Francisco | CA | 94103 | USA | San Jose Family Center | 988 New Life St | San Jose | CA | 95112 | USA | blankets | 2024-03-11T14:00:00 | 2024-03-11T17:30:00 | blank | at_checkpoint | Palo Alto Checkpoint | 2024-03-11T15:20:00 | Safe Nights Fund | blank | blank |
| SHIP0009 | food | 800 | false | DON-206 | NP-107 | Fresh Start Foundation | Northern Distribution Center | 456 Charity Dr | Seattle | WA | 98101 | USA | Spokane Outreach | 789 Hope St | Spokane | WA | 99201 | USA | kg | 2024-03-12T08:30:00 | 2024-03-12T17:30:00 | 2024-03-12T17:10:00 | delivered | Ellensburg Rest Area | 2024-03-12T12:45:00 | Northwest Giving Circle | blank | Helped families facing food insecurity. |
| SHIP0010 | medical | 320 | false | DON-207 | NP-108 | Hope for All | Central Storage Facility | 321 Faith Blvd | Denver | CO | 80202 | USA | Pueblo Relief Center | 210 Kindness Rd | Pueblo | CO | 81003 | USA | boxes | 2024-03-13T07:00:00 | 2024-03-13T16:00:00 | blank | in_transit | Colorado Springs Checkpoint | 2024-03-13T11:40:00 | HealthFirst Partners | blank | blank |
| SHIP0011 | educational | 300 | false | DON-208 | NP-106 | Education Forward | Learning Materials Hub | 800 Schoolhouse Ln | Boston | MA | 02108 | USA | Worcester Refugee Center | 10 Welcome St | Worcester | MA | 01608 | USA | books | 2024-03-14T10:15:00 | 2024-03-14T13:45:00 | 2024-03-14T13:55:00 | delivered | Framingham Waypoint | 2024-03-14T11:45:00 | Learning Together Fund | blank | Refugee children received school supplies. |
| SHIP0012 | food | 1100 | true | DON-209 | NP-101 | Global Aid Network | Central Relief Warehouse | 123 Hope Ave | Dallas | TX | 75201 | USA | Houston Community Aid | 345 Support St | Houston | TX | 77002 | USA | kg | 2024-03-16T06:45:00 | 2024-03-16T13:30:00 | 2024-03-16T14:20:00 | delayed | College Station Checkpoint | 2024-03-16T10:55:00 | Lone Star Donors | Mechanical issue delayed transit. | Helped feed 350 families. |
| SHIP0013 | medical | 225 | false | DON-210 | NP-109 | Global Health Outreach | Medical Supplies Depot | 501 Clinic Way | Miami | FL | 33101 | USA | Orlando Health Center | 700 Healing Blvd | Orlando | FL | 32801 | USA | boxes | 2024-03-17T09:55:00 | 2024-03-17T15:00:00 | blank | pending | blank | blank | Florida Wellness Trust | blank | blank |
| SHIP0014 | food | 950 | false | blank | NP-110 | Feed the Children | Gulf Coast Food Center | 900 Ocean Dr | New Orleans | LA | 70112 | USA | Baton Rouge Outreach | 120 Hope Blvd | Baton Rouge | LA | 70801 | USA | kg | 2024-03-18T08:30:00 | 2024-03-18T15:00:00 | 2024-03-18T14:45:00 | delivered | Laplace Checkpoint | 2024-03-18T10:45:00 | blank | blank | Supported local food pantry. |
| SHIP0015 | medical | 310 | false | DON-211 | NP-111 | Disaster Response Network | Emergency Relief Center | 890 Rescue Rd | Tampa | FL | 33602 | USA | Jacksonville Support Center | 901 Aid Ave | Jacksonville | FL | 32202 | USA | boxes | 2024-03-19T11:00:00 | 2024-03-19T18:30:00 | 2024-03-19T18:35:00 | delivered | Orlando Transfer | 2024-03-19T15:10:00 | Rapid Relief Fund | blank | Medical aid after severe storms. |
| SHIP0016 | clothing | 450 | false | blank | NP-112 | Kids in Need | Charity Goods Center | 222 Tomorrow Ln | Minneapolis | MN | 55401 | USA | St Paul Family Shelter | 88 Warmth St | St Paul | MN | 55101 | USA | pieces | 2024-03-20T07:45:00 | 2024-03-20T11:15:00 | 2024-03-20T11:20:00 | delivered | Roseville Distribution | 2024-03-20T09:30:00 | blank | blank | Winter clothing for families. |
| SHIP0017 | water | 2000 | false | DON-212 | NP-113 | Clean Water Project | Main Water Center | 302 Blue Lake Rd | Boise | ID | 83702 | USA | Twin Falls Outreach | 101 Clear Water St | Twin Falls | ID | 83301 | USA | liters | 2024-03-21T12:00:00 | 2024-03-21T17:30:00 | 2024-03-21T17:20:00 | delivered | Mountain Home Checkpoint | 2024-03-21T14:00:00 | Water Works Fund | blank | Clean water provided to 1,000 people. |
| SHIP0018 | water | 3200 | true | DON-213 | NP-104 | Water for Life | East Distribution Center | 222 River Rd | Atlanta | GA | 30303 | USA | Augusta Relief Point | 555 Health St | Augusta | GA | 30901 | USA | liters | 2024-03-22T09:30:00 | 2024-03-22T16:00:00 | 2024-03-22T16:40:00 | delayed | Macon Rest Area | 2024-03-22T13:10:00 | Pure Springs Foundation | Weather delay due to heavy rain. | Emergency water aid after flooding. |
| SHIP0019 | shelter | 90 | false | DON-214 | NP-114 | Shelter United | Shelter Warehouse | 600 Safety St | Portland | OR | 97201 | USA | Eugene Support Center | 800 Secure Pl | Eugene | OR | 97401 | USA | tents | 2024-03-23T13:00:00 | 2024-03-23T17:30:00 | 2024-03-23T17:35:00 | delivered | Salem Waypoint | 2024-03-23T15:10:00 | Shelter Now Fund | blank | Temporary housing for 120 people. |
| SHIP0020 | educational | 400 | true | DON-215 | NP-115 | Learning for All | Knowledge Depot | 350 Scholar Ct | Salt Lake City | UT | 84101 | USA | Ogden Youth Center | 45 Progress Ave | Ogden | UT | 84401 | USA | books | 2024-03-24T08:15:00 | 2024-03-24T12:45:00 | 2024-03-24T13:30:00 | delayed | Layton Transfer | 2024-03-24T10:10:00 | Future Minds Trust | Vehicle breakdown required alternate transport. | Education materials for remote schools. |
What the 90 rows show
from the 90-row sampleWater (supply type) stands out: mean quantity is 2,357, against 590.6 for the rest.
- 22%bottleneck_
flag = true - 607.8median quantity
- 5current statuses
- 7unitses
- 27origin states
Median 607.8, from 55.0 to 4,000.
- string 23
- float 1
- datetime 4
- boolean 1
Columns
29 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 23 columns | |||
shipment_id | string | Unique identifier for each supply shipment tracked in the system.unique | SHIP0001 |
nonprofit_id | string | Unique identifier for the nonprofit organization managing the shipment. | NP-101 |
nonprofit_name | string | Name of the nonprofit organization responsible for the shipment. | Global Aid Network |
origin_facility_name | string | Name of the facility or warehouse where the shipment originated. | Central Relief Warehouse |
origin_street_address | string | Street address of the origin facility. | 123 Hope Ave |
origin_city | string | City of the origin facility. | Dallas |
origin_state | string | State or province of the origin facility. | TX |
origin_postal_code | string | Postal code of the origin facility. | 75201 |
origin_country | string | Country of the origin facility. | USA |
destination_facility_name | string | Name of the final delivery facility or recipient location. | Austin Outreach Center |
destination_street_address | string | Street address of the final delivery location. | 200 Caring Blvd |
destination_city | string | City of the final delivery location. | Austin |
destination_state | string | State or province of the final delivery location. | TX |
destination_postal_code | string | Postal code of the final delivery location. | 73301 |
destination_country | string | Country of the final delivery location. | USA |
supply_type | string | Type or category of supplies being shipped (e.g., food, medical, clothing).6 types | food |
units | string | Measurement units for the quantity (e.g., kg, boxes, liters).7 unitses | kg |
current_status | string | Current status of the shipment (e.g., in_transit, delayed, delivered, lost, returned).7 values | delivered |
last_checkpoint_name | string | Name of the most recent checkpoint the shipment passed through.optional | Houston Crossdock |
bottleneck_description | string | Description of the bottleneck or delay, if any.optional | Route closed due to accid… |
donor_id | string | Unique identifier for the donor or funding partner for this shipment.optional | DON-200 |
donor_name | string | Name of the donor or funding partner.optional | HealthNow Corp |
impact_notes | string | Notes on the impact or outcome of the supply delivery for audit and reporting purposes.optional | Fed over 700 families. |
| Numbers 1 column | |||
quantity | float | Quantity of supplies in the shipment (use units field for context).0 or more | 1200.5 |
| Dates and times 4 columns | |||
shipment_departure_datetime | datetime | Date and time when the shipment departed from the origin facility. | 2024-03-01T08:00:00 |
expected_delivery_datetime | datetime | Planned date and time for final delivery at the destination. | 2024-03-02T14:00:00 |
actual_delivery_datetime | datetime | Actual date and time when the shipment was delivered at the destination.optional | 2024-03-02T13:45:00 |
last_checkpoint_datetime | datetime | Date and time when the shipment reached the last checkpoint.optional | 2024-03-02T06:15:00 |
| True or false 1 column | |||
bottleneck_flag | boolean | Indicates if a bottleneck or delay was encountered at the last checkpoint. | false |
Use it for
A logistics dashboard
The bottleneck_
flag rate, quantity by supply_ type and a breakdown of donor_ id. Excel, Power BI or Tableau. Why do the 14 water rows have a mean quantity of 2,357?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Shipments90SHIP00011200.5foodSHIP0002240medicalSHIP00054000water
A software demo
Believable shipments with nonprofit_
id, nonprofit_ name and origin_ facility_ name to fill a screen in front of a buyer.
blueprint · nonprofit-supply-distribution-traceability
Behind this dataset
Same schema. As many rows as you need.
These 90 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 row logs a unique shipment event or status update
- Shipment ID must be unique and traceable through all stages
- Include timestamps and geolocation for each checkpoint update
- Flag shipments exceeding predefined delay or anomaly thresholds
- Capture supply type, recipient organization, and intended beneficiaries
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
- nonprofit-supply-distribution-traceability