outages

1,620 rows where regionName = 35

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
645664 October 06, 2019 - 21:43:07 UTC 36.79461 -119.88031 Fresno 35 []
645666 October 06, 2019 - 21:44:36 UTC 36.79293 -119.87903 Fresno 35 []
645753 October 06, 2019 - 21:43:07 UTC 36.79478 -119.88031 Fresno 35 []
645768 October 07, 2019 - 09:14:26 UTC 36.82255 -119.76976 Fresno 35 []
645896 October 07, 2019 - 16:01:48 UTC 36.66301 -119.96952 Fresno 35 []
645898 October 07, 2019 - 16:02:00 UTC 36.72058 -119.90106 Fresno 35 []
645907 October 07, 2019 - 16:03:00 UTC 36.80688 -119.88955 Fresno 35 []
645916 October 07, 2019 - 16:11:59 UTC 36.80792 -119.75731 Fresno 35 []
645935 October 07, 2019 - 16:22:01 UTC 36.76975 -119.80802 Fresno 35 []
646007 October 07, 2019 - 17:12:15 UTC 36.76436 -119.90756 Fresno 35 []
646008 October 07, 2019 - 17:12:26 UTC 36.76757 -119.73486 Fresno 35 []
646014 October 07, 2019 - 17:14:27 UTC 36.61232 -119.85532 Fresno 35 []
646019 October 07, 2019 - 17:16:49 UTC 36.76629 -119.80095 Fresno 35 []
646075 October 07, 2019 - 18:08:34 UTC 36.77894 -119.80062 Fresno 35 []
646076 October 07, 2019 - 18:08:40 UTC 36.77881 -119.80023 Fresno 35 []
646125 October 07, 2019 - 18:29:21 UTC 36.77811 -119.80262 Fresno 35 []
646130 October 07, 2019 - 18:36:02 UTC 36.79445 -119.87904 Fresno 35 []
646149 October 07, 2019 - 18:57:29 UTC 36.80224 -119.73561 Fresno 35 []
646188 October 07, 2019 - 19:56:13 UTC 36.78935 -119.6729 Fresno 35 []
646333 October 07, 2019 - 20:39:17 UTC 36.73449 -119.69222 Fresno 35 []
646513 October 07, 2019 - 20:55:04 UTC 36.77086 -119.80097 Fresno 35 []
646653 October 07, 2019 - 21:08:08 UTC 36.79198 -119.83231 Fresno 35 []
646837 October 07, 2019 - 22:02:30 UTC 36.75756 -119.84813 Fresno 35 []
646842 October 07, 2019 - 22:07:46 UTC 36.83003 -119.82595 Fresno 35 [{"latitude": "36.83007", "longitude": "-119.81955"}, {"latitude": "36.83008", "longitude": "-119.81892"}, {"latitude": "36.83066", "longitude": "-119.81828"}, {"latitude": "36.83317", "longitude": "-119.81867"}, {"latitude": "36.83315", "longitude": "-119.82306"}, {"latitude": "36.83258", "longitude": "-119.82312"}, {"latitude": "36.83179", "longitude": "-119.82313"}, {"latitude": "36.83097", "longitude": "-119.8231"}, {"latitude": "36.83007", "longitude": "-119.8209"}]
646889 October 07, 2019 - 22:53:57 UTC 36.77907 -119.79907 Fresno 35 []
646894 October 07, 2019 - 23:00:32 UTC 36.7613 -119.80521 Fresno 35 []
646900 October 07, 2019 - 23:05:08 UTC 36.69113 -119.7918 Fresno 35 []
646942 October 08, 2019 - 00:08:00 UTC 36.83315 -119.82306 Fresno 35 []
646957 October 08, 2019 - 00:30:34 UTC 36.74745 -119.78886 Fresno 35 []
646971 October 08, 2019 - 01:10:57 UTC 36.7578 -119.75132 Fresno 35 []
647006 October 08, 2019 - 03:26:39 UTC 36.7871 -119.77692 Fresno 35 []
647007 October 08, 2019 - 03:31:38 UTC 36.79655 -119.84395 Fresno 35 []
647035 October 08, 2019 - 06:58:12 UTC 36.83954 -119.81122 Fresno 35 []
647091 October 08, 2019 - 15:00:31 UTC 36.73221 -119.75443 Fresno 35 [{"latitude": "36.73314", "longitude": "-119.754"}, {"latitude": "36.7336", "longitude": "-119.75399"}, {"latitude": "36.73532", "longitude": "-119.75396"}, {"latitude": "36.73521", "longitude": "-119.75424"}]
647154 October 08, 2019 - 15:35:30 UTC 36.66908 -119.65457 Fresno 35 []
647193 October 08, 2019 - 15:43:13 UTC 36.56251 -119.76079 Fresno 35 []
647266 October 08, 2019 - 15:54:41 UTC 36.82171 -119.76543 Fresno 35 []
647318 October 08, 2019 - 16:25:11 UTC 36.76092 -119.78113 Fresno 35 []
647359 October 08, 2019 - 17:05:54 UTC 36.61232 -119.85532 Fresno 35 []
647421 October 08, 2019 - 18:08:19 UTC 36.75674 -119.73473 Fresno 35 []
647490 October 08, 2019 - 19:51:53 UTC 36.82121 -119.77569 Fresno 35 []
647534 October 08, 2019 - 20:47:58 UTC 36.74257 -119.8219 Fresno 35 []
647555 October 08, 2019 - 21:27:15 UTC 36.85318 -119.76448 Fresno 35 []
647594 October 08, 2019 - 22:49:25 UTC 36.85318 -119.76448 Fresno 35 []
647597 October 08, 2019 - 22:53:52 UTC 36.757 -119.81363 Fresno 35 []
647668 October 09, 2019 - 00:25:56 UTC 36.74994 -119.86113 Fresno 35 []
647694 October 09, 2019 - 01:29:08 UTC 36.77158 -119.99722 Fresno 35 []
647802 October 09, 2019 - 06:40:20 UTC 36.83364 -119.7642 Fresno 35 []
649067 October 09, 2019 - 09:26:00 UTC 36.73065 -119.86419 Fresno 35 []
650596 October 09, 2019 - 14:07:45 UTC 36.77081 -119.78044 Fresno 35 []
650814 October 09, 2019 - 16:42:43 UTC 36.77913 -119.75244 Fresno 35 []
650824 October 09, 2019 - 16:52:00 UTC 36.60585 -119.77346 Fresno 35 [{"latitude": "36.52174", "longitude": "-119.73231"}, {"latitude": "36.52241", "longitude": "-119.71902"}, {"latitude": "36.54359", "longitude": "-119.69644"}, {"latitude": "36.56201", "longitude": "-119.68525"}, {"latitude": "36.65611", "longitude": "-119.75396"}, {"latitude": "36.66134", "longitude": "-119.76176"}, {"latitude": "36.66137", "longitude": "-119.7631"}, {"latitude": "36.66132", "longitude": "-119.76495"}, {"latitude": "36.65714", "longitude": "-119.79433"}, {"latitude": "36.65598", "longitude": "-119.79905"}, {"latitude": "36.63145", "longitude": "-119.81782"}, {"latitude": "36.62454", "longitude": "-119.82238"}, {"latitude": "36.60351", "longitude": "-119.8239"}, {"latitude": "36.56856", "longitude": "-119.82226"}, {"latitude": "36.53273", "longitude": "-119.77103"}, {"latitude": "36.52833", "longitude": "-119.76415"}, {"latitude": "36.52196", "longitude": "-119.73685"}]
650868 October 09, 2019 - 17:47:44 UTC 36.74729 -119.77548 Fresno 35 []
650914 October 09, 2019 - 18:33:49 UTC 36.74019 -119.74941 Fresno 35 []
651089 October 09, 2019 - 20:49:04 UTC 36.64046 -119.7638 Fresno 35 []
651275 October 09, 2019 - 22:33:01 UTC 36.77064 -119.78509 Fresno 35 []
651454 October 09, 2019 - 22:57:12 UTC 36.81547 -119.96905 Fresno 35 []
652553 October 10, 2019 - 09:44:00 UTC 36.83712 -119.88545 Fresno 35 []
652629 October 10, 2019 - 14:23:40 UTC 36.7517 -119.84216 Fresno 35 []
652636 October 10, 2019 - 14:40:42 UTC 36.83024 -119.78732 Fresno 35 []
652655 October 10, 2019 - 15:04:24 UTC 36.7513 -119.73136 Fresno 35 []
652722 October 10, 2019 - 16:10:05 UTC 36.80171 -119.75661 Fresno 35 [{"latitude": "36.80207", "longitude": "-119.75661"}, {"latitude": "36.80339", "longitude": "-119.7566"}, {"latitude": "36.8025", "longitude": "-119.75661"}]
653295 October 10, 2019 - 20:10:15 UTC 36.76225 -119.79035 Fresno 35 []
653307 October 10, 2019 - 20:14:03 UTC 36.77789 -119.82539 Fresno 35 []
653435 October 10, 2019 - 21:39:02 UTC 36.76642 -119.72299 Fresno 35 []
653591 October 10, 2019 - 23:04:34 UTC 36.77547 -119.77578 Fresno 35 []
653650 October 10, 2019 - 23:50:34 UTC 36.75274 -119.76343 Fresno 35 []
653969 October 11, 2019 - 04:33:27 UTC 36.7509 -119.76119 Fresno 35 []
653979 October 11, 2019 - 04:48:33 UTC 36.73606 -119.98154 Fresno 35 []
654077 October 11, 2019 - 12:05:22 UTC 36.82267 -119.80938 Fresno 35 []
654082 October 11, 2019 - 13:04:56 UTC 36.82278 -119.80878 Fresno 35 []
654115 October 11, 2019 - 14:46:27 UTC 36.83853 -119.76508 Fresno 35 []
654118 October 11, 2019 - 14:49:02 UTC 36.74049 -119.69772 Fresno 35 []
654130 October 11, 2019 - 15:04:54 UTC 36.75356 -119.76968 Fresno 35 []
654166 October 11, 2019 - 15:46:26 UTC 36.81337 -119.81324 Fresno 35 []
654214 October 11, 2019 - 16:01:44 UTC 36.71661 -119.75453 Fresno 35 []
654267 October 11, 2019 - 16:41:47 UTC 36.6708 -119.73458 Fresno 35 []
654298 October 11, 2019 - 17:07:29 UTC 36.75845 -119.84408 Fresno 35 []
654357 October 11, 2019 - 18:06:40 UTC 36.81151 -119.77417 Fresno 35 []
654416 October 11, 2019 - 19:11:42 UTC 36.74477 -119.80098 Fresno 35 []
654476 October 11, 2019 - 20:15:38 UTC 36.80423 -119.82243 Fresno 35 []
654503 October 11, 2019 - 20:48:40 UTC 36.84992 -119.85795 Fresno 35 []
654527 October 11, 2019 - 21:03:32 UTC 36.73832 -119.7753 Fresno 35 []
654611 October 11, 2019 - 22:00:24 UTC 36.86464 -119.74315 Fresno 35 []
654613 October 11, 2019 - 22:00:38 UTC 36.62646 -119.76384 Fresno 35 []
654622 October 11, 2019 - 22:06:38 UTC 36.78176 -119.79513 Fresno 35 []
654700 October 11, 2019 - 23:31:00 UTC 36.79947 -119.73921 Fresno 35 []
654703 October 11, 2019 - 23:31:00 UTC 36.80411 -119.75375 Fresno 35 []
654707 October 11, 2019 - 23:30:00 UTC 36.80501 -119.74741 Fresno 35 []
654708 October 11, 2019 - 23:31:00 UTC 36.80224 -119.73807 Fresno 35 []
654716 October 11, 2019 - 23:31:00 UTC 36.79928 -119.74446 Fresno 35 []
654717 October 11, 2019 - 23:32:00 UTC 36.8259 -119.75408 Fresno 35 [{"latitude": "36.82401", "longitude": "-119.7573"}, {"latitude": "36.82604", "longitude": "-119.75448"}, {"latitude": "36.82604", "longitude": "-119.7563"}, {"latitude": "36.82602", "longitude": "-119.75827"}]
654723 October 11, 2019 - 23:33:00 UTC 36.82029 -119.75568 Fresno 35 []
654724 October 11, 2019 - 23:33:00 UTC 36.81962 -119.75408 Fresno 35 [{"latitude": "36.81962", "longitude": "-119.75488"}, {"latitude": "36.81968", "longitude": "-119.75449"}, {"latitude": "36.81965", "longitude": "-119.75684"}]
654725 October 11, 2019 - 23:34:00 UTC 36.81218 -119.75632 Fresno 35 [{"latitude": "36.8106", "longitude": "-119.75694"}, {"latitude": "36.81116", "longitude": "-119.75679"}, {"latitude": "36.81188", "longitude": "-119.75663"}, {"latitude": "36.81265", "longitude": "-119.75699"}, {"latitude": "36.8108", "longitude": "-119.75762"}]
654726 October 11, 2019 - 23:35:00 UTC 36.8213 -119.75407 Fresno 35 [{"latitude": "36.82068", "longitude": "-119.75445"}, {"latitude": "36.82161", "longitude": "-119.75436"}, {"latitude": "36.8228", "longitude": "-119.75436"}, {"latitude": "36.82295", "longitude": "-119.75495"}, {"latitude": "36.82261", "longitude": "-119.75522"}, {"latitude": "36.82149", "longitude": "-119.75592"}]
654728 October 11, 2019 - 23:35:48 UTC 36.83013 -119.76656 Fresno 35 [{"latitude": "36.82942", "longitude": "-119.76521"}, {"latitude": "36.82943", "longitude": "-119.76391"}, {"latitude": "36.82992", "longitude": "-119.76406"}, {"latitude": "36.82991", "longitude": "-119.76623"}, {"latitude": "36.82942", "longitude": "-119.76644"}]
654749 October 11, 2019 - 23:46:00 UTC 36.81157 -119.75731 Fresno 35 []
654925 October 12, 2019 - 03:06:38 UTC 36.75877 -119.71915 Fresno 35 []
654978 October 12, 2019 - 05:46:00 UTC 36.76537 -119.80401 Fresno 35 []

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