Humanitarian Aid Supply Chain Tracker
This dataset provides comprehensive tracking of humanitarian aid shipments, capturing every stage from donor source to field delivery. It includes detailed information on shipment routes, itemized inventory, compliance checks, and risk management, empowering nonprofits and relief organizations to optimize logistics, ensure regulatory compliance, and respond rapidly to supply chain disruptions.
Sample rows
preview · 8 of 48 rows · all 38 columns| shipment_idstring | item_categorystring | item_quantityinteger | risk_flagboolean | item_unitstring | donor_idstring | donor_namestring | origin_warehouse_idstring | origin_warehouse_namestring | origin_street_addressstring | origin_citystring | origin_statestring | origin_postal_codestring | origin_countrystring | destination_field_idstring | destination_field_namestring | destination_street_addressstring | destination_citystring | destination_statestring | destination_postal_codestring | destination_countrystring | shipment_datedate | expected_delivery_datedate | actual_delivery_datedate | delivery_statusstring | route_idstring | route_descriptionstring | transport_modestring | carrier_namestring | item_idstring | item_namestring | current_inventory_levelinteger | compliance_statusstring | compliance_notesstring | risk_notesstring | last_status_updatedatetime | program_manager_idstring | program_manager_namestring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SHIP0001 | food | 500 | false | boxes | DON101 | Global Aid Foundation | WH01 | Berlin Central Depot | Alexanderplatz 5 | Berlin | Berlin | 10178 | Germany | FIELD201 | Kampala Relief Center | Plot 15, Jinja Rd | Kampala | Kampala | 25601 | Uganda | 2024-03-10 | 2024-03-20 | 2024-03-21 | delivered | RT100 | Berlin - Istanbul - Nairobi - Kampala | air | Lufthansa Cargo | ITEM001 | High-nutrition Biscuits | 1500 | compliant | All customs and donor protocols met. | blank | 2024-03-21T10:30:00 | PMGR01 | Anna Müller |
| SHIP0002 | medical | 300 | false | kits | DON102 | Health for All | WH02 | Brussels North Hub | Rue du Progrès 54 | Brussels | Brussels | 1030 | Belgium | FIELD202 | Goma Medical Camp | Avenue de la Victoire 17 | Goma | North Kivu | 24302 | DR Congo | 2024-04-05 | 2024-04-18 | 2024-04-18 | delivered | RT101 | Brussels - Kinshasa - Goma | air | Air Congo | ITEM002 | First Aid Kits | 800 | compliant | WHO standards followed. | blank | 2024-04-18T14:45:00 | PMGR02 | Jean Dumont |
| SHIP0003 | water | 10000 | false | tablets | DON103 | Clean Water Initiative | WH03 | Rotterdam Port Storage | Maasvlakteweg 23 | Rotterdam | South Holland | 3199 | Netherlands | FIELD203 | Cox's Bazar Camp | Block E, Camp 12 | Cox's Bazar | Chattogram | 4700 | Bangladesh | 2024-02-28 | 2024-03-12 | 2024-03-13 | delivered | RT102 | Rotterdam - Dubai - Dhaka - Cox's Bazar | sea | Maersk Line | ITEM003 | Water Purification Tablets | 40000 | compliant | Batch tested for safety. | blank | 2024-03-13T17:15:00 | PMGR03 | Farhana Rahman |
| SHIP0004 | shelter | 50 | false | units | DON104 | Shelter Now | WH04 | Milan Aid Storage | Via Torino 102 | Milan | Lombardy | 20123 | Italy | FIELD204 | Gaziantep Outreach | Şehitkamil Mah. | Gaziantep | Gaziantep | 27010 | Turkey | 2024-03-12 | 2024-03-18 | 2024-03-18 | delivered | RT103 | Milan - Rome - Istanbul - Gaziantep | road | DHL Logistics | ITEM004 | Emergency Tents | 120 | compliant | Fire-resistant certification present. | blank | 2024-03-18T09:20:00 | PMGR04 | Alessandro Rossi |
| SHIP0005 | hygiene | 2000 | true | packs | DON105 | Hygiene For Humanity | WH05 | Warsaw East Warehouse | ul. Marszałkowska 126 | Warsaw | Masovian | 00-008 | Poland | FIELD205 | Lviv Shelter | Svobody Ave 27 | Lviv | Lviv | 79000 | Ukraine | 2024-04-01 | 2024-04-03 | 2024-04-04 | delayed | RT104 | Warsaw - Krakow - Lviv | road | Orlen Transport | ITEM005 | Sanitary Napkins | 3500 | compliant | Packaging verified. | Border delay due to paperwork. | 2024-04-04T16:05:00 | PMGR05 | Olga Kovalchuk |
| SHIP0006 | education | 800 | false | pieces | DON106 | Education For Tomorrow | WH06 | London Thames Hub | Thames Rd 18 | London | Greater London | SE18 6HZ | UK | FIELD206 | Mogadishu Learning Site | Km4, Hodan District | Mogadishu | Benadir | 9999 | Somalia | 2024-03-15 | 2024-03-29 | blank | in_transit | RT105 | London - Nairobi - Mogadishu | air | Kenya Airways | ITEM006 | School Backpacks | blank | pending_review | Awaiting Somalia customs approval. | blank | 2024-03-27T11:00:00 | PMGR06 | Mohamed Hassan |
| SHIP0007 | food | 1200 | false | kg | DON107 | Food Security Trust | WH07 | Madrid Humanitarian Center | Calle Gran Vía 42 | Madrid | Madrid | 28013 | Spain | FIELD207 | Marrakech Aid Station | Rue Ibn Sina 9 | Marrakech | Marrakech-Safi | 40000 | Morocco | 2024-04-11 | 2024-04-15 | blank | pending | RT106 | Madrid - Tangier - Marrakech | road | Transiberica | ITEM007 | Rice Bags | blank | pending_review | Documentation pending. | blank | 2024-04-12T09:45:00 | PMGR07 | Maria Garcia |
| SHIP0008 | medical | 5000 | false | vials | DON108 | Medical Relief Alliance | WH08 | Geneva Medical Supplies | Rue du Rhône 22 | Geneva | Geneva | 1204 | Switzerland | FIELD208 | Aleppo Hospital | Al-Furqan District | Aleppo | Aleppo | 10000 | Syria | 2024-02-19 | 2024-03-05 | 2024-03-07 | delivered | RT107 | Geneva - Ankara - Aleppo | mixed | Medtrans | ITEM008 | Antibiotics | 9000 | compliant | Batch tested, temperature logs attached. | blank | 2024-03-07T20:30:00 | PMGR08 | Leila Al-Sayed |
| SHIP0009 | shelter | 700 | false | units | DON109 | Humanity United | WH09 | Lisbon Aid Point | Avenida da Liberdade 88 | Lisbon | Lisbon | 1250-145 | Portugal | FIELD209 | Maputo Assistance | Rua de Bagamoyo 24 | Maputo | Maputo | 1100 | Mozambique | 2024-04-09 | 2024-04-22 | blank | in_transit | RT108 | Lisbon - Cape Town - Maputo | sea | MSC Shipping | ITEM009 | Mosquito Nets | blank | pending_review | Awaiting Mozambique customs. | blank | 2024-04-16T18:10:00 | PMGR09 | Carlos Mota |
| SHIP0010 | hygiene | 3000 | false | bars | DON110 | Hope for Hygiene | WH10 | Vienna Central Storage | Lerchenfelder Str. 45 | Vienna | Vienna | 1070 | Austria | FIELD210 | Bucharest Help Center | Strada Lipscani 33 | Bucharest | Bucharest | 030167 | Romania | 2024-03-20 | 2024-03-28 | 2024-03-28 | delivered | RT109 | Vienna - Budapest - Bucharest | rail | Rail Cargo Austria | ITEM010 | Soap Bars | 8500 | compliant | Sample batch inspected. | blank | 2024-03-28T15:35:00 | PMGR10 | Stefan Popescu |
| SHIP0011 | medical | 2000 | false | bottles | DON101 | Global Aid Foundation | WH01 | Berlin Central Depot | Alexanderplatz 5 | Berlin | Berlin | 10178 | Germany | FIELD211 | Harare Community Clinic | Samora Machel Ave 32 | Harare | Harare | 00263 | Zimbabwe | 2024-02-12 | 2024-02-28 | 2024-02-27 | delivered | RT110 | Berlin - Lusaka - Harare | air | Ethiopian Airlines | ITEM011 | Vitamin Supplements | 4500 | compliant | Expiry dates checked. | blank | 2024-02-27T11:00:00 | PMGR01 | Anna Müller |
| SHIP0012 | medical | 6000 | false | pairs | DON102 | Health for All | WH02 | Brussels North Hub | Rue du Progrès 54 | Brussels | Brussels | 1030 | Belgium | FIELD212 | Monrovia Health Post | Randall St 11 | Monrovia | Montserrado | 1001 | Liberia | 2024-04-08 | 2024-04-20 | blank | in_transit | RT111 | Brussels - Abidjan - Monrovia | air | Liberia Airways | ITEM012 | Sterile Gloves | blank | pending_review | Customs check pending. | blank | 2024-04-15T13:30:00 | PMGR02 | Jean Dumont |
| SHIP0013 | water | 150 | false | units | DON103 | Clean Water Initiative | WH03 | Rotterdam Port Storage | Maasvlakteweg 23 | Rotterdam | South Holland | 3199 | Netherlands | FIELD213 | Kigali Children Center | Avenue de la Paix 19 | Kigali | Kigali City | 250 | Rwanda | 2024-03-02 | 2024-03-18 | 2024-03-18 | delivered | RT112 | Rotterdam - Nairobi - Kigali | road | TransAfrica | ITEM013 | Water Filters | 450 | compliant | Training documents provided. | blank | 2024-03-18T10:40:00 | PMGR03 | Farhana Rahman |
| SHIP0014 | shelter | 300 | false | sheets | DON104 | Shelter Now | WH04 | Milan Aid Storage | Via Torino 102 | Milan | Lombardy | 20123 | Italy | FIELD214 | Erbil Emergency Shelter | KDP Road 39 | Erbil | Erbil | 44001 | Iraq | 2024-03-17 | 2024-03-23 | 2024-03-23 | delivered | RT113 | Milan - Istanbul - Erbil | air | Iraqi Airways | ITEM014 | Tarpaulin Sheets | 1000 | compliant | Waterproof certification present. | blank | 2024-03-23T08:50:00 | PMGR04 | Alessandro Rossi |
| SHIP0015 | hygiene | 700 | true | bottles | DON105 | Hygiene For Humanity | WH05 | Warsaw East Warehouse | ul. Marszałkowska 126 | Warsaw | Masovian | 00-008 | Poland | FIELD215 | Chisinau Aid Center | Strada Stefan cel Mare 2 | Chisinau | Chisinau | 2000 | Moldova | 2024-03-29 | 2024-04-06 | 2024-04-07 | delayed | RT114 | Warsaw - Lublin - Chisinau | road | EuroExpress | ITEM015 | Disinfectant Spray | 1800 | compliant | EU safety standards. | Road closure caused 1-day delay. | 2024-04-07T19:20:00 | PMGR05 | Olga Kovalchuk |
| SHIP0016 | education | 1200 | false | books | DON106 | Education For Tomorrow | WH06 | London Thames Hub | Thames Rd 18 | London | Greater London | SE18 6HZ | UK | FIELD216 | Bamako School District | Rue de la Liberté 44 | Bamako | Bamako | 3001 | Mali | 2024-04-01 | 2024-04-15 | blank | pending | RT115 | London - Casablanca - Bamako | air | Royal Air Maroc | ITEM016 | Textbooks (French) | blank | pending_review | Customs documentation incomplete. | blank | 2024-04-03T09:30:00 | PMGR06 | Mohamed Hassan |
| SHIP0017 | food | 1800 | false | cans | DON107 | Food Security Trust | WH07 | Madrid Humanitarian Center | Calle Gran Vía 42 | Madrid | Madrid | 28013 | Spain | FIELD217 | Dakar Food Outreach | Boulevard du Centenaire 21 | Dakar | Dakar | 11000 | Senegal | 2024-04-12 | 2024-04-19 | blank | in_transit | RT116 | Madrid - Casablanca - Dakar | road | Senegal Logistics | ITEM017 | Canned Fish | blank | pending_review | Labeling review. | blank | 2024-04-15T12:50:00 | PMGR07 | Maria Garcia |
| SHIP0018 | medical | 1300 | false | bags | DON108 | Medical Relief Alliance | WH08 | Geneva Medical Supplies | Rue du Rhône 22 | Geneva | Geneva | 1204 | Switzerland | FIELD218 | Baghdad Health Unit | Al-Saadoun St 44 | Baghdad | Baghdad | 10001 | Iraq | 2024-02-13 | 2024-02-28 | 2024-03-01 | delivered | RT117 | Geneva - Istanbul - Baghdad | mixed | Medtrans | ITEM018 | IV Fluids | 3000 | compliant | Batch temperature monitored. | blank | 2024-03-01T13:00:00 | PMGR08 | Leila Al-Sayed |
| SHIP0019 | food | 1000 | false | liters | DON109 | Humanity United | WH09 | Lisbon Aid Point | Avenida da Liberdade 88 | Lisbon | Lisbon | 1250-145 | Portugal | FIELD219 | Antananarivo Aid Station | Rue Ravoninahitriniarivo 21 | Antananarivo | Analamanga | 101 | Madagascar | 2024-04-06 | 2024-04-20 | blank | pending | RT118 | Lisbon - Maputo - Antananarivo | sea | MSC Shipping | ITEM019 | Cooking Oil | blank | pending_review | blank | blank | 2024-04-08T15:05:00 | PMGR09 | Carlos Mota |
| SHIP0020 | hygiene | 2500 | false | tubes | DON110 | Hope for Hygiene | WH10 | Vienna Central Storage | Lerchenfelder Str. 45 | Vienna | Vienna | 1070 | Austria | FIELD220 | Belgrade Humanitarian Hub | Bulevar Kralja Aleksandra 54 | Belgrade | Belgrade | 11000 | Serbia | 2024-03-28 | 2024-04-05 | 2024-04-05 | delivered | RT119 | Vienna - Budapest - Belgrade | rail | Serbia Railways | ITEM020 | Toothpaste Tubes | 6000 | compliant | blank | blank | 2024-04-05T10:45:00 | PMGR10 | Stefan Popescu |
What the 48 rows show
from the 48-row sampleMedical (item category) stands out: mean item_
- 15%risk_
flag = true - 1,500median item_
quantity - 2compliance statuses
- 4delivery statuses
- 5transport modes
- 10donors
Median 1,500, from 25 to 14,000.
- string 31
- integer 2
- date 3
- datetime 1
- boolean 1
Columns
38 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 31 columns | |||
shipment_id | string | Unique identifier for each shipment recordunique | SHIP0001 |
donor_id | string | Unique identifier for the donor organization or individual10 donors | DON101 |
donor_name | string | Name of the donor organization or individual10 names | Global Aid Foundation |
origin_warehouse_id | string | Unique identifier for the warehouse or source location10 warehouses | WH01 |
origin_warehouse_name | string | Name of the warehouse or source location10 names | Berlin Central Depot |
origin_street_address | string | Street address of the origin warehouse10 addresses · optional | Alexanderplatz 5 |
origin_city | string | City of the origin warehouse10 cities · optional | Berlin |
origin_state | string | State or province of the origin warehouse10 states · optional | Berlin |
origin_postal_code | string | Postal code of the origin warehouse10 codes · optional | 10178 |
origin_country | string | Country of the origin warehouse10 countries | Germany |
destination_field_id | string | Unique identifier for the field location or recipient site | FIELD201 |
destination_field_name | string | Name of the field location or recipient site | Kampala Relief Center |
destination_street_address | string | Street address of the destination field locationoptional | Plot 15, Jinja Rd |
destination_city | string | City of the destination field locationoptional | Kampala |
destination_state | string | State or province of the destination field locationoptional | Kampala |
destination_postal_code | string | Postal code of the destination field locationoptional | 25601 |
destination_country | string | Country of the destination field location | Uganda |
delivery_status | string | Current status of the shipment delivery6 values | delivered |
route_id | string | Unique identifier for the route taken by the shipmentoptional | RT100 |
route_description | string | Description or summary of the shipment routeoptional | Warsaw - Krakow - Lviv |
transport_mode | string | Primary mode of transport used for the shipmentroad · air · sea · rail · mixed | air |
carrier_name | string | Name of the logistics provider or carrieroptional | Lufthansa Cargo |
item_id | string | Unique identifier for the aid item in the shipment | ITEM001 |
item_name | string | Name or description of the aid item | High-nutrition Biscuits |
item_category | string | Category of the aid item (e.g., food, medical, shelter, water, hygiene)7 values | food |
item_unit | string | Unit of measurement for the item quantity (e.g., boxes, kg, liters) | boxes |
compliance_status | string | Indicates if the shipment complies with regulatory and donor requirementscompliant · non_compliant · pending_review | compliant |
compliance_notes | string | Notes or details regarding compliance checks or issuesoptional | WHO standards followed. |
risk_notes | string | Details about any risks or incidents associated with this shipmentoptional | Minor customs issue. |
program_manager_id | string | Unique identifier for the program manager responsible for this shipment10 managers · optional | PMGR01 |
program_manager_name | string | Name of the program manager responsible for this shipment10 names · optional | Anna Müller |
| Numbers 2 columns | |||
item_quantity | integer | Quantity of the aid item in the shipment1 or more | 500 |
current_inventory_level | integer | Current inventory level of this item at the destination location after delivery0 or more · optional | 1500 |
| Dates and times 4 columns | |||
shipment_date | date | Date when the shipment was dispatched | 2024-03-10 |
expected_delivery_date | date | Expected date of delivery at the field location | 2024-03-20 |
actual_delivery_date | date | Actual date of delivery at the field locationoptional | 2024-03-21 |
last_status_update | datetime | Timestamp of the most recent status update for this shipment | 2024-03-21T10:30:00 |
| True or false 1 column | |||
risk_flag | boolean | Indicates if the shipment is flagged for risk (e.g., theft, delay, route hazard)optional | false |
Use it for
A logistics dashboard
The risk_
flag rate, item_ quantity by item_ category and a breakdown of item_ unit. Excel, Power BI or Tableau. Why do the 11 medical rows have a mean item_
quantity of 5,045? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Shipments48SHIP0001500foodSHIP00052000hygieneSHIP0015700hygiene
A software demo
Believable shipments with donor_
id, donor_ name and origin_ warehouse_ id to fill a screen in front of a buyer.
blueprint · humanitarian-aid-supply-chain-tracker
Behind this dataset
Same schema. As many rows as you need.
These 48 rows came out of a blueprint — 38 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 shipment must have a unique ID and donor source.
- Delivery status must update at every checkpoint (e.g., customs, warehouse, field site).
- Include risk flags for delays, loss, or damaged goods.
- Track compliance with local import/export and safety regulations.
- Inventory levels updated upon receipt at each location.
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
- humanitarian-aid-supply-chain-tracker