864 rows where regionName = 29 sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
1113121 October 08, 2020 - 00:40:00 UTC 37.53133 -122.27695 San Mateo 29 []
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 []
1189840 December 16, 2020 - 08:10:44 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"}]
1198615 December 25, 2020 - 22:22:47 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"}]
1136443 November 05, 2020 - 17:28:48 UTC 37.54198 -122.27925 San Mateo 29 []
1198632 December 25, 2020 - 22:22:47 UTC 37.54198 -122.27925 San Mateo 29 []
1198631 December 25, 2020 - 22:25:00 UTC 37.54295 -122.27926 San Mateo 29 []
1198726 December 26, 2020 - 01:35:00 UTC 37.54295 -122.27926 San Mateo 29 []
1198630 December 25, 2020 - 22:43:16 UTC 37.54055 -122.27935 San Mateo 29 []
1198725 December 26, 2020 - 01:32:00 UTC 37.54055 -122.27935 San Mateo 29 []
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 []
1147567 November 17, 2020 - 22:17:08 UTC 37.5348 -122.28042 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 []
1112729 October 07, 2020 - 16:32:00 UTC 37.53174 -122.28129 San Mateo 29 [{"latitude": "37.53074", "longitude": "-122.27647"}, {"latitude": "37.53133", "longitude": "-122.27695"}, {"latitude": "37.5324", "longitude": "-122.27808"}, {"latitude": "37.53293", "longitude": "-122.27864"}, {"latitude": "37.53326", "longitude": "-122.27954"}, {"latitude": "37.53315", "longitude": "-122.28055"}, {"latitude": "37.53171", "longitude": "-122.27998"}, {"latitude": "37.53093", "longitude": "-122.27895"}]
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 []
1139263 November 08, 2020 - 17:33:00 UTC 37.53855 -122.28183 San Mateo 29 []
1139439 November 08, 2020 - 17:33:00 UTC 37.53855 -122.28183 San Mateo 29 []
1191718 December 17, 2020 - 02:04:02 UTC 37.53649 -122.28196 San Mateo 29 []
1139998 November 09, 2020 - 16:17:33 UTC 37.54571 -122.28207 San Mateo 29 []
1216140 January 19, 2021 - 17:27:25 UTC 37.53464 -122.2824 San Mateo 29 []
707345 November 15, 2019 - 16:26:00 UTC 37.53938 -122.2826 San Mateo 29 []
1139190 November 08, 2020 - 16:40:00 UTC 37.53938 -122.2826 San Mateo 29 []
1216310 January 19, 2021 - 18:03:37 UTC 37.53938 -122.2826 San Mateo 29 []
1113005 October 07, 2020 - 21:28:42 UTC 37.53608 -122.28266 San Mateo 29 []
1218962 January 20, 2021 - 22:39:40 UTC 37.53608 -122.28266 San Mateo 29 []
675834 October 21, 2019 - 15:36:02 UTC 37.54632 -122.28298 San Mateo 29 []
1139195 November 08, 2020 - 16:44:00 UTC 37.54021 -122.28335 San Mateo 29 []
1216284 January 19, 2021 - 18:01:00 UTC 37.54021 -122.28335 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"}]
1106857 October 02, 2020 - 17:13:00 UTC 37.53359 -122.28339 San Mateo 29 []
1216584 January 19, 2021 - 19:01:00 UTC 37.54252 -122.28377 San Mateo 29 []
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 []
1104038 October 01, 2020 - 18:27:11 UTC 37.54148 -122.28401 San Mateo 29 []
1118664 October 15, 2020 - 21:11:53 UTC 37.54148 -122.28401 San Mateo 29 []
1196226 December 21, 2020 - 16:18:42 UTC 37.54148 -122.28401 San Mateo 29 []
1151867 November 21, 2020 - 21:37:35 UTC 37.53884 -122.28416 San Mateo 29 []
1152454 November 22, 2020 - 00:38:03 UTC 37.53884 -122.28416 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 []
1106858 October 02, 2020 - 17:14:51 UTC 37.5336 -122.28465 San Mateo 29 []
1106659 October 02, 2020 - 16:35:00 UTC 37.53233 -122.2848 San Mateo 29 [{"latitude": "37.53199", "longitude": "-122.28399"}, {"latitude": "37.53237", "longitude": "-122.28306"}, {"latitude": "37.53303", "longitude": "-122.28247"}]
1139181 November 08, 2020 - 16:34:00 UTC 37.54595 -122.28489 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.54658", "longitude": "-122.28382"}, {"latitude": "37.5461", "longitude": "-122.28464"}, {"latitude": "37.54108", "longitude": "-122.283"}, {"latitude": "37.53983", "longitude": "-122.28186"}]
1144379 November 14, 2020 - 02:32:00 UTC 37.5644 -122.28493 San Mateo 29 []
779483 February 06, 2020 - 21:44:48 UTC 37.53984 -122.28507 San Mateo 29 []
1157275 December 01, 2020 - 20:21:16 UTC 37.53984 -122.28507 San Mateo 29 []
1118749 October 15, 2020 - 22:39:30 UTC 37.54545 -122.28518 San Mateo 29 []
713873 November 24, 2019 - 18:20:00 UTC 37.54422 -122.28525 San Mateo 29 []
1118667 October 15, 2020 - 21:14:15 UTC 37.54287 -122.28541 San Mateo 29 []
1147564 November 17, 2020 - 22:15:32 UTC 37.53614 -122.28598 San Mateo 29 []
1193131 December 18, 2020 - 06:03:00 UTC 37.55813 -122.28606 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 []
1193132 December 18, 2020 - 06:08:00 UTC 37.55954 -122.28656 San Mateo 29 []
1203738 January 04, 2021 - 20:04:50 UTC 37.53577 -122.2867 San Mateo 29 []
1121758 October 20, 2020 - 21:32:13 UTC 37.54592 -122.28691 San Mateo 29 []
1139410 November 08, 2020 - 19:30:01 UTC 37.54592 -122.28691 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 []
1112674 October 07, 2020 - 16:32:00 UTC 37.53132 -122.28767 San Mateo 29 [{"latitude": "37.53074", "longitude": "-122.27647"}, {"latitude": "37.53133", "longitude": "-122.27695"}, {"latitude": "37.5324", "longitude": "-122.27808"}, {"latitude": "37.53293", "longitude": "-122.27864"}, {"latitude": "37.53326", "longitude": "-122.27954"}, {"latitude": "37.53303", "longitude": "-122.28247"}, {"latitude": "37.5324", "longitude": "-122.2848"}, {"latitude": "37.53141", "longitude": "-122.28771"}]
1215469 January 19, 2021 - 15:35:48 UTC 37.54671 -122.28803 San Mateo 29 []
1119272 October 16, 2020 - 17:28:19 UTC 37.53483 -122.28819 San Mateo 29 []
662993 October 16, 2019 - 23:02:08 UTC 37.54145 -122.28823 San Mateo 29 []
1096838 September 28, 2020 - 21:04:19 UTC 37.54145 -122.28823 San Mateo 29 []
1105840 October 02, 2020 - 01:25:11 UTC 37.539 -122.28915 San Mateo 29 []
730827 December 05, 2019 - 23:50:14 UTC 37.5483 -122.2892 San Mateo 29 []
1116701 October 13, 2020 - 20:48:53 UTC 37.54657 -122.28921 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 []
1215119 January 19, 2021 - 14:38:58 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 []
1118910 October 16, 2020 - 02:46:38 UTC 37.53954 -122.28969 San Mateo 29 []
1088651 September 23, 2020 - 01:48:54 UTC 37.53276 -122.28986 San Mateo 29 []
1141095 November 10, 2020 - 18:19:10 UTC 37.53348 -122.29006 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 []
1215073 January 19, 2021 - 14:28:52 UTC 37.53878 -122.29036 San Mateo 29 []
1122560 October 21, 2020 - 22:59:56 UTC 37.53298 -122.29067 San Mateo 29 []
1140352 November 09, 2020 - 19:41:20 UTC 37.53298 -122.29067 San Mateo 29 []
706326 November 13, 2019 - 23:25:18 UTC 37.56179 -122.29091 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
);