electricsheepafrica/africa-egypt-capmas-public-utility-services-city-and-district-council-level-0ce12220

Public Utility Services - City and District Council Level | Africa (CAPMAS Egypt Open Data)

5,952 rows - 1 Africa country/area - 2010-2023 - 128 indicators - Engineered by [Electric Sheep Africa](https://huggingface.co/electricsheepafrica)

TL;DR

This dataset contains 5,952 rows from CAPMAS Egypt Open Data, covering Public Utility Services - City and District Council Level. It is published as ML-ready Parquet with consistent Hugging Face metadata, source provenance, and analysis-friendly loading examples.

What This Dataset Measures

Official statistics datasets help analysts inspect public data as published by governments, national statistical systems, and regional data portals.

This dataset covers Public Utility Services - City and District Council Level from CAPMAS Egypt Open Data. Use the source and schema sections below to confirm definitions, units, and collection methodology before sensitive analytical use.

How To Read This Dataset

• —One row means: one indicator observation for one geography, time period, and optional source dimensions.
• —Primary geography column: source metadata (EGY).
• —Best time column: year.
• —Time coverage basis: year.
• —Recommended join keys: year, indicator_id, plus source-specific dimension columns.

Coverage

Geographic Coverage

Top areas shown below, sorted by row count when available:

Indicators, Variables, Or Resource Contents

• —2946 - Total number of residential buildings by type of construction at the level of city and neighborhood councils(Number)
• —3130 - Total number of beaches and their facilities by sector (public works, government, private)(Number)
• —2976 - Total Number of Fire Incidents Distributed by Location(Number)
• —2981 - Total losses in individuals due to fire incidents(Number)
• —2941 - Total number of fire stations and number of fires(Number)
• —9440 - Total Number of Fire Incidents Distributed by Months of the Year for the Governorates(Number)
• —3223 - Total property losses due to fire incidents(EGP Thousand)
• —3256 - Total Number of Fire Stations in the Governorates(Number)
• —2983 - Total number of fire incidents according to their causes(Number)
• —2982 - Total number of fire incidents by their causes in the governorates(Number)
• —2945 - Total Number of Building Permits by Sector(Number)
• —3066 - Total Weight and Quantity of Waste (in tons) According to the Entity Responsible for Disposal(Ton)
• —3207 - Total Number of Public Toilets in the Municipalities and Neighborhood Councils(Number)
• —9441 - Total number of parks and gardens according to their types within the councils of cities and neighborhoods in the governorates.(Number)
• —9442 - Total Number of Parks and Gardens within the Jurisdiction of City and Neighborhood Councils(Number)
• —2958 - Total number of public restrooms within the jurisdiction of city and neighborhood councils in the governorates(Number)
• —3022 - Total Amount of Waste (in tons) within the Scope of City and Neighborhood Councils in the Governorates(Ton)
• —3015 - Total Length of Newly Constructed Roads in Cities(kilometer)
• —3008 - Total Length of Maintained Roads in Cities(kilometer)
• —3023 - Total Amount of Waste (in cubic meters) within the Scope of City and Neighborhood Councils in the Governorates(M3)
• —... 108 more indicators

Schema

Usage

from datasets import load_dataset

ds = load_dataset("electricsheepafrica/africa-egypt-capmas-public-utility-services-city-and-district-council-level-0ce12220")
df = ds["train"].to_pandas()
print(df.head())

Inspect Columns

print(df.info())
print(df.head())

Filter By Geography

# This dataset is scoped to Egypt in source metadata.
sample = df.copy()

Time-Series Pattern

if "value" in df.columns and "year" in df.columns:
    trend = df.sort_values("year")

Pivot For Analysis

if {"indicator_id", "year", "value"}.issubset(df.columns):
    matrix = df.pivot_table(index="year", columns="indicator_id", values="value")
    print(matrix.tail())

Data Quality Notes

• —Canonical time field: year.
• —Missing values are preserved rather than silently imputed.
• —Column names are standardized for machine use; source meanings are preserved where known.
• —Always confirm source methodology, units, and collection definitions before policy, production, or redistribution-sensitive use.

Source And Provenance

• —Source: CAPMAS Egypt Open Data
• —Publisher: Central Agency for Public Mobilisation and Statistics (CAPMAS), Egypt
• —Portal: https://www.capmas.gov.eg
• —Resource: Public Utility Services - City and District Council Level
• —License: Source-specific or other license
• —Retrieved/generated: 2026-08-08T13:12:21Z
• —Hugging Face repo: electricsheepafrica/africa-egypt-capmas-public-utility-services-city-and-district-council-level-0ce12220

Transformations Applied

• —Converted the source table to Parquet for efficient analytics and ML workflows.
• —Added or preserved source provenance columns where available.
• —Standardized README metadata, dataset loading configuration, schema documentation, and citation format.
• —Preserved source-reported values without analytical imputation.

Suggested Analyses

• —Profile the distribution of values
• —Compare categories or geographies
• —Join with complementary public datasets
• —Build time-series views and period-over-period comparisons
• —Pivot to indicator x period matrices
• —Check missingness before modeling
• —Use source or repo metadata for country scope when a geography column is not present

Citation

@misc{electric_sheep_africa_africa_egypt_capmas_public_utility_services_city_and_district_council_level_0ce1_2023,
  title        = {Public Utility Services - City and District Council Level | Africa (CAPMAS Egypt Open Data)},
  author       = {Central Agency for Public Mobilisation and Statistics (CAPMAS), Egypt},
  year         = {2023},
  url          = {https://www.capmas.gov.eg},
  publisher    = {Hugging Face Datasets, engineered by Electric Sheep Africa},
  howpublished = {\url{https://huggingface.co/datasets/electricsheepafrica/africa-egypt-capmas-public-utility-services-city-and-district-council-level-0ce12220}}
}

License

Released under Source-specific or other license.

Original data is published by Central Agency for Public Mobilisation and Statistics (CAPMAS), Egypt. Electric Sheep Africa engineering standardizes the data for discovery, loading, and analysis on Hugging Face. Cite both the original source and this ML-ready dataset when used.

About Electric Sheep Africa

Electric Sheep Africa publishes ML-ready African public datasets on Hugging Face.

Provenance: README standardized 2026-08-11 by the Electric Sheep Africa README system. Source URL: https://www.capmas.gov.eg