outages

62 rows where regionName = 17 sorted by regionName

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName ▼ outageDevices
631014 September 30, 2019 - 16:49:43 UTC 39.0775 -121.52568 Olivehurst 17 []
643761 October 04, 2019 - 22:57:01 UTC 39.07668 -121.54332 Olivehurst 17 []
645946 October 07, 2019 - 16:32:00 UTC 39.10283 -121.56533 Olivehurst 17 []
650719 October 09, 2019 - 15:02:00 UTC 39.03261 -121.58668 Olivehurst 17 []
650843 October 09, 2019 - 17:10:20 UTC 39.07775 -121.54728 Olivehurst 17 [{"latitude": "39.07759", "longitude": "-121.54955"}, {"latitude": "39.0782", "longitude": "-121.54398"}, {"latitude": "39.07887", "longitude": "-121.54725"}, {"latitude": "39.07907", "longitude": "-121.54957"}, {"latitude": "39.07808", "longitude": "-121.55123"}]
650845 October 09, 2019 - 17:13:38 UTC 39.0777 -121.54728 Olivehurst 17 []
651781 October 10, 2019 - 01:37:04 UTC 39.04832 -121.56958 Olivehurst 17 []
654598 October 11, 2019 - 21:42:24 UTC 39.08093 -121.53222 Olivehurst 17 []
659988 October 16, 2019 - 04:57:31 UTC 39.07718 -121.54444 Olivehurst 17 [{"latitude": "39.0696", "longitude": "-121.54476"}, {"latitude": "39.07175", "longitude": "-121.54222"}, {"latitude": "39.07643", "longitude": "-121.54369"}, {"latitude": "39.07699", "longitude": "-121.54451"}, {"latitude": "39.07541", "longitude": "-121.54589"}, {"latitude": "39.07026", "longitude": "-121.54558"}]
659989 October 16, 2019 - 04:57:31 UTC 39.07726 -121.54441 Olivehurst 17 []
664108 October 17, 2019 - 16:24:00 UTC 39.07869 -121.54956 Olivehurst 17 []
664109 October 17, 2019 - 16:24:00 UTC 39.07839 -121.54955 Olivehurst 17 []
677232 October 23, 2019 - 03:36:20 UTC 39.08618 -121.56106 Olivehurst 17 []
679794 October 24, 2019 - 21:41:40 UTC 39.08063 -121.5496 Olivehurst 17 []
679959 October 25, 2019 - 00:19:41 UTC 39.07704 -121.53887 Olivehurst 17 []
685717 October 27, 2019 - 07:18:29 UTC 39.10952 -121.55677 Olivehurst 17 [{"latitude": "39.10657", "longitude": "-121.55921"}, {"latitude": "39.1066", "longitude": "-121.55711"}, {"latitude": "39.10757", "longitude": "-121.5561"}, {"latitude": "39.10962", "longitude": "-121.55725"}, {"latitude": "39.11015", "longitude": "-121.56097"}, {"latitude": "39.10848", "longitude": "-121.56055"}, {"latitude": "39.10706", "longitude": "-121.55977"}]
687752 October 27, 2019 - 17:34:00 UTC 39.09201 -121.54284 Olivehurst 17 [{"latitude": "39.08328", "longitude": "-121.45807"}, {"latitude": "39.08344", "longitude": "-121.45209"}, {"latitude": "39.09391", "longitude": "-121.43229"}, {"latitude": "39.1005", "longitude": "-121.43093"}, {"latitude": "39.12742", "longitude": "-121.43873"}, {"latitude": "39.14696", "longitude": "-121.47774"}, {"latitude": "39.14768", "longitude": "-121.48636"}, {"latitude": "39.12405", "longitude": "-121.57368"}, {"latitude": "39.11232", "longitude": "-121.58835"}, {"latitude": "39.10583", "longitude": "-121.5799"}, {"latitude": "39.09596", "longitude": "-121.54613"}, {"latitude": "39.08339", "longitude": "-121.46291"}]
687794 October 27, 2019 - 17:48:15 UTC 39.09352 -121.55382 Olivehurst 17 []
687918 October 27, 2019 - 18:03:00 UTC 39.09545 -121.54613 Olivehurst 17 []
688946 October 27, 2019 - 20:39:58 UTC 39.08 -121.54956 Olivehurst 17 []
689774 October 27, 2019 - 22:03:49 UTC 39.06795 -121.55833 Olivehurst 17 []
692046 October 28, 2019 - 21:36:02 UTC 39.07026 -121.54558 Olivehurst 17 []
695534 October 30, 2019 - 21:56:26 UTC 39.04565 -121.58332 Olivehurst 17 []
696404 October 31, 2019 - 15:04:39 UTC 39.08029 -121.55069 Olivehurst 17 []
697423 November 01, 2019 - 17:49:52 UTC 39.06074 -121.57865 Olivehurst 17 []
699385 November 04, 2019 - 21:00:00 UTC 39.09119 -121.53923 Olivehurst 17 []
699429 November 04, 2019 - 21:39:57 UTC 39.09232 -121.55628 Olivehurst 17 []
699608 November 05, 2019 - 01:36:11 UTC 39.09707 -121.55621 Olivehurst 17 []
700619 November 06, 2019 - 16:40:45 UTC 39.06306 -121.56075 Olivehurst 17 []
704433 November 11, 2019 - 20:55:52 UTC 39.09206 -121.54827 Olivehurst 17 []
705881 November 13, 2019 - 16:42:11 UTC 39.04603 -121.56729 Olivehurst 17 []
707398 November 15, 2019 - 16:58:00 UTC 39.09983 -121.55166 Olivehurst 17 [{"latitude": "39.10028", "longitude": "-121.55157"}, {"latitude": "39.10184", "longitude": "-121.55157"}, {"latitude": "39.10172", "longitude": "-121.55237"}, {"latitude": "39.10099", "longitude": "-121.5526"}]
707926 November 16, 2019 - 00:00:00 UTC 39.09983 -121.55166 Olivehurst 17 [{"latitude": "39.10028", "longitude": "-121.55157"}, {"latitude": "39.10184", "longitude": "-121.55157"}, {"latitude": "39.10172", "longitude": "-121.55237"}, {"latitude": "39.10099", "longitude": "-121.5526"}]
710117 November 19, 2019 - 19:10:44 UTC 39.07851 -121.55234 Olivehurst 17 []
710398 November 20, 2019 - 00:02:00 UTC 39.07794 -121.55206 Olivehurst 17 [{"latitude": "39.07753", "longitude": "-121.55325"}, {"latitude": "39.07959", "longitude": "-121.55416"}, {"latitude": "39.07839", "longitude": "-121.55387"}]
710428 November 20, 2019 - 00:48:27 UTC 39.09992 -121.55731 Olivehurst 17 []
711583 November 20, 2019 - 20:24:04 UTC 39.09525 -121.54911 Olivehurst 17 []
711700 November 20, 2019 - 22:15:57 UTC 39.07372 -121.54735 Olivehurst 17 []
711749 November 20, 2019 - 22:55:56 UTC 39.08963 -121.55164 Olivehurst 17 []
713887 November 24, 2019 - 20:29:09 UTC 39.07645 -121.54726 Olivehurst 17 []
714379 November 25, 2019 - 19:39:54 UTC 39.09904 -121.54645 Olivehurst 17 []
717225 November 27, 2019 - 02:18:00 UTC 39.04748 -121.56484 Olivehurst 17 [{"latitude": "39.03846", "longitude": "-121.56428"}, {"latitude": "39.03858", "longitude": "-121.56244"}, {"latitude": "39.03908", "longitude": "-121.56197"}, {"latitude": "39.04147", "longitude": "-121.56182"}, {"latitude": "39.04791", "longitude": "-121.5649"}, {"latitude": "39.04315", "longitude": "-121.56589"}, {"latitude": "39.03958", "longitude": "-121.56533"}]
720592 November 27, 2019 - 02:18:00 UTC 39.04055 -121.56485 Olivehurst 17 [{"latitude": "39.03846", "longitude": "-121.56428"}, {"latitude": "39.03858", "longitude": "-121.56244"}, {"latitude": "39.03908", "longitude": "-121.56197"}, {"latitude": "39.03999", "longitude": "-121.56295"}, {"latitude": "39.04032", "longitude": "-121.56477"}, {"latitude": "39.03958", "longitude": "-121.56533"}]
720674 November 27, 2019 - 16:48:13 UTC 39.09801 -121.55075 Olivehurst 17 []
721326 November 27, 2019 - 19:14:24 UTC 39.10448 -121.55781 Olivehurst 17 []
721410 November 27, 2019 - 19:43:44 UTC 39.09801 -121.55075 Olivehurst 17 []
724171 November 30, 2019 - 19:08:02 UTC 39.03356 -121.56267 Olivehurst 17 []
727443 December 02, 2019 - 18:57:28 UTC 39.09539 -121.55928 Olivehurst 17 [{"latitude": "39.09232", "longitude": "-121.55868"}, {"latitude": "39.09373", "longitude": "-121.55895"}, {"latitude": "39.09497", "longitude": "-121.5592"}, {"latitude": "39.09292", "longitude": "-121.5588"}]
727547 December 02, 2019 - 19:43:14 UTC 39.09535 -121.55419 Olivehurst 17 [{"latitude": "39.08137", "longitude": "-121.56898"}, {"latitude": "39.08418", "longitude": "-121.56219"}, {"latitude": "39.08746", "longitude": "-121.55922"}, {"latitude": "39.09515", "longitude": "-121.55257"}, {"latitude": "39.09733", "longitude": "-121.55388"}, {"latitude": "39.10069", "longitude": "-121.56072"}, {"latitude": "39.09439", "longitude": "-121.57399"}, {"latitude": "39.09365", "longitude": "-121.57395"}, {"latitude": "39.08582", "longitude": "-121.57156"}]
727883 December 03, 2019 - 00:23:33 UTC 39.10271 -121.56073 Olivehurst 17 []
727884 December 03, 2019 - 00:23:33 UTC 39.10439 -121.56077 Olivehurst 17 []
727885 December 03, 2019 - 00:23:38 UTC 39.10282 -121.56678 Olivehurst 17 []
728770 December 03, 2019 - 19:55:08 UTC 39.04395 -121.58808 Olivehurst 17 []
731425 December 06, 2019 - 18:11:53 UTC 39.06365 -121.58506 Olivehurst 17 []
733857 December 08, 2019 - 21:52:05 UTC 39.09984 -121.55302 Olivehurst 17 []
735934 December 11, 2019 - 01:32:11 UTC 39.03975 -121.56384 Olivehurst 17 []
779258 February 06, 2020 - 18:40:00 UTC 39.09166 -121.55226 Olivehurst 17 [{"latitude": "39.08849", "longitude": "-121.55642"}, {"latitude": "39.09169", "longitude": "-121.55269"}, {"latitude": "39.09426", "longitude": "-121.55156"}, {"latitude": "39.09413", "longitude": "-121.557"}, {"latitude": "39.09177", "longitude": "-121.55685"}]
779457 February 06, 2020 - 21:14:00 UTC 39.08987 -121.55224 Olivehurst 17 [{"latitude": "39.08921", "longitude": "-121.55336"}, {"latitude": "39.08987", "longitude": "-121.55261"}, {"latitude": "39.08991", "longitude": "-121.55414"}, {"latitude": "39.08993", "longitude": "-121.55504"}, {"latitude": "39.08994", "longitude": "-121.55581"}]
779459 February 06, 2020 - 21:15:42 UTC 39.08884 -121.55175 Olivehurst 17 [{"latitude": "39.08546", "longitude": "-121.5518"}, {"latitude": "39.08654", "longitude": "-121.55175"}, {"latitude": "39.08772", "longitude": "-121.55171"}, {"latitude": "39.08891", "longitude": "-121.55171"}]
779632 February 07, 2020 - 01:11:17 UTC 39.10756 -121.55832 Olivehurst 17 []
787089 February 10, 2020 - 16:42:00 UTC 39.08363 -121.54969 Olivehurst 17 [{"latitude": "39.08", "longitude": "-121.54956"}, {"latitude": "39.08255", "longitude": "-121.54963"}, {"latitude": "39.083", "longitude": "-121.54965"}, {"latitude": "39.08152", "longitude": "-121.54962"}, {"latitude": "39.08063", "longitude": "-121.5496"}]
787330 February 10, 2020 - 18:39:00 UTC 39.08374 -121.55011 Olivehurst 17 []

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 456.015ms · About: About this site