outage_snapshots

46 rows where snapshot = 49

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1569942021:629455 629455 629455 2019-10-01 08:00:21-07:00 49 September 30, 2019 - 19:29:15 UTC October 02, 2019 - 05:00:00 UTC   1 0 40.55785 -124.14553 Fortuna 9 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is on-site working to restore power. 2
1569942021:629993 629993 629993 2019-10-01 08:00:21-07:00 49 September 30, 2019 - 16:05:44 UTC October 01, 2019 - 00:00:00 UTC   1 0 38.50277 -122.71038 Santa Rosa 30 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1569942021:630055 630055 630055 2019-10-01 08:00:21-07:00 49 September 30, 2019 - 15:29:50 UTC October 02, 2019 - 23:00:00 UTC   1 0 38.12243 -121.83043 Rio Vista 21 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1569942021:631014 631014 631014 2019-10-01 08:00:21-07:00 49 September 30, 2019 - 17:04:42 UTC October 03, 2019 - 21:30:00 UTC   1 0 39.0775 -121.52568 Olivehurst 17 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E is assessing the cause at the outage location. 4
1569942021:632633 632633 632633 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:19:33 UTC October 02, 2019 - 01:00:00 UTC   1 1 38.37341 -121.54748 Clarksburg 5 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1569942021:633373 633373 633373 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:18:45 UTC October 01, 2019 - 23:46:00 UTC   1 0 38.36723 -121.54198 Clarksburg 5 Our preliminary determination is that your outage was caused by an emergency issue. 4 PG&E is sending a repair crew to the outage location. 3
1569942021:633433 633433 633433 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:03:16 UTC October 01, 2019 - 19:00:00 UTC   1 0 38.65738 -121.77805 Woodland 34 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is sending a repair crew to the outage location. 3
1569942021:633481 633481 633481 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 12:45:54 UTC October 01, 2019 - 16:00:00 UTC   4 0 37.69717 -122.08699 Castro Valley 4 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1569942021:633488 633488 633488 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 11:09:46 UTC October 01, 2019 - 14:15:00 UTC   27 1 35.99202 -119.57146 Kettleman City 10 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1569942021:633505 633505 633505 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 13:15:23 UTC     1 0 37.66473 -121.92102 Pleasanton 36 Unknown - PG&E will be assessing the cause. 1 PG&E is unable to access the affected equipment. 6
1569942021:633516 633516 633516 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:46:55 UTC October 01, 2019 - 22:59:00 UTC   41 1 35.52131 -120.71256 Atascadero 40 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569942021:633524 633524 633524 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:48:14 UTC October 01, 2019 - 22:00:00 UTC   94 0 37.29072 -121.95844 Campbell 43 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E repair crew is en route to the outage location. 7
1569942021:633532 633532 633532 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:10:18 UTC October 01, 2019 - 15:45:00 UTC October 01, 2019 - 15:45:00 UTC 1 1 37.79305 -122.18292 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569942021:633538 633538 633538 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:26:20 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 1 0 37.95276 -121.95995 Concord 46 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633540 633540 633540 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 12:57:48 UTC October 01, 2019 - 21:00:00 UTC   19 0 35.58976 -120.83334 Paso Robles 48 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1569942021:633541 633541 633541 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 13:50:08 UTC October 01, 2019 - 16:00:00 UTC October 01, 2019 - 16:00:00 UTC 36 0 37.86079 -122.29415 Berkeley 47 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569942021:633542 633542 633542 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:01:30 UTC October 01, 2019 - 16:15:00 UTC October 01, 2019 - 16:15:00 UTC 14 0 36.99019 -121.73674 Watsonville 49 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569942021:633545 633545 633545 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 13:07:00 UTC October 01, 2019 - 21:30:00 UTC   4 0 35.64097 -120.84891 Paso Robles 48 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1569942021:633546 633546 633546 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:25:03 UTC October 01, 2019 - 16:45:00 UTC October 01, 2019 - 16:45:00 UTC 20 0 37.87055 -122.03021 Walnut Creek 33 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569942021:633547 633547 633547 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 13:49:00 UTC October 01, 2019 - 23:00:00 UTC   4 0 41.17032 -121.68866 Burney 50 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1569942021:633548 633548 633548 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:41:22 UTC October 01, 2019 - 17:45:00 UTC October 01, 2019 - 17:45:00 UTC 1 0 34.93489 -120.45556 Santa Maria 52 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633549 633549 633549 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:24:49 UTC October 01, 2019 - 17:00:00 UTC October 01, 2019 - 17:00:00 UTC 1 0 37.29066 -121.95854 Campbell 43 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633550 633550 633550 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:22:00 UTC October 02, 2019 - 00:00:00 UTC   1 0 36.13872 -120.12345 Huron 51 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1569942021:633551 633551 633551 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:22:00 UTC October 02, 2019 - 00:00:00 UTC   1 0 36.13871 -120.12345 Huron 51 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1569942021:633552 633552 633552 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:22:00 UTC October 02, 2019 - 00:00:00 UTC   1 0 36.13868 -120.12345 Huron 51 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1569942021:633554 633554 633554 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:39:03 UTC October 01, 2019 - 17:45:00 UTC October 01, 2019 - 17:45:00 UTC 54 0 40.54673 -122.23841 Palo Cedro 54 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569942021:633558 633558 633558 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:11:49 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 8 0 37.92406 -121.912 Clayton 53 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569942021:633559 633559 633559 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:31:28 UTC October 01, 2019 - 15:30:00 UTC October 01, 2019 - 15:30:00 UTC 1 0 37.61449 -122.40357 San Bruno 55 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569942021:633560 633560 633560 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:16:14 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 40.38603 -122.26401 Cottonwood 56 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633568 633568 633568 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:21:56 UTC October 01, 2019 - 17:15:00 UTC October 01, 2019 - 17:15:00 UTC 1 0 37.74225 -122.16565 Oakland 16 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633571 633571 633571 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:43:05 UTC October 01, 2019 - 17:30:00 UTC October 01, 2019 - 17:30:00 UTC 8 0 36.82023 -119.70132 Clovis 57 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633572 633572 633572 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:23:50 UTC     1 0 37.72031 -122.38494 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633573 633573 633573 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:39:03 UTC October 01, 2019 - 23:00:00 UTC   28 0 38.84408 -122.20342 Guinda 59 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1569942021:633574 633574 633574 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:24:06 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72937 -121.782 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569942021:633575 633575 633575 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:37:21 UTC October 01, 2019 - 17:30:00 UTC October 01, 2019 - 17:30:00 UTC 113 0 35.50372 -120.53148 Creston 58 PG&E is investigating the cause of your outage. 6 PG&E has assigned a crew to assess the outage. 1
1569942021:633580 633580 633580 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:41:49 UTC October 01, 2019 - 17:45:00 UTC October 01, 2019 - 17:45:00 UTC 1 0 36.67409 -120.14191 Kerman 61 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633581 633581 633581 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:33:48 UTC October 01, 2019 - 17:45:00 UTC October 01, 2019 - 17:45:00 UTC 1 0 35.51321 -120.70711 Atascadero 40 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633582 633582 633582 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:36:43 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 38.72181 -121.83119 Woodland 34 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633583 633583 633583 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:39:03 UTC October 01, 2019 - 22:00:00 UTC   2 0 39.11232 -121.06791 Alta Sierra 62 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E repair crew is on-site working to restore power. 2
1569942021:633584 633584 633584 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:40:54 UTC     1 0 37.77368 -122.49814 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569942021:633585 633585 633585 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:42:32 UTC October 01, 2019 - 18:00:00 UTC October 01, 2019 - 18:00:00 UTC 1 0 36.81547 -121.70108 Elkhorn 63 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633586 633586 633586 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:46:55 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 5 0 38.03178 -122.2639 Rodeo 65 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633587 633587 633587 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:47:55 UTC October 01, 2019 - 17:45:00 UTC October 01, 2019 - 17:45:00 UTC 1 0 39.73326 -122.12754 Orland 64 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633588 633588 633588 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:46:55 UTC October 01, 2019 - 18:15:00 UTC October 01, 2019 - 18:15:00 UTC 1 0 38.50659 -122.76356 Larkfield-Wikiup 67 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633589 633589 633589 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:46:58 UTC October 01, 2019 - 19:00:00 UTC October 01, 2019 - 19:00:00 UTC 1 0 38.04554 -121.63728 Bethel Island 66 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569942021:633590 633590 633590 2019-10-01 08:00:21-07:00 49 October 01, 2019 - 14:48:34 UTC October 02, 2019 - 00:00:00 UTC   89 0 34.61365 -120.07835 Santa Ynez 68 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E has assigned a crew to assess the outage. 1

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [outage_snapshots] (
   [id] TEXT PRIMARY KEY,
   [outage] INTEGER REFERENCES [outages]([id]),
   [snapshot] INTEGER REFERENCES [snapshots]([id]),
   [lastUpdateTime] INTEGER,
   [currentEtor] INTEGER,
   [autoEtor] INTEGER,
   [estCustAffected] INTEGER,
   [hazardFlag] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [regionName] INTEGER REFERENCES [regionName]([id]),
   [cause] INTEGER REFERENCES [cause]([id]),
   [crewCurrentStatus] INTEGER REFERENCES [crewCurrentStatus]([id])
)
Powered by Datasette · Query took 4058.784ms · About: About this site