In the flower shops database, there are 10,975 records with title, address, hours, services, additional floral products and services, toll free phone, local phone number, fax number and average rating in each from 19,412 cities of 53 states in America. It contians 158.28M flower shops images in the media file. The whole United States flower shops totally has 5 tables.
| Name | n3zm_Flower_Shop_flowershopnetwork_com |
|---|---|
| Data | 37.23M (+ 0B) |
| Tables | 5 (+ 0) |
| Columns | 28 (+ 0) |
| Table Rows | 79,569 (+ 0) |
| Media | 32.24M (+ 0B) |
| Files | 1,500 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 19,412 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| city_x_flower_shop | 49,129 | city_id |
100%
|
| flower_shop_id |
100%
|
||
| flower_shop | 10,975 | title |
96.91%
|
| address |
100%
|
||
| hours |
88.19%
|
||
| services |
97.52%
|
||
| additional_floral_products_and_services |
97.52%
|
||
| toll_free_phone |
35.3%
|
||
| local_phone |
99.99%
|
||
| fax |
34.72%
|
||
| avg_rating |
78.41%
|
||
| state | 53 | 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
FLOWER_SHOP_IMAGE_DOWNLOAD
| Size (Bytes) | Files |
|---|---|
| 32.24M | 1,500 |
