outages

158 rows where regionName = 40

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
633516 October 01, 2019 - 10:52:00 UTC 35.52131 -120.71256 Atascadero 40 [{"latitude": "35.48417", "longitude": "-120.70298"}, {"latitude": "35.48504", "longitude": "-120.68012"}, {"latitude": "35.4882", "longitude": "-120.67746"}, {"latitude": "35.49073", "longitude": "-120.67796"}, {"latitude": "35.49226", "longitude": "-120.6787"}, {"latitude": "35.52238", "longitude": "-120.70701"}, {"latitude": "35.51986", "longitude": "-120.71845"}, {"latitude": "35.51874", "longitude": "-120.72061"}, {"latitude": "35.51476", "longitude": "-120.72775"}, {"latitude": "35.51138", "longitude": "-120.73369"}, {"latitude": "35.50591", "longitude": "-120.73773"}, {"latitude": "35.50146", "longitude": "-120.73998"}, {"latitude": "35.48952", "longitude": "-120.71789"}, {"latitude": "35.48456", "longitude": "-120.70425"}]
633581 October 01, 2019 - 14:33:00 UTC 35.51321 -120.70711 Atascadero 40 []
633641 October 01, 2019 - 15:19:09 UTC 35.49512 -120.67227 Atascadero 40 []
635273 October 01, 2019 - 23:07:57 UTC 35.50048 -120.66074 Atascadero 40 [{"latitude": "35.20785", "longitude": "-120.1921"}, {"latitude": "35.22805", "longitude": "-120.13285"}, {"latitude": "35.44687", "longitude": "-120.34512"}, {"latitude": "35.52073", "longitude": "-120.4465"}, {"latitude": "35.55832", "longitude": "-120.512"}, {"latitude": "35.55909", "longitude": "-120.51335"}, {"latitude": "35.56986", "longitude": "-120.5448"}, {"latitude": "35.54992", "longitude": "-120.6114"}, {"latitude": "35.54282", "longitude": "-120.6333"}, {"latitude": "35.52134", "longitude": "-120.66072"}, {"latitude": "35.51307", "longitude": "-120.66134"}, {"latitude": "35.50234", "longitude": "-120.66095"}, {"latitude": "35.46199", "longitude": "-120.64421"}, {"latitude": "35.41627", "longitude": "-120.62032"}]
635335 October 01, 2019 - 23:24:00 UTC 35.44264 -120.60529 Atascadero 40 []
635808 October 02, 2019 - 15:43:30 UTC 35.47432 -120.65376 Atascadero 40 []
639013 October 03, 2019 - 15:08:00 UTC 35.44732 -120.61715 Atascadero 40 []
639016 October 03, 2019 - 15:04:52 UTC 35.49611 -120.67004 Atascadero 40 []
639048 October 03, 2019 - 15:30:00 UTC 35.49581 -120.67009 Atascadero 40 []
642333 October 04, 2019 - 16:00:00 UTC 35.47495 -120.65955 Atascadero 40 []
642356 October 04, 2019 - 16:00:00 UTC 35.4743 -120.65911 Atascadero 40 []
642773 October 04, 2019 - 16:06:18 UTC 35.49691 -120.67265 Atascadero 40 []
642774 October 04, 2019 - 16:06:18 UTC 35.49691 -120.67233 Atascadero 40 []
643501 October 04, 2019 - 19:03:00 UTC 35.44679 -120.7044 Atascadero 40 [{"latitude": "35.44255", "longitude": "-120.70471"}, {"latitude": "35.4431", "longitude": "-120.70279"}, {"latitude": "35.44596", "longitude": "-120.704"}]
643995 October 05, 2019 - 15:13:00 UTC 35.476 -120.62999 Atascadero 40 []
645823 October 07, 2019 - 15:01:10 UTC 35.46985 -120.62368 Atascadero 40 []
647057 October 08, 2019 - 13:53:00 UTC 35.46482 -120.68526 Atascadero 40 [{"latitude": "35.45931", "longitude": "-120.68765"}, {"latitude": "35.46004", "longitude": "-120.68594"}, {"latitude": "35.4609", "longitude": "-120.68411"}, {"latitude": "35.46418", "longitude": "-120.68571"}, {"latitude": "35.4665", "longitude": "-120.69054"}, {"latitude": "35.46702", "longitude": "-120.69198"}, {"latitude": "35.46568", "longitude": "-120.69358"}, {"latitude": "35.46535", "longitude": "-120.69343"}, {"latitude": "35.46188", "longitude": "-120.69185"}, {"latitude": "35.46093", "longitude": "-120.69068"}]
647124 October 08, 2019 - 15:28:54 UTC 35.49457 -120.67277 Atascadero 40 []
647861 October 09, 2019 - 07:33:04 UTC 35.48001 -120.63077 Atascadero 40 []
653647 October 10, 2019 - 23:48:24 UTC 35.4833 -120.69563 Atascadero 40 []
654796 October 12, 2019 - 00:27:01 UTC 35.48467 -120.68311 Atascadero 40 []
655648 October 13, 2019 - 23:39:00 UTC 35.45569 -120.63419 Atascadero 40 []
655788 October 14, 2019 - 15:00:00 UTC 35.45005 -120.70739 Atascadero 40 [{"latitude": "35.44619", "longitude": "-120.70704"}, {"latitude": "35.44961", "longitude": "-120.70848"}, {"latitude": "35.44954", "longitude": "-120.70963"}, {"latitude": "35.44694", "longitude": "-120.70934"}]
655789 October 14, 2019 - 15:00:00 UTC 35.50041 -120.67273 Atascadero 40 [{"latitude": "35.49859", "longitude": "-120.67464"}, {"latitude": "35.49901", "longitude": "-120.67354"}, {"latitude": "35.50169", "longitude": "-120.67265"}, {"latitude": "35.50261", "longitude": "-120.67392"}, {"latitude": "35.505", "longitude": "-120.67848"}, {"latitude": "35.50389", "longitude": "-120.6781"}, {"latitude": "35.50239", "longitude": "-120.67727"}, {"latitude": "35.50092", "longitude": "-120.67641"}]
658833 October 15, 2019 - 15:03:08 UTC 35.51476 -120.72775 Atascadero 40 []
660335 October 16, 2019 - 15:45:38 UTC 35.48078 -120.69822 Atascadero 40 []
664024 October 17, 2019 - 15:45:22 UTC 35.45556 -120.71673 Atascadero 40 [{"latitude": "35.42561", "longitude": "-120.73955"}, {"latitude": "35.43667", "longitude": "-120.72865"}, {"latitude": "35.45565", "longitude": "-120.71709"}, {"latitude": "35.45873", "longitude": "-120.72029"}, {"latitude": "35.46655", "longitude": "-120.74093"}, {"latitude": "35.4737", "longitude": "-120.77785"}, {"latitude": "35.46297", "longitude": "-120.79461"}, {"latitude": "35.45977", "longitude": "-120.79466"}, {"latitude": "35.42973", "longitude": "-120.74962"}]
665937 October 17, 2019 - 19:56:00 UTC 35.48379 -120.68416 Atascadero 40 [{"latitude": "35.45936", "longitude": "-120.70541"}, {"latitude": "35.47393", "longitude": "-120.68877"}, {"latitude": "35.47897", "longitude": "-120.68516"}, {"latitude": "35.48046", "longitude": "-120.68439"}, {"latitude": "35.48266", "longitude": "-120.68449"}, {"latitude": "35.48425", "longitude": "-120.68475"}, {"latitude": "35.49202", "longitude": "-120.69338"}, {"latitude": "35.51337", "longitude": "-120.77526"}, {"latitude": "35.51363", "longitude": "-120.78136"}, {"latitude": "35.48554", "longitude": "-120.77758"}, {"latitude": "35.48265", "longitude": "-120.77141"}]
667378 October 18, 2019 - 13:55:45 UTC 35.48262 -120.71338 Atascadero 40 [{"latitude": "35.47266", "longitude": "-120.71592"}, {"latitude": "35.47272", "longitude": "-120.71346"}, {"latitude": "35.48262", "longitude": "-120.71343"}, {"latitude": "35.4961", "longitude": "-120.7232"}, {"latitude": "35.51337", "longitude": "-120.77526"}, {"latitude": "35.51363", "longitude": "-120.78136"}, {"latitude": "35.48554", "longitude": "-120.77758"}, {"latitude": "35.48265", "longitude": "-120.77141"}, {"latitude": "35.481", "longitude": "-120.76238"}]
667386 October 18, 2019 - 13:55:45 UTC 35.49452 -120.72527 Atascadero 40 []
667390 October 18, 2019 - 13:55:45 UTC 35.48122 -120.7197 Atascadero 40 []
667391 October 18, 2019 - 13:55:45 UTC 35.48262 -120.71338 Atascadero 40 [{"latitude": "35.47266", "longitude": "-120.71592"}, {"latitude": "35.47272", "longitude": "-120.71346"}, {"latitude": "35.48262", "longitude": "-120.71343"}, {"latitude": "35.4961", "longitude": "-120.7232"}, {"latitude": "35.51337", "longitude": "-120.77526"}, {"latitude": "35.51363", "longitude": "-120.78136"}, {"latitude": "35.48554", "longitude": "-120.77758"}, {"latitude": "35.48265", "longitude": "-120.77141"}, {"latitude": "35.481", "longitude": "-120.76238"}]
671099 October 19, 2019 - 14:44:11 UTC 35.46888 -120.64256 Atascadero 40 []
675634 October 21, 2019 - 15:23:35 UTC 35.48349 -120.68262 Atascadero 40 []
675934 October 21, 2019 - 16:13:28 UTC 35.49719 -120.66472 Atascadero 40 []
676133 October 21, 2019 - 18:27:44 UTC 35.51805 -120.69076 Atascadero 40 []
677363 October 23, 2019 - 15:09:38 UTC 35.47214 -120.67521 Atascadero 40 []
677384 October 23, 2019 - 15:33:29 UTC 35.51417 -120.70414 Atascadero 40 []
677390 October 23, 2019 - 15:38:16 UTC 35.49172 -120.77543 Atascadero 40 []
680003 October 25, 2019 - 00:54:51 UTC 35.47427 -120.67444 Atascadero 40 []
691667 October 28, 2019 - 17:58:31 UTC 35.48167 -120.65212 Atascadero 40 []
692883 October 29, 2019 - 11:04:16 UTC 35.49159 -120.64145 Atascadero 40 [{"latitude": "35.49113", "longitude": "-120.63886"}, {"latitude": "35.49304", "longitude": "-120.62073"}, {"latitude": "35.49407", "longitude": "-120.62425"}, {"latitude": "35.4948", "longitude": "-120.62848"}, {"latitude": "35.49356", "longitude": "-120.64024"}, {"latitude": "35.4922", "longitude": "-120.64066"}]
693310 October 29, 2019 - 16:00:00 UTC 35.48278 -120.66511 Atascadero 40 [{"latitude": "35.47733", "longitude": "-120.6624"}, {"latitude": "35.47739", "longitude": "-120.66055"}, {"latitude": "35.4784", "longitude": "-120.66065"}, {"latitude": "35.48246", "longitude": "-120.66183"}, {"latitude": "35.48312", "longitude": "-120.66279"}, {"latitude": "35.48271", "longitude": "-120.6649"}, {"latitude": "35.48184", "longitude": "-120.66525"}, {"latitude": "35.48049", "longitude": "-120.66499"}, {"latitude": "35.47802", "longitude": "-120.66402"}]
694335 October 29, 2019 - 23:23:00 UTC 35.47955 -120.66273 Atascadero 40 []
695933 October 31, 2019 - 00:39:17 UTC 35.4926 -120.68965 Atascadero 40 []
696559 October 31, 2019 - 17:06:29 UTC 35.47275 -120.65458 Atascadero 40 []
696568 October 31, 2019 - 17:10:21 UTC 35.47209 -120.65467 Atascadero 40 []
696844 October 31, 2019 - 20:29:35 UTC 35.43605 -120.62776 Atascadero 40 []
697076 November 01, 2019 - 00:41:00 UTC 35.5124 -120.67035 Atascadero 40 [{"latitude": "35.50907", "longitude": "-120.68708"}, {"latitude": "35.51073", "longitude": "-120.67312"}, {"latitude": "35.51801", "longitude": "-120.6695"}, {"latitude": "35.52132", "longitude": "-120.67621"}, {"latitude": "35.52161", "longitude": "-120.68836"}, {"latitude": "35.5107", "longitude": "-120.6889"}]
697078 November 01, 2019 - 00:43:20 UTC 35.51034 -120.66599 Atascadero 40 []
697079 November 01, 2019 - 00:43:20 UTC 35.51006 -120.67019 Atascadero 40 [{"latitude": "35.50927", "longitude": "-120.66954"}, {"latitude": "35.51036", "longitude": "-120.6709"}, {"latitude": "35.51113", "longitude": "-120.6731"}, {"latitude": "35.51139", "longitude": "-120.67407"}, {"latitude": "35.51103", "longitude": "-120.67438"}]
697098 November 01, 2019 - 00:59:54 UTC 35.50495 -120.69017 Atascadero 40 []
697442 November 01, 2019 - 18:05:25 UTC 35.48111 -120.65402 Atascadero 40 []
698408 November 03, 2019 - 01:51:00 UTC 35.44291 -120.60716 Atascadero 40 []
698443 November 03, 2019 - 04:00:15 UTC 35.50649 -120.69394 Atascadero 40 [{"latitude": "35.47639", "longitude": "-120.6732"}, {"latitude": "35.47739", "longitude": "-120.66055"}, {"latitude": "35.4784", "longitude": "-120.66065"}, {"latitude": "35.48246", "longitude": "-120.66183"}, {"latitude": "35.49024", "longitude": "-120.66573"}, {"latitude": "35.50765", "longitude": "-120.67451"}, {"latitude": "35.50968", "longitude": "-120.67684"}, {"latitude": "35.51006", "longitude": "-120.67848"}, {"latitude": "35.51053", "longitude": "-120.68452"}, {"latitude": "35.50998", "longitude": "-120.68949"}, {"latitude": "35.50612", "longitude": "-120.69311"}, {"latitude": "35.50197", "longitude": "-120.69132"}, {"latitude": "35.4805", "longitude": "-120.67997"}]
698452 November 03, 2019 - 04:00:15 UTC 35.48728 -120.66791 Atascadero 40 [{"latitude": "35.47639", "longitude": "-120.6732"}, {"latitude": "35.47739", "longitude": "-120.66055"}, {"latitude": "35.4784", "longitude": "-120.66065"}, {"latitude": "35.48246", "longitude": "-120.66183"}, {"latitude": "35.48807", "longitude": "-120.66647"}, {"latitude": "35.48244", "longitude": "-120.6793"}, {"latitude": "35.4805", "longitude": "-120.67997"}]
698582 November 03, 2019 - 17:21:24 UTC 35.47046 -120.66724 Atascadero 40 [{"latitude": "35.46871", "longitude": "-120.66498"}, {"latitude": "35.46883", "longitude": "-120.6633"}, {"latitude": "35.46984", "longitude": "-120.66362"}, {"latitude": "35.47086", "longitude": "-120.66523"}, {"latitude": "35.47046", "longitude": "-120.66721"}, {"latitude": "35.46873", "longitude": "-120.66608"}]
699244 November 04, 2019 - 18:48:59 UTC 35.47473 -120.66525 Atascadero 40 []
699583 November 05, 2019 - 00:51:36 UTC 35.51066 -120.68592 Atascadero 40 []
700886 November 06, 2019 - 18:48:55 UTC 35.43642 -120.63609 Atascadero 40 []
701405 November 07, 2019 - 06:49:19 UTC 35.47855 -120.65623 Atascadero 40 []
701667 November 07, 2019 - 16:22:19 UTC 35.49666 -120.67705 Atascadero 40 []
702995 November 08, 2019 - 23:24:52 UTC 35.45519 -120.64122 Atascadero 40 []
704410 November 11, 2019 - 19:57:52 UTC 35.45945 -120.6666 Atascadero 40 []
705209 November 12, 2019 - 21:28:00 UTC 35.45255 -120.62761 Atascadero 40 []
705337 November 12, 2019 - 21:24:00 UTC 35.46521 -120.67142 Atascadero 40 [{"latitude": "35.28442", "longitude": "-120.46918"}, {"latitude": "35.28562", "longitude": "-120.43622"}, {"latitude": "35.2985", "longitude": "-120.37053"}, {"latitude": "35.30772", "longitude": "-120.3575"}, {"latitude": "35.30883", "longitude": "-120.35747"}, {"latitude": "35.31027", "longitude": "-120.35747"}, {"latitude": "35.34175", "longitude": "-120.39967"}, {"latitude": "35.49672", "longitude": "-120.6499"}, {"latitude": "35.49738", "longitude": "-120.65151"}, {"latitude": "35.51337", "longitude": "-120.77526"}, {"latitude": "35.51363", "longitude": "-120.78136"}, {"latitude": "35.46297", "longitude": "-120.79461"}, {"latitude": "35.45977", "longitude": "-120.79466"}, {"latitude": "35.42973", "longitude": "-120.74962"}, {"latitude": "35.29623", "longitude": "-120.4922"}]
705390 November 12, 2019 - 21:34:00 UTC 35.46248 -120.6441 Atascadero 40 []
705418 November 12, 2019 - 21:24:00 UTC 35.46529 -120.67132 Atascadero 40 [{"latitude": "35.45375", "longitude": "-120.69942"}, {"latitude": "35.46558", "longitude": "-120.66851"}, {"latitude": "35.47243", "longitude": "-120.65178"}, {"latitude": "35.48168", "longitude": "-120.64382"}, {"latitude": "35.4883", "longitude": "-120.64106"}, {"latitude": "35.4963", "longitude": "-120.64928"}, {"latitude": "35.49672", "longitude": "-120.6499"}, {"latitude": "35.49738", "longitude": "-120.65151"}, {"latitude": "35.51337", "longitude": "-120.77526"}, {"latitude": "35.51363", "longitude": "-120.78136"}, {"latitude": "35.48554", "longitude": "-120.77758"}, {"latitude": "35.48265", "longitude": "-120.77141"}]
705428 November 12, 2019 - 21:34:00 UTC 35.46248 -120.6441 Atascadero 40 []
705429 November 12, 2019 - 21:28:00 UTC 35.45255 -120.62761 Atascadero 40 []
705440 November 12, 2019 - 22:14:02 UTC 35.47038 -120.66324 Atascadero 40 []
705442 November 12, 2019 - 22:17:32 UTC 35.44791 -120.63765 Atascadero 40 []
705477 November 12, 2019 - 23:06:44 UTC 35.48266 -120.68449 Atascadero 40 []
705497 November 12, 2019 - 23:24:44 UTC 35.47727 -120.66657 Atascadero 40 []
705889 November 13, 2019 - 16:46:09 UTC 35.44858 -120.70537 Atascadero 40 []
706130 November 13, 2019 - 19:06:35 UTC 35.4655 -120.68363 Atascadero 40 []
709020 November 18, 2019 - 16:16:35 UTC 35.52295 -120.70232 Atascadero 40 []
709815 November 19, 2019 - 15:58:00 UTC 35.49512 -120.67227 Atascadero 40 []
709829 November 19, 2019 - 16:06:00 UTC 35.45679 -120.7348 Atascadero 40 [{"latitude": "35.43667", "longitude": "-120.72865"}, {"latitude": "35.43978", "longitude": "-120.72752"}, {"latitude": "35.45626", "longitude": "-120.73502"}, {"latitude": "35.45659", "longitude": "-120.73573"}, {"latitude": "35.45519", "longitude": "-120.73862"}, {"latitude": "35.44408", "longitude": "-120.73455"}, {"latitude": "35.43807", "longitude": "-120.73095"}]
710044 November 19, 2019 - 18:09:31 UTC 35.4778 -120.67747 Atascadero 40 []
710215 November 19, 2019 - 20:38:57 UTC 35.46154 -120.64573 Atascadero 40 []
710938 November 20, 2019 - 16:10:18 UTC 35.52106 -120.70034 Atascadero 40 []
711488 November 20, 2019 - 18:57:48 UTC 35.44197 -120.61506 Atascadero 40 []
711995 November 21, 2019 - 16:06:00 UTC 35.49703 -120.67544 Atascadero 40 [{"latitude": "35.49603", "longitude": "-120.67578"}, {"latitude": "35.49608", "longitude": "-120.67472"}, {"latitude": "35.49692", "longitude": "-120.67526"}, {"latitude": "35.49676", "longitude": "-120.67546"}]
712217 November 21, 2019 - 18:21:00 UTC 35.49666 -120.67705 Atascadero 40 []
712694 November 22, 2019 - 16:13:00 UTC 35.48738 -120.67735 Atascadero 40 []
713421 November 23, 2019 - 17:28:01 UTC 35.52979 -120.70516 Atascadero 40 []
713460 November 23, 2019 - 18:19:52 UTC 35.46154 -120.64573 Atascadero 40 []
713632 November 24, 2019 - 02:57:00 UTC 35.501 -120.66206 Atascadero 40 [{"latitude": "35.47639", "longitude": "-120.6732"}, {"latitude": "35.47739", "longitude": "-120.66055"}, {"latitude": "35.4826", "longitude": "-120.65815"}, {"latitude": "35.48977", "longitude": "-120.65685"}, {"latitude": "35.4966", "longitude": "-120.65804"}, {"latitude": "35.49853", "longitude": "-120.65859"}, {"latitude": "35.50225", "longitude": "-120.66496"}, {"latitude": "35.505", "longitude": "-120.67848"}, {"latitude": "35.4805", "longitude": "-120.67997"}]
713665 November 24, 2019 - 03:24:09 UTC 35.48227 -120.66274 Atascadero 40 []
713913 November 24, 2019 - 22:35:41 UTC 35.49942 -120.70334 Atascadero 40 []
714271 November 25, 2019 - 18:00:45 UTC 35.47187 -120.68024 Atascadero 40 []
714595 November 25, 2019 - 21:52:06 UTC 35.50389 -120.6781 Atascadero 40 []
722025 November 28, 2019 - 00:57:00 UTC 35.52131 -120.71256 Atascadero 40 [{"latitude": "35.48417", "longitude": "-120.70298"}, {"latitude": "35.48504", "longitude": "-120.68012"}, {"latitude": "35.4882", "longitude": "-120.67746"}, {"latitude": "35.49073", "longitude": "-120.67796"}, {"latitude": "35.49226", "longitude": "-120.6787"}, {"latitude": "35.52238", "longitude": "-120.70701"}, {"latitude": "35.51986", "longitude": "-120.71845"}, {"latitude": "35.51874", "longitude": "-120.72061"}, {"latitude": "35.51476", "longitude": "-120.72775"}, {"latitude": "35.51138", "longitude": "-120.73369"}, {"latitude": "35.50591", "longitude": "-120.73773"}, {"latitude": "35.50146", "longitude": "-120.73998"}, {"latitude": "35.48952", "longitude": "-120.71789"}, {"latitude": "35.48456", "longitude": "-120.70425"}]
723184 November 29, 2019 - 01:24:00 UTC 35.50262 -120.67962 Atascadero 40 []
723669 November 29, 2019 - 21:10:07 UTC 35.484 -120.67572 Atascadero 40 []
728484 December 03, 2019 - 17:05:49 UTC 35.51264 -120.7002 Atascadero 40 []
728925 December 03, 2019 - 22:01:05 UTC 35.51435 -120.69294 Atascadero 40 []
729486 December 04, 2019 - 16:46:10 UTC 35.50037 -120.69482 Atascadero 40 []
730349 December 05, 2019 - 17:00:00 UTC 35.50166 -120.67342 Atascadero 40 []

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