outages

389 rows where regionName = 129

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices
633821 October 01, 2019 - 16:17:21 UTC 37.34017 -121.99712 Sunnyvale 129 []
633893 October 01, 2019 - 17:08:03 UTC 37.35501 -122.02688 Sunnyvale 129 []
634007 October 01, 2019 - 18:42:06 UTC 37.34889 -122.04992 Sunnyvale 129 []
634875 October 01, 2019 - 22:12:00 UTC 37.41626 -122.03181 Sunnyvale 129 [{"latitude": "37.4025", "longitude": "-122.03423"}, {"latitude": "37.41488", "longitude": "-122.03036"}, {"latitude": "37.41094", "longitude": "-122.03689"}, {"latitude": "37.40544", "longitude": "-122.03666"}, {"latitude": "37.40478", "longitude": "-122.03645"}, {"latitude": "37.40325", "longitude": "-122.03546"}]
635739 October 02, 2019 - 14:09:43 UTC 37.35412 -122.05282 Sunnyvale 129 []
636493 October 02, 2019 - 17:26:51 UTC 37.3385 -122.04558 Sunnyvale 129 []
637794 October 02, 2019 - 20:44:02 UTC 37.36642 -121.99851 Sunnyvale 129 []
638919 October 03, 2019 - 09:26:07 UTC 37.35412 -122.05282 Sunnyvale 129 []
638920 October 03, 2019 - 09:36:20 UTC 37.35529 -122.05281 Sunnyvale 129 []
643503 October 04, 2019 - 19:08:58 UTC 37.38014 -121.99666 Sunnyvale 129 []
643786 October 04, 2019 - 23:51:33 UTC 37.35581 -122.05569 Sunnyvale 129 []
644976 October 05, 2019 - 22:39:14 UTC 37.34817 -122.02168 Sunnyvale 129 []
645719 October 07, 2019 - 01:26:02 UTC 37.39384 -121.98795 Sunnyvale 129 []
647254 October 08, 2019 - 15:46:45 UTC 37.35306 -122.0544 Sunnyvale 129 []
647360 October 08, 2019 - 17:05:59 UTC 37.3778 -122.03515 Sunnyvale 129 []
647365 October 08, 2019 - 17:09:50 UTC 37.37348 -122.03033 Sunnyvale 129 []
647700 October 09, 2019 - 01:53:18 UTC 37.36444 -122.01115 Sunnyvale 129 []
647763 October 09, 2019 - 04:17:20 UTC 37.37373 -122.01896 Sunnyvale 129 []
647783 October 09, 2019 - 05:30:56 UTC 37.36443 -122.01241 Sunnyvale 129 []
651287 October 09, 2019 - 22:36:43 UTC 37.39341 -122.00935 Sunnyvale 129 []
653066 October 10, 2019 - 19:05:05 UTC 37.39629 -122.00047 Sunnyvale 129 []
653509 October 10, 2019 - 22:13:51 UTC 37.34085 -122.04025 Sunnyvale 129 []
653550 October 10, 2019 - 22:44:03 UTC 37.33959 -122.03816 Sunnyvale 129 []
653642 October 10, 2019 - 23:41:00 UTC 37.33568 -122.04483 Sunnyvale 129 []
653935 October 11, 2019 - 03:50:16 UTC 37.37624 -122.05909 Sunnyvale 129 []
654123 October 11, 2019 - 14:53:30 UTC 37.34898 -122.01797 Sunnyvale 129 []
655144 October 12, 2019 - 17:17:44 UTC 37.37582 -122.0145 Sunnyvale 129 []
655145 October 12, 2019 - 17:17:44 UTC 37.37719 -122.01321 Sunnyvale 129 []
655265 October 12, 2019 - 20:36:38 UTC 37.38271 -121.98718 Sunnyvale 129 []
655356 October 12, 2019 - 23:21:07 UTC 37.35582 -122.05479 Sunnyvale 129 []
656258 October 14, 2019 - 16:44:53 UTC 37.35907 -122.04439 Sunnyvale 129 []
656414 October 14, 2019 - 16:58:00 UTC 37.36876 -122.02052 Sunnyvale 129 []
658694 October 15, 2019 - 01:10:02 UTC 37.35368 -122.06026 Sunnyvale 129 []
658914 October 15, 2019 - 16:02:40 UTC 37.39345 -122.0323 Sunnyvale 129 [{"latitude": "37.39297", "longitude": "-122.03114"}, {"latitude": "37.39307", "longitude": "-122.03086"}, {"latitude": "37.39364", "longitude": "-122.03125"}, {"latitude": "37.39301", "longitude": "-122.03155"}]
658979 October 15, 2019 - 16:30:00 UTC 37.35843 -122.03645 Sunnyvale 129 [{"latitude": "37.35653", "longitude": "-122.03694"}, {"latitude": "37.35681", "longitude": "-122.03589"}, {"latitude": "37.35756", "longitude": "-122.03506"}, {"latitude": "37.35798", "longitude": "-122.03654"}]
659837 October 15, 2019 - 21:37:38 UTC 37.35803 -122.05675 Sunnyvale 129 []
659951 October 16, 2019 - 01:33:28 UTC 37.36827 -122.06048 Sunnyvale 129 []
664953 October 17, 2019 - 17:55:19 UTC 37.36136 -122.04975 Sunnyvale 129 []
665914 October 17, 2019 - 19:52:15 UTC 37.3549 -122.05634 Sunnyvale 129 []
666433 October 17, 2019 - 21:36:31 UTC 37.39853 -121.99753 Sunnyvale 129 []
667268 October 18, 2019 - 02:30:35 UTC 37.36414 -122.0543 Sunnyvale 129 []
668355 October 18, 2019 - 16:34:06 UTC 37.40061 -122.02211 Sunnyvale 129 []
668676 October 18, 2019 - 17:29:30 UTC 37.3874 -122.00458 Sunnyvale 129 []
669333 October 18, 2019 - 19:09:51 UTC 37.4002 -122.02267 Sunnyvale 129 [{"latitude": "37.40061", "longitude": "-122.02211"}, {"latitude": "37.4014", "longitude": "-122.02185"}, {"latitude": "37.40216", "longitude": "-122.0216"}]
670618 October 18, 2019 - 22:19:00 UTC 37.40061 -122.02211 Sunnyvale 129 []
670936 October 19, 2019 - 00:37:16 UTC 37.37941 -122.03675 Sunnyvale 129 []
671294 October 19, 2019 - 15:25:11 UTC 37.38254 -122.03521 Sunnyvale 129 [{"latitude": "37.38254", "longitude": "-122.03462"}, {"latitude": "37.38375", "longitude": "-122.03329"}, {"latitude": "37.38337", "longitude": "-122.03503"}]
671534 October 19, 2019 - 16:01:00 UTC 37.39219 -122.03006 Sunnyvale 129 [{"latitude": "37.39168", "longitude": "-122.0315"}, {"latitude": "37.39185", "longitude": "-122.0308"}, {"latitude": "37.39227", "longitude": "-122.03004"}, {"latitude": "37.39251", "longitude": "-122.03109"}]
672113 October 19, 2019 - 17:20:37 UTC 37.39156 -122.02773 Sunnyvale 129 []
673513 October 19, 2019 - 20:49:19 UTC 37.38352 -122.03212 Sunnyvale 129 []
673514 October 19, 2019 - 20:50:40 UTC 37.38254 -122.03521 Sunnyvale 129 []
674927 October 21, 2019 - 00:02:00 UTC 37.36314 -122.00221 Sunnyvale 129 []
676359 October 21, 2019 - 21:27:28 UTC 37.39119 -122.01038 Sunnyvale 129 []
677005 October 22, 2019 - 20:59:54 UTC 37.36144 -122.01251 Sunnyvale 129 []
677050 October 22, 2019 - 22:09:11 UTC 37.3753 -122.0458 Sunnyvale 129 []
677113 October 22, 2019 - 23:33:08 UTC 37.35843 -122.04962 Sunnyvale 129 []
677271 October 23, 2019 - 11:19:59 UTC 37.36144 -122.01251 Sunnyvale 129 []
677397 October 23, 2019 - 15:48:35 UTC 37.36553 -122.00764 Sunnyvale 129 []
677511 October 23, 2019 - 16:49:48 UTC 37.39871 -121.99321 Sunnyvale 129 []
677614 October 23, 2019 - 19:01:36 UTC 37.3549 -122.05634 Sunnyvale 129 []
679138 October 24, 2019 - 02:11:12 UTC 37.35843 -122.04962 Sunnyvale 129 []
679140 October 24, 2019 - 02:26:00 UTC 37.36065 -122.04971 Sunnyvale 129 []
679328 October 24, 2019 - 13:53:15 UTC 37.35149 -122.00587 Sunnyvale 129 []
679377 October 24, 2019 - 15:08:42 UTC 37.37833 -122.04167 Sunnyvale 129 []
679437 October 24, 2019 - 15:58:22 UTC 37.35718 -122.01555 Sunnyvale 129 []
679500 October 24, 2019 - 16:35:25 UTC 37.36621 -122.02093 Sunnyvale 129 []
679551 October 24, 2019 - 17:02:15 UTC 37.35653 -122.03694 Sunnyvale 129 []
679851 October 24, 2019 - 22:47:35 UTC 37.3441 -122.05355 Sunnyvale 129 []
680812 October 26, 2019 - 16:48:45 UTC 37.35114 -122.00856 Sunnyvale 129 []
680899 October 26, 2019 - 20:51:39 UTC 37.40523 -122.00166 Sunnyvale 129 []
680907 October 26, 2019 - 21:12:44 UTC 37.40699 -122.00602 Sunnyvale 129 []
680921 October 26, 2019 - 20:51:00 UTC 37.40722 -122.00602 Sunnyvale 129 []
684263 October 27, 2019 - 04:18:52 UTC 37.34693 -122.02483 Sunnyvale 129 []
687535 October 27, 2019 - 16:49:23 UTC 37.39104 -122.02525 Sunnyvale 129 [{"latitude": "37.38914", "longitude": "-122.02637"}, {"latitude": "37.39002", "longitude": "-122.02614"}, {"latitude": "37.39159", "longitude": "-122.02614"}, {"latitude": "37.39236", "longitude": "-122.02803"}, {"latitude": "37.39191", "longitude": "-122.02893"}, {"latitude": "37.39053", "longitude": "-122.02939"}, {"latitude": "37.39009", "longitude": "-122.02945"}, {"latitude": "37.38961", "longitude": "-122.02799"}]
688349 October 27, 2019 - 19:14:24 UTC 37.35653 -122.03694 Sunnyvale 129 []
689208 October 27, 2019 - 20:58:57 UTC 37.35887 -122.01008 Sunnyvale 129 []
690118 October 27, 2019 - 22:56:55 UTC 37.36406 -122.01374 Sunnyvale 129 []
690257 October 27, 2019 - 23:37:46 UTC 37.38067 -122.04067 Sunnyvale 129 []
690487 October 28, 2019 - 00:51:01 UTC 37.35 -122.05861 Sunnyvale 129 []
691247 October 28, 2019 - 12:51:21 UTC 37.35768 -122.01536 Sunnyvale 129 []
691351 October 28, 2019 - 15:03:27 UTC 37.35937 -122.03363 Sunnyvale 129 []
691730 October 28, 2019 - 18:36:14 UTC 37.39568 -122.03193 Sunnyvale 129 []
693239 October 29, 2019 - 15:30:47 UTC 37.35887 -122.01008 Sunnyvale 129 []
693970 October 29, 2019 - 19:09:39 UTC 37.36519 -122.03547 Sunnyvale 129 []
693971 October 29, 2019 - 19:11:47 UTC 37.35937 -122.03363 Sunnyvale 129 []
694062 October 29, 2019 - 20:08:19 UTC 37.36549 -122.04207 Sunnyvale 129 []
694151 October 29, 2019 - 21:11:04 UTC 37.35945 -122.03413 Sunnyvale 129 []
694400 October 29, 2019 - 23:48:13 UTC 37.37274 -122.02817 Sunnyvale 129 []
696526 October 31, 2019 - 16:41:16 UTC 37.36101 -122.04111 Sunnyvale 129 []
696808 October 31, 2019 - 19:58:08 UTC 37.3718 -122.00802 Sunnyvale 129 []
697240 November 01, 2019 - 14:22:29 UTC 37.33817 -122.02036 Sunnyvale 129 []
697246 November 01, 2019 - 14:31:11 UTC 37.34972 -122.05461 Sunnyvale 129 []
697355 November 01, 2019 - 16:40:48 UTC 37.3382 -122.01973 Sunnyvale 129 []
697385 November 01, 2019 - 17:07:56 UTC 37.36964 -122.05993 Sunnyvale 129 []
697425 November 01, 2019 - 17:50:30 UTC 37.35637 -122.04499 Sunnyvale 129 []
697482 November 01, 2019 - 18:39:33 UTC 37.36519 -122.03547 Sunnyvale 129 []
697746 November 01, 2019 - 21:51:00 UTC 37.35688 -122.04874 Sunnyvale 129 []
697767 November 01, 2019 - 22:03:38 UTC 37.38025 -122.03867 Sunnyvale 129 []
697881 November 01, 2019 - 23:06:22 UTC 37.37877 -122.03923 Sunnyvale 129 []
697961 November 02, 2019 - 00:57:41 UTC 37.37119 -122.05145 Sunnyvale 129 []

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