outages

30 rows where regionName = 77

View and edit SQL

Suggested facets: latitude, longitude, outageDevices

id outageStartTime latitude longitude regionName outageDevices
633595 October 01, 2019 - 15:01:57 UTC 38.92692 -123.72513 Point Arena 77 []
644028 October 05, 2019 - 15:41:00 UTC 38.91268 -123.69702 Point Arena 77 []
676615 October 22, 2019 - 14:06:00 UTC 38.90212 -123.54364 Point Arena 77 []
681791 October 27, 2019 - 00:58:55 UTC 38.93109 -123.71002 Point Arena 77 []
681792 October 27, 2019 - 00:58:55 UTC 38.93206 -123.70896 Point Arena 77 []
681948 October 27, 2019 - 01:15:41 UTC 38.93247 -123.71138 Point Arena 77 []
681949 October 27, 2019 - 01:15:42 UTC 38.94539 -123.6913 Point Arena 77 []
681954 October 27, 2019 - 01:15:41 UTC 38.94531 -123.7066 Point Arena 77 []
681955 October 27, 2019 - 01:15:42 UTC 38.93715 -123.68446 Point Arena 77 []
681956 October 27, 2019 - 01:15:42 UTC 38.9342 -123.68081 Point Arena 77 []
681968 October 27, 2019 - 01:16:15 UTC 38.8789 -123.60387 Point Arena 77 []
682853 October 27, 2019 - 02:31:06 UTC 38.95851 -123.60539 Point Arena 77 []
683080 October 27, 2019 - 00:44:00 UTC 38.88873 -123.55056 Point Arena 77 [{"latitude": "38.88875", "longitude": "-123.55078"}, {"latitude": "38.89161", "longitude": "-123.54046"}, {"latitude": "38.89649", "longitude": "-123.54056"}, {"latitude": "38.90383", "longitude": "-123.54223"}, {"latitude": "38.89406", "longitude": "-123.55508"}, {"latitude": "38.88931", "longitude": "-123.55138"}]
683132 October 27, 2019 - 00:44:00 UTC 38.91216 -123.67874 Point Arena 77 [{"latitude": "38.8479", "longitude": "-123.64533"}, {"latitude": "38.87691", "longitude": "-123.5995"}, {"latitude": "38.89443", "longitude": "-123.59087"}, {"latitude": "38.95532", "longitude": "-123.58288"}, {"latitude": "38.95965", "longitude": "-123.60621"}, {"latitude": "38.96249", "longitude": "-123.64893"}, {"latitude": "38.96376", "longitude": "-123.71198"}, {"latitude": "38.95211", "longitude": "-123.73833"}, {"latitude": "38.92692", "longitude": "-123.72513"}]
696603 October 31, 2019 - 17:38:10 UTC 38.90882 -123.69169 Point Arena 77 []
700110 November 05, 2019 - 20:09:46 UTC 38.88875 -123.55078 Point Arena 77 []
713865 November 24, 2019 - 18:53:39 UTC 38.91304 -123.69258 Point Arena 77 [{"latitude": "38.91145", "longitude": "-123.70175"}, {"latitude": "38.9116", "longitude": "-123.69477"}, {"latitude": "38.91182", "longitude": "-123.69313"}, {"latitude": "38.91317", "longitude": "-123.69315"}, {"latitude": "38.91489", "longitude": "-123.69699"}, {"latitude": "38.91586", "longitude": "-123.70163"}, {"latitude": "38.91623", "longitude": "-123.70356"}, {"latitude": "38.91413", "longitude": "-123.70936"}]
713866 November 24, 2019 - 18:53:41 UTC 38.91372 -123.69253 Point Arena 77 []
723052 November 28, 2019 - 21:20:25 UTC 38.89667 -123.62392 Point Arena 77 []
724141 November 30, 2019 - 18:34:28 UTC 38.92509 -123.64529 Point Arena 77 []
724246 November 30, 2019 - 20:36:00 UTC 38.91276 -123.67945 Point Arena 77 [{"latitude": "38.87566", "longitude": "-123.60271"}, {"latitude": "38.87691", "longitude": "-123.5995"}, {"latitude": "38.89443", "longitude": "-123.59087"}, {"latitude": "38.90562", "longitude": "-123.6077"}, {"latitude": "38.93038", "longitude": "-123.64982"}, {"latitude": "38.91281", "longitude": "-123.67876"}, {"latitude": "38.88011", "longitude": "-123.64371"}]
728470 December 03, 2019 - 16:58:18 UTC 38.91413 -123.70936 Point Arena 77 []
730447 December 05, 2019 - 17:53:00 UTC 38.90881 -123.69362 Point Arena 77 []
731834 December 07, 2019 - 00:50:00 UTC 38.9018 -123.61851 Point Arena 77 []
732242 December 07, 2019 - 14:41:10 UTC 38.9597 -123.60965 Point Arena 77 [{"latitude": "38.953", "longitude": "-123.59255"}, {"latitude": "38.9538", "longitude": "-123.58671"}, {"latitude": "38.95532", "longitude": "-123.58288"}, {"latitude": "38.95965", "longitude": "-123.60621"}, {"latitude": "38.95975", "longitude": "-123.60862"}]
732243 December 07, 2019 - 14:41:00 UTC 38.92204 -123.62556 Point Arena 77 []
732718 December 07, 2019 - 20:27:00 UTC 38.929 -123.69649 Point Arena 77 []
779312 February 06, 2020 - 19:45:47 UTC 38.91634 -123.65118 Point Arena 77 []
1062447 September 10, 2020 - 01:12:07 UTC 38.94972 -123.66849 Point Arena 77 []
1062713 September 10, 2020 - 15:24:29 UTC 38.93715 -123.68446 Point Arena 77 []

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