outage_snapshots

40 rows where snapshot = 131

View and edit SQL

id outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1569991222:630055 630055 630055 2019-10-01 21:40:22-07:00 131 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
1569991222:631014 631014 631014 2019-10-01 21:40:22-07:00 131 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
1569991222:633572 633572 633572 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 03:35:55 UTC October 02, 2019 - 06:35:00 UTC   1 0 37.72031 -122.38494 San Francisco 25 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
1569991222:633774 633774 633774 2019-10-01 21:40:22-07:00 131 October 01, 2019 - 20:26:41 UTC October 01, 2019 - 21:00:00 UTC   1 0 38.64604 -120.97578 Cameron Park 101 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E is sending a repair crew to the outage location. 3
1569991222:633849 633849 633849 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 02:32:58 UTC October 02, 2019 - 06:59:00 UTC   19 0 36.82228 -119.80053 Fresno 35 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
1569991222:633862 633862 633862 2019-10-01 21:40:22-07:00 131 October 01, 2019 - 21:39:42 UTC October 02, 2019 - 00:00:00 UTC   12 0 37.80511 -122.17103 Castro Valley 4 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
1569991222:633867 633867 633867 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 00:00:07 UTC October 01, 2019 - 23:00:00 UTC   3 0 36.61702 -119.27686 Orange Cove 136 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E is sending a repair crew to the outage location. 3
1569991222:633869 633869 633869 2019-10-01 21:40:22-07:00 131 October 01, 2019 - 22:02:27 UTC October 01, 2019 - 22:00:00 UTC   1 0 40.51095 -124.01787 Carlotta 139 Our preliminary determination is that your outage was caused by scheduled maintenance work. 3 PG&E is sending a repair crew to the outage location. 3
1569991222:633964 633964 633964 2019-10-01 21:40:22-07:00 131 October 01, 2019 - 23:32:16 UTC October 02, 2019 - 11:00:00 UTC   2 0 37.57104 -121.99067 Fremont 140 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
1569991222:634814 634814 634814 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 02:33:02 UTC October 02, 2019 - 06:59:00 UTC   1 1 38.69436 -121.93466 Woodland 34 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
1569991222:634832 634832 634832 2019-10-01 21:40:22-07:00 131 October 01, 2019 - 21:15:47 UTC October 01, 2019 - 22:00:00 UTC   10 0 38.64148 -120.51459 Grizzly Flats 150 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
1569991222:634839 634839 634839 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 03:08:26 UTC     25 0 37.73528 -122.4484 San Francisco 25 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569991222:635113 635113 635113 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:17:55 UTC October 02, 2019 - 06:00:00 UTC   1 0 37.30889 -121.90237 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569991222:635341 635341 635341 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 02:57:44 UTC October 02, 2019 - 07:01:00 UTC   56 1 36.22648 -121.11113 King City 196 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
1569991222:635354 635354 635354 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 03:17:12 UTC October 02, 2019 - 10:03:00 UTC   53 1 37.54582 -121.9443 Fremont 140 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
1569991222:635363 635363 635363 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:05:58 UTC October 02, 2019 - 06:00:00 UTC   27 1 35.55397 -121.07359 Cambria 3 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
1569991222:635374 635374 635374 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 02:52:20 UTC October 02, 2019 - 06:30:00 UTC   22 0 37.67522 -122.10853 Cherryland 232 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
1569991222:635402 635402 635402 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:26:23 UTC October 01, 2019 - 23:00:00 UTC   36 0 37.00083 -121.59888 Gilroy 223 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
1569991222:635405 635405 635405 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 03:28:29 UTC October 02, 2019 - 05:38:00 UTC   2 0 37.59914 -122.38716 Millbrae 173 Our preliminary determination is that your outage was caused by an emergency issue. 4 PG&E repair crew is on-site working to restore power. 2
1569991222:635407 635407 635407 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 02:47:07 UTC October 02, 2019 - 06:30:00 UTC   1 0 37.67687 -122.10863 Cherryland 232 PG&E is investigating the cause of your outage. 6 PG&E is sending a repair crew to the outage location. 3
1569991222:635415 635415 635415 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 03:50:37 UTC October 02, 2019 - 09:00:00 UTC   14 1 37.36975 -121.8522 San Jose 26 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
1569991222:635433 635433 635433 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 01:11:50 UTC October 02, 2019 - 06:00:00 UTC   32 0 38.98847 -122.8461 Lakeport 75 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
1569991222:635436 635436 635436 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 03:00:46 UTC October 02, 2019 - 08:00:00 UTC   1 0 37.55162 -122.32408 San Mateo 29 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569991222:635437 635437 635437 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:16:09 UTC October 02, 2019 - 08:15:00 UTC   1 1 37.44192 -122.19825 Menlo Park 141 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
1569991222:635440 635440 635440 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:18:30 UTC October 02, 2019 - 07:30:00 UTC   1 0 37.32584 -121.87129 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569991222:635441 635441 635441 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:16:14 UTC October 02, 2019 - 06:00:00 UTC   52 0 37.31986 -121.97287 San Jose 26 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569991222:635442 635442 635442 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:17:02 UTC October 02, 2019 - 06:00:00 UTC   45 0 37.31943 -121.96799 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569991222:635453 635453 635453 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:08:14 UTC October 02, 2019 - 07:31:00 UTC   1 0 37.52943 -122.34497 Highlands-Baywood Park 74 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569991222:635454 635454 635454 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 01:50:51 UTC October 02, 2019 - 06:59:00 UTC   28 0 37.3989 -122.09166 Mountain View 242 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
1569991222:635459 635459 635459 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 02:38:01 UTC     1 0 37.72681 -122.4397 San Francisco 25 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
1569991222:635461 635461 635461 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:20:47 UTC October 02, 2019 - 05:20:00 UTC   1 1 38.89263 -121.2845 Lincoln 245 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569991222:635498 635498 635498 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:27:12 UTC October 02, 2019 - 06:00:00 UTC   1 0 37.45352 -121.90816 Milpitas 142 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569991222:635517 635517 635517 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:09:15 UTC October 02, 2019 - 05:45:00 UTC October 02, 2019 - 05:45:00 UTC 13 0 37.2816 -121.8698 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569991222:635519 635519 635519 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 03:21:10 UTC October 02, 2019 - 06:00:00 UTC October 02, 2019 - 06:00:00 UTC 3 0 37.2795 -121.86861 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569991222:635520 635520 635520 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 03:06:10 UTC October 02, 2019 - 06:00:00 UTC October 02, 2019 - 06:00:00 UTC 1 0 37.2853 -121.87071 San Jose 26 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1569991222:635533 635533 635533 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 03:37:50 UTC October 02, 2019 - 06:00:00 UTC October 02, 2019 - 06:00:00 UTC 1 1 37.98437 -122.32811 Richmond 220 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569991222:635553 635553 635553 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:29:00 UTC October 02, 2019 - 06:30:00 UTC October 02, 2019 - 06:30:00 UTC 8 0 37.29316 -120.45997 Merced 13 Our preliminary determination is that your outage was caused by an equipment issue. 2 PG&E is assessing the cause at the outage location. 4
1569991222:635594 635594 635594 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:06:49 UTC October 02, 2019 - 09:00:00 UTC October 02, 2019 - 09:00:00 UTC 1 1 35.41186 -119.02374 Oildale 246 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569991222:635595 635595 635595 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 03:58:19 UTC October 02, 2019 - 05:15:00 UTC October 02, 2019 - 05:15:00 UTC 2 0 38.07448 -121.97359 Suisun City 243 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569991222:635613 635613 635613 2019-10-01 21:40:22-07:00 131 October 02, 2019 - 04:22:46 UTC October 02, 2019 - 12:00:00 UTC   64 0 39.71478 -121.81644 Chico 41 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

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 4348.101ms · About: About this site