outages

1 row where outageDevices = "[{"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"}]" and regionName = 10

View and edit SQL

outageDevices

  • [{"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"}] · 1
id outageStartTime latitude longitude regionName outageDevices
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"}]

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