880 rows where regionName = 46

View and edit SQL

id ▼ outageStartTime latitude longitude regionName outageDevices
633538 October 01, 2019 - 12:45:51 UTC 37.95276 -121.95995 Concord 46 []
635518 October 02, 2019 - 02:49:21 UTC 37.95536 -122.04391 Concord 46 []
635753 October 02, 2019 - 14:59:38 UTC 37.9865 -122.03452 Concord 46 []
636255 October 02, 2019 - 17:01:11 UTC 37.94396 -121.96034 Concord 46 []
636773 October 02, 2019 - 18:34:34 UTC 37.96679 -122.00216 Concord 46 []
641457 October 03, 2019 - 22:16:56 UTC 37.94869 -122.04109 Concord 46 []
641796 October 03, 2019 - 23:34:59 UTC 38.03022 -122.00196 Concord 46 []
643418 October 04, 2019 - 17:38:47 UTC 37.98021 -122.03421 Concord 46 []
643747 October 04, 2019 - 22:23:04 UTC 37.99333 -122.03465 Concord 46 []
643797 October 05, 2019 - 00:23:26 UTC 37.99333 -122.04305 Concord 46 []
643999 October 05, 2019 - 15:16:58 UTC 37.9382 -122.03206 Concord 46 [{"latitude": "37.93637", "longitude": "-122.03089"}, {"latitude": "37.93749", "longitude": "-122.0314"}, {"latitude": "37.93845", "longitude": "-122.03205"}, {"latitude": "37.93794", "longitude": "-122.03182"}]
644396 October 05, 2019 - 16:45:00 UTC 37.96343 -122.05209 Concord 46 [{"latitude": "37.96223", "longitude": "-122.06493"}, {"latitude": "37.96236", "longitude": "-122.06381"}, {"latitude": "37.96247", "longitude": "-122.06291"}, {"latitude": "37.96284", "longitude": "-122.06263"}, {"latitude": "37.96367", "longitude": "-122.06235"}, {"latitude": "37.97376", "longitude": "-122.06328"}, {"latitude": "37.97402", "longitude": "-122.06345"}, {"latitude": "37.97487", "longitude": "-122.06414"}, {"latitude": "37.97511", "longitude": "-122.06483"}, {"latitude": "37.97482", "longitude": "-122.06518"}, {"latitude": "37.97029", "longitude": "-122.06641"}, {"latitude": "37.96254", "longitude": "-122.06605"}]
645579 October 06, 2019 - 16:32:51 UTC 37.96857 -121.96056 Concord 46 []
645746 October 07, 2019 - 04:09:00 UTC 37.96722 -122.06013 Concord 46 [{"latitude": "37.96855", "longitude": "-122.06044"}, {"latitude": "37.96861", "longitude": "-122.06045"}, {"latitude": "37.96866", "longitude": "-122.06046"}]
645987 October 07, 2019 - 17:02:06 UTC 37.94271 -122.03838 Concord 46 []
646037 October 07, 2019 - 17:29:41 UTC 37.98734 -122.04531 Concord 46 []
647027 October 08, 2019 - 05:15:48 UTC 37.96548 -121.99737 Concord 46 []
647317 October 08, 2019 - 16:29:53 UTC 37.96081 -122.06133 Concord 46 []
647527 October 08, 2019 - 20:34:00 UTC 37.93678 -122.04345 Concord 46 []
647587 October 08, 2019 - 22:29:24 UTC 37.94578 -121.95289 Concord 46 []
650741 October 09, 2019 - 15:21:38 UTC 38.02063 -122.03007 Concord 46 []
650834 October 09, 2019 - 17:00:46 UTC 37.94954 -122.04794 Concord 46 []
651878 October 10, 2019 - 02:06:15 UTC 37.97438 -121.98095 Concord 46 []
652637 October 10, 2019 - 14:40:55 UTC 37.97929 -122.01995 Concord 46 []
652935 October 10, 2019 - 17:55:54 UTC 37.98562 -121.99993 Concord 46 []
653027 October 10, 2019 - 18:41:55 UTC 37.95463 -122.0046 Concord 46 []
653641 October 10, 2019 - 23:41:26 UTC 37.95583 -122.04624 Concord 46 []
654153 October 11, 2019 - 15:33:29 UTC 37.97743 -122.01958 Concord 46 []
654167 October 11, 2019 - 15:46:35 UTC 37.99904 -122.04578 Concord 46 []
654216 October 11, 2019 - 16:04:00 UTC 37.96957 -122.04522 Concord 46 []
654234 October 11, 2019 - 16:15:11 UTC 37.95806 -122.04827 Concord 46 []
654776 October 12, 2019 - 00:09:00 UTC 37.96155 -122.03699 Concord 46 []
654813 October 12, 2019 - 00:44:24 UTC 37.95583 -122.04624 Concord 46 []
654913 October 12, 2019 - 02:53:02 UTC 37.98644 -122.04366 Concord 46 []
655104 October 12, 2019 - 16:07:10 UTC 37.98644 -122.04366 Concord 46 []
655350 October 12, 2019 - 23:06:00 UTC 37.94422 -121.96912 Concord 46 [{"latitude": "37.84116", "longitude": "-121.82496"}, {"latitude": "37.86712", "longitude": "-121.73304"}, {"latitude": "37.87427", "longitude": "-121.72415"}, {"latitude": "37.89466", "longitude": "-121.77392"}, {"latitude": "37.92426", "longitude": "-121.905"}, {"latitude": "37.92423", "longitude": "-121.91157"}, {"latitude": "37.92379", "longitude": "-121.91202"}, {"latitude": "37.92341", "longitude": "-121.91208"}, {"latitude": "37.92294", "longitude": "-121.91211"}, {"latitude": "37.89254", "longitude": "-121.90786"}, {"latitude": "37.85114", "longitude": "-121.89392"}, {"latitude": "37.84263", "longitude": "-121.8391"}]
655839 October 14, 2019 - 15:07:42 UTC 37.96407 -122.05249 Concord 46 []
656216 October 14, 2019 - 16:41:03 UTC 37.96968 -121.99152 Concord 46 []
656373 October 14, 2019 - 16:53:23 UTC 37.96084 -122.04491 Concord 46 []
658373 October 14, 2019 - 21:40:31 UTC 37.97725 -121.99853 Concord 46 []
658856 October 15, 2019 - 15:23:41 UTC 37.97726 -122.01109 Concord 46 []
658963 October 15, 2019 - 16:26:37 UTC 37.98586 -122.0101 Concord 46 []
659850 October 15, 2019 - 21:51:14 UTC 37.96036 -121.97595 Concord 46 []
659946 October 16, 2019 - 01:09:31 UTC 37.9578 -122.0434 Concord 46 []
660825 October 16, 2019 - 18:16:00 UTC 37.96215 -121.99044 Concord 46 []
660827 October 16, 2019 - 18:17:00 UTC 37.95231 -121.96852 Concord 46 []
660842 October 16, 2019 - 18:28:35 UTC 37.96094 -121.98401 Concord 46 []
662193 October 16, 2019 - 20:49:20 UTC 37.98848 -122.03225 Concord 46 []
663186 October 17, 2019 - 01:05:03 UTC 37.93832 -122.02394 Concord 46 []
664017 October 17, 2019 - 15:37:09 UTC 37.95539 -122.04499 Concord 46 []
665982 October 17, 2019 - 20:04:43 UTC 37.95757 -121.97436 Concord 46 []
667136 October 17, 2019 - 23:54:22 UTC 37.98734 -122.04531 Concord 46 []
667159 October 18, 2019 - 00:05:00 UTC 37.9758 -122.02441 Concord 46 [{"latitude": "37.9688", "longitude": "-122.02972"}, {"latitude": "37.96896", "longitude": "-122.02661"}, {"latitude": "37.97239", "longitude": "-122.01019"}, {"latitude": "37.97294", "longitude": "-122.01008"}, {"latitude": "37.97475", "longitude": "-122.00972"}, {"latitude": "37.97582", "longitude": "-122.01233"}, {"latitude": "37.97691", "longitude": "-122.01705"}, {"latitude": "37.97693", "longitude": "-122.02076"}, {"latitude": "37.9767", "longitude": "-122.02248"}, {"latitude": "37.97526", "longitude": "-122.0262"}, {"latitude": "37.97407", "longitude": "-122.02745"}, {"latitude": "37.97031", "longitude": "-122.02949"}]
667271 October 18, 2019 - 02:36:42 UTC 37.94818 -121.95532 Concord 46 []
668855 October 18, 2019 - 17:45:25 UTC 37.96225 -121.98828 Concord 46 []
669835 October 18, 2019 - 20:05:47 UTC 37.95997 -121.98352 Concord 46 []
670194 October 18, 2019 - 21:08:04 UTC 37.93761 -122.0499 Concord 46 []
670579 October 18, 2019 - 22:08:00 UTC 37.96343 -122.05212 Concord 46 [{"latitude": "37.93369", "longitude": "-122.08081"}, {"latitude": "37.94212", "longitude": "-122.06142"}, {"latitude": "37.94505", "longitude": "-122.05965"}, {"latitude": "37.94652", "longitude": "-122.06004"}, {"latitude": "37.96074", "longitude": "-122.06485"}, {"latitude": "37.96158", "longitude": "-122.0653"}, {"latitude": "37.96248", "longitude": "-122.06724"}, {"latitude": "37.96821", "longitude": "-122.08973"}, {"latitude": "37.96859", "longitude": "-122.09155"}, {"latitude": "37.95987", "longitude": "-122.11603"}, {"latitude": "37.95776", "longitude": "-122.11692"}, {"latitude": "37.93642", "longitude": "-122.11863"}]
670694 October 18, 2019 - 22:51:45 UTC 37.97031 -122.04284 Concord 46 []
670722 October 18, 2019 - 21:08:04 UTC 37.96343 -122.05207 Concord 46 [{"latitude": "37.93979", "longitude": "-122.07082"}, {"latitude": "37.9405", "longitude": "-122.06783"}, {"latitude": "37.94212", "longitude": "-122.06142"}, {"latitude": "37.94505", "longitude": "-122.05965"}, {"latitude": "37.94652", "longitude": "-122.06004"}, {"latitude": "37.94817", "longitude": "-122.06067"}, {"latitude": "37.9449", "longitude": "-122.06813"}, {"latitude": "37.94064", "longitude": "-122.07051"}]
672114 October 19, 2019 - 17:20:45 UTC 37.98133 -122.04901 Concord 46 []
672133 October 19, 2019 - 17:22:51 UTC 37.9822 -122.04911 Concord 46 []
672213 October 19, 2019 - 17:35:34 UTC 37.98072 -122.04936 Concord 46 []
672413 October 19, 2019 - 18:05:52 UTC 37.97404 -122.0217 Concord 46 []
672493 October 19, 2019 - 18:21:23 UTC 37.93818 -122.04078 Concord 46 []
674961 October 21, 2019 - 02:37:57 UTC 37.97594 -122.00564 Concord 46 []
675911 October 21, 2019 - 16:08:42 UTC 37.98983 -122.02637 Concord 46 []
676288 October 21, 2019 - 20:25:53 UTC 37.97598 -122.0029 Concord 46 []
676375 October 21, 2019 - 21:35:34 UTC 37.96089 -122.04353 Concord 46 []
676546 October 22, 2019 - 05:37:24 UTC 37.98909 -122.00681 Concord 46 []
676608 October 22, 2019 - 13:07:56 UTC 37.95733 -121.9628 Concord 46 [{"latitude": "37.95487", "longitude": "-121.96395"}, {"latitude": "37.95647", "longitude": "-121.96313"}, {"latitude": "37.95768", "longitude": "-121.96373"}, {"latitude": "37.95587", "longitude": "-121.964"}]
677064 October 22, 2019 - 22:19:20 UTC 37.95359 -121.96656 Concord 46 []
677274 October 23, 2019 - 12:12:17 UTC 37.98038 -122.01781 Concord 46 []
677441 October 23, 2019 - 16:10:18 UTC 37.95379 -121.96495 Concord 46 []
677444 October 23, 2019 - 16:11:19 UTC 37.96347 -122.00439 Concord 46 []
677612 October 23, 2019 - 19:00:54 UTC 37.98212 -121.99231 Concord 46 []
677643 October 23, 2019 - 19:33:07 UTC 37.96148 -122.0478 Concord 46 []
677691 October 23, 2019 - 20:25:51 UTC 37.94731 -122.01046 Concord 46 []
677911 October 23, 2019 - 21:33:19 UTC 37.94709 -122.01063 Concord 46 []
679178 October 24, 2019 - 04:00:33 UTC 37.9801 -122.03674 Concord 46 []
679420 October 24, 2019 - 15:45:34 UTC 37.95717 -122.04827 Concord 46 []
679440 October 24, 2019 - 15:54:42 UTC 37.9694 -122.01111 Concord 46 []
679480 October 24, 2019 - 16:19:42 UTC 38.00897 -122.03481 Concord 46 []
679661 October 24, 2019 - 19:11:47 UTC 37.96523 -121.99624 Concord 46 []
679670 October 24, 2019 - 19:31:42 UTC 37.99042 -122.02605 Concord 46 []
680034 October 25, 2019 - 01:38:11 UTC 37.97293 -121.98356 Concord 46 []
680368 October 25, 2019 - 17:21:31 UTC 37.93763 -122.02278 Concord 46 []
680403 October 25, 2019 - 18:06:48 UTC 37.935 -122.04651 Concord 46 []
680460 October 25, 2019 - 19:30:28 UTC 37.96503 -122.05153 Concord 46 []
680823 October 26, 2019 - 17:15:37 UTC 37.99983 -122.02531 Concord 46 []
680879 October 26, 2019 - 19:59:18 UTC 38.00305 -122.04971 Concord 46 []
683956 October 27, 2019 - 03:49:44 UTC 37.93094 -121.97367 Concord 46 [{"latitude": "37.85658", "longitude": "-121.97294"}, {"latitude": "37.92542", "longitude": "-121.96893"}, {"latitude": "37.92702", "longitude": "-121.97296"}, {"latitude": "37.93882", "longitude": "-122.00891"}, {"latitude": "37.9221", "longitude": "-122.02756"}, {"latitude": "37.92146", "longitude": "-122.02815"}, {"latitude": "37.91858", "longitude": "-122.02919"}, {"latitude": "37.85741", "longitude": "-121.98322"}]
684040 October 27, 2019 - 03:55:24 UTC 37.93089 -121.973 Concord 46 [{"latitude": "37.92724", "longitude": "-121.97099"}, {"latitude": "37.9274", "longitude": "-121.96641"}, {"latitude": "37.92852", "longitude": "-121.96446"}, {"latitude": "37.93508", "longitude": "-121.96986"}, {"latitude": "37.93433", "longitude": "-121.97131"}, {"latitude": "37.9316", "longitude": "-121.97266"}]
684397 October 27, 2019 - 04:36:00 UTC 37.96317 -121.94071 Concord 46 [{"latitude": "37.95794", "longitude": "-121.92377"}, {"latitude": "37.97264", "longitude": "-121.91085"}, {"latitude": "37.97627", "longitude": "-121.9077"}, {"latitude": "37.97368", "longitude": "-121.91659"}, {"latitude": "37.96422", "longitude": "-121.94094"}, {"latitude": "37.96217", "longitude": "-121.93714"}]
684502 October 27, 2019 - 04:50:00 UTC 37.94014 -121.9615 Concord 46 []
685088 October 27, 2019 - 05:31:55 UTC 37.967 -121.96164 Concord 46 [{"latitude": "37.96749", "longitude": "-121.96136"}, {"latitude": "37.96757", "longitude": "-121.95999"}, {"latitude": "37.96975", "longitude": "-121.96106"}, {"latitude": "37.97083", "longitude": "-121.96163"}, {"latitude": "37.97188", "longitude": "-121.9628"}]
685089 October 27, 2019 - 05:31:55 UTC 37.96364 -121.95043 Concord 46 []
685090 October 27, 2019 - 05:31:55 UTC 37.96166 -121.94849 Concord 46 []
685117 October 27, 2019 - 05:32:00 UTC 37.94094 -121.96038 Concord 46 []
685127 October 27, 2019 - 04:30:00 UTC 37.94125 -121.95756 Concord 46 [{"latitude": "37.92916", "longitude": "-121.95976"}, {"latitude": "37.93092", "longitude": "-121.95687"}, {"latitude": "37.94021", "longitude": "-121.95758"}]

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