KNBS 2019 County and Sub-County Code List

This dataset maps Kenyan counties to their constituent sub-counties.
Each county and sub-county is assigned a unique numerical code.
The county_code ranges from 1 to 47, indicating 47 distinct counties.
The subcounty_code appears to incorporate the county_code as its prefix, suggesting a hierarchical coding structure.
"KITUI" has the most sub-counties listed, followed by "KIAMBU" and "KAKAMEGA".
There are no apparent missing values or outliers in the provided summary statistics.
The subcounty_name column shows unique values for each entry, indicating no duplicate sub-county names across different counties.
How many sub-counties does each county have?
What is the numerical range of sub-county codes within a specific county?
Which counties have the fewest sub-counties?

Column	Type	Nulls	Unique	Stats / Top values
county_code	number	—	47	mean 25.0449 · min 1 · max 47 · median 24
county_name	string	—	47	KITUI (18)KIAMBU (13)KAKAMEGA (13)MERU (11)NAKURU (11)
subcounty_code	number	—	334	mean 2509.1976 · min 101 · max 4711 · median 2401.5
subcounty_name	string	—	334	CHANGAMWE (1)BUURI EAST (1)JOMVU (1)BUURI WEST (1)KISAUNI (1)

Insights