outages

131 rows where regionName = 43 sorted by outageDevices

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices ▼
633526 October 01, 2019 - 11:28:11 UTC 37.29066 -121.95854 Campbell 43 []
633528 October 01, 2019 - 11:31:53 UTC 37.29 -121.9594 Campbell 43 []
633537 October 01, 2019 - 12:44:50 UTC 37.29243 -121.96658 Campbell 43 []
633549 October 01, 2019 - 13:43:00 UTC 37.29066 -121.95854 Campbell 43 []
633912 October 01, 2019 - 17:20:23 UTC 37.29407 -121.94072 Campbell 43 []
633947 October 01, 2019 - 17:41:55 UTC 37.2844 -121.94634 Campbell 43 []
636634 October 02, 2019 - 17:49:17 UTC 37.30129 -121.9409 Campbell 43 []
638666 October 02, 2019 - 23:20:19 UTC 37.27298 -121.97336 Campbell 43 []
638845 October 03, 2019 - 01:29:13 UTC 37.27943 -121.93996 Campbell 43 []
643464 October 04, 2019 - 18:22:54 UTC 37.28964 -121.95635 Campbell 43 []
643655 October 04, 2019 - 19:48:30 UTC 37.29038 -121.97432 Campbell 43 []
643682 October 04, 2019 - 20:21:55 UTC 37.2834 -121.94884 Campbell 43 []
644934 October 05, 2019 - 22:22:22 UTC 37.26513 -121.96736 Campbell 43 []
645146 October 06, 2019 - 03:29:29 UTC 37.26513 -121.96736 Campbell 43 []
646122 October 07, 2019 - 18:28:27 UTC 37.28964 -121.95635 Campbell 43 []
647070 October 08, 2019 - 14:12:23 UTC 37.28635 -121.98042 Campbell 43 []
647298 October 08, 2019 - 16:14:03 UTC 37.28988 -121.92487 Campbell 43 []
647541 October 08, 2019 - 21:03:29 UTC 37.28709 -121.97957 Campbell 43 []
647784 October 09, 2019 - 05:33:38 UTC 37.26412 -121.96746 Campbell 43 []
648198 October 09, 2019 - 08:08:04 UTC 37.26434 -121.99085 Campbell 43 []
654293 October 11, 2019 - 17:03:00 UTC 37.27653 -121.94241 Campbell 43 []
654795 October 12, 2019 - 00:27:00 UTC 37.28584 -121.9473 Campbell 43 []
655417 October 13, 2019 - 01:55:35 UTC 37.26407 -121.96971 Campbell 43 []
655805 October 14, 2019 - 14:14:46 UTC 37.28635 -121.98042 Campbell 43 []
656174 October 14, 2019 - 16:31:55 UTC 37.28617 -121.92431 Campbell 43 []
656215 October 14, 2019 - 16:35:59 UTC 37.26986 -121.97143 Campbell 43 []
658812 October 15, 2019 - 14:37:23 UTC 37.28883 -121.94372 Campbell 43 []
658823 October 15, 2019 - 14:59:20 UTC 37.27145 -121.95156 Campbell 43 []
659781 October 15, 2019 - 20:29:29 UTC 37.29203 -121.96343 Campbell 43 []
659818 October 15, 2019 - 14:59:20 UTC 37.27145 -121.95156 Campbell 43 []
664015 October 17, 2019 - 15:36:33 UTC 37.28216 -121.96036 Campbell 43 []
667275 October 18, 2019 - 02:47:58 UTC 37.2879 -121.97265 Campbell 43 []
667414 October 18, 2019 - 14:40:21 UTC 37.28495 -121.93039 Campbell 43 []
670413 October 18, 2019 - 21:44:10 UTC 37.28419 -121.92258 Campbell 43 []
670916 October 19, 2019 - 00:06:57 UTC 37.2879 -121.97265 Campbell 43 []
671676 October 19, 2019 - 16:13:27 UTC 37.28271 -121.92581 Campbell 43 []
674962 October 21, 2019 - 02:38:09 UTC 37.27264 -121.9607 Campbell 43 []
679024 October 24, 2019 - 00:56:48 UTC 37.2913 -121.97015 Campbell 43 []
690253 October 27, 2019 - 23:36:45 UTC 37.2697 -121.96689 Campbell 43 []
690995 October 28, 2019 - 05:16:46 UTC 37.292 -121.94815 Campbell 43 []
692253 October 28, 2019 - 23:24:34 UTC 37.27518 -121.96121 Campbell 43 []
693231 October 29, 2019 - 15:23:06 UTC 37.28573 -121.94161 Campbell 43 []
693402 October 29, 2019 - 16:08:55 UTC 37.27318 -121.98188 Campbell 43 []
693466 October 29, 2019 - 16:37:00 UTC 37.28677 -121.93981 Campbell 43 []
694034 October 29, 2019 - 19:54:39 UTC 37.28636 -121.94214 Campbell 43 []
696920 October 31, 2019 - 21:40:31 UTC 37.26729 -121.96596 Campbell 43 []
697005 October 31, 2019 - 23:06:33 UTC 37.2801 -121.95997 Campbell 43 []
699057 November 04, 2019 - 16:55:36 UTC 37.27686 -121.9383 Campbell 43 []
699476 November 04, 2019 - 22:48:57 UTC 37.27291 -121.96119 Campbell 43 []
700212 November 05, 2019 - 22:29:06 UTC 37.28988 -121.96598 Campbell 43 []
700522 November 06, 2019 - 15:50:59 UTC 37.29764 -121.93193 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 []
703296 November 09, 2019 - 17:29:51 UTC 37.3055 -121.94398 Campbell 43 []
704897 November 12, 2019 - 17:44:23 UTC 37.26513 -121.96736 Campbell 43 []
705631 November 13, 2019 - 04:21:13 UTC 37.27264 -121.9607 Campbell 43 []
707888 November 15, 2019 - 23:23:14 UTC 37.27518 -121.96121 Campbell 43 []
708009 November 16, 2019 - 03:40:02 UTC 37.28873 -121.9745 Campbell 43 []
712017 November 21, 2019 - 16:29:03 UTC 37.29078 -121.92386 Campbell 43 []
712021 November 21, 2019 - 16:38:25 UTC 37.26539 -121.96898 Campbell 43 []
712129 November 21, 2019 - 17:22:41 UTC 37.27586 -121.94383 Campbell 43 []
712678 November 22, 2019 - 15:57:08 UTC 37.26626 -121.95455 Campbell 43 []
720766 November 27, 2019 - 17:04:12 UTC 37.27865 -121.93569 Campbell 43 []
722402 November 28, 2019 - 05:23:25 UTC 37.28299 -121.93402 Campbell 43 []
722780 November 28, 2019 - 17:40:28 UTC 37.27818 -121.97687 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 []
724160 November 30, 2019 - 18:51:30 UTC 37.27864 -121.97803 Campbell 43 []
724685 December 01, 2019 - 00:52:20 UTC 37.27282 -121.98082 Campbell 43 []
724765 December 01, 2019 - 01:16:06 UTC 37.27342 -121.95978 Campbell 43 []
725009 December 01, 2019 - 02:10:48 UTC 37.29518 -121.95368 Campbell 43 []
725121 December 01, 2019 - 03:51:29 UTC 37.29164 -121.95266 Campbell 43 []
725190 December 01, 2019 - 04:46:35 UTC 37.30217 -121.93892 Campbell 43 []
725268 December 01, 2019 - 06:02:00 UTC 37.28162 -121.96387 Campbell 43 []
725288 December 01, 2019 - 06:20:27 UTC 37.30381 -121.94445 Campbell 43 []
725306 December 01, 2019 - 06:37:04 UTC 37.29158 -121.92435 Campbell 43 []
725323 December 01, 2019 - 06:40:21 UTC 37.30081 -121.94529 Campbell 43 []
725337 December 01, 2019 - 06:51:44 UTC 37.27864 -121.97803 Campbell 43 []
725344 December 01, 2019 - 07:03:34 UTC 37.2915 -121.92576 Campbell 43 []
725961 December 01, 2019 - 18:56:39 UTC 37.27864 -121.97803 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 []
726380 December 01, 2019 - 06:20:27 UTC 37.30381 -121.94445 Campbell 43 []
727658 December 02, 2019 - 21:15:56 UTC 37.26776 -121.96756 Campbell 43 []
727687 December 02, 2019 - 21:39:11 UTC 37.25777 -121.95039 Campbell 43 []
728891 December 03, 2019 - 21:33:42 UTC 37.29392 -121.95742 Campbell 43 []
729790 December 04, 2019 - 20:13:13 UTC 37.29281 -121.95265 Campbell 43 []
730215 December 05, 2019 - 13:05:18 UTC 37.28577 -121.9356 Campbell 43 []
730254 December 05, 2019 - 15:32:11 UTC 37.26651 -121.94499 Campbell 43 []
730700 December 05, 2019 - 21:37:08 UTC 37.27178 -121.94457 Campbell 43 []
730753 December 05, 2019 - 22:14:53 UTC 37.28024 -121.95922 Campbell 43 []
730832 December 05, 2019 - 23:58:09 UTC 37.28769 -121.92266 Campbell 43 []
731497 December 06, 2019 - 19:34:18 UTC 37.28656 -121.94598 Campbell 43 []
734000 December 09, 2019 - 01:50:10 UTC 37.2864 -121.94842 Campbell 43 []
734182 December 09, 2019 - 16:21:14 UTC 37.272 -121.95056 Campbell 43 []
734305 December 09, 2019 - 17:11:26 UTC 37.29523 -121.94797 Campbell 43 []
734313 December 09, 2019 - 17:12:00 UTC 37.28415 -121.93808 Campbell 43 []
734673 December 09, 2019 - 20:58:00 UTC 37.2864 -121.94842 Campbell 43 []
735323 December 10, 2019 - 16:55:30 UTC 37.2803 -121.95331 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 1087.904ms · About: About this site