outages

72 rows where regionName = 18

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices
633461 October 01, 2019 - 03:58:17 UTC 35.15723 -120.672 Pismo Beach 18 []
633602 October 01, 2019 - 15:05:58 UTC 35.15721 -120.66906 Pismo Beach 18 [{"latitude": "35.15481", "longitude": "-120.66104"}, {"latitude": "35.15737", "longitude": "-120.66584"}, {"latitude": "35.15811", "longitude": "-120.66817"}, {"latitude": "35.15631", "longitude": "-120.66574"}]
634813 October 01, 2019 - 20:32:16 UTC 35.15454 -120.66748 Pismo Beach 18 []
635850 October 02, 2019 - 16:05:49 UTC 35.15874 -120.67514 Pismo Beach 18 [{"latitude": "35.15629", "longitude": "-120.67686"}, {"latitude": "35.15741", "longitude": "-120.67607"}, {"latitude": "35.15856", "longitude": "-120.67526"}, {"latitude": "35.1582", "longitude": "-120.67552"}]
636695 October 02, 2019 - 17:59:37 UTC 35.15844 -120.6744 Pismo Beach 18 [{"latitude": "35.15598", "longitude": "-120.67612"}, {"latitude": "35.15828", "longitude": "-120.67452"}, {"latitude": "35.15696", "longitude": "-120.67545"}]
637555 October 02, 2019 - 20:07:15 UTC 35.15814 -120.67365 Pismo Beach 18 [{"latitude": "35.15557", "longitude": "-120.67544"}, {"latitude": "35.15654", "longitude": "-120.67475"}, {"latitude": "35.1579", "longitude": "-120.6738"}]
638373 October 02, 2019 - 21:58:26 UTC 35.15905 -120.67593 Pismo Beach 18 [{"latitude": "35.15697", "longitude": "-120.67739"}, {"latitude": "35.15806", "longitude": "-120.67662"}, {"latitude": "35.15854", "longitude": "-120.67629"}, {"latitude": "35.15743", "longitude": "-120.67707"}]
642758 October 04, 2019 - 16:05:59 UTC 35.15743 -120.67186 Pismo Beach 18 [{"latitude": "35.15413", "longitude": "-120.67416"}, {"latitude": "35.15723", "longitude": "-120.672"}, {"latitude": "35.15614", "longitude": "-120.67277"}]
643708 October 04, 2019 - 21:00:00 UTC 35.15723 -120.67135 Pismo Beach 18 [{"latitude": "35.15489", "longitude": "-120.673"}, {"latitude": "35.15656", "longitude": "-120.67181"}, {"latitude": "35.15709", "longitude": "-120.67144"}]
643790 October 05, 2019 - 00:05:17 UTC 35.15684 -120.67038 Pismo Beach 18 [{"latitude": "35.15418", "longitude": "-120.67211"}, {"latitude": "35.15436", "longitude": "-120.67162"}, {"latitude": "35.15535", "longitude": "-120.67092"}, {"latitude": "35.15603", "longitude": "-120.67045"}, {"latitude": "35.15573", "longitude": "-120.67102"}]
643856 October 05, 2019 - 02:47:00 UTC 35.15964 -120.67762 Pismo Beach 18 [{"latitude": "35.15413", "longitude": "-120.67416"}, {"latitude": "35.15723", "longitude": "-120.672"}, {"latitude": "35.15769", "longitude": "-120.67201"}, {"latitude": "35.15929", "longitude": "-120.67602"}, {"latitude": "35.15697", "longitude": "-120.67739"}, {"latitude": "35.15629", "longitude": "-120.67686"}]
643865 October 05, 2019 - 02:59:00 UTC 35.15943 -120.67667 Pismo Beach 18 []
645139 October 06, 2019 - 02:51:51 UTC 35.14112 -120.62024 Pismo Beach 18 []
656177 October 14, 2019 - 16:38:30 UTC 35.15922 -120.67685 Pismo Beach 18 [{"latitude": "35.15711", "longitude": "-120.67825"}, {"latitude": "35.15722", "longitude": "-120.67817"}, {"latitude": "35.15861", "longitude": "-120.67721"}, {"latitude": "35.15839", "longitude": "-120.67737"}]
656253 October 14, 2019 - 16:37:25 UTC 35.15943 -120.67667 Pismo Beach 18 []
660193 October 16, 2019 - 15:13:58 UTC 35.13476 -120.63548 Pismo Beach 18 []
663235 October 17, 2019 - 04:37:44 UTC 35.14422 -120.64486 Pismo Beach 18 []
663236 October 17, 2019 - 04:37:44 UTC 35.14424 -120.64482 Pismo Beach 18 [{"latitude": "35.14385", "longitude": "-120.64535"}, {"latitude": "35.14516", "longitude": "-120.64356"}, {"latitude": "35.14584", "longitude": "-120.64409"}]
674353 October 19, 2019 - 23:32:35 UTC 35.15629 -120.67686 Pismo Beach 18 []
677256 October 23, 2019 - 07:15:14 UTC 35.13766 -120.63663 Pismo Beach 18 []
679183 October 24, 2019 - 04:28:26 UTC 35.1433 -120.63998 Pismo Beach 18 []
679447 October 24, 2019 - 16:03:07 UTC 35.15824 -120.67152 Pismo Beach 18 [{"latitude": "35.15885", "longitude": "-120.67317"}, {"latitude": "35.16042", "longitude": "-120.67409"}, {"latitude": "35.15988", "longitude": "-120.67443"}]
679472 October 24, 2019 - 16:16:00 UTC 35.15874 -120.67144 Pismo Beach 18 []
680284 October 25, 2019 - 16:04:00 UTC 35.15702 -120.67082 Pismo Beach 18 [{"latitude": "35.15371", "longitude": "-120.67316"}, {"latitude": "35.15528", "longitude": "-120.67203"}, {"latitude": "35.1564", "longitude": "-120.67125"}, {"latitude": "35.15437", "longitude": "-120.67271"}]
680406 October 25, 2019 - 18:08:55 UTC 35.14384 -120.64034 Pismo Beach 18 [{"latitude": "35.14371", "longitude": "-120.64034"}, {"latitude": "35.14642", "longitude": "-120.64126"}, {"latitude": "35.14676", "longitude": "-120.64272"}, {"latitude": "35.14611", "longitude": "-120.64302"}, {"latitude": "35.14559", "longitude": "-120.64244"}]
680511 October 25, 2019 - 20:41:47 UTC 35.15702 -120.67082 Pismo Beach 18 [{"latitude": "35.15371", "longitude": "-120.67316"}, {"latitude": "35.15528", "longitude": "-120.67203"}, {"latitude": "35.1564", "longitude": "-120.67125"}, {"latitude": "35.15437", "longitude": "-120.67271"}]
690887 October 28, 2019 - 03:50:44 UTC 35.16177 -120.68283 Pismo Beach 18 []
691464 October 28, 2019 - 16:09:10 UTC 35.15634 -120.66973 Pismo Beach 18 []
693871 October 29, 2019 - 18:15:36 UTC 35.1543 -120.66686 Pismo Beach 18 []
694303 October 29, 2019 - 22:52:24 UTC 35.15413 -120.67416 Pismo Beach 18 []
697169 November 01, 2019 - 03:53:38 UTC 35.15448 -120.66838 Pismo Beach 18 []
697768 November 01, 2019 - 22:04:57 UTC 35.15413 -120.67416 Pismo Beach 18 []
699337 November 04, 2019 - 20:07:32 UTC 35.15352 -120.66903 Pismo Beach 18 []
701670 November 07, 2019 - 16:23:52 UTC 35.16324 -120.6871 Pismo Beach 18 [{"latitude": "35.16128", "longitude": "-120.6871"}, {"latitude": "35.16136", "longitude": "-120.68621"}, {"latitude": "35.162", "longitude": "-120.68615"}, {"latitude": "35.1626", "longitude": "-120.68661"}, {"latitude": "35.16272", "longitude": "-120.68749"}, {"latitude": "35.16207", "longitude": "-120.68789"}]
702118 November 07, 2019 - 22:48:45 UTC 35.16324 -120.6871 Pismo Beach 18 []
703086 November 09, 2019 - 02:01:29 UTC 35.13787 -120.61 Pismo Beach 18 []
703154 November 09, 2019 - 12:15:01 UTC 35.13682 -120.61291 Pismo Beach 18 [{"latitude": "35.13627", "longitude": "-120.61115"}, {"latitude": "35.13662", "longitude": "-120.60945"}, {"latitude": "35.13837", "longitude": "-120.61124"}, {"latitude": "35.13722", "longitude": "-120.61326"}]
703178 November 09, 2019 - 15:07:46 UTC 35.13624 -120.61109 Pismo Beach 18 []
703179 November 09, 2019 - 15:09:50 UTC 35.13682 -120.61291 Pismo Beach 18 []
703260 November 09, 2019 - 17:02:17 UTC 35.13787 -120.61 Pismo Beach 18 []
703964 November 10, 2019 - 19:41:40 UTC 35.13787 -120.61 Pismo Beach 18 []
704841 November 12, 2019 - 17:21:00 UTC 35.15769 -120.67309 Pismo Beach 18 [{"latitude": "35.15602", "longitude": "-120.67418"}, {"latitude": "35.15681", "longitude": "-120.67362"}, {"latitude": "35.15766", "longitude": "-120.67303"}]
708613 November 17, 2019 - 16:45:00 UTC 35.14257 -120.62932 Pismo Beach 18 []
708616 November 17, 2019 - 16:52:49 UTC 35.13405 -120.63445 Pismo Beach 18 []
709695 November 19, 2019 - 03:03:00 UTC 35.14608 -120.6378 Pismo Beach 18 []
709954 November 19, 2019 - 17:02:00 UTC 35.15662 -120.66935 Pismo Beach 18 [{"latitude": "35.15391", "longitude": "-120.67143"}, {"latitude": "35.15561", "longitude": "-120.67024"}, {"latitude": "35.1548", "longitude": "-120.67081"}]
710251 November 19, 2019 - 21:24:19 UTC 35.1522 -120.6368 Pismo Beach 18 []
710278 November 19, 2019 - 21:50:05 UTC 35.1535 -120.63641 Pismo Beach 18 []
710279 November 19, 2019 - 21:50:55 UTC 35.14608 -120.6378 Pismo Beach 18 []
710380 November 19, 2019 - 23:38:32 UTC 35.15595 -120.66417 Pismo Beach 18 []
710526 November 20, 2019 - 06:01:01 UTC 35.18395 -120.66505 Pismo Beach 18 []
710939 November 20, 2019 - 16:10:44 UTC 35.1522 -120.6368 Pismo Beach 18 []
711915 November 21, 2019 - 05:44:39 UTC 35.14159 -120.64021 Pismo Beach 18 []
712700 November 22, 2019 - 16:17:14 UTC 35.13807 -120.63891 Pismo Beach 18 []
713281 November 23, 2019 - 14:25:15 UTC 35.18012 -120.65706 Pismo Beach 18 []
713282 November 23, 2019 - 14:25:15 UTC 35.18395 -120.66505 Pismo Beach 18 []
713292 November 23, 2019 - 14:49:57 UTC 35.18395 -120.66505 Pismo Beach 18 []
713727 November 24, 2019 - 14:39:10 UTC 35.18395 -120.66505 Pismo Beach 18 []
719454 November 27, 2019 - 07:45:58 UTC 35.14715 -120.64636 Pismo Beach 18 [{"latitude": "35.14633", "longitude": "-120.64666"}, {"latitude": "35.14703", "longitude": "-120.64647"}, {"latitude": "35.14662", "longitude": "-120.64675"}]
719887 November 27, 2019 - 12:39:33 UTC 35.14293 -120.63656 Pismo Beach 18 []
726795 December 02, 2019 - 06:54:00 UTC 35.13984 -120.63916 Pismo Beach 18 []
727620 December 02, 2019 - 20:40:57 UTC 35.13984 -120.63916 Pismo Beach 18 []
729183 December 04, 2019 - 06:27:39 UTC 35.1328 -120.60801 Pismo Beach 18 []
730502 December 05, 2019 - 18:27:06 UTC 35.14292 -120.62579 Pismo Beach 18 []
731936 December 07, 2019 - 03:07:57 UTC 35.14703 -120.64647 Pismo Beach 18 []
733541 December 08, 2019 - 13:03:13 UTC 35.14041 -120.63925 Pismo Beach 18 []
734324 December 09, 2019 - 17:20:07 UTC 35.14292 -120.62579 Pismo Beach 18 []
737274 December 12, 2019 - 16:51:57 UTC 35.1473 -120.64071 Pismo Beach 18 []
739541 December 14, 2019 - 18:30:40 UTC 35.15483 -120.67501 Pismo Beach 18 []
743734 December 16, 2019 - 23:03:20 UTC 35.1579 -120.6738 Pismo Beach 18 []
786904 February 10, 2020 - 15:18:44 UTC 35.16177 -120.68283 Pismo Beach 18 []
788929 February 11, 2020 - 22:51:42 UTC 35.14676 -120.64272 Pismo Beach 18 []

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