This is a fields-rich apartment database with 82,664 records for rental from 3,975 cities of 51 states in US. Each record is comprised of title, streetaddress, addresslocality, addressregion, postalcode, latitude, longitude etc. There are 32 apartment feature records, 43 community features, 118,796 floor plans pricing records with bath and bed. It also comes with 81,486 additional feature records of these apartments. In the media set, there are 199.30M apartment images in the database media sets.
The whole US apartment rentals data set consists of 15 tables.
| Name | n3_chennan_house_apartmentguide_com |
|---|---|
| Data | 400.02M (+ 0B) |
| Tables | 15 (+ 0) |
| Columns | 65 (+ 0) |
| Table Rows | 3,010,855 (+ 0) |
| Media | 2.12M (+ 0B) |
| Files | 300 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| additional_feature | 81,486 | value |
100%
|
| apartment | 82,664 | title |
100%
|
| streetaddress |
100%
|
||
| addresslocality |
100%
|
||
| addressregion |
100%
|
||
| postalcode |
100%
|
||
| latitude |
100%
|
||
| longitude |
100%
|
||
| image_url |
35.48%
|
||
| phone |
71.97%
|
||
| apartment_feature | 32 | value |
100%
|
| apartment_x_additional_feature | 534,569 | apartment_id |
100%
|
| additional_feature_id |
100%
|
||
| apartment_x_apartment_feature | 523,220 | apartment_id |
100%
|
| apartment_feature_id |
100%
|
||
| apartment_x_community_feature | 432,392 | apartment_id |
100%
|
| community_feature_id |
100%
|
||
| apartment_x_floor_plans_pricing | 197,807 | apartment_id |
100%
|
| floor_plans_pricing_id |
100%
|
||
| apartment_x_special_feature | 120,840 | apartment_id |
100%
|
| special_feature_id |
100%
|
||
| city | 3,975 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| city_x_apartment | 914,970 | city_id |
100%
|
| apartment_id |
100%
|
||
| community_feature | 43 | value |
100%
|
| floor_plans_pricing | 118,796 | bath_and_bed |
4.39%
|
| price |
84.27%
|
||
| title |
100%
|
||
| special_feature | 10 | value |
100%
|
| state | 51 | 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
APARTMENT_IMAGE
| Size (Bytes) | Files |
|---|---|
| 2.12M | 300 |
