51 rows where regionName = 114

View and edit SQL

Suggested facets: outageDevices

id ▼ outageStartTime latitude longitude regionName outageDevices
633786 October 01, 2019 - 15:58:17 UTC 35.93635 -121.1071 Lockwood 114 []
668493 October 18, 2019 - 16:41:55 UTC 36.06641 -121.04364 Lockwood 114 []
671019 October 19, 2019 - 02:44:23 UTC 36.11089 -121.09583 Lockwood 114 []
676042 October 21, 2019 - 17:21:34 UTC 35.96179 -121.16409 Lockwood 114 []
679362 October 24, 2019 - 14:42:47 UTC 35.95212 -121.0677 Lockwood 114 []
679380 October 24, 2019 - 15:13:45 UTC 35.91214 -120.98501 Lockwood 114 []
720691 November 27, 2019 - 16:52:35 UTC 36.10171 -121.08169 Lockwood 114 [{"latitude": "36.08632", "longitude": "-121.0713"}, {"latitude": "36.10171", "longitude": "-121.07529"}, {"latitude": "36.09732", "longitude": "-121.07707"}, {"latitude": "36.0946", "longitude": "-121.07696"}]
722576 November 28, 2019 - 13:09:25 UTC 36.11067 -121.08313 Lockwood 114 [{"latitude": "36.08632", "longitude": "-121.0713"}, {"latitude": "36.10171", "longitude": "-121.07529"}, {"latitude": "36.10762", "longitude": "-121.08312"}, {"latitude": "36.10073", "longitude": "-121.08311"}, {"latitude": "36.09302", "longitude": "-121.08277"}, {"latitude": "36.09184", "longitude": "-121.08183"}]
722588 November 28, 2019 - 13:09:25 UTC 36.10762 -121.08312 Lockwood 114 []
722589 November 28, 2019 - 13:09:25 UTC 36.10171 -121.07529 Lockwood 114 []
722590 November 28, 2019 - 13:09:25 UTC 36.09967 -121.08286 Lockwood 114 [{"latitude": "36.09184", "longitude": "-121.08183"}, {"latitude": "36.09243", "longitude": "-121.08163"}, {"latitude": "36.09302", "longitude": "-121.08277"}]
722607 November 28, 2019 - 13:09:25 UTC 36.11067 -121.08313 Lockwood 114 [{"latitude": "36.08632", "longitude": "-121.0713"}, {"latitude": "36.10171", "longitude": "-121.07529"}, {"latitude": "36.10762", "longitude": "-121.08312"}, {"latitude": "36.10073", "longitude": "-121.08311"}, {"latitude": "36.09302", "longitude": "-121.08277"}, {"latitude": "36.09184", "longitude": "-121.08183"}]
727126 December 02, 2019 - 15:46:25 UTC 35.95244 -121.08934 Lockwood 114 []
787028 February 10, 2020 - 16:22:52 UTC 35.94807 -121.2335 Lockwood 114 []
788296 February 11, 2020 - 15:15:07 UTC 35.94807 -121.2335 Lockwood 114 []
1080216 September 18, 2020 - 16:12:11 UTC 36.10452 -121.13989 Lockwood 114 []
1092635 September 25, 2020 - 18:04:24 UTC 35.96616 -121.07794 Lockwood 114 []
1094742 September 27, 2020 - 09:22:00 UTC 35.96391 -121.09984 Lockwood 114 [{"latitude": "35.94208", "longitude": "-121.10288"}, {"latitude": "35.94722", "longitude": "-121.0997"}, {"latitude": "35.95688", "longitude": "-121.09542"}, {"latitude": "35.95882", "longitude": "-121.09537"}, {"latitude": "35.96156", "longitude": "-121.09986"}, {"latitude": "35.9591", "longitude": "-121.10496"}, {"latitude": "35.95736", "longitude": "-121.10494"}, {"latitude": "35.94895", "longitude": "-121.10418"}]
1094745 September 27, 2020 - 09:23:12 UTC 36.10896 -121.13129 Lockwood 114 []
1094747 September 27, 2020 - 09:23:12 UTC 36.11471 -121.12879 Lockwood 114 []
1094748 September 27, 2020 - 09:23:12 UTC 36.09958 -121.14779 Lockwood 114 []
1094752 September 27, 2020 - 09:23:12 UTC 35.92462 -121.0657 Lockwood 114 []
1094753 September 27, 2020 - 09:23:12 UTC 35.96831 -121.18785 Lockwood 114 []
1094763 September 27, 2020 - 09:26:00 UTC 35.94394 -121.05542 Lockwood 114 []
1094769 September 27, 2020 - 09:27:00 UTC 35.94075 -121.08295 Lockwood 114 []
1102798 October 01, 2020 - 01:21:00 UTC 36.11237 -121.03796 Lockwood 114 [{"latitude": "36.08632", "longitude": "-121.0713"}, {"latitude": "36.12075", "longitude": "-121.06091"}, {"latitude": "36.13003", "longitude": "-121.06742"}, {"latitude": "36.14214", "longitude": "-121.0797"}, {"latitude": "36.14969", "longitude": "-121.09304"}, {"latitude": "36.1472", "longitude": "-121.10041"}, {"latitude": "36.14196", "longitude": "-121.10422"}, {"latitude": "36.1127", "longitude": "-121.10327"}, {"latitude": "36.09184", "longitude": "-121.08183"}]
1110707 October 04, 2020 - 12:00:06 UTC 35.95142 -121.00202 Lockwood 114 []
1113724 October 08, 2020 - 22:47:08 UTC 35.95942 -121.18585 Lockwood 114 []
1119280 October 16, 2020 - 17:33:55 UTC 35.94392 -121.08196 Lockwood 114 []
1119281 October 16, 2020 - 17:34:02 UTC 35.95273 -121.07803 Lockwood 114 []
1119299 October 16, 2020 - 17:33:55 UTC 35.96575 -121.08192 Lockwood 114 [{"latitude": "35.94075", "longitude": "-121.08295"}, {"latitude": "35.95115", "longitude": "-121.07589"}, {"latitude": "35.95525", "longitude": "-121.07373"}, {"latitude": "35.95891", "longitude": "-121.0865"}, {"latitude": "35.94949", "longitude": "-121.09666"}, {"latitude": "35.94092", "longitude": "-121.08424"}]
1119340 October 16, 2020 - 18:52:58 UTC 36.09481 -121.16157 Lockwood 114 [{"latitude": "36.09281", "longitude": "-121.16003"}, {"latitude": "36.094", "longitude": "-121.16129"}, {"latitude": "36.09333", "longitude": "-121.1606"}]
1129888 October 27, 2020 - 17:42:18 UTC 35.94392 -121.08196 Lockwood 114 []
1129889 October 27, 2020 - 17:42:20 UTC 35.95008 -121.08214 Lockwood 114 []
1129890 October 27, 2020 - 17:42:15 UTC 35.95577 -121.08001 Lockwood 114 []
1129891 October 27, 2020 - 17:42:18 UTC 35.95123 -121.08228 Lockwood 114 [{"latitude": "35.94851", "longitude": "-121.08962"}, {"latitude": "35.95244", "longitude": "-121.08934"}, {"latitude": "35.95292", "longitude": "-121.08933"}, {"latitude": "35.94949", "longitude": "-121.09666"}]
1132217 October 30, 2020 - 17:44:47 UTC 35.94392 -121.08196 Lockwood 114 []
1132218 October 30, 2020 - 17:44:47 UTC 35.94851 -121.08962 Lockwood 114 []
1132232 October 30, 2020 - 18:07:00 UTC 35.95115 -121.07589 Lockwood 114 []
1132842 October 31, 2020 - 17:52:00 UTC 35.95577 -121.08001 Lockwood 114 []
1132855 October 31, 2020 - 18:03:10 UTC 35.95123 -121.08228 Lockwood 114 [{"latitude": "35.94851", "longitude": "-121.08962"}, {"latitude": "35.95244", "longitude": "-121.08934"}, {"latitude": "35.95292", "longitude": "-121.08933"}, {"latitude": "35.94949", "longitude": "-121.09666"}]
1132860 October 31, 2020 - 18:08:00 UTC 35.95367 -121.08211 Lockwood 114 []
1132866 October 31, 2020 - 18:14:06 UTC 35.95367 -121.08211 Lockwood 114 []
1132878 October 31, 2020 - 18:38:41 UTC 35.95115 -121.07589 Lockwood 114 []
1138228 November 07, 2020 - 14:27:04 UTC 35.95942 -121.18585 Lockwood 114 []
1142640 November 12, 2020 - 17:49:00 UTC 35.94851 -121.08962 Lockwood 114 []
1142641 November 12, 2020 - 17:49:57 UTC 35.95577 -121.08001 Lockwood 114 []
1142659 November 12, 2020 - 17:58:02 UTC 35.95115 -121.07589 Lockwood 114 []
1142676 November 12, 2020 - 18:08:00 UTC 35.94392 -121.08196 Lockwood 114 []
1151314 November 21, 2020 - 19:21:00 UTC 35.95577 -121.08001 Lockwood 114 []
1151316 November 21, 2020 - 19:25:05 UTC 35.95008 -121.08214 Lockwood 114 []

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