Programming & Development / April 11, 2025

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

Ireland counties Java enum Ireland ISO 3166-2 IE SQL Ireland counties IE county codes Ireland administrative divisions backend region enum Ireland provinces Java SQL Spring Boot regions Ireland

🇮🇪 Java Enum: Ireland’s Counties

Ireland is divided into 26 counties. Here’s the Java enum using ISO 3166-2:IE codes:

java

public enum IrelandCounty {
    ANTRIM("IE-ANT"),
    CARLOW("IE-CA"),
    CAVAN("IE-CAV"),
    CLARE("IE-CLA"),
    CORK("IE-CO"),
    DERRY("IE-DER"),
    DONEGAL("IE-DON"),
    DOWN("IE-DOW"),
    DUBLIN("IE-DUB"),
    GALWAY("IE-GAL"),
    KERRY("IE-KER"),
    KILDARE("IE-KIL"),
    KILKENNY("IE-KKN"),
    LAOIS("IE-LAO"),
    LEITRIM("IE-LEI"),
    LIMERICK("IE-LIM"),
    LONGFORD("IE-LON"),
    LOUTH("IE-LOU"),
    MAYO("IE-MAY"),
    MEATH("IE-MEA"),
    MONAGHAN("IE-MON"),
    OFFALY("IE-OFF"),
    ROSCOMMON("IE-ROS"),
    SLIGO("IE-SLI"),
    TIPPERARY("IE-TIP"),
    WATERFORD("IE-WAT"),
    WESTMEATH("IE-WME"),
    WEXFORD("IE-WEX"),
    WICKLOW("IE-WIK");

    private final String code;

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

    public String getCode() {
        return code;
    }
}

🗃️ SQL Table and Insert Statements

sql

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

INSERT INTO ireland_counties (name, code) VALUES
('Antrim', 'IE-ANT'),
('Carlow', 'IE-CA'),
('Cavan', 'IE-CAV'),
('Clare', 'IE-CLA'),
('Cork', 'IE-CO'),
('Derry', 'IE-DER'),
('Donegal', 'IE-DON'),
('Down', 'IE-DOW'),
('Dublin', 'IE-DUB'),
('Galway', 'IE-GAL'),
('Kerry', 'IE-KER'),
('Kildare', 'IE-KIL'),
('Kilkenny', 'IE-KKN'),
('Laois', 'IE-LAO'),
('Leitrim', 'IE-LEI'),
('Limerick', 'IE-LIM'),
('Longford', 'IE-LON'),
('Louth', 'IE-LOU'),
('Mayo', 'IE-MAY'),
('Meath', 'IE-MEA'),
('Monaghan', 'IE-MON'),
('Offaly', 'IE-OFF'),
('Roscommon', 'IE-ROS'),
('Sligo', 'IE-SLI'),
('Tipperary', 'IE-TIP'),
('Waterford', 'IE-WAT'),
('Westmeath', 'IE-WME'),
('Wexford', 'IE-WEX'),
('Wicklow', 'IE-WIK');

✅ Summary

This setup covers all 26 counties of Ireland using ISO 3166-2:IE codes, ideal for backend systems, 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