/regions-of-china

The administrative divisions of China(**省市地区和行政区划数据), provide CSV, SQL, text, Excel and XML data format.

Primary LanguageGoOtherNOASSERTION

Regions of China (**省市地区和行政区划数据)

The administrative divisions of China, provide CSV, SQL, text, Excel and XML data format.

Latest upated time: 2016-07-31

Data format

  • regions-of-china.csv CSV format.
  • regions-of-china.sql SQL format.
  • regions-of-china.txt Text format.
  • regions-of-china.xlsx Excel format.
  • regions-of-china.xml XML format.

Table structure

CREATE TABLE `region` (
  `district_id` int(10) unsigned NOT NULL,
  `district_name` varchar(128) NOT NULL,
  `city_id` int(10) unsigned NOT NULL,
  `city_name` varchar(128) NOT NULL,
  `province_id` int(10) unsigned NOT NULL,
  `province_name` varchar(128) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

说明

**行政区划数据. 包括省(直辖市)、市(县)和区, 数据来自"中华人民共和国统计局"官方网站. 数据截止2016年07月31日.

References