121 rows where regionName = 89

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
633640 October 01, 2019 - 15:16:01 UTC 36.60836 -119.64649 Fowler 89 []
635787 October 02, 2019 - 15:28:12 UTC 36.6157 -119.66197 Fowler 89 []
636215 October 02, 2019 - 16:56:00 UTC 36.6381 -119.6799 Fowler 89 []
653537 October 10, 2019 - 22:36:30 UTC 36.59844 -119.64788 Fowler 89 []
676141 October 21, 2019 - 18:37:59 UTC 36.62827 -119.67329 Fowler 89 []
709963 November 19, 2019 - 17:09:38 UTC 36.62885 -119.67155 Fowler 89 []
709979 November 19, 2019 - 17:22:18 UTC 36.62882 -119.6724 Fowler 89 []
710083 November 19, 2019 - 18:36:34 UTC 36.62669 -119.6758 Fowler 89 []
710585 November 20, 2019 - 07:03:51 UTC 36.62662 -119.68797 Fowler 89 []
710586 November 20, 2019 - 07:04:27 UTC 36.6287 -119.68977 Fowler 89 []
710587 November 20, 2019 - 07:05:00 UTC 36.62502 -119.68799 Fowler 89 []
710588 November 20, 2019 - 07:05:28 UTC 36.62588 -119.688 Fowler 89 []
710591 November 20, 2019 - 07:11:35 UTC 36.62437 -119.68872 Fowler 89 []
710592 November 20, 2019 - 07:05:00 UTC 36.62502 -119.68799 Fowler 89 []
710593 November 20, 2019 - 07:05:28 UTC 36.62588 -119.688 Fowler 89 []
710594 November 20, 2019 - 07:03:51 UTC 36.62662 -119.68797 Fowler 89 []
710595 November 20, 2019 - 07:04:27 UTC 36.62745 -119.69107 Fowler 89 [{"latitude": "36.62766", "longitude": "-119.68959"}, {"latitude": "36.62925", "longitude": "-119.68914"}, {"latitude": "36.62982", "longitude": "-119.68945"}, {"latitude": "36.63027", "longitude": "-119.68994"}, {"latitude": "36.63041", "longitude": "-119.69062"}, {"latitude": "36.6288", "longitude": "-119.69074"}]
710596 November 20, 2019 - 07:20:00 UTC 36.62424 -119.68713 Fowler 89 []
712269 November 21, 2019 - 19:14:09 UTC 36.66121 -119.64114 Fowler 89 []
715079 November 26, 2019 - 16:27:22 UTC 36.62348 -119.64221 Fowler 89 []
715273 November 26, 2019 - 20:06:54 UTC 36.6255 -119.67557 Fowler 89 []
719756 November 27, 2019 - 11:02:35 UTC 36.61273 -119.69982 Fowler 89 []
719757 November 27, 2019 - 11:02:36 UTC 36.61284 -119.70024 Fowler 89 [{"latitude": "36.61621", "longitude": "-119.70022"}, {"latitude": "36.61755", "longitude": "-119.69628"}, {"latitude": "36.62002", "longitude": "-119.69171"}, {"latitude": "36.62314", "longitude": "-119.69604"}, {"latitude": "36.61986", "longitude": "-119.70223"}]
719915 November 27, 2019 - 11:03:15 UTC 36.61999 -119.69569 Fowler 89 []
723059 November 28, 2019 - 21:25:40 UTC 36.6508 -119.67789 Fowler 89 []
723290 November 29, 2019 - 08:42:00 UTC 36.61035 -119.63823 Fowler 89 [{"latitude": "36.60723", "longitude": "-119.66264"}, {"latitude": "36.6144", "longitude": "-119.64248"}, {"latitude": "36.61984", "longitude": "-119.63757"}, {"latitude": "36.62714", "longitude": "-119.64638"}, {"latitude": "36.644", "longitude": "-119.67024"}, {"latitude": "36.64401", "longitude": "-119.67265"}, {"latitude": "36.64401", "longitude": "-119.67338"}, {"latitude": "36.63794", "longitude": "-119.68674"}, {"latitude": "36.62878", "longitude": "-119.6861"}, {"latitude": "36.6239", "longitude": "-119.68571"}, {"latitude": "36.62223", "longitude": "-119.68557"}, {"latitude": "36.62093", "longitude": "-119.68428"}]
725307 December 01, 2019 - 06:37:07 UTC 36.63047 -119.6718 Fowler 89 []
729394 December 04, 2019 - 15:41:54 UTC 36.63658 -119.61934 Fowler 89 []
730811 December 05, 2019 - 23:20:40 UTC 36.62093 -119.71371 Fowler 89 [{"latitude": "36.62187", "longitude": "-119.71369"}, {"latitude": "36.62305", "longitude": "-119.71142"}, {"latitude": "36.62619", "longitude": "-119.71366"}, {"latitude": "36.62474", "longitude": "-119.71369"}]
730893 December 06, 2019 - 01:20:26 UTC 36.62305 -119.71142 Fowler 89 []
730894 December 05, 2019 - 23:20:40 UTC 36.62187 -119.71369 Fowler 89 []
733850 December 08, 2019 - 21:39:00 UTC 36.66023 -119.64597 Fowler 89 []
738822 December 14, 2019 - 05:19:20 UTC 36.63087 -119.66147 Fowler 89 [{"latitude": "36.63134", "longitude": "-119.66109"}, {"latitude": "36.63199", "longitude": "-119.66025"}, {"latitude": "36.63292", "longitude": "-119.66019"}, {"latitude": "36.6341", "longitude": "-119.66084"}, {"latitude": "36.63301", "longitude": "-119.66143"}, {"latitude": "36.6322", "longitude": "-119.66139"}]
778696 February 05, 2020 - 22:43:58 UTC 36.60091 -119.68667 Fowler 89 []
779253 February 06, 2020 - 18:36:12 UTC 36.62141 -119.68551 Fowler 89 []
788582 February 11, 2020 - 18:23:07 UTC 36.62348 -119.64221 Fowler 89 []
788924 February 11, 2020 - 22:47:01 UTC 36.65225 -119.64155 Fowler 89 []
1078396 September 17, 2020 - 19:12:57 UTC 36.58388 -119.66458 Fowler 89 [{"latitude": "36.58165", "longitude": "-119.66842"}, {"latitude": "36.58361", "longitude": "-119.64559"}, {"latitude": "36.58507", "longitude": "-119.64206"}, {"latitude": "36.59062", "longitude": "-119.63981"}, {"latitude": "36.59435", "longitude": "-119.64377"}, {"latitude": "36.59346", "longitude": "-119.65778"}, {"latitude": "36.5836", "longitude": "-119.66917"}]
1092251 September 25, 2020 - 16:05:00 UTC 36.59019 -119.70042 Fowler 89 [{"latitude": "36.5704", "longitude": "-119.70498"}, {"latitude": "36.57161", "longitude": "-119.70122"}, {"latitude": "36.5723", "longitude": "-119.70073"}, {"latitude": "36.58318", "longitude": "-119.69749"}, {"latitude": "36.58559", "longitude": "-119.69841"}, {"latitude": "36.58822", "longitude": "-119.70042"}, {"latitude": "36.58745", "longitude": "-119.70461"}, {"latitude": "36.57632", "longitude": "-119.70726"}]
1103574 October 01, 2020 - 16:24:37 UTC 36.62305 -119.71142 Fowler 89 []
1112589 October 07, 2020 - 15:55:00 UTC 36.6043 -119.6823 Fowler 89 [{"latitude": "36.57923", "longitude": "-119.68249"}, {"latitude": "36.58366", "longitude": "-119.67134"}, {"latitude": "36.60239", "longitude": "-119.67406"}, {"latitude": "36.60325", "longitude": "-119.68203"}, {"latitude": "36.60243", "longitude": "-119.68456"}, {"latitude": "36.60091", "longitude": "-119.68667"}, {"latitude": "36.58374", "longitude": "-119.69368"}]
1113103 October 08, 2020 - 00:10:10 UTC 36.63389 -119.69864 Fowler 89 []
1124499 October 24, 2020 - 16:33:05 UTC 36.61273 -119.68916 Fowler 89 []
1138235 November 07, 2020 - 14:35:03 UTC 36.62684 -119.70456 Fowler 89 [{"latitude": "36.62314", "longitude": "-119.70456"}, {"latitude": "36.62536", "longitude": "-119.70618"}, {"latitude": "36.62673", "longitude": "-119.7072"}, {"latitude": "36.62535", "longitude": "-119.70894"}]
1141076 November 10, 2020 - 18:07:37 UTC 36.64632 -119.66423 Fowler 89 []
1141117 November 10, 2020 - 18:07:00 UTC 36.64732 -119.66431 Fowler 89 []
1141408 November 10, 2020 - 22:56:13 UTC 36.64453 -119.66423 Fowler 89 []
1142118 November 11, 2020 - 22:43:56 UTC 36.61274 -119.69143 Fowler 89 []
1142197 November 12, 2020 - 03:28:45 UTC 36.61273 -119.70486 Fowler 89 [{"latitude": "36.61212", "longitude": "-119.70485"}, {"latitude": "36.61513", "longitude": "-119.70402"}, {"latitude": "36.61998", "longitude": "-119.70473"}, {"latitude": "36.61933", "longitude": "-119.70486"}, {"latitude": "36.61514", "longitude": "-119.70486"}]
1143006 November 13, 2020 - 00:34:58 UTC 36.61273 -119.68916 Fowler 89 []
1144687 November 14, 2020 - 13:13:41 UTC 36.59092 -119.69951 Fowler 89 [{"latitude": "36.5901", "longitude": "-119.68931"}, {"latitude": "36.59155", "longitude": "-119.68932"}, {"latitude": "36.59276", "longitude": "-119.69174"}, {"latitude": "36.59094", "longitude": "-119.69705"}]
1149223 November 19, 2020 - 16:09:40 UTC 36.63548 -119.6732 Fowler 89 []
1149468 November 19, 2020 - 20:04:09 UTC 36.65338 -119.67135 Fowler 89 []
1152460 November 22, 2020 - 00:58:36 UTC 36.61274 -119.69351 Fowler 89 []
1155229 November 27, 2020 - 20:10:18 UTC 36.60158 -119.6493 Fowler 89 []
1156809 December 01, 2020 - 08:47:30 UTC 36.58388 -119.66458 Fowler 89 [{"latitude": "36.58165", "longitude": "-119.66842"}, {"latitude": "36.58361", "longitude": "-119.64559"}, {"latitude": "36.58507", "longitude": "-119.64206"}, {"latitude": "36.59062", "longitude": "-119.63981"}, {"latitude": "36.59435", "longitude": "-119.64377"}, {"latitude": "36.59346", "longitude": "-119.65778"}, {"latitude": "36.5836", "longitude": "-119.66917"}]
1161842 December 04, 2020 - 12:08:00 UTC 36.63606 -119.63714 Fowler 89 [{"latitude": "36.63502", "longitude": "-119.66605"}, {"latitude": "36.63505", "longitude": "-119.66339"}, {"latitude": "36.63909", "longitude": "-119.63717"}, {"latitude": "36.64586", "longitude": "-119.62162"}, {"latitude": "36.64852", "longitude": "-119.61953"}, {"latitude": "36.66655", "longitude": "-119.6134"}, {"latitude": "36.6704", "longitude": "-119.6126"}, {"latitude": "36.69229", "longitude": "-119.61191"}, {"latitude": "36.69916", "longitude": "-119.61858"}, {"latitude": "36.7042", "longitude": "-119.62941"}, {"latitude": "36.7042", "longitude": "-119.62944"}, {"latitude": "36.68407", "longitude": "-119.67288"}, {"latitude": "36.67822", "longitude": "-119.67768"}, {"latitude": "36.64904", "longitude": "-119.67991"}, {"latitude": "36.63609", "longitude": "-119.66832"}, {"latitude": "36.63502", "longitude": "-119.66695"}]
1166359 December 06, 2020 - 17:06:52 UTC 36.6121 -119.71835 Fowler 89 []
1169397 December 07, 2020 - 22:39:41 UTC 36.63245 -119.6802 Fowler 89 []
1170298 December 08, 2020 - 16:02:09 UTC 36.65723 -119.67305 Fowler 89 []
1176154 December 10, 2020 - 18:22:43 UTC 36.63469 -119.69107 Fowler 89 []
1180539 December 12, 2020 - 08:09:03 UTC 36.62054 -119.66963 Fowler 89 []
1181949 December 12, 2020 - 23:10:00 UTC 36.63464 -119.6848 Fowler 89 []
1188770 December 16, 2020 - 00:44:57 UTC 36.60158 -119.6493 Fowler 89 []
1197742 December 23, 2020 - 18:52:52 UTC 36.6448 -119.62962 Fowler 89 []
1198348 December 25, 2020 - 01:33:41 UTC 36.64165 -119.61024 Fowler 89 [{"latitude": "36.63658", "longitude": "-119.61934"}, {"latitude": "36.64159", "longitude": "-119.6048"}, {"latitude": "36.64479", "longitude": "-119.6196"}, {"latitude": "36.64478", "longitude": "-119.62117"}, {"latitude": "36.63927", "longitude": "-119.62109"}]
1198672 December 26, 2020 - 00:05:13 UTC 36.64878 -119.5994 Fowler 89 []
1199324 December 27, 2020 - 04:10:15 UTC 36.61324 -119.63743 Fowler 89 []
1199598 December 28, 2020 - 02:53:00 UTC 36.60622 -119.68231 Fowler 89 [{"latitude": "36.60695", "longitude": "-119.68231"}, {"latitude": "36.61683", "longitude": "-119.67331"}, {"latitude": "36.61727", "longitude": "-119.67332"}, {"latitude": "36.61998", "longitude": "-119.67353"}, {"latitude": "36.62225", "longitude": "-119.67911"}, {"latitude": "36.62336", "longitude": "-119.68923"}, {"latitude": "36.62335", "longitude": "-119.69005"}, {"latitude": "36.62248", "longitude": "-119.69084"}, {"latitude": "36.62145", "longitude": "-119.69087"}, {"latitude": "36.61773", "longitude": "-119.69045"}]
1199599 December 28, 2020 - 02:56:19 UTC 36.62719 -119.68035 Fowler 89 []
1199634 December 28, 2020 - 05:14:33 UTC 36.62173 -119.67831 Fowler 89 []
1199635 December 28, 2020 - 05:14:33 UTC 36.61722 -119.68729 Fowler 89 []
1199637 December 28, 2020 - 05:16:23 UTC 36.62067 -119.68547 Fowler 89 []
1199655 December 28, 2020 - 06:25:46 UTC 36.62719 -119.68035 Fowler 89 []
1199663 December 28, 2020 - 06:42:13 UTC 36.63405 -119.68123 Fowler 89 []
1199679 December 28, 2020 - 07:28:10 UTC 36.60622 -119.68231 Fowler 89 [{"latitude": "36.60695", "longitude": "-119.68231"}, {"latitude": "36.61683", "longitude": "-119.67331"}, {"latitude": "36.61727", "longitude": "-119.67332"}, {"latitude": "36.61998", "longitude": "-119.67353"}, {"latitude": "36.62225", "longitude": "-119.67911"}, {"latitude": "36.62336", "longitude": "-119.68923"}, {"latitude": "36.62335", "longitude": "-119.69005"}, {"latitude": "36.62248", "longitude": "-119.69084"}, {"latitude": "36.62145", "longitude": "-119.69087"}, {"latitude": "36.61773", "longitude": "-119.69045"}]
1199787 December 28, 2020 - 12:20:42 UTC 36.61704 -119.68952 Fowler 89 []
1199788 December 28, 2020 - 12:28:00 UTC 36.62056 -119.68949 Fowler 89 []
1204379 January 05, 2021 - 16:26:51 UTC 36.61176 -119.65738 Fowler 89 []
1207046 January 09, 2021 - 01:39:20 UTC 36.65723 -119.67305 Fowler 89 []
1207804 January 11, 2021 - 00:09:00 UTC 36.6026 -119.6815 Fowler 89 []
1209619 January 13, 2021 - 16:55:02 UTC 36.58388 -119.66458 Fowler 89 [{"latitude": "36.58165", "longitude": "-119.66842"}, {"latitude": "36.58251", "longitude": "-119.66827"}, {"latitude": "36.5836", "longitude": "-119.66917"}]
1210202 January 14, 2021 - 16:13:08 UTC 36.64896 -119.6594 Fowler 89 [{"latitude": "36.64918", "longitude": "-119.65936"}, {"latitude": "36.64984", "longitude": "-119.65935"}, {"latitude": "36.65052", "longitude": "-119.65935"}]
1210203 January 14, 2021 - 16:13:08 UTC 36.64867 -119.65942 Fowler 89 []
1210828 January 15, 2021 - 16:00:00 UTC 36.64221 -119.5928 Fowler 89 []
1215642 January 19, 2021 - 16:04:11 UTC 36.64896 -119.6594 Fowler 89 [{"latitude": "36.64918", "longitude": "-119.65936"}, {"latitude": "36.64984", "longitude": "-119.65935"}, {"latitude": "36.65052", "longitude": "-119.65935"}]
1215643 January 19, 2021 - 16:04:11 UTC 36.64867 -119.65942 Fowler 89 []
1220559 January 22, 2021 - 16:54:58 UTC 36.58718 -119.68754 Fowler 89 []
1221802 January 23, 2021 - 19:47:22 UTC 36.60744 -119.63752 Fowler 89 []
1222438 January 24, 2021 - 19:13:00 UTC 36.63606 -119.63714 Fowler 89 [{"latitude": "36.63502", "longitude": "-119.66695"}, {"latitude": "36.63502", "longitude": "-119.66605"}, {"latitude": "36.63505", "longitude": "-119.66339"}, {"latitude": "36.63909", "longitude": "-119.63717"}, {"latitude": "36.64586", "longitude": "-119.62162"}, {"latitude": "36.64852", "longitude": "-119.61953"}, {"latitude": "36.66655", "longitude": "-119.6134"}, {"latitude": "36.6704", "longitude": "-119.6126"}, {"latitude": "36.69229", "longitude": "-119.61191"}, {"latitude": "36.69916", "longitude": "-119.61858"}, {"latitude": "36.7042", "longitude": "-119.62941"}, {"latitude": "36.7042", "longitude": "-119.62944"}, {"latitude": "36.68407", "longitude": "-119.67288"}, {"latitude": "36.67822", "longitude": "-119.67768"}, {"latitude": "36.64904", "longitude": "-119.67991"}, {"latitude": "36.63609", "longitude": "-119.66832"}]
1242896 January 30, 2021 - 17:38:48 UTC 36.63369 -119.67705 Fowler 89 [{"latitude": "36.63429", "longitude": "-119.67672"}, {"latitude": "36.63502", "longitude": "-119.67577"}, {"latitude": "36.6362", "longitude": "-119.67599"}, {"latitude": "36.63642", "longitude": "-119.67724"}, {"latitude": "36.63503", "longitude": "-119.67845"}]
1246316 February 02, 2021 - 23:41:49 UTC 36.59092 -119.67365 Fowler 89 []
1246554 February 03, 2021 - 03:14:29 UTC 36.62668 -119.69181 Fowler 89 []
1246607 February 03, 2021 - 00:06:00 UTC 36.62668 -119.69181 Fowler 89 []
1246725 February 03, 2021 - 16:07:00 UTC 36.61266 -119.67785 Fowler 89 [{"latitude": "36.61472", "longitude": "-119.67603"}, {"latitude": "36.6174", "longitude": "-119.67582"}, {"latitude": "36.61602", "longitude": "-119.67786"}, {"latitude": "36.61472", "longitude": "-119.67771"}]
1247962 February 04, 2021 - 20:33:43 UTC 36.61273 -119.69982 Fowler 89 []
1248545 February 05, 2021 - 16:42:26 UTC 36.60484 -119.64651 Fowler 89 []
1248618 February 05, 2021 - 17:10:38 UTC 36.6055 -119.64197 Fowler 89 [{"latitude": "36.60242", "longitude": "-119.64376"}, {"latitude": "36.60344", "longitude": "-119.6412"}, {"latitude": "36.61091", "longitude": "-119.64191"}]
1252361 February 10, 2021 - 19:26:15 UTC 36.58388 -119.66458 Fowler 89 [{"latitude": "36.58165", "longitude": "-119.66842"}, {"latitude": "36.58361", "longitude": "-119.64559"}, {"latitude": "36.58507", "longitude": "-119.64206"}, {"latitude": "36.59062", "longitude": "-119.63981"}, {"latitude": "36.59435", "longitude": "-119.64377"}, {"latitude": "36.59346", "longitude": "-119.65778"}, {"latitude": "36.5836", "longitude": "-119.66917"}]
1258112 February 19, 2021 - 23:26:54 UTC 36.63701 -119.66611 Fowler 89 []

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