outage_snapshots

2,805 rows where regionName = 194

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ outage snapshot lastUpdateTime currentEtor autoEtor estCustAffected hazardFlag latitude longitude regionName cause crewCurrentStatus
1569963629:634823 634823 634823 2019-10-01 14:00:29-07:00 85 October 01, 2019 - 20:44:56 UTC October 01, 2019 - 22:30:00 UTC October 01, 2019 - 22:30:00 UTC 1 0 36.5535 -119.4051 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569964228:634823 634823 634823 2019-10-01 14:10:28-07:00 86 October 01, 2019 - 20:44:56 UTC October 01, 2019 - 22:30:00 UTC October 01, 2019 - 22:30:00 UTC 1 0 36.5535 -119.4051 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569964818:634823 634823 634823 2019-10-01 14:20:18-07:00 87 October 01, 2019 - 20:44:56 UTC October 01, 2019 - 22:30:00 UTC October 01, 2019 - 22:30:00 UTC 1 0 36.5535 -119.4051 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569965440:634823 634823 634823 2019-10-01 14:30:40-07:00 88 October 01, 2019 - 20:44:56 UTC October 01, 2019 - 22:30:00 UTC October 01, 2019 - 22:30:00 UTC 1 0 36.5535 -119.4051 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1569966020:634823 634823 634823 2019-10-01 14:40:20-07:00 89 October 01, 2019 - 21:30:03 UTC October 01, 2019 - 22:30:00 UTC October 01, 2019 - 22:30:00 UTC 1 0 36.5535 -119.4051 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569966613:634823 634823 634823 2019-10-01 14:50:13-07:00 90 October 01, 2019 - 21:30:03 UTC October 01, 2019 - 22:30:00 UTC October 01, 2019 - 22:30:00 UTC 1 0 36.5535 -119.4051 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1569967246:634823 634823 634823 2019-10-01 15:00:46-07:00 91 October 01, 2019 - 21:30:03 UTC October 01, 2019 - 22:30:00 UTC October 01, 2019 - 22:30:00 UTC 1 0 36.5535 -119.4051 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570030223:635778 635778 635778 2019-10-02 08:30:23-07:00 187 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570030821:635778 635778 635778 2019-10-02 08:40:21-07:00 188 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570031422:635778 635778 635778 2019-10-02 08:50:22-07:00 189 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570032029:635778 635778 635778 2019-10-02 09:00:29-07:00 190 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570032635:635778 635778 635778 2019-10-02 09:10:35-07:00 191 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570033232:635778 635778 635778 2019-10-02 09:20:32-07:00 192 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570033830:635778 635778 635778 2019-10-02 09:30:30-07:00 193 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570034425:635778 635778 635778 2019-10-02 09:40:25-07:00 194 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570035025:635778 635778 635778 2019-10-02 09:50:25-07:00 195 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570035638:635778 635778 635778 2019-10-02 10:00:38-07:00 196 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570036222:635778 635778 635778 2019-10-02 10:10:22-07:00 197 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570036832:635778 635778 635778 2019-10-02 10:20:32-07:00 198 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570037426:635778 635778 635778 2019-10-02 10:30:26-07:00 199 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570038018:635778 635778 635778 2019-10-02 10:40:18-07:00 200 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570038618:635778 635778 635778 2019-10-02 10:50:18-07:00 201 October 02, 2019 - 15:20:04 UTC October 02, 2019 - 20:00:00 UTC   46 0 36.53868 -119.38008 Dinuba 194 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
1570062022:638799 638799 638799 2019-10-02 17:20:22-07:00 240 October 03, 2019 - 00:10:40 UTC October 03, 2019 - 01:45:00 UTC October 03, 2019 - 01:45:00 UTC 1 1 36.55182 -119.38525 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570062631:638799 638799 638799 2019-10-02 17:30:31-07:00 241 October 03, 2019 - 00:10:40 UTC October 03, 2019 - 01:45:00 UTC October 03, 2019 - 01:45:00 UTC 1 1 36.55182 -119.38525 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570063216:638799 638799 638799 2019-10-02 17:40:16-07:00 242 October 03, 2019 - 00:10:40 UTC October 03, 2019 - 01:45:00 UTC October 03, 2019 - 01:45:00 UTC 1 1 36.55182 -119.38525 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570063816:638799 638799 638799 2019-10-02 17:50:16-07:00 243 October 03, 2019 - 00:10:40 UTC October 03, 2019 - 01:45:00 UTC October 03, 2019 - 01:45:00 UTC 1 1 36.55182 -119.38525 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570064430:638799 638799 638799 2019-10-02 18:00:30-07:00 244 October 03, 2019 - 00:50:09 UTC October 03, 2019 - 01:45:00 UTC October 03, 2019 - 01:45:00 UTC 1 1 36.55182 -119.38525 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570065022:638799 638799 638799 2019-10-02 18:10:22-07:00 245 October 03, 2019 - 01:06:30 UTC October 03, 2019 - 01:45:00 UTC October 03, 2019 - 01:45:00 UTC 1 1 36.55182 -119.38525 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570065616:638799 638799 638799 2019-10-02 18:20:16-07:00 246 October 03, 2019 - 01:15:57 UTC October 03, 2019 - 03:45:00 UTC   1 1 36.55182 -119.38525 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570066217:638799 638799 638799 2019-10-02 18:30:17-07:00 247 October 03, 2019 - 01:15:57 UTC October 03, 2019 - 03:45:00 UTC   1 1 36.55182 -119.38525 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570066840:638799 638799 638799 2019-10-02 18:40:40-07:00 248 October 03, 2019 - 01:15:57 UTC October 03, 2019 - 03:45:00 UTC   1 1 36.55182 -119.38525 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570067419:638799 638799 638799 2019-10-02 18:50:19-07:00 249 October 03, 2019 - 01:15:57 UTC October 03, 2019 - 03:45:00 UTC   1 1 36.55182 -119.38525 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570068016:638799 638799 638799 2019-10-02 19:00:16-07:00 250 October 03, 2019 - 01:15:57 UTC October 03, 2019 - 03:45:00 UTC   1 1 36.55182 -119.38525 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570068627:638799 638799 638799 2019-10-02 19:10:27-07:00 251 October 03, 2019 - 01:15:57 UTC October 03, 2019 - 03:45:00 UTC   1 1 36.55182 -119.38525 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570069252:638799 638799 638799 2019-10-02 19:20:52-07:00 252 October 03, 2019 - 01:15:57 UTC October 03, 2019 - 03:45:00 UTC   1 1 36.55182 -119.38525 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570069819:638799 638799 638799 2019-10-02 19:30:19-07:00 253 October 03, 2019 - 01:15:57 UTC October 03, 2019 - 03:45:00 UTC   1 1 36.55182 -119.38525 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570070412:638799 638799 638799 2019-10-02 19:40:12-07:00 254 October 03, 2019 - 01:15:57 UTC October 03, 2019 - 03:45:00 UTC   1 1 36.55182 -119.38525 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570126823:639736 639736 639736 2019-10-03 11:20:23-07:00 347 October 03, 2019 - 18:13:05 UTC October 03, 2019 - 20:00:00 UTC October 03, 2019 - 20:00:00 UTC 1 1 36.54811 -119.3996 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570127427:639736 639736 639736 2019-10-03 11:30:27-07:00 348 October 03, 2019 - 18:13:05 UTC October 03, 2019 - 20:00:00 UTC October 03, 2019 - 20:00:00 UTC 1 1 36.54811 -119.3996 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570128024:639736 639736 639736 2019-10-03 11:40:24-07:00 349 October 03, 2019 - 18:13:05 UTC October 03, 2019 - 20:00:00 UTC October 03, 2019 - 20:00:00 UTC 1 1 36.54811 -119.3996 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570128625:639736 639736 639736 2019-10-03 11:50:25-07:00 350 October 03, 2019 - 18:44:26 UTC October 03, 2019 - 20:00:00 UTC October 03, 2019 - 20:00:00 UTC 1 1 36.54811 -119.3996 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570129232:639736 639736 639736 2019-10-03 12:00:32-07:00 351 October 03, 2019 - 18:44:26 UTC October 03, 2019 - 20:00:00 UTC October 03, 2019 - 20:00:00 UTC 1 1 36.54811 -119.3996 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570129818:639736 639736 639736 2019-10-03 12:10:18-07:00 352 October 03, 2019 - 18:58:08 UTC October 03, 2019 - 20:00:00 UTC October 03, 2019 - 20:00:00 UTC 1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570130416:639736 639736 639736 2019-10-03 12:20:16-07:00 353 October 03, 2019 - 18:58:08 UTC October 03, 2019 - 20:00:00 UTC October 03, 2019 - 20:00:00 UTC 1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570131013:639736 639736 639736 2019-10-03 12:30:13-07:00 354 October 03, 2019 - 18:58:08 UTC October 03, 2019 - 20:00:00 UTC October 03, 2019 - 20:00:00 UTC 1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570131617:639736 639736 639736 2019-10-03 12:40:17-07:00 355 October 03, 2019 - 18:58:08 UTC October 03, 2019 - 20:00:00 UTC October 03, 2019 - 20:00:00 UTC 1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570132216:639736 639736 639736 2019-10-03 12:50:16-07:00 356 October 03, 2019 - 18:58:08 UTC October 03, 2019 - 20:00:00 UTC October 03, 2019 - 20:00:00 UTC 1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570132828:639736 639736 639736 2019-10-03 13:00:28-07:00 357 October 03, 2019 - 19:48:06 UTC October 03, 2019 - 22:00:00 UTC   1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570133424:639736 639736 639736 2019-10-03 13:10:24-07:00 358 October 03, 2019 - 19:48:06 UTC October 03, 2019 - 22:00:00 UTC   1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570134019:639736 639736 639736 2019-10-03 13:20:19-07:00 359 October 03, 2019 - 19:48:06 UTC October 03, 2019 - 22:00:00 UTC   1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570134619:639736 639736 639736 2019-10-03 13:30:19-07:00 360 October 03, 2019 - 19:48:06 UTC October 03, 2019 - 22:00:00 UTC   1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570135216:639736 639736 639736 2019-10-03 13:40:16-07:00 361 October 03, 2019 - 19:48:06 UTC October 03, 2019 - 22:00:00 UTC   1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570135822:639736 639736 639736 2019-10-03 13:50:22-07:00 362 October 03, 2019 - 19:48:06 UTC October 03, 2019 - 22:00:00 UTC   1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570136415:639736 639736 639736 2019-10-03 14:00:15-07:00 363 October 03, 2019 - 19:48:06 UTC October 03, 2019 - 22:00:00 UTC   1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570137013:639736 639736 639736 2019-10-03 14:10:13-07:00 364 October 03, 2019 - 19:48:06 UTC October 03, 2019 - 22:00:00 UTC   1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570137617:639736 639736 639736 2019-10-03 14:20:17-07:00 365 October 03, 2019 - 19:48:06 UTC October 03, 2019 - 22:00:00 UTC   1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570138249:639736 639736 639736 2019-10-03 14:30:49-07:00 366 October 03, 2019 - 19:48:06 UTC October 03, 2019 - 22:00:00 UTC   1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570138824:639736 639736 639736 2019-10-03 14:40:24-07:00 367 October 03, 2019 - 19:48:06 UTC October 03, 2019 - 22:00:00 UTC   1 1 36.54811 -119.3996 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570410038:645713 645713 645713 2019-10-06 18:00:38-07:00 814 October 07, 2019 - 00:54:00 UTC October 07, 2019 - 03:15:00 UTC October 07, 2019 - 03:15:00 UTC 1 1 36.53169 -119.44365 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570410621:645713 645713 645713 2019-10-06 18:10:21-07:00 815 October 07, 2019 - 00:54:00 UTC October 07, 2019 - 03:15:00 UTC October 07, 2019 - 03:15:00 UTC 1 1 36.53169 -119.44365 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570411222:645713 645713 645713 2019-10-06 18:20:22-07:00 816 October 07, 2019 - 01:09:34 UTC October 07, 2019 - 03:15:00 UTC October 07, 2019 - 03:15:00 UTC 1 1 36.53169 -119.44365 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570411820:645713 645713 645713 2019-10-06 18:30:20-07:00 817 October 07, 2019 - 01:09:34 UTC October 07, 2019 - 03:15:00 UTC October 07, 2019 - 03:15:00 UTC 1 1 36.53169 -119.44365 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570412413:645713 645713 645713 2019-10-06 18:40:13-07:00 818 October 07, 2019 - 01:34:12 UTC October 07, 2019 - 03:15:00 UTC October 07, 2019 - 03:15:00 UTC 1 1 36.53169 -119.44365 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570413023:645713 645713 645713 2019-10-06 18:50:23-07:00 819 October 07, 2019 - 01:42:33 UTC October 07, 2019 - 03:15:00 UTC October 07, 2019 - 03:15:00 UTC 1 1 36.53169 -119.44365 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570413611:645713 645713 645713 2019-10-06 19:00:11-07:00 820 October 07, 2019 - 01:48:08 UTC October 07, 2019 - 03:15:00 UTC October 07, 2019 - 03:15:00 UTC 1 1 36.53169 -119.44365 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570414220:645713 645713 645713 2019-10-06 19:10:20-07:00 821 October 07, 2019 - 01:48:08 UTC October 07, 2019 - 03:15:00 UTC October 07, 2019 - 03:15:00 UTC 1 1 36.53169 -119.44365 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570465214:645923 645923 645923 2019-10-07 09:20:14-07:00 903 October 07, 2019 - 16:14:38 UTC October 07, 2019 - 18:45:00 UTC October 07, 2019 - 18:45:00 UTC 3 0 36.53152 -119.41856 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570465831:645923 645923 645923 2019-10-07 09:30:31-07:00 904 October 07, 2019 - 16:16:27 UTC October 07, 2019 - 18:45:00 UTC October 07, 2019 - 18:45:00 UTC 3 0 36.53152 -119.41856 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570466425:645923 645923 645923 2019-10-07 09:40:25-07:00 905 October 07, 2019 - 16:28:46 UTC October 07, 2019 - 18:45:00 UTC October 07, 2019 - 18:45:00 UTC 3 0 36.53152 -119.41856 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570467027:645923 645923 645923 2019-10-07 09:50:27-07:00 906 October 07, 2019 - 16:28:46 UTC October 07, 2019 - 18:45:00 UTC October 07, 2019 - 18:45:00 UTC 3 0 36.53152 -119.41856 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570467625:645923 645923 645923 2019-10-07 10:00:25-07:00 907 October 07, 2019 - 16:51:12 UTC October 07, 2019 - 18:45:00 UTC October 07, 2019 - 18:45:00 UTC 3 0 36.53152 -119.41856 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570549828:647133 647133 647133 2019-10-08 08:50:28-07:00 1038 October 08, 2019 - 15:37:42 UTC October 08, 2019 - 18:15:00 UTC October 08, 2019 - 18:15:00 UTC 1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570550450:647133 647133 647133 2019-10-08 09:00:50-07:00 1039 October 08, 2019 - 15:37:42 UTC October 08, 2019 - 18:15:00 UTC October 08, 2019 - 18:15:00 UTC 1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570551020:647133 647133 647133 2019-10-08 09:10:20-07:00 1040 October 08, 2019 - 15:37:42 UTC October 08, 2019 - 18:15:00 UTC October 08, 2019 - 18:15:00 UTC 1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570551625:647133 647133 647133 2019-10-08 09:20:25-07:00 1041 October 08, 2019 - 15:37:42 UTC October 08, 2019 - 18:15:00 UTC October 08, 2019 - 18:15:00 UTC 1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570552216:647133 647133 647133 2019-10-08 09:30:16-07:00 1042 October 08, 2019 - 15:37:42 UTC October 08, 2019 - 18:15:00 UTC October 08, 2019 - 18:15:00 UTC 1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570552819:647133 647133 647133 2019-10-08 09:40:19-07:00 1043 October 08, 2019 - 15:37:42 UTC October 08, 2019 - 18:15:00 UTC October 08, 2019 - 18:15:00 UTC 1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570553431:647133 647133 647133 2019-10-08 09:50:31-07:00 1044 October 08, 2019 - 15:37:42 UTC October 08, 2019 - 18:15:00 UTC October 08, 2019 - 18:15:00 UTC 1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570554040:647133 647133 647133 2019-10-08 10:00:40-07:00 1045 October 08, 2019 - 15:37:42 UTC October 08, 2019 - 18:15:00 UTC October 08, 2019 - 18:15:00 UTC 1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570554619:647133 647133 647133 2019-10-08 10:10:19-07:00 1046 October 08, 2019 - 15:37:42 UTC October 08, 2019 - 18:15:00 UTC October 08, 2019 - 18:15:00 UTC 1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570555224:647133 647133 647133 2019-10-08 10:20:24-07:00 1047 October 08, 2019 - 15:37:42 UTC October 08, 2019 - 18:15:00 UTC October 08, 2019 - 18:15:00 UTC 1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570555829:647133 647133 647133 2019-10-08 10:30:29-07:00 1048 October 08, 2019 - 15:37:42 UTC October 08, 2019 - 18:15:00 UTC October 08, 2019 - 18:15:00 UTC 1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570556461:647133 647133 647133 2019-10-08 10:41:01-07:00 1049 October 08, 2019 - 15:37:42 UTC October 08, 2019 - 18:15:00 UTC October 08, 2019 - 18:15:00 UTC 1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570557027:647133 647133 647133 2019-10-08 10:50:27-07:00 1050 October 08, 2019 - 17:37:35 UTC October 08, 2019 - 18:15:00 UTC October 08, 2019 - 18:15:00 UTC 1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570557622:647133 647133 647133 2019-10-08 11:00:22-07:00 1051 October 08, 2019 - 17:47:18 UTC October 08, 2019 - 22:30:00 UTC   1 0 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570558228:647133 647133 647133 2019-10-08 11:10:28-07:00 1052 October 08, 2019 - 18:03:04 UTC October 08, 2019 - 22:30:00 UTC   1 1 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570558831:647133 647133 647133 2019-10-08 11:20:31-07:00 1053 October 08, 2019 - 18:11:07 UTC October 08, 2019 - 22:30:00 UTC   1 1 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570559421:647133 647133 647133 2019-10-08 11:30:21-07:00 1054 October 08, 2019 - 18:11:07 UTC October 08, 2019 - 22:30:00 UTC   1 1 36.54812 -119.39777 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570560032:647133 647133 647133 2019-10-08 11:40:32-07:00 1055 October 08, 2019 - 18:28:29 UTC October 08, 2019 - 22:30:00 UTC   1 1 36.54812 -119.39777 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570560622:647133 647133 647133 2019-10-08 11:50:22-07:00 1056 October 08, 2019 - 18:37:49 UTC October 08, 2019 - 22:30:00 UTC   1 1 36.54812 -119.39777 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570561220:647133 647133 647133 2019-10-08 12:00:20-07:00 1057 October 08, 2019 - 18:54:50 UTC October 08, 2019 - 22:30:00 UTC   1 1 36.54812 -119.39777 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570561817:647133 647133 647133 2019-10-08 12:10:17-07:00 1058 October 08, 2019 - 18:54:50 UTC October 08, 2019 - 22:30:00 UTC   1 1 36.54812 -119.39777 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570562420:647133 647133 647133 2019-10-08 12:20:20-07:00 1059 October 08, 2019 - 18:54:50 UTC October 08, 2019 - 22:30:00 UTC   1 1 36.54812 -119.39777 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570719638:652645 652645 652645 2019-10-10 08:00:38-07:00 1246 October 10, 2019 - 14:49:42 UTC October 10, 2019 - 16:30:00 UTC October 10, 2019 - 16:30:00 UTC 1 0 36.55504 -119.35617 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570720242:652645 652645 652645 2019-10-10 08:10:42-07:00 1247 October 10, 2019 - 14:49:42 UTC October 10, 2019 - 16:30:00 UTC October 10, 2019 - 16:30:00 UTC 1 0 36.55504 -119.35617 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570721434:652645 652645 652645 2019-10-10 08:30:34-07:00 1249 October 10, 2019 - 15:19:51 UTC October 10, 2019 - 16:30:00 UTC October 10, 2019 - 16:30:00 UTC 1 0 36.55504 -119.35617 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570722617:652645 652645 652645 2019-10-10 08:50:17-07:00 1250 October 10, 2019 - 14:49:42 UTC October 10, 2019 - 16:30:00 UTC October 10, 2019 - 16:30:00 UTC 1 0 36.55504 -119.35617 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E has assigned a crew to assess the outage. 1
1570727441:652645 652645 652645 2019-10-10 10:10:41-07:00 1251 October 10, 2019 - 15:39:15 UTC October 10, 2019 - 16:30:00 UTC October 10, 2019 - 16:30:00 UTC 1 0 36.55504 -119.35617 Dinuba 194 PG&E is investigating the cause of your outage. 6 PG&E is assessing the cause at the outage location. 4
1570741827:653364 653364 653364 2019-10-10 14:10:27-07:00 1258 October 10, 2019 - 20:43:18 UTC October 10, 2019 - 23:15:00 UTC October 10, 2019 - 23:15:00 UTC 1 1 36.53705 -119.38314 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5
1570742417:653364 653364 653364 2019-10-10 14:20:17-07:00 1259 October 10, 2019 - 20:43:18 UTC October 10, 2019 - 23:15:00 UTC October 10, 2019 - 23:15:00 UTC 1 1 36.53705 -119.38314 Dinuba 194 Unknown - PG&E will be assessing the cause. 1 PG&E assessment crew is en route to the outage. 5

Next page

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])
);
CREATE INDEX [idx_outage_snapshots_outage]
    ON [outage_snapshots] ([outage]);