outages

461 rows where regionName = 34 sorted by longitude descending

View and edit SQL

id outageStartTime latitude longitude ▲ regionName outageDevices
648268 October 09, 2019 - 07:48:53 UTC 38.72021 -121.9563 Woodland 34 [{"latitude": "38.72239", "longitude": "-121.95666"}, {"latitude": "38.73668", "longitude": "-121.92676"}, {"latitude": "38.74764", "longitude": "-121.92472"}, {"latitude": "38.75304", "longitude": "-121.94416"}, {"latitude": "38.74371", "longitude": "-121.95047"}, {"latitude": "38.7384", "longitude": "-121.95346"}, {"latitude": "38.73666", "longitude": "-121.95426"}, {"latitude": "38.73424", "longitude": "-121.95502"}, {"latitude": "38.73306", "longitude": "-121.95533"}, {"latitude": "38.73052", "longitude": "-121.95591"}]
648254 October 09, 2019 - 07:48:53 UTC 38.71882 -121.95259 Woodland 34 [{"latitude": "38.68811", "longitude": "-121.89899"}, {"latitude": "38.69636", "longitude": "-121.88621"}, {"latitude": "38.71879", "longitude": "-121.90514"}, {"latitude": "38.72922", "longitude": "-121.91807"}, {"latitude": "38.73007", "longitude": "-121.92161"}, {"latitude": "38.71981", "longitude": "-121.94926"}, {"latitude": "38.71211", "longitude": "-121.94819"}, {"latitude": "38.70333", "longitude": "-121.93753"}]
691336 October 28, 2019 - 14:55:01 UTC 38.66338 -121.94915 Woodland 34 []
687322 October 27, 2019 - 16:02:00 UTC 38.65703 -121.94728 Woodland 34 []
1064238 September 11, 2020 - 15:57:00 UTC 38.71764 -121.94693 Woodland 34 []
673914 October 19, 2019 - 22:01:13 UTC 38.69271 -121.9448 Woodland 34 []
674656 October 20, 2019 - 06:30:00 UTC 38.69269 -121.94417 Woodland 34 []
732986 December 07, 2019 - 22:42:35 UTC 38.5947 -121.94239 Woodland 34 []
688403 October 27, 2019 - 19:25:00 UTC 38.64929 -121.94037 Woodland 34 []
732961 December 07, 2019 - 22:31:59 UTC 38.58426 -121.93538 Woodland 34 []
634814 October 01, 2019 - 20:33:01 UTC 38.69436 -121.93466 Woodland 34 []
694652 October 30, 2019 - 04:43:26 UTC 38.69436 -121.93466 Woodland 34 []
712381 November 21, 2019 - 21:38:47 UTC 38.64946 -121.93389 Woodland 34 []
647415 October 08, 2019 - 18:06:10 UTC 38.676 -121.92681 Woodland 34 []
674890 October 20, 2019 - 21:46:04 UTC 38.62035 -121.91558 Woodland 34 []
788957 February 11, 2020 - 23:15:37 UTC 38.67361 -121.91051 Woodland 34 []
714069 November 25, 2019 - 14:31:48 UTC 38.69151 -121.90432 Woodland 34 []
699695 November 05, 2019 - 05:05:44 UTC 38.70256 -121.90207 Woodland 34 []
686425 October 27, 2019 - 09:41:27 UTC 38.70339 -121.90075 Woodland 34 []
694008 October 29, 2019 - 19:35:26 UTC 38.61998 -121.89512 Woodland 34 []
674887 October 20, 2019 - 21:36:19 UTC 38.6303 -121.89426 Woodland 34 []
695346 October 30, 2019 - 20:21:52 UTC 38.72187 -121.89031 Woodland 34 []
686111 October 27, 2019 - 08:26:44 UTC 38.76854 -121.88943 Woodland 34 []
687043 October 27, 2019 - 13:58:15 UTC 38.76854 -121.88943 Woodland 34 []
695372 October 30, 2019 - 20:31:00 UTC 38.61979 -121.88664 Woodland 34 []
692408 October 29, 2019 - 00:27:47 UTC 38.61978 -121.88661 Woodland 34 []
695124 October 30, 2019 - 18:07:00 UTC 38.61978 -121.88661 Woodland 34 []
696285 October 31, 2019 - 05:29:15 UTC 38.61978 -121.88661 Woodland 34 []
720702 November 27, 2019 - 16:54:10 UTC 38.61978 -121.88661 Woodland 34 []
1078513 September 17, 2020 - 19:53:54 UTC 38.64136 -121.88521 Woodland 34 []
726464 December 02, 2019 - 01:39:14 UTC 38.73766 -121.88316 Woodland 34 []
733395 December 08, 2019 - 03:22:27 UTC 38.61817 -121.87677 Woodland 34 []
733490 December 08, 2019 - 07:21:00 UTC 38.61817 -121.87677 Woodland 34 []
780923 February 09, 2020 - 13:10:50 UTC 38.6191 -121.87676 Woodland 34 [{"latitude": "38.56377", "longitude": "-121.85718"}, {"latitude": "38.57998", "longitude": "-121.85855"}, {"latitude": "38.59063", "longitude": "-121.85951"}, {"latitude": "38.61817", "longitude": "-121.87677"}, {"latitude": "38.59048", "longitude": "-121.89535"}, {"latitude": "38.57357", "longitude": "-121.87324"}, {"latitude": "38.57143", "longitude": "-121.86983"}]
708095 November 16, 2019 - 14:55:41 UTC 38.69334 -121.86532 Woodland 34 [{"latitude": "38.69111", "longitude": "-121.87129"}, {"latitude": "38.69198", "longitude": "-121.86727"}, {"latitude": "38.6948", "longitude": "-121.86779"}, {"latitude": "38.69319", "longitude": "-121.87464"}]
692732 October 29, 2019 - 03:20:01 UTC 38.59066 -121.86508 Woodland 34 []
696462 October 31, 2019 - 15:44:10 UTC 38.59066 -121.86508 Woodland 34 []
780921 February 09, 2020 - 13:10:00 UTC 38.61865 -121.85838 Woodland 34 [{"latitude": "38.59614", "longitude": "-121.85157"}, {"latitude": "38.61437", "longitude": "-121.86016"}, {"latitude": "38.59916", "longitude": "-121.86591"}]
783990 February 09, 2020 - 20:35:00 UTC 38.77462 -121.85812 Woodland 34 [{"latitude": "38.71355", "longitude": "-121.76748"}, {"latitude": "38.72675", "longitude": "-121.74587"}, {"latitude": "38.73486", "longitude": "-121.74452"}, {"latitude": "38.76639", "longitude": "-121.74719"}, {"latitude": "38.78667", "longitude": "-121.77108"}, {"latitude": "38.81265", "longitude": "-121.8126"}, {"latitude": "38.82313", "longitude": "-121.85324"}, {"latitude": "38.80853", "longitude": "-121.85579"}, {"latitude": "38.77767", "longitude": "-121.85894"}, {"latitude": "38.71639", "longitude": "-121.7846"}, {"latitude": "38.71362", "longitude": "-121.77184"}]
704872 November 12, 2019 - 17:38:23 UTC 38.5907 -121.85306 Woodland 34 []
686199 October 27, 2019 - 08:38:55 UTC 38.80847 -121.85134 Woodland 34 []
686996 October 27, 2019 - 14:00:00 UTC 38.72831 -121.85011 Woodland 34 []
694053 October 29, 2019 - 20:02:25 UTC 38.5916 -121.84836 Woodland 34 []
789633 February 12, 2020 - 20:53:17 UTC 38.77927 -121.84633 Woodland 34 []
686069 October 27, 2019 - 08:18:52 UTC 38.76299 -121.84132 Woodland 34 []
732725 December 07, 2019 - 20:31:13 UTC 38.67792 -121.84086 Woodland 34 [{"latitude": "38.67781", "longitude": "-121.84185"}, {"latitude": "38.68323", "longitude": "-121.84972"}, {"latitude": "38.68212", "longitude": "-121.84976"}, {"latitude": "38.67796", "longitude": "-121.84645"}, {"latitude": "38.67782", "longitude": "-121.8454"}]
691365 October 28, 2019 - 15:16:23 UTC 38.73562 -121.84053 Woodland 34 [{"latitude": "38.72813", "longitude": "-121.84879"}, {"latitude": "38.72883", "longitude": "-121.84748"}, {"latitude": "38.73699", "longitude": "-121.84885"}, {"latitude": "38.73582", "longitude": "-121.85445"}, {"latitude": "38.73501", "longitude": "-121.85445"}]
691380 October 28, 2019 - 15:16:25 UTC 38.73562 -121.84053 Woodland 34 [{"latitude": "38.72813", "longitude": "-121.84879"}, {"latitude": "38.72883", "longitude": "-121.84748"}, {"latitude": "38.73699", "longitude": "-121.84885"}, {"latitude": "38.73582", "longitude": "-121.85445"}, {"latitude": "38.73501", "longitude": "-121.85445"}]
692172 October 28, 2019 - 15:30:00 UTC 38.73562 -121.84053 Woodland 34 [{"latitude": "38.72813", "longitude": "-121.84879"}, {"latitude": "38.72883", "longitude": "-121.84748"}, {"latitude": "38.73699", "longitude": "-121.84885"}, {"latitude": "38.73582", "longitude": "-121.85445"}, {"latitude": "38.73501", "longitude": "-121.85445"}]
655894 October 14, 2019 - 15:46:04 UTC 38.56761 -121.84027 Woodland 34 []
712868 November 22, 2019 - 18:00:22 UTC 38.607 -121.84027 Woodland 34 []
1083075 September 20, 2020 - 00:09:33 UTC 38.56858 -121.84026 Woodland 34 []
685994 October 27, 2019 - 08:04:13 UTC 38.76474 -121.84009 Woodland 34 []
697376 November 01, 2019 - 16:59:23 UTC 38.56872 -121.83888 Woodland 34 []
716876 November 27, 2019 - 01:46:46 UTC 38.72179 -121.83797 Woodland 34 [{"latitude": "38.71767", "longitude": "-121.82654"}, {"latitude": "38.72439", "longitude": "-121.82368"}, {"latitude": "38.72469", "longitude": "-121.82662"}, {"latitude": "38.72243", "longitude": "-121.83712"}, {"latitude": "38.7222", "longitude": "-121.83739"}, {"latitude": "38.71833", "longitude": "-121.83527"}]
688537 October 27, 2019 - 16:13:30 UTC 38.73561 -121.83559 Woodland 34 [{"latitude": "38.71056", "longitude": "-121.80201"}, {"latitude": "38.74231", "longitude": "-121.77794"}, {"latitude": "38.74551", "longitude": "-121.78025"}, {"latitude": "38.75757", "longitude": "-121.79636"}, {"latitude": "38.7575", "longitude": "-121.80336"}, {"latitude": "38.75369", "longitude": "-121.83058"}, {"latitude": "38.73215", "longitude": "-121.83363"}, {"latitude": "38.72827", "longitude": "-121.83357"}]
696849 October 31, 2019 - 20:27:00 UTC 38.73561 -121.83559 Woodland 34 []
722064 November 28, 2019 - 01:20:16 UTC 38.68512 -121.83445 Woodland 34 []
668936 October 18, 2019 - 17:51:58 UTC 38.57525 -121.8332 Woodland 34 []
697297 November 01, 2019 - 15:50:21 UTC 38.57566 -121.83185 Woodland 34 []
727975 December 03, 2019 - 02:25:56 UTC 38.67696 -121.83151 Woodland 34 []
676379 October 21, 2019 - 21:46:13 UTC 38.69964 -121.83134 Woodland 34 []
633582 October 01, 2019 - 14:35:07 UTC 38.72181 -121.83119 Woodland 34 []
686949 October 27, 2019 - 13:49:59 UTC 38.6632 -121.83038 Woodland 34 []
655787 October 14, 2019 - 12:13:26 UTC 38.68093 -121.8301 Woodland 34 []
739598 December 14, 2019 - 19:42:09 UTC 38.69983 -121.82941 Woodland 34 []
686198 October 27, 2019 - 08:38:55 UTC 38.77916 -121.82768 Woodland 34 []
664074 October 17, 2019 - 16:12:12 UTC 38.71854 -121.82655 Woodland 34 []
686522 October 27, 2019 - 10:18:00 UTC 38.73631 -121.82623 Woodland 34 []
692493 October 29, 2019 - 00:46:00 UTC 38.73631 -121.82623 Woodland 34 []
780924 February 09, 2020 - 13:11:10 UTC 38.62113 -121.82513 Woodland 34 [{"latitude": "38.62373", "longitude": "-121.82505"}, {"latitude": "38.62676", "longitude": "-121.82095"}, {"latitude": "38.63864", "longitude": "-121.82143"}, {"latitude": "38.62678", "longitude": "-121.82665"}]
732623 December 07, 2019 - 19:30:28 UTC 38.60561 -121.82233 Woodland 34 []
715020 November 26, 2019 - 14:33:00 UTC 38.77973 -121.82167 Woodland 34 [{"latitude": "38.78391", "longitude": "-121.84953"}, {"latitude": "38.79433", "longitude": "-121.80948"}, {"latitude": "38.81265", "longitude": "-121.8126"}, {"latitude": "38.80853", "longitude": "-121.85579"}]
691832 October 28, 2019 - 19:44:06 UTC 38.68014 -121.82104 Woodland 34 []
694804 October 30, 2019 - 14:16:33 UTC 38.67866 -121.82104 Woodland 34 [{"latitude": "38.6794", "longitude": "-121.82104"}, {"latitude": "38.68526", "longitude": "-121.81941"}, {"latitude": "38.68993", "longitude": "-121.82004"}, {"latitude": "38.69015", "longitude": "-121.82103"}, {"latitude": "38.68886", "longitude": "-121.82513"}, {"latitude": "38.68834", "longitude": "-121.82554"}]
696488 October 31, 2019 - 16:11:30 UTC 38.68014 -121.82104 Woodland 34 []
686708 October 27, 2019 - 12:15:00 UTC 38.76442 -121.81978 Woodland 34 []
695653 October 30, 2019 - 22:38:00 UTC 38.69956 -121.81678 Woodland 34 [{"latitude": "38.69576", "longitude": "-121.83941"}, {"latitude": "38.69653", "longitude": "-121.83023"}, {"latitude": "38.70129", "longitude": "-121.82036"}, {"latitude": "38.70149", "longitude": "-121.82086"}, {"latitude": "38.70306", "longitude": "-121.82901"}, {"latitude": "38.70203", "longitude": "-121.83472"}, {"latitude": "38.69825", "longitude": "-121.83938"}, {"latitude": "38.6976", "longitude": "-121.83939"}]
696859 October 31, 2019 - 20:47:06 UTC 38.7312 -121.81618 Woodland 34 []
784804 February 09, 2020 - 21:35:00 UTC 38.70216 -121.81524 Woodland 34 [{"latitude": "38.70219", "longitude": "-121.81243"}, {"latitude": "38.70221", "longitude": "-121.80895"}, {"latitude": "38.7048", "longitude": "-121.80934"}, {"latitude": "38.70309", "longitude": "-121.81189"}]
690192 October 27, 2019 - 23:21:12 UTC 38.71674 -121.81522 Woodland 34 []
686116 October 27, 2019 - 08:27:34 UTC 38.71546 -121.81194 Woodland 34 []
728832 December 03, 2019 - 20:48:08 UTC 38.68008 -121.80952 Woodland 34 []
1068393 September 14, 2020 - 15:53:47 UTC 38.76432 -121.80759 Woodland 34 []
1078938 September 17, 2020 - 21:26:12 UTC 38.76431 -121.8067 Woodland 34 []
694743 October 30, 2019 - 14:16:33 UTC 38.67777 -121.80509 Woodland 34 [{"latitude": "38.66433", "longitude": "-121.82106"}, {"latitude": "38.67777", "longitude": "-121.80523"}, {"latitude": "38.68395", "longitude": "-121.80685"}, {"latitude": "38.68993", "longitude": "-121.82004"}, {"latitude": "38.69015", "longitude": "-121.82103"}, {"latitude": "38.68886", "longitude": "-121.82513"}, {"latitude": "38.67746", "longitude": "-121.83644"}, {"latitude": "38.67059", "longitude": "-121.83032"}]
687340 October 27, 2019 - 15:59:00 UTC 38.61969 -121.80409 Woodland 34 [{"latitude": "38.56377", "longitude": "-121.85718"}, {"latitude": "38.61969", "longitude": "-121.80594"}, {"latitude": "38.63864", "longitude": "-121.82143"}, {"latitude": "38.63614", "longitude": "-121.86094"}, {"latitude": "38.63433", "longitude": "-121.87647"}, {"latitude": "38.62723", "longitude": "-121.88605"}, {"latitude": "38.59048", "longitude": "-121.89535"}, {"latitude": "38.57357", "longitude": "-121.87324"}, {"latitude": "38.57143", "longitude": "-121.86983"}]
738520 December 13, 2019 - 19:25:00 UTC 38.62188 -121.80274 Woodland 34 [{"latitude": "38.62579", "longitude": "-121.80564"}, {"latitude": "38.62691", "longitude": "-121.8037"}, {"latitude": "38.63552", "longitude": "-121.794"}, {"latitude": "38.63986", "longitude": "-121.79209"}, {"latitude": "38.64044", "longitude": "-121.79207"}, {"latitude": "38.66021", "longitude": "-121.79362"}, {"latitude": "38.66644", "longitude": "-121.79751"}, {"latitude": "38.66815", "longitude": "-121.79908"}, {"latitude": "38.66942", "longitude": "-121.80033"}, {"latitude": "38.6694", "longitude": "-121.80128"}, {"latitude": "38.66821", "longitude": "-121.80205"}, {"latitude": "38.66307", "longitude": "-121.80405"}, {"latitude": "38.63258", "longitude": "-121.81506"}]
686112 October 27, 2019 - 08:26:44 UTC 38.64088 -121.80269 Woodland 34 []
677620 October 23, 2019 - 19:04:08 UTC 38.66468 -121.80162 Woodland 34 []
728149 December 03, 2019 - 08:59:27 UTC 38.69209 -121.79971 Woodland 34 [{"latitude": "38.69152", "longitude": "-121.79423"}, {"latitude": "38.69161", "longitude": "-121.79378"}, {"latitude": "38.69772", "longitude": "-121.79305"}, {"latitude": "38.69911", "longitude": "-121.79798"}, {"latitude": "38.69854", "longitude": "-121.802"}, {"latitude": "38.69364", "longitude": "-121.8019"}, {"latitude": "38.69208", "longitude": "-121.79924"}]
698187 November 02, 2019 - 17:06:10 UTC 38.74581 -121.79965 Woodland 34 []
699247 November 04, 2019 - 18:50:09 UTC 38.74581 -121.79965 Woodland 34 []
686515 October 27, 2019 - 10:14:09 UTC 38.66328 -121.79776 Woodland 34 [{"latitude": "38.66218", "longitude": "-121.79724"}, {"latitude": "38.66325", "longitude": "-121.79637"}, {"latitude": "38.66327", "longitude": "-121.79751"}]
1072673 September 15, 2020 - 20:42:08 UTC 38.66328 -121.79776 Woodland 34 [{"latitude": "38.66218", "longitude": "-121.79724"}, {"latitude": "38.66325", "longitude": "-121.79637"}, {"latitude": "38.66327", "longitude": "-121.79751"}]
647539 October 08, 2019 - 21:02:20 UTC 38.66218 -121.79724 Woodland 34 []
653370 October 10, 2019 - 20:53:00 UTC 38.69067 -121.79721 Woodland 34 []
1026961 August 22, 2020 - 16:06:27 UTC 38.66872 -121.79664 Woodland 34 []
687095 October 27, 2019 - 14:42:42 UTC 38.66602 -121.79621 Woodland 34 []
1061236 September 08, 2020 - 21:11:24 UTC 38.66602 -121.79621 Woodland 34 []

Next page

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