In the property for sale database, there are 259,644 records from 287 areas of 9 provinces (Gauteng, Western Cape, KwaZulu Natal, North West, Mpumalanga, Eastern Cape, Limpopo, Free State & Northern Cape) in the South Africa. Each record is comprised of title, price, description, bathroom, bedroom, latitude, longitude and etc. There are 375 features of these property in this data. The South Africa property database also has 3,890,241 property images with URL.
There are 8 tables in the whole South Africa property for sale database.
| Name | n3_chennan_house_privateproperty_co_za_sale |
|---|---|
| Data | 1.52G (+ 0B) |
| Tables | 8 (+ 0) |
| Columns | 43 (+ 0) |
| Table Rows | 6,759,688 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| area | 287 | title |
100%
|
| province |
100%
|
||
| province_id |
100%
|
||
| area_x_property | 259,644 | area_id |
100%
|
| property_id |
100%
|
||
| feature | 375 | key |
100%
|
| value |
86.93%
|
||
| image | 3,890,241 | image_url |
100%
|
| property_id |
100%
|
||
| property | 259,644 | title |
100%
|
| description |
98.1%
|
||
| price |
100%
|
||
| bedroom |
84.16%
|
||
| bathroom |
84.35%
|
||
| address |
27.98%
|
||
| floor_area |
49.86%
|
||
| rate |
59.78%
|
||
| land_area |
68.61%
|
||
| levy |
35.2%
|
||
| latitude |
98.24%
|
||
| longitude |
98.24%
|
||
| property_x_feature | 2,349,488 | property_id |
100%
|
| feature_id |
100%
|
||
| province | 9 | title |
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 |
|---|---|
| 0P | 0 |
