📄 全国省市数据.txt
字号:
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140601,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140602,'朔城区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140603,'平鲁区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140621,'山阴县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140622,'应 县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140623,'右玉县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140624,'怀仁县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140700,'晋中市','354')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140701,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140702,'榆次区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140721,'榆社县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140722,'左权县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140723,'和顺县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140724,'昔阳县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140725,'寿阳县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140726,'太谷县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140727,'祁 县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140728,'平遥县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140729,'灵石县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140781,'介休市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140800,'运城市','359')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140801,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140802,'盐湖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140821,'临猗县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140822,'万荣县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140823,'闻喜县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140824,'稷山县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140825,'新绛县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140826,'绛 县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140827,'垣曲县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140828,'夏 县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140829,'平陆县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140830,'芮城县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140881,'永济市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140882,'河津市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140900,'忻州市','350')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140901,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140902,'忻府区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140921,'定襄县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140922,'五台县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140923,'代 县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140924,'繁峙县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140925,'宁武县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140926,'静乐县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140927,'神池县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140928,'五寨县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140929,'岢岚县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140930,'河曲县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140931,'保德县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140932,'偏关县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (140981,'原平市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141000,'临汾市','357')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141001,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141002,'尧都区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141021,'曲沃县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141022,'翼城县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141023,'襄汾县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141024,'洪洞县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141025,'古 县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141026,'安泽县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141027,'浮山县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141028,'吉 县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141029,'乡宁县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141030,'大宁县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141031,'隰 县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141032,'永和县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141033,'蒲 县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141034,'汾西县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141081,'侯马市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (141082,'霍州市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142300,'吕梁地区','358')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142301,'孝义市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142302,'离石市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142303,'汾阳市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142322,'文水县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142323,'交城县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142325,'兴 县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142326,'临 县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142327,'柳林县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142328,'石楼县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142329,'岚 县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142330,'方山县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142332,'中阳县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (142333,'交口县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150000,'内蒙古自治区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150100,'呼和浩特市','471')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150101,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150102,'新城区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150103,'回民区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150104,'玉泉区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150105,'赛罕区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150121,'土默特左旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150122,'托克托县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150123,'和林格尔县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150124,'清水河县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150125,'武川县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150200,'包头市','472')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150201,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150202,'东河区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150203,'昆都仑区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150204,'青山区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150205,'石拐区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150206,'白云矿区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150207,'九原区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150221,'土默特右旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150222,'固阳县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150223,'达尔罕茂明安联合旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150300,'乌海市','473')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150301,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150302,'海勃湾区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150303,'海南区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150304,'乌达区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150400,'赤峰市','476')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150401,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150402,'红山区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150403,'元宝山区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150404,'松山区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150421,'阿鲁科尔沁旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150422,'巴林左旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150423,'巴林右旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150424,'林西县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150425,'克什克腾旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150426,'翁牛特旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150428,'喀喇沁旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150429,'宁城县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150430,'敖汉旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150500,'通辽市','475')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150501,'市辖区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150502,'科尔沁区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150521,'科尔沁左翼中旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150522,'科尔沁左翼后旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150523,'开鲁县',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150524,'库伦旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150525,'奈曼旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150526,'扎鲁特旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150581,'霍林郭勒市',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150600,'鄂尔多斯市','477')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150602,'东胜区',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150621,'达拉特旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150622,'准格尔旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150623,'鄂托克前旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150624,'鄂托克旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150625,'杭锦旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150626,'乌审旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150627,'伊金霍洛旗',NULL)
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150700,'呼伦贝尔市','470')
INSERT INTO [T_Area] ([sz_code],[name],[sz_AreaCode]) values (150701,'市辖区',NULL)
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -