190 rows where regionName = 22 sorted by latitude

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude ▼ longitude regionName outageDevices
646831 October 07, 2019 - 21:49:47 UTC 36.3795 -119.94166 Riverdale 22 []
677685 October 23, 2019 - 20:15:26 UTC 36.3795 -119.94166 Riverdale 22 []
631794 September 30, 2019 - 19:30:12 UTC 36.37987 -119.92783 Riverdale 22 []
1337702 April 30, 2021 - 16:03:57 UTC 36.38034 -119.94118 Riverdale 22 []
1347818 May 13, 2021 - 15:36:39 UTC 36.38055 -119.94117 Riverdale 22 []
1249973 February 07, 2021 - 13:56:42 UTC 36.38686 -119.94119 Riverdale 22 [{"latitude": "36.39019", "longitude": "-119.94105"}, {"latitude": "36.4081", "longitude": "-119.94052"}, {"latitude": "36.40857", "longitude": "-119.9409"}, {"latitude": "36.40871", "longitude": "-119.95763"}, {"latitude": "36.40836", "longitude": "-119.95863"}, {"latitude": "36.40447", "longitude": "-119.95892"}, {"latitude": "36.40123", "longitude": "-119.95864"}]
1145606 November 15, 2020 - 21:49:22 UTC 36.38759 -119.85802 Riverdale 22 []
1253603 February 12, 2021 - 16:12:50 UTC 36.38761 -119.86245 Riverdale 22 []
1249974 February 07, 2021 - 13:56:40 UTC 36.38824 -119.92074 Riverdale 22 []
1296031 March 24, 2021 - 20:32:04 UTC 36.38824 -119.92074 Riverdale 22 []
1347814 May 13, 2021 - 15:35:11 UTC 36.39019 -119.94105 Riverdale 22 []
1250193 February 08, 2021 - 00:41:00 UTC 36.39201 -119.85126 Riverdale 22 []
1212633 January 18, 2021 - 20:46:43 UTC 36.39276 -119.83423 Riverdale 22 []
1290788 March 21, 2021 - 18:02:24 UTC 36.39342 -119.86927 Riverdale 22 []
1334949 April 27, 2021 - 12:42:03 UTC 36.39342 -119.86927 Riverdale 22 []
1294928 March 24, 2021 - 10:52:01 UTC 36.39372 -119.95004 Riverdale 22 []
1249976 February 07, 2021 - 14:04:47 UTC 36.39378 -119.95913 Riverdale 22 []
1294929 March 24, 2021 - 10:51:58 UTC 36.39378 -119.95913 Riverdale 22 []
1296030 March 24, 2021 - 20:32:00 UTC 36.39378 -119.95913 Riverdale 22 []
1294930 March 24, 2021 - 10:52:01 UTC 36.39391 -119.94112 Riverdale 22 []
1267977 March 04, 2021 - 21:02:14 UTC 36.39423 -119.82085 Riverdale 22 []
1182955 December 14, 2020 - 12:06:03 UTC 36.39425 -119.83984 Riverdale 22 []
1093847 September 26, 2020 - 18:26:25 UTC 36.3943 -119.83422 Riverdale 22 []
655768 October 14, 2019 - 08:43:00 UTC 36.39484 -119.83492 Riverdale 22 []
721789 November 27, 2019 - 22:41:35 UTC 36.39486 -119.82314 Riverdale 22 []
721876 November 27, 2019 - 23:34:00 UTC 36.39486 -119.82207 Riverdale 22 []
722236 November 27, 2019 - 22:41:35 UTC 36.39486 -119.82314 Riverdale 22 []
722237 November 27, 2019 - 23:34:00 UTC 36.39486 -119.82207 Riverdale 22 []
1259317 February 22, 2021 - 17:41:33 UTC 36.39486 -119.82428 Riverdale 22 [{"latitude": "36.38795", "longitude": "-119.82531"}, {"latitude": "36.39766", "longitude": "-119.8253"}, {"latitude": "36.39484", "longitude": "-119.83492"}, {"latitude": "36.39276", "longitude": "-119.83423"}]
655781 October 14, 2019 - 10:25:43 UTC 36.39493 -119.81039 Riverdale 22 [{"latitude": "36.39487", "longitude": "-119.81673"}, {"latitude": "36.39491", "longitude": "-119.81238"}, {"latitude": "36.3949", "longitude": "-119.81352"}]
1250167 February 07, 2021 - 23:27:21 UTC 36.40123 -119.95864 Riverdale 22 []
725324 December 01, 2019 - 06:40:32 UTC 36.40199 -119.85124 Riverdale 22 [{"latitude": "36.37472", "longitude": "-119.8512"}, {"latitude": "36.39425", "longitude": "-119.83984"}, {"latitude": "36.4011", "longitude": "-119.85125"}, {"latitude": "36.39848", "longitude": "-119.86917"}, {"latitude": "36.39775", "longitude": "-119.87365"}, {"latitude": "36.39476", "longitude": "-119.87837"}, {"latitude": "36.39391", "longitude": "-119.87925"}, {"latitude": "36.38377", "longitude": "-119.87803"}]
779373 February 06, 2020 - 20:05:04 UTC 36.40211 -119.79986 Riverdale 22 []
1282541 March 15, 2021 - 15:01:00 UTC 36.40211 -119.85455 Riverdale 22 []
1342282 May 06, 2021 - 15:53:00 UTC 36.40211 -119.79866 Riverdale 22 []
687057 October 27, 2019 - 14:28:18 UTC 36.40435 -119.89453 Riverdale 22 []
1337560 April 30, 2021 - 13:49:00 UTC 36.40552 -119.89799 Riverdale 22 []
1337576 April 30, 2021 - 13:49:00 UTC 36.40552 -119.89799 Riverdale 22 []
680536 October 25, 2019 - 21:22:01 UTC 36.4076 -119.80394 Riverdale 22 []
779165 February 06, 2020 - 17:30:44 UTC 36.4076 -119.80394 Riverdale 22 []
1201886 December 31, 2020 - 21:34:38 UTC 36.40836 -119.95863 Riverdale 22 []
1250166 February 07, 2021 - 23:27:21 UTC 36.40836 -119.95863 Riverdale 22 []
779257 February 06, 2020 - 18:39:27 UTC 36.40929 -119.80906 Riverdale 22 []
1096036 September 28, 2020 - 14:37:46 UTC 36.40929 -119.80906 Riverdale 22 []
1295106 March 24, 2021 - 15:40:09 UTC 36.40929 -119.81071 Riverdale 22 []
1303737 March 30, 2021 - 23:19:04 UTC 36.40929 -119.81071 Riverdale 22 []
1255328 February 15, 2021 - 22:12:06 UTC 36.41074 -119.83417 Riverdale 22 [{"latitude": "36.41273", "longitude": "-119.83416"}, {"latitude": "36.41752", "longitude": "-119.83406"}, {"latitude": "36.41988", "longitude": "-119.83406"}, {"latitude": "36.41454", "longitude": "-119.83416"}]
1114436 October 09, 2020 - 19:08:43 UTC 36.41316 -119.83416 Riverdale 22 []
1194687 December 19, 2020 - 17:58:24 UTC 36.41316 -119.83416 Riverdale 22 []
1206200 January 07, 2021 - 20:17:19 UTC 36.41316 -119.83416 Riverdale 22 []
1254956 February 15, 2021 - 05:26:03 UTC 36.41316 -119.83416 Riverdale 22 []
1255507 February 16, 2021 - 15:29:59 UTC 36.41316 -119.83416 Riverdale 22 []
1258800 February 21, 2021 - 13:19:56 UTC 36.41316 -119.83416 Riverdale 22 []
663425 October 17, 2019 - 14:35:07 UTC 36.41515 -119.99914 Riverdale 22 []
1336715 April 29, 2021 - 15:58:37 UTC 36.41555 -119.86208 Riverdale 22 []
688446 October 27, 2019 - 19:32:08 UTC 36.41586 -119.83412 Riverdale 22 []
704082 November 11, 2019 - 00:57:00 UTC 36.41654 -119.79906 Riverdale 22 []
1225593 January 26, 2021 - 16:29:33 UTC 36.41731 -119.80731 Riverdale 22 []
643711 October 04, 2019 - 21:16:16 UTC 36.41798 -119.89538 Riverdale 22 []
1081855 September 18, 2020 - 23:00:25 UTC 36.42055 -119.89266 Riverdale 22 []
1262179 February 25, 2021 - 17:26:18 UTC 36.4224 -119.99492 Riverdale 22 []
1334483 April 26, 2021 - 19:00:32 UTC 36.42291 -119.81011 Riverdale 22 []
1280724 March 13, 2021 - 16:29:58 UTC 36.42335 -119.85132 Riverdale 22 [{"latitude": "36.36015", "longitude": "-119.85194"}, {"latitude": "36.36031", "longitude": "-119.8513"}, {"latitude": "36.36259", "longitude": "-119.84525"}, {"latitude": "36.39826", "longitude": "-119.81525"}, {"latitude": "36.40324", "longitude": "-119.8118"}, {"latitude": "36.40403", "longitude": "-119.81181"}, {"latitude": "36.41244", "longitude": "-119.8164"}, {"latitude": "36.41988", "longitude": "-119.83406"}, {"latitude": "36.42876", "longitude": "-119.88712"}, {"latitude": "36.42089", "longitude": "-119.89566"}, {"latitude": "36.40552", "longitude": "-119.89799"}, {"latitude": "36.3936", "longitude": "-119.8992"}, {"latitude": "36.38742", "longitude": "-119.89624"}, {"latitude": "36.36557", "longitude": "-119.8793"}, {"latitude": "36.3621", "longitude": "-119.86921"}]
724502 November 30, 2019 - 23:28:00 UTC 36.42338 -119.85132 Riverdale 22 [{"latitude": "36.36015", "longitude": "-119.85194"}, {"latitude": "36.36031", "longitude": "-119.8513"}, {"latitude": "36.36259", "longitude": "-119.84525"}, {"latitude": "36.39826", "longitude": "-119.81525"}, {"latitude": "36.40324", "longitude": "-119.8118"}, {"latitude": "36.40403", "longitude": "-119.81181"}, {"latitude": "36.41244", "longitude": "-119.8164"}, {"latitude": "36.41988", "longitude": "-119.83406"}, {"latitude": "36.42876", "longitude": "-119.88712"}, {"latitude": "36.42089", "longitude": "-119.89566"}, {"latitude": "36.40552", "longitude": "-119.89799"}, {"latitude": "36.3936", "longitude": "-119.8992"}, {"latitude": "36.38742", "longitude": "-119.89624"}, {"latitude": "36.36557", "longitude": "-119.8793"}, {"latitude": "36.3621", "longitude": "-119.86921"}]
1137399 November 06, 2020 - 18:00:01 UTC 36.42432 -119.84717 Riverdale 22 []
1070257 September 14, 2020 - 22:23:48 UTC 36.42492 -119.8459 Riverdale 22 []
1338352 May 01, 2021 - 04:51:00 UTC 36.42561 -119.84591 Riverdale 22 []
1244849 February 01, 2021 - 18:52:00 UTC 36.42628 -119.85668 Riverdale 22 []
721772 November 27, 2019 - 22:36:20 UTC 36.42667 -119.84593 Riverdale 22 [{"latitude": "36.42492", "longitude": "-119.8459"}, {"latitude": "36.42561", "longitude": "-119.84591"}, {"latitude": "36.42625", "longitude": "-119.84592"}]
1265050 March 02, 2021 - 02:41:50 UTC 36.42677 -119.84779 Riverdale 22 []
1159713 December 03, 2020 - 02:58:58 UTC 36.42702 -119.84963 Riverdale 22 [{"latitude": "36.42412", "longitude": "-119.84479"}, {"latitude": "36.42675", "longitude": "-119.84539"}, {"latitude": "36.42718", "longitude": "-119.84614"}, {"latitude": "36.42753", "longitude": "-119.84781"}, {"latitude": "36.42702", "longitude": "-119.84877"}, {"latitude": "36.42618", "longitude": "-119.84879"}, {"latitude": "36.42545", "longitude": "-119.84878"}, {"latitude": "36.42447", "longitude": "-119.84776"}, {"latitude": "36.42432", "longitude": "-119.84717"}]
1211723 January 17, 2021 - 05:57:00 UTC 36.42743 -119.85682 Riverdale 22 []
1173594 December 09, 2020 - 18:59:02 UTC 36.42876 -119.88712 Riverdale 22 []
1112034 October 06, 2020 - 17:49:11 UTC 36.42903 -119.8543 Riverdale 22 []
634013 October 01, 2019 - 18:45:55 UTC 36.42984 -119.99478 Riverdale 22 []
1293262 March 23, 2021 - 16:04:10 UTC 36.43017 -119.94043 Riverdale 22 []
1347472 May 13, 2021 - 01:31:12 UTC 36.43026 -119.93083 Riverdale 22 []
1152913 November 23, 2020 - 04:48:35 UTC 36.43048 -119.91102 Riverdale 22 []
680919 October 26, 2019 - 21:30:26 UTC 36.43082 -119.81754 Riverdale 22 []
1065452 September 12, 2020 - 13:48:22 UTC 36.43085 -119.88944 Riverdale 22 []
1170288 December 08, 2020 - 16:05:03 UTC 36.43092 -119.82301 Riverdale 22 []
712338 November 21, 2019 - 20:37:52 UTC 36.43095 -119.83861 Riverdale 22 [{"latitude": "36.42243", "longitude": "-119.83867"}, {"latitude": "36.43133", "longitude": "-119.83863"}, {"latitude": "36.43054", "longitude": "-119.83882"}, {"latitude": "36.42806", "longitude": "-119.83878"}]
722399 November 28, 2019 - 05:01:00 UTC 36.43095 -119.83861 Riverdale 22 [{"latitude": "36.42243", "longitude": "-119.83867"}, {"latitude": "36.43054", "longitude": "-119.83882"}, {"latitude": "36.42806", "longitude": "-119.83878"}]
1137820 November 06, 2020 - 23:38:33 UTC 36.43099 -119.81369 Riverdale 22 []
1282467 March 15, 2021 - 11:47:41 UTC 36.43099 -119.84965 Riverdale 22 []
1153974 November 24, 2020 - 20:15:03 UTC 36.431 -119.80932 Riverdale 22 []
721765 November 27, 2019 - 22:32:44 UTC 36.43133 -119.83863 Riverdale 22 []
1211462 January 16, 2021 - 16:44:45 UTC 36.43133 -119.83863 Riverdale 22 []
1119678 October 17, 2020 - 03:55:06 UTC 36.43141 -119.87312 Riverdale 22 []
1194147 December 18, 2020 - 23:38:05 UTC 36.43142 -119.86189 Riverdale 22 []
1113802 October 09, 2020 - 01:39:00 UTC 36.43145 -119.85883 Riverdale 22 []
1240619 January 29, 2021 - 03:55:00 UTC 36.43148 -120.03109 Riverdale 22 [{"latitude": "36.47367", "longitude": "-120.05824"}, {"latitude": "36.47825", "longitude": "-120.01741"}, {"latitude": "36.47829", "longitude": "-120.01715"}, {"latitude": "36.47838", "longitude": "-120.01692"}, {"latitude": "36.4887", "longitude": "-119.99711"}, {"latitude": "36.49294", "longitude": "-120.00193"}, {"latitude": "36.49776", "longitude": "-120.00821"}, {"latitude": "36.49621", "longitude": "-120.0802"}, {"latitude": "36.48828", "longitude": "-120.08944"}, {"latitude": "36.48066", "longitude": "-120.07364"}]
1137359 November 06, 2020 - 17:36:38 UTC 36.43157 -119.81494 Riverdale 22 []
1146449 November 16, 2020 - 22:37:30 UTC 36.43246 -119.85839 Riverdale 22 []
1188550 December 15, 2020 - 23:31:26 UTC 36.43248 -119.8618 Riverdale 22 []
1196459 December 21, 2020 - 20:46:25 UTC 36.43248 -119.8618 Riverdale 22 []
1302263 March 29, 2021 - 15:50:00 UTC 36.43251 -119.85747 Riverdale 22 []
1148392 November 18, 2020 - 17:16:42 UTC 36.43329 -119.81219 Riverdale 22 []
1286790 March 17, 2021 - 20:52:06 UTC 36.43329 -119.81219 Riverdale 22 []
728612 December 03, 2019 - 18:14:31 UTC 36.43438 -119.86088 Riverdale 22 []

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