outages

44 rows where regionName = 91

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices
633650 October 01, 2019 - 15:30:08 UTC 37.99955 -121.34093 Lincoln Village 91 []
646177 October 07, 2019 - 19:40:07 UTC 38.00087 -121.33688 Lincoln Village 91 []
654502 October 11, 2019 - 20:47:06 UTC 38.00543 -121.34254 Lincoln Village 91 []
655372 October 12, 2019 - 23:50:02 UTC 37.99955 -121.3397 Lincoln Village 91 []
655852 October 14, 2019 - 15:14:38 UTC 38.00693 -121.32943 Lincoln Village 91 []
657033 October 14, 2019 - 18:08:57 UTC 38.01031 -121.32506 Lincoln Village 91 []
676997 October 22, 2019 - 20:44:58 UTC 38.00693 -121.32943 Lincoln Village 91 []
680492 October 25, 2019 - 20:21:29 UTC 38.01159 -121.32616 Lincoln Village 91 []
686526 October 27, 2019 - 10:21:31 UTC 38.00334 -121.33239 Lincoln Village 91 [{"latitude": "38.00213", "longitude": "-121.33588"}, {"latitude": "38.00243", "longitude": "-121.33476"}, {"latitude": "38.00285", "longitude": "-121.33369"}, {"latitude": "38.00314", "longitude": "-121.33298"}]
687247 October 27, 2019 - 15:35:33 UTC 37.99955 -121.3397 Lincoln Village 91 []
688661 October 27, 2019 - 19:59:00 UTC 38.00426 -121.33676 Lincoln Village 91 []
689450 October 27, 2019 - 21:26:37 UTC 38.00065 -121.33781 Lincoln Village 91 []
692240 October 28, 2019 - 23:14:53 UTC 38.00389 -121.33535 Lincoln Village 91 []
694534 October 30, 2019 - 01:47:17 UTC 38.00065 -121.33781 Lincoln Village 91 []
695470 October 30, 2019 - 21:29:15 UTC 38.01031 -121.32903 Lincoln Village 91 []
696516 October 31, 2019 - 16:34:15 UTC 38.00392 -121.34373 Lincoln Village 91 []
696833 October 31, 2019 - 20:23:44 UTC 38.00197 -121.34637 Lincoln Village 91 []
697222 November 01, 2019 - 13:18:14 UTC 38.01098 -121.32352 Lincoln Village 91 []
700208 November 05, 2019 - 22:25:36 UTC 38.00469 -121.33106 Lincoln Village 91 []
700965 November 06, 2019 - 20:08:52 UTC 38.00503 -121.33966 Lincoln Village 91 [{"latitude": "38.00535", "longitude": "-121.3436"}, {"latitude": "38.00543", "longitude": "-121.33981"}, {"latitude": "38.00566", "longitude": "-121.34068"}]
704492 November 11, 2019 - 21:53:10 UTC 38.00426 -121.33676 Lincoln Village 91 []
705505 November 12, 2019 - 23:43:24 UTC 38.01188 -121.32483 Lincoln Village 91 []
707009 November 14, 2019 - 22:34:51 UTC 38.00189 -121.33707 Lincoln Village 91 []
707046 November 14, 2019 - 23:29:10 UTC 38.00189 -121.33707 Lincoln Village 91 []
708431 November 16, 2019 - 23:34:09 UTC 38.00682 -121.32543 Lincoln Village 91 []
709477 November 18, 2019 - 22:23:47 UTC 38.00535 -121.3436 Lincoln Village 91 []
714342 November 25, 2019 - 19:17:21 UTC 38.00394 -121.33298 Lincoln Village 91 []
715208 November 26, 2019 - 18:34:35 UTC 38.01281 -121.32731 Lincoln Village 91 []
715233 November 26, 2019 - 19:07:22 UTC 38.0065 -121.32656 Lincoln Village 91 []
717831 November 27, 2019 - 03:19:48 UTC 38.00641 -121.33518 Lincoln Village 91 []
724921 December 01, 2019 - 01:51:51 UTC 38.00587 -121.33422 Lincoln Village 91 []
725842 December 01, 2019 - 17:16:35 UTC 38.00587 -121.33422 Lincoln Village 91 []
730707 December 05, 2019 - 21:40:36 UTC 38.00569 -121.3301 Lincoln Village 91 []
788900 February 11, 2020 - 22:19:28 UTC 38.00207 -121.33978 Lincoln Village 91 []
789274 February 12, 2020 - 15:59:15 UTC 38.00785 -121.3285 Lincoln Village 91 []
789557 February 12, 2020 - 19:45:11 UTC 38.00785 -121.3285 Lincoln Village 91 []
789682 February 12, 2020 - 21:55:21 UTC 38.00136 -121.33981 Lincoln Village 91 []
1061822 September 09, 2020 - 15:04:03 UTC 38.00838 -121.32155 Lincoln Village 91 []
1062208 September 09, 2020 - 21:17:29 UTC 38.00467 -121.34398 Lincoln Village 91 []
1079512 September 18, 2020 - 00:03:20 UTC 38.00153 -121.34531 Lincoln Village 91 []
1080958 September 18, 2020 - 19:12:09 UTC 38.00641 -121.33518 Lincoln Village 91 []
1086859 September 22, 2020 - 16:21:15 UTC 38.0071 -121.32413 Lincoln Village 91 []
1090855 September 24, 2020 - 15:08:13 UTC 38.00153 -121.34531 Lincoln Village 91 []
1092913 September 25, 2020 - 20:16:21 UTC 38.00509 -121.3365 Lincoln Village 91 []

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