I have gathered all the counties of UK and Republic of Ireland and put them in a SQL file. It will help users to add state/county dropdown list for the countries United Kingdom & Ireland in Magento community edition. Please download the zip file from the following link and extract it first then import the sql file to the Magento’s database using import tool like phpMyAdmin, MySQL Workbench or any other tool you like/prefer.
Click here to Download
Cheers Enjoy!