INSERT INTO hat_area VALUES (1733,'420683','枣阳市','420600'); INSERT INTO hat_area VALUES (1734,'420684','宜城市','420600'); INSERT INTO hat_area VALUES (1735,'420701','市辖区','420700'); INSERT INTO hat_area VALUES (1736,'420702','梁子湖区','420700'); INSERT INTO hat_area VALUES (1737,'420703','华容区','420700'); INSERT INTO hat_area VALUES (1738,'420704','鄂城区','420700'); INSERT INTO hat_area VALUES (1739,'420801','市辖区','420800'); INSERT INTO hat_area VALUES (1740,'420802','东宝区','420800'); INSERT INTO hat_area VALUES (1741,'420804','掇刀区','420800'); INSERT INTO hat_area VALUES (1742,'420821','京山县','420800'); INSERT INTO hat_area VALUES (1743,'420822','沙洋县','420800'); INSERT INTO hat_area VALUES (1744,'420881','钟祥市','420800'); INSERT INTO hat_area VALUES (1745,'420901','市辖区','420900'); INSERT INTO hat_area VALUES (1746,'420902','孝南区','420900'); INSERT INTO hat_area VALUES (1747,'420921','孝昌县','420900'); INSERT INTO hat_area VALUES (1748,'420922','大悟县','420900'); INSERT INTO hat_area VALUES (1749,'420923','云梦县','420900'); INSERT INTO hat_area VALUES (1750,'420981','应城市','420900'); INSERT INTO hat_area VALUES (1751,'420982','安陆市','420900'); INSERT INTO hat_area VALUES (1752,'420984','汉川市','420900'); INSERT INTO hat_area VALUES (1753,'421001','市辖区','421000'); INSERT INTO hat_area VALUES (1754,'421002','沙市区','421000'); INSERT INTO hat_area VALUES (1755,'421003','荆州区','421000'); INSERT INTO hat_area VALUES (1756,'421022','公安县','421000'); INSERT INTO hat_area VALUES (1757,'421023','监利县','421000'); INSERT INTO hat_area VALUES (1758,'421024','江陵县','421000'); INSERT INTO hat_area VALUES (1759,'421081','石首市','421000'); INSERT INTO hat_area VALUES (1760,'421083','洪湖市','421000'); INSERT INTO hat_area VALUES (1761,'421087','松滋市','421000'); INSERT INTO hat_area VALUES (1762,'421101','市辖区','421100'); INSERT INTO hat_area VALUES (1763,'421102','黄州区','421100'); INSERT INTO hat_area VALUES (1764,'421121','团风县','421100'); INSERT INTO hat_area VALUES (1765,'421122','红安县','421100'); INSERT INTO hat_area VALUES (1766,'421123','罗田县','421100'); INSERT INTO hat_area VALUES (1767,'421124','英山县','421100'); INSERT INTO hat_area VALUES (1768,'421125','浠水县','421100'); INSERT INTO hat_area VALUES (1769,'421126','蕲春县','421100'); INSERT INTO hat_area VALUES (1770,'421127','黄梅县','421100'); INSERT INTO hat_area VALUES (1771,'421181','麻城市','421100'); INSERT INTO hat_area VALUES (1772,'421182','武穴市','421100'); INSERT INTO hat_area VALUES (1773,'421201','市辖区','421200'); INSERT INTO hat_area VALUES (1774,'421202','咸安区','421200'); INSERT INTO hat_area VALUES (1775,'421221','嘉鱼县','421200'); INSERT INTO hat_area VALUES (1776,'421222','通城县','421200');
INSERT INTO hat_area VALUES (1777,'421223','崇阳县','421200'); INSERT INTO hat_area VALUES (1778,'421224','通山县','421200'); INSERT INTO hat_area VALUES (1779,'421281','赤壁市','421200'); INSERT INTO hat_area VALUES (1780,'421301','市辖区','421300'); INSERT INTO hat_area VALUES (1781,'421302','曾都区','421300'); INSERT INTO hat_area VALUES (1782,'421381','广水市','421300'); INSERT INTO hat_area VALUES (1783,'422801','恩施市','422800'); INSERT INTO hat_area VALUES (1784,'422802','利川市','422800'); INSERT INTO hat_area VALUES (1785,'422822','建始县','422800'); INSERT INTO hat_area VALUES (1786,'422823','巴东县','422800'); INSERT INTO hat_area VALUES (1787,'422825','宣恩县','422800'); INSERT INTO hat_area VALUES (1788,'422826','咸丰县','422800'); INSERT INTO hat_area VALUES (1789,'422827','来凤县','422800'); INSERT INTO hat_area VALUES (1790,'422828','鹤峰县','422800'); INSERT INTO hat_area VALUES (1791,'429004','仙桃市','429000'); INSERT INTO hat_area VALUES (1792,'429005','潜江市','429000'); INSERT INTO hat_area VALUES (1793,'429006','天门市','429000'); INSERT INTO hat_area VALUES (1794,'429021','神农架林区','429000'); INSERT INTO hat_area VALUES (1795,'430101','市辖区','430100'); INSERT INTO hat_area VALUES (1796,'430102','芙蓉区','430100'); INSERT INTO hat_area VALUES (1797,'430103','天心区','430100'); INSERT INTO hat_area VALUES (1798,'430104','岳麓区','430100'); INSERT INTO hat_area VALUES (1799,'430105','开福区','430100'); INSERT INTO hat_area VALUES (1800,'430111','雨花区','430100'); INSERT INTO hat_area VALUES (1801,'430121','长沙县','430100'); INSERT INTO hat_area VALUES (1802,'430122','望城县','430100'); INSERT INTO hat_area VALUES (1803,'430124','宁乡县','430100'); INSERT INTO hat_area VALUES (1804,'430181','浏阳市','430100'); INSERT INTO hat_area VALUES (1805,'430201','市辖区','430200'); INSERT INTO hat_area VALUES (1806,'430202','荷塘区','430200'); INSERT INTO hat_area VALUES (1807,'430203','芦淞区','430200'); INSERT INTO hat_area VALUES (1808,'430204','石峰区','430200'); INSERT INTO hat_area VALUES (1809,'430211','天元区','430200'); INSERT INTO hat_area VALUES (1810,'430221','株洲县','430200'); INSERT INTO hat_area VALUES (1811,'430223','攸 县','430200'); INSERT INTO hat_area VALUES (1812,'430224','茶陵县','430200'); INSERT INTO hat_area VALUES (1813,'430225','炎陵县','430200'); INSERT INTO hat_area VALUES (1814,'430281','醴陵市','430200'); INSERT INTO hat_area VALUES (1815,'430301','市辖区','430300'); INSERT INTO hat_area VALUES (1816,'430302','雨湖区','430300'); INSERT INTO hat_area VALUES (1817,'430304','岳塘区','430300'); INSERT INTO hat_area VALUES (1818,'430321','湘潭县','430300'); INSERT INTO hat_area VALUES (1819,'430381','湘乡市','430300'); INSERT INTO hat_area VALUES (1820,'430382','韶山市','430300');
INSERT INTO hat_area VALUES (1821,'430401','市辖区','430400'); INSERT INTO hat_area VALUES (1822,'430405','珠晖区','430400'); INSERT INTO hat_area VALUES (1823,'430406','雁峰区','430400'); INSERT INTO hat_area VALUES (1824,'430407','石鼓区','430400'); INSERT INTO hat_area VALUES (1825,'430408','蒸湘区','430400'); INSERT INTO hat_area VALUES (1826,'430412','南岳区','430400'); INSERT INTO hat_area VALUES (1827,'430421','衡阳县','430400'); INSERT INTO hat_area VALUES (1828,'430422','衡南县','430400'); INSERT INTO hat_area VALUES (1829,'430423','衡山县','430400'); INSERT INTO hat_area VALUES (1830,'430424','衡东县','430400'); INSERT INTO hat_area VALUES (1831,'430426','祁东县','430400'); INSERT INTO hat_area VALUES (1832,'430481','耒阳市','430400'); INSERT INTO hat_area VALUES (1833,'430482','常宁市','430400'); INSERT INTO hat_area VALUES (1834,'430501','市辖区','430500'); INSERT INTO hat_area VALUES (1835,'430502','双清区','430500'); INSERT INTO hat_area VALUES (1836,'430503','大祥区','430500'); INSERT INTO hat_area VALUES (1837,'430511','北塔区','430500'); INSERT INTO hat_area VALUES (1838,'430521','邵东县','430500'); INSERT INTO hat_area VALUES (1839,'430522','新邵县','430500'); INSERT INTO hat_area VALUES (1840,'430523','邵阳县','430500'); INSERT INTO hat_area VALUES (1841,'430524','隆回县','430500'); INSERT INTO hat_area VALUES (1842,'430525','洞口县','430500'); INSERT INTO hat_area VALUES (1843,'430527','绥宁县','430500'); INSERT INTO hat_area VALUES (1844,'430528','新宁县','430500');
INSERT INTO hat_area VALUES (1845,'430529','城步苗族自治县','430500'); INSERT INTO hat_area VALUES (1846,'430581','武冈市','430500'); INSERT INTO hat_area VALUES (1847,'430601','市辖区','430600'); INSERT INTO hat_area VALUES (1848,'430602','岳阳楼区','430600'); INSERT INTO hat_area VALUES (1849,'430603','云溪区','430600'); INSERT INTO hat_area VALUES (1850,'430611','君山区','430600'); INSERT INTO hat_area VALUES (1851,'430621','岳阳县','430600'); INSERT INTO hat_area VALUES (1852,'430623','华容县','430600'); INSERT INTO hat_area VALUES (1853,'430624','湘阴县','430600'); INSERT INTO hat_area VALUES (1854,'430626','平江县','430600'); INSERT INTO hat_area VALUES (1855,'430681','汨罗市','430600'); INSERT INTO hat_area VALUES (1856,'430682','临湘市','430600'); INSERT INTO hat_area VALUES (1857,'430701','市辖区','430700'); INSERT INTO hat_area VALUES (1858,'430702','武陵区','430700'); INSERT INTO hat_area VALUES (1859,'430703','鼎城区','430700'); INSERT INTO hat_area VALUES (1860,'430721','安乡县','430700'); INSERT INTO hat_area VALUES (1861,'430722','汉寿县','430700'); INSERT INTO hat_area VALUES (1862,'430723','澧 县','430700'); INSERT INTO hat_area VALUES (1863,'430724','临澧县','430700'); INSERT INTO hat_area VALUES (1864,'430725','桃源县','430700');
INSERT INTO hat_area VALUES (1865,'430726','石门县','430700'); INSERT INTO hat_area VALUES (1866,'430781','津市市','430700'); INSERT INTO hat_area VALUES (1867,'430801','市辖区','430800'); INSERT INTO hat_area VALUES (1868,'430802','永定区','430800'); INSERT INTO hat_area VALUES (1869,'430811','武陵源区','430800'); INSERT INTO hat_area VALUES (1870,'430821','慈利县','430800'); INSERT INTO hat_area VALUES (1871,'430822','桑植县','430800'); INSERT INTO hat_area VALUES (1872,'430901','市辖区','430900'); INSERT INTO hat_area VALUES (1873,'430902','资阳区','430900'); INSERT INTO hat_area VALUES (1874,'430903','赫山区','430900'); INSERT INTO hat_area VALUES (1875,'430921','南 县','430900'); INSERT INTO hat_area VALUES (1876,'430922','桃江县','430900'); INSERT INTO hat_area VALUES (1877,'430923','安化县','430900'); INSERT INTO hat_area VALUES (1878,'430981','沅江市','430900'); INSERT INTO hat_area VALUES (1879,'431001','市辖区','431000'); INSERT INTO hat_area VALUES (1880,'431002','北湖区','431000'); INSERT INTO hat_area VALUES (1881,'431003','苏仙区','431000'); INSERT INTO hat_area VALUES (1882,'431021','桂阳县','431000'); INSERT INTO hat_area VALUES (1883,'431022','宜章县','431000'); INSERT INTO hat_area VALUES (1884,'431023','永兴县','431000'); INSERT INTO hat_area VALUES (1885,'431024','嘉禾县','431000'); INSERT INTO hat_area VALUES (1886,'431025','临武县','431000'); INSERT INTO hat_area VALUES (1887,'431026','汝城县','431000'); INSERT INTO hat_area VALUES (1888,'431027','桂东县','431000'); INSERT INTO hat_area VALUES (1889,'431028','安仁县','431000'); INSERT INTO hat_area VALUES (1890,'431081','资兴市','431000'); INSERT INTO hat_area VALUES (1891,'431101','市辖区','431100'); INSERT INTO hat_area VALUES (1892,'431102','芝山区','431100'); INSERT INTO hat_area VALUES (1893,'431103','冷水滩区','431100'); INSERT INTO hat_area VALUES (1894,'431121','祁阳县','431100'); INSERT INTO hat_area VALUES (1895,'431122','东安县','431100'); INSERT INTO hat_area VALUES (1896,'431123','双牌县','431100'); INSERT INTO hat_area VALUES (1897,'431124','道 县','431100'); INSERT INTO hat_area VALUES (1898,'431125','江永县','431100'); INSERT INTO hat_area VALUES (1899,'431126','宁远县','431100'); INSERT INTO hat_area VALUES (1900,'431127','蓝山县','431100'); INSERT INTO hat_area VALUES (1901,'431128','新田县','431100');
INSERT INTO hat_area VALUES (1902,'431129','江华瑶族自治县','431100'); INSERT INTO hat_area VALUES (1903,'431201','市辖区','431200'); INSERT INTO hat_area VALUES (1904,'431202','鹤城区','431200'); INSERT INTO hat_area VALUES (1905,'431221','中方县','431200'); INSERT INTO hat_area VALUES (1906,'431222','沅陵县','431200'); INSERT INTO hat_area VALUES (1907,'431223','辰溪县','431200'); INSERT INTO hat_area VALUES (1908,'431224','溆浦县','431200');
INSERT INTO hat_area VALUES (1909,'431225','会同县','431200');
INSERT INTO hat_area VALUES (1910,'431226','麻阳苗族自治县','431200'); INSERT INTO hat_area VALUES (1911,'431227','新晃侗族自治县','431200'); INSERT INTO hat_area VALUES (1912,'431228','芷江侗族自治县','431200'); INSERT INTO hat_area VALUES (1913,'431229','靖州苗族侗族自治县','431200'); INSERT INTO hat_area VALUES (1914,'431230','通道侗族自治县','431200'); INSERT INTO hat_area VALUES (1915,'431281','洪江市','431200'); INSERT INTO hat_area VALUES (1916,'431301','市辖区','431300'); INSERT INTO hat_area VALUES (1917,'431302','娄星区','431300'); INSERT INTO hat_area VALUES (1918,'431321','双峰县','431300'); INSERT INTO hat_area VALUES (1919,'431322','新化县','431300'); INSERT INTO hat_area VALUES (1920,'431381','冷水江市','431300'); INSERT INTO hat_area VALUES (1921,'431382','涟源市','431300'); INSERT INTO hat_area VALUES (1922,'433101','吉首市','433100'); INSERT INTO hat_area VALUES (1923,'433122','泸溪县','433100'); INSERT INTO hat_area VALUES (1924,'433123','凤凰县','433100'); INSERT INTO hat_area VALUES (1925,'433124','花垣县','433100'); INSERT INTO hat_area VALUES (1926,'433125','保靖县','433100'); INSERT INTO hat_area VALUES (1927,'433126','古丈县','433100'); INSERT INTO hat_area VALUES (1928,'433127','永顺县','433100'); INSERT INTO hat_area VALUES (1929,'433130','龙山县','433100'); INSERT INTO hat_area VALUES (1930,'440101','市辖区','440100'); INSERT INTO hat_area VALUES (1931,'440102','东山区','440100'); INSERT INTO hat_area VALUES (1932,'440103','荔湾区','440100'); INSERT INTO hat_area VALUES (1933,'440104','越秀区','440100'); INSERT INTO hat_area VALUES (1934,'440105','海珠区','440100'); INSERT INTO hat_area VALUES (1935,'440106','天河区','440100'); INSERT INTO hat_area VALUES (1936,'440107','芳村区','440100'); INSERT INTO hat_area VALUES (1937,'440111','白云区','440100'); INSERT INTO hat_area VALUES (1938,'440112','黄埔区','440100'); INSERT INTO hat_area VALUES (1939,'440113','番禺区','440100'); INSERT INTO hat_area VALUES (1940,'440114','花都区','440100'); INSERT INTO hat_area VALUES (1941,'440183','增城市','440100'); INSERT INTO hat_area VALUES (1942,'440184','从化市','440100'); INSERT INTO hat_area VALUES (1943,'440201','市辖区','440200'); INSERT INTO hat_area VALUES (1944,'440203','武江区','440200'); INSERT INTO hat_area VALUES (1945,'440204','浈江区','440200'); INSERT INTO hat_area VALUES (1946,'440205','曲江区','440200'); INSERT INTO hat_area VALUES (1947,'440222','始兴县','440200'); INSERT INTO hat_area VALUES (1948,'440224','仁化县','440200'); INSERT INTO hat_area VALUES (1949,'440229','翁源县','440200');
INSERT INTO hat_area VALUES (1950,'440232','乳源瑶族自治县','440200'); INSERT INTO hat_area VALUES (1951,'440233','新丰县','440200'); INSERT INTO hat_area VALUES (1952,'440281','乐昌市','440200');
中国省市区三级数据库表 sql
