In the car part location database, there are 2,149 records with street address, city, state, postal code, telephone number, description, latitude and longitude in each. All these auto part locations are from 3,067 cities of 52 states in America. Besides, there are 144 hour records and service with 4 records for these car part locations. The whole United States auto part locations data set has 8 tables in total.
| Name | n3_chennan_car_part_location_autozone_com |
|---|---|
| Data | 7.39M (+ 0B) |
| Tables | 8 (+ 0) |
| Columns | 44 (+ 0) |
| Table Rows | 28,702 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| car_part_location | 2,149 | title |
100%
|
| street_address |
100%
|
||
| city |
100%
|
||
| state |
99.44%
|
||
| postal_code |
100%
|
||
| telephone |
100%
|
||
| description |
96.88%
|
||
| latitude |
96.88%
|
||
| longitude |
96.88%
|
||
| car_part_location_x_hour | 14,553 | car_part_location_id |
100%
|
| hour_id |
100%
|
||
| car_part_location_x_service | 6,584 | car_part_location_id |
100%
|
| service_id |
100%
|
||
| city | 3,067 | title |
100%
|
| state_id |
100%
|
||
| state |
100%
|
||
| city_x_car_part_location | 2,149 | city_id |
100%
|
| car_part_location_id |
100%
|
||
| hour | 144 | key |
100%
|
| value |
100%
|
||
| service | 4 | key |
100%
|
| value |
100%
|
||
| state | 52 | 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.
