outages

131 rows where regionName = 43 sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
742793 December 16, 2019 - 18:48:27 UTC 37.28347 -121.92256 Campbell 43 []
670413 October 18, 2019 - 21:44:10 UTC 37.28419 -121.92258 Campbell 43 []
730832 December 05, 2019 - 23:58:09 UTC 37.28769 -121.92266 Campbell 43 []
712017 November 21, 2019 - 16:29:03 UTC 37.29078 -121.92386 Campbell 43 []
656174 October 14, 2019 - 16:31:55 UTC 37.28617 -121.92431 Campbell 43 []
783749 February 09, 2020 - 20:21:52 UTC 37.28617 -121.92431 Campbell 43 []
725306 December 01, 2019 - 06:37:04 UTC 37.29158 -121.92435 Campbell 43 []
739392 December 14, 2019 - 17:09:00 UTC 37.28372 -121.92475 Campbell 43 [{"latitude": "37.28368", "longitude": "-121.92418"}, {"latitude": "37.28369", "longitude": "-121.92364"}, {"latitude": "37.28368", "longitude": "-121.92631"}]
647298 October 08, 2019 - 16:14:03 UTC 37.28988 -121.92487 Campbell 43 []
725344 December 01, 2019 - 07:03:34 UTC 37.2915 -121.92576 Campbell 43 []
671676 October 19, 2019 - 16:13:27 UTC 37.28271 -121.92581 Campbell 43 []
781383 February 09, 2020 - 17:00:05 UTC 37.28616 -121.92615 Campbell 43 []
667414 October 18, 2019 - 14:40:21 UTC 37.28495 -121.93039 Campbell 43 []
700522 November 06, 2019 - 15:50:59 UTC 37.29764 -121.93193 Campbell 43 []
722402 November 28, 2019 - 05:23:25 UTC 37.28299 -121.93402 Campbell 43 []
730215 December 05, 2019 - 13:05:18 UTC 37.28577 -121.9356 Campbell 43 []
713748 November 24, 2019 - 15:17:00 UTC 37.29173 -121.93566 Campbell 43 [{"latitude": "37.2677", "longitude": "-121.92283"}, {"latitude": "37.26792", "longitude": "-121.92014"}, {"latitude": "37.2731", "longitude": "-121.91919"}, {"latitude": "37.27567", "longitude": "-121.92034"}, {"latitude": "37.28927", "longitude": "-121.92735"}, {"latitude": "37.29017", "longitude": "-121.92807"}, {"latitude": "37.29134", "longitude": "-121.93412"}, {"latitude": "37.29021", "longitude": "-121.93447"}, {"latitude": "37.2777", "longitude": "-121.93378"}, {"latitude": "37.27327", "longitude": "-121.93336"}, {"latitude": "37.26906", "longitude": "-121.931"}, {"latitude": "37.26773", "longitude": "-121.92599"}, {"latitude": "37.2677", "longitude": "-121.9241"}]
720766 November 27, 2019 - 17:04:12 UTC 37.27865 -121.93569 Campbell 43 []
783409 February 09, 2020 - 19:46:00 UTC 37.29154 -121.93573 Campbell 43 [{"latitude": "37.30438", "longitude": "-121.93026"}, {"latitude": "37.30601", "longitude": "-121.92345"}, {"latitude": "37.30798", "longitude": "-121.91532"}, {"latitude": "37.31036", "longitude": "-121.91421"}, {"latitude": "37.3147", "longitude": "-121.91642"}, {"latitude": "37.31496", "longitude": "-121.91687"}, {"latitude": "37.31543", "longitude": "-121.91779"}, {"latitude": "37.31593", "longitude": "-121.91931"}, {"latitude": "37.31531", "longitude": "-121.92291"}, {"latitude": "37.31213", "longitude": "-121.93008"}, {"latitude": "37.31138", "longitude": "-121.93047"}, {"latitude": "37.30571", "longitude": "-121.9309"}]
734313 December 09, 2019 - 17:12:00 UTC 37.28415 -121.93808 Campbell 43 []
699057 November 04, 2019 - 16:55:36 UTC 37.27686 -121.9383 Campbell 43 []
783285 February 09, 2020 - 19:46:51 UTC 37.29015 -121.93881 Campbell 43 []
725190 December 01, 2019 - 04:46:35 UTC 37.30217 -121.93892 Campbell 43 []
693466 October 29, 2019 - 16:37:00 UTC 37.28677 -121.93981 Campbell 43 []
638845 October 03, 2019 - 01:29:13 UTC 37.27943 -121.93996 Campbell 43 []
633912 October 01, 2019 - 17:20:23 UTC 37.29407 -121.94072 Campbell 43 []
636634 October 02, 2019 - 17:49:17 UTC 37.30129 -121.9409 Campbell 43 []
778584 February 05, 2020 - 20:27:48 UTC 37.30276 -121.94091 Campbell 43 []
693231 October 29, 2019 - 15:23:06 UTC 37.28573 -121.94161 Campbell 43 []
740456 December 16, 2019 - 06:06:01 UTC 37.29587 -121.94202 Campbell 43 []
694034 October 29, 2019 - 19:54:39 UTC 37.28636 -121.94214 Campbell 43 []
654293 October 11, 2019 - 17:03:00 UTC 37.27653 -121.94241 Campbell 43 []
701288 November 07, 2019 - 01:51:39 UTC 37.29105 -121.94257 Campbell 43 []
702805 November 08, 2019 - 19:45:07 UTC 37.27028 -121.94343 Campbell 43 []
658812 October 15, 2019 - 14:37:23 UTC 37.28883 -121.94372 Campbell 43 []
712129 November 21, 2019 - 17:22:41 UTC 37.27586 -121.94383 Campbell 43 []
703296 November 09, 2019 - 17:29:51 UTC 37.3055 -121.94398 Campbell 43 []
787180 February 10, 2020 - 17:24:10 UTC 37.30214 -121.94444 Campbell 43 []
725288 December 01, 2019 - 06:20:27 UTC 37.30381 -121.94445 Campbell 43 []
726380 December 01, 2019 - 06:20:27 UTC 37.30381 -121.94445 Campbell 43 []
730700 December 05, 2019 - 21:37:08 UTC 37.27178 -121.94457 Campbell 43 []
730254 December 05, 2019 - 15:32:11 UTC 37.26651 -121.94499 Campbell 43 []
738660 December 13, 2019 - 22:32:00 UTC 37.27513 -121.94504 Campbell 43 []
725323 December 01, 2019 - 06:40:21 UTC 37.30081 -121.94529 Campbell 43 []
731497 December 06, 2019 - 19:34:18 UTC 37.28656 -121.94598 Campbell 43 []
633947 October 01, 2019 - 17:41:55 UTC 37.2844 -121.94634 Campbell 43 []
654795 October 12, 2019 - 00:27:00 UTC 37.28584 -121.9473 Campbell 43 []
734305 December 09, 2019 - 17:11:26 UTC 37.29523 -121.94797 Campbell 43 []
690995 October 28, 2019 - 05:16:46 UTC 37.292 -121.94815 Campbell 43 []
734000 December 09, 2019 - 01:50:10 UTC 37.2864 -121.94842 Campbell 43 []
734673 December 09, 2019 - 20:58:00 UTC 37.2864 -121.94842 Campbell 43 []
643682 October 04, 2019 - 20:21:55 UTC 37.2834 -121.94884 Campbell 43 []
727687 December 02, 2019 - 21:39:11 UTC 37.25777 -121.95039 Campbell 43 []
778417 February 05, 2020 - 17:48:55 UTC 37.25777 -121.95039 Campbell 43 []
783510 February 09, 2020 - 20:00:22 UTC 37.26087 -121.95054 Campbell 43 []
734182 December 09, 2019 - 16:21:14 UTC 37.272 -121.95056 Campbell 43 []
675927 October 21, 2019 - 16:16:22 UTC 37.27182 -121.95155 Campbell 43 [{"latitude": "37.27036", "longitude": "-121.95157"}, {"latitude": "37.27177", "longitude": "-121.95155"}, {"latitude": "37.27145", "longitude": "-121.95156"}, {"latitude": "37.27075", "longitude": "-121.95157"}]
658823 October 15, 2019 - 14:59:20 UTC 37.27145 -121.95156 Campbell 43 []
659818 October 15, 2019 - 14:59:20 UTC 37.27145 -121.95156 Campbell 43 []
729790 December 04, 2019 - 20:13:13 UTC 37.29281 -121.95265 Campbell 43 []
725121 December 01, 2019 - 03:51:29 UTC 37.29164 -121.95266 Campbell 43 []
726062 December 01, 2019 - 20:20:32 UTC 37.29164 -121.95266 Campbell 43 []
726142 December 01, 2019 - 21:39:00 UTC 37.29164 -121.95266 Campbell 43 []
726279 December 01, 2019 - 23:19:00 UTC 37.29164 -121.95266 Campbell 43 []
789621 February 12, 2020 - 20:43:25 UTC 37.27749 -121.95312 Campbell 43 []
740147 December 15, 2019 - 17:59:44 UTC 37.27946 -121.95326 Campbell 43 []
743641 December 16, 2019 - 21:46:54 UTC 37.27946 -121.95326 Campbell 43 []
735323 December 10, 2019 - 16:55:30 UTC 37.2803 -121.95331 Campbell 43 []
787450 February 10, 2020 - 19:43:18 UTC 37.29475 -121.95357 Campbell 43 []
725009 December 01, 2019 - 02:10:48 UTC 37.29518 -121.95368 Campbell 43 []
712678 November 22, 2019 - 15:57:08 UTC 37.26626 -121.95455 Campbell 43 []
643464 October 04, 2019 - 18:22:54 UTC 37.28964 -121.95635 Campbell 43 []
646122 October 07, 2019 - 18:28:27 UTC 37.28964 -121.95635 Campbell 43 []
728891 December 03, 2019 - 21:33:42 UTC 37.29392 -121.95742 Campbell 43 []
633524 October 01, 2019 - 11:26:51 UTC 37.29081 -121.95834 Campbell 43 [{"latitude": "37.29132", "longitude": "-121.9585"}, {"latitude": "37.29177", "longitude": "-121.95685"}, {"latitude": "37.29439", "longitude": "-121.95733"}, {"latitude": "37.29446", "longitude": "-121.95998"}, {"latitude": "37.29377", "longitude": "-121.96015"}, {"latitude": "37.29283", "longitude": "-121.96013"}]
692870 October 29, 2019 - 09:36:37 UTC 37.29081 -121.95834 Campbell 43 [{"latitude": "37.29132", "longitude": "-121.9585"}, {"latitude": "37.29177", "longitude": "-121.95685"}, {"latitude": "37.29439", "longitude": "-121.95733"}, {"latitude": "37.29446", "longitude": "-121.95998"}, {"latitude": "37.29377", "longitude": "-121.96015"}, {"latitude": "37.29283", "longitude": "-121.96013"}]
701420 November 07, 2019 - 08:38:00 UTC 37.29081 -121.95834 Campbell 43 [{"latitude": "37.29132", "longitude": "-121.9585"}, {"latitude": "37.29177", "longitude": "-121.95685"}, {"latitude": "37.29439", "longitude": "-121.95733"}, {"latitude": "37.29446", "longitude": "-121.95998"}, {"latitude": "37.29377", "longitude": "-121.96015"}, {"latitude": "37.29283", "longitude": "-121.96013"}]
633526 October 01, 2019 - 11:28:11 UTC 37.29066 -121.95854 Campbell 43 []
633549 October 01, 2019 - 13:43:00 UTC 37.29066 -121.95854 Campbell 43 []
730753 December 05, 2019 - 22:14:53 UTC 37.28024 -121.95922 Campbell 43 []
633528 October 01, 2019 - 11:31:53 UTC 37.29 -121.9594 Campbell 43 []
724765 December 01, 2019 - 01:16:06 UTC 37.27342 -121.95978 Campbell 43 []
697005 October 31, 2019 - 23:06:33 UTC 37.2801 -121.95997 Campbell 43 []
664015 October 17, 2019 - 15:36:33 UTC 37.28216 -121.96036 Campbell 43 []
674962 October 21, 2019 - 02:38:09 UTC 37.27264 -121.9607 Campbell 43 []
705631 November 13, 2019 - 04:21:13 UTC 37.27264 -121.9607 Campbell 43 []
699476 November 04, 2019 - 22:48:57 UTC 37.27291 -121.96119 Campbell 43 []
692253 October 28, 2019 - 23:24:34 UTC 37.27518 -121.96121 Campbell 43 []
707888 November 15, 2019 - 23:23:14 UTC 37.27518 -121.96121 Campbell 43 []
736730 December 12, 2019 - 00:00:09 UTC 37.26629 -121.96205 Campbell 43 []
738720 December 14, 2019 - 00:10:07 UTC 37.26629 -121.96205 Campbell 43 []
659781 October 15, 2019 - 20:29:29 UTC 37.29203 -121.96343 Campbell 43 []
723002 November 28, 2019 - 20:28:00 UTC 37.28283 -121.96383 Campbell 43 []
723039 November 28, 2019 - 20:59:25 UTC 37.28283 -121.96383 Campbell 43 []
725268 December 01, 2019 - 06:02:00 UTC 37.28162 -121.96387 Campbell 43 []
696920 October 31, 2019 - 21:40:31 UTC 37.26729 -121.96596 Campbell 43 []
700212 November 05, 2019 - 22:29:06 UTC 37.28988 -121.96598 Campbell 43 []
633537 October 01, 2019 - 12:44:50 UTC 37.29243 -121.96658 Campbell 43 []
690253 October 27, 2019 - 23:36:45 UTC 37.2697 -121.96689 Campbell 43 []
644934 October 05, 2019 - 22:22:22 UTC 37.26513 -121.96736 Campbell 43 []

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