Querying a power outage database
I have been tracking power outage data using a technique I learned about from Simon Willison called git-scraping. The outages are broken down by city, a stylized version of the data looks like:
1pm     seattle: 300
          2pm     seattle: 200    tacoma: 150
          3pm                     tacoma: 140     # implied seattle = 0 …