outages

328 rows where regionName = 4

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
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 []
699946 November 05, 2019 - 17:31:00 UTC 37.81272 -122.17404 Castro Valley 4 [{"latitude": "37.81648", "longitude": "-122.1759"}, {"latitude": "37.81998", "longitude": "-122.1799"}, {"latitude": "37.81676", "longitude": "-122.17989"}]
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 []
713405 November 23, 2019 - 17:05:00 UTC 37.80546 -122.17043 Castro Valley 4 [{"latitude": "37.80017", "longitude": "-122.14372"}, {"latitude": "37.80148", "longitude": "-122.14502"}, {"latitude": "37.80613", "longitude": "-122.16551"}, {"latitude": "37.80647", "longitude": "-122.16793"}]
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 []
715049 November 26, 2019 - 15:26:00 UTC 37.70599 -122.0918 Castro Valley 4 []
715260 November 26, 2019 - 19:50:20 UTC 37.70087 -122.05971 Castro Valley 4 []
715501 November 26, 2019 - 21:29:20 UTC 37.69371 -122.09001 Castro Valley 4 []
717550 November 27, 2019 - 02:49:33 UTC 37.71613 -122.09321 Castro Valley 4 []
717555 November 27, 2019 - 02:49:53 UTC 37.71603 -122.0927 Castro Valley 4 []
717569 November 27, 2019 - 02:51:46 UTC 37.69988 -122.10312 Castro Valley 4 []
717710 November 27, 2019 - 03:04:00 UTC 37.71499 -122.0471 Castro Valley 4 []
718058 November 27, 2019 - 03:42:20 UTC 37.69242 -122.06809 Castro Valley 4 []
718162 November 27, 2019 - 03:53:16 UTC 37.71704 -122.11927 Castro Valley 4 []
721403 November 27, 2019 - 19:40:29 UTC 37.7109 -122.09358 Castro Valley 4 []
723387 November 29, 2019 - 16:33:49 UTC 37.71672 -122.09275 Castro Valley 4 []
723537 November 29, 2019 - 19:02:15 UTC 37.70333 -122.05927 Castro Valley 4 [{"latitude": "37.70058", "longitude": "-122.05703"}, {"latitude": "37.70089", "longitude": "-122.05646"}, {"latitude": "37.70155", "longitude": "-122.05638"}, {"latitude": "37.70269", "longitude": "-122.0569"}, {"latitude": "37.70312", "longitude": "-122.05907"}, {"latitude": "37.70099", "longitude": "-122.06085"}]
723924 November 30, 2019 - 06:03:52 UTC 37.69619 -122.0259 Castro Valley 4 []
724032 November 30, 2019 - 15:41:33 UTC 37.70306 -122.10334 Castro Valley 4 []
724117 November 30, 2019 - 18:01:34 UTC 37.6978 -122.02778 Castro Valley 4 [{"latitude": "37.61485", "longitude": "-121.94225"}, {"latitude": "37.62591", "longitude": "-121.94326"}, {"latitude": "37.62917", "longitude": "-121.9453"}, {"latitude": "37.63037", "longitude": "-121.94653"}, {"latitude": "37.69802", "longitude": "-122.02075"}, {"latitude": "37.69787", "longitude": "-122.02164"}, {"latitude": "37.6965", "longitude": "-122.02627"}, {"latitude": "37.69041", "longitude": "-122.02358"}, {"latitude": "37.68261", "longitude": "-122.01942"}, {"latitude": "37.67686", "longitude": "-122.01554"}, {"latitude": "37.65091", "longitude": "-121.98857"}, {"latitude": "37.64042", "longitude": "-121.97669"}]
724174 November 30, 2019 - 19:12:05 UTC 37.69802 -122.02075 Castro Valley 4 []
724256 November 30, 2019 - 20:59:15 UTC 37.71411 -122.12368 Castro Valley 4 []
724647 December 01, 2019 - 00:41:40 UTC 37.71411 -122.12368 Castro Valley 4 []
724982 December 01, 2019 - 01:58:04 UTC 37.70087 -122.05971 Castro Valley 4 []
724989 December 01, 2019 - 02:03:15 UTC 37.71411 -122.12368 Castro Valley 4 []
725259 December 01, 2019 - 05:54:40 UTC 37.69995 -122.10116 Castro Valley 4 []
727110 December 02, 2019 - 15:36:20 UTC 37.69813 -122.08004 Castro Valley 4 []
727142 December 02, 2019 - 16:06:17 UTC 37.70084 -122.09543 Castro Valley 4 []
727862 December 03, 2019 - 00:05:45 UTC 37.69864 -122.09469 Castro Valley 4 []
727925 December 03, 2019 - 01:07:55 UTC 37.68595 -122.0659 Castro Valley 4 []
728060 December 03, 2019 - 05:53:24 UTC 37.68572 -122.08553 Castro Valley 4 []
728357 December 03, 2019 - 16:09:03 UTC 37.7147 -122.1288 Castro Valley 4 []
728608 December 03, 2019 - 18:10:43 UTC 37.71405 -122.09791 Castro Valley 4 []
728782 December 03, 2019 - 20:02:53 UTC 37.69772 -122.05876 Castro Valley 4 []
728794 December 03, 2019 - 20:17:22 UTC 37.7147 -122.1288 Castro Valley 4 []
728830 December 03, 2019 - 20:46:21 UTC 37.69053 -122.0696 Castro Valley 4 []
730004 December 05, 2019 - 00:07:49 UTC 37.69208 -122.07941 Castro Valley 4 []
731193 December 06, 2019 - 16:02:59 UTC 37.70155 -122.09323 Castro Valley 4 [{"latitude": "37.70162", "longitude": "-122.09234"}, {"latitude": "37.70167", "longitude": "-122.09065"}, {"latitude": "37.70367", "longitude": "-122.0899"}, {"latitude": "37.70403", "longitude": "-122.09148"}, {"latitude": "37.7036", "longitude": "-122.09291"}, {"latitude": "37.70255", "longitude": "-122.09404"}, {"latitude": "37.70234", "longitude": "-122.09368"}]
731238 December 06, 2019 - 16:18:57 UTC 37.70136 -122.09346 Castro Valley 4 []
731327 December 06, 2019 - 17:21:20 UTC 37.69648 -122.10086 Castro Valley 4 []
731344 December 06, 2019 - 17:25:35 UTC 37.69366 -122.02341 Castro Valley 4 []
731458 December 06, 2019 - 18:46:00 UTC 37.70162 -122.09234 Castro Valley 4 []
731488 December 06, 2019 - 19:22:37 UTC 37.70754 -122.07759 Castro Valley 4 []
734661 December 09, 2019 - 20:50:15 UTC 37.70605 -122.06047 Castro Valley 4 []
734962 December 10, 2019 - 01:54:45 UTC 37.70605 -122.06047 Castro Valley 4 []
735409 December 10, 2019 - 17:28:15 UTC 37.70605 -122.06047 Castro Valley 4 []
737937 December 13, 2019 - 02:52:15 UTC 37.70381 -122.06146 Castro Valley 4 []
739568 December 14, 2019 - 18:48:16 UTC 37.69539 -122.0886 Castro Valley 4 []
739939 December 15, 2019 - 07:26:10 UTC 37.7147 -122.1288 Castro Valley 4 []
740104 December 15, 2019 - 17:05:10 UTC 37.70324 -122.04613 Castro Valley 4 [{"latitude": "37.70327", "longitude": "-122.04604"}, {"latitude": "37.70394", "longitude": "-122.04512"}, {"latitude": "37.71807", "longitude": "-122.04243"}, {"latitude": "37.71892", "longitude": "-122.04584"}, {"latitude": "37.71553", "longitude": "-122.05073"}, {"latitude": "37.71474", "longitude": "-122.05123"}, {"latitude": "37.70515", "longitude": "-122.04721"}]
740111 December 15, 2019 - 17:11:23 UTC 37.70204 -122.07167 Castro Valley 4 []
740357 December 16, 2019 - 00:31:15 UTC 37.69539 -122.0886 Castro Valley 4 []
741514 December 16, 2019 - 17:03:06 UTC 37.64935 -121.97635 Castro Valley 4 []
741837 December 16, 2019 - 17:35:34 UTC 37.80613 -122.16551 Castro Valley 4 []
741893 December 16, 2019 - 17:44:28 UTC 37.70872 -122.06783 Castro Valley 4 []
743687 December 16, 2019 - 22:35:35 UTC 37.80613 -122.16551 Castro Valley 4 []
743793 December 17, 2019 - 00:01:15 UTC 37.69539 -122.0886 Castro Valley 4 []
744936 December 18, 2019 - 01:11:44 UTC 37.65091 -121.98857 Castro Valley 4 []
745039 December 18, 2019 - 04:16:32 UTC 37.70381 -122.06146 Castro Valley 4 []
778426 February 05, 2020 - 17:59:42 UTC 37.69695 -122.09557 Castro Valley 4 []
778616 February 05, 2020 - 21:16:47 UTC 37.64547 -121.97414 Castro Valley 4 []
778685 February 05, 2020 - 22:39:37 UTC 37.69913 -122.07421 Castro Valley 4 []
778695 February 05, 2020 - 22:48:00 UTC 37.6863 -122.08765 Castro Valley 4 []
778985 February 06, 2020 - 16:26:08 UTC 37.70432 -122.09407 Castro Valley 4 []
779190 February 06, 2020 - 17:27:36 UTC 37.71733 -122.00894 Castro Valley 4 []
779314 February 06, 2020 - 19:44:33 UTC 37.70177 -122.0772 Castro Valley 4 []
779333 February 06, 2020 - 20:01:00 UTC 37.70178 -122.07682 Castro Valley 4 []
779334 February 06, 2020 - 20:01:54 UTC 37.70176 -122.07773 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 29.319ms · About: About this site