172 rows where regionName = 53

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
633558 October 01, 2019 - 13:51:58 UTC 37.92282 -121.91097 Clayton 53 []
634955 October 01, 2019 - 22:24:23 UTC 37.92112 -121.90074 Clayton 53 []
636293 October 02, 2019 - 17:05:00 UTC 37.94603 -121.93284 Clayton 53 []
639184 October 03, 2019 - 16:17:00 UTC 37.92575 -121.91434 Clayton 53 []
639573 October 03, 2019 - 17:46:52 UTC 37.941 -121.92861 Clayton 53 [{"latitude": "37.93005", "longitude": "-121.8694"}, {"latitude": "37.94221", "longitude": "-121.8859"}, {"latitude": "37.94385", "longitude": "-121.89044"}, {"latitude": "37.94277", "longitude": "-121.92691"}, {"latitude": "37.93873", "longitude": "-121.91117"}]
652616 October 10, 2019 - 14:00:05 UTC 37.879 -121.8687 Clayton 53 []
652630 October 10, 2019 - 14:27:57 UTC 37.87819 -121.86871 Clayton 53 []
652883 October 10, 2019 - 17:40:41 UTC 37.9246 -121.91867 Clayton 53 []
653446 October 10, 2019 - 21:47:58 UTC 37.9246 -121.91867 Clayton 53 []
653528 October 10, 2019 - 22:32:44 UTC 37.88557 -121.84111 Clayton 53 []
659955 October 16, 2019 - 02:02:54 UTC 37.88557 -121.84111 Clayton 53 []
660315 October 16, 2019 - 15:45:21 UTC 37.94144 -121.91813 Clayton 53 []
667230 October 18, 2019 - 01:12:00 UTC 37.92129 -121.91394 Clayton 53 []
667232 October 18, 2019 - 01:14:39 UTC 37.92406 -121.912 Clayton 53 [{"latitude": "37.92273", "longitude": "-121.91005"}, {"latitude": "37.92379", "longitude": "-121.91202"}, {"latitude": "37.92341", "longitude": "-121.91208"}, {"latitude": "37.92294", "longitude": "-121.91211"}, {"latitude": "37.92282", "longitude": "-121.91097"}]
676125 October 21, 2019 - 18:15:00 UTC 37.89322 -121.79397 Clayton 53 [{"latitude": "37.89356", "longitude": "-121.79302"}, {"latitude": "37.89373", "longitude": "-121.79325"}, {"latitude": "37.8939", "longitude": "-121.79459"}]
683889 October 27, 2019 - 03:45:35 UTC 37.92449 -121.9125 Clayton 53 [{"latitude": "37.86678", "longitude": "-121.74233"}, {"latitude": "37.86712", "longitude": "-121.73304"}, {"latitude": "37.87427", "longitude": "-121.72415"}, {"latitude": "37.89466", "longitude": "-121.77392"}, {"latitude": "37.92426", "longitude": "-121.905"}, {"latitude": "37.92423", "longitude": "-121.91157"}, {"latitude": "37.92379", "longitude": "-121.91202"}, {"latitude": "37.92341", "longitude": "-121.91208"}, {"latitude": "37.92294", "longitude": "-121.91211"}, {"latitude": "37.91914", "longitude": "-121.91104"}, {"latitude": "37.90753", "longitude": "-121.9065"}, {"latitude": "37.88376", "longitude": "-121.84"}, {"latitude": "37.8829", "longitude": "-121.83585"}]
683914 October 27, 2019 - 03:45:35 UTC 37.90393 -121.87407 Clayton 53 [{"latitude": "37.84116", "longitude": "-121.82496"}, {"latitude": "37.88786", "longitude": "-121.856"}, {"latitude": "37.90343", "longitude": "-121.87245"}, {"latitude": "37.90341", "longitude": "-121.87366"}, {"latitude": "37.89254", "longitude": "-121.90786"}, {"latitude": "37.85114", "longitude": "-121.89392"}, {"latitude": "37.84263", "longitude": "-121.8391"}]
684914 October 27, 2019 - 04:40:00 UTC 37.92459 -121.91432 Clayton 53 [{"latitude": "37.92186", "longitude": "-121.91432"}, {"latitude": "37.92407", "longitude": "-121.91433"}, {"latitude": "37.92301", "longitude": "-121.91433"}]
684915 October 27, 2019 - 05:21:42 UTC 37.92796 -121.94158 Clayton 53 [{"latitude": "37.92784", "longitude": "-121.94055"}, {"latitude": "37.93078", "longitude": "-121.93943"}, {"latitude": "37.93275", "longitude": "-121.93925"}]
684916 October 27, 2019 - 05:21:42 UTC 37.92868 -121.94168 Clayton 53 [{"latitude": "37.92958", "longitude": "-121.94072"}, {"latitude": "37.93206", "longitude": "-121.94029"}, {"latitude": "37.93123", "longitude": "-121.94094"}]
685141 October 27, 2019 - 04:55:00 UTC 37.92503 -121.91435 Clayton 53 []
685176 October 27, 2019 - 05:15:00 UTC 37.92597 -121.91769 Clayton 53 []
685955 October 27, 2019 - 07:45:00 UTC 37.94322 -121.92559 Clayton 53 [{"latitude": "37.93005", "longitude": "-121.8694"}, {"latitude": "37.94221", "longitude": "-121.8859"}, {"latitude": "37.94385", "longitude": "-121.89044"}, {"latitude": "37.93873", "longitude": "-121.91117"}]
693326 October 29, 2019 - 15:52:44 UTC 37.92202 -121.89998 Clayton 53 []
693995 October 29, 2019 - 19:26:57 UTC 37.94065 -121.93643 Clayton 53 []
694200 October 29, 2019 - 21:40:51 UTC 37.92202 -121.89998 Clayton 53 []
694461 October 30, 2019 - 00:25:45 UTC 37.92202 -121.89998 Clayton 53 []
695001 October 30, 2019 - 17:06:16 UTC 37.94123 -121.94833 Clayton 53 [{"latitude": "37.93475", "longitude": "-121.94558"}, {"latitude": "37.93735", "longitude": "-121.94473"}, {"latitude": "37.94087", "longitude": "-121.94497"}, {"latitude": "37.9401", "longitude": "-121.948"}, {"latitude": "37.93523", "longitude": "-121.94658"}]
702655 November 08, 2019 - 17:41:45 UTC 37.9246 -121.91867 Clayton 53 []
703482 November 10, 2019 - 00:13:41 UTC 37.94233 -121.94899 Clayton 53 []
704188 November 11, 2019 - 11:57:53 UTC 37.8723 -121.87452 Clayton 53 []
709371 November 18, 2019 - 20:24:22 UTC 37.88436 -121.8319 Clayton 53 []
711486 November 20, 2019 - 18:57:26 UTC 37.88559 -121.87024 Clayton 53 []
714437 November 25, 2019 - 20:18:41 UTC 37.94446 -121.94768 Clayton 53 []
714498 November 25, 2019 - 21:01:22 UTC 37.92784 -121.94055 Clayton 53 []
715183 November 26, 2019 - 18:08:34 UTC 37.92784 -121.94055 Clayton 53 []
717584 November 27, 2019 - 02:52:00 UTC 37.88504 -121.85857 Clayton 53 []
724234 November 30, 2019 - 20:27:09 UTC 37.90148 -121.86797 Clayton 53 []
739414 December 14, 2019 - 17:39:48 UTC 37.86784 -121.85688 Clayton 53 [{"latitude": "37.84116", "longitude": "-121.82496"}, {"latitude": "37.86608", "longitude": "-121.84643"}, {"latitude": "37.86753", "longitude": "-121.85514"}, {"latitude": "37.86709", "longitude": "-121.85822"}, {"latitude": "37.85273", "longitude": "-121.8486"}, {"latitude": "37.84263", "longitude": "-121.8391"}]
740107 December 15, 2019 - 17:08:37 UTC 37.86544 -121.85302 Clayton 53 []
743538 December 16, 2019 - 20:20:05 UTC 37.93912 -121.9396 Clayton 53 []
771471 January 28, 2020 - 16:30:19 UTC 37.84963 -121.93205 Clayton 53 []
780723 February 09, 2020 - 01:22:00 UTC 37.92449 -121.9125 Clayton 53 [{"latitude": "37.84116", "longitude": "-121.82496"}, {"latitude": "37.86712", "longitude": "-121.73304"}, {"latitude": "37.87427", "longitude": "-121.72415"}, {"latitude": "37.89466", "longitude": "-121.77392"}, {"latitude": "37.92426", "longitude": "-121.905"}, {"latitude": "37.92423", "longitude": "-121.91157"}, {"latitude": "37.92379", "longitude": "-121.91202"}, {"latitude": "37.92341", "longitude": "-121.91208"}, {"latitude": "37.92294", "longitude": "-121.91211"}, {"latitude": "37.89254", "longitude": "-121.90786"}, {"latitude": "37.85114", "longitude": "-121.89392"}, {"latitude": "37.84263", "longitude": "-121.8391"}]
780730 February 09, 2020 - 01:27:30 UTC 37.92118 -121.91268 Clayton 53 []
780731 February 09, 2020 - 01:27:59 UTC 37.93866 -121.93351 Clayton 53 []
781008 February 09, 2020 - 15:04:00 UTC 37.89125 -121.87105 Clayton 53 []
788445 February 11, 2020 - 17:06:46 UTC 37.88985 -121.79272 Clayton 53 []
788981 February 11, 2020 - 23:43:00 UTC 37.88401 -121.86741 Clayton 53 []
788982 February 11, 2020 - 23:43:00 UTC 37.8804 -121.86901 Clayton 53 []
788984 February 11, 2020 - 23:45:28 UTC 37.88035 -121.87482 Clayton 53 []
1071662 September 15, 2020 - 17:12:00 UTC 37.88783 -121.86753 Clayton 53 [{"latitude": "37.84116", "longitude": "-121.82496"}, {"latitude": "37.88786", "longitude": "-121.856"}, {"latitude": "37.88737", "longitude": "-121.86719"}, {"latitude": "37.88559", "longitude": "-121.87024"}, {"latitude": "37.88035", "longitude": "-121.87482"}, {"latitude": "37.85114", "longitude": "-121.89392"}, {"latitude": "37.84263", "longitude": "-121.8391"}]
1082100 September 19, 2020 - 14:39:00 UTC 37.92511 -121.91535 Clayton 53 [{"latitude": "37.92261", "longitude": "-121.91542"}, {"latitude": "37.92349", "longitude": "-121.91471"}, {"latitude": "37.92456", "longitude": "-121.915"}, {"latitude": "37.92365", "longitude": "-121.91545"}]
1083098 September 20, 2020 - 00:57:13 UTC 37.92796 -121.94158 Clayton 53 [{"latitude": "37.92784", "longitude": "-121.94055"}, {"latitude": "37.93078", "longitude": "-121.93943"}, {"latitude": "37.93275", "longitude": "-121.93925"}]
1093786 September 26, 2020 - 16:19:50 UTC 37.93393 -121.9263 Clayton 53 [{"latitude": "37.93312", "longitude": "-121.92354"}, {"latitude": "37.93642", "longitude": "-121.92588"}, {"latitude": "37.93744", "longitude": "-121.92764"}, {"latitude": "37.93457", "longitude": "-121.92648"}, {"latitude": "37.93364", "longitude": "-121.92474"}]
1095212 September 27, 2020 - 20:46:00 UTC 37.88565 -121.7857 Clayton 53 []
1095215 September 27, 2020 - 20:48:00 UTC 37.89235 -121.85523 Clayton 53 []
1095218 September 27, 2020 - 20:49:00 UTC 37.88985 -121.79272 Clayton 53 []
1095221 September 27, 2020 - 20:55:13 UTC 37.89373 -121.79325 Clayton 53 []
1095223 September 27, 2020 - 21:00:00 UTC 37.88326 -121.83652 Clayton 53 []
1096188 September 28, 2020 - 16:58:27 UTC 37.89235 -121.85523 Clayton 53 []
1098277 September 29, 2020 - 16:34:19 UTC 37.86951 -121.87458 Clayton 53 []
1104535 October 01, 2020 - 19:47:49 UTC 37.88035 -121.87482 Clayton 53 []
1112230 October 06, 2020 - 21:09:58 UTC 37.88953 -121.80767 Clayton 53 []
1112231 October 06, 2020 - 21:09:58 UTC 37.88565 -121.7857 Clayton 53 []
1112235 October 06, 2020 - 21:09:58 UTC 37.89008 -121.8064 Clayton 53 []
1112238 October 06, 2020 - 21:09:58 UTC 37.88985 -121.79272 Clayton 53 []
1112336 October 06, 2020 - 23:11:22 UTC 37.89061 -121.85183 Clayton 53 []
1112349 October 06, 2020 - 23:26:03 UTC 37.8866 -121.81359 Clayton 53 []
1113115 October 08, 2020 - 00:29:02 UTC 37.93171 -121.93697 Clayton 53 []
1118049 October 15, 2020 - 03:14:21 UTC 37.88163 -121.88568 Clayton 53 [{"latitude": "37.8911", "longitude": "-121.90655"}, {"latitude": "37.89182", "longitude": "-121.90716"}, {"latitude": "37.89254", "longitude": "-121.90786"}, {"latitude": "37.89223", "longitude": "-121.90758"}]
1118121 October 15, 2020 - 03:25:14 UTC 37.86831 -121.85801 Clayton 53 []
1118122 October 15, 2020 - 03:25:14 UTC 37.86885 -121.85255 Clayton 53 []
1118152 October 15, 2020 - 03:30:00 UTC 37.88849 -121.86937 Clayton 53 [{"latitude": "37.88608", "longitude": "-121.87143"}, {"latitude": "37.88738", "longitude": "-121.86865"}, {"latitude": "37.88849", "longitude": "-121.87088"}]
1118982 October 16, 2020 - 05:38:00 UTC 37.88783 -121.86753 Clayton 53 [{"latitude": "37.84116", "longitude": "-121.82496"}, {"latitude": "37.88786", "longitude": "-121.856"}, {"latitude": "37.88737", "longitude": "-121.86719"}, {"latitude": "37.88559", "longitude": "-121.87024"}, {"latitude": "37.88035", "longitude": "-121.87482"}, {"latitude": "37.85114", "longitude": "-121.89392"}, {"latitude": "37.84263", "longitude": "-121.8391"}]
1118990 October 16, 2020 - 05:37:00 UTC 37.88849 -121.86937 Clayton 53 [{"latitude": "37.88608", "longitude": "-121.87143"}, {"latitude": "37.88738", "longitude": "-121.86865"}, {"latitude": "37.88849", "longitude": "-121.87088"}]
1118996 October 16, 2020 - 05:43:00 UTC 37.88903 -121.86963 Clayton 53 [{"latitude": "37.88345", "longitude": "-121.87717"}, {"latitude": "37.88809", "longitude": "-121.87246"}, {"latitude": "37.89254", "longitude": "-121.90786"}, {"latitude": "37.89223", "longitude": "-121.90758"}, {"latitude": "37.8911", "longitude": "-121.90655"}, {"latitude": "37.88346", "longitude": "-121.87896"}]
1122588 October 21, 2020 - 23:36:21 UTC 37.89373 -121.79325 Clayton 53 []
1123943 October 23, 2020 - 15:43:37 UTC 37.94625 -121.94173 Clayton 53 [{"latitude": "37.94605", "longitude": "-121.94283"}, {"latitude": "37.94751", "longitude": "-121.94301"}, {"latitude": "37.94664", "longitude": "-121.94366"}]
1127297 October 26, 2020 - 03:03:00 UTC 37.94316 -121.92564 Clayton 53 [{"latitude": "37.93005", "longitude": "-121.8694"}, {"latitude": "37.94221", "longitude": "-121.8859"}, {"latitude": "37.94385", "longitude": "-121.89044"}]
1127329 October 26, 2020 - 03:15:00 UTC 37.92449 -121.9125 Clayton 53 [{"latitude": "37.86679", "longitude": "-121.74203"}, {"latitude": "37.86712", "longitude": "-121.73304"}, {"latitude": "37.87399", "longitude": "-121.72447"}, {"latitude": "37.89466", "longitude": "-121.77392"}, {"latitude": "37.92426", "longitude": "-121.905"}, {"latitude": "37.92423", "longitude": "-121.91157"}, {"latitude": "37.92379", "longitude": "-121.91202"}, {"latitude": "37.92341", "longitude": "-121.91208"}, {"latitude": "37.92296", "longitude": "-121.91211"}, {"latitude": "37.91914", "longitude": "-121.91104"}, {"latitude": "37.90753", "longitude": "-121.9065"}, {"latitude": "37.88376", "longitude": "-121.84"}, {"latitude": "37.8829", "longitude": "-121.83585"}, {"latitude": "37.86777", "longitude": "-121.74783"}]
1127360 October 26, 2020 - 03:15:00 UTC 37.90393 -121.87407 Clayton 53 [{"latitude": "37.84116", "longitude": "-121.82496"}, {"latitude": "37.88786", "longitude": "-121.856"}, {"latitude": "37.90343", "longitude": "-121.87245"}, {"latitude": "37.90341", "longitude": "-121.87366"}, {"latitude": "37.89254", "longitude": "-121.90786"}, {"latitude": "37.85114", "longitude": "-121.89392"}, {"latitude": "37.84263", "longitude": "-121.8391"}]
1129839 October 27, 2020 - 17:13:33 UTC 37.92118 -121.91268 Clayton 53 []
1130016 October 27, 2020 - 19:43:44 UTC 37.94462 -121.94157 Clayton 53 []
1130747 October 28, 2020 - 18:22:38 UTC 37.9307 -121.94193 Clayton 53 []
1130858 October 28, 2020 - 20:15:02 UTC 37.95191 -121.92925 Clayton 53 []
1130996 October 28, 2020 - 23:00:00 UTC 37.92637 -121.9439 Clayton 53 []
1132184 October 30, 2020 - 17:03:45 UTC 37.89892 -121.87298 Clayton 53 []
1138539 November 07, 2020 - 18:13:20 UTC 37.89223 -121.90758 Clayton 53 []
1138717 November 07, 2020 - 20:28:07 UTC 37.8834 -121.87717 Clayton 53 [{"latitude": "37.8911", "longitude": "-121.90655"}, {"latitude": "37.89182", "longitude": "-121.90716"}, {"latitude": "37.89254", "longitude": "-121.90786"}, {"latitude": "37.89223", "longitude": "-121.90758"}]
1139511 November 08, 2020 - 21:18:34 UTC 37.88183 -121.91873 Clayton 53 []
1140516 November 09, 2020 - 22:12:59 UTC 37.94462 -121.94157 Clayton 53 []
1140992 November 10, 2020 - 17:14:00 UTC 37.86574 -121.85533 Clayton 53 [{"latitude": "37.8656", "longitude": "-121.84629"}, {"latitude": "37.86586", "longitude": "-121.84671"}, {"latitude": "37.86613", "longitude": "-121.85232"}, {"latitude": "37.86593", "longitude": "-121.85334"}]
1142281 November 12, 2020 - 15:06:48 UTC 37.89694 -121.85968 Clayton 53 [{"latitude": "37.86679", "longitude": "-121.74203"}, {"latitude": "37.86712", "longitude": "-121.73304"}, {"latitude": "37.87399", "longitude": "-121.72447"}, {"latitude": "37.89452", "longitude": "-121.77387"}, {"latitude": "37.89468", "longitude": "-121.77515"}, {"latitude": "37.89535", "longitude": "-121.85644"}, {"latitude": "37.892", "longitude": "-121.85559"}, {"latitude": "37.89002", "longitude": "-121.8541"}, {"latitude": "37.88368", "longitude": "-121.8399"}, {"latitude": "37.8829", "longitude": "-121.83585"}, {"latitude": "37.86777", "longitude": "-121.74783"}]
1142693 November 12, 2020 - 18:20:10 UTC 37.88419 -121.8318 Clayton 53 []
1142694 November 12, 2020 - 18:20:11 UTC 37.88988 -121.85148 Clayton 53 []
1142892 November 12, 2020 - 21:53:19 UTC 37.88632 -121.81341 Clayton 53 []
1147169 November 17, 2020 - 18:43:10 UTC 37.86839 -121.85745 Clayton 53 []
1148221 November 18, 2020 - 15:26:02 UTC 37.89694 -121.85968 Clayton 53 [{"latitude": "37.86679", "longitude": "-121.74203"}, {"latitude": "37.86708", "longitude": "-121.73276"}, {"latitude": "37.87399", "longitude": "-121.72447"}, {"latitude": "37.89452", "longitude": "-121.77387"}, {"latitude": "37.89468", "longitude": "-121.77515"}, {"latitude": "37.89535", "longitude": "-121.85644"}, {"latitude": "37.892", "longitude": "-121.85559"}, {"latitude": "37.89002", "longitude": "-121.8541"}, {"latitude": "37.88368", "longitude": "-121.8399"}, {"latitude": "37.88266", "longitude": "-121.8354"}, {"latitude": "37.86777", "longitude": "-121.74783"}]
1148581 November 18, 2020 - 19:41:19 UTC 37.88957 -121.80723 Clayton 53 []
1148771 November 18, 2020 - 20:44:11 UTC 37.89121 -121.84779 Clayton 53 []

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
);