outages

438 rows where regionName = 29 sorted by latitude

View and edit SQL

outageDevices

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 []
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 []
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 []
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 []
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"}]
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 []
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 []
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 []
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 []
1062037 September 09, 2020 - 17:53:56 UTC 37.52985 -122.27763 San Mateo 29 []
708100 November 16, 2019 - 15:04:09 UTC 37.5304 -122.28433 San Mateo 29 []
654834 October 12, 2019 - 01:15:00 UTC 37.53096 -122.31593 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 []
733254 December 08, 2019 - 02:13:37 UTC 37.53141 -122.32093 San Mateo 29 []
658520 October 14, 2019 - 22:12:01 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"}]
712386 November 21, 2019 - 21:41:24 UTC 37.53194 -122.30971 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"}]
658254 October 14, 2019 - 21:18:25 UTC 37.53267 -122.29308 San Mateo 29 []
1066983 September 13, 2020 - 00:00:00 UTC 37.53344 -122.29363 San Mateo 29 []
657016 October 14, 2019 - 18:05:52 UTC 37.53368 -122.3173 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 []
782914 February 09, 2020 - 19:23:38 UTC 37.53458 -122.32089 San Mateo 29 []
680352 October 25, 2019 - 17:06:03 UTC 37.53525 -122.32042 San Mateo 29 []
786832 February 10, 2020 - 14:20:42 UTC 37.53534 -122.30293 San Mateo 29 []
689345 October 27, 2019 - 21:14:11 UTC 37.5356 -122.31369 San Mateo 29 []
1076596 September 16, 2020 - 22:59:41 UTC 37.53565 -122.30457 San Mateo 29 []
700715 November 06, 2019 - 17:27:00 UTC 37.53566 -122.30285 San Mateo 29 []
779695 February 07, 2020 - 02:44:00 UTC 37.53584 -122.31729 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"}]
691603 October 28, 2019 - 17:23:31 UTC 37.53622 -122.31217 San Mateo 29 []
708093 November 16, 2019 - 14:51:16 UTC 37.53628 -122.31621 San Mateo 29 []
731116 December 06, 2019 - 15:36:47 UTC 37.53636 -122.29249 San Mateo 29 []
647614 October 08, 2019 - 23:20:00 UTC 37.5365 -122.3218 San Mateo 29 [{"latitude": "37.53198", "longitude": "-122.31809"}, {"latitude": "37.53224", "longitude": "-122.31676"}, {"latitude": "37.53354", "longitude": "-122.31452"}, {"latitude": "37.53526", "longitude": "-122.31213"}, {"latitude": "37.55081", "longitude": "-122.32102"}, {"latitude": "37.55146", "longitude": "-122.32275"}, {"latitude": "37.54901", "longitude": "-122.33241"}, {"latitude": "37.54779", "longitude": "-122.33388"}, {"latitude": "37.5434", "longitude": "-122.3319"}]
1063593 September 10, 2020 - 20:58:41 UTC 37.53653 -122.30482 San Mateo 29 []
708097 November 16, 2019 - 14:57:51 UTC 37.53669 -122.31519 San Mateo 29 []
679506 October 24, 2019 - 16:31:41 UTC 37.53671 -122.30652 San Mateo 29 []
637576 October 02, 2019 - 20:12:59 UTC 37.53684 -122.29541 San Mateo 29 []
734005 December 09, 2019 - 02:01:03 UTC 37.53686 -122.28699 San Mateo 29 []
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"}]
683260 October 27, 2019 - 03:06:38 UTC 37.5374 -122.32801 San Mateo 29 [{"latitude": "37.53879", "longitude": "-122.32851"}, {"latitude": "37.53929", "longitude": "-122.32699"}, {"latitude": "37.54056", "longitude": "-122.32916"}]
731370 December 06, 2019 - 17:45:35 UTC 37.53759 -122.2872 San Mateo 29 []
720493 November 27, 2019 - 15:54:02 UTC 37.53775 -122.31763 San Mateo 29 []
1068854 September 14, 2020 - 16:56:22 UTC 37.538 -122.2865 San Mateo 29 []
790515 February 13, 2020 - 21:36:31 UTC 37.53839 -122.29537 San Mateo 29 []
677470 October 23, 2019 - 16:20:13 UTC 37.53855 -122.28183 San Mateo 29 []
1065833 September 12, 2020 - 17:00:00 UTC 37.53878 -122.29036 San Mateo 29 []
743990 December 17, 2019 - 13:13:12 UTC 37.53894 -122.32547 San Mateo 29 []
707345 November 15, 2019 - 16:26:00 UTC 37.53938 -122.2826 San Mateo 29 []
723918 November 30, 2019 - 05:50:52 UTC 37.53954 -122.28969 San Mateo 29 []
707305 November 15, 2019 - 15:56:00 UTC 37.53958 -122.2802 San Mateo 29 []
779483 February 06, 2020 - 21:44:48 UTC 37.53984 -122.28507 San Mateo 29 []
694115 October 29, 2019 - 20:43:33 UTC 37.53997 -122.30475 San Mateo 29 []
722128 November 28, 2019 - 02:01:34 UTC 37.54 -122.30035 San Mateo 29 []
698649 November 03, 2019 - 18:55:40 UTC 37.54004 -122.31823 San Mateo 29 []
698677 November 03, 2019 - 19:56:04 UTC 37.54004 -122.31823 San Mateo 29 []
698977 November 04, 2019 - 15:11:23 UTC 37.54004 -122.31823 San Mateo 29 []
733864 December 08, 2019 - 22:10:59 UTC 37.54007 -122.29307 San Mateo 29 []
719054 November 27, 2019 - 05:49:50 UTC 37.54035 -122.30338 San Mateo 29 []
719354 November 27, 2019 - 06:55:00 UTC 37.54035 -122.30338 San Mateo 29 []
720271 November 27, 2019 - 14:40:00 UTC 37.54035 -122.30338 San Mateo 29 []
720406 November 27, 2019 - 15:25:00 UTC 37.54035 -122.30338 San Mateo 29 []
722145 November 28, 2019 - 02:13:00 UTC 37.54035 -122.30338 San Mateo 29 []
739998 December 15, 2019 - 15:17:13 UTC 37.54047 -122.29214 San Mateo 29 []
1072535 September 15, 2020 - 20:02:49 UTC 37.54075 -122.287 San Mateo 29 []
783746 February 09, 2020 - 20:21:47 UTC 37.54089 -122.31613 San Mateo 29 []
645739 October 07, 2019 - 03:02:32 UTC 37.5409 -122.30993 San Mateo 29 []
701293 November 07, 2019 - 01:59:55 UTC 37.54092 -122.2964 San Mateo 29 []
788317 February 11, 2020 - 15:43:01 UTC 37.54125 -122.31441 San Mateo 29 []
661814 October 16, 2019 - 20:13:55 UTC 37.54136 -122.30682 San Mateo 29 []
662993 October 16, 2019 - 23:02:08 UTC 37.54145 -122.28823 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 1407.279ms · About: About this site