outages

82 rows where regionName = 150

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices
633914 October 01, 2019 - 17:22:00 UTC 38.62926 -120.53545 Grizzly Flats 150 []
634235 October 01, 2019 - 19:17:00 UTC 38.63536 -120.5339 Grizzly Flats 150 []
634832 October 01, 2019 - 20:51:00 UTC 38.64148 -120.51459 Grizzly Flats 150 [{"latitude": "38.6407", "longitude": "-120.51586"}, {"latitude": "38.64114", "longitude": "-120.51571"}, {"latitude": "38.64201", "longitude": "-120.51558"}, {"latitude": "38.64224", "longitude": "-120.51677"}, {"latitude": "38.64111", "longitude": "-120.51922"}]
639068 October 03, 2019 - 15:37:00 UTC 38.63081 -120.54935 Grizzly Flats 150 []
646001 October 07, 2019 - 17:05:00 UTC 38.63813 -120.51765 Grizzly Flats 150 [{"latitude": "38.63616", "longitude": "-120.51728"}, {"latitude": "38.6373", "longitude": "-120.5172"}, {"latitude": "38.63789", "longitude": "-120.51726"}, {"latitude": "38.63654", "longitude": "-120.51785"}]
649771 October 09, 2019 - 10:41:52 UTC 38.63383 -120.55215 Grizzly Flats 150 []
649792 October 09, 2019 - 10:44:36 UTC 38.64509 -120.52206 Grizzly Flats 150 []
650406 October 09, 2019 - 10:35:00 UTC 38.62158 -120.58666 Grizzly Flats 150 [{"latitude": "38.61973", "longitude": "-120.58396"}, {"latitude": "38.62055", "longitude": "-120.57013"}, {"latitude": "38.6336", "longitude": "-120.55589"}, {"latitude": "38.64733", "longitude": "-120.5494"}, {"latitude": "38.65681", "longitude": "-120.55524"}, {"latitude": "38.65053", "longitude": "-120.5676"}, {"latitude": "38.6423", "longitude": "-120.57533"}]
654849 October 12, 2019 - 01:34:00 UTC 38.6295 -120.53471 Grizzly Flats 150 []
655060 October 12, 2019 - 14:32:42 UTC 38.6295 -120.53471 Grizzly Flats 150 []
658624 October 14, 2019 - 23:26:10 UTC 38.63882 -120.51737 Grizzly Flats 150 []
660633 October 16, 2019 - 16:22:25 UTC 38.62942 -120.55021 Grizzly Flats 150 []
660729 October 16, 2019 - 17:09:41 UTC 38.63436 -120.53447 Grizzly Flats 150 []
664094 October 17, 2019 - 16:19:42 UTC 38.63808 -120.52411 Grizzly Flats 150 []
664233 October 17, 2019 - 16:46:05 UTC 38.64068 -120.50978 Grizzly Flats 150 []
678697 October 23, 2019 - 23:10:00 UTC 38.64079 -120.50907 Grizzly Flats 150 []
678705 October 23, 2019 - 23:10:23 UTC 38.63269 -120.54582 Grizzly Flats 150 [{"latitude": "38.62133", "longitude": "-120.55155"}, {"latitude": "38.6219", "longitude": "-120.5503"}, {"latitude": "38.62962", "longitude": "-120.54464"}, {"latitude": "38.63206", "longitude": "-120.54569"}, {"latitude": "38.63212", "longitude": "-120.54988"}, {"latitude": "38.62553", "longitude": "-120.55737"}, {"latitude": "38.62293", "longitude": "-120.5588"}, {"latitude": "38.6221", "longitude": "-120.55842"}, {"latitude": "38.62186", "longitude": "-120.55782"}]
678905 October 23, 2019 - 19:53:54 UTC 38.62158 -120.58666 Grizzly Flats 150 [{"latitude": "38.61973", "longitude": "-120.58396"}, {"latitude": "38.62055", "longitude": "-120.57013"}, {"latitude": "38.6336", "longitude": "-120.55589"}, {"latitude": "38.64733", "longitude": "-120.5494"}, {"latitude": "38.65681", "longitude": "-120.55524"}, {"latitude": "38.65053", "longitude": "-120.5676"}, {"latitude": "38.6423", "longitude": "-120.57533"}]
684478 October 27, 2019 - 03:05:00 UTC 38.62158 -120.58666 Grizzly Flats 150 [{"latitude": "38.61973", "longitude": "-120.58396"}, {"latitude": "38.62055", "longitude": "-120.57013"}, {"latitude": "38.6336", "longitude": "-120.55589"}, {"latitude": "38.64733", "longitude": "-120.5494"}, {"latitude": "38.65681", "longitude": "-120.55524"}, {"latitude": "38.65053", "longitude": "-120.5676"}, {"latitude": "38.6423", "longitude": "-120.57533"}]
684567 October 27, 2019 - 04:53:22 UTC 38.63179 -120.55132 Grizzly Flats 150 []
692216 October 27, 2019 - 03:08:00 UTC 38.63313 -120.53933 Grizzly Flats 150 [{"latitude": "38.62133", "longitude": "-120.55155"}, {"latitude": "38.6219", "longitude": "-120.5503"}, {"latitude": "38.62854", "longitude": "-120.54185"}, {"latitude": "38.63305", "longitude": "-120.5399"}, {"latitude": "38.63572", "longitude": "-120.5395"}, {"latitude": "38.63878", "longitude": "-120.54621"}, {"latitude": "38.63483", "longitude": "-120.55336"}, {"latitude": "38.62293", "longitude": "-120.5588"}, {"latitude": "38.6221", "longitude": "-120.55842"}, {"latitude": "38.62186", "longitude": "-120.55782"}]
695199 October 27, 2019 - 03:05:00 UTC 38.62487 -120.57036 Grizzly Flats 150 [{"latitude": "38.62055", "longitude": "-120.57013"}, {"latitude": "38.62229", "longitude": "-120.56973"}, {"latitude": "38.62364", "longitude": "-120.57099"}]
696822 October 31, 2019 - 20:10:24 UTC 38.62055 -120.57013 Grizzly Flats 150 []
705930 November 13, 2019 - 17:03:00 UTC 38.63252 -120.53326 Grizzly Flats 150 []
708220 November 16, 2019 - 17:29:56 UTC 38.63234 -120.54279 Grizzly Flats 150 []
709146 November 18, 2019 - 17:11:03 UTC 38.63999 -120.51846 Grizzly Flats 150 []
709990 November 19, 2019 - 17:27:00 UTC 38.63279 -120.53541 Grizzly Flats 150 [{"latitude": "38.63308", "longitude": "-120.5355"}, {"latitude": "38.63427", "longitude": "-120.53382"}, {"latitude": "38.63774", "longitude": "-120.53142"}, {"latitude": "38.64031", "longitude": "-120.53113"}, {"latitude": "38.64162", "longitude": "-120.53161"}, {"latitude": "38.64949", "longitude": "-120.53614"}, {"latitude": "38.64635", "longitude": "-120.5408"}]
712348 November 21, 2019 - 20:54:00 UTC 38.63169 -120.5485 Grizzly Flats 150 []
712755 November 22, 2019 - 16:56:00 UTC 38.6368 -120.53879 Grizzly Flats 150 [{"latitude": "38.63682", "longitude": "-120.5394"}, {"latitude": "38.63959", "longitude": "-120.53879"}, {"latitude": "38.64023", "longitude": "-120.53896"}, {"latitude": "38.6407", "longitude": "-120.54"}, {"latitude": "38.64132", "longitude": "-120.54432"}, {"latitude": "38.63851", "longitude": "-120.54379"}, {"latitude": "38.63755", "longitude": "-120.54171"}, {"latitude": "38.63687", "longitude": "-120.54011"}]
712954 November 22, 2019 - 19:27:59 UTC 38.64408 -120.51371 Grizzly Flats 150 []
713374 November 23, 2019 - 16:32:52 UTC 38.63355 -120.55815 Grizzly Flats 150 []
713443 November 23, 2019 - 17:48:09 UTC 38.631 -120.54535 Grizzly Flats 150 []
713471 November 23, 2019 - 16:04:00 UTC 38.63919 -120.51005 Grizzly Flats 150 [{"latitude": "38.63894", "longitude": "-120.50806"}, {"latitude": "38.64013", "longitude": "-120.50812"}, {"latitude": "38.64172", "longitude": "-120.50828"}, {"latitude": "38.64379", "longitude": "-120.51065"}, {"latitude": "38.64511", "longitude": "-120.51302"}, {"latitude": "38.64477", "longitude": "-120.51534"}, {"latitude": "38.64456", "longitude": "-120.516"}, {"latitude": "38.64111", "longitude": "-120.51922"}]
713520 November 23, 2019 - 20:26:00 UTC 38.64201 -120.51558 Grizzly Flats 150 []
719179 November 27, 2019 - 06:18:34 UTC 38.62055 -120.57013 Grizzly Flats 150 []
719202 November 27, 2019 - 06:24:28 UTC 38.6219 -120.59406 Grizzly Flats 150 []
719231 November 27, 2019 - 06:32:58 UTC 38.6235 -120.58768 Grizzly Flats 150 []
720031 November 27, 2019 - 13:17:00 UTC 38.63355 -120.53167 Grizzly Flats 150 []
720034 November 27, 2019 - 13:17:00 UTC 38.63308 -120.5355 Grizzly Flats 150 []
720035 November 27, 2019 - 13:17:00 UTC 38.63081 -120.54935 Grizzly Flats 150 []
720036 November 27, 2019 - 13:18:00 UTC 38.63203 -120.54668 Grizzly Flats 150 []
720037 November 27, 2019 - 13:21:19 UTC 38.63687 -120.54354 Grizzly Flats 150 []
720038 November 27, 2019 - 13:17:00 UTC 38.64261 -120.51819 Grizzly Flats 150 []
720039 November 27, 2019 - 13:18:00 UTC 38.63919 -120.51005 Grizzly Flats 150 []
720044 November 27, 2019 - 13:21:19 UTC 38.63687 -120.54354 Grizzly Flats 150 []
721034 November 27, 2019 - 18:12:12 UTC 38.63307 -120.54215 Grizzly Flats 150 [{"latitude": "38.6334", "longitude": "-120.5421"}, {"latitude": "38.63494", "longitude": "-120.53982"}, {"latitude": "38.63572", "longitude": "-120.5395"}, {"latitude": "38.63878", "longitude": "-120.54621"}, {"latitude": "38.63743", "longitude": "-120.54734"}, {"latitude": "38.63578", "longitude": "-120.54652"}]
721153 November 27, 2019 - 18:39:00 UTC 38.63834 -120.53362 Grizzly Flats 150 []
721154 November 27, 2019 - 18:39:00 UTC 38.65734 -120.52833 Grizzly Flats 150 [{"latitude": "38.65046", "longitude": "-120.53686"}, {"latitude": "38.65264", "longitude": "-120.53065"}, {"latitude": "38.65512", "longitude": "-120.53152"}, {"latitude": "38.65652", "longitude": "-120.53727"}, {"latitude": "38.65375", "longitude": "-120.53717"}]
721155 November 27, 2019 - 18:39:00 UTC 38.63636 -120.53664 Grizzly Flats 150 []
721158 November 27, 2019 - 18:39:00 UTC 38.64006 -120.517 Grizzly Flats 150 []
721166 November 27, 2019 - 18:40:00 UTC 38.64261 -120.51819 Grizzly Flats 150 []
721182 November 27, 2019 - 18:41:00 UTC 38.63355 -120.53167 Grizzly Flats 150 []
721186 November 27, 2019 - 18:41:17 UTC 38.63266 -120.54765 Grizzly Flats 150 []
722060 November 28, 2019 - 01:17:00 UTC 38.63307 -120.54215 Grizzly Flats 150 [{"latitude": "38.6334", "longitude": "-120.5421"}, {"latitude": "38.63494", "longitude": "-120.53982"}, {"latitude": "38.63572", "longitude": "-120.5395"}, {"latitude": "38.63878", "longitude": "-120.54621"}, {"latitude": "38.63743", "longitude": "-120.54734"}, {"latitude": "38.63578", "longitude": "-120.54652"}]
722139 November 28, 2019 - 02:05:00 UTC 38.62291 -120.55073 Grizzly Flats 150 []
722495 November 28, 2019 - 07:57:00 UTC 38.6394 -120.52001 Grizzly Flats 150 []
722506 November 28, 2019 - 08:08:14 UTC 38.64324 -120.53579 Grizzly Flats 150 []
722552 November 28, 2019 - 11:23:00 UTC 38.63743 -120.54734 Grizzly Flats 150 []
722659 November 28, 2019 - 15:43:00 UTC 38.62158 -120.58666 Grizzly Flats 150 [{"latitude": "38.61973", "longitude": "-120.58396"}, {"latitude": "38.62055", "longitude": "-120.57013"}, {"latitude": "38.6336", "longitude": "-120.55589"}, {"latitude": "38.64733", "longitude": "-120.5494"}, {"latitude": "38.65681", "longitude": "-120.55524"}, {"latitude": "38.65053", "longitude": "-120.5676"}, {"latitude": "38.6423", "longitude": "-120.57533"}]
722908 November 28, 2019 - 19:37:52 UTC 38.62024 -120.57979 Grizzly Flats 150 []
724302 November 30, 2019 - 21:33:00 UTC 38.64054 -120.51344 Grizzly Flats 150 []
725160 December 01, 2019 - 04:24:00 UTC 38.64054 -120.51344 Grizzly Flats 150 []
728606 December 03, 2019 - 18:10:00 UTC 38.63228 -120.5435 Grizzly Flats 150 [{"latitude": "38.63036", "longitude": "-120.544"}, {"latitude": "38.63158", "longitude": "-120.54398"}, {"latitude": "38.63084", "longitude": "-120.54428"}]
730346 December 05, 2019 - 16:51:56 UTC 38.62893 -120.53545 Grizzly Flats 150 []
731551 December 06, 2019 - 20:39:00 UTC 38.63937 -120.52055 Grizzly Flats 150 [{"latitude": "38.6394", "longitude": "-120.52001"}, {"latitude": "38.63959", "longitude": "-120.51937"}, {"latitude": "38.64021", "longitude": "-120.51784"}, {"latitude": "38.63999", "longitude": "-120.51846"}]
735298 December 10, 2019 - 16:42:00 UTC 38.6392 -120.52618 Grizzly Flats 150 [{"latitude": "38.63827", "longitude": "-120.52592"}, {"latitude": "38.63831", "longitude": "-120.52525"}, {"latitude": "38.63859", "longitude": "-120.52463"}, {"latitude": "38.63908", "longitude": "-120.52439"}, {"latitude": "38.63963", "longitude": "-120.52439"}, {"latitude": "38.6405", "longitude": "-120.52477"}, {"latitude": "38.64221", "longitude": "-120.52558"}]
736216 December 11, 2019 - 16:39:00 UTC 38.63087 -120.54693 Grizzly Flats 150 []
736449 December 11, 2019 - 18:59:06 UTC 38.6389 -120.53982 Grizzly Flats 150 []
737502 December 12, 2019 - 18:32:20 UTC 38.6295 -120.54957 Grizzly Flats 150 []
741716 December 16, 2019 - 17:19:00 UTC 38.63311 -120.537 Grizzly Flats 150 [{"latitude": "38.63377", "longitude": "-120.53686"}, {"latitude": "38.63572", "longitude": "-120.53666"}, {"latitude": "38.63636", "longitude": "-120.53664"}, {"latitude": "38.637", "longitude": "-120.53669"}, {"latitude": "38.64023", "longitude": "-120.53896"}, {"latitude": "38.6407", "longitude": "-120.54"}, {"latitude": "38.64132", "longitude": "-120.54432"}, {"latitude": "38.63851", "longitude": "-120.54379"}]
743581 December 16, 2019 - 20:39:48 UTC 38.63084 -120.55043 Grizzly Flats 150 []
778344 February 05, 2020 - 17:05:02 UTC 38.62956 -120.5478 Grizzly Flats 150 []
780089 February 07, 2020 - 16:09:00 UTC 38.63336 -120.55003 Grizzly Flats 150 []
780104 February 07, 2020 - 19:06:23 UTC 38.64197 -120.51093 Grizzly Flats 150 []
785891 February 10, 2020 - 01:25:00 UTC 38.67009 -120.53308 Grizzly Flats 150 [{"latitude": "38.62133", "longitude": "-120.55155"}, {"latitude": "38.62494", "longitude": "-120.51516"}, {"latitude": "38.63894", "longitude": "-120.50806"}, {"latitude": "38.64013", "longitude": "-120.50812"}, {"latitude": "38.64172", "longitude": "-120.50828"}, {"latitude": "38.65821", "longitude": "-120.52138"}, {"latitude": "38.66795", "longitude": "-120.53386"}, {"latitude": "38.63483", "longitude": "-120.55336"}, {"latitude": "38.62293", "longitude": "-120.5588"}, {"latitude": "38.6221", "longitude": "-120.55842"}, {"latitude": "38.62186", "longitude": "-120.55782"}]
1060373 September 08, 2020 - 08:08:00 UTC 38.62158 -120.58666 Grizzly Flats 150 [{"latitude": "38.61973", "longitude": "-120.58396"}, {"latitude": "38.62055", "longitude": "-120.57013"}, {"latitude": "38.6336", "longitude": "-120.55589"}, {"latitude": "38.64733", "longitude": "-120.5494"}, {"latitude": "38.65681", "longitude": "-120.55524"}, {"latitude": "38.65053", "longitude": "-120.5676"}, {"latitude": "38.6423", "longitude": "-120.57533"}]
1062232 September 09, 2020 - 21:39:00 UTC 38.63234 -120.54279 Grizzly Flats 150 []
1062269 September 09, 2020 - 22:02:41 UTC 38.64147 -120.52451 Grizzly Flats 150 []
1062338 September 08, 2020 - 08:08:00 UTC 38.62665 -120.56956 Grizzly Flats 150 []
1063899 September 11, 2020 - 00:58:06 UTC 38.6377 -120.53213 Grizzly Flats 150 []
1088293 September 22, 2020 - 22:12:04 UTC 38.63746 -120.5205 Grizzly Flats 150 []
1095686 September 28, 2020 - 01:06:00 UTC 38.62158 -120.58666 Grizzly Flats 150 [{"latitude": "38.61973", "longitude": "-120.58396"}, {"latitude": "38.62055", "longitude": "-120.57013"}, {"latitude": "38.6336", "longitude": "-120.55589"}, {"latitude": "38.64733", "longitude": "-120.5494"}, {"latitude": "38.65681", "longitude": "-120.55524"}, {"latitude": "38.65053", "longitude": "-120.5676"}, {"latitude": "38.6423", "longitude": "-120.57533"}]

Advanced export

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

CSV options:

CREATE TABLE [outages] (
   [id] INTEGER PRIMARY KEY,
   [outageStartTime] INTEGER,
   [latitude] TEXT,
   [longitude] TEXT,
   [regionName] INTEGER REFERENCES [regionName]([id]),
   [outageDevices] TEXT
)
Powered by Datasette · Query took 466.492ms · About: About this site