gnumed-server 16.17-1 / var / lib / gnumed / server / sql / gmCountryZones.sql

-- ===================================================================
-- project: GNUmed

-- The following state codes have been prepared by
-- Jim Busser working with data provided by Thilo Schuler
-- as an external database taken from 'tealow_zencart'.

-- license: GPL v2 or later (details at http://gnu.org)

-- $Source: /home/ncq/Projekte/cvs2git/vcs-mirror/gnumed/gnumed/server/sql/gmCountryZones.sql,v $
-- $Id: gmCountryZones.sql,v 1.4 2006-01-09 13:46:19 ncq Exp $
-- ===================================================================
-- force terminate + exit(3) on errors if non-interactive
\set ON_ERROR_STOP 1

-- ===================================================================
set client_encoding to latin1;

select i18n.i18n('state/territory/province/region not available');

-- country AD
INSERT into dem.state(code, country, name) VALUES ('AN','AD',i18n.i18n('Andorra'));
INSERT into dem.state(code, country, name) VALUES ('CA','AD',i18n.i18n('Canillo'));
INSERT into dem.state(code, country, name) VALUES ('EN','AD',i18n.i18n('Encamp'));
INSERT into dem.state(code, country, name) VALUES ('LM','AD',i18n.i18n('La Massana'));
INSERT into dem.state(code, country, name) VALUES ('LE','AD',i18n.i18n('Les Escaldes'));
INSERT into dem.state(code, country, name) VALUES ('OR','AD',i18n.i18n('Ordino'));
INSERT into dem.state(code, country, name) VALUES ('SJ','AD',i18n.i18n('Sant Julia de Lori'));
-- country AE
INSERT into dem.state(code, country, name) VALUES ('AE-1','AE',i18n.i18n('Arab Emirates territory'));
-- country AF
INSERT into dem.state(code, country, name) VALUES ('BA','AF',i18n.i18n('Badakhshan'));
INSERT into dem.state(code, country, name) VALUES ('BD','AF',i18n.i18n('Badghis'));
INSERT into dem.state(code, country, name) VALUES ('BG','AF',i18n.i18n('Baghlan'));
INSERT into dem.state(code, country, name) VALUES ('BL','AF',i18n.i18n('Balkh'));
INSERT into dem.state(code, country, name) VALUES ('BM','AF',i18n.i18n('Bamian'));
INSERT into dem.state(code, country, name) VALUES ('FA','AF',i18n.i18n('Farah'));
INSERT into dem.state(code, country, name) VALUES ('FR','AF',i18n.i18n('Faryab'));
INSERT into dem.state(code, country, name) VALUES ('GH','AF',i18n.i18n('Ghazni'));
INSERT into dem.state(code, country, name) VALUES ('GO','AF',i18n.i18n('Ghowr'));
INSERT into dem.state(code, country, name) VALUES ('HE','AF',i18n.i18n('Helmand'));
INSERT into dem.state(code, country, name) VALUES ('HR','AF',i18n.i18n('Herat'));
INSERT into dem.state(code, country, name) VALUES ('JO','AF',i18n.i18n('Jowzjan'));
INSERT into dem.state(code, country, name) VALUES ('KA','AF',i18n.i18n('Kabol'));
INSERT into dem.state(code, country, name) VALUES ('KN','AF',i18n.i18n('Kandahar'));
INSERT into dem.state(code, country, name) VALUES ('KP','AF',i18n.i18n('Kapisa'));
INSERT into dem.state(code, country, name) VALUES ('KO','AF',i18n.i18n('Konar'));
INSERT into dem.state(code, country, name) VALUES ('KD','AF',i18n.i18n('Kondoz'));
INSERT into dem.state(code, country, name) VALUES ('LA','AF',i18n.i18n('Laghman'));
INSERT into dem.state(code, country, name) VALUES ('LO','AF',i18n.i18n('Lowgar'));
INSERT into dem.state(code, country, name) VALUES ('NA','AF',i18n.i18n('Nangarhar'));
INSERT into dem.state(code, country, name) VALUES ('NI','AF',i18n.i18n('Nimruz'));
INSERT into dem.state(code, country, name) VALUES ('OR','AF',i18n.i18n('Oruzgan'));
INSERT into dem.state(code, country, name) VALUES ('PA','AF',i18n.i18n('Paktia'));
INSERT into dem.state(code, country, name) VALUES ('PK','AF',i18n.i18n('Paktika'));
INSERT into dem.state(code, country, name) VALUES ('PR','AF',i18n.i18n('Parvan'));
INSERT into dem.state(code, country, name) VALUES ('SA','AF',i18n.i18n('Samangan'));
INSERT into dem.state(code, country, name) VALUES ('SP','AF',i18n.i18n('Sar-e Pol'));
INSERT into dem.state(code, country, name) VALUES ('TA','AF',i18n.i18n('Takhar'));
INSERT into dem.state(code, country, name) VALUES ('VA','AF',i18n.i18n('Vardak'));
INSERT into dem.state(code, country, name) VALUES ('ZA','AF',i18n.i18n('Zabol'));
-- country AG
INSERT into dem.state(code, country, name) VALUES ('BA','AG',i18n.i18n('Barbuda'));
INSERT into dem.state(code, country, name) VALUES ('RE','AG',i18n.i18n('Redonda'));
INSERT into dem.state(code, country, name) VALUES ('SG','AG',i18n.i18n('Saint George'));
INSERT into dem.state(code, country, name) VALUES ('SJ','AG',i18n.i18n('Saint John'));
INSERT into dem.state(code, country, name) VALUES ('SM','AG',i18n.i18n('Saint Mary'));
INSERT into dem.state(code, country, name) VALUES ('SP','AG',i18n.i18n('Saint Paul'));
INSERT into dem.state(code, country, name) VALUES ('SE','AG',i18n.i18n('Saint Peter'));
INSERT into dem.state(code, country, name) VALUES ('SH','AG',i18n.i18n('Saint Philip'));
-- country AI
INSERT into dem.state(code, country, name) VALUES ('AI-1','AI',i18n.i18n('Anguilla territory'));
-- country AL
INSERT into dem.state(code, country, name) VALUES ('BE','AL',i18n.i18n('Berat'));
INSERT into dem.state(code, country, name) VALUES ('BU','AL',i18n.i18n('Bulqize'));
INSERT into dem.state(code, country, name) VALUES ('DE','AL',i18n.i18n('Delvine'));
INSERT into dem.state(code, country, name) VALUES ('DV','AL',i18n.i18n('Devoll (Bilisht)'));
INSERT into dem.state(code, country, name) VALUES ('DI','AL',i18n.i18n('Diber (Peshkopi)'));
INSERT into dem.state(code, country, name) VALUES ('DU','AL',i18n.i18n('Durres'));
INSERT into dem.state(code, country, name) VALUES ('EL','AL',i18n.i18n('Elbasan'));
INSERT into dem.state(code, country, name) VALUES ('FI','AL',i18n.i18n('Fier'));
INSERT into dem.state(code, country, name) VALUES ('GJ','AL',i18n.i18n('Gjirokaster'));
INSERT into dem.state(code, country, name) VALUES ('GR','AL',i18n.i18n('Gramsh'));
INSERT into dem.state(code, country, name) VALUES ('HA','AL',i18n.i18n('Has (Krume)'));
INSERT into dem.state(code, country, name) VALUES ('KA','AL',i18n.i18n('Kavaje'));
INSERT into dem.state(code, country, name) VALUES ('KO','AL',i18n.i18n('Kolonje (Erseke)'));
INSERT into dem.state(code, country, name) VALUES ('KR','AL',i18n.i18n('Korce'));
INSERT into dem.state(code, country, name) VALUES ('KU','AL',i18n.i18n('Kruje'));
INSERT into dem.state(code, country, name) VALUES ('KC','AL',i18n.i18n('Kucove'));
INSERT into dem.state(code, country, name) VALUES ('KK','AL',i18n.i18n('Kukes'));
INSERT into dem.state(code, country, name) VALUES ('LA','AL',i18n.i18n('Lac'));
INSERT into dem.state(code, country, name) VALUES ('LE','AL',i18n.i18n('Lezhe'));
INSERT into dem.state(code, country, name) VALUES ('LI','AL',i18n.i18n('Librazhd'));
INSERT into dem.state(code, country, name) VALUES ('LU','AL',i18n.i18n('Lushnje'));
INSERT into dem.state(code, country, name) VALUES ('MM','AL',i18n.i18n('Malesi e Madhe (Koplik)'));
INSERT into dem.state(code, country, name) VALUES ('MA','AL',i18n.i18n('Mallakaster (Ballsh)'));
INSERT into dem.state(code, country, name) VALUES ('MT','AL',i18n.i18n('Mat (Burrel)'));
INSERT into dem.state(code, country, name) VALUES ('MI','AL',i18n.i18n('Mirdite (Rreshen)'));
INSERT into dem.state(code, country, name) VALUES ('PE','AL',i18n.i18n('Peqin'));
INSERT into dem.state(code, country, name) VALUES ('PR','AL',i18n.i18n('Permet'));
INSERT into dem.state(code, country, name) VALUES ('PO','AL',i18n.i18n('Pogradec'));
INSERT into dem.state(code, country, name) VALUES ('PU','AL',i18n.i18n('Puke'));
INSERT into dem.state(code, country, name) VALUES ('SA','AL',i18n.i18n('Sarande'));
INSERT into dem.state(code, country, name) VALUES ('SH','AL',i18n.i18n('Shkoder'));
INSERT into dem.state(code, country, name) VALUES ('SK','AL',i18n.i18n('Skrapar (Corovode)'));
INSERT into dem.state(code, country, name) VALUES ('TE','AL',i18n.i18n('Tepelene'));
INSERT into dem.state(code, country, name) VALUES ('TI','AL',i18n.i18n('Tirane (Tirana)'));
INSERT into dem.state(code, country, name) VALUES ('TR','AL',i18n.i18n('Tropoje (Bajram Curri)'));
INSERT into dem.state(code, country, name) VALUES ('VL','AL',i18n.i18n('Vlore'));
-- country AM
INSERT into dem.state(code, country, name) VALUES ('AR','AM',i18n.i18n('Aragatsotn'));
INSERT into dem.state(code, country, name) VALUES ('AA','AM',i18n.i18n('Ararat'));
INSERT into dem.state(code, country, name) VALUES ('AM','AM',i18n.i18n('Armavir'));
INSERT into dem.state(code, country, name) VALUES ('GE','AM',i18n.i18n('Geghark''unik|'));
INSERT into dem.state(code, country, name) VALUES ('KO','AM',i18n.i18n('Kotayk'''));
INSERT into dem.state(code, country, name) VALUES ('LO','AM',i18n.i18n('Lorri'));
INSERT into dem.state(code, country, name) VALUES ('SH','AM',i18n.i18n('Shirak'));
INSERT into dem.state(code, country, name) VALUES ('SY','AM',i18n.i18n('Syunik'''));
INSERT into dem.state(code, country, name) VALUES ('TA','AM',i18n.i18n('Tavush'));
INSERT into dem.state(code, country, name) VALUES ('VA','AM',i18n.i18n('Vayots'' Dzor'));
INSERT into dem.state(code, country, name) VALUES ('YE','AM',i18n.i18n('Yerevan'));
-- country AN
INSERT into dem.state(code, country, name) VALUES ('AN-1','AN',i18n.i18n('Netherlands Antilles territory'));
-- country AO
INSERT into dem.state(code, country, name) VALUES ('BE','AO',i18n.i18n('Bengo'));
INSERT into dem.state(code, country, name) VALUES ('BN','AO',i18n.i18n('Benguela'));
INSERT into dem.state(code, country, name) VALUES ('BI','AO',i18n.i18n('Bie'));
INSERT into dem.state(code, country, name) VALUES ('CA','AO',i18n.i18n('Cabinda'));
INSERT into dem.state(code, country, name) VALUES ('CC','AO',i18n.i18n('Cuando Cubango'));
INSERT into dem.state(code, country, name) VALUES ('CN','AO',i18n.i18n('Cuanza Norte'));
INSERT into dem.state(code, country, name) VALUES ('CS','AO',i18n.i18n('Cuanza Sul'));
INSERT into dem.state(code, country, name) VALUES ('CU','AO',i18n.i18n('Cunene'));
INSERT into dem.state(code, country, name) VALUES ('HU','AO',i18n.i18n('Huambo'));
INSERT into dem.state(code, country, name) VALUES ('HI','AO',i18n.i18n('Huila'));
INSERT into dem.state(code, country, name) VALUES ('LU','AO',i18n.i18n('Luanda'));
INSERT into dem.state(code, country, name) VALUES ('LN','AO',i18n.i18n('Lunda Norte'));
INSERT into dem.state(code, country, name) VALUES ('LS','AO',i18n.i18n('Lunda Sul'));
INSERT into dem.state(code, country, name) VALUES ('MA','AO',i18n.i18n('Malanje'));
INSERT into dem.state(code, country, name) VALUES ('MO','AO',i18n.i18n('Moxico'));
INSERT into dem.state(code, country, name) VALUES ('NA','AO',i18n.i18n('Namibe'));
INSERT into dem.state(code, country, name) VALUES ('UI','AO',i18n.i18n('Uige'));
INSERT into dem.state(code, country, name) VALUES ('ZA','AO',i18n.i18n('Zaire'));
-- country AQ
INSERT into dem.state(code, country, name) VALUES ('AQ-1','AQ',i18n.i18n('Antarctica territory'));
-- country AR
INSERT into dem.state(code, country, name) VALUES ('AN','AR',i18n.i18n('Antartida e Islas del Atlantico'));
INSERT into dem.state(code, country, name) VALUES ('BA','AR',i18n.i18n('Buenos Aires'));
INSERT into dem.state(code, country, name) VALUES ('CA','AR',i18n.i18n('Catamarca'));
INSERT into dem.state(code, country, name) VALUES ('CH','AR',i18n.i18n('Chaco'));
INSERT into dem.state(code, country, name) VALUES ('CU','AR',i18n.i18n('Chubut'));
INSERT into dem.state(code, country, name) VALUES ('CO','AR',i18n.i18n('Cordoba'));
INSERT into dem.state(code, country, name) VALUES ('CR','AR',i18n.i18n('Corrientes'));
INSERT into dem.state(code, country, name) VALUES ('DF','AR',i18n.i18n('Distrito Federal'));
INSERT into dem.state(code, country, name) VALUES ('ER','AR',i18n.i18n('Entre Rios'));
INSERT into dem.state(code, country, name) VALUES ('FO','AR',i18n.i18n('Formosa'));
INSERT into dem.state(code, country, name) VALUES ('JU','AR',i18n.i18n('Jujuy'));
INSERT into dem.state(code, country, name) VALUES ('LP','AR',i18n.i18n('La Pampa'));
INSERT into dem.state(code, country, name) VALUES ('LR','AR',i18n.i18n('La Rioja'));
INSERT into dem.state(code, country, name) VALUES ('ME','AR',i18n.i18n('Mendoza'));
INSERT into dem.state(code, country, name) VALUES ('MI','AR',i18n.i18n('Misiones'));
INSERT into dem.state(code, country, name) VALUES ('NE','AR',i18n.i18n('Neuquen'));
INSERT into dem.state(code, country, name) VALUES ('RN','AR',i18n.i18n('Rio Negro'));
INSERT into dem.state(code, country, name) VALUES ('SA','AR',i18n.i18n('Salta'));
INSERT into dem.state(code, country, name) VALUES ('SJ','AR',i18n.i18n('San Juan'));
INSERT into dem.state(code, country, name) VALUES ('SL','AR',i18n.i18n('San Luis'));
INSERT into dem.state(code, country, name) VALUES ('SC','AR',i18n.i18n('Santa Cruz'));
INSERT into dem.state(code, country, name) VALUES ('SF','AR',i18n.i18n('Santa Fe'));
INSERT into dem.state(code, country, name) VALUES ('SD','AR',i18n.i18n('Santiago del Estero'));
INSERT into dem.state(code, country, name) VALUES ('TF','AR',i18n.i18n('Tierra del Fuego'));
INSERT into dem.state(code, country, name) VALUES ('TU','AR',i18n.i18n('Tucuman'));
-- country AS
INSERT into dem.state(code, country, name) VALUES ('EA','AS',i18n.i18n('Eastern'));
INSERT into dem.state(code, country, name) VALUES ('MA','AS',i18n.i18n('Manu''a'));
INSERT into dem.state(code, country, name) VALUES ('RI','AS',i18n.i18n('Rose Island'));
INSERT into dem.state(code, country, name) VALUES ('SI','AS',i18n.i18n('Swains Island'));
INSERT into dem.state(code, country, name) VALUES ('WE','AS',i18n.i18n('Western'));
-- country AW
INSERT into dem.state(code, country, name) VALUES ('AW-1','AW',i18n.i18n('Aruba territory'));
-- country AZ
INSERT into dem.state(code, country, name) VALUES ('AB','AZ',i18n.i18n('Abseron Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('AG','AZ',i18n.i18n('Agcabadi Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('AD','AZ',i18n.i18n('Agdam Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('AA','AZ',i18n.i18n('Agdas Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('AS','AZ',i18n.i18n('Agstafa Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('AU','AZ',i18n.i18n('Agsu Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('AL','AZ',i18n.i18n('Ali Bayramli Sahari'));
INSERT into dem.state(code, country, name) VALUES ('AT','AZ',i18n.i18n('Astara Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('BS','AZ',i18n.i18n('Baki Sahari'));
INSERT into dem.state(code, country, name) VALUES ('BR','AZ',i18n.i18n('Balakan Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('BA','AZ',i18n.i18n('Barda Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('BE','AZ',i18n.i18n('Beylaqan Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('BI','AZ',i18n.i18n('Bilasuvar Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('CA','AZ',i18n.i18n('Cabrayil Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('CL','AZ',i18n.i18n('Calilabad Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('DA','AZ',i18n.i18n('Daskasan Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('DV','AZ',i18n.i18n('Davaci Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('FU','AZ',i18n.i18n('Fuzuli Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('GA','AZ',i18n.i18n('Gadabay Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('GN','AZ',i18n.i18n('Ganca Sahari'));
INSERT into dem.state(code, country, name) VALUES ('GO','AZ',i18n.i18n('Goranboy Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('GY','AZ',i18n.i18n('Goycay Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('HA','AZ',i18n.i18n('Haciqabul Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('IM','AZ',i18n.i18n('Imisli Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('IS','AZ',i18n.i18n('Ismayilli Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('KA','AZ',i18n.i18n('Kalbacar Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('KU','AZ',i18n.i18n('Kurdamir Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('LA','AZ',i18n.i18n('Lacin Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('LN','AZ',i18n.i18n('Lankaran Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('LK','AZ',i18n.i18n('Lankaran Sahari'));
INSERT into dem.state(code, country, name) VALUES ('LE','AZ',i18n.i18n('Lerik Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('MA','AZ',i18n.i18n('Masalli Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('MI','AZ',i18n.i18n('Mingacevir Sahari'));
INSERT into dem.state(code, country, name) VALUES ('NA','AZ',i18n.i18n('Naftalan Sahari'));
INSERT into dem.state(code, country, name) VALUES ('NX','AZ',i18n.i18n('Naxcivan Muxtar Respublikasi'));
INSERT into dem.state(code, country, name) VALUES ('NE','AZ',i18n.i18n('Neftcala Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('OG','AZ',i18n.i18n('Oguz Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('QA','AZ',i18n.i18n('Qabala Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('QX','AZ',i18n.i18n('Qax Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('QZ','AZ',i18n.i18n('Qazax Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('QO','AZ',i18n.i18n('Qobustan Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('QU','AZ',i18n.i18n('Quba Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('QB','AZ',i18n.i18n('Qubadli Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('QS','AZ',i18n.i18n('Qusar Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('SA','AZ',i18n.i18n('Saatli Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('SB','AZ',i18n.i18n('Sabirabad Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('SK','AZ',i18n.i18n('Saki Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('SI','AZ',i18n.i18n('Saki Sahari'));
INSERT into dem.state(code, country, name) VALUES ('SL','AZ',i18n.i18n('Salyan Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('SM','AZ',i18n.i18n('Samaxi Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('SR','AZ',i18n.i18n('Samkir Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('SX','AZ',i18n.i18n('Samux Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('SY','AZ',i18n.i18n('Siyazan Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('SU','AZ',i18n.i18n('Sumqayit Sahari'));
INSERT into dem.state(code, country, name) VALUES ('SS','AZ',i18n.i18n('Susa Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('ST','AZ',i18n.i18n('Susa Sahari'));
INSERT into dem.state(code, country, name) VALUES ('TA','AZ',i18n.i18n('Tartar Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('TO','AZ',i18n.i18n('Tovuz Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('UC','AZ',i18n.i18n('Ucar Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('XA','AZ',i18n.i18n('Xacmaz Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('XN','AZ',i18n.i18n('Xankandi Sahari'));
INSERT into dem.state(code, country, name) VALUES ('XL','AZ',i18n.i18n('Xanlar Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('XI','AZ',i18n.i18n('Xizi Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('XO','AZ',i18n.i18n('Xocali Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('XC','AZ',i18n.i18n('Xocavand Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('YA','AZ',i18n.i18n('Yardimli Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('YE','AZ',i18n.i18n('Yevlax Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('YV','AZ',i18n.i18n('Yevlax Sahari'));
INSERT into dem.state(code, country, name) VALUES ('ZA','AZ',i18n.i18n('Zangilan Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('ZQ','AZ',i18n.i18n('Zaqatala Rayonu'));
INSERT into dem.state(code, country, name) VALUES ('ZR','AZ',i18n.i18n('Zardab Rayonu'));
-- country BA
INSERT into dem.state(code, country, name) VALUES ('BA-1','BA',i18n.i18n('Bosnia and Herzegovina territory'));
-- country BB
INSERT into dem.state(code, country, name) VALUES ('CC','BB',i18n.i18n('Christ Church'));
INSERT into dem.state(code, country, name) VALUES ('SA','BB',i18n.i18n('Saint Andrew'));
INSERT into dem.state(code, country, name) VALUES ('SG','BB',i18n.i18n('Saint George'));
INSERT into dem.state(code, country, name) VALUES ('SJ','BB',i18n.i18n('Saint James'));
INSERT into dem.state(code, country, name) VALUES ('SO','BB',i18n.i18n('Saint John'));
INSERT into dem.state(code, country, name) VALUES ('SS','BB',i18n.i18n('Saint Joseph'));
INSERT into dem.state(code, country, name) VALUES ('SL','BB',i18n.i18n('Saint Lucy'));
INSERT into dem.state(code, country, name) VALUES ('SM','BB',i18n.i18n('Saint Michael'));
INSERT into dem.state(code, country, name) VALUES ('SP','BB',i18n.i18n('Saint Peter'));
INSERT into dem.state(code, country, name) VALUES ('SH','BB',i18n.i18n('Saint Philip'));
INSERT into dem.state(code, country, name) VALUES ('ST','BB',i18n.i18n('Saint Thomas'));
-- country BD
INSERT into dem.state(code, country, name) VALUES ('BA','BD',i18n.i18n('Barisal'));
INSERT into dem.state(code, country, name) VALUES ('CH','BD',i18n.i18n('Chittagong'));
INSERT into dem.state(code, country, name) VALUES ('DH','BD',i18n.i18n('Dhaka'));
INSERT into dem.state(code, country, name) VALUES ('KH','BD',i18n.i18n('Khulna'));
INSERT into dem.state(code, country, name) VALUES ('RA','BD',i18n.i18n('Rajshahi'));
-- country BE
INSERT into dem.state(code, country, name) VALUES ('AN','BE',i18n.i18n('Antwerpen'));
INSERT into dem.state(code, country, name) VALUES ('BW','BE',i18n.i18n('Brabant Wallon'));
INSERT into dem.state(code, country, name) VALUES ('HA','BE',i18n.i18n('Hainaut'));
INSERT into dem.state(code, country, name) VALUES ('LG','BE',i18n.i18n('Liege'));
INSERT into dem.state(code, country, name) VALUES ('LM','BE',i18n.i18n('Limburg'));
INSERT into dem.state(code, country, name) VALUES ('LX','BE',i18n.i18n('Luxembourg'));
INSERT into dem.state(code, country, name) VALUES ('NM','BE',i18n.i18n('Namur'));
INSERT into dem.state(code, country, name) VALUES ('OV','BE',i18n.i18n('Oost-Vlaanderen'));
INSERT into dem.state(code, country, name) VALUES ('VB','BE',i18n.i18n('Vlaams Brabant'));
INSERT into dem.state(code, country, name) VALUES ('WV','BE',i18n.i18n('West-Vlaanderen'));
-- country BF
INSERT into dem.state(code, country, name) VALUES ('BA','BF',i18n.i18n('Bale'));
INSERT into dem.state(code, country, name) VALUES ('BM','BF',i18n.i18n('Bam'));
INSERT into dem.state(code, country, name) VALUES ('BN','BF',i18n.i18n('Banwa'));
INSERT into dem.state(code, country, name) VALUES ('BZ','BF',i18n.i18n('Bazega'));
INSERT into dem.state(code, country, name) VALUES ('BO','BF',i18n.i18n('Bougouriba'));
INSERT into dem.state(code, country, name) VALUES ('BU','BF',i18n.i18n('Boulgou'));
INSERT into dem.state(code, country, name) VALUES ('BL','BF',i18n.i18n('Boulkiemde'));
INSERT into dem.state(code, country, name) VALUES ('CO','BF',i18n.i18n('Comoe'));
INSERT into dem.state(code, country, name) VALUES ('GA','BF',i18n.i18n('Ganzourgou'));
INSERT into dem.state(code, country, name) VALUES ('GN','BF',i18n.i18n('Gnagna'));
INSERT into dem.state(code, country, name) VALUES ('GO','BF',i18n.i18n('Gourma'));
INSERT into dem.state(code, country, name) VALUES ('HO','BF',i18n.i18n('Houet'));
INSERT into dem.state(code, country, name) VALUES ('IO','BF',i18n.i18n('Ioba'));
INSERT into dem.state(code, country, name) VALUES ('KA','BF',i18n.i18n('Kadiogo'));
INSERT into dem.state(code, country, name) VALUES ('KE','BF',i18n.i18n('Kenedougou'));
INSERT into dem.state(code, country, name) VALUES ('KO','BF',i18n.i18n('Komandjari'));
INSERT into dem.state(code, country, name) VALUES ('KM','BF',i18n.i18n('Kompienga'));
INSERT into dem.state(code, country, name) VALUES ('KS','BF',i18n.i18n('Kossi'));
INSERT into dem.state(code, country, name) VALUES ('KU','BF',i18n.i18n('Koupelogo'));
INSERT into dem.state(code, country, name) VALUES ('KR','BF',i18n.i18n('Kouritenga'));
INSERT into dem.state(code, country, name) VALUES ('KW','BF',i18n.i18n('Kourweogo'));
INSERT into dem.state(code, country, name) VALUES ('LE','BF',i18n.i18n('Leraba'));
INSERT into dem.state(code, country, name) VALUES ('LO','BF',i18n.i18n('Loroum'));
INSERT into dem.state(code, country, name) VALUES ('MO','BF',i18n.i18n('Mouhoun'));
INSERT into dem.state(code, country, name) VALUES ('NA','BF',i18n.i18n('Nahouri'));
INSERT into dem.state(code, country, name) VALUES ('NM','BF',i18n.i18n('Namentenga'));
INSERT into dem.state(code, country, name) VALUES ('NU','BF',i18n.i18n('Naumbiel'));
INSERT into dem.state(code, country, name) VALUES ('NY','BF',i18n.i18n('Nayala'));
INSERT into dem.state(code, country, name) VALUES ('OU','BF',i18n.i18n('Oubritenga'));
INSERT into dem.state(code, country, name) VALUES ('OD','BF',i18n.i18n('Oudalan'));
INSERT into dem.state(code, country, name) VALUES ('PA','BF',i18n.i18n('Passore'));
INSERT into dem.state(code, country, name) VALUES ('PO','BF',i18n.i18n('Poni'));
INSERT into dem.state(code, country, name) VALUES ('SA','BF',i18n.i18n('Samentenga'));
INSERT into dem.state(code, country, name) VALUES ('SN','BF',i18n.i18n('Sanguie'));
INSERT into dem.state(code, country, name) VALUES ('SE','BF',i18n.i18n('Seno'));
INSERT into dem.state(code, country, name) VALUES ('SI','BF',i18n.i18n('Sissili'));
INSERT into dem.state(code, country, name) VALUES ('SO','BF',i18n.i18n('Soum'));
INSERT into dem.state(code, country, name) VALUES ('SU','BF',i18n.i18n('Sourou'));
INSERT into dem.state(code, country, name) VALUES ('TA','BF',i18n.i18n('Tapoa'));
INSERT into dem.state(code, country, name) VALUES ('TU','BF',i18n.i18n('Tuy'));
INSERT into dem.state(code, country, name) VALUES ('YA','BF',i18n.i18n('Yagha'));
INSERT into dem.state(code, country, name) VALUES ('YT','BF',i18n.i18n('Yatenga'));
INSERT into dem.state(code, country, name) VALUES ('ZI','BF',i18n.i18n('Ziro'));
INSERT into dem.state(code, country, name) VALUES ('ZO','BF',i18n.i18n('Zondomo'));
INSERT into dem.state(code, country, name) VALUES ('ZU','BF',i18n.i18n('Zoundweogo'));
-- country BG
INSERT into dem.state(code, country, name) VALUES ('BU','BG',i18n.i18n('Burgas'));
INSERT into dem.state(code, country, name) VALUES ('GS','BG',i18n.i18n('Grad Sofiya'));
INSERT into dem.state(code, country, name) VALUES ('KH','BG',i18n.i18n('Khaskovo'));
INSERT into dem.state(code, country, name) VALUES ('LO','BG',i18n.i18n('Lovech'));
INSERT into dem.state(code, country, name) VALUES ('MO','BG',i18n.i18n('Montana'));
INSERT into dem.state(code, country, name) VALUES ('PL','BG',i18n.i18n('Plovdiv'));
INSERT into dem.state(code, country, name) VALUES ('RU','BG',i18n.i18n('Ruse'));
INSERT into dem.state(code, country, name) VALUES ('SO','BG',i18n.i18n('Sofiya'));
INSERT into dem.state(code, country, name) VALUES ('VA','BG',i18n.i18n('Varna'));
-- country BH
INSERT into dem.state(code, country, name) VALUES ('AH','BH',i18n.i18n('Al Hadd'));
INSERT into dem.state(code, country, name) VALUES ('AM','BH',i18n.i18n('Al Manamah'));
INSERT into dem.state(code, country, name) VALUES ('AG','BH',i18n.i18n('Al Mintaqah al Gharbiyah'));
INSERT into dem.state(code, country, name) VALUES ('AW','BH',i18n.i18n('Al Mintaqah al Wusta'));
INSERT into dem.state(code, country, name) VALUES ('AS','BH',i18n.i18n('Al Mintaqah ash Shamaliyah'));
INSERT into dem.state(code, country, name) VALUES ('AU','BH',i18n.i18n('Al Muharraq'));
INSERT into dem.state(code, country, name) VALUES ('AR','BH',i18n.i18n('Ar Rifa'' wa al Mintaqah al Janub'));
INSERT into dem.state(code, country, name) VALUES ('JH','BH',i18n.i18n('Jidd Hafs'));
INSERT into dem.state(code, country, name) VALUES ('JU','BH',i18n.i18n('Juzur Hawar'));
INSERT into dem.state(code, country, name) VALUES ('MI','BH',i18n.i18n('Madinat ''Isa'));
INSERT into dem.state(code, country, name) VALUES ('MH','BH',i18n.i18n('Madinat Hamad'));
INSERT into dem.state(code, country, name) VALUES ('SI','BH',i18n.i18n('Sitrah'));
-- country BI
INSERT into dem.state(code, country, name) VALUES ('BU','BI',i18n.i18n('Bubanza'));
INSERT into dem.state(code, country, name) VALUES ('BJ','BI',i18n.i18n('Bujumbura'));
INSERT into dem.state(code, country, name) VALUES ('BR','BI',i18n.i18n('Bururi'));
INSERT into dem.state(code, country, name) VALUES ('CA','BI',i18n.i18n('Cankuzo'));
INSERT into dem.state(code, country, name) VALUES ('CI','BI',i18n.i18n('Cibitoke'));
INSERT into dem.state(code, country, name) VALUES ('GI','BI',i18n.i18n('Gitega'));
INSERT into dem.state(code, country, name) VALUES ('KA','BI',i18n.i18n('Karuzi'));
INSERT into dem.state(code, country, name) VALUES ('KY','BI',i18n.i18n('Kayanza'));
INSERT into dem.state(code, country, name) VALUES ('KI','BI',i18n.i18n('Kirundo'));
INSERT into dem.state(code, country, name) VALUES ('MA','BI',i18n.i18n('Makamba'));
INSERT into dem.state(code, country, name) VALUES ('MU','BI',i18n.i18n('Muramvya'));
INSERT into dem.state(code, country, name) VALUES ('MY','BI',i18n.i18n('Muyinga'));
INSERT into dem.state(code, country, name) VALUES ('MW','BI',i18n.i18n('Mwaro'));
INSERT into dem.state(code, country, name) VALUES ('NG','BI',i18n.i18n('Ngozi'));
INSERT into dem.state(code, country, name) VALUES ('RU','BI',i18n.i18n('Rutana'));
INSERT into dem.state(code, country, name) VALUES ('RY','BI',i18n.i18n('Ruyigi'));
-- country BJ
INSERT into dem.state(code, country, name) VALUES ('AI','BJ',i18n.i18n('Alibori'));
INSERT into dem.state(code, country, name) VALUES ('AT','BJ',i18n.i18n('Atakora'));
INSERT into dem.state(code, country, name) VALUES ('AL','BJ',i18n.i18n('Atlantique'));
INSERT into dem.state(code, country, name) VALUES ('BO','BJ',i18n.i18n('Borgou'));
INSERT into dem.state(code, country, name) VALUES ('CO','BJ',i18n.i18n('Collines'));
INSERT into dem.state(code, country, name) VALUES ('CF','BJ',i18n.i18n('Couffo'));
INSERT into dem.state(code, country, name) VALUES ('DO','BJ',i18n.i18n('Donga'));
INSERT into dem.state(code, country, name) VALUES ('LI','BJ',i18n.i18n('Littoral'));
INSERT into dem.state(code, country, name) VALUES ('MO','BJ',i18n.i18n('Mono'));
INSERT into dem.state(code, country, name) VALUES ('OU','BJ',i18n.i18n('Oueme'));
INSERT into dem.state(code, country, name) VALUES ('PL','BJ',i18n.i18n('Plateau'));
INSERT into dem.state(code, country, name) VALUES ('ZO','BJ',i18n.i18n('Zou'));
-- country BM
INSERT into dem.state(code, country, name) VALUES ('DE','BM',i18n.i18n('Devonshire'));
INSERT into dem.state(code, country, name) VALUES ('HA','BM',i18n.i18n('Hamilton'));
INSERT into dem.state(code, country, name) VALUES ('PA','BM',i18n.i18n('Paget'));
INSERT into dem.state(code, country, name) VALUES ('PE','BM',i18n.i18n('Pembroke'));
INSERT into dem.state(code, country, name) VALUES ('SG','BM',i18n.i18n('Saint Georges'));
INSERT into dem.state(code, country, name) VALUES ('SA','BM',i18n.i18n('Sandys'));
INSERT into dem.state(code, country, name) VALUES ('SM','BM',i18n.i18n('Smiths'));
INSERT into dem.state(code, country, name) VALUES ('SO','BM',i18n.i18n('Southampton'));
INSERT into dem.state(code, country, name) VALUES ('WA','BM',i18n.i18n('Warwick'));
-- country BN
INSERT into dem.state(code, country, name) VALUES ('BE','BN',i18n.i18n('Belait'));
INSERT into dem.state(code, country, name) VALUES ('BM','BN',i18n.i18n('Brunei and Muara'));
INSERT into dem.state(code, country, name) VALUES ('TE','BN',i18n.i18n('Temburong'));
INSERT into dem.state(code, country, name) VALUES ('TU','BN',i18n.i18n('Tutong'));
-- country BO
INSERT into dem.state(code, country, name) VALUES ('BE','BO',i18n.i18n('Beni'));
INSERT into dem.state(code, country, name) VALUES ('CH','BO',i18n.i18n('Chuquisaca'));
INSERT into dem.state(code, country, name) VALUES ('CO','BO',i18n.i18n('Cochabamba'));
INSERT into dem.state(code, country, name) VALUES ('LP','BO',i18n.i18n('La Paz'));
INSERT into dem.state(code, country, name) VALUES ('OR','BO',i18n.i18n('Oruro'));
INSERT into dem.state(code, country, name) VALUES ('PA','BO',i18n.i18n('Pando'));
INSERT into dem.state(code, country, name) VALUES ('PO','BO',i18n.i18n('Potosi'));
INSERT into dem.state(code, country, name) VALUES ('SC','BO',i18n.i18n('Santa Cruz'));
INSERT into dem.state(code, country, name) VALUES ('TA','BO',i18n.i18n('Tarija'));
-- country BR
INSERT into dem.state(code, country, name) VALUES ('AC','BR',i18n.i18n('Acre'));
INSERT into dem.state(code, country, name) VALUES ('AL','BR',i18n.i18n('Alagoas'));
INSERT into dem.state(code, country, name) VALUES ('AM','BR',i18n.i18n('Amapa'));
INSERT into dem.state(code, country, name) VALUES ('AZ','BR',i18n.i18n('Amazonas'));
INSERT into dem.state(code, country, name) VALUES ('BA','BR',i18n.i18n('Bahia'));
INSERT into dem.state(code, country, name) VALUES ('CE','BR',i18n.i18n('Ceara'));
INSERT into dem.state(code, country, name) VALUES ('DF','BR',i18n.i18n('Distrito Federal'));
INSERT into dem.state(code, country, name) VALUES ('ES','BR',i18n.i18n('Espirito Santo'));
INSERT into dem.state(code, country, name) VALUES ('GO','BR',i18n.i18n('Goias'));
INSERT into dem.state(code, country, name) VALUES ('MA','BR',i18n.i18n('Maranhao'));
INSERT into dem.state(code, country, name) VALUES ('MG','BR',i18n.i18n('Mato Grosso'));
INSERT into dem.state(code, country, name) VALUES ('MS','BR',i18n.i18n('Mato Grosso do Sul'));
INSERT into dem.state(code, country, name) VALUES ('MR','BR',i18n.i18n('Minas Gerais'));
INSERT into dem.state(code, country, name) VALUES ('PA','BR',i18n.i18n('Para'));
INSERT into dem.state(code, country, name) VALUES ('PR','BR',i18n.i18n('Paraiba'));
INSERT into dem.state(code, country, name) VALUES ('PN','BR',i18n.i18n('Parana'));
INSERT into dem.state(code, country, name) VALUES ('PE','BR',i18n.i18n('Pernambuco'));
INSERT into dem.state(code, country, name) VALUES ('PI','BR',i18n.i18n('Piaui'));
INSERT into dem.state(code, country, name) VALUES ('RJ','BR',i18n.i18n('Rio de Janeiro'));
INSERT into dem.state(code, country, name) VALUES ('RN','BR',i18n.i18n('Rio Grande do Norte'));
INSERT into dem.state(code, country, name) VALUES ('RS','BR',i18n.i18n('Rio Grande do Sul'));
INSERT into dem.state(code, country, name) VALUES ('RO','BR',i18n.i18n('Rondonia'));
INSERT into dem.state(code, country, name) VALUES ('RR','BR',i18n.i18n('Roraima'));
INSERT into dem.state(code, country, name) VALUES ('SC','BR',i18n.i18n('Santa Catarina'));
INSERT into dem.state(code, country, name) VALUES ('SP','BR',i18n.i18n('Sao Paulo'));
INSERT into dem.state(code, country, name) VALUES ('SE','BR',i18n.i18n('Sergipe'));
INSERT into dem.state(code, country, name) VALUES ('TO','BR',i18n.i18n('Tocantins'));
-- country BS
INSERT into dem.state(code, country, name) VALUES ('AC','BS',i18n.i18n('Acklins and Crooked Islands'));
INSERT into dem.state(code, country, name) VALUES ('BI','BS',i18n.i18n('Bimini'));
INSERT into dem.state(code, country, name) VALUES ('CI','BS',i18n.i18n('Cat Island'));
INSERT into dem.state(code, country, name) VALUES ('EX','BS',i18n.i18n('Exuma'));
INSERT into dem.state(code, country, name) VALUES ('FR','BS',i18n.i18n('Freeport'));
INSERT into dem.state(code, country, name) VALUES ('FC','BS',i18n.i18n('Fresh Creek'));
INSERT into dem.state(code, country, name) VALUES ('GH','BS',i18n.i18n('Governor''s Harbour'));
INSERT into dem.state(code, country, name) VALUES ('GT','BS',i18n.i18n('Green Turtle Cay'));
INSERT into dem.state(code, country, name) VALUES ('HI','BS',i18n.i18n('Harbour Island'));
INSERT into dem.state(code, country, name) VALUES ('HR','BS',i18n.i18n('High Rock'));
INSERT into dem.state(code, country, name) VALUES ('IN','BS',i18n.i18n('Inagua'));
INSERT into dem.state(code, country, name) VALUES ('KB','BS',i18n.i18n('Kemps Bay'));
INSERT into dem.state(code, country, name) VALUES ('LI','BS',i18n.i18n('Long Island'));
INSERT into dem.state(code, country, name) VALUES ('MH','BS',i18n.i18n('Marsh Harbour'));
INSERT into dem.state(code, country, name) VALUES ('MA','BS',i18n.i18n('Mayaguana'));
INSERT into dem.state(code, country, name) VALUES ('NP','BS',i18n.i18n('New Providence'));
INSERT into dem.state(code, country, name) VALUES ('NT','BS',i18n.i18n('Nicholls Town and Berry Islands'));
INSERT into dem.state(code, country, name) VALUES ('RI','BS',i18n.i18n('Ragged Island'));
INSERT into dem.state(code, country, name) VALUES ('RS','BS',i18n.i18n('Rock Sound'));
INSERT into dem.state(code, country, name) VALUES ('SS','BS',i18n.i18n('San Salvador and Rum Cay'));
INSERT into dem.state(code, country, name) VALUES ('SP','BS',i18n.i18n('Sandy Point'));
-- country BT
INSERT into dem.state(code, country, name) VALUES ('BU','BT',i18n.i18n('Bumthang'));
INSERT into dem.state(code, country, name) VALUES ('CH','BT',i18n.i18n('Chhukha'));
INSERT into dem.state(code, country, name) VALUES ('CI','BT',i18n.i18n('Chirang'));
INSERT into dem.state(code, country, name) VALUES ('DA','BT',i18n.i18n('Daga'));
INSERT into dem.state(code, country, name) VALUES ('GE','BT',i18n.i18n('Geylegphug'));
INSERT into dem.state(code, country, name) VALUES ('HA','BT',i18n.i18n('Ha'));
INSERT into dem.state(code, country, name) VALUES ('LH','BT',i18n.i18n('Lhuntshi'));
INSERT into dem.state(code, country, name) VALUES ('MO','BT',i18n.i18n('Mongar'));
INSERT into dem.state(code, country, name) VALUES ('PA','BT',i18n.i18n('Paro'));
INSERT into dem.state(code, country, name) VALUES ('PE','BT',i18n.i18n('Pemagatsel'));
INSERT into dem.state(code, country, name) VALUES ('PU','BT',i18n.i18n('Punakha'));
INSERT into dem.state(code, country, name) VALUES ('SA','BT',i18n.i18n('Samchi'));
INSERT into dem.state(code, country, name) VALUES ('SJ','BT',i18n.i18n('Samdrup Jongkhar'));
INSERT into dem.state(code, country, name) VALUES ('SH','BT',i18n.i18n('Shemgang'));
INSERT into dem.state(code, country, name) VALUES ('TA','BT',i18n.i18n('Tashigang'));
INSERT into dem.state(code, country, name) VALUES ('TH','BT',i18n.i18n('Thimphu'));
INSERT into dem.state(code, country, name) VALUES ('TO','BT',i18n.i18n('Tongsa'));
INSERT into dem.state(code, country, name) VALUES ('WP','BT',i18n.i18n('Wangdi Phodrang'));
-- country BV
INSERT into dem.state(code, country, name) VALUES ('BV-1','BV',i18n.i18n('Bouvet Island territory'));
-- country BW
INSERT into dem.state(code, country, name) VALUES ('CD','BW',i18n.i18n('Central District'));
INSERT into dem.state(code, country, name) VALUES ('CH','BW',i18n.i18n('Chobe'));
INSERT into dem.state(code, country, name) VALUES ('GH','BW',i18n.i18n('Ghanzi'));
INSERT into dem.state(code, country, name) VALUES ('KG','BW',i18n.i18n('Kgalagadi'));
INSERT into dem.state(code, country, name) VALUES ('KL','BW',i18n.i18n('Kgatleng'));
INSERT into dem.state(code, country, name) VALUES ('KW','BW',i18n.i18n('Kweneng'));
INSERT into dem.state(code, country, name) VALUES ('NG','BW',i18n.i18n('Ngamiland'));
INSERT into dem.state(code, country, name) VALUES ('NE','BW',i18n.i18n('North East District'));
INSERT into dem.state(code, country, name) VALUES ('SE','BW',i18n.i18n('South East District'));
INSERT into dem.state(code, country, name) VALUES ('SD','BW',i18n.i18n('Southern District'));
-- country BY
INSERT into dem.state(code, country, name) VALUES ('BR','BY',i18n.i18n('Brestskaya (Brest)'));
INSERT into dem.state(code, country, name) VALUES ('HO','BY',i18n.i18n('Homyel''skaya (Homyel|)'));
INSERT into dem.state(code, country, name) VALUES ('HM','BY',i18n.i18n('Horad Minsk'));
INSERT into dem.state(code, country, name) VALUES ('HR','BY',i18n.i18n('Hrodzyenskaya (Hrodna)'));
INSERT into dem.state(code, country, name) VALUES ('MA','BY',i18n.i18n('Mahilyowskaya (Mahilyow)'));
INSERT into dem.state(code, country, name) VALUES ('MI','BY',i18n.i18n('Minskaya'));
INSERT into dem.state(code, country, name) VALUES ('VI','BY',i18n.i18n('Vitsyebskaya (Vitsyebsk)'));
-- country BZ
INSERT into dem.state(code, country, name) VALUES ('BE','BZ',i18n.i18n('Belize'));
INSERT into dem.state(code, country, name) VALUES ('CA','BZ',i18n.i18n('Cayo'));
INSERT into dem.state(code, country, name) VALUES ('CO','BZ',i18n.i18n('Corozal'));
INSERT into dem.state(code, country, name) VALUES ('OW','BZ',i18n.i18n('Orange Walk'));
INSERT into dem.state(code, country, name) VALUES ('SC','BZ',i18n.i18n('Stann Creek'));
INSERT into dem.state(code, country, name) VALUES ('TO','BZ',i18n.i18n('Toledo'));
-- country CC
INSERT into dem.state(code, country, name) VALUES ('CC-1','CC',i18n.i18n('Cocos (Keeling) Islands territory'));
-- country CF
INSERT into dem.state(code, country, name) VALUES ('CF-1','CF',i18n.i18n('Central African Republic territory'));
-- country CG
INSERT into dem.state(code, country, name) VALUES ('CG-1','CG',i18n.i18n('Congo territory'));

-- country CH
INSERT into dem.state(code, country, name) VALUES ('AG','CH',i18n.i18n('Aargau'));
INSERT into dem.state(code, country, name) VALUES ('AR','CH',i18n.i18n('Appenzell Ausserrhoden'));
INSERT into dem.state(code, country, name) VALUES ('AI','CH',i18n.i18n('Appenzelli Innerrhoden'));
INSERT into dem.state(code, country, name) VALUES ('BS','CH',i18n.i18n('Basel'));
INSERT into dem.state(code, country, name) VALUES ('BE','CH',i18n.i18n('Bern'));
INSERT into dem.state(code, country, name) VALUES ('FR','CH',i18n.i18n('Freiburg'));
INSERT into dem.state(code, country, name) VALUES ('GE','CH',i18n.i18n('Geneve'));
INSERT into dem.state(code, country, name) VALUES ('GL','CH',i18n.i18n('Glarus'));
INSERT into dem.state(code, country, name) VALUES ('GR','CH',i18n.i18n('Graubünden'));
INSERT into dem.state(code, country, name) VALUES ('JU','CH',i18n.i18n('Jura'));
INSERT into dem.state(code, country, name) VALUES ('LU','CH',i18n.i18n('Luzern'));
INSERT into dem.state(code, country, name) VALUES ('NE','CH',i18n.i18n('Neuchâtel'));
INSERT into dem.state(code, country, name) VALUES ('NW','CH',i18n.i18n('Nidwalden'));
INSERT into dem.state(code, country, name) VALUES ('OW','CH',i18n.i18n('Obwalden'));
INSERT into dem.state(code, country, name) VALUES ('SG','CH',i18n.i18n('Sankt Gallen'));
INSERT into dem.state(code, country, name) VALUES ('SH','CH',i18n.i18n('Schaffhausen'));
INSERT into dem.state(code, country, name) VALUES ('SZ','CH',i18n.i18n('Schwyz'));
INSERT into dem.state(code, country, name) VALUES ('SO','CH',i18n.i18n('Solothurn'));
INSERT into dem.state(code, country, name) VALUES ('TG','CH',i18n.i18n('Thurgau'));
INSERT into dem.state(code, country, name) VALUES ('TI','CH',i18n.i18n('Ticino'));
INSERT into dem.state(code, country, name) VALUES ('UW','CH',i18n.i18n('Unterwalden'));
INSERT into dem.state(code, country, name) VALUES ('UR','CH',i18n.i18n('Uri'));
INSERT into dem.state(code, country, name) VALUES ('VS','CH',i18n.i18n('Valais'));
INSERT into dem.state(code, country, name) VALUES ('VD','CH',i18n.i18n('Vaud'));
INSERT into dem.state(code, country, name) VALUES ('ZG','CH',i18n.i18n('Zug'));
-- country CI
INSERT into dem.state(code, country, name) VALUES ('CI-1','CI',i18n.i18n('Cote D''Ivoire territory'));
-- country CK
INSERT into dem.state(code, country, name) VALUES ('CK-1','CK',i18n.i18n('Cook Islands territory'));
-- country CL
INSERT into dem.state(code, country, name) VALUES ('AI','CL',i18n.i18n('Aisen del General Carlos Ibanez'));
INSERT into dem.state(code, country, name) VALUES ('AN','CL',i18n.i18n('Antofagasta'));
INSERT into dem.state(code, country, name) VALUES ('AR','CL',i18n.i18n('Araucania'));
INSERT into dem.state(code, country, name) VALUES ('AT','CL',i18n.i18n('Atacama'));
INSERT into dem.state(code, country, name) VALUES ('BB','CL',i18n.i18n('Bio-Bio'));
INSERT into dem.state(code, country, name) VALUES ('CO','CL',i18n.i18n('Coquimbo'));
INSERT into dem.state(code, country, name) VALUES ('LI','CL',i18n.i18n('Libertador General Bernardo O''Hi'));
INSERT into dem.state(code, country, name) VALUES ('LL','CL',i18n.i18n('Los Lagos'));
INSERT into dem.state(code, country, name) VALUES ('MA','CL',i18n.i18n('Magallanes y de la Antartica Chi'));
INSERT into dem.state(code, country, name) VALUES ('MU','CL',i18n.i18n('Maule'));
INSERT into dem.state(code, country, name) VALUES ('RM','CL',i18n.i18n('Region Metropolitana'));
INSERT into dem.state(code, country, name) VALUES ('TA','CL',i18n.i18n('Tarapaca'));
INSERT into dem.state(code, country, name) VALUES ('VA','CL',i18n.i18n('Valparaiso'));
-- country CM
INSERT into dem.state(code, country, name) VALUES ('CM-1','CM',i18n.i18n('Cameroon territory'));
-- country CN
INSERT into dem.state(code, country, name) VALUES ('AN','CN',i18n.i18n('Anhui'));
INSERT into dem.state(code, country, name) VALUES ('BE','CN',i18n.i18n('Beijing'));
INSERT into dem.state(code, country, name) VALUES ('CH','CN',i18n.i18n('Chongqing'));
INSERT into dem.state(code, country, name) VALUES ('FU','CN',i18n.i18n('Fujian'));
INSERT into dem.state(code, country, name) VALUES ('GA','CN',i18n.i18n('Gansu'));
INSERT into dem.state(code, country, name) VALUES ('GU','CN',i18n.i18n('Guangdong'));
INSERT into dem.state(code, country, name) VALUES ('GX','CN',i18n.i18n('Guangxi'));
INSERT into dem.state(code, country, name) VALUES ('GZ','CN',i18n.i18n('Guizhou'));
INSERT into dem.state(code, country, name) VALUES ('HA','CN',i18n.i18n('Hainan'));
INSERT into dem.state(code, country, name) VALUES ('HB','CN',i18n.i18n('Hebei'));
INSERT into dem.state(code, country, name) VALUES ('HL','CN',i18n.i18n('Heilongjiang'));
INSERT into dem.state(code, country, name) VALUES ('HE','CN',i18n.i18n('Henan'));
INSERT into dem.state(code, country, name) VALUES ('HK','CN',i18n.i18n('Hong Kong'));
INSERT into dem.state(code, country, name) VALUES ('HU','CN',i18n.i18n('Hubei'));
INSERT into dem.state(code, country, name) VALUES ('HN','CN',i18n.i18n('Hunan'));
INSERT into dem.state(code, country, name) VALUES ('IM','CN',i18n.i18n('Inner Mongolia'));
INSERT into dem.state(code, country, name) VALUES ('JI','CN',i18n.i18n('Jiangsu'));
INSERT into dem.state(code, country, name) VALUES ('JX','CN',i18n.i18n('Jiangxi'));
INSERT into dem.state(code, country, name) VALUES ('JL','CN',i18n.i18n('Jilin'));
INSERT into dem.state(code, country, name) VALUES ('LI','CN',i18n.i18n('Liaoning'));
INSERT into dem.state(code, country, name) VALUES ('MA','CN',i18n.i18n('Macau'));
INSERT into dem.state(code, country, name) VALUES ('NI','CN',i18n.i18n('Ningxia'));
INSERT into dem.state(code, country, name) VALUES ('SH','CN',i18n.i18n('Shaanxi'));
INSERT into dem.state(code, country, name) VALUES ('SA','CN',i18n.i18n('Shandong'));
INSERT into dem.state(code, country, name) VALUES ('SG','CN',i18n.i18n('Shanghai'));
INSERT into dem.state(code, country, name) VALUES ('SX','CN',i18n.i18n('Shanxi'));
INSERT into dem.state(code, country, name) VALUES ('SI','CN',i18n.i18n('Sichuan'));
INSERT into dem.state(code, country, name) VALUES ('TI','CN',i18n.i18n('Tianjin'));
INSERT into dem.state(code, country, name) VALUES ('XI','CN',i18n.i18n('Xinjiang'));
INSERT into dem.state(code, country, name) VALUES ('YU','CN',i18n.i18n('Yunnan'));
INSERT into dem.state(code, country, name) VALUES ('ZH','CN',i18n.i18n('Zhejiang'));
-- country CO
INSERT into dem.state(code, country, name) VALUES ('AM','CO',i18n.i18n('Amazonas'));
INSERT into dem.state(code, country, name) VALUES ('AN','CO',i18n.i18n('Antioquia'));
INSERT into dem.state(code, country, name) VALUES ('AR','CO',i18n.i18n('Arauca'));
INSERT into dem.state(code, country, name) VALUES ('AT','CO',i18n.i18n('Atlantico'));
INSERT into dem.state(code, country, name) VALUES ('BO','CO',i18n.i18n('Bolivar'));
INSERT into dem.state(code, country, name) VALUES ('BY','CO',i18n.i18n('Boyaca'));
INSERT into dem.state(code, country, name) VALUES ('CA','CO',i18n.i18n('Caldas'));
INSERT into dem.state(code, country, name) VALUES ('CQ','CO',i18n.i18n('Caqueta'));
INSERT into dem.state(code, country, name) VALUES ('CS','CO',i18n.i18n('Casanare'));
INSERT into dem.state(code, country, name) VALUES ('CU','CO',i18n.i18n('Cauca'));
INSERT into dem.state(code, country, name) VALUES ('CE','CO',i18n.i18n('Cesar'));
INSERT into dem.state(code, country, name) VALUES ('CH','CO',i18n.i18n('Choco'));
INSERT into dem.state(code, country, name) VALUES ('CO','CO',i18n.i18n('Cordoba'));
INSERT into dem.state(code, country, name) VALUES ('DC','CO',i18n.i18n('Distrito Capital de Santa Fe de'));
INSERT into dem.state(code, country, name) VALUES ('GU','CO',i18n.i18n('Guainia'));
INSERT into dem.state(code, country, name) VALUES ('GA','CO',i18n.i18n('Guaviare'));
INSERT into dem.state(code, country, name) VALUES ('HU','CO',i18n.i18n('Huila'));
INSERT into dem.state(code, country, name) VALUES ('LG','CO',i18n.i18n('La Guajira'));
INSERT into dem.state(code, country, name) VALUES ('MA','CO',i18n.i18n('Magdalena'));
INSERT into dem.state(code, country, name) VALUES ('ME','CO',i18n.i18n('Meta'));
INSERT into dem.state(code, country, name) VALUES ('NA','CO',i18n.i18n('Narino'));
INSERT into dem.state(code, country, name) VALUES ('NS','CO',i18n.i18n('Norte de Santander'));
INSERT into dem.state(code, country, name) VALUES ('PU','CO',i18n.i18n('Putumayo'));
INSERT into dem.state(code, country, name) VALUES ('QU','CO',i18n.i18n('Quindio'));
INSERT into dem.state(code, country, name) VALUES ('RI','CO',i18n.i18n('Risaralda'));
INSERT into dem.state(code, country, name) VALUES ('SA','CO',i18n.i18n('San Andres y Providencia'));
INSERT into dem.state(code, country, name) VALUES ('SN','CO',i18n.i18n('Santander'));
INSERT into dem.state(code, country, name) VALUES ('SU','CO',i18n.i18n('Sucre'));
INSERT into dem.state(code, country, name) VALUES ('TO','CO',i18n.i18n('Tolima'));
INSERT into dem.state(code, country, name) VALUES ('VC','CO',i18n.i18n('Valle del Cauca'));
INSERT into dem.state(code, country, name) VALUES ('VA','CO',i18n.i18n('Vaupes'));
INSERT into dem.state(code, country, name) VALUES ('VI','CO',i18n.i18n('Vichada'));
-- country CR
INSERT into dem.state(code, country, name) VALUES ('AL','CR',i18n.i18n('Alajuela'));
INSERT into dem.state(code, country, name) VALUES ('CA','CR',i18n.i18n('Cartago'));
INSERT into dem.state(code, country, name) VALUES ('GU','CR',i18n.i18n('Guanacaste'));
INSERT into dem.state(code, country, name) VALUES ('HE','CR',i18n.i18n('Heredia'));
INSERT into dem.state(code, country, name) VALUES ('LI','CR',i18n.i18n('Limon'));
INSERT into dem.state(code, country, name) VALUES ('PU','CR',i18n.i18n('Puntarenas'));
INSERT into dem.state(code, country, name) VALUES ('SJ','CR',i18n.i18n('San Jose'));
-- country CU
INSERT into dem.state(code, country, name) VALUES ('CA','CU',i18n.i18n('Camaguey'));
INSERT into dem.state(code, country, name) VALUES ('CD','CU',i18n.i18n('Ciego de Avila'));
INSERT into dem.state(code, country, name) VALUES ('CI','CU',i18n.i18n('Cienfuegos'));
INSERT into dem.state(code, country, name) VALUES ('CH','CU',i18n.i18n('Ciudad de La Habana'));
INSERT into dem.state(code, country, name) VALUES ('GR','CU',i18n.i18n('Granma'));
INSERT into dem.state(code, country, name) VALUES ('GU','CU',i18n.i18n('Guantanamo'));
INSERT into dem.state(code, country, name) VALUES ('HO','CU',i18n.i18n('Holguin'));
INSERT into dem.state(code, country, name) VALUES ('IJ','CU',i18n.i18n('Isla de la Juventud'));
INSERT into dem.state(code, country, name) VALUES ('LH','CU',i18n.i18n('La Habana'));
INSERT into dem.state(code, country, name) VALUES ('LT','CU',i18n.i18n('Las Tunas'));
INSERT into dem.state(code, country, name) VALUES ('MA','CU',i18n.i18n('Matanzas'));
INSERT into dem.state(code, country, name) VALUES ('PR','CU',i18n.i18n('Pinar del Rio'));
INSERT into dem.state(code, country, name) VALUES ('SS','CU',i18n.i18n('Sancti Spiritus'));
INSERT into dem.state(code, country, name) VALUES ('SC','CU',i18n.i18n('Santiago de Cuba'));
INSERT into dem.state(code, country, name) VALUES ('VC','CU',i18n.i18n('Villa Clara'));
-- country CV
INSERT into dem.state(code, country, name) VALUES ('CV-1','CV',i18n.i18n('Cape Verde territory'));
-- country CX
INSERT into dem.state(code, country, name) VALUES ('CX-1','CX',i18n.i18n('Christmas Island territory'));
-- country CY
INSERT into dem.state(code, country, name) VALUES ('CY-1','CY',i18n.i18n('Cyprus territory'));
-- country CZ
INSERT into dem.state(code, country, name) VALUES ('U ','CZ',i18n.i18n('Ustecky'));
INSERT into dem.state(code, country, name) VALUES ('C ','CZ',i18n.i18n('Jihocesky'));
INSERT into dem.state(code, country, name) VALUES ('B ','CZ',i18n.i18n('Jihomoravsky'));
INSERT into dem.state(code, country, name) VALUES ('K ','CZ',i18n.i18n('Karlovarsky'));
INSERT into dem.state(code, country, name) VALUES ('H ','CZ',i18n.i18n('Kralovehradecky'));
INSERT into dem.state(code, country, name) VALUES ('L ','CZ',i18n.i18n('Liberecky'));
INSERT into dem.state(code, country, name) VALUES ('T ','CZ',i18n.i18n('Moravskoslezsky'));
INSERT into dem.state(code, country, name) VALUES ('M ','CZ',i18n.i18n('Olomoucky'));
INSERT into dem.state(code, country, name) VALUES ('E ','CZ',i18n.i18n('Pardubicky'));
INSERT into dem.state(code, country, name) VALUES ('P ','CZ',i18n.i18n('Plzensky'));
INSERT into dem.state(code, country, name) VALUES ('A ','CZ',i18n.i18n('Praha'));
INSERT into dem.state(code, country, name) VALUES ('S ','CZ',i18n.i18n('Stredocesky'));
INSERT into dem.state(code, country, name) VALUES ('J ','CZ',i18n.i18n('Vysocina'));
INSERT into dem.state(code, country, name) VALUES ('Z ','CZ',i18n.i18n('Zlinsky'));
-- country DJ
INSERT into dem.state(code, country, name) VALUES ('DJ-1','DJ',i18n.i18n('Djibouti territory'));
-- country DK
INSERT into dem.state(code, country, name) VALUES ('AR','DK',i18n.i18n('Arhus'));
INSERT into dem.state(code, country, name) VALUES ('BO','DK',i18n.i18n('Bornholm'));
INSERT into dem.state(code, country, name) VALUES ('FR','DK',i18n.i18n('Frederiksborg'));
INSERT into dem.state(code, country, name) VALUES ('FY','DK',i18n.i18n('Fyn'));
INSERT into dem.state(code, country, name) VALUES ('KO','DK',i18n.i18n('Kobenhavn'));
INSERT into dem.state(code, country, name) VALUES ('NO','DK',i18n.i18n('Nordjylland'));
INSERT into dem.state(code, country, name) VALUES ('RI','DK',i18n.i18n('Ribe'));
INSERT into dem.state(code, country, name) VALUES ('RK','DK',i18n.i18n('Ringkobing'));
INSERT into dem.state(code, country, name) VALUES ('RO','DK',i18n.i18n('Roskilde'));
INSERT into dem.state(code, country, name) VALUES ('SO','DK',i18n.i18n('Sonderjylland'));
INSERT into dem.state(code, country, name) VALUES ('ST','DK',i18n.i18n('Storstrom'));
INSERT into dem.state(code, country, name) VALUES ('VE','DK',i18n.i18n('Vejle'));
INSERT into dem.state(code, country, name) VALUES ('VJ','DK',i18n.i18n('Vestjælland'));
INSERT into dem.state(code, country, name) VALUES ('VI','DK',i18n.i18n('Viborg'));
-- country DM
INSERT into dem.state(code, country, name) VALUES ('DM-1','DM',i18n.i18n('Dominica territory'));
-- country DO
INSERT into dem.state(code, country, name) VALUES ('DO-1','DO',i18n.i18n('Dominican Republic territory'));
-- country DZ
INSERT into dem.state(code, country, name) VALUES ('AD','DZ',i18n.i18n('Adrar'));
INSERT into dem.state(code, country, name) VALUES ('AI','DZ',i18n.i18n('Ain Defla'));
INSERT into dem.state(code, country, name) VALUES ('AT','DZ',i18n.i18n('Ain Temouchent'));
INSERT into dem.state(code, country, name) VALUES ('AL','DZ',i18n.i18n('Alger'));
INSERT into dem.state(code, country, name) VALUES ('AN','DZ',i18n.i18n('Annaba'));
INSERT into dem.state(code, country, name) VALUES ('BA','DZ',i18n.i18n('Batna'));
INSERT into dem.state(code, country, name) VALUES ('BE','DZ',i18n.i18n('Bechar'));
INSERT into dem.state(code, country, name) VALUES ('BJ','DZ',i18n.i18n('Bejaia'));
INSERT into dem.state(code, country, name) VALUES ('BI','DZ',i18n.i18n('Biskra'));
INSERT into dem.state(code, country, name) VALUES ('BL','DZ',i18n.i18n('Blida'));
INSERT into dem.state(code, country, name) VALUES ('BB','DZ',i18n.i18n('Bordj Bou Arreridj'));
INSERT into dem.state(code, country, name) VALUES ('BO','DZ',i18n.i18n('Bouira'));
INSERT into dem.state(code, country, name) VALUES ('BU','DZ',i18n.i18n('Boumerdes'));
INSERT into dem.state(code, country, name) VALUES ('CH','DZ',i18n.i18n('Chlef'));
INSERT into dem.state(code, country, name) VALUES ('CO','DZ',i18n.i18n('Constantine'));
INSERT into dem.state(code, country, name) VALUES ('DJ','DZ',i18n.i18n('Djelfa'));
INSERT into dem.state(code, country, name) VALUES ('EB','DZ',i18n.i18n('El Bayadh'));
INSERT into dem.state(code, country, name) VALUES ('EO','DZ',i18n.i18n('El Oued'));
INSERT into dem.state(code, country, name) VALUES ('ET','DZ',i18n.i18n('El Tarf'));
INSERT into dem.state(code, country, name) VALUES ('GH','DZ',i18n.i18n('Ghardaia'));
INSERT into dem.state(code, country, name) VALUES ('GU','DZ',i18n.i18n('Guelma'));
INSERT into dem.state(code, country, name) VALUES ('IL','DZ',i18n.i18n('Illizi'));
INSERT into dem.state(code, country, name) VALUES ('JI','DZ',i18n.i18n('Jijel'));
INSERT into dem.state(code, country, name) VALUES ('KH','DZ',i18n.i18n('Khenchela'));
INSERT into dem.state(code, country, name) VALUES ('LA','DZ',i18n.i18n('Laghouat'));
INSERT into dem.state(code, country, name) VALUES ('MS','DZ',i18n.i18n('M''Sila'));
INSERT into dem.state(code, country, name) VALUES ('MA','DZ',i18n.i18n('Mascara'));
INSERT into dem.state(code, country, name) VALUES ('ME','DZ',i18n.i18n('Medea'));
INSERT into dem.state(code, country, name) VALUES ('MI','DZ',i18n.i18n('Mila'));
INSERT into dem.state(code, country, name) VALUES ('MO','DZ',i18n.i18n('Mostaganem'));
INSERT into dem.state(code, country, name) VALUES ('NA','DZ',i18n.i18n('Naama'));
INSERT into dem.state(code, country, name) VALUES ('OR','DZ',i18n.i18n('Oran'));
INSERT into dem.state(code, country, name) VALUES ('OU','DZ',i18n.i18n('Ouargla'));
INSERT into dem.state(code, country, name) VALUES ('OB','DZ',i18n.i18n('Oum el Bouaghi'));
INSERT into dem.state(code, country, name) VALUES ('RE','DZ',i18n.i18n('Relizane'));
INSERT into dem.state(code, country, name) VALUES ('SA','DZ',i18n.i18n('Saida'));
INSERT into dem.state(code, country, name) VALUES ('SE','DZ',i18n.i18n('Setif'));
INSERT into dem.state(code, country, name) VALUES ('SB','DZ',i18n.i18n('Sidi Bel Abbes'));
INSERT into dem.state(code, country, name) VALUES ('SK','DZ',i18n.i18n('Skikda'));
INSERT into dem.state(code, country, name) VALUES ('TA','DZ',i18n.i18n('Tamanghasset'));
INSERT into dem.state(code, country, name) VALUES ('TE','DZ',i18n.i18n('Tebessa'));
INSERT into dem.state(code, country, name) VALUES ('TI','DZ',i18n.i18n('Tiaret'));
INSERT into dem.state(code, country, name) VALUES ('TN','DZ',i18n.i18n('Tindouf'));
INSERT into dem.state(code, country, name) VALUES ('TP','DZ',i18n.i18n('Tipaza'));
INSERT into dem.state(code, country, name) VALUES ('TS','DZ',i18n.i18n('Tissemsilt'));
INSERT into dem.state(code, country, name) VALUES ('TO','DZ',i18n.i18n('Tizi Ouzou'));
INSERT into dem.state(code, country, name) VALUES ('TL','DZ',i18n.i18n('Tlemcen'));
-- country EC
INSERT into dem.state(code, country, name) VALUES ('EC-1','EC',i18n.i18n('Ecuador territory'));
-- country EE
INSERT into dem.state(code, country, name) VALUES ('HA','EE',i18n.i18n('Harjumaa (Tallinn)'));
INSERT into dem.state(code, country, name) VALUES ('HI','EE',i18n.i18n('Hiiumaa (Kardla)'));
INSERT into dem.state(code, country, name) VALUES ('IV','EE',i18n.i18n('Ida-Virumaa (Johvi)'));
INSERT into dem.state(code, country, name) VALUES ('JA','EE',i18n.i18n('Jarvamaa (Paide)'));
INSERT into dem.state(code, country, name) VALUES ('JO','EE',i18n.i18n('Jogevamaa (Jogeva)'));
INSERT into dem.state(code, country, name) VALUES ('LV','EE',i18n.i18n('Laane-Virumaa (Rakvere)'));
INSERT into dem.state(code, country, name) VALUES ('LA','EE',i18n.i18n('Laanemaa (Haapsalu)'));
INSERT into dem.state(code, country, name) VALUES ('PA','EE',i18n.i18n('Parnumaa (Parnu)'));
INSERT into dem.state(code, country, name) VALUES ('PO','EE',i18n.i18n('Polvamaa (Polva)'));
INSERT into dem.state(code, country, name) VALUES ('RA','EE',i18n.i18n('Raplamaa (Rapla)'));
INSERT into dem.state(code, country, name) VALUES ('SA','EE',i18n.i18n('Saaremaa (Kuessaare)'));
INSERT into dem.state(code, country, name) VALUES ('TA','EE',i18n.i18n('Tartumaa (Tartu)'));
INSERT into dem.state(code, country, name) VALUES ('VA','EE',i18n.i18n('Valgamaa (Valga)'));
INSERT into dem.state(code, country, name) VALUES ('VI','EE',i18n.i18n('Viljandimaa (Viljandi)'));
INSERT into dem.state(code, country, name) VALUES ('VO','EE',i18n.i18n('Vorumaa (Voru)'));
-- country EG
INSERT into dem.state(code, country, name) VALUES ('EG-1','EG',i18n.i18n('Egypt territory'));
-- country EH
--INSERT into dem.state(code, country, name) VALUES ('EH-1','EH',i18n.i18n('which country !!!'));
-- country ER
INSERT into dem.state(code, country, name) VALUES ('ER-1','ER',i18n.i18n('Eritrea territory'));
-- country ET
INSERT into dem.state(code, country, name) VALUES ('ET-1','ET',i18n.i18n('Ethiopia territory'));
-- country FI
INSERT into dem.state(code, country, name) VALUES ('AL','FI',i18n.i18n('Aland'));
INSERT into dem.state(code, country, name) VALUES ('ES','FI',i18n.i18n('Etela-Suomen Laani'));
INSERT into dem.state(code, country, name) VALUES ('IS','FI',i18n.i18n('Ita-Suomen Laani'));
INSERT into dem.state(code, country, name) VALUES ('LS','FI',i18n.i18n('Lansi-Suomen Laani'));
INSERT into dem.state(code, country, name) VALUES ('LA','FI',i18n.i18n('Lappi'));
INSERT into dem.state(code, country, name) VALUES ('OU','FI',i18n.i18n('Oulun Laani'));
-- country FJ
INSERT into dem.state(code, country, name) VALUES ('FJ-1','FJ',i18n.i18n('Fiji territory'));
-- country FK
INSERT into dem.state(code, country, name) VALUES ('FK-1','FK',i18n.i18n('Falkland Islands (Malvinas) territory'));
-- country FM
INSERT into dem.state(code, country, name) VALUES ('FM-1','FM',i18n.i18n('Micronesia, Federated States Of, territory'));
-- country FO
INSERT into dem.state(code, country, name) VALUES ('FO-1','FO',i18n.i18n('Faroe Islands territory'));
-- country FR
INSERT into dem.state(code, country, name) VALUES ('AL','FR',i18n.i18n('Alsace'));
INSERT into dem.state(code, country, name) VALUES ('AQ','FR',i18n.i18n('Aquitaine'));
INSERT into dem.state(code, country, name) VALUES ('AU','FR',i18n.i18n('Auvergne'));
INSERT into dem.state(code, country, name) VALUES ('BR','FR',i18n.i18n('Brittany'));
INSERT into dem.state(code, country, name) VALUES ('BU','FR',i18n.i18n('Burgundy'));
INSERT into dem.state(code, country, name) VALUES ('CE','FR',i18n.i18n('Center Loire Valley'));
INSERT into dem.state(code, country, name) VALUES ('CH','FR',i18n.i18n('Champagne'));
INSERT into dem.state(code, country, name) VALUES ('CO','FR',i18n.i18n('Corse'));
INSERT into dem.state(code, country, name) VALUES ('FR','FR',i18n.i18n('France Comte'));
INSERT into dem.state(code, country, name) VALUES ('LA','FR',i18n.i18n('Languedoc Roussillon'));
INSERT into dem.state(code, country, name) VALUES ('LI','FR',i18n.i18n('Limousin'));
INSERT into dem.state(code, country, name) VALUES ('LO','FR',i18n.i18n('Lorraine'));
INSERT into dem.state(code, country, name) VALUES ('MI','FR',i18n.i18n('Midi Pyrenees'));
INSERT into dem.state(code, country, name) VALUES ('NO','FR',i18n.i18n('Nord Pas de Calais'));
INSERT into dem.state(code, country, name) VALUES ('NR','FR',i18n.i18n('Normandy'));
INSERT into dem.state(code, country, name) VALUES ('PA','FR',i18n.i18n('Paris / Ill de France'));
INSERT into dem.state(code, country, name) VALUES ('PI','FR',i18n.i18n('Picardie'));
INSERT into dem.state(code, country, name) VALUES ('PO','FR',i18n.i18n('Poitou Charente'));
INSERT into dem.state(code, country, name) VALUES ('PR','FR',i18n.i18n('Provence'));
INSERT into dem.state(code, country, name) VALUES ('RH','FR',i18n.i18n('Rhone Alps'));
INSERT into dem.state(code, country, name) VALUES ('RI','FR',i18n.i18n('Riviera'));
INSERT into dem.state(code, country, name) VALUES ('WE','FR',i18n.i18n('Western Loire Valley'));
-- country FX
-- INSERT into dem.state(code, country, name) VALUES ('FX-1','FX',i18n.i18n('StateNameStub'));
-- country GA
INSERT into dem.state(code, country, name) VALUES ('GA-1','GA',i18n.i18n('Gabon territory'));
-- country GB
INSERT into dem.state(code, country, name) VALUES ('AB','GB',i18n.i18n('Aberdeen'));
--INSERT into dem.state(code, country, name) VALUES ('AB','GB',i18n.i18n('Aberdeenshire'));
INSERT into dem.state(code, country, name) VALUES ('AN','GB',i18n.i18n('Anglesey'));
INSERT into dem.state(code, country, name) VALUES ('AG','GB',i18n.i18n('Angus'));
INSERT into dem.state(code, country, name) VALUES ('AR','GB',i18n.i18n('Argyll and Bute'));
INSERT into dem.state(code, country, name) VALUES ('BE','GB',i18n.i18n('Bedfordshire'));
--INSERT into dem.state(code, country, name) VALUES ('BE','GB',i18n.i18n('Berkshire'));
INSERT into dem.state(code, country, name) VALUES ('BL','GB',i18n.i18n('Blaenau Gwent'));
INSERT into dem.state(code, country, name) VALUES ('BR','GB',i18n.i18n('Bridgend'));
INSERT into dem.state(code, country, name) VALUES ('BS','GB',i18n.i18n('Bristol'));
INSERT into dem.state(code, country, name) VALUES ('BU','GB',i18n.i18n('Buckinghamshire'));
INSERT into dem.state(code, country, name) VALUES ('CA','GB',i18n.i18n('Caerphilly'));
--INSERT into dem.state(code, country, name) VALUES ('CA','GB',i18n.i18n('Cambridgeshire'));
--INSERT into dem.state(code, country, name) VALUES ('CA','GB',i18n.i18n('Carmarthenshire'));
INSERT into dem.state(code, country, name) VALUES ('CD','GB',i18n.i18n('Cardiff'));
--INSERT into dem.state(code, country, name) VALUES ('CD','GB',i18n.i18n('Ceredigion'));
INSERT into dem.state(code, country, name) VALUES ('CH','GB',i18n.i18n('Cheshire'));
INSERT into dem.state(code, country, name) VALUES ('CL','GB',i18n.i18n('Clackmannanshire'));
INSERT into dem.state(code, country, name) VALUES ('CO','GB',i18n.i18n('Conwy'));
--INSERT into dem.state(code, country, name) VALUES ('CO','GB',i18n.i18n('Cornwall'));
INSERT into dem.state(code, country, name) VALUES ('DN','GB',i18n.i18n('Denbighshire'));
INSERT into dem.state(code, country, name) VALUES ('DE','GB',i18n.i18n('Derbyshire'));
INSERT into dem.state(code, country, name) VALUES ('DV','GB',i18n.i18n('Devon'));
INSERT into dem.state(code, country, name) VALUES ('DO','GB',i18n.i18n('Dorset'));
INSERT into dem.state(code, country, name) VALUES ('DG','GB',i18n.i18n('Dumfries and Galloway'));
INSERT into dem.state(code, country, name) VALUES ('DU','GB',i18n.i18n('Dundee'));
INSERT into dem.state(code, country, name) VALUES ('DH','GB',i18n.i18n('Durham'));
--INSERT into dem.state(code, country, name) VALUES ('AR','GB',i18n.i18n('East Ayrshire'));
--INSERT into dem.state(code, country, name) VALUES ('DU','GB',i18n.i18n('East Dunbartonshire'));
INSERT into dem.state(code, country, name) VALUES ('LO','GB',i18n.i18n('East Lothian'));
INSERT into dem.state(code, country, name) VALUES ('RE','GB',i18n.i18n('East Renfrewshire'));
INSERT into dem.state(code, country, name) VALUES ('ER','GB',i18n.i18n('East Riding of Yorkshire'));
INSERT into dem.state(code, country, name) VALUES ('SX','GB',i18n.i18n('East Sussex'));
INSERT into dem.state(code, country, name) VALUES ('ED','GB',i18n.i18n('Edinburgh'));
INSERT into dem.state(code, country, name) VALUES ('ES','GB',i18n.i18n('Essex'));
INSERT into dem.state(code, country, name) VALUES ('FA','GB',i18n.i18n('Falkirk'));
INSERT into dem.state(code, country, name) VALUES ('FF','GB',i18n.i18n('Fife'));
INSERT into dem.state(code, country, name) VALUES ('FL','GB',i18n.i18n('Flintshire'));
INSERT into dem.state(code, country, name) VALUES ('GL','GB',i18n.i18n('Glasgow'));
--INSERT into dem.state(code, country, name) VALUES ('GL','GB',i18n.i18n('Gloucestershire'));
INSERT into dem.state(code, country, name) VALUES ('LD','GB',i18n.i18n('Greater London'));
INSERT into dem.state(code, country, name) VALUES ('MC','GB',i18n.i18n('Greater Manchester'));
INSERT into dem.state(code, country, name) VALUES ('GD','GB',i18n.i18n('Gwynedd'));
INSERT into dem.state(code, country, name) VALUES ('HA','GB',i18n.i18n('Hampshire'));
INSERT into dem.state(code, country, name) VALUES ('HW','GB',i18n.i18n('Herefordshire'));
INSERT into dem.state(code, country, name) VALUES ('HE','GB',i18n.i18n('Hertfordshire'));
INSERT into dem.state(code, country, name) VALUES ('HL','GB',i18n.i18n('Highlands'));
INSERT into dem.state(code, country, name) VALUES ('IV','GB',i18n.i18n('Inverclyde'));
INSERT into dem.state(code, country, name) VALUES ('IO','GB',i18n.i18n('Isle of Wight'));
INSERT into dem.state(code, country, name) VALUES ('KN','GB',i18n.i18n('Kent'));
INSERT into dem.state(code, country, name) VALUES ('LA','GB',i18n.i18n('Lancashire'));
INSERT into dem.state(code, country, name) VALUES ('LE','GB',i18n.i18n('Leicestershire'));
INSERT into dem.state(code, country, name) VALUES ('LI','GB',i18n.i18n('Lincolnshire'));
INSERT into dem.state(code, country, name) VALUES ('MS','GB',i18n.i18n('Merseyside'));
INSERT into dem.state(code, country, name) VALUES ('ME','GB',i18n.i18n('Merthyr Tydfil'));
INSERT into dem.state(code, country, name) VALUES ('ML','GB',i18n.i18n('Midlothian'));
INSERT into dem.state(code, country, name) VALUES ('MM','GB',i18n.i18n('Monmouthshire'));
INSERT into dem.state(code, country, name) VALUES ('MO','GB',i18n.i18n('Moray'));
INSERT into dem.state(code, country, name) VALUES ('NP','GB',i18n.i18n('Neath Port Talbot'));
INSERT into dem.state(code, country, name) VALUES ('NE','GB',i18n.i18n('Newport'));
INSERT into dem.state(code, country, name) VALUES ('NO','GB',i18n.i18n('Norfolk'));
--INSERT into dem.state(code, country, name) VALUES ('AR','GB',i18n.i18n('North Ayrshire'));
--INSERT into dem.state(code, country, name) VALUES ('LA','GB',i18n.i18n('North Lanarkshire'));
INSERT into dem.state(code, country, name) VALUES ('YS','GB',i18n.i18n('North Yorkshire'));
INSERT into dem.state(code, country, name) VALUES ('NH','GB',i18n.i18n('Northamptonshire'));
INSERT into dem.state(code, country, name) VALUES ('NL','GB',i18n.i18n('Northumberland'));
--INSERT into dem.state(code, country, name) VALUES ('NO','GB',i18n.i18n('Nottinghamshire'));
INSERT into dem.state(code, country, name) VALUES ('OR','GB',i18n.i18n('Orkney Islands'));
INSERT into dem.state(code, country, name) VALUES ('OF','GB',i18n.i18n('Oxfordshire'));
INSERT into dem.state(code, country, name) VALUES ('PE','GB',i18n.i18n('Pembrokeshire'));
--INSERT into dem.state(code, country, name) VALUES ('PE','GB',i18n.i18n('Perth and Kinross'));
INSERT into dem.state(code, country, name) VALUES ('PW','GB',i18n.i18n('Powys'));
--INSERT into dem.state(code, country, name) VALUES ('RE','GB',i18n.i18n('Renfrewshire'));
INSERT into dem.state(code, country, name) VALUES ('RH','GB',i18n.i18n('Rhondda Cynon Taff'));
INSERT into dem.state(code, country, name) VALUES ('RU','GB',i18n.i18n('Rutland'));
INSERT into dem.state(code, country, name) VALUES ('BO','GB',i18n.i18n('Scottish Borders'));
INSERT into dem.state(code, country, name) VALUES ('SH','GB',i18n.i18n('Shetland Islands'));
INSERT into dem.state(code, country, name) VALUES ('SP','GB',i18n.i18n('Shropshire'));
INSERT into dem.state(code, country, name) VALUES ('SO','GB',i18n.i18n('Somerset'));
--INSERT into dem.state(code, country, name) VALUES ('AR','GB',i18n.i18n('South Ayrshire'));
--INSERT into dem.state(code, country, name) VALUES ('LA','GB',i18n.i18n('South Lanarkshire'));
--INSERT into dem.state(code, country, name) VALUES ('YS','GB',i18n.i18n('South Yorkshire'));
INSERT into dem.state(code, country, name) VALUES ('SF','GB',i18n.i18n('Staffordshire'));
INSERT into dem.state(code, country, name) VALUES ('ST','GB',i18n.i18n('Stirling'));
--INSERT into dem.state(code, country, name) VALUES ('SF','GB',i18n.i18n('Suffolk'));
INSERT into dem.state(code, country, name) VALUES ('SR','GB',i18n.i18n('Surrey'));
INSERT into dem.state(code, country, name) VALUES ('SW','GB',i18n.i18n('Swansea'));
INSERT into dem.state(code, country, name) VALUES ('TO','GB',i18n.i18n('Torfaen'));
INSERT into dem.state(code, country, name) VALUES ('TW','GB',i18n.i18n('Tyne and Wear'));
INSERT into dem.state(code, country, name) VALUES ('VG','GB',i18n.i18n('Vale of Glamorgan'));
INSERT into dem.state(code, country, name) VALUES ('WA','GB',i18n.i18n('Warwickshire'));
INSERT into dem.state(code, country, name) VALUES ('WD','GB',i18n.i18n('West Dunbartonshire'));
INSERT into dem.state(code, country, name) VALUES ('WL','GB',i18n.i18n('West Lothian'));
INSERT into dem.state(code, country, name) VALUES ('WM','GB',i18n.i18n('West Midlands'));
--INSERT into dem.state(code, country, name) VALUES ('SX','GB',i18n.i18n('West Sussex'));
--INSERT into dem.state(code, country, name) VALUES ('YS','GB',i18n.i18n('West Yorkshire'));
INSERT into dem.state(code, country, name) VALUES ('WI','GB',i18n.i18n('Western Isles'));
--INSERT into dem.state(code, country, name) VALUES ('WL','GB',i18n.i18n('Wiltshire'));
INSERT into dem.state(code, country, name) VALUES ('WO','GB',i18n.i18n('Worcestershire'));
INSERT into dem.state(code, country, name) VALUES ('WR','GB',i18n.i18n('Wrexham'));
-- country GD
INSERT into dem.state(code, country, name) VALUES ('GD-1','GD',i18n.i18n('StateNameStub'));
-- country GE
INSERT into dem.state(code, country, name) VALUES ('GE-1','GE',i18n.i18n('StateNameStub'));
-- country GF
INSERT into dem.state(code, country, name) VALUES ('GF-1','GF',i18n.i18n('StateNameStub'));
-- country GH
INSERT into dem.state(code, country, name) VALUES ('GH-1','GH',i18n.i18n('StateNameStub'));
-- country GI
INSERT into dem.state(code, country, name) VALUES ('GI-1','GI',i18n.i18n('StateNameStub'));
-- country GL
INSERT into dem.state(code, country, name) VALUES ('GL-1','GL',i18n.i18n('StateNameStub'));
-- country GM
INSERT into dem.state(code, country, name) VALUES ('GM-1','GM',i18n.i18n('StateNameStub'));
-- country GN
INSERT into dem.state(code, country, name) VALUES ('GN-1','GN',i18n.i18n('StateNameStub'));
-- country GP
INSERT into dem.state(code, country, name) VALUES ('GP-1','GP',i18n.i18n('StateNameStub'));
-- country GQ
INSERT into dem.state(code, country, name) VALUES ('GQ-1','GQ',i18n.i18n('StateNameStub'));
-- country GR
INSERT into dem.state(code, country, name) VALUES ('AI','GR',i18n.i18n('Aitolia kai Akarnania'));
INSERT into dem.state(code, country, name) VALUES ('AK','GR',i18n.i18n('Akhaia'));
INSERT into dem.state(code, country, name) VALUES ('AG','GR',i18n.i18n('Argolis'));
INSERT into dem.state(code, country, name) VALUES ('AD','GR',i18n.i18n('Arkadhia'));
INSERT into dem.state(code, country, name) VALUES ('AR','GR',i18n.i18n('Arta'));
INSERT into dem.state(code, country, name) VALUES ('AT','GR',i18n.i18n('Attiki'));
INSERT into dem.state(code, country, name) VALUES ('AY','GR',i18n.i18n('Ayion Oros (Mt. Athos)'));
INSERT into dem.state(code, country, name) VALUES ('DH','GR',i18n.i18n('Dhodhekanisos'));
INSERT into dem.state(code, country, name) VALUES ('DR','GR',i18n.i18n('Drama'));
INSERT into dem.state(code, country, name) VALUES ('ET','GR',i18n.i18n('Evritania'));
INSERT into dem.state(code, country, name) VALUES ('ES','GR',i18n.i18n('Evros'));
INSERT into dem.state(code, country, name) VALUES ('EV','GR',i18n.i18n('Evvoia'));
INSERT into dem.state(code, country, name) VALUES ('FL','GR',i18n.i18n('Florina'));
INSERT into dem.state(code, country, name) VALUES ('FO','GR',i18n.i18n('Fokis'));
INSERT into dem.state(code, country, name) VALUES ('FT','GR',i18n.i18n('Fthiotis'));
INSERT into dem.state(code, country, name) VALUES ('GR','GR',i18n.i18n('Grevena'));
INSERT into dem.state(code, country, name) VALUES ('IL','GR',i18n.i18n('Ilia'));
INSERT into dem.state(code, country, name) VALUES ('IM','GR',i18n.i18n('Imathia'));
INSERT into dem.state(code, country, name) VALUES ('IO','GR',i18n.i18n('Ioannina'));
INSERT into dem.state(code, country, name) VALUES ('IR','GR',i18n.i18n('Irakleion'));
INSERT into dem.state(code, country, name) VALUES ('KA','GR',i18n.i18n('Kardhitsa'));
INSERT into dem.state(code, country, name) VALUES ('KS','GR',i18n.i18n('Kastoria'));
INSERT into dem.state(code, country, name) VALUES ('KV','GR',i18n.i18n('Kavala'));
INSERT into dem.state(code, country, name) VALUES ('KE','GR',i18n.i18n('Kefallinia'));
INSERT into dem.state(code, country, name) VALUES ('KR','GR',i18n.i18n('Kerkyra'));
INSERT into dem.state(code, country, name) VALUES ('KH','GR',i18n.i18n('Khalkidhiki'));
INSERT into dem.state(code, country, name) VALUES ('KN','GR',i18n.i18n('Khania'));
INSERT into dem.state(code, country, name) VALUES ('KI','GR',i18n.i18n('Khios'));
INSERT into dem.state(code, country, name) VALUES ('KK','GR',i18n.i18n('Kikladhes'));
INSERT into dem.state(code, country, name) VALUES ('KL','GR',i18n.i18n('Kilkis'));
INSERT into dem.state(code, country, name) VALUES ('KO','GR',i18n.i18n('Korinthia'));
INSERT into dem.state(code, country, name) VALUES ('KZ','GR',i18n.i18n('Kozani'));
INSERT into dem.state(code, country, name) VALUES ('LA','GR',i18n.i18n('Lakonia'));
INSERT into dem.state(code, country, name) VALUES ('LR','GR',i18n.i18n('Larisa'));
INSERT into dem.state(code, country, name) VALUES ('LS','GR',i18n.i18n('Lasithi'));
INSERT into dem.state(code, country, name) VALUES ('LE','GR',i18n.i18n('Lesvos'));
INSERT into dem.state(code, country, name) VALUES ('LV','GR',i18n.i18n('Levkas'));
INSERT into dem.state(code, country, name) VALUES ('MA','GR',i18n.i18n('Magnisia'));
INSERT into dem.state(code, country, name) VALUES ('ME','GR',i18n.i18n('Messinia'));
INSERT into dem.state(code, country, name) VALUES ('PE','GR',i18n.i18n('Pella'));
INSERT into dem.state(code, country, name) VALUES ('PI','GR',i18n.i18n('Pieria'));
INSERT into dem.state(code, country, name) VALUES ('PR','GR',i18n.i18n('Preveza'));
INSERT into dem.state(code, country, name) VALUES ('RE','GR',i18n.i18n('Rethimni'));
INSERT into dem.state(code, country, name) VALUES ('RO','GR',i18n.i18n('Rodhopi'));
INSERT into dem.state(code, country, name) VALUES ('SA','GR',i18n.i18n('Samos'));
INSERT into dem.state(code, country, name) VALUES ('SE','GR',i18n.i18n('Serrai'));
INSERT into dem.state(code, country, name) VALUES ('TH','GR',i18n.i18n('Thesprotia'));
INSERT into dem.state(code, country, name) VALUES ('TS','GR',i18n.i18n('Thessaloniki'));
INSERT into dem.state(code, country, name) VALUES ('TR','GR',i18n.i18n('Trikala'));
INSERT into dem.state(code, country, name) VALUES ('VO','GR',i18n.i18n('Voiotia'));
INSERT into dem.state(code, country, name) VALUES ('XA','GR',i18n.i18n('Xanthi'));
INSERT into dem.state(code, country, name) VALUES ('ZA','GR',i18n.i18n('Zakinthos'));
-- country GS
INSERT into dem.state(code, country, name) VALUES ('GS-1','GS',i18n.i18n('StateNameStub'));
-- country GT
INSERT into dem.state(code, country, name) VALUES ('AV','GT',i18n.i18n('Alta Verapaz'));
INSERT into dem.state(code, country, name) VALUES ('BV','GT',i18n.i18n('Baja Verapaz'));
INSERT into dem.state(code, country, name) VALUES ('CH','GT',i18n.i18n('Chimaltenango'));
INSERT into dem.state(code, country, name) VALUES ('CI','GT',i18n.i18n('Chiquimula'));
INSERT into dem.state(code, country, name) VALUES ('EP','GT',i18n.i18n('El Progreso'));
INSERT into dem.state(code, country, name) VALUES ('ES','GT',i18n.i18n('Escuintla'));
INSERT into dem.state(code, country, name) VALUES ('GU','GT',i18n.i18n('Guatemala'));
INSERT into dem.state(code, country, name) VALUES ('HU','GT',i18n.i18n('Huehuetenango'));
INSERT into dem.state(code, country, name) VALUES ('IZ','GT',i18n.i18n('Izabal'));
INSERT into dem.state(code, country, name) VALUES ('JA','GT',i18n.i18n('Jalapa'));
INSERT into dem.state(code, country, name) VALUES ('JU','GT',i18n.i18n('Jutiapa'));
INSERT into dem.state(code, country, name) VALUES ('PE','GT',i18n.i18n('Peten'));
INSERT into dem.state(code, country, name) VALUES ('QU','GT',i18n.i18n('Quetzaltenango'));
INSERT into dem.state(code, country, name) VALUES ('QI','GT',i18n.i18n('Quiche'));
INSERT into dem.state(code, country, name) VALUES ('RE','GT',i18n.i18n('Retalhuleu'));
INSERT into dem.state(code, country, name) VALUES ('SA','GT',i18n.i18n('Sacatepequez'));
INSERT into dem.state(code, country, name) VALUES ('SM','GT',i18n.i18n('San Marcos'));
INSERT into dem.state(code, country, name) VALUES ('SR','GT',i18n.i18n('Santa Rosa'));
INSERT into dem.state(code, country, name) VALUES ('SO','GT',i18n.i18n('Solola'));
INSERT into dem.state(code, country, name) VALUES ('SU','GT',i18n.i18n('Suchitepequez'));
INSERT into dem.state(code, country, name) VALUES ('TO','GT',i18n.i18n('Totonicapan'));
INSERT into dem.state(code, country, name) VALUES ('ZA','GT',i18n.i18n('Zacapa'));
-- country GU
INSERT into dem.state(code, country, name) VALUES ('GU-1','GU',i18n.i18n('StateNameStub'));
-- country GW
INSERT into dem.state(code, country, name) VALUES ('GW-1','GW',i18n.i18n('StateNameStub'));
-- country GY
INSERT into dem.state(code, country, name) VALUES ('GY-1','GY',i18n.i18n('StateNameStub'));
-- country HK
INSERT into dem.state(code, country, name) VALUES ('HK-1','HK',i18n.i18n('StateNameStub'));
-- country HM
INSERT into dem.state(code, country, name) VALUES ('HM-1','HM',i18n.i18n('StateNameStub'));
-- country HN
INSERT into dem.state(code, country, name) VALUES ('HN-1','HN',i18n.i18n('StateNameStub'));
-- country HR
INSERT into dem.state(code, country, name) VALUES ('BB','HR',i18n.i18n('Bjelovar-Bilogora'));
INSERT into dem.state(code, country, name) VALUES ('CZ','HR',i18n.i18n('City of Zagreb'));
INSERT into dem.state(code, country, name) VALUES ('DN','HR',i18n.i18n('Dubrovnik-Neretva'));
INSERT into dem.state(code, country, name) VALUES ('IS','HR',i18n.i18n('Istra'));
INSERT into dem.state(code, country, name) VALUES ('KA','HR',i18n.i18n('Karlovac'));
INSERT into dem.state(code, country, name) VALUES ('KK','HR',i18n.i18n('Koprivnica-Krizevci'));
INSERT into dem.state(code, country, name) VALUES ('KZ','HR',i18n.i18n('Krapina-Zagorje'));
INSERT into dem.state(code, country, name) VALUES ('LS','HR',i18n.i18n('Lika-Senj'));
INSERT into dem.state(code, country, name) VALUES ('ME','HR',i18n.i18n('Medimurje'));
INSERT into dem.state(code, country, name) VALUES ('OB','HR',i18n.i18n('Osijek-Baranja'));
INSERT into dem.state(code, country, name) VALUES ('PS','HR',i18n.i18n('Pozega-Slavonia'));
INSERT into dem.state(code, country, name) VALUES ('PG','HR',i18n.i18n('Primorje-Gorski Kotar'));
INSERT into dem.state(code, country, name) VALUES ('SI','HR',i18n.i18n('Sibenik'));
INSERT into dem.state(code, country, name) VALUES ('SM','HR',i18n.i18n('Sisak-Moslavina'));
INSERT into dem.state(code, country, name) VALUES ('SB','HR',i18n.i18n('Slavonski Brod-Posavina'));
INSERT into dem.state(code, country, name) VALUES ('SD','HR',i18n.i18n('Split-Dalmatia'));
INSERT into dem.state(code, country, name) VALUES ('VA','HR',i18n.i18n('Varazdin'));
INSERT into dem.state(code, country, name) VALUES ('VP','HR',i18n.i18n('Virovitica-Podravina'));
INSERT into dem.state(code, country, name) VALUES ('VS','HR',i18n.i18n('Vukovar-Srijem'));
INSERT into dem.state(code, country, name) VALUES ('ZK','HR',i18n.i18n('Zadar-Knin'));
INSERT into dem.state(code, country, name) VALUES ('ZA','HR',i18n.i18n('Zagreb'));
-- country HT
INSERT into dem.state(code, country, name) VALUES ('HT-1','HT',i18n.i18n('StateNameStub'));
-- country HU
INSERT into dem.state(code, country, name) VALUES ('BK','HU',i18n.i18n('Bacs-Kiskun'));
INSERT into dem.state(code, country, name) VALUES ('BA','HU',i18n.i18n('Baranya'));
INSERT into dem.state(code, country, name) VALUES ('BE','HU',i18n.i18n('Bekes'));
INSERT into dem.state(code, country, name) VALUES ('BS','HU',i18n.i18n('Bekescsaba'));
INSERT into dem.state(code, country, name) VALUES ('BZ','HU',i18n.i18n('Borsod-Abauj-Zemplen'));
INSERT into dem.state(code, country, name) VALUES ('BU','HU',i18n.i18n('Budapest'));
INSERT into dem.state(code, country, name) VALUES ('CS','HU',i18n.i18n('Csongrad'));
INSERT into dem.state(code, country, name) VALUES ('DE','HU',i18n.i18n('Debrecen'));
INSERT into dem.state(code, country, name) VALUES ('DU','HU',i18n.i18n('Dunaujvaros'));
INSERT into dem.state(code, country, name) VALUES ('EG','HU',i18n.i18n('Eger'));
INSERT into dem.state(code, country, name) VALUES ('FE','HU',i18n.i18n('Fejer'));
INSERT into dem.state(code, country, name) VALUES ('GY','HU',i18n.i18n('Gyor'));
INSERT into dem.state(code, country, name) VALUES ('GM','HU',i18n.i18n('Gyor-Moson-Sopron'));
INSERT into dem.state(code, country, name) VALUES ('HB','HU',i18n.i18n('Hajdu-Bihar'));
INSERT into dem.state(code, country, name) VALUES ('HE','HU',i18n.i18n('Heves'));
INSERT into dem.state(code, country, name) VALUES ('HO','HU',i18n.i18n('Hodmezovasarhely'));
INSERT into dem.state(code, country, name) VALUES ('JN','HU',i18n.i18n('Jasz-Nagykun-Szolnok'));
INSERT into dem.state(code, country, name) VALUES ('KA','HU',i18n.i18n('Kaposvar'));
INSERT into dem.state(code, country, name) VALUES ('KE','HU',i18n.i18n('Kecskemet'));
INSERT into dem.state(code, country, name) VALUES ('KO','HU',i18n.i18n('Komarom-Esztergom'));
INSERT into dem.state(code, country, name) VALUES ('MI','HU',i18n.i18n('Miskolc'));
INSERT into dem.state(code, country, name) VALUES ('NA','HU',i18n.i18n('Nagykanizsa'));
INSERT into dem.state(code, country, name) VALUES ('NO','HU',i18n.i18n('Nograd'));
INSERT into dem.state(code, country, name) VALUES ('NY','HU',i18n.i18n('Nyiregyhaza'));
INSERT into dem.state(code, country, name) VALUES ('PE','HU',i18n.i18n('Pecs'));
INSERT into dem.state(code, country, name) VALUES ('PS','HU',i18n.i18n('Pest'));
INSERT into dem.state(code, country, name) VALUES ('SO','HU',i18n.i18n('Somogy'));
INSERT into dem.state(code, country, name) VALUES ('SP','HU',i18n.i18n('Sopron'));
INSERT into dem.state(code, country, name) VALUES ('SS','HU',i18n.i18n('Szabolcs-Szatmar-Bereg'));
INSERT into dem.state(code, country, name) VALUES ('SZ','HU',i18n.i18n('Szeged'));
INSERT into dem.state(code, country, name) VALUES ('SE','HU',i18n.i18n('Szekesfehervar'));
INSERT into dem.state(code, country, name) VALUES ('SL','HU',i18n.i18n('Szolnok'));
INSERT into dem.state(code, country, name) VALUES ('SM','HU',i18n.i18n('Szombathely'));
INSERT into dem.state(code, country, name) VALUES ('TA','HU',i18n.i18n('Tatabanya'));
INSERT into dem.state(code, country, name) VALUES ('TO','HU',i18n.i18n('Tolna'));
INSERT into dem.state(code, country, name) VALUES ('VA','HU',i18n.i18n('Vas'));
INSERT into dem.state(code, country, name) VALUES ('VE','HU',i18n.i18n('Veszprem'));
INSERT into dem.state(code, country, name) VALUES ('ZA','HU',i18n.i18n('Zala'));
INSERT into dem.state(code, country, name) VALUES ('ZZ','HU',i18n.i18n('Zalaegerszeg'));
-- country ID
INSERT into dem.state(code, country, name) VALUES ('AC','ID',i18n.i18n('Aceh'));
INSERT into dem.state(code, country, name) VALUES ('BA','ID',i18n.i18n('Bali'));
INSERT into dem.state(code, country, name) VALUES ('BT','ID',i18n.i18n('Banten'));
INSERT into dem.state(code, country, name) VALUES ('BE','ID',i18n.i18n('Bengkulu'));
INSERT into dem.state(code, country, name) VALUES ('BD','ID',i18n.i18n('BoDeTaBek'));
INSERT into dem.state(code, country, name) VALUES ('GO','ID',i18n.i18n('Gorontalo'));
INSERT into dem.state(code, country, name) VALUES ('JK','ID',i18n.i18n('Jakarta Raya'));
INSERT into dem.state(code, country, name) VALUES ('JA','ID',i18n.i18n('Jambi'));
INSERT into dem.state(code, country, name) VALUES ('JB','ID',i18n.i18n('Jawa Barat'));
INSERT into dem.state(code, country, name) VALUES ('JT','ID',i18n.i18n('Jawa Tengah'));
INSERT into dem.state(code, country, name) VALUES ('JI','ID',i18n.i18n('Jawa Timur'));
INSERT into dem.state(code, country, name) VALUES ('KB','ID',i18n.i18n('Kalimantan Barat'));
INSERT into dem.state(code, country, name) VALUES ('KS','ID',i18n.i18n('Kalimantan Selatan'));
INSERT into dem.state(code, country, name) VALUES ('KT','ID',i18n.i18n('Kalimantan Tengah'));
INSERT into dem.state(code, country, name) VALUES ('KI','ID',i18n.i18n('Kalimantan Timur'));
INSERT into dem.state(code, country, name) VALUES ('BB','ID',i18n.i18n('Kepulauan Bangka Belitung'));
INSERT into dem.state(code, country, name) VALUES ('LA','ID',i18n.i18n('Lampung'));
INSERT into dem.state(code, country, name) VALUES ('MA','ID',i18n.i18n('Maluku'));
INSERT into dem.state(code, country, name) VALUES ('MU','ID',i18n.i18n('Maluku Utara'));
INSERT into dem.state(code, country, name) VALUES ('NB','ID',i18n.i18n('Nusa Tenggara Barat'));
INSERT into dem.state(code, country, name) VALUES ('NT','ID',i18n.i18n('Nusa Tenggara Timur'));
INSERT into dem.state(code, country, name) VALUES ('PA','ID',i18n.i18n('Papua'));
INSERT into dem.state(code, country, name) VALUES ('RI','ID',i18n.i18n('Riau'));
INSERT into dem.state(code, country, name) VALUES ('SN','ID',i18n.i18n('Sulawesi Selatan'));
INSERT into dem.state(code, country, name) VALUES ('ST','ID',i18n.i18n('Sulawesi Tengah'));
INSERT into dem.state(code, country, name) VALUES ('SG','ID',i18n.i18n('Sulawesi Tenggara'));
INSERT into dem.state(code, country, name) VALUES ('SA','ID',i18n.i18n('Sulawesi Utara'));
INSERT into dem.state(code, country, name) VALUES ('SB','ID',i18n.i18n('Sumatera Barat'));
INSERT into dem.state(code, country, name) VALUES ('SS','ID',i18n.i18n('Sumatera Selatan'));
INSERT into dem.state(code, country, name) VALUES ('SU','ID',i18n.i18n('Sumatera Utara'));
INSERT into dem.state(code, country, name) VALUES ('YO','ID',i18n.i18n('Yogyakarta'));
-- country IE
INSERT into dem.state(code, country, name) VALUES ('CA','IE',i18n.i18n('Carlow'));
INSERT into dem.state(code, country, name) VALUES ('CV','IE',i18n.i18n('Cavan'));
INSERT into dem.state(code, country, name) VALUES ('CL','IE',i18n.i18n('Clare'));
INSERT into dem.state(code, country, name) VALUES ('CO','IE',i18n.i18n('Cork'));
INSERT into dem.state(code, country, name) VALUES ('DO','IE',i18n.i18n('Donegal'));
INSERT into dem.state(code, country, name) VALUES ('DU','IE',i18n.i18n('Dublin'));
INSERT into dem.state(code, country, name) VALUES ('GA','IE',i18n.i18n('Galway'));
INSERT into dem.state(code, country, name) VALUES ('KE','IE',i18n.i18n('Kerry'));
INSERT into dem.state(code, country, name) VALUES ('KI','IE',i18n.i18n('Kildare'));
INSERT into dem.state(code, country, name) VALUES ('KL','IE',i18n.i18n('Kilkenny'));
INSERT into dem.state(code, country, name) VALUES ('LA','IE',i18n.i18n('Laois'));
INSERT into dem.state(code, country, name) VALUES ('LE','IE',i18n.i18n('Leitrim'));
INSERT into dem.state(code, country, name) VALUES ('LI','IE',i18n.i18n('Limerick'));
INSERT into dem.state(code, country, name) VALUES ('LO','IE',i18n.i18n('Longford'));
INSERT into dem.state(code, country, name) VALUES ('LU','IE',i18n.i18n('Louth'));
INSERT into dem.state(code, country, name) VALUES ('MA','IE',i18n.i18n('Mayo'));
INSERT into dem.state(code, country, name) VALUES ('ME','IE',i18n.i18n('Meath'));
INSERT into dem.state(code, country, name) VALUES ('MO','IE',i18n.i18n('Monaghan'));
INSERT into dem.state(code, country, name) VALUES ('OF','IE',i18n.i18n('Offaly'));
INSERT into dem.state(code, country, name) VALUES ('RO','IE',i18n.i18n('Roscommon'));
INSERT into dem.state(code, country, name) VALUES ('SL','IE',i18n.i18n('Sligo'));
INSERT into dem.state(code, country, name) VALUES ('TI','IE',i18n.i18n('Tipperary'));
INSERT into dem.state(code, country, name) VALUES ('WA','IE',i18n.i18n('Waterford'));
INSERT into dem.state(code, country, name) VALUES ('WE','IE',i18n.i18n('Westmeath'));
INSERT into dem.state(code, country, name) VALUES ('WX','IE',i18n.i18n('Wexford'));
INSERT into dem.state(code, country, name) VALUES ('WI','IE',i18n.i18n('Wicklow'));
-- country IL
INSERT into dem.state(code, country, name) VALUES ('BS','IL',i18n.i18n('Be''er Sheva'));
INSERT into dem.state(code, country, name) VALUES ('BH','IL',i18n.i18n('Bika''at Hayarden'));
INSERT into dem.state(code, country, name) VALUES ('EA','IL',i18n.i18n('Eilat and Arava'));
INSERT into dem.state(code, country, name) VALUES ('GA','IL',i18n.i18n('Galil'));
INSERT into dem.state(code, country, name) VALUES ('HA','IL',i18n.i18n('Haifa'));
INSERT into dem.state(code, country, name) VALUES ('JM','IL',i18n.i18n('Jehuda Mountains'));
INSERT into dem.state(code, country, name) VALUES ('JE','IL',i18n.i18n('Jerusalem'));
INSERT into dem.state(code, country, name) VALUES ('NE','IL',i18n.i18n('Negev'));
INSERT into dem.state(code, country, name) VALUES ('SE','IL',i18n.i18n('Semaria'));
INSERT into dem.state(code, country, name) VALUES ('SH','IL',i18n.i18n('Sharon'));
INSERT into dem.state(code, country, name) VALUES ('TA','IL',i18n.i18n('Tel Aviv (Gosh Dan)'));
-- country IN
INSERT into dem.state(code, country, name) VALUES ('AN','IN',i18n.i18n('Andaman and Nicobar Islands'));
INSERT into dem.state(code, country, name) VALUES ('AP','IN',i18n.i18n('Andhra Pradesh'));
INSERT into dem.state(code, country, name) VALUES ('AR','IN',i18n.i18n('Arunachal Pradesh'));
INSERT into dem.state(code, country, name) VALUES ('AS','IN',i18n.i18n('Assam'));
INSERT into dem.state(code, country, name) VALUES ('BI','IN',i18n.i18n('Bihar'));
INSERT into dem.state(code, country, name) VALUES ('CH','IN',i18n.i18n('Chandigarh'));
INSERT into dem.state(code, country, name) VALUES ('DA','IN',i18n.i18n('Dadra and Nagar Haveli'));
INSERT into dem.state(code, country, name) VALUES ('DM','IN',i18n.i18n('Daman and Diu'));
INSERT into dem.state(code, country, name) VALUES ('DE','IN',i18n.i18n('Delhi'));
INSERT into dem.state(code, country, name) VALUES ('GO','IN',i18n.i18n('Goa'));
INSERT into dem.state(code, country, name) VALUES ('GU','IN',i18n.i18n('Gujarat'));
INSERT into dem.state(code, country, name) VALUES ('HA','IN',i18n.i18n('Haryana'));
INSERT into dem.state(code, country, name) VALUES ('HP','IN',i18n.i18n('Himachal Pradesh'));
INSERT into dem.state(code, country, name) VALUES ('JA','IN',i18n.i18n('Jammu and Kashmir'));
INSERT into dem.state(code, country, name) VALUES ('KA','IN',i18n.i18n('Karnataka'));
INSERT into dem.state(code, country, name) VALUES ('KE','IN',i18n.i18n('Kerala'));
INSERT into dem.state(code, country, name) VALUES ('LI','IN',i18n.i18n('Lakshadweep Islands'));
INSERT into dem.state(code, country, name) VALUES ('MP','IN',i18n.i18n('Madhya Pradesh'));
INSERT into dem.state(code, country, name) VALUES ('MA','IN',i18n.i18n('Maharashtra'));
INSERT into dem.state(code, country, name) VALUES ('MN','IN',i18n.i18n('Manipur'));
INSERT into dem.state(code, country, name) VALUES ('ME','IN',i18n.i18n('Meghalaya'));
INSERT into dem.state(code, country, name) VALUES ('MI','IN',i18n.i18n('Mizoram'));
INSERT into dem.state(code, country, name) VALUES ('NA','IN',i18n.i18n('Nagaland'));
INSERT into dem.state(code, country, name) VALUES ('OR','IN',i18n.i18n('Orissa'));
INSERT into dem.state(code, country, name) VALUES ('PO','IN',i18n.i18n('Pondicherry'));
INSERT into dem.state(code, country, name) VALUES ('PU','IN',i18n.i18n('Punjab'));
INSERT into dem.state(code, country, name) VALUES ('RA','IN',i18n.i18n('Rajasthan'));
INSERT into dem.state(code, country, name) VALUES ('SI','IN',i18n.i18n('Sikkim'));
INSERT into dem.state(code, country, name) VALUES ('TN','IN',i18n.i18n('Tamil Nadu'));
INSERT into dem.state(code, country, name) VALUES ('TR','IN',i18n.i18n('Tripura'));
INSERT into dem.state(code, country, name) VALUES ('UP','IN',i18n.i18n('Uttar Pradesh'));
INSERT into dem.state(code, country, name) VALUES ('WB','IN',i18n.i18n('West Bengal'));
-- country IO
INSERT into dem.state(code, country, name) VALUES ('IO-1','IO',i18n.i18n('StateNameStub'));
-- country IQ
INSERT into dem.state(code, country, name) VALUES ('IQ-1','IQ',i18n.i18n('StateNameStub'));
-- country IR
INSERT into dem.state(code, country, name) VALUES ('IR-1','IR',i18n.i18n('StateNameStub'));
-- country IS
INSERT into dem.state(code, country, name) VALUES ('IS-1','IS',i18n.i18n('StateNameStub'));
-- country IT
INSERT into dem.state(code, country, name) VALUES ('AB','IT',i18n.i18n('Abruzzo'));
INSERT into dem.state(code, country, name) VALUES ('BA','IT',i18n.i18n('Basilicata'));
INSERT into dem.state(code, country, name) VALUES ('CA','IT',i18n.i18n('Calabria'));
INSERT into dem.state(code, country, name) VALUES ('CP','IT',i18n.i18n('Campania'));
INSERT into dem.state(code, country, name) VALUES ('ER','IT',i18n.i18n('Emilia Romagna'));
INSERT into dem.state(code, country, name) VALUES ('FV','IT',i18n.i18n('Friuli-Venezia Giulia'));
INSERT into dem.state(code, country, name) VALUES ('LA','IT',i18n.i18n('Lazio (Latium & Rome)'));
INSERT into dem.state(code, country, name) VALUES ('TM','IT',i18n.i18n('Le Marche (The Marches)'));
INSERT into dem.state(code, country, name) VALUES ('LI','IT',i18n.i18n('Liguria'));
INSERT into dem.state(code, country, name) VALUES ('LO','IT',i18n.i18n('Lombardia (Lombardy)'));
INSERT into dem.state(code, country, name) VALUES ('MO','IT',i18n.i18n('Molise'));
INSERT into dem.state(code, country, name) VALUES ('PI','IT',i18n.i18n('Piemonte (Piedmont)'));
INSERT into dem.state(code, country, name) VALUES ('AP','IT',i18n.i18n('Puglia (Apulia)'));
INSERT into dem.state(code, country, name) VALUES ('SA','IT',i18n.i18n('Sardegna (Sardinia)'));
INSERT into dem.state(code, country, name) VALUES ('SI','IT',i18n.i18n('Sicilia (Sicily)'));
INSERT into dem.state(code, country, name) VALUES ('TU','IT',i18n.i18n('Toscana (Tuscany)'));
INSERT into dem.state(code, country, name) VALUES ('TR','IT',i18n.i18n('Trentino Alto Adige'));
INSERT into dem.state(code, country, name) VALUES ('UM','IT',i18n.i18n('Umbria'));
INSERT into dem.state(code, country, name) VALUES ('VA','IT',i18n.i18n('Val d''Aosta'));
INSERT into dem.state(code, country, name) VALUES ('VE','IT',i18n.i18n('Veneto'));
-- country JM
INSERT into dem.state(code, country, name) VALUES ('JM-1','JM',i18n.i18n('StateNameStub'));
-- country JO
INSERT into dem.state(code, country, name) VALUES ('AM','JO',i18n.i18n('Amman'));
INSERT into dem.state(code, country, name) VALUES ('AJ','JO',i18n.i18n('Ajlun'));
INSERT into dem.state(code, country, name) VALUES ('AA','JO',i18n.i18n('Al ''Aqabah'));
INSERT into dem.state(code, country, name) VALUES ('AB','JO',i18n.i18n('Al Balqa'''));
INSERT into dem.state(code, country, name) VALUES ('AK','JO',i18n.i18n('Al Karak'));
INSERT into dem.state(code, country, name) VALUES ('AL','JO',i18n.i18n('Al Mafraq'));
INSERT into dem.state(code, country, name) VALUES ('AT','JO',i18n.i18n('At Tafilah'));
INSERT into dem.state(code, country, name) VALUES ('AZ','JO',i18n.i18n('Az Zarqa'''));
INSERT into dem.state(code, country, name) VALUES ('IR','JO',i18n.i18n('Irbid'));
INSERT into dem.state(code, country, name) VALUES ('JA','JO',i18n.i18n('Jarash'));
INSERT into dem.state(code, country, name) VALUES ('MA','JO',i18n.i18n('Ma''an'));
INSERT into dem.state(code, country, name) VALUES ('MD','JO',i18n.i18n('Madaba'));
-- country JP
INSERT into dem.state(code, country, name) VALUES ('AI','JP',i18n.i18n('Aichi'));
INSERT into dem.state(code, country, name) VALUES ('AK','JP',i18n.i18n('Akita'));
INSERT into dem.state(code, country, name) VALUES ('AO','JP',i18n.i18n('Aomori'));
INSERT into dem.state(code, country, name) VALUES ('CH','JP',i18n.i18n('Chiba'));
INSERT into dem.state(code, country, name) VALUES ('EH','JP',i18n.i18n('Ehime'));
INSERT into dem.state(code, country, name) VALUES ('FK','JP',i18n.i18n('Fukui'));
INSERT into dem.state(code, country, name) VALUES ('FU','JP',i18n.i18n('Fukuoka'));
INSERT into dem.state(code, country, name) VALUES ('FS','JP',i18n.i18n('Fukushima'));
INSERT into dem.state(code, country, name) VALUES ('GI','JP',i18n.i18n('Gifu'));
INSERT into dem.state(code, country, name) VALUES ('GU','JP',i18n.i18n('Gumma'));
INSERT into dem.state(code, country, name) VALUES ('HI','JP',i18n.i18n('Hiroshima'));
INSERT into dem.state(code, country, name) VALUES ('HO','JP',i18n.i18n('Hokkaido'));
INSERT into dem.state(code, country, name) VALUES ('HY','JP',i18n.i18n('Hyogo'));
INSERT into dem.state(code, country, name) VALUES ('IB','JP',i18n.i18n('Ibaraki'));
INSERT into dem.state(code, country, name) VALUES ('IS','JP',i18n.i18n('Ishikawa'));
INSERT into dem.state(code, country, name) VALUES ('IW','JP',i18n.i18n('Iwate'));
INSERT into dem.state(code, country, name) VALUES ('KA','JP',i18n.i18n('Kagawa'));
INSERT into dem.state(code, country, name) VALUES ('KG','JP',i18n.i18n('Kagoshima'));
INSERT into dem.state(code, country, name) VALUES ('KN','JP',i18n.i18n('Kanagawa'));
INSERT into dem.state(code, country, name) VALUES ('KO','JP',i18n.i18n('Kochi'));
INSERT into dem.state(code, country, name) VALUES ('KU','JP',i18n.i18n('Kumamoto'));
INSERT into dem.state(code, country, name) VALUES ('KY','JP',i18n.i18n('Kyoto'));
INSERT into dem.state(code, country, name) VALUES ('MI','JP',i18n.i18n('Mie'));
INSERT into dem.state(code, country, name) VALUES ('MY','JP',i18n.i18n('Miyagi'));
INSERT into dem.state(code, country, name) VALUES ('MZ','JP',i18n.i18n('Miyazaki'));
INSERT into dem.state(code, country, name) VALUES ('NA','JP',i18n.i18n('Nagano'));
INSERT into dem.state(code, country, name) VALUES ('NG','JP',i18n.i18n('Nagasaki'));
INSERT into dem.state(code, country, name) VALUES ('NR','JP',i18n.i18n('Nara'));
INSERT into dem.state(code, country, name) VALUES ('NI','JP',i18n.i18n('Niigata'));
INSERT into dem.state(code, country, name) VALUES ('OI','JP',i18n.i18n('Oita'));
INSERT into dem.state(code, country, name) VALUES ('OK','JP',i18n.i18n('Okayama'));
INSERT into dem.state(code, country, name) VALUES ('ON','JP',i18n.i18n('Okinawa'));
INSERT into dem.state(code, country, name) VALUES ('OS','JP',i18n.i18n('Osaka'));
INSERT into dem.state(code, country, name) VALUES ('SA','JP',i18n.i18n('Saga'));
INSERT into dem.state(code, country, name) VALUES ('SI','JP',i18n.i18n('Saitama'));
INSERT into dem.state(code, country, name) VALUES ('SH','JP',i18n.i18n('Shiga'));
INSERT into dem.state(code, country, name) VALUES ('SM','JP',i18n.i18n('Shimane'));
INSERT into dem.state(code, country, name) VALUES ('SZ','JP',i18n.i18n('Shizuoka'));
INSERT into dem.state(code, country, name) VALUES ('TO','JP',i18n.i18n('Tochigi'));
INSERT into dem.state(code, country, name) VALUES ('TS','JP',i18n.i18n('Tokushima'));
INSERT into dem.state(code, country, name) VALUES ('TK','JP',i18n.i18n('Tokyo'));
INSERT into dem.state(code, country, name) VALUES ('TT','JP',i18n.i18n('Tottori'));
INSERT into dem.state(code, country, name) VALUES ('TY','JP',i18n.i18n('Toyama'));
INSERT into dem.state(code, country, name) VALUES ('WA','JP',i18n.i18n('Wakayama'));
INSERT into dem.state(code, country, name) VALUES ('YA','JP',i18n.i18n('Yamagata'));
INSERT into dem.state(code, country, name) VALUES ('YM','JP',i18n.i18n('Yamaguchi'));
INSERT into dem.state(code, country, name) VALUES ('YN','JP',i18n.i18n('Yamanashi'));
-- country KE
INSERT into dem.state(code, country, name) VALUES ('CE','KE',i18n.i18n('Central'));
INSERT into dem.state(code, country, name) VALUES ('CO','KE',i18n.i18n('Coast'));
INSERT into dem.state(code, country, name) VALUES ('EA','KE',i18n.i18n('Eastern'));
INSERT into dem.state(code, country, name) VALUES ('NA','KE',i18n.i18n('Nairobi Area'));
INSERT into dem.state(code, country, name) VALUES ('NE','KE',i18n.i18n('North Eastern'));
INSERT into dem.state(code, country, name) VALUES ('NY','KE',i18n.i18n('Nyanza'));
INSERT into dem.state(code, country, name) VALUES ('RV','KE',i18n.i18n('Rift Valley'));
INSERT into dem.state(code, country, name) VALUES ('WE','KE',i18n.i18n('Western'));
-- country KG
INSERT into dem.state(code, country, name) VALUES ('KG-1','KG',i18n.i18n('StateNameStub'));
-- country KH
INSERT into dem.state(code, country, name) VALUES ('KH-1','KH',i18n.i18n('StateNameStub'));
-- country KI
INSERT into dem.state(code, country, name) VALUES ('KI-1','KI',i18n.i18n('StateNameStub'));
-- country KM
INSERT into dem.state(code, country, name) VALUES ('KM-1','KM',i18n.i18n('StateNameStub'));
-- country KN
INSERT into dem.state(code, country, name) VALUES ('KN-1','KN',i18n.i18n('StateNameStub'));
-- country KP
INSERT into dem.state(code, country, name) VALUES ('KP-1','KP',i18n.i18n('StateNameStub'));
-- country KR
INSERT into dem.state(code, country, name) VALUES ('CO','KR',i18n.i18n('Ch''ungch|ong-bukto'));
INSERT into dem.state(code, country, name) VALUES ('CH','KR',i18n.i18n('Ch''ungch|ong-namdo'));
INSERT into dem.state(code, country, name) VALUES ('CD','KR',i18n.i18n('Cheju-do'));
INSERT into dem.state(code, country, name) VALUES ('CB','KR',i18n.i18n('Cholla-bukto'));
INSERT into dem.state(code, country, name) VALUES ('CN','KR',i18n.i18n('Cholla-namdo'));
INSERT into dem.state(code, country, name) VALUES ('IG','KR',i18n.i18n('Inch''on-gwangyoksi'));
INSERT into dem.state(code, country, name) VALUES ('KA','KR',i18n.i18n('Kangwon-do'));
INSERT into dem.state(code, country, name) VALUES ('KG','KR',i18n.i18n('Kwangju-gwangyoksi'));
INSERT into dem.state(code, country, name) VALUES ('KD','KR',i18n.i18n('Kyonggi-do'));
INSERT into dem.state(code, country, name) VALUES ('KB','KR',i18n.i18n('Kyongsang-bukto'));
INSERT into dem.state(code, country, name) VALUES ('KN','KR',i18n.i18n('Kyongsang-namdo'));
INSERT into dem.state(code, country, name) VALUES ('PG','KR',i18n.i18n('Pusan-gwangyoksi'));
INSERT into dem.state(code, country, name) VALUES ('SO','KR',i18n.i18n('Soul-t''ukpyolsi'));
INSERT into dem.state(code, country, name) VALUES ('TA','KR',i18n.i18n('Taegu-gwangyoksi'));
INSERT into dem.state(code, country, name) VALUES ('TG','KR',i18n.i18n('Taejon-gwangyoksi'));
-- country KW
INSERT into dem.state(code, country, name) VALUES ('AL','KW',i18n.i18n('Al ''Asimah'));
INSERT into dem.state(code, country, name) VALUES ('AA','KW',i18n.i18n('Al Ahmadi'));
INSERT into dem.state(code, country, name) VALUES ('AF','KW',i18n.i18n('Al Farwaniyah'));
INSERT into dem.state(code, country, name) VALUES ('AJ','KW',i18n.i18n('Al Jahra'''));
INSERT into dem.state(code, country, name) VALUES ('HA','KW',i18n.i18n('Hawalli'));
-- country KY
INSERT into dem.state(code, country, name) VALUES ('KY-1','KY',i18n.i18n('StateNameStub'));
-- country KZ
INSERT into dem.state(code, country, name) VALUES ('AL','KZ',i18n.i18n('Almaty'));
INSERT into dem.state(code, country, name) VALUES ('AC','KZ',i18n.i18n('Almaty City'));
INSERT into dem.state(code, country, name) VALUES ('AM','KZ',i18n.i18n('Aqmola'));
INSERT into dem.state(code, country, name) VALUES ('AQ','KZ',i18n.i18n('Aqtobe'));
INSERT into dem.state(code, country, name) VALUES ('AS','KZ',i18n.i18n('Astana City'));
INSERT into dem.state(code, country, name) VALUES ('AT','KZ',i18n.i18n('Atyrau'));
INSERT into dem.state(code, country, name) VALUES ('BA','KZ',i18n.i18n('Batys Qazaqstan'));
INSERT into dem.state(code, country, name) VALUES ('BY','KZ',i18n.i18n('Bayqongyr City'));
INSERT into dem.state(code, country, name) VALUES ('MA','KZ',i18n.i18n('Mangghystau'));
INSERT into dem.state(code, country, name) VALUES ('ON','KZ',i18n.i18n('Ongtustik Qazaqstan'));
INSERT into dem.state(code, country, name) VALUES ('PA','KZ',i18n.i18n('Pavlodar'));
INSERT into dem.state(code, country, name) VALUES ('QA','KZ',i18n.i18n('Qaraghandy'));
INSERT into dem.state(code, country, name) VALUES ('QO','KZ',i18n.i18n('Qostanay'));
INSERT into dem.state(code, country, name) VALUES ('QY','KZ',i18n.i18n('Qyzylorda'));
INSERT into dem.state(code, country, name) VALUES ('SH','KZ',i18n.i18n('Shyghys Qazaqstan'));
INSERT into dem.state(code, country, name) VALUES ('SO','KZ',i18n.i18n('Soltustik Qazaqstan'));
INSERT into dem.state(code, country, name) VALUES ('ZH','KZ',i18n.i18n('Zhambyl'));
-- country LA
INSERT into dem.state(code, country, name) VALUES ('LA-1','LA',i18n.i18n('StateNameStub'));
-- country LB
INSERT into dem.state(code, country, name) VALUES ('LB-1','LB',i18n.i18n('StateNameStub'));
-- country LC
INSERT into dem.state(code, country, name) VALUES ('LC-1','LC',i18n.i18n('StateNameStub'));
-- country LI
INSERT into dem.state(code, country, name) VALUES ('LI-1','LI',i18n.i18n('StateNameStub'));
-- country LK
INSERT into dem.state(code, country, name) VALUES ('CE','LK',i18n.i18n('Central'));
INSERT into dem.state(code, country, name) VALUES ('NC','LK',i18n.i18n('North Central'));
INSERT into dem.state(code, country, name) VALUES ('NE','LK',i18n.i18n('North Eastern'));
INSERT into dem.state(code, country, name) VALUES ('NW','LK',i18n.i18n('North Western'));
INSERT into dem.state(code, country, name) VALUES ('SA','LK',i18n.i18n('Sabaragamuwa'));
INSERT into dem.state(code, country, name) VALUES ('SO','LK',i18n.i18n('Southern'));
INSERT into dem.state(code, country, name) VALUES ('UV','LK',i18n.i18n('Uva'));
INSERT into dem.state(code, country, name) VALUES ('WE','LK',i18n.i18n('Western'));
-- country LR
INSERT into dem.state(code, country, name) VALUES ('LR-1','LR',i18n.i18n('StateNameStub'));
-- country LS
INSERT into dem.state(code, country, name) VALUES ('LS-1','LS',i18n.i18n('StateNameStub'));
-- country LT
INSERT into dem.state(code, country, name) VALUES ('LT-1','LT',i18n.i18n('StateNameStub'));
-- country LU
INSERT into dem.state(code, country, name) VALUES ('DI','LU',i18n.i18n('Diekirch'));
INSERT into dem.state(code, country, name) VALUES ('GR','LU',i18n.i18n('Grevenmacher'));
INSERT into dem.state(code, country, name) VALUES ('LU','LU',i18n.i18n('Luxembourg'));
-- country LV
INSERT into dem.state(code, country, name) VALUES ('LV-1','LV',i18n.i18n('StateNameStub'));
-- country LY
INSERT into dem.state(code, country, name) VALUES ('LY-1','LY',i18n.i18n('StateNameStub'));
-- country MA
INSERT into dem.state(code, country, name) VALUES ('MA-1','MA',i18n.i18n('StateNameStub'));
-- country MC
INSERT into dem.state(code, country, name) VALUES ('MC-1','MC',i18n.i18n('StateNameStub'));
-- country MD
INSERT into dem.state(code, country, name) VALUES ('MD-1','MD',i18n.i18n('StateNameStub'));
-- country MG
INSERT into dem.state(code, country, name) VALUES ('MG-1','MG',i18n.i18n('StateNameStub'));
-- country MH
INSERT into dem.state(code, country, name) VALUES ('MH-1','MH',i18n.i18n('StateNameStub'));
-- country MK
INSERT into dem.state(code, country, name) VALUES ('MK-1','MK',i18n.i18n('StateNameStub'));
-- country ML
INSERT into dem.state(code, country, name) VALUES ('ML-1','ML',i18n.i18n('StateNameStub'));
-- country MM
INSERT into dem.state(code, country, name) VALUES ('MM-1','MM',i18n.i18n('StateNameStub'));
-- country MN
INSERT into dem.state(code, country, name) VALUES ('MN-1','MN',i18n.i18n('StateNameStub'));
-- country MO
INSERT into dem.state(code, country, name) VALUES ('MO-1','MO',i18n.i18n('StateNameStub'));
-- country MP
INSERT into dem.state(code, country, name) VALUES ('MP-1','MP',i18n.i18n('StateNameStub'));
-- country MQ
INSERT into dem.state(code, country, name) VALUES ('MQ-1','MQ',i18n.i18n('StateNameStub'));
-- country MR
INSERT into dem.state(code, country, name) VALUES ('MR-1','MR',i18n.i18n('StateNameStub'));
-- country MS
INSERT into dem.state(code, country, name) VALUES ('MS-1','MS',i18n.i18n('StateNameStub'));
-- country MT
INSERT into dem.state(code, country, name) VALUES ('MT-1','MT',i18n.i18n('StateNameStub'));
-- country MU
INSERT into dem.state(code, country, name) VALUES ('MU-1','MU',i18n.i18n('StateNameStub'));
-- country MV
INSERT into dem.state(code, country, name) VALUES ('MV-1','MV',i18n.i18n('StateNameStub'));
-- country MW
INSERT into dem.state(code, country, name) VALUES ('MW-1','MW',i18n.i18n('StateNameStub'));
-- country MX
INSERT into dem.state(code, country, name) VALUES ('BC','MX',i18n.i18n('Baja California'));
INSERT into dem.state(code, country, name) VALUES ('BS','MX',i18n.i18n('Baja California Sur'));
INSERT into dem.state(code, country, name) VALUES ('CA','MX',i18n.i18n('Campeche'));
INSERT into dem.state(code, country, name) VALUES ('CI','MX',i18n.i18n('Chiapas'));
INSERT into dem.state(code, country, name) VALUES ('CH','MX',i18n.i18n('Chihuahua'));
INSERT into dem.state(code, country, name) VALUES ('CZ','MX',i18n.i18n('Coahuila de Zaragoza'));
INSERT into dem.state(code, country, name) VALUES ('CL','MX',i18n.i18n('Colima'));
INSERT into dem.state(code, country, name) VALUES ('DF','MX',i18n.i18n('Distrito Federal'));
INSERT into dem.state(code, country, name) VALUES ('DU','MX',i18n.i18n('Durango'));
INSERT into dem.state(code, country, name) VALUES ('GA','MX',i18n.i18n('Guanajuato'));
INSERT into dem.state(code, country, name) VALUES ('GE','MX',i18n.i18n('Guerrero'));
INSERT into dem.state(code, country, name) VALUES ('HI','MX',i18n.i18n('Hidalgo'));
INSERT into dem.state(code, country, name) VALUES ('JA','MX',i18n.i18n('Jalisco'));
INSERT into dem.state(code, country, name) VALUES ('ME','MX',i18n.i18n('Mexico'));
INSERT into dem.state(code, country, name) VALUES ('MI','MX',i18n.i18n('Michoacan de Ocampo'));
INSERT into dem.state(code, country, name) VALUES ('MO','MX',i18n.i18n('Morelos'));
INSERT into dem.state(code, country, name) VALUES ('NA','MX',i18n.i18n('Nayarit'));
INSERT into dem.state(code, country, name) VALUES ('NL','MX',i18n.i18n('Nuevo Leon'));
INSERT into dem.state(code, country, name) VALUES ('OA','MX',i18n.i18n('Oaxaca'));
INSERT into dem.state(code, country, name) VALUES ('PU','MX',i18n.i18n('Puebla'));
INSERT into dem.state(code, country, name) VALUES ('QA','MX',i18n.i18n('Queretaro de Arteaga'));
INSERT into dem.state(code, country, name) VALUES ('QR','MX',i18n.i18n('Quintana Roo'));
INSERT into dem.state(code, country, name) VALUES ('SA','MX',i18n.i18n('San Luis Potosi'));
INSERT into dem.state(code, country, name) VALUES ('SI','MX',i18n.i18n('Sinaloa'));
INSERT into dem.state(code, country, name) VALUES ('SO','MX',i18n.i18n('Sonora'));
INSERT into dem.state(code, country, name) VALUES ('TB','MX',i18n.i18n('Tabasco'));
INSERT into dem.state(code, country, name) VALUES ('TM','MX',i18n.i18n('Tamaulipas'));
INSERT into dem.state(code, country, name) VALUES ('TL','MX',i18n.i18n('Tlaxcala'));
INSERT into dem.state(code, country, name) VALUES ('VE','MX',i18n.i18n('Veracruz-Llave'));
INSERT into dem.state(code, country, name) VALUES ('YU','MX',i18n.i18n('Yucatan'));
INSERT into dem.state(code, country, name) VALUES ('ZA','MX',i18n.i18n('Zacatecas'));
-- country MY
INSERT into dem.state(code, country, name) VALUES ('JO','MY',i18n.i18n('Johor'));
INSERT into dem.state(code, country, name) VALUES ('KE','MY',i18n.i18n('Kedah'));
INSERT into dem.state(code, country, name) VALUES ('KL','MY',i18n.i18n('Kelantan'));
INSERT into dem.state(code, country, name) VALUES ('LA','MY',i18n.i18n('Labuan'));
INSERT into dem.state(code, country, name) VALUES ('ME','MY',i18n.i18n('Melaka'));
INSERT into dem.state(code, country, name) VALUES ('NS','MY',i18n.i18n('Negeri Sembilan'));
INSERT into dem.state(code, country, name) VALUES ('PA','MY',i18n.i18n('Pahang'));
INSERT into dem.state(code, country, name) VALUES ('PE','MY',i18n.i18n('Perak'));
INSERT into dem.state(code, country, name) VALUES ('PR','MY',i18n.i18n('Perlis'));
INSERT into dem.state(code, country, name) VALUES ('PP','MY',i18n.i18n('Pulau Pinang'));
INSERT into dem.state(code, country, name) VALUES ('SA','MY',i18n.i18n('Sabah'));
INSERT into dem.state(code, country, name) VALUES ('SR','MY',i18n.i18n('Sarawak'));
INSERT into dem.state(code, country, name) VALUES ('SE','MY',i18n.i18n('Selangor'));
INSERT into dem.state(code, country, name) VALUES ('TE','MY',i18n.i18n('Terengganu'));
INSERT into dem.state(code, country, name) VALUES ('WP','MY',i18n.i18n('Wilayah Persekutuan'));
-- country MZ
INSERT into dem.state(code, country, name) VALUES ('MZ-1','MZ',i18n.i18n('StateNameStub'));
-- country NA
INSERT into dem.state(code, country, name) VALUES ('NA-1','NA',i18n.i18n('StateNameStub'));
-- country NC
INSERT into dem.state(code, country, name) VALUES ('NC-1','NC',i18n.i18n('StateNameStub'));
-- country NE
INSERT into dem.state(code, country, name) VALUES ('AG','NE',i18n.i18n('Agadez'));
INSERT into dem.state(code, country, name) VALUES ('DI','NE',i18n.i18n('Diffa'));
INSERT into dem.state(code, country, name) VALUES ('DO','NE',i18n.i18n('Dosso'));
INSERT into dem.state(code, country, name) VALUES ('MA','NE',i18n.i18n('Maradi'));
INSERT into dem.state(code, country, name) VALUES ('NI','NE',i18n.i18n('Niamey'));
INSERT into dem.state(code, country, name) VALUES ('TA','NE',i18n.i18n('Tahoua'));
INSERT into dem.state(code, country, name) VALUES ('TI','NE',i18n.i18n('Tillaberi'));
INSERT into dem.state(code, country, name) VALUES ('ZI','NE',i18n.i18n('Zinder'));
-- country NF
INSERT into dem.state(code, country, name) VALUES ('NF-1','NF',i18n.i18n('StateNameStub'));
-- country NG
INSERT into dem.state(code, country, name) VALUES ('AB','NG',i18n.i18n('Abia'));
INSERT into dem.state(code, country, name) VALUES ('FC','NG',i18n.i18n('Abuja Federal Capital Territory'));
INSERT into dem.state(code, country, name) VALUES ('AD','NG',i18n.i18n('Adamawa'));
INSERT into dem.state(code, country, name) VALUES ('AI','NG',i18n.i18n('Akwa Ibom'));
INSERT into dem.state(code, country, name) VALUES ('AN','NG',i18n.i18n('Anambra'));
INSERT into dem.state(code, country, name) VALUES ('BA','NG',i18n.i18n('Bauchi'));
INSERT into dem.state(code, country, name) VALUES ('BY','NG',i18n.i18n('Bayelsa'));
INSERT into dem.state(code, country, name) VALUES ('BE','NG',i18n.i18n('Benue'));
INSERT into dem.state(code, country, name) VALUES ('BO','NG',i18n.i18n('Borno'));
INSERT into dem.state(code, country, name) VALUES ('CR','NG',i18n.i18n('Cross River'));
INSERT into dem.state(code, country, name) VALUES ('DE','NG',i18n.i18n('Delta'));
INSERT into dem.state(code, country, name) VALUES ('EB','NG',i18n.i18n('Ebonyi'));
INSERT into dem.state(code, country, name) VALUES ('ED','NG',i18n.i18n('Edo'));
INSERT into dem.state(code, country, name) VALUES ('EK','NG',i18n.i18n('Ekiti'));
INSERT into dem.state(code, country, name) VALUES ('EN','NG',i18n.i18n('Enugu'));
INSERT into dem.state(code, country, name) VALUES ('GO','NG',i18n.i18n('Gombe'));
INSERT into dem.state(code, country, name) VALUES ('IM','NG',i18n.i18n('Imo'));
INSERT into dem.state(code, country, name) VALUES ('JI','NG',i18n.i18n('Jigawa'));
INSERT into dem.state(code, country, name) VALUES ('KA','NG',i18n.i18n('Kaduna'));
INSERT into dem.state(code, country, name) VALUES ('KN','NG',i18n.i18n('Kano'));
INSERT into dem.state(code, country, name) VALUES ('KT','NG',i18n.i18n('Katsina'));
INSERT into dem.state(code, country, name) VALUES ('KE','NG',i18n.i18n('Kebbi'));
INSERT into dem.state(code, country, name) VALUES ('KO','NG',i18n.i18n('Kogi'));
INSERT into dem.state(code, country, name) VALUES ('KW','NG',i18n.i18n('Kwara'));
INSERT into dem.state(code, country, name) VALUES ('LA','NG',i18n.i18n('Lagos'));
INSERT into dem.state(code, country, name) VALUES ('NA','NG',i18n.i18n('Nassarawa'));
INSERT into dem.state(code, country, name) VALUES ('NI','NG',i18n.i18n('Niger'));
INSERT into dem.state(code, country, name) VALUES ('OG','NG',i18n.i18n('Ogun'));
INSERT into dem.state(code, country, name) VALUES ('ON','NG',i18n.i18n('Ondo'));
INSERT into dem.state(code, country, name) VALUES ('OS','NG',i18n.i18n('Osun'));
INSERT into dem.state(code, country, name) VALUES ('OY','NG',i18n.i18n('Oyo'));
INSERT into dem.state(code, country, name) VALUES ('PL','NG',i18n.i18n('Plateau'));
INSERT into dem.state(code, country, name) VALUES ('RI','NG',i18n.i18n('Rivers'));
INSERT into dem.state(code, country, name) VALUES ('SO','NG',i18n.i18n('Sokoto'));
INSERT into dem.state(code, country, name) VALUES ('TA','NG',i18n.i18n('Taraba'));
INSERT into dem.state(code, country, name) VALUES ('YO','NG',i18n.i18n('Yobe'));
INSERT into dem.state(code, country, name) VALUES ('ZA','NG',i18n.i18n('Zamfara'));
-- country NI
INSERT into dem.state(code, country, name) VALUES ('AN','NI',i18n.i18n('Atlantico Norte'));
INSERT into dem.state(code, country, name) VALUES ('AS','NI',i18n.i18n('Atlantico Sur'));
INSERT into dem.state(code, country, name) VALUES ('BO','NI',i18n.i18n('Boaco'));
INSERT into dem.state(code, country, name) VALUES ('CA','NI',i18n.i18n('Carazo'));
INSERT into dem.state(code, country, name) VALUES ('CI','NI',i18n.i18n('Chinandega'));
INSERT into dem.state(code, country, name) VALUES ('CO','NI',i18n.i18n('Chontales'));
INSERT into dem.state(code, country, name) VALUES ('ES','NI',i18n.i18n('Esteli'));
INSERT into dem.state(code, country, name) VALUES ('GR','NI',i18n.i18n('Granada'));
INSERT into dem.state(code, country, name) VALUES ('JI','NI',i18n.i18n('Jinotega'));
INSERT into dem.state(code, country, name) VALUES ('LE','NI',i18n.i18n('Leon'));
INSERT into dem.state(code, country, name) VALUES ('MD','NI',i18n.i18n('Madriz'));
INSERT into dem.state(code, country, name) VALUES ('MN','NI',i18n.i18n('Managua'));
INSERT into dem.state(code, country, name) VALUES ('MS','NI',i18n.i18n('Masaya'));
INSERT into dem.state(code, country, name) VALUES ('MT','NI',i18n.i18n('Matagalpa'));
INSERT into dem.state(code, country, name) VALUES ('NS','NI',i18n.i18n('Nuevo Segovia'));
INSERT into dem.state(code, country, name) VALUES ('RS','NI',i18n.i18n('Rio San Juan'));
INSERT into dem.state(code, country, name) VALUES ('RI','NI',i18n.i18n('Rivas'));
-- country NL
INSERT into dem.state(code, country, name) VALUES ('DR','NL',i18n.i18n('Drente'));
INSERT into dem.state(code, country, name) VALUES ('FL','NL',i18n.i18n('Flevoland'));
INSERT into dem.state(code, country, name) VALUES ('FR','NL',i18n.i18n('Friesland'));
INSERT into dem.state(code, country, name) VALUES ('GE','NL',i18n.i18n('Gelderland'));
INSERT into dem.state(code, country, name) VALUES ('GR','NL',i18n.i18n('Groningen'));
INSERT into dem.state(code, country, name) VALUES ('LB','NL',i18n.i18n('Limburg'));
INSERT into dem.state(code, country, name) VALUES ('NB','NL',i18n.i18n('Noord-Brabant'));
INSERT into dem.state(code, country, name) VALUES ('NH','NL',i18n.i18n('Noord-Holland'));
INSERT into dem.state(code, country, name) VALUES ('OV','NL',i18n.i18n('Overijssel'));
INSERT into dem.state(code, country, name) VALUES ('UT','NL',i18n.i18n('Utrecht'));
INSERT into dem.state(code, country, name) VALUES ('ZE','NL',i18n.i18n('Zeeland'));
INSERT into dem.state(code, country, name) VALUES ('ZH','NL',i18n.i18n('Zuid-Holland'));
-- country NO
INSERT into dem.state(code, country, name) VALUES ('AK','NO',i18n.i18n('Akershus'));
INSERT into dem.state(code, country, name) VALUES ('AA','NO',i18n.i18n('Aust-Agder'));
INSERT into dem.state(code, country, name) VALUES ('BU','NO',i18n.i18n('Buskerud'));
INSERT into dem.state(code, country, name) VALUES ('FI','NO',i18n.i18n('Finnmark'));
INSERT into dem.state(code, country, name) VALUES ('HE','NO',i18n.i18n('Hedmark'));
INSERT into dem.state(code, country, name) VALUES ('HO','NO',i18n.i18n('Hordaland'));
INSERT into dem.state(code, country, name) VALUES ('MR','NO',i18n.i18n('More og Romsdal'));
INSERT into dem.state(code, country, name) VALUES ('NT','NO',i18n.i18n('Nord-Trondelag'));
INSERT into dem.state(code, country, name) VALUES ('NL','NO',i18n.i18n('Nordland'));
INSERT into dem.state(code, country, name) VALUES ('OF','NO',i18n.i18n('Ostfold'));
INSERT into dem.state(code, country, name) VALUES ('OP','NO',i18n.i18n('Oppland'));
INSERT into dem.state(code, country, name) VALUES ('OS','NO',i18n.i18n('Oslo'));
INSERT into dem.state(code, country, name) VALUES ('RO','NO',i18n.i18n('Rogaland'));
INSERT into dem.state(code, country, name) VALUES ('ST','NO',i18n.i18n('Sor-Trondelag'));
INSERT into dem.state(code, country, name) VALUES ('SF','NO',i18n.i18n('Sogn og Fjordane'));
INSERT into dem.state(code, country, name) VALUES ('SV','NO',i18n.i18n('Svalbard'));
INSERT into dem.state(code, country, name) VALUES ('TE','NO',i18n.i18n('Telemark'));
INSERT into dem.state(code, country, name) VALUES ('TR','NO',i18n.i18n('Troms'));
INSERT into dem.state(code, country, name) VALUES ('VA','NO',i18n.i18n('Vest-Agder'));
INSERT into dem.state(code, country, name) VALUES ('VF','NO',i18n.i18n('Vestfold'));
-- country NP
INSERT into dem.state(code, country, name) VALUES ('NP-1','NP',i18n.i18n('StateNameStub'));
-- country NR
INSERT into dem.state(code, country, name) VALUES ('NR-1','NR',i18n.i18n('StateNameStub'));
-- country NU
INSERT into dem.state(code, country, name) VALUES ('NU-1','NU',i18n.i18n('StateNameStub'));
-- country NZ
INSERT into dem.state(code, country, name) VALUES ('AU','NZ',i18n.i18n('Auckland'));
INSERT into dem.state(code, country, name) VALUES ('BP','NZ',i18n.i18n('Bay of Plenty'));
INSERT into dem.state(code, country, name) VALUES ('CA','NZ',i18n.i18n('Canterbury'));
INSERT into dem.state(code, country, name) VALUES ('GI','NZ',i18n.i18n('Gisborne'));
INSERT into dem.state(code, country, name) VALUES ('HB','NZ',i18n.i18n('Hawke''s Bay'));
INSERT into dem.state(code, country, name) VALUES ('MA','NZ',i18n.i18n('Marlborough'));
INSERT into dem.state(code, country, name) VALUES ('NE','NZ',i18n.i18n('Nelson'));
INSERT into dem.state(code, country, name) VALUES ('NO','NZ',i18n.i18n('Northland'));
INSERT into dem.state(code, country, name) VALUES ('OT','NZ',i18n.i18n('Otago'));
INSERT into dem.state(code, country, name) VALUES ('SO','NZ',i18n.i18n('Southland'));
INSERT into dem.state(code, country, name) VALUES ('TA','NZ',i18n.i18n('Taranaki'));
INSERT into dem.state(code, country, name) VALUES ('TS','NZ',i18n.i18n('Tasman'));
INSERT into dem.state(code, country, name) VALUES ('WA','NZ',i18n.i18n('Waikato'));
INSERT into dem.state(code, country, name) VALUES ('WM','NZ',i18n.i18n('Wanganui-Manawatu'));
INSERT into dem.state(code, country, name) VALUES ('WE','NZ',i18n.i18n('Wellington'));
INSERT into dem.state(code, country, name) VALUES ('WC','NZ',i18n.i18n('West Coast'));
-- country OM
INSERT into dem.state(code, country, name) VALUES ('OM-1','OM',i18n.i18n('StateNameStub'));
-- country PA
INSERT into dem.state(code, country, name) VALUES ('PA-1','PA',i18n.i18n('StateNameStub'));
-- country PE
INSERT into dem.state(code, country, name) VALUES ('PE-1','PE',i18n.i18n('StateNameStub'));
-- country PF
INSERT into dem.state(code, country, name) VALUES ('PF-1','PF',i18n.i18n('StateNameStub'));
-- country PG
INSERT into dem.state(code, country, name) VALUES ('PG-1','PG',i18n.i18n('StateNameStub'));
-- country PH
INSERT into dem.state(code, country, name) VALUES ('AB','PH',i18n.i18n('Abra'));
INSERT into dem.state(code, country, name) VALUES ('AG','PH',i18n.i18n('Agusan del Norte'));
INSERT into dem.state(code, country, name) VALUES ('AU','PH',i18n.i18n('Agusan del Sur'));
INSERT into dem.state(code, country, name) VALUES ('AK','PH',i18n.i18n('Aklan'));
INSERT into dem.state(code, country, name) VALUES ('AL','PH',i18n.i18n('Albay'));
INSERT into dem.state(code, country, name) VALUES ('AN','PH',i18n.i18n('Angeles'));
INSERT into dem.state(code, country, name) VALUES ('AT','PH',i18n.i18n('Antique'));
INSERT into dem.state(code, country, name) VALUES ('BA','PH',i18n.i18n('Bacolod'));
INSERT into dem.state(code, country, name) VALUES ('BG','PH',i18n.i18n('Bago'));
INSERT into dem.state(code, country, name) VALUES ('BU','PH',i18n.i18n('Baguio'));
INSERT into dem.state(code, country, name) VALUES ('BI','PH',i18n.i18n('Bais'));
INSERT into dem.state(code, country, name) VALUES ('BS','PH',i18n.i18n('Basilan'));
INSERT into dem.state(code, country, name) VALUES ('BC','PH',i18n.i18n('Basilan City'));
INSERT into dem.state(code, country, name) VALUES ('BT','PH',i18n.i18n('Bataan'));
INSERT into dem.state(code, country, name) VALUES ('BN','PH',i18n.i18n('Batanes'));
INSERT into dem.state(code, country, name) VALUES ('BB','PH',i18n.i18n('Batangas'));
INSERT into dem.state(code, country, name) VALUES ('BD','PH',i18n.i18n('Batangas City'));
INSERT into dem.state(code, country, name) VALUES ('BE','PH',i18n.i18n('Benguet'));
INSERT into dem.state(code, country, name) VALUES ('BO','PH',i18n.i18n('Bohol'));
INSERT into dem.state(code, country, name) VALUES ('BK','PH',i18n.i18n('Bukidnon'));
INSERT into dem.state(code, country, name) VALUES ('BL','PH',i18n.i18n('Bulacan'));
INSERT into dem.state(code, country, name) VALUES ('BV','PH',i18n.i18n('Butuan'));
INSERT into dem.state(code, country, name) VALUES ('CA','PH',i18n.i18n('Cabanatuan'));
INSERT into dem.state(code, country, name) VALUES ('CD','PH',i18n.i18n('Cadiz'));
INSERT into dem.state(code, country, name) VALUES ('CG','PH',i18n.i18n('Cagayan'));
INSERT into dem.state(code, country, name) VALUES ('CO','PH',i18n.i18n('Cagayan de Oro'));
INSERT into dem.state(code, country, name) VALUES ('CL','PH',i18n.i18n('Calbayog'));
INSERT into dem.state(code, country, name) VALUES ('CC','PH',i18n.i18n('Caloocan'));
INSERT into dem.state(code, country, name) VALUES ('CN','PH',i18n.i18n('Camarines Norte'));
INSERT into dem.state(code, country, name) VALUES ('CS','PH',i18n.i18n('Camarines Sur'));
INSERT into dem.state(code, country, name) VALUES ('CM','PH',i18n.i18n('Camiguin'));
INSERT into dem.state(code, country, name) VALUES ('CB','PH',i18n.i18n('Canlaon'));
INSERT into dem.state(code, country, name) VALUES ('CP','PH',i18n.i18n('Capiz'));
INSERT into dem.state(code, country, name) VALUES ('CT','PH',i18n.i18n('Catanduanes'));
INSERT into dem.state(code, country, name) VALUES ('CV','PH',i18n.i18n('Cavite'));
INSERT into dem.state(code, country, name) VALUES ('CH','PH',i18n.i18n('Cavite City'));
INSERT into dem.state(code, country, name) VALUES ('CE','PH',i18n.i18n('Cebu'));
INSERT into dem.state(code, country, name) VALUES ('CY','PH',i18n.i18n('Cebu City'));
INSERT into dem.state(code, country, name) VALUES ('CF','PH',i18n.i18n('Cotabato'));
INSERT into dem.state(code, country, name) VALUES ('DA','PH',i18n.i18n('Dagupan'));
INSERT into dem.state(code, country, name) VALUES ('DN','PH',i18n.i18n('Danao'));
INSERT into dem.state(code, country, name) VALUES ('DP','PH',i18n.i18n('Dapitan'));
INSERT into dem.state(code, country, name) VALUES ('DD','PH',i18n.i18n('Davao City Davao'));
INSERT into dem.state(code, country, name) VALUES ('DS','PH',i18n.i18n('Davao del Sur'));
INSERT into dem.state(code, country, name) VALUES ('DO','PH',i18n.i18n('Davao Oriental'));
INSERT into dem.state(code, country, name) VALUES ('DI','PH',i18n.i18n('Dipolog'));
INSERT into dem.state(code, country, name) VALUES ('DU','PH',i18n.i18n('Dumaguete'));
INSERT into dem.state(code, country, name) VALUES ('ES','PH',i18n.i18n('Eastern Samar'));
INSERT into dem.state(code, country, name) VALUES ('GS','PH',i18n.i18n('General Santos'));
INSERT into dem.state(code, country, name) VALUES ('GI','PH',i18n.i18n('Gingoog'));
INSERT into dem.state(code, country, name) VALUES ('IF','PH',i18n.i18n('Ifugao'));
INSERT into dem.state(code, country, name) VALUES ('IL','PH',i18n.i18n('Iligan'));
INSERT into dem.state(code, country, name) VALUES ('IN','PH',i18n.i18n('Ilocos Norte'));
INSERT into dem.state(code, country, name) VALUES ('IS','PH',i18n.i18n('Ilocos Sur'));
INSERT into dem.state(code, country, name) VALUES ('IO','PH',i18n.i18n('Iloilo'));
INSERT into dem.state(code, country, name) VALUES ('IC','PH',i18n.i18n('Iloilo City'));
INSERT into dem.state(code, country, name) VALUES ('IR','PH',i18n.i18n('Iriga'));
INSERT into dem.state(code, country, name) VALUES ('IB','PH',i18n.i18n('Isabela'));
INSERT into dem.state(code, country, name) VALUES ('KA','PH',i18n.i18n('Kalinga-Apayao'));
INSERT into dem.state(code, country, name) VALUES ('LC','PH',i18n.i18n('La Carlota'));
INSERT into dem.state(code, country, name) VALUES ('LU','PH',i18n.i18n('La Union'));
INSERT into dem.state(code, country, name) VALUES ('LA','PH',i18n.i18n('Laguna'));
INSERT into dem.state(code, country, name) VALUES ('LN','PH',i18n.i18n('Lanao del Norte'));
INSERT into dem.state(code, country, name) VALUES ('LS','PH',i18n.i18n('Lanao del Sur'));
INSERT into dem.state(code, country, name) VALUES ('LG','PH',i18n.i18n('Laoag'));
INSERT into dem.state(code, country, name) VALUES ('LL','PH',i18n.i18n('Lapu-Lapu'));
INSERT into dem.state(code, country, name) VALUES ('LE','PH',i18n.i18n('Legaspi'));
INSERT into dem.state(code, country, name) VALUES ('LY','PH',i18n.i18n('Leyte'));
INSERT into dem.state(code, country, name) VALUES ('LI','PH',i18n.i18n('Lipa'));
INSERT into dem.state(code, country, name) VALUES ('LV','PH',i18n.i18n('Lucena'));
INSERT into dem.state(code, country, name) VALUES ('MA','PH',i18n.i18n('Maguindanao'));
INSERT into dem.state(code, country, name) VALUES ('MN','PH',i18n.i18n('Mandaue'));
INSERT into dem.state(code, country, name) VALUES ('MI','PH',i18n.i18n('Manila'));
INSERT into dem.state(code, country, name) VALUES ('MR','PH',i18n.i18n('Marawi'));
INSERT into dem.state(code, country, name) VALUES ('MD','PH',i18n.i18n('Marinduque'));
INSERT into dem.state(code, country, name) VALUES ('MS','PH',i18n.i18n('Masbate'));
INSERT into dem.state(code, country, name) VALUES ('MO','PH',i18n.i18n('Mindoro Occidental'));
INSERT into dem.state(code, country, name) VALUES ('MT','PH',i18n.i18n('Mindoro Oriental'));
INSERT into dem.state(code, country, name) VALUES ('ML','PH',i18n.i18n('Misamis Occidental'));
INSERT into dem.state(code, country, name) VALUES ('ME','PH',i18n.i18n('Misamis Oriental'));
INSERT into dem.state(code, country, name) VALUES ('MU','PH',i18n.i18n('Mountain'));
INSERT into dem.state(code, country, name) VALUES ('NA','PH',i18n.i18n('Naga'));
INSERT into dem.state(code, country, name) VALUES ('NO','PH',i18n.i18n('Negros Occidental'));
INSERT into dem.state(code, country, name) VALUES ('NE','PH',i18n.i18n('Negros Oriental'));
INSERT into dem.state(code, country, name) VALUES ('NC','PH',i18n.i18n('North Cotabato'));
INSERT into dem.state(code, country, name) VALUES ('NS','PH',i18n.i18n('Northern Samar'));
INSERT into dem.state(code, country, name) VALUES ('NI','PH',i18n.i18n('Nueva Ecija'));
INSERT into dem.state(code, country, name) VALUES ('NV','PH',i18n.i18n('Nueva Vizcaya'));
INSERT into dem.state(code, country, name) VALUES ('OL','PH',i18n.i18n('Olongapo'));
INSERT into dem.state(code, country, name) VALUES ('OR','PH',i18n.i18n('Ormoc'));
INSERT into dem.state(code, country, name) VALUES ('OQ','PH',i18n.i18n('Oroquieta'));
INSERT into dem.state(code, country, name) VALUES ('OZ','PH',i18n.i18n('Ozamis'));
INSERT into dem.state(code, country, name) VALUES ('PA','PH',i18n.i18n('Pagadian'));
INSERT into dem.state(code, country, name) VALUES ('PL','PH',i18n.i18n('Palawan'));
INSERT into dem.state(code, country, name) VALUES ('PY','PH',i18n.i18n('Palayan'));
INSERT into dem.state(code, country, name) VALUES ('PM','PH',i18n.i18n('Pampanga'));
INSERT into dem.state(code, country, name) VALUES ('PN','PH',i18n.i18n('Pangasinan'));
INSERT into dem.state(code, country, name) VALUES ('PS','PH',i18n.i18n('Pasay'));
INSERT into dem.state(code, country, name) VALUES ('PU','PH',i18n.i18n('Puerto Princesa'));
INSERT into dem.state(code, country, name) VALUES ('QU','PH',i18n.i18n('Quezon'));
INSERT into dem.state(code, country, name) VALUES ('QZ','PH',i18n.i18n('Quezon City'));
INSERT into dem.state(code, country, name) VALUES ('QR','PH',i18n.i18n('Quirino'));
INSERT into dem.state(code, country, name) VALUES ('RI','PH',i18n.i18n('Rizal'));
INSERT into dem.state(code, country, name) VALUES ('RO','PH',i18n.i18n('Romblon'));
INSERT into dem.state(code, country, name) VALUES ('RX','PH',i18n.i18n('Roxas'));
INSERT into dem.state(code, country, name) VALUES ('SA','PH',i18n.i18n('Samar'));
INSERT into dem.state(code, country, name) VALUES ('SC','PH',i18n.i18n('San Carlos (in Negros Occidental'));
INSERT into dem.state(code, country, name) VALUES ('SN','PH',i18n.i18n('San Carlos (in Pangasinan)'));
INSERT into dem.state(code, country, name) VALUES ('SJ','PH',i18n.i18n('San Jose'));
INSERT into dem.state(code, country, name) VALUES ('SP','PH',i18n.i18n('San Pablo'));
INSERT into dem.state(code, country, name) VALUES ('SI','PH',i18n.i18n('Silay'));
INSERT into dem.state(code, country, name) VALUES ('SQ','PH',i18n.i18n('Siquijor'));
INSERT into dem.state(code, country, name) VALUES ('SO','PH',i18n.i18n('Sorsogon'));
INSERT into dem.state(code, country, name) VALUES ('ST','PH',i18n.i18n('South Cotabato'));
INSERT into dem.state(code, country, name) VALUES ('SL','PH',i18n.i18n('Southern Leyte'));
INSERT into dem.state(code, country, name) VALUES ('SK','PH',i18n.i18n('Sultan Kudarat'));
INSERT into dem.state(code, country, name) VALUES ('SU','PH',i18n.i18n('Sulu'));
INSERT into dem.state(code, country, name) VALUES ('SG','PH',i18n.i18n('Surigao'));
INSERT into dem.state(code, country, name) VALUES ('SD','PH',i18n.i18n('Surigao del Norte'));
INSERT into dem.state(code, country, name) VALUES ('SS','PH',i18n.i18n('Surigao del Sur'));
INSERT into dem.state(code, country, name) VALUES ('TA','PH',i18n.i18n('Tacloban'));
INSERT into dem.state(code, country, name) VALUES ('TG','PH',i18n.i18n('Tagaytay'));
INSERT into dem.state(code, country, name) VALUES ('TB','PH',i18n.i18n('Tagbilaran'));
INSERT into dem.state(code, country, name) VALUES ('TN','PH',i18n.i18n('Tangub'));
INSERT into dem.state(code, country, name) VALUES ('TR','PH',i18n.i18n('Tarlac'));
INSERT into dem.state(code, country, name) VALUES ('TW','PH',i18n.i18n('Tawitawi'));
INSERT into dem.state(code, country, name) VALUES ('TO','PH',i18n.i18n('Toledo'));
INSERT into dem.state(code, country, name) VALUES ('TM','PH',i18n.i18n('Trece Martires'));
INSERT into dem.state(code, country, name) VALUES ('ZA','PH',i18n.i18n('Zambales'));
INSERT into dem.state(code, country, name) VALUES ('ZM','PH',i18n.i18n('Zamboanga'));
INSERT into dem.state(code, country, name) VALUES ('ZN','PH',i18n.i18n('Zamboanga del Norte'));
INSERT into dem.state(code, country, name) VALUES ('ZS','PH',i18n.i18n('Zamboanga del Sur'));
-- country PK
INSERT into dem.state(code, country, name) VALUES ('BA','PK',i18n.i18n('Balochistan'));
INSERT into dem.state(code, country, name) VALUES ('TA','PK',i18n.i18n('Federally Administered Tribal Ar'));
INSERT into dem.state(code, country, name) VALUES ('IS','PK',i18n.i18n('Islamabad Capital Territory'));
INSERT into dem.state(code, country, name) VALUES ('NF','PK',i18n.i18n('North-West Frontier'));
INSERT into dem.state(code, country, name) VALUES ('PU','PK',i18n.i18n('Punjab'));
INSERT into dem.state(code, country, name) VALUES ('SI','PK',i18n.i18n('Sindh'));
-- country PL
INSERT into dem.state(code, country, name) VALUES ('DO','PL',i18n.i18n('Dolnoslaskie'));
INSERT into dem.state(code, country, name) VALUES ('KM','PL',i18n.i18n('Kujawsko-Pomorskie'));
INSERT into dem.state(code, country, name) VALUES ('LO','PL',i18n.i18n('Lodzkie'));
INSERT into dem.state(code, country, name) VALUES ('LE','PL',i18n.i18n('Lubelskie'));
INSERT into dem.state(code, country, name) VALUES ('LU','PL',i18n.i18n('Lubuskie'));
INSERT into dem.state(code, country, name) VALUES ('ML','PL',i18n.i18n('Malopolskie'));
INSERT into dem.state(code, country, name) VALUES ('MZ','PL',i18n.i18n('Mazowieckie'));
INSERT into dem.state(code, country, name) VALUES ('OP','PL',i18n.i18n('Opolskie'));
INSERT into dem.state(code, country, name) VALUES ('PK','PL',i18n.i18n('Podkarpackie'));
INSERT into dem.state(code, country, name) VALUES ('PL','PL',i18n.i18n('Podlaskie'));
INSERT into dem.state(code, country, name) VALUES ('PM','PL',i18n.i18n('Pomorskie'));
INSERT into dem.state(code, country, name) VALUES ('SL','PL',i18n.i18n('Slaskie'));
INSERT into dem.state(code, country, name) VALUES ('SW','PL',i18n.i18n('Swietokrzyskie'));
INSERT into dem.state(code, country, name) VALUES ('WM','PL',i18n.i18n('Warminsko-Mazurskie'));
INSERT into dem.state(code, country, name) VALUES ('WI','PL',i18n.i18n('Wielkopolskie'));
INSERT into dem.state(code, country, name) VALUES ('ZA','PL',i18n.i18n('Zachodniopomorskie'));
-- country PM
INSERT into dem.state(code, country, name) VALUES ('PM-1','PM',i18n.i18n('StateNameStub'));
-- country PN
INSERT into dem.state(code, country, name) VALUES ('PN-1','PN',i18n.i18n('StateNameStub'));
-- country PR
INSERT into dem.state(code, country, name) VALUES ('PR-1','PR',i18n.i18n('StateNameStub'));
-- country PT
INSERT into dem.state(code, country, name) VALUES ('AC','PT',i18n.i18n('Acores (Azores)'));
INSERT into dem.state(code, country, name) VALUES ('AV','PT',i18n.i18n('Aveiro'));
INSERT into dem.state(code, country, name) VALUES ('BE','PT',i18n.i18n('Beja'));
INSERT into dem.state(code, country, name) VALUES ('BR','PT',i18n.i18n('Braga'));
INSERT into dem.state(code, country, name) VALUES ('BA','PT',i18n.i18n('Braganca'));
INSERT into dem.state(code, country, name) VALUES ('CB','PT',i18n.i18n('Castelo Branco'));
INSERT into dem.state(code, country, name) VALUES ('CO','PT',i18n.i18n('Coimbra'));
INSERT into dem.state(code, country, name) VALUES ('EV','PT',i18n.i18n('Evora'));
INSERT into dem.state(code, country, name) VALUES ('FA','PT',i18n.i18n('Faro'));
INSERT into dem.state(code, country, name) VALUES ('GU','PT',i18n.i18n('Guarda'));
INSERT into dem.state(code, country, name) VALUES ('LE','PT',i18n.i18n('Leiria'));
INSERT into dem.state(code, country, name) VALUES ('LI','PT',i18n.i18n('Lisboa'));
INSERT into dem.state(code, country, name) VALUES ('ME','PT',i18n.i18n('Madeira'));
INSERT into dem.state(code, country, name) VALUES ('PO','PT',i18n.i18n('Portalegre'));
INSERT into dem.state(code, country, name) VALUES ('PR','PT',i18n.i18n('Porto'));
INSERT into dem.state(code, country, name) VALUES ('SA','PT',i18n.i18n('Santarem'));
INSERT into dem.state(code, country, name) VALUES ('SE','PT',i18n.i18n('Setubal'));
INSERT into dem.state(code, country, name) VALUES ('VC','PT',i18n.i18n('Viana do Castelo'));
INSERT into dem.state(code, country, name) VALUES ('VR','PT',i18n.i18n('Vila Real'));
INSERT into dem.state(code, country, name) VALUES ('VI','PT',i18n.i18n('Viseu'));
-- country PW
INSERT into dem.state(code, country, name) VALUES ('PW-1','PW',i18n.i18n('StateNameStub'));
-- country PY
INSERT into dem.state(code, country, name) VALUES ('PY-1','PY',i18n.i18n('StateNameStub'));
-- country QA
INSERT into dem.state(code, country, name) VALUES ('QA-1','QA',i18n.i18n('StateNameStub'));
-- country RE
INSERT into dem.state(code, country, name) VALUES ('RE-1','RE',i18n.i18n('StateNameStub'));
-- country RO
INSERT into dem.state(code, country, name) VALUES ('AL','RO',i18n.i18n('Alba'));
INSERT into dem.state(code, country, name) VALUES ('AR','RO',i18n.i18n('Arad'));
INSERT into dem.state(code, country, name) VALUES ('AG','RO',i18n.i18n('Arges'));
INSERT into dem.state(code, country, name) VALUES ('BA','RO',i18n.i18n('Bacau'));
INSERT into dem.state(code, country, name) VALUES ('BI','RO',i18n.i18n('Bihor'));
INSERT into dem.state(code, country, name) VALUES ('BN','RO',i18n.i18n('Bistrita-Nasaud'));
INSERT into dem.state(code, country, name) VALUES ('BO','RO',i18n.i18n('Botosani'));
INSERT into dem.state(code, country, name) VALUES ('BL','RO',i18n.i18n('Braila'));
INSERT into dem.state(code, country, name) VALUES ('BR','RO',i18n.i18n('Brasov'));
INSERT into dem.state(code, country, name) VALUES ('BU','RO',i18n.i18n('Bucuresti'));
INSERT into dem.state(code, country, name) VALUES ('BZ','RO',i18n.i18n('Buzau'));
INSERT into dem.state(code, country, name) VALUES ('CA','RO',i18n.i18n('Calarasi'));
INSERT into dem.state(code, country, name) VALUES ('CS','RO',i18n.i18n('Caras-Severin'));
INSERT into dem.state(code, country, name) VALUES ('CL','RO',i18n.i18n('Cluj'));
INSERT into dem.state(code, country, name) VALUES ('CO','RO',i18n.i18n('Constanta'));
INSERT into dem.state(code, country, name) VALUES ('CV','RO',i18n.i18n('Covasna'));
INSERT into dem.state(code, country, name) VALUES ('DI','RO',i18n.i18n('Dimbovita'));
INSERT into dem.state(code, country, name) VALUES ('DO','RO',i18n.i18n('Dolj'));
INSERT into dem.state(code, country, name) VALUES ('GA','RO',i18n.i18n('Galati'));
INSERT into dem.state(code, country, name) VALUES ('GI','RO',i18n.i18n('Giurgiu'));
INSERT into dem.state(code, country, name) VALUES ('GO','RO',i18n.i18n('Gorj'));
INSERT into dem.state(code, country, name) VALUES ('HA','RO',i18n.i18n('Harghita'));
INSERT into dem.state(code, country, name) VALUES ('HU','RO',i18n.i18n('Hunedoara'));
INSERT into dem.state(code, country, name) VALUES ('IA','RO',i18n.i18n('Ialomita'));
INSERT into dem.state(code, country, name) VALUES ('IS','RO',i18n.i18n('Iasi'));
INSERT into dem.state(code, country, name) VALUES ('IL','RO',i18n.i18n('Ilfov'));
INSERT into dem.state(code, country, name) VALUES ('MA','RO',i18n.i18n('Maramures'));
INSERT into dem.state(code, country, name) VALUES ('ME','RO',i18n.i18n('Mehedinti'));
INSERT into dem.state(code, country, name) VALUES ('MU','RO',i18n.i18n('Mures'));
INSERT into dem.state(code, country, name) VALUES ('NE','RO',i18n.i18n('Neamt'));
INSERT into dem.state(code, country, name) VALUES ('OL','RO',i18n.i18n('Olt'));
INSERT into dem.state(code, country, name) VALUES ('PR','RO',i18n.i18n('Prahova'));
INSERT into dem.state(code, country, name) VALUES ('SA','RO',i18n.i18n('Salaj'));
INSERT into dem.state(code, country, name) VALUES ('SM','RO',i18n.i18n('Satu-Mare'));
INSERT into dem.state(code, country, name) VALUES ('SI','RO',i18n.i18n('Sibiu'));
INSERT into dem.state(code, country, name) VALUES ('SU','RO',i18n.i18n('Suceava'));
INSERT into dem.state(code, country, name) VALUES ('TE','RO',i18n.i18n('Teleorman'));
INSERT into dem.state(code, country, name) VALUES ('TI','RO',i18n.i18n('Timis'));
INSERT into dem.state(code, country, name) VALUES ('TU','RO',i18n.i18n('Tulcea'));
INSERT into dem.state(code, country, name) VALUES ('VA','RO',i18n.i18n('Vaslui'));
INSERT into dem.state(code, country, name) VALUES ('VI','RO',i18n.i18n('Vilcea'));
INSERT into dem.state(code, country, name) VALUES ('VR','RO',i18n.i18n('Vrancea'));
-- country RU
INSERT into dem.state(code, country, name) VALUES ('AB','RU',i18n.i18n('Abakan'));
INSERT into dem.state(code, country, name) VALUES ('AG','RU',i18n.i18n('Aginskoye'));
INSERT into dem.state(code, country, name) VALUES ('AN','RU',i18n.i18n('Anadyr'));
INSERT into dem.state(code, country, name) VALUES ('AR','RU',i18n.i18n('Arkahangelsk'));
INSERT into dem.state(code, country, name) VALUES ('AS','RU',i18n.i18n('Astrakhan'));
INSERT into dem.state(code, country, name) VALUES ('BA','RU',i18n.i18n('Barnaul'));
INSERT into dem.state(code, country, name) VALUES ('BE','RU',i18n.i18n('Belgorod'));
INSERT into dem.state(code, country, name) VALUES ('BI','RU',i18n.i18n('Birobidzhan'));
INSERT into dem.state(code, country, name) VALUES ('BL','RU',i18n.i18n('Blagoveshchensk'));
INSERT into dem.state(code, country, name) VALUES ('BR','RU',i18n.i18n('Bryansk'));
INSERT into dem.state(code, country, name) VALUES ('CH','RU',i18n.i18n('Cheboksary'));
INSERT into dem.state(code, country, name) VALUES ('CL','RU',i18n.i18n('Chelyabinsk'));
INSERT into dem.state(code, country, name) VALUES ('CR','RU',i18n.i18n('Cherkessk'));
INSERT into dem.state(code, country, name) VALUES ('CI','RU',i18n.i18n('Chita'));
INSERT into dem.state(code, country, name) VALUES ('DU','RU',i18n.i18n('Dudinka'));
INSERT into dem.state(code, country, name) VALUES ('EL','RU',i18n.i18n('Elista'));
INSERT into dem.state(code, country, name) VALUES ('GO','RU',i18n.i18n('Gomo-Altaysk'));
INSERT into dem.state(code, country, name) VALUES ('GA','RU',i18n.i18n('Gorno-Altaysk'));
INSERT into dem.state(code, country, name) VALUES ('GR','RU',i18n.i18n('Groznyy'));
INSERT into dem.state(code, country, name) VALUES ('IR','RU',i18n.i18n('Irkutsk'));
INSERT into dem.state(code, country, name) VALUES ('IV','RU',i18n.i18n('Ivanovo'));
INSERT into dem.state(code, country, name) VALUES ('IZ','RU',i18n.i18n('Izhevsk'));
INSERT into dem.state(code, country, name) VALUES ('KA','RU',i18n.i18n('Kalinigrad'));
INSERT into dem.state(code, country, name) VALUES ('KL','RU',i18n.i18n('Kaluga'));
INSERT into dem.state(code, country, name) VALUES ('KS','RU',i18n.i18n('Kasnodar'));
INSERT into dem.state(code, country, name) VALUES ('KZ','RU',i18n.i18n('Kazan'));
INSERT into dem.state(code, country, name) VALUES ('KE','RU',i18n.i18n('Kemerovo'));
INSERT into dem.state(code, country, name) VALUES ('KH','RU',i18n.i18n('Khabarovsk'));
INSERT into dem.state(code, country, name) VALUES ('KM','RU',i18n.i18n('Khanty-Mansiysk'));
INSERT into dem.state(code, country, name) VALUES ('KO','RU',i18n.i18n('Kostroma'));
INSERT into dem.state(code, country, name) VALUES ('KR','RU',i18n.i18n('Krasnodar'));
INSERT into dem.state(code, country, name) VALUES ('KN','RU',i18n.i18n('Krasnoyarsk'));
INSERT into dem.state(code, country, name) VALUES ('KU','RU',i18n.i18n('Kudymkar'));
INSERT into dem.state(code, country, name) VALUES ('KG','RU',i18n.i18n('Kurgan'));
INSERT into dem.state(code, country, name) VALUES ('KK','RU',i18n.i18n('Kursk'));
INSERT into dem.state(code, country, name) VALUES ('KY','RU',i18n.i18n('Kyzyl'));
INSERT into dem.state(code, country, name) VALUES ('LI','RU',i18n.i18n('Lipetsk'));
INSERT into dem.state(code, country, name) VALUES ('MA','RU',i18n.i18n('Magadan'));
INSERT into dem.state(code, country, name) VALUES ('MK','RU',i18n.i18n('Makhachkala'));
INSERT into dem.state(code, country, name) VALUES ('MY','RU',i18n.i18n('Maykop'));
INSERT into dem.state(code, country, name) VALUES ('MO','RU',i18n.i18n('Moscow'));
INSERT into dem.state(code, country, name) VALUES ('MU','RU',i18n.i18n('Murmansk'));
INSERT into dem.state(code, country, name) VALUES ('NA','RU',i18n.i18n('Nalchik'));
INSERT into dem.state(code, country, name) VALUES ('NR','RU',i18n.i18n('Naryan Mar'));
INSERT into dem.state(code, country, name) VALUES ('NZ','RU',i18n.i18n('Nazran'));
INSERT into dem.state(code, country, name) VALUES ('NI','RU',i18n.i18n('Nizhniy Novgorod'));
INSERT into dem.state(code, country, name) VALUES ('NO','RU',i18n.i18n('Novgorod'));
INSERT into dem.state(code, country, name) VALUES ('NV','RU',i18n.i18n('Novosibirsk'));
INSERT into dem.state(code, country, name) VALUES ('OM','RU',i18n.i18n('Omsk'));
INSERT into dem.state(code, country, name) VALUES ('OR','RU',i18n.i18n('Orel'));
INSERT into dem.state(code, country, name) VALUES ('OE','RU',i18n.i18n('Orenburg'));
INSERT into dem.state(code, country, name) VALUES ('PA','RU',i18n.i18n('Palana'));
INSERT into dem.state(code, country, name) VALUES ('PE','RU',i18n.i18n('Penza'));
INSERT into dem.state(code, country, name) VALUES ('PR','RU',i18n.i18n('Perm'));
INSERT into dem.state(code, country, name) VALUES ('PK','RU',i18n.i18n('Petropavlovsk-Kamchatskiy'));
INSERT into dem.state(code, country, name) VALUES ('PT','RU',i18n.i18n('Petrozavodsk'));
INSERT into dem.state(code, country, name) VALUES ('PS','RU',i18n.i18n('Pskov'));
INSERT into dem.state(code, country, name) VALUES ('RO','RU',i18n.i18n('Rostov-na-Donu'));
INSERT into dem.state(code, country, name) VALUES ('RY','RU',i18n.i18n('Ryazan'));
INSERT into dem.state(code, country, name) VALUES ('SL','RU',i18n.i18n('Salekhard'));
INSERT into dem.state(code, country, name) VALUES ('SA','RU',i18n.i18n('Samara'));
INSERT into dem.state(code, country, name) VALUES ('SR','RU',i18n.i18n('Saransk'));
INSERT into dem.state(code, country, name) VALUES ('SV','RU',i18n.i18n('Saratov'));
INSERT into dem.state(code, country, name) VALUES ('SM','RU',i18n.i18n('Smolensk'));
INSERT into dem.state(code, country, name) VALUES ('SP','RU',i18n.i18n('St. Petersburg'));
INSERT into dem.state(code, country, name) VALUES ('ST','RU',i18n.i18n('Stavropol'));
INSERT into dem.state(code, country, name) VALUES ('SY','RU',i18n.i18n('Syktyvkar'));
INSERT into dem.state(code, country, name) VALUES ('TA','RU',i18n.i18n('Tambov'));
INSERT into dem.state(code, country, name) VALUES ('TO','RU',i18n.i18n('Tomsk'));
INSERT into dem.state(code, country, name) VALUES ('TU','RU',i18n.i18n('Tula'));
INSERT into dem.state(code, country, name) VALUES ('TR','RU',i18n.i18n('Tura'));
INSERT into dem.state(code, country, name) VALUES ('TV','RU',i18n.i18n('Tver'));
INSERT into dem.state(code, country, name) VALUES ('TY','RU',i18n.i18n('Tyumen'));
INSERT into dem.state(code, country, name) VALUES ('UF','RU',i18n.i18n('Ufa'));
INSERT into dem.state(code, country, name) VALUES ('UL','RU',i18n.i18n('Ul''yanovsk'));
INSERT into dem.state(code, country, name) VALUES ('UU','RU',i18n.i18n('Ulan-Ude'));
INSERT into dem.state(code, country, name) VALUES ('US','RU',i18n.i18n('Ust''-Ordynskiy'));
INSERT into dem.state(code, country, name) VALUES ('VL','RU',i18n.i18n('Vladikavkaz'));
INSERT into dem.state(code, country, name) VALUES ('VA','RU',i18n.i18n('Vladimir'));
INSERT into dem.state(code, country, name) VALUES ('VV','RU',i18n.i18n('Vladivostok'));
INSERT into dem.state(code, country, name) VALUES ('VG','RU',i18n.i18n('Volgograd'));
INSERT into dem.state(code, country, name) VALUES ('VD','RU',i18n.i18n('Vologda'));
INSERT into dem.state(code, country, name) VALUES ('VO','RU',i18n.i18n('Voronezh'));
INSERT into dem.state(code, country, name) VALUES ('VY','RU',i18n.i18n('Vyatka'));
INSERT into dem.state(code, country, name) VALUES ('YA','RU',i18n.i18n('Yakutsk'));
INSERT into dem.state(code, country, name) VALUES ('YR','RU',i18n.i18n('Yaroslavl'));
INSERT into dem.state(code, country, name) VALUES ('YE','RU',i18n.i18n('Yekaterinburg'));
INSERT into dem.state(code, country, name) VALUES ('YO','RU',i18n.i18n('Yoshkar-Ola'));
-- country RW
INSERT into dem.state(code, country, name) VALUES ('RW-1','RW',i18n.i18n('StateNameStub'));
-- country SA
INSERT into dem.state(code, country, name) VALUES ('SA-1','SA',i18n.i18n('StateNameStub'));
-- country SB
INSERT into dem.state(code, country, name) VALUES ('SB-1','SB',i18n.i18n('StateNameStub'));
-- country SC
INSERT into dem.state(code, country, name) VALUES ('SC-1','SC',i18n.i18n('StateNameStub'));
-- country SD
INSERT into dem.state(code, country, name) VALUES ('SD-1','SD',i18n.i18n('StateNameStub'));
-- country SE
INSERT into dem.state(code, country, name) VALUES ('BL','SE',i18n.i18n('Blekinge'));
INSERT into dem.state(code, country, name) VALUES ('DA','SE',i18n.i18n('Dalarnas'));
INSERT into dem.state(code, country, name) VALUES ('GA','SE',i18n.i18n('Gavleborgs'));
INSERT into dem.state(code, country, name) VALUES ('GO','SE',i18n.i18n('Gotlands'));
INSERT into dem.state(code, country, name) VALUES ('HA','SE',i18n.i18n('Hallands'));
INSERT into dem.state(code, country, name) VALUES ('JA','SE',i18n.i18n('Jamtlands'));
INSERT into dem.state(code, country, name) VALUES ('JO','SE',i18n.i18n('Jonkopings'));
INSERT into dem.state(code, country, name) VALUES ('KA','SE',i18n.i18n('Kalmar'));
INSERT into dem.state(code, country, name) VALUES ('KR','SE',i18n.i18n('Kronobergs'));
INSERT into dem.state(code, country, name) VALUES ('NO','SE',i18n.i18n('Norrbottens'));
INSERT into dem.state(code, country, name) VALUES ('OR','SE',i18n.i18n('Orebro'));
INSERT into dem.state(code, country, name) VALUES ('OS','SE',i18n.i18n('Ostergotlands'));
INSERT into dem.state(code, country, name) VALUES ('SK','SE',i18n.i18n('Skane'));
INSERT into dem.state(code, country, name) VALUES ('SO','SE',i18n.i18n('Sodermanlands'));
INSERT into dem.state(code, country, name) VALUES ('ST','SE',i18n.i18n('Stockholms'));
INSERT into dem.state(code, country, name) VALUES ('UP','SE',i18n.i18n('Uppsala'));
INSERT into dem.state(code, country, name) VALUES ('VA','SE',i18n.i18n('Varmlands'));
INSERT into dem.state(code, country, name) VALUES ('VS','SE',i18n.i18n('Vasterbottens'));
INSERT into dem.state(code, country, name) VALUES ('VT','SE',i18n.i18n('Vasternorrlands'));
INSERT into dem.state(code, country, name) VALUES ('VM','SE',i18n.i18n('Vastmanlands'));
INSERT into dem.state(code, country, name) VALUES ('VG','SE',i18n.i18n('Vastra Gotalands'));
-- country SG
INSERT into dem.state(code, country, name) VALUES ('SG-1','SG',i18n.i18n('StateNameStub'));
-- country SH
INSERT into dem.state(code, country, name) VALUES ('AS','SH',i18n.i18n('Ascension'));
INSERT into dem.state(code, country, name) VALUES ('SH','SH',i18n.i18n('Saint Helena'));
INSERT into dem.state(code, country, name) VALUES ('TC','SH',i18n.i18n('Tristan da Cunha'));
-- country SI
INSERT into dem.state(code, country, name) VALUES ('SI-1','SI',i18n.i18n('StateNameStub'));
-- country SJ
INSERT into dem.state(code, country, name) VALUES ('SJ-1','SJ',i18n.i18n('StateNameStub'));
-- country SK
INSERT into dem.state(code, country, name) VALUES ('BA','SK',i18n.i18n('Banskobystricky'));
INSERT into dem.state(code, country, name) VALUES ('BR','SK',i18n.i18n('Bratislavsky'));
INSERT into dem.state(code, country, name) VALUES ('KO','SK',i18n.i18n('Kosicky'));
INSERT into dem.state(code, country, name) VALUES ('NI','SK',i18n.i18n('Nitriansky'));
INSERT into dem.state(code, country, name) VALUES ('PR','SK',i18n.i18n('Presovsky'));
INSERT into dem.state(code, country, name) VALUES ('TR','SK',i18n.i18n('Trenciansky'));
INSERT into dem.state(code, country, name) VALUES ('TN','SK',i18n.i18n('Trnavsky'));
INSERT into dem.state(code, country, name) VALUES ('ZI','SK',i18n.i18n('Zilinsky'));
-- country SL
INSERT into dem.state(code, country, name) VALUES ('SL-1','SL',i18n.i18n('StateNameStub'));
-- country SM
INSERT into dem.state(code, country, name) VALUES ('SM-1','SM',i18n.i18n('StateNameStub'));
-- country SN
INSERT into dem.state(code, country, name) VALUES ('SN-1','SN',i18n.i18n('StateNameStub'));
-- country SO
INSERT into dem.state(code, country, name) VALUES ('SO-1','SO',i18n.i18n('StateNameStub'));
-- country SR
INSERT into dem.state(code, country, name) VALUES ('SR-1','SR',i18n.i18n('StateNameStub'));
-- country ST
INSERT into dem.state(code, country, name) VALUES ('ST-1','ST',i18n.i18n('StateNameStub'));
-- country SV
INSERT into dem.state(code, country, name) VALUES ('AH','SV',i18n.i18n('Ahuachapan'));
INSERT into dem.state(code, country, name) VALUES ('CA','SV',i18n.i18n('Cabanas'));
INSERT into dem.state(code, country, name) VALUES ('CH','SV',i18n.i18n('Chalatenango'));
INSERT into dem.state(code, country, name) VALUES ('CU','SV',i18n.i18n('Cuscatlan'));
INSERT into dem.state(code, country, name) VALUES ('LL','SV',i18n.i18n('La Libertad'));
INSERT into dem.state(code, country, name) VALUES ('LP','SV',i18n.i18n('La Paz'));
INSERT into dem.state(code, country, name) VALUES ('LU','SV',i18n.i18n('La Union'));
INSERT into dem.state(code, country, name) VALUES ('MO','SV',i18n.i18n('Morazan'));
INSERT into dem.state(code, country, name) VALUES ('SM','SV',i18n.i18n('San Miguel'));
INSERT into dem.state(code, country, name) VALUES ('SS','SV',i18n.i18n('San Salvador'));
INSERT into dem.state(code, country, name) VALUES ('SV','SV',i18n.i18n('San Vicente'));
INSERT into dem.state(code, country, name) VALUES ('SA','SV',i18n.i18n('Santa Ana'));
INSERT into dem.state(code, country, name) VALUES ('SO','SV',i18n.i18n('Sonsonate'));
INSERT into dem.state(code, country, name) VALUES ('US','SV',i18n.i18n('Usulutan'));
-- country SY
INSERT into dem.state(code, country, name) VALUES ('SY-1','SY',i18n.i18n('StateNameStub'));
-- country SZ
INSERT into dem.state(code, country, name) VALUES ('SZ-1','SZ',i18n.i18n('StateNameStub'));
-- country TC
INSERT into dem.state(code, country, name) VALUES ('TC-1','TC',i18n.i18n('StateNameStub'));
-- country TD
INSERT into dem.state(code, country, name) VALUES ('TD-1','TD',i18n.i18n('StateNameStub'));
-- country TF
INSERT into dem.state(code, country, name) VALUES ('TF-1','TF',i18n.i18n('StateNameStub'));
-- country TG
INSERT into dem.state(code, country, name) VALUES ('TG-1','TG',i18n.i18n('StateNameStub'));
-- country TH
INSERT into dem.state(code, country, name) VALUES ('AC','TH',i18n.i18n('Amnat Charoen'));
INSERT into dem.state(code, country, name) VALUES ('AT','TH',i18n.i18n('Ang Thong'));
INSERT into dem.state(code, country, name) VALUES ('BU','TH',i18n.i18n('Buriram'));
INSERT into dem.state(code, country, name) VALUES ('CH','TH',i18n.i18n('Chachoengsao'));
INSERT into dem.state(code, country, name) VALUES ('CN','TH',i18n.i18n('Chai Nat'));
INSERT into dem.state(code, country, name) VALUES ('CA','TH',i18n.i18n('Chaiyaphum'));
INSERT into dem.state(code, country, name) VALUES ('CT','TH',i18n.i18n('Chanthaburi'));
INSERT into dem.state(code, country, name) VALUES ('CM','TH',i18n.i18n('Chiang Mai'));
INSERT into dem.state(code, country, name) VALUES ('CR','TH',i18n.i18n('Chiang Rai'));
INSERT into dem.state(code, country, name) VALUES ('CB','TH',i18n.i18n('Chon Buri'));
INSERT into dem.state(code, country, name) VALUES ('CU','TH',i18n.i18n('Chumphon'));
INSERT into dem.state(code, country, name) VALUES ('KA','TH',i18n.i18n('Kalasin'));
INSERT into dem.state(code, country, name) VALUES ('KP','TH',i18n.i18n('Kamphaeng Phet'));
INSERT into dem.state(code, country, name) VALUES ('KN','TH',i18n.i18n('Kanchanaburi'));
INSERT into dem.state(code, country, name) VALUES ('KK','TH',i18n.i18n('Khon Kaen'));
INSERT into dem.state(code, country, name) VALUES ('KR','TH',i18n.i18n('Krabi'));
INSERT into dem.state(code, country, name) VALUES ('KT','TH',i18n.i18n('Krung Thep Mahanakhon (Bangkok)'));
INSERT into dem.state(code, country, name) VALUES ('LA','TH',i18n.i18n('Lampang'));
INSERT into dem.state(code, country, name) VALUES ('LM','TH',i18n.i18n('Lamphun'));
INSERT into dem.state(code, country, name) VALUES ('LO','TH',i18n.i18n('Loei'));
INSERT into dem.state(code, country, name) VALUES ('LB','TH',i18n.i18n('Lop Buri'));
INSERT into dem.state(code, country, name) VALUES ('MH','TH',i18n.i18n('Mae Hong Son'));
INSERT into dem.state(code, country, name) VALUES ('MS','TH',i18n.i18n('Maha Sarakham'));
INSERT into dem.state(code, country, name) VALUES ('MU','TH',i18n.i18n('Mukdahan'));
INSERT into dem.state(code, country, name) VALUES ('NN','TH',i18n.i18n('Nakhon Nayok'));
INSERT into dem.state(code, country, name) VALUES ('NP','TH',i18n.i18n('Nakhon Pathom'));
INSERT into dem.state(code, country, name) VALUES ('NM','TH',i18n.i18n('Nakhon Phanom'));
INSERT into dem.state(code, country, name) VALUES ('NR','TH',i18n.i18n('Nakhon Ratchasima'));
INSERT into dem.state(code, country, name) VALUES ('NS','TH',i18n.i18n('Nakhon Sawan'));
INSERT into dem.state(code, country, name) VALUES ('NT','TH',i18n.i18n('Nakhon Si Thammarat'));
INSERT into dem.state(code, country, name) VALUES ('NA','TH',i18n.i18n('Nan'));
INSERT into dem.state(code, country, name) VALUES ('NW','TH',i18n.i18n('Narathiwat'));
INSERT into dem.state(code, country, name) VALUES ('NB','TH',i18n.i18n('Nong Bua Lamphu'));
INSERT into dem.state(code, country, name) VALUES ('NK','TH',i18n.i18n('Nong Khai'));
INSERT into dem.state(code, country, name) VALUES ('NO','TH',i18n.i18n('Nonthaburi'));
INSERT into dem.state(code, country, name) VALUES ('PT','TH',i18n.i18n('Pathum Thani'));
INSERT into dem.state(code, country, name) VALUES ('PA','TH',i18n.i18n('Pattani'));
INSERT into dem.state(code, country, name) VALUES ('PH','TH',i18n.i18n('Phangnga'));
INSERT into dem.state(code, country, name) VALUES ('PL','TH',i18n.i18n('Phatthalung'));
INSERT into dem.state(code, country, name) VALUES ('PY','TH',i18n.i18n('Phayao'));
INSERT into dem.state(code, country, name) VALUES ('PE','TH',i18n.i18n('Phetchabun'));
INSERT into dem.state(code, country, name) VALUES ('PC','TH',i18n.i18n('Phetchaburi'));
INSERT into dem.state(code, country, name) VALUES ('PI','TH',i18n.i18n('Phichit'));
INSERT into dem.state(code, country, name) VALUES ('PX','TH',i18n.i18n('Phitsanulok'));
INSERT into dem.state(code, country, name) VALUES ('PN','TH',i18n.i18n('Phra Nakhon Si Ayutthaya'));
INSERT into dem.state(code, country, name) VALUES ('PR','TH',i18n.i18n('Phrae'));
INSERT into dem.state(code, country, name) VALUES ('PU','TH',i18n.i18n('Phuket'));
INSERT into dem.state(code, country, name) VALUES ('PB','TH',i18n.i18n('Prachin Buri'));
INSERT into dem.state(code, country, name) VALUES ('PK','TH',i18n.i18n('Prachuap Khiri Khan'));
INSERT into dem.state(code, country, name) VALUES ('RA','TH',i18n.i18n('Ranong'));
INSERT into dem.state(code, country, name) VALUES ('RT','TH',i18n.i18n('Ratchaburi'));
INSERT into dem.state(code, country, name) VALUES ('RY','TH',i18n.i18n('Rayong'));
INSERT into dem.state(code, country, name) VALUES ('RE','TH',i18n.i18n('Roi Et'));
INSERT into dem.state(code, country, name) VALUES ('SK','TH',i18n.i18n('Sa Kaeo'));
INSERT into dem.state(code, country, name) VALUES ('SN','TH',i18n.i18n('Sakon Nakhon'));
INSERT into dem.state(code, country, name) VALUES ('SP','TH',i18n.i18n('Samut Prakan'));
INSERT into dem.state(code, country, name) VALUES ('SS','TH',i18n.i18n('Samut Sakhon'));
INSERT into dem.state(code, country, name) VALUES ('SM','TH',i18n.i18n('Samut Songkhram'));
INSERT into dem.state(code, country, name) VALUES ('SB','TH',i18n.i18n('Sara Buri'));
INSERT into dem.state(code, country, name) VALUES ('SA','TH',i18n.i18n('Satun'));
INSERT into dem.state(code, country, name) VALUES ('SI','TH',i18n.i18n('Sing Buri'));
INSERT into dem.state(code, country, name) VALUES ('SC','TH',i18n.i18n('Sisaket'));
INSERT into dem.state(code, country, name) VALUES ('SO','TH',i18n.i18n('Songkhla'));
INSERT into dem.state(code, country, name) VALUES ('SH','TH',i18n.i18n('Sukhothai'));
INSERT into dem.state(code, country, name) VALUES ('SR','TH',i18n.i18n('Suphan Buri'));
INSERT into dem.state(code, country, name) VALUES ('ST','TH',i18n.i18n('Surat Thani'));
INSERT into dem.state(code, country, name) VALUES ('SU','TH',i18n.i18n('Surin'));
INSERT into dem.state(code, country, name) VALUES ('TA','TH',i18n.i18n('Tak'));
INSERT into dem.state(code, country, name) VALUES ('TR','TH',i18n.i18n('Trang'));
INSERT into dem.state(code, country, name) VALUES ('TT','TH',i18n.i18n('Trat'));
INSERT into dem.state(code, country, name) VALUES ('UR','TH',i18n.i18n('Ubon Ratchathani'));
INSERT into dem.state(code, country, name) VALUES ('UT','TH',i18n.i18n('Udon Thani'));
INSERT into dem.state(code, country, name) VALUES ('UH','TH',i18n.i18n('Uthai Thani'));
INSERT into dem.state(code, country, name) VALUES ('UA','TH',i18n.i18n('Uttaradit'));
INSERT into dem.state(code, country, name) VALUES ('YA','TH',i18n.i18n('Yala'));
INSERT into dem.state(code, country, name) VALUES ('YS','TH',i18n.i18n('Yasothon'));
-- country TJ
INSERT into dem.state(code, country, name) VALUES ('TJ-1','TJ',i18n.i18n('StateNameStub'));
-- country TK
INSERT into dem.state(code, country, name) VALUES ('TK-1','TK',i18n.i18n('StateNameStub'));
-- country TM
INSERT into dem.state(code, country, name) VALUES ('TM-1','TM',i18n.i18n('StateNameStub'));
-- country TN
INSERT into dem.state(code, country, name) VALUES ('AK','TN',i18n.i18n('Al Kaf'));
INSERT into dem.state(code, country, name) VALUES ('AM','TN',i18n.i18n('Al Mahdiyah'));
INSERT into dem.state(code, country, name) VALUES ('AU','TN',i18n.i18n('Al Munastir'));
INSERT into dem.state(code, country, name) VALUES ('AQ','TN',i18n.i18n('Al Qasrayn'));
INSERT into dem.state(code, country, name) VALUES ('AA','TN',i18n.i18n('Al Qayrawan'));
INSERT into dem.state(code, country, name) VALUES ('AR','TN',i18n.i18n('Aryanah'));
INSERT into dem.state(code, country, name) VALUES ('BJ','TN',i18n.i18n('Bajah'));
INSERT into dem.state(code, country, name) VALUES ('BN','TN',i18n.i18n('Banzart'));
INSERT into dem.state(code, country, name) VALUES ('BA','TN',i18n.i18n('Bin ''Arus'));
INSERT into dem.state(code, country, name) VALUES ('JU','TN',i18n.i18n('Jundubah'));
INSERT into dem.state(code, country, name) VALUES ('MA','TN',i18n.i18n('Madanin'));
INSERT into dem.state(code, country, name) VALUES ('NA','TN',i18n.i18n('Nabul'));
INSERT into dem.state(code, country, name) VALUES ('QB','TN',i18n.i18n('Qabis'));
INSERT into dem.state(code, country, name) VALUES ('QF','TN',i18n.i18n('Qafsah'));
INSERT into dem.state(code, country, name) VALUES ('QI','TN',i18n.i18n('Qibili'));
INSERT into dem.state(code, country, name) VALUES ('SA','TN',i18n.i18n('Safaqis'));
INSERT into dem.state(code, country, name) VALUES ('SZ','TN',i18n.i18n('Sidi Bu Zayd'));
INSERT into dem.state(code, country, name) VALUES ('SI','TN',i18n.i18n('Silyanah'));
INSERT into dem.state(code, country, name) VALUES ('SU','TN',i18n.i18n('Susah'));
INSERT into dem.state(code, country, name) VALUES ('TA','TN',i18n.i18n('Tatawin'));
INSERT into dem.state(code, country, name) VALUES ('TW','TN',i18n.i18n('Tawzar'));
INSERT into dem.state(code, country, name) VALUES ('TU','TN',i18n.i18n('Tunis'));
INSERT into dem.state(code, country, name) VALUES ('ZA','TN',i18n.i18n('Zaghwan'));
-- country TO
INSERT into dem.state(code, country, name) VALUES ('TO-1','TO',i18n.i18n('StateNameStub'));
-- country TP
INSERT into dem.state(code, country, name) VALUES ('TP-1','TP',i18n.i18n('StateNameStub'));
-- country TR
INSERT into dem.state(code, country, name) VALUES ('AD','TR',i18n.i18n('Adana'));
INSERT into dem.state(code, country, name) VALUES ('AI','TR',i18n.i18n('Adiyaman'));
INSERT into dem.state(code, country, name) VALUES ('AF','TR',i18n.i18n('Afyon'));
INSERT into dem.state(code, country, name) VALUES ('AG','TR',i18n.i18n('Agri'));
INSERT into dem.state(code, country, name) VALUES ('AK','TR',i18n.i18n('Aksaray'));
INSERT into dem.state(code, country, name) VALUES ('AM','TR',i18n.i18n('Amasya'));
INSERT into dem.state(code, country, name) VALUES ('AN','TR',i18n.i18n('Ankara'));
INSERT into dem.state(code, country, name) VALUES ('AT','TR',i18n.i18n('Antalya'));
INSERT into dem.state(code, country, name) VALUES ('AR','TR',i18n.i18n('Ardahan'));
INSERT into dem.state(code, country, name) VALUES ('AV','TR',i18n.i18n('Artvin'));
INSERT into dem.state(code, country, name) VALUES ('AY','TR',i18n.i18n('Aydin'));
INSERT into dem.state(code, country, name) VALUES ('BA','TR',i18n.i18n('Balikesir'));
INSERT into dem.state(code, country, name) VALUES ('BR','TR',i18n.i18n('Bartin'));
INSERT into dem.state(code, country, name) VALUES ('BT','TR',i18n.i18n('Batman'));
INSERT into dem.state(code, country, name) VALUES ('BY','TR',i18n.i18n('Bayburt'));
INSERT into dem.state(code, country, name) VALUES ('BI','TR',i18n.i18n('Bilecik'));
INSERT into dem.state(code, country, name) VALUES ('BN','TR',i18n.i18n('Bingol'));
INSERT into dem.state(code, country, name) VALUES ('BL','TR',i18n.i18n('Bitlis'));
INSERT into dem.state(code, country, name) VALUES ('BO','TR',i18n.i18n('Bolu'));
INSERT into dem.state(code, country, name) VALUES ('BU','TR',i18n.i18n('Burdur'));
INSERT into dem.state(code, country, name) VALUES ('BS','TR',i18n.i18n('Bursa'));
INSERT into dem.state(code, country, name) VALUES ('CA','TR',i18n.i18n('Canakkale'));
INSERT into dem.state(code, country, name) VALUES ('CN','TR',i18n.i18n('Cankiri'));
INSERT into dem.state(code, country, name) VALUES ('CO','TR',i18n.i18n('Corum'));
INSERT into dem.state(code, country, name) VALUES ('DE','TR',i18n.i18n('Denizli'));
INSERT into dem.state(code, country, name) VALUES ('DI','TR',i18n.i18n('Diyarbakir'));
INSERT into dem.state(code, country, name) VALUES ('ED','TR',i18n.i18n('Edirne'));
INSERT into dem.state(code, country, name) VALUES ('EL','TR',i18n.i18n('Elazig'));
INSERT into dem.state(code, country, name) VALUES ('ER','TR',i18n.i18n('Erzincan'));
INSERT into dem.state(code, country, name) VALUES ('EZ','TR',i18n.i18n('Erzurum'));
INSERT into dem.state(code, country, name) VALUES ('ES','TR',i18n.i18n('Eskisehir'));
INSERT into dem.state(code, country, name) VALUES ('GA','TR',i18n.i18n('Gazi Antep'));
INSERT into dem.state(code, country, name) VALUES ('GI','TR',i18n.i18n('Giresun'));
INSERT into dem.state(code, country, name) VALUES ('GU','TR',i18n.i18n('Gumushane'));
INSERT into dem.state(code, country, name) VALUES ('HA','TR',i18n.i18n('Hakkari'));
INSERT into dem.state(code, country, name) VALUES ('HT','TR',i18n.i18n('Hatay'));
INSERT into dem.state(code, country, name) VALUES ('IC','TR',i18n.i18n('Icel'));
INSERT into dem.state(code, country, name) VALUES ('IG','TR',i18n.i18n('Igdir'));
INSERT into dem.state(code, country, name) VALUES ('IS','TR',i18n.i18n('Isparta'));
INSERT into dem.state(code, country, name) VALUES ('IT','TR',i18n.i18n('Istanbul'));
INSERT into dem.state(code, country, name) VALUES ('IZ','TR',i18n.i18n('Izmir'));
INSERT into dem.state(code, country, name) VALUES ('KM','TR',i18n.i18n('Kahraman Maras'));
INSERT into dem.state(code, country, name) VALUES ('KB','TR',i18n.i18n('Karabuk'));
INSERT into dem.state(code, country, name) VALUES ('KN','TR',i18n.i18n('Karaman'));
INSERT into dem.state(code, country, name) VALUES ('KA','TR',i18n.i18n('Kars'));
INSERT into dem.state(code, country, name) VALUES ('KT','TR',i18n.i18n('Kastamonu'));
INSERT into dem.state(code, country, name) VALUES ('KY','TR',i18n.i18n('Kayseri'));
INSERT into dem.state(code, country, name) VALUES ('KL','TR',i18n.i18n('Kilis'));
INSERT into dem.state(code, country, name) VALUES ('KR','TR',i18n.i18n('Kirikkale'));
INSERT into dem.state(code, country, name) VALUES ('KK','TR',i18n.i18n('Kirklareli'));
INSERT into dem.state(code, country, name) VALUES ('KS','TR',i18n.i18n('Kirsehir'));
INSERT into dem.state(code, country, name) VALUES ('KC','TR',i18n.i18n('Kocaeli'));
INSERT into dem.state(code, country, name) VALUES ('KO','TR',i18n.i18n('Konya'));
INSERT into dem.state(code, country, name) VALUES ('KU','TR',i18n.i18n('Kutahya'));
INSERT into dem.state(code, country, name) VALUES ('ML','TR',i18n.i18n('Malatya'));
INSERT into dem.state(code, country, name) VALUES ('MN','TR',i18n.i18n('Manisa'));
INSERT into dem.state(code, country, name) VALUES ('MR','TR',i18n.i18n('Mardin'));
INSERT into dem.state(code, country, name) VALUES ('MG','TR',i18n.i18n('Mugla'));
INSERT into dem.state(code, country, name) VALUES ('MS','TR',i18n.i18n('Mus'));
INSERT into dem.state(code, country, name) VALUES ('NE','TR',i18n.i18n('Nevsehir'));
INSERT into dem.state(code, country, name) VALUES ('NI','TR',i18n.i18n('Nigde'));
INSERT into dem.state(code, country, name) VALUES ('OR','TR',i18n.i18n('Ordu'));
INSERT into dem.state(code, country, name) VALUES ('OS','TR',i18n.i18n('Osmaniye'));
INSERT into dem.state(code, country, name) VALUES ('RI','TR',i18n.i18n('Rize'));
INSERT into dem.state(code, country, name) VALUES ('SA','TR',i18n.i18n('Sakarya'));
INSERT into dem.state(code, country, name) VALUES ('SM','TR',i18n.i18n('Samsun'));
INSERT into dem.state(code, country, name) VALUES ('SU','TR',i18n.i18n('Sanli Urfa'));
INSERT into dem.state(code, country, name) VALUES ('SI','TR',i18n.i18n('Siirt'));
INSERT into dem.state(code, country, name) VALUES ('SN','TR',i18n.i18n('Sinop'));
INSERT into dem.state(code, country, name) VALUES ('SR','TR',i18n.i18n('Sirnak'));
INSERT into dem.state(code, country, name) VALUES ('SV','TR',i18n.i18n('Sivas'));
INSERT into dem.state(code, country, name) VALUES ('TE','TR',i18n.i18n('Tekirdag'));
INSERT into dem.state(code, country, name) VALUES ('TO','TR',i18n.i18n('Tokat'));
INSERT into dem.state(code, country, name) VALUES ('TR','TR',i18n.i18n('Trabzon'));
INSERT into dem.state(code, country, name) VALUES ('TU','TR',i18n.i18n('Tunceli'));
INSERT into dem.state(code, country, name) VALUES ('US','TR',i18n.i18n('Usak'));
INSERT into dem.state(code, country, name) VALUES ('VA','TR',i18n.i18n('Van'));
INSERT into dem.state(code, country, name) VALUES ('YA','TR',i18n.i18n('Yalova'));
INSERT into dem.state(code, country, name) VALUES ('YO','TR',i18n.i18n('Yozgat'));
INSERT into dem.state(code, country, name) VALUES ('ZO','TR',i18n.i18n('Zonguldak'));
-- country TT
INSERT into dem.state(code, country, name) VALUES ('TT-1','TT',i18n.i18n('StateNameStub'));
-- country TV
INSERT into dem.state(code, country, name) VALUES ('TV-1','TV',i18n.i18n('StateNameStub'));
-- country TW
INSERT into dem.state(code, country, name) VALUES ('TW-1','TW',i18n.i18n('StateNameStub'));
-- country TZ
INSERT into dem.state(code, country, name) VALUES ('TZ-1','TZ',i18n.i18n('StateNameStub'));
-- country UA
INSERT into dem.state(code, country, name) VALUES ('KR','UA',i18n.i18n('Avtonomna Respublika Krym'));
INSERT into dem.state(code, country, name) VALUES ('CH','UA',i18n.i18n('Cherkas''ka'));
INSERT into dem.state(code, country, name) VALUES ('CE','UA',i18n.i18n('Chernihivs''ka'));
INSERT into dem.state(code, country, name) VALUES ('CR','UA',i18n.i18n('Chernivets''ka'));
INSERT into dem.state(code, country, name) VALUES ('DN','UA',i18n.i18n('Dnipropetrovs''ka'));
INSERT into dem.state(code, country, name) VALUES ('DO','UA',i18n.i18n('Donets''ka'));
INSERT into dem.state(code, country, name) VALUES ('IV','UA',i18n.i18n('Ivano-Frankivs''ka'));
INSERT into dem.state(code, country, name) VALUES ('KA','UA',i18n.i18n('Kharkivs''ka'));
INSERT into dem.state(code, country, name) VALUES ('KE','UA',i18n.i18n('Khersons''ka'));
INSERT into dem.state(code, country, name) VALUES ('KL','UA',i18n.i18n('Khmel''nyts|ka'));
INSERT into dem.state(code, country, name) VALUES ('KI','UA',i18n.i18n('Kirovohrads''ka'));
INSERT into dem.state(code, country, name) VALUES ('KY','UA',i18n.i18n('Kyyiv'));
INSERT into dem.state(code, country, name) VALUES ('KV','UA',i18n.i18n('Kyyivs''ka'));
INSERT into dem.state(code, country, name) VALUES ('LV','UA',i18n.i18n('L''vivs|ka'));
INSERT into dem.state(code, country, name) VALUES ('LU','UA',i18n.i18n('Luhans''ka'));
INSERT into dem.state(code, country, name) VALUES ('MY','UA',i18n.i18n('Mykolayivs''ka'));
INSERT into dem.state(code, country, name) VALUES ('OD','UA',i18n.i18n('Odes''ka'));
INSERT into dem.state(code, country, name) VALUES ('PO','UA',i18n.i18n('Poltavs''ka'));
INSERT into dem.state(code, country, name) VALUES ('RI','UA',i18n.i18n('Rivnens''ka'));
INSERT into dem.state(code, country, name) VALUES ('SE','UA',i18n.i18n('Sevastopol'''));
INSERT into dem.state(code, country, name) VALUES ('SU','UA',i18n.i18n('Sums''ka'));
INSERT into dem.state(code, country, name) VALUES ('TE','UA',i18n.i18n('Ternopil''s|ka'));
INSERT into dem.state(code, country, name) VALUES ('VI','UA',i18n.i18n('Vinnyts''ka'));
INSERT into dem.state(code, country, name) VALUES ('VO','UA',i18n.i18n('Volyns''ka'));
INSERT into dem.state(code, country, name) VALUES ('ZK','UA',i18n.i18n('Zakarpats''ka'));
INSERT into dem.state(code, country, name) VALUES ('ZP','UA',i18n.i18n('Zaporiz''ka'));
INSERT into dem.state(code, country, name) VALUES ('ZH','UA',i18n.i18n('Zhytomyrs''ka'));
-- country UG
INSERT into dem.state(code, country, name) VALUES ('UG-1','UG',i18n.i18n('StateNameStub'));
-- country UM
--INSERT into dem.state(code, country, name) VALUES ('UM-1','UM',i18n.i18n('StateNameStub'));
-- country US
INSERT into dem.state(code, country, name) VALUES ('AL','US',i18n.i18n('Alabama'));
INSERT into dem.state(code, country, name) VALUES ('AK','US',i18n.i18n('Alaska'));
INSERT into dem.state(code, country, name) VALUES ('AS','US',i18n.i18n('American Samoa'));
INSERT into dem.state(code, country, name) VALUES ('AZ','US',i18n.i18n('Arizona'));
INSERT into dem.state(code, country, name) VALUES ('AR','US',i18n.i18n('Arkansas'));
INSERT into dem.state(code, country, name) VALUES ('AF','US',i18n.i18n('Armed Forces Africa'));
INSERT into dem.state(code, country, name) VALUES ('AA','US',i18n.i18n('Armed Forces Americas'));
INSERT into dem.state(code, country, name) VALUES ('AC','US',i18n.i18n('Armed Forces Canada'));
INSERT into dem.state(code, country, name) VALUES ('AE','US',i18n.i18n('Armed Forces Europe'));
INSERT into dem.state(code, country, name) VALUES ('AM','US',i18n.i18n('Armed Forces Middle East'));
INSERT into dem.state(code, country, name) VALUES ('AP','US',i18n.i18n('Armed Forces Pacific'));
INSERT into dem.state(code, country, name) VALUES ('CA','US',i18n.i18n('California'));
INSERT into dem.state(code, country, name) VALUES ('CO','US',i18n.i18n('Colorado'));
INSERT into dem.state(code, country, name) VALUES ('CT','US',i18n.i18n('Connecticut'));
INSERT into dem.state(code, country, name) VALUES ('DE','US',i18n.i18n('Delaware'));
INSERT into dem.state(code, country, name) VALUES ('DC','US',i18n.i18n('District of Columbia'));
INSERT into dem.state(code, country, name) VALUES ('FM','US',i18n.i18n('Federated States Of Micronesia'));
INSERT into dem.state(code, country, name) VALUES ('FL','US',i18n.i18n('Florida'));
INSERT into dem.state(code, country, name) VALUES ('GA','US',i18n.i18n('Georgia'));
INSERT into dem.state(code, country, name) VALUES ('GU','US',i18n.i18n('Guam'));
INSERT into dem.state(code, country, name) VALUES ('HI','US',i18n.i18n('Hawaii'));
INSERT into dem.state(code, country, name) VALUES ('ID','US',i18n.i18n('Idaho'));
INSERT into dem.state(code, country, name) VALUES ('IL','US',i18n.i18n('Illinois'));
INSERT into dem.state(code, country, name) VALUES ('IN','US',i18n.i18n('Indiana'));
INSERT into dem.state(code, country, name) VALUES ('IA','US',i18n.i18n('Iowa'));
INSERT into dem.state(code, country, name) VALUES ('KS','US',i18n.i18n('Kansas'));
INSERT into dem.state(code, country, name) VALUES ('KY','US',i18n.i18n('Kentucky'));
INSERT into dem.state(code, country, name) VALUES ('LA','US',i18n.i18n('Louisiana'));
INSERT into dem.state(code, country, name) VALUES ('ME','US',i18n.i18n('Maine'));
INSERT into dem.state(code, country, name) VALUES ('MH','US',i18n.i18n('Marshall Islands'));
INSERT into dem.state(code, country, name) VALUES ('MD','US',i18n.i18n('Maryland'));
INSERT into dem.state(code, country, name) VALUES ('MA','US',i18n.i18n('Massachusetts'));
INSERT into dem.state(code, country, name) VALUES ('MI','US',i18n.i18n('Michigan'));
INSERT into dem.state(code, country, name) VALUES ('MN','US',i18n.i18n('Minnesota'));
INSERT into dem.state(code, country, name) VALUES ('MS','US',i18n.i18n('Mississippi'));
INSERT into dem.state(code, country, name) VALUES ('MO','US',i18n.i18n('Missouri'));
INSERT into dem.state(code, country, name) VALUES ('MT','US',i18n.i18n('Montana'));
INSERT into dem.state(code, country, name) VALUES ('NE','US',i18n.i18n('Nebraska'));
INSERT into dem.state(code, country, name) VALUES ('NV','US',i18n.i18n('Nevada'));
INSERT into dem.state(code, country, name) VALUES ('NH','US',i18n.i18n('New Hampshire'));
INSERT into dem.state(code, country, name) VALUES ('NJ','US',i18n.i18n('New Jersey'));
INSERT into dem.state(code, country, name) VALUES ('NM','US',i18n.i18n('New Mexico'));
INSERT into dem.state(code, country, name) VALUES ('NY','US',i18n.i18n('New York'));
INSERT into dem.state(code, country, name) VALUES ('NC','US',i18n.i18n('North Carolina'));
INSERT into dem.state(code, country, name) VALUES ('ND','US',i18n.i18n('North Dakota'));
INSERT into dem.state(code, country, name) VALUES ('MP','US',i18n.i18n('Northern Mariana Islands'));
INSERT into dem.state(code, country, name) VALUES ('OH','US',i18n.i18n('Ohio'));
INSERT into dem.state(code, country, name) VALUES ('OK','US',i18n.i18n('Oklahoma'));
INSERT into dem.state(code, country, name) VALUES ('OR','US',i18n.i18n('Oregon'));
INSERT into dem.state(code, country, name) VALUES ('PW','US',i18n.i18n('Palau'));
INSERT into dem.state(code, country, name) VALUES ('PA','US',i18n.i18n('Pennsylvania'));
INSERT into dem.state(code, country, name) VALUES ('PR','US',i18n.i18n('Puerto Rico'));
INSERT into dem.state(code, country, name) VALUES ('RI','US',i18n.i18n('Rhode Island'));
INSERT into dem.state(code, country, name) VALUES ('SC','US',i18n.i18n('South Carolina'));
INSERT into dem.state(code, country, name) VALUES ('SD','US',i18n.i18n('South Dakota'));
INSERT into dem.state(code, country, name) VALUES ('TN','US',i18n.i18n('Tennessee'));
INSERT into dem.state(code, country, name) VALUES ('TX','US',i18n.i18n('Texas'));
INSERT into dem.state(code, country, name) VALUES ('UT','US',i18n.i18n('Utah'));
INSERT into dem.state(code, country, name) VALUES ('VT','US',i18n.i18n('Vermont'));
INSERT into dem.state(code, country, name) VALUES ('VI','US',i18n.i18n('Virgin Islands'));
INSERT into dem.state(code, country, name) VALUES ('VA','US',i18n.i18n('Virginia'));
INSERT into dem.state(code, country, name) VALUES ('WA','US',i18n.i18n('Washington'));
INSERT into dem.state(code, country, name) VALUES ('WV','US',i18n.i18n('West Virginia'));
INSERT into dem.state(code, country, name) VALUES ('WI','US',i18n.i18n('Wisconsin'));
INSERT into dem.state(code, country, name) VALUES ('WY','US',i18n.i18n('Wyoming'));

-- country UY
insert into dem.country(code, name) values('UY', i18n.i18n('Uruguay'));

INSERT into dem.state(code, country, name) VALUES ('AR','UY',i18n.i18n('Artigas'));
INSERT into dem.state(code, country, name) VALUES ('CA','UY',i18n.i18n('Canelones'));
INSERT into dem.state(code, country, name) VALUES ('CL','UY',i18n.i18n('Cerro Largo'));
INSERT into dem.state(code, country, name) VALUES ('CO','UY',i18n.i18n('Colonia'));
INSERT into dem.state(code, country, name) VALUES ('DU','UY',i18n.i18n('Durazno'));
INSERT into dem.state(code, country, name) VALUES ('FL','UY',i18n.i18n('Flores'));
INSERT into dem.state(code, country, name) VALUES ('FO','UY',i18n.i18n('Florida'));
INSERT into dem.state(code, country, name) VALUES ('LA','UY',i18n.i18n('Lavalleja'));
INSERT into dem.state(code, country, name) VALUES ('MA','UY',i18n.i18n('Maldonado'));
INSERT into dem.state(code, country, name) VALUES ('MO','UY',i18n.i18n('Montevideo'));
INSERT into dem.state(code, country, name) VALUES ('PA','UY',i18n.i18n('Paysandu'));
INSERT into dem.state(code, country, name) VALUES ('RN','UY',i18n.i18n('Rio Negro'));
INSERT into dem.state(code, country, name) VALUES ('RI','UY',i18n.i18n('Rivera'));
INSERT into dem.state(code, country, name) VALUES ('RO','UY',i18n.i18n('Rocha'));
INSERT into dem.state(code, country, name) VALUES ('SA','UY',i18n.i18n('Salto'));
INSERT into dem.state(code, country, name) VALUES ('SJ','UY',i18n.i18n('San Jose'));
INSERT into dem.state(code, country, name) VALUES ('SO','UY',i18n.i18n('Soriano'));
INSERT into dem.state(code, country, name) VALUES ('TA','UY',i18n.i18n('Tacuarembo'));
INSERT into dem.state(code, country, name) VALUES ('TT','UY',i18n.i18n('Treinta y Tres'));
-- country UZ
--INSERT into dem.state(code, country, name) VALUES ('UZ-1','UZ',i18n.i18n('StateNameStub'));
-- country VA
INSERT into dem.state(code, country, name) VALUES ('VA-1','VA',i18n.i18n('StateNameStub'));
-- country VC
INSERT into dem.state(code, country, name) VALUES ('VC-1','VC',i18n.i18n('StateNameStub'));

-- country VE
insert into dem.country(code, name) values('VE', i18n.i18n('Venezuelas'));

INSERT into dem.state(code, country, name) VALUES ('AM','VE',i18n.i18n('Amazonas'));
INSERT into dem.state(code, country, name) VALUES ('AN','VE',i18n.i18n('Anzoategui'));
INSERT into dem.state(code, country, name) VALUES ('AP','VE',i18n.i18n('Apure'));
INSERT into dem.state(code, country, name) VALUES ('AR','VE',i18n.i18n('Aragua'));
INSERT into dem.state(code, country, name) VALUES ('BA','VE',i18n.i18n('Barinas'));
INSERT into dem.state(code, country, name) VALUES ('BO','VE',i18n.i18n('Bolivar'));
INSERT into dem.state(code, country, name) VALUES ('CA','VE',i18n.i18n('Carabobo'));
INSERT into dem.state(code, country, name) VALUES ('CO','VE',i18n.i18n('Cojedes'));
INSERT into dem.state(code, country, name) VALUES ('DA','VE',i18n.i18n('Delta Amacuro'));
INSERT into dem.state(code, country, name) VALUES ('DF','VE',i18n.i18n('Dependencias Federales'));
INSERT into dem.state(code, country, name) VALUES ('DI','VE',i18n.i18n('Distrito Federal'));
INSERT into dem.state(code, country, name) VALUES ('FA','VE',i18n.i18n('Falcon'));
INSERT into dem.state(code, country, name) VALUES ('GU','VE',i18n.i18n('Guarico'));
INSERT into dem.state(code, country, name) VALUES ('LA','VE',i18n.i18n('Lara'));
INSERT into dem.state(code, country, name) VALUES ('ME','VE',i18n.i18n('Merida'));
INSERT into dem.state(code, country, name) VALUES ('MI','VE',i18n.i18n('Miranda'));
INSERT into dem.state(code, country, name) VALUES ('MO','VE',i18n.i18n('Monagas'));
INSERT into dem.state(code, country, name) VALUES ('NE','VE',i18n.i18n('Nueva Esparta'));
INSERT into dem.state(code, country, name) VALUES ('PO','VE',i18n.i18n('Portuguesa'));
INSERT into dem.state(code, country, name) VALUES ('SU','VE',i18n.i18n('Sucre'));
INSERT into dem.state(code, country, name) VALUES ('TA','VE',i18n.i18n('Tachira'));
INSERT into dem.state(code, country, name) VALUES ('TR','VE',i18n.i18n('Trujillo'));
INSERT into dem.state(code, country, name) VALUES ('YA','VE',i18n.i18n('Yaracuy'));
INSERT into dem.state(code, country, name) VALUES ('ZU','VE',i18n.i18n('Zulia'));
-- country VG
--INSERT into dem.state(code, country, name) VALUES ('VG-1','VG',i18n.i18n('StateNameStub'));
-- country VI
--INSERT into dem.state(code, country, name) VALUES ('VI-1','VI',i18n.i18n('StateNameStub'));
-- country VN
--INSERT into dem.state(code, country, name) VALUES ('VN-1','VN',i18n.i18n('StateNameStub'));
-- country VU
--INSERT into dem.state(code, country, name) VALUES ('VU-1','VU',i18n.i18n('StateNameStub'));
-- country WF
--INSERT into dem.state(code, country, name) VALUES ('WF-1','WF',i18n.i18n('StateNameStub'));
-- country WS
--INSERT into dem.state(code, country, name) VALUES ('WS-1','WS',i18n.i18n('StateNameStub'));

-- country YE
insert into dem.country(code, name) values('YE', i18n.i18n('Yemen'));

INSERT into dem.state(code, country, name) VALUES ('AD','YE',i18n.i18n('Adan'));
INSERT into dem.state(code, country, name) VALUES ('AT','YE',i18n.i18n('Ataq'));
INSERT into dem.state(code, country, name) VALUES ('AB','YE',i18n.i18n('Abyan'));
INSERT into dem.state(code, country, name) VALUES ('AL','YE',i18n.i18n('Al Bayda'''));
INSERT into dem.state(code, country, name) VALUES ('AH','YE',i18n.i18n('Al Hudaydah'));
INSERT into dem.state(code, country, name) VALUES ('AJ','YE',i18n.i18n('Al Jawf'));
INSERT into dem.state(code, country, name) VALUES ('AM','YE',i18n.i18n('Al Mahrah'));
INSERT into dem.state(code, country, name) VALUES ('AW','YE',i18n.i18n('Al Mahwit'));
INSERT into dem.state(code, country, name) VALUES ('DH','YE',i18n.i18n('Dhamar'));
INSERT into dem.state(code, country, name) VALUES ('HA','YE',i18n.i18n('Hadhramawt'));
INSERT into dem.state(code, country, name) VALUES ('HJ','YE',i18n.i18n('Hajjah'));
INSERT into dem.state(code, country, name) VALUES ('IB','YE',i18n.i18n('Ibb'));
INSERT into dem.state(code, country, name) VALUES ('LA','YE',i18n.i18n('Lahij'));
INSERT into dem.state(code, country, name) VALUES ('MA','YE',i18n.i18n('Ma''rib'));
INSERT into dem.state(code, country, name) VALUES ('SA','YE',i18n.i18n('Sa''dah'));
INSERT into dem.state(code, country, name) VALUES ('SN','YE',i18n.i18n('San''a|'));
INSERT into dem.state(code, country, name) VALUES ('TA','YE',i18n.i18n('Ta''izz'));
-- country YT
--INSERT into dem.state(code, country, name) VALUES ('YT-1','YT',i18n.i18n('StateNameStub'));
-- country YU
--INSERT into dem.state(code, country, name) VALUES ('KO','YU',i18n.i18n('Kosovo'));
--INSERT into dem.state(code, country, name) VALUES ('MO','YU',i18n.i18n('Montenegro'));
--INSERT into dem.state(code, country, name) VALUES ('SE','YU',i18n.i18n('Serbia'));
--INSERT into dem.state(code, country, name) VALUES ('VO','YU',i18n.i18n('Vojvodina'));
-- country ZA
INSERT into dem.state(code, country, name) VALUES ('EC','ZA',i18n.i18n('Eastern Cape'));
INSERT into dem.state(code, country, name) VALUES ('FS','ZA',i18n.i18n('Free State'));
INSERT into dem.state(code, country, name) VALUES ('GA','ZA',i18n.i18n('Gauteng'));
INSERT into dem.state(code, country, name) VALUES ('KN','ZA',i18n.i18n('KwaZulu-Natal'));
INSERT into dem.state(code, country, name) VALUES ('MP','ZA',i18n.i18n('Mpumalanga'));
INSERT into dem.state(code, country, name) VALUES ('NW','ZA',i18n.i18n('North-West'));
INSERT into dem.state(code, country, name) VALUES ('NC','ZA',i18n.i18n('Northern Cape'));
INSERT into dem.state(code, country, name) VALUES ('NP','ZA',i18n.i18n('Northern Province'));
INSERT into dem.state(code, country, name) VALUES ('WC','ZA',i18n.i18n('Western Cape'));

-- country ZM
insert into dem.country(code, name) values('ZM', i18n.i18n('Zambia'));

INSERT into dem.state(code, country, name) VALUES ('CE','ZM',i18n.i18n('Central'));
INSERT into dem.state(code, country, name) VALUES ('CO','ZM',i18n.i18n('Copperbelt'));
INSERT into dem.state(code, country, name) VALUES ('EA','ZM',i18n.i18n('Eastern'));
INSERT into dem.state(code, country, name) VALUES ('LU','ZM',i18n.i18n('Luapula'));
INSERT into dem.state(code, country, name) VALUES ('LS','ZM',i18n.i18n('Lusaka'));
INSERT into dem.state(code, country, name) VALUES ('NW','ZM',i18n.i18n('North-Western'));
INSERT into dem.state(code, country, name) VALUES ('NO','ZM',i18n.i18n('Northern'));
INSERT into dem.state(code, country, name) VALUES ('SO','ZM',i18n.i18n('Southern'));
INSERT into dem.state(code, country, name) VALUES ('WE','ZM',i18n.i18n('Western'));

-- country ZR
--INSERT into dem.state(code, country, name) VALUES ('ZR-1','ZR',i18n.i18n('StateNameStub'));

-- country ZW
insert into dem.country(code, name) values('ZW', i18n.i18n('Zimbabwe'));

INSERT into dem.state(code, country, name) VALUES ('BU','ZW',i18n.i18n('Bulawayo'));
INSERT into dem.state(code, country, name) VALUES ('HA','ZW',i18n.i18n('Harare'));
INSERT into dem.state(code, country, name) VALUES ('MA','ZW',i18n.i18n('Manicaland'));
INSERT into dem.state(code, country, name) VALUES ('MC','ZW',i18n.i18n('Mashonaland Central'));
INSERT into dem.state(code, country, name) VALUES ('ME','ZW',i18n.i18n('Mashonaland East'));
INSERT into dem.state(code, country, name) VALUES ('MW','ZW',i18n.i18n('Mashonaland West'));
INSERT into dem.state(code, country, name) VALUES ('MV','ZW',i18n.i18n('Masvingo'));
INSERT into dem.state(code, country, name) VALUES ('MN','ZW',i18n.i18n('Matabeleland North'));
INSERT into dem.state(code, country, name) VALUES ('MS','ZW',i18n.i18n('Matabeleland South'));
INSERT into dem.state(code, country, name) VALUES ('MI','ZW',i18n.i18n('Midlands'));

-- =============================================
-- do simple schema revision tracking
select log_script_insertion('$RCSfile: gmCountryZones.sql,v $', '$Revision: 1.4 $');

-- =============================================
-- $Log: gmCountryZones.sql,v $
-- Revision 1.4  2006-01-09 13:46:19  ncq
-- - adjust to schema "i18n" qualification
--
-- Revision 1.3  2006/01/06 10:12:02  ncq
-- - add missing grants
-- - add_table_for_audit() now in "audit" schema
-- - demographics now in "dem" schema
-- - add view v_inds4vaccine
-- - move staff_role from clinical into demographics
-- - put add_coded_term() into "clin" schema
-- - put German things into "de_de" schema
--
-- Revision 1.2  2005/10/12 22:29:11  ncq
-- - comment out states/add in countries which (would) error out
--
-- Revision 1.1  2005/09/25 17:45:16  ncq
-- - we now got states for pretty much every country
--
--