Menu

What 247 Million Power Outage Records Can Actually Tell Us
📰

What 247 Million Power Outage Records Can Actually Tell Us

DEV Community: datascience·Logan·about 12 hours ago
#qOm5WJk8
#devtodatascience#science#devto#dev#million
Reading 0:00
15s threshold

The U.S. outage records for 2025 add up to 52.8% fewer reported customer-hours than the records for 2024. How much of that gap comes from a handful of severe days? Drop each year’s ten highest-burden days and the difference is still 41.3% .

That check took a few lines of Python. Deciding what to sum took more care. The data behind this comparison cover 11 calendar years, 2015–2025, and about 247.6 million source rows. Each row is a county-level observation, with a timestamp and a count of customers reported out at that moment.

What a snapshot can measure

Suppose a county reports 400 customers out at 08:00 UTC and 600 at 08:15. At the source’s nominal 15-minute cadence, those samples contribute (400 + 600) × 0.25 = 250 customer-hours . The second snapshot can represent a different set of customers. The data lack the customer IDs needed to reconstruct individual outage durations.

An earlier version of the analysis stitched county snapshots together when gaps were short.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.