outages

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

View and edit SQL

outageDevices

  • [{"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"}] · 1
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"}]

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