outages

75 rows where regionName = 60

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices
633576 October 01, 2019 - 14:16:30 UTC 35.48927 -120.56357 Templeton 60 []
635334 October 01, 2019 - 23:21:00 UTC 35.50799 -120.64293 Templeton 60 []
638657 October 02, 2019 - 23:11:52 UTC 35.52871 -120.65968 Templeton 60 []
645766 October 07, 2019 - 08:30:14 UTC 35.54283 -120.76452 Templeton 60 [{"latitude": "35.52876", "longitude": "-120.77241"}, {"latitude": "35.53075", "longitude": "-120.76857"}, {"latitude": "35.53551", "longitude": "-120.76317"}, {"latitude": "35.53944", "longitude": "-120.7624"}, {"latitude": "35.54189", "longitude": "-120.76496"}, {"latitude": "35.53322", "longitude": "-120.77391"}]
654688 October 11, 2019 - 23:20:44 UTC 35.52099 -120.72254 Templeton 60 []
660029 October 16, 2019 - 13:50:45 UTC 35.54312 -120.70412 Templeton 60 [{"latitude": "35.53812", "longitude": "-120.70728"}, {"latitude": "35.53897", "longitude": "-120.70601"}, {"latitude": "35.54365", "longitude": "-120.70321"}, {"latitude": "35.54479", "longitude": "-120.70357"}, {"latitude": "35.54004", "longitude": "-120.71019"}]
667953 October 18, 2019 - 15:53:00 UTC 35.52939 -120.66942 Templeton 60 []
675213 October 21, 2019 - 14:53:00 UTC 35.52323 -120.80705 Templeton 60 []
676461 October 21, 2019 - 23:48:00 UTC 35.5351 -120.72278 Templeton 60 [{"latitude": "35.515", "longitude": "-120.73176"}, {"latitude": "35.51552", "longitude": "-120.72862"}, {"latitude": "35.51706", "longitude": "-120.72499"}, {"latitude": "35.53209", "longitude": "-120.72104"}, {"latitude": "35.53503", "longitude": "-120.72278"}, {"latitude": "35.53561", "longitude": "-120.72772"}, {"latitude": "35.53837", "longitude": "-120.75614"}, {"latitude": "35.52796", "longitude": "-120.76119"}, {"latitude": "35.52214", "longitude": "-120.76321"}]
676530 October 22, 2019 - 03:22:54 UTC 35.52538 -120.74111 Templeton 60 []
676714 October 22, 2019 - 16:03:56 UTC 35.57568 -120.71984 Templeton 60 []
676758 October 22, 2019 - 16:29:35 UTC 35.52538 -120.74111 Templeton 60 []
677198 October 23, 2019 - 01:49:17 UTC 35.54969 -120.72693 Templeton 60 []
677200 October 23, 2019 - 01:47:35 UTC 35.55066 -120.72231 Templeton 60 [{"latitude": "35.54896", "longitude": "-120.71837"}, {"latitude": "35.55093", "longitude": "-120.71609"}, {"latitude": "35.55213", "longitude": "-120.72305"}, {"latitude": "35.55072", "longitude": "-120.72405"}, {"latitude": "35.54918", "longitude": "-120.72153"}]
677202 October 23, 2019 - 01:58:35 UTC 35.55065 -120.72696 Templeton 60 []
677362 October 23, 2019 - 15:03:40 UTC 35.52368 -120.72987 Templeton 60 []
694164 October 29, 2019 - 21:15:42 UTC 35.49265 -120.63548 Templeton 60 []
699186 November 04, 2019 - 18:24:22 UTC 35.52579 -120.73304 Templeton 60 []
699262 November 04, 2019 - 18:59:09 UTC 35.55125 -120.71102 Templeton 60 []
699933 November 05, 2019 - 17:17:00 UTC 35.51788 -120.73078 Templeton 60 []
699970 November 05, 2019 - 17:49:54 UTC 35.49676 -120.6054 Templeton 60 []
700709 November 06, 2019 - 17:25:00 UTC 35.48558 -120.60572 Templeton 60 [{"latitude": "35.48032", "longitude": "-120.60922"}, {"latitude": "35.4815", "longitude": "-120.60753"}, {"latitude": "35.4831", "longitude": "-120.6072"}]
701407 November 07, 2019 - 07:09:36 UTC 35.54312 -120.70412 Templeton 60 [{"latitude": "35.53812", "longitude": "-120.70728"}, {"latitude": "35.53897", "longitude": "-120.70601"}, {"latitude": "35.54365", "longitude": "-120.70321"}, {"latitude": "35.54479", "longitude": "-120.70357"}, {"latitude": "35.54004", "longitude": "-120.71019"}]
702624 November 08, 2019 - 17:21:01 UTC 35.50674 -120.64465 Templeton 60 []
702625 November 08, 2019 - 17:21:00 UTC 35.50688 -120.64477 Templeton 60 []
705435 November 12, 2019 - 22:10:05 UTC 35.48821 -120.84683 Templeton 60 []
706714 November 14, 2019 - 17:23:54 UTC 35.50236 -120.60741 Templeton 60 []
707237 November 15, 2019 - 13:07:00 UTC 35.51878 -120.64056 Templeton 60 [{"latitude": "35.51501", "longitude": "-120.65247"}, {"latitude": "35.51869", "longitude": "-120.64308"}, {"latitude": "35.51905", "longitude": "-120.64312"}, {"latitude": "35.52014", "longitude": "-120.6448"}, {"latitude": "35.5231", "longitude": "-120.65419"}, {"latitude": "35.52222", "longitude": "-120.65581"}, {"latitude": "35.5174", "longitude": "-120.65589"}, {"latitude": "35.51579", "longitude": "-120.65425"}]
707502 November 15, 2019 - 18:00:00 UTC 35.48121 -120.63027 Templeton 60 []
707919 November 15, 2019 - 23:54:00 UTC 35.50239 -120.64898 Templeton 60 [{"latitude": "35.41278", "longitude": "-120.46636"}, {"latitude": "35.41379", "longitude": "-120.45213"}, {"latitude": "35.44687", "longitude": "-120.34512"}, {"latitude": "35.52073", "longitude": "-120.4465"}, {"latitude": "35.55832", "longitude": "-120.512"}, {"latitude": "35.55909", "longitude": "-120.51335"}, {"latitude": "35.56986", "longitude": "-120.5448"}, {"latitude": "35.54992", "longitude": "-120.6114"}, {"latitude": "35.54282", "longitude": "-120.6333"}, {"latitude": "35.52134", "longitude": "-120.66072"}, {"latitude": "35.50646", "longitude": "-120.65015"}, {"latitude": "35.50366", "longitude": "-120.64784"}, {"latitude": "35.48032", "longitude": "-120.60922"}, {"latitude": "35.44472", "longitude": "-120.54658"}, {"latitude": "35.43115", "longitude": "-120.51987"}, {"latitude": "35.41858", "longitude": "-120.48925"}]
708624 November 17, 2019 - 17:04:53 UTC 35.52362 -120.65227 Templeton 60 []
710614 November 20, 2019 - 08:15:12 UTC 35.55177 -120.58711 Templeton 60 [{"latitude": "35.54236", "longitude": "-120.57658"}, {"latitude": "35.54721", "longitude": "-120.5618"}, {"latitude": "35.55531", "longitude": "-120.57791"}, {"latitude": "35.5513", "longitude": "-120.58478"}, {"latitude": "35.54446", "longitude": "-120.57856"}]
712268 November 21, 2019 - 19:08:13 UTC 35.56176 -120.8536 Templeton 60 []
712306 November 21, 2019 - 20:05:08 UTC 35.54876 -120.70975 Templeton 60 []
713398 November 23, 2019 - 17:00:00 UTC 35.52469 -120.65344 Templeton 60 []
713457 November 23, 2019 - 18:10:27 UTC 35.53096 -120.70789 Templeton 60 [{"latitude": "35.53347", "longitude": "-120.70909"}, {"latitude": "35.53669", "longitude": "-120.70284"}, {"latitude": "35.53473", "longitude": "-120.70889"}]
714059 November 25, 2019 - 12:36:01 UTC 35.52333 -120.72336 Templeton 60 []
714060 November 25, 2019 - 12:40:24 UTC 35.52623 -120.71726 Templeton 60 [{"latitude": "35.52018", "longitude": "-120.722"}, {"latitude": "35.52296", "longitude": "-120.72021"}, {"latitude": "35.52388", "longitude": "-120.72539"}]
714129 November 25, 2019 - 15:53:30 UTC 35.52651 -120.61031 Templeton 60 []
714429 November 25, 2019 - 20:14:00 UTC 35.52333 -120.72336 Templeton 60 []
718673 November 27, 2019 - 04:50:30 UTC 35.55177 -120.58711 Templeton 60 [{"latitude": "35.54236", "longitude": "-120.57658"}, {"latitude": "35.54721", "longitude": "-120.5618"}, {"latitude": "35.55531", "longitude": "-120.57791"}, {"latitude": "35.5513", "longitude": "-120.58478"}, {"latitude": "35.54446", "longitude": "-120.57856"}]
719346 November 27, 2019 - 06:53:00 UTC 35.53413 -120.72739 Templeton 60 [{"latitude": "35.515", "longitude": "-120.73176"}, {"latitude": "35.51552", "longitude": "-120.72862"}, {"latitude": "35.51706", "longitude": "-120.72499"}, {"latitude": "35.5283", "longitude": "-120.72567"}, {"latitude": "35.53344", "longitude": "-120.7267"}, {"latitude": "35.53561", "longitude": "-120.72772"}, {"latitude": "35.51748", "longitude": "-120.73177"}]
722833 November 28, 2019 - 18:30:31 UTC 35.52256 -120.73137 Templeton 60 []
723207 November 29, 2019 - 02:27:00 UTC 35.54804 -120.58645 Templeton 60 []
723412 November 29, 2019 - 16:50:01 UTC 35.56213 -120.6668 Templeton 60 []
729643 December 04, 2019 - 18:17:54 UTC 35.58272 -120.67346 Templeton 60 []
730331 December 05, 2019 - 16:48:02 UTC 35.57628 -120.70687 Templeton 60 []
733987 December 09, 2019 - 01:11:54 UTC 35.52581 -120.75252 Templeton 60 []
739378 December 14, 2019 - 17:01:48 UTC 35.48797 -120.60545 Templeton 60 []
740461 December 16, 2019 - 06:53:34 UTC 35.55701 -120.69588 Templeton 60 []
743819 December 17, 2019 - 00:50:12 UTC 35.54976 -120.70506 Templeton 60 []
744527 December 17, 2019 - 19:25:53 UTC 35.52256 -120.73137 Templeton 60 []
744738 December 17, 2019 - 22:00:49 UTC 35.51726 -120.79525 Templeton 60 []
778237 February 05, 2020 - 15:43:21 UTC 35.52951 -120.6084 Templeton 60 []
778464 February 05, 2020 - 18:22:30 UTC 35.52989 -120.7087 Templeton 60 []
778549 February 05, 2020 - 19:44:10 UTC 35.52685 -120.81833 Templeton 60 []
778602 February 05, 2020 - 20:42:31 UTC 35.52223 -120.62057 Templeton 60 []
780081 February 07, 2020 - 18:42:39 UTC 35.55329 -120.72214 Templeton 60 []
789058 February 12, 2020 - 00:56:13 UTC 35.49407 -120.60276 Templeton 60 []
789188 February 12, 2020 - 07:06:42 UTC 35.57533 -120.65827 Templeton 60 [{"latitude": "35.57591", "longitude": "-120.65461"}, {"latitude": "35.57668", "longitude": "-120.65433"}, {"latitude": "35.58258", "longitude": "-120.65765"}, {"latitude": "35.5868", "longitude": "-120.66268"}, {"latitude": "35.59014", "longitude": "-120.66828"}, {"latitude": "35.596", "longitude": "-120.67969"}, {"latitude": "35.59534", "longitude": "-120.68022"}, {"latitude": "35.59452", "longitude": "-120.68013"}, {"latitude": "35.59267", "longitude": "-120.67948"}, {"latitude": "35.59156", "longitude": "-120.67861"}, {"latitude": "35.59062", "longitude": "-120.67777"}, {"latitude": "35.57608", "longitude": "-120.65916"}, {"latitude": "35.576", "longitude": "-120.6571"}]
789607 February 12, 2020 - 20:27:14 UTC 35.53996 -120.83701 Templeton 60 []
1071553 September 15, 2020 - 16:40:10 UTC 35.48999 -120.58947 Templeton 60 []
1071554 September 15, 2020 - 16:40:10 UTC 35.48989 -120.58768 Templeton 60 []
1071556 September 15, 2020 - 16:42:44 UTC 35.58076 -120.69271 Templeton 60 []
1072553 September 15, 2020 - 20:14:37 UTC 35.49124 -120.58602 Templeton 60 []
1074715 September 16, 2020 - 16:25:15 UTC 35.57533 -120.79848 Templeton 60 []
1074716 September 16, 2020 - 16:25:15 UTC 35.5755 -120.80416 Templeton 60 []
1075215 September 16, 2020 - 18:45:00 UTC 35.57533 -120.79848 Templeton 60 []
1076922 September 17, 2020 - 13:22:00 UTC 35.4894 -120.63888 Templeton 60 [{"latitude": "35.20785", "longitude": "-120.1921"}, {"latitude": "35.22805", "longitude": "-120.13285"}, {"latitude": "35.39703", "longitude": "-120.35034"}, {"latitude": "35.49229", "longitude": "-120.62902"}, {"latitude": "35.49162", "longitude": "-120.63491"}, {"latitude": "35.49049", "longitude": "-120.63734"}, {"latitude": "35.48885", "longitude": "-120.63824"}, {"latitude": "35.46199", "longitude": "-120.64421"}, {"latitude": "35.41627", "longitude": "-120.62032"}]
1080335 September 18, 2020 - 16:30:52 UTC 35.48834 -120.58851 Templeton 60 []
1082189 September 19, 2020 - 16:04:38 UTC 35.58697 -120.65785 Templeton 60 []
1082633 September 19, 2020 - 19:29:00 UTC 35.58794 -120.65853 Templeton 60 []
1089639 September 23, 2020 - 18:41:47 UTC 35.57533 -120.79848 Templeton 60 []
1090957 September 24, 2020 - 15:57:43 UTC 35.53277 -120.72176 Templeton 60 []
1096287 September 28, 2020 - 18:09:00 UTC 35.52763 -120.66256 Templeton 60 []

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