outages

328 rows where regionName = 4 sorted by outageDevices

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices ▼
633481 October 01, 2019 - 05:08:00 UTC 37.69717 -122.08699 Castro Valley 4 []
633826 October 01, 2019 - 16:22:23 UTC 37.70669 -122.10963 Castro Valley 4 []
634236 October 01, 2019 - 19:17:04 UTC 37.74541 -122.03152 Castro Valley 4 []
636256 October 02, 2019 - 17:02:00 UTC 37.70828 -122.10286 Castro Valley 4 []
639313 October 03, 2019 - 17:20:19 UTC 37.70249 -122.02892 Castro Valley 4 []
643889 October 05, 2019 - 06:24:46 UTC 37.7046 -122.0874 Castro Valley 4 []
645015 October 05, 2019 - 23:03:22 UTC 37.70125 -122.08102 Castro Valley 4 []
645760 October 07, 2019 - 06:26:21 UTC 37.71023 -122.06891 Castro Valley 4 []
646136 October 07, 2019 - 18:25:00 UTC 37.71902 -122.0824 Castro Valley 4 []
646163 October 07, 2019 - 19:15:46 UTC 37.70006 -122.0974 Castro Valley 4 []
646992 October 08, 2019 - 02:28:57 UTC 37.6879 -122.01993 Castro Valley 4 []
647352 October 08, 2019 - 16:58:49 UTC 37.69255 -122.09139 Castro Valley 4 []
647372 October 08, 2019 - 16:58:49 UTC 37.69255 -122.09139 Castro Valley 4 []
647373 October 08, 2019 - 17:08:44 UTC 37.69284 -122.09024 Castro Valley 4 []
647775 October 09, 2019 - 04:39:55 UTC 37.70007 -122.1064 Castro Valley 4 []
652223 October 10, 2019 - 06:14:33 UTC 37.69607 -122.05 Castro Valley 4 []
652527 October 10, 2019 - 07:43:51 UTC 37.69707 -122.08382 Castro Valley 4 []
652934 October 10, 2019 - 06:14:33 UTC 37.65321 -121.98575 Castro Valley 4 []
652987 October 10, 2019 - 18:24:00 UTC 37.70156 -122.04593 Castro Valley 4 []
653247 October 10, 2019 - 06:13:34 UTC 37.76819 -122.00754 Castro Valley 4 []
653255 October 10, 2019 - 06:13:34 UTC 37.76692 -122.01091 Castro Valley 4 []
653262 October 10, 2019 - 06:13:34 UTC 37.76304 -122.02371 Castro Valley 4 []
653392 October 10, 2019 - 21:02:00 UTC 37.71387 -122.07219 Castro Valley 4 []
653492 October 10, 2019 - 22:00:21 UTC 37.71249 -122.08918 Castro Valley 4 []
653897 October 11, 2019 - 03:18:00 UTC 37.70467 -122.04543 Castro Valley 4 []
653988 October 11, 2019 - 05:06:00 UTC 37.70873 -122.02921 Castro Valley 4 []
655322 October 12, 2019 - 21:54:38 UTC 37.71432 -122.0957 Castro Valley 4 []
655379 October 13, 2019 - 00:02:41 UTC 37.71157 -122.08863 Castro Valley 4 []
656873 October 14, 2019 - 17:37:50 UTC 37.7123 -122.04764 Castro Valley 4 []
657814 October 14, 2019 - 20:10:58 UTC 37.71161 -122.09859 Castro Valley 4 []
663323 October 17, 2019 - 14:06:00 UTC 37.70164 -122.08474 Castro Valley 4 []
664155 October 17, 2019 - 16:35:00 UTC 37.70757 -122.02385 Castro Valley 4 []
664357 October 17, 2019 - 16:53:25 UTC 37.7054 -122.10523 Castro Valley 4 []
671193 October 19, 2019 - 15:00:00 UTC 37.71258 -122.12155 Castro Valley 4 []
674803 October 20, 2019 - 17:08:25 UTC 37.71891 -122.00388 Castro Valley 4 []
676470 October 21, 2019 - 23:55:55 UTC 37.70164 -122.08474 Castro Valley 4 []
676483 October 22, 2019 - 00:25:00 UTC 37.70776 -122.08329 Castro Valley 4 []
676752 October 22, 2019 - 16:27:00 UTC 37.70534 -122.09958 Castro Valley 4 []
676874 October 22, 2019 - 18:21:42 UTC 37.70103 -122.07854 Castro Valley 4 []
677436 October 23, 2019 - 16:06:48 UTC 37.71525 -122.09217 Castro Valley 4 []
677474 October 23, 2019 - 16:27:51 UTC 37.69509 -122.09042 Castro Valley 4 []
677477 October 23, 2019 - 16:25:20 UTC 37.71613 -122.09321 Castro Valley 4 []
677497 October 23, 2019 - 16:46:18 UTC 37.69428 -122.07425 Castro Valley 4 []
679499 October 24, 2019 - 16:30:11 UTC 37.71454 -122.09673 Castro Valley 4 []
680000 October 25, 2019 - 00:47:46 UTC 37.69732 -122.06489 Castro Valley 4 []
680534 October 25, 2019 - 21:19:01 UTC 37.71483 -122.07234 Castro Valley 4 []
680588 October 25, 2019 - 22:49:38 UTC 37.70455 -122.08949 Castro Valley 4 []
680682 October 26, 2019 - 02:18:30 UTC 37.69242 -122.06809 Castro Valley 4 []
687617 October 27, 2019 - 17:06:45 UTC 37.6881 -122.078 Castro Valley 4 []
687675 October 27, 2019 - 17:20:29 UTC 37.70088 -122.04829 Castro Valley 4 []
687860 October 27, 2019 - 17:56:27 UTC 37.696 -122.08973 Castro Valley 4 []
687892 October 27, 2019 - 17:59:50 UTC 37.6993 -122.09518 Castro Valley 4 []
688167 October 27, 2019 - 18:43:51 UTC 37.70205 -122.09149 Castro Valley 4 []
689245 October 27, 2019 - 21:02:36 UTC 37.69389 -122.09929 Castro Valley 4 []
689428 October 27, 2019 - 21:23:42 UTC 37.6961 -122.0981 Castro Valley 4 []
689482 October 27, 2019 - 21:33:12 UTC 37.69977 -122.10006 Castro Valley 4 []
689491 October 27, 2019 - 21:35:17 UTC 37.68129 -122.07736 Castro Valley 4 []
690825 October 28, 2019 - 03:11:26 UTC 37.70788 -122.06134 Castro Valley 4 []
690894 October 28, 2019 - 03:57:57 UTC 37.69598 -122.06772 Castro Valley 4 []
691564 October 28, 2019 - 16:54:01 UTC 37.70892 -122.06376 Castro Valley 4 []
692011 October 28, 2019 - 21:14:32 UTC 37.70924 -122.09441 Castro Valley 4 []
692142 October 28, 2019 - 22:19:27 UTC 37.70317 -122.09963 Castro Valley 4 []
692246 October 28, 2019 - 23:17:00 UTC 37.70838 -122.0462 Castro Valley 4 []
692395 October 29, 2019 - 00:19:48 UTC 37.7 -122.10233 Castro Valley 4 []
692525 October 29, 2019 - 00:57:59 UTC 37.70806 -122.09627 Castro Valley 4 []
692733 October 29, 2019 - 03:23:00 UTC 37.70838 -122.0462 Castro Valley 4 []
693309 October 29, 2019 - 15:49:27 UTC 37.68129 -122.07736 Castro Valley 4 []
694108 October 29, 2019 - 20:37:09 UTC 37.7 -122.10233 Castro Valley 4 []
694179 October 29, 2019 - 21:24:49 UTC 37.71917 -122.07428 Castro Valley 4 []
695391 October 30, 2019 - 20:49:31 UTC 37.71063 -122.08415 Castro Valley 4 []
695432 October 30, 2019 - 21:12:50 UTC 37.69848 -122.09938 Castro Valley 4 []
695663 October 30, 2019 - 22:48:50 UTC 37.7074 -122.06092 Castro Valley 4 []
696268 October 31, 2019 - 04:55:12 UTC 37.68354 -122.07895 Castro Valley 4 []
696779 October 31, 2019 - 19:38:06 UTC 37.69212 -122.07258 Castro Valley 4 []
699431 November 04, 2019 - 21:44:53 UTC 37.7122 -122.12737 Castro Valley 4 []
700404 November 06, 2019 - 03:18:00 UTC 37.6969 -122.06895 Castro Valley 4 []
700948 November 06, 2019 - 19:51:29 UTC 37.68445 -122.07494 Castro Valley 4 []
701946 November 07, 2019 - 19:49:16 UTC 37.70205 -122.09149 Castro Valley 4 []
702139 November 07, 2019 - 23:19:09 UTC 37.70951 -122.10755 Castro Valley 4 []
702820 November 08, 2019 - 20:01:49 UTC 37.69053 -122.0696 Castro Valley 4 []
703006 November 08, 2019 - 23:35:23 UTC 37.68826 -122.07156 Castro Valley 4 []
703266 November 09, 2019 - 17:01:11 UTC 37.71603 -122.0927 Castro Valley 4 []
703736 November 10, 2019 - 03:17:48 UTC 37.71486 -122.07455 Castro Valley 4 []
704026 November 10, 2019 - 22:29:43 UTC 37.71037 -122.0673 Castro Valley 4 []
704034 November 10, 2019 - 22:39:11 UTC 37.69977 -122.10006 Castro Valley 4 []
705801 November 13, 2019 - 16:16:42 UTC 37.71519 -122.12848 Castro Valley 4 []
705964 November 13, 2019 - 17:20:36 UTC 37.68698 -122.01488 Castro Valley 4 []
706793 November 14, 2019 - 18:23:04 UTC 37.69564 -122.09633 Castro Valley 4 []
707637 November 15, 2019 - 18:59:00 UTC 37.70088 -122.04829 Castro Valley 4 []
707638 November 15, 2019 - 19:01:01 UTC 37.71252 -122.12589 Castro Valley 4 []
709653 November 19, 2019 - 02:16:10 UTC 37.69905 -122.06432 Castro Valley 4 []
709791 November 19, 2019 - 14:53:24 UTC 37.68747 -122.07748 Castro Valley 4 []
710326 November 19, 2019 - 22:35:02 UTC 37.69566 -122.07935 Castro Valley 4 []
712255 November 21, 2019 - 18:55:32 UTC 37.68956 -122.07974 Castro Valley 4 []
712824 November 22, 2019 - 17:18:52 UTC 37.72634 -122.0587 Castro Valley 4 []
712986 November 22, 2019 - 20:09:55 UTC 37.68248 -122.08058 Castro Valley 4 []
713582 November 23, 2019 - 23:34:23 UTC 37.71499 -122.07025 Castro Valley 4 []
713618 November 24, 2019 - 01:34:34 UTC 37.69864 -122.09469 Castro Valley 4 []
714731 November 25, 2019 - 23:18:06 UTC 37.7148 -122.08018 Castro Valley 4 []
714838 November 26, 2019 - 01:27:53 UTC 37.73358 -122.06002 Castro Valley 4 []

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