IoT Shipment Tracking for Nonprofits
This dataset provides comprehensive, real-time tracking of humanitarian aid shipments for nonprofit organizations using IoT sensor data. It includes detailed shipment information, location updates, environmental conditions, and automated alerts to ensure the integrity and timely delivery of critical supplies. Ideal for improving supply chain transparency, risk management, and rapid response in humanitarian logistics.
Sample rows
preview · 8 of 80 rows · all 28 columns| shipment_idstring | shipment_statusstring | shock_event_countinteger | shock_event_detectedboolean | origin_statestring | organization_idstring | organization_namestring | aid_typestring | departure_datetimedatetime | arrival_datetimedatetime | origin_street_addressstring | origin_citystring | origin_postal_codestring | origin_countrystring | destination_street_addressstring | destination_citystring | destination_statestring | destination_postal_codestring | destination_countrystring | current_latitudefloat | current_longitudefloat | last_sensor_updatedatetime | current_temperature_celsiusfloat | current_humidity_percentfloat | temperature_violationboolean | humidity_violationboolean | alert_flagboolean | intervention_requiredboolean |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SHIP00001 | in_transit | 0 | false | IL | ORG100 | Aid for All | medical supplies | 2024-06-10T08:15:00Z | blank | 123 Elm Street | Chicago | 60601 | USA | 45 Sunrise Ave | Kigali | Kigali City | 11001 | Rwanda | -1.9441 | 30.0619 | 2024-06-13T05:20:00Z | 23.5 | 67.3 | false | false | false | false |
| SHIP00002 | delivered | 2 | true | TX | ORG101 | Global Relief Network | food | 2024-06-01T15:35:00Z | 2024-06-07T10:55:00Z | 56 Maple Lane | Houston | 77001 | USA | 12 Aid Road | Port-au-Prince | Ouest | HT6110 | Haiti | 18.5392 | -72.3364 | 2024-06-07T10:50:00Z | 28.9 | 78.1 | false | false | true | false |
| SHIP00003 | delayed | 0 | false | FL | ORG102 | HealthBridge | water | 2024-06-09T09:30:00Z | blank | 789 Cedar Drive | Miami | 33101 | USA | 88 Rescue Blvd | San Salvador | San Salvador | CP1101 | El Salvador | 13.6929 | -89.2182 | 2024-06-13T06:00:00Z | 34.2 | 84.5 | true | false | true | true |
| SHIP00004 | in_transit | 0 | false | WA | ORG103 | HopeLine | medical supplies | 2024-06-12T13:00:00Z | blank | 320 Oak Ave | Seattle | 98101 | USA | 4 Unity Street | Addis Ababa | Addis Ababa | 1000 | Ethiopia | 8.9806 | 38.7578 | 2024-06-13T06:15:00Z | 19.8 | 52.2 | false | false | false | false |
| SHIP00005 | at_risk | 6 | true | CO | ORG104 | Water Aid Foundation | water | 2024-06-08T07:40:00Z | blank | 220 Pine St | Denver | 80201 | USA | 56 Relief Avenue | Bamako | Bamako | BKO1000 | Mali | 12.6392 | -8.0029 | 2024-06-13T06:30:00Z | 41.5 | 14.9 | true | true | true | true |
| SHIP00006 | in_transit | 0 | false | AZ | ORG105 | BrightFuture | food | 2024-06-11T10:20:00Z | blank | 17 Willow Lane | Phoenix | 85001 | USA | 22 Hope Road | Kathmandu | Bagmati | 44600 | Nepal | 27.7172 | 85.324 | 2024-06-13T06:40:00Z | 31.7 | 65.5 | false | false | false | false |
| SHIP00007 | delayed | 0 | false | MA | ORG106 | Hands Together | medical supplies | 2024-06-04T11:00:00Z | blank | 102 Birch Blvd | Boston | 02101 | USA | 40 Care Crescent | Lagos | Lagos | 100001 | Nigeria | 6.5244 | 3.3792 | 2024-06-13T06:55:00Z | 33.1 | 70.2 | true | false | true | true |
| SHIP00008 | delivered | 0 | false | GA | ORG107 | Caring Hands | food | 2024-05-31T08:50:00Z | 2024-06-06T12:45:00Z | 65 Redwood St | Atlanta | 30301 | USA | 11 Giving Lane | Dhaka | Dhaka | 1205 | Bangladesh | 23.8103 | 90.4125 | 2024-06-06T12:30:00Z | 30.2 | 81.8 | false | false | false | false |
| SHIP00009 | in_transit | 0 | false | CA | ORG108 | Relief Reach | water | 2024-06-11T17:10:00Z | blank | 501 Spruce Circle | San Francisco | 94101 | USA | 77 Peace Street | Cairo | Cairo Governorate | 11511 | Egypt | 30.0444 | 31.2357 | 2024-06-13T07:10:00Z | 37.6 | 34.2 | false | false | false | false |
| SHIP00010 | at_risk | 8 | true | TX | ORG109 | Rescue United | medical supplies | 2024-06-07T13:20:00Z | blank | 150 Magnolia Road | Dallas | 75201 | USA | 36 Emergency Lane | Monrovia | Montserrado | 1000 | Liberia | 6.3156 | -10.8075 | 2024-06-13T07:25:00Z | 46.3 | 76.7 | true | true | true | true |
| SHIP00011 | delivered | 3 | true | IL | ORG100 | Aid for All | food | 2024-06-02T09:15:00Z | 2024-06-09T16:45:00Z | 123 Elm Street | Chicago | 60601 | USA | 99 Relief Lane | Delhi | Delhi | 110002 | India | 28.7041 | 77.1025 | 2024-06-09T16:40:00Z | 38.1 | 69.3 | true | false | true | false |
| SHIP00012 | in_transit | 0 | false | TX | ORG101 | Global Relief Network | water | 2024-06-12T21:45:00Z | blank | 56 Maple Lane | Houston | 77001 | USA | 101 Hope Blvd | Caracas | Capital District | 1010 | Venezuela | 10.4806 | -66.9036 | 2024-06-13T07:45:00Z | 29.5 | 70 | false | false | false | false |
| SHIP00013 | delayed | 0 | false | FL | ORG102 | HealthBridge | food | 2024-06-09T13:30:00Z | blank | 789 Cedar Drive | Miami | 33101 | USA | 9 Aid Street | Harare | Harare | 00263 | Zimbabwe | -17.8252 | 31.0335 | 2024-06-13T08:00:00Z | 27.1 | 43.4 | false | true | true | true |
| SHIP00014 | in_transit | 0 | false | WA | ORG103 | HopeLine | medical supplies | 2024-06-12T16:00:00Z | blank | 320 Oak Ave | Seattle | 98101 | USA | 2 Healing Crescent | Nairobi | Nairobi | 00100 | Kenya | -1.2921 | 36.8219 | 2024-06-13T08:25:00Z | 25.7 | 62.9 | false | false | false | false |
| SHIP00015 | at_risk | 7 | true | CO | ORG104 | Water Aid Foundation | water | 2024-06-08T05:30:00Z | blank | 220 Pine St | Denver | 80201 | USA | 72 Help Street | Kinshasa | Kinshasa | 001 | DR Congo | -4.4419 | 15.2663 | 2024-06-13T08:40:00Z | 42.1 | 11.2 | true | true | true | true |
| SHIP00016 | in_transit | 0 | false | AZ | ORG105 | BrightFuture | medical supplies | 2024-06-12T09:10:00Z | blank | 17 Willow Lane | Phoenix | 85001 | USA | 28 Forward Blvd | Maputo | Maputo | 1100 | Mozambique | -25.9692 | 32.5732 | 2024-06-13T08:55:00Z | 22.6 | 60.3 | false | false | false | false |
| SHIP00017 | delivered | 0 | false | MA | ORG106 | Hands Together | food | 2024-06-05T14:25:00Z | 2024-06-11T19:00:00Z | 102 Birch Blvd | Boston | 02101 | USA | 21 Relief Way | Jakarta | DKI Jakarta | 10110 | Indonesia | -6.2088 | 106.8456 | 2024-06-11T18:55:00Z | 30.7 | 84.2 | false | false | false | false |
| SHIP00018 | at_risk | 9 | true | GA | ORG107 | Caring Hands | medical supplies | 2024-06-09T21:10:00Z | blank | 65 Redwood St | Atlanta | 30301 | USA | 85 Save Ave | Manila | Metro Manila | 1000 | Philippines | 14.5995 | 120.9842 | 2024-06-13T09:10:00Z | 48.2 | 90.1 | true | true | true | true |
| SHIP00019 | in_transit | 0 | false | CA | ORG108 | Relief Reach | water | 2024-06-12T12:20:00Z | blank | 501 Spruce Circle | San Francisco | 94101 | USA | 77 Peace Street | Cairo | Cairo Governorate | 11511 | Egypt | 30.0444 | 31.2357 | 2024-06-13T09:25:00Z | 37.6 | 34.2 | false | false | false | false |
| SHIP00020 | delayed | 0 | false | TX | ORG109 | Rescue United | food | 2024-06-10T11:40:00Z | blank | 150 Magnolia Road | Dallas | 75201 | USA | 14 Care Road | Lima | Lima Province | 15001 | Peru | -12.0464 | -77.0428 | 2024-06-13T09:40:00Z | 18.7 | 88 | false | false | false | false |
What the 80 rows show
from the 80-row sampleAt_
- 36%shock_
event_ detected = true - 0median shock_
event_ count - 3aid types
- 22organization names
- 23organizations
- 31.7median current_
temperature_ celsius
Median 0, from 0 to 9.
- string 15
- integer 1
- float 4
- datetime 3
- boolean 5
Columns
28 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 15 columns | |||
shipment_id | string | Unique identifier for each aid shipment tracked by the systemunique | SHIP00001 |
organization_id | string | Unique identifier for the nonprofit organization responsible for the shipment | ORG100 |
organization_name | string | Name of the nonprofit organization | Aid for All |
aid_type | string | Type of humanitarian aid being shipped (e.g., medical supplies, food, water)3 types | medical supplies |
shipment_status | string | Current status of the shipment (e.g., in_transit, delivered, delayed, at_risk)in_transit · delivered · delayed · at_risk | in_transit |
origin_street_address | string | Street address of the shipment origin | 123 Elm Street |
origin_city | string | City of the shipment origin | Chicago |
origin_state | string | State or region of the shipment origin | IL |
origin_postal_code | string | Postal code of the shipment origin | 60601 |
origin_country | string | Country of the shipment origin | USA |
destination_street_address | string | Street address of the shipment destination | 45 Sunrise Ave |
destination_city | string | City of the shipment destination | Kigali |
destination_state | string | State or region of the shipment destination | Kigali City |
destination_postal_code | string | Postal code of the shipment destination | 11001 |
destination_country | string | Country of the shipment destination | Rwanda |
| Numbers 5 columns | |||
current_latitude | float | Current latitude of the shipment based on IoT sensor location-90 to 90 | -1.9441 |
current_longitude | float | Current longitude of the shipment based on IoT sensor location-180 to 180 | 30.0619 |
current_temperature_celsius | float | Current temperature inside the shipment container in degrees Celsius-50 to 100 | 23.5 |
current_humidity_percent | float | Current humidity inside the shipment container as a percentage0 to 100 | 67.3 |
shock_event_count | integer | Total number of shock events detected during the shipment's journey0 or more | 0 |
| Dates and times 3 columns | |||
departure_datetime | datetime | Date and time when the shipment departed from the origin | 2024-06-10T08:15:00Z |
arrival_datetime | datetime | Date and time when the shipment arrived at the destination (null if not yet arrived)optional | 2024-06-07T10:55:00Z |
last_sensor_update | datetime | Timestamp of the most recent IoT sensor data received for this shipment | 2024-06-13T05:20:00Z |
| True or false 5 columns | |||
shock_event_detected | boolean | Indicates if a shock event (impact or vibration) has been detected by the IoT sensor | false |
temperature_violation | boolean | Indicates if the temperature has gone outside the safe range for aid integrity at any point | false |
humidity_violation | boolean | Indicates if the humidity has gone outside the safe range for aid integrity at any point | false |
alert_flag | boolean | Indicates if any alert (shock, temperature, humidity) has been triggered for this shipment | false |
intervention_required | boolean | Indicates if shipment requires urgent intervention based on sensor data or status | false |
Use it for
A logistics dashboard
The shock_
event_ detected rate, shock_ event_ count by shipment_ status and a breakdown of origin_ state. Excel, Power BI or Tableau. Why do the 16 at_
risk rows have a mean shock_ event_ count of 4.4? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Shipments80SHIP000010in_trans…SHIP000022deliveredSHIP000056at_risk
A software demo
Believable shipments with organization_
id, organization_ name and aid_ type to fill a screen in front of a buyer.
blueprint · iot-shipment-tracking-for-nonprofits
Behind this dataset
Same schema. As many rows as you need.
These 80 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.
- Each shipment record must include a unique shipment ID and aid type.
- IoT sensor data fields (location, temperature, humidity, shock event) are updated at each checkpoint.
- Trigger an alert if temperature or humidity deviates from safe ranges for aid materials.
- Flag shipments that experience more than two shock events for inspection.
- Provide delivery confirmation and recipient verification at destination.
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
- iot-shipment-tracking-for-nonprofits