outages

32 rows where regionName = 65

View and edit SQL

Suggested facets: latitude, longitude, outageDevices

id outageStartTime latitude longitude regionName outageDevices
633586 October 01, 2019 - 14:42:30 UTC 38.03178 -122.2639 Rodeo 65 []
650765 October 09, 2019 - 15:49:00 UTC 38.03553 -122.25833 Rodeo 65 [{"latitude": "38.04367", "longitude": "-122.25738"}, {"latitude": "38.04558", "longitude": "-122.23367"}, {"latitude": "38.04669", "longitude": "-122.23045"}, {"latitude": "38.04757", "longitude": "-122.22798"}, {"latitude": "38.05588", "longitude": "-122.2253"}, {"latitude": "38.05652", "longitude": "-122.22815"}, {"latitude": "38.05734", "longitude": "-122.23585"}, {"latitude": "38.05396", "longitude": "-122.24123"}]
653770 October 11, 2019 - 01:30:47 UTC 38.02227 -122.2556 Rodeo 65 []
659840 October 15, 2019 - 21:36:00 UTC 38.0397 -122.264 Rodeo 65 [{"latitude": "38.03985", "longitude": "-122.26368"}, {"latitude": "38.04837", "longitude": "-122.24706"}, {"latitude": "38.04987", "longitude": "-122.24537"}, {"latitude": "38.05414", "longitude": "-122.24792"}, {"latitude": "38.04134", "longitude": "-122.26349"}]
660771 October 16, 2019 - 17:43:00 UTC 38.026 -122.26314 Rodeo 65 []
660873 October 16, 2019 - 18:29:53 UTC 38.04367 -122.25738 Rodeo 65 []
662365 October 16, 2019 - 21:21:00 UTC 38.03553 -122.25833 Rodeo 65 []
667156 October 18, 2019 - 00:04:53 UTC 38.04808 -122.24849 Rodeo 65 []
683217 October 27, 2019 - 03:05:00 UTC 38.03553 -122.25833 Rodeo 65 [{"latitude": "38.04367", "longitude": "-122.25738"}, {"latitude": "38.04558", "longitude": "-122.23367"}, {"latitude": "38.04669", "longitude": "-122.23045"}, {"latitude": "38.04757", "longitude": "-122.22798"}]
683381 October 27, 2019 - 03:17:00 UTC 38.04839 -122.24813 Rodeo 65 [{"latitude": "38.04837", "longitude": "-122.24706"}, {"latitude": "38.04987", "longitude": "-122.24537"}, {"latitude": "38.05414", "longitude": "-122.24792"}, {"latitude": "38.05066", "longitude": "-122.24978"}, {"latitude": "38.04876", "longitude": "-122.24797"}]
689807 October 27, 2019 - 22:10:29 UTC 38.02227 -122.2556 Rodeo 65 []
696048 October 31, 2019 - 01:31:33 UTC 38.03414 -122.2652 Rodeo 65 [{"latitude": "38.02843", "longitude": "-122.26333"}, {"latitude": "38.03391", "longitude": "-122.26434"}, {"latitude": "38.03374", "longitude": "-122.26527"}, {"latitude": "38.03311", "longitude": "-122.26632"}, {"latitude": "38.02926", "longitude": "-122.26441"}]
696149 October 31, 2019 - 02:39:00 UTC 38.03184 -122.26331 Rodeo 65 []
696819 October 31, 2019 - 20:07:39 UTC 38.03655 -122.27176 Rodeo 65 []
707084 November 15, 2019 - 00:21:07 UTC 38.04095 -122.26184 Rodeo 65 []
707123 November 15, 2019 - 01:20:17 UTC 38.04837 -122.24706 Rodeo 65 []
707134 November 15, 2019 - 01:38:00 UTC 38.04837 -122.24706 Rodeo 65 []
707155 November 15, 2019 - 03:40:27 UTC 38.04837 -122.24706 Rodeo 65 []
711682 November 20, 2019 - 21:49:47 UTC 38.03311 -122.26632 Rodeo 65 []
714724 November 25, 2019 - 23:15:36 UTC 38.03052 -122.26133 Rodeo 65 []
717736 November 27, 2019 - 03:10:30 UTC 38.03464 -122.26096 Rodeo 65 []
723175 November 29, 2019 - 00:41:00 UTC 38.03464 -122.26096 Rodeo 65 []
723374 November 29, 2019 - 16:07:00 UTC 38.03464 -122.26096 Rodeo 65 []
730025 December 05, 2019 - 00:49:28 UTC 38.01604 -122.25507 Rodeo 65 []
730221 December 05, 2019 - 13:40:00 UTC 38.01604 -122.25507 Rodeo 65 []
730694 December 05, 2019 - 21:29:47 UTC 38.01604 -122.25507 Rodeo 65 []
740277 December 15, 2019 - 21:11:08 UTC 38.03184 -122.26331 Rodeo 65 []
787116 February 10, 2020 - 17:01:46 UTC 38.03161 -122.26152 Rodeo 65 []
789651 February 12, 2020 - 21:10:14 UTC 38.02879 -122.26673 Rodeo 65 []
790583 February 13, 2020 - 23:36:22 UTC 38.03655 -122.27176 Rodeo 65 []
1063836 September 10, 2020 - 22:47:32 UTC 38.03199 -122.27146 Rodeo 65 []
1079543 September 18, 2020 - 01:26:17 UTC 38.03683 -122.26683 Rodeo 65 []

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