This auto part shops database contains 4,404 records with title, telephone, address, location, region post code, latitude and longitude from 2,923 regions of 48 states in the United States. There are 4,402 time records of these auto parts shops data. The whole America auto parts stores data totally has 7 tables.
| Name | n3_lyz_stores.advanceautoparts.com |
|---|---|
| Data | 4.64M (+ 0B) |
| Tables | 7 (+ 0) |
| Columns | 49 (+ 0) |
| Table Rows | 18,263 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| location_shop | 4,404 | shop_idt |
100%
|
| title |
100%
|
||
| telephone |
100%
|
||
| address |
100%
|
||
| location |
100%
|
||
| region |
99.41%
|
||
| post_code |
100%
|
||
| latitude |
100%
|
||
| longitude |
100%
|
||
| region | 2,923 | region |
100%
|
| state_id |
100%
|
||
| region_x_location_shop | 2,322 | region_id |
100%
|
| location_shop_id |
100%
|
||
| state | 48 | state |
100%
|
| sub_region | 2,082 | region_id |
100%
|
| sub_region_x_location_shop | 2,082 | sub_region_id |
100%
|
| location_shop_id |
100%
|
||
| time | 4,402 | monday_end |
100%
|
| monday_start |
100%
|
||
| location_shop_id |
100%
|
||
| tuesday_end |
100%
|
||
| tuesday_start |
100%
|
||
| wednesday_end |
100%
|
||
| wednesday_start |
100%
|
||
| thursday_end |
100%
|
||
| thursday_start |
100%
|
||
| friday_end |
100%
|
||
| friday_start |
100%
|
||
| saturday_end |
99.95%
|
||
| saturday_start |
99.95%
|
||
| sunday_end |
96.34%
|
||
| sunday_start |
96.34%
|
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.
