electricsheepafrica/africa-aid-flows-zambia

---
annotations_creators:
- no-annotation
language_creators:
- found
language:
- en
license: other
multilinguality:
- monolingual
size_categories:
- 10K<n<100K
source_datasets:
- original
task_categories:
- tabular-classification
- tabular-regression
task_ids: []
tags:
- africa
- humanitarian
- hdx
- electric-sheep-africa
- funding
- who-is-doing-what-and-where-3w-4w-5w
- zmb
pretty_name: "Zambia - Current IATI Aid Activities"
dataset_info:
splits:
- name: train
num_examples: 11592
- name: test
num_examples: 2898
---

# Zambia - Current IATI Aid Activities

**Publisher:** International Aid Transparency Initiative · **Source:** [HDX](https://data.humdata.org/dataset/iati-zmb) · **License:** `hdx-other` · **Updated:** 2026-04-24

---

## Abstract

List of active aid activities shared via the International Aid Transparency Initiative (IATI). Includes both humanitarian and development activities. More information on each activity (including financial data) is available from [http://www.d-portal.org](http://www.d-portal.org)

Each row in this dataset represents country-level aggregates. Temporal coverage is indicated by the `day_start`, `day_end` column(s). Geographic scope: **ZMB**.

*Curated into ML-ready Parquet format by [Electric Sheep Africa](https://huggingface.co/electricsheepafrica).*

---

## Dataset Characteristics

| | |
|---|---|
| **Domain** | Humanitarian and development data |
| **Unit of observation** | Country-level aggregates |
| **Rows (total)** | 14,490 |
| **Columns** | 27 (12 numeric, 13 categorical, 2 datetime) |
| **Train split** | 11,592 rows |
| **Test split** | 2,898 rows |
| **Geographic scope** | ZMB |
| **Publisher** | International Aid Transparency Initiative |
| **HDX last updated** | 2026-04-24 |

---

## Variables

**Geographic** — `day_start`, `day_end`, `day_length` (range 0.0–28853.0), `country_code`, `country_percent` (range 0.0–100.0).

**Outcome / Measurement** — `sector_percent` (range 0.0–100.0).

**Identifier / Metadata** — `aid` (http://d-portal.org/q.html?aid=NL-KVK-27378529-4000002092, http://d-portal.org/q.html?aid=NL-KVK-27378529-26067, http://d-portal.org/q.html?aid=AU-5-INO718), `reporting_ref` (US-GOV-1, SE-0, GB-GOV-1), `funder_ref` (US-GOV-1, SE, US), `title` (USAID redacted this field in accordance with the exceptions outlined in the Foreign Aid Transparency and Accountability Act of 2016., USAID Travel and Transportation, USAID Pay and Benefits), `status_code` (Finalisation, Implementation, Closed) and 3 others.

**Other** — `reporting` (U.S. Agency for International Development, Sweden, UK - Foreign, Commonwealth Development Office (FCDO)), `slug` (usaid-zm, ausgov-activity, rvo-01), `description` (This program supports the Mission's goal for an independent, prosperous, and healthy Ukraine united around core European values in one or more of the following sectors: strengthening of democratic governance, and more inclusive, sustainable, market-driven economic growth., Administrative costs and operating expenses of USAID contributing to Travel and Transportation., Administrative costs and operating expenses of USAID contributing to Payrolls and Benefits.), `commitment` (range -24904154.0–6789381600.0), `spend` (range -3489498.2–5922666500.0) and 8 others.

---

## Quick Start

```python
from datasets import load_dataset

ds = load_dataset("electricsheepafrica/africa-aid-flows-zambia")
train = ds["train"].to_pandas()
test = ds["test"].to_pandas()

print(train.shape)
train.head()
```

---

## Schema

| Column | Type | Null % | Range / Sample Values |
|---|---|---|---|
| `aid` | object | 0.0% | http://d-portal.org/q.html?aid=NL-KVK-27378529-4000002092, http://d-portal.org/q.html?aid=NL-KVK-27378529-26067, http://d-portal.org/q.html?aid=AU-5-INO718 |
| `reporting` | object | 0.0% | U.S. Agency for International Development, Sweden, UK - Foreign, Commonwealth Development Office (FCDO) |
| `reporting_ref` | object | 0.0% | US-GOV-1, SE-0, GB-GOV-1 |
| `funder_ref` | object | 0.0% | US-GOV-1, SE, US |
| `title` | object | 0.0% | USAID redacted this field in accordance with the exceptions outlined in the Foreign Aid Transparency and Accountability Act of 2016., USAID Travel and Transportation, USAID Pay and Benefits |
| `slug` | object | 0.0% | usaid-zm, ausgov-activity, rvo-01 |
| `status_code` | object | 0.0% | Finalisation, Implementation, Closed |
| `day_start` | datetime64[ns] | 0.0% | |
| `day_end` | datetime64[ns] | 0.0% | |
| `day_length` | float64 | 0.1% | 0.0 – 28853.0 (mean 1507.0428) |
| `description` | object | 0.2% | This program supports the Mission's goal for an independent, prosperous, and healthy Ukraine united around core European values in one or more of the following sectors: strengthening of democratic governance, and more inclusive, sustainable, market-driven economic growth., Administrative costs and operating expenses of USAID contributing to Travel and Transportation., Administrative costs and operating expenses of USAID contributing to Payrolls and Benefits. |
| `commitment` | float64 | 0.0% | -24904154.0 – 6789381600.0 (mean 36138816.5919) |
| `spend` | float64 | 0.0% | -3489498.2 – 5922666500.0 (mean 31914002.3121) |
| `commitment_eur` | float64 | 0.0% | -22979302.0 – 6054103000.0 (mean 31636005.3468) |
| `spend_eur` | float64 | 0.0% | -3077950.5 – 5275019300.0 (mean 28188748.0955) |
| `commitment_gbp` | float64 | 0.0% | -19736016.0 – 5257404000.0 (mean 26966777.6766) |
| `spend_gbp` | float64 | 0.0% | -2615915.0 – 4592923600.0 (mean 24123405.5512) |
| `commitment_cad` | float64 | 0.0% | -33101422.0 – 9021294000.0 (mean 46615637.0951) |
| `spend_cad` | float64 | 0.0% | -4449686.0 – 7843841000.0 (mean 41569122.5922) |
| `flags` | int64 | 0.0% | 0.0 – 0.0 (mean 0.0) |
| `sector_group` | object | 2.2% | Government & Civil Society-general, Population Policies/Programmes & Reproductive Health, Agriculture |
| `sector_code` | object | 6.4% | STD control including HIV/AIDS, Administrative costs (non-sector allocable), Democratic participation and civil society |
| `sector_percent` | float64 | 2.2% | 0.0 – 100.0 (mean 45.2438) |
| `country_code` | object | 0.0% | |
| `country_percent` | float64 | 0.0% | 0.0 – 100.0 (mean 51.0304) |
| `esa_source` | object | 0.0% | |
| `esa_processed` | object | 0.0% | |

---

## Numeric Summary

| Column | Min | Max | Mean | Median |
|---|---|---|---|---|
| `day_length` | 0.0 | 28853.0 | 1507.0428 | 1094.0 |
| `commitment` | -24904154.0 | 6789381600.0 | 36138816.5919 | 484042.53 |
| `spend` | -3489498.2 | 5922666500.0 | 31914002.3121 | 593060.15 |
| `commitment_eur` | -22979302.0 | 6054103000.0 | 31636005.3468 | 432555.0 |
| `spend_eur` | -3077950.5 | 5275019300.0 | 28188748.0955 | 524117.84 |
| `commitment_gbp` | -19736016.0 | 5257404000.0 | 26966777.6766 | 368414.0 |
| `spend_gbp` | -2615915.0 | 4592923600.0 | 24123405.5512 | 452286.12 |
| `commitment_cad` | -33101422.0 | 9021294000.0 | 46615637.0951 | 639598.12 |
| `spend_cad` | -4449686.0 | 7843841000.0 | 41569122.5922 | 783164.6 |
| `flags` | 0.0 | 0.0 | 0.0 | 0.0 |
| `sector_percent` | 0.0 | 100.0 | 45.2438 | 30.75 |
| `country_percent` | 0.0 | 100.0 | 51.0304 | 32.9917 |

---

## Curation

Raw data was downloaded from HDX via the CKAN API and converted to Parquet. Column names were lowercased and standardised to snake_case. Common missing-value markers (`N/A`, `null`, `none`, `-`, `unknown`, `no data`, `#N/A`) were unified to `NaN`. 25 exact duplicate rows were removed. 2 column(s) were cast from string to numeric or datetime based on parse-success rate (>85% threshold). The dataset was split 80/20 into train and test partitions using a fixed random seed (42) and saved as Snappy-compressed Parquet.

---

## Limitations

- Data originates from International Aid Transparency Initiative and has not been independently validated by ESA.
- Automated cleaning cannot correct for misreported values, definitional inconsistencies, or sampling bias in the original collection.
- Refer to the [original HDX dataset page](https://data.humdata.org/dataset/iati-zmb) for the publisher's own methodology notes and caveats.

---

## Citation

```bibtex
@dataset{hdx_africa_aid_flows_zambia,
title = {Zambia - Current IATI Aid Activities},
author = {International Aid Transparency Initiative},
year = {2026},
url = {https://data.humdata.org/dataset/iati-zmb},
note = {Repackaged for machine learning by Electric Sheep Africa (https://huggingface.co/electricsheepafrica)}
}
```

---

*[Electric Sheep Africa](https://huggingface.co/electricsheepafrica) — Africa's ML dataset infrastructure. Lagos, Nigeria.*