outages

345 rows where regionName = 70

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
633591 October 01, 2019 - 14:49:41 UTC 40.51612 -121.94749 Shingletown 70 []
633611 October 01, 2019 - 15:02:18 UTC 40.49137 -121.87263 Shingletown 70 []
633622 October 01, 2019 - 15:08:57 UTC 40.48525 -121.89554 Shingletown 70 []
633638 October 01, 2019 - 15:10:55 UTC 40.53641 -121.78374 Shingletown 70 []
633808 October 01, 2019 - 16:02:26 UTC 40.51465 -121.94384 Shingletown 70 []
633870 October 01, 2019 - 16:35:36 UTC 40.48529 -121.89642 Shingletown 70 []
633879 October 01, 2019 - 16:39:39 UTC 40.52844 -121.79491 Shingletown 70 []
633949 October 01, 2019 - 17:38:27 UTC 40.48364 -121.88148 Shingletown 70 []
633959 October 01, 2019 - 17:50:06 UTC 40.4935 -121.87539 Shingletown 70 []
634313 October 01, 2019 - 19:27:00 UTC 40.51479 -121.94039 Shingletown 70 []
634413 October 01, 2019 - 19:33:08 UTC 40.51125 -121.95736 Shingletown 70 []
634533 October 01, 2019 - 19:49:47 UTC 40.51314 -121.90868 Shingletown 70 []
635794 October 02, 2019 - 15:30:05 UTC 40.51877 -121.84079 Shingletown 70 []
635812 October 02, 2019 - 15:39:54 UTC 40.53832 -121.84126 Shingletown 70 []
635835 October 02, 2019 - 15:48:12 UTC 40.52399 -121.83503 Shingletown 70 []
636133 October 02, 2019 - 16:45:55 UTC 40.53019 -121.83913 Shingletown 70 []
636313 October 02, 2019 - 17:10:47 UTC 40.50333 -121.81957 Shingletown 70 []
636413 October 02, 2019 - 17:12:28 UTC 40.52151 -121.83587 Shingletown 70 []
636416 October 02, 2019 - 17:14:35 UTC 40.51841 -121.83574 Shingletown 70 []
636453 October 02, 2019 - 17:19:19 UTC 40.51777 -121.82258 Shingletown 70 []
636473 October 02, 2019 - 17:20:24 UTC 40.52635 -121.83611 Shingletown 70 []
636973 October 02, 2019 - 18:44:24 UTC 40.52632 -121.83982 Shingletown 70 []
637073 October 02, 2019 - 19:03:13 UTC 40.51969 -121.82541 Shingletown 70 []
637153 October 02, 2019 - 19:11:17 UTC 40.52065 -121.82978 Shingletown 70 []
637735 October 02, 2019 - 20:30:17 UTC 40.52181 -121.83854 Shingletown 70 []
638996 October 03, 2019 - 14:45:13 UTC 40.50992 -121.81447 Shingletown 70 []
639074 October 03, 2019 - 15:40:02 UTC 40.5074 -121.81408 Shingletown 70 []
639182 October 03, 2019 - 16:11:47 UTC 40.50254 -121.84749 Shingletown 70 []
639253 October 03, 2019 - 17:00:48 UTC 40.49906 -121.84319 Shingletown 70 []
639275 October 03, 2019 - 17:16:50 UTC 40.50822 -121.81733 Shingletown 70 []
640234 October 03, 2019 - 19:05:26 UTC 40.5017 -121.93609 Shingletown 70 []
640273 October 03, 2019 - 19:09:05 UTC 40.49938 -121.84614 Shingletown 70 []
641013 October 03, 2019 - 20:52:57 UTC 40.50469 -121.94208 Shingletown 70 []
642267 October 04, 2019 - 14:58:38 UTC 40.50822 -121.80486 Shingletown 70 []
642273 October 04, 2019 - 15:01:52 UTC 40.49026 -121.8591 Shingletown 70 []
642286 October 04, 2019 - 15:11:49 UTC 40.50848 -121.81387 Shingletown 70 []
643073 October 04, 2019 - 16:39:04 UTC 40.53245 -121.73672 Shingletown 70 []
643274 October 04, 2019 - 17:00:33 UTC 40.49814 -121.84917 Shingletown 70 []
643277 October 04, 2019 - 17:02:32 UTC 40.53026 -121.7355 Shingletown 70 []
643419 October 04, 2019 - 17:34:33 UTC 40.50847 -121.81118 Shingletown 70 []
643441 October 04, 2019 - 17:46:12 UTC 40.51022 -121.81828 Shingletown 70 []
643449 October 04, 2019 - 17:49:00 UTC 40.53175 -121.73731 Shingletown 70 []
643555 October 04, 2019 - 19:25:15 UTC 40.53077 -121.73118 Shingletown 70 []
643654 October 04, 2019 - 19:42:38 UTC 40.51047 -121.81762 Shingletown 70 []
643843 October 05, 2019 - 01:53:39 UTC 40.49628 -122.045 Shingletown 70 []
643851 October 05, 2019 - 02:39:27 UTC 40.50951 -122.03369 Shingletown 70 []
643942 October 05, 2019 - 14:19:35 UTC 40.50383 -121.94384 Shingletown 70 []
644685 October 05, 2019 - 18:03:21 UTC 40.53133 -121.72937 Shingletown 70 []
645837 October 07, 2019 - 15:22:31 UTC 40.50636 -121.8111 Shingletown 70 []
646150 October 07, 2019 - 18:57:54 UTC 40.50592 -121.81229 Shingletown 70 []
646907 October 07, 2019 - 23:15:05 UTC 40.52536 -121.75982 Shingletown 70 []
647278 October 08, 2019 - 15:59:41 UTC 40.50454 -121.81229 Shingletown 70 []
647456 October 08, 2019 - 18:56:18 UTC 40.52084 -121.79109 Shingletown 70 []
647498 October 08, 2019 - 19:50:00 UTC 40.40486 -122.12215 Shingletown 70 [{"latitude": "40.33043", "longitude": "-122.08285"}, {"latitude": "40.40475", "longitude": "-122.12167"}, {"latitude": "40.40278", "longitude": "-122.12576"}, {"latitude": "40.33823", "longitude": "-122.13349"}, {"latitude": "40.33466", "longitude": "-122.114"}]
647873 October 09, 2019 - 07:37:00 UTC 40.48608 -122.11506 Shingletown 70 []
647983 October 09, 2019 - 07:15:00 UTC 40.40446 -122.12166 Shingletown 70 [{"latitude": "40.33043", "longitude": "-122.08285"}, {"latitude": "40.40278", "longitude": "-122.12576"}, {"latitude": "40.33823", "longitude": "-122.13349"}, {"latitude": "40.33466", "longitude": "-122.114"}]
648654 October 09, 2019 - 08:55:58 UTC 40.48771 -121.91844 Shingletown 70 []
648655 October 09, 2019 - 08:55:58 UTC 40.50023 -121.91559 Shingletown 70 [{"latitude": "40.49975", "longitude": "-121.9122"}, {"latitude": "40.50137", "longitude": "-121.90624"}, {"latitude": "40.5045", "longitude": "-121.89937"}, {"latitude": "40.50473", "longitude": "-121.90327"}, {"latitude": "40.50472", "longitude": "-121.90546"}, {"latitude": "40.50449", "longitude": "-121.91146"}, {"latitude": "40.5038", "longitude": "-121.91267"}, {"latitude": "40.50214", "longitude": "-121.91457"}, {"latitude": "40.5002", "longitude": "-121.91551"}]
648656 October 09, 2019 - 08:55:58 UTC 40.52493 -121.94844 Shingletown 70 []
648657 October 09, 2019 - 08:55:58 UTC 40.4828 -121.99919 Shingletown 70 []
648658 October 09, 2019 - 08:55:58 UTC 40.48822 -122.00199 Shingletown 70 [{"latitude": "40.48714", "longitude": "-121.99657"}, {"latitude": "40.488", "longitude": "-122.00009"}, {"latitude": "40.48812", "longitude": "-122.00102"}, {"latitude": "40.4873", "longitude": "-121.99734"}]
648659 October 09, 2019 - 08:55:58 UTC 40.47612 -121.97707 Shingletown 70 []
648660 October 09, 2019 - 08:55:58 UTC 40.48995 -121.88602 Shingletown 70 []
648661 October 09, 2019 - 08:55:58 UTC 40.4896 -121.88558 Shingletown 70 [{"latitude": "40.48364", "longitude": "-121.88148"}, {"latitude": "40.49129", "longitude": "-121.88137"}, {"latitude": "40.4869", "longitude": "-121.8943"}, {"latitude": "40.48529", "longitude": "-121.89642"}, {"latitude": "40.48386", "longitude": "-121.8837"}]
648662 October 09, 2019 - 08:55:58 UTC 40.49038 -121.8526 Shingletown 70 []
648663 October 09, 2019 - 08:55:58 UTC 40.51804 -121.75518 Shingletown 70 [{"latitude": "40.51879", "longitude": "-121.75252"}, {"latitude": "40.52977", "longitude": "-121.72868"}, {"latitude": "40.53495", "longitude": "-121.72367"}, {"latitude": "40.5585", "longitude": "-121.70994"}, {"latitude": "40.56644", "longitude": "-121.71278"}, {"latitude": "40.56414", "longitude": "-121.72108"}, {"latitude": "40.56238", "longitude": "-121.7256"}, {"latitude": "40.55881", "longitude": "-121.73333"}, {"latitude": "40.52888", "longitude": "-121.76368"}, {"latitude": "40.52726", "longitude": "-121.76469"}, {"latitude": "40.51887", "longitude": "-121.76494"}]
648664 October 09, 2019 - 08:55:59 UTC 40.52131 -121.68264 Shingletown 70 []
648665 October 09, 2019 - 08:55:59 UTC 40.53178 -121.70352 Shingletown 70 []
648666 October 09, 2019 - 08:55:59 UTC 40.53052 -121.69514 Shingletown 70 []
648667 October 09, 2019 - 08:55:59 UTC 40.52427 -121.68466 Shingletown 70 []
648671 October 09, 2019 - 08:55:59 UTC 40.49946 -121.65708 Shingletown 70 []
648672 October 09, 2019 - 08:55:58 UTC 40.517 -121.69649 Shingletown 70 [{"latitude": "40.51737", "longitude": "-121.69648"}, {"latitude": "40.51806", "longitude": "-121.69525"}, {"latitude": "40.52022", "longitude": "-121.69297"}, {"latitude": "40.52062", "longitude": "-121.70183"}, {"latitude": "40.51967", "longitude": "-121.70396"}, {"latitude": "40.51816", "longitude": "-121.70302"}, {"latitude": "40.51769", "longitude": "-121.69927"}]
648673 October 09, 2019 - 08:55:58 UTC 40.50536 -121.74075 Shingletown 70 []
648674 October 09, 2019 - 08:55:58 UTC 40.52258 -121.79982 Shingletown 70 []
648675 October 09, 2019 - 08:55:58 UTC 40.51928 -121.79193 Shingletown 70 []
648676 October 09, 2019 - 08:55:58 UTC 40.51988 -121.79323 Shingletown 70 []
648677 October 09, 2019 - 08:55:58 UTC 40.52417 -121.79363 Shingletown 70 [{"latitude": "40.52593", "longitude": "-121.79231"}, {"latitude": "40.52616", "longitude": "-121.79032"}, {"latitude": "40.52779", "longitude": "-121.7867"}, {"latitude": "40.53641", "longitude": "-121.78374"}, {"latitude": "40.536", "longitude": "-121.79083"}, {"latitude": "40.52844", "longitude": "-121.79491"}]
648678 October 09, 2019 - 08:55:58 UTC 40.5073 -121.81917 Shingletown 70 [{"latitude": "40.50225", "longitude": "-121.8217"}, {"latitude": "40.50333", "longitude": "-121.8185"}, {"latitude": "40.50782", "longitude": "-121.81916"}, {"latitude": "40.5053", "longitude": "-121.82168"}]
648679 October 09, 2019 - 08:55:58 UTC 40.51832 -121.82752 Shingletown 70 [{"latitude": "40.51841", "longitude": "-121.83574"}, {"latitude": "40.51892", "longitude": "-121.834"}, {"latitude": "40.52065", "longitude": "-121.82978"}, {"latitude": "40.53002", "longitude": "-121.8304"}, {"latitude": "40.53832", "longitude": "-121.84126"}, {"latitude": "40.53691", "longitude": "-121.84127"}, {"latitude": "40.51877", "longitude": "-121.84079"}]
649004 October 09, 2019 - 09:23:53 UTC 40.49364 -122.04968 Shingletown 70 []
649005 October 09, 2019 - 09:23:53 UTC 40.49573 -122.0542 Shingletown 70 []
649006 October 09, 2019 - 09:23:53 UTC 40.49622 -122.04665 Shingletown 70 [{"latitude": "40.47827", "longitude": "-122.03429"}, {"latitude": "40.47876", "longitude": "-122.03138"}, {"latitude": "40.49597", "longitude": "-122.03112"}, {"latitude": "40.49471", "longitude": "-122.04414"}, {"latitude": "40.48875", "longitude": "-122.04694"}, {"latitude": "40.48187", "longitude": "-122.04679"}, {"latitude": "40.47836", "longitude": "-122.04597"}]
649051 October 09, 2019 - 09:24:00 UTC 40.49915 -122.03671 Shingletown 70 []
650221 October 09, 2019 - 08:19:00 UTC 40.50187 -122.04081 Shingletown 70 [{"latitude": "40.47827", "longitude": "-122.03429"}, {"latitude": "40.47876", "longitude": "-122.03138"}, {"latitude": "40.50777", "longitude": "-122.00392"}, {"latitude": "40.52305", "longitude": "-122.01155"}, {"latitude": "40.52299", "longitude": "-122.01251"}, {"latitude": "40.51385", "longitude": "-122.04685"}, {"latitude": "40.51324", "longitude": "-122.04879"}, {"latitude": "40.48802", "longitude": "-122.0641"}, {"latitude": "40.47836", "longitude": "-122.04597"}]
650251 October 09, 2019 - 07:52:00 UTC 40.4948 -121.87296 Shingletown 70 [{"latitude": "40.48738", "longitude": "-121.85862"}, {"latitude": "40.48739", "longitude": "-121.85762"}, {"latitude": "40.50333", "longitude": "-121.8185"}, {"latitude": "40.51308", "longitude": "-121.80897"}, {"latitude": "40.51574", "longitude": "-121.81001"}, {"latitude": "40.53832", "longitude": "-121.84126"}, {"latitude": "40.49589", "longitude": "-121.87328"}, {"latitude": "40.4951", "longitude": "-121.87317"}, {"latitude": "40.48751", "longitude": "-121.86062"}]
650259 October 09, 2019 - 07:52:00 UTC 40.50687 -121.81834 Shingletown 70 [{"latitude": "40.50254", "longitude": "-121.8138"}, {"latitude": "40.50291", "longitude": "-121.81012"}, {"latitude": "40.51388", "longitude": "-121.78946"}, {"latitude": "40.5121", "longitude": "-121.8063"}, {"latitude": "40.509", "longitude": "-121.81811"}, {"latitude": "40.50383", "longitude": "-121.81771"}]
650268 October 09, 2019 - 07:52:00 UTC 40.51399 -121.78753 Shingletown 70 [{"latitude": "40.51657", "longitude": "-121.7929"}, {"latitude": "40.51661", "longitude": "-121.78913"}, {"latitude": "40.51663", "longitude": "-121.78731"}, {"latitude": "40.51809", "longitude": "-121.78632"}, {"latitude": "40.51945", "longitude": "-121.78599"}, {"latitude": "40.53641", "longitude": "-121.78374"}, {"latitude": "40.536", "longitude": "-121.79083"}, {"latitude": "40.52569", "longitude": "-121.80352"}, {"latitude": "40.52312", "longitude": "-121.80246"}, {"latitude": "40.51753", "longitude": "-121.79961"}, {"latitude": "40.51662", "longitude": "-121.79676"}, {"latitude": "40.5166", "longitude": "-121.79587"}, {"latitude": "40.51658", "longitude": "-121.79498"}]
650273 October 09, 2019 - 07:52:00 UTC 40.5138 -121.78681 Shingletown 70 [{"latitude": "40.51266", "longitude": "-121.77229"}, {"latitude": "40.51582", "longitude": "-121.75255"}, {"latitude": "40.51694", "longitude": "-121.75191"}, {"latitude": "40.51694", "longitude": "-121.75458"}, {"latitude": "40.51689", "longitude": "-121.75904"}, {"latitude": "40.51428", "longitude": "-121.78127"}]
650280 October 09, 2019 - 07:52:00 UTC 40.51702 -121.74617 Shingletown 70 [{"latitude": "40.49946", "longitude": "-121.65708"}, {"latitude": "40.5022", "longitude": "-121.64662"}, {"latitude": "40.53048", "longitude": "-121.56324"}, {"latitude": "40.55389", "longitude": "-121.55756"}, {"latitude": "40.53178", "longitude": "-121.70352"}, {"latitude": "40.51716", "longitude": "-121.74336"}, {"latitude": "40.50101", "longitude": "-121.74567"}]
650290 October 09, 2019 - 07:52:00 UTC 40.51804 -121.75518 Shingletown 70 [{"latitude": "40.51879", "longitude": "-121.75252"}, {"latitude": "40.52977", "longitude": "-121.72868"}, {"latitude": "40.53226", "longitude": "-121.728"}, {"latitude": "40.53448", "longitude": "-121.72806"}, {"latitude": "40.53628", "longitude": "-121.73058"}, {"latitude": "40.54194", "longitude": "-121.7388"}, {"latitude": "40.54319", "longitude": "-121.7445"}, {"latitude": "40.54222", "longitude": "-121.74619"}, {"latitude": "40.52888", "longitude": "-121.76368"}, {"latitude": "40.52726", "longitude": "-121.76469"}, {"latitude": "40.51887", "longitude": "-121.76494"}]
650297 October 09, 2019 - 07:52:00 UTC 40.53509 -121.72764 Shingletown 70 [{"latitude": "40.53495", "longitude": "-121.72367"}, {"latitude": "40.5585", "longitude": "-121.70994"}, {"latitude": "40.56644", "longitude": "-121.71278"}, {"latitude": "40.56414", "longitude": "-121.72108"}, {"latitude": "40.56238", "longitude": "-121.7256"}, {"latitude": "40.55881", "longitude": "-121.73333"}, {"latitude": "40.55666", "longitude": "-121.73453"}, {"latitude": "40.55261", "longitude": "-121.73535"}, {"latitude": "40.53577", "longitude": "-121.72752"}]
650307 October 09, 2019 - 07:52:00 UTC 40.49374 -121.87355 Shingletown 70 [{"latitude": "40.48364", "longitude": "-121.88148"}, {"latitude": "40.4935", "longitude": "-121.87539"}, {"latitude": "40.49546", "longitude": "-121.87513"}, {"latitude": "40.5045", "longitude": "-121.89937"}, {"latitude": "40.50473", "longitude": "-121.90327"}, {"latitude": "40.50472", "longitude": "-121.90546"}, {"latitude": "40.50449", "longitude": "-121.91146"}, {"latitude": "40.5038", "longitude": "-121.91267"}, {"latitude": "40.50214", "longitude": "-121.91457"}, {"latitude": "40.48828", "longitude": "-121.92573"}, {"latitude": "40.48376", "longitude": "-121.92742"}]
650311 October 09, 2019 - 07:52:00 UTC 40.50068 -121.9162 Shingletown 70 [{"latitude": "40.49662", "longitude": "-121.94407"}, {"latitude": "40.5013", "longitude": "-121.92649"}, {"latitude": "40.50415", "longitude": "-121.91679"}, {"latitude": "40.51045", "longitude": "-121.90428"}, {"latitude": "40.51841", "longitude": "-121.90132"}, {"latitude": "40.54726", "longitude": "-121.90741"}, {"latitude": "40.52472", "longitude": "-121.97022"}, {"latitude": "40.5091", "longitude": "-122.00114"}, {"latitude": "40.50851", "longitude": "-122.00149"}, {"latitude": "40.50761", "longitude": "-122.00052"}]
650321 October 09, 2019 - 07:52:00 UTC 40.50933 -121.9584 Shingletown 70 [{"latitude": "40.46286", "longitude": "-121.98727"}, {"latitude": "40.49004", "longitude": "-121.96528"}, {"latitude": "40.50642", "longitude": "-121.95305"}, {"latitude": "40.51555", "longitude": "-121.94886"}, {"latitude": "40.52039", "longitude": "-121.96432"}, {"latitude": "40.50635", "longitude": "-122.00447"}, {"latitude": "40.50172", "longitude": "-122.00603"}, {"latitude": "40.47702", "longitude": "-122.01112"}, {"latitude": "40.46579", "longitude": "-122.00175"}, {"latitude": "40.46482", "longitude": "-122.00015"}]
654294 October 11, 2019 - 17:03:46 UTC 40.49923 -121.89946 Shingletown 70 []
654321 October 11, 2019 - 17:27:00 UTC 40.48416 -121.88463 Shingletown 70 []
654516 October 11, 2019 - 20:56:15 UTC 40.50425 -121.83203 Shingletown 70 []
654652 October 11, 2019 - 22:35:58 UTC 40.53018 -121.69286 Shingletown 70 []
654794 October 12, 2019 - 00:26:21 UTC 40.50176 -121.97285 Shingletown 70 []
655161 October 12, 2019 - 17:42:51 UTC 40.51666 -122.07641 Shingletown 70 []

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