Creare il database SQLite delle località

SQLite3 utilizza la normale sintassi SQL. Le operazioni di creazione, inserimento, lettura, modifica e cancellazione dei record avvengono, come per altri database, con istruzioni SQL tipo:

CREATE TABLE tabella  ( campo1 int, campo2 text, ... campo n blob);
SELECT * FROM tabella WHERE campo2 like 'xxx';
INSERT INTO tabella (campo1, campo2 ...) VALUES (x1, x2, x3);

non voglio dilungarmi eccessivamente sulla sintassi SQL, quanto piuttosto andare a realizzare la creazione di un database pronto uso.

Il file allNew.txt è già formattato correttamente. Per creare il database possiamo usare il tool in linea di comando che si scarica dal sito di SQLite3. L'eseguibile sarà naturalmente quello specifico di ogni piattaforma, Windows, Linux, MacOS.

L'operazione di trasferimento è molto semplice e si puo' effettuare in linea di comando. Si apre sqlite3 seguito dal nome del file, che possiamo chiamare semplicemente localita.db:

sqlite3 localita.db

procediamo alla creazione della tabella che conterrà le località, che chiamiamo 'luoghi'

CREATE TABLE luoghi (nome_unicode text, nome_ascii text, latitudine real, longitudine real, paese text, regione text, popolazione int, timezone text);

sempre all'interno dell'applicazione digitiamo .help per avere la lista dei comandi specifici di sqlite3, tra cui troviamo: .separator e .import

.separator indica il carattere usato come separatore, tanto nel file csv da cui importiamo i dati, tanto nel formato di stampa a video dopo una query. Si puo' definire in vario modo, noi usiamo il ";".

il comando è pertanto:

.separator ";"

per l'import si puo' digitare :

.import nome_del_file_csv nome_della tabella

quindi nel nostro caso:

.import allNew.csv luoghi

purtroppo in fase di import si è verificato un errore proprio alla fine del file, per cui la tabella non è stata creata, ho ovviato usando la funzione di import del programma sqliteman, di cui vi avevo già parlato, che ha portato a termine l'operazione senza inconvenienti

il database finale, con circa 317.000 località (comprese le grandi aggregazioni nazionali e regionali), pesa circa 24 mega su hard-disk, non proprio uno scherzo.

Per darvi modo di creare un database di prova, ho fatto il dump del database (ho cioè convertito una tabella in istruzioni SQL, limitatamente alle località con più di un milione di abitanti) in un file:

copiate le seguenti istruzioni SQL in un file di testo, diciamo provadb.txt sul vostro hard disk, e poi digitate il seguente comando:

 sqlite3 prova.db < provadb.txt

il database, molto più snello, diventerà immediatamente fruibile. Lo useremo in uno dei prossimi post quando costruiremo l'interfaccia per la gestione dei dati delle località

PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE local(
  nome_unicode TEXT,
  nome_ascii TEXT,
  latitudine REAL,
  longitudine REAL,
  paese TEXT,
  regione TEXT,
  popolazione INT,
  timezone TEXT
);
INSERT INTO "local" VALUES('United Arab Emirates','United Arab Emirates',23.75,54.5,'AE','00',4975593,'Asia/Dubai');
INSERT INTO "local" VALUES('Dubai','Dubai',25.25817,55.30472,'AE','03',1137347,'Asia/Dubai');
INSERT INTO "local" VALUES('Dubayy','Dubayy',25.0,55.33333,'AE','03',1141963,'Asia/Dubai');
INSERT INTO "local" VALUES('Abū Z̧aby','Abu Zaby',23.66667,54.0,'AE','01',1395899,'Asia/Dubai');
INSERT INTO "local" VALUES('Nangarhār','Nangarhar',34.33333,70.41667,'AF','18',1538444,'Asia/Kabul');
INSERT INTO "local" VALUES('Kandahār','Kandahar',31.0,65.75,'AF','23',1665487,'Asia/Kabul');
INSERT INTO "local" VALUES('Wilāyat-e Kābul','Wilayat-e Kabul',34.5,69.41667,'AF','13',3138338,'Asia/Kabul');
INSERT INTO "local" VALUES('Kabul','Kabul',34.52813,69.17233,'AF','13',3043532,'Asia/Kabul');
INSERT INTO "local" VALUES('Herāt','Herat',34.5,62.0,'AF','11',1382139,'Asia/Kabul');
INSERT INTO "local" VALUES('Balkh','Balkh',36.75,67.0,'AF','30',1245100,'Asia/Kabul');
INSERT INTO "local" VALUES('Badakhshān','Badakhshan',36.75,72.0,'AF','01',1062937,'Asia/Kabul');
INSERT INTO "local" VALUES('Islamic Republic of Afghanistan','Islamic Republic of Afghanistan',33.0,66.0,'AF','00',29121286,'Asia/Kabul');
INSERT INTO "local" VALUES('Republic of Albania','Republic of Albania',41.0,20.0,'AL','00',2986952,'Europe/Tirane');
INSERT INTO "local" VALUES('Republic of Armenia','Republic of Armenia',40.25,45.0,'AM','00',2968000,'Asia/Yerevan');
INSERT INTO "local" VALUES('Yerevan','Yerevan',40.18111,44.51361,'AM','11',1093485,'Asia/Yerevan');
INSERT INTO "local" VALUES('Luanda','Luanda',-8.83682,13.23432,'AO','20',2776168,'Africa/Luanda');
INSERT INTO "local" VALUES('Republic of Angola','Republic of Angola',-12.5,18.5,'AO','00',13068161,'Africa/Luanda');
INSERT INTO "local" VALUES('Partido de La Matanza','Partido de La Matanza',-34.75,-58.58333,'AR','01',1772130,'America/Argentina/Buenos_Aires');
INSERT INTO "local" VALUES('Ciudad Autónoma de Buenos Aires','Ciudad Autonoma de Buenos Aires',-34.6,-58.45,'AR','07',2776138,'America/Argentina/Buenos_Aires');
INSERT INTO "local" VALUES('Provincia de Entre Ríos','Provincia de Entre Rios',-32.0,-59.0,'AR','08',1158147,'America/Argentina/Cordoba');
INSERT INTO "local" VALUES('Provincia de Buenos Aires','Provincia de Buenos Aires',-36.0,-60.0,'AR','01',13827203,'America/Argentina/Buenos_Aires');
INSERT INTO "local" VALUES('Buenos Aires','Buenos Aires',-34.61315,-58.37723,'AR','07',13076300,'America/Argentina/Buenos_Aires');
INSERT INTO "local" VALUES('Provincia de Tucumán','Provincia de Tucuman',-27.0,-65.5,'AR','24',1338523,'America/Argentina/Tucuman');
INSERT INTO "local" VALUES('Provincia de Santa Fe','Provincia de Santa Fe',-31.0,-61.0,'AR','21',3000701,'America/Argentina/Cordoba');
INSERT INTO "local" VALUES('Provincia de Salta','Provincia de Salta',-24.75806,-65.43457,'AR','17',1079051,'America/Argentina/Salta');
INSERT INTO "local" VALUES('Rosario','Rosario',-32.94682,-60.63932,'AR','21',1173533,'America/Argentina/Cordoba');
INSERT INTO "local" VALUES('Provincia de Mendoza','Provincia de Mendoza',-34.5,-68.5,'AR','13',1579651,'America/Argentina/Mendoza');
INSERT INTO "local" VALUES('Provincia de Córdoba','Provincia de Cordoba',-32.0,-64.0,'AR','05',3066801,'America/Argentina/Cordoba');
INSERT INTO "local" VALUES('Córdoba','Cordoba',-31.4135,-64.18105,'AR','05',1428214,'America/Argentina/Cordoba');
INSERT INTO "local" VALUES('Argentine Republic','Argentine Republic',-34.0,-64.0,'AR','00',41343201,NULL);
INSERT INTO "local" VALUES('Wien','Wien',48.2082,16.37169,'AT','09',1569316,'Europe/Vienna');
INSERT INTO "local" VALUES('Vienna','Vienna',48.20849,16.37208,'AT','09',1691468,'Europe/Vienna');
INSERT INTO "local" VALUES('Steiermark','Steiermark',47.25,15.16667,'AT','06',1185175,'Europe/Vienna');
INSERT INTO "local" VALUES('Oberösterreich','Oberoesterreich',48.25,14.0,'AT','04',1400851,'Europe/Vienna');
INSERT INTO "local" VALUES('Niederösterreich','Niederoesterreich',48.33333,15.75,'AT','03',1576622,'Europe/Vienna');
INSERT INTO "local" VALUES('Republic of Austria','Republic of Austria',47.33333,13.33333,'AT','00',8205000,'Europe/Vienna');
INSERT INTO "local" VALUES('State of Western Australia','State of Western Australia',-25.0,122.0,'AU','08',2239170,'Australia/Perth');
INSERT INTO "local" VALUES('State of South Australia','State of South Australia',-30.0,135.0,'AU','05',1596572,'Australia/Adelaide');
INSERT INTO "local" VALUES('Perth','Perth',-31.95224,115.8614,'AU','08',1896548,'Australia/Perth');
INSERT INTO "local" VALUES('Commonwealth of Australia','Commonwealth of Australia',-25.0,135.0,'AU','00',21515754,NULL);
INSERT INTO "local" VALUES('Adelaide','Adelaide',-34.92866,138.59863,'AU','05',1225235,'Australia/Adelaide');
INSERT INTO "local" VALUES('State of Victoria','State of Victoria',-37.0,145.0,'AU','07',5354042,'Australia/Melbourne');
INSERT INTO "local" VALUES('Sydney','Sydney',-33.86785,151.20732,'AU','02',4627345,'Australia/Sydney');
INSERT INTO "local" VALUES('State of Queensland','State of Queensland',-20.0,145.0,'AU','04',4332739,'Australia/Brisbane');
INSERT INTO "local" VALUES('State of New South Wales','State of New South Wales',-33.0,146.0,'AU','02',6917658,'Australia/Sydney');
INSERT INTO "local" VALUES('Melbourne','Melbourne',-37.814,144.96332,'AU','07',4246375,'Australia/Melbourne');
INSERT INTO "local" VALUES('Brisbane','Brisbane',-27.46794,153.02809,'AU','04',2189878,'Australia/Brisbane');
INSERT INTO "local" VALUES('Baku','Baku',40.37767,49.89201,'AZ','09',1116513,'Asia/Baku');
INSERT INTO "local" VALUES('Republic of Azerbaijan','Republic of Azerbaijan',40.5,47.5,'AZ','00',8303512,'Asia/Baku');
INSERT INTO "local" VALUES('Bosnia and Herzegovina','Bosnia and Herzegovina',44.25,17.83333,'BA','00',4590000,'Europe/Sarajevo');
INSERT INTO "local" VALUES('Kushtia District','Kushtia District',23.83333,88.91667,'BD','82',1867660,'Asia/Dhaka');
INSERT INTO "local" VALUES('Dhaka','Dhaka',23.7104,90.40744,'BD','81',10356500,'Asia/Dhaka');
INSERT INTO "local" VALUES('Barisāl District','Barisal District',22.8,90.5,'BD','85',2291000,'Asia/Dhaka');
INSERT INTO "local" VALUES('Chittagong','Chittagong',22.3384,91.83168,'BD','84',3920222,'Asia/Dhaka');
INSERT INTO "local" VALUES('Bangladesh','Bangladesh',24.0,90.0,'BD','00',156118464,'Asia/Dhaka');
INSERT INTO "local" VALUES('Khulna','Khulna',22.80978,89.56439,'BD','82',1342339,'Asia/Dhaka');
INSERT INTO "local" VALUES('Thākurgaon District','Thakurgaon District',25.96667,88.33333,'BD','87',1318803,'Asia/Dhaka');
INSERT INTO "local" VALUES('Dinājpur District','Dinajpur District',25.61667,88.75,'BD','87',2860954,'Asia/Dhaka');
INSERT INTO "local" VALUES('Nilphāmāri District','Nilphamari District',25.96667,88.95,'BD','87',1689502,'Asia/Dhaka');
INSERT INTO "local" VALUES('Kurīgrām District','Kurigram District',25.75,89.66667,'BD','87',1918899,'Asia/Dhaka');
INSERT INTO "local" VALUES('Rangpur District','Rangpur District',25.6,89.25,'BD','87',2780661,'Asia/Dhaka');
INSERT INTO "local" VALUES('Naogaon','Naogaon',24.8118,88.94657,'BD','83',2555187,'Asia/Dhaka');
INSERT INTO "local" VALUES('Bogra District','Bogra District',24.78333,89.35,'BD','83',2988567,'Asia/Dhaka');
INSERT INTO "local" VALUES('Chapai Nawābganj District','Chapai Nawabganj District',24.68333,88.25,'BD','83',1576737,'Asia/Dhaka');
INSERT INTO "local" VALUES('Rājshāhi District','Rajshahi District',25.0,89.0,'BD','83',2262483,'Asia/Dhaka');
INSERT INTO "local" VALUES('Nator District','Nator District',24.35,89.08333,'BD','83',1629145,'Asia/Dhaka');
INSERT INTO "local" VALUES('Sirājganj District','Sirajganj District',24.33333,89.61667,'BD','83',2994053,'Asia/Dhaka');
INSERT INTO "local" VALUES('Pābna District','Pabna District',24.00633,89.33533,'BD','83',2153921,'Asia/Dhaka');
INSERT INTO "local" VALUES('Sherpur District','Sherpur District',25.08333,90.08333,'BD','81',1246511,'Asia/Dhaka');
INSERT INTO "local" VALUES('Netrakona District','Netrakona District',24.86667,90.86667,'BD','81',2101723,'Asia/Dhaka');
INSERT INTO "local" VALUES('Jamālpur District','Jamalpur District',25.0,89.83333,'BD','81',2089366,'Asia/Dhaka');
INSERT INTO "local" VALUES('Mymensingh District','Mymensingh District',24.75,90.4,'BD','81',5042000,'Asia/Dhaka');
INSERT INTO "local" VALUES('Tangail District','Tangail District',24.33853,89.98667,'BD','81',3485936,'Asia/Dhaka');
INSERT INTO "local" VALUES('Gāzipur District','Gazipur District',25.25,89.5,'BD','81',2287066,'Asia/Dhaka');
INSERT INTO "local" VALUES('Kishorganj District','Kishorganj District',24.41667,90.95,'BD','81',2715438,'Asia/Dhaka');
INSERT INTO "local" VALUES('Narsingdi District','Narsingdi District',24.0,90.83333,'BD','81',2202000,'Asia/Dhaka');
INSERT INTO "local" VALUES('Rājbāri District','Rajbari District',23.66667,89.55,'BD','81',1021321,'Asia/Dhaka');
INSERT INTO "local" VALUES('Farīdpur District','Faridpur District',23.41667,90.16667,'BD','81',1714496,'Asia/Dhaka');
INSERT INTO "local" VALUES('Nārāyanganj District','Narayanganj District',23.75,90.58333,'BD','81',2897000,'Asia/Dhaka');
INSERT INTO "local" VALUES('Munshiganj District','Munshiganj District',23.55,90.36667,'BD','81',1420000,'Asia/Dhaka');
INSERT INTO "local" VALUES('Gopālganj District','Gopalganj District',23.16667,89.91667,'BD','81',1172415,'Asia/Dhaka');
INSERT INTO "local" VALUES('Mādārīpur District','Madaripur District',23.25,90.2,'BD','81',1137008,'Asia/Dhaka');
INSERT INTO "local" VALUES('Sunāmganj District','Sunamganj District',24.86667,91.41667,'BD','86',1968669,'Asia/Dhaka');
INSERT INTO "local" VALUES('Sylhet District','Sylhet District',24.91667,91.76667,'BD','86',2675346,'Asia/Dhaka');
INSERT INTO "local" VALUES('Moulvibāzār District','Moulvibazar District',24.5,91.83333,'BD','86',1604028,'Asia/Dhaka');
INSERT INTO "local" VALUES('Habiganj District','Habiganj District',24.43333,91.41667,'BD','86',1911387,'Asia/Dhaka');
INSERT INTO "local" VALUES('Brāhmanbāria District','Brahmanbaria District',23.98333,91.16667,'BD','84',2141745,'Asia/Dhaka');
INSERT INTO "local" VALUES('Comilla District','Comilla District',23.4417,91.00987,'BD','84',4963682,'Asia/Dhaka');
INSERT INTO "local" VALUES('Chāndpur District','Chandpur District',23.25,90.83333,'BD','84',2416018,'Asia/Dhaka');
INSERT INTO "local" VALUES('Lakshmipur District','Lakshmipur District',22.91667,90.83333,'BD','84',1594279,'Asia/Dhaka');
INSERT INTO "local" VALUES('Noākhāli District','Noakhali District',22.75,91.16667,'BD','84',2741743,'Asia/Dhaka');
INSERT INTO "local" VALUES('Feni District','Feni District',22.96667,91.31667,'BD','84',1275195,'Asia/Dhaka');
INSERT INTO "local" VALUES('Chittagong District','Chittagong District',22.4875,91.96333,'BD','84',7509000,'Asia/Dhaka');
INSERT INTO "local" VALUES('Chittagong','Chittagong',22.91667,91.5,'BD','84',20522459,'Asia/Dhaka');
INSERT INTO "local" VALUES('Cox’s Bāzār District','Cox''s Bazar District',21.58389,92.01528,'BD','84',1419260,'Asia/Dhaka');
INSERT INTO "local" VALUES('Jhenaidah District','Jhenaidah District',23.5,89.16667,'BD','82',1771304,'Asia/Dhaka');
INSERT INTO "local" VALUES('Jessore District','Jessore District',23.08333,89.16667,'BD','82',2764547,'Asia/Dhaka');
INSERT INTO "local" VALUES('Khulna District','Khulna District',22.5,89.33333,'BD','82',2334285,'Asia/Dhaka');
INSERT INTO "local" VALUES('Sātkhira District','Satkhira District',22.35,89.15,'BD','82',2018568,'Asia/Dhaka');
INSERT INTO "local" VALUES('Bhola District','Bhola District',22.36667,90.81667,'BD','85',1758000,'Asia/Dhaka');
INSERT INTO "local" VALUES('Patuākhāli District','Patuakhali District',22.33333,90.33333,'BD','85',1464685,'Asia/Dhaka');
INSERT INTO "local" VALUES('Mānikganj District','Manikganj District',23.86667,89.95,'BD','81',1366514,'Asia/Dhaka');
INSERT INTO "local" VALUES('Sylhet Division','Sylhet Division',24.5,91.66667,'BD','86',6765039,'Asia/Dhaka');
INSERT INTO "local" VALUES('Pirojpur District','Pirojpur District',22.53671,90.00033,'BD','85',1222980,'Asia/Dhaka');
INSERT INTO "local" VALUES('Rangpur Division','Rangpur Division',25.83333,89.0,'BD','87',16412287,'Asia/Dhaka');
INSERT INTO "local" VALUES('Provincie West-Vlaanderen','Provincie West-Vlaanderen',51.0,3.0,'BE','VLG',1136692,'Europe/Brussels');
INSERT INTO "local" VALUES('Provincie Oost-Vlaanderen','Provincie Oost-Vlaanderen',51.0,3.75,'BE','VLG',1376407,'Europe/Brussels');
INSERT INTO "local" VALUES('Brussels','Brussels',50.85045,4.34878,'BE','BRU',1019022,'Europe/Brussels');
INSERT INTO "local" VALUES('Bruxelles-Capitale','Bruxelles-Capitale',50.85332,4.35144,'BE','BRU',1830000,'Europe/Brussels');
INSERT INTO "local" VALUES('Kingdom of Belgium','Kingdom of Belgium',50.75,4.5,'BE','00',10403000,'Europe/Brussels');
INSERT INTO "local" VALUES('Provincie Vlaams-Brabant','Provincie Vlaams-Brabant',50.91667,4.58333,'BE','VLG',1037335,'Europe/Brussels');
INSERT INTO "local" VALUES('Flanders','Flanders',51.0,4.5,'BE','VLG',6350765,'Europe/Brussels');
INSERT INTO "local" VALUES('Ouagadougou','Ouagadougou',12.36566,-1.53388,'BF','03',1086505,'Africa/Ouagadougou');
INSERT INTO "local" VALUES('Kadiogo Province','Kadiogo Province',12.33333,-1.5,'BF','03',1365958,'Africa/Ouagadougou');
INSERT INTO "local" VALUES('Burkina Faso','Burkina Faso',12.5,-1.66667,'BF','00',16241811,'Africa/Ouagadougou');
INSERT INTO "local" VALUES('Boucle du Mouhoun Region','Boucle du Mouhoun Region',12.47203,-3.47305,'BF','01',1434847,'Africa/Ouagadougou');
INSERT INTO "local" VALUES('High-Basins Region','High-Basins Region',11.28,-4.32,'BF','09',1410284,'Africa/Ouagadougou');
INSERT INTO "local" VALUES('Sofia','Sofia',42.69751,23.32415,'BG','42',1152556,'Europe/Sofia');
INSERT INTO "local" VALUES('Sofiya','Sofiya',42.65,23.63333,'BG','58',1241396,'Europe/Sofia');
INSERT INTO "local" VALUES('Republic of Bulgaria','Republic of Bulgaria',42.66667,25.25,'BG','00',7148785,'Europe/Sofia');
INSERT INTO "local" VALUES('Stolichna Obshtina','Stolichna Obshtina',42.68647,23.30561,'BG','42',1318791,'Europe/Sofia');
INSERT INTO "local" VALUES('Republic of Burundi','Republic of Burundi',-3.5,30.0,'BI','00',9863117,'Africa/Bujumbura');
INSERT INTO "local" VALUES('Republic of Benin','Republic of Benin',9.5,2.25,'BJ','00',9056010,'Africa/Porto-Novo');
INSERT INTO "local" VALUES('Santa Cruz de la Sierra','Santa Cruz de la Sierra',-17.78629,-63.18117,'BO','08',1364389,'America/La_Paz');
INSERT INTO "local" VALUES('Plurinational State of Bolivia','Plurinational State of Bolivia',-17.0,-65.0,'BO','00',9947418,'America/La_Paz');
INSERT INTO "local" VALUES('Estado do Rio Grande do Norte','Estado do Rio Grande do Norte',-5.75,-36.0,'BR','22',3168133,'America/Recife');
INSERT INTO "local" VALUES('Recife','Recife',-8.05389,-34.88111,'BR','30',1478098,'America/Recife');
INSERT INTO "local" VALUES('Estado do Piauí','Estado do Piaui',-7.0,-43.0,'BR','20',3119015,'America/Araguaina');
INSERT INTO "local" VALUES('Estado de Pernambuco','Estado de Pernambuco',-8.0,-37.0,'BR','30',8796032,'America/Recife');
INSERT INTO "local" VALUES('Estado da Paraíba','Estado da Paraiba',-7.25,-36.5,'BR','17',3766834,'America/Recife');
INSERT INTO "local" VALUES('Estado do Pará','Estado do Para',-4.0,-53.0,'BR','16',7588078,'America/Manaus');
INSERT INTO "local" VALUES('Estado do Maranhão','Estado do Maranhao',-5.0,-45.0,'BR','13',6569683,'America/Araguaina');
INSERT INTO "local" VALUES('Fortaleza','Fortaleza',-3.71722,-38.54306,'BR','06',2400000,'America/Fortaleza');
INSERT INTO "local" VALUES('Estado do Ceará','Estado do Ceara',-5.0,-40.0,'BR','06',8448055,'America/Fortaleza');
INSERT INTO "local" VALUES('Belém','Belem',-1.45583,-48.50444,'BR','16',1407737,'America/Belem');
INSERT INTO "local" VALUES('Estado de Alagoas','Estado de Alagoas',-9.0,-36.0,'BR','02',3120922,'America/Maceio');
INSERT INTO "local" VALUES('Estado de Sergipe','Estado de Sergipe',-10.5,-37.5,'BR','28',2068031,'America/Maceio');
INSERT INTO "local" VALUES('Estado de São Paulo','Estado de Sao Paulo',-22.0,-49.0,'BR','27',41252160,'America/Sao_Paulo');
INSERT INTO "local" VALUES('São Paulo','Sao Paulo',-23.5475,-46.63611,'BR','27',10021295,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Estado de Santa Catarina','Estado de Santa Catarina',-27.0,-50.0,'BR','26',6249682,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Salvador','Salvador',-12.97111,-38.51083,'BR','05',2711840,'America/Bahia');
INSERT INTO "local" VALUES('Estado do Rio Grande do Sul','Estado do Rio Grande do Sul',-30.0,-54.0,'BR','23',10695532,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Estado do Rio de Janeiro','Estado do Rio de Janeiro',-22.0,-42.5,'BR','21',15993583,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Rio de Janeiro','Rio de Janeiro',-22.90278,-43.2075,'BR','21',6023699,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Porto Alegre','Porto Alegre',-30.03306,-51.23,'BR','23',1372741,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Estado do Paraná','Estado do Parana',-24.0,-51.0,'BR','18',10439601,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Nova Iguaçu','Nova Iguacu',-22.75917,-43.45111,'BR','21',1002118,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Estado de Minas Gerais','Estado de Minas Gerais',-18.0,-44.0,'BR','15',19595309,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Estado de Mato Grosso do Sul','Estado de Mato Grosso do Sul',-21.0,-55.0,'BR','11',2505088,'America/Campo_Grande');
INSERT INTO "local" VALUES('Estado de Mato Grosso','Estado de Mato Grosso',-13.0,-56.0,'BR','14',3033991,'America/Cuiaba');
INSERT INTO "local" VALUES('Guarulhos','Guarulhos',-23.46278,-46.53333,'BR','27',1169577,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Estado de Goiás','Estado de Goias',-15.58071,-49.63623,'BR','29',6004045,'America/Araguaina');
INSERT INTO "local" VALUES('Goiânia','Goiania',-16.67861,-49.25389,'BR','29',1171195,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Distrito Federal','Distrito Federal',-15.75,-47.75,'BR','07',2648532,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Estado do Espírito Santo','Estado do Espirito Santo',-20.0,-40.75,'BR','08',3512672,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Curitiba','Curitiba',-25.42778,-49.27306,'BR','18',1718421,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Campinas','Campinas',-22.90556,-47.06083,'BR','27',1031554,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Federative Republic of Brazil','Federative Republic of Brazil',-10.0,-55.0,'BR','00',201103330,NULL);
INSERT INTO "local" VALUES('Brasília','Brasilia',-15.77972,-47.92972,'BR','07',2207718,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Belo Horizonte','Belo Horizonte',-19.92083,-43.93778,'BR','15',2373224,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Estado da Bahia','Estado da Bahia',-12.0,-42.0,'BR','05',14175341,'America/Bahia');
INSERT INTO "local" VALUES('Estado de Tocantins','Estado de Tocantins',-10.5,-48.0,'BR','31',1383453,'America/Araguaina');
INSERT INTO "local" VALUES('Manaus','Manaus',-3.10194,-60.025,'BR','04',1598210,'America/Manaus');
INSERT INTO "local" VALUES('Estado do Amazonas','Estado do Amazonas',-5.0,-63.0,'BR','04',3480937,'America/Manaus');
INSERT INTO "local" VALUES('Estado de Rondônia','Estado de Rondonia',-11.0,-63.0,'BR','24',1560501,'America/Porto_Velho');
INSERT INTO "local" VALUES('Manaus','Manaus',-3.04361,-60.01282,'BR','04',1802525,'America/Manaus');
INSERT INTO "local" VALUES('Belém','Belem',-1.34341,-48.41816,'BR','16',1392031,'America/Belem');
INSERT INTO "local" VALUES('São Luís','Sao Luis',-2.64949,-44.30441,'BR','13',1011943,'America/Belem');
INSERT INTO "local" VALUES('Fortaleza','Fortaleza',-3.72271,-38.52465,'BR','06',2447409,'America/Fortaleza');
INSERT INTO "local" VALUES('Recife','Recife',-8.01175,-34.95291,'BR','30',1536934,'America/Recife');
INSERT INTO "local" VALUES('Salvador','Salvador',-12.97177,-38.50811,'BR','05',2676606,'America/Bahia');
INSERT INTO "local" VALUES('Belo Horizonte','Belo Horizonte',-19.92623,-43.93982,'BR','15',2375444,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Rio de Janeiro','Rio De Janeiro',-22.92008,-43.33069,'BR','21',6323037,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Guarulhos','Guarulhos',-23.41201,-46.44348,'BR','27',1222357,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Curitiba','Curitiba',-25.50395,-49.29082,'BR','18',1746896,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Porto Alegre','Porto Alegre',-30.11462,-51.16393,'BR','23',1409939,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Goiânia','Goiania',-16.64019,-49.25993,'BR','29',1301892,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Brasília','Brasilia',-15.79159,-47.89558,'BR','07',2562963,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Campinas','Campinas',-22.89703,-47.04441,'BR','27',1080999,'America/Sao_Paulo');
INSERT INTO "local" VALUES('São Paulo','Sao Paulo',-23.62703,-46.63503,'BR','27',11244369,'America/Sao_Paulo');
INSERT INTO "local" VALUES('Republic of Botswana','Republic of Botswana',-22.0,24.0,'BW','00',2029307,'Africa/Gaborone');
INSERT INTO "local" VALUES('Horad Minsk','Horad Minsk',53.9,27.56667,'BY','04',2002600,'Europe/Minsk');
INSERT INTO "local" VALUES('Minsk','Minsk',53.9,27.56667,'BY','04',1742124,'Europe/Minsk');
INSERT INTO "local" VALUES('Republic of Belarus','Republic of Belarus',53.0,28.0,'BY','00',9685000,'Europe/Minsk');
INSERT INTO "local" VALUES('Horad Hrodna','Horad Hrodna',53.68333,23.83333,'BY','03',1142759,'Europe/Minsk');
INSERT INTO "local" VALUES('Horad Brest','Horad Brest',52.1,23.7,'BY','01',1456779,'Europe/Minsk');
INSERT INTO "local" VALUES('Alberta','Alberta',52.28333,-117.469,'CA','01',3497881,'America/Edmonton');
INSERT INTO "local" VALUES('British Columbia','British Columbia',53.99983,-125.0032,'CA','02',4413973,'America/Vancouver');
INSERT INTO "local" VALUES('Calgary','Calgary',51.05011,-114.08529,'CA','01',1019942,'America/Edmonton');
INSERT INTO "local" VALUES('Manitoba','Manitoba',55.00019,-97.00049,'CA','03',1193566,'America/Winnipeg');
INSERT INTO "local" VALUES('Montréal','Montreal',45.50884,-73.58781,'CA','10',3268513,'America/Montreal');
INSERT INTO "local" VALUES('Montréal','Montreal',45.50008,-73.68248,'CA','10',1934082,'America/Montreal');
INSERT INTO "local" VALUES('Ontario','Ontario',49.25014,-84.49983,'CA','08',12861940,'America/Toronto');
INSERT INTO "local" VALUES('Peel','Peel',43.75011,-79.78293,'CA','08',1296814,'America/Toronto');
INSERT INTO "local" VALUES('Peel','Peel',43.71667,-80.15,'CA','08',1159405,'America/Toronto');
INSERT INTO "local" VALUES('Québec','Quebec',52.00017,-71.99907,'CA','10',7730612,'America/Montreal');
INSERT INTO "local" VALUES('Saskatchewan','Saskatchewan',54.0001,-106.00099,'CA','11',1006644,'America/Regina');
INSERT INTO "local" VALUES('Toronto','Toronto',43.70011,-79.4163,'CA','08',4612191,'America/Toronto');
INSERT INTO "local" VALUES('Vancouver','Vancouver',49.24966,-123.11934,'CA','02',1837969,'America/Vancouver');
INSERT INTO "local" VALUES('York','York',44.00011,-79.46632,'CA','08',1032524,'America/Toronto');
INSERT INTO "local" VALUES('Canada','Canada',60.10867,-113.64258,'CA','00',33679000,NULL);
INSERT INTO "local" VALUES('Golden Horseshoe','Golden Horseshoe',44.48671,-79.71405,'CA','08',8102163,'America/Toronto');
INSERT INTO "local" VALUES('Lower Mainland','Lower Mainland',49.08333,-122.35,'CA','02',2524113,'America/Vancouver');
INSERT INTO "local" VALUES('Democratic Republic of the Congo','Democratic Republic of the Congo',-2.5,23.5,'CD','00',70916439,NULL);
INSERT INTO "local" VALUES('South Kivu Province','South Kivu Province',-3.16667,28.25,'CD','12',3909135,'Africa/Lubumbashi');
INSERT INTO "local" VALUES('Katanga Province','Katanga Province',-9.0,26.0,'CD','05',5600000,'Africa/Lubumbashi');
INSERT INTO "local" VALUES('Province du Nord-Kivu','Province du Nord-Kivu',-0.66667,28.75,'CD','11',4908824,'Africa/Lubumbashi');
INSERT INTO "local" VALUES('Province du Maniema','Province du Maniema',-2.91667,25.91667,'CD','10',1718257,'Africa/Lubumbashi');
INSERT INTO "local" VALUES('Province du Kasaï-Oriental','Province du Kasai-Oriental',-4.0,24.0,'CD','04',6500000,'Africa/Lubumbashi');
INSERT INTO "local" VALUES('Province du Kasaï-Occidental','Province du Kasai-Occidental',-4.5,22.0,'CD','03',4545940,'Africa/Lubumbashi');
INSERT INTO "local" VALUES('Orientale Province','Orientale Province',2.5,27.0,'CD','09',6828888,'Africa/Lubumbashi');
INSERT INTO "local" VALUES('Province de l’ Équateur','Province de l'' Equateur',1.0,20.5,'CD','02',7500000,'Africa/Kinshasa');
INSERT INTO "local" VALUES('Lubumbashi','Lubumbashi',-11.66089,27.47938,'CD','05',1373770,'Africa/Lubumbashi');
INSERT INTO "local" VALUES('Kinshasa','Kinshasa',-4.32142,15.30807,'CD','06',7785965,'Africa/Kinshasa');
INSERT INTO "local" VALUES('Province du Bas-Congo','Province du Bas-Congo',-5.5,14.5,'CD','08',3802736,'Africa/Kinshasa');
INSERT INTO "local" VALUES('Bandundu Province','Bandundu Province',-4.0,18.0,'CD','01',8000000,'Africa/Kinshasa');
INSERT INTO "local" VALUES('Central African Republic','Central African Republic',7.0,21.0,'CF','00',4844927,'Africa/Bangui');
INSERT INTO "local" VALUES('Republic of the Congo','Republic of the Congo',-1.0,15.5,'CG','00',3039126,'Africa/Brazzaville');
INSERT INTO "local" VALUES('Brazzaville','Brazzaville',-4.26613,15.28318,'CG','12',1284609,'Africa/Brazzaville');
INSERT INTO "local" VALUES('Kanton Zürich','Kanton Zurich',47.41667,8.66667,'CH','ZH',1289559,'Europe/Zurich');
INSERT INTO "local" VALUES('Swiss Confederation','Swiss Confederation',47.00016,8.01427,'CH','00',7581000,'Europe/Zurich');
INSERT INTO "local" VALUES('Republic of Côte d’Ivoire','Republic of Cote d''Ivoire',8.0,-5.5,'CI','00',21058798,'Africa/Abidjan');
INSERT INTO "local" VALUES('Abidjan','Abidjan',5.30966,-4.01266,'CI','82',3677115,'Africa/Abidjan');
INSERT INTO "local" VALUES('Santiago','Santiago',-33.45694,-70.64827,'CL','12',4837295,'America/Santiago');
INSERT INTO "local" VALUES('Región Metropolitana de Santiago','Region Metropolitana de Santiago',-33.47269,-70.64724,'CL','12',6685685,'America/Santiago');
INSERT INTO "local" VALUES('Republic of Chile','Republic of Chile',-30.0,-71.0,'CL','00',16746491,NULL);
INSERT INTO "local" VALUES('Yaoundé','Yaounde',3.86667,11.51667,'CM','11',1299369,'Africa/Douala');
INSERT INTO "local" VALUES('West Region','West Region',5.5,10.5,'CM','08',1339791,'Africa/Douala');
INSERT INTO "local" VALUES('Littoral Region','Littoral Region',4.0,10.0,'CM','05',2202340,'Africa/Douala');
INSERT INTO "local" VALUES('Far North Region','Far North Region',11.0,14.5,'CM','12',1855695,'Africa/Douala');
INSERT INTO "local" VALUES('Douala','Douala',4.04827,9.70428,'CM','05',1338082,'Africa/Douala');
INSERT INTO "local" VALUES('Centre Region','Centre Region',4.75,12.0,'CM','11',2672533,'Africa/Douala');
INSERT INTO "local" VALUES('Republic of Cameroon','Republic of Cameroon',6.0,12.5,'CM','00',19294149,'Africa/Douala');
INSERT INTO "local" VALUES('Tibet Autonomous Region','Tibet Autonomous Region',32.0,90.0,'CN','14',2870000,'Asia/Urumqi');
INSERT INTO "local" VALUES('Qinghai Sheng','Qinghai Sheng',36.0,96.0,'CN','06',5626722,'Asia/Urumqi');
INSERT INTO "local" VALUES('Xinjiang Uygur Zizhiqu','Xinjiang Uygur Zizhiqu',42.56917,85.45611,'CN','13',21310000,'Asia/Urumqi');
INSERT INTO "local" VALUES('Ürümqi','UEruemqi',43.80096,87.60046,'CN','13',1508225,'Asia/Urumqi');
INSERT INTO "local" VALUES('Zhumadian','Zhumadian',32.97944,114.02944,'CN','09',8263100,'Asia/Shanghai');
INSERT INTO "local" VALUES('Zhengzhou','Zhengzhou',34.75778,113.64861,'CN','09',2014125,'Asia/Shanghai');
INSERT INTO "local" VALUES('Zhejiang Sheng','Zhejiang Sheng',29.0,120.0,'CN','02',51200000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Yunnan Sheng','Yunnan Sheng',25.0,102.0,'CN','29',45430000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Yunfu','Yunfu',22.92832,112.03954,'CN','30',2612800,'Asia/Chongqing');
INSERT INTO "local" VALUES('Yueyang Shi','Yueyang Shi',29.32472,113.302,'CN','11',5100000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Yangpu Qu','Yangpu Qu',31.29248,121.5058,'CN','23',1313222,'Asia/Shanghai');
INSERT INTO "local" VALUES('Tongshan','Tongshan',34.18045,117.15707,'CN','04',1199193,'Asia/Shanghai');
INSERT INTO "local" VALUES('Xinyang','Xinyang',32.12278,114.06556,'CN','09',1590668,'Asia/Shanghai');
INSERT INTO "local" VALUES('Xicheng Qu','Xicheng Qu',39.93317,116.37337,'CN','22',1233000,'Asia/Harbin');
INSERT INTO "local" VALUES('Xianyang','Xianyang',34.33778,108.70261,'CN','26',1034081,'Asia/Chongqing');
INSERT INTO "local" VALUES('Xi’an','Xi''an',34.25833,108.92861,'CN','26',3225812,'Asia/Chongqing');
INSERT INTO "local" VALUES('Wuxi','Wuxi',31.56887,120.28857,'CN','04',1108647,'Asia/Shanghai');
INSERT INTO "local" VALUES('Wuhan','Wuhan',30.58333,114.26667,'CN','12',4184206,'Asia/Shanghai');
INSERT INTO "local" VALUES('Wanzhou District','Wanzhou District',30.70576,108.40202,'CN','33',1730000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Tongzhou Qu','Tongzhou Qu',39.80881,116.72402,'CN','22',1184000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Tianshui','Tianshui',34.57952,105.74238,'CN','15',3500000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Tianjin Shi','Tianjin Shi',39.13333,117.2,'CN','28',11760000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Tianjin','Tianjin',39.14222,117.17667,'CN','28',3766207,'Asia/Shanghai');
INSERT INTO "local" VALUES('Tangshan','Tangshan',39.63333,118.18333,'CN','10',1596949,'Asia/Shanghai');
INSERT INTO "local" VALUES('Taiyuan','Taiyuan',37.86944,112.56028,'CN','24',2722475,'Asia/Shanghai');
INSERT INTO "local" VALUES('Tai’an','Tai''an',36.18528,117.12,'CN','25',5499000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Songjiang Qu','Songjiang Qu',31.02098,121.21132,'CN','23',1582398,'Asia/Shanghai');
INSERT INTO "local" VALUES('Sichuan Sheng','Sichuan Sheng',30.5,102.5,'CN','32',87250000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Shiyan','Shiyan',32.6475,110.77806,'CN','12',3460000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Shijiazhuang','Shijiazhuang',38.04139,114.47861,'CN','10',1992474,'Asia/Shanghai');
INSERT INTO "local" VALUES('Shenzhen','Shenzhen',22.54554,114.0683,'CN','30',3000000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Shanxi Sheng','Shanxi Sheng',37.0,112.0,'CN','24',34110000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Shantou','Shantou',23.36814,116.71479,'CN','30',1333973,'Asia/Shanghai');
INSERT INTO "local" VALUES('Shanghai Shi','Shanghai Shi',31.23333,121.46667,'CN','23',18880000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Shanghai','Shanghai',31.22222,121.45806,'CN','23',14608512,'Asia/Shanghai');
INSERT INTO "local" VALUES('Shandong Sheng','Shandong Sheng',36.0,119.0,'CN','25',94170000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Shaanxi','Shaanxi',36.0,109.0,'CN','26',37620000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Jieyang','Jieyang',23.5418,116.36581,'CN','30',1001985,'Asia/Shanghai');
INSERT INTO "local" VALUES('Qingdao','Qingdao',36.09861,120.37194,'CN','25',1642245,'Asia/Shanghai');
INSERT INTO "local" VALUES('Puyang','Puyang',29.45679,119.88872,'CN','02',3590000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Putuo Qu','Putuo Qu',31.25539,121.39326,'CN','23',1135900,'Asia/Shanghai');
INSERT INTO "local" VALUES('Ningxia Huizu Zizhiqu','Ningxia Huizu Zizhiqu',37.0,106.0,'CN','21',6180000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Nanjing','Nanjing',32.06167,118.77778,'CN','04',3087010,'Asia/Shanghai');
INSERT INTO "local" VALUES('Nanchong','Nanchong',30.79508,106.08474,'CN','32',7150000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Nanchang','Nanchang',28.68333,115.88333,'CN','03',1871351,'Asia/Shanghai');
INSERT INTO "local" VALUES('Luoyang','Luoyang',34.68361,112.45361,'CN','09',1390581,'Asia/Shanghai');
INSERT INTO "local" VALUES('Guankou','Guankou',28.15861,113.62709,'CN','11',1380000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Lanzhou','Lanzhou',36.05701,103.83987,'CN','15',3200000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Kunming','Kunming',25.03889,102.71833,'CN','29',1023674,'Asia/Chongqing');
INSERT INTO "local" VALUES('Kaifeng','Kaifeng',34.7986,114.30742,'CN','09',4800000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Jinan','Jinan',36.66833,116.99722,'CN','25',2069266,'Asia/Shanghai');
INSERT INTO "local" VALUES('Jiangxi Sheng','Jiangxi Sheng',28.0,116.0,'CN','03',44000000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Jiangsu Sheng','Jiangsu Sheng',33.0,120.0,'CN','04',76770000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Hunan Sheng','Hunan Sheng',28.0,112.0,'CN','11',66980000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Hubei Sheng','Hubei Sheng',31.0,112.0,'CN','12',57110000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Huainan','Huainan',32.62639,116.99694,'CN','01',1027655,'Asia/Shanghai');
INSERT INTO "local" VALUES('Henan Sheng','Henan Sheng',34.0,114.0,'CN','09',94290000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Hefei','Hefei',31.86389,117.28083,'CN','01',1388904,'Asia/Shanghai');
INSERT INTO "local" VALUES('Hebei Sheng','Hebei Sheng',39.0,116.0,'CN','10',69890000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Hangzhou','Hangzhou',30.29365,120.16142,'CN','02',1878129,'Asia/Shanghai');
INSERT INTO "local" VALUES('Handan','Handan',36.60056,114.46778,'CN','10',1358318,'Asia/Shanghai');
INSERT INTO "local" VALUES('Hainan Sheng','Hainan Sheng',19.2,109.6,'CN','31',8540000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Haidian Qu','Haidian Qu',40.03102,116.22108,'CN','22',2240124,'Asia/Shanghai');
INSERT INTO "local" VALUES('Guizhou Sheng','Guizhou Sheng',27.0,107.0,'CN','18',37930000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Guiyang','Guiyang',26.58333,106.71667,'CN','18',1171633,'Asia/Chongqing');
INSERT INTO "local" VALUES('Guangzhou','Guangzhou',23.11667,113.25,'CN','30',3152825,'Asia/Shanghai');
INSERT INTO "local" VALUES('Guangxi Zhuangzu Zizhiqu','Guangxi Zhuangzu Zizhiqu',24.0,109.0,'CN','16',48160000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Guangdong Sheng','Guangdong Sheng',23.0,113.0,'CN','30',104303132,'Asia/Chongqing');
INSERT INTO "local" VALUES('Ganzhou Shi','Ganzhou Shi',25.70387,115.34822,'CN','03',8900000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Gansu Sheng','Gansu Sheng',38.0,102.0,'CN','15',26280000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Fuzhou','Fuzhou',26.06139,119.30611,'CN','07',1179720,'Asia/Shanghai');
INSERT INTO "local" VALUES('Fujian Sheng','Fujian Sheng',26.545,117.84278,'CN','07',36040000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Fengxian Qu','Fengxian Qu',30.92835,121.58221,'CN','23',1083400,'Asia/Shanghai');
INSERT INTO "local" VALUES('Fengtai Qu','Fengtai Qu',39.83781,116.24964,'CN','22',1360000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Lijiang','Lijiang',26.86879,100.22072,'CN','29',1137600,'Asia/Chongqing');
INSERT INTO "local" VALUES('Dalian','Dalian',38.91222,121.60222,'CN','19',2035307,'Asia/Shanghai');
INSERT INTO "local" VALUES('Chongqing Shi','Chongqing Shi',30.05705,107.87406,'CN','33',28390000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Chongqing','Chongqing',29.56278,106.55278,'CN','33',3967028,'Asia/Chongqing');
INSERT INTO "local" VALUES('People’s Republic of China','People''s Republic of China',35.0,105.0,'CN','00',1330044000,NULL);
INSERT INTO "local" VALUES('Chengdu','Chengdu',30.66667,104.06667,'CN','32',3950437,'Asia/Chongqing');
INSERT INTO "local" VALUES('Chaoyang Qu','Chaoyang Qu',39.95462,116.5029,'CN','22',3402000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Changsha','Changsha',28.19874,112.97087,'CN','11',2073938,'Asia/Shanghai');
INSERT INTO "local" VALUES('Beijing','Beijing',39.9075,116.39723,'CN','22',7480601,'Asia/Shanghai');
INSERT INTO "local" VALUES('Baoji Shi','Baoji Shi',34.36944,107.13634,'CN','26',3762500,'Asia/Chongqing');
INSERT INTO "local" VALUES('Anhui Sheng','Anhui Sheng',32.0,117.0,'CN','01',64610000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Changshu Shi','Changshu Shi',31.64841,120.7497,'CN','04',1047700,'Asia/Shanghai');
INSERT INTO "local" VALUES('Suzhou','Suzhou',31.30408,120.59538,'CN','04',1343091,'Asia/Shanghai');
INSERT INTO "local" VALUES('Zhongshan','Zhongshan',21.31992,110.5723,'CN','30',2493400,'Asia/Urumqi');
INSERT INTO "local" VALUES('Yueyang','Yueyang',29.37455,113.09481,'CN','11',5000000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Puyang Shi','Puyang Shi',35.81333,115.155,'CN','09',3870000,'Asia/Shanghai');
INSERT INTO "local" VALUES('Shenyang','Shenyang',41.79222,123.43278,'CN','19',3512192,'Asia/Shanghai');
INSERT INTO "local" VALUES('Inner Mongolia Autonomous Region','Inner Mongolia Autonomous Region',44.0,112.0,'CN','20',24259735,'Asia/Harbin');
INSERT INTO "local" VALUES('Liaoning Sheng','Liaoning Sheng',41.0,123.0,'CN','19',43150000,'Asia/Harbin');
INSERT INTO "local" VALUES('Jilin Sheng','Jilin Sheng',43.0,126.0,'CN','05',27340000,'Asia/Harbin');
INSERT INTO "local" VALUES('Jilin','Jilin',43.85083,126.56028,'CN','05',1881977,'Asia/Harbin');
INSERT INTO "local" VALUES('Heilongjiang Sheng','Heilongjiang Sheng',48.0,128.0,'CN','08',38250000,'Asia/Harbin');
INSERT INTO "local" VALUES('Harbin','Harbin',45.75,126.65,'CN','08',3229883,'Asia/Harbin');
INSERT INTO "local" VALUES('Fushun','Fushun',41.85583,123.92333,'CN','19',1400646,'Asia/Shanghai');
INSERT INTO "local" VALUES('Datong','Datong',40.09361,113.29139,'CN','24',1052678,'Asia/Shanghai');
INSERT INTO "local" VALUES('Changchun','Changchun',43.88,125.32278,'CN','05',2537421,'Asia/Harbin');
INSERT INTO "local" VALUES('Beijing Shi','Beijing Shi',39.91691,116.39706,'CN','22',14933274,'Asia/Shanghai');
INSERT INTO "local" VALUES('Baotou','Baotou',40.65222,109.82222,'CN','20',1301768,'Asia/Chongqing');
INSERT INTO "local" VALUES('Anshan','Anshan',41.12361,122.99,'CN','19',1199275,'Asia/Shanghai');
INSERT INTO "local" VALUES('Longgang Qu','Longgang Qu',22.6975,114.33528,'CN','30',1330000,'Asia/Chongqing');
INSERT INTO "local" VALUES('Changshu City','Changshu City',31.64615,120.74221,'CN','04',1047700,'Asia/Shanghai');
INSERT INTO "local" VALUES('Ordos','Ordos',39.6086,109.78157,'CN','20',1940653,'Asia/Chongqing');
INSERT INTO "local" VALUES('Departamento del Valle del Cauca','Departamento del Valle del Cauca',3.75,-76.5,'CO','29',4161425,'America/Bogota');
INSERT INTO "local" VALUES('Departamento de Tolima','Departamento de Tolima',3.75,-75.25,'CO','28',1365342,'America/Bogota');
INSERT INTO "local" VALUES('Departamento de Santander','Departamento de Santander',7.0,-73.25,'CO','26',1957789,'America/Bogota');
INSERT INTO "local" VALUES('Departamento de Norte de Santander','Departamento de Norte de Santander',8.0,-73.0,'CO','21',1243975,'America/Bogota');
INSERT INTO "local" VALUES('Departamento de Nariño','Departamento de Narino',1.5,-78.0,'CO','20',1541956,'America/Bogota');
INSERT INTO "local" VALUES('Medellín','Medellin',6.25184,-75.56359,'CO','02',1999979,'America/Bogota');
INSERT INTO "local" VALUES('Departamento del Magdalena','Departamento del Magdalena',10.0,-74.5,'CO','38',1149917,'America/Bogota');
INSERT INTO "local" VALUES('Departamento del Huila','Departamento del Huila',2.5,-75.75,'CO','16',1011418,'America/Bogota');
INSERT INTO "local" VALUES('Departamento de Cundinamarca','Departamento de Cundinamarca',5.0,-74.16667,'CO','33',2598245,'America/Bogota');
INSERT INTO "local" VALUES('Departamento de Córdoba','Departamento de Cordoba',8.33333,-75.66667,'CO','12',1467929,'America/Bogota');
INSERT INTO "local" VALUES('Republic of Colombia','Republic of Colombia',4.0,-73.25,'CO','00',44205293,'America/Bogota');
INSERT INTO "local" VALUES('Departamento del Cauca','Departamento del Cauca',2.5,-76.83333,'CO','09',1268937,'America/Bogota');
INSERT INTO "local" VALUES('Cali','Cali',3.43722,-76.5225,'CO','29',2392877,'America/Bogota');
INSERT INTO "local" VALUES('Cali','Cali',3.41667,-76.55,'CO','29',2244158,'America/Bogota');
INSERT INTO "local" VALUES('Departamento de Boyacá','Departamento de Boyaca',5.5,-72.5,'CO','36',1255311,'America/Bogota');
INSERT INTO "local" VALUES('Departamento de Bolívar','Departamento de Bolivar',9.0,-74.33333,'CO','35',2049083,'America/Bogota');
INSERT INTO "local" VALUES('Distrito Capital de Bogotá','Distrito Capital de Bogota',4.25,-74.18333,'CO','34',6840116,'America/Bogota');
INSERT INTO "local" VALUES('Bogotá','Bogota',4.60971,-74.08175,'CO','34',7674366,'America/Bogota');
INSERT INTO "local" VALUES('Barranquilla','Barranquilla',10.96854,-74.78132,'CO','04',1380425,'America/Bogota');
INSERT INTO "local" VALUES('Departamento del Atlántico','Departamento del Atlantico',10.75,-75.0,'CO','04',2166156,'America/Bogota');
INSERT INTO "local" VALUES('Departamento de Antioquia','Departamento de Antioquia',7.0,-75.5,'CO','02',6299886,'America/Bogota');
INSERT INTO "local" VALUES('Republic of Costa Rica','Republic of Costa Rica',10.0,-84.0,'CR','00',4516220,'America/Costa_Rica');
INSERT INTO "local" VALUES('Havana','Havana',23.13302,-82.38304,'CU','02',2163824,'America/Havana');
INSERT INTO "local" VALUES('Republic of Cuba','Republic of Cuba',22.0,-79.5,'CU','00',11423000,'America/Havana');
INSERT INTO "local" VALUES('Republic of Cyprus','Republic of Cyprus',35.0,33.0,'CY','00',1102677,'Asia/Nicosia');
INSERT INTO "local" VALUES('Hlavní město Praha','Hlavni mesto Praha',50.08333,14.46667,'CZ','52',1167050,'Europe/Prague');
INSERT INTO "local" VALUES('Prague','Prague',50.08804,14.42076,'CZ','52',1165581,'Europe/Prague');
INSERT INTO "local" VALUES('Czech Republic','Czech Republic',49.75,15.0,'CZ','00',10476000,'Europe/Prague');
INSERT INTO "local" VALUES('Jihomoravský kraj','Jihomoravsky kraj',49.20122,16.61339,'CZ','78',1196113,'Europe/Prague');
INSERT INTO "local" VALUES('Středočeský kraj','Stredocesky kraj',50.12718,14.1964,'CZ','88',1284629,'Europe/Prague');
INSERT INTO "local" VALUES('Regierungsbezirk Unterfranken','Regierungsbezirk Unterfranken',50.0,10.0,'DE','02',1297727,'Europe/Berlin');
INSERT INTO "local" VALUES('Freistaat Thüringen','Freistaat Thuringen',50.91667,11.0,'DE','15',2249882,'Europe/Berlin');
INSERT INTO "local" VALUES('Swabia','Swabia',48.33333,10.5,'DE','02',1792759,'Europe/Berlin');
INSERT INTO "local" VALUES('Land Schleswig-Holstein','Land Schleswig-Holstein',54.2,9.75,'DE','10',2832027,'Europe/Berlin');
INSERT INTO "local" VALUES('Land Sachsen-Anhalt','Land Sachsen-Anhalt',52.0,11.7333,'DE','14',2356219,'Europe/Berlin');
INSERT INTO "local" VALUES('Freistaat Sachsen','Freistaat Sachsen',51.0,13.25,'DE','13',4168732,'Europe/Berlin');
INSERT INTO "local" VALUES('Saarland','Saarland',49.40472,6.96083,'DE','09',1022585,'Europe/Berlin');
INSERT INTO "local" VALUES('Rhein-Main-Gebiet','Rhein-Main-Gebiet',50.0,8.66667,'DE','05',2200000,'Europe/Berlin');
INSERT INTO "local" VALUES('Rheinland-Pfalz','Rheinland-Pfalz',49.66667,7.5,'DE','08',4012675,'Europe/Berlin');
INSERT INTO "local" VALUES('Upper Palatinate','Upper Palatinate',49.5,12.0,'DE','02',1074738,'Europe/Berlin');
INSERT INTO "local" VALUES('Upper Franconia','Upper Franconia',49.83333,11.33333,'DE','02',1058711,'Europe/Berlin');
INSERT INTO "local" VALUES('Upper Bavaria','Upper Bavaria',48.0,11.0,'DE','02',4415649,'Europe/Berlin');
INSERT INTO "local" VALUES('Land Nordrhein-Westfalen','Land Nordrhein-Westfalen',51.21895,6.76339,'DE','07',17872763,'Europe/Berlin');
INSERT INTO "local" VALUES('Land Niedersachsen','Land Niedersachsen',52.83333,9.16667,'DE','06',7928815,'Europe/Berlin');
INSERT INTO "local" VALUES('Lower Bavaria','Lower Bavaria',48.75,12.83333,'DE','02',1181472,'Europe/Berlin');
INSERT INTO "local" VALUES('Regierungsbezirk Münster','Regierungsbezirk Munster',51.9666,7.4333,'DE','07',2572390,'Europe/Berlin');
INSERT INTO "local" VALUES('Munich','Munich',48.13743,11.57549,'DE','02',1260391,'Europe/Berlin');
INSERT INTO "local" VALUES('Regierungsbezirk Mittelfranken','Regierungsbezirk Mittelfranken',49.33333,10.83333,'DE','02',1698515,'Europe/Berlin');
INSERT INTO "local" VALUES('Land Mecklenburg-Vorpommern','Land Mecklenburg-Vorpommern',53.83333,12.5,'DE','12',1651216,'Europe/Berlin');
INSERT INTO "local" VALUES('Regierungsbezirk Köln','Regierungsbezirk Koln',50.78333,6.8666,'DE','07',4315912,'Europe/Berlin');
INSERT INTO "local" VALUES('Regierungsbezirk Kassel','Regierungsbezirk Kassel',51.08333,9.4,'DE','05',1201823,'Europe/Berlin');
INSERT INTO "local" VALUES('Land Hessen','Land Hessen',50.55,9.0,'DE','05',6061951,'Europe/Berlin');
INSERT INTO "local" VALUES('Free and Hanseatic City of Hamburg','Free and Hanseatic City of Hamburg',53.58333,10.0,'DE','04',1774224,'Europe/Berlin');
INSERT INTO "local" VALUES('Hamburg','Hamburg',53.57532,10.01534,'DE','04',1739117,'Europe/Berlin');
INSERT INTO "local" VALUES('Federal Republic of Germany','Federal Republic of Germany',51.5,10.5,'DE','00',81802257,NULL);
INSERT INTO "local" VALUES('Freiburg Region','Freiburg Region',48.16667,8.33333,'DE','01',2162340,'Europe/Berlin');
INSERT INTO "local" VALUES('Regierungsbezirk Düsseldorf','Regierungsbezirk Dusseldorf',51.4,6.6,'DE','07',5081061,'Europe/Berlin');
INSERT INTO "local" VALUES('Regierungsbezirk Detmold','Regierungsbezirk Detmold',51.9666,8.78333,'DE','07',2025415,'Europe/Berlin');
INSERT INTO "local" VALUES('Regierungsbezirk Darmstadt','Regierungsbezirk Darmstadt',50.0,8.75,'DE','05',3791381,'Europe/Berlin');
INSERT INTO "local" VALUES('Land Brandenburg','Land Brandenburg',52.33333,13.2,'DE','11',2511525,'Europe/Berlin');
INSERT INTO "local" VALUES('Land Berlin','Land Berlin',52.5,13.41667,'DE','16',3442675,'Europe/Berlin');
INSERT INTO "local" VALUES('Berlin','Berlin',52.52437,13.41053,'DE','16',3426354,'Europe/Berlin');
INSERT INTO "local" VALUES('Freistaat Bayern','Freistaat Bayern',49.0,11.5,'DE','02',12510331,'Europe/Berlin');
INSERT INTO "local" VALUES('Baden-Württemberg Region','Baden-Wuerttemberg Region',48.5,9.0,'DE','01',10744921,'Europe/Berlin');
INSERT INTO "local" VALUES('Regierungsbezirk Arnsberg','Regierungsbezirk Arnsberg',51.32967,8.0071,'DE','07',3559551,'Europe/Berlin');
INSERT INTO "local" VALUES('Karlsruhe Region','Karlsruhe Region',49.0,8.66667,'DE','01',2686573,'Europe/Berlin');
INSERT INTO "local" VALUES('Regierungsbezirk Stuttgart','Regierungsbezirk Stuttgart',49.08333,9.66667,'DE','01',3947568,'Europe/Berlin');
INSERT INTO "local" VALUES('Tübingen Region','Tuebingen Region',48.16667,9.5,'DE','01',1772630,'Europe/Berlin');
INSERT INTO "local" VALUES('Kreisfreie Stadt München','Kreisfreie Stadt Munchen',48.15389,11.54806,'DE','02',1388308,'Europe/Berlin');
INSERT INTO "local" VALUES('Regierungsbezirk Gießen','Regierungsbezirk Giessen',50.69806,8.76861,'DE','05',1023277,'Europe/Berlin');
INSERT INTO "local" VALUES('Regierungsbezirk Weser-Ems','Regierungsbezirk Weser-Ems',53.08333,7.83333,'DE','06',2475481,'Europe/Berlin');
INSERT INTO "local" VALUES('Region Hannover','Region Hannover',52.44889,9.74,'DE','06',1112675,'Europe/Berlin');
INSERT INTO "local" VALUES('Kreisfreie Stadt Köln','Kreisfreie Stadt Koln',50.94161,6.95864,'DE','07',1024373,'Europe/Berlin');
INSERT INTO "local" VALUES('Direktionsbezirk Dresden','Direktionsbezirk Dresden',51.16667,14.08333,'DE','13',1631486,'Europe/Berlin');
INSERT INTO "local" VALUES('Direktionsbezirk Chemnitz','Direktionsbezirk Chemnitz',50.66667,12.75,'DE','13',1540029,'Europe/Berlin');
INSERT INTO "local" VALUES('Berlin, Stadt','Berlin, Stadt',52.5233,13.41377,'DE','16',3375222,'Europe/Berlin');
INSERT INTO "local" VALUES('Hamburg, Freie und Hansestadt','Hamburg, Freie und Hansestadt',53.55,10.0,'DE','04',1734272,'Europe/Berlin');
INSERT INTO "local" VALUES('Berlin','Berlin',52.5233,13.41377,'DE','16',3375222,'Europe/Berlin');
INSERT INTO "local" VALUES('Köln','Koeln',50.93835,6.95428,'DE','07',1024373,'Europe/Berlin');
INSERT INTO "local" VALUES('München, Landeshauptstadt','Muenchen, Landeshauptstadt',48.13452,11.571,'DE','02',1388308,'Europe/Berlin');
INSERT INTO "local" VALUES('Hamburg, Freie und Hansestadt','Hamburg, Freie und Hansestadt',53.55,10.0,'DE','04',1734272,'Europe/Berlin');
INSERT INTO "local" VALUES('Copenhagen','Copenhagen',55.67594,12.56553,'DK','17',1153615,'Europe/Copenhagen');
INSERT INTO "local" VALUES('Kingdom of Denmark','Kingdom of Denmark',56.0,10.0,'DK','00',5484000,'Europe/Copenhagen');
INSERT INTO "local" VALUES('Oresund Region','Oresund Region',55.70468,12.79633,'DK','17',3583842,'Europe/Copenhagen');
INSERT INTO "local" VALUES('Region Hovedstaden','Region Hovedstaden',55.83333,12.33333,'DK','17',1680271,'Europe/Copenhagen');
INSERT INTO "local" VALUES('Region Midtjylland','Region Midtjylland',56.16667,9.5,'DK','18',1253998,'Europe/Copenhagen');
INSERT INTO "local" VALUES('Region Syddanmark','Region Syddanmark',55.37911,10.345,'DK','21',1200277,'Europe/Copenhagen');
INSERT INTO "local" VALUES('Santo Domingo','Santo Domingo',18.50012,-69.98857,'DO','34',2201941,'America/Santo_Domingo');
INSERT INTO "local" VALUES('Santiago de los Caballeros','Santiago de los Caballeros',19.4517,-70.69703,'DO','25',1200000,'America/Santo_Domingo');
INSERT INTO "local" VALUES('Dominican Republic','Dominican Republic',19.0,-70.66667,'DO','00',9823821,'America/Santo_Domingo');
INSERT INTO "local" VALUES('Provincia de Santo Domingo','Provincia de Santo Domingo',18.48042,-69.91871,'DO','37',2995211,'America/Santo_Domingo');
INSERT INTO "local" VALUES('Wilaya de Tizi Ouzou','Wilaya de Tizi Ouzou',36.75,4.25,'DZ','14',1127608,'Africa/Algiers');
INSERT INTO "local" VALUES('Wilaya de Sétif','Wilaya de Setif',36.16667,5.5,'DZ','12',1489979,'Africa/Algiers');
INSERT INTO "local" VALUES('Oran','Oran',35.66667,-0.5,'DZ','09',1454078,'Africa/Algiers');
INSERT INTO "local" VALUES('Wilaya de Djelfa','Wilaya de Djelfa',34.33333,3.66667,'DZ','22',1092184,'Africa/Algiers');
INSERT INTO "local" VALUES('Wilaya de Chlef','Wilaya de Chlef',36.25,1.25,'DZ','41',1002088,'Africa/Algiers');
INSERT INTO "local" VALUES('Wilaya de Blida','Wilaya de Blida',36.58333,3.0,'DZ','20',1002937,'Africa/Algiers');
INSERT INTO "local" VALUES('Wilaya de Batna','Wilaya de Batna',35.5,5.91667,'DZ','03',1119791,'Africa/Algiers');
INSERT INTO "local" VALUES('Wilaya d’ Alger','Wilaya d'' Alger',36.74053,3.00957,'DZ','01',2988145,'Africa/Algiers');
INSERT INTO "local" VALUES('Algiers','Algiers',36.7525,3.04197,'DZ','01',1977663,'Africa/Algiers');
INSERT INTO "local" VALUES('People’s Democratic Republic of Algeria','People''s Democratic Republic of Algeria',28.0,3.0,'DZ','00',34586184,'Africa/Algiers');
INSERT INTO "local" VALUES('Quito','Quito',-0.22985,-78.52495,'EC','18',1399814,'America/Guayaquil');
INSERT INTO "local" VALUES('Guayaquil','Guayaquil',-2.20584,-79.90795,'EC','10',1952029,'America/Guayaquil');
INSERT INTO "local" VALUES('Republic of Ecuador','Republic of Ecuador',-1.25,-78.25,'EC','00',14790608,NULL);
INSERT INTO "local" VALUES('Republic of Estonia','Republic of Estonia',59.0,26.0,'EE','00',1291170,'Europe/Tallinn');
INSERT INTO "local" VALUES('Arab Republic of Egypt','Arab Republic of Egypt',27.0,30.0,'EG','00',80471869,'Africa/Cairo');
INSERT INTO "local" VALUES('Muḩāfaz̧at Dumyāţ','Muhafazat Dumyat',31.35,31.75,'EG','20',1076132,'Africa/Cairo');
INSERT INTO "local" VALUES('Muḩāfaz̧at ash Sharqīyah','Muhafazat ash Sharqiyah',30.7,31.8,'EG','14',5109642,'Africa/Cairo');
INSERT INTO "local" VALUES('Muḩāfaz̧at al Qalyūbīyah','Muhafazat al Qalyubiyah',30.3,31.25,'EG','12',3881462,'Africa/Cairo');
INSERT INTO "local" VALUES('Cairo','Cairo',30.06263,31.24967,'EG','11',7734614,'Africa/Cairo');
INSERT INTO "local" VALUES('Muḩāfaz̧at al Qāhirah','Muhafazat al Qahirah',30.05,31.65,'EG','11',7734614,'Africa/Cairo');
INSERT INTO "local" VALUES('Muḩāfaz̧at al Minūfīyah','Muhafazat al Minufiyah',30.5,31.0,'EG','09',3228928,'Africa/Cairo');
INSERT INTO "local" VALUES('Al Jīzah','Al Jizah',30.00808,31.21093,'EG','08',2443203,'Africa/Cairo');
INSERT INTO "local" VALUES('Muḩāfaz̧at al Jīzah','Muhafazat al Jizah',29.99776,31.05286,'EG','08',3326444,'Africa/Cairo');
INSERT INTO "local" VALUES('Alexandria','Alexandria',31.21564,29.95527,'EG','06',3811516,'Africa/Cairo');
INSERT INTO "local" VALUES('Muḩāfaz̧at al Iskandarīyah','Muhafazat al Iskandariyah',31.0,29.75,'EG','06',3811516,'Africa/Cairo');
INSERT INTO "local" VALUES('Muḩāfaz̧at al Gharbīyah','Muhafazat al Gharbiyah',30.9,31.0,'EG','05',3920800,'Africa/Cairo');
INSERT INTO "local" VALUES('Beheira Governorate','Beheira Governorate',30.6,30.2,'EG','03',4689632,'Africa/Cairo');
INSERT INTO "local" VALUES('State of Eritrea','State of Eritrea',15.0,39.0,'ER','00',5792984,'Africa/Asmara');
INSERT INTO "local" VALUES('Província de València','Provincia de Valencia',39.33333,-0.83333,'ES','60',2575362,'Europe/Madrid');
INSERT INTO "local" VALUES('Kingdom of Spain','Kingdom of Spain',40.0,-4.0,'ES','00',46505963,NULL);
INSERT INTO "local" VALUES('Provincia de Sevilla','Provincia de Sevilla',37.44701,-5.69608,'ES','51',1900224,'Europe/Madrid');
INSERT INTO "local" VALUES('Provincia de Santa Cruz de Tenerife','Provincia de Santa Cruz de Tenerife',28.16667,-17.33333,'ES','53',1020490,'Atlantic/Canary');
INSERT INTO "local" VALUES('Región de Murcia','Region de Murcia',38.0,-1.5,'ES','31',1446520,'Europe/Madrid');
INSERT INTO "local" VALUES('Provincia de Málaga','Provincia de Malaga',36.8,-4.75,'ES','51',1593068,'Europe/Madrid');
INSERT INTO "local" VALUES('Provincia de Las Palmas','Provincia de Las Palmas',28.42039,-14.01306,'ES','53',1083502,'Atlantic/Canary');
INSERT INTO "local" VALUES('Canary Islands','Canary Islands',28.0,-15.5,'ES','53',1968280,'Atlantic/Canary');
INSERT INTO "local" VALUES('Provincia de Cádiz','Provincia de Cadiz',36.5,-5.75,'ES','51',1230594,'Europe/Madrid');
INSERT INTO "local" VALUES('Comunitat Autònoma de les Illes Balears','Comunitat Autonoma de les Illes Balears',39.58876,2.90314,'ES','07',1095426,'Europe/Madrid');
INSERT INTO "local" VALUES('Provincia de Alicante','Provincia de Alicante',38.5,-0.5,'ES','60',1917012,'Europe/Madrid');
INSERT INTO "local" VALUES('Andalucía','Andalucia',37.6,-4.5,'ES','51',8302923,'Europe/Madrid');
INSERT INTO "local" VALUES('Canarias','Canarias',28.0,-15.5,'ES','53',2103992,'Atlantic/Canary');
INSERT INTO "local" VALUES('Castilla-La Mancha','Castilla-La Mancha',39.5,-3.0,'ES','54',2081313,'Europe/Madrid');
INSERT INTO "local" VALUES('Extremadura','Extremadura',39.0,-6.0,'ES','57',1102410,'Europe/Madrid');
INSERT INTO "local" VALUES('Comunitat Valenciana','Comunitat Valenciana',39.5,-0.75,'ES','60',5094675,'Europe/Madrid');
INSERT INTO "local" VALUES('Bizkaia','Bizkaia',43.25,-2.91667,'ES','59',1152658,'Europe/Madrid');
INSERT INTO "local" VALUES('Principality of Asturias','Principality of Asturias',43.33333,-6.0,'ES','34',1085289,'Europe/Madrid');
INSERT INTO "local" VALUES('Comunidad de Madrid','Comunidad de Madrid',40.42526,-3.69063,'ES','29',6386932,'Europe/Madrid');
INSERT INTO "local" VALUES('Madrid','Madrid',40.4165,-3.70256,'ES','29',3255944,'Europe/Madrid');
INSERT INTO "local" VALUES('Provincia da Coruña','Provincia da Coruna',43.16667,-8.41667,'ES','58',1145488,'Europe/Madrid');
INSERT INTO "local" VALUES('Província de Barcelona','Provincia de Barcelona',41.66667,2.0,'ES','56',5487935,'Europe/Madrid');
INSERT INTO "local" VALUES('Barcelona','Barcelona',41.38879,2.15899,'ES','56',1621537,'Europe/Madrid');
INSERT INTO "local" VALUES('Aragón','Aragon',41.0,-1.0,'ES','52',1345473,'Europe/Madrid');
INSERT INTO "local" VALUES('Castilla y León','Castilla y Leon',41.66667,-4.25,'ES','55',2563521,'Europe/Madrid');
INSERT INTO "local" VALUES('Catalunya','Catalunya',41.82046,1.86768,'ES','56',7475420,'Europe/Madrid');
INSERT INTO "local" VALUES('Galicia','Galicia',42.75508,-7.86621,'ES','58',2796089,'Europe/Madrid');
INSERT INTO "local" VALUES('Euskal Autonomia Erkidegoa / Comunidad Autónoma Vasca','Euskal Autonomia Erkidegoa',43.0,-2.75,'ES','59',2172175,'Europe/Madrid');
INSERT INTO "local" VALUES('Provincia de Madrid','Provincia de Madrid',40.40225,-3.71029,'ES','29',6386932,'Europe/Madrid');
INSERT INTO "local" VALUES('Murcia','Murcia',37.98662,-1.14146,'ES','31',1446520,'Europe/Madrid');
INSERT INTO "local" VALUES('Province of Asturias','Province of Asturias',43.36662,-5.86112,'ES','34',1085289,'Europe/Madrid');
INSERT INTO "local" VALUES('Barcelona','Barcelona',41.39942,2.12804,'ES','56',1620943,'Europe/Madrid');
INSERT INTO "local" VALUES('Madrid','Madrid',40.48935,-3.68275,'ES','29',3233527,'Europe/Madrid');
INSERT INTO "local" VALUES('Illes Balears','Illes Balears',39.60992,3.02948,'ES','07',1095426,'Europe/Madrid');
INSERT INTO "local" VALUES('Wolayita Zone','Wolayita Zone',6.84312,37.70051,'ET','54',1501112,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Hadiya Zone','Hadiya Zone',7.5,37.75,'ET','54',1231196,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Jimma Zone','Jimma Zone',7.66667,37.0,'ET','51',2486155,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Federal Democratic Republic of Ethiopia','Federal Democratic Republic of Ethiopia',9.0,39.5,'ET','00',88013491,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Guraghe Zone','Guraghe Zone',8.25,38.0,'ET','54',1279646,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Addis Ababa','Addis Ababa',9.02497,38.74689,'ET','44',2757729,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Afar Region','Afar Region',12.0,41.5,'ET','45',1602995,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Amhara Region','Amhara Region',11.5,38.5,'ET','46',17221976,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Oromiya Region','Oromiya Region',8.0,39.0,'ET','51',27158471,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Southern Nations, Nationalities, and People''s Region','Southern Nations, Nationalities, and People''s Region',6.05862,36.7273,'ET','54',15042531,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Southern Tigray Zone','Southern Tigray Zone',12.96033,39.52831,'ET','53',1239988,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('North Shewa Zone','North Shewa Zone',9.66915,38.8124,'ET','51',1431305,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('East Shewa Zone','East Shewa Zone',8.21353,38.84809,'ET','51',1356342,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('East Wellega Zone','East Wellega Zone',9.51928,36.75762,'ET','51',1213503,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('South Wollo Zone','South Wollo Zone',11.0,39.25,'ET','46',2518862,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Illubabor Zone','Illubabor Zone',8.27526,35.75596,'ET','51',1271609,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('West Wellega Zone','West Wellega Zone',9.17283,35.05279,'ET','51',1350415,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('West Harerghe Zone','West Harerghe Zone',8.67245,40.84885,'ET','51',1871706,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('East Harerghe Zone','East Harerghe Zone',8.70114,42.00241,'ET','51',2723850,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('South Gondar Zone','South Gondar Zone',11.8385,38.09954,'ET','46',2051738,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('North Wollo Zone','North Wollo Zone',11.92,39.1,'ET','46',1500303,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('North Shewa Zone','North Shewa Zone',9.769,39.668,'ET','46',1837490,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Sidama Zone','Sidama Zone',6.718,38.448,'ET','54',2954136,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Guji Zone','Guji Zone',5.588,39.067,'ET','51',1389800,'Africa/Addis_Ababa');
INSERT INTO "local" VALUES('Republic of Finland','Republic of Finland',64.0,26.0,'FI','00',5244000,'Europe/Helsinki');
INSERT INTO "local" VALUES('Southern Finland Province','Southern Finland Province',60.83333,26.0,'FI','13',2209677,'Europe/Helsinki');
INSERT INTO "local" VALUES('Province of Western Finland','Province of Western Finland',62.0,24.0,'FI','15',1889542,'Europe/Helsinki');
INSERT INTO "local" VALUES('Département des Yvelines','Departement des Yvelines',48.78333,1.86667,'FR','A8',1433447,'Europe/Paris');
INSERT INTO "local" VALUES('Paris','Paris',48.8534,2.3486,'FR','A8',2257981,'Europe/Paris');
INSERT INTO "local" VALUES('Département du Var','Departement du Var',43.5,6.33333,'FR','B8',1025201,'Europe/Paris');
INSERT INTO "local" VALUES('Département du Val-d''Oise','Departement du Val-d''Oise',49.06667,2.06667,'FR','A8',1185379,'Europe/Paris');
INSERT INTO "local" VALUES('Département du Val-de-Marne','Departement du Val-de-Marne',48.78333,2.45,'FR','A8',1331443,'Europe/Paris');
INSERT INTO "local" VALUES('Département de Seine-Saint-Denis','Departement de Seine-Saint-Denis',48.91667,2.5,'FR','A8',1528413,'Europe/Paris');
INSERT INTO "local" VALUES('Département de la Seine-Maritime','Departement de la Seine-Maritime',49.75,1.0,'FR','A7',1275483,'Europe/Paris');
INSERT INTO "local" VALUES('Département de Seine-et-Marne','Departement de Seine-et-Marne',48.5,3.0,'FR','A8',1335284,'Europe/Paris');
INSERT INTO "local" VALUES('Région Rhône-Alpes','Region Rhone-Alpes',45.5,5.33333,'FR','B9',6065959,'Europe/Paris');
INSERT INTO "local" VALUES('Région Provence-Alpes-Côte d''Azur','Region Provence-Alpes-Cote d''Azur',44.0,6.0,'FR','B8',4864015,'Europe/Paris');
INSERT INTO "local" VALUES('Région Poitou-Charentes','Region Poitou-Charentes',46.08333,0.16667,'FR','B7',1739780,'Europe/Paris');
INSERT INTO "local" VALUES('Région Picardie','Region Picardie',50.0,3.5,'FR','B6',1900354,'Europe/Paris');
INSERT INTO "local" VALUES('Département du Rhône','Departement du Rhone',46.0,4.5,'FR','B9',1738949,'Europe/Paris');
INSERT INTO "local" VALUES('Région Pays de la Loire','Region Pays de la Loire',47.5,-1.0,'FR','B5',3482594,'Europe/Paris');
INSERT INTO "local" VALUES('Département du Pas-de-Calais','Departement du Pas-de-Calais',50.5,2.33333,'FR','B4',1488951,'Europe/Paris');
INSERT INTO "local" VALUES('Paris','Paris',48.85339,2.34864,'FR','A8',2257981,'Europe/Paris');
INSERT INTO "local" VALUES('Paris','Paris',48.85341,2.3488,'FR','A8',2138551,'Europe/Paris');
INSERT INTO "local" VALUES('Région Nord-Pas-de-Calais','Region Nord-Pas-de-Calais',50.5,2.5,'FR','B4',4021676,'Europe/Paris');
INSERT INTO "local" VALUES('Département du Nord','Departement du Nord',50.33333,3.66667,'FR','B4',2613285,'Europe/Paris');
INSERT INTO "local" VALUES('Département de la Moselle','Departement de la Moselle',49.0,6.5,'FR','B2',1066328,'Europe/Paris');
INSERT INTO "local" VALUES('Région Midi-Pyrénées','Region Midi-Pyrenees',43.5,1.33333,'FR','B3',2810247,'Europe/Paris');
INSERT INTO "local" VALUES('Arrondissement de Marseille','Arrondissement de Marseille',43.33333,5.5,'FR','B8',1057717,'Europe/Paris');
INSERT INTO "local" VALUES('Arrondissement de Lyon','Arrondissement de Lyon',45.75,4.58333,'FR','B9',1541416,'Europe/Paris');
INSERT INTO "local" VALUES('Région Lorraine','Region Lorraine',49.0,6.0,'FR','B2',2339881,'Europe/Paris');
INSERT INTO "local" VALUES('Département de la Loire-Atlantique','Departement de la Loire-Atlantique',47.25,-1.83333,'FR','B5',1301325,'Europe/Paris');
INSERT INTO "local" VALUES('Arrondissement de Lille','Arrondissement de Lille',50.58333,3.08333,'FR','B4',1222209,'Europe/Paris');
INSERT INTO "local" VALUES('Région Languedoc-Roussillon','Region Languedoc-Roussillon',43.66667,3.16667,'FR','A9',2560870,'Europe/Paris');
INSERT INTO "local" VALUES('Département de l''Isère','Departement de l''Isere',45.16667,5.83333,'FR','B9',1223730,'Europe/Paris');
INSERT INTO "local" VALUES('Département d''Ille-et-Vilaine','Departement d''Ille-et-Vilaine',48.16667,-1.5,'FR','A2',1003933,'Europe/Paris');
INSERT INTO "local" VALUES('Région Île-de-France','Region Ile-de-France',48.5,2.5,'FR','A8',11598866,'Europe/Paris');
INSERT INTO "local" VALUES('Département de l''Hérault','Departement de l''Herault',43.66667,3.5,'FR','A9',1050026,'Europe/Paris');
INSERT INTO "local" VALUES('Département des Hauts-de-Seine','Departement des Hauts-de-Seine',48.85,2.2,'FR','A8',1579457,'Europe/Paris');
INSERT INTO "local" VALUES('Région Haute-Normandie','Region Haute-Normandie',49.5,1.0,'FR','A7',1816716,'Europe/Paris');
INSERT INTO "local" VALUES('Département de la Haute-Garonne','Departement de la Haute-Garonne',43.41667,1.5,'FR','B3',1254347,'Europe/Paris');
INSERT INTO "local" VALUES('Département de la Gironde','Departement de la Gironde',44.91667,-0.5,'FR','97',1464088,'Europe/Paris');
INSERT INTO "local" VALUES('Région Franche-Comté','Region Franche-Comte',47.0,6.0,'FR','A6',1158671,'Europe/Paris');
INSERT INTO "local" VALUES('Republic of France','Republic of France',46.0,2.0,'FR','00',64768389,'Europe/Paris');
INSERT INTO "local" VALUES('Département de l''Essonne','Departement de l''Essonne',48.5,2.25,'FR','A8',1225717,'Europe/Paris');
INSERT INTO "local" VALUES('Région Champagne-Ardenne','Region Champagne-Ardenne',49.0,4.5,'FR','A4',1339487,'Europe/Paris');
INSERT INTO "local" VALUES('Région Centre','Region Centre',47.5,1.75,'FR','A3',2526919,'Europe/Paris');
INSERT INTO "local" VALUES('Région Bretagne','Region Bretagne',48.0,-3.0,'FR','A2',3120288,'Europe/Paris');
INSERT INTO "local" VALUES('Région Bourgogne','Region Bourgogne',47.0,4.5,'FR','A1',1633891,'Europe/Paris');
INSERT INTO "local" VALUES('Département des Bouches-du-Rhône','Departement des Bouches-du-Rhone',43.5,5.0,'FR','B8',1995094,'Europe/Paris');
INSERT INTO "local" VALUES('Région Basse-Normandie','Region Basse-Normandie',49.0,-1.0,'FR','99',1461429,'Europe/Paris');
INSERT INTO "local" VALUES('Département du Bas-Rhin','Departement du Bas-Rhin',48.58333,7.66667,'FR','C1',1113207,'Europe/Paris');
INSERT INTO "local" VALUES('Région Auvergne','Region Auvergne',45.33333,3.0,'FR','98',1339247,'Europe/Paris');
INSERT INTO "local" VALUES('Région Aquitaine','Region Aquitaine',44.58333,1.0,'FR','97',3150890,'Europe/Paris');
INSERT INTO "local" VALUES('Région Alsace','Region Alsace',48.5,7.5,'FR','C1',1827248,'Europe/Paris');
INSERT INTO "local" VALUES('Département des Alpes-Maritimes','Departement des Alpes-Maritimes',44.0,7.16667,'FR','B8',1094596,'Europe/Paris');
INSERT INTO "local" VALUES('Gabonese Republic','Gabonese Republic',-1.0,11.75,'GA','00',1545255,'Africa/Libreville');
INSERT INTO "local" VALUES('Yorkshire','Yorkshire',54.0,-1.5,'GB','ENG',3978484,'Europe/London');
INSERT INTO "local" VALUES('West Yorkshire','West Yorkshire',53.7,-1.58333,'GB','ENG',2161200,'Europe/London');
INSERT INTO "local" VALUES('West Midlands','West Midlands',52.5,-1.96667,'GB','ENG',2600100,'Europe/London');
INSERT INTO "local" VALUES('Wales','Wales',52.5,-3.5,'GB','WLS',3000000,'Europe/London');
INSERT INTO "local" VALUES('United Kingdom of Great Britain and Northern Ireland','United Kingdom of Great Britain and Northern Ireland',54.75844,-2.69531,'GB','00',62348447,'Europe/London');
INSERT INTO "local" VALUES('Tyne and Wear','Tyne and Wear',54.91667,-1.56667,'GB','ENG',1087600,'Europe/London');
INSERT INTO "local" VALUES('Surrey','Surrey',51.25,-0.33333,'GB','ENG',1085400,'Europe/London');
INSERT INTO "local" VALUES('Strathclyde Region','Strathclyde Region',55.81209,-4.02649,'GB','SCT',2435104,'Europe/London');
INSERT INTO "local" VALUES('Staffordshire','Staffordshire',52.83333,-2.0,'GB','ENG',1098300,'Europe/London');
INSERT INTO "local" VALUES('South Yorkshire','South Yorkshire',53.45,-1.25,'GB','ENG',1292900,'Europe/London');
INSERT INTO "local" VALUES('Scotland','Scotland',56.0,-4.0,'GB','SCT',5000000,'Europe/London');
INSERT INTO "local" VALUES('Nottinghamshire','Nottinghamshire',53.16667,-1.0,'GB','ENG',1055400,'Europe/London');
INSERT INTO "local" VALUES('North Yorkshire','North Yorkshire',54.16667,-1.5,'GB','ENG',1061300,'Europe/London');
INSERT INTO "local" VALUES('Northern Ireland','Northern Ireland',54.5,-6.5,'GB','NIR',1700000,'Europe/London');
INSERT INTO "local" VALUES('Merseyside','Merseyside',53.4,-3.08333,'GB','ENG',1353600,'Europe/London');
INSERT INTO "local" VALUES('City of London','City of London',51.51279,-0.09184,'GB','ENG',7556900,'Europe/London');
INSERT INTO "local" VALUES('London','London',51.50853,-0.12574,'GB','ENG',7556900,'Europe/London');
INSERT INTO "local" VALUES('Lincolnshire','Lincolnshire',53.16667,-0.25,'GB','ENG',1004200,'Europe/London');
INSERT INTO "local" VALUES('Lancashire','Lancashire',53.83333,-2.5,'GB','ENG',1449700,'Europe/London');
INSERT INTO "local" VALUES('Hertfordshire','Hertfordshire',51.83333,-0.25,'GB','ENG',1058600,'Europe/London');
INSERT INTO "local" VALUES('Hampshire','Hampshire',51.0,-1.25,'GB','ENG',1691000,'Europe/London');
INSERT INTO "local" VALUES('Greater Manchester','Greater Manchester',53.45,-2.23333,'GB','ENG',2553700,'Europe/London');
INSERT INTO "local" VALUES('Greater London','Greater London',51.5,-0.16667,'GB','ENG',7504800,'Europe/London');
INSERT INTO "local" VALUES('Essex','Essex',51.83333,0.58333,'GB','ENG',1670000,'Europe/London');
INSERT INTO "local" VALUES('Devon','Devon',50.75,-3.75,'GB','ENG',1122100,'Europe/London');
INSERT INTO "local" VALUES('Kent','Kent',51.16667,0.66667,'GB','ENG',1634500,'Europe/London');
INSERT INTO "local" VALUES('England','England',52.16045,-0.70312,'GB','ENG',50000000,'Europe/London');
INSERT INTO "local" VALUES('Home Counties','Home Counties',51.22473,-0.06969,'GB','ENG',8000550,'Europe/London');
INSERT INTO "local" VALUES('K''alak''i T''bilisi','K''alak''i T''bilisi',41.71667,44.83333,'GE','51',1106539,'Asia/Tbilisi');
INSERT INTO "local" VALUES('Tbilisi','Tbilisi',41.69411,44.83368,'GE','51',1049498,'Asia/Tbilisi');
INSERT INTO "local" VALUES('Georgia','Georgia',41.99998,43.4999,'GE','00',4630000,'Asia/Tbilisi');
INSERT INTO "local" VALUES('Volta Region','Volta Region',7.0,0.5,'GH','08',1738710,'Africa/Accra');
INSERT INTO "local" VALUES('Northern Region','Northern Region',9.5,-1.0,'GH','06',2003152,'Africa/Accra');
INSERT INTO "local" VALUES('Kumasi','Kumasi',6.68848,-1.62443,'GH','02',1468609,'Africa/Accra');
INSERT INTO "local" VALUES('Greater Accra Region','Greater Accra Region',5.75,0.0,'GH','01',3460792,'Africa/Accra');
INSERT INTO "local" VALUES('Republic of Ghana','Republic of Ghana',8.1,-1.2,'GH','00',24339838,'Africa/Accra');
INSERT INTO "local" VALUES('Central Region','Central Region',5.5,-1.0,'GH','04',1717543,'Africa/Accra');
INSERT INTO "local" VALUES('Brong-Ahafo Region','Brong-Ahafo Region',7.75,-1.5,'GH','03',1973199,'Africa/Accra');
INSERT INTO "local" VALUES('Ashanti Region','Ashanti Region',6.75,-1.5,'GH','02',4105402,'Africa/Accra');
INSERT INTO "local" VALUES('Accra','Accra',5.55602,-0.1969,'GH','01',1963264,'Africa/Accra');
INSERT INTO "local" VALUES('Gambia','Gambia',13.5,-15.5,'GM','00',1593256,'Africa/Banjul');
INSERT INTO "local" VALUES('Republic of Guinea','Republic of Guinea',10.83333,-10.66667,'GN','00',10324025,'Africa/Conakry');
INSERT INTO "local" VALUES('Conakry Region','Conakry Region',9.603,-13.597,'GN','04',1871242,'Africa/Conakry');
INSERT INTO "local" VALUES('Conakry','Conakry',9.53795,-13.67729,'GN','04',1767200,'Africa/Conakry');
INSERT INTO "local" VALUES('Camayenne','Camayenne',9.535,-13.68778,'GN','04',1871242,'Africa/Conakry');
INSERT INTO "local" VALUES('Republic of Equatorial Guinea','Republic of Equatorial Guinea',1.7,10.5,'GQ','00',1014999,'Africa/Malabo');
INSERT INTO "local" VALUES('Hellenic Republic','Hellenic Republic',39.0,22.0,'GR','00',11000000,'Europe/Athens');
INSERT INTO "local" VALUES('Attica','Attica',37.92037,23.9035,'GR','ESYE31',3761810,'Europe/Athens');
INSERT INTO "local" VALUES('Central Macedonia','Central Macedonia',40.91351,22.84058,'GR','ESYE12',1871952,'Europe/Athens');
INSERT INTO "local" VALUES('Republic of Guatemala','Republic of Guatemala',15.5,-90.25,'GT','00',13550440,'America/Guatemala');
INSERT INTO "local" VALUES('Republic of Guinea-Bissau','Republic of Guinea-Bissau',12.0,-15.0,'GW','00',1565126,'Africa/Bissau');
INSERT INTO "local" VALUES('Kowloon','Kowloon',22.31667,114.18333,'HK','KKC',2019533,'Asia/Hong_Kong');
INSERT INTO "local" VALUES('Hong Kong','Hong Kong',22.28552,114.15769,'HK','00',7012738,'Asia/Hong_Kong');
INSERT INTO "local" VALUES('Hong Kong Special Administrative Region','Hong Kong Special Administrative Region',22.25,114.16667,'HK','00',6898686,'Asia/Hong_Kong');
INSERT INTO "local" VALUES('Republic of Honduras','Republic of Honduras',15.0,-86.5,'HN','00',7989415,'America/Tegucigalpa');
INSERT INTO "local" VALUES('Republic of Croatia','Republic of Croatia',45.16667,15.5,'HR','00',4491000,'Europe/Zagreb');
INSERT INTO "local" VALUES('Port-au-Prince','Port-au-Prince',18.53917,-72.335,'HT','11',1234742,'America/Port-au-Prince');
INSERT INTO "local" VALUES('Republic of Haiti','Republic of Haiti',19.0,-72.41667,'HT','00',9648924,'America/Port-au-Prince');
INSERT INTO "local" VALUES('Hungary','Hungary',47.0,20.0,'HU','00',9982000,'Europe/Budapest');
INSERT INTO "local" VALUES('Pest megye','Pest megye',47.41667,19.33333,'HU','16',1213090,'Europe/Budapest');
INSERT INTO "local" VALUES('Budapest főváros','Budapest fovaros',47.5,19.08333,'HU','05',1696128,'Europe/Budapest');
INSERT INTO "local" VALUES('Budapest','Budapest',47.49801,19.03991,'HU','05',1741041,'Europe/Budapest');
INSERT INTO "local" VALUES('Sumatera Utara','Sumatera Utara',2.0,99.0,'ID','26',9630873,'Asia/Jakarta');
INSERT INTO "local" VALUES('Medan','Medan',3.58333,98.66667,'ID','26',1750971,'Asia/Jakarta');
INSERT INTO "local" VALUES('Kabupaten Deli Serdang','Kabupaten Deli Serdang',3.483,98.6887,'ID','26',1686000,'Asia/Jakarta');
INSERT INTO "local" VALUES('Nanggroe Aceh Darussalam Province','Nanggroe Aceh Darussalam Province',4.0,97.0,'ID','01',4748085,'Asia/Jakarta');
INSERT INTO "local" VALUES('Daerah Istimewa Yogyakarta','Daerah Istimewa Yogyakarta',-7.75,110.5,'ID','10',3665448,'Asia/Jakarta');
INSERT INTO "local" VALUES('Makassar','Makassar',-5.14,119.4221,'ID','38',1321717,'Asia/Makassar');
INSERT INTO "local" VALUES('Tangerang','Tangerang',-6.17806,106.63,'ID','33',1372124,'Asia/Jakarta');
INSERT INTO "local" VALUES('Surabaya','Surabaya',-7.24917,112.75083,'ID','08',2374658,'Asia/Jakarta');
INSERT INTO "local" VALUES('Sumatera Selatan','Sumatera Selatan',-2.75,103.83333,'ID','32',7743794,'Asia/Jakarta');
INSERT INTO "local" VALUES('Provinsi Sumatera Barat','Provinsi Sumatera Barat',-1.0,100.5,'ID','24',5014112,'Asia/Jakarta');
INSERT INTO "local" VALUES('Sumatra','Sumatra',0.0,102.0,'ID','00',50365538,'Asia/Jakarta');
INSERT INTO "local" VALUES('Sulawesi Utara','Sulawesi Utara',1.25,124.83333,'ID','31',2270596,'Asia/Makassar');
INSERT INTO "local" VALUES('Sulawesi Tenggara','Sulawesi Tenggara',-4.3935,122.2149,'ID','22',2232586,'Asia/Makassar');
INSERT INTO "local" VALUES('Sulawesi Tengah','Sulawesi Tengah',-0.9166,122.3538,'ID','21',2635009,'Asia/Makassar');
INSERT INTO "local" VALUES('Provinsi Sulawesi Selatan','Provinsi Sulawesi Selatan',-4.33333,120.25,'ID','38',8034776,'Asia/Makassar');
INSERT INTO "local" VALUES('Semarang','Semarang',-6.9932,110.4203,'ID','07',1288084,'Asia/Jakarta');
INSERT INTO "local" VALUES('Provinsi Riau','Provinsi Riau',0.5005,101.749,'ID','37',5714477,'Asia/Jakarta');
INSERT INTO "local" VALUES('Palembang','Palembang',-2.91673,104.7458,'ID','32',1441500,'Asia/Jakarta');
INSERT INTO "local" VALUES('West Nusa Tenggara','West Nusa Tenggara',-8.74,117.5333,'ID','17',4500212,'Asia/Makassar');
INSERT INTO "local" VALUES('Provinsi Maluku','Provinsi Maluku',-3.23846,130.14527,'ID','28',1531402,'Asia/Jayapura');
INSERT INTO "local" VALUES('Provinsi Lampung','Provinsi Lampung',-5.0,105.0,'ID','15',4817226,'Asia/Jakarta');
INSERT INTO "local" VALUES('Provinsi Kalimantan Timur','Provinsi Kalimantan Timur',0.5,116.5,'ID','14',3553143,'Asia/Makassar');
INSERT INTO "local" VALUES('Provinsi Kalimantan Tengah','Provinsi Kalimantan Tengah',-2.0,113.5,'ID','13',2212089,'Asia/Pontianak');
INSERT INTO "local" VALUES('Provinsi Kalimantan Selatan','Provinsi Kalimantan Selatan',-2.5,115.5,'ID','12',3626616,'Asia/Jakarta');
INSERT INTO "local" VALUES('Provinsi Kalimantan Barat','Provinsi Kalimantan Barat',0.0,110.5,'ID','11',4395983,'Asia/Pontianak');
INSERT INTO "local" VALUES('Kabupaten Jepara','Kabupaten Jepara',-6.5,110.83333,'ID','07',1100000,'Asia/Jakarta');
INSERT INTO "local" VALUES('Jawa Timur','Jawa Timur',-7.7394,112.5099,'ID','08',22200177,'Asia/Jakarta');
INSERT INTO "local" VALUES('Provinsi Jawa Tengah','Provinsi Jawa Tengah',-7.5,110.0,'ID','07',34087148,'Asia/Jakarta');
INSERT INTO "local" VALUES('Jawa Barat','Jawa Barat',-6.75,107.5,'ID','30',45278744,'Asia/Jakarta');
INSERT INTO "local" VALUES('Provinsi Jambi','Provinsi Jambi',-1.5,103.0,'ID','05',3249601,'Asia/Jakarta');
INSERT INTO "local" VALUES('Kotamadya Jakarta Utara','Kotamadya Jakarta Utara',-6.1339,106.8823,'ID','04',1645312,'Asia/Jakarta');
INSERT INTO "local" VALUES('Kotamadya Jakarta Selatan','Kotamadya Jakarta Selatan',-6.266,106.8135,'ID','04',2057080,'Asia/Jakarta');
INSERT INTO "local" VALUES('Daerah Khusus Ibukota Jakarta','Daerah Khusus Ibukota Jakarta',-6.2182,106.8584,'ID','04',9953016,'Asia/Jakarta');
INSERT INTO "local" VALUES('Jakarta','Jakarta',-6.21462,106.84513,'ID','04',8540121,'Asia/Jakarta');
INSERT INTO "local" VALUES('Provinsi Papua','Provinsi Papua',-4.75,138.0,'ID','36',2833381,'Asia/Jayapura');
INSERT INTO "local" VALUES('Republic of Indonesia','Republic of Indonesia',-5.0,120.0,'ID','00',242968342,NULL);
INSERT INTO "local" VALUES('Depok','Depok',-6.4,106.81861,'ID','30',1198129,'Asia/Jakarta');
INSERT INTO "local" VALUES('Borneo','Borneo',1.0,114.0,'ID','',19000000,'Asia/Makassar');
INSERT INTO "local" VALUES('Kotamadya Bengkulu','Kotamadya Bengkulu',-3.8,102.26667,'ID','00',1794484,'Asia/Jakarta');
INSERT INTO "local" VALUES('Bekasi','Bekasi',-6.2349,106.9896,'ID','30',1520119,'Asia/Jakarta');
INSERT INTO "local" VALUES('Bandung Regency','Bandung Regency',-6.99667,107.4975,'ID','30',3174499,'Asia/Jakarta');
INSERT INTO "local" VALUES('Bandung','Bandung',-6.90389,107.61861,'ID','30',1699719,'Asia/Jakarta');
INSERT INTO "local" VALUES('Provinsi Bali','Provinsi Bali',-8.5,115.0,'ID','02',3890757,'Asia/Makassar');
INSERT INTO "local" VALUES('Banten','Banten',-6.5,106.25,'ID','33',10632166,'Asia/Jakarta');
INSERT INTO "local" VALUES('Provinsi Gorontalo','Provinsi Gorontalo',0.693,122.4704,'ID','34',1040164,'Asia/Makassar');
INSERT INTO "local" VALUES('Kepulauan Bangka Belitung','Kepulauan Bangka Belitung',-2.66667,106.66667,'ID','35',1276873,'Asia/Jakarta');
INSERT INTO "local" VALUES('Provinsi Maluku Utara','Provinsi Maluku Utara',-0.25,127.5,'ID','29',1038087,'Asia/Jayapura');
INSERT INTO "local" VALUES('Provinsi Sulawesi Barat','Provinsi Sulawesi Barat',-2.5,119.3333,'ID','41',1158651,'Asia/Makassar');
INSERT INTO "local" VALUES('Provinsi Kepulauan Riau','Provinsi Kepulauan Riau',0.61667,106.98333,'ID','40',1747812,'Asia/Pontianak');
INSERT INTO "local" VALUES('Kota Administratip Klaten','Kota Administratip Klaten',-7.71889,110.60528,'ID','07',1129862,'Asia/Jakarta');
INSERT INTO "local" VALUES('Kotamadya Bekasi','Kotamadya Bekasi',-6.2873,106.9806,'ID','30',2378211,'Asia/Jakarta');
INSERT INTO "local" VALUES('Kotamadya Depok','Kotamadya Depok',-6.3726,106.8275,'ID','30',1751696,'Asia/Jakarta');
INSERT INTO "local" VALUES('South Tangerang','South Tangerang',-6.28862,106.71789,'ID','33',1303569,'Asia/Jakarta');
INSERT INTO "local" VALUES('Ireland','Ireland',53.0,-8.0,'IE','00',4622917,'Europe/Dublin');
INSERT INTO "local" VALUES('Baile Átha Cliath','Baile Atha Cliath',53.38046,-6.27113,'IE','L',1146503,'Europe/Dublin');
INSERT INTO "local" VALUES('Dublin','Dublin',53.33306,-6.24889,'IE','L',1024027,'Europe/Dublin');
INSERT INTO "local" VALUES('Leinster','Leinster',53.16667,-7.02121,'IE','L',2504814,'Europe/Dublin');
INSERT INTO "local" VALUES('Munster','Munster',52.34333,-8.71667,'IE','M',1246088,'Europe/Dublin');
INSERT INTO "local" VALUES('Ulster','Ulster',54.36111,-7.41667,'IE','U',2101164,'Europe/Dublin');
INSERT INTO "local" VALUES('Tel Aviv District','Tel Aviv District',32.08414,34.79995,'IL','05',1221600,'Asia/Jerusalem');
INSERT INTO "local" VALUES('State of Israel','State of Israel',31.5,34.75,'IL','00',7353985,'Asia/Jerusalem');
INSERT INTO "local" VALUES('Northern District','Northern District',32.83333,35.33333,'IL','03',1197985,'Asia/Jerusalem');
INSERT INTO "local" VALUES('State of West Bengal','State of West Bengal',24.0,88.0,'IN','28',84600002,'Asia/Kolkata');
INSERT INTO "local" VALUES('Vishākhapatnam','Vishakhapatnam',17.69004,83.20925,'IN','02',1063178,'Asia/Kolkata');
INSERT INTO "local" VALUES('Vārānasi','Varanasi',25.31668,83.01042,'IN','36',1164404,'Asia/Kolkata');
INSERT INTO "local" VALUES('Vadodara','Vadodara',22.2994,73.20812,'IN','09',1409476,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Uttar Pradesh','State of Uttar Pradesh',27.25,80.75,'IN','36',166052900,'Asia/Kolkata');
INSERT INTO "local" VALUES('Tuticorin','Tuticorin',8.78333,78.13333,'IN','25',1572273,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Tripura','State of Tripura',24.0,92.0,'IN','26',3191168,'Asia/Kolkata');
INSERT INTO "local" VALUES('Thāne','Thane',19.19704,72.96356,'IN','16',1261517,'Asia/Kolkata');
INSERT INTO "local" VALUES('Teni','Teni',10.01531,77.482,'IN','25',1034724,'Asia/Kolkata');
INSERT INTO "local" VALUES('Telengana','Telengana',18.0,79.5,'IN','02',35286757,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Tamil Nādu','State of Tamil Nadu',11.0,78.0,'IN','25',63995556,'Asia/Kolkata');
INSERT INTO "local" VALUES('Sūrat','Surat',21.19594,72.83023,'IN','09',2894504,'Asia/Kolkata');
INSERT INTO "local" VALUES('Rājkot','Rajkot',22.29161,70.79322,'IN','09',1177362,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Rājasthān','State of Rajasthan',26.0,74.0,'IN','24',61337382,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Punjab','State of Punjab',30.91667,75.41667,'IN','23',27704236,'Asia/Kolkata');
INSERT INTO "local" VALUES('Pune','Pune',18.51957,73.85535,'IN','16',2935744,'Asia/Kolkata');
INSERT INTO "local" VALUES('Pimpri','Pimpri',18.62292,73.80696,'IN','16',1284606,'Asia/Kolkata');
INSERT INTO "local" VALUES('Patna','Patna',25.60222,85.11936,'IN','34',1599920,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Odisha','State of Odisha',20.5,84.41667,'IN','21',36706920,'Asia/Kolkata');
INSERT INTO "local" VALUES('Nashik','Nashik',19.99727,73.79096,'IN','16',1289497,'Asia/Kolkata');
INSERT INTO "local" VALUES('Nagpur','Nagpur',21.14631,79.08491,'IN','16',2228018,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Nāgāland','State of Nagaland',26.0,94.25,'IN','20',2367478,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Meghālaya','State of Meghalaya',25.5,91.33333,'IN','18',2520146,'Asia/Kolkata');
INSERT INTO "local" VALUES('Meerut','Meerut',28.97155,77.71934,'IN','36',1223184,'Asia/Kolkata');
INSERT INTO "local" VALUES('Medak','Medak',17.75,78.25,'IN','02',2670097,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Manipur','State of Manipur',25.0,94.0,'IN','17',2388634,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Mahārāshtra','State of Maharashtra',19.5,75.0,'IN','16',103391791,'Asia/Kolkata');
INSERT INTO "local" VALUES('Chennai','Chennai',13.08784,80.27847,'IN','25',4328063,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Madhya Pradesh','State of Madhya Pradesh',23.5,78.5,'IN','35',60385118,'Asia/Kolkata');
INSERT INTO "local" VALUES('Ludhiāna','Ludhiana',30.90015,75.85229,'IN','23',1545368,'Asia/Kolkata');
INSERT INTO "local" VALUES('Lucknow','Lucknow',26.83928,80.92313,'IN','36',2472011,'Asia/Kolkata');
INSERT INTO "local" VALUES('Koraput','Koraput',19.0,83.0,'IN','21',1177954,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Kerala','State of Kerala',10.0,76.5,'IN','13',31838619,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Karnātaka','State of Karnataka',13.5,76.0,'IN','19',55437258,'Asia/Kolkata');
INSERT INTO "local" VALUES('Kānpur','Kanpur',26.4478,80.34627,'IN','36',2823249,'Asia/Kolkata');
INSERT INTO "local" VALUES('Kalyān','Kalyan',19.2437,73.13554,'IN','16',1262255,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Jammu and Kashmīr','State of Jammu and Kashmir',33.91667,76.66667,'IN','12',10069917,'Asia/Kolkata');
INSERT INTO "local" VALUES('Jaipur','Jaipur',26.91962,75.78781,'IN','24',2711758,'Asia/Kolkata');
INSERT INTO "local" VALUES('Jabalpur','Jabalpur',23.16697,79.95006,'IN','35',1030168,'Asia/Kolkata');
INSERT INTO "local" VALUES('Indore','Indore',22.71792,75.8333,'IN','35',1837041,'Asia/Kolkata');
INSERT INTO "local" VALUES('Republic of India','Republic of India',22.0,79.0,'IN','00',1173108018,'Asia/Kolkata');
INSERT INTO "local" VALUES('Hyderabad','Hyderabad',17.38405,78.45636,'IN','02',3597816,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Himāchal Pradesh','State of Himachal Pradesh',31.91667,77.25,'IN','11',6394040,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Haryāna','State of Haryana',29.0,76.0,'IN','10',25353081,'Asia/Kolkata');
INSERT INTO "local" VALUES('Hāora','Haora',22.57688,88.31857,'IN','28',1027672,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Gujarāt','State of Gujarat',23.0,72.0,'IN','09',53957371,'Asia/Kolkata');
INSERT INTO "local" VALUES('Gorakhpur','Gorakhpur',29.44702,75.67181,'IN','10',1324570,'Asia/Kolkata');
INSERT INTO "local" VALUES('Goa','Goa',15.33333,74.08333,'IN','33',1225000,'Asia/Kolkata');
INSERT INTO "local" VALUES('Ghāziābād','Ghaziabad',28.66249,77.43777,'IN','36',1199191,'Asia/Kolkata');
INSERT INTO "local" VALUES('Farīdābād','Faridabad',28.41252,77.31977,'IN','10',1220229,'Asia/Kolkata');
INSERT INTO "local" VALUES('Dombivli','Dombivli',19.21667,73.08333,'IN','16',1193000,'Asia/Kolkata');
INSERT INTO "local" VALUES('National Capital Territory of Delhi','National Capital Territory of Delhi',28.6667,77.1,'IN','07',15766943,'Asia/Kolkata');
INSERT INTO "local" VALUES('Delhi','Delhi',28.65381,77.22897,'IN','07',10927986,'Asia/Kolkata');
INSERT INTO "local" VALUES('Cuttack','Cuttack',20.5,86.25,'IN','21',2618708,'Asia/Kolkata');
INSERT INTO "local" VALUES('Union Territory of Chandīgarh','Union Territory of Chandigarh',30.75,76.8,'IN','05',1013325,'Asia/Kolkata');
INSERT INTO "local" VALUES('Kannur','Kannur',12.16667,75.33333,'IN','13',2412365,'Asia/Kolkata');
INSERT INTO "local" VALUES('Kolkata','Kolkata',22.56263,88.36304,'IN','28',4631392,'Asia/Kolkata');
INSERT INTO "local" VALUES('Cāchār','Cachar',25.08333,92.91667,'IN','03',1736391,'Asia/Kolkata');
INSERT INTO "local" VALUES('Mumbai','Mumbai',19.07283,72.88261,'IN','16',12691836,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Bihār','State of Bihar',25.75,85.75,'IN','34',82998509,'Asia/Kolkata');
INSERT INTO "local" VALUES('Bhopal','Bhopal',23.25469,77.40289,'IN','35',1599914,'Asia/Kolkata');
INSERT INTO "local" VALUES('Bāramūla','Baramula',34.56667,74.75,'IN','12',1150652,'Asia/Kolkata');
INSERT INTO "local" VALUES('Bangalore','Bangalore',12.97194,77.59369,'IN','19',5104047,'Asia/Kolkata');
INSERT INTO "local" VALUES('Aurangabad','Aurangabad',19.87757,75.34226,'IN','16',1016441,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Assam','State of Assam',26.0,93.0,'IN','03',26655528,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Arunāchal Pradesh','State of Arunachal Pradesh',27.06,93.37,'IN','30',1183045,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Andhra Pradesh','State of Andhra Pradesh',16.0,79.0,'IN','02',76210007,'Asia/Kolkata');
INSERT INTO "local" VALUES('Amritsar','Amritsar',31.63661,74.87476,'IN','23',1092450,'Asia/Kolkata');
INSERT INTO "local" VALUES('Alappuzha','Alappuzha',9.41667,76.5,'IN','13',2105349,'Asia/Kolkata');
INSERT INTO "local" VALUES('Allahābād','Allahabad',25.44894,81.83328,'IN','36',1073438,'Asia/Kolkata');
INSERT INTO "local" VALUES('Ahmedabad','Ahmedabad',23.02579,72.58726,'IN','09',3719710,'Asia/Kolkata');
INSERT INTO "local" VALUES('Āgra','Agra',27.18333,78.01667,'IN','36',1430055,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Chhattīsgarh','State of Chhattisgarh',21.5,82.0,'IN','37',20795956,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Jharkhand','State of Jharkhand',23.75,85.5,'IN','38',26909428,'Asia/Kolkata');
INSERT INTO "local" VALUES('State of Uttarakhand','State of Uttarakhand',30.25,79.25,'IN','39',8479562,'Asia/Kolkata');
INSERT INTO "local" VALUES('Navi Mumbai','Navi Mumbai',19.03681,73.01582,'IN','16',2600000,'Asia/Kolkata');
INSERT INTO "local" VALUES('Gautam Budh Nagar','Gautam Budh Nagar',28.58075,77.33053,'IN','36',1674714,'Asia/Kolkata');
INSERT INTO "local" VALUES('Konkan Division','Konkan Division',19.07558,72.86914,'IN','16',24000000,'Asia/Kolkata');
INSERT INTO "local" VALUES('Raigad District','Raigad District',18.24229,73.43521,'IN','16',2600000,'Asia/Kolkata');
INSERT INTO "local" VALUES('Thrissur District','Thrissur District',10.52022,76.2204,'IN','13',2975440,'Asia/Kolkata');
INSERT INTO "local" VALUES('South Delhi','South Delhi',28.53009,77.25174,'IN','07',2258367,'Asia/Kolkata');
INSERT INTO "local" VALUES('East Delhi','East Delhi',28.66242,77.29122,'IN','07',1448770,'Asia/Kolkata');
INSERT INTO "local" VALUES('North East Delhi','North East Delhi',28.6869,77.30195,'IN','07',2240749,'Asia/Kolkata');
INSERT INTO "local" VALUES('South West Delhi','South West Delhi',28.5806,77.0672,'IN','07',1749492,'Asia/Kolkata');
INSERT INTO "local" VALUES('North West Delhi','North West Delhi',28.70113,77.10154,'IN','07',3651261,'Asia/Kolkata');
INSERT INTO "local" VALUES('West Delhi','West Delhi',28.65655,77.10068,'IN','07',1743980,'Asia/Kolkata');
INSERT INTO "local" VALUES('Muhafazat Salah ad Din','Muhafazat Salah ad Din',34.5,43.65,'IQ','18',1032674,'Asia/Baghdad');
INSERT INTO "local" VALUES('Qaḑā’ Arbīl','Qada'' Arbil',36.1,44.0,'IQ','11',1384321,'Asia/Baghdad');
INSERT INTO "local" VALUES('Muḩāfaz̧at Diyālá','Muhafazat Diyala',34.0,45.0,'IQ','10',1224000,'Asia/Baghdad');
INSERT INTO "local" VALUES('Muḩāfaz̧at Dhī Qār','Muhafazat Dhi Qar',31.0,46.0,'IQ','09',1386335,'Asia/Baghdad');
INSERT INTO "local" VALUES('Baghdad','Baghdad',33.34058,44.40088,'IQ','07',5672513,'Asia/Baghdad');
INSERT INTO "local" VALUES('Muḩāfaz̧at as Sulaymānīyah','Muhafazat as Sulaymaniyah',35.66667,45.5,'IQ','05',1552000,'Asia/Baghdad');
INSERT INTO "local" VALUES('Al Mawşil al Jadīdah','Al Mawsil al Jadidah',36.33091,43.09065,'IQ','15',2065597,'Asia/Baghdad');
INSERT INTO "local" VALUES('Mosul','Mosul',36.335,43.11889,'IQ','15',1739800,'Asia/Baghdad');
INSERT INTO "local" VALUES('Republic of Iraq','Republic of Iraq',33.0,44.0,'IQ','00',29671605,'Asia/Baghdad');
INSERT INTO "local" VALUES('Al Başrah','Al Basrah',30.53302,47.79747,'IQ','02',2600000,'Asia/Baghdad');
INSERT INTO "local" VALUES('Al Başrat al Qadīmah','Al Basrat al Qadimah',30.49528,47.8169,'IQ','02',2015483,'Asia/Baghdad');
INSERT INTO "local" VALUES('Tehrān','Tehran',35.69439,51.42151,'IR','26',7153309,'Asia/Tehran');
INSERT INTO "local" VALUES('Tabrīz','Tabriz',38.08,46.2919,'IR','33',1424641,'Asia/Tehran');
INSERT INTO "local" VALUES('Shiraz','Shiraz',29.61031,52.53114,'IR','07',1249942,'Asia/Tehran');
INSERT INTO "local" VALUES('Mashhad','Mashhad',36.31559,59.56796,'IR','42',2307177,'Asia/Tehran');
INSERT INTO "local" VALUES('Karaj','Karaj',35.83266,50.99154,'IR','44',1448075,'Asia/Tehran');
INSERT INTO "local" VALUES('Islamic Republic of Iran','Islamic Republic of Iran',32.0,53.0,'IR','00',76923300,'Asia/Tehran');
INSERT INTO "local" VALUES('Isfahan','Isfahan',32.65246,51.67462,'IR','28',1547164,'Asia/Tehran');
INSERT INTO "local" VALUES('Sicilia','Sicilia',37.75,14.25,'IT','15',5042992,'Europe/Rome');
INSERT INTO "local" VALUES('Sardinia','Sardinia',40.0,9.0,'IT','14',1670219,'Europe/Rome');
INSERT INTO "local" VALUES('Sardegna','Sardegna',40.0,9.0,'IT','14',1672404,'Europe/Rome');
INSERT INTO "local" VALUES('Provincia di Palermo','Provincia di Palermo',37.81667,13.58333,'IT','15',1243585,'Europe/Rome');
INSERT INTO "local" VALUES('Provincia di Catania','Provincia di Catania',37.38333,14.66667,'IT','15',1078766,'Europe/Rome');
INSERT INTO "local" VALUES('Regione Calabria','Regione Calabria',39.0,16.5,'IT','03',2009330,'Europe/Rome');
INSERT INTO "local" VALUES('Regione Veneto','Regione Veneto',45.5,11.75,'IT','20',4912438,'Europe/Rome');
INSERT INTO "local" VALUES('Trentino-Alto Adige','Trentino-Alto Adige',46.5,11.33333,'IT','17',1028260,'Europe/Rome');
INSERT INTO "local" VALUES('Regione Toscana','Regione Toscana',43.41667,11.0,'IT','16',3730130,'Europe/Rome');
INSERT INTO "local" VALUES('Provincia di Torino','Provincia di Torino',45.13333,7.36667,'IT','12',2247780,'Europe/Rome');
INSERT INTO "local" VALUES('Provincia di Salerno','Provincia di Salerno',40.45,15.26667,'IT','04',1092876,'Europe/Rome');
INSERT INTO "local" VALUES('Provincia di Roma','Provincia di Roma',41.96667,12.66667,'IT','07',3997465,'Europe/Rome');
INSERT INTO "local" VALUES('Rome','Rome',41.89474,12.4839,'IT','07',2318895,'Europe/Rome');
INSERT INTO "local" VALUES('Roma Capitale','Roma Capitale',41.90036,12.49575,'IT','07',2617175,'Europe/Rome');
INSERT INTO "local" VALUES('Puglia','Puglia',41.25,16.25,'IT','13',4084035,'Europe/Rome');
INSERT INTO "local" VALUES('Regione Piemonte','Regione Piemonte',45.0,8.0,'IT','12',4446230,'Europe/Rome');
INSERT INTO "local" VALUES('Provincia di Napoli','Provincia di Napoli',40.88333,14.41667,'IT','04',3054956,'Europe/Rome');
INSERT INTO "local" VALUES('Provincia di Milano','Provincia di Milano',45.5,9.5,'IT','09',3038420,'Europe/Rome');
INSERT INTO "local" VALUES('Milano','Milano',45.46427,9.18951,'IT','09',1236837,'Europe/Rome');
INSERT INTO "local" VALUES('Marche','Marche',43.5,13.25,'IT','10',1559542,'Europe/Rome');
INSERT INTO "local" VALUES('Regione Lombardia','Regione Lombardia',45.66667,9.5,'IT','09',9826141,'Europe/Rome');
INSERT INTO "local" VALUES('Regione Liguria','Regione Liguria',44.5,8.83333,'IT','08',1615986,'Europe/Rome');
INSERT INTO "local" VALUES('Lazio','Lazio',42.0,12.5,'IT','07',5681868,'Europe/Rome');
INSERT INTO "local" VALUES('Repubblica Italiana','Repubblica Italiana',42.83333,12.83333,'IT','00',60340328,'Europe/Rome');
INSERT INTO "local" VALUES('Regione Autonoma Friuli Venezia Giulia','Regione Autonoma Friuli Venezia Giulia',46.0,13.0,'IT','06',1234079,'Europe/Rome');
INSERT INTO "local" VALUES('Regione Emilia-Romagna','Regione Emilia-Romagna',44.75,11.0,'IT','05',4395569,'Europe/Rome');
INSERT INTO "local" VALUES('Regione Campania','Regione Campania',41.0,14.5,'IT','04',5824662,'Europe/Rome');
INSERT INTO "local" VALUES('Provincia di Brescia','Provincia di Brescia',45.63333,10.3,'IT','09',1238044,'Europe/Rome');
INSERT INTO "local" VALUES('Provincia di Bergamo','Provincia di Bergamo',45.83333,9.8,'IT','09',1086277,'Europe/Rome');
INSERT INTO "local" VALUES('Provincia di Bari','Provincia di Bari',40.93333,16.66667,'IT','13',1247303,'Europe/Rome');
INSERT INTO "local" VALUES('Regione Abruzzo','Regione Abruzzo',42.25,13.75,'IT','01',1338898,'Europe/Rome');
INSERT INTO "local" VALUES('Milano','Milano',45.46416,9.19199,'IT','09',1242123,'Europe/Rome');
INSERT INTO "local" VALUES('Jamaica','Jamaica',18.16667,-77.25,'JM','00',2847232,'America/Jamaica');
INSERT INTO "local" VALUES('Fitzroy''s Elecctronics','Fitzroy''s Elecctronics',17.98234,-76.86918,'JM','10',3000000,'America/Jamaica');
INSERT INTO "local" VALUES('Hashemite Kingdom of Jordan','Hashemite Kingdom of Jordan',31.0,36.0,'JO','00',6407085,'Asia/Amman');
INSERT INTO "local" VALUES('Muḩāfaz̧at `Ammān','Muhafazat `Amman',31.58369,36.33335,'JO','16',1972712,'Asia/Amman');
INSERT INTO "local" VALUES('Amman','Amman',31.95522,35.94503,'JO','16',1275857,'Asia/Amman');
INSERT INTO "local" VALUES('Yono','Yono',35.88333,139.63333,'JP','34',1077730,'Asia/Tokyo');
INSERT INTO "local" VALUES('Yokohama-shi','Yokohama-shi',35.44778,139.6425,'JP','19',3574443,'Asia/Tokyo');
INSERT INTO "local" VALUES('Tōkyō-to','Tokyo-to',35.6895,139.69171,'JP','40',12445327,'Asia/Tokyo');
INSERT INTO "local" VALUES('Tokyo','Tokyo',35.6895,139.69171,'JP','40',8336599,'Asia/Tokyo');
INSERT INTO "local" VALUES('Tochigi-ken','Tochigi-ken',36.69259,139.81613,'JP','38',2017548,'Asia/Tokyo');
INSERT INTO "local" VALUES('Shikoku','Shikoku',33.75,133.5,'JP','00',4141955,'Asia/Tokyo');
INSERT INTO "local" VALUES('Ōsaka-shi','Osaka-shi',34.69374,135.50218,'JP','32',2592413,'Asia/Tokyo');
INSERT INTO "local" VALUES('Nagoya-shi','Nagoya-shi',35.18147,136.90641,'JP','01',2191279,'Asia/Tokyo');
INSERT INTO "local" VALUES('Kyushu','Kyushu',33.0,131.0,'JP','00',13231995,'Asia/Tokyo');
INSERT INTO "local" VALUES('Kyoto','Kyoto',35.02107,135.75385,'JP','22',1459640,'Asia/Tokyo');
INSERT INTO "local" VALUES('Kumamoto-ken','Kumamoto-ken',32.62049,130.7543,'JP','21',1812255,'Asia/Tokyo');
INSERT INTO "local" VALUES('Kōbe-shi','Kobe-shi',34.6913,135.183,'JP','13',1528478,'Asia/Tokyo');
INSERT INTO "local" VALUES('Kawasaki','Kawasaki',35.52056,139.71722,'JP','19',1306785,'Asia/Tokyo');
INSERT INTO "local" VALUES('Japan','Japan',35.68536,139.75309,'JP','00',127288000,'Asia/Tokyo');
INSERT INTO "local" VALUES('Hiroshima-shi','Hiroshima-shi',34.39627,132.45937,'JP','11',1143841,'Asia/Tokyo');
INSERT INTO "local" VALUES('Gunma','Gunma',36.50747,138.98235,'JP','10',2014608,'Asia/Tokyo');
INSERT INTO "local" VALUES('Fukuoka-shi','Fukuoka-shi',33.60639,130.41806,'JP','07',1392289,'Asia/Tokyo');
INSERT INTO "local" VALUES('Ehime-ken','Ehime-ken',33.6258,132.85472,'JP','05',1476750,'Asia/Tokyo');
INSERT INTO "local" VALUES('Sendai-shi','Sendai-shi',38.26889,140.87194,'JP','24',1063103,'Asia/Tokyo');
INSERT INTO "local" VALUES('Sapporo','Sapporo',43.06417,141.34694,'JP','12',1883027,'Asia/Tokyo');
INSERT INTO "local" VALUES('Hokkaidō','Hokkaido',43.06451,141.3466,'JP','12',5647230,'Asia/Tokyo');
INSERT INTO "local" VALUES('Aomori','Aomori',40.7831,140.82828,'JP','03',1373164,'Asia/Tokyo');
INSERT INTO "local" VALUES('Saitama','Saitama',35.90807,139.65657,'JP','34',1193350,'Asia/Tokyo');
INSERT INTO "local" VALUES('Sendai','Sendai',38.25759,140.8667,'JP','24',1063103,'Asia/Tokyo');
INSERT INTO "local" VALUES('Nyanza Province','Nyanza Province',-0.5,34.5,'KE','07',4392196,'Africa/Nairobi');
INSERT INTO "local" VALUES('Nairobi','Nairobi Province',-1.28333,36.83333,'KE','05',3138369,'Africa/Nairobi');
INSERT INTO "local" VALUES('Nairobi','Nairobi',-1.28333,36.81667,'KE','05',2750547,'Africa/Nairobi');
INSERT INTO "local" VALUES('Meru','Meru Central District',0.0,37.518,'KE','35',1356301,'Africa/Nairobi');
INSERT INTO "local" VALUES('Mandera','Mandera District',3.36667,40.7,'KE','33',1025756,'Africa/Nairobi');
INSERT INTO "local" VALUES('Kitui','Kitui District',-1.835,38.451,'KE','27',1012709,'Africa/Nairobi');
INSERT INTO "local" VALUES('Kisii','Kisii District',-0.75,34.83333,'KE','25',1152282,'Africa/Nairobi');
INSERT INTO "local" VALUES('Kilifi','Kilifi District',-3.563,39.644,'KE','23',1109735,'Africa/Nairobi');
INSERT INTO "local" VALUES('Kiambu','Kiambu District',-1.09,36.699,'KE','22',1623282,'Africa/Nairobi');
INSERT INTO "local" VALUES('Republic of Kenya','Republic of Kenya',1.0,38.0,'KE','00',40046566,'Africa/Nairobi');
INSERT INTO "local" VALUES('Kakamega','Kakamega District',0.334,34.797,'KE','20',1660651,'Africa/Nairobi');
INSERT INTO "local" VALUES('Bungoma','Bungoma District',0.66,34.639,'KE','12',1630934,'Africa/Nairobi');
INSERT INTO "local" VALUES('Eastern Province','Eastern Province',0.0,38.0,'KE','03',4631779,'Africa/Nairobi');
INSERT INTO "local" VALUES('Central Province','Central Province',-0.75,37.0,'KE','01',3724159,'Africa/Nairobi');
INSERT INTO "local" VALUES('Western Province','Western Province',0.5,34.58333,'KE','09',3358776,'Africa/Nairobi');
INSERT INTO "local" VALUES('Rift Valley Province','Rift Valley Province',0.5,36.0,'KE','08',6987036,'Africa/Nairobi');
INSERT INTO "local" VALUES('Machakos','Machakos District',-1.282,37.408,'KE','31',1098584,'Africa/Nairobi');
INSERT INTO "local" VALUES('Migori','Migori District',-0.982,34.409,'KE','36',1028579,'Africa/Nairobi');
INSERT INTO "local" VALUES('Nakuru','Nakuru District',-0.48402,36.17126,'KE','39',1603325,'Africa/Nairobi');
INSERT INTO "local" VALUES('Kyrgyz Republic','Kyrgyz Republic',41.5,75.0,'KG','00',5508626,'Asia/Bishkek');
INSERT INTO "local" VALUES('Phnom Penh','Phnom Penh',11.56245,104.91601,'KH','22',1573544,'Asia/Phnom_Penh');
INSERT INTO "local" VALUES('Battambang','Battambang',12.91667,103.08333,'KH','29',1036523,'Asia/Phnom_Penh');
INSERT INTO "local" VALUES('Phnom Penh','Phnom Penh',11.57489,104.91394,'KH','22',2301725,'Asia/Phnom_Penh');
INSERT INTO "local" VALUES('Kingdom of Cambodia','Kingdom of Cambodia',13.0,105.0,'KH','00',14453680,'Asia/Phnom_Penh');
INSERT INTO "local" VALUES('Pyongyang','Pyongyang',39.03385,125.75432,'KP','12',3222000,'Asia/Pyongyang');
INSERT INTO "local" VALUES('Democratic People’s Republic of Korea','Democratic People''s Republic of Korea',40.0,127.0,'KP','00',22912177,'Asia/Pyongyang');
INSERT INTO "local" VALUES('Hwanghae-bukto','Hwanghae-bukto',38.56278,126.3,'KP','07',2113672,'Asia/Pyongyang');
INSERT INTO "local" VALUES('Daejeon','Daejeon',36.33333,127.41667,'KR','19',1539154,'Asia/Seoul');
INSERT INTO "local" VALUES('Daejeon','Daejeon',36.32139,127.41972,'KR','19',1475221,'Asia/Seoul');
INSERT INTO "local" VALUES('Daegu','Daegu',35.8,128.55,'KR','15',2527566,'Asia/Seoul');
INSERT INTO "local" VALUES('Daegu','Daegu',35.87028,128.59111,'KR','15',2566540,'Asia/Seoul');
INSERT INTO "local" VALUES('Suwon-si','Suwon-si',37.28586,127.00993,'KR','13',1160062,'Asia/Seoul');
INSERT INTO "local" VALUES('Suwon-si','Suwon-si',37.29111,127.00889,'KR','13',1242724,'Asia/Seoul');
INSERT INTO "local" VALUES('Republic of Korea','Republic of Korea',36.5,127.75,'KR','00',48422644,'Asia/Seoul');
INSERT INTO "local" VALUES('Seoul','Seoul',37.58333,127.0,'KR','11',10349312,'Asia/Seoul');
INSERT INTO "local" VALUES('Seoul','Seoul',37.566,126.9784,'KR','11',10349312,'Asia/Seoul');
INSERT INTO "local" VALUES('Busan','Busan',35.10278,129.04028,'KR','10',3678555,'Asia/Seoul');
INSERT INTO "local" VALUES('Gyeongsangbuk-do','Gyeongsangbuk-do',36.33333,128.75,'KR','14',2708787,'Asia/Seoul');
INSERT INTO "local" VALUES('Gyeonggi-do','Gyeonggi-do',37.6,127.25,'KR','13',12093000,'Asia/Seoul');
INSERT INTO "local" VALUES('Gwangju','Gwangju',35.16667,126.91667,'KR','18',1471324,'Asia/Seoul');
INSERT INTO "local" VALUES('Gwangju','Gwangju',35.15472,126.91556,'KR','18',1416938,'Asia/Seoul');
INSERT INTO "local" VALUES('Goyang-si','Goyang-si',37.65639,126.835,'KR','13',1073069,'Asia/Seoul');
INSERT INTO "local" VALUES('Goyang-si','Goyang-si',37.66667,126.83333,'KR','13',1073069,'Asia/Seoul');
INSERT INTO "local" VALUES('Incheon','Incheon',37.46178,126.70017,'KR','12',2900898,'Asia/Seoul');
INSERT INTO "local" VALUES('Incheon','Incheon',37.45646,126.70515,'KR','12',2628000,'Asia/Seoul');
INSERT INTO "local" VALUES('Chungcheongnam-do','Chungcheongnam-do',36.5,127.0,'KR','17',2033019,'Asia/Seoul');
INSERT INTO "local" VALUES('Changwon-si','Changwon-si',35.27534,128.65152,'KR','20',1089406,'Asia/Seoul');
INSERT INTO "local" VALUES('Seongnam-si','Seongnam-si',37.43861,127.13778,'KR','13',1031935,'Asia/Seoul');
INSERT INTO "local" VALUES('State of Kuwait','State of Kuwait',29.5,47.75,'KW','00',2789132,'Asia/Kuwait');
INSERT INTO "local" VALUES('Shyghys Qazaqstan Oblysy','Shyghys Qazaqstan Oblysy',48.5,82.0,'KZ','15',1464269,'Asia/Almaty');
INSERT INTO "local" VALUES('Republic of Kazakhstan','Republic of Kazakhstan',48.0,68.0,'KZ','00',15340000,NULL);
INSERT INTO "local" VALUES('Almaty','Almaty',43.25654,76.92848,'KZ','02',2000900,'Asia/Almaty');
INSERT INTO "local" VALUES('Almaty Qalasy','Almaty Qalasy',43.06667,76.91667,'KZ','02',1472866,'Asia/Almaty');
INSERT INTO "local" VALUES('Lao People’s Democratic Republic','Lao People''s Democratic Republic',18.0,105.0,'LA','00',6368162,'Asia/Vientiane');
INSERT INTO "local" VALUES('Ra’s Bayrūt','Ra''s Bayrut',33.9,35.48333,'LB','04',1251739,'Asia/Beirut');
INSERT INTO "local" VALUES('Lebanon','Lebanon',33.83333,35.83333,'LB','00',4125247,'Asia/Beirut');
INSERT INTO "local" VALUES('Mohafazat Mont-Liban','Mohafazat Mont-Liban',33.91667,35.66667,'LB','05',1679229,'Asia/Beirut');
INSERT INTO "local" VALUES('Beirut','Beirut',33.88894,35.49442,'LB','04',1916100,'Asia/Beirut');
INSERT INTO "local" VALUES('Democratic Socialist Republic of Sri Lanka','Democratic Socialist Republic of Sri Lanka',7.75,80.75,'LK','00',21513990,'Asia/Colombo');
INSERT INTO "local" VALUES('Ratnapura District','Ratnapura District',6.5831,80.5833,'LK','33',1019512,'Asia/Colombo');
INSERT INTO "local" VALUES('Kurunegala District','Kurunegala District',7.75,80.25,'LK','32',1455531,'Asia/Colombo');
INSERT INTO "local" VALUES('Kandy District','Kandy District',7.3044,80.7073,'LK','29',1277647,'Asia/Colombo');
INSERT INTO "local" VALUES('Gampaha District','Gampaha District',7.1333,80.0,'LK','36',2146077,'Asia/Colombo');
INSERT INTO "local" VALUES('Colombo District','Colombo District',6.8664,80.0166,'LK','36',2273260,'Asia/Colombo');
INSERT INTO "local" VALUES('Eastern Province','Eastern Province',8.60614,81.20201,'LK','37',1500000,'Asia/Colombo');
INSERT INTO "local" VALUES('Montserrado County','Montserrado County',6.5,-10.5,'LR','14',1144806,'Africa/Monrovia');
INSERT INTO "local" VALUES('Republic of Liberia','Republic of Liberia',6.5,-9.5,'LR','00',3685076,'Africa/Monrovia');
INSERT INTO "local" VALUES('Kingdom of Lesotho','Kingdom of Lesotho',-29.5,28.25,'LS','00',1919552,'Africa/Maseru');
INSERT INTO "local" VALUES('Republic of Lithuania','Republic of Lithuania',55.41667,24.0,'LT','00',3565000,'Europe/Vilnius');
INSERT INTO "local" VALUES('Republic of Latvia','Republic of Latvia',57.0,25.0,'LV','00',2217969,'Europe/Riga');
INSERT INTO "local" VALUES('Tripoli','Tripoli',32.87519,13.18746,'LY','77',1150989,'Africa/Tripoli');
INSERT INTO "local" VALUES('Libya','Libya',28.0,17.0,'LY','00',6461454,'Africa/Tripoli');
INSERT INTO "local" VALUES('Rabat','Rabat',34.01325,-6.83255,'MA','49',1655753,'Africa/Casablanca');
INSERT INTO "local" VALUES('Kingdom of Morocco','Kingdom of Morocco',32.0,-6.0,'MA','00',31627428,'Africa/Casablanca');
INSERT INTO "local" VALUES('Région de Meknès-Tafilalet','Region de Meknes-Tafilalet',32.58333,-5.0,'MA','48',2164141,'Africa/Casablanca');
INSERT INTO "local" VALUES('Kenitra Province','Kenitra Province',34.58333,-6.33333,'MA','52',1167301,'Africa/Casablanca');
INSERT INTO "local" VALUES('El-Jadida','El-Jadida',32.9,-8.5,'MA','51',1128098,'Africa/Casablanca');
INSERT INTO "local" VALUES('Région du Grand Casablanca','Region du Grand Casablanca',33.53333,-7.58333,'MA','45',3679839,'Africa/Casablanca');
INSERT INTO "local" VALUES('Casablanca','Casablanca',33.58831,-7.61138,'MA','45',3144909,'Africa/Casablanca');
INSERT INTO "local" VALUES('Oriental Region','Oriental Region',33.66667,-2.5,'MA','54',1918094,'Africa/Casablanca');
INSERT INTO "local" VALUES('Marrakech','Marrakech',31.63623,-8.01041,'MA','47',1063415,'Africa/Casablanca');
INSERT INTO "local" VALUES('Casablanca','Casablanca',33.5884,-7.55785,'MA','45',2936874,'Africa/Casablanca');
INSERT INTO "local" VALUES('Republic of Moldova','Republic of Moldova',47.25,28.58333,'MD','00',4324000,'Europe/Chisinau');
INSERT INTO "local" VALUES('Republic of Madagascar','Republic of Madagascar',-20.0,47.0,'MG','00',21281844,'Indian/Antananarivo');
INSERT INTO "local" VALUES('Antananarivo','Antananarivo',-18.91368,47.53613,'MG','7670856',1391433,'Indian/Antananarivo');
INSERT INTO "local" VALUES('Vakinankaratra Region','Vakinankaratra Region',-19.7,46.9,'MG','7670854',1589800,'Indian/Antananarivo');
INSERT INTO "local" VALUES('Analamanga Region','Analamanga Region',-18.45,47.5,'MG','7670856',2811500,'Indian/Antananarivo');
INSERT INTO "local" VALUES('Atsinanana Region','Atsinanana Region',-19.0,48.9,'MG','7670857',1117100,'Indian/Antananarivo');
INSERT INTO "local" VALUES('Haute Matsiatra Region','Haute Matsiatra Region',-21.37,46.5,'MG','7670905',1128900,'Indian/Antananarivo');
INSERT INTO "local" VALUES('Vatovavy Fitovinany Region','Vatovavy Fitovinany Region',-21.3,47.9,'MG','7670906',1097700,'Indian/Antananarivo');
INSERT INTO "local" VALUES('Atsimo-Andrefana Region','Atsimo-Andrefana Region',-23.2,44.4,'MG','7670913',1018500,'Indian/Antananarivo');
INSERT INTO "local" VALUES('Republic of Macedonia','Republic of Macedonia',41.66667,21.75,'MK','00',2062294,'Europe/Skopje');
INSERT INTO "local" VALUES('Sikasso Region','Sikasso Region',11.3,-6.2,'ML','06',2625919,'Africa/Bamako');
INSERT INTO "local" VALUES('Ségou Region','Segou Region',13.6,-5.9,'ML','05',2336255,'Africa/Bamako');
INSERT INTO "local" VALUES('Mopti Region','Mopti Region',14.7,-3.4,'ML','04',2037330,'Africa/Bamako');
INSERT INTO "local" VALUES('Republic of Mali','Republic of Mali',18.0,-2.0,'ML','00',13796354,'Africa/Bamako');
INSERT INTO "local" VALUES('Koulikoro Region','Koulikoro Region',13.8,-7.5,'ML','07',2418305,'Africa/Bamako');
INSERT INTO "local" VALUES('Kayes Region','Kayes Region',13.9,-10.1,'ML','03',1996812,'Africa/Bamako');
INSERT INTO "local" VALUES('Bamako','Bamako',12.65,-8.0,'ML','01',1297281,'Africa/Bamako');
INSERT INTO "local" VALUES('Azaouâd','Azaouad',18.54778,-2.33417,'ML','08',1200000,'Africa/Bamako');
INSERT INTO "local" VALUES('Taninthayi Region','Taninthayi Region',13.0,99.0,'MM','12',1383287,'Asia/Rangoon');
INSERT INTO "local" VALUES('Rangoon','Rangoon',16.80528,96.15611,'MM','17',4477638,'Asia/Rangoon');
INSERT INTO "local" VALUES('Bago Region','Bago Region',18.25,96.25,'MM','16',5728709,'Asia/Rangoon');
INSERT INTO "local" VALUES('Mon State','Mon State',16.25,97.75,'MM','13',2535609,'Asia/Rangoon');
INSERT INTO "local" VALUES('Mandalay','Mandalay',21.97473,96.08359,'MM','08',1208099,'Asia/Rangoon');
INSERT INTO "local" VALUES('Magway Region','Magway Region',20.5,94.75,'MM','15',4885832,'Asia/Rangoon');
INSERT INTO "local" VALUES('Kayin State','Kayin State',17.5,97.75,'MM','05',1594146,'Asia/Rangoon');
INSERT INTO "local" VALUES('Union of Burma','Union of Burma',21.0,96.0,'MM','00',53414374,'Asia/Rangoon');
INSERT INTO "local" VALUES('Mongolia','Mongolia',46.0,105.0,'MN','00',3086918,NULL);
INSERT INTO "local" VALUES('Islamic Republic of Mauritania','Islamic Republic of Mauritania',20.25,-10.5,'MR','00',3205060,'Africa/Nouakchott');
INSERT INTO "local" VALUES('Republic of Mauritius','Republic of Mauritius',-20.3,57.58333,'MU','00',1294104,'Indian/Mauritius');
INSERT INTO "local" VALUES('Southern Region','Southern Region',-15.5,35.0,'MW','S',5345000,'Africa/Blantyre');
INSERT INTO "local" VALUES('Northern Region','Northern Region',-11.0,34.0,'MW','N',1389000,'Africa/Blantyre');
INSERT INTO "local" VALUES('Republic of Malawi','Republic of Malawi',-13.5,34.0,'MW','00',15447500,'Africa/Blantyre');
INSERT INTO "local" VALUES('Central Region','Central Region',-13.5,34.0,'MW','C',4814000,'Africa/Blantyre');
INSERT INTO "local" VALUES('Gustavo A. Madero','Gustavo A. Madero',22.86971,-98.75895,'MX','28',1185772,'America/Monterrey');
INSERT INTO "local" VALUES('Estado de Yucatán','Estado de Yucatan',20.83333,-89.0,'MX','31',1761761,'America/Merida');
INSERT INTO "local" VALUES('Gustavo A. Madero','Gustavo A. Madero',19.49016,-99.10978,'MX','09',1193161,'America/Mexico_City');
INSERT INTO "local" VALUES('Estado de Veracruz-Llave','Estado de Veracruz-Llave',19.33333,-96.66667,'MX','30',7058898,'America/Mexico_City');
INSERT INTO "local" VALUES('Estado de Tlaxcala','Estado de Tlaxcala',19.41667,-98.16667,'MX','29',1044369,'America/Mexico_City');
INSERT INTO "local" VALUES('Estado de Tamaulipas','Estado de Tamaulipas',24.0,-98.75,'MX','28',2976339,'America/Monterrey');
INSERT INTO "local" VALUES('Estado de Tabasco','Estado de Tabasco',18.0,-92.66667,'MX','27',2041286,'America/Merida');
INSERT INTO "local" VALUES('Estado de Quintana Roo','Estado de Quintana Roo',19.66667,-88.5,'MX','23',1090281,'America/Merida');
INSERT INTO "local" VALUES('Estado de Querétaro de Arteaga','Estado de Queretaro de Arteaga',21.0,-99.91667,'MX','22',1568610,'America/Mexico_City');
INSERT INTO "local" VALUES('Puebla','Puebla',19.04334,-98.20193,'MX','21',1590256,'America/Mexico_City');
INSERT INTO "local" VALUES('Estado de Puebla','Estado de Puebla',18.83333,-98.0,'MX','21',5522918,'America/Mexico_City');
INSERT INTO "local" VALUES('Estado de Oaxaca','Estado de Oaxaca',17.0,-96.5,'MX','20',3625487,'America/Mexico_City');
INSERT INTO "local" VALUES('Estado de Nuevo León','Estado de Nuevo Leon',25.66667,-100.0,'MX','19',4123418,'America/Monterrey');
INSERT INTO "local" VALUES('Estado de Morelos','Estado de Morelos',18.75,-99.0,'MX','17',1680239,'America/Mexico_City');
INSERT INTO "local" VALUES('Iztapalapa','Iztapalapa',19.35738,-99.0671,'MX','09',1820888,'America/Mexico_City');
INSERT INTO "local" VALUES('Estado de Hidalgo','Estado de Hidalgo',20.5,-99.0,'MX','13',2356133,'America/Mexico_City');
INSERT INTO "local" VALUES('Estado de Guerrero','Estado de Guerrero',17.66667,-100.0,'MX','12',3237579,'America/Mexico_City');
INSERT INTO "local" VALUES('Distrito Federal','Distrito Federal',19.25,-99.16667,'MX','09',8851080,'America/Mexico_City');
INSERT INTO "local" VALUES('Ecatepec','Ecatepec',19.61725,-99.06601,'MX','15',1806226,'America/Mexico_City');
INSERT INTO "local" VALUES('Ciudad Nezahualcóyotl','Ciudad Nezahualcoyotl',19.40061,-99.01483,'MX','15',1232220,'America/Mexico_City');
INSERT INTO "local" VALUES('Mexico City','Mexico City',19.42847,-99.12766,'MX','09',12294193,'America/Mexico_City');
INSERT INTO "local" VALUES('Estado de Chiapas','Estado de Chiapas',16.5,-92.5,'MX','05',4250246,'America/Merida');
INSERT INTO "local" VALUES('Estado de Zacatecas','Estado de Zacatecas',23.0,-103.0,'MX','32',1363577,'America/Monterrey');
INSERT INTO "local" VALUES('Tijuana','Tijuana',32.5027,-117.00371,'MX','02',1376457,'America/Tijuana');
INSERT INTO "local" VALUES('Estado de Sonora','Estado de Sonora',29.33333,-110.66667,'MX','26',2351427,'America/Hermosillo');
INSERT INTO "local" VALUES('Estado de Sinaloa','Estado de Sinaloa',25.0,-107.5,'MX','25',2641696,'America/Mazatlan');
INSERT INTO "local" VALUES('Estado de San Luis Potosí','Estado de San Luis Potosi',22.5,-100.5,'MX','24',2391929,'America/Monterrey');
INSERT INTO "local" VALUES('Monterrey','Monterrey',25.67506,-100.31846,'MX','19',1122874,'America/Monterrey');
INSERT INTO "local" VALUES('Estado de Michoacán de Ocampo','Estado de Michoacan de Ocampo',19.16667,-101.83333,'MX','16',4090997,'America/Mexico_City');
INSERT INTO "local" VALUES('Mexico','Mexico',23.0,-102.0,'MX','00',112468855,NULL);
INSERT INTO "local" VALUES('León','Leon',21.12131,-101.66801,'MX','11',1114626,'America/Mexico_City');
INSERT INTO "local" VALUES('Estado de Jalisco','Estado de Jalisco',20.33333,-103.66667,'MX','14',6653364,'America/Mexico_City');
INSERT INTO "local" VALUES('Estado de Guanajuato','Estado de Guanajuato',21.0,-101.0,'MX','11',4908056,'America/Mexico_City');
INSERT INTO "local" VALUES('Guadalajara','Guadalajara',20.66682,-103.39182,'MX','14',1640589,'America/Mexico_City');
INSERT INTO "local" VALUES('Estado de Durango','Estado de Durango',24.83333,-104.83333,'MX','10',1460178,'America/Monterrey');
INSERT INTO "local" VALUES('Estado de Coahuila de Zaragoza','Estado de Coahuila de Zaragoza',27.33333,-102.0,'MX','07',2415862,'America/Monterrey');
INSERT INTO "local" VALUES('Ciudad Juárez','Ciudad Juarez',31.73333,-106.48333,'MX','06',1512354,'America/Ojinaga');
INSERT INTO "local" VALUES('Estado de Chihuahua','Estado de Chihuahua',28.5,-106.0,'MX','06',3316178,'America/Chihuahua');
INSERT INTO "local" VALUES('Estado de Aguascalientes','Estado de Aguascalientes',22.0,-102.5,'MX','01',1032680,'America/Mexico_City');
INSERT INTO "local" VALUES('Tijuana','Tijuana',32.50223,-116.97212,'MX','02',1410687,'America/Tijuana');
INSERT INTO "local" VALUES('Ecatepec de Morelos','Ecatepec de Morelos',19.60378,-99.05514,'MX','15',1656107,'America/Mexico_City');
INSERT INTO "local" VALUES('Daerah Johor Baharu','Daerah Johor Baharu',1.65,103.6,'MY','01',2374778,'Asia/Kuala_Lumpur');
INSERT INTO "local" VALUES('Kelantan','Kelantan',5.33333,102.0,'MY','03',1635000,'Asia/Kuala_Lumpur');
INSERT INTO "local" VALUES('Malaysia','Malaysia',2.5,112.5,'MY','00',28274729,NULL);
INSERT INTO "local" VALUES('Kuala Lumpur','Kuala Lumpur',3.14309,101.68653,'MY','14',1453975,'Asia/Kuala_Lumpur');
INSERT INTO "local" VALUES('Kuala Lumpur','Kuala Lumpur',3.1412,101.68653,'MY','14',1453975,'Asia/Kuala_Lumpur');
INSERT INTO "local" VALUES('Kota Bharu','Kota Bharu',6.13328,102.2386,'MY','03',1459994,'Asia/Kuala_Lumpur');
INSERT INTO "local" VALUES('Província de Zambézia','Provincia de Zambezia',-17.0,37.0,'MZ','09',3949841,'Africa/Maputo');
INSERT INTO "local" VALUES('Tete','Tete',-15.5,33.0,'MZ','08',1551949,'Africa/Maputo');
INSERT INTO "local" VALUES('Republic of Mozambique','Republic of Mozambique',-18.25,35.0,'MZ','00',22061451,'Africa/Maputo');
INSERT INTO "local" VALUES('Maputo Province','Maputo Province',-25.5,32.33333,'MZ','04',1072086,'Africa/Maputo');
INSERT INTO "local" VALUES('Maputo','Maputo',-25.96553,32.58322,'MZ','11',1191613,'Africa/Maputo');
INSERT INTO "local" VALUES('Inhambane Province','Inhambane Province',-23.0,34.5,'MZ','03',1371712,'Africa/Maputo');
INSERT INTO "local" VALUES('Cabo Delgado Province','Cabo Delgado Province',-12.5,39.4,'MZ','01',1583884,'Africa/Maputo');
INSERT INTO "local" VALUES('Republic of Namibia','Republic of Namibia',-22.0,17.0,'NA','00',2128471,'Africa/Windhoek');
INSERT INTO "local" VALUES('Département de Tillabéri','Departement de Tillaberi',14.5,1.33333,'NE','08',2017214,'Africa/Niamey');
INSERT INTO "local" VALUES('Republic of Niger','Republic of Niger',18.0,9.0,'NE','00',15878271,'Africa/Niamey');
INSERT INTO "local" VALUES('Sokoto State','Sokoto State',13.08333,5.25,'NG','51',4244399,'Africa/Lagos');
INSERT INTO "local" VALUES('Rivers State','Rivers State',4.74974,6.82766,'NG','50',6689087,'Africa/Lagos');
INSERT INTO "local" VALUES('Port Harcourt','Port Harcourt',4.77742,7.0134,'NG','50',1148665,'Africa/Lagos');
INSERT INTO "local" VALUES('Plateau State','Plateau State',9.16667,9.75,'NG','49',3553440,'Africa/Lagos');
INSERT INTO "local" VALUES('Oyo State','Oyo State',8.0,4.0,'NG','32',6617720,'Africa/Lagos');
INSERT INTO "local" VALUES('Ondo State','Ondo State',7.16667,5.08333,'NG','48',4011407,'Africa/Lagos');
INSERT INTO "local" VALUES('Ogun State','Ogun State',7.0,3.58333,'NG','16',4054272,'Africa/Lagos');
INSERT INTO "local" VALUES('Niger State','Niger State',10.0,6.0,'NG','31',4082558,'Africa/Lagos');
INSERT INTO "local" VALUES('Federal Republic of Nigeria','Federal Republic of Nigeria',10.0,8.0,'NG','00',154000000,'Africa/Lagos');
INSERT INTO "local" VALUES('Maiduguri','Maiduguri',11.84644,13.16027,'NG','27',1112449,'Africa/Lagos');
INSERT INTO "local" VALUES('Lagos State','Lagos State',6.58333,3.75,'NG','05',10601345,'Africa/Lagos');
INSERT INTO "local" VALUES('Lagos','Lagos',6.45306,3.39583,'NG','05',9000000,'Africa/Lagos');
INSERT INTO "local" VALUES('Kwara State','Kwara State',8.5,5.0,'NG','30',2591555,'Africa/Lagos');
INSERT INTO "local" VALUES('Katsina State','Katsina State',12.25,7.5,'NG','24',6483429,'Africa/Lagos');
INSERT INTO "local" VALUES('Kano State','Kano State',11.5,8.5,'NG','29',10077751,'Africa/Lagos');
INSERT INTO "local" VALUES('Kano','Kano',12.00012,8.51672,'NG','29',3626068,'Africa/Lagos');
INSERT INTO "local" VALUES('Kaduna State','Kaduna State',10.33333,7.75,'NG','23',6849075,'Africa/Lagos');
INSERT INTO "local" VALUES('Kaduna','Kaduna',10.52224,7.43828,'NG','23',1582102,'Africa/Lagos');
INSERT INTO "local" VALUES('Imo State','Imo State',5.5,7.16667,'NG','28',3934899,'Africa/Lagos');
INSERT INTO "local" VALUES('Ibadan','Ibadan',7.38778,3.89639,'NG','32',3565108,'Africa/Lagos');
INSERT INTO "local" VALUES('Cross River State','Cross River State',5.75,8.5,'NG','22',3104446,'Africa/Lagos');
INSERT INTO "local" VALUES('Borno State','Borno State',11.5,13.0,'NG','27',4588668,'Africa/Lagos');
INSERT INTO "local" VALUES('Benue State','Benue State',7.33333,8.75,'NG','26',5181642,'Africa/Lagos');
INSERT INTO "local" VALUES('Benin City','Benin City',6.33504,5.62749,'NG','37',1125058,'Africa/Lagos');
INSERT INTO "local" VALUES('Bauchi State','Bauchi State',10.5,10.0,'NG','46',4653066,'Africa/Lagos');
INSERT INTO "local" VALUES('Anambra State','Anambra State',6.33333,7.0,'NG','25',4721858,'Africa/Lagos');
INSERT INTO "local" VALUES('Akwa Ibom State','Akwa Ibom State',5.0,7.83333,'NG','21',4805451,'Africa/Lagos');
INSERT INTO "local" VALUES('Federal Capital Territory','Federal Capital Territory',8.83333,7.16667,'NG','11',1405201,'Africa/Lagos');
INSERT INTO "local" VALUES('Abia State','Abia State',5.41667,7.5,'NG','45',4222476,'Africa/Lagos');
INSERT INTO "local" VALUES('Delta State','Delta State',5.5,6.0,'NG','36',4170214,'Africa/Lagos');
INSERT INTO "local" VALUES('Adamawa State','Adamawa State',9.33333,12.5,'NG','35',3737223,'Africa/Lagos');
INSERT INTO "local" VALUES('Edo','Edo',6.5,6.0,'NG','37',3497502,'Africa/Lagos');
INSERT INTO "local" VALUES('Enugu State','Enugu State',6.5,7.5,'NG','47',3267837,'Africa/Lagos');
INSERT INTO "local" VALUES('Jigawa State','Jigawa State',12.1,9.56,'NG','39',2829929,'Africa/Lagos');
INSERT INTO "local" VALUES('Bayelsa State','Bayelsa State',4.75,6.08333,'NG','52',1998349,'Africa/Lagos');
INSERT INTO "local" VALUES('Ebonyi State','Ebonyi State',6.25,8.08333,'NG','53',1739136,'Africa/Lagos');
INSERT INTO "local" VALUES('Ekiti State','Ekiti State',7.66667,5.25,'NG','54',2737186,'Africa/Lagos');
INSERT INTO "local" VALUES('Gombe State','Gombe State',10.25,11.16667,'NG','55',2448236,'Africa/Lagos');
INSERT INTO "local" VALUES('Nassarawa State','Nassarawa State',8.5,8.25,'NG','56',2040097,'Africa/Lagos');
INSERT INTO "local" VALUES('Zamfara State','Zamfara State',12.16667,6.25,'NG','57',3602356,'Africa/Lagos');
INSERT INTO "local" VALUES('Kebbi State','Kebbi State',11.5,4.0,'NG','40',3630931,'Africa/Lagos');
INSERT INTO "local" VALUES('Kogi State','Kogi State',7.75,6.75,'NG','41',3595789,'Africa/Lagos');
INSERT INTO "local" VALUES('Osun State','Osun State',7.5,4.5,'NG','42',4137627,'Africa/Lagos');
INSERT INTO "local" VALUES('Taraba State','Taraba State',8.0,10.5,'NG','43',1480590,'Africa/Lagos');
INSERT INTO "local" VALUES('Yobe State','Yobe State',12.0,11.5,'NG','44',2532395,'Africa/Lagos');
INSERT INTO "local" VALUES('Republic of Nicaragua','Republic of Nicaragua',13.0,-85.0,'NI','00',5995928,'America/Managua');
INSERT INTO "local" VALUES('Provincie Zuid-Holland','Provincie Zuid-Holland',52.0,4.66667,'NL','11',3581452,'Europe/Amsterdam');
INSERT INTO "local" VALUES('Provincie Utrecht','Provincie Utrecht',52.0,5.25,'NL','09',1170622,'Europe/Amsterdam');
INSERT INTO "local" VALUES('Provincie Overijssel','Provincie Overijssel',52.41667,6.5,'NL','15',1065667,'Europe/Amsterdam');
INSERT INTO "local" VALUES('Provincie Noord-Holland','Provincie Noord-Holland',52.58333,4.91667,'NL','07',2498931,'Europe/Amsterdam');
INSERT INTO "local" VALUES('Provincie Noord-Brabant','Provincie Noord-Brabant',51.66667,5.0,'NL','06',2331709,'Europe/Amsterdam');
INSERT INTO "local" VALUES('Kingdom of the Netherlands','Kingdom of the Netherlands',52.25,5.75,'NL','00',16645000,'Europe/Amsterdam');
INSERT INTO "local" VALUES('Provincie Limburg','Provincie Limburg',51.25,6.0,'NL','05',1091697,'Europe/Amsterdam');
INSERT INTO "local" VALUES('Provincie Gelderland','Provincie Gelderland',52.0,5.83333,'NL','03',2080675,'Europe/Amsterdam');
INSERT INTO "local" VALUES('Kingdom of Norway','Kingdom of Norway',62.0,10.0,'NO','00',5009150,'Europe/Oslo');
INSERT INTO "local" VALUES('Federal Democratic Republic of Nepal','Federal Democratic Republic of Nepal',28.0,84.0,'NP','00',28951852,'Asia/Kathmandu');
INSERT INTO "local" VALUES('Kathmandu','Kathmandu',27.70169,85.3206,'NP','CR',1442271,'Asia/Kathmandu');
INSERT INTO "local" VALUES('Kathmandu District','Kathmandu District',27.70704,85.33218,'NP','CR',1264684,'Asia/Kathmandu');
INSERT INTO "local" VALUES('Sudur Pashchimanchal','Sudur Pashchimanchal',29.30915,80.91534,'NP','FR',2191330,'Asia/Kathmandu');
INSERT INTO "local" VALUES('Madhya Pashchimanchal','Madhya Pashchimanchal',29.05977,82.31335,'NP','MR',3012975,'Asia/Kathmandu');
INSERT INTO "local" VALUES('Madhyamanchal','Madhyamanchal',27.45436,85.22301,'NP','CR',8031629,'Asia/Kathmandu');
INSERT INTO "local" VALUES('Purwanchal','Purwanchal',27.23998,87.14802,'NP','ER',5344000,'Asia/Kathmandu');
INSERT INTO "local" VALUES('Pashchimanchal','Pashchimanchal',28.17039,83.93829,'NP','WR',4571000,'Asia/Kathmandu');
INSERT INTO "local" VALUES('South Island','South Island',-43.0,171.0,'NZ','00',1027500,'Pacific/Auckland');
INSERT INTO "local" VALUES('North Island','North Island',-39.0,176.0,'NZ','00',3287600,'Pacific/Auckland');
INSERT INTO "local" VALUES('New Zealand','New Zealand',-42.0,174.0,'NZ','00',4252277,NULL);
INSERT INTO "local" VALUES('Sultanate of Oman','Sultanate of Oman',21.0,57.0,'OM','00',2967717,'Asia/Muscat');
INSERT INTO "local" VALUES('Republic of Panama','Republic of Panama',9.0,-80.0,'PA','00',3410676,'America/Panama');
INSERT INTO "local" VALUES('Piura','Piura',-5.0,-80.33333,'PE','20',1630772,'America/Lima');
INSERT INTO "local" VALUES('Lambayeque','Lambayeque',-6.33333,-80.0,'PE','14',1091535,'America/Lima');
INSERT INTO "local" VALUES('La Libertad','La Libertad',-8.0,-78.5,'PE','13',1617050,'America/Lima');
INSERT INTO "local" VALUES('Ancash','Ancash',-9.5,-77.75,'PE','02',1039415,'America/Lima');
INSERT INTO "local" VALUES('Puno','Puno',-15.0,-70.0,'PE','21',1364362,'America/Lima');
INSERT INTO "local" VALUES('Republic of Peru','Republic of Peru',-10.0,-75.25,'PE','00',29907003,'America/Lima');
INSERT INTO "local" VALUES('Provincia de Lima','Provincia de Lima',-12.0,-76.83333,'PE','LMA',7605742,'America/Lima');
INSERT INTO "local" VALUES('Lima','Lima',-11.85,-76.45,'PE','15',8481415,'America/Lima');
INSERT INTO "local" VALUES('Lima','Lima',-12.04318,-77.02824,'PE','LMA',7737002,'America/Lima');
INSERT INTO "local" VALUES('Arequipa','Arequipa',-16.0,-72.25,'PE','04',1218168,'America/Lima');
INSERT INTO "local" VALUES('Independent State of Papua New Guinea','Independent State of Papua New Guinea',-6.0,147.0,'PG','00',6064515,'Pacific/Port_Moresby');
INSERT INTO "local" VALUES('Province of Tarlac','Province of Tarlac',15.5,120.5,'PH','03',1243449,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Rizal','Province of Rizal',14.58333,121.16667,'PH','40',2284046,'Asia/Manila');
INSERT INTO "local" VALUES('Quezon City','Quezon City',14.6488,121.0509,'PH','NCR',2761720,'Asia/Manila');
INSERT INTO "local" VALUES('Quezon City','Quezon City',14.63333,121.03333,'PH','NCR',2761720,'Asia/Manila');
INSERT INTO "local" VALUES('Republic of the Philippines','Republic of the Philippines',13.0,122.0,'PH','00',99900177,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Pangasinan','Province of Pangasinan',15.91667,120.33333,'PH','01',2645395,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Pampanga','Province of Pampanga',15.06667,120.66667,'PH','03',1911951,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Nueva Ecija','Province of Nueva Ecija',15.58333,121.0,'PH','03',1853853,'Asia/Manila');
INSERT INTO "local" VALUES('Province of North Cotabato','Province of North Cotabato',7.01667,125.08333,'PH','12',1121974,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Negros Oriental','Province of Negros Oriental',9.75,123.0,'PH','07',1231904,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Negros Occidental','Province of Negros Occidental',10.41667,123.0,'PH','06',2370269,'Asia/Manila');
INSERT INTO "local" VALUES('City of Manila','City of Manila',14.58333,121.0,'PH','NCR',1652171,'Asia/Manila');
INSERT INTO "local" VALUES('Manila','Manila',14.6042,120.9822,'PH','NCR',10444527,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Maguindanao','Province of Maguindanao',7.13333,124.3,'PH','14',1273715,'Asia/Manila');
INSERT INTO "local" VALUES('Luzon','Luzon',16.0,121.0,'PH','00',46228000,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Leyte','Province of Leyte',10.91667,124.66667,'PH','08',1722036,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Lanao del Sur','Province of Lanao del Sur',7.91667,124.33333,'PH','14',1138544,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Laguna','Province of Laguna',14.16667,121.33333,'PH','40',2473530,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Isabela','Province of Isabela',17.0,122.0,'PH','02',1401495,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Iloilo','Province of Iloilo',11.0,122.66667,'PH','06',1691878,'Asia/Manila');
INSERT INTO "local" VALUES('Davao City','Davao City',7.06955,125.59845,'PH','11',1280040,'Asia/Manila');
INSERT INTO "local" VALUES('Davao','Davao',7.07306,125.61278,'PH','11',1212504,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Cebu','Province of Cebu',9.33333,123.66667,'PH','07',2439005,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Cavite','Province of Cavite',14.25,120.83333,'PH','40',2856765,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Camarines Sur','Province of Camarines Sur',13.66667,123.33333,'PH','05',1693821,'Asia/Manila');
INSERT INTO "local" VALUES('Caloocan City','Caloocan City',14.65,120.96667,'PH','NCR',1489040,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Cagayan','Province of Cagayan',18.0,121.83333,'PH','02',1072571,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Bulacan','Province of Bulacan',15.0,121.08333,'PH','03',2826926,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Bukidnon','Province of Bukidnon',8.0,125.0,'PH','10',1190284,'Asia/Manila');
INSERT INTO "local" VALUES('Budta','Budta',7.20417,124.43972,'PH','14',1273715,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Bohol','Province of Bohol',9.83333,124.16667,'PH','07',1230110,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Batangas','Province of Batangas',13.91667,121.08333,'PH','40',2245869,'Asia/Manila');
INSERT INTO "local" VALUES('Province of Albay','Province of Albay',13.21667,123.55,'PH','05',1190823,'Asia/Manila');
INSERT INTO "local" VALUES('Malingao','Malingao',7.16083,124.475,'PH','12',1121974,'Asia/Manila');
INSERT INTO "local" VALUES('Autonomous Region in Muslim Mindanao','Autonomous Region in Muslim Mindanao',7.09544,124.38721,'PH','14',3256140,'Asia/Manila');
INSERT INTO "local" VALUES('Northern Mindanao','Northern Mindanao',8.5625,124.6125,'PH','10',3952437,'Asia/Manila');
INSERT INTO "local" VALUES('Mimaropa','Mimaropa',12.38333,120.99,'PH','41',2559791,'Asia/Manila');
INSERT INTO "local" VALUES('Cagayan Valley','Cagayan Valley',17.65667,121.73333,'PH','02',3051487,'Asia/Manila');
INSERT INTO "local" VALUES('Soccsksargen','Soccsksargen',7.18889,124.45556,'PH','12',3829081,'Asia/Manila');
INSERT INTO "local" VALUES('Caraga','Caraga',9.0,125.74167,'PH','13',2293480,'Asia/Manila');
INSERT INTO "local" VALUES('Cordillera Administrative Region','Cordillera Administrative Region',17.0852,121.03322,'PH','15',1616867,'Asia/Manila');
INSERT INTO "local" VALUES('Ilocos','Ilocos',16.97917,120.52083,'PH','01',4545906,'Asia/Manila');
INSERT INTO "local" VALUES('Calabarzon','Calabarzon',14.31,121.09,'PH','40',11743110,'Asia/Manila');
INSERT INTO "local" VALUES('Western Visayas','Western Visayas',11.13,122.53,'PH','06',6843643,'Asia/Manila');
INSERT INTO "local" VALUES('Central Luzon','Central Luzon',15.30714,120.79762,'PH','03',10137737,'Asia/Manila');
INSERT INTO "local" VALUES('Central Visayas','Central Visayas',9.525,123.6,'PH','07',6398628,'Asia/Manila');
INSERT INTO "local" VALUES('Eastern Visayas','Eastern Visayas',11.41667,124.98333,'PH','08',3912936,'Asia/Manila');
INSERT INTO "local" VALUES('Zamboanga Peninsula','Zamboanga Peninsula',7.49432,122.67366,'PH','09',3230094,'Asia/Manila');
INSERT INTO "local" VALUES('Davao','Davao',6.81304,125.70848,'PH','11',4156653,'Asia/Manila');
INSERT INTO "local" VALUES('Bicol','Bicol',13.31389,123.56389,'PH','05',5109798,'Asia/Manila');
INSERT INTO "local" VALUES('National Capital Region','National Capital Region',14.59455,120.97175,'PH','NCR',11855975,'Asia/Manila');
INSERT INTO "local" VALUES('Islāmābād Capital Territory','Islamabad Capital Territory',33.7104,73.13382,'PK','08',1115396,'Asia/Karachi');
INSERT INTO "local" VALUES('Sindh','Sindh',26.13456,68.7696,'PK','05',35992288,'Asia/Karachi');
INSERT INTO "local" VALUES('Rāwalpindi','Rawalpindi',33.6007,73.0679,'PK','04',1743101,'Asia/Karachi');
INSERT INTO "local" VALUES('Punjab','Punjab',30.86017,72.31976,'PK','04',85579866,'Asia/Karachi');
INSERT INTO "local" VALUES('Peshāwar','Peshawar',34.008,71.57849,'PK','03',1218773,'Asia/Karachi');
INSERT INTO "local" VALUES('Islamic Republic of Pakistan','Islamic Republic of Pakistan',30.0,70.0,'PK','00',184404791,'Asia/Karachi');
INSERT INTO "local" VALUES('Khyber Pakhtunkhwa Province','Khyber Pakhtunkhwa Province',34.45993,72.50237,'PK','03',22000000,'Asia/Karachi');
INSERT INTO "local" VALUES('Multān','Multan',30.19556,71.47528,'PK','04',1437230,'Asia/Karachi');
INSERT INTO "local" VALUES('Lahore','Lahore',31.54972,74.34361,'PK','04',6310888,'Asia/Karachi');
INSERT INTO "local" VALUES('Karachi','Karachi',24.9056,67.0822,'PK','05',11624219,'Asia/Karachi');
INSERT INTO "local" VALUES('Hyderābād','Hyderabad',25.39242,68.37366,'PK','05',1386330,'Asia/Karachi');
INSERT INTO "local" VALUES('Gujrānwāla','Gujranwala',32.16167,74.18831,'PK','04',1384471,'Asia/Karachi');
INSERT INTO "local" VALUES('Federally Administered Tribal Areas','Federally Administered Tribal Areas',33.01455,69.99925,'PK','01',3645919,'Asia/Karachi');
INSERT INTO "local" VALUES('Faisalābād','Faisalabad',31.41667,73.08333,'PK','04',2506595,'Asia/Karachi');
INSERT INTO "local" VALUES('Balochistān','Balochistan',28.47849,65.64355,'PK','02',7706478,'Asia/Karachi');
INSERT INTO "local" VALUES('NH&MP Beat-34 Nooriabad','NH&MP Beat-34 Nooriabad',25.17549,67.79682,'PK','05',1521651,'Asia/Karachi');
INSERT INTO "local" VALUES('Warsaw','Warsaw',52.22977,21.01178,'PL','78',1702139,'Europe/Warsaw');
INSERT INTO "local" VALUES('Województwo Mazowieckie','Wojewodztwo Mazowieckie',52.23011,21.01118,'PL','78',5164000,'Europe/Warsaw');
INSERT INTO "local" VALUES('Województwo Warmińsko-Mazurskie','Wojewodztwo Warminsko-Mazurskie',53.75,20.5,'PL','00',1428601,'Europe/Warsaw');
INSERT INTO "local" VALUES('Województwo Świętokrzyskie','Wojewodztwo Swietokrzyskie',50.75,20.5,'PL','00',1281796,'Europe/Warsaw');
INSERT INTO "local" VALUES('Województwo Podlaskie','Wojewodztwo Podlaskie',53.0,23.25,'PL','00',1196101,'Europe/Warsaw');
INSERT INTO "local" VALUES('Republic of Poland','Republic of Poland',52.0,20.0,'PL','00',38500000,'Europe/Warsaw');
INSERT INTO "local" VALUES('Lubelskie','Lubelskie',51.0,23.0,'PL','75',2157202,'Europe/Warsaw');
INSERT INTO "local" VALUES('Województwo Małopolskie','Wojewodztwo Malopolskie',49.75,20.5,'PL','77',3298270,'Europe/Warsaw');
INSERT INTO "local" VALUES('Mazowieckie','Mazowieckie',52.25,21.0,'PL','78',5222167,'Europe/Warsaw');
INSERT INTO "local" VALUES('Podkarpackie','Podkarpackie',50.0,22.0,'PL','80',2101732,'Europe/Warsaw');
INSERT INTO "local" VALUES('Podlaskie','Podlaskie',53.25,23.0,'PL','81',1189731,'Europe/Warsaw');
INSERT INTO "local" VALUES('Województwo Świętokrzyskie','Wojewodztwo Swietokrzyskie',50.75,20.75,'PL','84',1270120,'Europe/Warsaw');
INSERT INTO "local" VALUES('Województwo Warmińsko-Mazurskie','Wojewodztwo Warminsko-Mazurskie',53.83333,21.0,'PL','85',1427118,'Europe/Warsaw');
INSERT INTO "local" VALUES('Województwo Łódzkie','Wojewodztwo Lodzkie',51.75,19.5,'PL','00',2597000,'Europe/Warsaw');
INSERT INTO "local" VALUES('Województwo Pomorskie','Wojewodztwo Pomorskie',54.25,18.25,'PL','00',2199043,'Europe/Warsaw');
INSERT INTO "local" VALUES('Województwo Kujawsko-Pomorskie','Wojewodztwo Kujawsko-Pomorskie',53.0,18.0,'PL','73',2068000,'Europe/Warsaw');
INSERT INTO "local" VALUES('Województwo Dolnośląskie','Wojewodztwo Dolnoslaskie',51.0,16.5,'PL','72',2876627,'Europe/Warsaw');
INSERT INTO "local" VALUES('Województwo Łódzkie','Wojewodztwo Lodzkie',51.5,19.5,'PL','74',2541832,'Europe/Warsaw');
INSERT INTO "local" VALUES('Lubuskie','Lubuskie',52.25,15.25,'PL','76',1010047,'Europe/Warsaw');
INSERT INTO "local" VALUES('Opolskie','Opolskie',50.5,18.0,'PL','79',1031097,'Europe/Warsaw');
INSERT INTO "local" VALUES('Pomorskie','Pomorskie',54.25,18.0,'PL','82',2230099,'Europe/Warsaw');
INSERT INTO "local" VALUES('Województwo Śląskie','Wojewodztwo Slaskie',50.25,19.0,'PL','83',4640725,'Europe/Warsaw');
INSERT INTO "local" VALUES('Wielkopolskie','Wielkopolskie',52.25,17.0,'PL','86',3408281,'Europe/Warsaw');
INSERT INTO "local" VALUES('Zachodniopomorskie','Zachodniopomorskie',53.5,15.5,'PL','87',1693198,'Europe/Warsaw');
INSERT INTO "local" VALUES('Kujawsko-Pomorskie','Kujawsko-Pomorskie',53.0,18.5,'PL','73',2069083,'Europe/Warsaw');
INSERT INTO "local" VALUES('Puerto Rico','Puerto Rico',18.24829,-66.49989,'PR','00',3916632,'America/Puerto_Rico');
INSERT INTO "local" VALUES('West Bank','West Bank',31.66667,35.25,'PS','WE',2771681,'Asia/Hebron');
INSERT INTO "local" VALUES('Palestine','Palestine',31.92157,35.20329,'PS','00',3800000,NULL);
INSERT INTO "local" VALUES('Portuguese Republic','Portuguese Republic',39.6945,-8.13057,'PT','00',10676000,NULL);
INSERT INTO "local" VALUES('Republic of Paraguay','Republic of Paraguay',-23.33333,-58.0,'PY','00',6375830,'America/Asuncion');
INSERT INTO "local" VALUES('Departamento Central','Departamento Central',-25.53333,-57.46667,'PY','06',1533589,'America/Asuncion');
INSERT INTO "local" VALUES('Asunción','Asuncion',-25.30066,-57.63591,'PY','22',1482200,'America/Asuncion');
INSERT INTO "local" VALUES('București','Bucuresti',44.5,26.08333,'RO','10',1877155,'Europe/Bucharest');
INSERT INTO "local" VALUES('Bucharest','Bucharest',44.43225,26.10626,'RO','10',1877155,'Europe/Bucharest');
INSERT INTO "local" VALUES('România','Romania',46.0,25.0,'RO','00',21959278,'Europe/Bucharest');
INSERT INTO "local" VALUES('Autonomna Pokrajina Vojvodina','Autonomna Pokrajina Vojvodina',45.0,20.0,'RS','VO',2134409,'Europe/Belgrade');
INSERT INTO "local" VALUES('Belgrade','Belgrade',44.80401,20.46513,'RS','SE',1273651,'Europe/Belgrade');
INSERT INTO "local" VALUES('Serbia','Serbia',44.81892,20.45998,'RS','00',7344847,'Europe/Belgrade');
INSERT INTO "local" VALUES('Yaroslavskaya Oblast’','Yaroslavskaya Oblast''',58.0,39.5,'RU','88',1338750,'Europe/Moscow');
INSERT INTO "local" VALUES('Voronezhskaya Oblast’','Voronezhskaya Oblast''',51.0,40.5,'RU','86',2345910,'Europe/Moscow');
INSERT INTO "local" VALUES('Vologodskaya Oblast’','Vologodskaya Oblast''',60.0,42.0,'RU','85',1245037,'Europe/Moscow');
INSERT INTO "local" VALUES('Volgograd','Volgograd',48.71939,44.50184,'RU','84',1011417,'Europe/Volgograd');
INSERT INTO "local" VALUES('Ulyanovsk Oblast','Ulyanovsk Oblast',54.0,48.0,'RU','81',1350713,'Europe/Volgograd');
INSERT INTO "local" VALUES('Ufa','Ufa',54.74306,55.96779,'RU','08',1033338,'Asia/Yekaterinburg');
INSERT INTO "local" VALUES('Udmurtskaya Respublika','Udmurtskaya Respublika',57.0,53.0,'RU','80',1552897,'Europe/Samara');
INSERT INTO "local" VALUES('Tverskaya Oblast’','Tverskaya Oblast''',57.00964,35.00488,'RU','77',1425582,'Europe/Moscow');
INSERT INTO "local" VALUES('Tul’skaya Oblast''','Tul''skaya Oblast''',54.0,37.5,'RU','76',1628465,'Europe/Moscow');
INSERT INTO "local" VALUES('Tambovskaya Oblast’','Tambovskaya Oblast''',52.75,41.5,'RU','72',1143906,'Europe/Moscow');
INSERT INTO "local" VALUES('Smolenskaya Oblast’','Smolenskaya Oblast''',55.0,33.0,'RU','69',1022035,'Europe/Moscow');
INSERT INTO "local" VALUES('Saratovskaya Oblast’','Saratovskaya Oblast''',51.5,47.0,'RU','67',2648495,'Europe/Volgograd');
INSERT INTO "local" VALUES('Saint Petersburg','Saint Petersburg',59.93863,30.31413,'RU','66',5028000,'Europe/Moscow');
INSERT INTO "local" VALUES('Samarskaya Oblast’','Samarskaya Oblast''',53.0,50.0,'RU','65',3201272,'Europe/Samara');
INSERT INTO "local" VALUES('Samara','Samara',53.20006,50.15,'RU','65',1134730,'Europe/Samara');
INSERT INTO "local" VALUES('Ryazanskaya Oblast’','Ryazanskaya Oblast''',54.25,40.5,'RU','62',1197310,'Europe/Moscow');
INSERT INTO "local" VALUES('Rostovskaya Oblast’','Rostovskaya Oblast''',47.44032,41.08083,'RU','61',4397303,'Europe/Moscow');
INSERT INTO "local" VALUES('Rostov-na-Donu','Rostov-na-Donu',47.23135,39.72328,'RU','61',1074482,'Europe/Moscow');
INSERT INTO "local" VALUES('Perm Krai','Perm Krai',59.0,57.0,'RU','90',2819421,'Asia/Yekaterinburg');
INSERT INTO "local" VALUES('Penzenskaya Oblast’','Penzenskaya Oblast''',53.0,44.5,'RU','57',1433768,'Europe/Moscow');
INSERT INTO "local" VALUES('Nizhniy Novgorod','Nizhniy Novgorod',56.32867,44.00205,'RU','51',1284164,'Europe/Moscow');
INSERT INTO "local" VALUES('Moscow','Moscow',55.75222,37.61556,'RU','48',10381222,'Europe/Moscow');
INSERT INTO "local" VALUES('Moskovskaya Oblast’','Moskovskaya Oblast''',55.75,37.5,'RU','47',10636983,'Europe/Moscow');
INSERT INTO "local" VALUES('Leningradskaya Oblast’','Leningradskaya Oblast''',60.0,32.0,'RU','42',1716868,'Europe/Moscow');
INSERT INTO "local" VALUES('Kurskaya Oblast’','Kurskaya Oblast''',51.5,36.0,'RU','41',1207091,'Europe/Moscow');
INSERT INTO "local" VALUES('Krasnodarskiy Kray','Krasnodarskiy Kray',44.98811,38.97675,'RU','38',5191490,'Europe/Moscow');
INSERT INTO "local" VALUES('Kirovskaya Oblast’','Kirovskaya Oblast''',58.0,50.0,'RU','33',1457862,'Europe/Volgograd');
INSERT INTO "local" VALUES('Kazan','Kazan',55.78874,49.12214,'RU','73',1104738,'Europe/Moscow');
INSERT INTO "local" VALUES('Kaluzhskaya Oblast’','Kaluzhskaya Oblast''',54.5,35.5,'RU','25',1030145,'Europe/Moscow');
INSERT INTO "local" VALUES('Dagestan','Dagestan',43.0,47.0,'RU','17',2576531,'Europe/Moscow');
INSERT INTO "local" VALUES('Chuvashskaya Respublika','Chuvashskaya Respublika',55.5,47.0,'RU','16',1301226,'Europe/Moscow');
INSERT INTO "local" VALUES('Chechenskaya Respublika','Chechenskaya Respublika',43.25,45.83333,'RU','12',1210000,'Europe/Moscow');
INSERT INTO "local" VALUES('Belgorodskaya Oblast’','Belgorodskaya Oblast''',50.75,37.5,'RU','09',1511603,'Europe/Moscow');
INSERT INTO "local" VALUES('Arkhangel’skaya Oblast’','Arkhangel''skaya Oblast''',64.0,44.0,'RU','06',1262043,'Europe/Moscow');
INSERT INTO "local" VALUES('Gorod Bryansk','Gorod Bryansk',53.25,34.41667,'RU','10',1351463,'Europe/Moscow');
INSERT INTO "local" VALUES('Yekaterinburg','Yekaterinburg',56.8519,60.6122,'RU','71',1349772,'Asia/Yekaterinburg');
INSERT INTO "local" VALUES('Tyumenskaya Oblast’','Tyumenskaya Oblast''',57.33333,68.5,'RU','78',1316577,'Asia/Yekaterinburg');
INSERT INTO "local" VALUES('Tomskaya Oblast’','Tomskaya Oblast''',58.5,82.5,'RU','75',1049069,'Asia/Krasnoyarsk');
INSERT INTO "local" VALUES('Sverdlovskaya Oblast’','Sverdlovskaya Oblast''',58.0,62.0,'RU','71',4412629,'Asia/Yekaterinburg');
INSERT INTO "local" VALUES('Omskaya Oblast’','Omskaya Oblast''',56.0,73.0,'RU','54',2054238,'Asia/Omsk');
INSERT INTO "local" VALUES('Omsk','Omsk',54.99244,73.36859,'RU','54',1129281,'Asia/Omsk');
INSERT INTO "local" VALUES('Novosibirsk','Novosibirsk',55.0415,82.9346,'RU','53',1419007,'Asia/Novosibirsk');
INSERT INTO "local" VALUES('Krasnoyarskiy Kray','Krasnoyarskiy Kray',58.0,93.0,'RU','91',2845899,'Asia/Krasnoyarsk');
INSERT INTO "local" VALUES('Khanty-Mansiyskiy Avtonomnyy Okrug','Khanty-Mansiyskiy Avtonomnyy Okrug',62.0,72.0,'RU','32',1460892,'Asia/Yekaterinburg');
INSERT INTO "local" VALUES('Kemerovskaya Oblast’','Kemerovskaya Oblast''',55.0,86.0,'RU','29',2827246,'Asia/Novokuznetsk');
INSERT INTO "local" VALUES('Chelyabinskaya Oblast’','Chelyabinskaya Oblast''',54.0,60.5,'RU','13',3476217,'Asia/Yekaterinburg');
INSERT INTO "local" VALUES('Chelyabinsk','Chelyabinsk',55.15402,61.42915,'RU','13',1062919,'Asia/Yekaterinburg');
INSERT INTO "local" VALUES('Altayskiy Kray','Altayskiy Kray',52.5,83.0,'RU','04',2586976,'Asia/Omsk');
INSERT INTO "local" VALUES('Gorod Chelyabinsk','Gorod Chelyabinsk',55.16553,61.41673,'RU','13',3577253,'Asia/Yekaterinburg');
INSERT INTO "local" VALUES('Russian Federation','Russian Federation',60.0,100.0,'RU','00',140702000,NULL);
INSERT INTO "local" VALUES('Primorskiy Kray','Primorskiy Kray',45.0,135.0,'RU','59',2021901,'Asia/Vladivostok');
INSERT INTO "local" VALUES('Khabarovskiy Kray','Khabarovskiy Kray',55.0,134.0,'RU','30',1394490,'Asia/Vladivostok');
INSERT INTO "local" VALUES('Zabaykal’skiy Kray','Zabaykal''skiy Kray',52.0,117.0,'RU','93',1107107,'Asia/Yakutsk');
INSERT INTO "local" VALUES('Republic of Rwanda','Republic of Rwanda',-2.0,30.0,'RW','00',11055976,'Africa/Kigali');
INSERT INTO "local" VALUES('Kingdom of Saudi Arabia','Kingdom of Saudi Arabia',25.0,45.0,'SA','00',25731776,'Asia/Riyadh');
INSERT INTO "local" VALUES('Makkah Province','Makkah Province',20.66667,41.33333,'SA','14',5899358,'Asia/Riyadh');
INSERT INTO "local" VALUES('Mecca','Mecca',21.42667,39.82611,'SA','14',1323624,'Asia/Riyadh');
INSERT INTO "local" VALUES('Jizan Region','Jizan Region',17.33333,42.66667,'SA','17',1212393,'Asia/Riyadh');
INSERT INTO "local" VALUES('Jeddah','Jeddah',21.51694,39.21917,'SA','14',2867446,'Asia/Riyadh');
INSERT INTO "local" VALUES('Al Minţaqah ash Sharqīyah','Al Mintaqah ash Sharqiyah',22.5,51.0,'SA','06',3421191,'Asia/Riyadh');
INSERT INTO "local" VALUES('Riyadh','Riyadh',24.68773,46.72185,'SA','10',4205961,'Asia/Riyadh');
INSERT INTO "local" VALUES('Minţaqat ar Riyāḑ','Mintaqat ar Riyad',23.33333,45.33333,'SA','10',5588987,'Asia/Riyadh');
INSERT INTO "local" VALUES('Al-Qassim Province','Al-Qassim Province',27.08333,43.46667,'SA','08',1016756,'Asia/Riyadh');
INSERT INTO "local" VALUES('Medina','Medina',24.46861,39.61417,'SA','05',1300000,'Asia/Riyadh');
INSERT INTO "local" VALUES('Minţaqat al Madīnah','Mintaqat al Madinah',25.66667,39.66667,'SA','05',1547487,'Asia/Riyadh');
INSERT INTO "local" VALUES('Omdurman','Omdurman',15.64453,32.47773,'SD','29',1200000,'Africa/Khartoum');
INSERT INTO "local" VALUES('Republic of the Sudan','Republic of the Sudan',16.0,30.0,'SD','00',35000000,'Africa/Khartoum');
INSERT INTO "local" VALUES('Khartoum','Khartoum',15.55177,32.53241,'SD','29',1974647,'Africa/Khartoum');
INSERT INTO "local" VALUES('Khartoum','Khartoum',15.8,33.0,'SD','29',7152102,'Africa/Khartoum');
INSERT INTO "local" VALUES('Al Jazirah State','Al Jazirah State',14.6,33.35,'SD','38',2796330,'Africa/Khartoum');
INSERT INTO "local" VALUES('Al Qadarif State','Al Qadarif State',14.05,35.35,'SD','39',1369300,'Africa/Khartoum');
INSERT INTO "local" VALUES('White Nile','White Nile',13.5,32.4,'SD','41',1188707,'Africa/Khartoum');
INSERT INTO "local" VALUES('Western Darfur','Western Darfur',13.41667,22.66667,'SD','47',1006801,'Africa/Khartoum');
INSERT INTO "local" VALUES('Southern Darfur','Southern Darfur',11.5,24.66667,'SD','49',2890348,'Africa/Khartoum');
INSERT INTO "local" VALUES('Southern Kordofan','Southern Kordofan',11.0,30.0,'SD','50',1111859,'Africa/Khartoum');
INSERT INTO "local" VALUES('Kassala State','Kassala State',15.9,35.65,'SD','52',1171118,'Africa/Khartoum');
INSERT INTO "local" VALUES('River Nile','River Nile',19.0,33.2,'SD','53',1008493,'Africa/Khartoum');
INSERT INTO "local" VALUES('Northern Kordofan','Northern Kordofan',14.5,29.5,'SD','56',3340000,'Africa/Khartoum');
INSERT INTO "local" VALUES('Sinnar State','Sinnar State',13.0,34.0,'SD','58',1502047,'Africa/Khartoum');
INSERT INTO "local" VALUES('Kingdom of Sweden','Kingdom of Sweden',62.0,15.0,'SE','00',9555893,'Europe/Stockholm');
INSERT INTO "local" VALUES('Stockholm','Stockholm',59.5,18.0,'SE','26',2127006,'Europe/Stockholm');
INSERT INTO "local" VALUES('Stockholm','Stockholm',59.33258,18.0649,'SE','26',1253309,'Europe/Stockholm');
INSERT INTO "local" VALUES('Skåne Län','Skane Laen',55.98333,13.5,'SE','27',1263088,'Europe/Stockholm');
INSERT INTO "local" VALUES('Västra Götalands Län','Vaestra Goetalands Laen',58.0,13.0,'SE','28',1600447,'Europe/Stockholm');
INSERT INTO "local" VALUES('Republic of Singapore','Republic of Singapore',1.36667,103.8,'SG','00',4701069,'Asia/Singapore');
INSERT INTO "local" VALUES('Singapore','Singapore',1.28967,103.85007,'SG','00',3547809,'Asia/Singapore');
INSERT INTO "local" VALUES('Republic of Slovenia','Republic of Slovenia',46.08333,15.0,'SI','00',2007000,'Europe/Ljubljana');
INSERT INTO "local" VALUES('Slovak Republic','Slovak Republic',48.66667,19.5,'SK','00',5455000,'Europe/Bratislava');
INSERT INTO "local" VALUES('Republic of Sierra Leone','Republic of Sierra Leone',8.5,-11.5,'SL','00',5245695,'Africa/Freetown');
INSERT INTO "local" VALUES('Republic of Senegal','Republic of Senegal',14.5,-14.25,'SN','00',12323252,'Africa/Dakar');
INSERT INTO "local" VALUES('Grand Dakar','Grand Dakar',14.71331,-17.45472,'SN','01',2352057,'Africa/Dakar');
INSERT INTO "local" VALUES('Dakar','Dakar',14.75,-17.33333,'SN','01',2431062,'Africa/Dakar');
INSERT INTO "local" VALUES('Dakar','Dakar',14.6937,-17.44406,'SN','01',2476400,'Africa/Dakar');
INSERT INTO "local" VALUES('Dakar Department','Dakar Department',14.71403,-17.45534,'SN','01',1030594,'Africa/Dakar');
INSERT INTO "local" VALUES('Somalia','Somalia',6.0,48.0,'SO','00',10112453,'Africa/Mogadishu');
INSERT INTO "local" VALUES('Mogadishu','Mogadishu',2.03711,45.34375,'SO','02',2587183,'Africa/Mogadishu');
INSERT INTO "local" VALUES('Central Equatoria State','Central Equatoria State',4.75,31.0,'SS','01',1443500,'Africa/Juba');
INSERT INTO "local" VALUES('Jonglei','Jonglei',7.4,32.4,'SS','03',1443500,'Africa/Juba');
INSERT INTO "local" VALUES('South Sudan','South Sudan',7.5,30.0,'SS','00',8260490,'Africa/Juba');
INSERT INTO "local" VALUES('Republic of El Salvador','Republic of El Salvador',13.83333,-88.91667,'SV','00',6052064,'America/El_Salvador');
INSERT INTO "local" VALUES('Syrian Arab Republic','Syrian Arab Republic',35.0,38.0,'SY','00',22198110,'Asia/Damascus');
INSERT INTO "local" VALUES('Muḩāfaz̧at Ḩalab','Muhafazat Halab',36.25,37.61667,'SY','09',3115559,'Asia/Damascus');
INSERT INTO "local" VALUES('Aleppo','Aleppo',36.20124,37.16117,'SY','09',1602264,'Asia/Damascus');
INSERT INTO "local" VALUES('Muḩāfaz̧at Rīf Dimashq','Muhafazat Rif Dimashq',33.5,37.38333,'SY','08',2836000,'Asia/Damascus');
INSERT INTO "local" VALUES('Damascus','Damascus',33.5102,36.29128,'SY','13',1569394,'Asia/Damascus');
INSERT INTO "local" VALUES('Kingdom of Swaziland','Kingdom of Swaziland',-26.5,31.5,'SZ','00',1354051,'Africa/Mbabane');
INSERT INTO "local" VALUES('Moyen-Chari Region','Moyen-Chari Region',9.3333,18.5,'TD','17',1003054,'Africa/Ndjamena');
INSERT INTO "local" VALUES('Mayo-Kebbi East Region','Mayo-Kebbi East Region',10.0,15.83,'TD','16',1120612,'Africa/Ndjamena');
INSERT INTO "local" VALUES('Chari-Baguirmi Region','Chari-Baguirmi Region',11.34,16.25,'TD','15',1700160,'Africa/Ndjamena');
INSERT INTO "local" VALUES('Republic of Chad','Republic of Chad',15.0,19.0,'TD','00',10543464,'Africa/Ndjamena');
INSERT INTO "local" VALUES('Ville de N''Djaména','Ville de N''Djamena',12.11666,15.06666,'TD','21',1092066,'Africa/Ndjamena');
INSERT INTO "local" VALUES('Togolese Republic','Togolese Republic',8.66667,1.08333,'TG','00',6587239,'Africa/Lome');
INSERT INTO "local" VALUES('Changwat Chiang Rai','Changwat Chiang Rai',19.91667,99.91667,'TH','03',1494052,'Asia/Bangkok');
INSERT INTO "local" VALUES('Chiang Mai Province','Chiang Mai Province',18.75,99.0,'TH','02',1763560,'Asia/Bangkok');
INSERT INTO "local" VALUES('Kingdom of Thailand','Kingdom of Thailand',15.5,101.0,'TH','00',67089500,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Surin','Changwat Surin',14.83333,103.75,'TH','29',1491395,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Songkhla','Changwat Songkhla',6.83333,100.66667,'TH','68',1292287,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Sisaket','Changwat Sisaket',14.83333,104.33333,'TH','30',1405500,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Samut Prakan','Changwat Samut Prakan',13.60442,100.70531,'TH','42',1041843,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Sakon Nakhon','Changwat Sakon Nakhon',17.33333,103.83333,'TH','20',1201904,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Roi Et','Changwat Roi Et',15.75,103.75,'TH','25',1411066,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Phetchabun','Changwat Phetchabun',16.25,101.08333,'TH','14',1151325,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Nonthaburi','Changwat Nonthaburi',13.90433,100.40335,'TH','38',1045341,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Nakhon Si Thammarat','Changwat Nakhon Si Thammarat',8.39102,99.82203,'TH','64',1544410,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Nakhon Sawan','Changwat Nakhon Sawan',15.7,100.08333,'TH','16',1178742,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Nakhon Ratchasima','Changwat Nakhon Ratchasima',15.0,102.16667,'TH','27',2604980,'Asia/Bangkok');
INSERT INTO "local" VALUES('Bangkok','Bangkok',13.87719,100.71991,'TH','40',5104476,'Asia/Bangkok');
INSERT INTO "local" VALUES('Bangkok','Bangkok',13.75398,100.50144,'TH','40',5104476,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Khon Kaen','Changwat Khon Kaen',16.43056,102.61667,'TH','22',1807627,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Kalasin','Changwat Kalasin',16.5,103.5,'TH','23',1084082,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Chon Buri','Changwat Chon Buri',13.3,101.3,'TH','46',1289424,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Chaiyaphum','Changwat Chaiyaphum',16.01804,101.81249,'TH','26',1185521,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Buriram','Changwat Buriram',14.84823,102.99332,'TH','28',1493359,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Udon Thani','Changwat Udon Thani',17.33333,102.83333,'TH','76',1467158,'Asia/Bangkok');
INSERT INTO "local" VALUES('Changwat Ubon Ratchathani','Changwat Ubon Ratchathani',15.16667,105.16667,'TH','75',1691441,'Asia/Bangkok');
INSERT INTO "local" VALUES('Republic of Tajikistan','Republic of Tajikistan',39.0,71.0,'TJ','00',7487489,'Asia/Dushanbe');
INSERT INTO "local" VALUES('Viloyati Sughd','Viloyati Sughd',40.0,69.0,'TJ','03',1989843,'Asia/Dushanbe');
INSERT INTO "local" VALUES('Viloyati Khatlon','Viloyati Khatlon',37.83333,69.0,'TJ','02',2337744,'Asia/Dushanbe');
INSERT INTO "local" VALUES('Region of Republican Subordination','Region of Republican Subordination',38.86537,70.18066,'TJ','RR',1606900,'Asia/Dushanbe');
INSERT INTO "local" VALUES('Democratic Republic of Timor-Leste','Democratic Republic of Timor-Leste',-8.83333,125.75,'TL','00',1154625,'Asia/Dili');
INSERT INTO "local" VALUES('Turkmenistan','Turkmenistan',39.75,59.66667,'TM','00',4940916,'Asia/Ashgabat');
INSERT INTO "local" VALUES('Mary','Mary',37.0,62.5,'TM','05',1536553,'Asia/Ashgabat');
INSERT INTO "local" VALUES('Lebap','Lebap',39.0,63.0,'TM','04',1388461,'Asia/Ashgabat');
INSERT INTO "local" VALUES('Tunisian Republic','Tunisian Republic',34.0,9.0,'TN','00',10589025,'Africa/Tunis');
INSERT INTO "local" VALUES('Şanlıurfa','Sanliurfa',37.21283,38.78174,'TR','63',1684249,'Europe/Istanbul');
INSERT INTO "local" VALUES('Republic of Turkey','Republic of Turkey',39.0,35.0,'TR','00',77804122,'Europe/Istanbul');
INSERT INTO "local" VALUES('Manisa','Manisa',38.83333,28.16667,'TR','45',1299232,'Europe/Istanbul');
INSERT INTO "local" VALUES('Konya','Konya',38.16667,32.5,'TR','71',2450952,'Europe/Istanbul');
INSERT INTO "local" VALUES('Kayseri','Kayseri',38.73695,35.49683,'TR','38',1091608,'Europe/Istanbul');
INSERT INTO "local" VALUES('Kahramanmaraş','Kahramanmaras',38.0,37.0,'TR','46',1055182,'Europe/Istanbul');
INSERT INTO "local" VALUES('İzmir','Izmir',38.46219,27.09229,'TR','35',3731863,'Europe/Istanbul');
INSERT INTO "local" VALUES('İzmir','Izmir',38.41273,27.13838,'TR','35',2500603,'Europe/Istanbul');
INSERT INTO "local" VALUES('İçel','Icel',36.86204,34.65088,'TR','32',1877605,'Europe/Istanbul');
INSERT INTO "local" VALUES('Gaziantep','Gaziantep',37.05944,37.3825,'TR','83',1065975,'Europe/Istanbul');
INSERT INTO "local" VALUES('Balıkesir','Balikesir',39.75,28.0,'TR','10',1116014,'Europe/Istanbul');
INSERT INTO "local" VALUES('Aydın','Aydin',37.75,28.0,'TR','09',1009186,'Europe/Istanbul');
INSERT INTO "local" VALUES('Antalya','Antalya',36.77409,30.71777,'TR','07',2081238,'Europe/Istanbul');
INSERT INTO "local" VALUES('Ankara','Ankara',39.91667,32.83333,'TR','68',4383400,'Europe/Istanbul');
INSERT INTO "local" VALUES('Ankara','Ankara',39.91987,32.85427,'TR','68',3517182,'Europe/Istanbul');
INSERT INTO "local" VALUES('Adana','Adana',36.985,35.28809,'TR','81',1996235,'Europe/Istanbul');
INSERT INTO "local" VALUES('Adana','Adana',37.00167,35.32889,'TR','81',1248988,'Europe/Istanbul');
INSERT INTO "local" VALUES('Trabzon','Trabzon',40.91667,39.83333,'TR','61',1068151,'Europe/Istanbul');
INSERT INTO "local" VALUES('Samsun','Samsun',41.25,36.33333,'TR','55',1211141,'Europe/Istanbul');
INSERT INTO "local" VALUES('Kocaeli','Kocaeli',40.91667,29.91667,'TR','41',1350456,'Europe/Istanbul');
INSERT INTO "local" VALUES('İstanbul','Istanbul',41.03508,28.98331,'TR','34',13854740,'Europe/Istanbul');
INSERT INTO "local" VALUES('İstanbul','Istanbul',41.01384,28.94966,'TR','34',11174257,'Europe/Istanbul');
INSERT INTO "local" VALUES('Bursa','Bursa',40.16667,29.08333,'TR','16',2374307,'Europe/Istanbul');
INSERT INTO "local" VALUES('Bursa','Bursa',40.19266,29.08403,'TR','16',1412701,'Europe/Istanbul');
INSERT INTO "local" VALUES('Republic of Trinidad and Tobago','Republic of Trinidad and Tobago',11.0,-61.0,'TT','00',1228691,'America/Port_of_Spain');
INSERT INTO "local" VALUES('Taiwan','Taiwan',24.0,121.0,'TW','00',22894384,'Asia/Taipei');
INSERT INTO "local" VALUES('Taipei','Taipei',25.04776,121.53185,'TW','03',7871900,'Asia/Taipei');
INSERT INTO "local" VALUES('Taichung','Taichung',24.15926,120.66145,'TW','04',1050000,'Asia/Taipei');
INSERT INTO "local" VALUES('Taichung','Taichung',24.1469,120.6839,'TW','04',1040725,'Asia/Taipei');
INSERT INTO "local" VALUES('Kaohsiung','Kaohsiung',22.61626,120.31333,'TW','02',1519711,'Asia/Taipei');
INSERT INTO "local" VALUES('Kaohsiung','Kaohsiung',22.63429,120.36621,'TW','02',2769072,'Asia/Taipei');
INSERT INTO "local" VALUES('Kagera Region','Kagera Region',-1.9,31.45,'TZ','19',2189850,'Africa/Dar_es_Salaam');
INSERT INTO "local" VALUES('Unguja Ukuu','Unguja Ukuu',-6.28333,39.36667,'TZ','21',1060416,'Africa/Dar_es_Salaam');
INSERT INTO "local" VALUES('United Republic of Tanzania','United Republic of Tanzania',-6.0,35.0,'TZ','00',41892895,'Africa/Dar_es_Salaam');
INSERT INTO "local" VALUES('Rukwa Region','Rukwa Region',-7.9,31.33333,'TZ','24',1004539,'Africa/Dar_es_Salaam');
INSERT INTO "local" VALUES('Morogoro Region','Morogoro Region',-8.0,37.0,'TZ','10',2218492,'Africa/Dar_es_Salaam');
INSERT INTO "local" VALUES('Dar es Salaam Region','Dar es Salaam Region',-6.83522,39.19597,'TZ','23',2791063,'Africa/Dar_es_Salaam');
INSERT INTO "local" VALUES('Dar es Salaam','Dar es Salaam',-6.82349,39.26951,'TZ','23',2698652,'Africa/Dar_es_Salaam');
INSERT INTO "local" VALUES('Manyara Region','Manyara Region',-4.75,36.66667,'TZ','27',1148070,'Africa/Dar_es_Salaam');
INSERT INTO "local" VALUES('Ruvuma Region','Ruvuma Region',-11.0,36.0,'TZ','14',1190348,'Africa/Dar_es_Salaam');
INSERT INTO "local" VALUES('Simiyu Region','Simiyu Region',-2.95,34.2,'TZ','31',1584157,'Africa/Dar_es_Salaam');
INSERT INTO "local" VALUES('Geita Region','Geita Region',-3.2,31.9,'TZ','28',1739530,'Africa/Dar_es_Salaam');
INSERT INTO "local" VALUES('Zhytomyrs’ka Oblast’','Zhytomyrs''ka Oblast''',50.5,28.5,'UA','27',1328158,'Europe/Kiev');
INSERT INTO "local" VALUES('Zakarpattia Oblast','Zakarpattia Oblast',48.33333,23.0,'UA','25',1241887,'Europe/Uzhgorod');
INSERT INTO "local" VALUES('Volyns’ka Oblast’','Volyns''ka Oblast''',51.0,25.0,'UA','24',1036891,'Europe/Uzhgorod');
INSERT INTO "local" VALUES('Ukraine','Ukraine',49.0,32.0,'UA','00',45415596,NULL);
INSERT INTO "local" VALUES('Ternopil’s’ka Oblast’','Ternopil''s''ka Oblast''',49.5,25.5,'UA','22',1107294,'Europe/Uzhgorod');
INSERT INTO "local" VALUES('Sums’ka Oblast’','Sums''ka Oblast''',51.0,34.0,'UA','21',1221368,'Europe/Kiev');
INSERT INTO "local" VALUES('Rivnens’ka Oblast’','Rivnens''ka Oblast''',51.0,26.5,'UA','19',1154682,'Europe/Kiev');
INSERT INTO "local" VALUES('Poltavs’ka Oblast’','Poltavs''ka Oblast''',49.47705,33.81866,'UA','18',1544085,'Europe/Kiev');
INSERT INTO "local" VALUES('Odes’ka Oblast’','Odes''ka Oblast''',47.0,30.0,'UA','17',2687543,'Europe/Kiev');
INSERT INTO "local" VALUES('Odessa','Odessa',46.47747,30.73262,'UA','17',1001558,'Europe/Kiev');
INSERT INTO "local" VALUES('Mykolayivs’ka Oblast’','Mykolayivs''ka Oblast''',47.25,32.0,'UA','16',1217103,'Europe/Zaporozhye');
INSERT INTO "local" VALUES('L’vivs’ka Oblast’','L''vivs''ka Oblast''',50.0,24.0,'UA','15',2725900,'Europe/Uzhgorod');
INSERT INTO "local" VALUES('Luhans’ka Oblast’','Luhans''ka Oblast''',49.0,39.0,'UA','14',2409000,'Europe/Zaporozhye');
INSERT INTO "local" VALUES('Kyiv Oblast','Kyiv Oblast',50.25,30.5,'UA','13',1727800,'Europe/Kiev');
INSERT INTO "local" VALUES('Kiev','Kiev',50.45466,30.5238,'UA','12',2797553,'Europe/Kiev');
INSERT INTO "local" VALUES('Avtonomna Respublika Krym','Avtonomna Respublika Krym',45.0,34.0,'UA','11',1958114,'Europe/Simferopol');
INSERT INTO "local" VALUES('Kirovohrads’ka Oblast’','Kirovohrads''ka Oblast''',48.5,32.0,'UA','10',1057951,'Europe/Kiev');
INSERT INTO "local" VALUES('Khmel’nyts’ka Oblast’','Khmel''nyts''ka Oblast''',49.5,27.0,'UA','09',1367892,'Europe/Kiev');
INSERT INTO "local" VALUES('Khersons’ka Oblast’','Khersons''ka Oblast''',46.5,34.0,'UA','08',1126000,'Europe/Zaporozhye');
INSERT INTO "local" VALUES('Kharkivs’ka Oblast’','Kharkivs''ka Oblast''',49.5,36.5,'UA','07',2808701,'Europe/Zaporozhye');
INSERT INTO "local" VALUES('Kharkiv','Kharkiv',49.98081,36.25272,'UA','07',1430885,'Europe/Kiev');
INSERT INTO "local" VALUES('Ivano-Frankivs’ka Oblast’','Ivano-Frankivs''ka Oblast''',48.5,24.5,'UA','06',1381700,'Europe/Uzhgorod');
INSERT INTO "local" VALUES('Donets’ka Oblast’','Donets''ka Oblast''',48.0,37.5,'UA','05',4622900,'Europe/Zaporozhye');
INSERT INTO "local" VALUES('Donets’k','Donets''k',48.023,37.80224,'UA','05',1024700,'Europe/Kiev');
INSERT INTO "local" VALUES('Dnipropetrovska Oblast''','Dnipropetrovska Oblast''',48.5,35.0,'UA','04',3476200,'Europe/Zaporozhye');
INSERT INTO "local" VALUES('Dnipropetrovsk','Dnipropetrovsk',48.45,34.98333,'UA','04',1032822,'Europe/Kiev');
INSERT INTO "local" VALUES('Chernihivs’ka Oblast’','Chernihivs''ka Oblast''',51.0,32.0,'UA','02',1156609,'Europe/Kiev');
INSERT INTO "local" VALUES('Cherkas’ka Oblast’','Cherkas''ka Oblast''',49.0,31.0,'UA','01',1335064,'Europe/Kiev');
INSERT INTO "local" VALUES('Republic of Uganda','Republic of Uganda',1.25,32.5,'UG','00',33398682,'Africa/Kampala');
INSERT INTO "local" VALUES('Kampala','Kampala',0.31628,32.58219,'UG','C',1353189,'Africa/Kampala');
INSERT INTO "local" VALUES('Central Region','Central Region',0.5,32.0,'UG','C',6683887,'Africa/Kampala');
INSERT INTO "local" VALUES('Eastern Region','Eastern Region',0.96675,33.82622,'UG','E',6301677,'Africa/Kampala');
INSERT INTO "local" VALUES('Northern Region','Northern Region',2.7373,31.88644,'UG','N',5345964,'Africa/Kampala');
INSERT INTO "local" VALUES('Western Region','Western Region',-0.61179,30.55573,'UG','W',6417449,'Africa/Kampala');
INSERT INTO "local" VALUES('Arkansas','Arkansas',34.75037,-92.50044,'US','AR',2757631,'America/Chicago');
INSERT INTO "local" VALUES('Broward County','Broward County',26.15186,-80.45589,'US','FL',1748066,'America/New_York');
INSERT INTO "local" VALUES('Florida','Florida',28.75054,-82.5001,'US','FL',17671452,'America/New_York');
INSERT INTO "local" VALUES('Hillsborough County','Hillsborough County',27.90623,-82.34692,'US','FL',1229226,'America/New_York');
INSERT INTO "local" VALUES('Miami-Dade County','Miami-Dade County',25.60897,-80.49867,'US','FL',2496435,'America/New_York');
INSERT INTO "local" VALUES('Orange County','Orange County',28.51442,-81.32348,'US','FL',1145956,'America/New_York');
INSERT INTO "local" VALUES('Palm Beach County','Palm Beach County',26.64757,-80.43651,'US','FL',1320134,'America/New_York');
INSERT INTO "local" VALUES('Georgia','Georgia',32.75042,-83.50018,'US','GA',8975842,'America/New_York');
INSERT INTO "local" VALUES('Kansas','Kansas',38.50029,-98.50063,'US','KS',2740759,'America/Chicago');
INSERT INTO "local" VALUES('Commonwealth of Kentucky','Commonwealth of Kentucky',37.52662,-85.29056,'US','KY',3801393,'America/New_York');
INSERT INTO "local" VALUES('Louisiana','Louisiana',31.00047,-92.0004,'US','LA',4515939,'America/Chicago');
INSERT INTO "local" VALUES('Maryland','Maryland',39.00039,-76.74997,'US','MD',5624246,'America/New_York');
INSERT INTO "local" VALUES('Missouri','Missouri',38.25031,-92.50046,'US','MO',5768151,'America/Chicago');
INSERT INTO "local" VALUES('Mississippi','Mississippi',32.75041,-89.75036,'US','MS',2901371,'America/Chicago');
INSERT INTO "local" VALUES('North Carolina','North Carolina',35.50069,-80.00032,'US','NC',8611367,'America/New_York');
INSERT INTO "local" VALUES('Franklin County','Franklin County',39.96952,-83.00935,'US','OH',1163414,'America/New_York');
INSERT INTO "local" VALUES('Oklahoma','Oklahoma',35.49209,-97.50328,'US','OK',3547049,'America/Chicago');
INSERT INTO "local" VALUES('City of Philadelphia','City of Philadelphia',40.00764,-75.13396,'US','PA',1526006,'America/New_York');
INSERT INTO "local" VALUES('Philadelphia','Philadelphia',39.95234,-75.16379,'US','PA',1526006,'America/New_York');
INSERT INTO "local" VALUES('South Carolina','South Carolina',34.00043,-81.00009,'US','SC',4229842,'America/New_York');
INSERT INTO "local" VALUES('Tennessee','Tennessee',35.75035,-86.25027,'US','TN',5935099,'America/Chicago');
INSERT INTO "local" VALUES('Bexar County','Bexar County',29.44896,-98.52002,'US','TX',1714773,'America/Chicago');
INSERT INTO "local" VALUES('Dallas','Dallas',32.78306,-96.80667,'US','TX',1197816,'America/Chicago');
INSERT INTO "local" VALUES('Dallas County','Dallas County',32.76663,-96.77787,'US','TX',2368139,'America/Chicago');
INSERT INTO "local" VALUES('Harris County','Harris County',29.85728,-95.39234,'US','TX',4092459,'America/Chicago');
INSERT INTO "local" VALUES('Houston','Houston',29.76328,-95.36327,'US','TX',2099451,'America/Chicago');
INSERT INTO "local" VALUES('San Antonio','San Antonio',29.42412,-98.49363,'US','TX',1327407,'America/Chicago');
INSERT INTO "local" VALUES('Tarrant County','Tarrant County',32.77156,-97.29124,'US','TX',1809034,'America/Chicago');
INSERT INTO "local" VALUES('Texas','Texas',31.25044,-99.25061,'US','TX',22875689,'America/Chicago');
INSERT INTO "local" VALUES('Travis County','Travis County',30.33469,-97.78195,'US','TX',1024266,'America/Chicago');
INSERT INTO "local" VALUES('Fairfax County','Fairfax County',38.83469,-77.27622,'US','VA',1081726,'America/New_York');
INSERT INTO "local" VALUES('Commonwealth of Virginia','Commonwealth of Virginia',37.51087,-78.66636,'US','VA',6385717,'America/New_York');
INSERT INTO "local" VALUES('West Virginia','West Virginia',38.50038,-80.50009,'US','WV',1817871,'America/New_York');
INSERT INTO "local" VALUES('Alabama','Alabama',32.75041,-86.75026,'US','AL',4530315,'America/Chicago');
INSERT INTO "local" VALUES('Connecticut','Connecticut',41.66704,-72.66648,'US','CT',3527249,'America/New_York');
INSERT INTO "local" VALUES('Iowa','Iowa',42.00027,-93.50049,'US','IA',2955010,'America/Chicago');
INSERT INTO "local" VALUES('Chicago','Chicago',41.85003,-87.65005,'US','IL',2695598,'America/Chicago');
INSERT INTO "local" VALUES('City of Chicago','City of Chicago',41.83691,-87.68475,'US','IL',2695598,'America/Chicago');
INSERT INTO "local" VALUES('Cook County','Cook County',41.8954,-87.64616,'US','IL',5194675,'America/Chicago');
INSERT INTO "local" VALUES('Illinois','Illinois',40.00032,-89.25037,'US','IL',12772888,'America/Chicago');
INSERT INTO "local" VALUES('Indiana','Indiana',40.00032,-86.25027,'US','IN',6265933,'America/Indiana/Indianapolis');
INSERT INTO "local" VALUES('Commonwealth of Massachusetts','Commonwealth of Massachusetts',42.16009,-71.50399,'US','MA',6033404,'America/New_York');
INSERT INTO "local" VALUES('Middlesex County','Middlesex County',42.48555,-71.39184,'US','MA',1503085,'America/New_York');
INSERT INTO "local" VALUES('Maine','Maine',45.50032,-69.24977,'US','ME',1325518,'America/New_York');
INSERT INTO "local" VALUES('Michigan','Michigan',44.25029,-85.50033,'US','MI',9883360,'America/Detroit');
INSERT INTO "local" VALUES('Oakland County','Oakland County',42.66041,-83.3858,'US','MI',1202362,'America/Detroit');
INSERT INTO "local" VALUES('Wayne County','Wayne County',42.28478,-83.26112,'US','MI',1820584,'America/Detroit');
INSERT INTO "local" VALUES('Hennepin County','Hennepin County',45.00458,-93.47688,'US','MN',1152425,'America/Chicago');
INSERT INTO "local" VALUES('Minnesota','Minnesota',46.25024,-94.25055,'US','MN',5141953,'America/Chicago');
INSERT INTO "local" VALUES('Nebraska','Nebraska',41.50028,-99.75067,'US','NE',1757399,'America/Chicago');
INSERT INTO "local" VALUES('New Hampshire','New Hampshire',43.66702,-71.4998,'US','NH',1316216,'America/New_York');
INSERT INTO "local" VALUES('New Jersey','New Jersey',40.16706,-74.49987,'US','NJ',8751436,'America/New_York');
INSERT INTO "local" VALUES('Bronx','Bronx',40.82732,-73.92357,'US','NY',1385108,'America/New_York');
INSERT INTO "local" VALUES('Borough of Bronx','Borough of Bronx',40.84985,-73.86641,'US','NY',1385108,'America/New_York');
INSERT INTO "local" VALUES('Brooklyn','Brooklyn',40.6501,-73.94958,'US','NY',2300664,'America/New_York');
INSERT INTO "local" VALUES('Long Island','Long Island',40.81677,-73.06622,'US','NY',7559372,'America/New_York');
INSERT INTO "local" VALUES('Manhattan','Manhattan',40.78343,-73.96625,'US','NY',1487536,'America/New_York');
INSERT INTO "local" VALUES('Nassau County','Nassau County',40.73217,-73.58545,'US','NY',1339532,'America/New_York');
INSERT INTO "local" VALUES('New York City','New York City',40.71427,-74.00597,'US','NY',8175133,'America/New_York');
INSERT INTO "local" VALUES('New York County','New York County',40.77427,-73.96981,'US','NY',1585873,'America/New_York');
INSERT INTO "local" VALUES('New York','New York',43.00035,-75.4999,'US','NY',19274244,'America/New_York');
INSERT INTO "local" VALUES('Queens County','Queens County',40.65749,-73.83875,'US','NY',2230722,'America/New_York');
INSERT INTO "local" VALUES('Borough of Queens','Borough of Queens',40.68149,-73.83652,'US','NY',2272771,'America/New_York');
INSERT INTO "local" VALUES('Suffolk County','Suffolk County',40.94046,-72.68524,'US','NY',1493350,'America/New_York');
INSERT INTO "local" VALUES('Cuyahoga County','Cuyahoga County',41.63506,-81.7002,'US','OH',1280122,'America/New_York');
INSERT INTO "local" VALUES('Ohio','Ohio',40.25034,-83.00018,'US','OH',11467123,'America/New_York');
INSERT INTO "local" VALUES('Allegheny County','Allegheny County',40.46883,-79.98119,'US','PA',1223348,'America/New_York');
INSERT INTO "local" VALUES('Commonwealth of Pennsylvania','Commonwealth of Pennsylvania',40.8967,-77.83892,'US','PA',12053709,'America/New_York');
INSERT INTO "local" VALUES('Philadelphia County','Philadelphia County',40.00764,-75.13396,'US','PA',1526006,'America/New_York');
INSERT INTO "local" VALUES('Rhode Island','Rhode Island',41.75038,-71.49978,'US','RI',1050292,'America/New_York');
INSERT INTO "local" VALUES('Wisconsin','Wisconsin',44.50024,-90.00041,'US','WI',5535168,'America/Chicago');
INSERT INTO "local" VALUES('Maricopa County','Maricopa County',33.34883,-112.49123,'US','AZ',3817117,'America/Phoenix');
INSERT INTO "local" VALUES('Phoenix','Phoenix',33.44838,-112.07404,'US','AZ',1445632,'America/Phoenix');
INSERT INTO "local" VALUES('Alameda County','Alameda County',37.65055,-121.91789,'US','CA',1510271,'America/Los_Angeles');
INSERT INTO "local" VALUES('California','California',37.25022,-119.75126,'US','CA',37691912,'America/Los_Angeles');
INSERT INTO "local" VALUES('Contra Costa County','Contra Costa County',37.92342,-121.95121,'US','CA',1049025,'America/Los_Angeles');
INSERT INTO "local" VALUES('Los Angeles','Los Angeles',34.05223,-118.24368,'US','CA',3792621,'America/Los_Angeles');
INSERT INTO "local" VALUES('Los Angeles County','Los Angeles County',34.19801,-118.26102,'US','CA',9818605,'America/Los_Angeles');
INSERT INTO "local" VALUES('Orange County','Orange County',33.67691,-117.77617,'US','CA',3010232,'America/Los_Angeles');
INSERT INTO "local" VALUES('Riverside County','Riverside County',33.74368,-115.99386,'US','CA',2189641,'America/Los_Angeles');
INSERT INTO "local" VALUES('Sacramento County','Sacramento County',38.44932,-121.34424,'US','CA',1418788,'America/Los_Angeles');
INSERT INTO "local" VALUES('San Bernardino County','San Bernardino County',34.84143,-116.17846,'US','CA',2035210,'America/Los_Angeles');
INSERT INTO "local" VALUES('San Diego','San Diego',32.71533,-117.15726,'US','CA',1307402,'America/Los_Angeles');
INSERT INTO "local" VALUES('San Diego County','San Diego County',33.0282,-116.77021,'US','CA',3095313,'America/Los_Angeles');
INSERT INTO "local" VALUES('Santa Clara County','Santa Clara County',37.23249,-121.69627,'US','CA',1781642,'America/Los_Angeles');
INSERT INTO "local" VALUES('Colorado','Colorado',39.00027,-105.50083,'US','CO',4678630,'America/Denver');
INSERT INTO "local" VALUES('New Mexico','New Mexico',34.50034,-106.00085,'US','NM',1912684,'America/Denver');
INSERT INTO "local" VALUES('Clark County','Clark County',36.2152,-115.01356,'US','NV',1951269,'America/Los_Angeles');
INSERT INTO "local" VALUES('Nevada','Nevada',39.25021,-116.75119,'US','NV',2399532,'America/Los_Angeles');
INSERT INTO "local" VALUES('Utah','Utah',39.25024,-111.75103,'US','UT',2427340,'America/Denver');
INSERT INTO "local" VALUES('Arizona','Arizona',34.5003,-111.50098,'US','AZ',5863809,'America/Phoenix');
INSERT INTO "local" VALUES('Idaho','Idaho',44.5002,-114.25118,'US','ID',1416564,'America/Boise');
INSERT INTO "local" VALUES('Oregon','Oregon',44.00013,-120.50139,'US','OR',3642919,'America/Los_Angeles');
INSERT INTO "local" VALUES('Salt Lake County','Salt Lake County',40.66758,-111.92403,'US','UT',1029655,'America/Denver');
INSERT INTO "local" VALUES('King County','King County',47.49084,-121.83583,'US','WA',1931249,'America/Los_Angeles');
INSERT INTO "local" VALUES('Washington','Washington',47.50012,-120.50147,'US','WA',6271775,'America/Los_Angeles');
INSERT INTO "local" VALUES('Hawaii','Hawaii',20.75028,-156.50028,'US','HI',1284220,'Pacific/Honolulu');
INSERT INTO "local" VALUES('United States','United States',39.76,-98.5,'US','00',310232863,NULL);
INSERT INTO "local" VALUES('Kentucky','Kentucky',38.20042,-84.87762,'US','KY',4206074,'America/New_York');
INSERT INTO "local" VALUES('Massachusetts','Massachusetts',42.36565,-71.10832,'US','MA',6433422,'America/New_York');
INSERT INTO "local" VALUES('Pennsylvania','Pennsylvania',40.27245,-76.90567,'US','PA',12440621,'America/New_York');
INSERT INTO "local" VALUES('Virginia','Virginia',37.54812,-77.44675,'US','VA',7642884,'America/New_York');
INSERT INTO "local" VALUES('Kings County','Kings County',40.63439,-73.95027,'US','NY',2504700,'America/New_York');
INSERT INTO "local" VALUES('Tampa-St. Petersburg-Clearwater','Tampa-St. Petersburg-Clearwater',27.87307,-82.51007,'US','FL',2733761,'America/New_York');
INSERT INTO "local" VALUES('New York-Northern New Jersey-Long Island','New York-Northern New Jersey-Long Island',40.75766,-73.91327,'US','NY',19006798,'America/New_York');
INSERT INTO "local" VALUES('Los Angeles-Long Beach-Santa Ana','Los Angeles-Long Beach-Santa Ana',33.88638,-118.04535,'US','CA',12872808,'America/Los_Angeles');
INSERT INTO "local" VALUES('Chicago-Naperville-Joliet','Chicago-Naperville-Joliet',41.70778,-87.89062,'US','IL',9569624,'America/Chicago');
INSERT INTO "local" VALUES('Dallas-Fort Worth-Arlington','Dallas-Fort Worth-Arlington',32.76303,-97.03262,'US','TX',6300006,'America/Chicago');
INSERT INTO "local" VALUES('Philadelphia-Camden-Wilmington','Philadelphia-Camden-Wilmington',39.8328,-75.39505,'US','PA',5838471,'America/New_York');
INSERT INTO "local" VALUES('Houston-Sugar Land-Baytown','Houston-Sugar Land-Baytown',29.73576,-95.3064,'US','TX',5728143,'America/Chicago');
INSERT INTO "local" VALUES('Miami-Fort Lauderdale-Pompano Beach','Miami-Fort Lauderdale-Pompano Beach',26.00002,-80.1947,'US','FL',5414772,'America/New_York');
INSERT INTO "local" VALUES('Atlanta-Sandy Springs-Marietta','Atlanta-Sandy Springs-Marietta',33.73119,-84.38324,'US','GA',5376285,'America/New_York');
INSERT INTO "local" VALUES('Washington-Arlington-Alexandria','Washington-Arlington-Alexandria',38.85735,-77.06223,'US','VA',5358130,'America/New_York');
INSERT INTO "local" VALUES('Boston-Cambridge-Quincy','Boston-Cambridge-Quincy',42.35347,-71.06094,'US','MA',4522858,'America/New_York');
INSERT INTO "local" VALUES('Detroit-Warren-Livonia','Detroit-Warren-Livonia',42.34231,-83.07175,'US','MI',4425110,'America/Detroit');
INSERT INTO "local" VALUES('Phoenix-Mesa-Scotsdale','Phoenix-Mesa-Scotsdale',33.4492,-112.0784,'US','AZ',4281899,'America/Phoenix');
INSERT INTO "local" VALUES('San Francisco-Oakland-Fremont','San Francisco-Oakland-Fremont',37.77668,-122.42031,'US','CA',4274531,'America/Los_Angeles');
INSERT INTO "local" VALUES('Riverside-San Bernadino-Ontario','Riverside-San Bernadino-Ontario',34.06062,-117.4205,'US','CA',4115871,'America/Los_Angeles');
INSERT INTO "local" VALUES('Seattle-Tacoma-Bellevue','Seattle-Tacoma-Bellevue',47.60014,-122.3283,'US','WA',3344813,'America/Los_Angeles');
INSERT INTO "local" VALUES('Minneapolis-St. Paul-Bloomington','Minneapolis-St. Paul-Bloomington',44.95751,-93.17848,'US','MN',3229878,'America/Chicago');
INSERT INTO "local" VALUES('San Diego-Carlsbad-San Marcos','San Diego-Carlsbad-San Marcos',32.71307,-117.15855,'US','CA',3001072,'America/Los_Angeles');
INSERT INTO "local" VALUES('St. Louis','St. Louis',38.63162,-90.24925,'US','MO',2816710,'America/Chicago');
INSERT INTO "local" VALUES('Baltimore-Towson','Baltimore-Towson',39.28808,-76.61076,'US','MD',2667117,'America/New_York');
INSERT INTO "local" VALUES('City of New York','City of New York',40.66393,-73.93827,'US','NY',8175133,'America/New_York');
INSERT INTO "local" VALUES('City of Los Angeles','City of Los Angeles',34.15649,-118.53995,'US','CA',3792621,'America/Los_Angeles');
INSERT INTO "local" VALUES('Oriental Republic of Uruguay','Oriental Republic of Uruguay',-33.0,-56.0,'UY','00',3477000,'America/Montevideo');
INSERT INTO "local" VALUES('Departamento de Montevideo','Departamento de Montevideo',-34.86528,-56.18194,'UY','10',1324115,'America/Montevideo');
INSERT INTO "local" VALUES('Montevideo','Montevideo',-34.90328,-56.18816,'UY','10',1270737,'America/Montevideo');
INSERT INTO "local" VALUES('Qashqadaryo Province','Qashqadaryo Province',38.58333,66.0,'UZ','08',2067000,'Asia/Samarkand');
INSERT INTO "local" VALUES('Namangan Province','Namangan Province',40.99747,71.24784,'UZ','06',1862000,'Asia/Tashkent');
INSERT INTO "local" VALUES('Xorazm Viloyati','Xorazm Viloyati',41.5,60.5,'UZ','05',1411406,'Asia/Samarkand');
INSERT INTO "local" VALUES('Andijan','Andijan',40.75,72.33333,'UZ','01',1899000,'Asia/Tashkent');
INSERT INTO "local" VALUES('Republic of Uzbekistan','Republic of Uzbekistan',41.66667,63.83333,'UZ','00',27865738,NULL);
INSERT INTO "local" VALUES('Tashkent','Tashkent',41.26465,69.21627,'UZ','13',1978028,'Asia/Tashkent');
INSERT INTO "local" VALUES('Estado Zulia','Estado Zulia',10.0,-72.16667,'VE','23',3704404,'America/Caracas');
INSERT INTO "local" VALUES('Bolivarian Republic of Venezuela','Bolivarian Republic of Venezuela',8.0,-66.0,'VE','00',27223228,'America/Caracas');
INSERT INTO "local" VALUES('Valencia','Valencia',10.16202,-68.00765,'VE','07',1385083,'America/Caracas');
INSERT INTO "local" VALUES('Estado Táchira','Estado Tachira',7.83333,-72.08333,'VE','20',1177300,'America/Caracas');
INSERT INTO "local" VALUES('Estado Miranda','Estado Miranda',10.25,-66.41667,'VE','15',2675165,'America/Caracas');
INSERT INTO "local" VALUES('Maracay','Maracay',10.24694,-67.59583,'VE','04',1754256,'America/Caracas');
INSERT INTO "local" VALUES('Maracaibo','Maracaibo',10.63167,-71.64056,'VE','23',2225000,'America/Caracas');
INSERT INTO "local" VALUES('Estado Lara','Estado Lara',10.16667,-69.83333,'VE','13',1795100,'America/Caracas');
INSERT INTO "local" VALUES('Distrito Capital','Distrito Capital',10.5,-66.91667,'VE','25',2097400,'America/Caracas');
INSERT INTO "local" VALUES('Caracas','Caracas',10.48801,-66.87919,'VE','25',3000000,'America/Caracas');
INSERT INTO "local" VALUES('Estado Carabobo','Estado Carabobo',10.16667,-68.08333,'VE','07',2245744,'America/Caracas');
INSERT INTO "local" VALUES('Estado Bolívar','Estado Bolivar',6.33333,-63.5,'VE','06',1620359,'America/Caracas');
INSERT INTO "local" VALUES('Estado Aragua','Estado Aragua',10.0,-67.16667,'VE','04',1689056,'America/Caracas');
INSERT INTO "local" VALUES('Socialist Republic of Vietnam','Socialist Republic of Vietnam',16.16667,107.83333,'VN','00',89571130,'Asia/Ho_Chi_Minh');
INSERT INTO "local" VALUES('Ho Chi Minh City','Ho Chi Minh City',10.82302,106.62965,'VN','20',3467331,'Asia/Ho_Chi_Minh');
INSERT INTO "local" VALUES('Tỉnh Hà Tây','Tinh Ha Tay',20.91667,105.66667,'VN','51',2500000,'Asia/Ho_Chi_Minh');
INSERT INTO "local" VALUES('Hanoi','Hanoi',21.0245,105.84117,'VN','44',1431270,'Asia/Ho_Chi_Minh');
INSERT INTO "local" VALUES('Republic of Kosovo','Republic of Kosovo',42.58333,20.91667,'XK','00',1800000,'Europe/Belgrade');
INSERT INTO "local" VALUES('Republic of Yemen','Republic of Yemen',15.5,47.5,'YE','00',23495361,'Asia/Aden');
INSERT INTO "local" VALUES('Muḩāfaz̧at Ta‘izz','Muhafazat Ta`izz',13.5,44.0,'YE','25',2613947,'Asia/Aden');
INSERT INTO "local" VALUES('Sanaa','Sanaa',15.26069,44.4249,'YE','16',1109000,'Asia/Aden');
INSERT INTO "local" VALUES('Sanaa','Sanaa',15.35472,44.20667,'YE','16',1937451,'Asia/Aden');
INSERT INTO "local" VALUES('Amanat Al Asimah','Amanat Al Asimah',15.45037,44.221,'YE','26',1947139,'Asia/Aden');
INSERT INTO "local" VALUES('Yemen, Democratic','Yemen, Democratic',12.79891,45.03313,'YE','00',2585484,'Asia/Aden');
INSERT INTO "local" VALUES('Soweto','Soweto',-26.26781,27.85849,'ZA','06',1695047,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Republic of South Africa','Republic of South Africa',-29.0,24.0,'ZA','00',49000000,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Pretoria','Pretoria',-25.74486,28.18783,'ZA','06',1619438,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Province of the Orange Free State','Province of the Orange Free State',-29.0,26.0,'ZA','03',2740946,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Province of KwaZulu-Natal','Province of KwaZulu-Natal',-29.0,30.0,'ZA','02',10154469,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Johannesburg','Johannesburg',-26.20227,28.04363,'ZA','06',2026469,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Durban','Durban',-29.8579,31.0292,'ZA','02',3120282,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Province of Eastern Cape','Province of Eastern Cape',-32.0,26.0,'ZA','05',6490714,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Gauteng','Gauteng',-26.08333,28.25,'ZA','06',10058121,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Mpumalanga','Mpumalanga',-26.0,30.0,'ZA','07',3409743,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Limpopo','Limpopo',-24.0,29.5,'ZA','09',5494928,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Province of North-West','Province of North-West',-26.5,26.0,'ZA','10',3895126,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Province of the Western Cape','Province of the Western Cape',-34.0,20.0,'ZA','11',4988154,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Cape Town','Cape Town',-33.92584,18.42322,'ZA','11',3433441,'Africa/Johannesburg');
INSERT INTO "local" VALUES('eThekwini Metropolitan Municipality','eThekwini Metropolitan Municipality',-29.8667,31.0167,'ZA','02',3442361,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Capricorn District Municipality','Capricorn District Municipality',-23.48163,29.1835,'ZA','09',1261463,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Bojanala Platinum District Municipality','Bojanala Platinum District Municipality',-25.42612,27.2243,'ZA','10',1268618,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Ekurhuleni Metropolitan Municipality','Ekurhuleni Metropolitan Municipality',-26.1989,28.31262,'ZA','06',2724229,'Africa/Johannesburg');
INSERT INTO "local" VALUES('City of Johannesburg Metropolitan Municipality','City of Johannesburg Metropolitan Municipality',-26.17673,27.96353,'ZA','06',3888180,'Africa/Johannesburg');
INSERT INTO "local" VALUES('City of Tshwane Metropolitan Municipality','City of Tshwane Metropolitan Municipality',-25.65985,28.44343,'ZA','06',2499447,'Africa/Johannesburg');
INSERT INTO "local" VALUES('OR Tambo District Municipality','OR Tambo District Municipality',-31.4674,29.05247,'ZA','05',1862218,'Africa/Johannesburg');
INSERT INTO "local" VALUES('uMgungundlovu District Municipality','uMgungundlovu District Municipality',-29.50927,30.19838,'ZA','02',1017763,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Gert Sibande District Municipality','Gert Sibande District Municipality',-26.671,29.92953,'ZA','07',1043194,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Nkangala District Municipality','Nkangala District Municipality',-25.71222,29.42431,'ZA','07',1226500,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Mopani District Municipality','Mopani District Municipality',-23.76661,30.836,'ZA','09',1068568,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Vhembe District Municipality','Vhembe District Municipality',-22.75467,30.1936,'ZA','09',1240035,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Sekhukhune District Municipality','Sekhukhune District Municipality',-24.82806,29.83803,'ZA','09',1090424,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Nelson Mandela Bay Metropolitan Municipality','Nelson Mandela Bay Metropolitan Municipality',-33.80399,25.49213,'ZA','05',1050930,'Africa/Johannesburg');
INSERT INTO "local" VALUES('City of Cape Town','City of Cape Town',-33.89267,18.59418,'ZA','11',3497097,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Nelson Mandela Bay','Nelson Mandela Bay',-33.80399,25.49213,'ZA','05',1050930,'Africa/Johannesburg');
INSERT INTO "local" VALUES('City of Johannesburg','City of Johannesburg',-26.17673,27.96353,'ZA','06',3888180,'Africa/Johannesburg');
INSERT INTO "local" VALUES('City of Tshwane','City of Tshwane',-25.65985,28.44343,'ZA','06',2499447,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Ekurhuleni','Ekurhuleni',-26.1989,28.31262,'ZA','06',2724229,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Ethekwini','Ethekwini',-29.80547,30.85062,'ZA','02',3468086,'Africa/Johannesburg');
INSERT INTO "local" VALUES('Republic of Zambia','Republic of Zambia',-14.33333,28.5,'ZM','00',13460305,'Africa/Lusaka');
INSERT INTO "local" VALUES('Lusaka','Lusaka',-15.40669,28.28713,'ZM','09',1267440,'Africa/Lusaka');
INSERT INTO "local" VALUES('Republic of Zimbabwe','Republic of Zimbabwe',-19.0,29.75,'ZW','00',11651858,'Africa/Harare');
INSERT INTO "local" VALUES('Midlands Province','Midlands Province',-19.2,29.8,'ZW','02',1514459,'Africa/Harare');
INSERT INTO "local" VALUES('Mashonaland West Province','Mashonaland West Province',-17.0,29.5,'ZW','05',1270629,'Africa/Harare');
INSERT INTO "local" VALUES('Mashonaland East Province','Mashonaland East Province',-17.5,32.0,'ZW','04',1167065,'Africa/Harare');
INSERT INTO "local" VALUES('Mashonaland Central Province','Mashonaland Central Province',-17.0,31.0,'ZW','03',1054077,'Africa/Harare');
INSERT INTO "local" VALUES('Manicaland Province','Manicaland Province',-19.0,32.5,'ZW','01',1590136,'Africa/Harare');
INSERT INTO "local" VALUES('Harare','Harare',-17.82772,31.05337,'ZW','10',1542813,'Africa/Harare');
INSERT INTO "local" VALUES('Harare Province','Harare Province',-17.81667,31.03333,'ZW','10',1606000,'Africa/Harare');
INSERT INTO "local" VALUES('Asia','Asia',29.84064,89.29688,'','',3812366000,'Australia/Perth');
INSERT INTO "local" VALUES('South America','South America',-14.60485,-57.65625,'','',357000000,'America/Recife');
INSERT INTO "local" VALUES('Earth','Earth',0.0,0.0,'','',6814400000,NULL);
COMMIT;