Chinese regions database
Chinese regions database in sqlite3 format(NBSC last-update: 2014-01-16)
Getting Started
to install nodejs dependencies:
npm --registry=http://registry.cnpmjs.org install
and type following command to dump database into json files:
node dump.js
Example projects
chineserp
basic API for region picker.
chineserp-jquery
a jQuery plugin which provides sets of wonderful user experience.
Database schema
regions table
id TEXT PRIMARY KEY ASC,
parent_id TEXT,
name TEXT,
alias TEXT,
pinyin TEXT,
abbr TEXT,
zip TEXT,
level INTEGER
dumped JSON object struct:
{
i: '310000', //ID, the unique code of region
n: '上海市', //Name, the fullname of region
a: '上海', //Alias, the simplfied name of region
b: 'SH', //Abbr, the simplfied chinese Pinyin of region
y: 'ShangHai', //Pinyin, the chinese Pinyin of region
z: '200000', //Zipcode, the post-code of region
}
Stats, Version, Provinces, Cities, Suburbs, Total, --------, ---------, ------, -------, -----, 20130831, 34, 469, 2814, 3317, 20140116, 34, 469, 2816, 3319, ## Changes of v2014.01.16
New Regions:
扎赉诺尔区,扶余市,溧水区,高淳区,姜堰区,清新区,潮安区,揭东区,临桂区,龙圩区,福绵区,江州区,前锋区,达川区,恩阳区,观山湖区,弥勒市,双湖县,海东市,乐都区,平安县,民和回族土族自治县,互助土族自治县,化隆回族自治县,循化撒拉族自治县,玉树市,阿拉山口市
Removed Regions:
扶余县,白下区,下关区,溧水县,高淳县,姜堰市,四方区,胶南市,清新县,潮安县,揭东县,临桂县,蝶山区,江洲区,达县,小河区,弥勒县,海东地区,平安县,民和回族土族自治县,乐都县,互助土族自治县,化隆回族自治县,循化撒拉族自治县,玉树县
Use the upgrade_to_20140116.sql to upgrade your database.
Reference
最新县及县以上行政区划代码（截止2013年8月31日） National bureau of statistics of china
最新县及县以上行政区划代码（截止2012年10月31日）National bureau of statistics of china