outages

275 rows where regionName = 93

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
633643 October 01, 2019 - 15:26:07 UTC 38.11171 -122.59581 Novato 93 []
634154 October 01, 2019 - 18:55:12 UTC 38.09206 -122.54889 Novato 93 []
635838 October 02, 2019 - 15:55:42 UTC 38.09206 -122.54889 Novato 93 []
638909 October 03, 2019 - 07:18:21 UTC 38.1108 -122.59437 Novato 93 []
638983 October 03, 2019 - 14:32:54 UTC 38.0644 -122.55306 Novato 93 []
639108 October 03, 2019 - 16:02:13 UTC 38.08509 -122.59214 Novato 93 [{"latitude": "38.08402", "longitude": "-122.60252"}, {"latitude": "38.08466", "longitude": "-122.593"}, {"latitude": "38.08539", "longitude": "-122.59308"}, {"latitude": "38.08698", "longitude": "-122.59514"}, {"latitude": "38.08565", "longitude": "-122.59974"}]
641894 October 03, 2019 - 23:58:05 UTC 38.1108 -122.59437 Novato 93 []
642248 October 04, 2019 - 14:15:57 UTC 38.11547 -122.58368 Novato 93 [{"latitude": "38.11495", "longitude": "-122.58269"}, {"latitude": "38.1155", "longitude": "-122.58149"}, {"latitude": "38.11616", "longitude": "-122.58267"}]
644704 October 05, 2019 - 18:53:00 UTC 38.06856 -122.54179 Novato 93 [{"latitude": "38.06729", "longitude": "-122.53939"}, {"latitude": "38.06826", "longitude": "-122.53884"}, {"latitude": "38.06957", "longitude": "-122.54014"}, {"latitude": "38.0699", "longitude": "-122.54188"}, {"latitude": "38.06855", "longitude": "-122.54242"}]
644705 October 05, 2019 - 18:54:32 UTC 38.06643 -122.54151 Novato 93 [{"latitude": "38.06613", "longitude": "-122.54099"}, {"latitude": "38.0663", "longitude": "-122.53959"}, {"latitude": "38.06674", "longitude": "-122.53927"}, {"latitude": "38.0676", "longitude": "-122.54018"}, {"latitude": "38.06615", "longitude": "-122.54153"}]
646039 October 07, 2019 - 17:30:57 UTC 38.08316 -122.5674 Novato 93 []
647776 October 09, 2019 - 04:43:51 UTC 38.08674 -122.57187 Novato 93 []
653108 October 10, 2019 - 19:17:00 UTC 38.14025 -122.55315 Novato 93 []
653368 October 10, 2019 - 20:47:00 UTC 38.11465 -122.57785 Novato 93 []
654679 October 11, 2019 - 23:04:37 UTC 38.1003 -122.57401 Novato 93 []
655185 October 12, 2019 - 18:02:01 UTC 38.10745 -122.50758 Novato 93 []
655491 October 13, 2019 - 12:45:32 UTC 38.05097 -122.53096 Novato 93 []
655533 October 13, 2019 - 15:56:36 UTC 38.09181 -122.57828 Novato 93 [{"latitude": "38.09198", "longitude": "-122.57992"}, {"latitude": "38.09217", "longitude": "-122.57935"}, {"latitude": "38.09295", "longitude": "-122.57995"}, {"latitude": "38.09408", "longitude": "-122.58113"}, {"latitude": "38.09244", "longitude": "-122.58287"}]
655617 October 13, 2019 - 20:45:50 UTC 38.10234 -122.56427 Novato 93 []
655687 October 14, 2019 - 01:50:00 UTC 38.05007 -122.53477 Novato 93 []
656633 October 14, 2019 - 17:19:34 UTC 38.1003 -122.57401 Novato 93 []
658949 October 15, 2019 - 16:22:00 UTC 38.11207 -122.59316 Novato 93 [{"latitude": "38.11247", "longitude": "-122.59184"}, {"latitude": "38.11378", "longitude": "-122.59074"}, {"latitude": "38.11427", "longitude": "-122.59102"}, {"latitude": "38.11486", "longitude": "-122.59175"}, {"latitude": "38.11553", "longitude": "-122.59656"}, {"latitude": "38.11509", "longitude": "-122.59719"}, {"latitude": "38.11257", "longitude": "-122.59292"}]
658988 October 15, 2019 - 16:51:13 UTC 38.09169 -122.60979 Novato 93 []
659813 October 15, 2019 - 21:00:08 UTC 38.09807 -122.5676 Novato 93 []
660677 October 16, 2019 - 16:43:41 UTC 38.08586 -122.57833 Novato 93 []
661556 October 16, 2019 - 19:28:00 UTC 38.09711 -122.55911 Novato 93 []
661693 October 16, 2019 - 19:42:59 UTC 38.09217 -122.57935 Novato 93 []
667895 October 18, 2019 - 15:46:21 UTC 38.06819 -122.55133 Novato 93 []
675193 October 21, 2019 - 14:50:05 UTC 38.06838 -122.53375 Novato 93 []
676959 October 22, 2019 - 19:59:55 UTC 38.0984 -122.58248 Novato 93 []
679195 October 24, 2019 - 05:10:39 UTC 38.10743 -122.59123 Novato 93 []
680285 October 25, 2019 - 16:11:22 UTC 38.06116 -122.58 Novato 93 [{"latitude": "38.06168", "longitude": "-122.57876"}, {"latitude": "38.06351", "longitude": "-122.57718"}, {"latitude": "38.06182", "longitude": "-122.58096"}]
680351 October 25, 2019 - 17:00:13 UTC 38.11058 -122.59905 Novato 93 []
680551 October 25, 2019 - 21:47:28 UTC 38.06869 -122.56174 Novato 93 []
680714 October 26, 2019 - 06:46:19 UTC 38.08623 -122.57101 Novato 93 []
680759 October 26, 2019 - 15:06:41 UTC 38.135 -122.68651 Novato 93 []
680979 October 27, 2019 - 00:05:36 UTC 38.11998 -122.61384 Novato 93 [{"latitude": "38.10532", "longitude": "-122.61617"}, {"latitude": "38.107", "longitude": "-122.57825"}, {"latitude": "38.10785", "longitude": "-122.57106"}, {"latitude": "38.10919", "longitude": "-122.56776"}, {"latitude": "38.12814", "longitude": "-122.57206"}, {"latitude": "38.12943", "longitude": "-122.57242"}, {"latitude": "38.13075", "longitude": "-122.57557"}, {"latitude": "38.12961", "longitude": "-122.60526"}, {"latitude": "38.11262", "longitude": "-122.62891"}, {"latitude": "38.10946", "longitude": "-122.62801"}, {"latitude": "38.10659", "longitude": "-122.62276"}]
680988 October 27, 2019 - 00:03:00 UTC 38.11712 -122.56416 Novato 93 [{"latitude": "38.12049", "longitude": "-122.56461"}, {"latitude": "38.13903", "longitude": "-122.53029"}, {"latitude": "38.15545", "longitude": "-122.54497"}, {"latitude": "38.1657", "longitude": "-122.5678"}, {"latitude": "38.1723", "longitude": "-122.58986"}, {"latitude": "38.1502", "longitude": "-122.5948"}, {"latitude": "38.14489", "longitude": "-122.59453"}]
681047 October 27, 2019 - 00:05:36 UTC 38.11718 -122.60983 Novato 93 [{"latitude": "38.10532", "longitude": "-122.61617"}, {"latitude": "38.10632", "longitude": "-122.60562"}, {"latitude": "38.10663", "longitude": "-122.60247"}, {"latitude": "38.10792", "longitude": "-122.60102"}, {"latitude": "38.10841", "longitude": "-122.60086"}, {"latitude": "38.10974", "longitude": "-122.60043"}, {"latitude": "38.11147", "longitude": "-122.60215"}, {"latitude": "38.11287", "longitude": "-122.60408"}, {"latitude": "38.11636", "longitude": "-122.61008"}, {"latitude": "38.11262", "longitude": "-122.62891"}, {"latitude": "38.10946", "longitude": "-122.62801"}, {"latitude": "38.10659", "longitude": "-122.62276"}]
681138 October 27, 2019 - 00:16:00 UTC 38.11998 -122.61393 Novato 93 [{"latitude": "38.08402", "longitude": "-122.60252"}, {"latitude": "38.08466", "longitude": "-122.593"}, {"latitude": "38.08687", "longitude": "-122.58571"}, {"latitude": "38.08872", "longitude": "-122.58241"}, {"latitude": "38.09058", "longitude": "-122.57924"}, {"latitude": "38.09071", "longitude": "-122.57907"}, {"latitude": "38.09736", "longitude": "-122.57072"}, {"latitude": "38.09871", "longitude": "-122.57138"}, {"latitude": "38.1063", "longitude": "-122.57958"}, {"latitude": "38.11817", "longitude": "-122.59262"}, {"latitude": "38.12273", "longitude": "-122.61311"}, {"latitude": "38.12142", "longitude": "-122.61809"}, {"latitude": "38.11162", "longitude": "-122.63967"}, {"latitude": "38.10567", "longitude": "-122.64624"}, {"latitude": "38.10368", "longitude": "-122.64556"}, {"latitude": "38.08525", "longitude": "-122.61138"}]
681177 October 27, 2019 - 00:16:00 UTC 38.12214 -122.62238 Novato 93 [{"latitude": "38.11417", "longitude": "-122.65307"}, {"latitude": "38.11838", "longitude": "-122.63544"}, {"latitude": "38.12395", "longitude": "-122.63786"}, {"latitude": "38.12515", "longitude": "-122.63918"}, {"latitude": "38.1255", "longitude": "-122.63992"}, {"latitude": "38.135", "longitude": "-122.68651"}, {"latitude": "38.1143", "longitude": "-122.66431"}]
681195 October 27, 2019 - 00:16:00 UTC 38.12301 -122.62675 Novato 93 [{"latitude": "38.13155", "longitude": "-122.62391"}, {"latitude": "38.13832", "longitude": "-122.62276"}, {"latitude": "38.14074", "longitude": "-122.62516"}]
681209 October 27, 2019 - 00:16:00 UTC 38.11757 -122.60857 Novato 93 [{"latitude": "38.09736", "longitude": "-122.57072"}, {"latitude": "38.09871", "longitude": "-122.57138"}, {"latitude": "38.1063", "longitude": "-122.57958"}, {"latitude": "38.11817", "longitude": "-122.59262"}, {"latitude": "38.1173", "longitude": "-122.60786"}, {"latitude": "38.11461", "longitude": "-122.60738"}, {"latitude": "38.09764", "longitude": "-122.59577"}]
681219 October 27, 2019 - 00:16:00 UTC 38.1072 -122.59411 Novato 93 [{"latitude": "38.08402", "longitude": "-122.60252"}, {"latitude": "38.08466", "longitude": "-122.593"}, {"latitude": "38.08687", "longitude": "-122.58571"}, {"latitude": "38.08872", "longitude": "-122.58241"}, {"latitude": "38.09058", "longitude": "-122.57924"}, {"latitude": "38.09071", "longitude": "-122.57907"}, {"latitude": "38.09115", "longitude": "-122.57864"}, {"latitude": "38.10666", "longitude": "-122.5945"}, {"latitude": "38.1084", "longitude": "-122.59765"}, {"latitude": "38.10885", "longitude": "-122.59966"}, {"latitude": "38.11162", "longitude": "-122.63967"}, {"latitude": "38.10567", "longitude": "-122.64624"}, {"latitude": "38.10368", "longitude": "-122.64556"}, {"latitude": "38.08525", "longitude": "-122.61138"}]
681221 October 27, 2019 - 00:28:38 UTC 38.08669 -122.56158 Novato 93 []
683106 October 27, 2019 - 00:05:36 UTC 38.11018 -122.61324 Novato 93 [{"latitude": "38.10946", "longitude": "-122.62801"}, {"latitude": "38.11035", "longitude": "-122.6137"}, {"latitude": "38.11132", "longitude": "-122.61228"}, {"latitude": "38.11294", "longitude": "-122.61179"}, {"latitude": "38.113", "longitude": "-122.61738"}, {"latitude": "38.11297", "longitude": "-122.61901"}, {"latitude": "38.11262", "longitude": "-122.62891"}]
683128 October 27, 2019 - 00:05:36 UTC 38.11996 -122.58582 Novato 93 [{"latitude": "38.107", "longitude": "-122.57825"}, {"latitude": "38.10785", "longitude": "-122.57106"}, {"latitude": "38.10919", "longitude": "-122.56776"}, {"latitude": "38.11224", "longitude": "-122.56962"}, {"latitude": "38.12017", "longitude": "-122.57981"}, {"latitude": "38.12029", "longitude": "-122.58634"}, {"latitude": "38.1192", "longitude": "-122.58995"}, {"latitude": "38.11836", "longitude": "-122.59108"}, {"latitude": "38.11661", "longitude": "-122.59337"}, {"latitude": "38.11176", "longitude": "-122.58953"}]
683281 October 27, 2019 - 00:05:36 UTC 38.11882 -122.61254 Novato 93 []
683327 October 27, 2019 - 00:05:36 UTC 38.11864 -122.60849 Novato 93 [{"latitude": "38.11669", "longitude": "-122.60425"}, {"latitude": "38.11672", "longitude": "-122.60345"}, {"latitude": "38.11692", "longitude": "-122.60265"}, {"latitude": "38.1181", "longitude": "-122.59898"}, {"latitude": "38.11823", "longitude": "-122.60792"}, {"latitude": "38.11769", "longitude": "-122.60723"}, {"latitude": "38.1171", "longitude": "-122.6058"}]
683344 October 27, 2019 - 00:05:36 UTC 38.11141 -122.61432 Novato 93 [{"latitude": "38.11146", "longitude": "-122.61432"}, {"latitude": "38.11239", "longitude": "-122.61253"}, {"latitude": "38.11294", "longitude": "-122.61179"}, {"latitude": "38.113", "longitude": "-122.61738"}, {"latitude": "38.11297", "longitude": "-122.61901"}, {"latitude": "38.11262", "longitude": "-122.62891"}]
683371 October 27, 2019 - 00:05:36 UTC 38.11187 -122.61916 Novato 93 [{"latitude": "38.11188", "longitude": "-122.62504"}, {"latitude": "38.11229", "longitude": "-122.61709"}, {"latitude": "38.1123", "longitude": "-122.61961"}, {"latitude": "38.11188", "longitude": "-122.62729"}]
683390 October 27, 2019 - 00:05:36 UTC 38.11497 -122.5872 Novato 93 [{"latitude": "38.11528", "longitude": "-122.58786"}, {"latitude": "38.11826", "longitude": "-122.58762"}, {"latitude": "38.11931", "longitude": "-122.58824"}, {"latitude": "38.1192", "longitude": "-122.58995"}, {"latitude": "38.11836", "longitude": "-122.59108"}, {"latitude": "38.11661", "longitude": "-122.59337"}, {"latitude": "38.1162", "longitude": "-122.59235"}]
683406 October 27, 2019 - 00:05:36 UTC 38.11445 -122.58754 Novato 93 [{"latitude": "38.11473", "longitude": "-122.58824"}, {"latitude": "38.1152", "longitude": "-122.58946"}, {"latitude": "38.11572", "longitude": "-122.5914"}, {"latitude": "38.11541", "longitude": "-122.59077"}]
683423 October 27, 2019 - 00:05:36 UTC 38.11547 -122.58368 Novato 93 [{"latitude": "38.11495", "longitude": "-122.58269"}, {"latitude": "38.1155", "longitude": "-122.58149"}, {"latitude": "38.11616", "longitude": "-122.58267"}]
683439 October 27, 2019 - 00:05:36 UTC 38.11063 -122.57785 Novato 93 [{"latitude": "38.11026", "longitude": "-122.58153"}, {"latitude": "38.11062", "longitude": "-122.57966"}, {"latitude": "38.1109", "longitude": "-122.57857"}, {"latitude": "38.11279", "longitude": "-122.58077"}, {"latitude": "38.1128", "longitude": "-122.58165"}, {"latitude": "38.11073", "longitude": "-122.58226"}]
683461 October 27, 2019 - 00:05:36 UTC 38.11178 -122.57782 Novato 93 [{"latitude": "38.11232", "longitude": "-122.57811"}, {"latitude": "38.11393", "longitude": "-122.57405"}, {"latitude": "38.12017", "longitude": "-122.57981"}, {"latitude": "38.11975", "longitude": "-122.58082"}, {"latitude": "38.11353", "longitude": "-122.5787"}]
683640 October 27, 2019 - 03:33:03 UTC 38.10614 -122.54632 Novato 93 []
683659 October 27, 2019 - 03:34:04 UTC 38.11191 -122.56158 Novato 93 []
683660 October 27, 2019 - 03:34:03 UTC 38.11244 -122.56336 Novato 93 []
683712 October 27, 2019 - 03:36:10 UTC 38.10563 -122.56588 Novato 93 []
683739 October 27, 2019 - 03:37:42 UTC 38.10203 -122.56239 Novato 93 []
683740 October 27, 2019 - 03:37:43 UTC 38.08706 -122.55456 Novato 93 []
683774 October 27, 2019 - 03:39:02 UTC 38.11811 -122.56796 Novato 93 []
683789 October 27, 2019 - 03:39:57 UTC 38.06477 -122.53965 Novato 93 [{"latitude": "38.06382", "longitude": "-122.53711"}, {"latitude": "38.06449", "longitude": "-122.53736"}, {"latitude": "38.0645", "longitude": "-122.53863"}, {"latitude": "38.06412", "longitude": "-122.53871"}]
683793 October 27, 2019 - 03:40:06 UTC 38.07988 -122.56698 Novato 93 []
683794 October 27, 2019 - 03:40:03 UTC 38.07731 -122.5163 Novato 93 []
683819 October 27, 2019 - 03:41:23 UTC 38.05781 -122.53373 Novato 93 []
683826 October 27, 2019 - 03:42:05 UTC 38.10669 -122.57412 Novato 93 []
683833 October 27, 2019 - 03:42:08 UTC 38.05257 -122.52807 Novato 93 []
683850 October 27, 2019 - 03:42:52 UTC 38.10918 -122.5599 Novato 93 []
683860 October 27, 2019 - 03:43:36 UTC 38.10499 -122.55022 Novato 93 []
683864 October 27, 2019 - 03:43:45 UTC 38.10348 -122.56694 Novato 93 [{"latitude": "38.10247", "longitude": "-122.56756"}, {"latitude": "38.10305", "longitude": "-122.56742"}, {"latitude": "38.10356", "longitude": "-122.56813"}]
683894 October 27, 2019 - 03:45:53 UTC 38.11434 -122.57045 Novato 93 []
683913 October 27, 2019 - 03:46:57 UTC 38.06498 -122.54071 Novato 93 []
683916 October 27, 2019 - 03:47:00 UTC 38.10439 -122.56704 Novato 93 []
683919 October 27, 2019 - 03:47:20 UTC 38.09192 -122.55349 Novato 93 []
683944 October 27, 2019 - 03:48:41 UTC 38.04672 -122.53083 Novato 93 []
683946 October 27, 2019 - 03:48:53 UTC 38.05187 -122.50797 Novato 93 []
683962 October 27, 2019 - 03:50:00 UTC 38.10422 -122.55099 Novato 93 []
683971 October 27, 2019 - 03:50:30 UTC 38.1184 -122.55028 Novato 93 [{"latitude": "38.11896", "longitude": "-122.55121"}, {"latitude": "38.12216", "longitude": "-122.54566"}, {"latitude": "38.12368", "longitude": "-122.545"}, {"latitude": "38.12427", "longitude": "-122.54503"}, {"latitude": "38.12033", "longitude": "-122.54996"}]
684037 October 27, 2019 - 03:55:13 UTC 38.08693 -122.56793 Novato 93 []
684122 October 27, 2019 - 04:03:52 UTC 38.10542 -122.54238 Novato 93 []
684138 October 27, 2019 - 04:05:35 UTC 38.1106 -122.56077 Novato 93 []
684142 October 27, 2019 - 04:05:00 UTC 38.11101 -122.5548 Novato 93 []
684162 October 27, 2019 - 04:07:27 UTC 38.07856 -122.52092 Novato 93 []
684173 October 27, 2019 - 04:09:04 UTC 38.05007 -122.53477 Novato 93 []
684191 October 27, 2019 - 04:10:58 UTC 38.07976 -122.54835 Novato 93 []
684271 October 27, 2019 - 04:19:53 UTC 38.08695 -122.54952 Novato 93 []
684312 October 27, 2019 - 04:25:00 UTC 38.08865 -122.56319 Novato 93 []
684343 October 27, 2019 - 04:28:06 UTC 38.10746 -122.54774 Novato 93 []
684374 October 27, 2019 - 04:32:00 UTC 38.10215 -122.55823 Novato 93 []
684450 October 27, 2019 - 04:44:42 UTC 38.11395 -122.56406 Novato 93 []
684513 October 27, 2019 - 04:51:46 UTC 38.08832 -122.56179 Novato 93 []
684568 October 27, 2019 - 03:33:03 UTC 38.10849 -122.56784 Novato 93 [{"latitude": "38.09728", "longitude": "-122.55872"}, {"latitude": "38.1015", "longitude": "-122.53538"}, {"latitude": "38.11558", "longitude": "-122.52927"}, {"latitude": "38.11817", "longitude": "-122.52854"}, {"latitude": "38.12427", "longitude": "-122.54503"}, {"latitude": "38.12513", "longitude": "-122.56873"}, {"latitude": "38.12092", "longitude": "-122.57511"}, {"latitude": "38.11786", "longitude": "-122.57531"}, {"latitude": "38.10356", "longitude": "-122.56813"}, {"latitude": "38.10247", "longitude": "-122.56756"}, {"latitude": "38.10136", "longitude": "-122.56576"}]
684582 October 27, 2019 - 04:53:22 UTC 38.10772 -122.56809 Novato 93 []
684585 October 27, 2019 - 04:53:22 UTC 38.1061 -122.56865 Novato 93 []
684630 October 27, 2019 - 04:53:22 UTC 38.07826 -122.54261 Novato 93 []
684631 October 27, 2019 - 04:53:22 UTC 38.08204 -122.54553 Novato 93 []
684632 October 27, 2019 - 04:53:22 UTC 38.0775 -122.55245 Novato 93 [{"latitude": "38.07729", "longitude": "-122.55485"}, {"latitude": "38.07733", "longitude": "-122.5546"}, {"latitude": "38.07989", "longitude": "-122.54762"}, {"latitude": "38.08146", "longitude": "-122.54944"}, {"latitude": "38.07869", "longitude": "-122.55402"}]
684633 October 27, 2019 - 04:53:23 UTC 38.05838 -122.53516 Novato 93 []

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