outages

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

View and edit SQL

outageDevices

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

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