Technology
23 columns
127 rows
8 formats

Smart City Technology Failure Logs

This dataset provides granular logs of smart city technology failures, including device details, failure types, geolocation, severity, resolution status, and downtime. It enables city planners and technologists to monitor infrastructure health, prioritize maintenance, analyze root causes, and enhance urban resilience through data-driven decision making.

last updated 13 Jan 2026
by GoMask

The brief that made it

Prioritizing urban technology maintenance and repairs

Sample rows

preview · 8 of 127 rows · all 23 columns

failure_idstring	device_typestring	downtime_minutesinteger	maintenance_team_idstring	device_idstring	system_namestring	failure_datetimedatetime	failure_typestring	failure_severitystring	location_street_addressstring	location_citystring	location_statestring	location_postal_codestring	location_countrystring	latitudefloat	longitudefloat	reported_bystring	resolution_statusstring	resolution_datetimedatetime	affected_servicesstring	failure_descriptionstring	resolution_descriptionstring	root_causestring
SIG-4912_R	traffic_signal	322	MT-02	SIG-4821	SmartTraffic	2024-05-14T09:17:00Z	power	critical	1520 Main St	Dallas	TX	75201	USA	32.7792	-96.8008	system_alert	resolved	2024-05-14T14:39:00Z	traffic_management, emergency_services	Citywide traffic signal outage due to transformer malfunction during morning rush hour.	Replaced faulty transformer and restored power to the intersection.	Transformer short-circuit caused widespread device failure.
CAM-X8325B	iot_camera	48	blank	CAM-8325	CityWatch	2024-04-18T20:04:00Z	connectivity	minor	930 Border Ave	Tijuana	BCN	22010	Mexico	32.5252	-117.0362	operator_cam02	open	blank	border_surveillance, security	Border surveillance camera intermittently lost connection to the network.	blank	blank
SS-7918_X	smart_sensor	1109	MT-07	SS-7918	EnviroNet	2024-03-23T13:56:00Z	hardware	major	298 King St	Newcastle	NSW	2300	Australia	-32.9267	151.7817	system_alert	resolved	2024-03-24T09:15:00Z	air_quality_monitoring, public_health	Air quality smart sensor reported abnormally high PM2.5 readings due to sensor miscalibration.	Recalibrated air quality sensor and verified correct readings.	Sensor miscalibration following firmware update.
EM-4039_U	environmental_monitor	0	blank	EM-4039	AquaTrack	2024-06-01T03:48:00Z	environmental	informational	17 Fjord Rd	Longyearbyen	Svalbard	9170	Norway	78.2232	15.6469	system_auto_check	closed	2024-06-01T04:03:00Z	water_quality, environmental_monitoring	Remote water quality monitor detected temporary turbidity spike due to rainfall.	No action needed, readings normalized after precipitation event.	Heavy rainfall caused temporary water turbidity spike.
LC-9823C_T	lighting_controller	141	MT-05	LC-9823	LightCity	2024-04-11T18:24:00Z	software	major	48 Rue Saint-Paul	Montreal	QC	H2Y 1H2	Canada	45.5088	-73.5617	operator_lc03	resolved	2024-04-11T20:45:00Z	street_lighting, public_safety	Lighting controller failed to update schedule, resulting in street lights remaining off after sunset.	Controller firmware was rolled back and schedule applied.	Software bug in latest controller release.
OTH-3091-D	other	19	blank	OTH-3091	GreenNet	2024-05-30T11:21:00Z	unknown	minor	6122 Oak Lane	Birmingham	ENG	B20 2HT	UK	52.4862	-1.8904	operator_misc	in_progress	blank	park_monitoring	Unclassified device failed to report status during scheduled polling.	blank	blank
SIG-4987_L	traffic_signal	325	MT-04	SIG-4987	SmartTraffic	2024-05-21T15:34:00Z	hardware	critical	8431 Elm St	London	ENG	W1A 6US	UK	51.5074	-0.1278	system_alert	resolved	2024-05-21T20:59:00Z	traffic_management, emergency_services	Intersection signal failed due to damaged relay, causing major traffic delays.	Relay replaced and traffic signal tested for correct operation.	Relay burned out due to excess voltage.
CAM-9145E	iot_camera	62	blank	CAM-9145	CityWatch	2024-06-03T07:27:00Z	software	minor	1129 Mission St	San Francisco	CA	94103	USA	37.7749	-122.4194	operator_cam04	open	blank	security, surveillance	Camera firmware update failed, causing video stream interruptions.	blank	blank
EM-1129_M	environmental_monitor	0	blank	EM-1129	EnviroNet	2024-04-04T00:50:00Z	software	informational	23 Calle Mitre	Ushuaia	TDF	9410	Argentina	-54.8019	-68.303	system_auto_check	closed	2024-04-04T03:30:00Z	environmental_monitoring, water_quality	Remote monitor reported firmware version mismatch but continued functional.	Logged firmware mismatch for future update.	Firmware not updated during last maintenance cycle.
LC-2481B_J	lighting_controller	102	MT-10	LC-2481	LightCity	2024-03-22T21:19:00Z	power	major	34 O'Connell St	Dublin	Leinster	D01 H6K0	Ireland	53.3498	-6.2603	operator_lc02	resolved	2024-03-22T23:01:00Z	street_lighting, public_safety	Street lighting controller lost power during unexpected grid fluctuation.	Power restored after grid stabilization.	Grid instability from external supplier.
SS-5093Q_P	smart_sensor	609	MT-08	SS-5093	EnviroNet	2024-05-08T11:24:00Z	software	major	201 Kira Rd	Kampala	Central	256	Uganda	0.3476	32.5825	system_alert	resolved	2024-05-08T21:33:00Z	air_quality_monitoring, public_health	Environmental sensor failed to report temperature due to software crash.	Rebooted sensor and applied patch for stability.	Memory leak in sensor software.
CAM-7741F	iot_camera	53	blank	CAM-7741	CityWatch	2024-03-14T14:11:00Z	connectivity	minor	19 Rue de Rivoli	Paris	IDF	75001	France	48.8566	2.3522	operator_cam06	open	blank	security, surveillance	Camera at metro entrance unable to connect to video server intermittently.	blank	blank
SIG-3001H_S	traffic_signal	506	MT-06	SIG-3001	SmartTraffic	2024-06-04T07:13:00Z	environmental	critical	1000 Orchard Ave	Singapore	SG	238801	Singapore	1.3521	103.8198	system_alert	resolved	2024-06-04T15:39:00Z	traffic_management, emergency_services	Traffic signal controller flooded during overnight rainstorm.	Controller replaced and additional waterproofing installed.	Flood caused by blocked drainage.
LC-5112M_W	lighting_controller	198	MT-09	LC-5112	LightCity	2024-04-17T22:51:00Z	power	major	1 Skólavörðustígur	Reykjavik	Höfuðborgarsvæði	101	Iceland	64.1466	-21.9426	operator_lc08	resolved	2024-04-18T02:09:00Z	street_lighting, public_safety	Lighting controller outage after substation failure during evening hours.	Substation repaired and controller reset.	Transformer malfunction in substation.
SS-6129A_K	smart_sensor	988	MT-01	SS-6129	EnviroNet	2024-05-19T16:11:00Z	hardware	major	17 Market St	Kampala	Central	256	Uganda	0.3476	32.5825	system_alert	resolved	2024-05-20T08:44:00Z	air_quality_monitoring, public_health	Smart sensor failed to transmit air quality data due to antenna damage.	Antenna replaced, sensor connectivity restored.	Physical damage to sensor antenna from wildlife.
EM-7762_G	environmental_monitor	0	blank	EM-7762	AquaTrack	2024-04-30T05:28:00Z	environmental	informational	22 Glacier Rd	Nuuk	Kommuneqarfik Sermersooq	3900	Greenland	64.1835	-51.7216	system_auto_check	closed	2024-04-30T08:00:00Z	water_quality, environmental_monitoring	Glacier runoff monitor detected brief pH change after snowmelt.	Environmental readings normalized after snowmelt.	Seasonal glacier runoff.
CAM-3228Z	iot_camera	58	blank	CAM-3228	CityWatch	2024-05-15T11:09:00Z	hardware	minor	8724 Fishermans Wharf	San Francisco	CA	94133	USA	37.808	-122.4177	operator_cam01	open	blank	surveillance, security	Camera housing cracked, leading to moisture intrusion and video loss.	blank	blank
SIG-2764R_G	traffic_signal	698	MT-03	SIG-2764	SmartTraffic	2024-06-02T16:42:00Z	hardware	critical	600 N Michigan Ave	Chicago	IL	60611	USA	41.8925	-87.6247	system_alert	resolved	2024-06-03T07:20:00Z	traffic_management, emergency_services	Major traffic signal failure at busy downtown intersection.	Signal controller replaced and tested.	Controller failure from overheating.
LC-9017N_C	lighting_controller	63	MT-10	LC-9017	LightCity	2024-05-02T19:56:00Z	software	minor	14 Rue de la Commune	Montreal	QC	H2Y 2C6	Canada	45.5072	-73.5541	operator_lc07	in_progress	blank	street_lighting	Street lights failed to dim during scheduled night mode.	blank	blank
SS-4822V_B	smart_sensor	1078	MT-02	SS-4822	EnviroNet	2024-03-28T14:59:00Z	hardware	major	88 Main St	Newcastle	NSW	2300	Australia	-32.9275	151.7752	system_alert	resolved	2024-03-29T09:17:00Z	air_quality_monitoring, public_health	Sensor reported no readings for 18 hours due to battery failure.	Battery replaced and sensor recalibrated.	Battery reached end-of-life.

What the 127 rows show

from the 127-row sample

Smart_sensor (device type) stands out: mean downtime_minutes is 587.1, against 147.8 for the rest.

120median downtime_minutes
4failure severities
4resolution statuses
6failure types
8system names
18location countries

Mean downtime_minutes by device_type127 rows

downtime_minutes127 rows, in bands of 200

Median 120, from 0 to 1,420.

maintenance_team_id71 rows with a value · 56 left blank

MT-019
MT-028
MT-058
MT-068
MT-077
MT-087
MT-037
MT-046
MT-096
MT-105

23 columns by typefrom the column list below

string 18
integer 1
float 2
datetime 2

Columns

23 columns in three groups

blueprint · 23 columns
column	type	description	example
Text 18 columns
`failure_id`	string	Unique identifier for each technology failure eventunique	SIG-4912_R
`device_id`	string	Unique identifier for the device or sensor that failed	SIG-4821
`device_type`	string	Type of device (e.g., smart sensor, IoT camera, traffic signal)6 values	traffic_signal
`system_name`	string	Name of the connected system or platform the device belongs to8 names	SmartTraffic
`failure_type`	string	Category of failure (e.g., hardware, software, connectivity, power)6 values	power
`failure_severity`	string	Severity level of the failurecritical · major · minor · informational	critical
`failure_description`	string	Detailed description of the failure eventoptional	Citywide traffic signal o…
`location_street_address`	string	Street address where the failure occurredoptional	1520 Main St
`location_city`	string	City where the failure occurred	Dallas
`location_state`	string	State or region where the failure occurred	TX
`location_postal_code`	string	Postal code of the failure locationoptional	75201
`location_country`	string	Country of the failure location	USA
`reported_by`	string	Name or identifier of the person/system that reported the failureoptional	system_alert
`maintenance_team_id`	string	Identifier for the maintenance team assigned to resolve the failure10 teams · optional	MT-02
`resolution_status`	string	Current status of the failure resolutionopen · in_progress · resolved · closed · escalated	resolved
`resolution_description`	string	Details about how the failure was resolvedoptional	Replaced faulty transform…
`root_cause`	string	Identified root cause of the failureoptional	Seasonal glacier runoff.
`affected_services`	string	Comma-separated list of city services impacted by the failureoptional	park_monitoring
Numbers 3 columns
`latitude`	float	Latitude coordinate of the failure location-90 to 90 · optional	32.7792
`longitude`	float	Longitude coordinate of the failure location-180 to 180 · optional	-96.8008
`downtime_minutes`	integer	Total downtime in minutes caused by the failure0 or more · optional	322
Dates and times 2 columns
`failure_datetime`	datetime	Date and time when the failure was detected	2024-05-14T09:17:00Z
`resolution_datetime`	datetime	Date and time when the failure was resolvedoptional	2024-05-14T14:39:00Z

Use it for

A technology dashboard
Downtime_minutes by device_type and a breakdown of maintenance_team_id. Excel, Power BI or Tableau.
Why do the 22 smart_sensor rows have a mean downtime_minutes of 587.1?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Failures127
SIG-4912_R322traffic_…
CAM-X8325B48iot_came…
SS-7918_X1109smart_se…
A software demo
Believable failures with device_id, device_type and system_name to fill a screen in front of a buyer.

This dataset127 rows23 columns

Yours1,000 rows23 columnslocation_street_address: UK only

blueprint · smart-city-technology-failure-logs

Behind this dataset

Same schema. As many rows as you need.

These 127 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 row represents a unique failure event logged by a city system.
Includes device type, location, time to resolution, and impact assessment.
Events must be categorized by failure reason (e.g., power, connectivity, hardware).
Resolution actions and responsible department must be logged.
No two events share identical timestamp and device ID.

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: smart-city-technology-failure-logs

What should your data show?

No signup. No card.

Sample rows

What the 127 rows show

Columns

Use it for

A technology dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Technology

What should your data show?