Programming & Development / April 11, 2025

How to Represent Kenya’s Counties in Java and SQL Using ISO 3166-2 Codes

Kenya counties Java enum Kenya ISO 3166-2 KE SQL Kenya counties KE county codes Kenya administrative divisions backend region enum Kenya counties Java SQL Spring Boot regions Kenya

🇰🇪 Java Enum: Kenya’s Counties

Kenya is divided into 47 counties. Here’s the Java enum using ISO 3166-2:KE codes:

java

public enum KenyaCounty {
    BOMET("KE-01"),
    BUNGOMA("KE-02"),
    BUSIA("KE-03"),
    ELGEYO_MARAKWET("KE-04"),
    EMBU("KE-05"),
    GARISSA("KE-06"),
    HOMABAY("KE-07"),
    ISIOLO("KE-08"),
    KAJIADO("KE-09"),
    KAKAMEGA("KE-10"),
    KERICHO("KE-11"),
    KIAMBU("KE-12"),
    KILIFI("KE-13"),
    KIRINYAGA("KE-14"),
    KISII("KE-15"),
    KISUMU("KE-16"),
    KITUI("KE-17"),
    KWALE("KE-18"),
    LAIKIPIA("KE-19"),
    LAMU("KE-20"),
    MACHAKOS("KE-21"),
    MANDERA("KE-22"),
    MARSABIT("KE-23"),
    MERU("KE-24"),
    MIGORI("KE-25"),
    MOMBASA("KE-26"),
    MURANGA("KE-27"),
    NANDI("KE-28"),
    NAROK("KE-29"),
    NYAMIRA("KE-30"),
    NYANDARUA("KE-31"),
    NYERI("KE-32"),
    SAMBURU("KE-33"),
    SIAYA("KE-34"),
    TANARIVER("KE-35"),
    THARAKA_NITHI("KE-36"),
    Trans_Nzoia("KE-37"),
    TURKANA("KE-38"),
    UASIN_GISHU("KE-39"),
    VIHIGA("KE-40"),
    Wajir("KE-41"),
    WEST_POKOT("KE-42"),
    NAIROBI("KE-47");

    private final String code;

    KenyaCounty(String code) {
        this.code = code;
    }

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

CREATE TABLE kenya_counties (
    id SERIAL PRIMARY KEY,
    name VARCHAR(64) NOT NULL,
    code VARCHAR(8) NOT NULL UNIQUE
);

INSERT INTO kenya_counties (name, code) VALUES
('Bomet', 'KE-01'),
('Bungoma', 'KE-02'),
('Busia', 'KE-03'),
('Elgeyo Marakwet', 'KE-04'),
('Embu', 'KE-05'),
('Garissa', 'KE-06'),
('Homa Bay', 'KE-07'),
('Isiolo', 'KE-08'),
('Kajiado', 'KE-09'),
('Kakamega', 'KE-10'),
('Kericho', 'KE-11'),
('Kiambu', 'KE-12'),
('Kilifi', 'KE-13'),
('Kirinyaga', 'KE-14'),
('Kisii', 'KE-15'),
('Kisumu', 'KE-16'),
('Kitui', 'KE-17'),
('Kwale', 'KE-18'),
('Laikipia', 'KE-19'),
('Lamu', 'KE-20'),
('Machakos', 'KE-21'),
('Mandera', 'KE-22'),
('Marsabit', 'KE-23'),
('Meru', 'KE-24'),
('Migori', 'KE-25'),
('Mombasa', 'KE-26'),
('Muranga', 'KE-27'),
('Nandi', 'KE-28'),
('Narok', 'KE-29'),
('Nyamira', 'KE-30'),
('Nyandarua', 'KE-31'),
('Nyeri', 'KE-32'),
('Samburu', 'KE-33'),
('Siaya', 'KE-34'),
('Tana River', 'KE-35'),
('Tharaka Nithi', 'KE-36'),
('Trans Nzoia', 'KE-37'),
('Turkana', 'KE-38'),
('Uasin Gishu', 'KE-39'),
('Vihiga', 'KE-40'),
('Wajir', 'KE-41'),
('West Pokot', 'KE-42'),
('Nairobi', 'KE-47');

✅ Summary

This setup covers all 47 counties of Kenya using ISO 3166-2:KE codes, ideal for backend services, Java applications, and SQL databases.


Comments

No comments yet

Add a new Comment

NUHMAN.COM

Information Technology website for Programming & Development, Web Design & UX/UI, Startups & Innovation, Gadgets & Consumer Tech, Cloud Computing & Enterprise Tech, Cybersecurity, Artificial Intelligence (AI) & Machine Learning (ML), Gaming Technology, Mobile Development, Tech News & Trends, Open Source & Linux, Data Science & Analytics

Categories

Tags

©{" "} Nuhmans.com . All Rights Reserved. Designed by{" "} HTML Codex