• Energy
  • 15 columns
  • 120 rows
  • 8 formats

AMI Outage Detection and Last Gasp Events

This dataset provides near real-time smart meter outage and restoration events, including precise timestamps, meter and customer identifiers, and detailed location information. It enables utilities to rapidly detect outages, verify restorations, and analyze outage patterns for improved grid reliability and customer service.

  • last updated 2 Nov 2025
  • by GoMask
The brief that made it

Real-time outage detection and restoration verification for utility companies

Sample rows

preview · 8 of 120 rows · all 15 columns
event_idstringmeter_location_countrystringsignal_strength_dbmfloatrestoration_confirmedbooleanmeter_location_citystringmeter_idstringevent_typestringevent_timestampdatetimemeter_location_streetstringmeter_location_statestringmeter_location_postal_codestringcustomer_idstringoutage_duration_minutesfloatmeter_modelstringutility_companystring
EVT000001USA-73.2falseSpringfieldMTR10001last_gasp2024-04-03T17:32:44Z123 Oakwood AveIL62704CUST9001blankSMX-1000Springfield Electric
EVT000002USA-81.5falseSpringfieldMTR10002last_gasp2024-04-03T17:35:23Z234 Maple StIL62705CUST9002blankSMX-1000Springfield Electric
EVT000003USA-66.4falseHartfordMTR10003last_gasp2024-04-03T17:40:19Z56 River RdCT06103CUST9003blankNRG-220Hartford Power
EVT000004USA-53falseHartfordMTR10004last_gasp2024-04-03T17:42:57Z88 Elm StCT06105CUST9004blankNRG-220Hartford Power
EVT000005USA-90.2falseCheyenneMTR10005last_gasp2024-04-03T17:44:01Z12 Pine StWY82001CUST9005blankWTG-3A50Cheyenne Utilities
EVT000006USA-75.8falseCheyenneMTR10006last_gasp2024-04-03T17:48:30Z400 Main StWY82002CUST9006blankWTG-3A50Cheyenne Utilities
EVT000007USA-62.7falsePortlandMTR10007last_gasp2024-04-03T17:51:11Z76 Lakeview DrOR97201CUST9007blankSMX-1000Portland Energy
EVT000008USA-58.5falsePortlandMTR10008last_gasp2024-04-03T17:55:18Z19 Baker StOR97202CUST9008blankSMX-1000Portland Energy

What the 120 rows show

from the 120-row sample

CAN (meter location country) stands out: mean signal_strength_dbm is -93.0, against -75.1 for the rest.

  • 48%restoration_confirmed = true
  • -77.4median signal_strength_dbm
  • 2event types
  • 13meter models
  • 30meter location states
  • 70.0median outage_duration_minutes
signal_strength_dbm120 rows, in bands of 10
01530491324252916-120-80-50signal_strength_dbm →

Median -77.4, from -115.3 to -51.2.

meter_location_city120 rows · top 10 of 40 values
  1. Toronto10
  2. Springfield7
  3. Portland6
  4. Montreal6
  5. San Francisco6
  6. Hartford4
  7. Cheyenne4
  8. Cleveland4
  9. Sydney4
  10. Melbourne4
15 columns by typefrom the column list below
  • string 11
  • float 2
  • datetime 1
  • boolean 1

Columns

15 columns in four groups
blueprint · 15 columns
columntypedescriptionexample
Text 11 columns
event_idstringUnique identifier for each outage or restoration eventuniqueEVT000001
meter_idstringUnique identifier for the smart meter reporting the eventMTR10001
event_typestringType of event reported: 'last_gasp' for outage, 'restoration' for power restorationlast_gasp · restorationlast_gasp
meter_location_streetstringStreet address of the meter locationoptional123 Oakwood Ave
meter_location_citystringCity where the meter is installedoptionalSpringfield
meter_location_statestringState or province of the meter locationoptionalIL
meter_location_postal_codestringPostal or ZIP code of the meter locationoptional62704
meter_location_countrystringCountry where the meter is installed6 countries · optionalUSA
customer_idstringUnique identifier for the customer associated with the meteroptionalCUST9001
meter_modelstringModel identifier of the smart meteroptionalSMX-1000
utility_companystringName of the utility company operating the meteroptionalSpringfield Electric
Numbers 2 columns
outage_duration_minutesfloatDuration of the outage in minutes (only for restoration events)0 or more · optional61
signal_strength_dbmfloatSignal strength of the meter at the time of event (in dBm)optional-73.2
Dates and times 1 column
event_timestampdatetimeDate and time when the event was detected by the meter2024-04-03T17:32:44Z
True or false 1 column
restoration_confirmedbooleanIndicates if restoration has been confirmed by the meter (true/false)optionalfalse

Use it for

  • restoration co…48%58 of 120 rows

    An energy dashboard

    The restoration_confirmed rate, signal_strength_dbm by meter_location_country and a breakdown of meter_location_city. Excel, Power BI or Tableau.

  • Why do the 19 CAN rows have a mean signal_strength_dbm of -93.0?

    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 events with meter_id, event_type and event_timestamp to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 15 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 rows15 columns
Yours1,000 rows15 columnsmeter_location_street: UK only

blueprint · ami-outage-detection-and-last-gasp-events

Behind this dataset

Same schema. As many rows as you need.

These 120 rows came out of a blueprint — 15 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
  • Event type: last gasp (power loss) or restoration (power up)
  • Event timestamp with millisecond precision
  • Meter ID and geolocation (lat/long) for outage mapping
  • Voltage measurement at time of event
  • Feeder circuit ID and substation for correlation
  • Outage duration calculated from gasp to restoration
  • SAIDI/SAIFI/CAIDI reliability metrics calculated from events
  • Integration with OMS for crew dispatch and customer notifications
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
ami-outage-detection-and-last-gasp-events

More in Energy

Browse all
Also in EnergyVoltage Quality and Power Outage Duration MonitoringSCADA Alarm and Event ManagementNatural Gas Pipeline Receipt and Delivery PointsAll 1,954 datasets

What should your data show?

Preview 20 rows free
No signup. No card.