outages

111 rows where regionName = 486

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: outageDevices

id ▼ outageStartTime latitude longitude regionName outageDevices
644758 October 05, 2019 - 21:01:00 UTC 36.86626 -121.62184 Aromas 486 [{"latitude": "36.85891", "longitude": "-121.63046"}, {"latitude": "36.86272", "longitude": "-121.62224"}, {"latitude": "36.86466", "longitude": "-121.6223"}, {"latitude": "36.8657", "longitude": "-121.62598"}, {"latitude": "36.8658", "longitude": "-121.63345"}, {"latitude": "36.86097", "longitude": "-121.63174"}]
645106 October 05, 2019 - 21:01:00 UTC 36.86626 -121.62184 Aromas 486 [{"latitude": "36.85891", "longitude": "-121.63046"}, {"latitude": "36.86272", "longitude": "-121.62224"}, {"latitude": "36.86466", "longitude": "-121.6223"}, {"latitude": "36.8657", "longitude": "-121.62598"}, {"latitude": "36.8658", "longitude": "-121.63345"}, {"latitude": "36.86097", "longitude": "-121.63174"}]
645914 October 07, 2019 - 16:10:59 UTC 36.87194 -121.65531 Aromas 486 []
647335 October 08, 2019 - 16:34:44 UTC 36.87656 -121.62955 Aromas 486 [{"latitude": "36.87733", "longitude": "-121.62955"}, {"latitude": "36.87815", "longitude": "-121.62953"}, {"latitude": "36.88015", "longitude": "-121.62983"}]
655708 October 14, 2019 - 03:34:01 UTC 36.87513 -121.6343 Aromas 486 []
655907 October 14, 2019 - 15:57:00 UTC 36.87408 -121.57391 Aromas 486 [{"latitude": "36.85384", "longitude": "-121.5877"}, {"latitude": "36.85439", "longitude": "-121.57207"}, {"latitude": "36.87423", "longitude": "-121.57519"}, {"latitude": "36.87825", "longitude": "-121.59268"}, {"latitude": "36.87554", "longitude": "-121.59518"}, {"latitude": "36.87342", "longitude": "-121.59697"}, {"latitude": "36.87164", "longitude": "-121.59836"}, {"latitude": "36.87024", "longitude": "-121.59863"}, {"latitude": "36.85898", "longitude": "-121.59804"}, {"latitude": "36.85396", "longitude": "-121.5889"}]
660413 October 16, 2019 - 15:56:49 UTC 36.87544 -121.64226 Aromas 486 []
660874 October 16, 2019 - 18:24:54 UTC 36.87436 -121.64237 Aromas 486 []
660876 October 16, 2019 - 18:30:34 UTC 36.8739 -121.64251 Aromas 486 []
680630 October 26, 2019 - 00:04:58 UTC 36.88113 -121.64236 Aromas 486 []
688591 October 27, 2019 - 19:50:01 UTC 36.86287 -121.66567 Aromas 486 [{"latitude": "36.8629", "longitude": "-121.66547"}, {"latitude": "36.8645", "longitude": "-121.66398"}, {"latitude": "36.86472", "longitude": "-121.6649"}, {"latitude": "36.86492", "longitude": "-121.66635"}]
692213 October 27, 2019 - 04:19:00 UTC 36.87656 -121.62955 Aromas 486 [{"latitude": "36.87733", "longitude": "-121.62955"}, {"latitude": "36.87815", "longitude": "-121.62953"}, {"latitude": "36.88015", "longitude": "-121.62983"}]
692239 October 28, 2019 - 23:13:52 UTC 36.88073 -121.63995 Aromas 486 []
703335 November 09, 2019 - 18:16:16 UTC 36.87978 -121.64141 Aromas 486 []
704288 November 11, 2019 - 17:11:16 UTC 36.87531 -121.63899 Aromas 486 []
704540 November 11, 2019 - 23:46:49 UTC 36.90596 -121.66773 Aromas 486 []
707358 November 15, 2019 - 16:37:00 UTC 36.88632 -121.63385 Aromas 486 [{"latitude": "36.88482", "longitude": "-121.63482"}, {"latitude": "36.88616", "longitude": "-121.63379"}, {"latitude": "36.88728", "longitude": "-121.63429"}]
708263 November 16, 2019 - 18:40:57 UTC 36.88722 -121.6714 Aromas 486 []
711354 November 20, 2019 - 17:39:13 UTC 36.88466 -121.64569 Aromas 486 []
712521 November 22, 2019 - 00:22:44 UTC 36.8582 -121.64352 Aromas 486 []
718397 November 27, 2019 - 04:19:01 UTC 36.87844 -121.669 Aromas 486 []
718454 November 27, 2019 - 04:23:00 UTC 36.87709 -121.66548 Aromas 486 []
722619 November 28, 2019 - 14:50:43 UTC 36.88015 -121.62983 Aromas 486 []
722620 November 28, 2019 - 14:50:43 UTC 36.88366 -121.6296 Aromas 486 []
722621 November 28, 2019 - 14:50:43 UTC 36.88114 -121.63326 Aromas 486 []
722622 November 28, 2019 - 14:50:43 UTC 36.88354 -121.63425 Aromas 486 []
722623 November 28, 2019 - 14:50:43 UTC 36.88167 -121.63722 Aromas 486 []
722624 November 28, 2019 - 14:50:43 UTC 36.88379 -121.63297 Aromas 486 []
722625 November 28, 2019 - 14:50:43 UTC 36.88073 -121.63995 Aromas 486 []
725438 December 01, 2019 - 08:49:58 UTC 36.87941 -121.64425 Aromas 486 []
725744 December 01, 2019 - 15:39:37 UTC 36.8783 -121.64402 Aromas 486 []
727608 December 02, 2019 - 20:28:58 UTC 36.87253 -121.62536 Aromas 486 []
730135 December 05, 2019 - 03:32:13 UTC 36.86715 -121.62129 Aromas 486 [{"latitude": "36.86005", "longitude": "-121.61057"}, {"latitude": "36.86545", "longitude": "-121.61216"}, {"latitude": "36.86691", "longitude": "-121.61813"}, {"latitude": "36.86721", "longitude": "-121.62243"}, {"latitude": "36.86168", "longitude": "-121.61346"}]
730967 December 06, 2019 - 04:28:53 UTC 36.87662 -121.64748 Aromas 486 []
732380 December 07, 2019 - 16:55:21 UTC 36.85648 -121.63848 Aromas 486 []
733608 December 08, 2019 - 16:38:36 UTC 36.88509 -121.67131 Aromas 486 []
737482 December 12, 2019 - 18:15:00 UTC 36.87988 -121.64415 Aromas 486 []
738332 December 13, 2019 - 17:00:00 UTC 36.86972 -121.64492 Aromas 486 []
739815 December 14, 2019 - 23:07:03 UTC 36.88379 -121.63297 Aromas 486 []
741340 December 16, 2019 - 16:38:20 UTC 36.8879 -121.63285 Aromas 486 []
744539 December 17, 2019 - 19:36:00 UTC 36.88486 -121.62647 Aromas 486 []
784800 February 09, 2020 - 22:09:16 UTC 36.88015 -121.62983 Aromas 486 []
786999 February 10, 2020 - 16:11:57 UTC 36.87849 -121.64172 Aromas 486 [{"latitude": "36.87663", "longitude": "-121.64466"}, {"latitude": "36.87666", "longitude": "-121.64328"}, {"latitude": "36.87844", "longitude": "-121.64211"}, {"latitude": "36.87985", "longitude": "-121.64217"}, {"latitude": "36.87988", "longitude": "-121.64415"}, {"latitude": "36.87733", "longitude": "-121.64493"}]
789885 February 13, 2020 - 01:46:45 UTC 36.88244 -121.62116 Aromas 486 []
789893 February 13, 2020 - 01:55:24 UTC 36.88373 -121.62059 Aromas 486 []
789924 February 13, 2020 - 01:46:00 UTC 36.88375 -121.62065 Aromas 486 []
790019 February 13, 2020 - 05:18:00 UTC 36.88373 -121.62059 Aromas 486 []
1061566 September 09, 2020 - 02:59:54 UTC 36.87584 -121.66381 Aromas 486 []
1061570 September 09, 2020 - 03:03:55 UTC 36.87713 -121.66317 Aromas 486 []
1061578 September 09, 2020 - 03:16:24 UTC 36.8766 -121.66189 Aromas 486 []
1061583 September 09, 2020 - 03:18:25 UTC 36.8737 -121.66226 Aromas 486 []
1063128 September 10, 2020 - 18:22:28 UTC 36.85648 -121.63848 Aromas 486 []
1066353 September 12, 2020 - 19:45:57 UTC 36.89597 -121.64647 Aromas 486 []
1082061 September 19, 2020 - 12:29:19 UTC 36.88069 -121.63648 Aromas 486 []
1082092 September 19, 2020 - 13:54:00 UTC 36.88354 -121.63425 Aromas 486 []
1082240 September 19, 2020 - 13:54:26 UTC 36.88069 -121.63648 Aromas 486 []
1107193 October 02, 2020 - 18:52:24 UTC 36.88462 -121.64239 Aromas 486 []
1108755 October 03, 2020 - 06:07:15 UTC 36.89725 -121.65298 Aromas 486 []
1108756 October 03, 2020 - 06:07:15 UTC 36.89453 -121.65028 Aromas 486 []
1110815 October 04, 2020 - 17:31:17 UTC 36.89774 -121.64633 Aromas 486 []
1110822 October 04, 2020 - 17:52:09 UTC 36.90013 -121.65337 Aromas 486 []
1112938 October 07, 2020 - 20:17:32 UTC 36.88069 -121.63648 Aromas 486 []
1114325 October 09, 2020 - 16:45:00 UTC 36.85521 -121.63377 Aromas 486 [{"latitude": "36.85583", "longitude": "-121.6331"}, {"latitude": "36.85615", "longitude": "-121.6332"}, {"latitude": "36.85649", "longitude": "-121.63332"}, {"latitude": "36.85714", "longitude": "-121.63359"}]
1116254 October 13, 2020 - 13:35:19 UTC 36.9077 -121.65872 Aromas 486 []
1116926 October 14, 2020 - 03:24:59 UTC 36.9077 -121.65872 Aromas 486 []
1137151 November 06, 2020 - 16:30:00 UTC 36.88604 -121.59382 Aromas 486 []
1138461 November 07, 2020 - 17:04:57 UTC 36.89597 -121.64647 Aromas 486 []
1155250 November 27, 2020 - 21:20:58 UTC 36.88078 -121.63591 Aromas 486 []
1156342 November 30, 2020 - 18:43:14 UTC 36.86662 -121.64211 Aromas 486 []
1165011 December 05, 2020 - 19:49:44 UTC 36.87844 -121.669 Aromas 486 []
1165013 December 05, 2020 - 19:50:54 UTC 36.87682 -121.66644 Aromas 486 []
1183529 December 14, 2020 - 16:37:00 UTC 36.87253 -121.65339 Aromas 486 []
1193097 December 18, 2020 - 03:20:06 UTC 36.88751 -121.6559 Aromas 486 []
1193971 December 18, 2020 - 22:35:15 UTC 36.86097 -121.63174 Aromas 486 []
1193973 December 18, 2020 - 22:35:15 UTC 36.86044 -121.62914 Aromas 486 []
1193974 December 18, 2020 - 22:34:31 UTC 36.86311 -121.63148 Aromas 486 []
1193977 December 18, 2020 - 22:34:30 UTC 36.8658 -121.63345 Aromas 486 []
1193982 December 18, 2020 - 22:45:00 UTC 36.86515 -121.63012 Aromas 486 []
1204230 January 05, 2021 - 05:50:37 UTC 36.90962 -121.66026 Aromas 486 []
1204641 January 05, 2021 - 20:32:06 UTC 36.88751 -121.6559 Aromas 486 []
1211780 January 17, 2021 - 18:12:30 UTC 36.85841 -121.64267 Aromas 486 []
1215070 January 19, 2021 - 14:26:48 UTC 36.87988 -121.64415 Aromas 486 []
1215457 January 19, 2021 - 15:34:00 UTC 36.86836 -121.66057 Aromas 486 []
1215478 January 19, 2021 - 15:37:28 UTC 36.90757 -121.66812 Aromas 486 []
1215479 January 19, 2021 - 15:37:29 UTC 36.90647 -121.66786 Aromas 486 []
1215837 January 19, 2021 - 16:14:42 UTC 36.90757 -121.66812 Aromas 486 []
1215958 January 19, 2021 - 16:55:53 UTC 36.90647 -121.66786 Aromas 486 []
1216810 January 19, 2021 - 19:43:32 UTC 36.89742 -121.66969 Aromas 486 []
1217063 January 19, 2021 - 20:43:35 UTC 36.89401 -121.66921 Aromas 486 []
1217813 January 20, 2021 - 01:31:10 UTC 36.89774 -121.64633 Aromas 486 []
1217820 January 20, 2021 - 01:33:00 UTC 36.87941 -121.64425 Aromas 486 []
1218044 January 20, 2021 - 04:16:32 UTC 36.90517 -121.65988 Aromas 486 []
1218088 January 20, 2021 - 05:10:04 UTC 36.90962 -121.66026 Aromas 486 []
1218644 January 20, 2021 - 18:50:57 UTC 36.89474 -121.62856 Aromas 486 []
1218960 January 20, 2021 - 22:39:13 UTC 36.89129 -121.61371 Aromas 486 []
1219151 January 21, 2021 - 01:16:50 UTC 36.90966 -121.65798 Aromas 486 []
1219208 January 21, 2021 - 02:12:33 UTC 36.88723 -121.65313 Aromas 486 []
1219540 January 21, 2021 - 16:25:45 UTC 36.90966 -121.65798 Aromas 486 []
1238756 January 28, 2021 - 15:43:56 UTC 36.87978 -121.64141 Aromas 486 []
1241859 January 29, 2021 - 20:45:50 UTC 36.8702 -121.66878 Aromas 486 []

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