Global McDonalds Ice Cream Machine Downtime

Columns

• lat: Represents the latitude coordinate, detailing the geographical position of the machine. Valid range observed from -159.37 to 15.
• lon: Represents the longitude coordinate, providing the geographical position. Valid range observed from 19.5 to 64.9.
• alt: Stands for altitude. All entries in this column are recorded as 0.
• is_broken: A boolean field indicating whether the ice cream machine is currently broken. Approximately 11% of the entries show machines as broken, while 89% are not.
• is_active: A boolean field denoting if the machine is active. The majority, 98%, are active, with 2% inactive.
• dot: Describes the status of the machine. The most frequent status is 'working' (87%), followed by 'broken' (11%), with a small percentage categorised as 'Other'.
• state: The state or region where the machine is located. This column has some missing values (24%), and 'CA' is the most commonly occurring state. There are 52 unique state values.
• city: Indicates the city of the machine's location. There are almost 6,700 unique city values, with 'Houston' appearing most frequently.
• street: The street address of the machine. This column contains over 16,600 unique street names, with 'London Road' being a frequently occurring entry.
• country: Specifies the country of the machine. The 'USA' accounts for the largest share of entries (76%), followed by 'CA' (8%). There are 4 unique country values in total.
• last_checked: Provides a timestamp of when the machine's status was last verified. This column displays a variety of timestamps, with 'Checked 32 minutes ago' and 'Checked 15 minutes ago' being common.

Distribution

Usage

• Comparing complaint volumes and patterns across different global regions.
• Investigating potential correlations between reported machine breakdowns and temperature fluctuations.
• Identifying specific periods or times of day when complaints are most frequent.
• Analysing how the number of complaints changes and evolves over time.
• Pinpointing particular locations that experience a higher incidence of broken ice cream machines.

Coverage

License

Who Can Use It

• Researchers and Data Analysts: To conduct in-depth studies on equipment reliability, geographical complaint distributions, and temporal trends in operational issues.
• Business Intelligence Professionals: To gain insights into global operational challenges for large retail or food service chains, aiding strategic decision-making and resource allocation.
• Software Developers and Data Scientists: For building applications that monitor equipment status, developing predictive models for machine failures, or creating visual dashboards for operational oversight.

Dataset Name Suggestions

• Global McDonald's Ice Cream Machine Downtime
• McBroken World Status Tracker
• McDonald's Soft Serve Faults - Timeseries
• Worldwide Fast Food Equipment Reliability
• Hourly Ice Cream Machine Global Complaints

Attributes