outages

119 rows where regionName = 32 sorted by outageDevices

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices ▼
633485 October 01, 2019 - 05:54:46 UTC 38.1891 -120.82691 Valley Springs 32 []
633795 October 01, 2019 - 16:00:06 UTC 38.26855 -120.76325 Valley Springs 32 []
633810 October 01, 2019 - 16:03:58 UTC 38.21263 -120.75959 Valley Springs 32 []
633813 October 01, 2019 - 16:04:34 UTC 38.16742 -120.84556 Valley Springs 32 []
639149 October 03, 2019 - 16:00:32 UTC 38.20577 -120.89568 Valley Springs 32 []
639179 October 03, 2019 - 16:11:09 UTC 38.17047 -120.9182 Valley Springs 32 []
642756 October 04, 2019 - 16:00:38 UTC 38.17702 -120.92811 Valley Springs 32 []
642759 October 04, 2019 - 16:01:16 UTC 38.18201 -120.93287 Valley Springs 32 []
643959 October 05, 2019 - 15:00:00 UTC 38.25805 -120.75958 Valley Springs 32 []
652604 October 10, 2019 - 13:43:55 UTC 38.17346 -120.9587 Valley Springs 32 []
652605 October 10, 2019 - 13:43:55 UTC 38.16534 -120.96496 Valley Springs 32 []
652606 October 10, 2019 - 13:43:55 UTC 38.16737 -120.96264 Valley Springs 32 []
652614 October 10, 2019 - 13:56:00 UTC 38.17333 -120.95717 Valley Springs 32 []
652869 October 10, 2019 - 17:30:48 UTC 38.16405 -120.83373 Valley Springs 32 []
654557 October 11, 2019 - 21:14:03 UTC 38.20812 -120.76517 Valley Springs 32 []
655191 October 12, 2019 - 18:12:35 UTC 38.17418 -120.83022 Valley Springs 32 []
658983 October 15, 2019 - 16:43:00 UTC 38.1999 -120.87041 Valley Springs 32 []
675979 October 21, 2019 - 16:38:33 UTC 38.17679 -120.88389 Valley Springs 32 []
677094 October 22, 2019 - 22:54:19 UTC 38.09559 -120.89578 Valley Springs 32 []
680474 October 25, 2019 - 19:54:12 UTC 38.18338 -120.82297 Valley Springs 32 []
680802 October 26, 2019 - 16:25:54 UTC 38.27413 -120.76857 Valley Springs 32 []
692262 October 28, 2019 - 23:27:07 UTC 38.17612 -120.82967 Valley Springs 32 []
692266 October 28, 2019 - 23:28:41 UTC 38.16945 -120.8342 Valley Springs 32 []
692342 October 29, 2019 - 00:00:24 UTC 38.10601 -120.89397 Valley Springs 32 []
692728 October 29, 2019 - 03:14:50 UTC 38.18614 -120.89778 Valley Springs 32 []
692801 October 29, 2019 - 04:27:00 UTC 38.17386 -120.90875 Valley Springs 32 []
692858 October 29, 2019 - 07:42:27 UTC 38.15441 -120.87409 Valley Springs 32 []
694727 October 30, 2019 - 13:59:38 UTC 38.17346 -120.9587 Valley Springs 32 []
694728 October 30, 2019 - 13:59:38 UTC 38.17081 -120.96223 Valley Springs 32 []
694730 October 30, 2019 - 14:00:15 UTC 38.17347 -120.9596 Valley Springs 32 []
694731 October 30, 2019 - 14:00:15 UTC 38.16387 -120.96348 Valley Springs 32 []
697323 November 01, 2019 - 16:11:08 UTC 38.16652 -120.88095 Valley Springs 32 []
698934 November 04, 2019 - 14:15:00 UTC 38.21608 -120.85563 Valley Springs 32 []
698936 November 04, 2019 - 14:15:36 UTC 38.22355 -120.85607 Valley Springs 32 []
698937 November 04, 2019 - 14:15:00 UTC 38.17081 -120.96223 Valley Springs 32 []
698954 November 04, 2019 - 14:29:52 UTC 38.1704 -120.95904 Valley Springs 32 []
698955 November 04, 2019 - 14:15:00 UTC 38.17081 -120.96223 Valley Springs 32 []
699945 November 05, 2019 - 17:31:48 UTC 38.22774 -120.85223 Valley Springs 32 []
700362 November 06, 2019 - 01:29:11 UTC 38.22774 -120.85223 Valley Springs 32 []
702198 November 08, 2019 - 00:56:40 UTC 38.14644 -120.90745 Valley Springs 32 []
703320 November 09, 2019 - 18:12:52 UTC 38.11094 -120.90962 Valley Springs 32 []
704002 November 10, 2019 - 21:42:52 UTC 38.19608 -120.9325 Valley Springs 32 []
707360 November 15, 2019 - 16:38:58 UTC 38.17333 -120.95717 Valley Springs 32 []
707362 November 15, 2019 - 16:38:55 UTC 38.16784 -120.96038 Valley Springs 32 []
707379 November 15, 2019 - 16:50:36 UTC 38.1704 -120.95904 Valley Springs 32 []
707441 November 15, 2019 - 17:18:55 UTC 38.18454 -120.81786 Valley Springs 32 []
707446 November 15, 2019 - 17:25:42 UTC 38.16558 -120.96351 Valley Springs 32 []
707540 November 15, 2019 - 18:19:00 UTC 38.17807 -120.93562 Valley Springs 32 []
708016 November 16, 2019 - 04:29:17 UTC 38.1779 -120.8914 Valley Springs 32 []
709118 November 18, 2019 - 17:12:07 UTC 38.13491 -120.88796 Valley Springs 32 []
709301 November 18, 2019 - 19:09:48 UTC 38.16803 -120.86014 Valley Springs 32 []
709853 November 19, 2019 - 16:15:59 UTC 38.15079 -120.88236 Valley Springs 32 []
712296 November 21, 2019 - 19:53:33 UTC 38.1535 -120.88279 Valley Springs 32 []
715088 November 26, 2019 - 16:33:58 UTC 38.13877 -120.89315 Valley Springs 32 []
715090 November 26, 2019 - 16:34:15 UTC 38.142 -120.90033 Valley Springs 32 []
715091 November 26, 2019 - 16:34:14 UTC 38.13396 -120.8986 Valley Springs 32 []
715092 November 26, 2019 - 16:34:15 UTC 38.14666 -120.88107 Valley Springs 32 []
715093 November 26, 2019 - 16:35:15 UTC 38.13833 -120.89835 Valley Springs 32 []
715115 November 26, 2019 - 17:01:27 UTC 38.12338 -120.89181 Valley Springs 32 []
717561 November 27, 2019 - 02:50:00 UTC 38.16546 -120.91806 Valley Springs 32 []
717965 November 27, 2019 - 03:33:00 UTC 38.10269 -120.92424 Valley Springs 32 []
719498 November 27, 2019 - 08:03:22 UTC 38.14256 -120.91317 Valley Springs 32 []
720483 November 27, 2019 - 15:50:56 UTC 38.10269 -120.92424 Valley Springs 32 []
720640 November 27, 2019 - 16:36:00 UTC 38.16546 -120.91806 Valley Springs 32 []
724472 November 30, 2019 - 23:07:44 UTC 38.17232 -120.83167 Valley Springs 32 []
727323 December 02, 2019 - 17:51:28 UTC 38.16511 -120.85459 Valley Springs 32 []
728295 December 03, 2019 - 15:17:10 UTC 38.16511 -120.85459 Valley Springs 32 []
729961 December 04, 2019 - 23:19:09 UTC 38.22729 -120.85376 Valley Springs 32 []
730444 December 05, 2019 - 17:51:13 UTC 38.22729 -120.85376 Valley Springs 32 []
730453 December 05, 2019 - 17:53:42 UTC 38.1809 -120.81507 Valley Springs 32 []
731855 December 07, 2019 - 01:09:21 UTC 38.1945 -120.83093 Valley Springs 32 []
733366 December 08, 2019 - 02:45:00 UTC 38.18154 -120.89043 Valley Springs 32 []
733374 December 08, 2019 - 02:59:19 UTC 38.18159 -120.88874 Valley Springs 32 []
735297 December 10, 2019 - 16:42:14 UTC 38.1486 -120.95163 Valley Springs 32 []
736279 December 11, 2019 - 17:02:00 UTC 38.17925 -120.86644 Valley Springs 32 []
736360 December 11, 2019 - 18:00:00 UTC 38.28696 -120.72101 Valley Springs 32 []
736841 December 12, 2019 - 01:32:24 UTC 38.13277 -120.90246 Valley Springs 32 []
737492 December 12, 2019 - 18:22:00 UTC 38.13277 -120.90246 Valley Springs 32 []
741839 December 16, 2019 - 17:37:17 UTC 38.18738 -120.79655 Valley Springs 32 []
780009 February 07, 2020 - 17:43:45 UTC 38.18289 -120.84237 Valley Springs 32 []
780095 February 07, 2020 - 19:04:42 UTC 38.2487 -120.74749 Valley Springs 32 []
780750 February 09, 2020 - 02:07:00 UTC 38.17679 -120.88389 Valley Springs 32 []
783798 February 09, 2020 - 20:25:47 UTC 38.1916 -120.83044 Valley Springs 32 []
784109 February 09, 2020 - 20:58:26 UTC 38.19084 -120.83026 Valley Springs 32 []
785275 February 09, 2020 - 23:30:36 UTC 38.19134 -120.82997 Valley Springs 32 []
786495 February 10, 2020 - 05:02:00 UTC 38.19354 -120.83173 Valley Springs 32 []
688297 October 27, 2019 - 07:25:00 UTC 38.0961 -120.88941 Valley Springs 32 [{"latitude": "38.01229", "longitude": "-120.8356"}, {"latitude": "38.01506", "longitude": "-120.81369"}, {"latitude": "38.02203", "longitude": "-120.80987"}, {"latitude": "38.06711", "longitude": "-120.84689"}, {"latitude": "38.09191", "longitude": "-120.87301"}, {"latitude": "38.09086", "longitude": "-120.88501"}, {"latitude": "38.06428", "longitude": "-120.88821"}, {"latitude": "38.03045", "longitude": "-120.85548"}]
689692 October 27, 2019 - 07:25:00 UTC 38.11554 -120.89312 Valley Springs 32 [{"latitude": "38.10758", "longitude": "-120.89449"}, {"latitude": "38.10866", "longitude": "-120.89134"}, {"latitude": "38.11467", "longitude": "-120.89306"}, {"latitude": "38.11086", "longitude": "-120.89784"}, {"latitude": "38.10841", "longitude": "-120.89798"}, {"latitude": "38.10811", "longitude": "-120.89697"}, {"latitude": "38.10782", "longitude": "-120.89599"}]
689722 October 27, 2019 - 07:25:00 UTC 38.11599 -120.8905 Valley Springs 32 [{"latitude": "38.11098", "longitude": "-120.88077"}, {"latitude": "38.1156", "longitude": "-120.88767"}, {"latitude": "38.11485", "longitude": "-120.89072"}]
686303 October 27, 2019 - 07:15:00 UTC 38.18589 -120.82508 Valley Springs 32 [{"latitude": "38.1154", "longitude": "-120.80029"}, {"latitude": "38.18322", "longitude": "-120.78865"}, {"latitude": "38.1898", "longitude": "-120.78819"}, {"latitude": "38.19264", "longitude": "-120.78818"}, {"latitude": "38.19324", "longitude": "-120.79"}, {"latitude": "38.19298", "longitude": "-120.80786"}, {"latitude": "38.19287", "longitude": "-120.80868"}, {"latitude": "38.18535", "longitude": "-120.82724"}, {"latitude": "38.1634", "longitude": "-120.82959"}, {"latitude": "38.12732", "longitude": "-120.81463"}, {"latitude": "38.12008", "longitude": "-120.8086"}]
686294 October 27, 2019 - 07:15:00 UTC 38.19937 -120.8282 Valley Springs 32 [{"latitude": "38.1154", "longitude": "-120.80029"}, {"latitude": "38.18322", "longitude": "-120.78865"}, {"latitude": "38.1898", "longitude": "-120.78819"}, {"latitude": "38.19264", "longitude": "-120.78818"}, {"latitude": "38.19324", "longitude": "-120.79"}, {"latitude": "38.19588", "longitude": "-120.82931"}, {"latitude": "38.19031", "longitude": "-120.85074"}, {"latitude": "38.12732", "longitude": "-120.81463"}, {"latitude": "38.12008", "longitude": "-120.8086"}]
685706 October 27, 2019 - 07:15:00 UTC 38.19924 -120.71917 Valley Springs 32 [{"latitude": "38.1154", "longitude": "-120.80029"}, {"latitude": "38.20769", "longitude": "-120.69898"}, {"latitude": "38.20833", "longitude": "-120.69843"}, {"latitude": "38.27598", "longitude": "-120.76274"}, {"latitude": "38.28218", "longitude": "-120.77082"}, {"latitude": "38.28174", "longitude": "-120.7774"}, {"latitude": "38.22213", "longitude": "-120.88487"}, {"latitude": "38.19748", "longitude": "-120.8966"}, {"latitude": "38.19694", "longitude": "-120.89676"}, {"latitude": "38.12008", "longitude": "-120.8086"}]
743887 December 17, 2019 - 03:22:25 UTC 38.20061 -120.82695 Valley Springs 32 [{"latitude": "38.1154", "longitude": "-120.80029"}, {"latitude": "38.2487", "longitude": "-120.74749"}, {"latitude": "38.267", "longitude": "-120.75686"}, {"latitude": "38.27598", "longitude": "-120.76274"}, {"latitude": "38.28218", "longitude": "-120.77082"}, {"latitude": "38.28174", "longitude": "-120.7774"}, {"latitude": "38.22213", "longitude": "-120.88487"}, {"latitude": "38.19748", "longitude": "-120.8966"}, {"latitude": "38.19694", "longitude": "-120.89676"}, {"latitude": "38.12008", "longitude": "-120.8086"}]
685980 October 27, 2019 - 07:25:00 UTC 38.11668 -120.89073 Valley Springs 32 [{"latitude": "38.11682", "longitude": "-120.89075"}, {"latitude": "38.12862", "longitude": "-120.88099"}, {"latitude": "38.14666", "longitude": "-120.88107"}, {"latitude": "38.14765", "longitude": "-120.89929"}, {"latitude": "38.14577", "longitude": "-120.9013"}, {"latitude": "38.12992", "longitude": "-120.91443"}, {"latitude": "38.12694", "longitude": "-120.91035"}]
715107 November 26, 2019 - 16:33:27 UTC 38.11668 -120.89073 Valley Springs 32 [{"latitude": "38.11682", "longitude": "-120.89075"}, {"latitude": "38.12862", "longitude": "-120.88099"}, {"latitude": "38.14666", "longitude": "-120.88107"}, {"latitude": "38.14765", "longitude": "-120.89929"}, {"latitude": "38.14577", "longitude": "-120.9013"}, {"latitude": "38.12992", "longitude": "-120.91443"}, {"latitude": "38.12694", "longitude": "-120.91035"}]
652573 October 10, 2019 - 11:21:41 UTC 38.13394 -120.89948 Valley Springs 32 [{"latitude": "38.12603", "longitude": "-120.90751"}, {"latitude": "38.12702", "longitude": "-120.89817"}, {"latitude": "38.12833", "longitude": "-120.89851"}, {"latitude": "38.13277", "longitude": "-120.90246"}, {"latitude": "38.13275", "longitude": "-120.90415"}, {"latitude": "38.12992", "longitude": "-120.91443"}, {"latitude": "38.12694", "longitude": "-120.91035"}]
652929 October 10, 2019 - 11:21:41 UTC 38.12972 -120.90384 Valley Springs 32 [{"latitude": "38.12702", "longitude": "-120.89817"}, {"latitude": "38.12833", "longitude": "-120.89851"}, {"latitude": "38.12817", "longitude": "-120.90047"}, {"latitude": "38.12776", "longitude": "-120.90355"}]
686280 October 27, 2019 - 07:25:00 UTC 38.13395 -120.92554 Valley Springs 32 [{"latitude": "38.13073", "longitude": "-120.90788"}, {"latitude": "38.14876", "longitude": "-120.8701"}, {"latitude": "38.14911", "longitude": "-120.86949"}, {"latitude": "38.15353", "longitude": "-120.86354"}, {"latitude": "38.15498", "longitude": "-120.8616"}, {"latitude": "38.15557", "longitude": "-120.86112"}, {"latitude": "38.15721", "longitude": "-120.87739"}, {"latitude": "38.15991", "longitude": "-120.91202"}, {"latitude": "38.15197", "longitude": "-120.92352"}, {"latitude": "38.13393", "longitude": "-120.92417"}, {"latitude": "38.13203", "longitude": "-120.92327"}]
707239 November 15, 2019 - 14:10:00 UTC 38.13395 -120.92554 Valley Springs 32 [{"latitude": "38.13073", "longitude": "-120.90788"}, {"latitude": "38.14876", "longitude": "-120.8701"}, {"latitude": "38.14911", "longitude": "-120.86949"}, {"latitude": "38.15353", "longitude": "-120.86354"}, {"latitude": "38.15498", "longitude": "-120.8616"}, {"latitude": "38.15557", "longitude": "-120.86112"}, {"latitude": "38.15721", "longitude": "-120.87739"}, {"latitude": "38.15991", "longitude": "-120.91202"}, {"latitude": "38.15197", "longitude": "-120.92352"}, {"latitude": "38.13393", "longitude": "-120.92417"}, {"latitude": "38.13203", "longitude": "-120.92327"}]
715089 November 26, 2019 - 16:33:27 UTC 38.13974 -120.89016 Valley Springs 32 [{"latitude": "38.13193", "longitude": "-120.88813"}, {"latitude": "38.13729", "longitude": "-120.88719"}, {"latitude": "38.13906", "longitude": "-120.88752"}, {"latitude": "38.1409", "longitude": "-120.88814"}, {"latitude": "38.13835", "longitude": "-120.88904"}, {"latitude": "38.13222", "longitude": "-120.88827"}]

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
)
Powered by Datasette · Query took 755.873ms · About: About this site