100 rows where regionName = 10

View and edit SQL

outageDevices

id ▼ outageStartTime latitude longitude regionName outageDevices
633488 October 01, 2019 - 06:13:00 UTC 35.99202 -119.57146 Kettleman City 10 [{"latitude": "36.0699", "longitude": "-119.54522"}, {"latitude": "36.07279", "longitude": "-119.53918"}, {"latitude": "36.07571", "longitude": "-119.5413"}, {"latitude": "36.07594", "longitude": "-119.55424"}, {"latitude": "36.07269", "longitude": "-119.56981"}, {"latitude": "36.07082", "longitude": "-119.55826"}]
639015 October 03, 2019 - 15:04:24 UTC 36.01448 -119.96702 Kettleman City 10 []
650970 October 09, 2019 - 19:18:52 UTC 35.87642 -119.7682 Kettleman City 10 []
676815 October 22, 2019 - 17:09:39 UTC 36.02678 -119.61755 Kettleman City 10 []
677122 October 22, 2019 - 21:54:00 UTC 35.87577 -119.57308 Kettleman City 10 [{"latitude": "35.80535", "longitude": "-119.65526"}, {"latitude": "35.83568", "longitude": "-119.57354"}, {"latitude": "35.84206", "longitude": "-119.55895"}, {"latitude": "35.86285", "longitude": "-119.5739"}, {"latitude": "35.86295", "longitude": "-119.57435"}, {"latitude": "35.87616", "longitude": "-119.64388"}, {"latitude": "35.877", "longitude": "-119.64852"}, {"latitude": "35.84611", "longitude": "-119.65772"}, {"latitude": "35.82462", "longitude": "-119.65869"}]
700086 November 05, 2019 - 19:46:06 UTC 35.87642 -119.7682 Kettleman City 10 []
722059 November 28, 2019 - 01:16:06 UTC 36.01032 -119.96228 Kettleman City 10 []
729620 December 04, 2019 - 17:53:00 UTC 35.98837 -119.9407 Kettleman City 10 [{"latitude": "35.80355", "longitude": "-119.87779"}, {"latitude": "35.87642", "longitude": "-119.7682"}, {"latitude": "35.94005", "longitude": "-119.82684"}, {"latitude": "35.97855", "longitude": "-119.92596"}, {"latitude": "35.96535", "longitude": "-119.93568"}, {"latitude": "35.94897", "longitude": "-119.93314"}, {"latitude": "35.89815", "longitude": "-119.91601"}, {"latitude": "35.81794", "longitude": "-119.88656"}, {"latitude": "35.80608", "longitude": "-119.87988"}]
736659 December 11, 2019 - 22:38:18 UTC 36.03793 -120.03291 Kettleman City 10 []
737091 December 12, 2019 - 14:22:53 UTC 36.0036 -119.94969 Kettleman City 10 [{"latitude": "36.00333", "longitude": "-119.94099"}, {"latitude": "36.04934", "longitude": "-119.82548"}, {"latitude": "36.04953", "longitude": "-119.82523"}, {"latitude": "36.05064", "longitude": "-119.82406"}, {"latitude": "36.07939", "longitude": "-119.80152"}, {"latitude": "36.09418", "longitude": "-119.82474"}, {"latitude": "36.10416", "longitude": "-119.93206"}, {"latitude": "36.1012", "longitude": "-120.00299"}, {"latitude": "36.0942", "longitude": "-120.01225"}, {"latitude": "36.04339", "longitude": "-120.0218"}, {"latitude": "36.03594", "longitude": "-120.0145"}, {"latitude": "36.01542", "longitude": "-119.99321"}, {"latitude": "36.00898", "longitude": "-119.98533"}]
737107 December 12, 2019 - 15:08:00 UTC 35.93489 -119.92118 Kettleman City 10 [{"latitude": "35.88693", "longitude": "-119.863"}, {"latitude": "35.88837", "longitude": "-119.82605"}, {"latitude": "35.90509", "longitude": "-119.82588"}, {"latitude": "35.91239", "longitude": "-119.82587"}, {"latitude": "35.94005", "longitude": "-119.82684"}, {"latitude": "35.94587", "longitude": "-119.84323"}, {"latitude": "35.94904", "longitude": "-119.86011"}, {"latitude": "35.94194", "longitude": "-119.90718"}, {"latitude": "35.93496", "longitude": "-119.91454"}]
743795 December 17, 2019 - 00:02:39 UTC 36.10873 -119.9669 Kettleman City 10 []
780713 February 09, 2020 - 01:04:52 UTC 36.00871 -119.96365 Kettleman City 10 []
788911 February 11, 2020 - 22:29:56 UTC 36.0942 -119.99928 Kettleman City 10 []
789218 February 12, 2020 - 11:54:00 UTC 35.99004 -119.96045 Kettleman City 10 []
790156 February 13, 2020 - 16:42:40 UTC 36.0942 -119.99928 Kettleman City 10 []
1061325 September 08, 2020 - 22:18:54 UTC 36.00871 -119.96365 Kettleman City 10 []
1062768 September 10, 2020 - 15:56:00 UTC 35.99202 -119.5714 Kettleman City 10 [{"latitude": "35.80535", "longitude": "-119.65526"}, {"latitude": "35.83568", "longitude": "-119.57354"}, {"latitude": "35.84206", "longitude": "-119.55895"}, {"latitude": "35.93952", "longitude": "-119.54574"}, {"latitude": "35.94387", "longitude": "-119.55089"}, {"latitude": "35.96005", "longitude": "-119.57303"}, {"latitude": "35.9484", "longitude": "-119.75148"}, {"latitude": "35.9479", "longitude": "-119.75206"}]
1062913 September 10, 2020 - 17:16:16 UTC 36.05447 -120.03948 Kettleman City 10 []
1064156 September 11, 2020 - 15:35:00 UTC 36.05447 -120.03948 Kettleman City 10 []
1083141 September 20, 2020 - 03:06:04 UTC 36.00664 -119.94426 Kettleman City 10 []
1088726 September 23, 2020 - 07:04:46 UTC 35.98581 -119.9585 Kettleman City 10 []
1100841 September 30, 2020 - 12:11:34 UTC 36.00502 -119.95873 Kettleman City 10 []
1112298 October 06, 2020 - 22:12:05 UTC 36.04953 -119.82523 Kettleman City 10 []
1116134 October 12, 2020 - 23:43:20 UTC 36.05779 -120.0128 Kettleman City 10 []
1116233 October 12, 2020 - 23:43:00 UTC 36.05415 -120.0051 Kettleman City 10 [{"latitude": "36.05118", "longitude": "-120.01241"}, {"latitude": "36.05419", "longitude": "-120.01087"}, {"latitude": "36.05779", "longitude": "-120.0128"}]
1116568 October 13, 2020 - 18:53:12 UTC 35.85156 -119.6463 Kettleman City 10 []
1118530 October 15, 2020 - 18:18:14 UTC 35.85156 -119.6463 Kettleman City 10 []
1119329 October 16, 2020 - 18:35:17 UTC 36.10858 -120.01208 Kettleman City 10 []
1119985 October 17, 2020 - 22:18:00 UTC 36.00866 -119.96063 Kettleman City 10 []
1122190 October 21, 2020 - 16:38:37 UTC 35.94072 -119.57024 Kettleman City 10 []
1123567 October 22, 2020 - 20:15:45 UTC 36.00696 -119.75088 Kettleman City 10 []
1123579 October 22, 2020 - 20:26:06 UTC 35.9479 -119.75206 Kettleman City 10 []
1124214 October 23, 2020 - 21:04:25 UTC 35.9479 -119.75206 Kettleman City 10 []
1129874 October 27, 2020 - 17:34:58 UTC 36.04953 -119.82523 Kettleman City 10 []
1133246 November 01, 2020 - 07:14:51 UTC 35.98646 -119.95913 Kettleman City 10 []
1133716 November 02, 2020 - 16:35:35 UTC 36.1013 -119.94959 Kettleman City 10 []
1135053 November 03, 2020 - 17:23:20 UTC 35.86122 -119.57345 Kettleman City 10 []
1135145 November 03, 2020 - 17:23:00 UTC 36.02394 -119.6437 Kettleman City 10 [{"latitude": "36.0409", "longitude": "-119.64475"}, {"latitude": "36.04098", "longitude": "-119.64236"}, {"latitude": "36.04253", "longitude": "-119.64163"}, {"latitude": "36.04216", "longitude": "-119.64488"}, {"latitude": "36.04109", "longitude": "-119.6464"}]
1139032 November 08, 2020 - 08:28:21 UTC 35.90517 -119.88866 Kettleman City 10 []
1139033 November 08, 2020 - 08:28:21 UTC 35.90524 -119.90601 Kettleman City 10 []
1140629 November 10, 2020 - 00:37:24 UTC 36.0506 -120.03061 Kettleman City 10 []
1141088 November 10, 2020 - 18:08:00 UTC 36.0378 -119.95907 Kettleman City 10 []
1142869 November 12, 2020 - 21:23:09 UTC 35.79008 -119.80679 Kettleman City 10 []
1149740 November 20, 2020 - 00:36:14 UTC 36.04862 -119.69462 Kettleman City 10 []
1149755 November 20, 2020 - 00:56:37 UTC 36.02105 -119.74819 Kettleman City 10 [{"latitude": "36.00696", "longitude": "-119.75088"}, {"latitude": "36.05216", "longitude": "-119.75058"}, {"latitude": "36.0478", "longitude": "-119.75061"}]
1149996 November 20, 2020 - 16:52:58 UTC 36.10858 -120.01208 Kettleman City 10 []
1155324 November 28, 2020 - 01:09:13 UTC 36.00926 -119.96437 Kettleman City 10 []
1156600 November 30, 2020 - 23:12:22 UTC 36.00696 -119.75088 Kettleman City 10 []
1169752 December 08, 2020 - 00:05:53 UTC 36.04346 -120.01211 Kettleman City 10 []
1173847 December 09, 2020 - 20:14:53 UTC 36.02185 -119.96757 Kettleman City 10 []
1180583 December 12, 2020 - 09:54:28 UTC 36.00664 -119.94426 Kettleman City 10 []
1185350 December 14, 2020 - 22:27:38 UTC 36.1012 -120.00299 Kettleman City 10 []
1185615 December 14, 2020 - 23:43:15 UTC 36.02185 -119.96757 Kettleman City 10 []
1196465 December 21, 2020 - 20:56:04 UTC 35.94004 -119.82637 Kettleman City 10 []
1204416 January 05, 2021 - 16:56:00 UTC 35.94172 -119.57013 Kettleman City 10 []
1206576 January 08, 2021 - 16:07:46 UTC 35.99223 -119.53619 Kettleman City 10 [{"latitude": "35.94868", "longitude": "-119.53665"}, {"latitude": "35.94903", "longitude": "-119.53661"}, {"latitude": "35.95628", "longitude": "-119.53621"}, {"latitude": "35.96373", "longitude": "-119.53613"}, {"latitude": "35.97779", "longitude": "-119.53615"}, {"latitude": "35.97852", "longitude": "-119.53616"}]
1207475 January 10, 2021 - 12:57:02 UTC 36.10082 -120.00297 Kettleman City 10 []
1210573 January 14, 2021 - 23:53:30 UTC 36.13342 -120.01259 Kettleman City 10 []
1215810 January 19, 2021 - 16:36:23 UTC 36.0478 -119.75061 Kettleman City 10 []
1234859 January 27, 2021 - 18:31:00 UTC 35.98837 -119.9407 Kettleman City 10 [{"latitude": "35.80355", "longitude": "-119.87779"}, {"latitude": "35.87642", "longitude": "-119.7682"}, {"latitude": "35.94005", "longitude": "-119.82684"}, {"latitude": "35.97855", "longitude": "-119.92596"}, {"latitude": "35.96535", "longitude": "-119.93568"}, {"latitude": "35.94897", "longitude": "-119.93314"}, {"latitude": "35.89815", "longitude": "-119.91601"}, {"latitude": "35.81794", "longitude": "-119.88656"}, {"latitude": "35.80608", "longitude": "-119.87988"}]
1241767 January 29, 2021 - 20:16:44 UTC 36.00864 -119.96636 Kettleman City 10 []
1243623 January 31, 2021 - 07:06:28 UTC 35.98583 -119.96042 Kettleman City 10 []
1243656 January 31, 2021 - 07:06:00 UTC 35.98583 -119.96042 Kettleman City 10 []
1245285 February 01, 2021 - 23:36:55 UTC 35.98965 -119.95873 Kettleman City 10 []
1246891 February 03, 2021 - 17:50:34 UTC 36.12306 -119.96798 Kettleman City 10 []
1251007 February 09, 2021 - 01:23:13 UTC 36.00917 -119.96636 Kettleman City 10 []
1261846 February 25, 2021 - 13:38:26 UTC 35.935 -119.87895 Kettleman City 10 []
1262208 February 25, 2021 - 17:42:43 UTC 35.935 -119.87895 Kettleman City 10 []
1266760 March 04, 2021 - 06:00:00 UTC 36.16396 -119.97822 Kettleman City 10 []
1276692 March 10, 2021 - 11:46:38 UTC 35.84717 -119.88764 Kettleman City 10 []
1276693 March 10, 2021 - 11:46:42 UTC 35.80608 -119.87988 Kettleman City 10 []
1276694 March 10, 2021 - 11:46:44 UTC 35.85167 -119.89048 Kettleman City 10 []
1277528 March 10, 2021 - 22:24:30 UTC 35.93952 -119.54574 Kettleman City 10 []
1278164 March 11, 2021 - 03:56:25 UTC 35.85167 -119.89048 Kettleman City 10 []
1280344 March 12, 2021 - 20:44:42 UTC 35.8622 -119.64628 Kettleman City 10 []
1287409 March 18, 2021 - 00:34:58 UTC 36.04261 -119.62372 Kettleman City 10 []
1289808 March 20, 2021 - 16:53:55 UTC 36.13789 -120.01263 Kettleman City 10 []
1301955 March 28, 2021 - 19:19:24 UTC 35.94587 -119.84323 Kettleman City 10 []
1302032 March 29, 2021 - 00:38:00 UTC 35.93419 -119.87936 Kettleman City 10 [{"latitude": "35.88693", "longitude": "-119.863"}, {"latitude": "35.93051", "longitude": "-119.8794"}, {"latitude": "35.91609", "longitude": "-119.87975"}, {"latitude": "35.90688", "longitude": "-119.87952"}, {"latitude": "35.9028", "longitude": "-119.87922"}]
1303312 March 30, 2021 - 16:01:00 UTC 36.02183 -119.95947 Kettleman City 10 [{"latitude": "36.00898", "longitude": "-119.98533"}, {"latitude": "36.01381", "longitude": "-119.96754"}, {"latitude": "36.01448", "longitude": "-119.96702"}, {"latitude": "36.02185", "longitude": "-119.96757"}, {"latitude": "36.02181", "longitude": "-119.98478"}, {"latitude": "36.01807", "longitude": "-119.99439"}, {"latitude": "36.01542", "longitude": "-119.99321"}]
1303503 March 30, 2021 - 19:13:18 UTC 35.84717 -119.88764 Kettleman City 10 []
1304983 April 01, 2021 - 16:44:13 UTC 35.89756 -119.87382 Kettleman City 10 []
1305569 April 02, 2021 - 15:20:41 UTC 36.09423 -120.0302 Kettleman City 10 []
1307005 April 05, 2021 - 16:23:00 UTC 35.98837 -119.9407 Kettleman City 10 [{"latitude": "35.80355", "longitude": "-119.87779"}, {"latitude": "35.87642", "longitude": "-119.7682"}, {"latitude": "35.94005", "longitude": "-119.82684"}, {"latitude": "35.97855", "longitude": "-119.92596"}, {"latitude": "35.96535", "longitude": "-119.93568"}, {"latitude": "35.94897", "longitude": "-119.93314"}, {"latitude": "35.89815", "longitude": "-119.91601"}, {"latitude": "35.81794", "longitude": "-119.88656"}, {"latitude": "35.80608", "longitude": "-119.87988"}]
1307062 April 05, 2021 - 17:03:58 UTC 36.10416 -119.93206 Kettleman City 10 []
1307460 April 06, 2021 - 09:06:00 UTC 35.93489 -119.92118 Kettleman City 10 [{"latitude": "35.88693", "longitude": "-119.863"}, {"latitude": "35.88837", "longitude": "-119.82605"}, {"latitude": "35.90509", "longitude": "-119.82588"}, {"latitude": "35.91239", "longitude": "-119.82587"}, {"latitude": "35.94005", "longitude": "-119.82684"}, {"latitude": "35.94587", "longitude": "-119.84323"}, {"latitude": "35.94904", "longitude": "-119.86011"}, {"latitude": "35.94194", "longitude": "-119.90718"}, {"latitude": "35.93496", "longitude": "-119.91454"}]
1307461 April 06, 2021 - 09:07:00 UTC 35.92676 -119.92072 Kettleman City 10 []
1314032 April 13, 2021 - 13:46:57 UTC 36.05415 -120.0051 Kettleman City 10 [{"latitude": "36.05118", "longitude": "-120.01241"}, {"latitude": "36.05419", "longitude": "-120.01087"}, {"latitude": "36.05779", "longitude": "-120.0128"}]
1326101 April 21, 2021 - 08:36:00 UTC 36.00383 -119.94981 Kettleman City 10 [{"latitude": "35.9777", "longitude": "-119.94847"}, {"latitude": "35.99263", "longitude": "-119.94798"}, {"latitude": "35.9957", "longitude": "-119.94901"}, {"latitude": "36.00437", "longitude": "-119.9522"}, {"latitude": "36.01058", "longitude": "-119.95804"}, {"latitude": "36.0112", "longitude": "-119.96062"}, {"latitude": "36.0144", "longitude": "-119.97662"}, {"latitude": "35.99522", "longitude": "-119.96951"}, {"latitude": "35.99307", "longitude": "-119.96837"}, {"latitude": "35.98728", "longitude": "-119.96479"}]
1329326 April 23, 2021 - 08:43:02 UTC 36.02105 -119.74819 Kettleman City 10 [{"latitude": "36.00696", "longitude": "-119.75088"}, {"latitude": "36.05216", "longitude": "-119.75058"}, {"latitude": "36.0478", "longitude": "-119.75061"}]
1333445 April 25, 2021 - 15:10:00 UTC 36.06567 -120.03004 Kettleman City 10 [{"latitude": "36.07239", "longitude": "-120.03927"}, {"latitude": "36.07242", "longitude": "-120.02579"}, {"latitude": "36.07975", "longitude": "-120.02159"}]
1334666 April 26, 2021 - 20:57:45 UTC 36.04382 -120.03954 Kettleman City 10 []
1335142 April 27, 2021 - 16:16:15 UTC 36.06553 -120.04827 Kettleman City 10 [{"latitude": "36.06841", "longitude": "-120.04829"}, {"latitude": "36.07333", "longitude": "-120.04635"}, {"latitude": "36.07444", "longitude": "-120.04691"}, {"latitude": "36.07177", "longitude": "-120.0481"}]
1337238 April 29, 2021 - 22:33:40 UTC 35.79008 -119.80679 Kettleman City 10 []
1337360 April 30, 2021 - 02:01:23 UTC 35.80608 -119.87988 Kettleman City 10 []
1340174 May 03, 2021 - 23:34:05 UTC 36.0098 -119.96527 Kettleman City 10 []
1340369 May 04, 2021 - 14:42:49 UTC 36.07177 -120.0481 Kettleman City 10 []
1340652 May 04, 2021 - 17:44:00 UTC 36.07308 -120.04826 Kettleman City 10 []
1347240 May 12, 2021 - 20:47:25 UTC 36.02879 -120.01697 Kettleman City 10 []

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