这是一个全国二手房信息数据库,共有2,646,914个二手房信息记录。这些二手房信息来源于全国363个城市。每个二手房信息中有发布时间,价格,房屋描述,单价,房型,小区名字,房屋情况,地址,联系人,联系电话等。除此之外,数据库中还包含有79,284个房屋详情描述和51,102张房屋图片。该二手房数据库共有8个表。
From this China second-hand houses data, there are 2,646,914 second-hand housing records with release time, price, description, unit price, house layout, name of residential area, state of the house, address, contact, telephone number, etc. in each. All these second-hand houses are from 363 cities in China. It also has other 2 most related tables, they are 79,284 detailed of description records and 51,102 photos of these houses. The whole China second-hand houses database totally has 8 tables.
| Name | n3_chennan_CS_ershoufang_liebiao_com |
|---|---|
| Data | 3.20G (+ 0B) |
| Tables | 8 (+ 0) |
| Columns | 42 (+ 0) |
| Table Rows | 12,476,776 (+ 0) |
| Media | 812.84M (+ 0B) |
| Files | 8,396 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 363 | chengshi_id |
100%
|
| chengshi |
100%
|
||
| category_1_x_ershoufang | 2,646,914 | category_1_id |
100%
|
| ershoufang_id |
100%
|
||
| chengshi | 363 | title |
100%
|
| ershoufang | 2,646,914 | title |
100%
|
| fabu_shijian |
100%
|
||
| jiage |
100%
|
||
| fangwu_miaoshu |
92.71%
|
||
| danjia |
92.45%
|
||
| fangxing |
92.65%
|
||
| xiaoqu_mingzi |
4.18%
|
||
| fangwu_qingkuang |
88.2%
|
||
| dizhi |
92.78%
|
||
| lianxiren |
80.52%
|
||
| lianxi_dianhua |
92.78%
|
||
| tese_biaoqian |
2.31%
|
||
| ershoufang_x_xiangqing_miaoshu | 7,051,836 | ershoufang_id |
100%
|
| xiangqing_miaoshu_id |
100%
|
||
| image | 51,102 | ershoufang_id |
100%
|
| xiangqing_miaoshu | 79,284 | key |
100%
|
| value |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
PROPERTY_IMAGE
| Size (Bytes) | Files |
|---|---|
| 812.84M | 8,396 |

