Irish County Table

[polestar]

Hi Guys,

Following to the help and instructions I received from my fellow members/administrators. Here is the Ireland County Table for civicrm_county table in the MySQL database.

Hope it helps others who would like to customise CiviCRM in Ireland.

Regards
Rohit

Couldn't Attach... Download it from here http://www.targetintegration.com/Files/IE_civicrm_county.sql.txt

[Piotr Szotkowski]

In CiviCRM, the subdivision of a country is kept in civicrm_state_province, and only the next level of subdivision is kept in civicrm_county. Thus, Ireland’s counties (in the list as per ISO 3166-2) are kept in civicrm_state_province (with country_id of 1105):

Code: [Select]

mysql> SELECT s.id, s.name, abbreviation FROM civicrm_state_province s JOIN civicrm_country c ON (s.country_id = c.id) WHERE c.name = 'Ireland' ORDER BY name;
+------+-----------+--------------+
| id   | name      | abbreviation |
+------+-----------+--------------+
| 3089 | Carlow    | CW           |
| 3088 | Cavan     | CN           |
| 3087 | Clare     | CE           |
| 3086 | Cork      | C            |
| 3091 | Donegal   | DL           |
| 3090 | Dublin    | D            |
| 3092 | Galway    | G            |
| 3095 | Kerry     | KY           |
| 3093 | Kildare   | KE           |
| 3094 | Kilkenny  | KK           |
| 3100 | Laois     | LS           |
| 3099 | Leitrim   | LM           |
| 3098 | Limerick  | LK           |
| 3096 | Longford  | LD           |
| 3097 | Louth     | LH           |
| 3103 | Mayo      | MO           |
| 3101 | Meath     | MH           |
| 3102 | Monaghan  | MN           |
| 3104 | Offaly    | OY           |
| 3105 | Roscommon | RN           |
| 3106 | Sligo     | SO           |
| 3107 | Tipperary | TA           |
| 3108 | Waterford | WD           |
| 3109 | Westmeath | WH           |
| 3111 | Wexford   | WX           |
| 3110 | Wicklow   | WW           |
+------+-----------+--------------+
26 rows in set (0.00 sec)