outages

179 rows where regionName = 9

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
629455 September 30, 2019 - 03:17:55 UTC 40.55785 -124.14553 Fortuna 9 []
647640 October 08, 2019 - 23:58:47 UTC 40.54575 -124.14117 Fortuna 9 []
648291 October 09, 2019 - 08:22:58 UTC 40.59213 -124.15367 Fortuna 9 []
648305 October 09, 2019 - 08:29:17 UTC 40.60072 -124.15516 Fortuna 9 []
648428 October 09, 2019 - 08:53:00 UTC 40.59753 -124.15869 Fortuna 9 []
648474 October 09, 2019 - 08:55:54 UTC 40.55405 -124.11667 Fortuna 9 []
648475 October 09, 2019 - 08:55:54 UTC 40.55128 -124.11951 Fortuna 9 []
648767 October 09, 2019 - 08:57:40 UTC 40.56716 -124.12699 Fortuna 9 []
648928 October 09, 2019 - 09:23:52 UTC 40.52492 -124.14683 Fortuna 9 []
648983 October 09, 2019 - 09:23:52 UTC 40.59235 -124.15619 Fortuna 9 []
649069 October 09, 2019 - 09:27:00 UTC 40.56169 -124.14042 Fortuna 9 []
649261 October 09, 2019 - 09:40:00 UTC 40.56632 -124.13151 Fortuna 9 []
649421 October 09, 2019 - 08:13:00 UTC 40.59478 -124.13505 Fortuna 9 [{"latitude": "40.59663", "longitude": "-124.13507"}, {"latitude": "40.59684", "longitude": "-124.1334"}, {"latitude": "40.59894", "longitude": "-124.13191"}, {"latitude": "40.60602", "longitude": "-124.1329"}, {"latitude": "40.62942", "longitude": "-124.15237"}, {"latitude": "40.61576", "longitude": "-124.20049"}, {"latitude": "40.60336", "longitude": "-124.17687"}, {"latitude": "40.60051", "longitude": "-124.16824"}]
649469 October 09, 2019 - 08:13:00 UTC 40.59478 -124.13513 Fortuna 9 [{"latitude": "40.56232", "longitude": "-124.10712"}, {"latitude": "40.57409", "longitude": "-124.10036"}, {"latitude": "40.57608", "longitude": "-124.10012"}, {"latitude": "40.58919", "longitude": "-124.10958"}, {"latitude": "40.59185", "longitude": "-124.12372"}, {"latitude": "40.59365", "longitude": "-124.13476"}, {"latitude": "40.5893", "longitude": "-124.1359"}, {"latitude": "40.58259", "longitude": "-124.13728"}, {"latitude": "40.57457", "longitude": "-124.13618"}, {"latitude": "40.56853", "longitude": "-124.13274"}, {"latitude": "40.56498", "longitude": "-124.1291"}, {"latitude": "40.56286", "longitude": "-124.1172"}]
649472 October 09, 2019 - 08:13:00 UTC 40.57021 -124.12722 Fortuna 9 [{"latitude": "40.56444", "longitude": "-124.13581"}, {"latitude": "40.56523", "longitude": "-124.13021"}, {"latitude": "40.57021", "longitude": "-124.12742"}, {"latitude": "40.57586", "longitude": "-124.14505"}, {"latitude": "40.57203", "longitude": "-124.14839"}, {"latitude": "40.56963", "longitude": "-124.14682"}, {"latitude": "40.56475", "longitude": "-124.13876"}]
649480 October 09, 2019 - 08:13:00 UTC 40.56402 -124.12667 Fortuna 9 [{"latitude": "40.53167", "longitude": "-124.09452"}, {"latitude": "40.53245", "longitude": "-124.08909"}, {"latitude": "40.56346", "longitude": "-124.12434"}, {"latitude": "40.56471", "longitude": "-124.12752"}, {"latitude": "40.56907", "longitude": "-124.14954"}, {"latitude": "40.56403", "longitude": "-124.15313"}, {"latitude": "40.55581", "longitude": "-124.1534"}, {"latitude": "40.54781", "longitude": "-124.14984"}, {"latitude": "40.54409", "longitude": "-124.14117"}, {"latitude": "40.54373", "longitude": "-124.14019"}, {"latitude": "40.53454", "longitude": "-124.10825"}, {"latitude": "40.53271", "longitude": "-124.1001"}]
649487 October 09, 2019 - 08:13:00 UTC 40.57028 -124.12538 Fortuna 9 [{"latitude": "40.56232", "longitude": "-124.10712"}, {"latitude": "40.57409", "longitude": "-124.10036"}, {"latitude": "40.57608", "longitude": "-124.10012"}, {"latitude": "40.57034", "longitude": "-124.12409"}, {"latitude": "40.56992", "longitude": "-124.12479"}, {"latitude": "40.56364", "longitude": "-124.12126"}, {"latitude": "40.56286", "longitude": "-124.1172"}]
649493 October 09, 2019 - 08:13:00 UTC 40.54878 -124.14255 Fortuna 9 [{"latitude": "40.53167", "longitude": "-124.09452"}, {"latitude": "40.53245", "longitude": "-124.08909"}, {"latitude": "40.54381", "longitude": "-124.10297"}, {"latitude": "40.5482", "longitude": "-124.11536"}, {"latitude": "40.54857", "longitude": "-124.13992"}, {"latitude": "40.54852", "longitude": "-124.14262"}, {"latitude": "40.54409", "longitude": "-124.14117"}, {"latitude": "40.54373", "longitude": "-124.14019"}, {"latitude": "40.53454", "longitude": "-124.10825"}, {"latitude": "40.53271", "longitude": "-124.1001"}]
649589 October 09, 2019 - 08:13:00 UTC 40.63531 -124.20121 Fortuna 9 [{"latitude": "40.61704", "longitude": "-124.1806"}, {"latitude": "40.61705", "longitude": "-124.17859"}, {"latitude": "40.61875", "longitude": "-124.16985"}, {"latitude": "40.62401", "longitude": "-124.171"}, {"latitude": "40.67857", "longitude": "-124.18505"}, {"latitude": "40.69365", "longitude": "-124.1894"}, {"latitude": "40.69815", "longitude": "-124.19172"}, {"latitude": "40.70339", "longitude": "-124.20291"}, {"latitude": "40.68915", "longitude": "-124.23628"}, {"latitude": "40.67001", "longitude": "-124.23593"}, {"latitude": "40.61807", "longitude": "-124.18493"}]
649737 October 09, 2019 - 08:13:00 UTC 40.59478 -124.135 Fortuna 9 [{"latitude": "40.59083", "longitude": "-124.14459"}, {"latitude": "40.59117", "longitude": "-124.1376"}, {"latitude": "40.59607", "longitude": "-124.12593"}, {"latitude": "40.60036", "longitude": "-124.12334"}, {"latitude": "40.60172", "longitude": "-124.12787"}, {"latitude": "40.60069", "longitude": "-124.13211"}, {"latitude": "40.59374", "longitude": "-124.14371"}, {"latitude": "40.59211", "longitude": "-124.14593"}]
649754 October 09, 2019 - 08:13:00 UTC 40.59223 -124.14016 Fortuna 9 [{"latitude": "40.57666", "longitude": "-124.15117"}, {"latitude": "40.58771", "longitude": "-124.13735"}, {"latitude": "40.58981", "longitude": "-124.13725"}, {"latitude": "40.59139", "longitude": "-124.13951"}, {"latitude": "40.5963", "longitude": "-124.14692"}, {"latitude": "40.58984", "longitude": "-124.15426"}, {"latitude": "40.58595", "longitude": "-124.15692"}, {"latitude": "40.58493", "longitude": "-124.15748"}, {"latitude": "40.57856", "longitude": "-124.15442"}, {"latitude": "40.5769", "longitude": "-124.15337"}]
649765 October 09, 2019 - 08:13:00 UTC 40.58707 -124.14694 Fortuna 9 [{"latitude": "40.57389", "longitude": "-124.1393"}, {"latitude": "40.5777", "longitude": "-124.13287"}, {"latitude": "40.58418", "longitude": "-124.13873"}, {"latitude": "40.58533", "longitude": "-124.14091"}, {"latitude": "40.58655", "longitude": "-124.14694"}, {"latitude": "40.58591", "longitude": "-124.14904"}, {"latitude": "40.58464", "longitude": "-124.14908"}, {"latitude": "40.5753", "longitude": "-124.14816"}]
649787 October 09, 2019 - 08:13:00 UTC 40.59458 -124.14274 Fortuna 9 [{"latitude": "40.59334", "longitude": "-124.13909"}, {"latitude": "40.59538", "longitude": "-124.13716"}, {"latitude": "40.60821", "longitude": "-124.14022"}, {"latitude": "40.61006", "longitude": "-124.14597"}, {"latitude": "40.60645", "longitude": "-124.15839"}, {"latitude": "40.60143", "longitude": "-124.1658"}, {"latitude": "40.59991", "longitude": "-124.16655"}, {"latitude": "40.59818", "longitude": "-124.16588"}, {"latitude": "40.59345", "longitude": "-124.15605"}]
649795 October 09, 2019 - 08:13:00 UTC 40.59499 -124.1544 Fortuna 9 [{"latitude": "40.59121", "longitude": "-124.1544"}, {"latitude": "40.59213", "longitude": "-124.15367"}, {"latitude": "40.59471", "longitude": "-124.1544"}, {"latitude": "40.59411", "longitude": "-124.15501"}, {"latitude": "40.59235", "longitude": "-124.15619"}]
649802 October 09, 2019 - 08:13:00 UTC 40.59688 -124.15753 Fortuna 9 [{"latitude": "40.58885", "longitude": "-124.15931"}, {"latitude": "40.58903", "longitude": "-124.15724"}, {"latitude": "40.5902", "longitude": "-124.15656"}, {"latitude": "40.59581", "longitude": "-124.15753"}, {"latitude": "40.5931", "longitude": "-124.15918"}]
652569 October 10, 2019 - 11:07:30 UTC 40.56792 -124.12965 Fortuna 9 []
654480 October 11, 2019 - 20:22:15 UTC 40.57131 -124.12787 Fortuna 9 []
655707 October 14, 2019 - 03:24:31 UTC 40.59607 -124.15545 Fortuna 9 []
655763 October 14, 2019 - 08:19:25 UTC 40.57072 -124.12675 Fortuna 9 []
665853 October 17, 2019 - 19:48:27 UTC 40.55487 -124.14749 Fortuna 9 []
667094 October 17, 2019 - 23:44:05 UTC 40.6084 -124.18606 Fortuna 9 []
667224 October 18, 2019 - 01:04:00 UTC 40.59298 -124.15446 Fortuna 9 []
676006 October 21, 2019 - 16:57:44 UTC 40.5833 -124.14696 Fortuna 9 []
676373 October 21, 2019 - 21:35:02 UTC 40.59594 -124.15652 Fortuna 9 []
676510 October 22, 2019 - 01:54:15 UTC 40.61233 -124.16806 Fortuna 9 []
677430 October 23, 2019 - 16:03:00 UTC 40.54878 -124.14255 Fortuna 9 [{"latitude": "40.53167", "longitude": "-124.09452"}, {"latitude": "40.53245", "longitude": "-124.08909"}, {"latitude": "40.54381", "longitude": "-124.10297"}, {"latitude": "40.5482", "longitude": "-124.11536"}, {"latitude": "40.54857", "longitude": "-124.13992"}, {"latitude": "40.54852", "longitude": "-124.14262"}, {"latitude": "40.54409", "longitude": "-124.14117"}, {"latitude": "40.54373", "longitude": "-124.14019"}, {"latitude": "40.53454", "longitude": "-124.10825"}, {"latitude": "40.53271", "longitude": "-124.1001"}]
679743 October 24, 2019 - 21:01:03 UTC 40.59374 -124.14371 Fortuna 9 []
680471 October 25, 2019 - 19:49:33 UTC 40.59632 -124.15921 Fortuna 9 []
682051 October 27, 2019 - 01:29:45 UTC 40.61277 -124.1749 Fortuna 9 []
685315 October 27, 2019 - 05:58:56 UTC 40.52377 -124.15028 Fortuna 9 []
685316 October 27, 2019 - 05:58:56 UTC 40.52296 -124.14987 Fortuna 9 [{"latitude": "40.51366", "longitude": "-124.13717"}, {"latitude": "40.51559", "longitude": "-124.13952"}, {"latitude": "40.51877", "longitude": "-124.14513"}, {"latitude": "40.52125", "longitude": "-124.15009"}, {"latitude": "40.52123", "longitude": "-124.15303"}, {"latitude": "40.51787", "longitude": "-124.15316"}, {"latitude": "40.51449", "longitude": "-124.14786"}]
685317 October 27, 2019 - 05:58:56 UTC 40.52447 -124.14892 Fortuna 9 []
685318 October 27, 2019 - 05:58:56 UTC 40.5195 -124.1434 Fortuna 9 [{"latitude": "40.52027", "longitude": "-124.14249"}, {"latitude": "40.52108", "longitude": "-124.14424"}, {"latitude": "40.52095", "longitude": "-124.14512"}]
685342 October 27, 2019 - 05:58:56 UTC 40.54898 -124.11761 Fortuna 9 []
685343 October 27, 2019 - 05:58:56 UTC 40.55031 -124.11662 Fortuna 9 []
685344 October 27, 2019 - 05:58:56 UTC 40.55482 -124.11406 Fortuna 9 []
685413 October 27, 2019 - 06:07:00 UTC 40.58466 -124.11614 Fortuna 9 []
685961 October 27, 2019 - 05:42:00 UTC 40.59478 -124.13513 Fortuna 9 [{"latitude": "40.53167", "longitude": "-124.09452"}, {"latitude": "40.53245", "longitude": "-124.08909"}, {"latitude": "40.57608", "longitude": "-124.10012"}, {"latitude": "40.58919", "longitude": "-124.10958"}, {"latitude": "40.59185", "longitude": "-124.12372"}, {"latitude": "40.59365", "longitude": "-124.13476"}, {"latitude": "40.57203", "longitude": "-124.14839"}, {"latitude": "40.56403", "longitude": "-124.15313"}, {"latitude": "40.55581", "longitude": "-124.1534"}, {"latitude": "40.54781", "longitude": "-124.14984"}, {"latitude": "40.54409", "longitude": "-124.14117"}, {"latitude": "40.54373", "longitude": "-124.14019"}, {"latitude": "40.53454", "longitude": "-124.10825"}, {"latitude": "40.53271", "longitude": "-124.1001"}]
685974 October 27, 2019 - 05:42:00 UTC 40.59478 -124.135 Fortuna 9 [{"latitude": "40.57389", "longitude": "-124.1393"}, {"latitude": "40.5777", "longitude": "-124.13287"}, {"latitude": "40.60036", "longitude": "-124.12334"}, {"latitude": "40.60821", "longitude": "-124.14022"}, {"latitude": "40.61006", "longitude": "-124.14597"}, {"latitude": "40.60645", "longitude": "-124.15839"}, {"latitude": "40.60143", "longitude": "-124.1658"}, {"latitude": "40.59991", "longitude": "-124.16655"}, {"latitude": "40.59818", "longitude": "-124.16588"}, {"latitude": "40.57856", "longitude": "-124.15442"}, {"latitude": "40.5769", "longitude": "-124.15337"}, {"latitude": "40.5753", "longitude": "-124.14816"}]
685984 October 27, 2019 - 05:42:00 UTC 40.59478 -124.13505 Fortuna 9 [{"latitude": "40.59663", "longitude": "-124.13507"}, {"latitude": "40.59684", "longitude": "-124.1334"}, {"latitude": "40.59894", "longitude": "-124.13191"}, {"latitude": "40.60602", "longitude": "-124.1329"}, {"latitude": "40.62942", "longitude": "-124.15237"}, {"latitude": "40.61576", "longitude": "-124.20049"}, {"latitude": "40.60336", "longitude": "-124.17687"}, {"latitude": "40.60051", "longitude": "-124.16824"}]
691851 October 28, 2019 - 19:53:00 UTC 40.59782 -124.14904 Fortuna 9 []
691964 October 28, 2019 - 20:48:01 UTC 40.59852 -124.14361 Fortuna 9 []
699796 November 05, 2019 - 15:59:34 UTC 40.56444 -124.13581 Fortuna 9 []
707475 November 15, 2019 - 17:47:45 UTC 40.56718 -124.13393 Fortuna 9 []
707828 November 15, 2019 - 21:59:14 UTC 40.56889 -124.14201 Fortuna 9 []
708635 November 17, 2019 - 17:22:00 UTC 40.59223 -124.14016 Fortuna 9 [{"latitude": "40.57389", "longitude": "-124.1393"}, {"latitude": "40.5777", "longitude": "-124.13287"}, {"latitude": "40.58981", "longitude": "-124.13725"}, {"latitude": "40.59139", "longitude": "-124.13951"}, {"latitude": "40.5963", "longitude": "-124.14692"}, {"latitude": "40.58984", "longitude": "-124.15426"}, {"latitude": "40.58595", "longitude": "-124.15692"}, {"latitude": "40.58493", "longitude": "-124.15748"}, {"latitude": "40.57856", "longitude": "-124.15442"}, {"latitude": "40.5769", "longitude": "-124.15337"}, {"latitude": "40.5753", "longitude": "-124.14816"}]
708639 November 17, 2019 - 17:20:00 UTC 40.58859 -124.1487 Fortuna 9 [{"latitude": "40.58741", "longitude": "-124.14934"}, {"latitude": "40.58859", "longitude": "-124.14922"}, {"latitude": "40.59012", "longitude": "-124.15026"}, {"latitude": "40.59053", "longitude": "-124.15144"}, {"latitude": "40.59055", "longitude": "-124.15331"}, {"latitude": "40.58984", "longitude": "-124.15426"}, {"latitude": "40.58944", "longitude": "-124.15439"}]
709236 November 18, 2019 - 18:10:44 UTC 40.594 -124.13549 Fortuna 9 []
709492 November 18, 2019 - 22:46:04 UTC 40.59603 -124.14509 Fortuna 9 []
710416 November 20, 2019 - 00:25:46 UTC 40.61038 -124.17982 Fortuna 9 []
710436 November 20, 2019 - 00:57:00 UTC 40.59966 -124.15669 Fortuna 9 []
711688 November 20, 2019 - 21:58:04 UTC 40.60542 -124.15409 Fortuna 9 []
712044 November 21, 2019 - 16:55:59 UTC 40.62952 -124.1867 Fortuna 9 []
712045 November 21, 2019 - 16:55:59 UTC 40.62955 -124.18755 Fortuna 9 []
712046 November 21, 2019 - 16:55:59 UTC 40.62437 -124.18091 Fortuna 9 []
712105 November 21, 2019 - 17:09:35 UTC 40.58731 -124.13536 Fortuna 9 []
712117 November 21, 2019 - 17:20:00 UTC 40.59997 -124.15235 Fortuna 9 []
712120 November 21, 2019 - 17:21:27 UTC 40.5674 -124.13955 Fortuna 9 []
712121 November 21, 2019 - 17:21:00 UTC 40.57861 -124.13432 Fortuna 9 []
712122 November 21, 2019 - 17:21:00 UTC 40.5878 -124.1264 Fortuna 9 []
712126 November 21, 2019 - 17:22:00 UTC 40.6048 -124.13552 Fortuna 9 []
712128 November 21, 2019 - 17:22:00 UTC 40.60536 -124.17391 Fortuna 9 []
712130 November 21, 2019 - 17:23:00 UTC 40.58812 -124.14178 Fortuna 9 []
712131 November 21, 2019 - 17:23:00 UTC 40.53281 -124.09476 Fortuna 9 []
712133 November 21, 2019 - 17:23:11 UTC 40.56814 -124.12274 Fortuna 9 [{"latitude": "40.56286", "longitude": "-124.1172"}, {"latitude": "40.56436", "longitude": "-124.11628"}, {"latitude": "40.56777", "longitude": "-124.12322"}, {"latitude": "40.56667", "longitude": "-124.12275"}, {"latitude": "40.56364", "longitude": "-124.12126"}]
712134 November 21, 2019 - 17:23:30 UTC 40.5941 -124.14284 Fortuna 9 []
712135 November 21, 2019 - 17:23:32 UTC 40.58466 -124.11614 Fortuna 9 []
712136 November 21, 2019 - 17:23:00 UTC 40.60642 -124.17658 Fortuna 9 []
712137 November 21, 2019 - 17:23:49 UTC 40.59966 -124.15669 Fortuna 9 []
712139 November 21, 2019 - 17:24:35 UTC 40.57911 -124.1274 Fortuna 9 []
712140 November 21, 2019 - 17:24:41 UTC 40.5916 -124.14244 Fortuna 9 []
712141 November 21, 2019 - 17:24:41 UTC 40.5621 -124.12303 Fortuna 9 []
712142 November 21, 2019 - 17:24:53 UTC 40.56809 -124.13394 Fortuna 9 []
712143 November 21, 2019 - 17:25:07 UTC 40.59412 -124.15753 Fortuna 9 []
712144 November 21, 2019 - 17:25:00 UTC 40.59581 -124.15753 Fortuna 9 []
712145 November 21, 2019 - 17:25:00 UTC 40.59664 -124.15439 Fortuna 9 []
712146 November 21, 2019 - 17:25:00 UTC 40.5963 -124.14692 Fortuna 9 []
712147 November 21, 2019 - 17:25:59 UTC 40.55936 -124.12337 Fortuna 9 []
712148 November 21, 2019 - 17:26:07 UTC 40.59937 -124.15979 Fortuna 9 []
712149 November 21, 2019 - 17:26:00 UTC 40.61145 -124.1769 Fortuna 9 []
712151 November 21, 2019 - 17:26:00 UTC 40.57097 -124.13425 Fortuna 9 []
712153 November 21, 2019 - 17:26:36 UTC 40.58398 -124.14368 Fortuna 9 []
712154 November 21, 2019 - 17:27:00 UTC 40.57034 -124.12409 Fortuna 9 []
712156 November 21, 2019 - 17:28:17 UTC 40.60633 -124.1748 Fortuna 9 []
712157 November 21, 2019 - 17:28:00 UTC 40.56426 -124.12842 Fortuna 9 []
712158 November 21, 2019 - 17:28:00 UTC 40.57795 -124.13145 Fortuna 9 []
712161 November 21, 2019 - 17:30:41 UTC 40.59364 -124.14267 Fortuna 9 []
712166 November 21, 2019 - 17:35:19 UTC 40.58278 -124.13676 Fortuna 9 []
712186 November 21, 2019 - 17:50:48 UTC 40.57966 -124.13101 Fortuna 9 []
712239 November 21, 2019 - 18:43:04 UTC 40.56133 -124.14543 Fortuna 9 []

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