The stores database has 413 shops from 339 cities of 5 states in America. Each shop consists of latitude, longitude, address, address extend, country, postal code, phone number, store start, store end, pharmacy phone number, pharmacy fax number, pharmacy start, pharmacy end, gas station address, gas station phone number, gas station postal code, gas station latitude, gas station longitude and etc. There are 21 store departments and 35 store services in this data. The whole United States stores data set totally has 8 tables.
| Name | n3_lyz_stopandshop.com |
|---|---|
| Data | 1.81M (+ 80K) |
| Tables | 8 (+ 0) |
| Columns | 73 (+ 0) |
| Table Rows | 8,853 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| city | 339 | title |
100%
|
| state_id |
100%
|
||
| count |
100%
|
||
| city_x_shop | 413 | city_id |
100%
|
| shop_id |
100%
|
||
| shop | 413 | latitude |
100%
|
| longitude |
100%
|
||
| address |
100%
|
||
| address_extend |
100%
|
||
| country |
100%
|
||
| postal_code |
100%
|
||
| phone |
100%
|
||
| store_monday_start |
100%
|
||
| store_monday_end |
100%
|
||
| store_tuesday_start |
100%
|
||
| store_tuesday_end |
100%
|
||
| store_wednesday_start |
100%
|
||
| store_wednesday_end |
100%
|
||
| store_thursday_start |
62.95%
|
||
| store_thursday_end |
62.95%
|
||
| store_friday_start |
100%
|
||
| store_friday_end |
100%
|
||
| store_saturday_start |
100%
|
||
| store_saturday_end |
100%
|
||
| store_sunday_start |
100%
|
||
| store_sunday_end |
100%
|
||
| pharmacy_phone |
61.26%
|
||
| pharmacy_fax |
61.02%
|
||
| pharmacy_monday_start |
62.23%
|
||
| pharmacy_monday_end |
62.23%
|
||
| pharmacy_tuesday_start |
62.23%
|
||
| pharmacy_tuesday_end |
62.23%
|
||
| pharmacy_wednesday_start |
62.23%
|
||
| pharmacy_wednesday_end |
62.23%
|
||
| pharmacy_thursday_start |
62.23%
|
||
| pharmacy_thursday_end |
62.23%
|
||
| pharmacy_friday_start |
62.23%
|
||
| pharmacy_friday_end |
62.23%
|
||
| pharmacy_saturday_start |
62.23%
|
||
| pharmacy_saturday_end |
62.23%
|
||
| pharmacy_sunday_start |
62.23%
|
||
| pharmacy_sunday_end |
62.23%
|
||
| gas_station_phone |
97.09%
|
||
| gas_station_address |
97.09%
|
||
| gas_station_postal_code |
97.09%
|
||
| gas_station_latitude |
97.09%
|
||
| gas_station_longitude |
97.09%
|
||
| shop_x_store_department | 4,207 | shop_id |
100%
|
| store_department_id |
100%
|
||
| shop_x_store_service | 3,420 | shop_id |
100%
|
| store_service_id |
100%
|
||
| state | 5 | title |
100%
|
| store_department | 21 | store_department |
100%
|
| store_service | 35 | store_service |
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.
