outages

328 rows where regionName = 4 sorted by regionName

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 []
633862 October 01, 2019 - 16:35:00 UTC 37.80511 -122.17103 Castro Valley 4 [{"latitude": "37.8104", "longitude": "-122.17206"}, {"latitude": "37.81648", "longitude": "-122.1759"}, {"latitude": "37.81998", "longitude": "-122.1799"}, {"latitude": "37.81676", "longitude": "-122.17989"}]
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 []
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"}]
652180 October 10, 2019 - 06:03:21 UTC 37.70989 -122.07386 Castro Valley 4 [{"latitude": "37.70996", "longitude": "-122.07386"}, {"latitude": "37.72045", "longitude": "-122.06171"}, {"latitude": "37.72494", "longitude": "-122.05859"}, {"latitude": "37.73289", "longitude": "-122.05723"}, {"latitude": "37.73421", "longitude": "-122.05825"}, {"latitude": "37.76858", "longitude": "-122.09593"}, {"latitude": "37.71919", "longitude": "-122.09319"}, {"latitude": "37.71088", "longitude": "-122.08576"}]
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"}]
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"}]
652223 October 10, 2019 - 06:14:33 UTC 37.69607 -122.05 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"}]
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"}]
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"}]
652527 October 10, 2019 - 07:43:51 UTC 37.69707 -122.08382 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"}]
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"}]
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"}]
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"}]
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"}]
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"}]
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"}]
652934 October 10, 2019 - 06:14:33 UTC 37.65321 -121.98575 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"}]
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 []
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"}]
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 []
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"}]
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 []
671154 October 19, 2019 - 15:00:00 UTC 37.71214 -122.12114 Castro Valley 4 [{"latitude": "37.71286", "longitude": "-122.12034"}, {"latitude": "37.71489", "longitude": "-122.11605"}, {"latitude": "37.72256", "longitude": "-122.11789"}, {"latitude": "37.72361", "longitude": "-122.11821"}, {"latitude": "37.72226", "longitude": "-122.1202"}, {"latitude": "37.71383", "longitude": "-122.12133"}]
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 []
683402 October 27, 2019 - 03:19:25 UTC 37.70313 -122.1035 Castro Valley 4 [{"latitude": "37.70112", "longitude": "-122.10206"}, {"latitude": "37.70149", "longitude": "-122.09994"}, {"latitude": "37.70464", "longitude": "-122.1002"}, {"latitude": "37.70949", "longitude": "-122.10164"}, {"latitude": "37.71108", "longitude": "-122.10276"}, {"latitude": "37.71083", "longitude": "-122.10998"}, {"latitude": "37.70997", "longitude": "-122.10986"}, {"latitude": "37.70839", "longitude": "-122.10962"}, {"latitude": "37.70337", "longitude": "-122.10561"}]
683565 October 27, 2019 - 03:29:19 UTC 37.70143 -122.08835 Castro Valley 4 [{"latitude": "37.70207", "longitude": "-122.08859"}, {"latitude": "37.70273", "longitude": "-122.08641"}, {"latitude": "37.71033", "longitude": "-122.08519"}, {"latitude": "37.71685", "longitude": "-122.08447"}, {"latitude": "37.7193", "longitude": "-122.08907"}, {"latitude": "37.71937", "longitude": "-122.08924"}, {"latitude": "37.71936", "longitude": "-122.09173"}, {"latitude": "37.71896", "longitude": "-122.09704"}, {"latitude": "37.71694", "longitude": "-122.10403"}, {"latitude": "37.70509", "longitude": "-122.09504"}, {"latitude": "37.70432", "longitude": "-122.09407"}]
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"}]
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"}]
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"}]
684081 October 27, 2019 - 03:58:48 UTC 37.71085 -122.12355 Castro Valley 4 [{"latitude": "37.71089", "longitude": "-122.12379"}, {"latitude": "37.71353", "longitude": "-122.12375"}, {"latitude": "37.71463", "longitude": "-122.12772"}, {"latitude": "37.7147", "longitude": "-122.1288"}, {"latitude": "37.7145", "longitude": "-122.12962"}, {"latitude": "37.71395", "longitude": "-122.12938"}, {"latitude": "37.71286", "longitude": "-122.12858"}, {"latitude": "37.7122", "longitude": "-122.12737"}, {"latitude": "37.7109", "longitude": "-122.12487"}]
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"}]
684128 October 27, 2019 - 04:03:44 UTC 37.70989 -122.07386 Castro Valley 4 [{"latitude": "37.70996", "longitude": "-122.07386"}, {"latitude": "37.72045", "longitude": "-122.06171"}, {"latitude": "37.72494", "longitude": "-122.05859"}, {"latitude": "37.73289", "longitude": "-122.05723"}, {"latitude": "37.73421", "longitude": "-122.05825"}, {"latitude": "37.76858", "longitude": "-122.09593"}, {"latitude": "37.71919", "longitude": "-122.09319"}, {"latitude": "37.71088", "longitude": "-122.08576"}]
684175 October 27, 2019 - 04:08:00 UTC 37.70321 -122.09722 Castro Valley 4 [{"latitude": "37.70304", "longitude": "-122.10013"}, {"latitude": "37.70364", "longitude": "-122.09511"}, {"latitude": "37.70463", "longitude": "-122.09455"}, {"latitude": "37.70943", "longitude": "-122.09341"}, {"latitude": "37.70975", "longitude": "-122.09388"}, {"latitude": "37.71247", "longitude": "-122.09889"}, {"latitude": "37.71219", "longitude": "-122.10023"}, {"latitude": "37.70736", "longitude": "-122.10193"}]
684523 October 27, 2019 - 04:46:00 UTC 37.70248 -122.11032 Castro Valley 4 [{"latitude": "37.70261", "longitude": "-122.11024"}, {"latitude": "37.70421", "longitude": "-122.10838"}, {"latitude": "37.70497", "longitude": "-122.1076"}, {"latitude": "37.70534", "longitude": "-122.1074"}, {"latitude": "37.70792", "longitude": "-122.10932"}, {"latitude": "37.70848", "longitude": "-122.11185"}, {"latitude": "37.70859", "longitude": "-122.1124"}, {"latitude": "37.70622", "longitude": "-122.11636"}, {"latitude": "37.70576", "longitude": "-122.11585"}]
684737 October 27, 2019 - 04:17:00 UTC 37.71748 -122.12094 Castro Valley 4 [{"latitude": "37.71857", "longitude": "-122.12031"}, {"latitude": "37.72256", "longitude": "-122.11789"}, {"latitude": "37.72361", "longitude": "-122.11821"}, {"latitude": "37.72226", "longitude": "-122.1202"}]
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"}]
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"}]
686281 October 27, 2019 - 07:31:00 UTC 37.80513 -122.17108 Castro Valley 4 [{"latitude": "37.8104", "longitude": "-122.17206"}, {"latitude": "37.81648", "longitude": "-122.1759"}, {"latitude": "37.81998", "longitude": "-122.1799"}, {"latitude": "37.81676", "longitude": "-122.17989"}]
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 []
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"}]
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 []
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"}]
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 []

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