Open Data and Disclosures
Access machine-readable administrative datasets, schema architectures, and open public registers maintained on CitizenGuide.KE.
Open Data Policy
In accordance with international open-data conventions and public access transparency standards, CitizenGuide.KE distributes consolidated datasets under a public domain attribution framework. Developers, civil researchers, and citizens are free to extract, reuse, and redistribute this information without cost.
Available Datasets
Download complete raw records tables processed into standard comma-separated value (CSV) formats:
- Counties of Kenya Directory CSV (48KB)— Contains names, official codes, geographic regions, population densities, and registered leadership names for all 47 counties.
- Constituencies and Wards Mapping CSV (310KB)— Complete relational lookup linking all 1,450 electoral wards back to their parent 290 constituencies and respective county codes.
- National Executive Ministries & State Departments CSV (115KB)— Comprehensive structural index details outlining active cabinet portfolios, sub-tier dockets, and administrative head titles.
Data Schemas & Integration
Review our structural relational mapping tables to understand the database types when linking into external environments like Supabase or Sanity:
Wards Table Schema Layout
Core datatypes used inside the administrative ward index mapping tracks:
- id: uuid (PRIMARY KEY)
- slug: text (UNIQUE INDEX)
- name: text (NOT NULL)
- ward_code: text
- constituency_name: text
- county_name: text
- registered_voters_2022: integer
Institutions Table Schema Layout
Core fields tracking national ministries, state departments, and semi-autonomous agencies:
- id: uuid (PRIMARY KEY)
- slug: text (UNIQUE INDEX)
- name: text (NOT NULL)
- institution_type: text ('Ministry' | 'State Department')
- government_level: text ('National' | 'County')
- parent_institution_id: uuid (FOREIGN KEY)
Accuracy and Discrepancy Reporting
While data tables undergo rigorous validation cycles against gazetted notices before release, automated parsing updates may occasionally flag formatting discrepancies. If you identify a mismatched ward code or an unaligned expenditure figure within a CSV stream, please submit a structural data check on our Contact page with the specific column reference.