outages

53 rows where regionName = 53

View and edit SQL

Suggested facets: outageDevices

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"}]

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