Public Wi-Fi Incident Event Log
This dataset provides detailed event logs of incidents occurring on municipally-operated public Wi-Fi networks, including incident types, severity, affected locations, device information, and response actions. It enables smart city teams to monitor network health, analyze security trends, and evaluate response protocols, supporting both operational management and strategic network improvements.
Sample rows
preview · 8 of 85 rows · all 23 columns| incident_idstring | incident_statusstring | downtime_minutesfloat | location_statestring | event_timestampdatetime | network_idstring | network_namestring | location_namestring | location_street_addressstring | location_citystring | location_postal_codestring | location_countrystring | incident_typestring | incident_severitystring | reported_bystring | user_device_macstring | user_device_typestring | user_ip_addressstring | actions_takenstring | resolved_timestampdatetime | response_time_minutesfloat | affected_users_countinteger | descriptionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INC00001 | investigating | 0 | IL | 2024-06-03T09:12:00 | WIFI-001 | Central Park WiFi | Central Park | 123 Park Ave | Springfield | 62701 | USA | connectivity_issue | medium | user_report | 7A:2B:4C:9F:1D:02 | smartphone | 192.168.1.45 | Network diagnostics initiated, user notified. | blank | 12 | 7 | User unable to connect to WiFi near playground. Signal appears weak. |
| INC00002 | escalated | 20 | IL | 2024-06-03T10:07:43 | WIFI-002 | Library Public WiFi | Downtown Library | 456 Main St | Springfield | 62702 | USA | security_threat | high | automated_monitoring | BD:33:FA:7E:91:AC | laptop | 10.0.0.88 | Traffic isolated, security team notified. | blank | 5.5 | 3 | Unusual network traffic detected, possible malware communication. |
| INC00003 | resolved | 2 | OH | 2024-06-03T11:22:15 | WIFI-003 | Transit WiFi | Union Station | 789 Transit Blvd | Columbus | 43215 | USA | bandwidth_abuse | medium | automated_monitoring | 8C:55:2D:4B:1E:FF | tablet | 10.10.10.102 | Bandwidth limited, user notified. | 2024-06-03T12:00:55 | 7 | 12 | High bandwidth usage detected, streaming services. |
| INC00004 | closed | 0 | WI | 2024-06-03T13:04:10 | WIFI-004 | City Hall WiFi | City Hall | 101 Civic Center | Madison | 53703 | USA | device_blocked | low | staff_observation | 45:EF:12:46:89:DA | IoT_device | 172.16.0.44 | Device blocked, log updated. | 2024-06-03T13:20:10 | 10 | 1 | Unauthorized IoT device detected and blocked. |
| INC00005 | open | 0 | WI | 2024-06-03T14:15:22 | WIFI-005 | Riverside WiFi | Riverside Park | 202 River Rd | Madison | 53704 | USA | connectivity_issue | medium | user_report | F3:9D:3B:22:44:0A | smartphone | 192.168.1.67 | Network scan scheduled. | blank | 15 | 4 | Spotty connectivity reported in the north picnic area. |
| INC00006 | investigating | 0 | OH | 2024-06-03T15:08:16 | WIFI-006 | Community Center WiFi | Eastside Community Center | 303 Center St | Columbus | 43216 | USA | content_violation | high | external_alert | blank | unknown | blank | Content filter reviewed, staff notified. | blank | 20 | 1 | External agency flagged inappropriate content access. |
| INC00007 | resolved | 15 | OH | 2024-06-03T16:40:57 | WIFI-007 | Transit WiFi | Union Station | 789 Transit Blvd | Columbus | 43215 | USA | connectivity_issue | low | staff_observation | blank | unknown | blank | Maintenance completed. | 2024-06-03T16:55:10 | 2 | 8 | Brief network downtime during scheduled maintenance. |
| INC00008 | escalated | 60 | WI | 2024-06-03T18:02:34 | WIFI-008 | City Hall WiFi | City Hall | 101 Civic Center | Madison | 53703 | USA | security_threat | critical | automated_monitoring | 72:AA:5F:99:04:CB | laptop | 172.16.0.55 | Admin access blocked, incident escalated. | blank | 4 | 2 | Detected brute-force login attempt on admin portal. |
| INC00009 | closed | 7 | IL | 2024-06-03T19:13:05 | WIFI-009 | Library Public WiFi | Downtown Library | 456 Main St | Springfield | 62702 | USA | connectivity_issue | low | user_report | blank | smartphone | blank | Network reboot performed. | 2024-06-03T19:20:05 | 3 | 5 | Short-lived dropped connections on second floor. |
| INC00010 | resolved | 0 | IL | 2024-06-04T08:10:22 | WIFI-001 | Central Park WiFi | Central Park | 123 Park Ave | Springfield | 62701 | USA | device_blocked | medium | automated_monitoring | B6:07:4A:2E:19:FA | IoT_device | 192.168.1.99 | Device MAC added to block list. | 2024-06-04T08:45:00 | 8 | 1 | Device attempting repeated unauthorized access blocked. |
| INC00011 | investigating | 2 | IL | 2024-06-04T09:02:00 | WIFI-002 | Library Public WiFi | Downtown Library | 456 Main St | Springfield | 62702 | USA | bandwidth_abuse | medium | automated_monitoring | E2:23:3D:8C:77:AF | laptop | 10.0.0.101 | Bandwidth throttled for affected users. | blank | 6.5 | 11 | Multiple users streaming large files, bandwidth spikes noted. |
| INC00012 | open | 16 | WI | 2024-06-04T10:18:15 | WIFI-005 | Riverside WiFi | Riverside Park | 202 River Rd | Madison | 53704 | USA | security_threat | high | automated_monitoring | F8:2C:9B:3E:55:1D | laptop | 192.168.1.23 | Connection blocked, alert sent to admin. | blank | 4 | 2 | Attempted connection to blacklisted IP detected. |
| INC00013 | resolved | 18 | OH | 2024-06-04T11:00:00 | WIFI-006 | Community Center WiFi | Eastside Community Center | 303 Center St | Columbus | 43216 | USA | connectivity_issue | low | user_report | blank | tablet | blank | Router reset performed. | 2024-06-04T11:30:00 | 9 | 9 | Slow network speeds, resolved after router reset. |
| INC00014 | closed | 0 | OH | 2024-06-04T12:11:45 | WIFI-007 | Transit WiFi | Union Station | 789 Transit Blvd | Columbus | 43215 | USA | content_violation | medium | staff_observation | blank | smartphone | blank | User access restricted. | 2024-06-04T12:30:19 | 11 | 1 | Staff observed user accessing blocked adult content. |
| INC00015 | resolved | 0 | WI | 2024-06-04T13:35:10 | WIFI-008 | City Hall WiFi | City Hall | 101 Civic Center | Madison | 53703 | USA | other | low | external_alert | blank | unknown | blank | Configuration updated. | 2024-06-04T14:05:00 | 14 | 0 | Minor configuration error flagged by external audit. |
| INC00016 | open | 0 | WI | 2024-06-04T14:22:33 | WIFI-004 | City Hall WiFi | City Hall | 101 Civic Center | Madison | 53703 | USA | connectivity_issue | medium | user_report | 5B:7C:4A:8D:63:FE | tablet | 192.168.2.88 | Network team dispatched. | blank | 16 | 6 | Multiple users reported dropped connections in council chamber. |
| INC00017 | escalated | 0 | OH | 2024-06-04T15:40:02 | WIFI-003 | Transit WiFi | Union Station | 789 Transit Blvd | Columbus | 43215 | USA | device_blocked | critical | automated_monitoring | A2:99:33:BD:18:5E | IoT_device | 10.10.10.221 | Device MAC blocked, incident escalated. | blank | 3 | 1 | Device flagged for persistent unauthorized activity. |
| INC00018 | escalated | 55 | OH | 2024-06-04T16:55:30 | WIFI-007 | Transit WiFi | Union Station | 789 Transit Blvd | Columbus | 43215 | USA | security_threat | critical | external_alert | blank | unknown | blank | Security protocols updated, monitoring increased. | blank | 2.5 | 5 | External agency reported network scan by unknown entity. |
| INC00019 | resolved | 1 | WI | 2024-06-05T08:15:12 | WIFI-005 | Riverside WiFi | Riverside Park | 202 River Rd | Madison | 53704 | USA | bandwidth_abuse | medium | user_report | C1:DE:22:43:55:BF | tablet | 192.168.1.111 | Affected accounts bandwidth limited. | 2024-06-05T08:32:00 | 6.5 | 7 | User reported network slowdowns due to excessive downloading. |
| INC00020 | closed | 10 | IL | 2024-06-05T09:50:00 | WIFI-002 | Library Public WiFi | Downtown Library | 456 Main St | Springfield | 62702 | USA | connectivity_issue | low | staff_observation | blank | laptop | blank | Access point rebooted. | 2024-06-05T10:15:00 | 5 | 6 | Intermittent connection issues on third floor, resolved after AP reboot. |
What the 85 rows show
from the 85-row sampleEscalated (incident status) stands out: mean downtime_
- 0.0median downtime_
minutes - 4location countries
- 4incident severities
- 4reported_
by values - 5user device types
- 6incident types
Median 0.0, from 0.0 to 70.0.
- string 18
- integer 1
- float 2
- datetime 2
Columns
23 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 18 columns | |||
incident_id | string | Unique identifier for the incident event.unique | INC00001 |
network_id | string | Unique identifier of the public Wi-Fi network where the incident occurred. | WIFI-001 |
network_name | string | Human-readable name of the Wi-Fi network. | Central Park WiFi |
location_name | string | Name or description of the physical location (e.g., park, library, transit station) where the network is deployed. | Central Park |
location_street_address | string | Street address of the incident location.optional | 123 Park Ave |
location_city | string | City where the incident occurred.11 cities | Springfield |
location_state | string | State or province of the incident location.9 states · optional | IL |
location_postal_code | string | Postal or ZIP code of the incident location.optional | 62701 |
location_country | string | Country where the incident occurred.4 countries | USA |
incident_type | string | Category of incident (e.g., connectivity_issue, security_threat, content_violation, device_blocked, bandwidth_abuse).6 values | connectivity_issue |
incident_severity | string | Severity level of the incident (e.g., low, medium, high, critical).low · medium · high · critical | medium |
incident_status | string | Current status of the incident (e.g., open, investigating, resolved, closed, escalated).open · investigating · resolved · closed · escalated | investigating |
reported_by | string | Source of the incident report (e.g., automated_monitoring, user_report, staff_observation, external_alert).4 values | user_report |
user_device_mac | string | MAC address of the user device involved in the incident (if applicable).optional | 7A:2B:4C:9F:1D:02 |
user_device_type | string | Type of user device involved (e.g., smartphone, laptop, tablet, IoT_device).smartphone · laptop · tablet · IoT_device · unknown · optional | smartphone |
user_ip_address | string | IP address assigned to the user device during the incident (if applicable).optional | 192.168.1.45 |
description | string | Detailed description of the incident, including observed symptoms and context.optional | User unable to connect to… |
actions_taken | string | Actions taken in response to the incident (e.g., device blocked, bandwidth limited, user notified, escalated to security team).optional | Network scan scheduled. |
| Numbers 3 columns | |||
response_time_minutes | float | Time in minutes between incident detection and first response action.0 or more · optional | 12 |
downtime_minutes | float | Total duration in minutes that the network or affected service was unavailable due to the incident.0 or more · optional | 0 |
affected_users_count | integer | Estimated number of users affected by the incident.0 or more · optional | 7 |
| Dates and times 2 columns | |||
event_timestamp | datetime | Date and time when the incident was detected or reported. | 2024-06-03T09:12:00 |
resolved_timestamp | datetime | Date and time when the incident was resolved or closed.optional | 2024-06-03T12:00:55 |
Use it for
A technology dashboard
Downtime_
minutes by incident_ status and a breakdown of location_ state. Excel, Power BI or Tableau. Why do the 12 escalated rows have a mean downtime_
minutes of 37.2? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Incidents85INC000010investig…INC0000220escalatedINC000032resolved
A software demo
Believable incidents with event_
timestamp, network_ id and network_ name to fill a screen in front of a buyer.
This dataset85 rows23 columns
Yours10,000 rows23 columnslocation_name: UK only
blueprint · public-wi-fi-incident-event-log
Behind this dataset
Same schema. As many rows as you need.
These 85 rows came out of a blueprint — 23 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
Rules it was built with
- Each event is tied to a unique network hotspot ID.
- Incident types include unauthorized access, bandwidth abuse, hardware malfunction, and suspected malware.
- Severity levels are categorized as Low, Medium, or High.
- Resolution timestamps are only present if status is 'Resolved'.
- Repeat incidents at the same hotspot must show escalation in severity if unresolved after 2 events.
Open the blueprint in Data Factory
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- public-wi-fi-incident-event-log