In the McDonald's locations database, there are 13,315 records from 53 regions in China. Each record is comprised of latitude, longitude, description, address, postcode, telephone number, job url, long description, monday, tuesday, wednesday, thursday, friday, saturday, sunday, drive hours monday, drive hours tuesday, drive hours wednesday, drive hours thursday, drive hours friday, drive hours saturday and drive hours sunday. The whole McDonald's location data set totally has 3 tables.
| Name | n3_lyz_mcdonalds_location |
|---|---|
| Data | 11.44M (+ 4.45M) |
| Tables | 3 (+ 0) |
| Columns | 35 (+ 0) |
| Table Rows | 26,683 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| location_info | 13,315 | latitude |
100%
|
| longitude |
100%
|
||
| description |
0%
|
||
| address_1 |
100%
|
||
| address_2 |
100%
|
||
| address_3 |
100%
|
||
| address_4 |
100%
|
||
| postcode |
100%
|
||
| telephone |
100%
|
||
| job_url |
0%
|
||
| long_description |
0%
|
||
| monday |
99.96%
|
||
| tuesday |
99.96%
|
||
| wednesday |
99.96%
|
||
| thursday |
99.96%
|
||
| friday |
99.96%
|
||
| saturday |
99.96%
|
||
| sunday |
99.96%
|
||
| drive_hours_monday |
99.96%
|
||
| drive_hours_tuesday |
99.96%
|
||
| drive_hours_wednesday |
99.96%
|
||
| drive_hours_thursday |
99.96%
|
||
| drive_hours_friday |
99.96%
|
||
| drive_hours_saturday |
99.96%
|
||
| drive_hours_sunday |
99.96%
|
||
| location_info_x_region | 13,315 | region_id |
100%
|
| location_info_id |
100%
|
||
| region | 53 | region |
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.
