outages

460 rows where regionName = 34 sorted by latitude

View and edit SQL

id outageStartTime latitude ▼ longitude regionName outageDevices
1072753 September 15, 2020 - 20:43:00 UTC 38.66347 -121.79104 Woodland 34 []
686224 October 27, 2019 - 08:44:02 UTC 38.66371 -121.7836 Woodland 34 []
697970 November 02, 2019 - 01:10:29 UTC 38.66371 -121.7836 Woodland 34 []
696866 October 31, 2019 - 20:50:40 UTC 38.66381 -121.78998 Woodland 34 []
779440 February 06, 2020 - 21:00:13 UTC 38.66381 -121.78998 Woodland 34 []
781235 February 09, 2020 - 16:24:02 UTC 38.66381 -121.78998 Woodland 34 []
782615 February 09, 2020 - 18:58:18 UTC 38.66381 -121.78998 Woodland 34 []
714301 November 25, 2019 - 18:24:45 UTC 38.66392 -121.7813 Woodland 34 []
691678 October 28, 2019 - 18:04:16 UTC 38.66414 -121.76938 Woodland 34 []
696851 October 31, 2019 - 20:31:30 UTC 38.66414 -121.76938 Woodland 34 []
697342 November 01, 2019 - 16:30:22 UTC 38.66414 -121.76938 Woodland 34 []
664040 October 17, 2019 - 16:02:19 UTC 38.66426 -121.77663 Woodland 34 []
1062529 September 10, 2020 - 05:16:52 UTC 38.66427 -121.77875 Woodland 34 []
686283 October 27, 2019 - 09:06:42 UTC 38.66436 -121.78239 Woodland 34 []
690788 October 28, 2019 - 02:42:37 UTC 38.66447 -121.7743 Woodland 34 []
1065283 September 11, 2020 - 23:38:55 UTC 38.66447 -121.7711 Woodland 34 []
677620 October 23, 2019 - 19:04:08 UTC 38.66468 -121.80162 Woodland 34 []
1061383 September 08, 2020 - 23:25:00 UTC 38.66484 -121.79614 Woodland 34 []
716935 November 27, 2019 - 01:56:00 UTC 38.66494 -121.7682 Woodland 34 [{"latitude": "38.66314", "longitude": "-121.76873"}, {"latitude": "38.66388", "longitude": "-121.76871"}, {"latitude": "38.66449", "longitude": "-121.76871"}, {"latitude": "38.66493", "longitude": "-121.76913"}, {"latitude": "38.66491", "longitude": "-121.77004"}]
697112 November 01, 2019 - 01:27:31 UTC 38.66495 -121.77224 Woodland 34 []
737939 December 13, 2019 - 03:10:57 UTC 38.66503 -121.75905 Woodland 34 []
1071754 September 15, 2020 - 17:25:25 UTC 38.66527 -121.76766 Woodland 34 []
725915 December 01, 2019 - 18:20:39 UTC 38.66531 -121.78997 Woodland 34 []
789437 February 12, 2020 - 17:48:55 UTC 38.6654 -121.7718 Woodland 34 []
737514 December 12, 2019 - 18:48:08 UTC 38.66545 -121.794 Woodland 34 []
702164 November 07, 2019 - 23:56:11 UTC 38.66556 -121.79102 Woodland 34 []
693409 October 29, 2019 - 16:11:10 UTC 38.66576 -121.77954 Woodland 34 []
711849 November 21, 2019 - 02:03:34 UTC 38.66579 -121.78358 Woodland 34 []
687095 October 27, 2019 - 14:42:42 UTC 38.66602 -121.79621 Woodland 34 []
1061236 September 08, 2020 - 21:11:24 UTC 38.66602 -121.79621 Woodland 34 []
680438 October 25, 2019 - 18:53:40 UTC 38.6663 -121.79102 Woodland 34 []
655692 October 14, 2019 - 01:57:50 UTC 38.66639 -121.77195 Woodland 34 []
665513 October 17, 2019 - 19:07:38 UTC 38.66658 -121.78392 Woodland 34 []
736897 December 12, 2019 - 04:16:24 UTC 38.66673 -121.79033 Woodland 34 []
737300 December 12, 2019 - 17:07:43 UTC 38.66673 -121.79033 Woodland 34 []
650871 October 09, 2019 - 17:50:26 UTC 38.66675 -121.76953 Woodland 34 []
652631 October 10, 2019 - 14:32:06 UTC 38.66675 -121.76953 Woodland 34 []
692225 October 28, 2019 - 23:07:00 UTC 38.66719 -121.78638 Woodland 34 []
686521 October 27, 2019 - 10:18:07 UTC 38.66745 -121.78191 Woodland 34 []
686740 October 27, 2019 - 12:31:29 UTC 38.66748 -121.78 Woodland 34 []
690834 October 28, 2019 - 03:13:39 UTC 38.66765 -121.78169 Woodland 34 []
694456 October 30, 2019 - 00:20:28 UTC 38.66765 -121.78169 Woodland 34 []
734668 December 09, 2019 - 20:54:45 UTC 38.66778 -121.74612 Woodland 34 []
706321 November 13, 2019 - 23:18:17 UTC 38.66797 -121.77426 Woodland 34 []
692318 October 28, 2019 - 23:50:18 UTC 38.66816 -121.77796 Woodland 34 []
633993 October 01, 2019 - 18:28:23 UTC 38.66842 -121.78516 Woodland 34 []
686235 October 27, 2019 - 08:47:38 UTC 38.66842 -121.78474 Woodland 34 [{"latitude": "38.66719", "longitude": "-121.78638"}, {"latitude": "38.66731", "longitude": "-121.78474"}, {"latitude": "38.66842", "longitude": "-121.78516"}, {"latitude": "38.66843", "longitude": "-121.78596"}, {"latitude": "38.66797", "longitude": "-121.78637"}]
1064090 September 11, 2020 - 14:57:59 UTC 38.66857 -121.77135 Woodland 34 []
1026961 August 22, 2020 - 16:06:27 UTC 38.66872 -121.79664 Woodland 34 []
687354 October 27, 2019 - 16:10:04 UTC 38.66876 -121.76132 Woodland 34 []
734860 December 09, 2019 - 23:37:53 UTC 38.66876 -121.76132 Woodland 34 []
690525 October 28, 2019 - 01:14:35 UTC 38.66941 -121.75927 Woodland 34 []
1076313 September 16, 2020 - 22:10:28 UTC 38.66964 -121.76835 Woodland 34 []
704355 November 11, 2019 - 18:23:07 UTC 38.66976 -121.76317 Woodland 34 []
686296 October 27, 2019 - 09:11:01 UTC 38.66987 -121.76949 Woodland 34 []
655094 October 12, 2019 - 15:49:53 UTC 38.66992 -121.78207 Woodland 34 []
651443 October 09, 2019 - 22:51:54 UTC 38.67057 -121.77793 Woodland 34 []
654107 October 11, 2019 - 14:39:13 UTC 38.67057 -121.77705 Woodland 34 []
742474 December 16, 2019 - 18:25:16 UTC 38.671 -121.7935 Woodland 34 []
696976 October 31, 2019 - 22:44:38 UTC 38.67157 -121.78285 Woodland 34 []
1064375 September 11, 2020 - 16:30:17 UTC 38.67157 -121.78285 Woodland 34 []
1081914 September 18, 2020 - 22:57:00 UTC 38.6717 -121.73785 Woodland 34 [{"latitude": "38.67285", "longitude": "-121.73725"}, {"latitude": "38.67298", "longitude": "-121.73337"}, {"latitude": "38.67322", "longitude": "-121.73525"}, {"latitude": "38.67325", "longitude": "-121.73679"}]
734980 December 10, 2019 - 02:32:23 UTC 38.67177 -121.76206 Woodland 34 []
778570 February 05, 2020 - 20:07:57 UTC 38.67186 -121.79226 Woodland 34 []
1072714 September 15, 2020 - 20:49:09 UTC 38.67202 -121.76989 Woodland 34 []
652677 October 10, 2019 - 15:38:00 UTC 38.67208 -121.77378 Woodland 34 [{"latitude": "38.66341", "longitude": "-121.77963"}, {"latitude": "38.66426", "longitude": "-121.77663"}, {"latitude": "38.67208", "longitude": "-121.77397"}, {"latitude": "38.67381", "longitude": "-121.77592"}, {"latitude": "38.67413", "longitude": "-121.77819"}, {"latitude": "38.6691", "longitude": "-121.79763"}, {"latitude": "38.66486", "longitude": "-121.79701"}, {"latitude": "38.66347", "longitude": "-121.79104"}, {"latitude": "38.66343", "longitude": "-121.78889"}]
717187 November 27, 2019 - 02:10:00 UTC 38.67208 -121.77378 Woodland 34 [{"latitude": "38.66341", "longitude": "-121.77963"}, {"latitude": "38.66426", "longitude": "-121.77663"}, {"latitude": "38.67208", "longitude": "-121.77397"}, {"latitude": "38.67381", "longitude": "-121.77592"}, {"latitude": "38.67413", "longitude": "-121.77819"}, {"latitude": "38.6691", "longitude": "-121.79763"}, {"latitude": "38.66486", "longitude": "-121.79701"}, {"latitude": "38.66347", "longitude": "-121.79104"}, {"latitude": "38.66343", "longitude": "-121.78889"}]
686788 October 27, 2019 - 13:14:07 UTC 38.67211 -121.77805 Woodland 34 []
694028 October 29, 2019 - 19:52:03 UTC 38.67211 -121.77805 Woodland 34 []
695390 October 30, 2019 - 20:48:56 UTC 38.67211 -121.77805 Woodland 34 []
696405 October 31, 2019 - 15:04:49 UTC 38.67211 -121.77805 Woodland 34 []
690038 October 27, 2019 - 22:45:14 UTC 38.67215 -121.78328 Woodland 34 []
1081919 September 18, 2020 - 23:14:00 UTC 38.67231 -121.7358 Woodland 34 []
1081953 September 18, 2020 - 23:14:00 UTC 38.67231 -121.7358 Woodland 34 []
709750 November 19, 2019 - 07:51:57 UTC 38.67242 -121.79236 Woodland 34 []
688753 October 27, 2019 - 20:11:31 UTC 38.67276 -121.75514 Woodland 34 []
654356 October 11, 2019 - 18:04:17 UTC 38.67287 -121.73142 Woodland 34 []
699327 November 04, 2019 - 19:58:28 UTC 38.67293 -121.78123 Woodland 34 []
689355 October 27, 2019 - 21:17:06 UTC 38.67309 -121.77123 Woodland 34 []
688336 October 27, 2019 - 19:10:50 UTC 38.67312 -121.77821 Woodland 34 []
788957 February 11, 2020 - 23:15:37 UTC 38.67361 -121.91051 Woodland 34 []
709109 November 18, 2019 - 17:08:03 UTC 38.67379 -121.7627 Woodland 34 []
709898 November 19, 2019 - 16:40:42 UTC 38.67381 -121.76517 Woodland 34 []
717296 November 27, 2019 - 02:26:00 UTC 38.67381 -121.7794 Woodland 34 []
1072735 September 15, 2020 - 20:52:12 UTC 38.67381 -121.7794 Woodland 34 []
687261 October 27, 2019 - 15:41:45 UTC 38.67398 -121.79327 Woodland 34 []
688300 October 27, 2019 - 19:02:11 UTC 38.67422 -121.78168 Woodland 34 []
714945 November 26, 2019 - 05:09:57 UTC 38.67422 -121.78168 Woodland 34 []
664693 October 17, 2019 - 17:33:57 UTC 38.67453 -121.77072 Woodland 34 []
686044 October 27, 2019 - 08:13:39 UTC 38.67475 -121.75413 Woodland 34 []
688266 October 27, 2019 - 18:56:02 UTC 38.67498 -121.76955 Woodland 34 []
689964 October 27, 2019 - 22:31:11 UTC 38.67498 -121.76955 Woodland 34 []
694553 October 30, 2019 - 02:12:32 UTC 38.67498 -121.76955 Woodland 34 []
695752 October 30, 2019 - 23:19:26 UTC 38.67498 -121.76955 Woodland 34 []
697362 November 01, 2019 - 16:49:50 UTC 38.67498 -121.76955 Woodland 34 []
687627 October 27, 2019 - 17:09:07 UTC 38.67509 -121.77186 Woodland 34 []
654412 October 11, 2019 - 19:08:09 UTC 38.67519 -121.76441 Woodland 34 []
676038 October 21, 2019 - 17:23:16 UTC 38.6753 -121.78167 Woodland 34 []
677184 October 23, 2019 - 01:26:54 UTC 38.67538 -121.79171 Woodland 34 []
647415 October 08, 2019 - 18:06:10 UTC 38.676 -121.92681 Woodland 34 []

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