Educational Aid Supply Chain Tracking

This dataset tracks the end-to-end supply chain of educational resource kits distributed to remote learners, capturing detailed shipment, inventory, and delivery data across multiple regions and partners. It enables NGOs and education organizations to identify bottlenecks, monitor delivery performance, and address inventory gaps for more efficient and equitable resource allocation.

  • last updated 26 Jan 2026
  • by GoMask
The brief that made it

Monitor and optimize the delivery of educational kits to remote learners

Sample rows

preview · 8 of 80 rows · all 26 columns
shipment_idstringdestination_countrystringquantity_shippedintegerinventory_gap_flagbooleandestination_region_idstringkit_idstringkit_namestringorigin_warehouse_idstringorigin_warehouse_namestringorigin_warehouse_citystringorigin_warehouse_statestringorigin_warehouse_countrystringdestination_region_namestringdestination_citystringdestination_statestringrecipient_partner_idstringrecipient_partner_namestringshipment_statusstringshipment_created_datedatetimeshipment_dispatched_datedatetimeshipment_expected_delivery_datedateshipment_actual_delivery_datedatedelivery_delay_daysintegerreported_bottleneckstringlast_updateddatetimekit_contentsstring
SHP0001Kenya120falseREG-KE-01KIT101Primary School Basic KitWH-01Central Distribution CenterNairobiNairobi CountyKenyaWestern HighlandsKisumuKisumu CountyNGO-01Education for All Kenyadelivered2023-09-18T10:15:002023-09-19T09:40:002023-09-232023-09-241Heavy rains delayed truck transit2023-09-25T17:20:00{"books":5,"notebooks":10,"pens":5,"pencils":10}
SHP0002Kenya60falseREG-KE-02KIT102Secondary STEM KitWH-02Mombasa StorageMombasaMombasa CountyKenyaCoastal BeltMalindiKilifi CountyNGO-02STEM Outreach Africain_transit2023-09-20T14:30:002023-09-21T08:10:002023-09-25blankblankblank2023-09-22T12:50:00{"lab_manuals":3,"calculators":2,"science_kits":1}
SHP0003Kenya40falseREG-KE-03KIT103Digital Learning KitWH-03Eldoret HubEldoretUasin GishuKenyaRift ValleyKitaleTrans NzoiaNGO-03Digital Literacy Trustpending2023-09-22T08:45:00blank2023-09-28blankblankblank2023-09-22T08:45:00{"tablets":2,"chargers":2,"workbooks":4}
SHP0004Kenya80falseREG-KE-04KIT104Girls Empowerment KitWH-01Central Distribution CenterNairobiNairobi CountyKenyaNorthern FrontierMarsabitMarsabit CountyNGO-04Girls First Initiativedelayed2023-09-15T11:00:002023-09-16T10:30:002023-09-202023-09-266Road closure due to landslide2023-09-26T20:00:00{"sanitary_pads":20,"books":3,"guidance_pamphlets":2}
SHP0005Tanzania150falseREG-TZ-01KIT101Primary School Basic KitWH-02Mombasa StorageMombasaMombasa CountyKenyaLake ZoneMwanzaMwanzaNGO-05Tanzania Education Funddelivered2023-09-19T09:50:002023-09-20T08:15:002023-09-252023-09-250blank2023-09-25T16:00:00{"books":5,"notebooks":10,"pens":5,"pencils":10}
SHP0006Tanzania70falseREG-TZ-02KIT102Secondary STEM KitWH-04Arusha DepotArushaArushaTanzaniaNorthern TanzaniaMoshiKilimanjaroNGO-06STEM Tanzaniain_transit2023-09-21T13:05:002023-09-22T09:00:002023-09-27blankblankblank2023-09-22T13:30:00{"lab_manuals":3,"calculators":2,"science_kits":1}
SHP0007Uganda35trueREG-UG-01KIT105Inclusive Learning KitWH-03Eldoret HubEldoretUasin GishuKenyaCentral UgandaKampalaKampalaNGO-07Uganda Inclusive Educationpending2023-09-23T07:40:00blank2023-09-29blankblankblank2023-09-23T07:40:00{"braille_books":3,"audio_devices":1,"visual_aids":2}
SHP0008Uganda50falseREG-UG-02KIT104Girls Empowerment KitWH-05Kampala FacilityKampalaKampalaUgandaEastern UgandaMbaleMbaleNGO-08Girls Empowerment Ugandadelivered2023-09-17T16:20:002023-09-18T09:30:002023-09-222023-09-231Congested traffic in Mbale2023-09-23T17:45:00{"sanitary_pads":20,"books":3,"guidance_pamphlets":2}

What the 80 rows show

from the 80-row sample

Tanzania (destination country) stands out: mean quantity_shipped is 95.1, against 51.6 for the rest.

  • 23%inventory_gap_flag = true
  • 49.5median quantity_shipped
  • 4origin warehouse countries
  • 5shipment statuses
  • 11kits
  • 11kit names
Mean quantity_shipped by destination_country80 rows
05010041.8India40 rows63.3Kenya20 rows95.1Tanzania11 rows69.4Uganda9 rows
quantity_shipped80 rows, in bands of 20
01530262711643320100160quantity_shipped →

Median 49.5, from 22 to 150.

destination_region_id80 rows · top 10 of 31 values
  1. REG-TZ-015
  2. REG-KE-034
  3. REG-KE-054
  4. REG-2104
  5. REG-KE-013
  6. REG-KE-023
  7. REG-KE-043
  8. REG-TZ-023
  9. REG-TZ-033
  10. REG-KE-063
26 columns by typefrom the column list below
  • string 18
  • integer 2
  • date 2
  • datetime 3
  • boolean 1

Columns

26 columns in four groups
blueprint · 26 columns
columntypedescriptionexample
Text 18 columns
shipment_idstringUnique identifier for each shipment of educational resource kitsuniqueSHP0001
kit_idstringUnique identifier for the type of educational resource kit being shipped11 kitsKIT101
kit_namestringDescriptive name of the educational resource kit11 namesPrimary School Basic Kit
kit_contentsstringJSON object listing the contents of the kit (e.g., books, stationery, devices)optional{"books":5,"notebooks":10…
origin_warehouse_idstringUnique identifier for the warehouse or storage location from which the shipment originatesWH-01
origin_warehouse_namestringName of the origin warehouse or storage facilityMombasa Storage
origin_warehouse_citystringCity where the origin warehouse is locatedNairobi
origin_warehouse_statestringState or province of the origin warehouseoptionalNairobi County
origin_warehouse_countrystringCountry of the origin warehouse4 countriesKenya
destination_region_idstringUnique identifier for the destination region or areaREG-KE-01
destination_region_namestringName of the destination region or areaWestern Highlands
destination_citystringCity of the final delivery locationoptionalKisumu
destination_statestringState or province of the final delivery locationoptionalKisumu County
destination_countrystringCountry of the final delivery location4 countriesKenya
recipient_partner_idstringUnique identifier for the NGO or education partner receiving the shipmentNGO-01
recipient_partner_namestringName of the NGO or education partner receiving the shipmentEducation for All Kenya
shipment_statusstringCurrent status of the shipmentpending · in_transit · delivered · delayed · cancelleddelivered
reported_bottleneckstringDescription of any supply chain bottleneck encountered during this shipmentoptionalCustoms paperwork issue
Numbers 2 columns
quantity_shippedintegerNumber of kits shipped in this shipment1 or more120
delivery_delay_daysintegerNumber of days the delivery was delayed (if any)0 or more · optional1
Dates and times 5 columns
shipment_created_datedatetimeTimestamp when the shipment record was created2023-09-18T10:15:00
shipment_dispatched_datedatetimeTimestamp when the shipment left the origin warehouseoptional2023-09-19T09:40:00
shipment_expected_delivery_datedateExpected date of delivery to the destination2023-09-23
shipment_actual_delivery_datedateActual date when the shipment was deliveredoptional2023-09-24
last_updateddatetimeTimestamp of the last update to this shipment record2023-09-25T17:20:00
True or false 1 column
inventory_gap_flagbooleanIndicates if there was an inventory gap at the origin warehouse for this shipmentfalse

Use it for

  • inventory gap …23%18 of 80 rowsmean quantity shipped…41.8India63.3Kenya95.1Tanz…69.4Ugan…

    A logistics dashboard

    The inventory_gap_flag rate, quantity_shipped by destination_country and a breakdown of destination_region_id. Excel, Power BI or Tableau.

  • Why do the 11 Tanzania rows have a mean quantity_shipped of 95.1?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable shipments with kit_id, kit_name and kit_contents to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 26 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset80 rows26 columns
Yours1,000 rows26 columnsorigin_warehouse_city: UK only

blueprint · educational-aid-supply-chain-tracking

Behind this dataset

Same schema. As many rows as you need.

These 80 rows came out of a blueprint — 26 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 row represents a shipment of education kits to a specific school or region.
  • Track shipment status: pending, in transit, delivered, delayed, canceled.
  • Capture quantity shipped, source warehouse, and intended beneficiary count.
  • Flag deliveries delayed over 5 days for escalation.
  • Include a field for last-mile partner organization.
Rows
Open the blueprint in Data Factory

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
educational-aid-supply-chain-tracking

More in Logistics

Browse all
Also in LogisticsSupply Chain Disruption SimulationsDelivery Route Optimization DatasetSupply Chain Inventory MovementsAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.