outages

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

View and edit SQL

outageDevices

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

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