outages

297 rows where regionName = 33

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
690255 October 27, 2019 - 23:36:56 UTC 37.86452 -122.07842 Walnut Creek 33 []
690523 October 28, 2019 - 01:12:20 UTC 37.86999 -122.02049 Walnut Creek 33 []
690531 October 28, 2019 - 01:17:01 UTC 37.89474 -122.07015 Walnut Creek 33 []
690577 October 28, 2019 - 01:30:42 UTC 37.90112 -122.07152 Walnut Creek 33 []
690757 October 28, 2019 - 02:27:14 UTC 37.86782 -122.02694 Walnut Creek 33 []
690910 October 28, 2019 - 04:12:02 UTC 37.89922 -122.06453 Walnut Creek 33 []
690937 October 28, 2019 - 04:27:27 UTC 37.93119 -122.0439 Walnut Creek 33 []
691328 October 28, 2019 - 14:39:11 UTC 37.89914 -122.06516 Walnut Creek 33 []
691403 October 28, 2019 - 15:42:58 UTC 37.88349 -122.06082 Walnut Creek 33 []
691495 October 28, 2019 - 16:17:32 UTC 37.89903 -122.06128 Walnut Creek 33 []
691569 October 28, 2019 - 16:55:51 UTC 37.92281 -122.04664 Walnut Creek 33 []
691571 October 28, 2019 - 16:57:38 UTC 37.90024 -122.06891 Walnut Creek 33 []
691607 October 28, 2019 - 17:28:00 UTC 37.86446 -122.07839 Walnut Creek 33 []
691658 October 28, 2019 - 17:55:01 UTC 37.89125 -122.04036 Walnut Creek 33 []
691728 October 28, 2019 - 18:33:46 UTC 37.93362 -122.05208 Walnut Creek 33 []
691777 October 28, 2019 - 19:09:19 UTC 37.90117 -122.04876 Walnut Creek 33 []
691959 October 27, 2019 - 03:49:44 UTC 37.92376 -122.01304 Walnut Creek 33 [{"latitude": "37.92375", "longitude": "-122.01545"}, {"latitude": "37.92431", "longitude": "-122.01341"}, {"latitude": "37.92479", "longitude": "-122.01375"}, {"latitude": "37.92516", "longitude": "-122.01415"}, {"latitude": "37.92399", "longitude": "-122.01623"}]
691965 October 28, 2019 - 20:48:28 UTC 37.90087 -122.04968 Walnut Creek 33 []
691990 October 27, 2019 - 03:49:44 UTC 37.92376 -122.01304 Walnut Creek 33 [{"latitude": "37.92375", "longitude": "-122.01545"}, {"latitude": "37.92431", "longitude": "-122.01341"}, {"latitude": "37.92479", "longitude": "-122.01375"}, {"latitude": "37.92516", "longitude": "-122.01415"}, {"latitude": "37.92399", "longitude": "-122.01623"}]
692035 October 28, 2019 - 21:30:40 UTC 37.92032 -122.06915 Walnut Creek 33 []
692099 October 28, 2019 - 22:01:51 UTC 37.87513 -122.0874 Walnut Creek 33 []
692214 October 28, 2019 - 23:01:58 UTC 37.90196 -122.0479 Walnut Creek 33 []
692284 October 28, 2019 - 23:36:19 UTC 37.91617 -122.01459 Walnut Creek 33 []
692296 October 28, 2019 - 23:39:27 UTC 37.91157 -122.02092 Walnut Creek 33 []
692363 October 29, 2019 - 00:07:45 UTC 37.92578 -122.07092 Walnut Creek 33 []
692364 October 29, 2019 - 00:07:47 UTC 37.91464 -122.07345 Walnut Creek 33 []
692491 October 29, 2019 - 00:45:42 UTC 37.89493 -122.05392 Walnut Creek 33 []
692517 October 29, 2019 - 00:55:44 UTC 37.90141 -122.04104 Walnut Creek 33 []
692579 October 29, 2019 - 01:27:38 UTC 37.91565 -122.02158 Walnut Creek 33 []
692637 October 29, 2019 - 01:54:06 UTC 37.91578 -122.05299 Walnut Creek 33 []
692656 October 29, 2019 - 02:03:19 UTC 37.90752 -122.05178 Walnut Creek 33 []
693393 October 29, 2019 - 16:06:00 UTC 37.91006 -122.06238 Walnut Creek 33 []
693544 October 29, 2019 - 17:06:29 UTC 37.89735 -122.07031 Walnut Creek 33 []
693942 October 29, 2019 - 18:59:08 UTC 37.9042 -122.05415 Walnut Creek 33 []
693987 October 29, 2019 - 19:21:49 UTC 37.89474 -122.07015 Walnut Creek 33 []
694167 October 29, 2019 - 21:18:56 UTC 37.88703 -122.06095 Walnut Creek 33 []
694204 October 29, 2019 - 21:46:09 UTC 37.88758 -122.05969 Walnut Creek 33 []
694391 October 29, 2019 - 23:42:45 UTC 37.88777 -122.06097 Walnut Creek 33 []
694592 October 30, 2019 - 02:51:36 UTC 37.89735 -122.07031 Walnut Creek 33 []
694852 October 30, 2019 - 15:43:21 UTC 37.89735 -122.07031 Walnut Creek 33 []
694987 October 30, 2019 - 17:00:00 UTC 37.89922 -122.06453 Walnut Creek 33 []
696561 October 31, 2019 - 17:06:53 UTC 37.89654 -122.05052 Walnut Creek 33 []
696864 October 31, 2019 - 20:48:55 UTC 37.93362 -122.05208 Walnut Creek 33 []
696921 October 31, 2019 - 21:44:52 UTC 37.90243 -122.0621 Walnut Creek 33 []
697140 November 01, 2019 - 02:33:41 UTC 37.88373 -122.05698 Walnut Creek 33 []
697216 November 01, 2019 - 11:41:24 UTC 37.90739 -122.05015 Walnut Creek 33 [{"latitude": "37.90741", "longitude": "-122.0506"}, {"latitude": "37.90752", "longitude": "-122.05178"}, {"latitude": "37.90748", "longitude": "-122.05141"}]
697228 November 01, 2019 - 14:04:15 UTC 37.91004 -122.05103 Walnut Creek 33 []
697230 November 01, 2019 - 14:04:15 UTC 37.90929 -122.0525 Walnut Creek 33 [{"latitude": "37.90961", "longitude": "-122.05297"}, {"latitude": "37.91129", "longitude": "-122.05153"}, {"latitude": "37.91203", "longitude": "-122.0513"}, {"latitude": "37.91422", "longitude": "-122.05152"}, {"latitude": "37.9148", "longitude": "-122.05207"}, {"latitude": "37.91133", "longitude": "-122.05388"}, {"latitude": "37.91086", "longitude": "-122.05409"}]
697580 November 01, 2019 - 19:31:08 UTC 37.92281 -122.04664 Walnut Creek 33 []
697641 November 01, 2019 - 20:34:00 UTC 37.88121 -122.05971 Walnut Creek 33 [{"latitude": "37.88028", "longitude": "-122.06177"}, {"latitude": "37.88115", "longitude": "-122.06007"}, {"latitude": "37.88368", "longitude": "-122.06218"}, {"latitude": "37.88327", "longitude": "-122.06308"}]
698196 November 02, 2019 - 17:18:24 UTC 37.91069 -122.00461 Walnut Creek 33 []
698555 November 03, 2019 - 16:40:16 UTC 37.91679 -122.03135 Walnut Creek 33 []
699414 November 04, 2019 - 21:25:25 UTC 37.91617 -122.01459 Walnut Creek 33 []
699921 November 05, 2019 - 17:14:49 UTC 37.87883 -122.08108 Walnut Creek 33 []
700206 November 05, 2019 - 22:21:57 UTC 37.93173 -122.02791 Walnut Creek 33 []
700368 November 06, 2019 - 01:40:01 UTC 37.9331 -122.02995 Walnut Creek 33 [{"latitude": "37.9313", "longitude": "-122.02886"}, {"latitude": "37.93173", "longitude": "-122.02791"}, {"latitude": "37.93233", "longitude": "-122.02834"}, {"latitude": "37.9333", "longitude": "-122.02917"}, {"latitude": "37.93231", "longitude": "-122.03055"}, {"latitude": "37.93148", "longitude": "-122.02932"}]
700381 November 06, 2019 - 02:00:38 UTC 37.9331 -122.03002 Walnut Creek 33 []
700757 November 06, 2019 - 17:31:02 UTC 37.91617 -122.01459 Walnut Creek 33 []
700819 November 06, 2019 - 17:56:45 UTC 37.90164 -122.04561 Walnut Creek 33 []
700977 November 06, 2019 - 20:19:26 UTC 37.898 -122.05478 Walnut Creek 33 []
702092 November 07, 2019 - 22:20:38 UTC 37.91008 -122.0689 Walnut Creek 33 []
702152 November 07, 2019 - 23:42:05 UTC 37.91233 -122.00699 Walnut Creek 33 []
702258 November 08, 2019 - 05:35:50 UTC 37.90866 -122.02158 Walnut Creek 33 []
702530 November 08, 2019 - 16:37:30 UTC 37.89878 -122.05604 Walnut Creek 33 []
702564 November 08, 2019 - 16:47:45 UTC 37.91195 -122.09504 Walnut Creek 33 []
702636 November 08, 2019 - 17:29:42 UTC 37.88476 -122.05169 Walnut Creek 33 []
702783 November 08, 2019 - 19:18:01 UTC 37.92213 -122.08546 Walnut Creek 33 []
702834 November 08, 2019 - 20:25:30 UTC 37.90227 -122.07266 Walnut Creek 33 []
703077 November 09, 2019 - 01:48:59 UTC 37.91195 -122.09504 Walnut Creek 33 []
703109 November 09, 2019 - 02:58:47 UTC 37.91195 -122.09504 Walnut Creek 33 []
703428 November 09, 2019 - 21:42:48 UTC 37.92553 -122.04121 Walnut Creek 33 []
703485 November 10, 2019 - 00:16:15 UTC 37.90848 -122.04524 Walnut Creek 33 []
703986 November 10, 2019 - 21:00:36 UTC 37.90848 -122.04524 Walnut Creek 33 []
704016 November 10, 2019 - 22:01:00 UTC 37.90968 -122.05954 Walnut Creek 33 []
704690 November 12, 2019 - 15:10:11 UTC 37.85586 -122.06944 Walnut Creek 33 []
704704 November 12, 2019 - 15:38:58 UTC 37.91041 -122.04055 Walnut Creek 33 []
704903 November 12, 2019 - 17:55:47 UTC 37.92138 -122.02582 Walnut Creek 33 []
705539 November 13, 2019 - 00:34:49 UTC 37.91136 -122.07483 Walnut Creek 33 []
706063 November 13, 2019 - 18:22:58 UTC 37.91263 -122.01998 Walnut Creek 33 []
706288 November 13, 2019 - 22:22:33 UTC 37.87529 -122.08656 Walnut Creek 33 []
706323 November 13, 2019 - 23:21:47 UTC 37.86852 -122.0267 Walnut Creek 33 []
706501 November 13, 2019 - 23:21:47 UTC 37.86852 -122.0267 Walnut Creek 33 []
706921 November 14, 2019 - 20:45:07 UTC 37.93225 -122.06322 Walnut Creek 33 []
707809 November 15, 2019 - 21:29:28 UTC 37.87927 -122.07256 Walnut Creek 33 []
707816 November 15, 2019 - 21:37:17 UTC 37.93374 -122.02848 Walnut Creek 33 []
707897 November 15, 2019 - 23:32:00 UTC 37.91219 -122.06349 Walnut Creek 33 []
708985 November 18, 2019 - 15:52:07 UTC 37.90138 -122.06761 Walnut Creek 33 []
709021 November 18, 2019 - 15:52:00 UTC 37.90138 -122.06761 Walnut Creek 33 []
709789 November 19, 2019 - 14:48:01 UTC 37.88252 -122.0567 Walnut Creek 33 []
709980 November 19, 2019 - 17:23:02 UTC 37.90267 -122.04802 Walnut Creek 33 []
710094 November 19, 2019 - 18:51:22 UTC 37.9333 -122.02917 Walnut Creek 33 []
710104 November 19, 2019 - 19:01:36 UTC 37.91711 -122.07734 Walnut Creek 33 []
710383 November 19, 2019 - 23:41:43 UTC 37.91173 -122.05808 Walnut Creek 33 []
710389 November 19, 2019 - 23:48:28 UTC 37.93548 -122.03933 Walnut Creek 33 []
710452 November 20, 2019 - 01:38:02 UTC 37.9331 -122.02995 Walnut Creek 33 [{"latitude": "37.9313", "longitude": "-122.02886"}, {"latitude": "37.93173", "longitude": "-122.02791"}, {"latitude": "37.93233", "longitude": "-122.02834"}, {"latitude": "37.9333", "longitude": "-122.02917"}, {"latitude": "37.93231", "longitude": "-122.03055"}, {"latitude": "37.93148", "longitude": "-122.02932"}]
710459 November 20, 2019 - 01:49:28 UTC 37.9331 -122.03002 Walnut Creek 33 []
711621 November 20, 2019 - 20:53:48 UTC 37.88209 -122.05351 Walnut Creek 33 []
711877 November 21, 2019 - 03:41:03 UTC 37.90117 -122.04876 Walnut Creek 33 []
713040 November 22, 2019 - 21:39:43 UTC 37.93225 -122.06322 Walnut Creek 33 []
713377 November 23, 2019 - 16:32:00 UTC 37.9137 -122.03318 Walnut Creek 33 [{"latitude": "37.91195", "longitude": "-122.03235"}, {"latitude": "37.91346", "longitude": "-122.03326"}, {"latitude": "37.91357", "longitude": "-122.0346"}, {"latitude": "37.91346", "longitude": "-122.03607"}, {"latitude": "37.91301", "longitude": "-122.03607"}, {"latitude": "37.91214", "longitude": "-122.03334"}]

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