118 rows where regionName = 68

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
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"}]
633809 October 01, 2019 - 16:07:35 UTC 34.61353 -120.07835 Santa Ynez 68 []
633952 October 01, 2019 - 17:45:24 UTC 34.6023 -120.111 Santa Ynez 68 []
644094 October 05, 2019 - 16:01:00 UTC 34.62996 -120.00137 Santa Ynez 68 []
645597 October 06, 2019 - 17:45:36 UTC 34.59623 -120.05576 Santa Ynez 68 []
646827 October 07, 2019 - 21:45:51 UTC 34.62117 -120.09578 Santa Ynez 68 []
659845 October 15, 2019 - 21:42:17 UTC 34.63426 -120.0304 Santa Ynez 68 []
659846 October 15, 2019 - 21:42:32 UTC 34.63747 -120.08309 Santa Ynez 68 []
663228 October 17, 2019 - 03:20:14 UTC 34.63544 -120.06838 Santa Ynez 68 []
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"}]
676261 October 21, 2019 - 19:55:54 UTC 34.62741 -120.08041 Santa Ynez 68 []
679365 October 24, 2019 - 15:00:00 UTC 34.6987 -120.05969 Santa Ynez 68 [{"latitude": "34.69981", "longitude": "-120.05895"}, {"latitude": "34.70285", "longitude": "-120.05738"}, {"latitude": "34.70818", "longitude": "-120.05886"}, {"latitude": "34.71282", "longitude": "-120.0613"}, {"latitude": "34.70702", "longitude": "-120.06348"}]
699705 November 05, 2019 - 07:18:04 UTC 34.65656 -120.08844 Santa Ynez 68 [{"latitude": "34.65621", "longitude": "-120.08745"}, {"latitude": "34.65636", "longitude": "-120.08589"}, {"latitude": "34.66171", "longitude": "-120.08239"}, {"latitude": "34.67757", "longitude": "-120.07376"}, {"latitude": "34.67899", "longitude": "-120.07493"}, {"latitude": "34.67991", "longitude": "-120.08003"}, {"latitude": "34.67775", "longitude": "-120.08512"}, {"latitude": "34.65747", "longitude": "-120.08773"}]
702491 November 08, 2019 - 16:35:00 UTC 34.66667 -120.10402 Santa Ynez 68 []
702492 November 08, 2019 - 16:35:00 UTC 34.66417 -120.1008 Santa Ynez 68 []
702495 November 08, 2019 - 16:35:00 UTC 34.66735 -120.06083 Santa Ynez 68 []
702699 November 08, 2019 - 18:03:44 UTC 34.62792 -120.09325 Santa Ynez 68 []
702719 November 08, 2019 - 18:20:42 UTC 34.61402 -120.00636 Santa Ynez 68 []
702730 November 08, 2019 - 18:28:15 UTC 34.65826 -120.08624 Santa Ynez 68 []
702870 November 08, 2019 - 21:14:00 UTC 34.69173 -120.06382 Santa Ynez 68 []
721135 November 27, 2019 - 18:35:00 UTC 34.68757 -120.08779 Santa Ynez 68 [{"latitude": "34.68782", "longitude": "-120.08742"}, {"latitude": "34.6897", "longitude": "-120.08396"}, {"latitude": "34.69471", "longitude": "-120.07525"}, {"latitude": "34.7034", "longitude": "-120.07644"}, {"latitude": "34.70521", "longitude": "-120.07949"}, {"latitude": "34.70236", "longitude": "-120.08642"}, {"latitude": "34.69986", "longitude": "-120.08979"}, {"latitude": "34.68953", "longitude": "-120.08956"}]
721230 November 27, 2019 - 18:47:00 UTC 34.68732 -120.07788 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 []
731510 December 06, 2019 - 19:53:45 UTC 34.61567 -120.08009 Santa Ynez 68 []
732626 December 07, 2019 - 19:31:00 UTC 34.66696 -120.08933 Santa Ynez 68 []
736255 December 11, 2019 - 16:56:38 UTC 34.64295 -120.09816 Santa Ynez 68 []
737104 December 12, 2019 - 15:03:22 UTC 34.65829 -119.94817 Santa Ynez 68 []
744348 December 17, 2019 - 17:32:06 UTC 34.66858 -120.02821 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 []
780256 February 07, 2020 - 22:32:16 UTC 34.60717 -120.09207 Santa Ynez 68 []
790265 February 13, 2020 - 17:23:04 UTC 34.62618 -120.09288 Santa Ynez 68 []
1062844 September 10, 2020 - 16:39:02 UTC 34.58721 -119.99096 Santa Ynez 68 []
1062999 September 10, 2020 - 17:37:43 UTC 34.61004 -120.08515 Santa Ynez 68 []
1063221 September 10, 2020 - 18:28:00 UTC 34.60994 -120.08546 Santa Ynez 68 []
1068353 September 14, 2020 - 15:51:04 UTC 34.61265 -120.10013 Santa Ynez 68 []
1088938 September 23, 2020 - 15:56:22 UTC 34.60379 -120.11593 Santa Ynez 68 []
1097005 September 28, 2020 - 23:48:59 UTC 34.61244 -120.1064 Santa Ynez 68 [{"latitude": "34.60828", "longitude": "-120.10822"}, {"latitude": "34.61019", "longitude": "-120.1061"}, {"latitude": "34.61213", "longitude": "-120.10543"}, {"latitude": "34.61201", "longitude": "-120.10664"}, {"latitude": "34.61148", "longitude": "-120.10757"}, {"latitude": "34.60925", "longitude": "-120.11132"}, {"latitude": "34.60863", "longitude": "-120.11075"}]
1097029 September 29, 2020 - 00:14:25 UTC 34.61225 -120.10844 Santa Ynez 68 []
1097030 September 29, 2020 - 00:15:20 UTC 34.61462 -120.10539 Santa Ynez 68 []
1101275 September 30, 2020 - 16:02:49 UTC 34.6581 -120.05945 Santa Ynez 68 [{"latitude": "34.65806", "longitude": "-120.06012"}, {"latitude": "34.66344", "longitude": "-120.06194"}, {"latitude": "34.66739", "longitude": "-120.06376"}, {"latitude": "34.66771", "longitude": "-120.06488"}, {"latitude": "34.66424", "longitude": "-120.06377"}]
1113382 October 08, 2020 - 16:05:00 UTC 34.63223 -120.01118 Santa Ynez 68 []
1115043 October 11, 2020 - 00:39:05 UTC 34.60828 -120.08664 Santa Ynez 68 []
1116302 October 13, 2020 - 15:12:58 UTC 34.65032 -120.08919 Santa Ynez 68 [{"latitude": "34.6547", "longitude": "-120.08912"}, {"latitude": "34.65636", "longitude": "-120.08589"}, {"latitude": "34.66171", "longitude": "-120.08239"}, {"latitude": "34.67757", "longitude": "-120.07376"}, {"latitude": "34.67899", "longitude": "-120.07493"}, {"latitude": "34.67991", "longitude": "-120.08003"}, {"latitude": "34.67957", "longitude": "-120.09225"}, {"latitude": "34.67917", "longitude": "-120.09494"}, {"latitude": "34.67776", "longitude": "-120.10063"}, {"latitude": "34.67524", "longitude": "-120.10145"}, {"latitude": "34.67407", "longitude": "-120.10145"}, {"latitude": "34.66592", "longitude": "-120.10112"}, {"latitude": "34.66417", "longitude": "-120.1008"}, {"latitude": "34.661", "longitude": "-120.09866"}]
1116308 October 13, 2020 - 15:12:58 UTC 34.65742 -120.09078 Santa Ynez 68 [{"latitude": "34.65524", "longitude": "-120.0925"}, {"latitude": "34.66026", "longitude": "-120.09516"}, {"latitude": "34.66072", "longitude": "-120.09677"}, {"latitude": "34.65743", "longitude": "-120.09666"}]
1116714 October 13, 2020 - 20:58:50 UTC 34.65032 -120.08919 Santa Ynez 68 [{"latitude": "34.6547", "longitude": "-120.08912"}, {"latitude": "34.65636", "longitude": "-120.08589"}, {"latitude": "34.66171", "longitude": "-120.08239"}, {"latitude": "34.67757", "longitude": "-120.07376"}, {"latitude": "34.67899", "longitude": "-120.07493"}, {"latitude": "34.67991", "longitude": "-120.08003"}, {"latitude": "34.67957", "longitude": "-120.09225"}, {"latitude": "34.67917", "longitude": "-120.09494"}, {"latitude": "34.67776", "longitude": "-120.10063"}, {"latitude": "34.67524", "longitude": "-120.10145"}, {"latitude": "34.67407", "longitude": "-120.10145"}, {"latitude": "34.66592", "longitude": "-120.10112"}, {"latitude": "34.66417", "longitude": "-120.1008"}, {"latitude": "34.661", "longitude": "-120.09866"}]
1117143 October 14, 2020 - 16:18:00 UTC 34.68507 -120.03777 Santa Ynez 68 [{"latitude": "34.67939", "longitude": "-120.01749"}, {"latitude": "34.72743", "longitude": "-119.98315"}, {"latitude": "34.73412", "longitude": "-119.99194"}, {"latitude": "34.733", "longitude": "-120.00452"}, {"latitude": "34.73202", "longitude": "-120.00563"}, {"latitude": "34.6882", "longitude": "-120.02011"}, {"latitude": "34.68239", "longitude": "-120.02038"}]
1117271 October 14, 2020 - 18:16:00 UTC 34.65747 -120.08773 Santa Ynez 68 []
1121343 October 20, 2020 - 14:59:50 UTC 34.59935 -120.09789 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.60896", "longitude": "-120.05714"}, {"latitude": "34.60261", "longitude": "-120.09322"}, {"latitude": "34.60005", "longitude": "-120.0973"}, {"latitude": "34.58259", "longitude": "-120.09643"}, {"latitude": "34.57149", "longitude": "-120.08071"}, {"latitude": "34.52699", "longitude": "-119.97544"}]
1121435 October 20, 2020 - 15:59:35 UTC 34.68757 -120.08779 Santa Ynez 68 [{"latitude": "34.68782", "longitude": "-120.08742"}, {"latitude": "34.6897", "longitude": "-120.08396"}, {"latitude": "34.69471", "longitude": "-120.07525"}, {"latitude": "34.7034", "longitude": "-120.07644"}, {"latitude": "34.70521", "longitude": "-120.07949"}, {"latitude": "34.70236", "longitude": "-120.08642"}, {"latitude": "34.69986", "longitude": "-120.08979"}, {"latitude": "34.68953", "longitude": "-120.08956"}]
1121556 October 20, 2020 - 17:26:00 UTC 34.68732 -120.07788 Santa Ynez 68 []
1121695 October 20, 2020 - 20:12:24 UTC 34.62372 -120.08637 Santa Ynez 68 []
1121722 October 20, 2020 - 20:47:52 UTC 34.69959 -120.08172 Santa Ynez 68 []
1122118 October 21, 2020 - 15:55:00 UTC 34.61751 -120.08936 Santa Ynez 68 [{"latitude": "34.61113", "longitude": "-120.09259"}, {"latitude": "34.61203", "longitude": "-120.09058"}, {"latitude": "34.6175", "longitude": "-120.08941"}, {"latitude": "34.61891", "longitude": "-120.09139"}, {"latitude": "34.61388", "longitude": "-120.09307"}, {"latitude": "34.61206", "longitude": "-120.09309"}]
1122385 October 21, 2020 - 19:55:03 UTC 34.65917 -120.07679 Santa Ynez 68 []
1123305 October 22, 2020 - 15:50:00 UTC 34.63609 -120.09585 Santa Ynez 68 [{"latitude": "34.63637", "longitude": "-120.09193"}, {"latitude": "34.6374", "longitude": "-120.09361"}, {"latitude": "34.63734", "longitude": "-120.0958"}, {"latitude": "34.63649", "longitude": "-120.09573"}]
1124403 October 24, 2020 - 11:22:32 UTC 34.6114 -120.09487 Santa Ynez 68 []
1130355 October 28, 2020 - 02:05:42 UTC 34.60758 -120.10567 Santa Ynez 68 []
1131069 October 29, 2020 - 00:38:25 UTC 34.60283 -120.09628 Santa Ynez 68 []
1132918 October 31, 2020 - 20:15:30 UTC 34.59623 -120.05576 Santa Ynez 68 []
1137242 November 06, 2020 - 16:37:00 UTC 34.62794 -120.08939 Santa Ynez 68 [{"latitude": "34.62611", "longitude": "-120.09476"}, {"latitude": "34.62612", "longitude": "-120.09341"}, {"latitude": "34.62615", "longitude": "-120.09156"}, {"latitude": "34.6279", "longitude": "-120.09033"}, {"latitude": "34.62792", "longitude": "-120.09325"}]
1140592 November 09, 2020 - 23:37:04 UTC 34.62886 -120.02933 Santa Ynez 68 []
1140900 November 10, 2020 - 16:31:00 UTC 34.61216 -120.10101 Santa Ynez 68 [{"latitude": "34.61213", "longitude": "-120.10376"}, {"latitude": "34.61214", "longitude": "-120.10298"}, {"latitude": "34.61229", "longitude": "-120.10217"}, {"latitude": "34.61294", "longitude": "-120.10217"}]
1141615 November 11, 2020 - 12:17:57 UTC 34.6358 -120.08224 Santa Ynez 68 []
1145947 November 16, 2020 - 16:15:48 UTC 34.61751 -120.08936 Santa Ynez 68 [{"latitude": "34.61113", "longitude": "-120.09259"}, {"latitude": "34.61203", "longitude": "-120.09058"}, {"latitude": "34.6175", "longitude": "-120.08941"}, {"latitude": "34.61891", "longitude": "-120.09139"}, {"latitude": "34.61388", "longitude": "-120.09307"}, {"latitude": "34.61206", "longitude": "-120.09309"}]
1145992 November 16, 2020 - 16:44:00 UTC 34.61372 -120.09483 Santa Ynez 68 []
1146390 November 16, 2020 - 21:41:15 UTC 34.66632 -119.99333 Santa Ynez 68 []
1146885 November 17, 2020 - 16:35:33 UTC 34.61499 -120.07781 Santa Ynez 68 []
1146949 November 17, 2020 - 17:03:12 UTC 34.64701 -119.97213 Santa Ynez 68 []
1148364 November 18, 2020 - 17:00:32 UTC 34.64888 -119.97273 Santa Ynez 68 []
1150070 November 20, 2020 - 17:11:01 UTC 34.61626 -120.08185 Santa Ynez 68 []
1151648 November 21, 2020 - 20:47:20 UTC 34.61567 -120.08009 Santa Ynez 68 []
1152607 November 22, 2020 - 08:13:02 UTC 34.64082 -119.96793 Santa Ynez 68 [{"latitude": "34.64461", "longitude": "-119.96234"}, {"latitude": "34.6447", "longitude": "-119.9599"}, {"latitude": "34.64627", "longitude": "-119.95032"}, {"latitude": "34.65283", "longitude": "-119.94495"}, {"latitude": "34.65416", "longitude": "-119.94395"}, {"latitude": "34.65674", "longitude": "-119.94417"}, {"latitude": "34.65829", "longitude": "-119.94817"}]
1154008 November 24, 2020 - 20:47:33 UTC 34.61218 -120.08622 Santa Ynez 68 []
1154717 November 26, 2020 - 07:36:54 UTC 34.72783 -119.98957 Santa Ynez 68 []
1157705 December 02, 2020 - 16:03:00 UTC 34.60887 -120.11048 Santa Ynez 68 []
1161827 December 04, 2020 - 06:10:00 UTC 34.62105 -120.07607 Santa Ynez 68 []
1172028 December 08, 2020 - 20:10:45 UTC 34.61192 -120.10883 Santa Ynez 68 []
1174627 December 09, 2020 - 23:21:00 UTC 34.60693 -120.11186 Santa Ynez 68 []
1175442 December 10, 2020 - 16:45:00 UTC 34.61516 -120.07834 Santa Ynez 68 []
1181126 December 12, 2020 - 17:22:00 UTC 34.69208 -120.05992 Santa Ynez 68 []
1182113 December 13, 2020 - 01:18:00 UTC 34.61031 -120.09589 Santa Ynez 68 []
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"}]
1192170 December 17, 2020 - 17:09:23 UTC 34.63592 -120.05131 Santa Ynez 68 []
1197128 December 22, 2020 - 18:06:43 UTC 34.66712 -120.05013 Santa Ynez 68 []
1197679 December 23, 2020 - 17:25:00 UTC 34.69539 -120.06526 Santa Ynez 68 [{"latitude": "34.69726", "longitude": "-120.06622"}, {"latitude": "34.7007", "longitude": "-120.06307"}, {"latitude": "34.70271", "longitude": "-120.06595"}, {"latitude": "34.70306", "longitude": "-120.06979"}]
1197768 December 23, 2020 - 19:56:30 UTC 34.66857 -120.02819 Santa Ynez 68 []
1198306 December 24, 2020 - 23:33:40 UTC 34.70022 -120.08925 Santa Ynez 68 []
1201694 December 31, 2020 - 15:28:04 UTC 34.62145 -120.07615 Santa Ynez 68 [{"latitude": "34.62147", "longitude": "-120.07612"}, {"latitude": "34.62503", "longitude": "-120.07395"}, {"latitude": "34.62648", "longitude": "-120.07599"}, {"latitude": "34.62316", "longitude": "-120.07673"}]
1202288 January 02, 2021 - 03:22:00 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"}]
1202299 January 02, 2021 - 03:42:32 UTC 34.58792 -119.99207 Santa Ynez 68 []
1208826 January 12, 2021 - 17:06:44 UTC 34.63544 -120.06838 Santa Ynez 68 []
1209071 January 12, 2021 - 20:51:00 UTC 34.63518 -120.06631 Santa Ynez 68 [{"latitude": "34.62281", "longitude": "-120.06425"}, {"latitude": "34.62297", "longitude": "-120.06388"}, {"latitude": "34.63493", "longitude": "-120.06631"}, {"latitude": "34.62427", "longitude": "-120.07031"}]
1210669 January 15, 2021 - 01:16:12 UTC 34.61757 -120.08053 Santa Ynez 68 []
1212115 January 18, 2021 - 14:20:00 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"}]
1212660 January 18, 2021 - 21:28:12 UTC 34.61904 -120.07995 Santa Ynez 68 []
1212866 January 19, 2021 - 02:23:00 UTC 34.61195 -120.08123 Santa Ynez 68 []
1218354 January 20, 2021 - 16:23:50 UTC 34.58177 -120.07068 Santa Ynez 68 []
1218910 January 20, 2021 - 21:59:12 UTC 34.61071 -120.08942 Santa Ynez 68 []

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