全国行政分区明细表（省市区比较2010年左右）（第二部分）

接上回：

--浙江省
insert into Area values('杭州市','310000',88),('上城区','310000',88),('下城区','310000',88),('江干区','310000',88),('拱墅区','310000',88),('西湖区','310000',88),('滨江区','310000',88),('萧山区','311200',88),('余杭区','311100',88),('桐庐县','311500',88),('淳安县','311700',88),('建德市','311600',88),('富阳市','311400',88),('临安市','311300',88)
insert into Area values('宁波市','315000',89),('海曙区','315000',89),('江东区','315000',89),('江北区','315000',89),('北仑区','315800',89),('镇海区','315200',89),('鄞州区','315100',89),('象山县','315700',89),('宁海县','315600',89),('余姚市','315400',89),('慈溪市','315300',89),('奉化市','315500',89)
insert into Area values('温州市','325000',90),('鹿城区','325000',90),('龙湾区','325000',90),('瓯海区','325000',90),('洞头县','325700',90),('永嘉县','325100',90),('平阳县','325400',90),('苍南县','325800',90),('文成县','325300',90),('泰顺县','325500',90),('瑞安市','325200',90),('乐清市','325600',90)
insert into Area values('嘉兴市','314000',91),('秀城区','314000',91),('嘉善县','314100',91),('海盐县','314300',91),('海宁市','314400',91),('平湖市','314200',91),('桐乡市','314500',91)
insert into Area values('湖州市','313000',92),('吴兴区','313000',92),('南浔区','313000',92),('德清县','313200',92),('长兴县','313100',92),('安吉县','313300',92)
insert into Area values('绍兴市','312000',93),('越城区','312000',93),('绍兴县','312000',93),('新昌县','312500',93),('诸暨市','311800',93),('上虞市','312300',93),('嵊州市','312400',93)
insert into Area values('金华市','321000',94),('婺城区','321000',94),('金东区','321000',94),('武义县','321200',94),('浦江县','322200',94),('磐安县','322300',94),('兰溪市','321100',94),('义乌市','322000',94),('东阳市','322100',94),('永康市','321300',94)
insert into Area values('衢州市','324000',95),('柯城区','324000',95),('衢江区','324000',95),('常山县','324200',95),('开化县','324300',95),('龙游县','324400',95),('江山市','324100',95)
insert into Area values('舟山市','316000',96),('定海区','316000',96),('普陀区','316100',96),('岱山县','316200',96),('嵊泗县','202450',96)
insert into Area values('台州市','318000',97),('椒江区','317700',97),('黄岩区','318020',97),('路桥区','318000',97),('玉环县','317600',97),('三门县','317100',97),('天台县','317200',97),('仙居县','317300',97),('温岭市','317500',97),('临海市','317000',97)
insert into Area values('丽水市','323000',98),('莲都区','323000',98),('青田县','323900',98),('缙云县','321400',98),('遂昌县','323300',98),('松阳县','323400',98),('云和县','323600',98),('庆元县','323800',98),('景宁畲族自治县','323500',98),('龙泉市','323700',98)
--安徽省
insert into Area values('合肥市','230000',99),('长丰县','231100',99),('肥东县','230000',99),('肥西县','231200',99)
insert into Area values('芜湖市','241000',100),('镜湖区','241000',100),('马塘区','241000',100),('新芜区','241000',100),('鸠江区','241000',100),('芜湖县','241100',100),('繁昌县','241200',100),('南陵县','242400',100)
insert into Area values('蚌埠市','233000',101),('东市区','233000',101),('中市区','233000',101),('西市区','233000',101),('郊区','233000',101),('怀远县','233400',101),('五河县','233300',101),('固镇县','233700',101)
insert into Area values('淮南市','232000',102),('大通区','232000',102),('田家庵区','232000',102),('谢家集区','232000',102),('八公山区','232000',102),('潘集区','232000',102),('凤台县','232100',102)
insert into Area values('马鞍山市','243000',103),('金家庄区','243000',103),('花山区','243000',103),('雨山区','243000',103),('当涂县','243100',103)
insert into Area values('淮北市','235000',104),('杜集区','235000',104),('相山区','235000',104),('烈山区','235000',104),('濉溪县','235100',104)
insert into Area values('铜陵市','244000',105),('铜官山区','244000',105),('狮子山区','244000',105),('郊区','244000',105),('铜陵县','244100',105)
insert into Area values('安庆市','246000',106),('迎江区','246000',106),('大观区','246000',106),('郊区','246000',106),('怀宁县','246100',106),('枞阳县','246700',106),('潜山县','246300',106),('太湖县','246400',106),('宿松县','246500',106),('望江县','246200',106),('岳西县','246600',106),('桐城市','231400',106)
insert into Area values('黄山市','245000',107),('屯溪区','245000',107),('黄山区','245000',107),('徽州区','245000',107),('歙县','245200',107),('休宁县','245400',107),('黟县','245500',107),('祁门县','245600',107)
insert into Area values('滁州市','239000',108),('琅琊区','239000',108),('南谯区','239000',108),('来安县','239200',108),('全椒县','239500',108),('定远县','233200',108),('凤阳县','233100',108),('天长市','239300',108),('明光市','239400',108),('颍州区','239000',108),('颍东区','239000',108),('颍泉区','239000',108),('临泉县','236400',108),('太和县','236600',108),('阜南县','236300',108),('颍上县','236200',108),('界首市','236500',108)
insert into Area values('阜阳市','236000',109),('颍州区','236000',109),('颍泉区','236000',109),('颍东区','236000',109),('颍上县','236200',109),('阜南县','236300',109),('临泉县','236400',109),('界首市','236500',109),('太和县','236600',109)
insert into Area values('宿州市','234000',110),('墉桥区','234000',110),('砀山县','235300',110),('萧县','235200',110),('灵璧县','234200',110),('泗县','234300',110)
insert into Area values('巢湖市','238000',111),('居巢区','238000',111),('庐江县','231500',111),('无为县','238300',111),('含山县','238100',111),('和县','238200',111)
insert into Area values('六安市','237000',112),('金安区','237000',112),('裕安区','237000',112),('寿县','232200',112),('霍邱县','237400',112),('舒城县','231300',112),('金寨县','237300',112),('霍山县','237200',112)
insert into Area values('亳州市','236000',113),('谯城区','236800',113),('涡阳县','233600',113),('蒙城县','233500',113),('利辛县','236700',113)
insert into Area values('池州市','247100',114),('贵池区','247100',114),('东至县','247200',114),('石台县','245100',114),('青阳县','242800',114)
insert into Area values('宣城市','242000',115),('宣州区','242000',115),('郎溪县','242100',115),('广德县','242200',115),('泾县','242500',115),('绩溪县','245300',115),('旌德县','242600',115),('宁国市','242300',115)
--福建省
insert into Area values('福州市','350000',116),('鼓楼区','350000',116),('台江区','350000',116),('仓山区','350000',116),('马尾区','350000',116),('晋安区','350000',116),('闽侯县','350100',116),('连江县','350500',116),('罗源县','350600',116),('闽清县','350800',116),('永泰县','350700',116),('平潭县','350400',116),('福清市','350300',116),('长乐市','350200',116)
insert into Area values('厦门市','361000',117),('思明区','361000',117),('海沧区','361000',117),('湖里区','361000',117),('集美区','361000',117),('同安区','361100',117),('翔安区','361100',117),('厦门市','361000',117),('思明区','361000',117),('海沧区','361000',117),('湖里区','361000',117),('集美区','361000',117),('同安区','361100',117),('翔安区','361100',117)
insert into Area values('莆田市','351100',118),('城厢区','351100',118),('涵江区','351100',118),('荔城区','351100',118),('秀屿区','351100',118),('仙游县','351200',118)
insert into Area values('三明市','365000',119),('梅列区','365000',119),('三元区','365000',119),('明溪县','365300',119),('清流县','365300',119),('宁化县','365400',119),('大田县','366100',119),('尤溪县','365100',119),('沙县','365500',119),('将乐县','353300',119),('泰宁县','354400',119),('建宁县','354500',119),('永安市','366000',119)
insert into Area values('泉州市','362000',120),('鲤城区','362000',120),('丰泽区','362000',120),('洛江区','362000',120),('泉港区','362100',120),('惠安县','362100',120),('安溪县','362400',120),('永春县','362600',120),('德化县','362500',120),('金门县','362000',120),('石狮市','362700',120),('晋江市','362200',120),('南安市','362300',120)
insert into Area values('漳州市','363000',121),('芗城区','363000',121),('龙文区','363000',121),('云霄县','363300',121),('漳浦县','363200',121),('诏安县','363500',121),('长泰县','363900',121),('东山县','363400',121),('南靖县','363600',121),('平和县','363700',121),('华安县','363800',121),('龙海市','363100',121)
insert into Area values('南平市','353000',122),('延平区','353000',122),('顺昌县','353200',122),('浦城县','353400',122),('光泽县','354100',122),('松溪县','353500',122),('政和县','353600',122),('邵武市','354000',122),('武夷山市','354300',122),('建瓯市','353100',122),('建阳市','354200',122)
insert into Area values('龙岩市','364000',123),('新罗区','364000',123),('长汀县','366300',123),('永定县','364100',123),('上杭县','364200',123),('武平县','364300',123),('连城县','366200',123),('漳平市','364400',123)
insert into Area values('宁德市','352000',124),('蕉城区','352000',124),('霞浦县','355100',124),('古田县','352200',124),('屏南县','352300',124),('寿宁县','355500',124),('周宁县','355400',124),('柘荣县','355300',124),('福安市','355000',124),('福鼎市','355200',124)
--江西省
insert into Area values('南昌市','330000',125),('东湖区','330000',125),('西湖区','330000',125),('青云谱区','330000',125),('湾里区','330000',125),('南昌县','330200',125),('新建县','330100',125),('安义县','330500',125),('进贤县','331700',125)
insert into Area values('景德镇市','333000',126),('昌江区','333000',126),('珠山区','333000',126),('浮梁县','333400',126),('乐平市','333300',126)
insert into Area values('萍乡市','337000',127),('安源区','337000',127),('湘东区','337000',127),('莲花县','337100',127),('上栗县','337000',127),('芦溪县','337000',127)
insert into Area values('九江市','332000',128),('庐山区','332900',128),('浔阳区','332000',128),('九江县','332100',128),('武宁县','332300',128),('修水县','332400',128),('永修县','330300',128),('德安县','330400',128),('星子县','332800',128),('都昌县','332600',128),('湖口县','332500',128),('彭泽县','332700',128),('瑞昌市','332200',128)
insert into Area values('新余市','336500',129),('渝水区','336500',129),('分宜县','336600',129)
insert into Area values('鹰潭市','335000',130),('月湖区','335000',130),('余江县','335200',130),('贵溪市','335400',130)
insert into Area values('赣州市','341000',131),('章贡区','341000',131),('赣县','341100',131),('信丰县','341600',131),('大余县','341500',131),('上犹县','341200',131),('崇义县','341300',131),('安远县','342100',131),('龙南县','341700',131),('定南县','341900',131),('全南县','341800',131),('宁都县','342800',131),('于都县','342300',131),('兴国县','342400',131),('会昌县','342600',131),('寻乌县','342200',131),('石城县','342700',131),('瑞金市','342500',131),('南康市','341400',131)
insert into Area values('吉安市','343000',132),('吉州区','343000',132),('青原区','343000',132),('吉安县','343100',132),('吉水县','331600',132),('峡江县','331400',132),('新干县','331300',132),('永丰县','331500',132),('泰和县','343700',132),('遂川县','343900',132),('万安县','343800',132),('安福县','343200',132),('永新县','343400',132),('井冈山市','343600',132)
insert into Area values('宜春市','336000',133),('袁州区','336000',133),('奉新县','330700',133),('万载县','336100',133),('上高县','336400',133),('宜丰县','336300',133),('靖安县','330600',133),('铜鼓县','336200',133),('丰城市','331100',133),('樟树市','331200',133),('高安市','330800',133)
insert into Area values('抚州市','344000',134),('临川区','344100',134),('南城县','344700',134),('黎川县','344600',134),('南丰县','344500',134),('崇仁县','344200',134),('乐安县','344300',134),('宜黄县','344400',134),('金溪县','344800',134),('资溪县','335300',134),('东乡县','331800',134),('广昌县','344900',134)
insert into Area values('上饶市','334000',135),('信州区','334000',135),('上饶县','334100',135),('广丰县','334600',135),('玉山县','334700',135),('铅山县','334500',135),('横峰县','334300',135),('弋阳县','334400',135),('余干县','335100',135),('鄱阳县','333100',135),('万年县','335500',135),('婺源县','333200',135),('德兴市','334200',135)
--山东省
insert into Area values('济南市','250000',136),('历下区','250000',136),('市中区','250000',136),('槐荫区','250000',136),('天桥区','250000',136),('历城区','250100',136),('长清区','250300',136),('平阴县','250400',136),('济阳县','251400',136),('商河县','251600',136),('章丘市','250200',136)
insert into Area values('青岛市','266000',137),('市南区','266000',137),('市北区','266000',137),('四方区','266000',137),('黄岛区','266000',137),('崂山区','266100',137),('李沧区','266000',137),('城阳区','266000',137),('胶州市','266300',137),('即墨市','266200',137),('平度市','266700',137),('胶南市','266400',137),('莱西市','266600',137)
insert into Area values('淄博市','255000',138),('淄川区','255100',138),('张店区','255000',138),('博山区','255200',138),('临淄区','255400',138),('周村区','255300',138),('桓台县','256400',138),('高青县','256300',138),('沂源县','256100',138)
insert into Area values('枣庄市','277000',139),('市中区','277000',139),('薛城区','277000',139),('峄城区','277300',139),('台儿庄区','277400',139),('山亭区','277200',139),('滕州市','277500',139)
insert into Area values('东营市','257000',140),('东营区','257100',140),('河口区','257200',140),('垦利县','257500',140),('利津县','257400',140),('广饶县','257300',140)
insert into Area values('烟台市','264000',141),('芝罘区','264000',141),('福山区','265500',141),('牟平区','264100',141),('莱山区','264000',141),('长岛县','265800',141),('龙口市','265700',141),('莱阳市','265200',141),('莱州市','261400',141),('蓬莱市','265600',141),('招远市','265400',141),('栖霞市','265300',141),('海阳市','265100',141)
insert into Area values('潍坊市','261000',142),('潍城区','261000',142),('寒亭区','261100',142),('坊子区','261200',142),('奎文区','261000',142),('临朐县','262600',142),('昌乐县','262400',142),('青州市','262500',142),('诸城市','262200',142),('寿光市','262700',142),('安丘市','262100',142),('高密市','261500',142),('昌邑市','261300',142)
insert into Area values('济宁市','272000',143),('市中区','272000',143),('任城区','272000',143),('微山县','277600',143),('鱼台县','272300',143),('金乡县','272200',143),('嘉祥县','272400',143),('汶上县','272500',143),('泗水县','273200',143),('梁山县','272600',143),('曲阜市','273100',143),('兖州市','272000',143),('邹城市','273500',143)
insert into Area values('泰安市','271000',144),('泰山区','271000',144),('岱岳区','271000',144),('宁阳县','271400',144),('东平县','271500',144),('新泰市','271200',144),('肥城市','271600',144)
insert into Area values('威海市','264200',145),('环翠区','264200',145),('文登市','264400',145),('荣成市','264300',145),('乳山市','264500',145)
insert into Area values('日照市','276800',146),('东港区','276800',146),('五莲县','262300',146),('莒县','276500',146)
insert into Area values('莱芜市','271100',147),('莱城区','271100',147),('钢城区','271100',147)
insert into Area values('临沂市','276000',148),('兰山区','276000',148),('罗庄区','276000',148),('河东区','276000',148),('沂南县','276300',148),('郯城县','276100',148),('沂水县','276400',148),('苍山县','277700',148),('费县','273400',148),('平邑县','273300',148),('莒南县','276600',148),('蒙阴县','276200',148),('临沭县','276700',148)
insert into Area values('德州市','253000',149),('德城区','253000',149),('陵县','253500',149),('宁津县','253400',149),('庆云县','253700',149),('临邑县','251500',149),('齐河县','251100',149),('平原县','253100',149),('夏津县','253200',149),('武城县','253300',149),('乐陵市','253600',149),('禹城市','251200',149)
insert into Area values('聊城市','252000',150),('东昌府区','252000',150),('阳谷县','252300',150),('莘县','252400',150),('茌平县','252100',150),('东阿县','252200',150),('冠县','252500',150),('高唐县','252800',150),('临清市','252600',150)
insert into Area values('滨州市','256600',151),('滨城区','256600',151),('惠民县','251700',151),('阳信县','251800',151),('无棣县','251900',151),('沾化县','256800',151),('博兴县','256500',151),('邹平县','256200',151)
insert into Area values('荷泽市','274000',152),('牡丹区','274000',152),('曹县','274400',152),('单县','274300',152),('成武县','274200',152),('巨野县','274900',152),('郓城县','274700',152),('鄄城县','274600',152),('定陶县','274100',152),('东明县','274500',152)
--河南省
insert into Area values('郑州市','450000',153),('中原区','450000',153),('二七区','450000',153),('管城回族区','450000',153),('金水区','450000',153),('上街区','450041',153),('邙山区','450000',153),('中牟县','451450',153),('巩义市','452100',153),('荥阳市','450100',153),('新密市','452370',153),('新郑市','451100',153),('登封市','452470',153)
insert into Area values('开封市','475000',154),('龙亭区','475000',154),('顺河回族区','475000',154),('鼓楼区','475000',154),('南关区','475000',154),('郊区','475000',154),('杞县','475200',154),('通许县','452200',154),('尉氏县','452100',154),('开封县','475100',154),('兰考县','475300',154)
insert into Area values('洛阳市','471000',155),('老城区','471000',155),('西工区','471000',155),('廛河回族区','471000',155),('涧西区','471000',155),('吉利区','471000',155),('洛龙区','471000',155),('孟津县','471100',155),('新安县','471800',155),('栾川县','471500',155),('嵩县','471400',155),('汝阳县','471200',155),('宜阳县','471600',155),('洛宁县','471700',155),('伊川县','471300',155),('偃师市','471900',155)
insert into Area values('平顶山市','467000',156),('新华区','467000',156),('卫东区','467000',156),('石龙区','467000',156),('湛河区','467000',156),('宝丰县','467400',156),('叶县','467200',156),('鲁山县','467300',156),('郏县','467100',156),('舞钢市','462500',156),('汝州市','467500',156)
insert into Area values('安阳市','455000',157),('文峰区','455000',157),('北关区','455000',157),('殷都区','455000',157),('龙安区','455000',157),('安阳县','455100',157),('汤阴县','456150',157),('滑县','456400',157),('内黄县','456300',157),('林州市','456500',157)
insert into Area values('鹤壁市','458000',158),('鹤山区','458000',158),('山城区','458000',158),('淇滨区','458000',158),('浚县','456250',158),('淇县','456750',158)
insert into Area values('新乡市','453000',159),('红旗区','453000',159),('新乡县','453700',159),('获嘉县','453800',159),('原阳县','453500',159),('延津县','453200',159),('封丘县','453300',159),('长垣县','453400',159),('卫辉市','453100',159),('辉县市','453600',159)
insert into Area values('焦作市','454150',160),('解放区','454150',160),('中站区','454150',160),('马村区','454150',160),('山阳区','454150',160),('修武县','454350',160),('博爱县','454450',160),('武陟县','454950',160),('温县','454850',160),('济源市','454650',160),('沁阳市','454550',160),('孟州市','454750',160)
insert into Area values('濮阳市','457000',161),('清丰县','457300',161),('南乐县','457400',161),('范县','457500',161),('台前县','457600',161),('濮阳县','457100',161)
insert into Area values('许昌市','461000',162),('魏都区','461000',162),('许昌县','461100',162),('鄢陵县','461200',162),('襄城县','452670',162),('禹州市','452570',162),('长葛市','461500',162)
insert into Area values('漯河市','462000',163),('源汇区','462000',163),('舞阳县','462400',163),('临颍县','462600',163),('郾城县','462300',163)
insert into Area values('三门峡市','472000',164),('湖滨区','472000',164),('渑池县','472400',164),('陕县','472100',164),('卢氏县','472200',164),('义马市','472300',164),('灵宝市','472500',164)
insert into Area values('南阳市','473000',165),('宛城区','473000',165),('卧龙区','473000',165),('南召县','474650',165),('方城县','473200',165),('西峡县','474550',165),('镇平县','474250',165),('内乡县','474350',165),('淅川县','474450',165),('社旗县','473300',165),('唐河县','473400',165),('新野县','473500',165),('桐柏县','474750',165),('邓州市','474150',165)
insert into Area values('商丘市','476000',166),('梁园区','476000',166),('睢阳区','476000',166),('民权县','476800',166),('睢县','476900',166),('宁陵县','476700',166),('柘城县','476200',166),('虞城县','476300',166),('夏邑县','476400',166),('永城市','476600',166)
insert into Area values('信阳市','464000',167),('师河区','464000',167),('平桥区','464000',167),('罗山县','464200',167),('光山县','465450',167),('新县','465500',167),('商城县','465350',167),('固始县','465200',167),('潢川县','465150',167),('淮滨县','464400',167),('息县','464300',167)
insert into Area values('周口市','466000',168),('川汇区','466000',168),('扶沟县','461300',168),('西华县','466600',168),('商水县','466100',168),('沈丘县','466300',168),('郸城县','477150',168),('淮阳县','466700',168),('太康县','475400',168),('鹿邑县','477200',168),('项城市','466200',168)
insert into Area values('驻马店市','463000',169),('驿城区','463000',169),('西平县','463900',169),('上蔡县','463800',169),('平舆县','463400',169),('正阳县','463600',169),('确山县','463200',169),('泌阳县','463700',169),('汝南县','463300',169),('遂平县','463100',169),('新蔡县','463500',169)
--湖北省
insert into Area values('武汉市','430000',170),('江岸区','430014',170),('江汉区','430000',170),('乔口区','430000',170),('汉阳区','430050',170),('武昌区','430000',170),('青山区','430080',170),('洪山区','430070',170),('东西湖区','430040',170),('汉南区','430090',170),('蔡甸区','430100',170),('江夏区','430200',170),('黄陂区','432200',170),('新洲区','431400',170)
insert into Area values('黄石市','435000',171),('黄石港区','435000',171),('下陆区','435000',171),('铁山区','435000',171),('阳新县','435200',171),('大冶市','435100',171)
insert into Area values('十堰市','442000',172),('茅箭区','442000',172),('张湾区','442000',172),('郧县','442500',172),('郧西县','442600',172),('竹山县','442200',172),('竹溪县','442300',172),('房县','442100',172),('丹江口市','442700',172)
insert into Area values('宜昌市','443000',173),('西陵区','443000',173),('伍家岗区','443000',173),('点军区','443000',173),('虎亭区','443000',173),('夷陵区','443100',173),('远安县','444200',173),('兴山县','443700',173),('秭归县','443600',173),('长阳土家族自治县','443500',173),('五峰土家族自治县','443400',173),('宜都市','443000',173),('当阳市','444100',173),('枝江市','443200',173)
insert into Area values('襄樊市','441000',174),('襄城区','441000',174),('樊城区','441000',174),('襄阳区','441100',174),('南漳县','441500',174),('谷城县','441700',174),('保康县','441600',174),('老河口市','441800',174),('枣阳市','441200',174),('宜城市','441400',174)
insert into Area values('鄂州市','436000',175),('梁子湖区','436000',175),('华容区','436000',175),('鄂城区','436000',175)
insert into Area values('荆门市','448000',176),('东宝区','448000',176),('掇刀区','448000',176),('京山县','431800',176),('沙洋县','448200',176),('钟祥市','431900',176)
insert into Area values('孝感市','432000',177),('孝南区','432100',177),('孝昌县','432900',177),('大悟县','432800',177),('云梦县','432500',177),('应城市','432400',177),('安陆市','432600',177),('汉川市','432300',177)
insert into Area values('荆州市','434000',178),('沙市区','434000',178),('荆州区','434020',178),('公安县','434300',178),('监利县','433300',178),('江陵县','434100',178),('石首市','434400',178),('洪湖市','433200',178),('松滋市','434200',178)
insert into Area values('黄冈市','438000',179),('黄州区','438000',179),('团风县','438000',179),('红安县','438400',179),('罗田县','438600',179),('英山县','438700',179),('浠水县','438200',179),('蕲春县','435300',179),('黄梅县','435500',179),('麻城市','438300',179),('武穴市','435400',179)
insert into Area values('咸宁市','437000',180),('咸安区','437000',180),('嘉鱼县','437200',180),('通城县','437400',180),('崇阳县','437500',180),('通山县','437600',180),('赤壁市','437300',180)
insert into Area values('随州市','441300',181),('曾都区','441300',181),('广水市','432700',181)
insert into Area values('恩施土家族苗族自治州','445000',182),('恩施市','445000',182),('利川市','445400',182),('建始县','445300',182),('巴东县','444300',182),('宣恩县','445500',182),('咸丰县','445600',182),('来凤县','445700',182),('鹤峰县','445800',182)
insert into Area values('仙桃市','433000',183),('潜江市','433100',183),('天门市','431700',183),('神农架林区','442400',183)
--湖南省
insert into Area values('长沙市','410000',184),('芙蓉区','410000',184),('天心区','410000',184),('岳麓区','410000',184),('开福区','410000',184),('雨花区','410000',184),('长沙县','410100',184),('望城县','410200',184),('宁乡县','410600',184),('浏阳市','410300',184)
insert into Area values('株洲市','412000',185),('荷塘区','412000',185),('芦淞区','412000',185),('石峰区','412000',185),('天元区','412000',185),('株洲县','412000',185),('攸县','412300',185),('茶陵县','412400',185),('炎陵县','412500',185),('醴陵市','412200',185)
insert into Area values('湘潭市','411100',186),('雨湖区','411100',186),('岳塘区','411100',186),('湘潭县','411200',186),('湘乡市','411400',186),('韶山市','411300',186)
insert into Area values('衡阳市','421000',187),('珠晖区','421000',187),('雁峰区','421000',187),('石鼓区','421000',187),('蒸湘区','421000',187),('南岳区','421000',187),('衡阳县','421200',187),('衡南县','421100',187),('衡山县','421300',187),('衡东县','421400',187),('祁东县','421600',187),('耒阳市','421800',187),('常宁市','421500',187)
insert into Area values('邵阳市','422000',188),('双清区','422000',188),('大祥区','422000',188),('北塔区','422000',188),('邵东县','422800',188),('新邵县','422900',188),('邵阳县','422100',188),('隆回县','422200',188),('洞口县','422300',188),('绥宁县','422600',188),('新宁县','422700',188),('城步苗族自治县','422500',188),('武冈市','422400',188)
insert into Area values('岳阳市','414000',189),('岳阳楼区','414000',189),('云溪区','414000',189),('君山区','414000',189),('岳阳县','414100',189),('华容县','414200',189),('湘阴县','410500',189),('平江县','410400',189),('汨罗市','414400',189),('临湘市','414300',189)
insert into Area values('常德市','415000',190),('武陵区','415000',190),('鼎城区','415100',190),('安乡县','415600',190),('汉寿县','415900',190),('澧县','415500',190),('临澧县','415200',190),('桃源县','415700',190),('石门县','415300',190),('津市市','415400',190)
insert into Area values('张家界市','427000',191),('永定区','427000',191),('武陵源区','427400',191),('慈利县','427200',191),('桑植县','427100',191)
insert into Area values('益阳市','413000',192),('资阳区','413000',192),('赫山区','413000',192),('南县','413200',192),('桃江县','413400',192),('安化县','413500',192),('沅江市','413100',192)
insert into Area values('郴州市','423000',193),('北湖区','423000',193),('苏仙区','423000',193),('桂阳县','424400',193),('宜章县','424200',193),('永兴县','423300',193),('嘉禾县','424500',193),('临武县','424300',193),('汝城县','424100',193),('桂东县','423500',193),('安仁县','423600',193),('资兴市','423400',193)
insert into Area values('永州市','425000',194),('芝山区','425000',194),('冷水滩区','425000',194),('祁阳县','421700',194),('东安县','425900',194),('双牌县','425200',194),('道县','425300',194),('江永县','425400',194),('宁远县','425600',194),('蓝山县','425800',194),('新田县','425700',194),('江华瑶族自治县','425500',194)
insert into Area values('怀化市','418000',195),('鹤城区','418000',195),('中方县','418000',195),('沅陵县','419600',195),('辰溪县','419500',195),('溆浦县','419300',195),('会同县','418300',195),('麻阳苗族自治县','419400',195),('新晃侗族自治县','419200',195),('芷江侗族自治县','419100',195),('靖州苗族侗族自治县','418400',195),('通道侗族自治县','418500',195),('洪江市','418200',195)
insert into Area values('娄底市','417000',196),('娄星区','417000',196),('双峰县','417700',196),('新化县','417600',196),('冷水江市','417500',196),('涟源市','417100',196)
insert into Area values('湘西土家族苗族自治州','416000',197),('吉首市','416000',197),('泸溪县','416100',197),('凤凰县','416200',197),('花垣县','416400',197),('保靖县','416500',197),('古丈县','416300',197),('永顺县','416700',197),('龙山县','416800',197)
--广东省
insert into Area values('广州市','510000',198),('东山区','510000',198),('荔湾区','510000',198),('越秀区','510000',198),('海珠区','510000',198),('天河区','510000',198),('芳村区','510000',198),('白云区','510000',198),('黄埔区','510700',198),('番禺区','511400',198),('花都区','510800',198),('增城市','511300',198),('从化市','510900',198)
insert into Area values('韶关市','512000',199),('北江区','512000',199),('武江区','512000',199),('浈江区','512000',199),('曲江县','512100',199),('始兴县','512500',199),('仁化县','512300',199),('翁源县','512600',199),('乳源瑶族自治县','512600',199),('新丰县','511100',199),('乐昌市','512200',199),('南雄市','512400',199)
insert into Area values('深圳市','518000',200),('罗湖区','518000',200),('福田区','518000',200),('南山区','518000',200),('宝安区','518100',200),('龙岗区','518100',200),('盐田区','518000',200)
insert into Area values('珠海市','519000',201),('香洲区','519000',201),('斗门区','519100',201),('金湾区','519090',201)
insert into Area values('汕头市','515000',202),('龙湖区','515000',202),('金平区','515000',202),('濠江区','515000',202),('潮阳区','515100',202),('潮南区','515100',202),('澄海区','515800',202),('南澳县','515900',202)
insert into Area values('佛山市','528000',203),('禅城区','528000',203),('南海区','528200',203),('顺德区','528000',203),('三水区','528100',203),('高明区','528500',203)
insert into Area values('江门市','529000',204),('蓬江区','529000',204),('江海区','529000',204),('新会区','529100',204),('台山市','529200',204),('开平市','529300',204),('鹤山市','529700',204),('恩平市','529400',204)
insert into Area values('湛江市','524000',205),('赤坎区','524000',205),('霞山区','524000',205),('坡头区','524000',205),('麻章区','524000',205),('遂溪县','524300',205),('徐闻县','524100',205),('廉江市','524400',205),('雷州市','524200',205),('吴川市','524500',205)
insert into Area values('茂名市','525000',206),('茂南区','525000',206),('茂港区','525000',206),('电白县','525400',206),('高州市','525200',206),('化州市','525100',206),('信宜市','525300',206)
insert into Area values('肇庆市','526000',207),('端州区','526000',207),('鼎湖区','526000',207),('广宁县','526300',207),('怀集县','526400',207),('封开县','526500',207),('德庆县','526600',207),('高要市','526100',207),('四会市','526200',207)
insert into Area values('惠州市','516000',208),('惠城区','516000',208),('惠阳区','516200',208),('博罗县','516100',208),('惠东县','516300',208),('龙门县','516800',208)
insert into Area values('梅州市','514000',209),('梅江区','514000',209),('梅县','514700',209),('大埔县','514200',209),('丰顺县','514300',209),('五华县','514400',209),('平远县','514600',209),('蕉岭县','514100',209),('兴宁市','514500',209)
insert into Area values('汕尾市','516600',210),('城区','516600',210),('海丰县','516400',210),('陆河县','516700',210),('陆丰市','516500',210)
insert into Area values('河源市','517000',211),('源城区','517000',211),('紫金县','517400',211),('龙川县','517300',211),('连平县','517100',211),('和平县','517200',211),('东源县','517500',211)
insert into Area values('阳江市','529500',212),('江城区','529500',212),('阳西县','529800',212),('阳东县','529900',212),('阳春市','529600',212)
insert into Area values('清远市','511500',213),('清城区','511500',213),('佛冈县','511600',213),('阳山县','513100',213),('连山壮族瑶族自治县','513200',213),('连南瑶族自治县','513300',213),('清新县','511800',213),('英德市','513000',213),('连州市','513400',213)
insert into Area values('东莞市','523000',214),('万江','523050',214),('篁村','523070',214),('寮步','5234003',214),('附城','523110',214),('麻涌','523130',214),('洪梅','523160',214),('道滘','5231705',214),('望牛墩','523200',214),('中堂','5232206',214),('高埗','523270',214),('石碣','523290',214),('石龙','523320',214),('茶山','5233808',214),('东坑','523450',214),('横沥','523460',214)
insert into Area values('中山市','528400',215),('黄圃镇','528429',215),('南头镇','528427',215),('东凤镇','528425',215),('阜沙镇','528434',215),('小榄镇','528415',215)
insert into Area values('潮州市','521000',216),('湘桥区','521000',216),('潮安县','515600',216),('饶平县','515700',216)
insert into Area values('揭阳市','522000',217),('榕城区','522000',217),('揭东县','515500',217),('揭西县','515400',217),('惠来县','515200',217),('普宁市','515300',217)
insert into Area values('云浮市','527300',218),('云城区','527300',218),('新兴县','527400',218),('郁南县','527100',218),('云安县','527500',218),('罗定市','527200',218)
--广西省
insert into Area values('南宁市','530000',219),('兴宁区','530000',219),('新城区','530000',219),('城北区','530000',219),('江南区','530000',219),('永新区','530000',219),('邕宁县','530200',219),('武鸣县','530100',219),('隆安县','532700',219),('马山县','530600',219),('上林县','530500',219),('宾阳县','530400',219),('横县','530300',219)
insert into Area values('柳州市','545000',220),('城中区','545000',220),('鱼峰区','545000',220),('柳南区','545000',220),('柳北区','545000',220),('柳江县','545100',220),('柳城县','545200',220),('鹿寨县','545600',220),('融安县','545400',220),('融水苗族自治县','545300',220),('三江侗族自治县','545500',220)
insert into Area values('桂林市','541000',221),('秀峰区','541000',221),('叠彩区','541000',221),('象山区','541000',221),('七星区','541000',221),('雁山区','541000',221),('阳朔县','541900',221),('临桂县','541100',221),('灵川县','541200',221),('全州县','541500',221),('兴安县','541300',221),('永福县','541800',221),('灌阳县','541600',221),('龙胜各族自治县','541700',221),('资源县','541400',221),('平乐县','542400',221),('荔蒲县','546600',221),('恭城瑶族自治县','542500',221)
insert into Area values('梧州市','543000',222),('万秀区','543000',222),('蝶山区','543000',222),('长洲区','543000',222),('苍梧县','543100',222),('藤县','543300',222),('蒙山县','546700',222),('岑溪市','543200',222)
insert into Area values('北海市','536000',223),('海城区','536000',223),('银海区','536000',223),('铁山港区','536000',223),('合浦县','536100',223)
insert into Area values('防城港市','538000',224),('港口区','538000',224),('防城区','538000',224),('上思县','535500',224),('东兴市','538100',224)
insert into Area values('钦州市','535000',225),('钦南区','535000',225),('钦北区','535000',225),('灵山县','535400',225),('浦北县','535300',225)
insert into Area values('贵港市','537000',226),('港北区','537100',226),('港南区','537100',226),('覃塘区','537100',226),('平南县','537300',226),('桂平市','537200',226)
insert into Area values('玉林市','537000',227),('玉州区','537000',227),('容县','537500',227),('陆川县','537700',227),('博白县','537600',227),('兴业县','537800',227),('北流市','537400',227)
insert into Area values('百色市','533000',228),('右江区','533000',228),('田阳县','533600',228),('田东县','531500',228),('平果县','531400',228),('德保县','533700',228),('靖西县','533800',228),('那坡县','533900',228),('凌云县','533100',228),('乐业县','533200',228),('田林县','533300',228),('西林县','533500',228),('隆林各族自治县','533500',228)
insert into Area values('贺州市','542800',229),('八步区','542800',229),('昭平县','546800',229),('钟山县','542600',229),('富川瑶族自治县','542700',229)
insert into Area values('河池市','547000',230),('金城江区','547000',230),('南丹县','547200',230),('天峨县','547300',230),('凤山县','547600',230),('东兰县','547400',230),('罗城仫佬族自治县','546400',230),('环江毛南族自治县','547100',230),('巴马瑶族自治县','547500',230),('都安瑶族自治县','530700',230),('大化瑶族自治县','530800',230),('宜州市','546300',230)
insert into Area values('来宾市','546100',231),('兴宾区','546100',231),('忻城县','546200',231),('象州县','545800',231),('武宣县','545900',231),('金秀瑶族自治县','545700',231),('合山市','546500',231)
insert into Area values('崇左市','532200',232),('江洲区','532200',232),('扶绥县','532100',232),('宁明县','532500',232),('龙州县','532400',232),('大新县','532300',232),('天等县','532800',232),('凭祥市','532600',232)
--海南省
insert into Area values('海口市','570100',233),('秀英区','570100',233),('龙华区','570100',233),('琼山区','571100',233),('美兰区','570100',233)
insert into Area values('三亚市','572000',234),('五指山市','572200',234),('琼海市','571400',234),('儋州市','571700',234),('文昌市','571300',234),('万宁市','571500',234),('东方市','572600',234),('定安县','571200',234),('屯昌县','571600',234),('澄迈县','571900',234),('临高县','571800',234),('白沙黎族自治县','572800',234),('昌江黎族自治县','572700',234),('乐东黎族自治县','572500',234),('陵水黎族自治县','572400',234),('保亭黎族苗族自治县','572300',234),('琼中黎族苗族自治县','572900',234),('西沙群岛','572000',234),('南沙群岛','572000',234),('中沙群岛的岛礁及其海域','572000',234),('保亭黎族苗族自治县','572300',235)
--重庆市
insert into Area values('渝中区','400000',236),('南川区','408400',236),('双桥区','400900',236),('涪陵区','408000',236),('永川区','402100',236),('北碚区','400700',236),('万盛区','400700',236),('万州区','404000',236),('巴南区','400000',236),('九龙坡区','400000',236),('黔江区','409000',236),('沙坪坝区','400000',236),('江北区','400000',236),('渝北区','401100',236),('大渡口区','400000',236),('长寿区','401200',236),('南岸区','400000',236),('合川区','401500',236),('江津区','402200',236)
insert into Area values('城口县','405900',237),('梁平县','405200',237),('荣昌县','402400',237),('丰都县','408200',237),('綦江县','401400',237),('大足县','402300',237),('云阳县','404500',237),('巫山县','404700',237),('彭水苗族土家族自治县','409600',237),('璧山县','402700',237),('石柱土家族自治县','409100',237),('忠县','404300',237),('武隆县','408500',237),('酉阳土家族苗族自治县','409800',237),('垫江县','408300',237),('铜梁县','402500',237),('奉节县','404600',237),('开县','404500',237),('秀山土家族苗族自治县','409900',237),('巫溪县','405800',237),('潼南县','402600',237)
insert into Area values('江津','402260',238),('合川','401520',238),('永川','402160',238),('南川','408400',238)
--四川省
insert into Area values('成都市','610000',239),('锦江区','610000',239),('青羊区','610000',239),('金牛区','610000',239),('武侯区','610000',239),('成华区','610000',239),('龙泉驿区','610100',239),('青白江区','610300',239),('新都区','610500',239),('金堂县','610400',239),('双流县','610200',239),('温江县','611100',239),('郫县','611700',239),('大邑县','611300',239),('蒲江县','611600',239),('新津县','611400',239),('都江堰市','611800',239),('彭州市','610000',239),('邛崃市','611500',239),('崇州市','611200',239)
insert into Area values('自贡市','643000',240),('自流井区','643000',240),('贡井区','643020',240),('大安区','643010',240),('沿滩区','643030',240),('荣县','643100',240),('富顺县','643200',240)
insert into Area values('攀枝花市','617000',241),('东区','617000',241),('西区','617000',241),('仁和区','617000',241),('米易县','617200',241),('盐边县','617100',241)
insert into Area values('泸州市','646000',242),('江阳区','646000',242),('纳溪区','646300',242),('龙马潭区','646000',242),('泸县','646100',242),('合江县','646200',242),('叙永县','646400',242),('古蔺县','646500',242)
insert into Area values('德阳市','618000',243),('旌阳区','618000',243),('中江县','618300',243),('罗江县','618500',243),('广汉市','618300',243),('什邡市','618400',243),('绵竹市','618200',243)
insert into Area values('绵阳市','621000',244),('涪城区','621000',244),('游仙区','621000',244),('三台县','621100',244),('盐亭县','621600',244),('安县','622650',244),('梓潼县','622150',244),('平武县','622550',244),('江油市','621700',244)
insert into Area values('广元市','628000',245),('市中区','628000',245),('元坝区','628000',245),('朝天区','628000',245),('旺苍县','628200',245),('青川县','628100',245),('剑阁县','628300',245),('苍溪县','628400',245)
insert into Area values('遂宁市','629000',246),('船山区','629000',246),('安居区','629000',246),('蓬溪县','629100',246),('射洪县','629200',246),('大英县','629300',246)
insert into Area values('内江市','641000',247),('市中区','641000',247),('东兴区','641100',247),('威远县','642450',247),('资中县','641200',247),('隆昌县','642150',247)
insert into Area values('乐山市','614000',248),('市中区','614000',248),('沙湾区','614900',248),('五通桥区','614800',248),('金口河区','614700',248),('犍为县','614400',248),('井研县','613100',248),('夹江县','614100',248),('沐川县','614500',248),('峨边彝族自治县','614300',248),('马边彝族自治县','614600',248),('峨眉山市','614200',248)
insert into Area values('南充市','637000',249),('顺庆区','637000',249),('高坪区','637100',249),('嘉陵区','637500',249),('南部县','637300',249),('营山县','637700',249),('蓬安县','637800',249),('仪陇县','637600',249),('西充县','637200',249),('阆中市','637400',249)
insert into Area values('眉山市','620000',250),('东坡区','620000',250),('仁寿县','620500',250),('彭山县','620800',250),('洪雅县','620300',250),('丹棱县','620200',250),('青神县','620400',250)
insert into Area values('宜宾市','644000',251),('翠屏区','644000',251),('宜宾县','644600',251),('南溪县','644100',251),('江安县','644200',251),('长宁县','644300',251),('高县','645150',251),('珙县','644500',251),('筠连县','645250',251),('兴文县','644400',251),('屏山县','645350',251)
insert into Area values('广安市','638500',252),('广安区','638550',252),('岳池县','638300',252),('武胜县','638400',252),('邻水县','638500',252),('华莹市','638600',252)
insert into Area values('达州市','635000',253),('通川区','635000',253),('达县','635000',253),('宣汉县','636150',253),('开江县','636250',253),('大竹县','635100',253),('渠县','635200',253),('万源市','636350',253)
insert into Area values('雅安市','625000',254),('雨城区','625000',254),('名山县','625100',254),('荥经县','625200',254),('汉源县','625300',254),('石棉县','625400',254),('天全县','625500',254),('芦山县','625600',254),('宝兴县','625700',254)
insert into Area values('巴中市','636600',255),('巴州区','636600',255),('通江县','636700',255),('南江县','635600',255),('平昌县','636400',255)
insert into Area values('资阳市','641300',256),('雁江区','641300',256),('安岳县','642350',256),('乐至县','641500',256),('简阳市','641400',256)
insert into Area values('阿坝藏族羌族自治州','624000',257),('汶川县','623000',257),('理县','623100',257),('茂县','623200',257),('松潘县','623300',257),('九寨沟县','623400',257),('金川县','624100',257),('小金县','624200',257),('黑水县','623500',257),('马尔康县','624000',257),('壤塘县','624300',257),('阿坝县','624600',257),('若尔盖县','624500',257),('红原县','624400',257)
insert into Area values('甘孜藏族自治州','626000',258),('康定县','626000',258),('泸定县','626100',258),('丹巴县','626300',258),('九龙县','616200',258),('雅江县','627450',258),('道孚县','626400',258),('炉霍县','626500',258),('甘孜县','626700',258),('新龙县','626800',258),('德格县','627250',258),('白玉县','627150',258),('石渠县','627350',258),('色达县','626600',258),('理塘县','624300',258),('巴塘县','627650',258),('乡城县','627850',258),('稻城县','627750',258),('得荣县','627950',258)
insert into Area values('凉山彝族自治州','615000',259),('西昌市','615000',259),('木里藏族自治县','615800',259),('盐源县','615700',259),('德昌县','615500',259),('会理县','615100',259),('会东县','615200',259),('宁南县','615400',259),('普格县','615300',259),('布拖县','615350',259),('金阳县','616250',259),('昭觉县','616150',259),('喜德县','616750',259),('冕宁县','615600',259),('越西县','616650',259),('甘洛县','616850',259),('美姑县','616450',259),('雷波县','616550',259)
--贵州省
insert into Area values('贵阳市','550000',260),('南明区','550000',260),('云岩区','550000',260),('花溪区','550000',260),('乌当区','550000',260),('白云区','550000',260),('小河区','550000',260),('开阳县','550300',260),('息烽县','551100',260),('修文县','550200',260),('清镇市','551400',260)
insert into Area values('六盘水市','553000',261),('钟山区','553000',261),('六枝特区','553400',261),('水城县','553000',261),('盘县','561600',261)
insert into Area values('遵义市','563000',262),('红花岗区','563000',262),('汇川区','563000',262),('遵义县','563100',262),('桐梓县','563200',262),('绥阳县','563300',262),('正安县','563400',262),('道真仡佬族苗族自治县','563500',262),('务川仡佬族苗族自治县','564300',262),('凤冈县','564200',262),('湄潭县','564100',262),('余庆县','564400',262),('习水县','564600',262),('赤水市','564700',262),('仁怀市','564500',262)
insert into Area values('安顺市','561000',263),('西秀区','561000',263),('平坝县','561100',263),('普定县','562100',263),('镇宁布依族苗族自治县','561200',263),('关岭布依族苗族自治县','561300',263),('紫云苗族布依族自治县','550800',263)
insert into Area values('铜仁地区','554300',264),('铜仁市','554300',264),('江口县','554400',264),('玉屏侗族自治县','554000',264),('石阡县','555100',264),('思南县','565100',264),('印江土家族苗族自治县','555200',264),('德江县','565200',264),('沿河土家族自治县','565300',264),('松桃苗族自治县','554100',264),('万山特区','554200',264)
insert into Area values('黔西南布依族苗族自治州','562400',265),('兴义市','562400',265),('兴仁县','562300',265),('普安县','561500',265),('晴隆县','561400',265),('贞丰县','562200',265),('望谟县','552300',265),('册亨县','552200',265),('安龙县','552400',265)
insert into Area values('毕节地区','551700',266),('毕节市','551700',266),('大方县','551600',266),('黔西县','551500',266),('金沙县','551800',266),('织金县','552100',266),('纳雍县','553300',266),('威宁彝族回族苗族自治县','553100',266),('赫章县','553200',266)
insert into Area values('黔东南苗族侗族自治州','556000',267),('凯里市','556000',267),('黄平县','556100',267),('施秉县','556200',267),('三穗县','556500',267),('镇远县','557700',267),('岑巩县','557800',267),('天柱县','556600',267),('锦屏县','556700',267),('剑河县','556400',267),('台江县','556300',267),('黎平县','557300',267),('榕江县','557200',267),('从江县','557400',267),('雷山县','557100',267),('麻江县','557600',267),('丹寨县','557500',267)
insert into Area values('黔南布依族苗族自治州','558000',268),('都匀市','558000',268),('福泉市','550500',268),('荔波县','558400',268),('贵定县','551300',268),('瓮安县','550400',268),('独山县','558200',268),('平塘县','558300',268),('罗甸县','550100',268),('长顺县','550700',268),('龙里县','551200',268),('惠水县','550600',268),('三都水族自治县','558100',268)
--云南省
insert into Area values('昆明市','650000',269),('五华区','650000',269),('盘龙区','650000',269),('官渡区','650200',269),('西山区','650100',269),('东川区','654100',269),('呈贡县','650500',269),('晋宁县','650600',269),('富民县','650400',269),('宜良县','652100',269),('石林彝族自治县','652200',269),('嵩明县','651700',269),('禄劝彝族苗族自治县','651500',269),('寻甸回族彝族自治县','655200',269),('安宁市','650300',269)
insert into Area values('曲靖市','655000',270),('麒麟区','655000',270),('马龙县','655100',270),('陆良县','655600',270),('师宗县','655700',270),('罗平县','655800',270),('富源县','655500',270),('会泽县','654200',270),('沾益县','655500',270),('宣威市','655400',270)
insert into Area values('玉溪市','653100',271),('红塔区','653100',271),('江川县','652600',271),('澄江县','652500',271),('通海县','652700',271),('华宁县','652800',271),('易门县','651100',271),('峨山彝族自治县','653200',271),('新平彝族傣族自治县','653400',271),('元江哈尼族彝族傣族自治县','653300',271)
insert into Area values('保山市','678000',272),('隆阳区','678000',272),('施甸县','678200',272),('腾冲县','679100',272),('龙陵县','678300',272),('昌宁县','678100',272)
insert into Area values('昭通市','657000',273),('昭阳区','657000',273),('鲁甸县','657100',273),('巧家县','654600',273),('盐津县','657500',273),('大关县','657400',273),('永善县','657300',273),('绥江县','657700',273),('镇雄县','657200',273),('彝良县','657600',273),('威信县','657900',273),('水富县','657800',273)
insert into Area values('丽江市','674100',274),('古城区','674100',274),('玉龙纳西族自治县','674100',274),('永胜县','674200',274),('华坪县','674800',274),('宁蒗彝族自治县','674300',274)
insert into Area values('思茅市','665000',275),('翠云区','665000',275),('普洱哈尼族彝族自治县','665100',275),('墨江哈尼族自治县','654800',275),('景东彝族自治县','676200',275),('景谷傣族彝族自治县','666400',275),('镇沅彝族哈尼族拉祜族自治县','666500',275),('江城哈尼族彝族自治县','665900',275),('孟连傣族拉祜族佤族自治县','665800',275),('澜沧拉祜族自治县','665600',275),('西盟佤族自治县','665700',275)
insert into Area values('临沧市','677000',276),('临翔区','677000',276),('凤庆县','675900',276),('云县','675800',276),('永德县','677600',276),('镇康县','677700',276),('双江拉祜族佤族布朗族傣族自治县','677300',276),('耿马傣族佤族自治县','677500',276),('沧源佤族自治县','677400',276)
insert into Area values('楚雄彝族自治州','675000',277),('楚雄市','675000',277),('双柏县','675100',277),('牟定县','675500',277),('南华县','675200',277),('姚安县','675300',277),('大姚县','675400',277),('永仁县','651400',277),('元谋县','651300',277),('武定县','651600',277),('禄丰县','651200',277)
insert into Area values('红河哈尼族彝族自治州','661400',278),('个旧市','661000',278),('开远市','661600',278),('蒙自县','661100',278),('屏边苗族自治县','661200',278),('建水县','654300',278),('石屏县','662200',278),('弥勒县','652300',278),('泸西县','652400',278),('元阳县','662400',278),('红河县','654400',278),('金平苗族瑶族傣族自治县','661500',278),('绿春县','662500',278),('河口瑶族自治县','661300',278)
insert into Area values('文山壮族苗族自治州','663000',279),('文山县','663000',279),('砚山县','663100',279),('西畴县','663500',279),('麻栗坡县','663600',279),('马关县','663700',279),('丘北县','663200',279),('广南县','663300',279),('富宁县','663400',279)
insert into Area values('西双版纳傣族自治州','666100',280),('景洪市','666100',280),('勐海县','666200',280),('勐腊县','666300',280)
insert into Area values('大理白族自治州','671000',281),('大理市','671000',281),('漾濞彝族自治县','672500',281),('祥云县','672100',281),('宾川县','671600',281),('弥渡县','675600',281),('南涧彝族自治县','675700',281),('巍山彝族回族自治县','672400',281),('永平县','672600',281),('云龙县','672700',281),('洱源县','671200',281),('剑川县','671300',281),('鹤庆县','671500',281)
insert into Area values('德宏傣族景颇族自治州','678400',282),('瑞丽市','678600',282),('潞西市','678400',282),('梁河县','679200',282),('盈江县','679300',282),('陇川县','678700',282)
insert into Area values('怒江傈僳族自治州','673100',283),('泸水县','673200',283),('福贡县','673400',283),('贡山独龙族怒族自治县','673500',283),('兰坪白族普米族自治县','671400',283)
insert into Area values('迪庆藏族自治州','674400',284),('香格里拉县','674400',284),('德钦县','674500',284),('维西傈僳族自治县','674600',284)
--西藏
insert into Area values('拉萨市','850000',285),('城关区','850000',285),('林周县','851600',285),('当雄县','851500',285),('尼木县','851600',285),('曲水县','850600',285),('堆龙德庆县','851400',285),('达孜县','850100',285),('墨竹工卡县','850200',285)
insert into Area values('昌都地区','854000',286),('昌都县','854000',286),('江达县','854100',286),('贡觉县','854200',286),('类乌齐县','855600',286),('丁青县','855700',286),('察雅县','854300',286),('八宿县','854600',286),('左贡县','854400',286),('芒康县','854500',286),('洛隆县','855400',286),('边坝县','855500',286)
insert into Area values('山南地区','856000',287),('乃东县','856100',287),('扎囊县','850800',287),('贡嘎县','850700',287),('桑日县','856200',287),('琼结县','856800',287),('曲松县','856300',287),('措美县','856900',287),('洛扎县','851200',287),('加查县','856400',287),('隆子县','856600',287),('错那县','856700',287),('浪卡子县','851100',287)
insert into Area values('日喀则地区','857000',288),('日喀则市','857000',288),('南木林县','857100',288),('江孜县','857400',288),('定日县','858200',288),('萨迦县','857800',288),('拉孜县','858100',288),('昂仁县','858500',288),('谢通门县','858900',288),('白朗县','857300',288),('仁布县','857200',288),('康马县','857500',288),('定结县','857900',288),('仲巴县','858800',288),('亚东县','857600',288),('吉隆县','858700',288),('聂拉木县','858300',288),('萨嘎县','858600',288),('岗巴县','857700',288)
insert into Area values('那曲地区','852000',289),('那曲县','852000',289),('嘉黎县','852400',289),('比如县','852300',289),('聂荣县','853500',289),('安多县','853400',289),('申扎县','853100',289),('索县','852200',289),('班戈县','852500',289),('巴青县','852100',289),('尼玛县','853200',289)
insert into Area values('阿里地区','859000',290),('普兰县','859500',290),('札达县','859600',290),('噶尔县','859000',290),('日土县','859700',290),('革吉县','859100',290),('改则县','859200',290),('措勤县','859300',290)
insert into Area values('林芝地区','860000',291),('林芝县','860100',291),('工布江达县','860200',291),('米林县','860500',291),('墨脱县','860700',291),('波密县','860300',291),('察隅县','860600',291),('朗县','860400',291)
--陕西省
insert into Area values('西安市','710000',292),('新城区','710000',292),('碑林区','710000',292),('莲湖区','710000',292),('灞桥区','710000',292),('未央区','710000',292),('雁塔区','710000',292),('阎良区','710000',292),('临潼区','710600',292),('长安区','710100',292),('蓝田县','710500',292),('周至县','710400',292),('户县','710300',292),('高陵县','710200',292)
insert into Area values('铜川市','727000',293),('耀州区','727100',293),('宜君县','727200',293)
insert into Area values('宝鸡市','721000',294),('渭滨区','721000',294),('金台区','721000',294),('陈仓区','721300',294),('凤翔县','721400',294),('岐山县','722400',294),('扶风县','722200',294),('眉县','722300',294),('陇县','721200',294),('千阳县','721100',294),('麟游县','721500',294),('凤县','721700',294),('太白县','721600',294)
insert into Area values('咸阳市','712000',295),('秦都区','712000',295),('杨陵区','712100',295),('渭城区','712000',295),('三原县','713800',295),('泾阳县','713700',295),('乾县','713300',295),('礼泉县','713200',295),('永寿县','713400',295),('彬县','713500',295),('长武县','713600',295),('旬邑县','711300',295),('淳化县','711200',295),('武功县','712200',295),('兴平市','713100',295)
insert into Area values('渭南市','714000',296),('临渭区','714000',296),('华县','714100',296),('潼关县','714300',296),('大荔县','715100',296),('合阳县','715300',296),('澄城县','715200',296),('蒲城县','715500',296),('白水县','715600',296),('富平县','711700',296),('韩城市','715400',296),('华阴市','714200',296)
insert into Area values('延安市','716000',297),('宝塔区','716000',297),('延长县','717100',297),('延川县','717200',297),('子长县','717300',297),('安塞县','717400',297),('志丹县','717500',297),('吴旗县','717600',297),('甘泉县','716100',297),('富县','727500',297),('洛川县','727400',297),('宜川县','716200',297),('黄龙县','715700',297),('黄陵县','727300',297)
insert into Area values('汉中市','723000',298),('汉台区','723000',298),('南郑县','723100',298),('城固县','723200',298),('洋县','723300',298),('西乡县','723500',298),('勉县','724200',298),('宁强县','724400',298),('略阳县','724300',298),('镇巴县','723600',298),('留坝县','724100',298),('佛坪县','723400',298)
insert into Area values('榆林市','719000',299),('榆阳区','719000',299),('府谷县','719400',299),('横山县','719200',299),('靖边县','718500',299),('定边县','718600',299),('绥德县','718000',299),('米脂县','718100',299),('佳县','719200',299),('吴堡县','718200',299),('清涧县','718300',299),('子洲县','718400',299)
insert into Area values('安康市','725000',300),('汉滨区','725000',300),('汉阴县','725100',300),('石泉县','725200',300),('宁陕县','711600',300),('紫阳县','725300',300),('岚皋县','725400',300),('平利县','725500',300),('镇坪县','725600',300),('旬阳县','725700',300),('白河县','725800',300)
insert into Area values('商洛市','726000',301),('商州区','726000',301),('洛南县','726100',301),('丹凤县','726200',301),('商南县','726300',301),('山阳县','726400',301),('镇安县','711500',301),('柞水县','711400',301),('神木县','719300',301)
--甘肃省
insert into Area values('兰州市','730000',302),('城关区','730030',302),('七里河区','730050',302),('西固区','730060',302),('安宁区','730070',302),('红古区','730080',302),('永登县','730300',302),('皋兰县','730200',302),('榆中县','730100',302)
insert into Area values('嘉峪关市','735100',303),('峪泉镇','735100',303),('新城镇','735106',303)
insert into Area values('金昌市','737100',304),('金川区','737100',304),('永昌县','737200',304)
insert into Area values('白银市','730900',305),('白银区','730900',305),('平川区','730900',305),('靖远县','730600',305),('会宁县','730700',305),('景泰县','730400',305)
insert into Area values('天水市','741000',306),('秦城区','741000',306),('北道区','741020',306),('清水县','741400',306),('秦安县','741600',306),('甘谷县','741200',306),('武山县','741300',306),('张家川回族自治县','741500',306)
insert into Area values('武威市','733000',307),('凉州区','733000',307),('民勤县','733300',307),('古浪县','733100',307),('天祝藏族自治县','733200',307)
insert into Area values('张掖市','734000',308),('甘州区','734000',308),('肃南裕固族自治县','734400',308),('民乐县','734500',308),('临泽县','734200',308),('高台县','734300',308),('山丹县','734100',308)
insert into Area values('平凉市','744000',309),('崆峒区','744000',309),('泾川县','744300',309),('灵台县','744400',309),('崇信县','744200',309),('华亭县','744100',309),('庄浪县','744600',309),('静宁县','743400',309)
insert into Area values('酒泉市','735000',310),('肃州区','735000',310),('金塔县','735300',310),('安西县','736100',310),('肃北蒙古族自治县','736300',310),('阿克塞哈萨克族自治县','736400',310),('玉门市','735200',310),('敦煌市','736200',310)
insert into Area values('庆阳市','745000',311),('西峰区','745000',311),('庆阳县','745100',311),('环县','745700',311),('华池县','745600',311),('合水县','745400',311),('正宁县','745300',311),('宁县','745200',311),('镇原县','744500',311)
insert into Area values('定西市','743000',312),('安定区','744300',312),('通渭县','743300',312),('陇西县','748100',312),('渭源县','748200',312),('临洮县','730500',312),('漳县','748300',312),('岷县','748400',312)
insert into Area values('陇南市','746000',313),('武都区','746000',313),('武都区','746000',313),('成县','742500',313),('宕昌县','748500',313),('康县','746500',313),('文县','746400',313),('西和县','742100',313),('礼县','742200',313),('两当县','742400',313),('徽县','742300',313)
insert into Area values('临夏回族自治州','731100',314),('临夏市','731100',314),('临夏县','731800',314),('康乐县','731500',314),('永靖县','731600',314),('广河县','731300',314),('和政县','731200',314),('东乡族自治县','731400',314),('积石山保安族东乡族撒拉族自治县','731700',314)
insert into Area values('甘南藏族自治州','747000',315),('合作市','747000',315),('临潭县','747500',315),('卓尼县','747600',315),('舟曲县','746300',315),('迭部县','747400',315),('玛曲县','747300',315),('碌曲县','747200',315),('夏河县','747100',315)
--青海
insert into Area values('西宁市','810000',316),('城东区','810000',316),('城中区','810000',316),('城西区','810000',316),('城北区','810000',316),('大通回族土族自治县','810100',316),('湟中县','811600',316),('湟源县','812100',316)
insert into Area values('海东地区','810600',317),('平安县','810600',317),('民和回族土族自治县','810800',317),('乐都县','810700',317),('互助土族自治县','810500',317),('化隆回族自治县','810900',317),('循化撒拉族自治县','811100',317)
insert into Area values('海北藏族自治州','812200',318),('门源回族自治县','810300',318),('祁连县','810400',318),('海晏县','812200',318),('刚察县','812300',318)
insert into Area values('黄南藏族自治州','811300',319),('同仁县','811300',319),('尖扎县','811200',319),('泽库县','811400',319),('河南蒙古族自治县','811500',319)
insert into Area values('海南藏族自治州','813000',320),('共和县','813000',320),('同德县','813200',320),('贵德县','811700',320),('兴海县','813300',320),('贵南县','813100',320)
insert into Area values('果洛藏族自治州','814000',321),('玛沁县','814000',321),('班玛县','814300',321),('甘德县','814100',321),('达日县','814200',321),('久治县','624700',321),('玛多县','813500',321)
insert into Area values('玉树藏族自治州','815000',322),('玉树县','815000',322),('杂多县','815300',322),('称多县','815100',322),('治多县','815400',322),('囊谦县','815200',322),('曲麻莱县','815500',322)
insert into Area values('海西蒙古族藏族自治州','817000',323),('格尔木市','816000',323),('德令哈市','817000',323),('乌兰县','817100',323),('都兰县','816100',323),('天峻县','817200',323)
--宁夏
insert into Area values('银川市','750000',324),('兴庆区','750000',324),('西夏区','750000',324),('金凤区','750000',324),('永宁县','750100',324),('贺兰县','750200',324),('灵武市','751400',324)
insert into Area values('石嘴山市','753000',325),('大武口区','753000',325),('惠农区','753600',325),('平罗县','753400',325)
insert into Area values('吴忠市','751100',326),('利通区','751100',326),('盐池县','751500',326),('同心县','751300',326),('青铜峡市','751600',326)
insert into Area values('固原市','756000',327),('原州区','756000',327),('西吉县','756200',327),('隆德县','756300',327),('泾源县','756400',327),('彭阳县','756500',327)
insert into Area values('中卫市','751700',328),('沙坡头区','751700',328),('中宁县','751200',328),('海原县','751800',328)
--新疆
insert into Area values('乌鲁木齐市','830000',329),('天山区','830000',329),('沙依巴克区','830000',329),('新市区','830000',329),('水磨沟区','830000',329),('头屯河区','830000',329),('东山区','830000',329),('乌鲁木齐县','830000',329)
insert into Area values('克拉玛依市','834000',330),('独山子区','838600',330),('克拉玛依区','834000',330),('白碱滩区','834000',330),('乌尔禾区','834000',330)
insert into Area values('吐鲁番地区','838000',331),('吐鲁番市','838000',331),('鄯善县','838200',331),('托克逊县','838100',331)
insert into Area values('哈密地区','839000',332),('哈密市','839000',332),('巴里坤哈萨克自治县','839200',332),('伊吾县','839300',332)
insert into Area values('昌吉回族自治州','831100',333),('昌吉市','831100',333),('阜康市','831500',333),('米泉市','831400',333),('呼图壁县','831200',333),('玛纳斯县','832200',333),('奇台县','831800',333),('吉木萨尔县','831700',333),('木垒哈萨克自治县','831900',333)
insert into Area values('博尔塔拉蒙古自治州','833400',334),('博乐市','833400',334),('精河县','833300',334),('温泉县','833500',334)
insert into Area values('巴音郭楞蒙古自治州','841000',335),('库尔勒市','841000',335),('轮台县','841600',335),('尉犁县','841500',335),('若羌县','841800',335),('且末县','841900',335),('焉耆回族自治县','841100',335),('和静县','841300',335),('和硕县','841200',335),('博湖县','841400',335)
insert into Area values('阿克苏地区','843000',336),('阿克苏市','843000',336),('温宿县','843100',336),('库车县','842000',336),('沙雅县','842200',336),('新和县','842100',336),('拜城县','842300',336),('乌什县','843400',336),('阿瓦提县','843200',336),('柯坪县','843600',336)
insert into Area values('克孜勒苏柯尔克孜自治州','845350',337),('阿图什市','845350',337),('阿克陶县','845550',337),('阿合奇县','843500',337),('乌恰县','845450',337)
insert into Area values('喀什地区','844000',338),('喀什市','844000',338),('疏附县','844100',338),('疏勒县','844200',338),('英吉沙县','844500',338),('泽普县','844800',338),('莎车县','844700',338),('叶城县','844900',338),('麦盖提县','844600',338),('岳普湖县','844400',338),('伽师县','844300',338),('巴楚县','843800',338),('塔什库尔干塔吉克自治县','845250',338)
insert into Area values('和田地区','848000',339),('和田市','848000',339),('和田县','848000',339),('墨玉县','848100',339),('皮山县','845150',339),('洛浦县','848200',339),('策勒县','848300',339),('于田县','848400',339),('民丰县','848500',339)
insert into Area values('伊犁哈萨克自治州','835000',340),('伊宁市','835000',340),('奎屯市','833200',340),('伊宁县','835100',340),('察布查尔锡伯自治县','835300',340),('霍城县','835200',340),('巩留县','835400',340),('新源县','835800',340),('昭苏县','835600',340),('特克斯县','835500',340),('尼勒克县','835700',340)
insert into Area values('塔城地区','834700',341),('塔城市','834300',341),('乌苏市','833300',341),('额敏县','834600',341),('沙湾县','832100',341),('托里县','834500',341),('裕民县','834800',341),('和布克赛尔蒙古自治县','834400',341)
insert into Area values('阿勒泰地区','836500',342),('阿勒泰市','836500',342),('布尔津县','836600',342),('富蕴县','836100',342),('福海县','836400',342),('哈巴河县','836700',342),('青河县','836200',342),('吉木乃县','836800',342)
insert into Area values('石河子市','832000',343),('阿拉尔市','843300',343),('图木舒克市','844000',343),('五家渠市','831300',343)
--台湾省
insert into Area values('台北市','222',344),('台中市','400',344),('基隆市','200',344),('台北县','220',344),('苗粟县','360',344),('台南市','700',344),('新竹县','300',344),('云林县','640',344),('高雄县','800',344),('嘉义县','600',344),('屏东县','900',344),('台南县','730',344),('台中县','420',344),('彭湖县','880',344),('宜兰县','260',344),('桃园县','330',344),('南投县','540',344),('花莲县','950',344),('彰化县','500',344),('台东县','210',344)
--香港
insert into Area values('中华人民共和国香港特别行政区','999077',345)
--澳门
insert into Area values('中华人民共和国澳门特别行政区','999078',346)  

select * from Province
select * from City
select * from Area