outages

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

View and edit SQL

outageDevices

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

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