outages

159 rows where regionName = 64

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices
633587 October 01, 2019 - 14:43:34 UTC 39.73326 -122.12754 Orland 64 []
633820 October 01, 2019 - 16:16:11 UTC 39.73326 -122.12754 Orland 64 []
635849 October 02, 2019 - 16:05:33 UTC 39.74778 -122.21744 Orland 64 []
636953 October 02, 2019 - 18:44:16 UTC 39.7478 -122.23891 Orland 64 []
638872 October 03, 2019 - 02:30:47 UTC 39.63457 -122.13162 Orland 64 []
639064 October 03, 2019 - 15:37:46 UTC 39.81868 -122.07239 Orland 64 []
641353 October 03, 2019 - 22:02:20 UTC 39.73105 -122.13259 Orland 64 []
641702 October 03, 2019 - 23:15:04 UTC 39.73209 -122.13232 Orland 64 []
641703 October 03, 2019 - 23:16:06 UTC 39.73219 -122.12373 Orland 64 []
642573 October 04, 2019 - 15:44:48 UTC 39.73219 -122.12373 Orland 64 []
642593 October 04, 2019 - 15:46:12 UTC 39.73209 -122.13232 Orland 64 []
645978 October 07, 2019 - 16:53:13 UTC 39.74371 -122.17973 Orland 64 []
646073 October 07, 2019 - 18:07:18 UTC 39.73486 -122.25285 Orland 64 []
646940 October 08, 2019 - 00:07:38 UTC 39.73793 -122.15031 Orland 64 []
648083 October 09, 2019 - 08:08:01 UTC 39.73435 -122.40349 Orland 64 []
648084 October 09, 2019 - 08:08:01 UTC 39.79948 -122.43107 Orland 64 []
648212 October 09, 2019 - 08:08:01 UTC 39.78752 -122.51903 Orland 64 []
648248 October 09, 2019 - 08:10:27 UTC 39.7789 -122.31018 Orland 64 []
650779 October 09, 2019 - 16:08:37 UTC 39.7722 -122.24769 Orland 64 []
650911 October 09, 2019 - 18:32:23 UTC 39.8089 -122.06752 Orland 64 []
651057 October 09, 2019 - 20:29:33 UTC 39.79995 -122.06659 Orland 64 []
651093 October 09, 2019 - 20:48:00 UTC 39.79994 -122.06607 Orland 64 []
651102 October 09, 2019 - 20:54:13 UTC 39.80231 -122.05508 Orland 64 []
651200 October 09, 2019 - 22:06:18 UTC 39.74157 -122.18595 Orland 64 []
651466 October 09, 2019 - 23:04:00 UTC 39.74735 -122.14088 Orland 64 []
651467 October 09, 2019 - 23:04:47 UTC 39.74739 -122.14088 Orland 64 [{"latitude": "39.74818", "longitude": "-122.14087"}, {"latitude": "39.75345", "longitude": "-122.13954"}, {"latitude": "39.75491", "longitude": "-122.14102"}, {"latitude": "39.75028", "longitude": "-122.14162"}]
651523 October 09, 2019 - 23:24:34 UTC 39.73793 -122.15031 Orland 64 []
654248 October 09, 2019 - 07:32:00 UTC 39.63812 -122.61077 Orland 64 [{"latitude": "39.65159", "longitude": "-122.72526"}, {"latitude": "39.65282", "longitude": "-122.72089"}, {"latitude": "39.65489", "longitude": "-122.7164"}, {"latitude": "39.65178", "longitude": "-122.72662"}]
655021 October 12, 2019 - 13:04:48 UTC 39.65168 -122.17834 Orland 64 [{"latitude": "39.64415", "longitude": "-122.15968"}, {"latitude": "39.64659", "longitude": "-122.15964"}, {"latitude": "39.65639", "longitude": "-122.168"}, {"latitude": "39.65365", "longitude": "-122.17833"}, {"latitude": "39.65309", "longitude": "-122.17853"}, {"latitude": "39.64575", "longitude": "-122.17391"}, {"latitude": "39.6448", "longitude": "-122.17113"}]
655761 October 14, 2019 - 08:17:00 UTC 39.73938 -122.1056 Orland 64 []
655766 October 14, 2019 - 08:35:00 UTC 39.74314 -122.11945 Orland 64 []
655771 October 14, 2019 - 09:02:54 UTC 39.7431 -122.11417 Orland 64 []
656056 October 14, 2019 - 16:24:35 UTC 39.65996 -122.14785 Orland 64 []
658397 October 14, 2019 - 21:48:11 UTC 39.72153 -122.02799 Orland 64 []
658670 October 15, 2019 - 00:26:13 UTC 39.78373 -122.20594 Orland 64 []
664813 October 17, 2019 - 17:44:03 UTC 39.7908 -122.08453 Orland 64 []
666600 October 17, 2019 - 22:04:54 UTC 39.73741 -122.17152 Orland 64 [{"latitude": "39.7382", "longitude": "-122.17225"}, {"latitude": "39.74168", "longitude": "-122.16553"}, {"latitude": "39.74178", "longitude": "-122.17271"}, {"latitude": "39.74008", "longitude": "-122.17548"}, {"latitude": "39.73961", "longitude": "-122.17489"}]
668356 October 18, 2019 - 16:34:00 UTC 39.75085 -122.19602 Orland 64 []
671134 October 19, 2019 - 15:12:07 UTC 39.69436 -122.04293 Orland 64 []
674233 October 19, 2019 - 23:02:01 UTC 39.67474 -122.2426 Orland 64 []
674415 October 19, 2019 - 23:54:37 UTC 39.67474 -122.2426 Orland 64 []
674802 October 20, 2019 - 17:07:30 UTC 39.77577 -122.09481 Orland 64 [{"latitude": "39.77919", "longitude": "-122.0948"}, {"latitude": "39.77923", "longitude": "-122.09004"}, {"latitude": "39.77923", "longitude": "-122.09358"}]
674914 October 20, 2019 - 23:10:24 UTC 39.77923 -122.09358 Orland 64 []
674964 October 20, 2019 - 23:10:24 UTC 39.77923 -122.09358 Orland 64 []
676355 October 21, 2019 - 21:21:30 UTC 39.67803 -122.27235 Orland 64 []
677538 October 23, 2019 - 17:29:49 UTC 39.73744 -122.18744 Orland 64 []
677694 October 23, 2019 - 20:30:33 UTC 39.73197 -122.23447 Orland 64 []
678814 October 23, 2019 - 23:34:23 UTC 39.80822 -122.11034 Orland 64 []
679603 October 24, 2019 - 18:03:56 UTC 39.74432 -122.18821 Orland 64 []
681304 October 27, 2019 - 00:07:00 UTC 39.78092 -122.29706 Orland 64 [{"latitude": "39.72929", "longitude": "-122.425"}, {"latitude": "39.73651", "longitude": "-122.38007"}, {"latitude": "39.75193", "longitude": "-122.33329"}, {"latitude": "39.77824", "longitude": "-122.30942"}, {"latitude": "39.7789", "longitude": "-122.31018"}, {"latitude": "39.82775", "longitude": "-122.52313"}, {"latitude": "39.82592", "longitude": "-122.52425"}, {"latitude": "39.78025", "longitude": "-122.54667"}]
685428 October 27, 2019 - 06:12:36 UTC 39.74394 -122.19351 Orland 64 []
686241 October 27, 2019 - 08:49:57 UTC 39.5843 -122.22361 Orland 64 []
687133 October 27, 2019 - 14:46:00 UTC 39.5843 -122.22462 Orland 64 []
687919 October 27, 2019 - 18:04:07 UTC 39.68334 -122.19279 Orland 64 []
687920 October 27, 2019 - 18:04:06 UTC 39.68227 -122.18936 Orland 64 []
687921 October 27, 2019 - 18:04:06 UTC 39.68234 -122.19404 Orland 64 []
687975 October 27, 2019 - 18:09:07 UTC 39.78414 -122.25111 Orland 64 []
688162 October 27, 2019 - 18:42:57 UTC 39.70641 -122.21566 Orland 64 []
688342 October 27, 2019 - 19:13:15 UTC 39.68236 -122.19597 Orland 64 [{"latitude": "39.6744", "longitude": "-122.19319"}, {"latitude": "39.67702", "longitude": "-122.18504"}, {"latitude": "39.68796", "longitude": "-122.193"}, {"latitude": "39.68234", "longitude": "-122.19399"}]
688665 October 27, 2019 - 19:59:00 UTC 39.63133 -122.13416 Orland 64 []
691613 October 28, 2019 - 17:32:10 UTC 39.61661 -122.1535 Orland 64 []
696154 October 31, 2019 - 02:43:27 UTC 39.65783 -122.57661 Orland 64 []
696341 October 31, 2019 - 14:03:28 UTC 39.76263 -122.22971 Orland 64 []
696538 October 31, 2019 - 16:48:53 UTC 39.73243 -122.19073 Orland 64 []
697598 November 01, 2019 - 19:48:17 UTC 39.77577 -122.12292 Orland 64 []
698024 November 02, 2019 - 03:51:53 UTC 39.73243 -122.19073 Orland 64 []
698267 November 02, 2019 - 19:46:06 UTC 39.76247 -122.22015 Orland 64 []
698327 November 02, 2019 - 22:05:46 UTC 39.64574 -122.1725 Orland 64 []
698474 November 03, 2019 - 09:18:49 UTC 39.64415 -122.15968 Orland 64 []
698543 November 03, 2019 - 16:36:27 UTC 39.79767 -122.15523 Orland 64 []
700154 November 05, 2019 - 21:13:49 UTC 39.72153 -122.02799 Orland 64 []
700563 November 06, 2019 - 16:07:07 UTC 39.6969 -122.20117 Orland 64 []
704226 November 11, 2019 - 15:30:00 UTC 39.77684 -122.23323 Orland 64 []
704267 November 11, 2019 - 16:30:44 UTC 39.71751 -122.1111 Orland 64 []
705024 November 12, 2019 - 18:08:00 UTC 39.78345 -122.29426 Orland 64 []
705122 November 12, 2019 - 20:56:00 UTC 39.7833 -122.29455 Orland 64 []
706185 November 13, 2019 - 20:17:26 UTC 39.77183 -122.27102 Orland 64 []
706289 November 13, 2019 - 22:22:46 UTC 39.73632 -122.21561 Orland 64 []
708654 November 17, 2019 - 18:10:21 UTC 39.76913 -122.19849 Orland 64 []
709526 November 18, 2019 - 22:53:00 UTC 39.65882 -122.57153 Orland 64 []
709532 November 18, 2019 - 23:02:23 UTC 39.67306 -122.52089 Orland 64 []
709863 November 19, 2019 - 16:22:40 UTC 39.7824 -122.05722 Orland 64 []
709864 November 19, 2019 - 16:22:38 UTC 39.78205 -122.05582 Orland 64 []
709865 November 19, 2019 - 16:22:46 UTC 39.78316 -122.06645 Orland 64 []
711311 November 20, 2019 - 17:29:49 UTC 39.79206 -122.52162 Orland 64 [{"latitude": "39.79596", "longitude": "-122.52127"}, {"latitude": "39.82586", "longitude": "-122.52179"}, {"latitude": "39.82775", "longitude": "-122.52313"}, {"latitude": "39.82592", "longitude": "-122.52425"}]
712929 November 22, 2019 - 19:04:25 UTC 39.72577 -122.02139 Orland 64 []
712953 November 22, 2019 - 19:30:32 UTC 39.65326 -122.19894 Orland 64 []
714208 November 25, 2019 - 17:08:00 UTC 39.64574 -122.17291 Orland 64 []
714216 November 25, 2019 - 17:16:31 UTC 39.7289 -122.15888 Orland 64 []
714892 November 26, 2019 - 03:38:00 UTC 39.72905 -122.16886 Orland 64 [{"latitude": "39.72522", "longitude": "-122.15984"}, {"latitude": "39.72699", "longitude": "-122.15457"}, {"latitude": "39.72883", "longitude": "-122.15222"}, {"latitude": "39.72967", "longitude": "-122.15205"}, {"latitude": "39.73096", "longitude": "-122.16539"}, {"latitude": "39.72905", "longitude": "-122.16817"}, {"latitude": "39.72671", "longitude": "-122.16545"}, {"latitude": "39.72523", "longitude": "-122.16074"}]
715316 November 26, 2019 - 20:39:52 UTC 39.74781 -122.24159 Orland 64 []
716058 November 26, 2019 - 23:35:02 UTC 39.80124 -122.14803 Orland 64 []
716488 November 27, 2019 - 00:47:17 UTC 39.74679 -122.1225 Orland 64 []
716515 November 26, 2019 - 23:35:02 UTC 39.79443 -122.15035 Orland 64 [{"latitude": "39.79463", "longitude": "-122.15036"}, {"latitude": "39.80016", "longitude": "-122.14805"}, {"latitude": "39.80124", "longitude": "-122.14803"}, {"latitude": "39.80318", "longitude": "-122.14865"}, {"latitude": "39.80399", "longitude": "-122.1534"}, {"latitude": "39.80204", "longitude": "-122.1534"}]
716517 November 27, 2019 - 00:53:04 UTC 39.78772 -122.15032 Orland 64 []
716655 November 27, 2019 - 01:10:00 UTC 39.81765 -122.09416 Orland 64 []
717345 November 27, 2019 - 02:31:20 UTC 39.74679 -122.1225 Orland 64 []
717642 November 27, 2019 - 03:00:15 UTC 39.69702 -122.25261 Orland 64 []
717643 November 27, 2019 - 03:00:15 UTC 39.69717 -122.23734 Orland 64 []
717763 November 27, 2019 - 03:13:26 UTC 39.69645 -122.2624 Orland 64 []

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