outages

297 rows where regionName = 33 sorted by outageDevices

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices ▼
632153 September 30, 2019 - 20:18:37 UTC 37.89203 -122.03894 Walnut Creek 33 []
633546 October 01, 2019 - 13:07:08 UTC 37.87055 -122.03021 Walnut Creek 33 []
633594 October 01, 2019 - 14:57:11 UTC 37.91565 -122.02158 Walnut Creek 33 []
633894 October 01, 2019 - 17:08:16 UTC 37.88173 -122.06065 Walnut Creek 33 []
635653 October 02, 2019 - 04:24:00 UTC 37.87056 -122.03111 Walnut Creek 33 []
635861 October 02, 2019 - 16:09:46 UTC 37.91821 -122.03537 Walnut Creek 33 []
636677 October 02, 2019 - 17:54:48 UTC 37.93184 -122.01142 Walnut Creek 33 []
638233 October 02, 2019 - 21:45:36 UTC 37.92807 -122.04595 Walnut Creek 33 []
638829 October 03, 2019 - 00:57:19 UTC 37.8997 -122.04257 Walnut Creek 33 []
642250 October 04, 2019 - 14:25:08 UTC 37.90531 -122.05356 Walnut Creek 33 []
642742 October 04, 2019 - 16:02:00 UTC 37.90531 -122.05356 Walnut Creek 33 []
642778 October 04, 2019 - 16:13:00 UTC 37.90493 -122.0529 Walnut Creek 33 []
644723 October 05, 2019 - 19:40:15 UTC 37.90126 -122.04802 Walnut Creek 33 []
645595 October 06, 2019 - 17:40:33 UTC 37.91709 -122.06095 Walnut Creek 33 []
645610 October 06, 2019 - 18:31:39 UTC 37.9171 -122.06193 Walnut Creek 33 []
646151 October 07, 2019 - 18:58:24 UTC 37.91904 -122.08001 Walnut Creek 33 []
646972 October 08, 2019 - 01:12:00 UTC 37.90412 -122.07097 Walnut Creek 33 []
647016 October 08, 2019 - 04:04:00 UTC 37.89259 -122.0616 Walnut Creek 33 []
652337 October 10, 2019 - 06:30:05 UTC 37.93283 -122.06781 Walnut Creek 33 []
652572 October 10, 2019 - 11:17:00 UTC 37.90775 -122.05502 Walnut Creek 33 []
653028 October 10, 2019 - 18:42:05 UTC 37.88767 -122.02371 Walnut Creek 33 []
653355 October 10, 2019 - 20:35:24 UTC 37.9269 -122.06331 Walnut Creek 33 []
653409 October 10, 2019 - 21:18:00 UTC 37.92449 -122.0789 Walnut Creek 33 []
653803 October 11, 2019 - 01:53:00 UTC 37.92641 -122.0695 Walnut Creek 33 []
653963 October 11, 2019 - 04:26:20 UTC 37.9269 -122.06331 Walnut Creek 33 []
654391 October 11, 2019 - 18:50:38 UTC 37.88767 -122.02371 Walnut Creek 33 []
654758 October 11, 2019 - 23:53:21 UTC 37.91545 -122.07089 Walnut Creek 33 []
654769 October 12, 2019 - 00:01:29 UTC 37.92641 -122.0695 Walnut Creek 33 []
655851 October 14, 2019 - 15:09:02 UTC 37.88279 -122.06069 Walnut Creek 33 []
656153 October 14, 2019 - 16:33:51 UTC 37.9269 -122.06331 Walnut Creek 33 []
658967 October 15, 2019 - 16:31:00 UTC 37.86391 -122.0786 Walnut Creek 33 []
659831 October 15, 2019 - 21:28:54 UTC 37.89195 -122.05035 Walnut Creek 33 []
659841 October 15, 2019 - 21:41:08 UTC 37.92213 -122.08546 Walnut Creek 33 []
659956 October 16, 2019 - 02:07:36 UTC 37.9269 -122.06331 Walnut Creek 33 []
667314 October 18, 2019 - 05:05:00 UTC 37.89424 -122.06248 Walnut Creek 33 []
668375 October 18, 2019 - 16:34:14 UTC 37.91449 -122.03168 Walnut Creek 33 []
674898 October 20, 2019 - 21:55:00 UTC 37.93213 -122.03803 Walnut Creek 33 []
675924 October 21, 2019 - 16:13:59 UTC 37.9155 -122.06907 Walnut Creek 33 []
676121 October 21, 2019 - 18:15:25 UTC 37.91006 -122.06238 Walnut Creek 33 []
677041 October 22, 2019 - 22:00:44 UTC 37.90234 -122.04097 Walnut Creek 33 []
677148 October 23, 2019 - 00:34:25 UTC 37.92874 -122.06261 Walnut Creek 33 []
677435 October 23, 2019 - 16:11:36 UTC 37.91612 -122.07843 Walnut Creek 33 []
677500 October 23, 2019 - 16:41:54 UTC 37.9036 -122.04189 Walnut Creek 33 []
679821 October 24, 2019 - 22:11:25 UTC 37.92913 -122.01172 Walnut Creek 33 []
680350 October 25, 2019 - 17:02:47 UTC 37.91142 -122.00379 Walnut Creek 33 []
685498 October 27, 2019 - 06:22:00 UTC 37.86391 -122.0786 Walnut Creek 33 []
685503 October 27, 2019 - 06:23:49 UTC 37.85536 -122.0657 Walnut Creek 33 []
685532 October 27, 2019 - 06:26:11 UTC 37.85945 -122.07604 Walnut Creek 33 []
685534 October 27, 2019 - 06:26:11 UTC 37.85787 -122.07579 Walnut Creek 33 []
685537 October 27, 2019 - 06:25:18 UTC 37.85681 -122.07438 Walnut Creek 33 []
687101 October 27, 2019 - 14:45:15 UTC 37.85217 -122.05739 Walnut Creek 33 []
687475 October 27, 2019 - 16:33:41 UTC 37.92584 -122.06368 Walnut Creek 33 []
687497 October 27, 2019 - 16:39:50 UTC 37.93362 -122.05208 Walnut Creek 33 []
687622 October 27, 2019 - 17:07:49 UTC 37.90122 -122.06624 Walnut Creek 33 []
687717 October 27, 2019 - 17:30:39 UTC 37.89922 -122.06453 Walnut Creek 33 []
687718 October 27, 2019 - 17:30:54 UTC 37.92898 -122.06223 Walnut Creek 33 []
687735 October 27, 2019 - 17:34:55 UTC 37.9127 -122.06813 Walnut Creek 33 []
687784 October 27, 2019 - 17:46:35 UTC 37.93498 -122.01684 Walnut Creek 33 []
687821 October 27, 2019 - 17:50:00 UTC 37.93161 -122.03404 Walnut Creek 33 []
687864 October 27, 2019 - 17:56:47 UTC 37.93675 -122.05241 Walnut Creek 33 []
687945 October 27, 2019 - 18:06:19 UTC 37.87801 -122.0739 Walnut Creek 33 []
688033 October 27, 2019 - 18:20:37 UTC 37.91385 -122.03862 Walnut Creek 33 []
688052 October 27, 2019 - 18:23:03 UTC 37.90087 -122.04968 Walnut Creek 33 []
688156 October 27, 2019 - 18:42:12 UTC 37.88349 -122.06082 Walnut Creek 33 []
688332 October 27, 2019 - 19:09:52 UTC 37.93256 -122.02365 Walnut Creek 33 []
688506 October 27, 2019 - 19:40:09 UTC 37.93826 -122.05962 Walnut Creek 33 []
688684 October 27, 2019 - 20:01:55 UTC 37.88703 -122.06095 Walnut Creek 33 []
688756 October 27, 2019 - 20:13:00 UTC 37.88777 -122.06097 Walnut Creek 33 []
689199 October 27, 2019 - 20:57:38 UTC 37.87245 -122.08131 Walnut Creek 33 []
689227 October 27, 2019 - 21:01:11 UTC 37.92224 -122.08192 Walnut Creek 33 []
689723 October 27, 2019 - 21:55:44 UTC 37.90451 -122.04976 Walnut Creek 33 []
689724 October 27, 2019 - 21:56:06 UTC 37.86999 -122.02049 Walnut Creek 33 []
689767 October 27, 2019 - 22:03:15 UTC 37.90224 -122.05343 Walnut Creek 33 []
689768 October 27, 2019 - 22:03:15 UTC 37.89118 -122.04786 Walnut Creek 33 []
689769 October 27, 2019 - 22:03:15 UTC 37.90832 -122.05431 Walnut Creek 33 []
689845 October 27, 2019 - 22:14:20 UTC 37.9028 -122.05714 Walnut Creek 33 []
689870 October 27, 2019 - 22:18:33 UTC 37.90359 -122.06679 Walnut Creek 33 []
689884 October 27, 2019 - 22:21:41 UTC 37.91069 -122.05905 Walnut Creek 33 []
689986 October 27, 2019 - 22:35:11 UTC 37.87602 -122.08757 Walnut Creek 33 []
690005 October 27, 2019 - 22:38:49 UTC 37.9338 -122.01756 Walnut Creek 33 []
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 []
691965 October 28, 2019 - 20:48:28 UTC 37.90087 -122.04968 Walnut Creek 33 []
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 []

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