Overall, cleaning the geographic data has shown that there is still some confusion amongst those reporting over the exact definition of administrative divisions in Kenya. Admin level 0 is the country, Kenya, itself. At admin level 1 is the County – there are 47 of these political entities who have various devolved powers outlined in the Constitution of Kenya; each directly elects their governor.
Additionally, each county has a County Assembly, formed of elected representatives of single-seat constituencies known as wards. Constituencies are considered to be admin level 2, the second level of administrative division in Kenya, and it is these boundaries which have been marked by the shapefiles found in HDX. These sometimes do not overlap with the political entities known as sub-counties, though their most notable misalignment is when it comes to urban areas. Sub-counties might better represent the lived realities, or the preferences, of the national and local governments. There is no perfect way to develop administrative boundaries – though there are usually rules about fairness in the allocation of constituencies.
Ultimately, the UN recognises these constituencies as the official – to the government of Kenya – boundaries as the second administrative level. This is reflected in the shapefiles required to generate maps. Should an actual map of sub-counties be desired, UNICEF is encouraged to meet these demands with its own capacity, in coordination with local authorities.
Until such data is collected – an unlikely prospect – it would be best for UNICEF personnel and partners to report at the level of the constituency. Typically, the officially-recognised administrative boundaries are used for reporting, this is doubly important given that they have p-codes which can be matched against constituency codes created by the Kenyan government as well as against sources of official data, such as the Census.
Though how well that aligns with actual political realities and the administration of these territories is something for UNICEF to figure out on its own. UNICEF may compare current boundaries with the old defunct sub-counties (collected here by the America Red Cross). But what is more important is that a decision be taken on adherence to using constituencies for reporting and standardising the reporting received from partners and the field.
It would also be advised to start collecting ward-level data, especially in urban areas. Insufficient granularity is possible from 5W submissions from UNICEF, though not its partners and the other members of the EiE working group. Given this, it is recommended that implementing partners be tasked with completing the relevant reporting and UNICEF compensate them with increased allotments in M&E and IM budgets for the burden placed on them.
This exercise has underscored the importance of standardised reporting and as well as the use of pcodes.
As mentioned, the matching of constituencies and sub-counties is incomplete. Even though I prioritised counties that UNICEF are currently working in. Some of these areas are national forests, whilst others, such as Embakasi, encompass a range of constituencies.
Below is a list of the number of sub-counties per county yet to be matched to constituency PCodes:
county | count |
|---|---|
Kisii | 11 |
Kitui | 11 |
Nyandarua | 6 |
Kakamega | 5 |
Kericho | 5 |
Embu | 4 |
Murang'a | 4 |
Nandi | 4 |
Nyamira | 4 |
Busia | 3 |
Homa Bay | 3 |
Nakuru | 3 |
Nyeri | 3 |
Kiambu | 2 |
Laikipia | 2 |
Meru | 2 |
Bungoma | 1 |
Kirinyaga | 1 |
Nairobi | 1 |
Narok | 1 |
Siaya | 1 |
Tharaka-Nithi | 1 |
Vihiga | 1 |
West Pokot | 1 |
The following outputs are produced by this file:
locations.csv – updated locations and their
alternate names. Pay attention to the columns adm2alt1en
and adm2alt2en: these are where the alternate names of each
constituency have been recorded. Download here
locations_match.csv – file for matching sub-county
pcodes with constituency pcodes. In long format, with all names and
alternate names recorded under the column adm2_en. Download
here
census_adm2_incomplete.csv – columns are listed
below. But this is a collection of basic data at the sub-county level,
including the population, average household size, and the breakdown of
children by by age group. As noted, sub-county and constituency matching
is incomplete. Download here
poverty.csv – county-level poverty incidence and
counts. Download here
census_adm2_incomplete %>%
glimpse()
## Rows: 346
## Columns: 15
## $ county <chr> "Mombasa", "Mombasa", "Mombasa", "Mombasa", "Mo~
## $ sub_county <chr> "Changamwe", "Jomvu", "Kisauni", "Likoni", "Mvi~
## $ admin_area <chr> "SubCounty", "SubCounty", "SubCounty", "SubCoun~
## $ population <dbl> 130541, 162760, 287131, 249230, 147983, 213342,~
## $ number_of_households <dbl> 46614, 53472, 88202, 81191, 38995, 69948, 16043~
## $ average_household_size <dbl> 2.8, 3.0, 3.3, 3.1, 3.8, 3.1, 5.8, 5.3, 4.9, 3.~
## $ constituency <chr> "Changamwe", "Jomvu", "Kisauni", "Likoni", "Mvi~
## $ adm1_pcode <chr> "KE001", "KE001", "KE001", "KE001", "KE001", "K~
## $ adm2_pcode <chr> "KE001001", "KE001002", "KE001003", "KE001005",~
## $ fo <chr> NA, NA, NA, NA, NA, NA, "Nairobi", "Nairobi", "~
## $ sub_county_pcode <chr> "KEN_1_101", "KEN_1_102", "KEN_1_103", "KEN_1_1~
## $ age_0_4 <dbl> 14775, 21156, 37972, 33633, 15502, 24865, 16100~
## $ age_5_9 <dbl> 13318, 18957, 33008, 28202, 14719, 21782, 16309~
## $ age_10_14 <dbl> 11943, 16728, 29343, 23882, 14263, 19265, 15105~
## $ age_15_17 <dbl> 5773, 7564, 14610, 11987, 8355, 9769, 7217, 146~
Verification and matching needed. This is from the Africa Research and Impact Network.