outages

131 rows where regionName = 43

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
731497 December 06, 2019 - 19:34:18 UTC 37.28656 -121.94598 Campbell 43 []
734000 December 09, 2019 - 01:50:10 UTC 37.2864 -121.94842 Campbell 43 []
734182 December 09, 2019 - 16:21:14 UTC 37.272 -121.95056 Campbell 43 []
734305 December 09, 2019 - 17:11:26 UTC 37.29523 -121.94797 Campbell 43 []
734313 December 09, 2019 - 17:12:00 UTC 37.28415 -121.93808 Campbell 43 []
734673 December 09, 2019 - 20:58:00 UTC 37.2864 -121.94842 Campbell 43 []
735323 December 10, 2019 - 16:55:30 UTC 37.2803 -121.95331 Campbell 43 []
736730 December 12, 2019 - 00:00:09 UTC 37.26629 -121.96205 Campbell 43 []
736784 December 12, 2019 - 00:34:45 UTC 37.28873 -121.9745 Campbell 43 []
736853 December 12, 2019 - 01:56:24 UTC 37.29466 -121.96803 Campbell 43 []
738660 December 13, 2019 - 22:32:00 UTC 37.27513 -121.94504 Campbell 43 []
738720 December 14, 2019 - 00:10:07 UTC 37.26629 -121.96205 Campbell 43 []
739392 December 14, 2019 - 17:09:00 UTC 37.28372 -121.92475 Campbell 43 [{"latitude": "37.28368", "longitude": "-121.92418"}, {"latitude": "37.28369", "longitude": "-121.92364"}, {"latitude": "37.28368", "longitude": "-121.92631"}]
740147 December 15, 2019 - 17:59:44 UTC 37.27946 -121.95326 Campbell 43 []
740456 December 16, 2019 - 06:06:01 UTC 37.29587 -121.94202 Campbell 43 []
742793 December 16, 2019 - 18:48:27 UTC 37.28347 -121.92256 Campbell 43 []
743641 December 16, 2019 - 21:46:54 UTC 37.27946 -121.95326 Campbell 43 []
778417 February 05, 2020 - 17:48:55 UTC 37.25777 -121.95039 Campbell 43 []
778584 February 05, 2020 - 20:27:48 UTC 37.30276 -121.94091 Campbell 43 []
779638 February 07, 2020 - 01:20:01 UTC 37.2879 -121.97265 Campbell 43 []
781383 February 09, 2020 - 17:00:05 UTC 37.28616 -121.92615 Campbell 43 []
783285 February 09, 2020 - 19:46:51 UTC 37.29015 -121.93881 Campbell 43 []
783409 February 09, 2020 - 19:46:00 UTC 37.29154 -121.93573 Campbell 43 [{"latitude": "37.30438", "longitude": "-121.93026"}, {"latitude": "37.30601", "longitude": "-121.92345"}, {"latitude": "37.30798", "longitude": "-121.91532"}, {"latitude": "37.31036", "longitude": "-121.91421"}, {"latitude": "37.3147", "longitude": "-121.91642"}, {"latitude": "37.31496", "longitude": "-121.91687"}, {"latitude": "37.31543", "longitude": "-121.91779"}, {"latitude": "37.31593", "longitude": "-121.91931"}, {"latitude": "37.31531", "longitude": "-121.92291"}, {"latitude": "37.31213", "longitude": "-121.93008"}, {"latitude": "37.31138", "longitude": "-121.93047"}, {"latitude": "37.30571", "longitude": "-121.9309"}]
783510 February 09, 2020 - 20:00:22 UTC 37.26087 -121.95054 Campbell 43 []
783749 February 09, 2020 - 20:21:52 UTC 37.28617 -121.92431 Campbell 43 []
784223 February 09, 2020 - 21:12:00 UTC 37.29356 -121.96899 Campbell 43 []
785003 February 09, 2020 - 22:39:44 UTC 37.27236 -121.97053 Campbell 43 []
787180 February 10, 2020 - 17:24:10 UTC 37.30214 -121.94444 Campbell 43 []
787450 February 10, 2020 - 19:43:18 UTC 37.29475 -121.95357 Campbell 43 []
789549 February 12, 2020 - 19:41:27 UTC 37.27036 -121.97016 Campbell 43 []
789621 February 12, 2020 - 20:43:25 UTC 37.27749 -121.95312 Campbell 43 []

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