各种数据集详细

  

1.国家统计局70城市指数

    # 表结构 data_statistics_70_index_1
    CREATE TABLE data_statistics_70_index_1
    (
      id serial NOT NULL,
      city_code integer,
      city_name text,
      chainid numeric,
      anid numeric,
      fixedid numeric,
      timeseries text,
      timeyear integer,
      timemonth integer,
      mark integer,
      create_time timestamp without time zone DEFAULT now()
    )

    # 表结构 data_statistics_70_index_fixed_price_1
    CREATE TABLE data_statistics_70_index_fixed_price_1
    (
      id serial NOT NULL,
      city_code integer,
      city_name text,
      chainid numeric,
      anid numeric,
      fixedid numeric,
      fixed10 numeric,
      fixed15 numeric,
      fixed_prcie10 numeric,
      fixed_prcie15 numeric,
      timeseries text,
      timeyear integer,
      timemonth integer,
      mark integer,
      create_time timestamp without time zone DEFAULT now()
    )


    # 表结构Json
    {"oTableName":"data_statistics_70_index_1" , "oFieldType":["number", "text", "number", "number", "number", "text", "number", "number", "number"]}

    {"oTableName":"data_statistics_70_index_fixed_price_1" , "oFieldType":["number", "text", "number", "number", "number", "number", "number", "number", "number", "text", "number", "number", "number"]}


    # 数据检索

    SELECT id, city_code, city_name, chainid, anid, fixedid, fixed10, fixed15, 
           fixed_prcie10, fixed_prcie15, timeseries, timeyear, timemonth, 
           mark, create_time
      FROM data_statistics_70_index_fixed_price
      limit 100


    SELECT id, city_code, city_name, chainid, anid, fixedid, timeseries, 
           timeyear, timemonth, mark, create_time
      FROM data_statistics_70_index_1
      limit 100


    # URL网址


    http://www.stats.gov.cn/was5/web/search?channelid=288041&andsen=70%E4%B8%AA%E5%A4%A7%E4%B8%AD%E5%9F%8E%E5%B8%82%E4%BD%8F%E5%AE%85#


    # 2017年09月
    http://www.stats.gov.cn/tjsj/zxfb/201710/t20171023_1545010.html

    # 2017年08月
    http://www.stats.gov.cn/tjsj/zxfb/201709/t20170918_1535004.html

    # 2017年07月  
    http://www.stats.gov.cn/tjsj/zxfb/201708/t20170818_1525124.html

    # 2017年06月  
    http://www.stats.gov.cn/tjsj/zxfb/201707/t20170718_1513941.html

    # 2017年05月  
    http://www.stats.gov.cn/tjsj/zxfb/201706/t20170619_1504783.html

    # 2017年04月
    http://www.stats.gov.cn/tjsj/zxfb/201705/t20170518_1495434.html

    # 2017年03月
    http://www.stats.gov.cn/tjsj/zxfb/201704/t20170418_1485514.html

    # 2017年02月
    http://www.stats.gov.cn/tjsj/zxfb/201703/t20170318_1474458.html

    # 2017年01月
    http://www.stats.gov.cn/tjsj/zxfb/201702/t20170222_1465242.html

    # 2016年12月
    http://www.stats.gov.cn/tjsj/zxfb/201701/t20170118_1454976.html

    # 2016年11月
    http://www.stats.gov.cn/tjsj/zxfb/201612/t20161219_1442973.html

    # 2016年10月
    http://www.stats.gov.cn/tjsj/zxfb/201611/t20161118_1430920.html

    # 2016年9月
    http://www.stats.gov.cn/tjsj/zxfb/201610/t20161021_1412289.html

    # 2016年8月
    http://www.stats.gov.cn/tjsj/zxfb/201609/t20160919_1401192.html

    # 2016年7月
    http://www.stats.gov.cn/tjsj/zxfb/201608/t20160818_1389865.html

    # 2016年6月
    http://www.stats.gov.cn/tjsj/zxfb/201607/t20160718_1378481.html

    # 2016年5月
    http://www.stats.gov.cn/tjsj/zxfb/201606/t20160617_1368635.html

    # 2016年4月
    http://www.stats.gov.cn/tjsj/zxfb/201605/t20160518_1357722.html

    # 2016年3月
    http://www.stats.gov.cn/tjsj/zxfb/201604/t20160418_1344861.html

    # 2016年2月
    http://www.stats.gov.cn/tjsj/zxfb/201603/t20160318_1332610.html

    # 2016年1月
    http://www.stats.gov.cn/tjsj/zxfb/201602/t20160226_1323146.html

    # 2015年12月
    http://www.stats.gov.cn/tjsj/zxfb/201601/t20160118_1305503.html

    # 标识解释
        chainid    环比
        anid       同比
        fixedid    定基
        mark=1     新建住宅价格指数
        mark=2     新建商品住宅价格指数
        mark=3     二手住宅价格指数

  

2.搜房百城指数

    # 表结构
    CREATE TABLE project_data.data_sf_bc_index_price_1
    (
      id serial NOT NULL,
      city_code integer,
      city_name text,
      price numeric,
      timeseries text,
      timeyear integer,
      timemonth integer,
      create_time timestamp without time zone DEFAULT now()
    )

    # 表结构Json
    {"oTableName":"project_data.data_sf_bc_index_price_1" , "oFieldType":["number", "text", "number", "text", "number", "number"]}

    # 数据检索
    SELECT city_code, city_name, price, timeseries, timeyear, timemonth FROM project_data.data_sf_bc_index_price_1

    # 网址
    (http://fdc.fang.com/index/BaiChengIndex.html)

    # 百城价格指数
    http://fdc.fang.com/index/BaiChengIndex.aspx?action=chart&city=%27%u5317%u4EAC%27,&stamp=78447352
    http://fdc.fang.com/index/BaiChengIndex.aspx?action=chart&city=%27%u5168%u56fd%u0028%u767e%u57ce%u0029%27,&stamp=78447352
    http://fdc.fang.com/index/BaiChengIndex.aspx?action=chart&city=%27%u5168%u56FD%28%u767E%u57CE%29%27,%27%u5317%u4EAC%27,%27%u4E0A%u6D77%27,&stamp=92442191
    http://fdc.fang.com/index/BaiChengIndex.aspx?action=chart&city='%u5168%u56FD%28%u767E%u57CE%29','%u5317%u4EAC','%u4E0A%u6D77','%u5E7F%u5DDE','%u676D%u5DDE',&stamp=8334176
    http://fdc.fang.com/index/BaiChengIndex.aspx?action=chart&city='%u5168%u56FD%28%u767E%u57CE%29','%u91CD%u5E86','%u6DF1%u5733','%u5357%u4EAC','%u82CF%u5DDE',&stamp=94369833



    # 在百城指数中，70指数缺的城市价格
    SELECT citycode, provincename, cityname, mediandata, meandata, ulistingyear, ulistingmonth   FROM abdata_esf_result_city_number_price  where citycode in ('2106','2107','2310','3403','3408','3604','3708','4104','4206','4306','4307','4402','5105','5113','5203','5329') and ulistingyear='2015' and ulistingmonth='2'

  

3.环境保护部全国城市空气质量日报

{"oTableName":"project_data.data_air_daily_1" , "oFieldType":['number', 'text', 'text', 'number', 'text', 'text']}