outages

297 rows where regionName = 33 sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
726896 December 02, 2019 - 09:21:43 UTC 37.91762 -121.99685 Walnut Creek 33 [{"latitude": "37.85658", "longitude": "-121.97294"}, {"latitude": "37.85805", "longitude": "-121.97328"}, {"latitude": "37.91456", "longitude": "-121.99138"}, {"latitude": "37.91544", "longitude": "-121.99183"}, {"latitude": "37.91637", "longitude": "-121.99309"}, {"latitude": "37.91752", "longitude": "-121.99563"}, {"latitude": "37.91738", "longitude": "-121.99672"}, {"latitude": "37.91482", "longitude": "-122.00237"}, {"latitude": "37.90455", "longitude": "-122.01432"}, {"latitude": "37.89071", "longitude": "-122.00559"}, {"latitude": "37.85741", "longitude": "-121.98322"}]
680350 October 25, 2019 - 17:02:47 UTC 37.91142 -122.00379 Walnut Creek 33 []
786541 February 10, 2020 - 05:30:00 UTC 37.93197 -122.00459 Walnut Creek 33 []
698196 November 02, 2019 - 17:18:24 UTC 37.91069 -122.00461 Walnut Creek 33 []
786051 February 10, 2020 - 02:27:00 UTC 37.93238 -122.00464 Walnut Creek 33 [{"latitude": "37.93317", "longitude": "-122.00485"}, {"latitude": "37.93469", "longitude": "-122.00556"}, {"latitude": "37.93577", "longitude": "-122.00632"}, {"latitude": "37.93882", "longitude": "-122.00891"}, {"latitude": "37.93695", "longitude": "-122.00866"}]
786490 February 10, 2020 - 05:00:00 UTC 37.93238 -122.00464 Walnut Creek 33 [{"latitude": "37.93317", "longitude": "-122.00485"}, {"latitude": "37.93469", "longitude": "-122.00556"}, {"latitude": "37.93577", "longitude": "-122.00632"}, {"latitude": "37.93882", "longitude": "-122.00891"}, {"latitude": "37.93695", "longitude": "-122.00866"}]
713434 November 23, 2019 - 17:41:41 UTC 37.91705 -122.00496 Walnut Creek 33 []
786071 February 10, 2020 - 02:34:17 UTC 37.93089 -122.00623 Walnut Creek 33 []
786498 February 10, 2020 - 05:03:00 UTC 37.93089 -122.00623 Walnut Creek 33 []
789552 February 12, 2020 - 19:42:57 UTC 37.93089 -122.00623 Walnut Creek 33 []
786033 February 10, 2020 - 02:22:00 UTC 37.93161 -122.00628 Walnut Creek 33 []
702152 November 07, 2019 - 23:42:05 UTC 37.91233 -122.00699 Walnut Creek 33 []
786488 February 10, 2020 - 04:59:17 UTC 37.93027 -122.00723 Walnut Creek 33 []
786530 February 10, 2020 - 05:21:00 UTC 37.93013 -122.00829 Walnut Creek 33 []
781507 February 09, 2020 - 17:14:13 UTC 37.93237 -122.0088 Walnut Creek 33 [{"latitude": "37.93231", "longitude": "-122.00754"}, {"latitude": "37.9352", "longitude": "-122.00718"}, {"latitude": "37.93528", "longitude": "-122.00811"}, {"latitude": "37.9328", "longitude": "-122.00849"}]
786064 February 10, 2020 - 02:30:00 UTC 37.93237 -122.0088 Walnut Creek 33 [{"latitude": "37.93231", "longitude": "-122.00754"}, {"latitude": "37.9352", "longitude": "-122.00718"}, {"latitude": "37.93528", "longitude": "-122.00811"}, {"latitude": "37.9328", "longitude": "-122.00849"}]
786504 February 10, 2020 - 05:06:00 UTC 37.93237 -122.0088 Walnut Creek 33 [{"latitude": "37.93231", "longitude": "-122.00754"}, {"latitude": "37.9352", "longitude": "-122.00718"}, {"latitude": "37.93528", "longitude": "-122.00811"}, {"latitude": "37.9328", "longitude": "-122.00849"}]
786046 February 10, 2020 - 02:24:55 UTC 37.93112 -122.00914 Walnut Creek 33 []
786067 February 10, 2020 - 02:32:36 UTC 37.93228 -122.01121 Walnut Creek 33 []
786015 February 10, 2020 - 02:18:21 UTC 37.92992 -122.01125 Walnut Creek 33 []
636677 October 02, 2019 - 17:54:48 UTC 37.93184 -122.01142 Walnut Creek 33 []
679821 October 24, 2019 - 22:11:25 UTC 37.92913 -122.01172 Walnut Creek 33 []
781346 February 09, 2020 - 16:55:25 UTC 37.93436 -122.01209 Walnut Creek 33 []
785448 February 09, 2020 - 23:58:00 UTC 37.93436 -122.01209 Walnut Creek 33 []
786594 February 10, 2020 - 04:59:17 UTC 37.9305 -122.01243 Walnut Creek 33 [{"latitude": "37.92987", "longitude": "-122.00934"}, {"latitude": "37.93027", "longitude": "-122.00723"}, {"latitude": "37.93124", "longitude": "-122.00492"}, {"latitude": "37.93197", "longitude": "-122.00459"}, {"latitude": "37.93317", "longitude": "-122.00485"}, {"latitude": "37.93469", "longitude": "-122.00556"}, {"latitude": "37.93577", "longitude": "-122.00632"}, {"latitude": "37.93882", "longitude": "-122.00891"}, {"latitude": "37.93199", "longitude": "-122.01234"}, {"latitude": "37.92992", "longitude": "-122.01125"}]
736323 December 11, 2019 - 17:35:08 UTC 37.93128 -122.01292 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"}]
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"}]
781524 February 09, 2020 - 17:15:00 UTC 37.92795 -122.01365 Walnut Creek 33 [{"latitude": "37.92831", "longitude": "-122.01315"}, {"latitude": "37.92858", "longitude": "-122.01149"}, {"latitude": "37.93027", "longitude": "-122.00723"}, {"latitude": "37.93124", "longitude": "-122.00492"}, {"latitude": "37.93197", "longitude": "-122.00459"}, {"latitude": "37.93317", "longitude": "-122.00485"}, {"latitude": "37.93469", "longitude": "-122.00556"}, {"latitude": "37.93577", "longitude": "-122.00632"}, {"latitude": "37.93882", "longitude": "-122.00891"}, {"latitude": "37.93026", "longitude": "-122.01673"}, {"latitude": "37.92847", "longitude": "-122.01479"}]
786596 February 10, 2020 - 06:38:48 UTC 37.92795 -122.01365 Walnut Creek 33 [{"latitude": "37.92831", "longitude": "-122.01315"}, {"latitude": "37.92858", "longitude": "-122.01149"}, {"latitude": "37.92913", "longitude": "-122.01172"}, {"latitude": "37.93128", "longitude": "-122.01292"}, {"latitude": "37.93099", "longitude": "-122.01518"}, {"latitude": "37.93062", "longitude": "-122.01613"}, {"latitude": "37.93026", "longitude": "-122.01673"}, {"latitude": "37.92847", "longitude": "-122.01479"}]
692284 October 28, 2019 - 23:36:19 UTC 37.91617 -122.01459 Walnut Creek 33 []
699414 November 04, 2019 - 21:25:25 UTC 37.91617 -122.01459 Walnut Creek 33 []
700757 November 06, 2019 - 17:31:02 UTC 37.91617 -122.01459 Walnut Creek 33 []
779159 February 06, 2020 - 17:24:33 UTC 37.93417 -122.01539 Walnut Creek 33 [{"latitude": "37.93439", "longitude": "-122.01499"}, {"latitude": "37.93479", "longitude": "-122.01536"}, {"latitude": "37.93498", "longitude": "-122.01684"}]
687784 October 27, 2019 - 17:46:35 UTC 37.93498 -122.01684 Walnut Creek 33 []
783675 February 09, 2020 - 20:12:39 UTC 37.91785 -122.01725 Walnut Creek 33 []
690005 October 27, 2019 - 22:38:49 UTC 37.9338 -122.01756 Walnut Creek 33 []
782070 February 09, 2020 - 18:11:56 UTC 37.91826 -122.0185 Walnut Creek 33 []
781384 February 09, 2020 - 17:00:00 UTC 37.91447 -122.01871 Walnut Creek 33 [{"latitude": "37.90962", "longitude": "-122.01925"}, {"latitude": "37.91174", "longitude": "-122.01863"}, {"latitude": "37.91428", "longitude": "-122.01915"}, {"latitude": "37.91263", "longitude": "-122.01998"}, {"latitude": "37.91161", "longitude": "-122.02005"}, {"latitude": "37.90978", "longitude": "-122.01986"}]
706063 November 13, 2019 - 18:22:58 UTC 37.91263 -122.01998 Walnut Creek 33 []
721958 November 28, 2019 - 00:19:50 UTC 37.8887 -122.02023 Walnut Creek 33 []
689724 October 27, 2019 - 21:56:06 UTC 37.86999 -122.02049 Walnut Creek 33 []
690523 October 28, 2019 - 01:12:20 UTC 37.86999 -122.02049 Walnut Creek 33 []
721947 November 28, 2019 - 00:16:00 UTC 37.86999 -122.02049 Walnut Creek 33 []
692296 October 28, 2019 - 23:39:27 UTC 37.91157 -122.02092 Walnut Creek 33 []
633594 October 01, 2019 - 14:57:11 UTC 37.91565 -122.02158 Walnut Creek 33 []
692579 October 29, 2019 - 01:27:38 UTC 37.91565 -122.02158 Walnut Creek 33 []
702258 November 08, 2019 - 05:35:50 UTC 37.90866 -122.02158 Walnut Creek 33 []
743580 December 16, 2019 - 20:43:43 UTC 37.90866 -122.02158 Walnut Creek 33 []
722827 November 28, 2019 - 18:23:00 UTC 37.88263 -122.02252 Walnut Creek 33 []
688332 October 27, 2019 - 19:09:52 UTC 37.93256 -122.02365 Walnut Creek 33 []
653028 October 10, 2019 - 18:42:05 UTC 37.88767 -122.02371 Walnut Creek 33 []
654391 October 11, 2019 - 18:50:38 UTC 37.88767 -122.02371 Walnut Creek 33 []
721952 November 28, 2019 - 00:17:00 UTC 37.88971 -122.0252 Walnut Creek 33 []
743655 December 16, 2019 - 22:04:31 UTC 37.88183 -122.0252 Walnut Creek 33 []
653055 October 10, 2019 - 18:59:10 UTC 37.9144 -122.02577 Walnut Creek 33 [{"latitude": "37.91268", "longitude": "-122.02385"}, {"latitude": "37.91468", "longitude": "-122.02363"}, {"latitude": "37.91432", "longitude": "-122.02443"}, {"latitude": "37.91409", "longitude": "-122.02494"}]
704903 November 12, 2019 - 17:55:47 UTC 37.92138 -122.02582 Walnut Creek 33 []
732429 December 07, 2019 - 17:43:00 UTC 37.86999 -122.02665 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 []
690757 October 28, 2019 - 02:27:14 UTC 37.86782 -122.02694 Walnut Creek 33 []
732433 December 07, 2019 - 17:46:46 UTC 37.87076 -122.02732 Walnut Creek 33 []
700206 November 05, 2019 - 22:21:57 UTC 37.93173 -122.02791 Walnut Creek 33 []
707816 November 15, 2019 - 21:37:17 UTC 37.93374 -122.02848 Walnut Creek 33 []
710094 November 19, 2019 - 18:51:22 UTC 37.9333 -122.02917 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"}]
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"}]
700381 November 06, 2019 - 02:00:38 UTC 37.9331 -122.03002 Walnut Creek 33 []
710459 November 20, 2019 - 01:49:28 UTC 37.9331 -122.03002 Walnut Creek 33 []
633546 October 01, 2019 - 13:07:08 UTC 37.87055 -122.03021 Walnut Creek 33 []
717559 November 27, 2019 - 02:50:08 UTC 37.91067 -122.03081 Walnut Creek 33 []
781016 February 09, 2020 - 15:07:49 UTC 37.87619 -122.03096 Walnut Creek 33 []
635653 October 02, 2019 - 04:24:00 UTC 37.87056 -122.03111 Walnut Creek 33 []
698555 November 03, 2019 - 16:40:16 UTC 37.91679 -122.03135 Walnut Creek 33 []
668375 October 18, 2019 - 16:34:14 UTC 37.91449 -122.03168 Walnut Creek 33 []
729570 December 04, 2019 - 17:31:48 UTC 37.87635 -122.03202 Walnut Creek 33 []
781617 February 09, 2020 - 17:22:00 UTC 37.91195 -122.03235 Walnut Creek 33 []
735221 December 10, 2019 - 16:17:48 UTC 37.87429 -122.03266 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"}]
721954 November 28, 2019 - 00:18:40 UTC 37.87192 -122.03359 Walnut Creek 33 []
687821 October 27, 2019 - 17:50:00 UTC 37.93161 -122.03404 Walnut Creek 33 []
638393 October 02, 2019 - 21:59:26 UTC 37.91811 -122.03487 Walnut Creek 33 [{"latitude": "37.91859", "longitude": "-122.0344"}, {"latitude": "37.91922", "longitude": "-122.03465"}, {"latitude": "37.91952", "longitude": "-122.03556"}]
635861 October 02, 2019 - 16:09:46 UTC 37.91821 -122.03537 Walnut Creek 33 []
721951 November 28, 2019 - 00:17:00 UTC 37.87687 -122.03554 Walnut Creek 33 []
729654 December 04, 2019 - 18:22:09 UTC 37.91853 -122.03615 Walnut Creek 33 []
784917 February 09, 2020 - 22:25:02 UTC 37.91631 -122.03625 Walnut Creek 33 []
734219 December 09, 2019 - 16:44:56 UTC 37.92989 -122.03698 Walnut Creek 33 []
674898 October 20, 2019 - 21:55:00 UTC 37.93213 -122.03803 Walnut Creek 33 []
688033 October 27, 2019 - 18:20:37 UTC 37.91385 -122.03862 Walnut Creek 33 []
632153 September 30, 2019 - 20:18:37 UTC 37.89203 -122.03894 Walnut Creek 33 []
710389 November 19, 2019 - 23:48:28 UTC 37.93548 -122.03933 Walnut Creek 33 []
732485 December 07, 2019 - 18:10:26 UTC 37.9317 -122.04017 Walnut Creek 33 []
784155 February 09, 2020 - 21:02:59 UTC 37.90175 -122.04017 Walnut Creek 33 []
691658 October 28, 2019 - 17:55:01 UTC 37.89125 -122.04036 Walnut Creek 33 []
717337 November 27, 2019 - 02:30:25 UTC 37.89125 -122.04036 Walnut Creek 33 []
704704 November 12, 2019 - 15:38:58 UTC 37.91041 -122.04055 Walnut Creek 33 []
687795 October 27, 2019 - 17:48:00 UTC 37.93207 -122.04057 Walnut Creek 33 [{"latitude": "37.93286", "longitude": "-122.03986"}, {"latitude": "37.93333", "longitude": "-122.03922"}, {"latitude": "37.9336", "longitude": "-122.03948"}, {"latitude": "37.93394", "longitude": "-122.03983"}, {"latitude": "37.93445", "longitude": "-122.04139"}, {"latitude": "37.93349", "longitude": "-122.0406"}]
677041 October 22, 2019 - 22:00:44 UTC 37.90234 -122.04097 Walnut Creek 33 []
692517 October 29, 2019 - 00:55:44 UTC 37.90141 -122.04104 Walnut Creek 33 []
703428 November 09, 2019 - 21:42:48 UTC 37.92553 -122.04121 Walnut Creek 33 []

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