outages

1,620 rows where regionName = 35 sorted by outageDevices

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices ▼
633503 October 01, 2019 - 06:59:16 UTC 36.76072 -119.7904 Fresno 35 []
633512 October 01, 2019 - 10:13:25 UTC 36.81268 -119.76425 Fresno 35 []
633775 October 01, 2019 - 15:46:40 UTC 36.77528 -119.8636 Fresno 35 []
633849 October 01, 2019 - 16:32:19 UTC 36.82228 -119.80053 Fresno 35 []
633917 October 01, 2019 - 17:26:04 UTC 36.77444 -119.76961 Fresno 35 []
633939 October 01, 2019 - 17:32:00 UTC 36.80194 -119.76819 Fresno 35 []
634009 October 01, 2019 - 18:44:53 UTC 36.78797 -119.81413 Fresno 35 []
634693 October 01, 2019 - 20:10:41 UTC 36.82255 -119.76976 Fresno 35 []
634753 October 01, 2019 - 20:26:21 UTC 36.61242 -119.89452 Fresno 35 []
634815 October 01, 2019 - 20:33:03 UTC 36.82298 -119.7708 Fresno 35 []
635014 October 01, 2019 - 22:33:06 UTC 36.82842 -119.77457 Fresno 35 []
635173 October 01, 2019 - 22:57:41 UTC 36.82121 -119.77569 Fresno 35 []
635233 October 01, 2019 - 23:02:43 UTC 36.81232 -119.80543 Fresno 35 []
635253 October 01, 2019 - 23:03:32 UTC 36.8126 -119.80657 Fresno 35 []
635254 October 01, 2019 - 23:04:17 UTC 36.81185 -119.80442 Fresno 35 []
635396 October 02, 2019 - 00:13:22 UTC 36.71958 -119.78908 Fresno 35 []
635417 October 02, 2019 - 00:43:58 UTC 36.79276 -119.77566 Fresno 35 []
635759 October 02, 2019 - 15:04:00 UTC 36.72548 -119.76139 Fresno 35 []
635766 October 02, 2019 - 15:07:47 UTC 36.88405 -119.76749 Fresno 35 []
635856 October 02, 2019 - 16:02:44 UTC 36.76195 -119.80744 Fresno 35 []
636076 October 02, 2019 - 16:49:32 UTC 36.88129 -119.76955 Fresno 35 []
636673 October 02, 2019 - 17:52:22 UTC 36.7137 -119.88514 Fresno 35 []
637033 October 02, 2019 - 19:02:39 UTC 36.75499 -119.78466 Fresno 35 []
637154 October 02, 2019 - 19:16:20 UTC 36.75251 -119.83998 Fresno 35 []
638253 October 02, 2019 - 21:47:53 UTC 36.77995 -119.68884 Fresno 35 []
638516 October 02, 2019 - 22:24:39 UTC 36.75403 -119.81137 Fresno 35 []
638805 October 03, 2019 - 00:17:29 UTC 36.65853 -119.82656 Fresno 35 []
638828 October 03, 2019 - 00:56:03 UTC 36.72339 -119.743 Fresno 35 []
638833 October 03, 2019 - 01:04:32 UTC 36.79118 -119.94765 Fresno 35 []
638894 October 03, 2019 - 05:02:32 UTC 36.78133 -119.78128 Fresno 35 []
638956 October 03, 2019 - 13:27:36 UTC 36.76762 -119.65902 Fresno 35 []
639060 October 03, 2019 - 15:30:00 UTC 36.7154 -119.80896 Fresno 35 []
639142 October 03, 2019 - 16:00:03 UTC 36.76561 -119.82565 Fresno 35 []
639180 October 03, 2019 - 16:11:17 UTC 36.79878 -119.85831 Fresno 35 []
639204 October 03, 2019 - 16:26:00 UTC 36.74824 -119.73927 Fresno 35 []
639833 October 03, 2019 - 18:19:11 UTC 36.76109 -119.71469 Fresno 35 []
640117 October 03, 2019 - 19:00:45 UTC 36.67364 -119.92606 Fresno 35 []
640533 October 03, 2019 - 19:54:00 UTC 36.65099 -119.83546 Fresno 35 []
641116 October 03, 2019 - 21:20:49 UTC 36.77522 -119.69416 Fresno 35 []
641713 October 03, 2019 - 23:21:32 UTC 36.7575 -119.91622 Fresno 35 []
642173 October 04, 2019 - 02:17:10 UTC 36.73548 -119.74892 Fresno 35 []
642202 October 04, 2019 - 03:49:23 UTC 36.81879 -119.75726 Fresno 35 []
642211 October 04, 2019 - 04:51:22 UTC 36.739 -119.733 Fresno 35 []
642234 October 04, 2019 - 11:48:14 UTC 36.76657 -119.7996 Fresno 35 []
642243 October 04, 2019 - 13:52:48 UTC 36.75183 -119.76292 Fresno 35 []
642244 October 04, 2019 - 13:52:47 UTC 36.75089 -119.76336 Fresno 35 []
642256 October 04, 2019 - 14:35:06 UTC 36.67211 -119.7089 Fresno 35 []
642313 October 04, 2019 - 15:23:04 UTC 36.67102 -119.70976 Fresno 35 []
642536 October 04, 2019 - 15:42:39 UTC 36.70272 -119.87632 Fresno 35 []
642954 October 04, 2019 - 16:30:35 UTC 36.76548 -119.78564 Fresno 35 []
642993 October 04, 2019 - 16:30:56 UTC 36.77819 -119.79351 Fresno 35 []
643275 October 04, 2019 - 17:05:59 UTC 36.84112 -119.86886 Fresno 35 []
643293 October 04, 2019 - 17:09:14 UTC 36.74548 -119.76365 Fresno 35 []
643407 October 04, 2019 - 17:29:23 UTC 36.72517 -119.80638 Fresno 35 []
643420 October 04, 2019 - 17:40:12 UTC 36.82266 -119.88615 Fresno 35 []
643461 October 04, 2019 - 18:16:28 UTC 36.84397 -119.79908 Fresno 35 []
643513 October 04, 2019 - 19:20:51 UTC 36.80895 -119.80606 Fresno 35 []
643688 October 04, 2019 - 20:26:07 UTC 36.79547 -119.75959 Fresno 35 []
643697 October 04, 2019 - 20:47:02 UTC 36.72745 -119.79071 Fresno 35 []
643762 October 04, 2019 - 22:57:22 UTC 36.69234 -119.74955 Fresno 35 []
643827 October 05, 2019 - 01:13:23 UTC 36.74546 -119.73738 Fresno 35 []
643885 October 05, 2019 - 05:54:42 UTC 36.71846 -119.80974 Fresno 35 []
643891 October 05, 2019 - 06:56:01 UTC 36.78006 -119.836 Fresno 35 []
643910 October 05, 2019 - 11:53:55 UTC 36.71846 -119.80974 Fresno 35 []
644031 October 05, 2019 - 15:45:48 UTC 36.71537 -119.79537 Fresno 35 []
644036 October 05, 2019 - 13:49:37 UTC 36.78549 -119.77607 Fresno 35 []
644038 October 05, 2019 - 15:25:00 UTC 36.78549 -119.77539 Fresno 35 []
644174 October 05, 2019 - 16:10:02 UTC 36.71846 -119.80974 Fresno 35 []
644193 October 05, 2019 - 16:14:48 UTC 36.71543 -119.79474 Fresno 35 []
644194 October 05, 2019 - 16:14:50 UTC 36.7855 -119.77761 Fresno 35 []
644534 October 05, 2019 - 17:21:58 UTC 36.78527 -119.75314 Fresno 35 []
644683 October 05, 2019 - 18:00:23 UTC 36.78527 -119.75314 Fresno 35 []
644689 October 05, 2019 - 18:12:00 UTC 36.7855 -119.77761 Fresno 35 []
644715 October 05, 2019 - 19:19:53 UTC 36.77262 -119.80932 Fresno 35 []
644719 October 05, 2019 - 19:25:00 UTC 36.71846 -119.80974 Fresno 35 []
644755 October 05, 2019 - 20:49:51 UTC 36.71846 -119.80974 Fresno 35 []
644833 October 05, 2019 - 22:11:58 UTC 36.72813 -119.73869 Fresno 35 []
645041 October 06, 2019 - 00:05:54 UTC 36.73561 -119.86642 Fresno 35 []
645118 October 06, 2019 - 01:34:55 UTC 36.80535 -119.83892 Fresno 35 []
645119 October 06, 2019 - 01:36:51 UTC 36.80476 -119.83964 Fresno 35 []
645145 October 06, 2019 - 03:27:16 UTC 36.77436 -119.8348 Fresno 35 []
645149 October 06, 2019 - 03:27:16 UTC 36.77436 -119.8348 Fresno 35 []
645506 October 06, 2019 - 08:21:19 UTC 36.80268 -119.75838 Fresno 35 []
645528 October 06, 2019 - 14:19:19 UTC 36.83168 -119.91039 Fresno 35 []
645591 October 06, 2019 - 17:09:27 UTC 36.72762 -119.72739 Fresno 35 []
645601 October 06, 2019 - 17:57:13 UTC 36.81853 -119.80665 Fresno 35 []
645617 October 06, 2019 - 19:22:03 UTC 36.79614 -119.85041 Fresno 35 []
645634 October 06, 2019 - 20:01:01 UTC 36.80901 -119.79979 Fresno 35 []
645653 October 06, 2019 - 20:00:00 UTC 36.80881 -119.79881 Fresno 35 []
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 []

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