outages

68 rows where regionName = 133

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices
633844 October 01, 2019 - 16:29:24 UTC 37.37402 -121.8091 East Foothills 133 [{"latitude": "37.37242", "longitude": "-121.81029"}, {"latitude": "37.37342", "longitude": "-121.80956"}, {"latitude": "37.37308", "longitude": "-121.80981"}]
633854 October 01, 2019 - 16:33:16 UTC 37.3744 -121.80994 East Foothills 133 []
639063 October 03, 2019 - 15:37:00 UTC 37.379 -121.81942 East Foothills 133 [{"latitude": "37.37914", "longitude": "-121.81976"}, {"latitude": "37.38087", "longitude": "-121.82317"}, {"latitude": "37.37994", "longitude": "-121.82177"}]
647376 October 08, 2019 - 17:14:10 UTC 37.37309 -121.81228 East Foothills 133 []
652285 October 10, 2019 - 06:30:05 UTC 37.3796 -121.82863 East Foothills 133 []
652580 October 10, 2019 - 12:31:35 UTC 37.3901 -121.81414 East Foothills 133 [{"latitude": "37.38829", "longitude": "-121.81208"}, {"latitude": "37.38962", "longitude": "-121.80916"}, {"latitude": "37.3901", "longitude": "-121.80921"}, {"latitude": "37.39174", "longitude": "-121.81161"}, {"latitude": "37.391", "longitude": "-121.81539"}]
652582 October 10, 2019 - 12:31:59 UTC 37.38952 -121.8185 East Foothills 133 []
652583 October 10, 2019 - 12:33:49 UTC 37.39315 -121.82349 East Foothills 133 []
652585 October 10, 2019 - 12:43:00 UTC 37.39049 -121.81759 East Foothills 133 []
653080 October 10, 2019 - 06:13:00 UTC 37.37545 -121.82069 East Foothills 133 [{"latitude": "37.35976", "longitude": "-121.79948"}, {"latitude": "37.36187", "longitude": "-121.79058"}, {"latitude": "37.37111", "longitude": "-121.79803"}, {"latitude": "37.37761", "longitude": "-121.81375"}, {"latitude": "37.37767", "longitude": "-121.81776"}, {"latitude": "37.37711", "longitude": "-121.81846"}, {"latitude": "37.37519", "longitude": "-121.82005"}, {"latitude": "37.37354", "longitude": "-121.82027"}, {"latitude": "37.3635", "longitude": "-121.81093"}]
653086 October 10, 2019 - 06:13:00 UTC 37.37611 -121.82083 East Foothills 133 [{"latitude": "37.37614", "longitude": "-121.81727"}, {"latitude": "37.37619", "longitude": "-121.8133"}, {"latitude": "37.37637", "longitude": "-121.80703"}, {"latitude": "37.38785", "longitude": "-121.80799"}, {"latitude": "37.38883", "longitude": "-121.80919"}, {"latitude": "37.38927", "longitude": "-121.81408"}, {"latitude": "37.3887", "longitude": "-121.81497"}, {"latitude": "37.38496", "longitude": "-121.82023"}, {"latitude": "37.38023", "longitude": "-121.82421"}, {"latitude": "37.37686", "longitude": "-121.82189"}, {"latitude": "37.37637", "longitude": "-121.82067"}]
653089 October 10, 2019 - 06:13:00 UTC 37.38569 -121.81304 East Foothills 133 [{"latitude": "37.36767", "longitude": "-121.78667"}, {"latitude": "37.36888", "longitude": "-121.77443"}, {"latitude": "37.36962", "longitude": "-121.77378"}, {"latitude": "37.37476", "longitude": "-121.77213"}, {"latitude": "37.37685", "longitude": "-121.77146"}, {"latitude": "37.38638", "longitude": "-121.79414"}, {"latitude": "37.38665", "longitude": "-121.79563"}, {"latitude": "37.38661", "longitude": "-121.80806"}, {"latitude": "37.38514", "longitude": "-121.81388"}, {"latitude": "37.3836", "longitude": "-121.81484"}, {"latitude": "37.38094", "longitude": "-121.81367"}, {"latitude": "37.3738", "longitude": "-121.80517"}, {"latitude": "37.37322", "longitude": "-121.8036"}]
653389 October 10, 2019 - 21:00:14 UTC 37.39315 -121.82349 East Foothills 133 []
653403 October 10, 2019 - 21:10:00 UTC 37.39396 -121.82731 East Foothills 133 []
653508 October 10, 2019 - 22:13:00 UTC 37.39315 -121.82349 East Foothills 133 []
653581 October 10, 2019 - 22:58:00 UTC 37.3757 -121.80222 East Foothills 133 []
653643 October 10, 2019 - 23:43:01 UTC 37.39151 -121.81911 East Foothills 133 []
653681 October 11, 2019 - 00:17:00 UTC 37.38413 -121.80765 East Foothills 133 []
655034 October 12, 2019 - 14:16:00 UTC 37.37715 -121.81663 East Foothills 133 []
655069 October 12, 2019 - 15:10:44 UTC 37.38154 -121.81746 East Foothills 133 []
657133 October 14, 2019 - 18:17:38 UTC 37.37559 -121.79895 East Foothills 133 []
674919 October 20, 2019 - 23:34:29 UTC 37.38077 -121.81912 East Foothills 133 []
675865 October 21, 2019 - 15:54:27 UTC 37.37625 -121.80106 East Foothills 133 [{"latitude": "37.37322", "longitude": "-121.8036"}, {"latitude": "37.37443", "longitude": "-121.80199"}, {"latitude": "37.37598", "longitude": "-121.80163"}, {"latitude": "37.37578", "longitude": "-121.80338"}, {"latitude": "37.37562", "longitude": "-121.80395"}, {"latitude": "37.37518", "longitude": "-121.8044"}, {"latitude": "37.37353", "longitude": "-121.80418"}]
675869 October 21, 2019 - 15:55:25 UTC 37.37656 -121.79725 East Foothills 133 [{"latitude": "37.37696", "longitude": "-121.79817"}, {"latitude": "37.37806", "longitude": "-121.79795"}, {"latitude": "37.3779", "longitude": "-121.79868"}]
676090 October 21, 2019 - 17:46:39 UTC 37.37701 -121.81321 East Foothills 133 []
679186 October 24, 2019 - 04:34:54 UTC 37.38784 -121.83021 East Foothills 133 []
688069 October 27, 2019 - 18:25:46 UTC 37.38869 -121.82824 East Foothills 133 []
688087 October 27, 2019 - 18:29:28 UTC 37.36988 -121.8086 East Foothills 133 []
689146 October 27, 2019 - 20:53:05 UTC 37.39162 -121.82019 East Foothills 133 []
690347 October 28, 2019 - 00:01:05 UTC 37.38514 -121.81388 East Foothills 133 []
691655 October 28, 2019 - 17:53:19 UTC 37.38496 -121.82023 East Foothills 133 []
692066 October 28, 2019 - 21:47:54 UTC 37.38578 -121.81499 East Foothills 133 []
692468 October 29, 2019 - 00:39:32 UTC 37.3827 -121.81714 East Foothills 133 [{"latitude": "37.38323", "longitude": "-121.81743"}, {"latitude": "37.38429", "longitude": "-121.81799"}, {"latitude": "37.3855", "longitude": "-121.81863"}, {"latitude": "37.38496", "longitude": "-121.82023"}]
694902 October 30, 2019 - 16:22:46 UTC 37.37841 -121.81325 East Foothills 133 [{"latitude": "37.37619", "longitude": "-121.8133"}, {"latitude": "37.37737", "longitude": "-121.81154"}, {"latitude": "37.37833", "longitude": "-121.81199"}, {"latitude": "37.37838", "longitude": "-121.81321"}, {"latitude": "37.37654", "longitude": "-121.81399"}]
695088 October 30, 2019 - 17:49:00 UTC 37.37699 -121.81435 East Foothills 133 []
695751 October 30, 2019 - 23:19:21 UTC 37.37684 -121.81526 East Foothills 133 []
698165 November 02, 2019 - 16:28:02 UTC 37.37619 -121.81162 East Foothills 133 []
698607 November 03, 2019 - 18:09:00 UTC 37.37545 -121.82069 East Foothills 133 [{"latitude": "37.35976", "longitude": "-121.79948"}, {"latitude": "37.36187", "longitude": "-121.79058"}, {"latitude": "37.37111", "longitude": "-121.79803"}, {"latitude": "37.37761", "longitude": "-121.81375"}, {"latitude": "37.37767", "longitude": "-121.81776"}, {"latitude": "37.37711", "longitude": "-121.81846"}, {"latitude": "37.37519", "longitude": "-121.82005"}, {"latitude": "37.37354", "longitude": "-121.82027"}, {"latitude": "37.3635", "longitude": "-121.81093"}]
699278 November 04, 2019 - 19:15:37 UTC 37.37925 -121.81177 East Foothills 133 []
700128 November 05, 2019 - 20:38:11 UTC 37.38324 -121.8248 East Foothills 133 []
701822 November 07, 2019 - 17:47:33 UTC 37.38399 -121.81996 East Foothills 133 []
707323 November 15, 2019 - 16:07:08 UTC 37.3901 -121.81414 East Foothills 133 [{"latitude": "37.38829", "longitude": "-121.81208"}, {"latitude": "37.38947", "longitude": "-121.80497"}, {"latitude": "37.39049", "longitude": "-121.80179"}, {"latitude": "37.39566", "longitude": "-121.80241"}, {"latitude": "37.391", "longitude": "-121.81539"}]
709637 November 19, 2019 - 01:30:09 UTC 37.38784 -121.83021 East Foothills 133 []
713579 November 23, 2019 - 23:23:57 UTC 37.37684 -121.81526 East Foothills 133 []
718029 November 27, 2019 - 03:39:39 UTC 37.39065 -121.81294 East Foothills 133 []
724471 November 30, 2019 - 23:06:44 UTC 37.38314 -121.82218 East Foothills 133 []
725105 December 01, 2019 - 03:42:26 UTC 37.38314 -121.82218 East Foothills 133 []
725990 December 01, 2019 - 19:24:40 UTC 37.39158 -121.81714 East Foothills 133 []
730856 December 06, 2019 - 00:30:29 UTC 37.37947 -121.82328 East Foothills 133 []
736570 December 11, 2019 - 20:49:55 UTC 37.36884 -121.80739 East Foothills 133 []
743620 December 16, 2019 - 21:21:53 UTC 37.38077 -121.81912 East Foothills 133 []
743654 December 16, 2019 - 22:04:31 UTC 37.37862 -121.82847 East Foothills 133 []
780479 February 08, 2020 - 08:16:25 UTC 37.37278 -121.81518 East Foothills 133 []
781829 February 09, 2020 - 17:48:09 UTC 37.37619 -121.8133 East Foothills 133 []
782730 February 09, 2020 - 19:07:41 UTC 37.37175 -121.81343 East Foothills 133 []
783024 February 09, 2020 - 19:31:00 UTC 37.38156 -121.82202 East Foothills 133 [{"latitude": "37.38248", "longitude": "-121.823"}, {"latitude": "37.3825", "longitude": "-121.8217"}, {"latitude": "37.38399", "longitude": "-121.81996"}, {"latitude": "37.38624", "longitude": "-121.8198"}, {"latitude": "37.38654", "longitude": "-121.82088"}, {"latitude": "37.3856", "longitude": "-121.82527"}, {"latitude": "37.38469", "longitude": "-121.82562"}]
785999 February 10, 2020 - 02:14:20 UTC 37.38087 -121.82317 East Foothills 133 []
786315 February 10, 2020 - 03:57:00 UTC 37.38314 -121.82218 East Foothills 133 []
786907 February 10, 2020 - 15:19:01 UTC 37.37175 -121.81343 East Foothills 133 []
787080 February 10, 2020 - 16:46:45 UTC 37.38296 -121.81656 East Foothills 133 []
787389 February 10, 2020 - 19:10:31 UTC 37.37278 -121.81518 East Foothills 133 []
787473 February 10, 2020 - 19:10:31 UTC 37.37278 -121.81518 East Foothills 133 []
788902 February 11, 2020 - 22:21:05 UTC 37.37917 -121.82493 East Foothills 133 []
789076 February 12, 2020 - 01:33:21 UTC 37.38237 -121.82001 East Foothills 133 []
1064963 September 11, 2020 - 20:26:13 UTC 37.37805 -121.80756 East Foothills 133 []
1087075 September 22, 2020 - 17:03:00 UTC 37.38017 -121.8183 East Foothills 133 []
1089994 September 23, 2020 - 19:41:55 UTC 37.38897 -121.81117 East Foothills 133 []
1095347 September 27, 2020 - 23:36:41 UTC 37.37914 -121.81976 East Foothills 133 []

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