62 rows where regionName = 202

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
634849 October 01, 2019 - 21:30:30 UTC 40.01626 -122.40273 Rancho Tehama Reserve 202 []
647538 October 08, 2019 - 20:56:23 UTC 40.01706 -122.40928 Rancho Tehama Reserve 202 []
647904 October 09, 2019 - 07:13:00 UTC 39.99671 -122.4058 Rancho Tehama Reserve 202 [{"latitude": "39.995", "longitude": "-122.4122"}, {"latitude": "39.99679", "longitude": "-122.4062"}, {"latitude": "40.01857", "longitude": "-122.35836"}, {"latitude": "40.02112", "longitude": "-122.35314"}, {"latitude": "40.02277", "longitude": "-122.36897"}, {"latitude": "40.02268", "longitude": "-122.44615"}, {"latitude": "40.02187", "longitude": "-122.45918"}, {"latitude": "40.02107", "longitude": "-122.45972"}, {"latitude": "40.02039", "longitude": "-122.45989"}, {"latitude": "40.00715", "longitude": "-122.46276"}, {"latitude": "39.99826", "longitude": "-122.45977"}, {"latitude": "39.99559", "longitude": "-122.43575"}]
647920 October 09, 2019 - 07:13:00 UTC 40.01494 -122.39762 Rancho Tehama Reserve 202 [{"latitude": "40.00966", "longitude": "-122.39"}, {"latitude": "40.01857", "longitude": "-122.35836"}, {"latitude": "40.02112", "longitude": "-122.35314"}, {"latitude": "40.02277", "longitude": "-122.36897"}, {"latitude": "40.01976", "longitude": "-122.39202"}, {"latitude": "40.01936", "longitude": "-122.39275"}, {"latitude": "40.01863", "longitude": "-122.39407"}, {"latitude": "40.01488", "longitude": "-122.39731"}]
653400 October 09, 2019 - 07:13:00 UTC 40.01566 -122.40047 Rancho Tehama Reserve 202 [{"latitude": "39.99559", "longitude": "-122.43575"}, {"latitude": "40.00118", "longitude": "-122.41885"}, {"latitude": "40.01812", "longitude": "-122.39856"}, {"latitude": "40.02022", "longitude": "-122.39949"}, {"latitude": "40.02156", "longitude": "-122.4001"}, {"latitude": "40.02182", "longitude": "-122.40058"}, {"latitude": "40.02204", "longitude": "-122.40166"}, {"latitude": "40.02268", "longitude": "-122.44615"}, {"latitude": "40.02187", "longitude": "-122.45918"}, {"latitude": "40.02107", "longitude": "-122.45972"}, {"latitude": "40.02039", "longitude": "-122.45989"}, {"latitude": "40.00715", "longitude": "-122.46276"}, {"latitude": "39.99826", "longitude": "-122.45977"}]
654970 October 12, 2019 - 05:03:12 UTC 40.0189 -122.42602 Rancho Tehama Reserve 202 []
665774 October 17, 2019 - 19:40:26 UTC 40.01902 -122.44867 Rancho Tehama Reserve 202 []
667153 October 18, 2019 - 00:01:44 UTC 40.01101 -122.39806 Rancho Tehama Reserve 202 []
680429 October 25, 2019 - 18:42:34 UTC 40.01754 -122.45064 Rancho Tehama Reserve 202 []
681042 October 27, 2019 - 00:11:00 UTC 40.00296 -122.42475 Rancho Tehama Reserve 202 []
681060 October 27, 2019 - 00:14:00 UTC 40.01473 -122.40072 Rancho Tehama Reserve 202 []
681184 October 27, 2019 - 00:01:00 UTC 39.99671 -122.4058 Rancho Tehama Reserve 202 [{"latitude": "39.995", "longitude": "-122.4122"}, {"latitude": "39.99679", "longitude": "-122.4062"}, {"latitude": "40.01857", "longitude": "-122.35836"}, {"latitude": "40.02112", "longitude": "-122.35314"}, {"latitude": "40.02277", "longitude": "-122.36897"}, {"latitude": "40.02268", "longitude": "-122.44615"}, {"latitude": "40.02187", "longitude": "-122.45918"}, {"latitude": "40.02107", "longitude": "-122.45972"}, {"latitude": "40.02039", "longitude": "-122.45989"}, {"latitude": "40.00715", "longitude": "-122.46276"}, {"latitude": "39.99826", "longitude": "-122.45977"}, {"latitude": "39.99559", "longitude": "-122.43575"}]
681213 October 27, 2019 - 00:01:00 UTC 40.01494 -122.39762 Rancho Tehama Reserve 202 [{"latitude": "40.00966", "longitude": "-122.39"}, {"latitude": "40.01857", "longitude": "-122.35836"}, {"latitude": "40.02112", "longitude": "-122.35314"}, {"latitude": "40.02277", "longitude": "-122.36897"}, {"latitude": "40.01976", "longitude": "-122.39202"}, {"latitude": "40.01936", "longitude": "-122.39275"}, {"latitude": "40.01863", "longitude": "-122.39407"}, {"latitude": "40.01488", "longitude": "-122.39731"}]
693471 October 29, 2019 - 16:38:00 UTC 40.01244 -122.41328 Rancho Tehama Reserve 202 []
693473 October 29, 2019 - 16:39:35 UTC 40.01985 -122.44805 Rancho Tehama Reserve 202 []
693477 October 29, 2019 - 16:40:00 UTC 40.00621 -122.40425 Rancho Tehama Reserve 202 [{"latitude": "40.00078", "longitude": "-122.39903"}, {"latitude": "40.00108", "longitude": "-122.39838"}, {"latitude": "40.00354", "longitude": "-122.39481"}, {"latitude": "40.00746", "longitude": "-122.40615"}, {"latitude": "40.00634", "longitude": "-122.40709"}, {"latitude": "40.00446", "longitude": "-122.40622"}, {"latitude": "40.0028", "longitude": "-122.4054"}, {"latitude": "40.00158", "longitude": "-122.40311"}]
693487 October 29, 2019 - 16:38:46 UTC 40.01564 -122.4333 Rancho Tehama Reserve 202 [{"latitude": "39.99559", "longitude": "-122.43575"}, {"latitude": "40.00118", "longitude": "-122.41885"}, {"latitude": "40.00599", "longitude": "-122.41919"}, {"latitude": "40.01562", "longitude": "-122.43326"}, {"latitude": "40.00964", "longitude": "-122.44567"}, {"latitude": "39.99893", "longitude": "-122.45938"}, {"latitude": "39.99826", "longitude": "-122.45977"}]
693512 October 29, 2019 - 16:32:00 UTC 39.99671 -122.4058 Rancho Tehama Reserve 202 [{"latitude": "39.995", "longitude": "-122.4122"}, {"latitude": "39.99679", "longitude": "-122.4062"}, {"latitude": "40.01857", "longitude": "-122.35836"}, {"latitude": "40.02112", "longitude": "-122.35314"}, {"latitude": "40.02277", "longitude": "-122.36897"}, {"latitude": "40.02268", "longitude": "-122.44615"}, {"latitude": "40.02187", "longitude": "-122.45918"}, {"latitude": "40.02107", "longitude": "-122.45972"}, {"latitude": "40.02039", "longitude": "-122.45989"}, {"latitude": "40.00715", "longitude": "-122.46276"}, {"latitude": "39.99826", "longitude": "-122.45977"}, {"latitude": "39.99559", "longitude": "-122.43575"}]
693517 October 29, 2019 - 16:32:00 UTC 40.01494 -122.39762 Rancho Tehama Reserve 202 [{"latitude": "40.00966", "longitude": "-122.39"}, {"latitude": "40.01857", "longitude": "-122.35836"}, {"latitude": "40.02112", "longitude": "-122.35314"}, {"latitude": "40.02277", "longitude": "-122.36897"}, {"latitude": "40.01976", "longitude": "-122.39202"}, {"latitude": "40.01936", "longitude": "-122.39275"}, {"latitude": "40.01863", "longitude": "-122.39407"}, {"latitude": "40.01488", "longitude": "-122.39731"}]
696573 October 31, 2019 - 17:15:31 UTC 40.01041 -122.40979 Rancho Tehama Reserve 202 []
703050 November 09, 2019 - 01:00:58 UTC 40.01308 -122.44217 Rancho Tehama Reserve 202 []
704205 November 11, 2019 - 14:17:45 UTC 40.01976 -122.39202 Rancho Tehama Reserve 202 []
705043 November 12, 2019 - 19:22:51 UTC 40.00736 -122.40998 Rancho Tehama Reserve 202 []
707763 November 15, 2019 - 20:44:18 UTC 40.01882 -122.4512 Rancho Tehama Reserve 202 []
708359 November 16, 2019 - 20:43:26 UTC 40.00736 -122.40998 Rancho Tehama Reserve 202 []
709199 November 18, 2019 - 17:52:52 UTC 40.01214 -122.40516 Rancho Tehama Reserve 202 []
717600 November 27, 2019 - 02:55:21 UTC 40.00634 -122.40709 Rancho Tehama Reserve 202 []
778326 February 05, 2020 - 16:57:33 UTC 40.01241 -122.39062 Rancho Tehama Reserve 202 []
790392 February 13, 2020 - 19:30:00 UTC 40.0189 -122.42602 Rancho Tehama Reserve 202 []
1077953 September 17, 2020 - 16:59:46 UTC 40.01797 -122.41632 Rancho Tehama Reserve 202 []
1088946 September 23, 2020 - 15:55:45 UTC 40.01531 -122.45393 Rancho Tehama Reserve 202 []
1111195 October 05, 2020 - 15:43:36 UTC 40.01039 -122.45139 Rancho Tehama Reserve 202 []
1112683 October 07, 2020 - 16:32:52 UTC 40.02062 -122.40258 Rancho Tehama Reserve 202 []
1113270 October 08, 2020 - 08:22:10 UTC 40.01382 -122.40738 Rancho Tehama Reserve 202 []
1121469 October 20, 2020 - 16:19:54 UTC 40.01815 -122.41903 Rancho Tehama Reserve 202 []
1125118 October 25, 2020 - 17:07:50 UTC 39.99671 -122.40582 Rancho Tehama Reserve 202 [{"latitude": "39.99505", "longitude": "-122.41204"}, {"latitude": "39.99673", "longitude": "-122.40604"}, {"latitude": "40.00113", "longitude": "-122.39837"}, {"latitude": "40.00363", "longitude": "-122.39481"}, {"latitude": "40.00877", "longitude": "-122.39339"}, {"latitude": "40.0181", "longitude": "-122.39509"}, {"latitude": "40.02151", "longitude": "-122.40013"}, {"latitude": "40.02179", "longitude": "-122.40062"}, {"latitude": "40.02196", "longitude": "-122.40173"}, {"latitude": "40.0227", "longitude": "-122.44613"}, {"latitude": "40.02183", "longitude": "-122.45911"}, {"latitude": "40.02097", "longitude": "-122.45977"}, {"latitude": "40.00715", "longitude": "-122.46276"}, {"latitude": "39.9983", "longitude": "-122.45974"}, {"latitude": "39.99555", "longitude": "-122.43572"}]
1125127 October 25, 2020 - 17:07:50 UTC 40.01495 -122.3976 Rancho Tehama Reserve 202 [{"latitude": "40.00962", "longitude": "-122.3899"}, {"latitude": "40.01848", "longitude": "-122.35866"}, {"latitude": "40.021", "longitude": "-122.35363"}, {"latitude": "40.02142", "longitude": "-122.35744"}, {"latitude": "40.02265", "longitude": "-122.36941"}, {"latitude": "40.01983", "longitude": "-122.39195"}, {"latitude": "40.01943", "longitude": "-122.3927"}, {"latitude": "40.01898", "longitude": "-122.39351"}, {"latitude": "40.01868", "longitude": "-122.39405"}, {"latitude": "40.0149", "longitude": "-122.39728"}]
1125134 October 25, 2020 - 17:07:50 UTC 40.0157 -122.40048 Rancho Tehama Reserve 202 [{"latitude": "39.99555", "longitude": "-122.43572"}, {"latitude": "40.00113", "longitude": "-122.41875"}, {"latitude": "40.01814", "longitude": "-122.39856"}, {"latitude": "40.0202", "longitude": "-122.39949"}, {"latitude": "40.02151", "longitude": "-122.40013"}, {"latitude": "40.02179", "longitude": "-122.40062"}, {"latitude": "40.02196", "longitude": "-122.40173"}, {"latitude": "40.0227", "longitude": "-122.44613"}, {"latitude": "40.02183", "longitude": "-122.45911"}, {"latitude": "40.02097", "longitude": "-122.45977"}, {"latitude": "40.00715", "longitude": "-122.46276"}, {"latitude": "39.9983", "longitude": "-122.45974"}]
1137181 November 06, 2020 - 15:25:00 UTC 40.01966 -122.44793 Rancho Tehama Reserve 202 [{"latitude": "40.01834", "longitude": "-122.44621"}, {"latitude": "40.01895", "longitude": "-122.44648"}, {"latitude": "40.01926", "longitude": "-122.44695"}, {"latitude": "40.01944", "longitude": "-122.44745"}]
1137878 November 07, 2020 - 00:46:02 UTC 40.01944 -122.44745 Rancho Tehama Reserve 202 []
1146031 November 16, 2020 - 17:11:02 UTC 40.02088 -122.44783 Rancho Tehama Reserve 202 []
1146050 November 16, 2020 - 17:13:03 UTC 40.01306 -122.45587 Rancho Tehama Reserve 202 []
1146162 November 16, 2020 - 18:24:36 UTC 40.01384 -122.39141 Rancho Tehama Reserve 202 []
1146292 November 16, 2020 - 20:08:07 UTC 40.0206 -122.45623 Rancho Tehama Reserve 202 []
1146293 November 16, 2020 - 17:11:02 UTC 40.02088 -122.44783 Rancho Tehama Reserve 202 []
1153105 November 23, 2020 - 17:16:32 UTC 39.99673 -122.40604 Rancho Tehama Reserve 202 []
1156383 November 30, 2020 - 19:06:03 UTC 40.01738 -122.41129 Rancho Tehama Reserve 202 [{"latitude": "40.01785", "longitude": "-122.40606"}, {"latitude": "40.01785", "longitude": "-122.40501"}, {"latitude": "40.01787", "longitude": "-122.40402"}, {"latitude": "40.01803", "longitude": "-122.40354"}, {"latitude": "40.0184", "longitude": "-122.4032"}, {"latitude": "40.01993", "longitude": "-122.40769"}, {"latitude": "40.02037", "longitude": "-122.40942"}, {"latitude": "40.01801", "longitude": "-122.41693"}, {"latitude": "40.01797", "longitude": "-122.41632"}]
1160468 December 03, 2020 - 17:29:34 UTC 40.01345 -122.40168 Rancho Tehama Reserve 202 []
1171467 December 08, 2020 - 18:44:29 UTC 40.00073 -122.41378 Rancho Tehama Reserve 202 []
1173131 December 09, 2020 - 16:35:00 UTC 40.01615 -122.4017 Rancho Tehama Reserve 202 [{"latitude": "40.01671", "longitude": "-122.40139"}, {"latitude": "40.01712", "longitude": "-122.40052"}, {"latitude": "40.0175", "longitude": "-122.39974"}, {"latitude": "40.01814", "longitude": "-122.39856"}, {"latitude": "40.0202", "longitude": "-122.39949"}, {"latitude": "40.02151", "longitude": "-122.40013"}, {"latitude": "40.02179", "longitude": "-122.40062"}, {"latitude": "40.02196", "longitude": "-122.40173"}, {"latitude": "40.02177", "longitude": "-122.40222"}, {"latitude": "40.02111", "longitude": "-122.40273"}, {"latitude": "40.01928", "longitude": "-122.40237"}]
1181647 December 12, 2020 - 21:29:11 UTC 40.01932 -122.39004 Rancho Tehama Reserve 202 []
1193499 December 18, 2020 - 17:13:08 UTC 40.00848 -122.40244 Rancho Tehama Reserve 202 []
1196157 December 21, 2020 - 10:15:02 UTC 40.0188 -122.41063 Rancho Tehama Reserve 202 []
1196567 December 21, 2020 - 22:25:41 UTC 40.0188 -122.41063 Rancho Tehama Reserve 202 []
1197226 December 22, 2020 - 20:02:17 UTC 40.0188 -122.41063 Rancho Tehama Reserve 202 []
1203931 January 04, 2021 - 22:09:13 UTC 40.01688 -122.39306 Rancho Tehama Reserve 202 []
1223622 January 25, 2021 - 16:30:00 UTC 40.01474 -122.38314 Rancho Tehama Reserve 202 [{"latitude": "40.01388", "longitude": "-122.37754"}, {"latitude": "40.01848", "longitude": "-122.35866"}, {"latitude": "40.021", "longitude": "-122.35363"}, {"latitude": "40.02142", "longitude": "-122.35744"}, {"latitude": "40.02265", "longitude": "-122.36941"}, {"latitude": "40.01575", "longitude": "-122.38142"}, {"latitude": "40.01536", "longitude": "-122.38204"}, {"latitude": "40.01483", "longitude": "-122.38257"}]
1248633 February 05, 2021 - 17:12:21 UTC 40.0166 -122.4084 Rancho Tehama Reserve 202 [{"latitude": "40.01548", "longitude": "-122.40918"}, {"latitude": "40.01567", "longitude": "-122.40886"}, {"latitude": "40.01603", "longitude": "-122.4086"}]
1251214 February 09, 2021 - 16:13:29 UTC 40.01483 -122.38257 Rancho Tehama Reserve 202 []
1260907 February 24, 2021 - 17:02:22 UTC 40.01215 -122.40799 Rancho Tehama Reserve 202 []
1262852 February 26, 2021 - 17:39:01 UTC 40.01793 -122.40652 Rancho Tehama Reserve 202 []
1262982 February 26, 2021 - 19:38:52 UTC 40.01793 -122.40652 Rancho Tehama Reserve 202 []

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