outages

175 rows where regionName = 132

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
633855 October 01, 2019 - 16:29:16 UTC 39.19886 -122.00288 Colusa 132 []
634843 October 01, 2019 - 21:15:43 UTC 39.31515 -122.01282 Colusa 132 []
643480 October 04, 2019 - 18:35:32 UTC 39.21437 -122.01573 Colusa 132 []
643916 October 05, 2019 - 13:13:40 UTC 39.19928 -122.00166 Colusa 132 []
647112 October 08, 2019 - 15:18:00 UTC 39.12364 -121.95915 Colusa 132 []
647550 October 08, 2019 - 21:18:15 UTC 39.20946 -122.00298 Colusa 132 []
647683 October 09, 2019 - 01:04:24 UTC 39.20633 -122.03801 Colusa 132 [{"latitude": "39.20029", "longitude": "-122.04612"}, {"latitude": "39.20471", "longitude": "-122.04165"}, {"latitude": "39.20634", "longitude": "-122.04043"}, {"latitude": "39.20978", "longitude": "-122.04316"}, {"latitude": "39.20637", "longitude": "-122.04609"}, {"latitude": "39.20472", "longitude": "-122.04721"}]
650593 October 09, 2019 - 14:06:38 UTC 39.20642 -122.01088 Colusa 132 [{"latitude": "39.20633", "longitude": "-122.01053"}, {"latitude": "39.20664", "longitude": "-122.0118"}, {"latitude": "39.20787", "longitude": "-122.0172"}, {"latitude": "39.20749", "longitude": "-122.01557"}]
650747 October 09, 2019 - 15:31:26 UTC 39.27173 -122.08332 Colusa 132 []
650848 October 09, 2019 - 17:24:31 UTC 39.20908 -121.99975 Colusa 132 []
650851 October 09, 2019 - 17:28:43 UTC 39.20872 -121.99987 Colusa 132 []
650904 October 09, 2019 - 18:24:19 UTC 39.1879 -122.01726 Colusa 132 []
650905 October 09, 2019 - 18:24:19 UTC 39.18676 -122.04335 Colusa 132 []
651434 October 09, 2019 - 22:48:50 UTC 39.27539 -122.08441 Colusa 132 [{"latitude": "39.26799", "longitude": "-122.08213"}, {"latitude": "39.27176", "longitude": "-122.08145"}, {"latitude": "39.27173", "longitude": "-122.08332"}]
651598 October 10, 2019 - 00:05:10 UTC 39.22812 -122.02132 Colusa 132 []
652955 October 10, 2019 - 18:06:26 UTC 39.14309 -121.9605 Colusa 132 []
653526 October 10, 2019 - 22:31:18 UTC 39.21506 -122.00579 Colusa 132 []
654573 October 11, 2019 - 21:27:19 UTC 39.24482 -121.95424 Colusa 132 []
654605 October 11, 2019 - 21:49:45 UTC 39.24041 -121.94859 Colusa 132 [{"latitude": "39.21541", "longitude": "-121.93702"}, {"latitude": "39.22024", "longitude": "-121.93536"}, {"latitude": "39.22044", "longitude": "-121.93535"}, {"latitude": "39.2287", "longitude": "-121.93958"}, {"latitude": "39.23813", "longitude": "-121.94565"}, {"latitude": "39.23965", "longitude": "-121.9469"}, {"latitude": "39.23971", "longitude": "-121.94844"}, {"latitude": "39.22634", "longitude": "-121.94382"}]
655008 October 12, 2019 - 12:04:02 UTC 39.22815 -122.0245 Colusa 132 [{"latitude": "39.22155", "longitude": "-122.02998"}, {"latitude": "39.22197", "longitude": "-122.02565"}, {"latitude": "39.22344", "longitude": "-122.02438"}, {"latitude": "39.22515", "longitude": "-122.02297"}, {"latitude": "39.22741", "longitude": "-122.02557"}, {"latitude": "39.23062", "longitude": "-122.03728"}, {"latitude": "39.23184", "longitude": "-122.05102"}, {"latitude": "39.23063", "longitude": "-122.05133"}]
655016 October 12, 2019 - 12:36:01 UTC 39.20633 -122.03801 Colusa 132 [{"latitude": "39.20029", "longitude": "-122.04612"}, {"latitude": "39.20471", "longitude": "-122.04165"}, {"latitude": "39.20634", "longitude": "-122.04043"}, {"latitude": "39.20978", "longitude": "-122.04316"}, {"latitude": "39.20637", "longitude": "-122.04609"}, {"latitude": "39.20472", "longitude": "-122.04721"}]
655503 October 13, 2019 - 14:13:08 UTC 39.12214 -121.95953 Colusa 132 []
655552 October 13, 2019 - 17:38:00 UTC 39.34464 -122.00353 Colusa 132 [{"latitude": "39.27403", "longitude": "-121.92793"}, {"latitude": "39.27403", "longitude": "-121.927"}, {"latitude": "39.27785", "longitude": "-121.92304"}, {"latitude": "39.34773", "longitude": "-121.8997"}, {"latitude": "39.36227", "longitude": "-121.94346"}, {"latitude": "39.36224", "longitude": "-121.95354"}, {"latitude": "39.34464", "longitude": "-122.0031"}, {"latitude": "39.30036", "longitude": "-121.98187"}]
660697 October 16, 2019 - 16:50:19 UTC 39.20719 -122.01426 Colusa 132 []
669373 October 18, 2019 - 19:14:25 UTC 39.30064 -121.92264 Colusa 132 []
675839 October 21, 2019 - 15:32:38 UTC 39.24041 -121.94859 Colusa 132 [{"latitude": "39.21541", "longitude": "-121.93702"}, {"latitude": "39.22024", "longitude": "-121.93536"}, {"latitude": "39.22044", "longitude": "-121.93535"}, {"latitude": "39.2287", "longitude": "-121.93958"}, {"latitude": "39.23813", "longitude": "-121.94565"}, {"latitude": "39.23965", "longitude": "-121.9469"}, {"latitude": "39.23971", "longitude": "-121.94844"}, {"latitude": "39.22634", "longitude": "-121.94382"}]
675935 October 21, 2019 - 16:18:00 UTC 39.188 -122.01469 Colusa 132 []
678736 October 23, 2019 - 23:13:01 UTC 39.20945 -122.01811 Colusa 132 []
679115 October 24, 2019 - 01:44:28 UTC 39.1979 -121.94443 Colusa 132 []
679173 October 24, 2019 - 02:10:00 UTC 39.19588 -121.95144 Colusa 132 []
679779 October 24, 2019 - 21:36:37 UTC 39.17426 -122.03596 Colusa 132 []
680398 October 25, 2019 - 18:00:42 UTC 39.38339 -121.93672 Colusa 132 []
680848 October 26, 2019 - 18:00:54 UTC 39.38235 -121.93634 Colusa 132 []
685489 October 27, 2019 - 06:20:40 UTC 39.24761 -122.23048 Colusa 132 []
685490 October 27, 2019 - 06:20:38 UTC 39.25203 -122.23732 Colusa 132 []
685506 October 27, 2019 - 06:19:00 UTC 39.1301 -121.9505 Colusa 132 [{"latitude": "39.08963", "longitude": "-121.98299"}, {"latitude": "39.09292", "longitude": "-121.95514"}, {"latitude": "39.13202", "longitude": "-121.95344"}, {"latitude": "39.13011", "longitude": "-121.97799"}, {"latitude": "39.11481", "longitude": "-121.98745"}, {"latitude": "39.09712", "longitude": "-121.99491"}]
685508 October 27, 2019 - 06:20:33 UTC 39.24541 -122.21841 Colusa 132 []
685749 October 27, 2019 - 07:21:15 UTC 39.20856 -121.99901 Colusa 132 []
685781 October 27, 2019 - 07:14:00 UTC 39.21298 -121.99947 Colusa 132 [{"latitude": "39.19902", "longitude": "-121.99796"}, {"latitude": "39.19913", "longitude": "-121.99529"}, {"latitude": "39.19924", "longitude": "-121.99272"}, {"latitude": "39.19975", "longitude": "-121.98839"}, {"latitude": "39.20391", "longitude": "-121.98568"}, {"latitude": "39.20566", "longitude": "-121.98454"}, {"latitude": "39.20919", "longitude": "-121.98956"}, {"latitude": "39.21166", "longitude": "-121.99363"}, {"latitude": "39.21299", "longitude": "-121.99649"}, {"latitude": "39.21333", "longitude": "-121.99802"}, {"latitude": "39.21278", "longitude": "-121.99865"}, {"latitude": "39.21007", "longitude": "-122.00129"}, {"latitude": "39.20913", "longitude": "-122.00152"}]
685938 October 27, 2019 - 07:48:32 UTC 39.28121 -122.00864 Colusa 132 []
685986 October 27, 2019 - 08:01:36 UTC 39.19721 -122.00953 Colusa 132 []
685995 October 27, 2019 - 08:04:28 UTC 39.2063 -122.00219 Colusa 132 []
685996 October 27, 2019 - 08:04:48 UTC 39.20642 -122.01088 Colusa 132 [{"latitude": "39.20633", "longitude": "-122.01053"}, {"latitude": "39.20664", "longitude": "-122.0118"}, {"latitude": "39.20787", "longitude": "-122.0172"}, {"latitude": "39.20749", "longitude": "-122.01557"}]
686003 October 27, 2019 - 08:03:00 UTC 39.14623 -121.93883 Colusa 132 [{"latitude": "39.06062", "longitude": "-121.94501"}, {"latitude": "39.07245", "longitude": "-121.90125"}, {"latitude": "39.11222", "longitude": "-121.91253"}, {"latitude": "39.11996", "longitude": "-121.91681"}, {"latitude": "39.14511", "longitude": "-121.93823"}, {"latitude": "39.1438", "longitude": "-121.96269"}, {"latitude": "39.08572", "longitude": "-121.96884"}]
686076 October 27, 2019 - 08:20:50 UTC 39.21585 -122.02091 Colusa 132 []
686316 October 27, 2019 - 09:11:00 UTC 39.27545 -122.12344 Colusa 132 [{"latitude": "39.25988", "longitude": "-122.0724"}, {"latitude": "39.27033", "longitude": "-122.02911"}, {"latitude": "39.28596", "longitude": "-122.01691"}, {"latitude": "39.29", "longitude": "-122.01618"}, {"latitude": "39.29353", "longitude": "-122.01621"}, {"latitude": "39.31752", "longitude": "-122.02968"}, {"latitude": "39.32294", "longitude": "-122.03423"}, {"latitude": "39.3188", "longitude": "-122.07989"}, {"latitude": "39.3007", "longitude": "-122.13524"}, {"latitude": "39.28008", "longitude": "-122.12253"}, {"latitude": "39.2751", "longitude": "-122.11664"}, {"latitude": "39.26078", "longitude": "-122.08478"}, {"latitude": "39.26017", "longitude": "-122.0789"}]
686747 October 27, 2019 - 12:45:00 UTC 39.20038 -122.005 Colusa 132 []
686782 October 27, 2019 - 13:09:48 UTC 39.21071 -122.01257 Colusa 132 []
686953 October 27, 2019 - 13:50:49 UTC 39.20993 -122.00919 Colusa 132 []
687002 October 27, 2019 - 14:07:00 UTC 39.21023 -122.01049 Colusa 132 []
687222 October 27, 2019 - 15:23:37 UTC 39.21355 -122.01224 Colusa 132 []
687228 October 27, 2019 - 15:26:00 UTC 39.20946 -122.00298 Colusa 132 []
687610 October 27, 2019 - 17:04:56 UTC 39.19477 -121.9378 Colusa 132 []
688094 October 27, 2019 - 07:14:00 UTC 39.20729 -121.99139 Colusa 132 [{"latitude": "39.20391", "longitude": "-121.98568"}, {"latitude": "39.20566", "longitude": "-121.98454"}, {"latitude": "39.20919", "longitude": "-121.98956"}, {"latitude": "39.20734", "longitude": "-121.98874"}, {"latitude": "39.20657", "longitude": "-121.98835"}]
688189 October 27, 2019 - 18:46:25 UTC 39.21476 -122.00878 Colusa 132 []
688866 October 27, 2019 - 20:28:44 UTC 39.2003 -122.00258 Colusa 132 []
690479 October 28, 2019 - 00:45:11 UTC 39.21449 -122.01622 Colusa 132 []
690674 October 28, 2019 - 01:53:26 UTC 39.29035 -122.04636 Colusa 132 []
691498 October 28, 2019 - 16:18:03 UTC 39.19577 -121.935 Colusa 132 [{"latitude": "39.19701", "longitude": "-121.92974"}, {"latitude": "39.19985", "longitude": "-121.9211"}, {"latitude": "39.20215", "longitude": "-121.92992"}]
691752 October 28, 2019 - 18:52:16 UTC 39.20664 -122.0118 Colusa 132 []
691871 October 28, 2019 - 20:07:52 UTC 39.19928 -122.00166 Colusa 132 []
692678 October 29, 2019 - 02:22:55 UTC 39.33101 -122.0614 Colusa 132 []
693334 October 29, 2019 - 15:54:28 UTC 39.27476 -121.9288 Colusa 132 []
694109 October 29, 2019 - 20:39:17 UTC 39.21442 -121.99396 Colusa 132 []
696769 October 31, 2019 - 19:23:32 UTC 39.21349 -122.01621 Colusa 132 []
697106 November 01, 2019 - 01:19:48 UTC 39.21124 -122.01066 Colusa 132 []
697835 November 01, 2019 - 22:31:02 UTC 39.29798 -122.0344 Colusa 132 [{"latitude": "39.29022", "longitude": "-122.0506"}, {"latitude": "39.29799", "longitude": "-122.03607"}, {"latitude": "39.29838", "longitude": "-122.05111"}]
698215 November 02, 2019 - 17:47:36 UTC 39.14377 -121.96138 Colusa 132 []
698321 November 02, 2019 - 21:57:13 UTC 39.14377 -121.96138 Colusa 132 []
698577 November 03, 2019 - 17:11:41 UTC 39.22474 -122.01631 Colusa 132 []
698997 November 04, 2019 - 15:56:40 UTC 39.20525 -122.00102 Colusa 132 []
699447 November 04, 2019 - 21:59:57 UTC 39.20518 -122.00979 Colusa 132 []
700049 November 05, 2019 - 19:08:03 UTC 39.21824 -122.00022 Colusa 132 []
703973 November 10, 2019 - 20:19:42 UTC 39.20525 -122.00102 Colusa 132 []
706409 November 14, 2019 - 01:03:06 UTC 39.21585 -122.02091 Colusa 132 []
706834 November 14, 2019 - 18:50:30 UTC 39.21585 -122.02091 Colusa 132 []
706917 November 14, 2019 - 20:33:47 UTC 39.20525 -122.00102 Colusa 132 []
707947 November 16, 2019 - 00:46:27 UTC 39.21463 -122.03679 Colusa 132 []
708241 November 16, 2019 - 18:04:31 UTC 39.37647 -121.99407 Colusa 132 []
709268 November 18, 2019 - 18:41:43 UTC 39.21817 -122.11585 Colusa 132 [{"latitude": "39.22441", "longitude": "-122.11591"}, {"latitude": "39.25161", "longitude": "-122.11018"}, {"latitude": "39.24616", "longitude": "-122.11635"}, {"latitude": "39.22444", "longitude": "-122.13312"}]
711142 November 20, 2019 - 16:44:03 UTC 39.20913 -122.00152 Colusa 132 []
711173 November 20, 2019 - 16:50:31 UTC 39.36238 -121.99742 Colusa 132 []
711195 November 20, 2019 - 16:55:41 UTC 39.3107 -121.98325 Colusa 132 []
711316 November 20, 2019 - 16:44:03 UTC 39.20736 -122.00034 Colusa 132 [{"latitude": "39.20773", "longitude": "-121.99963"}, {"latitude": "39.20856", "longitude": "-121.99901"}, {"latitude": "39.21021", "longitude": "-121.99936"}, {"latitude": "39.21007", "longitude": "-122.00129"}, {"latitude": "39.20913", "longitude": "-122.00152"}, {"latitude": "39.20808", "longitude": "-122.00115"}, {"latitude": "39.20798", "longitude": "-122.00073"}]
711403 November 20, 2019 - 18:13:00 UTC 39.20946 -122.00298 Colusa 132 []
711550 November 20, 2019 - 20:00:30 UTC 39.26844 -122.05594 Colusa 132 []
711986 November 21, 2019 - 15:40:07 UTC 39.23934 -122.06042 Colusa 132 []
713101 November 22, 2019 - 22:45:02 UTC 39.31496 -122.03438 Colusa 132 []
714063 November 25, 2019 - 13:47:00 UTC 39.18863 -122.01055 Colusa 132 [{"latitude": "39.13602", "longitude": "-122.0057"}, {"latitude": "39.166", "longitude": "-121.9963"}, {"latitude": "39.18782", "longitude": "-122.01089"}, {"latitude": "39.19106", "longitude": "-122.02445"}, {"latitude": "39.18809", "longitude": "-122.04025"}, {"latitude": "39.18676", "longitude": "-122.04335"}, {"latitude": "39.16184", "longitude": "-122.03917"}, {"latitude": "39.1439", "longitude": "-122.02706"}]
714153 November 25, 2019 - 16:30:39 UTC 39.16184 -122.03917 Colusa 132 []
716747 November 27, 2019 - 01:25:00 UTC 39.27545 -122.12344 Colusa 132 [{"latitude": "39.25988", "longitude": "-122.0724"}, {"latitude": "39.26099", "longitude": "-122.0697"}, {"latitude": "39.2732", "longitude": "-122.05125"}, {"latitude": "39.27425", "longitude": "-122.04991"}, {"latitude": "39.29456", "longitude": "-122.0603"}, {"latitude": "39.3188", "longitude": "-122.07989"}, {"latitude": "39.3007", "longitude": "-122.13524"}, {"latitude": "39.28008", "longitude": "-122.12253"}, {"latitude": "39.2751", "longitude": "-122.11664"}, {"latitude": "39.26078", "longitude": "-122.08478"}, {"latitude": "39.26017", "longitude": "-122.0789"}]
718858 November 27, 2019 - 01:25:00 UTC 39.27549 -122.12252 Colusa 132 []
722729 November 28, 2019 - 16:54:00 UTC 39.21047 -122.01151 Colusa 132 []
723643 November 29, 2019 - 20:44:46 UTC 39.2655 -121.97208 Colusa 132 []
726762 December 02, 2019 - 06:38:00 UTC 39.21358 -122.00306 Colusa 132 [{"latitude": "39.17513", "longitude": "-122.06012"}, {"latitude": "39.19779", "longitude": "-122.00333"}, {"latitude": "39.20368", "longitude": "-122.00093"}, {"latitude": "39.20441", "longitude": "-122.00083"}, {"latitude": "39.21188", "longitude": "-122.00078"}, {"latitude": "39.21311", "longitude": "-122.00129"}, {"latitude": "39.21449", "longitude": "-122.00335"}, {"latitude": "39.21576", "longitude": "-122.00616"}, {"latitude": "39.21655", "longitude": "-122.01304"}, {"latitude": "39.21662", "longitude": "-122.02161"}, {"latitude": "39.21367", "longitude": "-122.03933"}, {"latitude": "39.19496", "longitude": "-122.06025"}]
726767 December 02, 2019 - 06:42:00 UTC 39.21282 -122.02016 Colusa 132 []
726769 December 02, 2019 - 06:42:00 UTC 39.26574 -122.03648 Colusa 132 []
726771 December 02, 2019 - 06:42:00 UTC 39.19563 -122.00862 Colusa 132 []
726775 December 02, 2019 - 06:42:00 UTC 39.19272 -122.00888 Colusa 132 []
726781 December 02, 2019 - 06:44:03 UTC 39.21454 -122.01211 Colusa 132 []

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