outages

328 rows where regionName = 4 sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
782308 February 09, 2020 - 18:35:23 UTC 37.64734 -121.97259 Castro Valley 4 []
778616 February 05, 2020 - 21:16:47 UTC 37.64547 -121.97414 Castro Valley 4 []
741514 December 16, 2019 - 17:03:06 UTC 37.64935 -121.97635 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"}]
744936 December 18, 2019 - 01:11:44 UTC 37.65091 -121.98857 Castro Valley 4 []
655905 October 14, 2019 - 15:51:17 UTC 37.70332 -122.00118 Castro Valley 4 [{"latitude": "37.70618", "longitude": "-122.00339"}, {"latitude": "37.72646", "longitude": "-121.99548"}, {"latitude": "37.72623", "longitude": "-121.99861"}, {"latitude": "37.72576", "longitude": "-122.00112"}, {"latitude": "37.71872", "longitude": "-122.01031"}, {"latitude": "37.7084", "longitude": "-122.01875"}]
674803 October 20, 2019 - 17:08:25 UTC 37.71891 -122.00388 Castro Valley 4 []
653247 October 10, 2019 - 06:13:34 UTC 37.76819 -122.00754 Castro Valley 4 []
779190 February 06, 2020 - 17:27:36 UTC 37.71733 -122.00894 Castro Valley 4 []
653255 October 10, 2019 - 06:13:34 UTC 37.76692 -122.01091 Castro Valley 4 []
691573 October 27, 2019 - 03:17:43 UTC 37.70274 -122.01184 Castro Valley 4 [{"latitude": "37.70394", "longitude": "-122.02126"}, {"latitude": "37.70411", "longitude": "-122.01204"}, {"latitude": "37.70485", "longitude": "-122.00582"}, {"latitude": "37.70614", "longitude": "-122.01284"}, {"latitude": "37.70609", "longitude": "-122.01914"}]
705964 November 13, 2019 - 17:20:36 UTC 37.68698 -122.01488 Castro Valley 4 []
782312 February 09, 2020 - 18:35:47 UTC 37.67763 -122.01498 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"}]
782313 February 09, 2020 - 18:35:50 UTC 37.68641 -122.01936 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"}]
646992 October 08, 2019 - 02:28:57 UTC 37.6879 -122.01993 Castro Valley 4 []
782293 February 09, 2020 - 18:33:00 UTC 37.68862 -122.02045 Castro Valley 4 []
724174 November 30, 2019 - 19:12:05 UTC 37.69802 -122.02075 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"}]
731344 December 06, 2019 - 17:25:35 UTC 37.69366 -122.02341 Castro Valley 4 []
653262 October 10, 2019 - 06:13:34 UTC 37.76304 -122.02371 Castro Valley 4 []
664155 October 17, 2019 - 16:35:00 UTC 37.70757 -122.02385 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"}]
653268 October 10, 2019 - 06:13:34 UTC 37.76184 -122.02537 Castro Valley 4 [{"latitude": "37.73324", "longitude": "-122.03023"}, {"latitude": "37.73385", "longitude": "-122.0291"}, {"latitude": "37.7366", "longitude": "-122.02615"}, {"latitude": "37.73926", "longitude": "-122.02538"}, {"latitude": "37.76153", "longitude": "-122.02793"}, {"latitude": "37.76346", "longitude": "-122.02989"}, {"latitude": "37.76404", "longitude": "-122.03066"}, {"latitude": "37.76173", "longitude": "-122.03547"}, {"latitude": "37.74364", "longitude": "-122.03853"}, {"latitude": "37.73397", "longitude": "-122.03346"}]
723924 November 30, 2019 - 06:03:52 UTC 37.69619 -122.0259 Castro Valley 4 []
652918 October 10, 2019 - 06:14:33 UTC 37.69833 -122.02726 Castro Valley 4 [{"latitude": "37.69918", "longitude": "-122.02607"}, {"latitude": "37.70728", "longitude": "-122.02334"}, {"latitude": "37.70967", "longitude": "-122.02296"}, {"latitude": "37.70818", "longitude": "-122.02645"}, {"latitude": "37.70496", "longitude": "-122.02849"}, {"latitude": "37.70122", "longitude": "-122.0305"}]
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"}]
782320 February 09, 2020 - 18:30:00 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"}]
639313 October 03, 2019 - 17:20:19 UTC 37.70249 -122.02892 Castro Valley 4 []
781242 February 09, 2020 - 16:27:13 UTC 37.73385 -122.0291 Castro Valley 4 []
788272 February 11, 2020 - 14:30:06 UTC 37.73385 -122.0291 Castro Valley 4 []
653988 October 11, 2019 - 05:06:00 UTC 37.70873 -122.02921 Castro Valley 4 []
634236 October 01, 2019 - 19:17:04 UTC 37.74541 -122.03152 Castro Valley 4 []
786976 February 10, 2020 - 15:59:06 UTC 37.73397 -122.03346 Castro Valley 4 []
785868 February 10, 2020 - 01:18:04 UTC 37.74674 -122.034 Castro Valley 4 []
789390 February 12, 2020 - 17:17:43 UTC 37.71009 -122.03409 Castro Valley 4 []
780695 February 09, 2020 - 00:00:56 UTC 37.72711 -122.03598 Castro Valley 4 []
652907 October 10, 2019 - 06:13:00 UTC 37.71497 -122.03974 Castro Valley 4 [{"latitude": "37.71513", "longitude": "-122.03982"}, {"latitude": "37.72782", "longitude": "-122.03098"}, {"latitude": "37.73224", "longitude": "-122.03191"}, {"latitude": "37.73282", "longitude": "-122.0327"}, {"latitude": "37.73283", "longitude": "-122.03346"}, {"latitude": "37.73072", "longitude": "-122.03563"}, {"latitude": "37.73043", "longitude": "-122.03587"}, {"latitude": "37.72269", "longitude": "-122.0393"}]
782250 February 09, 2020 - 18:27:00 UTC 37.71497 -122.03974 Castro Valley 4 [{"latitude": "37.71513", "longitude": "-122.03982"}, {"latitude": "37.72782", "longitude": "-122.03098"}, {"latitude": "37.73224", "longitude": "-122.03191"}, {"latitude": "37.73282", "longitude": "-122.0327"}, {"latitude": "37.73283", "longitude": "-122.03346"}, {"latitude": "37.73072", "longitude": "-122.03563"}, {"latitude": "37.73043", "longitude": "-122.03587"}, {"latitude": "37.72269", "longitude": "-122.0393"}]
788589 February 11, 2020 - 18:29:20 UTC 37.71856 -122.04503 Castro Valley 4 []
789330 February 12, 2020 - 16:39:03 UTC 37.70409 -122.0451 Castro Valley 4 []
683964 October 27, 2019 - 03:49:54 UTC 37.70222 -122.04521 Castro Valley 4 [{"latitude": "37.70225", "longitude": "-122.04495"}, {"latitude": "37.70314", "longitude": "-122.04408"}, {"latitude": "37.71317", "longitude": "-122.035"}, {"latitude": "37.72782", "longitude": "-122.03098"}, {"latitude": "37.73224", "longitude": "-122.03191"}, {"latitude": "37.73282", "longitude": "-122.0327"}, {"latitude": "37.73283", "longitude": "-122.03346"}, {"latitude": "37.73072", "longitude": "-122.03563"}, {"latitude": "37.73043", "longitude": "-122.03587"}, {"latitude": "37.71762", "longitude": "-122.04412"}, {"latitude": "37.71553", "longitude": "-122.04517"}, {"latitude": "37.71433", "longitude": "-122.04574"}]
652212 October 10, 2019 - 06:13:00 UTC 37.70222 -122.04527 Castro Valley 4 [{"latitude": "37.70225", "longitude": "-122.04495"}, {"latitude": "37.70314", "longitude": "-122.04408"}, {"latitude": "37.71317", "longitude": "-122.035"}, {"latitude": "37.72782", "longitude": "-122.03098"}, {"latitude": "37.73224", "longitude": "-122.03191"}, {"latitude": "37.73282", "longitude": "-122.0327"}, {"latitude": "37.73283", "longitude": "-122.03346"}, {"latitude": "37.73072", "longitude": "-122.03563"}, {"latitude": "37.73043", "longitude": "-122.03587"}, {"latitude": "37.71762", "longitude": "-122.04412"}, {"latitude": "37.71553", "longitude": "-122.04517"}, {"latitude": "37.71433", "longitude": "-122.04574"}]
653897 October 11, 2019 - 03:18:00 UTC 37.70467 -122.04543 Castro Valley 4 []
652987 October 10, 2019 - 18:24:00 UTC 37.70156 -122.04593 Castro Valley 4 []
652199 October 10, 2019 - 06:10:00 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"}]
683932 October 27, 2019 - 03:48:02 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"}]
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"}]
692246 October 28, 2019 - 23:17:00 UTC 37.70838 -122.0462 Castro Valley 4 []
692733 October 29, 2019 - 03:23:00 UTC 37.70838 -122.0462 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"}]
717710 November 27, 2019 - 03:04:00 UTC 37.71499 -122.0471 Castro Valley 4 []
656873 October 14, 2019 - 17:37:50 UTC 37.7123 -122.04764 Castro Valley 4 []
687675 October 27, 2019 - 17:20:29 UTC 37.70088 -122.04829 Castro Valley 4 []
707637 November 15, 2019 - 18:59:00 UTC 37.70088 -122.04829 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"}]
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"}]
652170 October 10, 2019 - 06:01:00 UTC 37.70486 -122.05483 Castro Valley 4 [{"latitude": "37.70611", "longitude": "-122.05163"}, {"latitude": "37.71128", "longitude": "-122.04941"}, {"latitude": "37.71274", "longitude": "-122.04909"}, {"latitude": "37.71432", "longitude": "-122.04889"}, {"latitude": "37.78694", "longitude": "-122.05535"}, {"latitude": "37.78778", "longitude": "-122.05595"}, {"latitude": "37.7904", "longitude": "-122.06329"}, {"latitude": "37.7864", "longitude": "-122.06567"}, {"latitude": "37.77424", "longitude": "-122.07191"}, {"latitude": "37.70649", "longitude": "-122.05436"}]
684107 October 27, 2019 - 04:01:15 UTC 37.70486 -122.05483 Castro Valley 4 [{"latitude": "37.70611", "longitude": "-122.05163"}, {"latitude": "37.71128", "longitude": "-122.04941"}, {"latitude": "37.71274", "longitude": "-122.04909"}, {"latitude": "37.71432", "longitude": "-122.04889"}, {"latitude": "37.78694", "longitude": "-122.05535"}, {"latitude": "37.78778", "longitude": "-122.05595"}, {"latitude": "37.7904", "longitude": "-122.06329"}, {"latitude": "37.7864", "longitude": "-122.06567"}, {"latitude": "37.77424", "longitude": "-122.07191"}, {"latitude": "37.70649", "longitude": "-122.05436"}]
785525 February 10, 2020 - 00:10:55 UTC 37.7253 -122.05742 Castro Valley 4 []
712824 November 22, 2019 - 17:18:52 UTC 37.72634 -122.0587 Castro Valley 4 []
728782 December 03, 2019 - 20:02:53 UTC 37.69772 -122.05876 Castro Valley 4 []
782926 February 09, 2020 - 19:24:57 UTC 37.70671 -122.05915 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"}]
715260 November 26, 2019 - 19:50:20 UTC 37.70087 -122.05971 Castro Valley 4 []
724982 December 01, 2019 - 01:58:04 UTC 37.70087 -122.05971 Castro Valley 4 []
785482 February 10, 2020 - 00:05:00 UTC 37.72631 -122.05992 Castro Valley 4 []
714838 November 26, 2019 - 01:27:53 UTC 37.73358 -122.06002 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 []
695663 October 30, 2019 - 22:48:50 UTC 37.7074 -122.06092 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"}]
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"}]
690825 October 28, 2019 - 03:11:26 UTC 37.70788 -122.06134 Castro Valley 4 []
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"}]
737937 December 13, 2019 - 02:52:15 UTC 37.70381 -122.06146 Castro Valley 4 []
745039 December 18, 2019 - 04:16:32 UTC 37.70381 -122.06146 Castro Valley 4 []
788776 February 11, 2020 - 20:38:44 UTC 37.70382 -122.06163 Castro Valley 4 [{"latitude": "37.70329", "longitude": "-122.06194"}, {"latitude": "37.70453", "longitude": "-122.06196"}, {"latitude": "37.70475", "longitude": "-122.06381"}, {"latitude": "37.70475", "longitude": "-122.06486"}, {"latitude": "37.70425", "longitude": "-122.06605"}, {"latitude": "37.70346", "longitude": "-122.06373"}]
787296 February 10, 2020 - 18:16:58 UTC 37.70395 -122.0628 Castro Valley 4 []
691564 October 28, 2019 - 16:54:01 UTC 37.70892 -122.06376 Castro Valley 4 []
709653 November 19, 2019 - 02:16:10 UTC 37.69905 -122.06432 Castro Valley 4 []
787412 February 10, 2020 - 19:28:30 UTC 37.7028 -122.0645 Castro Valley 4 []
783735 February 09, 2020 - 20:20:10 UTC 37.7012 -122.06463 Castro Valley 4 []
680000 October 25, 2019 - 00:47:46 UTC 37.69732 -122.06489 Castro Valley 4 []
785637 February 10, 2020 - 00:32:00 UTC 37.6961 -122.06519 Castro Valley 4 []
727925 December 03, 2019 - 01:07:55 UTC 37.68595 -122.0659 Castro Valley 4 []
787882 February 11, 2020 - 00:30:07 UTC 37.70425 -122.06605 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 []
704026 November 10, 2019 - 22:29:43 UTC 37.71037 -122.0673 Castro Valley 4 []
786000 February 10, 2020 - 02:14:00 UTC 37.70022 -122.0675 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 400.035ms · About: About this site