There are 6,133 apartments records from 70 popular locations in the United States. Each apartment record is comprised of title, description, street address, address locality, address region and postal code. Beside, it includes feature amenity with 16,795 records, list price with 4,910 records, 421 office hour records and pet policy with 4,431 records. It also comes with 71,428 images of these apartments in this database.
The whole America apartments for rent database consists of 13 tables.
| Name | n3_chennan_apartment_apartmentsearch_com |
|---|---|
| Data | 60.98M (+ 0B) |
| Tables | 13 (+ 0) |
| Columns | 52 (+ 0) |
| Table Rows | 200,652 (+ 0) |
| Media | 19.03M (+ 0B) |
| Files | 300 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| apartment | 6,133 | title |
100%
|
| description |
99.56%
|
||
| street_address |
99.59%
|
||
| address_locality |
99.59%
|
||
| address_region |
99.59%
|
||
| postal_code |
99.59%
|
||
| apartment_x_feature_amenity | 31,040 | apartment_id |
100%
|
| feature_amenity_id |
100%
|
||
| apartment_x_list_price | 15,539 | apartment_id |
100%
|
| list_price_id |
100%
|
||
| apartment_x_office_hour | 17,973 | apartment_id |
100%
|
| office_hour_id |
100%
|
||
| apartment_x_pet_policy | 25,768 | apartment_id |
100%
|
| pet_policy_id |
100%
|
||
| category_1 | 70 | title |
100%
|
| category_1_x_apartment | 6,144 | category_1_id |
100%
|
| apartment_id |
100%
|
||
| feature_amenity | 16,795 | value |
99.99%
|
| image | 71,428 | apartment_id |
100%
|
| list_price | 4,910 | value |
100%
|
| office_hour | 421 | value |
100%
|
| key |
100%
|
||
| pet_policy | 4,431 | 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
APARTMENT_IMAGE
| Size (Bytes) | Files |
|---|---|
| 19.03M | 300 |
