55 rows where regionName = 501

View and edit SQL

Suggested facets: latitude, longitude, outageDevices

id ▼ outageStartTime latitude longitude regionName outageDevices
645261 October 06, 2019 - 05:15:57 UTC 39.72169 -121.50857 Yankee Hill 501 []
645353 October 06, 2019 - 05:24:36 UTC 39.70696 -121.52841 Yankee Hill 501 []
645354 October 06, 2019 - 05:24:36 UTC 39.70518 -121.52177 Yankee Hill 501 []
645365 October 06, 2019 - 05:25:15 UTC 39.71885 -121.51527 Yankee Hill 501 []
645366 October 06, 2019 - 05:25:18 UTC 39.70046 -121.52818 Yankee Hill 501 []
645368 October 06, 2019 - 05:25:18 UTC 39.71096 -121.51957 Yankee Hill 501 []
645369 October 06, 2019 - 05:25:18 UTC 39.70325 -121.52744 Yankee Hill 501 []
645493 October 06, 2019 - 05:18:00 UTC 39.69452 -121.52522 Yankee Hill 501 [{"latitude": "39.6816", "longitude": "-121.5049"}, {"latitude": "39.70644", "longitude": "-121.50899"}, {"latitude": "39.7188", "longitude": "-121.51295"}, {"latitude": "39.73016", "longitude": "-121.52656"}, {"latitude": "39.73188", "longitude": "-121.53131"}, {"latitude": "39.72824", "longitude": "-121.54003"}, {"latitude": "39.70368", "longitude": "-121.54929"}]
649123 October 09, 2019 - 09:34:44 UTC 39.70613 -121.52894 Yankee Hill 501 []
649125 October 09, 2019 - 09:34:44 UTC 39.70325 -121.52744 Yankee Hill 501 []
650124 October 09, 2019 - 09:04:00 UTC 39.69452 -121.52522 Yankee Hill 501 [{"latitude": "39.6816", "longitude": "-121.5049"}, {"latitude": "39.70644", "longitude": "-121.50899"}, {"latitude": "39.7188", "longitude": "-121.51295"}, {"latitude": "39.73016", "longitude": "-121.52656"}, {"latitude": "39.73188", "longitude": "-121.53131"}, {"latitude": "39.72824", "longitude": "-121.54003"}, {"latitude": "39.70368", "longitude": "-121.54929"}]
677875 October 23, 2019 - 21:32:01 UTC 39.70046 -121.52818 Yankee Hill 501 []
677876 October 23, 2019 - 21:32:01 UTC 39.70613 -121.52894 Yankee Hill 501 []
677878 October 23, 2019 - 21:32:01 UTC 39.71885 -121.51527 Yankee Hill 501 []
678180 October 23, 2019 - 21:19:00 UTC 39.69452 -121.52522 Yankee Hill 501 [{"latitude": "39.6816", "longitude": "-121.5049"}, {"latitude": "39.70644", "longitude": "-121.50899"}, {"latitude": "39.7188", "longitude": "-121.51295"}, {"latitude": "39.73016", "longitude": "-121.52656"}, {"latitude": "39.73188", "longitude": "-121.53131"}, {"latitude": "39.72824", "longitude": "-121.54003"}, {"latitude": "39.70368", "longitude": "-121.54929"}]
681927 October 27, 2019 - 01:15:43 UTC 39.70046 -121.52818 Yankee Hill 501 []
681928 October 27, 2019 - 01:15:43 UTC 39.70696 -121.52841 Yankee Hill 501 []
681930 October 27, 2019 - 01:15:43 UTC 39.71885 -121.51527 Yankee Hill 501 []
681931 October 27, 2019 - 01:15:43 UTC 39.70325 -121.52744 Yankee Hill 501 []
682126 October 27, 2019 - 01:29:48 UTC 39.70745 -121.51987 Yankee Hill 501 []
683233 October 27, 2019 - 00:52:00 UTC 39.69452 -121.52522 Yankee Hill 501 [{"latitude": "39.6816", "longitude": "-121.5049"}, {"latitude": "39.70644", "longitude": "-121.50899"}, {"latitude": "39.7188", "longitude": "-121.51295"}, {"latitude": "39.73016", "longitude": "-121.52656"}, {"latitude": "39.73188", "longitude": "-121.53131"}, {"latitude": "39.72824", "longitude": "-121.54003"}, {"latitude": "39.70368", "longitude": "-121.54929"}]
692982 October 29, 2019 - 12:16:08 UTC 39.70613 -121.52894 Yankee Hill 501 []
692983 October 29, 2019 - 12:16:00 UTC 39.70985 -121.52347 Yankee Hill 501 [{"latitude": "39.70495", "longitude": "-121.50877"}, {"latitude": "39.70644", "longitude": "-121.50899"}, {"latitude": "39.71096", "longitude": "-121.51957"}, {"latitude": "39.70928", "longitude": "-121.52235"}, {"latitude": "39.70657", "longitude": "-121.52377"}, {"latitude": "39.70539", "longitude": "-121.51907"}]
692984 October 29, 2019 - 12:16:08 UTC 39.70325 -121.52744 Yankee Hill 501 []
692985 October 29, 2019 - 12:16:08 UTC 39.70518 -121.52177 Yankee Hill 501 []
693106 October 29, 2019 - 12:09:00 UTC 39.69452 -121.52522 Yankee Hill 501 [{"latitude": "39.6816", "longitude": "-121.5049"}, {"latitude": "39.70644", "longitude": "-121.50899"}, {"latitude": "39.7188", "longitude": "-121.51295"}, {"latitude": "39.73016", "longitude": "-121.52656"}, {"latitude": "39.73188", "longitude": "-121.53131"}, {"latitude": "39.72824", "longitude": "-121.54003"}, {"latitude": "39.70368", "longitude": "-121.54929"}]
696489 October 31, 2019 - 16:11:38 UTC 39.68562 -121.52709 Yankee Hill 501 []
718782 November 27, 2019 - 04:56:00 UTC 39.69898 -121.52076 Yankee Hill 501 []
718788 November 27, 2019 - 04:56:48 UTC 39.70325 -121.52744 Yankee Hill 501 []
720397 November 27, 2019 - 15:22:43 UTC 39.70056 -121.51994 Yankee Hill 501 []
721751 November 27, 2019 - 22:24:22 UTC 39.70565 -121.52583 Yankee Hill 501 []
1060336 September 08, 2020 - 05:02:00 UTC 39.69445 -121.52483 Yankee Hill 501 [{"latitude": "39.6816", "longitude": "-121.5049"}, {"latitude": "39.70655", "longitude": "-121.50866"}, {"latitude": "39.70786", "longitude": "-121.50906"}, {"latitude": "39.71861", "longitude": "-121.51311"}, {"latitude": "39.73015", "longitude": "-121.5265"}, {"latitude": "39.73135", "longitude": "-121.53117"}, {"latitude": "39.72843", "longitude": "-121.54026"}, {"latitude": "39.70384", "longitude": "-121.54911"}]
1063806 September 08, 2020 - 05:02:00 UTC 39.70722 -121.526 Yankee Hill 501 [{"latitude": "39.70604", "longitude": "-121.52866"}, {"latitude": "39.70722", "longitude": "-121.52738"}, {"latitude": "39.70787", "longitude": "-121.52826"}]
1094814 September 27, 2020 - 11:05:00 UTC 39.69445 -121.52483 Yankee Hill 501 [{"latitude": "39.68126", "longitude": "-121.45681"}, {"latitude": "39.69358", "longitude": "-121.44902"}, {"latitude": "39.70077", "longitude": "-121.44459"}, {"latitude": "39.82824", "longitude": "-121.47166"}, {"latitude": "39.78952", "longitude": "-121.53076"}, {"latitude": "39.78527", "longitude": "-121.53261"}, {"latitude": "39.70384", "longitude": "-121.54911"}, {"latitude": "39.68156", "longitude": "-121.50506"}]
1118078 October 15, 2020 - 01:06:00 UTC 39.69445 -121.52483 Yankee Hill 501 [{"latitude": "39.68156", "longitude": "-121.50506"}, {"latitude": "39.70655", "longitude": "-121.50866"}, {"latitude": "39.70786", "longitude": "-121.50906"}, {"latitude": "39.71861", "longitude": "-121.51311"}, {"latitude": "39.73015", "longitude": "-121.5265"}, {"latitude": "39.73135", "longitude": "-121.53117"}, {"latitude": "39.72843", "longitude": "-121.54026"}, {"latitude": "39.70384", "longitude": "-121.54911"}]
1121819 October 20, 2020 - 22:35:18 UTC 39.70834 -121.51959 Yankee Hill 501 []
1122850 October 22, 2020 - 12:08:18 UTC 39.70055 -121.52801 Yankee Hill 501 []
1122851 October 22, 2020 - 12:08:18 UTC 39.70722 -121.526 Yankee Hill 501 [{"latitude": "39.70604", "longitude": "-121.52866"}, {"latitude": "39.70722", "longitude": "-121.52738"}, {"latitude": "39.70787", "longitude": "-121.52826"}]
1122852 October 22, 2020 - 12:08:17 UTC 39.70995 -121.52354 Yankee Hill 501 [{"latitude": "39.7055", "longitude": "-121.5191"}, {"latitude": "39.70655", "longitude": "-121.50866"}, {"latitude": "39.70786", "longitude": "-121.50906"}, {"latitude": "39.71108", "longitude": "-121.51935"}, {"latitude": "39.70941", "longitude": "-121.52247"}, {"latitude": "39.70658", "longitude": "-121.52355"}]
1122853 October 22, 2020 - 12:08:18 UTC 39.70297 -121.5277 Yankee Hill 501 []
1122856 October 22, 2020 - 12:08:27 UTC 39.71413 -121.52141 Yankee Hill 501 [{"latitude": "39.71072", "longitude": "-121.51753"}, {"latitude": "39.71861", "longitude": "-121.51311"}, {"latitude": "39.721", "longitude": "-121.51684"}, {"latitude": "39.71773", "longitude": "-121.51869"}, {"latitude": "39.71509", "longitude": "-121.52007"}]
1122857 October 22, 2020 - 12:08:30 UTC 39.70524 -121.52203 Yankee Hill 501 []
1122858 October 22, 2020 - 12:08:31 UTC 39.70643 -121.5262 Yankee Hill 501 []
1122859 October 22, 2020 - 12:08:35 UTC 39.71055 -121.52178 Yankee Hill 501 []
1122873 October 22, 2020 - 12:10:52 UTC 39.71574 -121.53847 Yankee Hill 501 []
1122921 October 22, 2020 - 12:02:00 UTC 39.69445 -121.52483 Yankee Hill 501 [{"latitude": "39.68156", "longitude": "-121.50506"}, {"latitude": "39.70655", "longitude": "-121.50866"}, {"latitude": "39.70786", "longitude": "-121.50906"}, {"latitude": "39.71861", "longitude": "-121.51311"}, {"latitude": "39.73015", "longitude": "-121.5265"}, {"latitude": "39.73135", "longitude": "-121.53117"}, {"latitude": "39.72843", "longitude": "-121.54026"}, {"latitude": "39.70384", "longitude": "-121.54911"}]
1125439 October 25, 2020 - 21:10:28 UTC 39.70055 -121.52801 Yankee Hill 501 []
1125440 October 25, 2020 - 21:10:28 UTC 39.70722 -121.526 Yankee Hill 501 [{"latitude": "39.70604", "longitude": "-121.52866"}, {"latitude": "39.70722", "longitude": "-121.52738"}, {"latitude": "39.70787", "longitude": "-121.52826"}]
1125442 October 25, 2020 - 21:10:28 UTC 39.70995 -121.52354 Yankee Hill 501 [{"latitude": "39.7055", "longitude": "-121.5191"}, {"latitude": "39.70655", "longitude": "-121.50866"}, {"latitude": "39.70786", "longitude": "-121.50906"}, {"latitude": "39.71108", "longitude": "-121.51935"}, {"latitude": "39.70941", "longitude": "-121.52247"}, {"latitude": "39.70658", "longitude": "-121.52355"}]
1125443 October 25, 2020 - 21:10:28 UTC 39.70297 -121.5277 Yankee Hill 501 []
1125444 October 25, 2020 - 21:10:28 UTC 39.70524 -121.52203 Yankee Hill 501 []
1125663 October 25, 2020 - 21:01:00 UTC 39.69445 -121.52483 Yankee Hill 501 [{"latitude": "39.68156", "longitude": "-121.50506"}, {"latitude": "39.70655", "longitude": "-121.50866"}, {"latitude": "39.70786", "longitude": "-121.50906"}, {"latitude": "39.71861", "longitude": "-121.51311"}, {"latitude": "39.73015", "longitude": "-121.5265"}, {"latitude": "39.73135", "longitude": "-121.53117"}, {"latitude": "39.72843", "longitude": "-121.54026"}, {"latitude": "39.70384", "longitude": "-121.54911"}]
1171549 December 08, 2020 - 19:06:54 UTC 39.71284 -121.52616 Yankee Hill 501 []
1204620 January 05, 2021 - 20:03:00 UTC 39.72252 -121.50818 Yankee Hill 501 []
1212134 January 18, 2021 - 14:55:00 UTC 39.72253 -121.50816 Yankee Hill 501 []

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