801 rows where regionName = 29 sorted by latitude

View and edit SQL

id outageStartTime latitude ▼ longitude regionName outageDevices
1064583 September 11, 2020 - 18:14:09 UTC 37.51598 -122.33514 San Mateo 29 []
691859 October 28, 2019 - 20:00:00 UTC 37.51599 -122.32972 San Mateo 29 []
683241 October 27, 2019 - 03:06:38 UTC 37.51714 -122.3356 San Mateo 29 [{"latitude": "37.5172", "longitude": "-122.33263"}, {"latitude": "37.51746", "longitude": "-122.33097"}, {"latitude": "37.53453", "longitude": "-122.32171"}, {"latitude": "37.53826", "longitude": "-122.32744"}, {"latitude": "37.53377", "longitude": "-122.34491"}, {"latitude": "37.52943", "longitude": "-122.34497"}, {"latitude": "37.52178", "longitude": "-122.34067"}, {"latitude": "37.51974", "longitude": "-122.33817"}, {"latitude": "37.51863", "longitude": "-122.33672"}]
1063237 September 10, 2020 - 18:50:08 UTC 37.52246 -122.30519 San Mateo 29 []
1194669 December 19, 2020 - 17:52:00 UTC 37.52299 -122.33572 San Mateo 29 []
1203730 January 04, 2021 - 20:02:50 UTC 37.52299 -122.33572 San Mateo 29 []
703028 November 09, 2019 - 00:24:40 UTC 37.523 -122.30293 San Mateo 29 []
720860 November 27, 2019 - 17:24:55 UTC 37.523 -122.30293 San Mateo 29 []
1061476 September 09, 2020 - 01:12:00 UTC 37.52336 -122.32692 San Mateo 29 []
1116719 October 13, 2020 - 21:06:21 UTC 37.52373 -122.3252 San Mateo 29 []
1200925 December 29, 2020 - 23:45:04 UTC 37.52399 -122.31199 San Mateo 29 []
1208338 January 11, 2021 - 19:16:44 UTC 37.52402 -122.30309 San Mateo 29 []
1061477 September 09, 2020 - 01:16:37 UTC 37.52413 -122.32958 San Mateo 29 []
739412 December 14, 2019 - 17:38:00 UTC 37.52457 -122.30367 San Mateo 29 [{"latitude": "37.52243", "longitude": "-122.30638"}, {"latitude": "37.52246", "longitude": "-122.30519"}, {"latitude": "37.52452", "longitude": "-122.30382"}, {"latitude": "37.52506", "longitude": "-122.30548"}, {"latitude": "37.5235", "longitude": "-122.30872"}]
779403 February 06, 2020 - 20:24:00 UTC 37.52465 -122.30108 San Mateo 29 []
782803 February 09, 2020 - 19:14:52 UTC 37.52478 -122.32561 San Mateo 29 []
647444 October 08, 2019 - 18:39:17 UTC 37.52571 -122.30535 San Mateo 29 []
1148295 November 18, 2020 - 16:22:08 UTC 37.52571 -122.30012 San Mateo 29 []
1168669 December 07, 2020 - 20:05:20 UTC 37.52616 -122.30761 San Mateo 29 []
658315 October 14, 2019 - 21:33:47 UTC 37.52638 -122.30393 San Mateo 29 []
691451 October 28, 2019 - 16:09:43 UTC 37.52654 -122.30865 San Mateo 29 []
699204 November 04, 2019 - 18:25:15 UTC 37.52659 -122.33268 San Mateo 29 []
1146465 November 16, 2020 - 22:54:55 UTC 37.52704 -122.2931 San Mateo 29 []
689234 October 27, 2019 - 21:01:20 UTC 37.52711 -122.29829 San Mateo 29 []
701834 November 07, 2019 - 18:06:46 UTC 37.52731 -122.30693 San Mateo 29 []
1058184 September 07, 2020 - 13:58:00 UTC 37.52737 -122.32601 San Mateo 29 []
1061449 September 09, 2020 - 00:15:00 UTC 37.52737 -122.32601 San Mateo 29 [{"latitude": "37.52168", "longitude": "-122.32896"}, {"latitude": "37.52178", "longitude": "-122.32698"}, {"latitude": "37.52228", "longitude": "-122.32618"}, {"latitude": "37.523", "longitude": "-122.32558"}, {"latitude": "37.52481", "longitude": "-122.32419"}, {"latitude": "37.52627", "longitude": "-122.32502"}, {"latitude": "37.52486", "longitude": "-122.33002"}, {"latitude": "37.524", "longitude": "-122.33079"}, {"latitude": "37.52245", "longitude": "-122.32973"}, {"latitude": "37.52184", "longitude": "-122.3293"}]
1137483 November 06, 2020 - 18:32:54 UTC 37.52761 -122.29172 San Mateo 29 []
717588 November 27, 2019 - 02:53:29 UTC 37.52763 -122.30981 San Mateo 29 []
709721 November 19, 2019 - 05:15:09 UTC 37.52765 -122.30385 San Mateo 29 []
735916 December 11, 2019 - 00:58:49 UTC 37.52768 -122.30893 San Mateo 29 []
1135840 November 04, 2020 - 19:52:33 UTC 37.5279 -122.29854 San Mateo 29 []
737072 December 12, 2019 - 12:34:04 UTC 37.52796 -122.29313 San Mateo 29 []
709708 November 19, 2019 - 04:09:48 UTC 37.52802 -122.303 San Mateo 29 []
717593 November 27, 2019 - 02:54:10 UTC 37.52826 -122.30998 San Mateo 29 []
1068989 September 14, 2020 - 18:07:25 UTC 37.52828 -122.29377 San Mateo 29 []
675923 October 21, 2019 - 16:08:16 UTC 37.52843 -122.32135 San Mateo 29 []
1072075 September 15, 2020 - 18:40:43 UTC 37.52862 -122.29152 San Mateo 29 []
1122517 October 21, 2020 - 22:12:05 UTC 37.52862 -122.29152 San Mateo 29 []
719735 November 27, 2019 - 10:44:56 UTC 37.52863 -122.31889 San Mateo 29 []
714469 November 25, 2019 - 20:45:09 UTC 37.52864 -122.30933 San Mateo 29 []
1174674 December 10, 2020 - 00:25:59 UTC 37.52905 -122.30561 San Mateo 29 []
678231 October 23, 2019 - 21:58:24 UTC 37.52919 -122.31528 San Mateo 29 []
1080980 September 18, 2020 - 19:22:20 UTC 37.52935 -122.3142 San Mateo 29 []
1192525 December 17, 2020 - 19:05:26 UTC 37.52984 -122.3268 San Mateo 29 []
1062037 September 09, 2020 - 17:53:56 UTC 37.52985 -122.27763 San Mateo 29 []
1209545 January 13, 2021 - 16:04:29 UTC 37.52989 -122.32295 San Mateo 29 []
1201041 December 30, 2020 - 05:02:37 UTC 37.5303 -122.31802 San Mateo 29 []
1201083 December 30, 2020 - 09:06:09 UTC 37.5303 -122.31802 San Mateo 29 []
1201328 December 30, 2020 - 20:27:28 UTC 37.5303 -122.31802 San Mateo 29 []
1201437 December 30, 2020 - 22:49:00 UTC 37.5303 -122.31802 San Mateo 29 []
708100 November 16, 2019 - 15:04:09 UTC 37.5304 -122.28433 San Mateo 29 []
1149587 November 19, 2020 - 21:49:47 UTC 37.53089 -122.30562 San Mateo 29 []
1180327 December 12, 2020 - 05:08:09 UTC 37.53089 -122.30562 San Mateo 29 []
654834 October 12, 2019 - 01:15:00 UTC 37.53096 -122.31593 San Mateo 29 []
1132096 October 30, 2020 - 16:04:45 UTC 37.53108 -122.32893 San Mateo 29 []
1132460 October 31, 2020 - 00:07:46 UTC 37.53108 -122.32893 San Mateo 29 []
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"}]
727807 December 02, 2019 - 23:09:28 UTC 37.53123 -122.31742 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 []
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"}]
1113121 October 08, 2020 - 00:40:00 UTC 37.53133 -122.27695 San Mateo 29 []
1119410 October 16, 2020 - 20:29:14 UTC 37.53134 -122.30659 San Mateo 29 []
733254 December 08, 2019 - 02:13:37 UTC 37.53141 -122.32093 San Mateo 29 []
1156266 November 30, 2020 - 17:36:54 UTC 37.5315 -122.29811 San Mateo 29 []
1205130 January 06, 2021 - 16:35:23 UTC 37.5315 -122.29811 San Mateo 29 []
658520 October 14, 2019 - 22:12:01 UTC 37.53157 -122.3161 San Mateo 29 []
1158231 December 02, 2020 - 19:02:24 UTC 37.53157 -122.3161 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"}]
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"}]
712386 November 21, 2019 - 21:41:24 UTC 37.53194 -122.30971 San Mateo 29 []
1140770 November 10, 2020 - 08:44:08 UTC 37.53226 -122.30085 San Mateo 29 []
1083301 September 20, 2020 - 20:39:00 UTC 37.53227 -122.32721 San Mateo 29 [{"latitude": "37.53198", "longitude": "-122.32708"}, {"latitude": "37.53238", "longitude": "-122.32735"}, {"latitude": "37.53234", "longitude": "-122.32735"}]
1134957 November 03, 2020 - 16:29:37 UTC 37.5323 -122.29701 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"}]
1106142 October 02, 2020 - 14:54:34 UTC 37.53266 -122.30759 San Mateo 29 []
658254 October 14, 2019 - 21:18:25 UTC 37.53267 -122.29308 San Mateo 29 []
1140662 November 10, 2020 - 01:49:31 UTC 37.53274 -122.30159 San Mateo 29 []
1140689 November 10, 2020 - 03:42:09 UTC 37.53274 -122.30159 San Mateo 29 []
1088651 September 23, 2020 - 01:48:54 UTC 37.53276 -122.28986 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 []
1202465 January 02, 2021 - 19:19:39 UTC 37.53302 -122.32121 San Mateo 29 []
1140762 November 10, 2020 - 08:08:55 UTC 37.53303 -122.30094 San Mateo 29 []
1140686 November 10, 2020 - 03:33:25 UTC 37.53324 -122.29985 San Mateo 29 []
1140726 November 10, 2020 - 05:08:58 UTC 37.53324 -122.29985 San Mateo 29 []
1066983 September 13, 2020 - 00:00:00 UTC 37.53344 -122.29363 San Mateo 29 []
1141095 November 10, 2020 - 18:19:10 UTC 37.53348 -122.29006 San Mateo 29 []
1106857 October 02, 2020 - 17:13:00 UTC 37.53359 -122.28339 San Mateo 29 []
1106858 October 02, 2020 - 17:14:51 UTC 37.5336 -122.28465 San Mateo 29 []
1140836 November 10, 2020 - 15:17:28 UTC 37.53362 -122.29502 San Mateo 29 []
657016 October 14, 2019 - 18:05:52 UTC 37.53368 -122.3173 San Mateo 29 []
1204470 January 05, 2021 - 17:18:53 UTC 37.53368 -122.3173 San Mateo 29 []
1120516 October 19, 2020 - 04:20:56 UTC 37.5339 -122.30551 San Mateo 29 []
1210459 January 14, 2021 - 20:52:00 UTC 37.53392 -122.31123 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"}]
713155 November 23, 2019 - 00:15:14 UTC 37.53413 -122.31937 San Mateo 29 []
734872 December 09, 2019 - 23:53:41 UTC 37.5344 -122.30603 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
);