outages

29 rows where regionName = 202

View and edit SQL

Suggested facets: outageStartTime, latitude, longitude, outageDevices

id outageStartTime latitude longitude regionName outageDevices
634849 October 01, 2019 - 21:30:30 UTC 40.01626 -122.40273 Rancho Tehama Reserve 202 []
647538 October 08, 2019 - 20:56:23 UTC 40.01706 -122.40928 Rancho Tehama Reserve 202 []
647904 October 09, 2019 - 07:13:00 UTC 39.99671 -122.4058 Rancho Tehama Reserve 202 [{"latitude": "39.995", "longitude": "-122.4122"}, {"latitude": "39.99679", "longitude": "-122.4062"}, {"latitude": "40.01857", "longitude": "-122.35836"}, {"latitude": "40.02112", "longitude": "-122.35314"}, {"latitude": "40.02277", "longitude": "-122.36897"}, {"latitude": "40.02268", "longitude": "-122.44615"}, {"latitude": "40.02187", "longitude": "-122.45918"}, {"latitude": "40.02107", "longitude": "-122.45972"}, {"latitude": "40.02039", "longitude": "-122.45989"}, {"latitude": "40.00715", "longitude": "-122.46276"}, {"latitude": "39.99826", "longitude": "-122.45977"}, {"latitude": "39.99559", "longitude": "-122.43575"}]
647920 October 09, 2019 - 07:13:00 UTC 40.01494 -122.39762 Rancho Tehama Reserve 202 [{"latitude": "40.00966", "longitude": "-122.39"}, {"latitude": "40.01857", "longitude": "-122.35836"}, {"latitude": "40.02112", "longitude": "-122.35314"}, {"latitude": "40.02277", "longitude": "-122.36897"}, {"latitude": "40.01976", "longitude": "-122.39202"}, {"latitude": "40.01936", "longitude": "-122.39275"}, {"latitude": "40.01863", "longitude": "-122.39407"}, {"latitude": "40.01488", "longitude": "-122.39731"}]
653400 October 09, 2019 - 07:13:00 UTC 40.01566 -122.40047 Rancho Tehama Reserve 202 [{"latitude": "39.99559", "longitude": "-122.43575"}, {"latitude": "40.00118", "longitude": "-122.41885"}, {"latitude": "40.01812", "longitude": "-122.39856"}, {"latitude": "40.02022", "longitude": "-122.39949"}, {"latitude": "40.02156", "longitude": "-122.4001"}, {"latitude": "40.02182", "longitude": "-122.40058"}, {"latitude": "40.02204", "longitude": "-122.40166"}, {"latitude": "40.02268", "longitude": "-122.44615"}, {"latitude": "40.02187", "longitude": "-122.45918"}, {"latitude": "40.02107", "longitude": "-122.45972"}, {"latitude": "40.02039", "longitude": "-122.45989"}, {"latitude": "40.00715", "longitude": "-122.46276"}, {"latitude": "39.99826", "longitude": "-122.45977"}]
654970 October 12, 2019 - 05:03:12 UTC 40.0189 -122.42602 Rancho Tehama Reserve 202 []
665774 October 17, 2019 - 19:40:26 UTC 40.01902 -122.44867 Rancho Tehama Reserve 202 []
667153 October 18, 2019 - 00:01:44 UTC 40.01101 -122.39806 Rancho Tehama Reserve 202 []
680429 October 25, 2019 - 18:42:34 UTC 40.01754 -122.45064 Rancho Tehama Reserve 202 []
681042 October 27, 2019 - 00:11:00 UTC 40.00296 -122.42475 Rancho Tehama Reserve 202 []
681060 October 27, 2019 - 00:14:00 UTC 40.01473 -122.40072 Rancho Tehama Reserve 202 []
681184 October 27, 2019 - 00:01:00 UTC 39.99671 -122.4058 Rancho Tehama Reserve 202 [{"latitude": "39.995", "longitude": "-122.4122"}, {"latitude": "39.99679", "longitude": "-122.4062"}, {"latitude": "40.01857", "longitude": "-122.35836"}, {"latitude": "40.02112", "longitude": "-122.35314"}, {"latitude": "40.02277", "longitude": "-122.36897"}, {"latitude": "40.02268", "longitude": "-122.44615"}, {"latitude": "40.02187", "longitude": "-122.45918"}, {"latitude": "40.02107", "longitude": "-122.45972"}, {"latitude": "40.02039", "longitude": "-122.45989"}, {"latitude": "40.00715", "longitude": "-122.46276"}, {"latitude": "39.99826", "longitude": "-122.45977"}, {"latitude": "39.99559", "longitude": "-122.43575"}]
681213 October 27, 2019 - 00:01:00 UTC 40.01494 -122.39762 Rancho Tehama Reserve 202 [{"latitude": "40.00966", "longitude": "-122.39"}, {"latitude": "40.01857", "longitude": "-122.35836"}, {"latitude": "40.02112", "longitude": "-122.35314"}, {"latitude": "40.02277", "longitude": "-122.36897"}, {"latitude": "40.01976", "longitude": "-122.39202"}, {"latitude": "40.01936", "longitude": "-122.39275"}, {"latitude": "40.01863", "longitude": "-122.39407"}, {"latitude": "40.01488", "longitude": "-122.39731"}]
693471 October 29, 2019 - 16:38:00 UTC 40.01244 -122.41328 Rancho Tehama Reserve 202 []
693473 October 29, 2019 - 16:39:35 UTC 40.01985 -122.44805 Rancho Tehama Reserve 202 []
693477 October 29, 2019 - 16:40:00 UTC 40.00621 -122.40425 Rancho Tehama Reserve 202 [{"latitude": "40.00078", "longitude": "-122.39903"}, {"latitude": "40.00108", "longitude": "-122.39838"}, {"latitude": "40.00354", "longitude": "-122.39481"}, {"latitude": "40.00746", "longitude": "-122.40615"}, {"latitude": "40.00634", "longitude": "-122.40709"}, {"latitude": "40.00446", "longitude": "-122.40622"}, {"latitude": "40.0028", "longitude": "-122.4054"}, {"latitude": "40.00158", "longitude": "-122.40311"}]
693487 October 29, 2019 - 16:38:46 UTC 40.01564 -122.4333 Rancho Tehama Reserve 202 [{"latitude": "39.99559", "longitude": "-122.43575"}, {"latitude": "40.00118", "longitude": "-122.41885"}, {"latitude": "40.00599", "longitude": "-122.41919"}, {"latitude": "40.01562", "longitude": "-122.43326"}, {"latitude": "40.00964", "longitude": "-122.44567"}, {"latitude": "39.99893", "longitude": "-122.45938"}, {"latitude": "39.99826", "longitude": "-122.45977"}]
693512 October 29, 2019 - 16:32:00 UTC 39.99671 -122.4058 Rancho Tehama Reserve 202 [{"latitude": "39.995", "longitude": "-122.4122"}, {"latitude": "39.99679", "longitude": "-122.4062"}, {"latitude": "40.01857", "longitude": "-122.35836"}, {"latitude": "40.02112", "longitude": "-122.35314"}, {"latitude": "40.02277", "longitude": "-122.36897"}, {"latitude": "40.02268", "longitude": "-122.44615"}, {"latitude": "40.02187", "longitude": "-122.45918"}, {"latitude": "40.02107", "longitude": "-122.45972"}, {"latitude": "40.02039", "longitude": "-122.45989"}, {"latitude": "40.00715", "longitude": "-122.46276"}, {"latitude": "39.99826", "longitude": "-122.45977"}, {"latitude": "39.99559", "longitude": "-122.43575"}]
693517 October 29, 2019 - 16:32:00 UTC 40.01494 -122.39762 Rancho Tehama Reserve 202 [{"latitude": "40.00966", "longitude": "-122.39"}, {"latitude": "40.01857", "longitude": "-122.35836"}, {"latitude": "40.02112", "longitude": "-122.35314"}, {"latitude": "40.02277", "longitude": "-122.36897"}, {"latitude": "40.01976", "longitude": "-122.39202"}, {"latitude": "40.01936", "longitude": "-122.39275"}, {"latitude": "40.01863", "longitude": "-122.39407"}, {"latitude": "40.01488", "longitude": "-122.39731"}]
696573 October 31, 2019 - 17:15:31 UTC 40.01041 -122.40979 Rancho Tehama Reserve 202 []
703050 November 09, 2019 - 01:00:58 UTC 40.01308 -122.44217 Rancho Tehama Reserve 202 []
704205 November 11, 2019 - 14:17:45 UTC 40.01976 -122.39202 Rancho Tehama Reserve 202 []
705043 November 12, 2019 - 19:22:51 UTC 40.00736 -122.40998 Rancho Tehama Reserve 202 []
707763 November 15, 2019 - 20:44:18 UTC 40.01882 -122.4512 Rancho Tehama Reserve 202 []
708359 November 16, 2019 - 20:43:26 UTC 40.00736 -122.40998 Rancho Tehama Reserve 202 []
709199 November 18, 2019 - 17:52:52 UTC 40.01214 -122.40516 Rancho Tehama Reserve 202 []
717600 November 27, 2019 - 02:55:21 UTC 40.00634 -122.40709 Rancho Tehama Reserve 202 []
778326 February 05, 2020 - 16:57:33 UTC 40.01241 -122.39062 Rancho Tehama Reserve 202 []
790392 February 13, 2020 - 19:30:00 UTC 40.0189 -122.42602 Rancho Tehama Reserve 202 []

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