outages

119 rows where regionName = 32

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
736279 December 11, 2019 - 17:02:00 UTC 38.17925 -120.86644 Valley Springs 32 []
736360 December 11, 2019 - 18:00:00 UTC 38.28696 -120.72101 Valley Springs 32 []
736841 December 12, 2019 - 01:32:24 UTC 38.13277 -120.90246 Valley Springs 32 []
737492 December 12, 2019 - 18:22:00 UTC 38.13277 -120.90246 Valley Springs 32 []
741839 December 16, 2019 - 17:37:17 UTC 38.18738 -120.79655 Valley Springs 32 []
743887 December 17, 2019 - 03:22:25 UTC 38.20061 -120.82695 Valley Springs 32 [{"latitude": "38.1154", "longitude": "-120.80029"}, {"latitude": "38.2487", "longitude": "-120.74749"}, {"latitude": "38.267", "longitude": "-120.75686"}, {"latitude": "38.27598", "longitude": "-120.76274"}, {"latitude": "38.28218", "longitude": "-120.77082"}, {"latitude": "38.28174", "longitude": "-120.7774"}, {"latitude": "38.22213", "longitude": "-120.88487"}, {"latitude": "38.19748", "longitude": "-120.8966"}, {"latitude": "38.19694", "longitude": "-120.89676"}, {"latitude": "38.12008", "longitude": "-120.8086"}]
779666 February 07, 2020 - 02:15:00 UTC 38.18589 -120.82508 Valley Springs 32 [{"latitude": "38.20194", "longitude": "-120.82763"}, {"latitude": "38.20967", "longitude": "-120.80733"}, {"latitude": "38.2487", "longitude": "-120.74749"}, {"latitude": "38.267", "longitude": "-120.75686"}, {"latitude": "38.27598", "longitude": "-120.76274"}, {"latitude": "38.28218", "longitude": "-120.77082"}, {"latitude": "38.28174", "longitude": "-120.7774"}, {"latitude": "38.24346", "longitude": "-120.84416"}, {"latitude": "38.21688", "longitude": "-120.84157"}, {"latitude": "38.20592", "longitude": "-120.83346"}, {"latitude": "38.20263", "longitude": "-120.83019"}]
779682 February 07, 2020 - 02:01:39 UTC 38.24438 -120.8446 Valley Springs 32 [{"latitude": "38.19694", "longitude": "-120.89676"}, {"latitude": "38.197", "longitude": "-120.89074"}, {"latitude": "38.19905", "longitude": "-120.86698"}, {"latitude": "38.21149", "longitude": "-120.85547"}, {"latitude": "38.21337", "longitude": "-120.85402"}, {"latitude": "38.22774", "longitude": "-120.85223"}, {"latitude": "38.23041", "longitude": "-120.86064"}, {"latitude": "38.22941", "longitude": "-120.86601"}, {"latitude": "38.22213", "longitude": "-120.88487"}, {"latitude": "38.19748", "longitude": "-120.8966"}]
779986 February 07, 2020 - 17:29:39 UTC 38.16496 -120.85774 Valley Springs 32 [{"latitude": "38.16391", "longitude": "-120.85907"}, {"latitude": "38.16498", "longitude": "-120.85778"}, {"latitude": "38.18051", "longitude": "-120.84808"}, {"latitude": "38.18454", "longitude": "-120.84686"}, {"latitude": "38.18331", "longitude": "-120.86098"}, {"latitude": "38.17955", "longitude": "-120.86694"}, {"latitude": "38.17654", "longitude": "-120.87151"}, {"latitude": "38.17277", "longitude": "-120.87214"}, {"latitude": "38.16583", "longitude": "-120.86702"}]
780009 February 07, 2020 - 17:43:45 UTC 38.18289 -120.84237 Valley Springs 32 []
780095 February 07, 2020 - 19:04:42 UTC 38.2487 -120.74749 Valley Springs 32 []
780750 February 09, 2020 - 02:07:00 UTC 38.17679 -120.88389 Valley Springs 32 []
782301 February 09, 2020 - 18:29:35 UTC 38.19224 -120.82992 Valley Springs 32 [{"latitude": "38.192", "longitude": "-120.82356"}, {"latitude": "38.19295", "longitude": "-120.81791"}, {"latitude": "38.19588", "longitude": "-120.82931"}, {"latitude": "38.1945", "longitude": "-120.83093"}, {"latitude": "38.19391", "longitude": "-120.83144"}, {"latitude": "38.19354", "longitude": "-120.83173"}, {"latitude": "38.19226", "longitude": "-120.83126"}]
783614 February 09, 2020 - 20:07:07 UTC 38.19224 -120.82992 Valley Springs 32 [{"latitude": "38.192", "longitude": "-120.82356"}, {"latitude": "38.19295", "longitude": "-120.81791"}, {"latitude": "38.19588", "longitude": "-120.82931"}, {"latitude": "38.1945", "longitude": "-120.83093"}, {"latitude": "38.19391", "longitude": "-120.83144"}, {"latitude": "38.19354", "longitude": "-120.83173"}, {"latitude": "38.19226", "longitude": "-120.83126"}]
783798 February 09, 2020 - 20:25:47 UTC 38.1916 -120.83044 Valley Springs 32 []
784109 February 09, 2020 - 20:58:26 UTC 38.19084 -120.83026 Valley Springs 32 []
785275 February 09, 2020 - 23:30:36 UTC 38.19134 -120.82997 Valley Springs 32 []
786495 February 10, 2020 - 05:02:00 UTC 38.19354 -120.83173 Valley Springs 32 []
789194 February 12, 2020 - 07:25:00 UTC 38.21624 -120.87909 Valley Springs 32 [{"latitude": "38.19694", "longitude": "-120.89676"}, {"latitude": "38.197", "longitude": "-120.89074"}, {"latitude": "38.19907", "longitude": "-120.88159"}, {"latitude": "38.20057", "longitude": "-120.87867"}, {"latitude": "38.20176", "longitude": "-120.87691"}, {"latitude": "38.21445", "longitude": "-120.87226"}, {"latitude": "38.21552", "longitude": "-120.87907"}, {"latitude": "38.21439", "longitude": "-120.884"}, {"latitude": "38.21245", "longitude": "-120.88548"}, {"latitude": "38.19748", "longitude": "-120.8966"}]

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