outages

83,213 rows sorted by latitude

View and edit SQL

id outageStartTime latitude ▼ longitude regionName outageDevices
705540 November 13, 2019 - 00:35:42 UTC 34.51772 -120.30603 Goleta 874 []
696487 October 31, 2019 - 16:11:00 UTC 34.52404 -120.28229 Lompoc 260 [{"latitude": "34.52168", "longitude": "-120.27955"}, {"latitude": "34.52326", "longitude": "-120.28299"}, {"latitude": "34.52381", "longitude": "-120.28487"}]
731832 December 07, 2019 - 00:49:36 UTC 34.5302 -120.31936 Lompoc 260 []
703177 November 09, 2019 - 15:07:00 UTC 34.53602 -120.17866 Goleta 874 []
700279 November 05, 2019 - 23:33:41 UTC 34.55496 -120.35456 Lompoc 260 []
700308 November 06, 2019 - 00:04:00 UTC 34.55496 -120.35456 Lompoc 260 []
658989 October 15, 2019 - 16:46:07 UTC 34.55711 -119.92583 Santa Barbara 752 []
1074056 September 16, 2020 - 14:49:00 UTC 34.55766 -120.14084 Solvang 446 []
1074416 September 16, 2020 - 14:49:00 UTC 34.55766 -120.14084 Solvang 446 []
1074817 September 16, 2020 - 16:46:03 UTC 34.5614 -120.12167 Solvang 446 []
1074418 September 16, 2020 - 14:45:39 UTC 34.56186 -120.13948 Solvang 446 [{"latitude": "34.56451", "longitude": "-120.14072"}, {"latitude": "34.57018", "longitude": "-120.14111"}, {"latitude": "34.57202", "longitude": "-120.1433"}, {"latitude": "34.57029", "longitude": "-120.14352"}, {"latitude": "34.56601", "longitude": "-120.14238"}]
1074816 September 16, 2020 - 16:46:01 UTC 34.56186 -120.13948 Solvang 446 [{"latitude": "34.56451", "longitude": "-120.14072"}, {"latitude": "34.57018", "longitude": "-120.14111"}, {"latitude": "34.57029", "longitude": "-120.14352"}, {"latitude": "34.56601", "longitude": "-120.14238"}]
738358 December 13, 2019 - 17:18:00 UTC 34.56309 -120.19066 Lompoc 260 [{"latitude": "34.56317", "longitude": "-120.19228"}, {"latitude": "34.56794", "longitude": "-120.19864"}, {"latitude": "34.56706", "longitude": "-120.20042"}, {"latitude": "34.5638", "longitude": "-120.1983"}, {"latitude": "34.56359", "longitude": "-120.19665"}]
701662 November 07, 2019 - 16:16:00 UTC 34.56491 -120.41922 Lompoc 260 []
715240 November 26, 2019 - 19:19:01 UTC 34.56683 -120.49895 Lompoc 260 []
1074033 September 16, 2020 - 14:45:39 UTC 34.57202 -120.1433 Solvang 446 []
736254 December 11, 2019 - 17:00:00 UTC 34.57277 -119.96322 Santa Barbara 752 [{"latitude": "34.52494", "longitude": "-119.95989"}, {"latitude": "34.52538", "longitude": "-119.95882"}, {"latitude": "34.52585", "longitude": "-119.95818"}, {"latitude": "34.55441", "longitude": "-119.95275"}, {"latitude": "34.56863", "longitude": "-119.96688"}, {"latitude": "34.56745", "longitude": "-119.96889"}, {"latitude": "34.55551", "longitude": "-119.97682"}, {"latitude": "34.55218", "longitude": "-119.97893"}, {"latitude": "34.53128", "longitude": "-119.98328"}, {"latitude": "34.52699", "longitude": "-119.97544"}]
677464 October 23, 2019 - 16:17:08 UTC 34.57303 -120.1477 Solvang 446 []
1074417 September 16, 2020 - 15:10:58 UTC 34.57303 -120.1477 Solvang 446 []
650996 October 09, 2019 - 19:26:00 UTC 34.57381 -120.098 Solvang 446 [{"latitude": "34.5251", "longitude": "-120.08415"}, {"latitude": "34.5256", "longitude": "-120.08069"}, {"latitude": "34.53135", "longitude": "-120.05794"}, {"latitude": "34.55595", "longitude": "-120.07769"}, {"latitude": "34.57332", "longitude": "-120.09768"}, {"latitude": "34.53157", "longitude": "-120.09447"}, {"latitude": "34.53118", "longitude": "-120.0942"}, {"latitude": "34.53026", "longitude": "-120.09309"}]
677042 October 22, 2019 - 22:01:35 UTC 34.57925 -119.95499 Santa Barbara 752 []
735578 December 10, 2019 - 18:32:15 UTC 34.57966 -120.10107 Solvang 446 []
1062844 September 10, 2020 - 16:39:02 UTC 34.58721 -119.99096 Santa Ynez 68 []
736256 December 11, 2019 - 17:01:41 UTC 34.58742 -119.98785 Santa Barbara 752 [{"latitude": "34.54373", "longitude": "-119.89861"}, {"latitude": "34.54634", "longitude": "-119.87253"}, {"latitude": "34.55845", "longitude": "-119.88388"}, {"latitude": "34.58491", "longitude": "-119.95788"}, {"latitude": "34.58635", "longitude": "-119.98269"}, {"latitude": "34.57996", "longitude": "-119.98219"}, {"latitude": "34.57362", "longitude": "-119.97815"}, {"latitude": "34.55871", "longitude": "-119.94911"}, {"latitude": "34.55171", "longitude": "-119.935"}]
664877 October 17, 2019 - 17:48:55 UTC 34.58978 -120.48655 Lompoc 260 []
1064948 September 11, 2020 - 20:05:07 UTC 34.58978 -120.48655 Lompoc 260 []
1066495 September 12, 2020 - 20:10:36 UTC 34.58978 -120.48655 Lompoc 260 []
695601 October 30, 2019 - 22:22:25 UTC 34.59278 -120.14013 Solvang 446 []
655473 October 13, 2019 - 06:18:00 UTC 34.59409 -120.14087 Solvang 446 [{"latitude": "34.5568", "longitude": "-120.14311"}, {"latitude": "34.55693", "longitude": "-120.12517"}, {"latitude": "34.55986", "longitude": "-120.11981"}, {"latitude": "34.56291", "longitude": "-120.11504"}, {"latitude": "34.59133", "longitude": "-120.13297"}, {"latitude": "34.59403", "longitude": "-120.13921"}, {"latitude": "34.59407", "longitude": "-120.13959"}, {"latitude": "34.59317", "longitude": "-120.14337"}, {"latitude": "34.59115", "longitude": "-120.14713"}, {"latitude": "34.58836", "longitude": "-120.14837"}, {"latitude": "34.57303", "longitude": "-120.1477"}]
655475 October 13, 2019 - 06:26:50 UTC 34.59431 -120.13917 Solvang 446 []
731039 December 06, 2019 - 11:14:08 UTC 34.59486 -120.26668 Lompoc 260 [{"latitude": "34.58747", "longitude": "-120.27257"}, {"latitude": "34.59533", "longitude": "-120.26782"}, {"latitude": "34.61232", "longitude": "-120.26912"}, {"latitude": "34.61541", "longitude": "-120.27013"}, {"latitude": "34.62539", "longitude": "-120.28673"}, {"latitude": "34.62057", "longitude": "-120.33019"}, {"latitude": "34.6186", "longitude": "-120.3477"}, {"latitude": "34.61706", "longitude": "-120.35154"}, {"latitude": "34.60697", "longitude": "-120.35998"}]
788983 February 11, 2020 - 23:45:02 UTC 34.59524 -120.17916 Goleta 874 []
645597 October 06, 2019 - 17:45:36 UTC 34.59623 -120.05576 Santa Ynez 68 []
698725 November 03, 2019 - 22:21:47 UTC 34.59713 -120.15007 Solvang 446 []
710204 November 19, 2019 - 20:24:18 UTC 34.59717 -120.13359 Solvang 446 []
1074397 September 16, 2020 - 15:44:00 UTC 34.59746 -120.14455 Solvang 446 []
673893 October 19, 2019 - 21:58:53 UTC 34.59808 -120.02964 Santa Ynez 68 [{"latitude": "34.52494", "longitude": "-119.95989"}, {"latitude": "34.54634", "longitude": "-119.87253"}, {"latitude": "34.55845", "longitude": "-119.88388"}, {"latitude": "34.58491", "longitude": "-119.95788"}, {"latitude": "34.60195", "longitude": "-120.00554"}, {"latitude": "34.59648", "longitude": "-120.02512"}, {"latitude": "34.59451", "longitude": "-120.02589"}, {"latitude": "34.53128", "longitude": "-119.98328"}, {"latitude": "34.52699", "longitude": "-119.97544"}]
731026 December 06, 2019 - 11:14:08 UTC 34.5983 -120.24681 Lompoc 260 [{"latitude": "34.58747", "longitude": "-120.27257"}, {"latitude": "34.58993", "longitude": "-120.25107"}, {"latitude": "34.59073", "longitude": "-120.24961"}, {"latitude": "34.59634", "longitude": "-120.24945"}, {"latitude": "34.61541", "longitude": "-120.27013"}, {"latitude": "34.62539", "longitude": "-120.28673"}, {"latitude": "34.62057", "longitude": "-120.33019"}, {"latitude": "34.6186", "longitude": "-120.3477"}, {"latitude": "34.61706", "longitude": "-120.35154"}, {"latitude": "34.60697", "longitude": "-120.35998"}]
643446 October 04, 2019 - 18:04:55 UTC 34.59835 -120.13023 Solvang 446 []
723589 November 29, 2019 - 19:54:50 UTC 34.59846 -120.13521 Solvang 446 []
723831 November 30, 2019 - 01:16:33 UTC 34.59846 -120.13521 Solvang 446 []
700630 November 06, 2019 - 16:53:03 UTC 34.59869 -120.13002 Solvang 446 [{"latitude": "34.59795", "longitude": "-120.13063"}, {"latitude": "34.59835", "longitude": "-120.13023"}, {"latitude": "34.59903", "longitude": "-120.13017"}]
702102 November 07, 2019 - 22:02:00 UTC 34.59946 -120.12974 Solvang 446 []
659373 October 15, 2019 - 18:28:54 UTC 34.59962 -120.141 Solvang 446 []
633952 October 01, 2019 - 17:45:24 UTC 34.6023 -120.111 Santa Ynez 68 []
741993 December 16, 2019 - 17:52:46 UTC 34.60252 -120.12588 Solvang 446 []
1075375 September 16, 2020 - 19:14:36 UTC 34.60329 -120.28868 Lompoc 260 []
709953 November 19, 2019 - 17:06:00 UTC 34.60453 -120.29653 Lompoc 260 [{"latitude": "34.60266", "longitude": "-120.29882"}, {"latitude": "34.60307", "longitude": "-120.29729"}, {"latitude": "34.60345", "longitude": "-120.29709"}, {"latitude": "34.61383", "longitude": "-120.29296"}, {"latitude": "34.61232", "longitude": "-120.29846"}]
732286 December 07, 2019 - 17:00:00 UTC 34.60464 -120.46382 Lompoc 260 [{"latitude": "34.60325", "longitude": "-120.46484"}, {"latitude": "34.60599", "longitude": "-120.46502"}, {"latitude": "34.60833", "longitude": "-120.46823"}, {"latitude": "34.60775", "longitude": "-120.46859"}]
1068952 September 14, 2020 - 17:39:36 UTC 34.60478 -120.13409 Solvang 446 []
780256 February 07, 2020 - 22:32:16 UTC 34.60717 -120.09207 Santa Ynez 68 []
697379 November 01, 2019 - 17:01:54 UTC 34.60783 -120.18658 Buellton 374 []
702576 November 08, 2019 - 16:59:00 UTC 34.60895 -120.13676 Solvang 446 [{"latitude": "34.60625", "longitude": "-120.13374"}, {"latitude": "34.60685", "longitude": "-120.13343"}, {"latitude": "34.60822", "longitude": "-120.1329"}, {"latitude": "34.60928", "longitude": "-120.13444"}, {"latitude": "34.60894", "longitude": "-120.13657"}, {"latitude": "34.60636", "longitude": "-120.1342"}]
1079979 September 18, 2020 - 15:24:17 UTC 34.60938 -120.46416 Lompoc 260 [{"latitude": "34.53749", "longitude": "-120.53184"}, {"latitude": "34.59302", "longitude": "-120.46924"}, {"latitude": "34.59501", "longitude": "-120.46722"}, {"latitude": "34.59765", "longitude": "-120.46522"}, {"latitude": "34.60325", "longitude": "-120.46484"}, {"latitude": "34.60599", "longitude": "-120.46502"}, {"latitude": "34.60833", "longitude": "-120.46823"}, {"latitude": "34.59104", "longitude": "-120.52933"}, {"latitude": "34.5898", "longitude": "-120.53239"}, {"latitude": "34.53945", "longitude": "-120.53706"}, {"latitude": "34.53775", "longitude": "-120.53307"}]
691561 October 28, 2019 - 16:46:19 UTC 34.60967 -120.29484 Lompoc 260 []
1063221 September 10, 2020 - 18:28:00 UTC 34.60994 -120.08546 Santa Ynez 68 []
1062999 September 10, 2020 - 17:37:43 UTC 34.61004 -120.08515 Santa Ynez 68 []
655518 October 13, 2019 - 14:56:01 UTC 34.6101 -120.19697 Buellton 374 []
679317 October 24, 2019 - 15:00:00 UTC 34.61081 -120.13674 Solvang 446 []
707085 November 15, 2019 - 00:23:05 UTC 34.61162 -120.18151 Buellton 374 []
787396 February 10, 2020 - 19:15:19 UTC 34.61213 -120.19969 Buellton 374 []
1068353 September 14, 2020 - 15:51:04 UTC 34.61265 -120.10013 Santa Ynez 68 []
677004 October 22, 2019 - 20:57:53 UTC 34.61343 -120.3642 Lompoc 260 []
633809 October 01, 2019 - 16:07:35 UTC 34.61353 -120.07835 Santa Ynez 68 []
633590 October 01, 2019 - 16:00:00 UTC 34.61365 -120.07835 Santa Ynez 68 [{"latitude": "34.61459", "longitude": "-120.07834"}, {"latitude": "34.61499", "longitude": "-120.07675"}, {"latitude": "34.62218", "longitude": "-120.07108"}, {"latitude": "34.62503", "longitude": "-120.07395"}, {"latitude": "34.62648", "longitude": "-120.07599"}, {"latitude": "34.62061", "longitude": "-120.07754"}, {"latitude": "34.61652", "longitude": "-120.07833"}]
702719 November 08, 2019 - 18:20:42 UTC 34.61402 -120.00636 Santa Ynez 68 []
731510 December 06, 2019 - 19:53:45 UTC 34.61567 -120.08009 Santa Ynez 68 []
730456 December 05, 2019 - 18:00:46 UTC 34.61643 -120.09366 Santa Ynez 68 []
730763 December 05, 2019 - 22:28:38 UTC 34.61643 -120.09366 Santa Ynez 68 []
1078337 September 17, 2020 - 18:23:46 UTC 34.61743 -120.3796 Lompoc 260 []
727820 December 02, 2019 - 23:22:52 UTC 34.61759 -120.25252 Buellton 374 []
667996 October 18, 2019 - 16:01:00 UTC 34.61833 -120.12048 Solvang 446 [{"latitude": "34.6172", "longitude": "-120.11503"}, {"latitude": "34.61781", "longitude": "-120.1171"}, {"latitude": "34.61774", "longitude": "-120.11751"}]
722522 November 28, 2019 - 08:55:00 UTC 34.61916 -120.20427 Buellton 374 []
639045 October 03, 2019 - 15:28:40 UTC 34.61978 -120.19725 Buellton 374 []
712354 November 21, 2019 - 21:06:02 UTC 34.62019 -120.46127 Lompoc 260 []
694031 October 29, 2019 - 19:53:00 UTC 34.62066 -120.10934 Solvang 446 [{"latitude": "34.61568", "longitude": "-120.11"}, {"latitude": "34.61998", "longitude": "-120.10967"}, {"latitude": "34.6157", "longitude": "-120.11172"}]
702583 November 08, 2019 - 16:56:17 UTC 34.62104 -120.19067 Buellton 374 []
646827 October 07, 2019 - 21:45:51 UTC 34.62117 -120.09578 Santa Ynez 68 []
723472 November 29, 2019 - 17:47:00 UTC 34.62133 -120.46022 Lompoc 260 []
714441 November 25, 2019 - 20:23:11 UTC 34.62285 -120.21586 Buellton 374 []
787056 February 10, 2020 - 16:37:52 UTC 34.62389 -120.22775 Buellton 374 [{"latitude": "34.62453", "longitude": "-120.22775"}, {"latitude": "34.62686", "longitude": "-120.2277"}, {"latitude": "34.62795", "longitude": "-120.22769"}, {"latitude": "34.62791", "longitude": "-120.23014"}]
714190 November 25, 2019 - 16:55:32 UTC 34.62479 -120.2424 Buellton 374 []
790265 February 13, 2020 - 17:23:04 UTC 34.62618 -120.09288 Santa Ynez 68 []
676261 October 21, 2019 - 19:55:54 UTC 34.62741 -120.08041 Santa Ynez 68 []
702699 November 08, 2019 - 18:03:44 UTC 34.62792 -120.09325 Santa Ynez 68 []
644094 October 05, 2019 - 16:01:00 UTC 34.62996 -120.00137 Santa Ynez 68 []
723317 November 29, 2019 - 12:56:00 UTC 34.633 -120.45405 Lompoc 260 [{"latitude": "34.53749", "longitude": "-120.53184"}, {"latitude": "34.59302", "longitude": "-120.46924"}, {"latitude": "34.59501", "longitude": "-120.46722"}, {"latitude": "34.59765", "longitude": "-120.46522"}, {"latitude": "34.63343", "longitude": "-120.45403"}, {"latitude": "34.5898", "longitude": "-120.53239"}, {"latitude": "34.53945", "longitude": "-120.53706"}, {"latitude": "34.53775", "longitude": "-120.53307"}]
737092 December 12, 2019 - 14:18:00 UTC 34.633 -120.45405 Lompoc 260 [{"latitude": "34.53749", "longitude": "-120.53184"}, {"latitude": "34.59302", "longitude": "-120.46924"}, {"latitude": "34.59501", "longitude": "-120.46722"}, {"latitude": "34.59765", "longitude": "-120.46522"}, {"latitude": "34.63343", "longitude": "-120.45403"}, {"latitude": "34.5898", "longitude": "-120.53239"}, {"latitude": "34.53945", "longitude": "-120.53706"}, {"latitude": "34.53775", "longitude": "-120.53307"}]
1026870 August 22, 2020 - 13:21:00 UTC 34.633 -120.45405 Lompoc 260 [{"latitude": "34.53749", "longitude": "-120.53184"}, {"latitude": "34.59302", "longitude": "-120.46924"}, {"latitude": "34.59501", "longitude": "-120.46722"}, {"latitude": "34.59765", "longitude": "-120.46522"}, {"latitude": "34.60325", "longitude": "-120.46484"}, {"latitude": "34.60599", "longitude": "-120.46502"}, {"latitude": "34.60833", "longitude": "-120.46823"}, {"latitude": "34.59104", "longitude": "-120.52933"}, {"latitude": "34.5898", "longitude": "-120.53239"}, {"latitude": "34.53945", "longitude": "-120.53706"}, {"latitude": "34.53775", "longitude": "-120.53307"}]
709878 November 19, 2019 - 16:28:00 UTC 34.63377 -120.14196 Solvang 446 [{"latitude": "34.63444", "longitude": "-120.14407"}, {"latitude": "34.63748", "longitude": "-120.14767"}, {"latitude": "34.6424", "longitude": "-120.15462"}, {"latitude": "34.63721", "longitude": "-120.1511"}, {"latitude": "34.63571", "longitude": "-120.1474"}]
659845 October 15, 2019 - 21:42:17 UTC 34.63426 -120.0304 Santa Ynez 68 []
691557 October 28, 2019 - 16:49:06 UTC 34.63465 -120.1134 Ballard 843 []
728497 December 03, 2019 - 17:06:48 UTC 34.63471 -120.19889 Buellton 374 []
663228 October 17, 2019 - 03:20:14 UTC 34.63544 -120.06838 Santa Ynez 68 []
778375 February 05, 2020 - 17:23:59 UTC 34.63561 -120.10394 Santa Ynez 68 []
778453 February 05, 2020 - 18:17:48 UTC 34.63565 -120.10302 Santa Ynez 68 []
778310 February 05, 2020 - 16:41:36 UTC 34.63566 -120.1068 Ballard 843 []
706547 November 14, 2019 - 15:38:41 UTC 34.63655 -120.50356 Lompoc 260 []
659846 October 15, 2019 - 21:42:32 UTC 34.63747 -120.08309 Santa Ynez 68 []
735382 December 10, 2019 - 17:09:00 UTC 34.63976 -120.4843 Lompoc 260 [{"latitude": "34.64411", "longitude": "-120.48423"}, {"latitude": "34.64641", "longitude": "-120.48033"}, {"latitude": "34.65018", "longitude": "-120.47982"}, {"latitude": "34.65772", "longitude": "-120.48408"}, {"latitude": "34.65412", "longitude": "-120.48412"}]

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