225,105 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"}]
1122117 October 21, 2020 - 15:54:48 UTC 34.52478 -120.29201 Lompoc 260 []
1092259 September 25, 2020 - 16:09:58 UTC 34.52555 -120.34387 Lompoc 260 []
1123940 October 23, 2020 - 15:42:28 UTC 34.52557 -120.08049 Goleta 874 []
1129724 October 27, 2020 - 15:39:06 UTC 34.52557 -120.08049 Goleta 874 []
1346745 May 12, 2021 - 15:27:12 UTC 34.52557 -120.08049 Goleta 874 []
1328134 April 22, 2021 - 15:30:00 UTC 34.52626 -120.30674 Lompoc 260 [{"latitude": "34.51772", "longitude": "-120.30603"}, {"latitude": "34.52499", "longitude": "-120.30238"}, {"latitude": "34.52286", "longitude": "-120.30366"}]
1225128 January 26, 2021 - 01:41:07 UTC 34.53006 -120.30619 Lompoc 260 []
1304972 April 01, 2021 - 16:30:55 UTC 34.53015 -120.33759 Lompoc 260 []
731832 December 07, 2019 - 00:49:36 UTC 34.5302 -120.31936 Lompoc 260 []
1237778 January 28, 2021 - 05:08:00 UTC 34.53132 -120.29391 Lompoc 260 []
1198441 December 25, 2020 - 14:44:23 UTC 34.53134 -120.29128 Lompoc 260 [{"latitude": "34.51772", "longitude": "-120.30603"}, {"latitude": "34.52739", "longitude": "-120.2921"}, {"latitude": "34.53226", "longitude": "-120.29258"}, {"latitude": "34.54622", "longitude": "-120.29602"}, {"latitude": "34.55496", "longitude": "-120.35456"}, {"latitude": "34.52236", "longitude": "-120.3454"}]
1255469 February 16, 2021 - 08:56:10 UTC 34.53134 -120.29128 Lompoc 260 [{"latitude": "34.51772", "longitude": "-120.30603"}, {"latitude": "34.52739", "longitude": "-120.2921"}, {"latitude": "34.53226", "longitude": "-120.29258"}, {"latitude": "34.54622", "longitude": "-120.29602"}, {"latitude": "34.55419", "longitude": "-120.35559"}, {"latitude": "34.52199", "longitude": "-120.34407"}]
1124105 October 23, 2020 - 18:26:48 UTC 34.53206 -120.09313 Goleta 874 []
1128730 October 26, 2020 - 16:19:49 UTC 34.53206 -120.09313 Goleta 874 []
1136314 November 05, 2020 - 16:30:11 UTC 34.533 -120.30897 Lompoc 260 []
1217455 January 19, 2021 - 21:36:00 UTC 34.53535 -120.18081 Goleta 874 [{"latitude": "34.53434", "longitude": "-120.17759"}, {"latitude": "34.53458", "longitude": "-120.1754"}, {"latitude": "34.53851", "longitude": "-120.17918"}, {"latitude": "34.54032", "longitude": "-120.18129"}, {"latitude": "34.53452", "longitude": "-120.17833"}]
703177 November 09, 2019 - 15:07:00 UTC 34.53602 -120.17866 Goleta 874 []
1225558 January 26, 2021 - 15:59:37 UTC 34.5388 -120.53676 Lompoc 260 []
1217228 January 19, 2021 - 21:36:31 UTC 34.53913 -120.18585 Goleta 874 []
1285539 March 16, 2021 - 23:35:00 UTC 34.54402 -119.86417 Santa Barbara 752 []
1112020 October 06, 2020 - 17:31:36 UTC 34.54662 -119.89281 Santa Barbara 752 []
1098058 September 29, 2020 - 16:17:00 UTC 34.54918 -119.87833 Santa Barbara 752 []
1337046 April 29, 2021 - 19:44:06 UTC 34.55419 -120.35559 Lompoc 260 []
1124312 October 24, 2020 - 00:17:14 UTC 34.55456 -120.195 Lompoc 260 []
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 []
1203287 January 04, 2021 - 18:45:03 UTC 34.55845 -119.88388 Santa Barbara 752 []
1133619 November 02, 2020 - 14:54:53 UTC 34.55986 -120.11981 Solvang 446 []
1337842 April 30, 2021 - 18:05:52 UTC 34.55986 -120.11981 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"}]
1337536 April 30, 2021 - 12:50:10 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"}]
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"}]
1150572 November 21, 2020 - 16:00:00 UTC 34.56326 -120.19293 Buellton 374 [{"latitude": "34.56357", "longitude": "-120.19552"}, {"latitude": "34.56794", "longitude": "-120.19864"}, {"latitude": "34.56706", "longitude": "-120.20042"}, {"latitude": "34.5638", "longitude": "-120.1983"}, {"latitude": "34.56359", "longitude": "-120.19665"}]
1221681 January 23, 2021 - 16:03:00 UTC 34.5636 -120.19026 Lompoc 260 [{"latitude": "34.50593", "longitude": "-120.22533"}, {"latitude": "34.53195", "longitude": "-120.1784"}, {"latitude": "34.53458", "longitude": "-120.1754"}, {"latitude": "34.56238", "longitude": "-120.18944"}, {"latitude": "34.56794", "longitude": "-120.19864"}, {"latitude": "34.55496", "longitude": "-120.35456"}, {"latitude": "34.52236", "longitude": "-120.3454"}]
701662 November 07, 2019 - 16:16:00 UTC 34.56491 -120.41922 Lompoc 260 []
1108905 October 03, 2020 - 16:25:20 UTC 34.56652 -120.49929 Lompoc 260 []
1109715 October 03, 2020 - 21:15:40 UTC 34.56652 -120.49929 Lompoc 260 []
1255491 February 16, 2021 - 14:57:31 UTC 34.56659 -120.49908 Lompoc 260 []
715240 November 26, 2019 - 19:19:01 UTC 34.56683 -120.49895 Lompoc 260 []
1190272 December 16, 2020 - 17:03:00 UTC 34.57007 -120.09554 Santa Ynez 68 [{"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.53157", "longitude": "-120.09447"}, {"latitude": "34.53118", "longitude": "-120.0942"}, {"latitude": "34.53026", "longitude": "-120.09305"}]
1074033 September 16, 2020 - 14:45:39 UTC 34.57202 -120.1433 Solvang 446 []
1155378 November 28, 2020 - 05:24:00 UTC 34.5727 -120.40502 Lompoc 260 []
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"}]
1242839 January 30, 2021 - 16:46:20 UTC 34.57418 -120.51715 Lompoc 260 [{"latitude": "34.53759", "longitude": "-120.53113"}, {"latitude": "34.5388", "longitude": "-120.53676"}, {"latitude": "34.53768", "longitude": "-120.53236"}]
1319272 April 16, 2021 - 15:35:16 UTC 34.57471 -120.14423 Solvang 446 []
1337683 April 30, 2021 - 15:43:46 UTC 34.57471 -120.14423 Solvang 446 []
1148419 November 18, 2020 - 17:34:00 UTC 34.57682 -119.95538 Santa Barbara 752 [{"latitude": "34.54373", "longitude": "-119.89861"}, {"latitude": "34.54634", "longitude": "-119.87253"}, {"latitude": "34.55845", "longitude": "-119.88388"}, {"latitude": "34.57651", "longitude": "-119.95407"}, {"latitude": "34.57668", "longitude": "-119.95477"}, {"latitude": "34.56971", "longitude": "-119.95486"}, {"latitude": "34.56026", "longitude": "-119.95075"}, {"latitude": "34.55871", "longitude": "-119.94911"}, {"latitude": "34.55171", "longitude": "-119.935"}]
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 []
1278453 March 11, 2021 - 16:24:11 UTC 34.57999 -120.05951 Santa Ynez 68 []
1255484 February 16, 2021 - 14:30:30 UTC 34.58157 -120.14639 Solvang 446 []
1274673 March 09, 2021 - 14:01:29 UTC 34.58168 -120.07781 Santa Ynez 68 [{"latitude": "34.57149", "longitude": "-120.08071"}, {"latitude": "34.57165", "longitude": "-120.0675"}, {"latitude": "34.58082", "longitude": "-120.07788"}, {"latitude": "34.58133", "longitude": "-120.0803"}, {"latitude": "34.57673", "longitude": "-120.08229"}]
1218354 January 20, 2021 - 16:23:50 UTC 34.58177 -120.07068 Santa Ynez 68 []
1251281 February 09, 2021 - 17:03:00 UTC 34.58188 -120.05854 Santa Ynez 68 []
1284232 March 16, 2021 - 15:02:07 UTC 34.58208 -120.05994 Santa Ynez 68 []
1337535 April 30, 2021 - 12:50:10 UTC 34.5826 -120.1457 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.58157", "longitude": "-120.14639"}, {"latitude": "34.57303", "longitude": "-120.1477"}]
1278616 March 11, 2021 - 17:21:18 UTC 34.58336 -120.05342 Santa Ynez 68 []
1209191 January 12, 2021 - 23:44:14 UTC 34.58361 -119.98064 Santa Barbara 752 []
1131353 October 29, 2020 - 16:16:43 UTC 34.58372 -120.39762 Lompoc 260 []
1163049 December 04, 2020 - 20:07:53 UTC 34.58384 -120.52532 Lompoc 260 []
1339803 May 03, 2021 - 17:14:34 UTC 34.58449 -120.09123 Santa Ynez 68 []
1340728 May 04, 2021 - 19:27:41 UTC 34.58449 -120.09123 Santa Ynez 68 []
1131073 October 29, 2020 - 00:46:28 UTC 34.58487 -120.4021 Lompoc 260 []
1289609 March 20, 2021 - 15:05:49 UTC 34.58562 -120.06241 Santa Ynez 68 [{"latitude": "34.57999", "longitude": "-120.05951"}, {"latitude": "34.58453", "longitude": "-120.0573"}, {"latitude": "34.5846", "longitude": "-120.06095"}]
1289626 March 20, 2021 - 15:24:16 UTC 34.58646 -120.06189 Santa Ynez 68 [{"latitude": "34.58366", "longitude": "-120.06266"}, {"latitude": "34.58616", "longitude": "-120.06226"}, {"latitude": "34.58579", "longitude": "-120.06288"}]
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"}]
1202299 January 02, 2021 - 03:42:32 UTC 34.58792 -119.99207 Santa Ynez 68 []
1263510 February 27, 2021 - 17:39:58 UTC 34.5887 -120.09966 Santa Ynez 68 []
1125678 October 25, 2020 - 21:56:14 UTC 34.58966 -120.48735 Lompoc 260 []
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 []
1110825 October 04, 2020 - 18:01:34 UTC 34.59078 -120.1448 Solvang 446 []
1326688 April 21, 2021 - 16:38:39 UTC 34.59084 -120.14105 Solvang 446 []
1153096 November 23, 2020 - 17:15:00 UTC 34.59101 -120.14422 Solvang 446 []
695601 October 30, 2019 - 22:22:25 UTC 34.59278 -120.14013 Solvang 446 []
1209045 January 12, 2021 - 20:28:39 UTC 34.59278 -120.14013 Solvang 446 []
1189864 December 16, 2020 - 14:53:00 UTC 34.59327 -120.14516 Solvang 446 []
1282796 March 15, 2021 - 16:27:03 UTC 34.59382 -120.27085 Buellton 374 []
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"}]
1189866 December 16, 2020 - 14:54:00 UTC 34.59409 -120.14612 Solvang 446 []
655475 October 13, 2019 - 06:26:50 UTC 34.59431 -120.13917 Solvang 446 []
1161882 December 04, 2020 - 15:05:00 UTC 34.59431 -120.46835 Lompoc 260 [{"latitude": "34.53759", "longitude": "-120.53113"}, {"latitude": "34.56659", "longitude": "-120.49908"}, {"latitude": "34.59241", "longitude": "-120.4716"}, {"latitude": "34.59297", "longitude": "-120.47355"}, {"latitude": "34.59419", "longitude": "-120.49378"}, {"latitude": "34.59119", "longitude": "-120.52912"}, {"latitude": "34.59058", "longitude": "-120.5325"}, {"latitude": "34.5388", "longitude": "-120.53676"}, {"latitude": "34.53768", "longitude": "-120.53236"}]
1123820 October 23, 2020 - 03:09:49 UTC 34.59439 -120.13944 Solvang 446 []
1084913 September 21, 2020 - 18:56:34 UTC 34.59442 -120.14208 Solvang 446 []
1120018 October 17, 2020 - 23:37:24 UTC 34.59454 -120.25432 Buellton 374 []
1156101 November 30, 2020 - 16:13:33 UTC 34.59455 -120.15657 Goleta 874 []
1245793 February 02, 2021 - 16:53:49 UTC 34.59477 -120.1279 Solvang 446 [{"latitude": "34.59532", "longitude": "-120.12571"}, {"latitude": "34.59634", "longitude": "-120.12448"}, {"latitude": "34.59775", "longitude": "-120.12362"}]
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"}]

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