outages

166 rows where regionName = 36

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices
633505 October 01, 2019 - 07:15:17 UTC 37.66473 -121.92102 Pleasanton 36 []
641433 October 03, 2019 - 22:11:32 UTC 37.66409 -121.85921 Pleasanton 36 []
645523 October 06, 2019 - 12:00:45 UTC 37.67289 -121.83101 Pleasanton 36 []
647549 October 08, 2019 - 21:17:00 UTC 37.68943 -121.88024 Pleasanton 36 []
650901 October 09, 2019 - 18:21:40 UTC 37.63338 -121.87636 Pleasanton 36 []
651833 October 10, 2019 - 01:53:31 UTC 37.65232 -121.88361 Pleasanton 36 []
652552 October 10, 2019 - 09:37:00 UTC 37.69363 -121.89635 Pleasanton 36 []
653316 October 10, 2019 - 20:16:36 UTC 37.69498 -121.95814 Pleasanton 36 []
654599 October 11, 2019 - 21:43:51 UTC 37.69095 -121.89282 Pleasanton 36 []
654600 October 11, 2019 - 21:44:00 UTC 37.69299 -121.89299 Pleasanton 36 []
655510 October 13, 2019 - 14:33:00 UTC 37.69114 -121.88696 Pleasanton 36 []
655624 October 13, 2019 - 21:33:47 UTC 37.69114 -121.88696 Pleasanton 36 []
660649 October 16, 2019 - 16:35:41 UTC 37.67794 -121.88057 Pleasanton 36 [{"latitude": "37.67915", "longitude": "-121.8803"}, {"latitude": "37.67996", "longitude": "-121.87753"}, {"latitude": "37.68082", "longitude": "-121.8764"}, {"latitude": "37.6812", "longitude": "-121.87809"}, {"latitude": "37.68086", "longitude": "-121.8808"}, {"latitude": "37.67924", "longitude": "-121.88058"}]
667429 October 18, 2019 - 14:45:00 UTC 37.68147 -121.91012 Pleasanton 36 []
667430 October 18, 2019 - 14:53:10 UTC 37.68468 -121.93446 Pleasanton 36 []
667453 October 18, 2019 - 14:58:00 UTC 37.67008 -121.91437 Pleasanton 36 []
667454 October 18, 2019 - 14:59:00 UTC 37.67548 -121.91552 Pleasanton 36 []
667633 October 18, 2019 - 15:15:20 UTC 37.65764 -121.91082 Pleasanton 36 []
674977 October 21, 2019 - 05:17:00 UTC 37.66882 -121.85845 Pleasanton 36 []
675972 October 21, 2019 - 16:35:57 UTC 37.63434 -121.89143 Pleasanton 36 []
675976 October 21, 2019 - 16:42:00 UTC 37.63691 -121.89278 Pleasanton 36 [{"latitude": "37.63638", "longitude": "-121.89177"}, {"latitude": "37.63781", "longitude": "-121.89291"}, {"latitude": "37.63704", "longitude": "-121.89235"}]
676003 October 21, 2019 - 16:56:00 UTC 37.63673 -121.89335 Pleasanton 36 []
676193 October 21, 2019 - 19:35:46 UTC 37.6911 -121.87532 Pleasanton 36 []
676416 October 21, 2019 - 22:43:43 UTC 37.6396 -121.80902 Pleasanton 36 []
676814 October 22, 2019 - 17:08:00 UTC 37.63071 -121.88885 Pleasanton 36 []
676892 October 22, 2019 - 18:45:49 UTC 37.67892 -121.88383 Pleasanton 36 []
677479 October 23, 2019 - 16:30:38 UTC 37.66935 -121.85848 Pleasanton 36 []
677745 October 23, 2019 - 21:19:52 UTC 37.67695 -121.87638 Pleasanton 36 []
678873 October 23, 2019 - 23:44:06 UTC 37.64735 -121.81897 Pleasanton 36 []
680159 October 25, 2019 - 05:17:01 UTC 37.70075 -121.87959 Pleasanton 36 [{"latitude": "37.69951", "longitude": "-121.88478"}, {"latitude": "37.70069", "longitude": "-121.87974"}, {"latitude": "37.70098", "longitude": "-121.88601"}, {"latitude": "37.70059", "longitude": "-121.88646"}]
680161 October 25, 2019 - 05:28:09 UTC 37.69762 -121.88821 Pleasanton 36 []
680174 October 25, 2019 - 11:37:50 UTC 37.69762 -121.88821 Pleasanton 36 []
680768 October 26, 2019 - 15:21:30 UTC 37.70021 -121.9002 Pleasanton 36 []
682727 October 27, 2019 - 02:15:54 UTC 37.69448 -121.86441 Pleasanton 36 []
683378 October 27, 2019 - 03:17:43 UTC 37.69767 -121.94205 Pleasanton 36 [{"latitude": "37.68371", "longitude": "-121.96798"}, {"latitude": "37.68849", "longitude": "-121.94444"}, {"latitude": "37.69316", "longitude": "-121.93876"}, {"latitude": "37.69403", "longitude": "-121.93919"}, {"latitude": "37.69769", "longitude": "-121.94281"}, {"latitude": "37.72646", "longitude": "-121.99548"}, {"latitude": "37.72623", "longitude": "-121.99861"}, {"latitude": "37.72576", "longitude": "-122.00112"}, {"latitude": "37.71872", "longitude": "-122.01031"}, {"latitude": "37.7084", "longitude": "-122.01875"}, {"latitude": "37.70394", "longitude": "-122.02126"}, {"latitude": "37.69938", "longitude": "-122.02033"}, {"latitude": "37.68424", "longitude": "-121.97024"}]
683782 October 27, 2019 - 03:39:50 UTC 37.69367 -121.8803 Pleasanton 36 []
683904 October 27, 2019 - 03:46:42 UTC 37.66464 -121.91619 Pleasanton 36 [{"latitude": "37.65844", "longitude": "-121.93278"}, {"latitude": "37.65908", "longitude": "-121.92698"}, {"latitude": "37.65951", "longitude": "-121.92413"}, {"latitude": "37.6656", "longitude": "-121.91089"}, {"latitude": "37.66636", "longitude": "-121.91007"}, {"latitude": "37.68597", "longitude": "-121.90898"}, {"latitude": "37.68645", "longitude": "-121.91026"}, {"latitude": "37.69502", "longitude": "-121.94088"}, {"latitude": "37.68702", "longitude": "-121.94407"}]
684291 October 27, 2019 - 04:21:37 UTC 37.63672 -121.88107 Pleasanton 36 [{"latitude": "37.62843", "longitude": "-121.86996"}, {"latitude": "37.63072", "longitude": "-121.86828"}, {"latitude": "37.63141", "longitude": "-121.86888"}, {"latitude": "37.63676", "longitude": "-121.87518"}, {"latitude": "37.63987", "longitude": "-121.87887"}, {"latitude": "37.64015", "longitude": "-121.88078"}, {"latitude": "37.63949", "longitude": "-121.88082"}, {"latitude": "37.6376", "longitude": "-121.88046"}, {"latitude": "37.63444", "longitude": "-121.87975"}, {"latitude": "37.63064", "longitude": "-121.8751"}]
684387 October 27, 2019 - 04:33:39 UTC 37.64346 -121.87817 Pleasanton 36 [{"latitude": "37.62655", "longitude": "-121.8602"}, {"latitude": "37.62783", "longitude": "-121.86009"}, {"latitude": "37.63523", "longitude": "-121.86009"}, {"latitude": "37.64186", "longitude": "-121.86462"}, {"latitude": "37.64414", "longitude": "-121.87692"}, {"latitude": "37.64338", "longitude": "-121.87799"}, {"latitude": "37.63884", "longitude": "-121.88029"}, {"latitude": "37.62968", "longitude": "-121.86713"}, {"latitude": "37.62877", "longitude": "-121.86579"}]
684527 October 27, 2019 - 04:51:38 UTC 37.63867 -121.88663 Pleasanton 36 [{"latitude": "37.62799", "longitude": "-121.90138"}, {"latitude": "37.62848", "longitude": "-121.89587"}, {"latitude": "37.62951", "longitude": "-121.89346"}, {"latitude": "37.63158", "longitude": "-121.88953"}, {"latitude": "37.63675", "longitude": "-121.88372"}, {"latitude": "37.64491", "longitude": "-121.8927"}, {"latitude": "37.64157", "longitude": "-121.89703"}, {"latitude": "37.63314", "longitude": "-121.90439"}]
684830 October 27, 2019 - 05:11:10 UTC 37.64024 -121.88377 Pleasanton 36 []
684944 October 27, 2019 - 04:28:07 UTC 37.68147 -121.91012 Pleasanton 36 []
685140 October 27, 2019 - 05:34:00 UTC 37.66085 -121.83286 Pleasanton 36 []
685430 October 27, 2019 - 05:48:00 UTC 37.65574 -121.90878 Pleasanton 36 []
685437 October 27, 2019 - 05:56:00 UTC 37.65664 -121.90938 Pleasanton 36 []
685467 October 27, 2019 - 06:16:57 UTC 37.65758 -121.83089 Pleasanton 36 []
685496 October 27, 2019 - 06:22:24 UTC 37.6603 -121.91536 Pleasanton 36 []
685619 October 27, 2019 - 06:43:00 UTC 37.65505 -121.82405 Pleasanton 36 [{"latitude": "37.65106", "longitude": "-121.82514"}, {"latitude": "37.65203", "longitude": "-121.82417"}, {"latitude": "37.65422", "longitude": "-121.82411"}, {"latitude": "37.65397", "longitude": "-121.82693"}]
687612 October 27, 2019 - 17:05:00 UTC 37.64273 -121.86961 Pleasanton 36 []
689421 October 27, 2019 - 21:23:16 UTC 37.66833 -121.87311 Pleasanton 36 []
690449 October 28, 2019 - 00:33:10 UTC 37.65758 -121.83089 Pleasanton 36 []
691574 October 28, 2019 - 16:59:38 UTC 37.65758 -121.83089 Pleasanton 36 []
691724 October 28, 2019 - 18:32:11 UTC 37.69989 -121.87698 Pleasanton 36 []
691739 October 27, 2019 - 06:10:00 UTC 37.65967 -121.91132 Pleasanton 36 []
691741 October 27, 2019 - 06:16:00 UTC 37.66267 -121.91425 Pleasanton 36 []
691766 October 28, 2019 - 19:04:00 UTC 37.69627 -121.92865 Pleasanton 36 []
691829 October 28, 2019 - 19:40:00 UTC 37.68468 -121.93446 Pleasanton 36 []
693729 October 29, 2019 - 17:30:50 UTC 37.63691 -121.89278 Pleasanton 36 [{"latitude": "37.63638", "longitude": "-121.89177"}, {"latitude": "37.63781", "longitude": "-121.89291"}, {"latitude": "37.63704", "longitude": "-121.89235"}]
694022 October 29, 2019 - 19:48:18 UTC 37.67323 -121.89254 Pleasanton 36 []
694776 October 30, 2019 - 14:40:50 UTC 37.65781 -121.87339 Pleasanton 36 []
695092 October 30, 2019 - 17:50:16 UTC 37.70059 -121.88646 Pleasanton 36 []
697671 November 01, 2019 - 21:07:27 UTC 37.6697 -121.88446 Pleasanton 36 []
699516 November 04, 2019 - 23:34:07 UTC 37.66358 -121.87917 Pleasanton 36 []
699672 November 05, 2019 - 04:14:16 UTC 37.6969 -121.94825 Pleasanton 36 []
699955 November 05, 2019 - 17:42:23 UTC 37.66302 -121.87702 Pleasanton 36 []
699959 November 05, 2019 - 17:46:50 UTC 37.67775 -121.92072 Pleasanton 36 []
700435 November 06, 2019 - 05:46:01 UTC 37.66273 -121.88109 Pleasanton 36 []
700461 November 06, 2019 - 10:53:53 UTC 37.67845 -121.86159 Pleasanton 36 []
700532 November 06, 2019 - 15:55:35 UTC 37.67845 -121.86159 Pleasanton 36 []
702002 November 07, 2019 - 21:01:04 UTC 37.65982 -121.87213 Pleasanton 36 []
703119 November 09, 2019 - 04:17:01 UTC 37.66226 -121.87742 Pleasanton 36 []
703936 November 10, 2019 - 18:34:09 UTC 37.66408 -121.87896 Pleasanton 36 []
704012 November 10, 2019 - 21:56:00 UTC 37.65417 -121.8106 Pleasanton 36 [{"latitude": "37.62498", "longitude": "-121.80902"}, {"latitude": "37.62649", "longitude": "-121.79117"}, {"latitude": "37.6317", "longitude": "-121.78475"}, {"latitude": "37.63203", "longitude": "-121.78488"}, {"latitude": "37.64015", "longitude": "-121.78967"}, {"latitude": "37.65499", "longitude": "-121.81275"}, {"latitude": "37.64822", "longitude": "-121.82129"}, {"latitude": "37.6459", "longitude": "-121.82268"}, {"latitude": "37.6431", "longitude": "-121.82293"}]
704044 November 10, 2019 - 21:56:00 UTC 37.65304 -121.81291 Pleasanton 36 [{"latitude": "37.6417", "longitude": "-121.82127"}, {"latitude": "37.64235", "longitude": "-121.81762"}, {"latitude": "37.64707", "longitude": "-121.81293"}, {"latitude": "37.64822", "longitude": "-121.82129"}, {"latitude": "37.6459", "longitude": "-121.82268"}, {"latitude": "37.6431", "longitude": "-121.82293"}]
705878 November 13, 2019 - 16:35:20 UTC 37.68865 -121.89358 Pleasanton 36 []
705914 November 13, 2019 - 17:00:00 UTC 37.69099 -121.92643 Pleasanton 36 []
705996 November 13, 2019 - 17:40:27 UTC 37.6729 -121.89211 Pleasanton 36 []
706244 November 13, 2019 - 21:23:24 UTC 37.66061 -121.87418 Pleasanton 36 []
706781 November 14, 2019 - 18:11:04 UTC 37.63741 -121.87356 Pleasanton 36 []
707231 November 15, 2019 - 11:31:00 UTC 37.69767 -121.94205 Pleasanton 36 [{"latitude": "37.68371", "longitude": "-121.96798"}, {"latitude": "37.68849", "longitude": "-121.94444"}, {"latitude": "37.69316", "longitude": "-121.93876"}, {"latitude": "37.69403", "longitude": "-121.93919"}, {"latitude": "37.69769", "longitude": "-121.94281"}, {"latitude": "37.72646", "longitude": "-121.99548"}, {"latitude": "37.72623", "longitude": "-121.99861"}, {"latitude": "37.72576", "longitude": "-122.00112"}, {"latitude": "37.71872", "longitude": "-122.01031"}, {"latitude": "37.7084", "longitude": "-122.01875"}, {"latitude": "37.70394", "longitude": "-122.02126"}, {"latitude": "37.69938", "longitude": "-122.02033"}, {"latitude": "37.68424", "longitude": "-121.97024"}]
708533 November 17, 2019 - 06:42:00 UTC 37.65806 -121.87734 Pleasanton 36 [{"latitude": "37.65728", "longitude": "-121.8783"}, {"latitude": "37.65732", "longitude": "-121.87784"}, {"latitude": "37.6586", "longitude": "-121.87648"}, {"latitude": "37.65889", "longitude": "-121.87639"}, {"latitude": "37.65885", "longitude": "-121.87696"}, {"latitude": "37.65806", "longitude": "-121.87799"}, {"latitude": "37.65766", "longitude": "-121.87822"}]
708539 November 17, 2019 - 08:00:37 UTC 37.65806 -121.87734 Pleasanton 36 [{"latitude": "37.65728", "longitude": "-121.8783"}, {"latitude": "37.65732", "longitude": "-121.87784"}, {"latitude": "37.6586", "longitude": "-121.87648"}, {"latitude": "37.65889", "longitude": "-121.87639"}, {"latitude": "37.65885", "longitude": "-121.87696"}, {"latitude": "37.65806", "longitude": "-121.87799"}, {"latitude": "37.65766", "longitude": "-121.87822"}]
708567 November 17, 2019 - 13:40:11 UTC 37.65766 -121.87822 Pleasanton 36 []
708568 November 17, 2019 - 13:40:10 UTC 37.65809 -121.87737 Pleasanton 36 []
708569 November 17, 2019 - 14:03:17 UTC 37.65866 -121.87935 Pleasanton 36 []
708570 November 17, 2019 - 14:28:22 UTC 37.65865 -121.878 Pleasanton 36 []
708775 November 18, 2019 - 00:26:01 UTC 37.65885 -121.87696 Pleasanton 36 []
709773 November 19, 2019 - 13:40:43 UTC 37.6628 -121.87884 Pleasanton 36 []
710155 November 19, 2019 - 19:40:08 UTC 37.67386 -121.87078 Pleasanton 36 []
711683 November 20, 2019 - 21:50:01 UTC 37.64735 -121.87709 Pleasanton 36 []
711721 November 20, 2019 - 22:39:28 UTC 37.66404 -121.86607 Pleasanton 36 []
712034 November 21, 2019 - 16:46:19 UTC 37.65551 -121.82415 Pleasanton 36 [{"latitude": "37.65106", "longitude": "-121.82514"}, {"latitude": "37.65203", "longitude": "-121.82417"}, {"latitude": "37.65509", "longitude": "-121.82355"}, {"latitude": "37.65397", "longitude": "-121.82693"}]
713517 November 23, 2019 - 20:20:30 UTC 37.6847 -121.88811 Pleasanton 36 []
716805 November 27, 2019 - 01:36:24 UTC 37.67209 -121.88627 Pleasanton 36 [{"latitude": "37.67046", "longitude": "-121.88432"}, {"latitude": "37.67183", "longitude": "-121.88637"}, {"latitude": "37.67135", "longitude": "-121.88575"}, {"latitude": "37.67113", "longitude": "-121.8854"}, {"latitude": "37.67081", "longitude": "-121.88489"}]
717698 November 27, 2019 - 03:04:44 UTC 37.65434 -121.86613 Pleasanton 36 []
722474 November 28, 2019 - 07:11:00 UTC 37.66404 -121.86607 Pleasanton 36 []
727212 December 02, 2019 - 16:51:26 UTC 37.67772 -121.90786 Pleasanton 36 []
727266 December 02, 2019 - 17:23:02 UTC 37.66026 -121.87867 Pleasanton 36 []
727561 December 02, 2019 - 19:54:06 UTC 37.66128 -121.86065 Pleasanton 36 []
727894 December 03, 2019 - 00:30:23 UTC 37.69323 -121.89077 Pleasanton 36 []

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