-
Notifications
You must be signed in to change notification settings - Fork 192
/
city.sql
3815 lines (3803 loc) · 273 KB
/
city.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
# ************************************************************
# Sequel Pro SQL dump
# Version
#
# http://www.sequelpro.com/
# https://github.com/sequelpro/sequelpro
#
# Host: 101.200.77.107 (MySQL 5.6.14-log)
# Database: learn_job
# Generation Time: 2016-05-16 12:37:25 +0000
# ************************************************************
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
SET NAMES utf8mb4;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
# Dump of table city
# ------------------------------------------------------------
DROP TABLE IF EXISTS `city`;
CREATE TABLE `city` (
`id` int(8) unsigned NOT NULL AUTO_INCREMENT,
`country_id` int(8) DEFAULT NULL COMMENT '城市所在的国家对应的id',
`state` varchar(256) DEFAULT NULL COMMENT '省或者州的英文名称,若某国家没有这一个行政级别,则为空',
`name` varchar(256) DEFAULT NULL COMMENT '城市的标准英文名称',
`lower_name` varchar(256) DEFAULT NULL COMMENT '城市的小写英文名称,用于搜索',
`cn_state` varchar(256) DEFAULT NULL COMMENT '省或者州的中文名称,若某国家没有这一个行政级别',
`cn_name` varchar(256) DEFAULT NULL COMMENT '城市的标准中文名称',
`city_code` varchar(64) DEFAULT NULL COMMENT '城市的代码(一般表示缩写',
`state_code` varchar(64) DEFAULT NULL COMMENT '省或者州代码(一般表示缩写),若某个国家没有州或省这个行政级别，则为空',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
LOCK TABLES `city` WRITE;
/*!40000 ALTER TABLE `city` DISABLE KEYS */;
INSERT INTO `city` (`id`, `country_id`, `state`, `name`, `lower_name`, `cn_state`, `cn_name`, `city_code`, `state_code`)
VALUES
(1,156,NULL,'Elbasan','elbasan',NULL,'爱尔巴桑','EL',NULL),
(2,156,NULL,'Diber','diber',NULL,'迪勃拉','DI',NULL),
(3,156,NULL,'Tirane','tirane',NULL,'地拉那','TR',NULL),
(4,156,NULL,'Durres','durres',NULL,'都拉斯','DR',NULL),
(5,156,NULL,'Vlore','vlore',NULL,'发罗拉','VL',NULL),
(6,156,NULL,'Fier','fier',NULL,'费里','FR',NULL),
(7,156,NULL,'Gjirokaster','gjirokaster',NULL,'吉诺卡斯特','GJ',NULL),
(8,156,NULL,'Korce','korce',NULL,'科尔察','KO',NULL),
(9,156,NULL,'Kukes','kukes',NULL,'库克斯','KU',NULL),
(10,156,NULL,'Lezhe','lezhe',NULL,'莱什','LE',NULL),
(11,156,NULL,'Berat','berat',NULL,'培拉特','BR',NULL),
(12,156,NULL,'Shkoder','shkoder',NULL,'斯库台','SH',NULL),
(13,51,NULL,'Adrar','adrar',NULL,'阿德拉尔','ADR',NULL),
(14,51,NULL,'Alger','alger',NULL,'阿尔及尔','ALG',NULL),
(15,51,NULL,'Ain Defla','ain defla',NULL,'艾因·德夫拉','ADE',NULL),
(16,51,NULL,'Ain Temouchent','ain temouchent',NULL,'艾因·蒂姆尚特','ATE',NULL),
(17,51,NULL,'Annaba','annaba',NULL,'安纳巴','AAE',NULL),
(18,51,NULL,'Oran','oran',NULL,'奥兰','ORA',NULL),
(19,51,NULL,'Batna','batna',NULL,'巴特纳','BAT',NULL),
(20,51,NULL,'Bejaia','bejaia',NULL,'贝贾亚','BJA',NULL),
(21,51,NULL,'Bechar','bechar',NULL,'贝沙尔','BEC',NULL),
(22,51,NULL,'El Bayadh','el bayadh',NULL,'贝伊德','EBA',NULL),
(23,51,NULL,'Biskra','biskra',NULL,'比斯克拉','BIS',NULL),
(24,51,NULL,'Bordj Bou Arreridj','bordj bou arreridj',NULL,'布尔吉·布阿雷里吉','BOR',NULL),
(25,51,NULL,'Blida','blida',NULL,'布利达','BLI',NULL),
(26,51,NULL,'Boumerdes','boumerdes',NULL,'布迈德斯','BOU',NULL),
(27,51,NULL,'Bouira','bouira',NULL,'布依拉','BOA',NULL),
(28,51,NULL,'Tipaza','tipaza',NULL,'蒂巴扎','TIP',NULL),
(29,51,NULL,'Tissemsilt','tissemsilt',NULL,'蒂斯姆西勒特','TIS',NULL),
(30,51,NULL,'Ghardaia','ghardaia',NULL,'盖尔达耶','GHA',NULL),
(31,51,NULL,'Guelma','guelma',NULL,'盖尔马','GUE',NULL),
(32,51,NULL,'Khenchela','khenchela',NULL,'罕西拉','KHE',NULL),
(33,51,NULL,'Relizane','relizane',NULL,'赫利赞','REL',NULL),
(34,51,NULL,'Jijel','jijel',NULL,'吉杰尔','JIJ',NULL),
(35,51,NULL,'Djelfa','djelfa',NULL,'杰勒法','DJE',NULL),
(36,51,NULL,'Constantine','constantine',NULL,'君士坦丁','CZL',NULL),
(37,51,NULL,'Laghouat','laghouat',NULL,'拉格瓦特','LAG',NULL),
(38,51,NULL,'Mascara','mascara',NULL,'马斯卡拉','MUA',NULL),
(39,51,NULL,'Medea','medea',NULL,'麦迪亚','MED',NULL),
(40,51,NULL,'Mila','mila',NULL,'密拉','MIL',NULL),
(41,51,NULL,'Mostaganem','mostaganem',NULL,'莫斯塔加纳姆','MOS',NULL),
(42,51,NULL,'Msila','msila',NULL,'姆西拉','MSI',NULL),
(43,51,NULL,'Naama','naama',NULL,'纳阿马','NAA',NULL),
(44,51,NULL,'Setif','setif',NULL,'塞蒂夫','SET',NULL),
(45,51,NULL,'Saida','saida',NULL,'赛伊达','SAI',NULL),
(46,51,NULL,'Skikda','skikda',NULL,'斯基克达','SKI',NULL),
(47,51,NULL,'Souk Ahras','souk ahras',NULL,'苏克·阿赫拉斯','SAH',NULL),
(48,51,NULL,'El Tarf','el tarf',NULL,'塔里夫','ETA',NULL),
(49,51,NULL,'Tamanghasset','tamanghasset',NULL,'塔曼拉塞特','TAM',NULL),
(50,51,NULL,'Tebessa','tebessa',NULL,'特贝萨','TEB',NULL),
(51,51,NULL,'Tlemcen','tlemcen',NULL,'特莱姆森','TLE',NULL),
(52,51,NULL,'Tizi Ouzou','tizi ouzou',NULL,'提济乌祖','IOU',NULL),
(53,51,NULL,'Tiaret','tiaret',NULL,'提亚雷特','TIA',NULL),
(54,51,NULL,'Tindouf','tindouf',NULL,'廷杜夫','TIN',NULL),
(55,51,NULL,'El Oued','el oued',NULL,'瓦德','EOU',NULL),
(56,51,NULL,'Ouargla','ouargla',NULL,'瓦尔格拉','OUA',NULL),
(57,51,NULL,'Oum el Bouaghi','oum el bouaghi',NULL,'乌姆布阿基','OEB',NULL),
(58,51,NULL,'Sidi Bel Abbes','sidi bel abbes',NULL,'西迪贝勒阿贝斯','SBA',NULL),
(59,51,NULL,'Chlef','chlef',NULL,'谢里夫','CHL',NULL),
(60,51,NULL,'Illizi','illizi',NULL,'伊利齐','ILL',NULL),
(61,70,NULL,'Herat','herat',NULL,'赫拉特','HEA',NULL),
(62,70,NULL,'Kabul','kabul',NULL,'喀布尔','KBL',NULL),
(63,70,NULL,'Kandahar','kandahar',NULL,'坎大哈','KDH',NULL),
(64,70,NULL,'Mazar-i Sharif','mazar-i sharif',NULL,'马扎里沙里夫','MZR',NULL),
(65,208,NULL,'Parana','parana',NULL,'巴拉那','PRA',NULL),
(66,208,NULL,'Viedma','viedma',NULL,'别德马','VDM',NULL),
(67,208,NULL,'Posadas','posadas',NULL,'波萨达斯','PSS',NULL),
(68,208,NULL,'Bahia Blanca','bahia blanca',NULL,'布兰卡港','BHI',NULL),
(69,208,NULL,'Buenos Aires','buenos aires',NULL,'布宜诺斯艾利斯','BUE',NULL),
(70,208,NULL,'Formosa','formosa',NULL,'福莫萨','FMA',NULL),
(71,208,NULL,'Jujuy','jujuy',NULL,'胡胡伊','JUJ',NULL),
(72,208,NULL,'Catamarca','catamarca',NULL,'卡塔马卡','CTC',NULL),
(73,208,NULL,'Cordoba','cordoba',NULL,'科尔多瓦','COR',NULL),
(74,208,NULL,'Corrientes','corrientes',NULL,'科连特斯','CNQ',NULL),
(75,208,NULL,'Villa Krause','villa krause',NULL,'克劳斯城','VLK',NULL),
(76,208,NULL,'Concordia','concordia',NULL,'肯考迪娅','COC',NULL),
(77,208,NULL,'La Rioja','la rioja',NULL,'拉里奥哈','IRJ',NULL),
(78,208,NULL,'La Plata','la plata',NULL,'拉普拉塔','LPG',NULL),
(79,208,NULL,'Resistencia','resistencia',NULL,'雷西斯滕匹亚','RES',NULL),
(80,208,NULL,'Rio Gallegos','rio gallegos',NULL,'里奥加耶戈斯','RGL',NULL),
(81,208,NULL,'Rio Cuarto','rio cuarto',NULL,'里奥夸尔托','RCU',NULL),
(82,208,NULL,'Comodoro Rivadavia','comodoro rivadavia',NULL,'里瓦达维亚海军准将城','CRD',NULL),
(83,208,NULL,'Rosario','rosario',NULL,'罗萨里奥','ROS',NULL),
(84,208,NULL,'Rawson','rawson',NULL,'罗森','RWO',NULL),
(85,208,NULL,'Mar del Plata','mar del plata',NULL,'马德普拉塔','MDQ',NULL),
(86,208,NULL,'Mendoza','mendoza',NULL,'门多萨','MDZ',NULL),
(87,208,NULL,'Neuquen','neuquen',NULL,'内乌肯','NQN',NULL),
(88,208,NULL,'Salta','salta',NULL,'萨尔塔','SLA',NULL),
(89,208,NULL,'Santiago del Estero','santiago del estero',NULL,'圣地亚哥-德尔埃斯特罗','SDE',NULL),
(90,208,NULL,'Santa Fe','santa fe',NULL,'圣菲','SFN',NULL),
(91,208,NULL,'San Juan','san juan',NULL,'圣胡安','UAQ',NULL),
(92,208,NULL,'San Rafael','san rafael',NULL,'圣拉斐尔','AFA',NULL),
(93,208,NULL,'San Luis','san luis',NULL,'圣路易斯','LUQ',NULL),
(94,208,NULL,'Santa Rosa','santa rosa',NULL,'圣罗莎','RSA',NULL),
(95,208,NULL,'San Miguel de Tucuman','san miguel de tucuman',NULL,'圣米格尔-德图库曼','SMC',NULL),
(96,208,NULL,'San Nicolas','san nicolas',NULL,'圣尼古拉斯','SNS',NULL),
(97,208,NULL,'Trelew','trelew',NULL,'特雷利乌','REL',NULL),
(98,208,NULL,'Ushuaia','ushuaia',NULL,'乌斯怀亚','USH',NULL),
(99,68,NULL,'Abu Dhabi','abu dhabi',NULL,'阿布扎比','AZ',NULL),
(100,68,NULL,'Al l\'Ayn','al l\'ayn',NULL,'艾因','AL',NULL),
(101,68,NULL,'Dubai','dubai',NULL,'迪拜','DU',NULL),
(102,68,NULL,'Ash Shariqah','ash shariqah',NULL,'沙迦','SH',NULL),
(103,84,NULL,'Al-Batinah','al-batinah',NULL,'巴提奈地区','BA',NULL),
(104,84,NULL,'Az-Zahirah','az-zahirah',NULL,'达希莱地区','ZA',NULL),
(105,84,NULL,'Ash-Sharqiyah','ash-sharqiyah',NULL,'东部地区','SH',NULL),
(106,84,NULL,'Masqat','masqat',NULL,'马斯喀特省','MA',NULL),
(107,84,NULL,'Musandam','musandam',NULL,'穆桑达姆省','MU',NULL),
(108,84,NULL,'Ad-Dakhiliyah','ad-dakhiliyah',NULL,'内地地区','DA',NULL),
(109,84,NULL,'Al-Wusta','al-wusta',NULL,'中部地区','WU',NULL),
(110,84,NULL,'Zufar','zufar',NULL,'佐法尔省','ZU',NULL),
(111,117,NULL,'Abseron','abseron',NULL,'阿布歇隆','ABS',NULL),
(112,117,NULL,'Xacmaz','xacmaz',NULL,'哈奇马斯','XAC',NULL),
(113,117,NULL,'Kalbacar','kalbacar',NULL,'卡尔巴卡尔','KAL',NULL),
(114,117,NULL,'Qazax','qazax',NULL,'卡扎赫','QAZ',NULL),
(115,117,NULL,'Lankaran','lankaran',NULL,'连科兰','LAN',NULL),
(116,117,NULL,'Mil-Qarabax','mil-qarabax',NULL,'密尔-卡拉巴赫','MQA',NULL),
(117,117,NULL,'Mugan-Salyan','mugan-salyan',NULL,'穆甘-萨连','MSA',NULL),
(118,117,NULL,'Nagorni-Qarabax','nagorni-qarabax',NULL,'纳戈尔诺－卡拉巴赫','NQA',NULL),
(119,117,NULL,'Naxcivan','naxcivan',NULL,'纳希切万','NX',NULL),
(120,117,NULL,'Priaraks','priaraks',NULL,'普利亚拉克斯','PRI',NULL),
(121,117,NULL,'Saki','saki',NULL,'舍基','SA',NULL),
(122,117,NULL,'Sumqayit','sumqayit',NULL,'苏姆盖特','SMC',NULL),
(123,117,NULL,'Sirvan','sirvan',NULL,'锡尔万','SIR',NULL),
(124,117,NULL,'Ganca','ganca',NULL,'占贾','GA',NULL),
(125,7,NULL,'Aswan','aswan',NULL,'阿斯旺','ASW',NULL),
(126,7,NULL,'Al Ghurdaqah','al ghurdaqah',NULL,'古尔代盖','GBY',NULL),
(127,7,NULL,'Cairo','cairo',NULL,'开罗','CAI',NULL),
(128,7,NULL,'Shubra al Khaymah','shubra al khaymah',NULL,'苏布拉开马','SKH',NULL),
(129,7,NULL,'Alexandria','alexandria',NULL,'亚历山大','ALY',NULL),
(130,45,NULL,'Afar','afar',NULL,'阿法尔','AF',NULL),
(131,45,NULL,'Amara','amara',NULL,'阿姆哈拉','AH',NULL),
(132,45,NULL,'Oromiya','oromiya',NULL,'奥罗米亚','OR',NULL),
(133,45,NULL,'Binshangul Gumuz','binshangul gumuz',NULL,'宾香古尔','BG',NULL),
(134,45,NULL,'Dire Dawa','dire dawa',NULL,'德雷达瓦','DD',NULL),
(135,45,NULL,'Gambela Hizboch','gambela hizboch',NULL,'甘贝拉各族','GB',NULL),
(136,45,NULL,'Hareri Hizb','hareri hizb',NULL,'哈勒里民族','HR',NULL),
(137,45,NULL,'YeDebub Biheroch','yedebub biheroch',NULL,'南方各族','SN',NULL),
(138,45,NULL,'Sumale','sumale',NULL,'索马里','SM',NULL),
(139,45,NULL,'Tigray','tigray',NULL,'提格雷','TG',NULL),
(140,45,NULL,'Adis abeba','adis abeba',NULL,'亚的斯亚贝巴','AA',NULL),
(141,144,NULL,'Offaly','offaly',NULL,'奥法利','OF',NULL),
(142,144,NULL,'Tipperary','tipperary',NULL,'蒂珀雷里','TP',NULL),
(143,144,NULL,'Dublin','dublin',NULL,'都柏林','DB',NULL),
(144,144,NULL,'Donegal','donegal',NULL,'多内加尔','DG',NULL),
(145,144,NULL,'Galway','galway',NULL,'戈尔韦','GW',NULL),
(146,144,NULL,'Kildare','kildare',NULL,'基尔代尔','KD',NULL),
(147,144,NULL,'Kilkenny','kilkenny',NULL,'基尔肯尼','KK',NULL),
(148,144,NULL,'Cavan','cavan',NULL,'卡范','CV',NULL),
(149,144,NULL,'Carlow','carlow',NULL,'卡洛','CW',NULL),
(150,144,NULL,'Kerry','kerry',NULL,'凯里','KR',NULL),
(151,144,NULL,'Cork','cork',NULL,'科克','CK',NULL),
(152,144,NULL,'Clare','clare',NULL,'克莱尔','CL',NULL),
(153,144,NULL,'Longford','longford',NULL,'朗福德','LF',NULL),
(154,144,NULL,'Louth','louth',NULL,'劳斯','LT',NULL),
(155,144,NULL,'Laois','laois',NULL,'崂斯','LA',NULL),
(156,144,NULL,'Limerick','limerick',NULL,'利默里克','LM',NULL),
(157,144,NULL,'Leitrim','leitrim',NULL,'利特里姆','LR',NULL),
(158,144,NULL,'Roscommon','roscommon',NULL,'罗斯康芒','RC',NULL),
(159,144,NULL,'Mayo','mayo',NULL,'梅奥','MY',NULL),
(160,144,NULL,'Meath','meath',NULL,'米斯','MT',NULL),
(161,144,NULL,'Monaghan','monaghan',NULL,'莫内根','MG',NULL),
(162,144,NULL,'Sligo','sligo',NULL,'斯莱戈','SL',NULL),
(163,144,NULL,'Wicklow','wicklow',NULL,'威克洛','WK',NULL),
(164,144,NULL,'Wexford','wexford',NULL,'韦克斯福德','WX',NULL),
(165,144,NULL,'Waterford','waterford',NULL,'沃特福德','WF',NULL),
(166,144,NULL,'Westmeath','westmeath',NULL,'西米斯','WM',NULL),
(167,130,NULL,'Polva','polva',NULL,'贝尔瓦','65',NULL),
(168,130,NULL,'Harju','harju',NULL,'哈留','37',NULL),
(169,130,NULL,'Rapla','rapla',NULL,'拉普拉','70',NULL),
(170,130,NULL,'Laane','laane',NULL,'里亚内','57',NULL),
(171,130,NULL,'Parnu','parnu',NULL,'帕尔努','67',NULL),
(172,130,NULL,'Saare','saare',NULL,'萨雷','74',NULL),
(173,130,NULL,'Tartu','tartu',NULL,'塔尔图','78',NULL),
(174,130,NULL,'Valga','valga',NULL,'瓦尔加','82',NULL),
(175,130,NULL,'Viljandi','viljandi',NULL,'维良地','84',NULL),
(176,130,NULL,'Laane-Viru','laane-viru',NULL,'维鲁','59',NULL),
(177,130,NULL,'Voru','voru',NULL,'沃鲁','86',NULL),
(178,130,NULL,'Hiiu','hiiu',NULL,'希尤','39',NULL),
(179,130,NULL,'Jarva','jarva',NULL,'耶尔韦','51',NULL),
(180,130,NULL,'Jogeva','jogeva',NULL,'耶盖瓦','49',NULL),
(181,130,NULL,'Ida-Viru','ida-viru',NULL,'依达－维鲁','44',NULL),
(182,157,NULL,'Andorra la Vella','andorra la vella',NULL,'安道尔城','7',NULL),
(183,157,NULL,'Ordino','ordino',NULL,'奥尔迪诺','5',NULL),
(184,157,NULL,'Encamp','encamp',NULL,'恩坎普','3',NULL),
(185,157,NULL,'Canillo','canillo',NULL,'卡尼略','2',NULL),
(186,157,NULL,'Escaldes-Engordany','escaldes-engordany',NULL,'莱塞斯卡尔德－恩戈尔达','8',NULL),
(187,157,NULL,'La Massana','la massana',NULL,'马萨纳','4',NULL),
(188,157,NULL,'Sant Julia de Laria','sant julia de laria',NULL,'圣胡利娅－德洛里亚','6',NULL),
(189,12,NULL,'Cuanza Norte','cuanza norte',NULL,'北宽扎','CNO',NULL),
(190,12,NULL,'Lunda Norte','lunda norte',NULL,'北隆达','LNO',NULL),
(191,12,NULL,'Bengo','bengo',NULL,'本戈','BGO',NULL),
(192,12,NULL,'Benguela','benguela',NULL,'本格拉','BGU',NULL),
(193,12,NULL,'Bie','bie',NULL,'比耶','BIE',NULL),
(194,12,NULL,'Cabinda','cabinda',NULL,'卡宾达','CAB',NULL),
(195,12,NULL,'Cunene','cunene',NULL,'库内内','CNN',NULL),
(196,12,NULL,'Cuando Cubango','cuando cubango',NULL,'宽多库邦戈','CCU',NULL),
(197,12,NULL,'Luanda','luanda',NULL,'罗安达','LUA',NULL),
(198,12,NULL,'Malanje','malanje',NULL,'马兰热','MAL',NULL),
(199,12,NULL,'Moxico','moxico',NULL,'莫希科','MOX',NULL),
(200,12,NULL,'Namibe','namibe',NULL,'纳米贝','NAM',NULL),
(201,12,NULL,'Cuanza Sul','cuanza sul',NULL,'南宽扎','CUS',NULL),
(202,12,NULL,'Lunda Sul','lunda sul',NULL,'南隆达','LSU',NULL),
(203,12,NULL,'Huambo','huambo',NULL,'万博','HUA',NULL),
(204,12,NULL,'Huila','huila',NULL,'威拉','HUI',NULL),
(205,12,NULL,'Uige','uige',NULL,'威热','UIG',NULL),
(206,12,NULL,'Zaire','zaire',NULL,'扎伊尔','ZAI',NULL),
(207,160,NULL,'Burgenland','burgenland',NULL,'布尔根兰','BUR',NULL),
(208,160,NULL,'Tyrol','tyrol',NULL,'蒂罗尔','TYR',NULL),
(209,160,NULL,'Vorarlberg','vorarlberg',NULL,'福拉尔贝格','VOR',NULL),
(210,160,NULL,'Carinthia','carinthia',NULL,'克恩顿','CAT',NULL),
(211,160,NULL,'Salzburg','salzburg',NULL,'萨尔茨堡','SZG',NULL),
(212,160,NULL,'Upper Austria','upper austria',NULL,'上奥地利','UAU',NULL),
(213,160,NULL,'Styria','styria',NULL,'施蒂利亚','STY',NULL),
(214,160,NULL,'Vienna','vienna',NULL,'维也纳','VDD',NULL),
(215,160,NULL,'Lower Austria','lower austria',NULL,'下奥地利','LAU',NULL),
(216,184,NULL,'Northern','northern',NULL,'北部','NO',NULL),
(217,184,NULL,'Bougainville','bougainville',NULL,'布干维尔','BV',NULL),
(218,184,NULL,'Eastern Highlands','eastern highlands',NULL,'东部高地','EH',NULL),
(219,184,NULL,'East Sepik','east sepik',NULL,'东塞皮克','ES',NULL),
(220,184,NULL,'East New Britain','east new britain',NULL,'东新不列颠','EB',NULL),
(221,184,NULL,'Enga','enga',NULL,'恩加','EN',NULL),
(222,184,NULL,'Gulf','gulf',NULL,'海湾','GU',NULL),
(223,184,NULL,'Madang','madang',NULL,'马当','MD',NULL),
(224,184,NULL,'Manus','manus',NULL,'马努斯','MN',NULL),
(225,184,NULL,'Milne Bay','milne bay',NULL,'米尔恩湾','MB',NULL),
(226,184,NULL,'Port Moresby','port moresby',NULL,'莫尔兹比港','NC',NULL),
(227,184,NULL,'Morobe','morobe',NULL,'莫罗贝','MR',NULL),
(228,184,NULL,'Southern Highlands','southern highlands',NULL,'南部高地','SH',NULL),
(229,184,NULL,'Simbu','simbu',NULL,'钦布','SI',NULL),
(230,184,NULL,'Sandaun','sandaun',NULL,'桑道恩','SA',NULL),
(231,184,NULL,'Western','western',NULL,'西部','WE',NULL),
(232,184,NULL,'Western Highlands','western highlands',NULL,'西部高地','WH',NULL),
(233,184,NULL,'West New Britain','west new britain',NULL,'西新不列颠','WB',NULL),
(234,184,NULL,'New Ireland','new ireland',NULL,'新爱尔兰','NI',NULL),
(235,92,NULL,'Peshawar','peshawar',NULL,'白沙瓦','PEW',NULL),
(236,92,NULL,'Faisalabad','faisalabad',NULL,'费萨拉巴德','LYP',NULL),
(237,92,NULL,'Gujranwala','gujranwala',NULL,'故吉软瓦拉','GUJ',NULL),
(238,92,NULL,'Hyderabad','hyderabad',NULL,'海德拉巴','HDD',NULL),
(239,92,NULL,'Karachi','karachi',NULL,'卡拉奇','KCT',NULL),
(240,92,NULL,'Lahore','lahore',NULL,'拉合尔','LHE',NULL),
(241,92,NULL,'Rawalpindi','rawalpindi',NULL,'拉瓦尔品第','RWP',NULL),
(242,92,NULL,'Multan','multan',NULL,'木尔坦','MUX',NULL),
(243,92,NULL,'Islamabad','islamabad',NULL,'伊斯兰堡','ISB',NULL),
(244,189,NULL,'Amambay','amambay',NULL,'阿曼拜','AM',NULL),
(245,189,NULL,'Presidente Hayes','presidente hayes',NULL,'阿耶斯总统省','PH',NULL),
(246,189,NULL,'Paraguari','paraguari',NULL,'巴拉瓜里','PA',NULL),
(247,189,NULL,'Boqueron','boqueron',NULL,'博克龙','BO',NULL),
(248,189,NULL,'Guaira','guaira',NULL,'瓜伊拉','GU',NULL),
(249,189,NULL,'Caaguazu','caaguazu',NULL,'卡瓜苏','CG',NULL),
(250,189,NULL,'Canindeyu','canindeyu',NULL,'卡嫩迪尤','CN',NULL),
(251,189,NULL,'Caazapa','caazapa',NULL,'卡萨帕','CZ',NULL),
(252,189,NULL,'Concepcion','concepcion',NULL,'康塞普西翁','CC',NULL),
(253,189,NULL,'Cordillera','cordillera',NULL,'科迪勒拉','CD',NULL),
(254,189,NULL,'Misiones','misiones',NULL,'米西奥内斯','MI',NULL),
(255,189,NULL,'Neembucu','neembucu',NULL,'涅恩布库','NE',NULL),
(256,189,NULL,'Alto Paraguay','alto paraguay',NULL,'上巴拉圭','AG',NULL),
(257,189,NULL,'Alto Parana','alto parana',NULL,'上巴拉那','AN',NULL),
(258,189,NULL,'San Pedro','san pedro',NULL,'圣佩德罗','SP',NULL),
(259,189,NULL,'Asuncion','asuncion',NULL,'亚松森特别区','AS',NULL),
(260,189,NULL,'Itapua','itapua',NULL,'伊塔普亚','IT',NULL),
(261,189,NULL,'Central','central',NULL,'中央','CE',NULL),
(262,74,NULL,'Gaza Strip','gaza strip',NULL,'加沙地带','GZ',NULL),
(263,74,NULL,'West Bank','west bank',NULL,'西岸','WE',NULL),
(264,61,NULL,'Ash-Shamaliyah','ash-shamaliyah',NULL,'北部','5',NULL),
(265,61,NULL,'Al-Hadd','al-hadd',NULL,'哈德','1',NULL),
(266,61,NULL,'Hammad','hammad',NULL,'哈马德','12',NULL),
(267,61,NULL,'Ar-Rifa','ar-rifa',NULL,'里法','9',NULL),
(268,61,NULL,'Al-Manamah','al-manamah',NULL,'麦纳麦','3',NULL),
(269,61,NULL,'Al-Muharraq','al-muharraq',NULL,'穆哈拉格','2',NULL),
(270,61,NULL,'Al-Gharbiyah','al-gharbiyah',NULL,'西部','10',NULL),
(271,61,NULL,'Isa','isa',NULL,'伊萨城','8',NULL),
(272,61,NULL,'Al-Wusta','al-wusta',NULL,'中部','7',NULL),
(273,211,NULL,'Acre','acre',NULL,'阿克里','AC',NULL),
(274,211,NULL,'Alagoas','alagoas',NULL,'阿拉戈斯','AL',NULL),
(275,211,NULL,'Amapa','amapa',NULL,'阿马帕','AP',NULL),
(276,211,NULL,'Parana','parana',NULL,'巴拉那','PR',NULL),
(277,211,NULL,'Brasilia','brasilia',NULL,'巴西利亚','BSB',NULL),
(278,211,NULL,'Bahia','bahia',NULL,'巴伊亚','BA',NULL),
(279,211,NULL,'Rio Grande do Norte','rio grande do norte',NULL,'北里奥格兰德','RN',NULL),
(280,211,NULL,'Pernambuco','pernambuco',NULL,'伯南布哥','PE',NULL),
(281,211,NULL,'Goias','goias',NULL,'戈亚斯','GO',NULL),
(282,211,NULL,'Rondonia','rondonia',NULL,'朗多尼亚','RO',NULL),
(283,211,NULL,'Rio de Janeiro','rio de janeiro',NULL,'里约热内卢','RJ',NULL),
(284,211,NULL,'Roraima','roraima',NULL,'罗赖马','RR',NULL),
(285,211,NULL,'Maranhao','maranhao',NULL,'马拉尼昂','MA',NULL),
(286,211,NULL,'Mato Grosso','mato grosso',NULL,'马托格罗索','MT',NULL),
(287,211,NULL,'Minas Gerais','minas gerais',NULL,'米纳斯吉拉斯','MG',NULL),
(288,211,NULL,'Rio Grande do Sul','rio grande do sul',NULL,'南里奥格兰德','RS',NULL),
(289,211,NULL,'Mato Grosso do Sul','mato grosso do sul',NULL,'南马托格罗索','MS',NULL),
(290,211,NULL,'Para','para',NULL,'帕拉','PA',NULL),
(291,211,NULL,'Paraiba','paraiba',NULL,'帕拉伊巴','PB',NULL),
(292,211,NULL,'Piaui','piaui',NULL,'皮奥伊','PI',NULL),
(293,211,NULL,'Ceara','ceara',NULL,'塞阿拉','CE',NULL),
(294,211,NULL,'Sergipe','sergipe',NULL,'塞尔希培','SE',NULL),
(295,211,NULL,'Espirito Santo','espirito santo',NULL,'圣埃斯皮里图','ES',NULL),
(296,211,NULL,'Sao Paulo','sao paulo',NULL,'圣保罗','SP',NULL),
(297,211,NULL,'Santa Catarina','santa catarina',NULL,'圣卡塔琳娜','SC',NULL),
(298,211,NULL,'Tocantins','tocantins',NULL,'托坎廷斯','TO',NULL),
(299,211,NULL,'Amazonas','amazonas',NULL,'亚马孙','AM',NULL),
(300,118,NULL,'Bresckaja','bresckaja',NULL,'布列斯特','BR',NULL),
(301,118,NULL,'Homelskaja','homelskaja',NULL,'戈梅利','HO',NULL),
(302,118,NULL,'Hrodzenskaja','hrodzenskaja',NULL,'格罗德诺','HR',NULL),
(303,118,NULL,'Minsk','minsk',NULL,'明斯克市','MI',NULL),
(304,118,NULL,'Mahileuskaja','mahileuskaja',NULL,'莫吉廖夫','MA',NULL),
(305,118,NULL,'Vicebskaja','vicebskaja',NULL,'维捷布斯克','VI',NULL),
(306,161,NULL,'Burgas','burgas',NULL,'布尔加斯','BOJ',NULL),
(307,161,NULL,'Khaskovo','khaskovo',NULL,'卡斯科伏','KHO',NULL),
(308,161,NULL,'Ruse','ruse',NULL,'鲁塞','ROU',NULL),
(309,161,NULL,'Lovech','lovech',NULL,'洛维奇','LVP',NULL),
(310,161,NULL,'Montana','montana',NULL,'蒙塔纳','OZA',NULL),
(311,161,NULL,'Plovdiv','plovdiv',NULL,'普罗夫迪夫','PDV',NULL),
(312,161,NULL,'Sofiya','sofiya',NULL,'索非亚','SOF',NULL),
(313,161,NULL,'Grad Sofiya','grad sofiya',NULL,'索非亚市','GSO',NULL),
(314,161,NULL,'Varna','varna',NULL,'瓦尔纳','VAR',NULL),
(315,2,NULL,'Alibori','alibori',NULL,'阿黎博里','AL',NULL),
(316,2,NULL,'Atakora','atakora',NULL,'阿塔科拉','AK',NULL),
(317,2,NULL,'Littoral','littoral',NULL,'滨海','LI',NULL),
(318,2,NULL,'Bohicon','bohicon',NULL,'波希康市','BOH',NULL),
(319,2,NULL,'Borgou','borgou',NULL,'博尔古','BO',NULL),
(320,2,NULL,'Atlantique','atlantique',NULL,'大西洋','AQ',NULL),
(321,2,NULL,'Plateau','plateau',NULL,'高原','PL',NULL),
(322,2,NULL,'Kouffo','kouffo',NULL,'库福','KO',NULL),
(323,2,NULL,'Mono','mono',NULL,'莫诺','MO',NULL),
(324,2,NULL,'Collines','collines',NULL,'丘陵','CO',NULL),
(325,2,NULL,'Oueme','oueme',NULL,'韦梅','OU',NULL),
(326,2,NULL,'Donga','donga',NULL,'峡谷','DO',NULL),
(327,2,NULL,'Zou','zou',NULL,'祖','ZO',NULL),
(328,145,NULL,'Hainaut','hainaut',NULL,'埃诺','WHT',NULL),
(329,145,NULL,'Antwerpen','antwerpen',NULL,'安特卫普','VAN',NULL),
(330,145,NULL,'Brabant-Wallone','brabant-wallone',NULL,'布拉班特-瓦隆','WBR',NULL),
(331,145,NULL,'Brussels','brussels',NULL,'布鲁塞尔','BRU',NULL),
(332,145,NULL,'Oost-Vlaanderen','oost-vlaanderen',NULL,'东佛兰德','VOV',NULL),
(333,145,NULL,'Vlaams-Brabant','vlaams-brabant',NULL,'佛兰芒-布拉班特','VBR',NULL),
(334,145,NULL,'Liege','liege',NULL,'列日','WLG',NULL),
(335,145,NULL,'Limburg','limburg',NULL,'林堡','VLI',NULL),
(336,145,NULL,'Luxembourg','luxembourg',NULL,'卢森堡','WLX',NULL),
(337,145,NULL,'Namur','namur',NULL,'那慕尔','WNA',NULL),
(338,145,NULL,'West-Vlaanderen','west-vlaanderen',NULL,'西佛兰德','VWV',NULL),
(339,154,NULL,'Elbląg','elbląg',NULL,'埃尔布隆格','ELB',NULL),
(340,154,NULL,'Olsztyn','olsztyn',NULL,'奥尔什丁','OLS',NULL),
(341,154,NULL,'Ostrołeka','ostrołeka',NULL,'奥斯特罗文卡','OSS',NULL),
(342,154,NULL,'Bydgoszcz','bydgoszcz',NULL,'比得哥什','BZG',NULL),
(343,154,NULL,'Piotrkow','piotrkow',NULL,'彼得库夫','PIO',NULL),
(344,154,NULL,'Bytom','bytom',NULL,'比托姆','BYT',NULL),
(345,154,NULL,'Biała Podlaska','biała podlaska',NULL,'比亚瓦波德拉斯卡','BAP',NULL),
(346,154,NULL,'Białystok','białystok',NULL,'比亚维斯托克','BIA',NULL),
(347,154,NULL,'Opole','opole',NULL,'波莱','OPO',NULL),
(348,154,NULL,'Poznan','poznan',NULL,'波兹南','POZ',NULL),
(349,154,NULL,'Dabrowa Gornicza','dabrowa gornicza',NULL,'达布罗瓦戈尼察','DAB',NULL),
(350,154,NULL,'Gorzow Wlkp','gorzow wlkp',NULL,'大波兰地区戈茹夫','GOW',NULL),
(351,154,NULL,'Wroclaw','wroclaw',NULL,'弗罗茨瓦夫','WRO',NULL),
(352,154,NULL,'Wlocławek','wlocławek',NULL,'弗沃茨瓦韦克','WLO',NULL),
(353,154,NULL,'Gdansk','gdansk',NULL,'格但斯克','GDN',NULL),
(354,154,NULL,'Gdynia','gdynia',NULL,'格丁尼亚','GDY',NULL),
(355,154,NULL,'Gliwice','gliwice',NULL,'格利维采','GWC',NULL),
(356,154,NULL,'Grudziadz','grudziadz',NULL,'格鲁琼兹','GRU',NULL),
(357,154,NULL,'Chełm','chełm',NULL,'海乌姆','CHO',NULL),
(358,154,NULL,'Warszawa','warszawa',NULL,'华沙','WAW',NULL),
(359,154,NULL,'Chorzow','chorzow',NULL,'霍茹夫','CHZ',NULL),
(360,154,NULL,'Kalisz','kalisz',NULL,'卡利什','KAL',NULL),
(361,154,NULL,'Katowice','katowice',NULL,'卡托维兹','KTW',NULL),
(362,154,NULL,'Kielce','kielce',NULL,'凯尔采','KLC',NULL),
(363,154,NULL,'Konin','konin',NULL,'科宁','KON',NULL),
(364,154,NULL,'Koszalin','koszalin',NULL,'科沙林','OSZ',NULL),
(365,154,NULL,'Krakow','krakow',NULL,'克拉科夫','KRK',NULL),
(366,154,NULL,'Krosno','krosno',NULL,'克罗斯诺','KRO',NULL),
(367,154,NULL,'Radom','radom',NULL,'拉多姆','RDM',NULL),
(368,154,NULL,'Legnica','legnica',NULL,'莱格尼察','LEG',NULL),
(369,154,NULL,'Leszno','leszno',NULL,'莱什诺','LEZ',NULL),
(370,154,NULL,'Lublin','lublin',NULL,'卢布林','LUL',NULL),
(371,154,NULL,'Ruda Sl','ruda sl',NULL,'鲁达','RDS',NULL),
(372,154,NULL,'Lodz','lodz',NULL,'罗兹','LOD',NULL),
(373,154,NULL,'Zielona Gora','zielona gora',NULL,'绿山城','IEG',NULL),
(374,154,NULL,'Mysłowice','mysłowice',NULL,'米什洛维采','MYL',NULL),
(375,154,NULL,'Piła','piła',NULL,'皮瓦','PIL',NULL),
(376,154,NULL,'Przemysl','przemysl',NULL,'普热梅希尔','PRZ',NULL),
(377,154,NULL,'Plock','plock',NULL,'普沃茨克','PLO',NULL),
(378,154,NULL,'Ciechanow','ciechanow',NULL,'切哈努夫','CIE',NULL),
(379,154,NULL,'Rzeszow','rzeszow',NULL,'热舒夫','RZE',NULL),
(380,154,NULL,'Szczecin','szczecin',NULL,'什切青','SZZ',NULL),
(381,154,NULL,'Skierniewice','skierniewice',NULL,'斯凯尔涅维采','SKI',NULL),
(382,154,NULL,'Slupsk','slupsk',NULL,'斯武普斯克','SLP',NULL),
(383,154,NULL,'Suwałki','suwałki',NULL,'苏瓦乌基','SWL',NULL),
(384,154,NULL,'Sopot','sopot',NULL,'索波特','SOP',NULL),
(385,154,NULL,'Sosnowiec','sosnowiec',NULL,'索斯诺维茨','SWC',NULL),
(386,154,NULL,'Tarnow','tarnow',NULL,'塔尔努夫','TAR',NULL),
(387,154,NULL,'Tarnobrzeg','tarnobrzeg',NULL,'塔尔诺布热格','QEP',NULL),
(388,154,NULL,'Tychy','tychy',NULL,'特切','TYY',NULL),
(389,154,NULL,'Torun','torun',NULL,'托伦','TOR',NULL),
(390,154,NULL,'Walbrzych','walbrzych',NULL,'瓦乌布日赫','WZH',NULL),
(391,154,NULL,'Lomza','lomza',NULL,'沃姆扎','QOY',NULL),
(392,154,NULL,'Siemianowice Sl','siemianowice sl',NULL,'希米亚诺维采','SOW',NULL),
(393,154,NULL,'Swinoujscie','swinoujscie',NULL,'希维诺乌伊希切','SWI',NULL),
(394,154,NULL,'Swietochłowice','swietochłowice',NULL,'希维托赫洛维采','SWT',NULL),
(395,154,NULL,'Siedlce','siedlce',NULL,'谢德尔采','SDC',NULL),
(396,154,NULL,'Sieradz','sieradz',NULL,'谢拉兹','SIR',NULL),
(397,154,NULL,'Nowy Sacz','nowy sacz',NULL,'新松奇','NOW',NULL),
(398,154,NULL,'Jaworzno','jaworzno',NULL,'雅沃兹诺','JAW',NULL),
(399,154,NULL,'Jelenia Gora','jelenia gora',NULL,'耶莱尼亚古拉','JEG',NULL),
(400,154,NULL,'Zabrze','zabrze',NULL,'扎布热','ZAB',NULL),
(401,154,NULL,'Zamosc','zamosc',NULL,'扎莫希奇','ZAM',NULL),
(402,210,NULL,'El Alto','el alto',NULL,'奥尔托','ALT',NULL),
(403,210,NULL,'Oruro','oruro',NULL,'奥鲁罗','ORU',NULL),
(404,210,NULL,'El Beni','el beni',NULL,'贝尼','BEN',NULL),
(405,210,NULL,'Potosi','potosi',NULL,'波多西','POI',NULL),
(406,210,NULL,'Quillacollo','quillacollo',NULL,'基拉科洛','QUI',NULL),
(407,210,NULL,'Cochabamba','cochabamba',NULL,'科恰班巴','CBB',NULL),
(408,210,NULL,'La Paz','la paz',NULL,'拉巴斯','LPB',NULL),
(409,210,NULL,'Pando','pando',NULL,'潘多','PAN',NULL),
(410,210,NULL,'Chuquisaca','chuquisaca',NULL,'丘基萨卡','CHU',NULL),
(411,210,NULL,'Sacaba','sacaba',NULL,'萨卡巴','SAC',NULL),
(412,210,NULL,'Santa Cruz','santa cruz',NULL,'圣克鲁斯','SRZ',NULL),
(413,210,NULL,'Tarija','tarija',NULL,'塔里哈','TJA',NULL),
(414,139,NULL,'Posavski','posavski',NULL,'波萨维纳','FPO',NULL),
(415,139,NULL,'Bosansko-Podrinjski','bosansko-podrinjski',NULL,'波斯尼亚－波德里涅','FBP',NULL),
(416,139,NULL,'Tomislavgrad','tomislavgrad',NULL,'多米斯拉夫格勒','FTO',NULL),
(417,139,NULL,'Hercegovacko-Neretvanski','hercegovacko-neretvanski',NULL,'黑塞哥维那－涅雷特瓦','FHN',NULL),
(418,139,NULL,'Sarajevo','sarajevo',NULL,'萨拉热窝','FSA',NULL),
(419,139,NULL,'Tuzlanski-Podrinjski','tuzlanski-podrinjski',NULL,'图兹拉－波德里涅','FTU',NULL),
(420,139,NULL,'Unsko-Sanski','unsko-sanski',NULL,'乌纳－萨纳','FUS',NULL),
(421,139,NULL,'Hercegovacko-Bosanski','hercegovacko-bosanski',NULL,'西波斯尼亚','FHB',NULL),
(422,139,NULL,'Zapadno-Hercegovaki','zapadno-hercegovaki',NULL,'西黑塞哥维那','FZH',NULL),
(423,139,NULL,'Zenicko-Dobojski','zenicko-dobojski',NULL,'泽尼察－多博伊','FZE',NULL),
(424,139,NULL,'Srednjo-Bosanski','srednjo-bosanski',NULL,'中波斯尼亚','FSB',NULL),
(425,209,NULL,'Belize','belize',NULL,'伯利兹','BZ',NULL),
(426,209,NULL,'Orange Walk','orange walk',NULL,'橘园','OW',NULL),
(427,209,NULL,'Cayo','cayo',NULL,'卡约','CY',NULL),
(428,209,NULL,'Corozal','corozal',NULL,'科罗萨尔','CR',NULL),
(429,209,NULL,'Stann Creek','stann creek',NULL,'斯坦港','SC',NULL),
(430,209,NULL,'Toledo','toledo',NULL,'托莱多','TO',NULL),
(431,9,NULL,'Bale','bale',NULL,'巴雷','BAL',NULL),
(432,9,NULL,'Bam','bam',NULL,'巴姆','BAM',NULL),
(433,9,NULL,'Banwa','banwa',NULL,'巴瓦','BAN',NULL),
(434,9,NULL,'Bazega','bazega',NULL,'巴泽加','BAZ',NULL),
(435,9,NULL,'Poni','poni',NULL,'波尼','PON',NULL),
(436,9,NULL,'Boulgou','boulgou',NULL,'布尔古','BLG',NULL),
(437,9,NULL,'Boulkiemde','boulkiemde',NULL,'布尔基恩德','BOK',NULL),
(438,9,NULL,'Bougouriba','bougouriba',NULL,'布古里巴','BOR',NULL),
(439,9,NULL,'Ganzourgou','ganzourgou',NULL,'冈祖尔古','GAN',NULL),
(440,9,NULL,'Gourma','gourma',NULL,'古尔马','GOU',NULL),
(441,9,NULL,'Ziro','ziro',NULL,'济罗','ZIR',NULL),
(442,9,NULL,'Kadiogo','kadiogo',NULL,'卡焦戈','KAD',NULL),
(443,9,NULL,'Kenedougou','kenedougou',NULL,'凯内杜古','KEN',NULL),
(444,9,NULL,'Komondjari','komondjari',NULL,'科蒙加里','KOO',NULL),
(445,9,NULL,'Comoe','comoe',NULL,'科莫埃','COM',NULL),
(446,9,NULL,'Kompienga','kompienga',NULL,'孔皮恩加','KOP',NULL),
(447,9,NULL,'Kossi','kossi',NULL,'孔西','KOS',NULL),
(448,9,NULL,'Koulpelogo','koulpelogo',NULL,'库尔佩罗戈','KOL',NULL),
(449,9,NULL,'Kourweogo','kourweogo',NULL,'库尔维奥戈','KOW',NULL),
(450,9,NULL,'Kouritenga','kouritenga',NULL,'库里滕加','KOT',NULL),
(451,9,NULL,'Leraba','leraba',NULL,'雷拉巴','LER',NULL),
(452,9,NULL,'Loroum','loroum',NULL,'罗卢姆','LOR',NULL),
(453,9,NULL,'Mouhoun','mouhoun',NULL,'穆翁','MOU',NULL),
(454,9,NULL,'Namentenga','namentenga',NULL,'纳门滕加','NAM',NULL),
(455,9,NULL,'Nahouri','nahouri',NULL,'纳乌里','NAH',NULL),
(456,9,NULL,'Nayala','nayala',NULL,'纳亚拉','NAY',NULL),
(457,9,NULL,'Gnagna','gnagna',NULL,'尼亚尼亚','GNA',NULL),
(458,9,NULL,'Noumbiel','noumbiel',NULL,'努姆比埃尔','NOU',NULL),
(459,9,NULL,'Passore','passore',NULL,'帕索雷','PAS',NULL),
(460,9,NULL,'Seno','seno',NULL,'塞诺','SEN',NULL),
(461,9,NULL,'Sanguie','sanguie',NULL,'桑吉','SAG',NULL),
(462,9,NULL,'Sanmatenga','sanmatenga',NULL,'桑马滕加','SAM',NULL),
(463,9,NULL,'Sourou','sourou',NULL,'苏鲁','SOR',NULL),
(464,9,NULL,'Soum','soum',NULL,'苏姆','SOM',NULL),
(465,9,NULL,'Tapoa','tapoa',NULL,'塔波阿','TAP',NULL),
(466,9,NULL,'Tuy','tuy',NULL,'图伊','TUY',NULL),
(467,9,NULL,'Houet','houet',NULL,'乌埃','HOU',NULL),
(468,9,NULL,'Oubritenga','oubritenga',NULL,'乌布里滕加','OUB',NULL),
(469,9,NULL,'Oudalan','oudalan',NULL,'乌达兰','OUD',NULL),
(470,9,NULL,'Sissili','sissili',NULL,'锡西里','SIS',NULL),
(471,9,NULL,'Yagha','yagha',NULL,'亚加','YAG',NULL),
(472,9,NULL,'Yatenga','yatenga',NULL,'亚滕加','YAT',NULL),
(473,9,NULL,'Ioba','ioba',NULL,'伊奥巴','IOA',NULL),
(474,9,NULL,'Zoundweogo','zoundweogo',NULL,'宗德韦奥戈','ZOW',NULL),
(475,9,NULL,'Zondoma','zondoma',NULL,'宗多马','ZOD',NULL),
(476,50,NULL,'Bubanza','bubanza',NULL,'布班扎','BB',NULL),
(477,50,NULL,'Bururi','bururi',NULL,'布鲁里','BR',NULL),
(478,50,NULL,'Bujumbura Mairie','bujumbura mairie',NULL,'布琼布拉城市','BM',NULL),
(479,50,NULL,'Bujumbura Rural','bujumbura rural',NULL,'布琼布拉乡村','BU',NULL),
(480,50,NULL,'Ngozi','ngozi',NULL,'恩戈齐','NG',NULL),
(481,50,NULL,'Kirundo','kirundo',NULL,'基龙多','KI',NULL),
(482,50,NULL,'Gitega','gitega',NULL,'基特加','GI',NULL),
(483,50,NULL,'Karuzi','karuzi',NULL,'卡鲁济','KR',NULL),
(484,50,NULL,'Kayanza','kayanza',NULL,'卡扬扎','KY',NULL),
(485,50,NULL,'Cankuzo','cankuzo',NULL,'坎库佐','CA',NULL),
(486,50,NULL,'Rutana','rutana',NULL,'鲁塔纳','RT',NULL),
(487,50,NULL,'Ruyigi','ruyigi',NULL,'鲁伊吉','RY',NULL),
(488,50,NULL,'Makamba','makamba',NULL,'马坎巴','MA',NULL),
(489,50,NULL,'Muramvya','muramvya',NULL,'穆拉姆维亚','MU',NULL),
(490,50,NULL,'Mwaro','mwaro',NULL,'穆瓦洛','MW',NULL),
(491,50,NULL,'Muyinga','muyinga',NULL,'穆因加','MY',NULL),
(492,50,NULL,'Cibitoke','cibitoke',NULL,'锡比托凯','CI',NULL),
(493,73,NULL,'Haeju','haeju',NULL,'海州','HAE',NULL),
(494,73,NULL,'Hyesan','hyesan',NULL,'惠山','HYE',NULL),
(495,73,NULL,'Kanggye','kanggye',NULL,'江界','KAN',NULL),
(496,73,NULL,'Kaesong','kaesong',NULL,'开城','KSN',NULL),
(497,73,NULL,'Naseon','naseon',NULL,'罗先','NAS',NULL),
(498,73,NULL,'Namp\'o','namp\'o',NULL,'南浦','NAM',NULL),
(499,73,NULL,'Pyongyang','pyongyang',NULL,'平壤','FNJ',NULL),
(500,73,NULL,'Ch\'ongjin','ch\'ongjin',NULL,'清津','CHO',NULL),
(501,73,NULL,'Sariwon','sariwon',NULL,'沙里院','SAR',NULL),
(502,73,NULL,'Hamhung','hamhung',NULL,'咸兴','HAM',NULL),
(503,73,NULL,'Sinuiju','sinuiju',NULL,'新义州','SII',NULL),
(504,73,NULL,'Wonsan','wonsan',NULL,'元山','WON',NULL),
(505,147,NULL,'Aarhus','aarhus',NULL,'奥胡斯','AR',NULL),
(506,147,NULL,'Nordjylland','nordjylland',NULL,'北日德兰','VSV',NULL),
(507,147,NULL,'Bornholm','bornholm',NULL,'博恩霍尔姆','BO',NULL),
(508,147,NULL,'Frederiksborg','frederiksborg',NULL,'菲特烈堡','FRE',NULL),
(509,147,NULL,'Fyn','fyn',NULL,'菲茵','FY',NULL),
(510,147,NULL,'Copenhagen','copenhagen',NULL,'哥本哈根','CPH',NULL),
(511,147,NULL,'Ribe','ribe',NULL,'里伯','RIB',NULL),
(512,147,NULL,'Ringkoebing','ringkoebing',NULL,'灵克宾','RKG',NULL),
(513,147,NULL,'Roskilde','roskilde',NULL,'罗斯基勒','RKE',NULL),
(514,147,NULL,'Soenderjylland','soenderjylland',NULL,'南日德兰','VBI',NULL),
(515,147,NULL,'Storstroem','storstroem',NULL,'斯多斯特姆','ST',NULL),
(516,147,NULL,'Viborg','viborg',NULL,'维堡','VIB',NULL),
(517,147,NULL,'Vejle','vejle',NULL,'维厄勒','VEJ',NULL),
(518,147,NULL,'Vestsjaelland','vestsjaelland',NULL,'西希兰','VS',NULL),
(519,149,NULL,'Arnsberg','arnsberg',NULL,'阿恩斯贝格','ARN',NULL),
(520,149,NULL,'Erfurt','erfurt',NULL,'爱尔福特','ERF',NULL),
(521,149,NULL,'Ansbach','ansbach',NULL,'安斯巴格','ANS',NULL),
(522,149,NULL,'Augsburg','augsburg',NULL,'奥格斯堡','AGB',NULL),
(523,149,NULL,'Berlin','berlin',NULL,'柏林','BE',NULL),
(524,149,NULL,'Bayreuth','bayreuth',NULL,'拜伊罗特','BYU',NULL),
(525,149,NULL,'Bielefeld','bielefeld',NULL,'比勒费尔德','BFE',NULL),
(526,149,NULL,'Potsdam','potsdam',NULL,'波茨坦','POT',NULL),
(527,149,NULL,'Bochum','bochum',NULL,'波鸿','BOM',NULL),
(528,149,NULL,'Bremen','bremen',NULL,'不来梅','HB',NULL),
(529,149,NULL,'Brunswick','brunswick',NULL,'不伦瑞克','BRW',NULL),
(530,149,NULL,'Darmstadt','darmstadt',NULL,'达姆施塔特','DAR',NULL),
(531,149,NULL,'Detmold','detmold',NULL,'代特莫尔特','DET',NULL),
(532,149,NULL,'Dresden','dresden',NULL,'德累斯顿','DRS',NULL),
(533,149,NULL,'Dessau','dessau',NULL,'德绍','DES',NULL),
(534,149,NULL,'Dusseldorf','dusseldorf',NULL,'杜塞尔多夫','DUS',NULL),
(535,149,NULL,'Frankfurt','frankfurt',NULL,'法兰克福','FFO',NULL),
(536,149,NULL,'Freiburg','freiburg',NULL,'弗赖堡','FBG',NULL),
(537,149,NULL,'Halle','halle',NULL,'哈雷','HAE',NULL),
(538,149,NULL,'Hamburg','hamburg',NULL,'汉堡','HH',NULL),
(539,149,NULL,'Hannover','hannover',NULL,'汉诺威','HAJ',NULL),
(540,149,NULL,'Kiel','kiel',NULL,'基尔','KEL',NULL),
(541,149,NULL,'GieBen','gieben',NULL,'吉森','GBN',NULL),
(542,149,NULL,'Karlsruhe','karlsruhe',NULL,'卡尔斯鲁厄','KAE',NULL),
(543,149,NULL,'Kassel','kassel',NULL,'卡塞尔','KAS',NULL),
(544,149,NULL,'Chemnitz','chemnitz',NULL,'开姆尼斯','CHE',NULL),
(545,149,NULL,'Koblenz','koblenz',NULL,'科布伦次','KOB',NULL),
(546,149,NULL,'Cologne','cologne',NULL,'科隆','CGN',NULL),
(547,149,NULL,'Leipzig','leipzig',NULL,'莱比锡','LEJ',NULL),
(548,149,NULL,'Landshut','landshut',NULL,'兰茨胡特','LDH',NULL),
(549,149,NULL,'Luneburg','luneburg',NULL,'吕讷堡','LBG',NULL),
(550,149,NULL,'Magdeburg','magdeburg',NULL,'马格德堡','MAG',NULL),
(551,149,NULL,'Mannheim','mannheim',NULL,'曼海姆','MHG',NULL),
(552,149,NULL,'Mainz','mainz',NULL,'美因兹','MAI',NULL),
(553,149,NULL,'Muenster','muenster',NULL,'明斯特','MUN',NULL),
(554,149,NULL,'Munich','munich',NULL,'慕尼黑','MUC',NULL),
(555,149,NULL,'Nuremberg','nuremberg',NULL,'纽伦堡','NUE',NULL),
(556,149,NULL,'Schwerin','schwerin',NULL,'什未林','SWH',NULL),
(557,149,NULL,'Stuttgart','stuttgart',NULL,'斯图加特','STR',NULL),
(558,149,NULL,'Trier','trier',NULL,'特里尔','TRI',NULL),
(559,149,NULL,'Wiesbaden','wiesbaden',NULL,'威斯巴登','WIB',NULL),
(560,149,NULL,'Wuerzburg','wuerzburg',NULL,'维尔茨堡','WUG',NULL),
(561,88,NULL,'Aileu','aileu',NULL,'阿伊莱乌','AL',NULL),
(562,88,NULL,'Ainaro','ainaro',NULL,'阿伊纳罗','AN',NULL),
(563,88,NULL,'Ermera','ermera',NULL,'埃尔梅拉','ER',NULL),
(564,88,NULL,'Ambeno','ambeno',NULL,'安贝诺','AM',NULL),
(565,88,NULL,'Baucau','baucau',NULL,'包考','BA',NULL),
(566,88,NULL,'Bobonaro','bobonaro',NULL,'博博纳罗','BO',NULL),
(567,88,NULL,'Dili','dili',NULL,'帝力','DI',NULL),
(568,88,NULL,'Kovalima','kovalima',NULL,'科瓦利马','KO',NULL),
(569,88,NULL,'Lautem','lautem',NULL,'劳滕','LA',NULL),
(570,88,NULL,'Liquica','liquica',NULL,'利基卡','LI',NULL),
(571,88,NULL,'Manatuto','manatuto',NULL,'马纳图托','MT',NULL),
(572,88,NULL,'Manofahi','manofahi',NULL,'马努法伊','MF',NULL),
(573,88,NULL,'Viqueque','viqueque',NULL,'维克克','VI',NULL),
(574,42,NULL,'Maritime','maritime',NULL,'滨海区','M',NULL),
(575,42,NULL,'Savanes','savanes',NULL,'草原区','S',NULL),
(576,42,NULL,'Plateaux','plateaux',NULL,'高原区','P',NULL),
(577,42,NULL,'Kara','kara',NULL,'卡拉区','K',NULL),
(578,42,NULL,'Centre','centre',NULL,'中部区','C',NULL),
(579,118,NULL,'Abakan','abakan',NULL,'阿巴坎','ABA',NULL),
(580,118,NULL,'Arkhangelsk','arkhangelsk',NULL,'阿尔汉格尔斯克','ARK',NULL),
(581,118,NULL,'Aginskoye','aginskoye',NULL,'阿金斯科耶','AGI',NULL),
(582,118,NULL,'Anadyr','anadyr',NULL,'阿纳德尔','DYR',NULL),
(583,118,NULL,'Astrakhan','astrakhan',NULL,'阿斯特拉罕','AST',NULL),
(584,118,NULL,'Elista','elista',NULL,'埃利斯塔','ESL',NULL),
(585,118,NULL,'Orel','orel',NULL,'奥廖尔','ORL',NULL),
(586,118,NULL,'Orenburg','orenburg',NULL,'奥伦堡','ORE',NULL),
(587,118,NULL,'Barnaul','barnaul',NULL,'巴尔瑙尔','BAX',NULL),
(588,118,NULL,'Penza','penza',NULL,'奔萨','PNZ',NULL),
(589,118,NULL,'Petropavlovsk-Kamchatskiy','petropavlovsk-kamchatskiy',NULL,'彼得罗巴甫洛夫斯克','PKC',NULL),
(590,118,NULL,'Petrozavodsk','petrozavodsk',NULL,'彼得罗扎沃茨克','PES',NULL),
(591,118,NULL,'Perm','perm',NULL,'彼尔姆','PER',NULL),
(592,118,NULL,'Birobidzan','birobidzan',NULL,'比罗比詹','BBZ',NULL),
(593,118,NULL,'Belgorod','belgorod',NULL,'别尔哥罗德','BEL',NULL),
(594,118,NULL,'Chabarovsk','chabarovsk',NULL,'伯力','COK',NULL),
(595,118,NULL,'Blagoveshchensk','blagoveshchensk',NULL,'布拉戈维申斯克','BQS',NULL),
(596,118,NULL,'Bryansk','bryansk',NULL,'布良斯克','BRY',NULL),
(597,118,NULL,'Chelyabinsk','chelyabinsk',NULL,'车里雅宾斯克','CHE',NULL),
(598,118,NULL,'Chita','chita',NULL,'赤塔','CHI',NULL),
(599,118,NULL,'Rostov-na-Donu','rostov-na-donu',NULL,'顿河畔罗斯托夫','ROS',NULL),
(600,118,NULL,'Omsk','omsk',NULL,'鄂木斯克','OMS',NULL),
(601,118,NULL,'Volgograd','volgograd',NULL,'伏尔加格勒','VOG',NULL),
(602,118,NULL,'Vladimir','vladimir',NULL,'弗拉基米尔','VMR',NULL),
(603,118,NULL,'Vladikavkaz','vladikavkaz',NULL,'弗拉季高加索','VLA',NULL),
(604,118,NULL,'Gorno-Altajsk','gorno-altajsk',NULL,'戈尔诺－阿尔泰斯克','GOA',NULL),
(605,118,NULL,'Grozny','grozny',NULL,'格罗兹尼','GRV',NULL),
(606,118,NULL,'Vladivostok','vladivostok',NULL,'海参崴','VVO',NULL),
(607,118,NULL,'Khanty-Mansiysk','khanty-mansiysk',NULL,'汉特－曼西斯克','KHM',NULL),
(608,118,NULL,'Kirov','kirov',NULL,'基洛夫','KIR',NULL),
(609,118,NULL,'Kaliningrad','kaliningrad',NULL,'加里宁格勒','KGD',NULL),
(610,118,NULL,'Kazan','kazan',NULL,'喀山','KZN',NULL),
(611,118,NULL,'Kaluga','kaluga',NULL,'卡卢加','KLF',NULL),
(612,118,NULL,'Kostroma','kostroma',NULL,'科斯特罗马','KOS',NULL),
(613,118,NULL,'Krasnodar','krasnodar',NULL,'克拉斯诺达尔','KRR',NULL),
(614,118,NULL,'Krasnojarsk','krasnojarsk',NULL,'克拉斯诺亚尔斯克','KYA',NULL),
(615,118,NULL,'Kemerovo','kemerovo',NULL,'克麦罗沃','KEM',NULL),
(616,118,NULL,'Kyzyl','kyzyl',NULL,'克孜勒','KYZ',NULL),
(617,118,NULL,'Kudymkar','kudymkar',NULL,'库德姆卡尔','KUD',NULL),
(618,118,NULL,'Kurgan','kurgan',NULL,'库尔干','KRO',NULL),
(619,118,NULL,'Kursk','kursk',NULL,'库尔斯克','URS',NULL),
(620,118,NULL,'Lipeck','lipeck',NULL,'利佩茨克','LIP',NULL),
(621,118,NULL,'Ryazan','ryazan',NULL,'梁赞','RYA',NULL),
(622,118,NULL,'Makhachkala','makhachkala',NULL,'马哈奇卡拉','MCX',NULL),
(623,118,NULL,'Magadan','magadan',NULL,'马加丹','MAG',NULL),
(624,118,NULL,'Magas','magas',NULL,'马加斯','IN',NULL),
(625,118,NULL,'Maykop','maykop',NULL,'迈科普','MAY',NULL),
(626,118,NULL,'Murmansk','murmansk',NULL,'摩尔曼斯克','MMK',NULL),
(627,118,NULL,'Moscow','moscow',NULL,'莫斯科','MOW',NULL),
(628,118,NULL,'Nalchik','nalchik',NULL,'纳尔奇克','NAL',NULL),
(629,118,NULL,'Naryan-Mar','naryan-mar',NULL,'纳里扬马尔','NNM',NULL),
(630,118,NULL,'Juzno-Sachalinsk','juzno-sachalinsk',NULL,'南萨哈林斯克','JSA',NULL),
(631,118,NULL,'Velikij Novgorod','velikij novgorod',NULL,'诺夫哥罗德','VUS',NULL),
(632,118,NULL,'Palana','palana',NULL,'帕拉纳','PAL',NULL),
(633,118,NULL,'Pskov','pskov',NULL,'普斯科夫','PSK',NULL),
(634,118,NULL,'Cheboksary','cheboksary',NULL,'切博克萨雷','CSY',NULL),
(635,118,NULL,'Cherkessk','cherkessk',NULL,'切尔克斯克','CKS',NULL),
(636,118,NULL,'Tyumen','tyumen',NULL,'秋明','TYU',NULL),
(637,118,NULL,'Saratov','saratov',NULL,'萨拉托夫','SAR',NULL),
(638,118,NULL,'Saransk','saransk',NULL,'萨兰斯克','SKX',NULL),
(639,118,NULL,'Salekhard','salekhard',NULL,'萨列哈尔德','SLY',NULL),
(640,118,NULL,'Samara','samara',NULL,'萨马拉','SAM',NULL),
(641,118,NULL,'Syktyvkar','syktyvkar',NULL,'瑟克特夫卡尔','SCW',NULL),
(642,118,NULL,'St. Peterburg','st. peterburg',NULL,'圣彼得堡','SPE',NULL),
(643,118,NULL,'Smolensk','smolensk',NULL,'斯摩棱斯克','LNX',NULL),
(644,118,NULL,'Stavropol','stavropol',NULL,'斯塔夫罗波尔','STA',NULL),
(645,118,NULL,'Tambov','tambov',NULL,'坦波夫','TAM',NULL),
(646,118,NULL,'Tver','tver',NULL,'特维尔','TVE',NULL),
(647,118,NULL,'Tula','tula',NULL,'图拉','TUL',NULL),
(648,118,NULL,'Tomsk','tomsk',NULL,'托木斯克','TOM',NULL),
(649,118,NULL,'Voronezh','voronezh',NULL,'沃罗涅什','VOR',NULL),
(650,118,NULL,'Vologda','vologda',NULL,'沃洛格达','VLG',NULL),
(651,118,NULL,'Ufa','ufa',NULL,'乌法','UFA',NULL),
(652,118,NULL,'Ulan-Ude','ulan-ude',NULL,'乌兰乌德','UUD',NULL),
(653,118,NULL,'Uljanovsk','uljanovsk',NULL,'乌里扬诺夫斯克','ULY',NULL),
(654,118,NULL,'Ust-Ordynsky','ust-ordynsky',NULL,'乌斯季奥尔登斯基','UOB',NULL),
(655,118,NULL,'Niznij Novgorod','niznij novgorod',NULL,'下诺夫哥罗德','GOJ',NULL),
(656,118,NULL,'Novosibirsk','novosibirsk',NULL,'新西伯利亚','NVS',NULL),
(657,118,NULL,'Jakutsk','jakutsk',NULL,'雅库茨克','JAK',NULL),
(658,118,NULL,'Jaroslavl','jaroslavl',NULL,'雅罗斯拉夫尔','JAR',NULL),
(659,118,NULL,'Jekaterinburg','jekaterinburg',NULL,'叶卡捷林堡','JEK',NULL),
(660,118,NULL,'Irkutsk','irkutsk',NULL,'伊尔库茨克','IKT',NULL),
(661,118,NULL,'Izhevsk','izhevsk',NULL,'伊热夫斯克','IJK',NULL),
(662,118,NULL,'Ivanovo','ivanovo',NULL,'伊万诺沃','IVO',NULL),
(663,118,NULL,'Yoshkar-Ola','yoshkar-ola',NULL,'约什卡尔奥拉','YOL',NULL),
(664,194,NULL,'Azuay','azuay',NULL,'阿苏艾','A',NULL),
(665,194,NULL,'El Oro','el oro',NULL,'埃尔奥罗','O',NULL),
(666,194,NULL,'Esmeraldas','esmeraldas',NULL,'埃斯梅拉尔达斯','E',NULL),
(667,194,NULL,'Bolivar','bolivar',NULL,'玻利瓦尔','B',NULL),
(668,194,NULL,'Guayas','guayas',NULL,'瓜亚斯','G',NULL),
(669,194,NULL,'Galapagos','galapagos',NULL,'加拉帕戈斯','W',NULL),
(670,194,NULL,'Carchi','carchi',NULL,'卡尔奇','C',NULL),
(671,194,NULL,'Canar','canar',NULL,'卡尼亚尔','F',NULL),
(672,194,NULL,'Cotopaxi','cotopaxi',NULL,'科托帕希','X',NULL),
(673,194,NULL,'Loja','loja',NULL,'洛哈','L',NULL),
(674,194,NULL,'Los Rios','los rios',NULL,'洛斯里奥斯','R',NULL),
(675,194,NULL,'Manabi','manabi',NULL,'马纳比','M',NULL),
(676,194,NULL,'Morona-Santiago','morona-santiago',NULL,'莫罗纳－圣地亚哥','S',NULL),
(677,194,NULL,'Napo, Orellana','napo, orellana',NULL,'纳波，奥雷利亚纳','D',NULL),
(678,194,NULL,'Pastaza','pastaza',NULL,'帕斯塔萨','Y',NULL),
(679,194,NULL,'Pichincha','pichincha',NULL,'皮钦查','P',NULL),
(680,194,NULL,'Chimborazo','chimborazo',NULL,'钦博拉索','H',NULL),
(681,194,NULL,'Zamora-Chinchipe','zamora-chinchipe',NULL,'萨莫拉－钦奇佩','Z',NULL),
(682,194,NULL,'Sucumbios','sucumbios',NULL,'苏昆毕奥斯','U',NULL),
(683,194,NULL,'Tungurahua','tungurahua',NULL,'通古拉瓦','T',NULL),
(684,194,NULL,'Imbabura','imbabura',NULL,'因巴布拉','I',NULL),
(685,10,NULL,'Anseba','anseba',NULL,'安塞巴','KE',NULL),
(686,10,NULL,'Semenawi Keyih Bahri','semenawi keyih bahri',NULL,'北红海','SK',NULL),
(687,10,NULL,'Gash Barka','gash barka',NULL,'加什·巴尔卡','BR',NULL),
(688,10,NULL,'Debub','debub',NULL,'南部','DE',NULL),
(689,10,NULL,'Debubawi Keyih Bahri','debubawi keyih bahri',NULL,'南红海','DK',NULL),
(690,10,NULL,'Maekel','maekel',NULL,'中部','MA',NULL),
(691,150,NULL,'Arles','arles',NULL,'阿尔勒','ARL',NULL),
(692,150,NULL,'Ajaccio','ajaccio',NULL,'阿雅克修','AJA',NULL),
(693,150,NULL,'Aix-en-Provence','aix-en-provence',NULL,'艾克斯','QXB',NULL),
(694,150,NULL,'Orleans','orleans',NULL,'奥尔良','ORR',NULL),
(695,150,NULL,'Paris','paris',NULL,'巴黎','PAR',NULL),
(696,150,NULL,'Besancon','besancon',NULL,'贝桑松','BSN',NULL),
(697,150,NULL,'Dijon','dijon',NULL,'第戎','DIJ',NULL),
(698,150,NULL,'Frejus','frejus',NULL,'弗雷瑞斯','FRJ',NULL),
(699,150,NULL,'Caen','caen',NULL,'卡昂','CFR',NULL),
(700,150,NULL,'Rennes','rennes',NULL,'雷恩','RNS',NULL),
(701,150,NULL,'Lyon','lyon',NULL,'里昂','LIO',NULL),
(702,150,NULL,'Lille','lille',NULL,'里尔','LLE',NULL),
(703,150,NULL,'Limoges','limoges',NULL,'利摩日','LIG',NULL),
(704,150,NULL,'Rouen','rouen',NULL,'鲁昂','URO',NULL),
(705,150,NULL,'Marseille','marseille',NULL,'马赛','MRS',NULL),
(706,150,NULL,'Metz','metz',NULL,'梅斯','MZM',NULL),
(707,150,NULL,'Montpellier','montpellier',NULL,'蒙彼利埃','MPL',NULL),
(708,150,NULL,'Nantes','nantes',NULL,'南特','NTE',NULL),
(709,150,NULL,'Nice','nice',NULL,'尼斯','NCE',NULL),
(710,150,NULL,'Chalons-en-Champagne','chalons-en-champagne',NULL,'沙隆','CSM',NULL),
(711,150,NULL,'Toulouse','toulouse',NULL,'图卢兹','TLS',NULL),
(712,150,NULL,'Valence','valence',NULL,'瓦朗斯','VAA',NULL),
(713,150,NULL,'Amiens','amiens',NULL,'亚眠','AMI',NULL),
(714,99,NULL,'Davao','davao',NULL,'达沃','DOR',NULL),
(715,99,NULL,'Caloocan','caloocan',NULL,'卡卢坎','CAO',NULL),
(716,99,NULL,'Manila','manila',NULL,'马尼拉','MNL',NULL),
(717,99,NULL,'Cebu','cebu',NULL,'宿务','CEB',NULL),
(718,162,NULL,'Espoo','espoo',NULL,'埃斯波','ESP',NULL),
(719,162,NULL,'Oulu','oulu',NULL,'奥卢','OLU',NULL),
(720,162,NULL,'Pori','pori',NULL,'波里','POR',NULL),
(721,162,NULL,'Porvoo','porvoo',NULL,'博尔沃','PRV',NULL),
(722,162,NULL,'Hameenlinna','hameenlinna',NULL,'海门林纳','HMY',NULL),
(723,162,NULL,'Helsinki','helsinki',NULL,'赫尔辛基','HEL',NULL),
(724,162,NULL,'Kajaani','kajaani',NULL,'卡亚尼','KAJ',NULL),
(725,162,NULL,'Kokkola','kokkola',NULL,'科科拉','KOK',NULL),
(726,162,NULL,'Kotka','kotka',NULL,'科特卡','KTK',NULL),
(727,162,NULL,'Kuopio','kuopio',NULL,'库奥皮奥','KUO',NULL),
(728,162,NULL,'Lahti','lahti',NULL,'拉赫蒂','LHI',NULL),
(729,162,NULL,'Lappeenranta','lappeenranta',NULL,'拉彭兰塔','LPP',NULL),
(730,162,NULL,'Rovaniemi','rovaniemi',NULL,'罗瓦涅米','RVN',NULL),
(731,162,NULL,'Mariehamn','mariehamn',NULL,'玛丽港','MHQ',NULL),
(732,162,NULL,'Mikkeli','mikkeli',NULL,'米凯利','MIK',NULL),
(733,162,NULL,'Tampere','tampere',NULL,'坦佩雷','TMP',NULL),
(734,162,NULL,'Turku','turku',NULL,'图尔库','TKU',NULL),
(735,162,NULL,'Vaasa','vaasa',NULL,'瓦萨','VAA',NULL),
(736,162,NULL,'Vantaa','vantaa',NULL,'万塔','VAT',NULL),
(737,162,NULL,'Joensuu','joensuu',NULL,'约恩苏','JOE',NULL),
(738,49,NULL,'Paul','paul',NULL,'保尔','PA',NULL),
(739,49,NULL,'Porto Novo','porto novo',NULL,'波多诺伏','PN',NULL),
(740,49,NULL,'Boa Vista','boa vista',NULL,'博阿维斯塔岛','BV',NULL),
(741,49,NULL,'Brava','brava',NULL,'布拉瓦岛','BR',NULL),
(742,49,NULL,'Ribeira Grande','ribeira grande',NULL,'大里贝拉','RG',NULL),
(743,49,NULL,'Fogo','fogo',NULL,'福古岛','FO',NULL),
(744,49,NULL,'Maio','maio',NULL,'马尤岛','MA',NULL),
(745,49,NULL,'Mosteiros','mosteiros',NULL,'莫斯特罗','MO',NULL),
(746,49,NULL,'Praia','praia',NULL,'普拉亚','PR',NULL),
(747,49,NULL,'Sal','sal',NULL,'萨尔岛','SL',NULL),
(748,49,NULL,'Santo Antao','santo antao',NULL,'圣安唐岛','SA',NULL),
(749,49,NULL,'Santiago','santiago',NULL,'圣地亚哥岛','IA',NULL),
(750,49,NULL,'Sao Domingos','sao domingos',NULL,'圣多明戈','SD',NULL),
(751,49,NULL,'Sao Filipe','sao filipe',NULL,'圣菲利普','SF',NULL),
(752,49,NULL,'Santa Catarina','santa catarina',NULL,'圣卡塔琳娜','CA',NULL),
(753,49,NULL,'Santa Cruz','santa cruz',NULL,'圣克鲁斯','CR',NULL),
(754,49,NULL,'Sao Miguel','sao miguel',NULL,'圣米戈尔','SM',NULL),
(755,49,NULL,'Sao Nicolau','sao nicolau',NULL,'圣尼古拉岛','SN',NULL),
(756,49,NULL,'Sao Vicente','sao vicente',NULL,'圣维森特岛','SV',NULL),
(757,49,NULL,'Tarrafal','tarrafal',NULL,'塔拉法尔','TA',NULL),
(758,187,NULL,'Arauca','arauca',NULL,'阿劳卡','ARA',NULL),
(759,187,NULL,'Antioquia','antioquia',NULL,'安提奥基亚','ANT',NULL),
(760,187,NULL,'Norte de Santander','norte de santander',NULL,'北桑坦德','NDS',NULL),
(761,187,NULL,'Bogota','bogota',NULL,'波哥大首都区','BDC',NULL),
(762,187,NULL,'Bolivar','bolivar',NULL,'博利瓦尔','BOL',NULL),
(763,187,NULL,'Boyaca','boyaca',NULL,'博亚卡','BOY',NULL),
(764,187,NULL,'Atlantico','atlantico',NULL,'大西洋','ATL',NULL),
(765,187,NULL,'Guaviare','guaviare',NULL,'瓜维亚雷','GVR',NULL),
(766,187,NULL,'La Guajira','la guajira',NULL,'瓜希拉','GJR',NULL),
(767,187,NULL,'Guainia','guainia',NULL,'瓜伊尼亚','GNA',NULL),
(768,187,NULL,'Quindio','quindio',NULL,'金迪奥','QUI',NULL),
(769,187,NULL,'Caldas','caldas',NULL,'卡尔达斯','CAL',NULL),
(770,187,NULL,'Caqueta','caqueta',NULL,'卡克塔','CAQ',NULL),
(771,187,NULL,'Casanare','casanare',NULL,'卡萨纳雷','CAS',NULL),
(772,187,NULL,'Cauca','cauca',NULL,'考卡','CAU',NULL),
(773,187,NULL,'Valle del Cauca','valle del cauca',NULL,'考卡山谷','VDC',NULL),
(774,187,NULL,'Cordoba','cordoba',NULL,'科尔多巴','COR',NULL),
(775,187,NULL,'Cundinamarca','cundinamarca',NULL,'昆迪纳马卡','CAM',NULL),
(776,187,NULL,'Risaralda','risaralda',NULL,'利萨拉尔达','RIS',NULL),
(777,187,NULL,'Magdalena','magdalena',NULL,'马格达雷那','MAG',NULL),
(778,187,NULL,'Meta','meta',NULL,'梅塔','MET',NULL),
(779,187,NULL,'Narino','narino',NULL,'纳里尼奥','NAR',NULL),
(780,187,NULL,'Putumayo','putumayo',NULL,'普图马约','PUT',NULL),
(781,187,NULL,'Choco','choco',NULL,'乔科','CHO',NULL),
(782,187,NULL,'Cesar','cesar',NULL,'塞萨尔','CES',NULL),
(783,187,NULL,'Santander','santander',NULL,'桑坦德','SAN',NULL),
(784,187,NULL,'San Andres y Providencia','san andres y providencia',NULL,'圣安德烈斯-普罗维登西亚','SAP',NULL),
(785,187,NULL,'Sucre','sucre',NULL,'苏克雷','SUC',NULL),
(786,187,NULL,'Tolima','tolima',NULL,'托利马','TOL',NULL),
(787,187,NULL,'Vichada','vichada',NULL,'维查达','VIC',NULL),
(788,187,NULL,'Vaupes','vaupes',NULL,'沃佩斯','VAU',NULL),
(789,187,NULL,'Huila','huila',NULL,'乌伊拉','HUI',NULL),
(790,187,NULL,'Amazonas','amazonas',NULL,'亚马孙','AMZ',NULL),
(791,103,NULL,'Alajuela','alajuela',NULL,'阿拉胡埃拉','A',NULL),
(792,103,NULL,'Heredia','heredia',NULL,'埃雷迪亚','H',NULL),
(793,103,NULL,'Guanacaste','guanacaste',NULL,'瓜纳卡斯特','G',NULL),
(794,103,NULL,'Cartago','cartago',NULL,'卡塔戈','C',NULL),
(795,103,NULL,'Limon','limon',NULL,'利蒙','L',NULL),
(796,103,NULL,'Puntarenas','puntarenas',NULL,'蓬塔雷纳斯','P',NULL),
(797,103,NULL,'San Jose','san jose',NULL,'圣何塞','SJ',NULL),
(798,104,NULL,'Holguin','holguin',NULL,'奥尔金','11',NULL),
(799,104,NULL,'Pinar del Rio','pinar del rio',NULL,'比那尔德里奥','1',NULL),
(800,104,NULL,'Villa Clara','villa clara',NULL,'比亚克拉拉','5',NULL),
(801,104,NULL,'Granma','granma',NULL,'格拉玛','12',NULL),
(802,104,NULL,'Guantanamo','guantanamo',NULL,'关塔那摩','14',NULL),
(803,104,NULL,'La Habana','la habana',NULL,'哈瓦那','2',NULL),
(804,104,NULL,'Ciudad de la Habana','ciudad de la habana',NULL,'哈瓦那城','3',NULL),
(805,104,NULL,'Camaguey','camaguey',NULL,'卡马圭','9',NULL),
(806,104,NULL,'Las Tunas','las tunas',NULL,'拉斯图纳斯','10',NULL),
(807,104,NULL,'Matanzas','matanzas',NULL,'马坦萨斯','4',NULL),
(808,104,NULL,'Mayari','mayari',NULL,'马亚里','MAY',NULL),
(809,104,NULL,'Manzanillo','manzanillo',NULL,'曼萨尼罗','MZO',NULL),
(810,104,NULL,'Isla de la Juventud','isla de la juventud',NULL,'青年岛特区','99',NULL),
(811,104,NULL,'Santiago de Cuba','santiago de cuba',NULL,'圣地亚哥','13',NULL),
(812,104,NULL,'Sancti Spiritus','sancti spiritus',NULL,'圣斯皮里图斯','7',NULL),
(813,104,NULL,'Cienfuegos','cienfuegos',NULL,'西恩富戈斯','6',NULL),
(814,104,NULL,'Ciego de Avila','ciego de avila',NULL,'谢戈德阿维拉','8',NULL),
(815,188,NULL,'Essequibo Islands-West Demerara','essequibo islands-west demerara',NULL,'埃塞奎博群岛-西德梅拉拉','EW',NULL),
(816,188,NULL,'Barima-Waini','barima-waini',NULL,'巴里马-瓦伊尼','BW',NULL),
(817,188,NULL,'Pomeroon-Supenaam','pomeroon-supenaam',NULL,'波默伦-苏佩纳姆','PM',NULL),
(818,188,NULL,'Potaro-Siparuni','potaro-siparuni',NULL,'波塔罗-锡帕鲁尼','PI',NULL),
(819,188,NULL,'Demerara-Mahaica','demerara-mahaica',NULL,'德梅拉拉-马海卡','DM',NULL),
(820,188,NULL,'East Berbice-Corentyne','east berbice-corentyne',NULL,'东伯比斯-科兰太因','EC',NULL),
(821,188,NULL,'Cuyuni-Mazaruni','cuyuni-mazaruni',NULL,'库尤尼-马扎鲁尼','CM',NULL),
(822,188,NULL,'Mahaica-Berbice','mahaica-berbice',NULL,'马海卡-伯比斯','MB',NULL),
(823,188,NULL,'Upper Demerara-Berbice','upper demerara-berbice',NULL,'上德梅拉拉-伯比斯','UD',NULL),
(824,188,NULL,'Upper Takutu-Upper Essequibo','upper takutu-upper essequibo',NULL,'上塔库图-上埃塞奎博','UT',NULL),
(825,98,NULL,'Arkalyk','arkalyk',NULL,'阿尔卡累克','AYK',NULL),
(826,98,NULL,'Aqmola','aqmola',NULL,'阿克莫拉','AKM',NULL),
(827,98,NULL,'Aksu','aksu',NULL,'阿克苏','AKS',NULL),
(828,98,NULL,'Aqtobe','aqtobe',NULL,'阿克托别','AKT',NULL),
(829,98,NULL,'Almaty','almaty',NULL,'阿拉木图','ALA',NULL),
(830,98,NULL,'Arys','arys',NULL,'阿雷斯','ARY',NULL),
(831,98,NULL,'Astana','astana',NULL,'阿斯塔纳市','AST',NULL),
(832,98,NULL,'Atyrau','atyrau',NULL,'阿特劳','ATY',NULL),
(833,98,NULL,'Ekibastuz','ekibastuz',NULL,'埃基巴斯图兹','EKB',NULL),
(834,98,NULL,'Balkhash','balkhash',NULL,'巴尔喀什','BXH',NULL),
(835,98,NULL,'Pavlodar','pavlodar',NULL,'巴甫洛达尔','PAV',NULL),
(836,98,NULL,'Soltustik Qazaqstan','soltustik qazaqstan',NULL,'北哈萨克斯坦','SEV',NULL),
(837,98,NULL,'Shyghys Qazaqstan','shyghys qazaqstan',NULL,'东哈萨克斯坦','VOS',NULL),
(838,98,NULL,'Zyryanovsk','zyryanovsk',NULL,'济良诺夫斯克','ZYR',NULL),
(839,98,NULL,'Zhambyl','zhambyl',NULL,'江布尔','DMB',NULL),
(840,98,NULL,'Zhezkazgan','zhezkazgan',NULL,'杰兹卡兹甘','DZH',NULL),
(841,98,NULL,'Qaraghandy','qaraghandy',NULL,'卡拉干达','KAR',NULL),
(842,98,NULL,'Karazhal','karazhal',NULL,'卡拉扎尔','KZO',NULL),
(843,98,NULL,'Kapchagay','kapchagay',NULL,'卡普恰盖','KAP',NULL),
(844,98,NULL,'Qostanay','qostanay',NULL,'科斯塔奈','KST',NULL),
(845,98,NULL,'Qyzylorda','qyzylorda',NULL,'克孜勒奥尔达','KZY',NULL),
(846,98,NULL,'Kentau','kentau',NULL,'肯套','KEN',NULL),
(847,98,NULL,'Kurchatov','kurchatov',NULL,'库尔恰托夫','KUR',NULL),
(848,98,NULL,'Lisakovsk','lisakovsk',NULL,'利萨科夫斯克','LKK',NULL),
(849,98,NULL,'Leninogorsk','leninogorsk',NULL,'列宁诺戈尔斯克','LEN',NULL),
(850,98,NULL,'Rudny','rudny',NULL,'鲁德内','RUD',NULL),
(851,98,NULL,'Mangghystau','mangghystau',NULL,'曼格斯套','MAN',NULL),
(852,98,NULL,'Ongtustik Qazaqstan','ongtustik qazaqstan',NULL,'南哈萨克斯坦','KGT',NULL),
(853,98,NULL,'Saran','saran',NULL,'萨兰','SAR',NULL),
(854,98,NULL,'Semey','semey',NULL,'塞梅伊','SEM',NULL),
(855,98,NULL,'Shakhtinsk','shakhtinsk',NULL,'沙赫京斯克','SAK',NULL),
(856,98,NULL,'Stepnogorsk','stepnogorsk',NULL,'斯捷普诺戈尔斯克','STE',NULL),
(857,98,NULL,'Tekeli','tekeli',NULL,'铁克利','TEK',NULL),
(858,98,NULL,'Temirtau','temirtau',NULL,'铁米尔套','TEM',NULL),
(859,98,NULL,'Turkestan','turkestan',NULL,'突厥斯坦','TUR',NULL),
(860,98,NULL,'Batys Qazaqstan','batys qazaqstan',NULL,'西哈萨克斯坦','ZAP',NULL),
(861,98,NULL,'Zhanaozen','zhanaozen',NULL,'扎纳奥津','ZHA',NULL),
(862,141,NULL,'Almere','almere',NULL,'阿尔梅勒','AER',NULL),
(863,141,NULL,'Amersfoort','amersfoort',NULL,'阿默斯福特','AME',NULL),
(864,141,NULL,'Amsterdam','amsterdam',NULL,'阿姆斯特丹','AMS',NULL),
(865,141,NULL,'Arnhem','arnhem',NULL,'阿纳姆','ARN',NULL),
(866,141,NULL,'Apeldoorn','apeldoorn',NULL,'阿珀尔多伦','APE',NULL),
(867,141,NULL,'Assen','assen',NULL,'阿森','ASS',NULL),
(868,141,NULL,'Ede','ede',NULL,'埃德','EDE',NULL),
(869,141,NULL,'Emmen','emmen',NULL,'埃门','EMM',NULL),
(870,141,NULL,'Eindhoven','eindhoven',NULL,'埃因霍芬','EIN',NULL),
(871,141,NULL,'Breda','breda',NULL,'布雷达','BRD',NULL),
(872,141,NULL,'Tilburg','tilburg',NULL,'蒂尔堡','TLB',NULL),
(873,141,NULL,'Dordrecht','dordrecht',NULL,'多德雷赫特','DOR',NULL),
(874,141,NULL,'Enschede','enschede',NULL,'恩斯赫德','ENS',NULL),
(875,141,NULL,'Groningen','groningen',NULL,'格罗宁根','GRQ',NULL),
(876,141,NULL,'Haarlem','haarlem',NULL,'哈勒姆','HRA',NULL),
(877,141,NULL,'Hague','hague',NULL,'海牙','HAG',NULL),
(878,141,NULL,'Hoofddorp','hoofddorp',NULL,'霍夫多尔普','HFD',NULL),
(879,141,NULL,'Leiden','leiden',NULL,'莱顿','LID',NULL),
(880,141,NULL,'Lelystad','lelystad',NULL,'莱利斯塔德','LEY',NULL),
(881,141,NULL,'Rotterdam','rotterdam',NULL,'鹿特丹','RTM',NULL),
(882,141,NULL,'Leeuwarden','leeuwarden',NULL,'吕伐登','LWR',NULL),
(883,141,NULL,'Maastricht','maastricht',NULL,'马斯特里赫特','MST',NULL),
(884,141,NULL,'Middelburg','middelburg',NULL,'米德尔堡','MDL',NULL),
(885,141,NULL,'Nijmegen','nijmegen',NULL,'奈梅亨','NIJ',NULL),
(886,141,NULL,'\'s-Hertogenbosch','\'s-hertogenbosch',NULL,'斯海尔托亨博思','HTB',NULL),
(887,141,NULL,'Utrecht','utrecht',NULL,'乌得勒支','UTC',NULL),
(888,141,NULL,'Zwolle','zwolle',NULL,'兹沃勒','ZWO',NULL),
(889,141,NULL,'Zoetermeer','zoetermeer',NULL,'佐特尔梅','ZTM',NULL),
(890,113,NULL,'Atlantida','atlantida',NULL,'阿特兰蒂达','AT',NULL),
(891,113,NULL,'El Paraiso','el paraiso',NULL,'埃尔帕拉伊索','PA',NULL),
(892,113,NULL,'Ocotepeque','ocotepeque',NULL,'奥科特佩克','OC',NULL),
(893,113,NULL,'Olancho','olancho',NULL,'奥兰乔','OL',NULL),
(894,113,NULL,'Francisco Morazan','francisco morazan',NULL,'弗朗西斯科-莫拉桑','FM',NULL),
(895,113,NULL,'Gracias a Dios','gracias a dios',NULL,'格拉西亚斯-阿迪奥斯','GD',NULL),
(896,113,NULL,'Islas de la Bahia','islas de la bahia',NULL,'海湾群岛','IB',NULL),
(897,113,NULL,'Cortes','cortes',NULL,'科尔特斯','CR',NULL),
(898,113,NULL,'Colon','colon',NULL,'科隆','CL',NULL),
(899,113,NULL,'Comayagua','comayagua',NULL,'科马亚瓜','CM',NULL),
(900,113,NULL,'Copan','copan',NULL,'科潘','CP',NULL),
(901,113,NULL,'La Paz','la paz',NULL,'拉巴斯','PZ',NULL),
(902,113,NULL,'Lempira','lempira',NULL,'伦皮拉','LE',NULL),
(903,113,NULL,'Choluteca','choluteca',NULL,'乔卢特卡','CH',NULL),
(904,113,NULL,'Choloma','choloma',NULL,'乔罗马','CHO',NULL),
(905,113,NULL,'Valle','valle',NULL,'山谷','VA',NULL),
(906,113,NULL,'Santa Barbara','santa barbara',NULL,'圣巴巴拉','SB',NULL),
(907,113,NULL,'Intibuca','intibuca',NULL,'因蒂布卡','IN',NULL),
(908,113,NULL,'Yoro','yoro',NULL,'约罗','YO',NULL),
(909,180,NULL,'Phoenix Islands','phoenix islands',NULL,'菲尼克斯群岛','PHO',NULL),
(910,180,NULL,'Gilberts Islands','gilberts islands',NULL,'吉尔伯特群岛','GIL',NULL),
(911,180,NULL,'Line Islands','line islands',NULL,'莱恩群岛','LIN',NULL),
(912,52,NULL,'Ali Sabih','ali sabih',NULL,'阿里萨比赫区','S',NULL),
(913,52,NULL,'Obock','obock',NULL,'奥博克区','O',NULL),
(914,52,NULL,'Dikhil','dikhil',NULL,'迪基勒区','K',NULL),
(915,52,NULL,'Tadjoura','tadjoura',NULL,'塔朱拉区','T',NULL),
(916,65,NULL,'Osh','osh',NULL,'奥什','O',NULL),
(917,65,NULL,'Batken','batken',NULL,'巴特肯','B',NULL),
(918,65,NULL,'Bishkek','bishkek',NULL,'比什凯克市','GB',NULL),
(919,65,NULL,'Chuy','chuy',NULL,'楚河','C',NULL),
(920,65,NULL,'Jalal-Abad','jalal-abad',NULL,'贾拉拉巴德','J',NULL),
(921,65,NULL,'Karabalta','karabalta',NULL,'卡拉巴尔塔','KBA',NULL),
(922,65,NULL,'Kara-Kol','kara-kol',NULL,'卡拉库尔','KKO',NULL),
(923,65,NULL,'Kant','kant',NULL,'坎特','KAN',NULL),
(924,65,NULL,'Kok-Jangak','kok-jangak',NULL,'科克扬加克','KJ',NULL),
(925,65,NULL,'Mailuu-Suu','mailuu-suu',NULL,'迈利赛','MS',NULL),
(926,65,NULL,'Naryn','naryn',NULL,'纳伦','N',NULL),
(927,65,NULL,'Suluktu','suluktu',NULL,'苏卢克图','SU',NULL),
(928,65,NULL,'Talas','talas',NULL,'塔拉斯','T',NULL),
(929,65,NULL,'Tash-Kumyr','tash-kumyr',NULL,'塔什库梅尔','TK',NULL),
(930,65,NULL,'Uzgen','uzgen',NULL,'乌兹根','UG',NULL),
(931,65,NULL,'Ysyk-Kol','ysyk-kol',NULL,'伊塞克湖','Y',NULL),
(932,15,NULL,'Boke','boke',NULL,'博凯','BOK',NULL),
(933,15,NULL,'Nzerekore','nzerekore',NULL,'恩泽雷科雷','NZR',NULL),
(934,15,NULL,'Faranah','faranah',NULL,'法拉纳','FRN',NULL),
(935,15,NULL,'Kindia','kindia',NULL,'金迪亚','KND',NULL),
(936,15,NULL,'Kankan','kankan',NULL,'康康','KNK',NULL),
(937,15,NULL,'Conakry','conakry',NULL,'科纳克里','CNK',NULL),
(938,15,NULL,'Labe','labe',NULL,'拉贝','LAB',NULL),
(939,15,NULL,'Mamou','mamou',NULL,'玛木','MAM',NULL),
(940,166,NULL,'Abbotsford','abbotsford',NULL,'阿伯茨福','ABB',NULL),
(941,166,NULL,'Edmonton','edmonton',NULL,'埃德蒙顿','EDM',NULL),
(942,166,NULL,'Oshawa','oshawa',NULL,'奥沙瓦','OSH',NULL),
(943,166,NULL,'Barrie','barrie',NULL,'巴里','BAR',NULL),
(944,166,NULL,'Cape Breton','cape breton',NULL,'布列塔尼角','CBR',NULL),
(945,166,NULL,'Toronto','toronto',NULL,'多伦多','TOR',NULL),
(946,166,NULL,'Fredericton','fredericton',NULL,'弗雷德里顿','FRE',NULL),
(947,166,NULL,'Guelph','guelph',NULL,'圭尔夫','GLP',NULL),
(948,166,NULL,'Halifax','halifax',NULL,'哈利法克斯','HAL',NULL),
(949,166,NULL,'Hamilton','hamilton',NULL,'哈密尔顿','HAM',NULL),
(950,166,NULL,'Whitehorse','whitehorse',NULL,'怀特霍斯','YXY',NULL),
(951,166,NULL,'Kelowna','kelowna',NULL,'基劳纳','KWL',NULL),
(952,166,NULL,'Brampton','brampton',NULL,'基奇纳','BRP',NULL),
(953,166,NULL,'Kingston','kingston',NULL,'金斯敦','KGN',NULL),
(954,166,NULL,'Calgary','calgary',NULL,'卡里加里','CAL',NULL),