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 …