outages

17 rows where outageDevices = "[]" and regionName = 10

View and edit SQL

Suggested facets: longitude

outageDevices

id outageStartTime latitude longitude regionName outageDevices
639015 October 03, 2019 - 15:04:24 UTC 36.01448 -119.96702 Kettleman City 10 []
650970 October 09, 2019 - 19:18:52 UTC 35.87642 -119.7682 Kettleman City 10 []
676815 October 22, 2019 - 17:09:39 UTC 36.02678 -119.61755 Kettleman City 10 []
700086 November 05, 2019 - 19:46:06 UTC 35.87642 -119.7682 Kettleman City 10 []
722059 November 28, 2019 - 01:16:06 UTC 36.01032 -119.96228 Kettleman City 10 []
736659 December 11, 2019 - 22:38:18 UTC 36.03793 -120.03291 Kettleman City 10 []
743795 December 17, 2019 - 00:02:39 UTC 36.10873 -119.9669 Kettleman City 10 []
780713 February 09, 2020 - 01:04:52 UTC 36.00871 -119.96365 Kettleman City 10 []
788911 February 11, 2020 - 22:29:56 UTC 36.0942 -119.99928 Kettleman City 10 []
789218 February 12, 2020 - 11:54:00 UTC 35.99004 -119.96045 Kettleman City 10 []
790156 February 13, 2020 - 16:42:40 UTC 36.0942 -119.99928 Kettleman City 10 []
1061325 September 08, 2020 - 22:18:54 UTC 36.00871 -119.96365 Kettleman City 10 []
1062913 September 10, 2020 - 17:16:16 UTC 36.05447 -120.03948 Kettleman City 10 []
1064156 September 11, 2020 - 15:35:00 UTC 36.05447 -120.03948 Kettleman City 10 []
1083141 September 20, 2020 - 03:06:04 UTC 36.00664 -119.94426 Kettleman City 10 []
1088726 September 23, 2020 - 07:04:46 UTC 35.98581 -119.9585 Kettleman City 10 []
1100841 September 30, 2020 - 12:11:34 UTC 36.00502 -119.95873 Kettleman City 10 []

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