211 rows where regionName = 194

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
634823 October 01, 2019 - 20:43:17 UTC 36.5535 -119.4051 Dinuba 194 []
635778 October 02, 2019 - 15:17:00 UTC 36.53868 -119.38008 Dinuba 194 [{"latitude": "36.53872", "longitude": "-119.37923"}, {"latitude": "36.54101", "longitude": "-119.38009"}, {"latitude": "36.5393", "longitude": "-119.38009"}]
638799 October 03, 2019 - 00:07:44 UTC 36.55182 -119.38525 Dinuba 194 []
639736 October 03, 2019 - 18:12:11 UTC 36.54811 -119.3996 Dinuba 194 []
645713 October 07, 2019 - 00:47:24 UTC 36.53169 -119.44365 Dinuba 194 []
645923 October 07, 2019 - 16:14:19 UTC 36.53152 -119.41856 Dinuba 194 []
647133 October 08, 2019 - 15:36:09 UTC 36.54812 -119.39777 Dinuba 194 []
652645 October 10, 2019 - 14:47:54 UTC 36.55504 -119.35617 Dinuba 194 []
653364 October 10, 2019 - 20:42:18 UTC 36.53705 -119.38314 Dinuba 194 []
655831 October 14, 2019 - 14:59:42 UTC 36.54251 -119.42755 Dinuba 194 []
659908 October 15, 2019 - 23:34:10 UTC 36.54237 -119.37801 Dinuba 194 []
669818 October 18, 2019 - 19:57:00 UTC 36.54655 -119.37686 Dinuba 194 [{"latitude": "36.53875", "longitude": "-119.38108"}, {"latitude": "36.5415", "longitude": "-119.33237"}, {"latitude": "36.54473", "longitude": "-119.33368"}, {"latitude": "36.55989", "longitude": "-119.34497"}, {"latitude": "36.56797", "longitude": "-119.35229"}, {"latitude": "36.56749", "longitude": "-119.35876"}, {"latitude": "36.55275", "longitude": "-119.3864"}, {"latitude": "36.54806", "longitude": "-119.38775"}, {"latitude": "36.54567", "longitude": "-119.38775"}, {"latitude": "36.54095", "longitude": "-119.38597"}]
670405 October 18, 2019 - 21:41:00 UTC 36.54101 -119.38009 Dinuba 194 []
674828 October 20, 2019 - 18:18:40 UTC 36.55948 -119.31957 Dinuba 194 [{"latitude": "36.55679", "longitude": "-119.32775"}, {"latitude": "36.55753", "longitude": "-119.32551"}, {"latitude": "36.56077", "longitude": "-119.32079"}, {"latitude": "36.5623", "longitude": "-119.32801"}, {"latitude": "36.55958", "longitude": "-119.32992"}, {"latitude": "36.55829", "longitude": "-119.33054"}, {"latitude": "36.55684", "longitude": "-119.33064"}]
676117 October 21, 2019 - 18:10:54 UTC 36.57437 -119.35761 Dinuba 194 []
677532 October 23, 2019 - 17:22:23 UTC 36.5466 -119.41085 Dinuba 194 []
690043 October 27, 2019 - 22:46:16 UTC 36.57142 -119.40537 Dinuba 194 []
691650 October 28, 2019 - 17:51:30 UTC 36.48814 -119.41304 Dinuba 194 []
692036 October 28, 2019 - 21:31:33 UTC 36.53687 -119.38644 Dinuba 194 []
698978 November 04, 2019 - 15:14:50 UTC 36.52443 -119.45321 Dinuba 194 []
700700 November 06, 2019 - 17:22:15 UTC 36.54744 -119.38038 Dinuba 194 []
702196 November 08, 2019 - 00:53:26 UTC 36.55566 -119.39117 Dinuba 194 []
702587 November 08, 2019 - 17:04:08 UTC 36.54619 -119.38017 Dinuba 194 []
702798 November 08, 2019 - 19:37:45 UTC 36.55954 -119.39956 Dinuba 194 []
704279 November 11, 2019 - 16:46:34 UTC 36.55712 -119.40527 Dinuba 194 []
704387 November 11, 2019 - 19:17:38 UTC 36.55712 -119.40527 Dinuba 194 []
705124 November 12, 2019 - 21:00:26 UTC 36.55999 -119.35061 Dinuba 194 [{"latitude": "36.55666", "longitude": "-119.35016"}, {"latitude": "36.55989", "longitude": "-119.34497"}, {"latitude": "36.55994", "longitude": "-119.3479"}, {"latitude": "36.55887", "longitude": "-119.35015"}]
706161 November 13, 2019 - 19:52:56 UTC 36.57089 -119.32183 Dinuba 194 []
706891 November 14, 2019 - 19:48:03 UTC 36.54727 -119.3958 Dinuba 194 []
707129 November 15, 2019 - 01:27:42 UTC 36.50927 -119.37125 Dinuba 194 []
709138 November 18, 2019 - 17:24:46 UTC 36.51619 -119.3677 Dinuba 194 []
710422 November 20, 2019 - 00:30:55 UTC 36.55517 -119.39637 Dinuba 194 []
713554 November 23, 2019 - 22:03:03 UTC 36.51047 -119.40388 Dinuba 194 []
715979 November 26, 2019 - 23:03:46 UTC 36.5387 -119.37479 Dinuba 194 []
719627 November 27, 2019 - 09:13:10 UTC 36.5459 -119.41717 Dinuba 194 [{"latitude": "36.53073", "longitude": "-119.41549"}, {"latitude": "36.53149", "longitude": "-119.41449"}, {"latitude": "36.54334", "longitude": "-119.41325"}, {"latitude": "36.54553", "longitude": "-119.41717"}, {"latitude": "36.54462", "longitude": "-119.41784"}, {"latitude": "36.5324", "longitude": "-119.42264"}, {"latitude": "36.53154", "longitude": "-119.42138"}]
719764 November 27, 2019 - 11:07:41 UTC 36.51177 -119.48475 Dinuba 194 []
719766 November 27, 2019 - 11:07:41 UTC 36.5032 -119.48476 Dinuba 194 [{"latitude": "36.49133", "longitude": "-119.48481"}, {"latitude": "36.49237", "longitude": "-119.48046"}, {"latitude": "36.49921", "longitude": "-119.47832"}, {"latitude": "36.50291", "longitude": "-119.48405"}, {"latitude": "36.5029", "longitude": "-119.48653"}]
720366 November 27, 2019 - 14:30:00 UTC 36.49239 -119.4848 Dinuba 194 []
721838 November 27, 2019 - 23:16:00 UTC 36.55476 -119.3928 Dinuba 194 [{"latitude": "36.55345", "longitude": "-119.39287"}, {"latitude": "36.554", "longitude": "-119.39287"}, {"latitude": "36.55457", "longitude": "-119.39288"}]
721839 November 27, 2019 - 23:16:00 UTC 36.55345 -119.39099 Dinuba 194 []
721842 November 27, 2019 - 23:17:51 UTC 36.55483 -119.39099 Dinuba 194 []
721843 November 27, 2019 - 23:17:51 UTC 36.55487 -119.39215 Dinuba 194 [{"latitude": "36.55545", "longitude": "-119.39245"}, {"latitude": "36.55546", "longitude": "-119.39157"}, {"latitude": "36.55614", "longitude": "-119.39157"}, {"latitude": "36.55596", "longitude": "-119.39244"}]
721844 November 27, 2019 - 23:18:00 UTC 36.55241 -119.39488 Dinuba 194 []
721857 November 27, 2019 - 23:26:00 UTC 36.55332 -119.3949 Dinuba 194 []
723735 November 29, 2019 - 23:16:15 UTC 36.54909 -119.40059 Dinuba 194 []
723944 November 30, 2019 - 07:07:00 UTC 36.54939 -119.40059 Dinuba 194 [{"latitude": "36.54882", "longitude": "-119.40102"}, {"latitude": "36.54909", "longitude": "-119.40059"}, {"latitude": "36.54882", "longitude": "-119.40164"}]
727210 December 02, 2019 - 16:50:52 UTC 36.54041 -119.38089 Dinuba 194 []
728427 December 03, 2019 - 16:30:17 UTC 36.54952 -119.39574 Dinuba 194 []
730032 December 05, 2019 - 00:58:35 UTC 36.51007 -119.44416 Dinuba 194 []
731119 December 06, 2019 - 15:37:34 UTC 36.54822 -119.34145 Dinuba 194 []
731568 December 06, 2019 - 20:58:50 UTC 36.57487 -119.32302 Dinuba 194 []
734227 December 09, 2019 - 16:45:25 UTC 36.57595 -119.30599 Dinuba 194 []
734603 December 09, 2019 - 20:01:55 UTC 36.57789 -119.31922 Dinuba 194 []
735930 December 11, 2019 - 01:27:36 UTC 36.54101 -119.38009 Dinuba 194 []
742935 December 16, 2019 - 19:06:38 UTC 36.48715 -119.35663 Dinuba 194 []
743694 December 16, 2019 - 22:41:59 UTC 36.5393 -119.38088 Dinuba 194 []
743788 December 16, 2019 - 23:54:54 UTC 36.53152 -119.41856 Dinuba 194 []
778857 February 06, 2020 - 03:43:08 UTC 36.57224 -119.32141 Dinuba 194 []
779138 February 06, 2020 - 17:15:40 UTC 36.55923 -119.40577 Dinuba 194 []
779562 February 06, 2020 - 23:40:27 UTC 36.57809 -119.30795 Dinuba 194 []
780325 February 08, 2020 - 01:00:29 UTC 36.47149 -119.40918 Dinuba 194 []
788719 February 11, 2020 - 19:47:56 UTC 36.46705 -119.36712 Dinuba 194 []
788749 February 11, 2020 - 20:17:58 UTC 36.47292 -119.41183 Dinuba 194 []
790702 February 14, 2020 - 04:15:00 UTC 36.50944 -119.38564 Dinuba 194 []
790739 February 14, 2020 - 08:33:55 UTC 36.50935 -119.37671 Dinuba 194 [{"latitude": "36.50548", "longitude": "-119.38115"}, {"latitude": "36.50937", "longitude": "-119.37885"}, {"latitude": "36.51366", "longitude": "-119.38352"}, {"latitude": "36.51366", "longitude": "-119.38443"}, {"latitude": "36.51285", "longitude": "-119.38557"}, {"latitude": "36.50935", "longitude": "-119.38687"}]
1062029 September 09, 2020 - 17:52:00 UTC 36.53561 -119.39258 Dinuba 194 []
1067524 September 14, 2020 - 11:26:00 UTC 36.54505 -119.39031 Dinuba 194 []
1069614 September 14, 2020 - 19:53:20 UTC 36.56023 -119.42202 Dinuba 194 []
1069933 September 14, 2020 - 21:00:47 UTC 36.54668 -119.38419 Dinuba 194 []
1072034 September 15, 2020 - 18:30:23 UTC 36.50391 -119.43949 Dinuba 194 []
1074178 September 16, 2020 - 15:15:54 UTC 36.54901 -119.38583 Dinuba 194 []
1083080 September 20, 2020 - 00:19:00 UTC 36.55116 -119.39099 Dinuba 194 []
1084036 September 21, 2020 - 15:32:58 UTC 36.54811 -119.3996 Dinuba 194 []
1084658 September 21, 2020 - 17:53:33 UTC 36.50174 -119.38489 Dinuba 194 []
1087795 September 22, 2020 - 19:10:57 UTC 36.54527 -119.32838 Dinuba 194 []
1088168 September 22, 2020 - 20:55:00 UTC 36.53145 -119.40762 Dinuba 194 [{"latitude": "36.53142", "longitude": "-119.40399"}, {"latitude": "36.53245", "longitude": "-119.40396"}, {"latitude": "36.53144", "longitude": "-119.40579"}]
1089076 September 23, 2020 - 16:14:53 UTC 36.48736 -119.37114 Dinuba 194 []
1090624 September 23, 2020 - 22:21:37 UTC 36.53161 -119.43071 Dinuba 194 [{"latitude": "36.53162", "longitude": "-119.43185"}, {"latitude": "36.53166", "longitude": "-119.43809"}, {"latitude": "36.53164", "longitude": "-119.43585"}, {"latitude": "36.53163", "longitude": "-119.43439"}, {"latitude": "36.53162", "longitude": "-119.43239"}]
1090703 September 24, 2020 - 00:49:59 UTC 36.53561 -119.39258 Dinuba 194 []
1090719 September 24, 2020 - 02:16:36 UTC 36.53161 -119.43053 Dinuba 194 []
1091033 September 24, 2020 - 16:50:49 UTC 36.48461 -119.34459 Dinuba 194 []
1091813 September 25, 2020 - 00:40:17 UTC 36.5393 -119.38009 Dinuba 194 []
1107177 October 02, 2020 - 18:45:59 UTC 36.51535 -119.42174 Dinuba 194 [{"latitude": "36.46187", "longitude": "-119.4391"}, {"latitude": "36.46986", "longitude": "-119.39882"}, {"latitude": "36.47129", "longitude": "-119.39392"}, {"latitude": "36.47828", "longitude": "-119.39107"}, {"latitude": "36.50565", "longitude": "-119.38831"}, {"latitude": "36.51308", "longitude": "-119.39059"}, {"latitude": "36.5138", "longitude": "-119.39571"}, {"latitude": "36.51464", "longitude": "-119.42174"}, {"latitude": "36.49395", "longitude": "-119.45303"}, {"latitude": "36.49204", "longitude": "-119.45413"}, {"latitude": "36.48792", "longitude": "-119.45417"}, {"latitude": "36.46191", "longitude": "-119.44298"}]
1109785 October 03, 2020 - 21:52:19 UTC 36.516 -119.38812 Dinuba 194 []
1111010 October 05, 2020 - 02:36:21 UTC 36.55793 -119.37877 Dinuba 194 []
1112967 October 07, 2020 - 20:49:14 UTC 36.5206 -119.426 Dinuba 194 []
1113064 October 07, 2020 - 23:17:56 UTC 36.54505 -119.39031 Dinuba 194 []
1113645 October 08, 2020 - 21:06:24 UTC 36.58833 -119.36635 Dinuba 194 []
1113647 October 08, 2020 - 21:06:23 UTC 36.58869 -119.37228 Dinuba 194 []
1113663 October 08, 2020 - 21:06:23 UTC 36.58909 -119.37452 Dinuba 194 [{"latitude": "36.58763", "longitude": "-119.36634"}, {"latitude": "36.58895", "longitude": "-119.3605"}, {"latitude": "36.5918", "longitude": "-119.36567"}, {"latitude": "36.58991", "longitude": "-119.37335"}, {"latitude": "36.58869", "longitude": "-119.37228"}]
1114648 October 10, 2020 - 01:45:24 UTC 36.51047 -119.40388 Dinuba 194 []
1114676 October 10, 2020 - 03:18:31 UTC 36.45843 -119.39666 Dinuba 194 []
1115784 October 12, 2020 - 16:50:56 UTC 36.49364 -119.46955 Dinuba 194 []
1116439 October 13, 2020 - 16:47:35 UTC 36.50166 -119.38575 Dinuba 194 []
1116620 October 13, 2020 - 19:47:05 UTC 36.50174 -119.38489 Dinuba 194 []
1117366 October 14, 2020 - 20:14:32 UTC 36.55303 -119.38448 Dinuba 194 []
1118191 October 15, 2020 - 04:25:15 UTC 36.55281 -119.35359 Dinuba 194 []
1118195 October 15, 2020 - 04:29:00 UTC 36.55397 -119.34603 Dinuba 194 []
1119652 October 17, 2020 - 02:06:44 UTC 36.55636 -119.36901 Dinuba 194 []
1121820 October 20, 2020 - 22:35:00 UTC 36.50162 -119.34962 Dinuba 194 []

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