outages

328 rows where regionName = 4 sorted by latitude

View and edit SQL

id outageStartTime latitude ▼ longitude regionName outageDevices
778616 February 05, 2020 - 21:16:47 UTC 37.64547 -121.97414 Castro Valley 4 []
782308 February 09, 2020 - 18:35:23 UTC 37.64734 -121.97259 Castro Valley 4 []
741514 December 16, 2019 - 17:03:06 UTC 37.64935 -121.97635 Castro Valley 4 []
744936 December 18, 2019 - 01:11:44 UTC 37.65091 -121.98857 Castro Valley 4 []
652942 October 10, 2019 - 06:14:33 UTC 37.65167 -121.98182 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.63401", "longitude": "-121.9506"}, {"latitude": "37.649", "longitude": "-121.97363"}, {"latitude": "37.6497", "longitude": "-121.97726"}, {"latitude": "37.64042", "longitude": "-121.97669"}]
652934 October 10, 2019 - 06:14:33 UTC 37.65321 -121.98575 Castro Valley 4 []
652931 October 10, 2019 - 06:14:33 UTC 37.65512 -121.98747 Castro Valley 4 [{"latitude": "37.65481", "longitude": "-121.98778"}, {"latitude": "37.65801", "longitude": "-121.99293"}, {"latitude": "37.6565", "longitude": "-121.99297"}]
782312 February 09, 2020 - 18:35:47 UTC 37.67763 -122.01498 Castro Valley 4 []
689491 October 27, 2019 - 21:35:17 UTC 37.68129 -122.07736 Castro Valley 4 []
693309 October 29, 2019 - 15:49:27 UTC 37.68129 -122.07736 Castro Valley 4 []
712986 November 22, 2019 - 20:09:55 UTC 37.68248 -122.08058 Castro Valley 4 []
783352 February 09, 2020 - 19:49:00 UTC 37.68327 -122.07667 Castro Valley 4 [{"latitude": "37.67999", "longitude": "-122.07995"}, {"latitude": "37.6804", "longitude": "-122.07663"}, {"latitude": "37.68052", "longitude": "-122.07614"}, {"latitude": "37.68283", "longitude": "-122.07501"}, {"latitude": "37.68259", "longitude": "-122.07705"}, {"latitude": "37.68224", "longitude": "-122.07825"}, {"latitude": "37.68081", "longitude": "-122.07977"}]
786485 February 10, 2020 - 04:57:47 UTC 37.68327 -122.07667 Castro Valley 4 [{"latitude": "37.68052", "longitude": "-122.07614"}, {"latitude": "37.68283", "longitude": "-122.07501"}, {"latitude": "37.68259", "longitude": "-122.07705"}]
696268 October 31, 2019 - 04:55:12 UTC 37.68354 -122.07895 Castro Valley 4 []
780951 February 09, 2020 - 14:24:00 UTC 37.68389 -122.0733 Castro Valley 4 [{"latitude": "37.68201", "longitude": "-122.07239"}, {"latitude": "37.68277", "longitude": "-122.07272"}, {"latitude": "37.68342", "longitude": "-122.07307"}, {"latitude": "37.68336", "longitude": "-122.0739"}]
789913 February 13, 2020 - 02:21:00 UTC 37.68429 -122.07848 Castro Valley 4 []
700948 November 06, 2019 - 19:51:29 UTC 37.68445 -122.07494 Castro Valley 4 []
789901 February 13, 2020 - 02:11:00 UTC 37.68459 -122.07999 Castro Valley 4 [{"latitude": "37.68539", "longitude": "-122.07995"}, {"latitude": "37.68942", "longitude": "-122.07442"}, {"latitude": "37.69005", "longitude": "-122.07765"}, {"latitude": "37.69023", "longitude": "-122.08272"}, {"latitude": "37.69021", "longitude": "-122.0836"}, {"latitude": "37.68998", "longitude": "-122.08436"}, {"latitude": "37.6889", "longitude": "-122.08431"}, {"latitude": "37.68815", "longitude": "-122.08427"}]
785276 February 09, 2020 - 23:30:48 UTC 37.68486 -122.07378 Castro Valley 4 []
652926 October 10, 2019 - 06:14:33 UTC 37.68572 -122.01899 Castro Valley 4 [{"latitude": "37.68588", "longitude": "-122.01773"}, {"latitude": "37.68641", "longitude": "-122.01241"}, {"latitude": "37.68722", "longitude": "-122.01164"}, {"latitude": "37.68698", "longitude": "-122.01488"}]
728060 December 03, 2019 - 05:53:24 UTC 37.68572 -122.08553 Castro Valley 4 []
727925 December 03, 2019 - 01:07:55 UTC 37.68595 -122.0659 Castro Valley 4 []
778695 February 05, 2020 - 22:48:00 UTC 37.6863 -122.08765 Castro Valley 4 []
782313 February 09, 2020 - 18:35:50 UTC 37.68641 -122.01936 Castro Valley 4 []
789920 February 13, 2020 - 02:43:00 UTC 37.68646 -122.08107 Castro Valley 4 []
782389 February 09, 2020 - 18:43:20 UTC 37.68682 -122.07844 Castro Valley 4 []
705964 November 13, 2019 - 17:20:36 UTC 37.68698 -122.01488 Castro Valley 4 []
709791 November 19, 2019 - 14:53:24 UTC 37.68747 -122.07748 Castro Valley 4 []
781323 February 09, 2020 - 16:49:46 UTC 37.68747 -122.07748 Castro Valley 4 []
789563 February 12, 2020 - 19:49:01 UTC 37.68747 -122.07748 Castro Valley 4 []
646992 October 08, 2019 - 02:28:57 UTC 37.6879 -122.01993 Castro Valley 4 []
789915 February 13, 2020 - 02:22:00 UTC 37.68804 -122.08256 Castro Valley 4 []
687617 October 27, 2019 - 17:06:45 UTC 37.6881 -122.078 Castro Valley 4 []
703006 November 08, 2019 - 23:35:23 UTC 37.68826 -122.07156 Castro Valley 4 []
787668 February 10, 2020 - 21:57:53 UTC 37.68839 -122.08595 Castro Valley 4 []
782293 February 09, 2020 - 18:33:00 UTC 37.68862 -122.02045 Castro Valley 4 []
652923 October 10, 2019 - 06:14:33 UTC 37.68863 -122.01983 Castro Valley 4 [{"latitude": "37.69004", "longitude": "-122.01913"}, {"latitude": "37.69335", "longitude": "-122.01942"}, {"latitude": "37.69151", "longitude": "-122.01988"}]
712255 November 21, 2019 - 18:55:32 UTC 37.68956 -122.07974 Castro Valley 4 []
702820 November 08, 2019 - 20:01:49 UTC 37.69053 -122.0696 Castro Valley 4 []
728830 December 03, 2019 - 20:46:21 UTC 37.69053 -122.0696 Castro Valley 4 []
652920 October 10, 2019 - 06:14:33 UTC 37.69115 -122.02203 Castro Valley 4 [{"latitude": "37.69041", "longitude": "-122.02358"}, {"latitude": "37.69077", "longitude": "-122.02275"}, {"latitude": "37.69093", "longitude": "-122.02243"}]
781382 February 09, 2020 - 16:59:59 UTC 37.6916 -122.07705 Castro Valley 4 []
787353 February 09, 2020 - 18:30:51 UTC 37.6916 -122.07705 Castro Valley 4 []
787745 February 10, 2020 - 22:48:21 UTC 37.6916 -122.07705 Castro Valley 4 []
789884 February 13, 2020 - 01:40:44 UTC 37.69163 -122.08398 Castro Valley 4 []
652356 October 10, 2019 - 06:36:46 UTC 37.6917 -122.061 Castro Valley 4 [{"latitude": "37.66565", "longitude": "-122.04052"}, {"latitude": "37.66636", "longitude": "-122.03749"}, {"latitude": "37.67561", "longitude": "-122.02983"}, {"latitude": "37.69249", "longitude": "-122.03208"}, {"latitude": "37.69639", "longitude": "-122.04459"}, {"latitude": "37.69139", "longitude": "-122.04551"}]
690713 October 28, 2019 - 02:08:00 UTC 37.6917 -122.06132 Castro Valley 4 [{"latitude": "37.66289", "longitude": "-122.08619"}, {"latitude": "37.66518", "longitude": "-122.08012"}, {"latitude": "37.66563", "longitude": "-122.07947"}, {"latitude": "37.67684", "longitude": "-122.07087"}, {"latitude": "37.68896", "longitude": "-122.06291"}, {"latitude": "37.68967", "longitude": "-122.0631"}, {"latitude": "37.69746", "longitude": "-122.06777"}, {"latitude": "37.69793", "longitude": "-122.06895"}, {"latitude": "37.68301", "longitude": "-122.09023"}, {"latitude": "37.67171", "longitude": "-122.0958"}, {"latitude": "37.66473", "longitude": "-122.09283"}]
780773 February 09, 2020 - 03:19:00 UTC 37.6917 -122.06136 Castro Valley 4 [{"latitude": "37.67897", "longitude": "-122.06974"}, {"latitude": "37.67915", "longitude": "-122.06504"}, {"latitude": "37.67944", "longitude": "-122.06412"}, {"latitude": "37.68113", "longitude": "-122.06152"}, {"latitude": "37.68884", "longitude": "-122.06171"}, {"latitude": "37.6888", "longitude": "-122.06251"}, {"latitude": "37.68326", "longitude": "-122.0701"}, {"latitude": "37.67941", "longitude": "-122.07287"}]
780955 February 09, 2020 - 14:24:00 UTC 37.6917 -122.06132 Castro Valley 4 [{"latitude": "37.66289", "longitude": "-122.08619"}, {"latitude": "37.66518", "longitude": "-122.08012"}, {"latitude": "37.66563", "longitude": "-122.07947"}, {"latitude": "37.67684", "longitude": "-122.07087"}, {"latitude": "37.68896", "longitude": "-122.06291"}, {"latitude": "37.68967", "longitude": "-122.0631"}, {"latitude": "37.69746", "longitude": "-122.06777"}, {"latitude": "37.69793", "longitude": "-122.06895"}, {"latitude": "37.67526", "longitude": "-122.10479"}, {"latitude": "37.66953", "longitude": "-122.10116"}, {"latitude": "37.66836", "longitude": "-122.09957"}, {"latitude": "37.66473", "longitude": "-122.09283"}]
781425 February 09, 2020 - 17:04:20 UTC 37.69199 -122.07706 Castro Valley 4 []
788151 February 11, 2020 - 04:15:18 UTC 37.69199 -122.07706 Castro Valley 4 []
730004 December 05, 2019 - 00:07:49 UTC 37.69208 -122.07941 Castro Valley 4 []
696779 October 31, 2019 - 19:38:06 UTC 37.69212 -122.07258 Castro Valley 4 []
680682 October 26, 2019 - 02:18:30 UTC 37.69242 -122.06809 Castro Valley 4 []
718058 November 27, 2019 - 03:42:20 UTC 37.69242 -122.06809 Castro Valley 4 []
787398 February 10, 2020 - 19:15:33 UTC 37.69242 -122.0807 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 []
790031 February 13, 2020 - 06:14:06 UTC 37.69316 -122.09904 Castro Valley 4 []
788074 February 11, 2020 - 02:47:08 UTC 37.6932 -122.08337 Castro Valley 4 []
731344 December 06, 2019 - 17:25:35 UTC 37.69366 -122.02341 Castro Valley 4 []
715501 November 26, 2019 - 21:29:20 UTC 37.69371 -122.09001 Castro Valley 4 []
689245 October 27, 2019 - 21:02:36 UTC 37.69389 -122.09929 Castro Valley 4 []
782826 February 09, 2020 - 19:16:01 UTC 37.69407 -122.08117 Castro Valley 4 []
677497 October 23, 2019 - 16:46:18 UTC 37.69428 -122.07425 Castro Valley 4 []
787419 February 10, 2020 - 19:31:39 UTC 37.69478 -122.07712 Castro Valley 4 []
677474 October 23, 2019 - 16:27:51 UTC 37.69509 -122.09042 Castro Valley 4 []
652275 October 10, 2019 - 06:14:33 UTC 37.69527 -122.02404 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.63401", "longitude": "-121.9506"}, {"latitude": "37.68722", "longitude": "-122.01164"}, {"latitude": "37.69335", "longitude": "-122.01942"}, {"latitude": "37.69418", "longitude": "-122.02369"}, {"latitude": "37.69328", "longitude": "-122.02413"}, {"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"}]
684829 October 27, 2019 - 03:52:53 UTC 37.69527 -122.02404 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.63401", "longitude": "-121.9506"}, {"latitude": "37.68722", "longitude": "-122.01164"}, {"latitude": "37.69335", "longitude": "-122.01942"}, {"latitude": "37.69418", "longitude": "-122.02369"}, {"latitude": "37.69328", "longitude": "-122.02413"}, {"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"}]
739568 December 14, 2019 - 18:48:16 UTC 37.69539 -122.0886 Castro Valley 4 []
740357 December 16, 2019 - 00:31:15 UTC 37.69539 -122.0886 Castro Valley 4 []
743793 December 17, 2019 - 00:01:15 UTC 37.69539 -122.0886 Castro Valley 4 []
706793 November 14, 2019 - 18:23:04 UTC 37.69564 -122.09633 Castro Valley 4 []
710326 November 19, 2019 - 22:35:02 UTC 37.69566 -122.07935 Castro Valley 4 []
783513 February 09, 2020 - 20:00:56 UTC 37.69572 -122.06606 Castro Valley 4 []
785954 February 10, 2020 - 02:00:54 UTC 37.69572 -122.06606 Castro Valley 4 []
787684 February 10, 2020 - 22:04:15 UTC 37.69572 -122.06606 Castro Valley 4 []
785554 February 10, 2020 - 00:14:00 UTC 37.69595 -122.10383 Castro Valley 4 []
690894 October 28, 2019 - 03:57:57 UTC 37.69598 -122.06772 Castro Valley 4 []
687860 October 27, 2019 - 17:56:27 UTC 37.696 -122.08973 Castro Valley 4 []
652223 October 10, 2019 - 06:14:33 UTC 37.69607 -122.05 Castro Valley 4 []
684007 October 27, 2019 - 03:52:53 UTC 37.69607 -122.05 Castro Valley 4 [{"latitude": "37.61485", "longitude": "-121.94225"}, {"latitude": "37.62591", "longitude": "-121.94326"}, {"latitude": "37.62917", "longitude": "-121.9453"}, {"latitude": "37.71968", "longitude": "-122.02047"}, {"latitude": "37.72098", "longitude": "-122.02402"}, {"latitude": "37.72215", "longitude": "-122.02889"}, {"latitude": "37.72204", "longitude": "-122.02938"}, {"latitude": "37.71712", "longitude": "-122.03467"}, {"latitude": "37.71567", "longitude": "-122.03607"}, {"latitude": "37.71514", "longitude": "-122.03655"}, {"latitude": "37.69705", "longitude": "-122.05051"}, {"latitude": "37.69469", "longitude": "-122.04888"}, {"latitude": "37.64042", "longitude": "-121.97669"}]
689428 October 27, 2019 - 21:23:42 UTC 37.6961 -122.0981 Castro Valley 4 []
785637 February 10, 2020 - 00:32:00 UTC 37.6961 -122.06519 Castro Valley 4 []
723924 November 30, 2019 - 06:03:52 UTC 37.69619 -122.0259 Castro Valley 4 []
784695 February 09, 2020 - 21:51:33 UTC 37.69644 -122.1034 Castro Valley 4 []
787516 February 10, 2020 - 20:21:02 UTC 37.69644 -122.1034 Castro Valley 4 []
731327 December 06, 2019 - 17:21:20 UTC 37.69648 -122.10086 Castro Valley 4 []
788939 February 11, 2020 - 23:00:37 UTC 37.69659 -122.08087 Castro Valley 4 []
652909 October 10, 2019 - 06:14:33 UTC 37.6966 -122.0486 Castro Valley 4 [{"latitude": "37.69416", "longitude": "-122.0446"}, {"latitude": "37.69491", "longitude": "-122.04223"}, {"latitude": "37.69728", "longitude": "-122.04145"}, {"latitude": "37.69752", "longitude": "-122.04384"}, {"latitude": "37.69751", "longitude": "-122.0445"}, {"latitude": "37.69745", "longitude": "-122.04504"}, {"latitude": "37.69559", "longitude": "-122.04597"}]
700404 November 06, 2019 - 03:18:00 UTC 37.6969 -122.06895 Castro Valley 4 []
778426 February 05, 2020 - 17:59:42 UTC 37.69695 -122.09557 Castro Valley 4 []
652527 October 10, 2019 - 07:43:51 UTC 37.69707 -122.08382 Castro Valley 4 []
786502 February 10, 2020 - 04:51:00 UTC 37.6971 -122.07382 Castro Valley 4 [{"latitude": "37.69557", "longitude": "-122.07086"}, {"latitude": "37.69682", "longitude": "-122.0703"}, {"latitude": "37.69811", "longitude": "-122.07025"}, {"latitude": "37.70361", "longitude": "-122.07029"}, {"latitude": "37.70458", "longitude": "-122.07099"}, {"latitude": "37.70641", "longitude": "-122.07391"}, {"latitude": "37.70303", "longitude": "-122.07781"}, {"latitude": "37.70175", "longitude": "-122.07824"}, {"latitude": "37.70019", "longitude": "-122.07774"}, {"latitude": "37.69721", "longitude": "-122.07382"}]
633481 October 01, 2019 - 05:08:00 UTC 37.69717 -122.08699 Castro Valley 4 []
652241 October 10, 2019 - 06:14:33 UTC 37.6973 -122.04688 Castro Valley 4 [{"latitude": "37.61485", "longitude": "-121.94225"}, {"latitude": "37.62591", "longitude": "-121.94326"}, {"latitude": "37.62917", "longitude": "-121.9453"}, {"latitude": "37.71968", "longitude": "-122.02047"}, {"latitude": "37.72098", "longitude": "-122.02402"}, {"latitude": "37.72215", "longitude": "-122.02889"}, {"latitude": "37.72204", "longitude": "-122.02938"}, {"latitude": "37.71712", "longitude": "-122.03467"}, {"latitude": "37.71567", "longitude": "-122.03607"}, {"latitude": "37.71514", "longitude": "-122.03655"}, {"latitude": "37.69758", "longitude": "-122.04618"}, {"latitude": "37.64042", "longitude": "-121.97669"}]
684796 October 27, 2019 - 03:52:53 UTC 37.6973 -122.04688 Castro Valley 4 [{"latitude": "37.69483", "longitude": "-122.02534"}, {"latitude": "37.69594", "longitude": "-122.0223"}, {"latitude": "37.69649", "longitude": "-122.02177"}, {"latitude": "37.69685", "longitude": "-122.02145"}, {"latitude": "37.69802", "longitude": "-122.02075"}, {"latitude": "37.71222", "longitude": "-122.01687"}, {"latitude": "37.71367", "longitude": "-122.01658"}, {"latitude": "37.71968", "longitude": "-122.02047"}, {"latitude": "37.72098", "longitude": "-122.02402"}, {"latitude": "37.72215", "longitude": "-122.02889"}, {"latitude": "37.72204", "longitude": "-122.02938"}, {"latitude": "37.71712", "longitude": "-122.03467"}, {"latitude": "37.71567", "longitude": "-122.03607"}, {"latitude": "37.71514", "longitude": "-122.03655"}, {"latitude": "37.69758", "longitude": "-122.04618"}]
680000 October 25, 2019 - 00:47:46 UTC 37.69732 -122.06489 Castro Valley 4 []
781739 February 09, 2020 - 17:37:52 UTC 37.69768 -122.08335 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 2145.01ms · About: About this site