outages

19 rows where regionName = 111

View and edit SQL

Suggested facets: outageStartTime, latitude, longitude, outageDevices

id outageStartTime latitude longitude regionName outageDevices
633801 October 01, 2019 - 16:00:28 UTC 37.95149 -122.32156 East Richmond Heights 111 [{"latitude": "37.95033", "longitude": "-122.31304"}, {"latitude": "37.9505", "longitude": "-122.31217"}, {"latitude": "37.95179", "longitude": "-122.31368"}, {"latitude": "37.95149", "longitude": "-122.32152"}]
638827 October 03, 2019 - 00:55:40 UTC 37.94313 -122.31702 East Richmond Heights 111 []
680479 October 25, 2019 - 20:06:11 UTC 37.94363 -122.31217 East Richmond Heights 111 []
684253 October 27, 2019 - 04:17:40 UTC 37.94165 -122.3127 East Richmond Heights 111 [{"latitude": "37.93362", "longitude": "-122.29789"}, {"latitude": "37.93522", "longitude": "-122.29978"}, {"latitude": "37.94668", "longitude": "-122.31461"}, {"latitude": "37.94721", "longitude": "-122.31541"}, {"latitude": "37.94669", "longitude": "-122.31704"}, {"latitude": "37.94054", "longitude": "-122.31212"}, {"latitude": "37.9388", "longitude": "-122.30983"}, {"latitude": "37.93508", "longitude": "-122.30391"}]
684673 October 27, 2019 - 04:53:23 UTC 37.95148 -122.32157 East Richmond Heights 111 [{"latitude": "37.95033", "longitude": "-122.31304"}, {"latitude": "37.9505", "longitude": "-122.31217"}, {"latitude": "37.95179", "longitude": "-122.31368"}, {"latitude": "37.95149", "longitude": "-122.32152"}]
684922 October 27, 2019 - 05:21:41 UTC 37.95111 -122.32104 East Richmond Heights 111 [{"latitude": "37.94675", "longitude": "-122.31247"}, {"latitude": "37.94735", "longitude": "-122.31295"}, {"latitude": "37.94833", "longitude": "-122.31387"}, {"latitude": "37.95035", "longitude": "-122.31645"}, {"latitude": "37.95056", "longitude": "-122.31738"}, {"latitude": "37.95109", "longitude": "-122.32059"}]
684923 October 27, 2019 - 05:21:41 UTC 37.94628 -122.31815 East Richmond Heights 111 [{"latitude": "37.94721", "longitude": "-122.31836"}, {"latitude": "37.94771", "longitude": "-122.31441"}, {"latitude": "37.9497", "longitude": "-122.31728"}, {"latitude": "37.94989", "longitude": "-122.31759"}, {"latitude": "37.94993", "longitude": "-122.31806"}, {"latitude": "37.94999", "longitude": "-122.31938"}, {"latitude": "37.9498", "longitude": "-122.31967"}]
687537 October 27, 2019 - 16:50:00 UTC 37.94331 -122.31764 East Richmond Heights 111 []
696581 October 31, 2019 - 17:21:23 UTC 37.94908 -122.31669 East Richmond Heights 111 []
698894 November 04, 2019 - 06:04:16 UTC 37.94612 -122.31487 East Richmond Heights 111 []
701106 November 06, 2019 - 22:42:31 UTC 37.9388 -122.30983 East Richmond Heights 111 []
703057 November 09, 2019 - 01:15:10 UTC 37.94897 -122.32157 East Richmond Heights 111 []
714451 November 25, 2019 - 20:32:39 UTC 37.94814 -122.31768 East Richmond Heights 111 []
724475 November 30, 2019 - 23:11:03 UTC 37.94721 -122.31541 East Richmond Heights 111 []
733176 December 08, 2019 - 00:50:58 UTC 37.94665 -122.31614 East Richmond Heights 111 []
734591 December 09, 2019 - 19:47:35 UTC 37.95072 -122.31902 East Richmond Heights 111 []
783988 February 09, 2020 - 20:40:46 UTC 37.94845 -122.31603 East Richmond Heights 111 []
787407 February 10, 2020 - 19:22:32 UTC 37.94897 -122.32157 East Richmond Heights 111 []
790130 February 13, 2020 - 16:16:45 UTC 37.94171 -122.30963 East Richmond Heights 111 []

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