Energy
17 columns
121 rows
8 formats

Urban Utility IoT Sensor Metrics

This dataset provides granular, time-stamped IoT sensor readings for electricity, water, and natural gas utilities across urban locations. It includes detailed metrics, anomaly flags, efficiency benchmarks, and operational status, empowering city planners to optimize resource usage, detect issues, and benchmark utility performance for smart city initiatives.

last updated 4 Feb 2026
by GoMask

The brief that made it

Urban utility usage analysis and optimization

Sample rows

preview · 8 of 121 rows · all 17 columns

sensor_idstring	unitstring	metric_valuefloat	anomaly_detectedboolean	sensor_manufacturerstring	utility_typestring	location_idstring	location_street_addressstring	location_citystring	location_statestring	location_postal_codestring	location_countrystring	timestampdatetime	metric_typestring	benchmark_efficiency_scorefloat	sensor_statusstring	sensor_installation_datedate
ELEC-001	kWh	87.34	false	EnergiCloud	electricity	LOC-1001	120 Main St	San Francisco	CA	94105	USA	2023-09-15T15:27:12	usage	92.6	active	2022-08-01
WATR-002	liters	2461.2	false	AquaSense	water	LOC-1002	4 St. Mary's Lane	London	London	EC1A 4HJ	UK	2022-11-21T05:43:55	usage	88.9	active	2018-07-19
GAS-003	m3	95.21	false	FlowPro	natural_gas	LOC-1003	300 King St W	Toronto	ON	M5V 1J2	Canada	2024-02-11T12:08:04	usage	75.8	active	2020-03-05
ELEC-004	volts	229.63	false	VoltWorks	electricity	LOC-1004	1600 Broadway	Denver	CO	80202	USA	2022-07-24T18:04:38	voltage	97.2	active	2021-06-10
WATR-005	psi	2.43	false	HydroMatic	water	LOC-1005	10 O'Connell St	Dublin	Leinster	D01 K0Y5	Ireland	2023-05-03T11:21:11	pressure	67.5	active	2019-03-27
GAS-006	psi	17.9	false	FlowPro	natural_gas	LOC-1006	55 Market St	Montreal	QC	H3B 2K3	Canada	2024-03-10T07:54:21	pressure	81.3	active	2021-12-18
ELEC-007	amps	8.65	false	VoltWorks	electricity	LOC-1007	255 Wall St	New York	NY	10005	USA	2024-04-02T01:29:36	current	73.7	active	2022-11-07
WATR-008	m3	32.7	false	AquaSense	water	LOC-1008	22 Queen St	London	London	SW1A 1AA	UK	2023-08-15T22:03:47	flow_rate	61.4	active	2017-09-17
GAS-009	m3	156.82	false	FlowPro	natural_gas	LOC-1009	612 12th Ave	Philadelphia	PA	19123	USA	2023-01-16T13:44:08	flow_rate	84.2	active	2021-02-12
ELEC-010	°C	26.1	false	EnergiCloud	electricity	LOC-1010	2104 3rd St	Los Angeles	CA	90007	USA	2024-05-12T09:35:15	temperature	78.9	active	2022-05-18
ELEC-011	kWh	105.45	false	VoltWorks	electricity	LOC-1011	66 Elm St	Chicago	IL	60610	USA	2023-02-07T14:13:59	usage	99.1	active	2022-03-10
WATR-012	°C	11.2	false	HydroMatic	water	LOC-1002	4 St. Mary's Lane	London	London	EC1A 4HJ	UK	2023-04-21T12:29:42	temperature	54.9	active	2018-07-19
GAS-013	psi	88.73	false	FlowPro	natural_gas	LOC-1013	85 Rue St-Paul	Montreal	QC	H2Y 1Z4	Canada	2022-03-18T16:21:32	pressure	77.5	active	2019-11-09
ELEC-014	volts	117.5	false	EnergiCloud	electricity	LOC-1014	905 5th Ave	Seattle	WA	98104	USA	2023-07-21T17:16:44	voltage	94.2	active	2020-09-16
WATR-015	psi	0.93	false	AquaSense	water	LOC-1015	7 Abbey Rd	London	London	NW8 9AY	UK	2022-10-30T20:51:07	pressure	41.2	active	2019-06-14
GAS-016	m3	324.11	false	FlowPro	natural_gas	LOC-1016	1234 Gas St	Denver	CO	80205	USA	2023-10-14T04:43:18	usage	92.9	active	2020-07-29
ELEC-017	amps	15.28	false	EnergiCloud	electricity	LOC-1017	8 Park Ave	New York	NY	10016	USA	2024-01-27T14:09:52	current	85.7	active	2022-09-10
WATR-018	°C	7.3	false	HydroMatic	water	LOC-1018	2 Liffey Terrace	Dublin	Leinster	D08 E8Y5	Ireland	2022-12-05T08:17:14	temperature	53.4	active	2016-04-30
GAS-019	m3	523.5	false	FlowPro	natural_gas	LOC-1019	421 7th Ave	Philadelphia	PA	19104	USA	2022-06-14T22:10:08	flow_rate	70.2	active	2021-01-23
ELEC-020	volts	120.3	false	VoltWorks	electricity	LOC-1020	2300 South St	Philadelphia	PA	19146	USA	2023-05-18T11:41:25	voltage	89.4	active	2020-02-12

What the 121 rows show

from the 121-row sample

Liters unit stands out: mean metric_value is 1,200, against 102.3 for the rest.

15%anomaly_detected = true
61.2median metric_value
3utility types
4location countries
4sensor statuses
6metric types

Mean metric_value by unit121 rows

metric_value121 rows, in bands of 500

Median 61.2, from -1.0 to 3,099.

sensor_manufacturer114 rows with a value · 7 left blank

FlowPro31
EnergiCloud23
VoltWorks21
AquaSense20
HydroMatic19

17 columns by typefrom the column list below

string 12
float 2
date 1
datetime 1
boolean 1

Columns

17 columns in four groups

blueprint · 17 columns
column	type	description	example
Text 12 columns
`sensor_id`	string	Unique identifier for each IoT sensor deviceunique	ELEC-001
`utility_type`	string	Type of public utility monitored by the sensor (electricity, water, natural_gas)electricity · water · natural_gas	electricity
`location_id`	string	Unique identifier for the location where the sensor is installed	LOC-1001
`location_street_address`	string	Street address of the sensor's installation site	120 Main St
`location_city`	string	City where the sensor is installed	San Francisco
`location_state`	string	State or region where the sensor is installed	CA
`location_postal_code`	string	Postal code for the sensor's location	94105
`location_country`	string	Country where the sensor is installed4 countries	USA
`metric_type`	string	Type of metric measured (usage, pressure, flow_rate, voltage, etc.)6 values	usage
`unit`	string	Unit of measurement for the metric value (e.g., kWh, liters, psi, m3, volts, amps, °C)7 values	kWh
`sensor_status`	string	Operational status of the sensor (active, inactive, maintenance, error)active · inactive · maintenance · error	active
`sensor_manufacturer`	string	Name of the company that manufactured the sensor5 manufacturers · optional	EnergiCloud
Numbers 2 columns
`metric_value`	float	Measured value for the specified metric type	87.34
`benchmark_efficiency_score`	float	Efficiency score comparing this reading to city-wide benchmarks (0-100 scale)0 to 100 · optional	92.6
Dates and times 2 columns
`timestamp`	datetime	Date and time when the sensor reading was recorded	2023-09-15T15:27:12
`sensor_installation_date`	date	Date the sensor was installed at its locationoptional	2022-08-01
True or false 1 column
`anomaly_detected`	boolean	Indicates whether an anomaly was detected in this reading	false

Use it for

An energy dashboard
The anomaly_detected rate, metric_value by unit and a breakdown of sensor_manufacturer. Excel, Power BI or Tableau.
Why do the 14 liters rows have a mean metric_value of 1,200?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Sensors121
ELEC-00187.34kWh
NGAS-008348.9m3
WATR-0131200.55liters
A software demo
Believable sensors with utility_type, location_id and location_street_address to fill a screen in front of a buyer.

This dataset121 rows17 columns

Yours10,000 rows17 columnslocation_id: UK only

blueprint · urban-utility-iot-sensor-metrics

Behind this dataset

Same schema. As many rows as you need.

These 121 rows came out of a blueprint — 17 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 sensor's hourly reading
Includes sensor type, location, utility type, usage value, and anomaly flag
Sensors cover electricity, water, and gas utilities from multiple districts
Values flagged if exceeding 2x district average for the hour
Missing readings are backfilled from nearest neighbor sensor within the last hour

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

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: urban-utility-iot-sensor-metrics

What should your data show?

No signup. No card.

Sample rows

What the 121 rows show

Columns

Use it for

An energy dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Energy

What should your data show?