Osman-Geomatics93/duckdb-sudan-

# DuckDB Sudan Extension **Unified SQL access to Sudan's humanitarian, development, and geospatial data from 5 international APIs** **Explore the Documentation** | **View on GitHub** | **Report Bug** --- Sudan is experiencing one of the world's largest humanitarian crises, yet its data is scattered across dozens of international APIs with incompatible formats and authentication schemes. This extension brings **all publicly available Sudan data into DuckDB** — enabling analysts, researchers, and humanitarian workers to query demographics, economics, health, agriculture, displacement, and geospatial boundaries using standard SQL. > **Interactive Documentation** — Visit **osman-geomatics93.github.io for live charts, interactive map, SQL playground, and bilingual (Arabic/English) reference. ## Video Tutorial **Complete walkthrough covering installation, setup (local & Google Colab), and live usage examples.** ## Data Providers | Provider | Function | Data | Rows (Sudan) | |----------|----------|------|:------------:| | World Bank | `SUDAN_WorldBank()` | Development indicators, GDP, population, education | 65+ | | WHO | `SUDAN_WHO()` | Health indicators, disease burden, mortality | 39+ | | FAO | `SUDAN_FAO()` | Agricultural production, food security, land use | 188+ | | UNHCR | `SUDAN_UNHCR()` | Refugees, IDPs, asylum seekers, displacement | 122+ | | ILO | `SUDAN_ILO()` | Employment, labor force, unemployment | 302+ | Plus **12 SQL functions** including indicator search, geospatial boundaries, and bilingual (Arabic/English) state data. ## Quick Start ### Option A: Install from Online Repository (Recommended) No building required — works with any DuckDB v1.4.4+ installation. **Step 1:** Launch DuckDB with unsigned extension support ```cmd duckdb -unsigned ``` **Step 2:** Install and load the extension ```sql INSTALL httpfs; LOAD httpfs; SET custom_extension_repository = 'osman-geomatics93.github.io'; IN …