outages

438 rows where regionName = 29 sorted by longitude

View and edit SQL

outageDevices

id outageStartTime latitude longitude ▼ regionName outageDevices
1062037 September 09, 2020 - 17:53:56 UTC 37.52985 -122.27763 San Mateo 29 []
719214 November 27, 2019 - 06:28:24 UTC 37.5313 -122.27828 San Mateo 29 []
721294 November 27, 2019 - 19:09:00 UTC 37.5313 -122.27828 San Mateo 29 []
676027 October 21, 2019 - 17:13:00 UTC 37.5426 -122.27855 San Mateo 29 [{"latitude": "37.53924", "longitude": "-122.28131"}, {"latitude": "37.53958", "longitude": "-122.2802"}, {"latitude": "37.54055", "longitude": "-122.27935"}, {"latitude": "37.54198", "longitude": "-122.27925"}, {"latitude": "37.54295", "longitude": "-122.27926"}, {"latitude": "37.54267", "longitude": "-122.27985"}, {"latitude": "37.54108", "longitude": "-122.283"}, {"latitude": "37.53983", "longitude": "-122.28186"}]
707442 November 15, 2019 - 17:23:52 UTC 37.5426 -122.27855 San Mateo 29 [{"latitude": "37.53924", "longitude": "-122.28131"}, {"latitude": "37.53958", "longitude": "-122.2802"}, {"latitude": "37.54055", "longitude": "-122.27935"}, {"latitude": "37.54198", "longitude": "-122.27925"}, {"latitude": "37.54295", "longitude": "-122.27926"}, {"latitude": "37.54267", "longitude": "-122.27985"}, {"latitude": "37.54108", "longitude": "-122.283"}, {"latitude": "37.53983", "longitude": "-122.28186"}]
787819 February 10, 2020 - 23:47:54 UTC 37.54229 -122.28011 San Mateo 29 []
707305 November 15, 2019 - 15:56:00 UTC 37.53958 -122.2802 San Mateo 29 []
701531 November 07, 2019 - 15:03:02 UTC 37.54581 -122.28051 San Mateo 29 []
702622 November 08, 2019 - 17:20:26 UTC 37.54581 -122.28051 San Mateo 29 []
702754 November 08, 2019 - 18:53:00 UTC 37.54581 -122.28051 San Mateo 29 []
702773 November 08, 2019 - 19:13:01 UTC 37.54581 -122.28051 San Mateo 29 []
702881 November 08, 2019 - 21:25:00 UTC 37.54581 -122.28051 San Mateo 29 []
703116 November 09, 2019 - 04:07:00 UTC 37.54581 -122.28051 San Mateo 29 []
703285 November 09, 2019 - 17:24:00 UTC 37.54581 -122.28051 San Mateo 29 []
703393 November 09, 2019 - 20:01:00 UTC 37.54581 -122.28051 San Mateo 29 []
703749 November 10, 2019 - 04:09:00 UTC 37.54581 -122.28051 San Mateo 29 []
1062132 September 09, 2020 - 19:50:47 UTC 37.53166 -122.2815 San Mateo 29 [{"latitude": "37.52793", "longitude": "-122.27312"}, {"latitude": "37.52996", "longitude": "-122.27522"}, {"latitude": "37.53293", "longitude": "-122.27864"}, {"latitude": "37.53326", "longitude": "-122.27954"}, {"latitude": "37.53315", "longitude": "-122.28055"}, {"latitude": "37.53127", "longitude": "-122.28123"}, {"latitude": "37.52852", "longitude": "-122.27656"}, {"latitude": "37.52823", "longitude": "-122.27508"}]
707386 November 15, 2019 - 16:55:32 UTC 37.55921 -122.2818 San Mateo 29 []
677470 October 23, 2019 - 16:20:13 UTC 37.53855 -122.28183 San Mateo 29 []
707345 November 15, 2019 - 16:26:00 UTC 37.53938 -122.2826 San Mateo 29 []
675834 October 21, 2019 - 15:36:02 UTC 37.54632 -122.28298 San Mateo 29 []
677602 October 23, 2019 - 18:47:00 UTC 37.54616 -122.28338 San Mateo 29 [{"latitude": "37.53924", "longitude": "-122.28131"}, {"latitude": "37.53958", "longitude": "-122.2802"}, {"latitude": "37.54058", "longitude": "-122.27833"}, {"latitude": "37.54327", "longitude": "-122.2784"}, {"latitude": "37.54581", "longitude": "-122.28051"}, {"latitude": "37.54571", "longitude": "-122.28207"}, {"latitude": "37.54565", "longitude": "-122.28291"}, {"latitude": "37.54527", "longitude": "-122.2833"}, {"latitude": "37.54108", "longitude": "-122.283"}, {"latitude": "37.53983", "longitude": "-122.28186"}]
707311 November 15, 2019 - 15:56:00 UTC 37.54616 -122.28338 San Mateo 29 [{"latitude": "37.53924", "longitude": "-122.28131"}, {"latitude": "37.53958", "longitude": "-122.2802"}, {"latitude": "37.54058", "longitude": "-122.27833"}, {"latitude": "37.54327", "longitude": "-122.2784"}, {"latitude": "37.54581", "longitude": "-122.28051"}, {"latitude": "37.54571", "longitude": "-122.28207"}, {"latitude": "37.54565", "longitude": "-122.28291"}, {"latitude": "37.54527", "longitude": "-122.2833"}, {"latitude": "37.54108", "longitude": "-122.283"}, {"latitude": "37.53983", "longitude": "-122.28186"}]
717854 November 27, 2019 - 03:21:31 UTC 37.54658 -122.28382 San Mateo 29 []
655695 October 14, 2019 - 02:08:00 UTC 37.54148 -122.28401 San Mateo 29 []
708100 November 16, 2019 - 15:04:09 UTC 37.5304 -122.28433 San Mateo 29 []
666478 October 17, 2019 - 21:40:54 UTC 37.5461 -122.28464 San Mateo 29 []
779483 February 06, 2020 - 21:44:48 UTC 37.53984 -122.28507 San Mateo 29 []
713873 November 24, 2019 - 18:20:00 UTC 37.54422 -122.28525 San Mateo 29 []
647793 October 09, 2019 - 06:05:29 UTC 37.55112 -122.28621 San Mateo 29 []
1068854 September 14, 2020 - 16:56:22 UTC 37.538 -122.2865 San Mateo 29 []
734005 December 09, 2019 - 02:01:03 UTC 37.53686 -122.28699 San Mateo 29 []
1072535 September 15, 2020 - 20:02:49 UTC 37.54075 -122.287 San Mateo 29 []
726812 December 02, 2019 - 07:33:52 UTC 37.56568 -122.28703 San Mateo 29 []
731370 December 06, 2019 - 17:45:35 UTC 37.53759 -122.2872 San Mateo 29 []
662993 October 16, 2019 - 23:02:08 UTC 37.54145 -122.28823 San Mateo 29 []
730827 December 05, 2019 - 23:50:14 UTC 37.5483 -122.2892 San Mateo 29 []
693217 October 29, 2019 - 15:09:02 UTC 37.55803 -122.28933 San Mateo 29 []
655790 October 14, 2019 - 12:49:38 UTC 37.56222 -122.28951 San Mateo 29 []
1065534 September 12, 2020 - 15:46:21 UTC 37.55049 -122.28953 San Mateo 29 []
644687 October 05, 2019 - 18:07:19 UTC 37.54939 -122.28965 San Mateo 29 []
723918 November 30, 2019 - 05:50:52 UTC 37.53954 -122.28969 San Mateo 29 []
712167 November 21, 2019 - 17:36:00 UTC 37.549 -122.29036 San Mateo 29 []
1065833 September 12, 2020 - 17:00:00 UTC 37.53878 -122.29036 San Mateo 29 []
706326 November 13, 2019 - 23:25:18 UTC 37.56179 -122.29091 San Mateo 29 []
643399 October 04, 2019 - 17:22:31 UTC 37.55025 -122.29107 San Mateo 29 []
1072075 September 15, 2020 - 18:40:43 UTC 37.52862 -122.29152 San Mateo 29 []
739998 December 15, 2019 - 15:17:13 UTC 37.54047 -122.29214 San Mateo 29 []
718541 November 27, 2019 - 04:33:00 UTC 37.55171 -122.29226 San Mateo 29 [{"latitude": "37.53806", "longitude": "-122.29521"}, {"latitude": "37.53905", "longitude": "-122.29269"}, {"latitude": "37.53957", "longitude": "-122.29189"}, {"latitude": "37.53983", "longitude": "-122.29149"}, {"latitude": "37.54262", "longitude": "-122.28785"}, {"latitude": "37.55036", "longitude": "-122.2973"}, {"latitude": "37.55133", "longitude": "-122.29921"}, {"latitude": "37.55172", "longitude": "-122.30087"}, {"latitude": "37.55184", "longitude": "-122.30196"}, {"latitude": "37.55198", "longitude": "-122.30439"}, {"latitude": "37.55151", "longitude": "-122.30613"}, {"latitude": "37.54899", "longitude": "-122.31155"}, {"latitude": "37.54347", "longitude": "-122.30931"}, {"latitude": "37.54299", "longitude": "-122.30911"}, {"latitude": "37.54157", "longitude": "-122.30569"}, {"latitude": "37.5388", "longitude": "-122.29889"}]
1065409 September 12, 2020 - 08:40:00 UTC 37.53736 -122.2923 San Mateo 29 [{"latitude": "37.53406", "longitude": "-122.29388"}, {"latitude": "37.53623", "longitude": "-122.29114"}, {"latitude": "37.53694", "longitude": "-122.29107"}, {"latitude": "37.53715", "longitude": "-122.29138"}, {"latitude": "37.53729", "longitude": "-122.29223"}, {"latitude": "37.53848", "longitude": "-122.30175"}, {"latitude": "37.53706", "longitude": "-122.30113"}, {"latitude": "37.53505", "longitude": "-122.29941"}, {"latitude": "37.53483", "longitude": "-122.29851"}]
671102 October 19, 2019 - 14:35:00 UTC 37.55307 -122.29242 San Mateo 29 []
731116 December 06, 2019 - 15:36:47 UTC 37.53636 -122.29249 San Mateo 29 []
781924 February 09, 2020 - 17:54:00 UTC 37.55165 -122.29251 San Mateo 29 [{"latitude": "37.52959", "longitude": "-122.34764"}, {"latitude": "37.53026", "longitude": "-122.34467"}, {"latitude": "37.55305", "longitude": "-122.30005"}, {"latitude": "37.55351", "longitude": "-122.29915"}, {"latitude": "37.5548", "longitude": "-122.29902"}, {"latitude": "37.55509", "longitude": "-122.29912"}, {"latitude": "37.56457", "longitude": "-122.30826"}, {"latitude": "37.56512", "longitude": "-122.30882"}, {"latitude": "37.56544", "longitude": "-122.30937"}, {"latitude": "37.57544", "longitude": "-122.36055"}, {"latitude": "37.57177", "longitude": "-122.3827"}, {"latitude": "37.56676", "longitude": "-122.38795"}, {"latitude": "37.56573", "longitude": "-122.38728"}, {"latitude": "37.53231", "longitude": "-122.36409"}]
730387 December 05, 2019 - 17:14:01 UTC 37.5652 -122.29286 San Mateo 29 [{"latitude": "37.56535", "longitude": "-122.29232"}, {"latitude": "37.56585", "longitude": "-122.28816"}, {"latitude": "37.56736", "longitude": "-122.28734"}, {"latitude": "37.56708", "longitude": "-122.29137"}, {"latitude": "37.56593", "longitude": "-122.29253"}]
733864 December 08, 2019 - 22:10:59 UTC 37.54007 -122.29307 San Mateo 29 []
658254 October 14, 2019 - 21:18:25 UTC 37.53267 -122.29308 San Mateo 29 []
737072 December 12, 2019 - 12:34:04 UTC 37.52796 -122.29313 San Mateo 29 []
1066983 September 13, 2020 - 00:00:00 UTC 37.53344 -122.29363 San Mateo 29 []
1068989 September 14, 2020 - 18:07:25 UTC 37.52828 -122.29377 San Mateo 29 []
634553 October 01, 2019 - 19:58:20 UTC 37.56459 -122.29399 San Mateo 29 []
699527 November 04, 2019 - 23:43:01 UTC 37.55921 -122.29426 San Mateo 29 []
700670 November 06, 2019 - 17:07:49 UTC 37.55921 -122.29426 San Mateo 29 []
662197 October 16, 2019 - 20:50:37 UTC 37.55438 -122.29444 San Mateo 29 []
703344 November 09, 2019 - 18:25:39 UTC 37.55903 -122.29517 San Mateo 29 []
703348 November 09, 2019 - 18:25:00 UTC 37.55993 -122.29518 San Mateo 29 []
790515 February 13, 2020 - 21:36:31 UTC 37.53839 -122.29537 San Mateo 29 []
637576 October 02, 2019 - 20:12:59 UTC 37.53684 -122.29541 San Mateo 29 []
641613 October 03, 2019 - 22:44:33 UTC 37.56519 -122.29555 San Mateo 29 []
782418 February 09, 2020 - 18:45:16 UTC 37.56454 -122.29566 San Mateo 29 []
701293 November 07, 2019 - 01:59:55 UTC 37.54092 -122.2964 San Mateo 29 []
636675 October 02, 2019 - 17:53:00 UTC 37.53397 -122.29652 San Mateo 29 [{"latitude": "37.53405", "longitude": "-122.29639"}, {"latitude": "37.53435", "longitude": "-122.29565"}, {"latitude": "37.53443", "longitude": "-122.29547"}, {"latitude": "37.53487", "longitude": "-122.29551"}]
737309 December 12, 2019 - 17:10:32 UTC 37.53112 -122.29685 San Mateo 29 [{"latitude": "37.53038", "longitude": "-122.29739"}, {"latitude": "37.53051", "longitude": "-122.29662"}, {"latitude": "37.5316", "longitude": "-122.29736"}, {"latitude": "37.5315", "longitude": "-122.29811"}]
1072834 September 15, 2020 - 21:10:21 UTC 37.54956 -122.29694 San Mateo 29 []
706215 November 13, 2019 - 20:52:27 UTC 37.55036 -122.2973 San Mateo 29 []
718534 November 27, 2019 - 04:35:05 UTC 37.55036 -122.2973 San Mateo 29 []
786305 February 10, 2020 - 03:49:35 UTC 37.55036 -122.2973 San Mateo 29 []
699343 November 04, 2019 - 20:06:00 UTC 37.54552 -122.2976 San Mateo 29 []
699126 November 04, 2019 - 17:36:52 UTC 37.55836 -122.29792 San Mateo 29 []
689234 October 27, 2019 - 21:01:20 UTC 37.52711 -122.29829 San Mateo 29 []
721133 November 27, 2019 - 18:35:33 UTC 37.55004 -122.29836 San Mateo 29 []
722114 November 28, 2019 - 01:45:00 UTC 37.55004 -122.29836 San Mateo 29 []
738408 December 13, 2019 - 17:53:00 UTC 37.54328 -122.29866 San Mateo 29 []
718527 November 27, 2019 - 04:35:00 UTC 37.55081 -122.2987 San Mateo 29 []
671059 October 19, 2019 - 08:12:00 UTC 37.53587 -122.2989 San Mateo 29 [{"latitude": "37.53483", "longitude": "-122.29851"}, {"latitude": "37.53575", "longitude": "-122.2968"}, {"latitude": "37.53684", "longitude": "-122.29671"}, {"latitude": "37.53676", "longitude": "-122.29881"}, {"latitude": "37.53505", "longitude": "-122.29941"}]
674985 October 21, 2019 - 09:41:00 UTC 37.53587 -122.2989 San Mateo 29 [{"latitude": "37.53483", "longitude": "-122.29851"}, {"latitude": "37.53575", "longitude": "-122.2968"}, {"latitude": "37.53684", "longitude": "-122.29671"}, {"latitude": "37.53676", "longitude": "-122.29881"}, {"latitude": "37.53505", "longitude": "-122.29941"}]
680493 October 25, 2019 - 20:24:22 UTC 37.55966 -122.29913 San Mateo 29 []
686090 October 27, 2019 - 08:24:00 UTC 37.56796 -122.29915 San Mateo 29 []
721494 November 27, 2019 - 20:14:00 UTC 37.55032 -122.29916 San Mateo 29 [{"latitude": "37.55036", "longitude": "-122.2973"}, {"latitude": "37.55133", "longitude": "-122.29921"}, {"latitude": "37.55081", "longitude": "-122.2987"}]
718536 November 27, 2019 - 04:36:05 UTC 37.54986 -122.29917 San Mateo 29 []
713383 November 23, 2019 - 16:38:59 UTC 37.54198 -122.30011 San Mateo 29 []
738296 December 13, 2019 - 16:44:53 UTC 37.57071 -122.30019 San Mateo 29 []
743253 December 16, 2019 - 19:42:38 UTC 37.57071 -122.30019 San Mateo 29 []
784211 February 09, 2020 - 21:11:21 UTC 37.55969 -122.30023 San Mateo 29 []
786032 February 10, 2020 - 02:22:34 UTC 37.55969 -122.30023 San Mateo 29 []
790168 February 13, 2020 - 16:45:31 UTC 37.55969 -122.30023 San Mateo 29 []
722128 November 28, 2019 - 02:01:34 UTC 37.54 -122.30035 San Mateo 29 []
790612 February 14, 2020 - 00:22:45 UTC 37.57168 -122.30105 San Mateo 29 []
779403 February 06, 2020 - 20:24:00 UTC 37.52465 -122.30108 San Mateo 29 []
1085113 September 21, 2020 - 19:30:00 UTC 37.56569 -122.30123 San Mateo 29 []
696961 October 31, 2019 - 22:20:47 UTC 37.56475 -122.30133 San Mateo 29 []

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