• Energy
  • 17 columns
  • 120 rows
  • 8 formats

Smart Grid Device Uptime Monitoring

This dataset provides detailed, real-time operational records for IoT-enabled devices across a smart energy grid, including uptime events, device status, fault diagnostics, energy metrics, and compliance tracking. It enables predictive maintenance, outage management, and regulatory reporting for grid reliability and sustainability initiatives.

  • last updated 24 Oct 2025
  • by GoMask
The brief that made it

Proactive outage detection and response

Sample rows

preview · 8 of 120 rows · all 17 columns
device_idstringdevice_typestringenergy_consumed_kwhfloatstatusstringlocation_namestringlocation_latitudefloatlocation_longitudefloatinstallation_datedatelast_maintenance_datedateuptime_startdatetimeuptime_enddatetimeuptime_duration_secondsintegerfault_codestringenergy_generated_kwhfloatcompliance_statusstringlast_status_updatedatetimefault_descriptionstring
MTR-CHICAGO-0018meter24521.7activeChicago North Substation41.8369-87.68472016-04-152024-04-082024-06-06T10:13:54Zblank553200blank0compliant2024-06-13T10:13:54Zblank
SNSR-WIND-AX09sensor15.2activeWind Farm Alpha43.5121-98.21442022-07-022024-02-212024-06-11T14:34:21Zblank235580blank44.7pending2024-06-13T14:34:21Zblank
TRNS-COAST-319Vtransformer3160.8faultCoastal Hub 389.9999179.99972015-09-192024-01-112024-06-01T08:41:17Z2024-06-08T08:41:17Z604800TRNSF-OVRLOAD0non-compliant2024-06-08T08:43:17ZTransformer overload detected during peak demand period. Immediate inspection recommended.
CTRL-BATT-2024Acontroller241.5activeBattery Storage Unit 24A37.7749-122.41942023-02-172024-05-212024-05-17T11:03:00Zblank2334600blank99.3compliant2024-06-13T11:03:00Zblank
RELY-BACKUP-077relay0inactiveBackup Relay Station 77-89.99990blankblank2024-06-12T08:58:44Z2024-06-13T08:58:44Z86400blankblankpending2024-06-13T08:59:44Zblank
MTR-DENVER-0023meter15632.2activeDenver Industrial West39.7392-104.99032017-03-272024-02-172024-06-02T07:17:00Zblank1012320blankblankcompliant2024-06-13T07:17:00Zblank
SNSR-SOLAR-3X22sensor7.3maintenanceSolar Array 3X2233.4484-112.0742021-08-092023-11-032024-06-12T04:17:29Z2024-06-13T04:17:29Z86400blank111.2pending2024-06-13T04:18:29Zblank
TRNS-ISLAND-ZB7transformerblankofflineIsland Substation ZB790-1802014-06-192024-01-022024-06-09T21:22:41Z2024-06-12T21:22:41Z259200blank1011.3compliant2024-06-12T21:23:41Zblank

What the 120 rows show

from the 120-row sample

Meter (device type) stands out: mean energy_consumed_kwh is 35,563, against 541.3 for the rest.

  • 84.3median energy_consumed_kwh
  • 3compliance statuses
  • 345,600median uptime_duration_seconds
  • 101.1median energy_generated_kwh
Mean energy_consumed_kwh by device_type114 rows
020k40k10.0sensor23 rows35,563meter25 rows0.08relay21 rows2,304trans…18 rows307.8contr…21 rows0.0other6 rows
energy_consumed_kwh114 rows, in bands of 10k
0459090771231111050k100kenergy_consumed_kwh →

Median 84.3, from 0.0 to 100,000.

status120 rows · 5 values
  1. active69
  2. inactive15
  3. fault14
  4. maintenance12
  5. offline10
17 columns by typefrom the column list below
  • string 7
  • integer 1
  • float 4
  • date 2
  • datetime 3

Columns

17 columns in three groups
blueprint · 17 columns
columntypedescriptionexample
Text 7 columns
device_idstringUnique identifier for the IoT-enabled device within the smart grid.uniqueMTR-CHICAGO-0018
device_typestringType or model of the smart grid device (e.g., sensor, meter, relay, transformer).6 valuesmeter
location_namestringHuman-readable name or label for the device's location within the grid.optionalChicago North Substation
statusstringCurrent operational status of the device.active · inactive · fault · maintenance · offlineactive
fault_codestringCode indicating the type of fault or error encountered (if any).optionalTRNSF-OVRLOAD
fault_descriptionstringDetailed description of the fault or error (if any).optionalTransformer overload dete…
compliance_statusstringIndicates if the device is compliant with regulatory or sustainability standards.compliant · non-compliant · pending · optionalcompliant
Numbers 5 columns
location_latitudefloatLatitude coordinate of the device's physical location.-90 to 9041.8369
location_longitudefloatLongitude coordinate of the device's physical location.-180 to 180-87.6847
uptime_duration_secondsintegerTotal duration of the uptime period in seconds.0 or more553200
energy_consumed_kwhfloatAmount of energy consumed by the device during the uptime period (in kilowatt-hours).0 or more · optional24521.7
energy_generated_kwhfloatAmount of energy generated by the device during the uptime period (in kilowatt-hours).0 or more · optional0
Dates and times 5 columns
installation_datedateDate when the device was installed on the grid.optional2016-04-15
last_maintenance_datedateDate of the most recent maintenance performed on the device.optional2024-04-08
uptime_startdatetimeTimestamp when the device started its current uptime period.2024-06-06T10:13:54Z
uptime_enddatetimeTimestamp when the device ended its current uptime period (null if currently active).optional2024-06-08T08:41:17Z
last_status_updatedatetimeTimestamp of the most recent status update for the device.2024-06-13T10:13:54Z

Use it for

  • median energy …84.3114 rowsmean energy consumed …10.0sens…35.6kmeter0.08relay2.3ktran…

    An energy dashboard

    Energy_consumed_kwh by device_type and a breakdown of status. Excel, Power BI or Tableau.

  • Why do the 25 meter rows have a mean energy_consumed_kwh of 35,563?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable devices with device_type, location_name and location_latitude to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 17 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset120 rows17 columns
Yours1,000 rows17 columnslocation_name: UK only

blueprint · smart-grid-device-uptime-monitoring

Behind this dataset

Same schema. As many rows as you need.

These 120 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 one device's hourly status update.
  • Device types alternate between transformer, smart meter, and relay.
  • Outage events flagged if uptime drops below 99.5%.
  • Include columns for region, device age, firmware version, and recent maintenance status.
  • Sustainability flag set if device energy use exceeds set threshold.
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-grid-device-uptime-monitoring

More in Energy

Browse all
Also in EnergySmart Grid Fault Detection DatasetEnergy Solar Output Time SeriesAMI Tamper and Theft Detection EventsAll 1,967 datasets

What should your data show?

Preview 20 rows free
No signup. No card.