This is a most comprehensive real estates database of the world. There are 717,641 properties records over 20,944 popular cities from 1,499 states of 71 countries in the world. Each record is comprised of address, price, description, property id and phone number. In the whole real estates data, there are 4 tables related with the properties, they are 604,673 basic information records, 55 exterior feature records, 66 interior feature records and 36,788 nearby school records with type. The worldwide properties data also comes with 3,172,720 properties images in the 279.57K media sets. There are 15 tables in the whole world properties data set.
| Name | n3_chennan_house_realestate_com_au |
|---|---|
| Data | 2.37G (+ 0B) |
| Tables | 15 (+ 0) |
| Columns | 66 (+ 0) |
| Table Rows | 10,754,109 (+ 0) |
| Media | 279.57K (+ 0B) |
| Files | 100 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| basic_info | 604,673 | key |
100%
|
| value |
100%
|
||
| city | 20,944 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| city_x_property | 734,837 | city_id |
100%
|
| property_id |
100%
|
||
| country | 71 | title |
100%
|
| exterior_feature | 55 | key |
100%
|
| value |
58.18%
|
||
| image | 3,172,720 | image_url |
100%
|
| property_id |
100%
|
||
| interior_feature | 66 | key |
100%
|
| value |
65.15%
|
||
| nearby_school | 36,788 | school_name |
100%
|
| school_type |
100%
|
||
| property | 717,641 | address |
100%
|
| price |
92.33%
|
||
| description |
78.69%
|
||
| property_id |
81.54%
|
||
| phone |
46.5%
|
||
| property_x_basic_info | 3,875,970 | property_id |
100%
|
| basic_info_id |
100%
|
||
| property_x_exterior_feature | 440,585 | property_id |
100%
|
| exterior_feature_id |
100%
|
||
| property_x_interior_feature | 315,168 | property_id |
100%
|
| interior_feature_id |
100%
|
||
| property_x_nearby_school | 833,092 | property_id |
100%
|
| nearby_school_id |
100%
|
||
| state | 1,499 | title |
100%
|
| country |
100%
|
||
| country_id |
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 |
|---|---|
| 279.57K | 100 |
