outages

16 rows where regionName = 10

View and edit SQL

Suggested facets: latitude, longitude

outageDevices

id outageStartTime latitude longitude regionName outageDevices
633488 October 01, 2019 - 06:13:00 UTC 35.99202 -119.57146 Kettleman City 10 [{"latitude": "36.0699", "longitude": "-119.54522"}, {"latitude": "36.07279", "longitude": "-119.53918"}, {"latitude": "36.07571", "longitude": "-119.5413"}, {"latitude": "36.07594", "longitude": "-119.55424"}, {"latitude": "36.07269", "longitude": "-119.56981"}, {"latitude": "36.07082", "longitude": "-119.55826"}]
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 []
677122 October 22, 2019 - 21:54:00 UTC 35.87577 -119.57308 Kettleman City 10 [{"latitude": "35.80535", "longitude": "-119.65526"}, {"latitude": "35.83568", "longitude": "-119.57354"}, {"latitude": "35.84206", "longitude": "-119.55895"}, {"latitude": "35.86285", "longitude": "-119.5739"}, {"latitude": "35.86295", "longitude": "-119.57435"}, {"latitude": "35.87616", "longitude": "-119.64388"}, {"latitude": "35.877", "longitude": "-119.64852"}, {"latitude": "35.84611", "longitude": "-119.65772"}, {"latitude": "35.82462", "longitude": "-119.65869"}]
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 []
729620 December 04, 2019 - 17:53:00 UTC 35.98837 -119.9407 Kettleman City 10 [{"latitude": "35.80355", "longitude": "-119.87779"}, {"latitude": "35.87642", "longitude": "-119.7682"}, {"latitude": "35.94005", "longitude": "-119.82684"}, {"latitude": "35.97855", "longitude": "-119.92596"}, {"latitude": "35.96535", "longitude": "-119.93568"}, {"latitude": "35.94897", "longitude": "-119.93314"}, {"latitude": "35.89815", "longitude": "-119.91601"}, {"latitude": "35.81794", "longitude": "-119.88656"}, {"latitude": "35.80608", "longitude": "-119.87988"}]
736659 December 11, 2019 - 22:38:18 UTC 36.03793 -120.03291 Kettleman City 10 []
737091 December 12, 2019 - 14:22:53 UTC 36.0036 -119.94969 Kettleman City 10 [{"latitude": "36.00333", "longitude": "-119.94099"}, {"latitude": "36.04934", "longitude": "-119.82548"}, {"latitude": "36.04953", "longitude": "-119.82523"}, {"latitude": "36.05064", "longitude": "-119.82406"}, {"latitude": "36.07939", "longitude": "-119.80152"}, {"latitude": "36.09418", "longitude": "-119.82474"}, {"latitude": "36.10416", "longitude": "-119.93206"}, {"latitude": "36.1012", "longitude": "-120.00299"}, {"latitude": "36.0942", "longitude": "-120.01225"}, {"latitude": "36.04339", "longitude": "-120.0218"}, {"latitude": "36.03594", "longitude": "-120.0145"}, {"latitude": "36.01542", "longitude": "-119.99321"}, {"latitude": "36.00898", "longitude": "-119.98533"}]
737107 December 12, 2019 - 15:08:00 UTC 35.93489 -119.92118 Kettleman City 10 [{"latitude": "35.88693", "longitude": "-119.863"}, {"latitude": "35.88837", "longitude": "-119.82605"}, {"latitude": "35.90509", "longitude": "-119.82588"}, {"latitude": "35.91239", "longitude": "-119.82587"}, {"latitude": "35.94005", "longitude": "-119.82684"}, {"latitude": "35.94587", "longitude": "-119.84323"}, {"latitude": "35.94904", "longitude": "-119.86011"}, {"latitude": "35.94194", "longitude": "-119.90718"}, {"latitude": "35.93496", "longitude": "-119.91454"}]
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 []

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