most_recent_snapshot (view)

117 rows

View and edit SQL

id latitude longitude outage estCustAffected lastUpdateTime hazardFlag region cause crewCurrentStatus outage_url currentEtor autoEtor
1573838420:707358 36.88632 -121.63385 707358 17 November 15, 2019 - 16:41:21 UTC 0 Aromas Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707358 November 16, 2019 - 00:00:00 UTC  
1573838420:707342 35.32576 -119.13148 707342 16 November 15, 2019 - 17:10:58 UTC 0 Bakersfield Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707342 November 15, 2019 - 17:30:00 UTC  
1573838420:707322 35.29628 -119.13918 707322 1 November 15, 2019 - 16:45:05 UTC 0 Bakersfield PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707322 November 15, 2019 - 19:45:00 UTC November 15, 2019 - 19:45:00 UTC
1573838420:707259 40.74388 -122.01851 707259 2 November 15, 2019 - 14:44:40 UTC 0 Bella Vista Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707259 November 15, 2019 - 23:00:00 UTC  
1573838420:706163 40.7853 -121.96274 706163 1 November 13, 2019 - 20:00:06 UTC 0 Bella Vista Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/706163 November 13, 2019 - 23:00:00 UTC  
1573838420:707418 37.88395 -122.25992 707418 12 November 15, 2019 - 17:13:07 UTC 0 Berkeley Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707418 November 15, 2019 - 22:00:00 UTC  
1573838420:707411 37.88465 -122.25899 707411 17 November 15, 2019 - 17:07:34 UTC 0 Berkeley Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707411 November 15, 2019 - 22:00:00 UTC  
1573838420:707353 37.97814 -121.62148 707353 1 November 15, 2019 - 16:39:03 UTC 1 Brentwood Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707353 November 15, 2019 - 20:00:00 UTC November 15, 2019 - 20:00:00 UTC
1573838420:707396 37.69402 -122.4828 707396 1 November 15, 2019 - 17:02:20 UTC 0 Broadmoor Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707396 November 15, 2019 - 19:30:00 UTC November 15, 2019 - 19:30:00 UTC
1573838420:707301 35.57222 -121.10497 707301 6 November 15, 2019 - 16:15:37 UTC 0 Cambria Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707301 November 15, 2019 - 19:00:00 UTC  
1573838420:707303 36.38279 -121.63635 707303 1 November 15, 2019 - 16:00:09 UTC 0 Carmel Valley Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707303 November 15, 2019 - 19:45:00 UTC November 15, 2019 - 19:45:00 UTC
1573838420:707297 39.51839 -121.19033 707297 1 November 15, 2019 - 15:55:59 UTC 0 Challenge Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707297 November 16, 2019 - 00:00:00 UTC  
1573838420:707372 39.44535 -121.27964 707372 1 November 15, 2019 - 16:56:33 UTC 0 Challenge-Brownsville Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707372 November 15, 2019 - 22:15:00 UTC November 15, 2019 - 22:15:00 UTC
1573838420:707335 36.93682 -119.46855 707335 1 November 15, 2019 - 16:15:47 UTC 0 Clovis Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707335 November 15, 2019 - 18:00:00 UTC  
1573838420:707347 36.95559 -119.46095 707347 3 November 15, 2019 - 16:28:44 UTC 0 Clovis Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707347 November 15, 2019 - 18:00:00 UTC  
1573838420:707370 36.81377 -119.64038 707370 1 November 15, 2019 - 16:43:30 UTC 0 Clovis Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707370 November 15, 2019 - 19:30:00 UTC November 15, 2019 - 19:30:00 UTC
1573838420:707329 36.81437 -119.63714 707329 111 November 15, 2019 - 16:18:36 UTC 0 Clovis Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707329 November 16, 2019 - 00:00:00 UTC  
1573838420:707343 37.1259 -119.76078 707343 1 November 15, 2019 - 16:31:13 UTC 0 Coarsegold Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707343 November 15, 2019 - 19:30:00 UTC November 15, 2019 - 19:30:00 UTC
1573838420:707406 37.2639 -119.68466 707406 4 November 15, 2019 - 17:06:51 UTC 0 Coarsegold Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707406 November 16, 2019 - 00:00:00 UTC  
1573838420:707344 39.03638 -120.98748 707344 25 November 15, 2019 - 16:26:07 UTC 0 Colfax Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707344 November 16, 2019 - 01:00:00 UTC  
1573838420:707355 39.04888 -121.00325 707355 3 November 15, 2019 - 16:42:45 UTC 0 Colfax Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707355 November 15, 2019 - 22:00:00 UTC  
1573838420:707381 39.10005 -120.94572 707381 1 November 15, 2019 - 16:54:47 UTC 1 Colfax Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707381 November 15, 2019 - 19:45:00 UTC November 15, 2019 - 19:45:00 UTC
1573838420:707368 38.046 -120.39016 707368 2 November 15, 2019 - 16:42:26 UTC 0 Columbia Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707368 November 15, 2019 - 19:00:00 UTC  
1573838420:707354 39.17093 -123.56562 707354 1 November 15, 2019 - 17:01:12 UTC 1 Comptche Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707354 November 15, 2019 - 20:30:00 UTC November 15, 2019 - 20:30:00 UTC
1573838420:707346 37.97982 -122.03795 707346 1 November 15, 2019 - 16:30:30 UTC 1 Concord Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707346 November 15, 2019 - 19:00:00 UTC November 15, 2019 - 19:00:00 UTC
1573838420:707403 37.96939 -122.02373 707403 1 November 15, 2019 - 17:11:08 UTC 1 Concord Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707403 November 15, 2019 - 20:15:00 UTC November 15, 2019 - 20:15:00 UTC
1573838420:707349 37.91741 -120.62296 707349 1 November 15, 2019 - 17:03:09 UTC 0 Copperopolis Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707349 November 15, 2019 - 18:15:00 UTC November 15, 2019 - 18:15:00 UTC
1573838420:707318 35.49069 -120.54188 707318 2 November 15, 2019 - 16:07:00 UTC 0 Creston Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707318 November 15, 2019 - 22:00:00 UTC  
1573838420:707393 37.32011 -122.057 707393 6 November 15, 2019 - 17:00:37 UTC 0 Cupertino Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707393 November 16, 2019 - 01:00:00 UTC  
1573838420:707420 37.82879 -122.002 707420 1 November 15, 2019 - 17:14:55 UTC 0 Danville Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707420 November 15, 2019 - 20:45:00 UTC November 15, 2019 - 20:45:00 UTC
1573838420:707392 38.55306 -122.45675 707392 37 November 15, 2019 - 17:10:22 UTC 0 Deer Park Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707392 November 16, 2019 - 01:00:00 UTC  
1573838420:707304 38.49719 -121.77754 707304 1 November 15, 2019 - 15:56:37 UTC 0 Dixon Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707304 November 15, 2019 - 19:45:00 UTC November 15, 2019 - 19:45:00 UTC
1573838420:707331 36.98155 -120.56085 707331 1 November 15, 2019 - 16:47:05 UTC 0 Dos Palos Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707331 November 15, 2019 - 18:00:00 UTC November 15, 2019 - 18:00:00 UTC
1573838420:707357 36.99084 -120.6284 707357 1 November 15, 2019 - 16:46:23 UTC 0 Dos Palos Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707357 November 15, 2019 - 19:30:00 UTC November 15, 2019 - 19:30:00 UTC
1573838420:707408 39.62078 -121.78717 707408 3 November 15, 2019 - 17:09:49 UTC 0 Durham Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707408 November 15, 2019 - 22:30:00 UTC  
1573838420:707373 39.19603 -120.79806 707373 1 November 15, 2019 - 16:49:56 UTC 1 Dutch Flat Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707373 November 15, 2019 - 20:15:00 UTC November 15, 2019 - 20:15:00 UTC
1573838420:707323 37.3901 -121.81414 707323 155 November 15, 2019 - 16:45:32 UTC 0 East Foothills Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707323 November 15, 2019 - 19:00:00 UTC November 15, 2019 - 19:00:00 UTC
1573838420:707278 38.6585 -121.04003 707278 1 November 15, 2019 - 17:14:57 UTC 0 El Dorado Hills PG&E is investigating the cause of your outage. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707278 November 15, 2019 - 18:30:00 UTC November 15, 2019 - 18:30:00 UTC
1573838420:707405 39.61381 -122.51929 707405 39 November 15, 2019 - 17:14:59 UTC 0 Elk Creek Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707405 November 16, 2019 - 00:00:00 UTC  
1573838420:707336 40.44786 -124.2684 707336 8 November 15, 2019 - 16:18:43 UTC 0 Ferndale Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707336 November 16, 2019 - 01:00:00 UTC  
1573838420:707315 38.50641 -122.9233 707315 1 November 15, 2019 - 17:13:07 UTC 0 Forestville Our preliminary determination is that your outage was caused by an equipment issue. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707315 November 16, 2019 - 00:30:00 UTC  
1573838420:707333 37.49404 -121.91104 707333 9 November 15, 2019 - 17:05:58 UTC 0 Fremont Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707333 November 15, 2019 - 23:00:00 UTC  
1573838420:707289 37.5387 -121.96484 707289 1 November 15, 2019 - 16:20:02 UTC 1 Fremont PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707289 November 15, 2019 - 19:15:00 UTC November 15, 2019 - 19:15:00 UTC
1573838420:707417 36.76825 -119.73634 707417 39 November 15, 2019 - 17:15:42 UTC 0 Fresno Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707417 November 15, 2019 - 23:00:00 UTC  
1573838420:707397 36.66306 -119.74709 707397 1 November 15, 2019 - 17:04:46 UTC 0 Fresno Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707397 November 16, 2019 - 00:30:00 UTC  
1573838420:707294 36.6103 -119.83049 707294 1 November 15, 2019 - 15:42:35 UTC 1 Fresno Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707294 November 15, 2019 - 19:30:00 UTC November 15, 2019 - 19:30:00 UTC
1573838420:707422 36.76826 -119.73676 707422 6 November 15, 2019 - 17:13:19 UTC 0 Fresno Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707422 November 15, 2019 - 20:00:00 UTC November 15, 2019 - 20:00:00 UTC
1573838420:707327 36.83681 -119.83776 707327 1 November 15, 2019 - 16:10:17 UTC 0 Fresno Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707327 November 16, 2019 - 00:00:00 UTC  
1573838420:707256 38.80539 -120.84512 707256 5 November 15, 2019 - 17:02:47 UTC 0 Garden Valley PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707256 November 15, 2019 - 18:15:00 UTC November 15, 2019 - 18:15:00 UTC
1573838420:707383 39.38515 -121.68909 707383 1 November 15, 2019 - 16:54:22 UTC 0 Gridley Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707383 November 15, 2019 - 22:00:00 UTC  
1573838420:707402 38.50139 -122.99828 707402 1 November 15, 2019 - 17:05:25 UTC 0 Guerneville Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707402 November 15, 2019 - 20:00:00 UTC  
1573838420:707247 37.15892 -120.99621 707247 4 November 15, 2019 - 17:12:01 UTC 1 Gustine Our preliminary determination is that your outage was caused by an equipment issue. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707247 November 15, 2019 - 18:30:00 UTC November 15, 2019 - 18:30:00 UTC
1573838420:707299 36.26948 -119.59994 707299 1 November 15, 2019 - 16:44:07 UTC 0 Hanford Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707299 November 16, 2019 - 00:00:00 UTC  
1573838420:707328 38.87803 -123.01527 707328 3 November 15, 2019 - 16:49:12 UTC 0 Hopland Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707328 November 15, 2019 - 23:00:00 UTC  
1573838420:707375 36.20031 -120.0977 707375 14 November 15, 2019 - 17:04:47 UTC 0 Huron Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707375 November 15, 2019 - 20:00:00 UTC  
1573838420:707416 38.39594 -120.68477 707416 1 November 15, 2019 - 17:08:13 UTC 0 Jackson Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707416 November 15, 2019 - 23:00:00 UTC  
1573838420:707399 37.97802 -120.41827 707399 1 November 15, 2019 - 17:05:29 UTC 0 Jamestown Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707399 November 15, 2019 - 21:00:00 UTC  
1573838420:707409 36.22823 -121.14129 707409 1 November 15, 2019 - 17:10:54 UTC 0 King City Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707409 November 15, 2019 - 20:00:00 UTC November 15, 2019 - 20:00:00 UTC
1573838420:707425 40.84449 -122.34241 707425 3 November 15, 2019 - 17:14:36 UTC 0 Lakehead Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707425 November 15, 2019 - 21:00:00 UTC  
1573838420:707334 38.99709 -122.86969 707334 1 November 15, 2019 - 16:25:08 UTC 0 Lakeport Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707334 November 15, 2019 - 19:30:00 UTC November 15, 2019 - 19:30:00 UTC
1573838420:707195 37.34972 -122.11174 707195 12 November 15, 2019 - 11:02:28 UTC 0 Los Altos Hills PG&E is investigating the cause of your outage. PG&E is sending a repair crew to the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707195 November 15, 2019 - 23:00:00 UTC  
1573838420:707302 36.94794 -120.0375 707302 1 November 15, 2019 - 16:56:27 UTC 1 Madera PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707302 November 15, 2019 - 18:45:00 UTC November 15, 2019 - 18:45:00 UTC
1573838420:707389 36.844 -120.09253 707389 1 November 15, 2019 - 17:12:18 UTC 1 Madera Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707389 November 15, 2019 - 18:45:00 UTC November 15, 2019 - 18:45:00 UTC
1573838420:707326 39.14454 -121.59866 707326 1 November 15, 2019 - 16:23:08 UTC 1 Marysville PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707326 November 15, 2019 - 18:30:00 UTC November 15, 2019 - 18:30:00 UTC
1573838420:707325 35.46979 -119.68951 707325 3 November 15, 2019 - 16:11:23 UTC 0 Mc Kittrick Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707325 November 15, 2019 - 23:00:00 UTC  
1573838420:707330 40.54052 -122.14 707330 1 November 15, 2019 - 16:12:55 UTC 0 Millville Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707330 November 15, 2019 - 18:00:00 UTC  
1573838420:707394 37.53757 -122.01759 707394 38 November 15, 2019 - 17:03:05 UTC 0 Newark Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707394 November 15, 2019 - 19:30:00 UTC  
1573838420:707356 38.91926 -121.08684 707356 1 November 15, 2019 - 16:36:39 UTC 0 North Auburn Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707356 November 15, 2019 - 20:00:00 UTC  
1573838420:707410 37.47103 -122.20064 707410 15 November 15, 2019 - 17:11:22 UTC 0 North Fair Oaks Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707410 November 16, 2019 - 01:00:00 UTC  
1573838420:707414 37.22961 -119.50844 707414 20 November 15, 2019 - 17:07:51 UTC 0 North Fork Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707414 November 15, 2019 - 22:00:00 UTC  
1573838420:707293 37.77347 -122.19561 707293 1 November 15, 2019 - 15:40:44 UTC 0 Oakland Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707293 November 15, 2019 - 19:00:00 UTC November 15, 2019 - 19:00:00 UTC
1573838420:707376 38.39206 -122.92203 707376 6 November 15, 2019 - 17:06:22 UTC 0 Occidental Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707376 November 16, 2019 - 00:00:00 UTC  
1573838420:707324 38.38105 -122.98845 707324 13 November 15, 2019 - 17:04:53 UTC 0 Occidental PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707324 November 15, 2019 - 19:15:00 UTC November 15, 2019 - 19:15:00 UTC
1573838420:707398 39.09983 -121.55166 707398 83 November 15, 2019 - 17:14:36 UTC 0 Olivehurst Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707398 November 16, 2019 - 00:00:00 UTC  
1573838420:707382 36.61163 -119.09983 707382 1 November 15, 2019 - 17:02:35 UTC 0 Orosi Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707382 November 15, 2019 - 20:45:00 UTC November 15, 2019 - 20:45:00 UTC
1573838420:707252 39.57065 -121.31594 707252 3 November 15, 2019 - 14:35:35 UTC 0 Oroville Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707252 November 16, 2019 - 00:00:00 UTC  
1573838420:707423 38.00368 -121.88961 707423 1 November 15, 2019 - 17:15:57 UTC 0 Pittsburg Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707423 November 15, 2019 - 20:15:00 UTC November 15, 2019 - 20:15:00 UTC
1573838420:707339 38.67339 -120.64728 707339 1 November 15, 2019 - 16:20:01 UTC 0 Placerville Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707339 November 15, 2019 - 22:00:00 UTC  
1573838420:707275 38.72995 -120.92433 707275 46 November 15, 2019 - 14:53:29 UTC 0 Placerville Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707275 November 15, 2019 - 23:00:00 UTC  
1573838420:707231 37.69767 -121.94205 707231 62 November 15, 2019 - 15:45:59 UTC 3 Pleasanton Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707231 November 16, 2019 - 01:00:00 UTC  
1573838420:707401 38.70762 -120.59914 707401 3 November 15, 2019 - 17:05:04 UTC 0 Pollock Pines Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707401 November 16, 2019 - 01:00:00 UTC  
1573838420:707264 37.37876 -122.20231 707264 64 November 15, 2019 - 17:06:06 UTC 0 Portola Valley PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707264 November 15, 2019 - 18:45:00 UTC November 15, 2019 - 18:45:00 UTC
1573838420:707413 37.4854 -122.24798 707413 13 November 15, 2019 - 17:07:40 UTC 0 Redwood City Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707413 November 16, 2019 - 01:00:00 UTC  
1573838420:707407 38.54437 -120.74138 707407 8 November 15, 2019 - 17:06:51 UTC 0 River Pines Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707407 November 15, 2019 - 21:00:00 UTC  
1573838420:707314 38.5133 -122.50922 707314 7 November 15, 2019 - 16:01:58 UTC 0 Saint Helena Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707314 November 16, 2019 - 01:00:00 UTC  
1573838420:707391 36.66752 -121.66254 707391 1 November 15, 2019 - 16:59:22 UTC 0 Salinas Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707391 November 15, 2019 - 19:45:00 UTC November 15, 2019 - 19:45:00 UTC
1573838420:707332 37.76324 -122.48619 707332 43 November 15, 2019 - 16:16:10 UTC 0 San Francisco Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707332 November 16, 2019 - 01:30:00 UTC  
1573838420:707209 37.79836 -122.40988 707209 71 November 15, 2019 - 15:08:27 UTC 0 San Francisco Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707209 November 15, 2019 - 14:00:00 UTC  
1573838420:707365 37.76119 -122.47364 707365 1 November 15, 2019 - 17:15:03 UTC 0 San Francisco PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707365 November 15, 2019 - 18:30:00 UTC November 15, 2019 - 18:30:00 UTC
1573838420:707310 37.74979 -122.41941 707310 1 November 15, 2019 - 16:35:34 UTC 0 San Francisco Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707310 November 15, 2019 - 19:00:00 UTC November 15, 2019 - 19:00:00 UTC
1573838420:707296 37.73901 -122.42568 707296 1 November 15, 2019 - 16:06:59 UTC 0 San Francisco Unknown - PG&E will be assessing the cause. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707296 November 15, 2019 - 18:15:00 UTC November 15, 2019 - 18:15:00 UTC
1573838420:707426 37.74708 -122.4361 707426 32 November 15, 2019 - 17:16:02 UTC 0 San Francisco Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E has assigned a crew to assess the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707426 November 16, 2019 - 01:00:00 UTC  
1573838420:707242 37.33534 -121.77139 707242 4 November 15, 2019 - 16:52:58 UTC 0 San Jose Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is en route to the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707242 November 15, 2019 - 22:00:00 UTC  
1573838420:707288 35.27419 -120.65956 707288 1 November 15, 2019 - 17:11:36 UTC 0 San Luis Obispo PG&E is investigating the cause of your outage. PG&E is assessing the cause at the outage location. https://pge-outages.simonwillison.net/pge-outages/outage/707288 November 15, 2019 - 18:30:00 UTC November 15, 2019 - 18:30:00 UTC
1573838420:707312 34.99834 -120.36249 707312 6 November 15, 2019 - 16:11:30 UTC 0 Santa Maria Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707312 November 15, 2019 - 23:00:00 UTC  
1573838420:707291 38.41548 -122.67068 707291 1 November 15, 2019 - 15:45:30 UTC 0 Santa Rosa Unknown - PG&E will be assessing the cause. PG&E assessment crew is en route to the outage. https://pge-outages.simonwillison.net/pge-outages/outage/707291 November 15, 2019 - 18:30:00 UTC November 15, 2019 - 18:30:00 UTC
1573838420:707211 36.97678 -121.91442 707211 31 November 15, 2019 - 17:06:12 UTC 0 Seacliff Our preliminary determination is that your outage was caused by an equipment issue. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707211 November 15, 2019 - 23:00:00 UTC  
1573838420:707337 36.56157 -119.5822 707337 4 November 15, 2019 - 16:17:13 UTC 0 Selma Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707337 November 15, 2019 - 23:00:00 UTC  
1573838420:707338 38.70207 -120.93645 707338 1 November 15, 2019 - 16:38:37 UTC 0 Shingle Springs Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707338 November 15, 2019 - 23:00:00 UTC  
1573838420:707300 40.52808 -121.74926 707300 4 November 15, 2019 - 15:55:59 UTC 0 Shingletown Our preliminary determination is that your outage was caused by scheduled maintenance work. PG&E repair crew is on-site working to restore power. https://pge-outages.simonwillison.net/pge-outages/outage/707300 November 16, 2019 - 00:00:00 UTC  

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW most_recent_snapshot as
select
    outage_snapshots.id, latitude, longitude, outage, estCustAffected,
    lastUpdateTime, hazardFlag, regionName.name as region, cause.name as cause,
    crewCurrentStatus.name as crewCurrentStatus,
    'https://pge-outages.simonwillison.net/pge-outages/outage/' || outage as outage_url, currentEtor, autoEtor
from outage_snapshots
    join regionName on outage_snapshots.regionName = regionName.id
    join cause on outage_snapshots.cause = cause.id
    join crewCurrentStatus on outage_snapshots.crewCurrentStatus = crewCurrentStatus.id
where
    snapshot in (select id from snapshots order by id desc limit 1)
Powered by Datasette · Query took 2500.671ms · About: About this site