There are 117,636 nail salons over 34,820 cities from 51 states in the America.
It has phone number, address, locality, star, vote, latitude, longitude, general information, other information, email, extra phones, hours, brand and website in each salon record. In the table image, there are 36,377 images and they are keeped in the 5.41M media set.
The whole United States nail salons data set has 6 tables.
| Name | n3_lyz_nail_salon |
|---|---|
| Data | 810.36M (+ 16K) |
| Tables | 6 (+ 0) |
| Columns | 39 (+ 0) |
| Table Rows | 4,361,823 (+ 0) |
| Media | 5.41M (+ 0B) |
| Files | 100 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 34,820 | city |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| city_x_nail_salon | 4,172,939 | city_id |
100%
|
| nail_salon_id |
100%
|
||
| image_slug | 36,377 | nail_salon_id |
100%
|
| nail_salon | 117,636 | title |
100%
|
| phone |
99.98%
|
||
| address |
99.17%
|
||
| locality |
99.48%
|
||
| star |
24.87%
|
||
| vote |
24.87%
|
||
| latitude |
98.87%
|
||
| longitude |
98.87%
|
||
| general_info |
7.64%
|
||
| other_information |
50.81%
|
||
|
30.17%
|
|||
| extra_phones |
19.71%
|
||
| hours |
99.32%
|
||
| brand |
9.66%
|
||
| websit |
44.13%
|
||
| state | 51 | state |
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
IMAGE
| Size (Bytes) | Files |
|---|---|
| 5.41M | 100 |
