outages

26 rows where regionName = 51

View and edit SQL

Suggested facets: latitude, longitude, outageDevices

id outageStartTime latitude longitude regionName outageDevices
633550 October 01, 2019 - 13:45:10 UTC 36.13872 -120.12345 Huron 51 []
633551 October 01, 2019 - 13:45:22 UTC 36.13871 -120.12345 Huron 51 []
633552 October 01, 2019 - 13:45:32 UTC 36.13868 -120.12345 Huron 51 []
635337 October 01, 2019 - 23:25:04 UTC 36.35719 -120.09399 Huron 51 []
644213 October 05, 2019 - 16:16:42 UTC 36.2376 -119.99477 Huron 51 []
660076 October 16, 2019 - 14:50:49 UTC 36.48066 -120.07364 Huron 51 []
660077 October 16, 2019 - 14:50:43 UTC 36.40185 -120.13852 Huron 51 [{"latitude": "36.38606", "longitude": "-120.10291"}, {"latitude": "36.38607", "longitude": "-120.10151"}, {"latitude": "36.3861", "longitude": "-120.09854"}, {"latitude": "36.3935", "longitude": "-120.01248"}, {"latitude": "36.40066", "longitude": "-119.96809"}, {"latitude": "36.40444", "longitude": "-119.96801"}, {"latitude": "36.40793", "longitude": "-119.96795"}, {"latitude": "36.43442", "longitude": "-119.96762"}, {"latitude": "36.4516", "longitude": "-120.01858"}, {"latitude": "36.45175", "longitude": "-120.0401"}, {"latitude": "36.45191", "longitude": "-120.0671"}, {"latitude": "36.4518", "longitude": "-120.07555"}, {"latitude": "36.4431", "longitude": "-120.09431"}, {"latitude": "36.40041", "longitude": "-120.13708"}]
660078 October 16, 2019 - 14:50:53 UTC 36.48799 -120.09759 Huron 51 []
660079 October 16, 2019 - 14:50:57 UTC 36.42003 -120.19356 Huron 51 []
660082 October 16, 2019 - 14:50:58 UTC 36.41786 -120.19327 Huron 51 []
674847 October 20, 2019 - 19:10:57 UTC 36.50225 -120.11031 Huron 51 []
676024 October 21, 2019 - 17:09:14 UTC 36.41486 -120.19291 Huron 51 []
676300 October 21, 2019 - 20:38:36 UTC 36.22696 -120.01271 Huron 51 []
689296 October 27, 2019 - 21:07:19 UTC 36.21256 -120.10288 Huron 51 []
700816 November 06, 2019 - 17:55:08 UTC 36.26533 -120.12122 Huron 51 []
702106 November 07, 2019 - 22:37:25 UTC 36.36455 -120.15653 Huron 51 []
704778 November 12, 2019 - 16:50:23 UTC 36.13775 -120.04745 Huron 51 []
704987 November 12, 2019 - 18:31:24 UTC 36.20012 -120.09803 Huron 51 []
706523 November 14, 2019 - 13:34:29 UTC 36.50321 -120.09493 Huron 51 []
707375 November 15, 2019 - 16:49:13 UTC 36.20031 -120.0977 Huron 51 []
714581 November 25, 2019 - 21:36:00 UTC 36.28411 -120.12072 Huron 51 [{"latitude": "36.25429", "longitude": "-120.08651"}, {"latitude": "36.25588", "longitude": "-120.03093"}, {"latitude": "36.26957", "longitude": "-119.98516"}, {"latitude": "36.29816", "longitude": "-119.98578"}, {"latitude": "36.30004", "longitude": "-119.99497"}, {"latitude": "36.29912", "longitude": "-120.04813"}, {"latitude": "36.28568", "longitude": "-120.10289"}, {"latitude": "36.28504", "longitude": "-120.10339"}, {"latitude": "36.26989", "longitude": "-120.10331"}, {"latitude": "36.26083", "longitude": "-120.09378"}, {"latitude": "36.25531", "longitude": "-120.08771"}]
715221 November 26, 2019 - 18:49:27 UTC 36.36455 -120.15653 Huron 51 []
778543 February 05, 2020 - 19:33:29 UTC 36.31795 -120.19655 Huron 51 []
779913 February 07, 2020 - 16:47:20 UTC 36.24459 -119.99815 Huron 51 []
788513 February 11, 2020 - 17:37:00 UTC 36.38523 -120.13949 Huron 51 [{"latitude": "36.34987", "longitude": "-120.14034"}, {"latitude": "36.34988", "longitude": "-120.13991"}, {"latitude": "36.35694", "longitude": "-120.13957"}, {"latitude": "36.37724", "longitude": "-120.13872"}, {"latitude": "36.37144", "longitude": "-120.15149"}]
1075374 September 16, 2020 - 19:14:18 UTC 36.42801 -120.10251 Huron 51 []

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