In the assisted living database, there are a total of 11,967 assisted living residences throughout 4,205 popular cities of 56 states in America. Each assisted living residence is comprised of title, description, telephone number, latitude, longitude, rating, street address, address locality, address region and postal code. The whole United States assisted living data set has 6 tables.
| Name | n3_chennan_assisted_living_aplaceformom_com |
|---|---|
| Data | 55.36M (+ 0B) |
| Tables | 6 (+ 0) |
| Columns | 36 (+ 0) |
| Table Rows | 291,478 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| amenity | 12 | value |
100%
|
| assisted_living | 11,967 | title |
100%
|
| description |
93.26%
|
||
| telephone |
100%
|
||
| latitude |
100%
|
||
| longitude |
100%
|
||
| rating |
73.34%
|
||
| street_address |
100%
|
||
| address_locality |
100%
|
||
| address_region |
100%
|
||
| postal_code |
100%
|
||
| assisted_living_x_amenity | 79,147 | assisted_living_id |
100%
|
| amenity_id |
100%
|
||
| city | 4,205 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| city_x_assisted_living | 196,091 | city_id |
100%
|
| assisted_living_id |
100%
|
||
| state | 56 | 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
No media sets.
