outages

260 rows where regionName = 81

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
633619 October 01, 2019 - 15:30:00 UTC 38.81335 -122.99919 Cloverdale 81 []
635769 October 02, 2019 - 15:30:00 UTC 38.85216 -123.07676 Cloverdale 81 []
641495 October 03, 2019 - 22:21:23 UTC 38.80343 -123.01787 Cloverdale 81 []
647011 October 08, 2019 - 03:41:49 UTC 38.80102 -122.99083 Cloverdale 81 []
647015 October 08, 2019 - 04:09:03 UTC 38.80102 -122.99083 Cloverdale 81 []
647646 October 09, 2019 - 00:03:00 UTC 38.79722 -123.01068 Cloverdale 81 [{"latitude": "38.75047", "longitude": "-122.9092"}, {"latitude": "38.75786", "longitude": "-122.89593"}, {"latitude": "38.77878", "longitude": "-122.89287"}, {"latitude": "38.87712", "longitude": "-122.88475"}, {"latitude": "38.89282", "longitude": "-122.99011"}, {"latitude": "38.89937", "longitude": "-123.04825"}, {"latitude": "38.88446", "longitude": "-123.12255"}, {"latitude": "38.81723", "longitude": "-123.16563"}, {"latitude": "38.80201", "longitude": "-123.17479"}, {"latitude": "38.79943", "longitude": "-123.17229"}, {"latitude": "38.79607", "longitude": "-123.16846"}, {"latitude": "38.79431", "longitude": "-123.16444"}, {"latitude": "38.78645", "longitude": "-123.13357"}, {"latitude": "38.76775", "longitude": "-123.05444"}, {"latitude": "38.76269", "longitude": "-123.02144"}, {"latitude": "38.75514", "longitude": "-122.95608"}]
647656 October 09, 2019 - 00:13:00 UTC 38.813 -123.02815 Cloverdale 81 []
647657 October 09, 2019 - 00:13:00 UTC 38.80759 -123.02835 Cloverdale 81 []
647658 October 09, 2019 - 00:13:00 UTC 38.80952 -123.02673 Cloverdale 81 []
647659 October 09, 2019 - 00:14:00 UTC 38.80111 -123.02154 Cloverdale 81 []
647660 October 09, 2019 - 00:15:00 UTC 38.81038 -123.01518 Cloverdale 81 []
649863 October 09, 2019 - 10:50:26 UTC 38.78316 -123.01575 Cloverdale 81 []
649869 October 09, 2019 - 10:51:47 UTC 38.795 -123.01453 Cloverdale 81 []
649870 October 09, 2019 - 10:51:47 UTC 38.7944 -123.01524 Cloverdale 81 []
649871 October 09, 2019 - 10:51:47 UTC 38.79326 -123.01709 Cloverdale 81 []
649872 October 09, 2019 - 10:51:47 UTC 38.79371 -123.01564 Cloverdale 81 []
649873 October 09, 2019 - 10:51:47 UTC 38.79256 -123.01607 Cloverdale 81 []
649874 October 09, 2019 - 10:51:47 UTC 38.77249 -123.00038 Cloverdale 81 []
649875 October 09, 2019 - 10:51:47 UTC 38.77148 -122.99573 Cloverdale 81 []
649876 October 09, 2019 - 10:51:47 UTC 38.77131 -122.99849 Cloverdale 81 []
649877 October 09, 2019 - 10:51:47 UTC 38.78108 -123.01258 Cloverdale 81 []
649878 October 09, 2019 - 10:51:47 UTC 38.78835 -123.02529 Cloverdale 81 []
649879 October 09, 2019 - 10:51:47 UTC 38.77895 -123.01454 Cloverdale 81 []
649880 October 09, 2019 - 10:51:47 UTC 38.78675 -123.02111 Cloverdale 81 []
649881 October 09, 2019 - 10:51:47 UTC 38.79073 -123.01758 Cloverdale 81 [{"latitude": "38.78831", "longitude": "-123.0246"}, {"latitude": "38.78848", "longitude": "-123.02016"}, {"latitude": "38.78886", "longitude": "-123.01869"}, {"latitude": "38.78969", "longitude": "-123.0176"}, {"latitude": "38.79073", "longitude": "-123.01849"}, {"latitude": "38.79108", "longitude": "-123.02643"}, {"latitude": "38.79018", "longitude": "-123.02902"}, {"latitude": "38.78846", "longitude": "-123.02819"}]
649882 October 09, 2019 - 10:51:47 UTC 38.79166 -123.01797 Cloverdale 81 [{"latitude": "38.79078", "longitude": "-123.02245"}, {"latitude": "38.79169", "longitude": "-123.01916"}, {"latitude": "38.79214", "longitude": "-123.02099"}, {"latitude": "38.79192", "longitude": "-123.02237"}, {"latitude": "38.79166", "longitude": "-123.02387"}]
649883 October 09, 2019 - 10:51:47 UTC 38.7985 -123.0194 Cloverdale 81 [{"latitude": "38.7976", "longitude": "-123.02566"}, {"latitude": "38.79778", "longitude": "-123.02414"}, {"latitude": "38.79862", "longitude": "-123.01943"}, {"latitude": "38.79953", "longitude": "-123.01887"}, {"latitude": "38.80075", "longitude": "-123.01861"}, {"latitude": "38.8006", "longitude": "-123.02161"}, {"latitude": "38.79989", "longitude": "-123.02608"}, {"latitude": "38.79854", "longitude": "-123.0273"}]
649884 October 09, 2019 - 10:51:47 UTC 38.79433 -123.01314 Cloverdale 81 [{"latitude": "38.79201", "longitude": "-123.01546"}, {"latitude": "38.79215", "longitude": "-123.01451"}, {"latitude": "38.7925", "longitude": "-123.0134"}, {"latitude": "38.79408", "longitude": "-123.01296"}, {"latitude": "38.79466", "longitude": "-123.01336"}]
649885 October 09, 2019 - 10:51:47 UTC 38.7839 -122.98754 Cloverdale 81 []
649886 October 09, 2019 - 10:51:47 UTC 38.78316 -122.97346 Cloverdale 81 []
649887 October 09, 2019 - 10:51:47 UTC 38.78368 -122.98924 Cloverdale 81 []
649888 October 09, 2019 - 10:51:47 UTC 38.7849 -122.98873 Cloverdale 81 []
649889 October 09, 2019 - 10:51:47 UTC 38.79399 -122.98733 Cloverdale 81 []
649890 October 09, 2019 - 10:51:47 UTC 38.81315 -122.99789 Cloverdale 81 []
649891 October 09, 2019 - 10:51:47 UTC 38.79974 -122.98365 Cloverdale 81 []
649892 October 09, 2019 - 10:51:47 UTC 38.81349 -122.9964 Cloverdale 81 []
649893 October 09, 2019 - 10:51:47 UTC 38.81098 -123.00415 Cloverdale 81 []
649894 October 09, 2019 - 10:51:47 UTC 38.83775 -122.95808 Cloverdale 81 []
649898 October 09, 2019 - 10:51:47 UTC 38.81425 -123.00627 Cloverdale 81 []
649899 October 09, 2019 - 10:51:47 UTC 38.8166 -122.98911 Cloverdale 81 []
649900 October 09, 2019 - 10:51:47 UTC 38.79359 -123.00956 Cloverdale 81 []
649901 October 09, 2019 - 10:51:47 UTC 38.78706 -123.00748 Cloverdale 81 [{"latitude": "38.78619", "longitude": "-123.00512"}, {"latitude": "38.78648", "longitude": "-123.00632"}, {"latitude": "38.7863", "longitude": "-123.00635"}]
649903 October 09, 2019 - 10:52:15 UTC 38.82568 -123.01662 Cloverdale 81 []
649904 October 09, 2019 - 10:52:15 UTC 38.80963 -122.99409 Cloverdale 81 []
649905 October 09, 2019 - 10:52:15 UTC 38.79745 -122.98539 Cloverdale 81 []
649906 October 09, 2019 - 10:52:15 UTC 38.84506 -122.99315 Cloverdale 81 []
650737 October 09, 2019 - 15:16:15 UTC 38.79971 -123.01848 Cloverdale 81 []
651070 October 09, 2019 - 10:12:45 UTC 38.7244 -122.93436 Cloverdale 81 [{"latitude": "38.71966", "longitude": "-122.9347"}, {"latitude": "38.72055", "longitude": "-122.93368"}, {"latitude": "38.72341", "longitude": "-122.93401"}]
651079 October 09, 2019 - 10:12:45 UTC 38.71054 -122.92495 Cloverdale 81 [{"latitude": "38.6892", "longitude": "-122.90246"}, {"latitude": "38.69111", "longitude": "-122.90155"}, {"latitude": "38.70802", "longitude": "-122.91379"}, {"latitude": "38.70969", "longitude": "-122.91824"}, {"latitude": "38.71036", "longitude": "-122.92187"}, {"latitude": "38.69306", "longitude": "-122.92413"}, {"latitude": "38.6905", "longitude": "-122.92025"}]
651103 October 09, 2019 - 10:12:45 UTC 38.71132 -123.00025 Cloverdale 81 [{"latitude": "38.62299", "longitude": "-123.19379"}, {"latitude": "38.66976", "longitude": "-123.03206"}, {"latitude": "38.69009", "longitude": "-122.99969"}, {"latitude": "38.70906", "longitude": "-123.00745"}, {"latitude": "38.716", "longitude": "-123.01903"}, {"latitude": "38.7336", "longitude": "-123.06972"}, {"latitude": "38.74809", "longitude": "-123.12027"}, {"latitude": "38.65599", "longitude": "-123.217"}, {"latitude": "38.64398", "longitude": "-123.21489"}]
651178 October 09, 2019 - 10:41:00 UTC 38.77624 -122.98103 Cloverdale 81 [{"latitude": "38.75047", "longitude": "-122.9092"}, {"latitude": "38.75786", "longitude": "-122.89593"}, {"latitude": "38.77878", "longitude": "-122.89287"}, {"latitude": "38.78077", "longitude": "-122.89359"}, {"latitude": "38.78576", "longitude": "-122.97212"}, {"latitude": "38.77748", "longitude": "-122.98024"}, {"latitude": "38.77013", "longitude": "-122.97602"}, {"latitude": "38.75514", "longitude": "-122.95608"}]
651181 October 09, 2019 - 10:41:00 UTC 38.80098 -122.9916 Cloverdale 81 [{"latitude": "38.79571", "longitude": "-122.98565"}, {"latitude": "38.79913", "longitude": "-122.96321"}, {"latitude": "38.8023", "longitude": "-122.98841"}, {"latitude": "38.80102", "longitude": "-122.99083"}, {"latitude": "38.79615", "longitude": "-122.98811"}]
651183 October 09, 2019 - 10:41:00 UTC 38.78526 -123.02267 Cloverdale 81 [{"latitude": "38.76775", "longitude": "-123.05444"}, {"latitude": "38.78094", "longitude": "-123.02722"}, {"latitude": "38.78261", "longitude": "-123.02414"}, {"latitude": "38.78748", "longitude": "-123.02258"}, {"latitude": "38.81723", "longitude": "-123.16563"}, {"latitude": "38.80201", "longitude": "-123.17479"}, {"latitude": "38.79943", "longitude": "-123.17229"}, {"latitude": "38.79607", "longitude": "-123.16846"}, {"latitude": "38.79431", "longitude": "-123.16444"}, {"latitude": "38.78645", "longitude": "-123.13357"}]
651185 October 09, 2019 - 10:41:00 UTC 38.7802 -123.00848 Cloverdale 81 []
651188 October 09, 2019 - 10:41:00 UTC 38.77827 -123.00681 Cloverdale 81 []
651198 October 09, 2019 - 10:41:00 UTC 38.77324 -122.99897 Cloverdale 81 [{"latitude": "38.77022", "longitude": "-122.99757"}, {"latitude": "38.77131", "longitude": "-122.99849"}, {"latitude": "38.77418", "longitude": "-123.00123"}, {"latitude": "38.77427", "longitude": "-123.00151"}, {"latitude": "38.77472", "longitude": "-123.00381"}, {"latitude": "38.77464", "longitude": "-123.0039"}]
653487 October 10, 2019 - 21:56:00 UTC 38.80027 -123.01879 Cloverdale 81 []
653704 October 11, 2019 - 00:33:00 UTC 38.78318 -123.01833 Cloverdale 81 []
653736 October 11, 2019 - 00:59:22 UTC 38.78265 -123.01534 Cloverdale 81 []
653861 October 11, 2019 - 00:59:22 UTC 38.78417 -123.01273 Cloverdale 81 [{"latitude": "38.78181", "longitude": "-123.01407"}, {"latitude": "38.7835", "longitude": "-123.01272"}, {"latitude": "38.78316", "longitude": "-123.01575"}, {"latitude": "38.78213", "longitude": "-123.01543"}]
653917 October 11, 2019 - 03:35:56 UTC 38.78316 -123.01575 Cloverdale 81 []
653938 October 11, 2019 - 03:54:00 UTC 38.78218 -122.98933 Cloverdale 81 []
653980 October 11, 2019 - 04:51:42 UTC 38.78323 -123.01382 Cloverdale 81 []
653991 October 11, 2019 - 03:36:09 UTC 38.78316 -123.01575 Cloverdale 81 []
657933 October 14, 2019 - 20:38:26 UTC 38.81409 -123.02171 Cloverdale 81 []
659894 October 15, 2019 - 23:11:00 UTC 38.80213 -123.01821 Cloverdale 81 [{"latitude": "38.80047", "longitude": "-123.02441"}, {"latitude": "38.80073", "longitude": "-123.02317"}, {"latitude": "38.80111", "longitude": "-123.02154"}, {"latitude": "38.80303", "longitude": "-123.01584"}, {"latitude": "38.80806", "longitude": "-123.01403"}, {"latitude": "38.81114", "longitude": "-123.01301"}, {"latitude": "38.8263", "longitude": "-123.01669"}, {"latitude": "38.82812", "longitude": "-123.01721"}, {"latitude": "38.88055", "longitude": "-123.10029"}, {"latitude": "38.88508", "longitude": "-123.11635"}, {"latitude": "38.88446", "longitude": "-123.12255"}, {"latitude": "38.86351", "longitude": "-123.11161"}, {"latitude": "38.81009", "longitude": "-123.05947"}]
659933 October 16, 2019 - 00:21:00 UTC 38.81075 -123.01567 Cloverdale 81 []
659939 October 16, 2019 - 00:39:00 UTC 38.80952 -123.02673 Cloverdale 81 []
667165 October 18, 2019 - 00:10:49 UTC 38.80014 -123.0147 Cloverdale 81 []
667303 October 18, 2019 - 04:28:23 UTC 38.80014 -123.0147 Cloverdale 81 []
667577 October 18, 2019 - 15:08:00 UTC 38.79722 -123.01068 Cloverdale 81 [{"latitude": "38.75047", "longitude": "-122.9092"}, {"latitude": "38.75786", "longitude": "-122.89593"}, {"latitude": "38.77878", "longitude": "-122.89287"}, {"latitude": "38.87712", "longitude": "-122.88475"}, {"latitude": "38.89282", "longitude": "-122.99011"}, {"latitude": "38.89937", "longitude": "-123.04825"}, {"latitude": "38.88446", "longitude": "-123.12255"}, {"latitude": "38.81723", "longitude": "-123.16563"}, {"latitude": "38.80201", "longitude": "-123.17479"}, {"latitude": "38.79943", "longitude": "-123.17229"}, {"latitude": "38.79607", "longitude": "-123.16846"}, {"latitude": "38.79431", "longitude": "-123.16444"}, {"latitude": "38.78645", "longitude": "-123.13357"}, {"latitude": "38.76775", "longitude": "-123.05444"}, {"latitude": "38.76269", "longitude": "-123.02144"}, {"latitude": "38.75514", "longitude": "-122.95608"}]
673873 October 19, 2019 - 21:56:44 UTC 38.80014 -123.0147 Cloverdale 81 []
675845 October 21, 2019 - 16:00:00 UTC 38.79983 -122.9879 Cloverdale 81 [{"latitude": "38.79571", "longitude": "-122.98565"}, {"latitude": "38.79773", "longitude": "-122.98743"}, {"latitude": "38.79615", "longitude": "-122.98811"}]
676118 October 21, 2019 - 18:11:20 UTC 38.80818 -123.02316 Cloverdale 81 []
678044 October 23, 2019 - 21:41:00 UTC 38.80213 -123.01821 Cloverdale 81 [{"latitude": "38.80047", "longitude": "-123.02441"}, {"latitude": "38.80073", "longitude": "-123.02317"}, {"latitude": "38.80111", "longitude": "-123.02154"}, {"latitude": "38.80303", "longitude": "-123.01584"}, {"latitude": "38.80806", "longitude": "-123.01403"}, {"latitude": "38.81114", "longitude": "-123.01301"}, {"latitude": "38.8263", "longitude": "-123.01669"}, {"latitude": "38.82812", "longitude": "-123.01721"}, {"latitude": "38.88055", "longitude": "-123.10029"}, {"latitude": "38.88508", "longitude": "-123.11635"}, {"latitude": "38.88446", "longitude": "-123.12255"}, {"latitude": "38.86351", "longitude": "-123.11161"}, {"latitude": "38.81009", "longitude": "-123.05947"}]
678295 October 23, 2019 - 21:41:00 UTC 38.71054 -122.92495 Cloverdale 81 [{"latitude": "38.6892", "longitude": "-122.90246"}, {"latitude": "38.69111", "longitude": "-122.90155"}, {"latitude": "38.70802", "longitude": "-122.91379"}, {"latitude": "38.70969", "longitude": "-122.91824"}, {"latitude": "38.71036", "longitude": "-122.92187"}, {"latitude": "38.69306", "longitude": "-122.92413"}, {"latitude": "38.6905", "longitude": "-122.92025"}]
678305 October 23, 2019 - 22:11:00 UTC 38.7987 -122.99238 Cloverdale 81 [{"latitude": "38.75047", "longitude": "-122.9092"}, {"latitude": "38.75786", "longitude": "-122.89593"}, {"latitude": "38.77878", "longitude": "-122.89287"}, {"latitude": "38.87712", "longitude": "-122.88475"}, {"latitude": "38.89282", "longitude": "-122.99011"}, {"latitude": "38.89937", "longitude": "-123.04825"}, {"latitude": "38.89904", "longitude": "-123.04938"}, {"latitude": "38.88391", "longitude": "-123.0603"}, {"latitude": "38.87496", "longitude": "-123.06417"}, {"latitude": "38.86694", "longitude": "-123.05854"}, {"latitude": "38.8195", "longitude": "-123.02181"}, {"latitude": "38.77771", "longitude": "-122.98891"}, {"latitude": "38.77719", "longitude": "-122.98837"}, {"latitude": "38.77656", "longitude": "-122.9877"}, {"latitude": "38.75514", "longitude": "-122.95608"}]
678387 October 23, 2019 - 22:11:00 UTC 38.79914 -122.99128 Cloverdale 81 [{"latitude": "38.79571", "longitude": "-122.98565"}, {"latitude": "38.79913", "longitude": "-122.96321"}, {"latitude": "38.89282", "longitude": "-122.99011"}, {"latitude": "38.89937", "longitude": "-123.04825"}, {"latitude": "38.89904", "longitude": "-123.04938"}, {"latitude": "38.88391", "longitude": "-123.0603"}, {"latitude": "38.87496", "longitude": "-123.06417"}, {"latitude": "38.86694", "longitude": "-123.05854"}, {"latitude": "38.8195", "longitude": "-123.02181"}, {"latitude": "38.80141", "longitude": "-123.0026"}, {"latitude": "38.79615", "longitude": "-122.98811"}]
678391 October 23, 2019 - 22:11:00 UTC 38.79767 -122.99097 Cloverdale 81 [{"latitude": "38.75047", "longitude": "-122.9092"}, {"latitude": "38.75786", "longitude": "-122.89593"}, {"latitude": "38.77878", "longitude": "-122.89287"}, {"latitude": "38.78077", "longitude": "-122.89359"}, {"latitude": "38.7953", "longitude": "-122.9801"}, {"latitude": "38.79613", "longitude": "-122.98935"}, {"latitude": "38.79616", "longitude": "-122.99097"}, {"latitude": "38.7961", "longitude": "-122.99359"}, {"latitude": "38.79484", "longitude": "-122.99622"}, {"latitude": "38.79235", "longitude": "-122.99784"}, {"latitude": "38.78903", "longitude": "-122.99719"}, {"latitude": "38.77771", "longitude": "-122.98891"}, {"latitude": "38.77719", "longitude": "-122.98837"}, {"latitude": "38.77656", "longitude": "-122.9877"}, {"latitude": "38.75514", "longitude": "-122.95608"}]
678408 October 23, 2019 - 22:11:00 UTC 38.82384 -123.00323 Cloverdale 81 [{"latitude": "38.81839", "longitude": "-122.99775"}, {"latitude": "38.81857", "longitude": "-122.95285"}, {"latitude": "38.84959", "longitude": "-122.90489"}, {"latitude": "38.87183", "longitude": "-122.88639"}, {"latitude": "38.87712", "longitude": "-122.88475"}, {"latitude": "38.87045", "longitude": "-122.97559"}, {"latitude": "38.8523", "longitude": "-122.99514"}, {"latitude": "38.84966", "longitude": "-122.99744"}, {"latitude": "38.83227", "longitude": "-123.00232"}, {"latitude": "38.82421", "longitude": "-123.00257"}]
678431 October 23, 2019 - 22:11:00 UTC 38.82943 -123.00639 Cloverdale 81 [{"latitude": "38.81863", "longitude": "-123.01844"}, {"latitude": "38.81916", "longitude": "-123.01618"}, {"latitude": "38.8239", "longitude": "-123.0111"}, {"latitude": "38.82697", "longitude": "-123.00862"}, {"latitude": "38.82968", "longitude": "-123.00708"}, {"latitude": "38.89282", "longitude": "-122.99011"}, {"latitude": "38.89937", "longitude": "-123.04825"}, {"latitude": "38.89904", "longitude": "-123.04938"}, {"latitude": "38.88391", "longitude": "-123.0603"}, {"latitude": "38.87496", "longitude": "-123.06417"}, {"latitude": "38.86694", "longitude": "-123.05854"}, {"latitude": "38.8195", "longitude": "-123.02181"}]
678442 October 23, 2019 - 22:39:00 UTC 38.80213 -123.01821 Cloverdale 81 [{"latitude": "38.80047", "longitude": "-123.02441"}, {"latitude": "38.80073", "longitude": "-123.02317"}, {"latitude": "38.80111", "longitude": "-123.02154"}, {"latitude": "38.80303", "longitude": "-123.01584"}, {"latitude": "38.80806", "longitude": "-123.01403"}, {"latitude": "38.81114", "longitude": "-123.01301"}, {"latitude": "38.8263", "longitude": "-123.01669"}, {"latitude": "38.82812", "longitude": "-123.01721"}, {"latitude": "38.88055", "longitude": "-123.10029"}, {"latitude": "38.88508", "longitude": "-123.11635"}, {"latitude": "38.88446", "longitude": "-123.12255"}, {"latitude": "38.86351", "longitude": "-123.11161"}, {"latitude": "38.81009", "longitude": "-123.05947"}]
678560 October 23, 2019 - 22:55:58 UTC 38.81574 -123.02486 Cloverdale 81 []
678561 October 23, 2019 - 22:55:58 UTC 38.81617 -123.02506 Cloverdale 81 []
678562 October 23, 2019 - 22:55:58 UTC 38.8263 -123.01669 Cloverdale 81 []
678563 October 23, 2019 - 22:55:58 UTC 38.81742 -123.02636 Cloverdale 81 []
678564 October 23, 2019 - 22:55:58 UTC 38.81692 -123.02549 Cloverdale 81 []
678565 October 23, 2019 - 22:55:58 UTC 38.81525 -123.02424 Cloverdale 81 []
678566 October 23, 2019 - 22:55:58 UTC 38.80368 -123.02489 Cloverdale 81 []
678567 October 23, 2019 - 22:55:58 UTC 38.80407 -123.02305 Cloverdale 81 []
678568 October 23, 2019 - 22:55:58 UTC 38.80435 -123.02251 Cloverdale 81 []
678569 October 23, 2019 - 22:55:58 UTC 38.80294 -123.02192 Cloverdale 81 []
678570 October 23, 2019 - 22:55:58 UTC 38.80047 -123.02441 Cloverdale 81 []
678571 October 23, 2019 - 22:55:58 UTC 38.80073 -123.02317 Cloverdale 81 []
678572 October 23, 2019 - 22:55:58 UTC 38.80111 -123.02154 Cloverdale 81 []
678573 October 23, 2019 - 22:39:00 UTC 38.80153 -123.02409 Cloverdale 81 []
678574 October 23, 2019 - 22:55:59 UTC 38.80197 -123.02201 Cloverdale 81 []
678575 October 23, 2019 - 22:55:59 UTC 38.80317 -123.02119 Cloverdale 81 []
678576 October 23, 2019 - 22:55:59 UTC 38.8043 -123.02211 Cloverdale 81 []
678577 October 23, 2019 - 22:55:58 UTC 38.80734 -123.02258 Cloverdale 81 [{"latitude": "38.80461", "longitude": "-123.02609"}, {"latitude": "38.80533", "longitude": "-123.02412"}, {"latitude": "38.80609", "longitude": "-123.02326"}, {"latitude": "38.80702", "longitude": "-123.02311"}, {"latitude": "38.80702", "longitude": "-123.02606"}, {"latitude": "38.80613", "longitude": "-123.02795"}]

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