outages

431 rows where regionName = 29 sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
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 []
736008 December 11, 2019 - 04:22:12 UTC 37.56297 -122.30359 San Mateo 29 []
738878 December 14, 2019 - 13:26:30 UTC 37.56297 -122.30359 San Mateo 29 []
739153 December 14, 2019 - 15:48:12 UTC 37.56297 -122.30359 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"}]
647014 October 08, 2019 - 04:02:28 UTC 37.55757 -122.3037 San Mateo 29 []
633773 October 01, 2019 - 15:45:58 UTC 37.56931 -122.30385 San Mateo 29 []
709721 November 19, 2019 - 05:15:09 UTC 37.52765 -122.30385 San Mateo 29 []
780013 February 07, 2020 - 17:47:55 UTC 37.54164 -122.30386 San Mateo 29 []
658315 October 14, 2019 - 21:33:47 UTC 37.52638 -122.30393 San Mateo 29 []
1062174 September 09, 2020 - 20:40:52 UTC 37.5511 -122.30438 San Mateo 29 []
1062755 September 10, 2020 - 15:35:53 UTC 37.5511 -122.30438 San Mateo 29 []
1064975 September 11, 2020 - 20:49:00 UTC 37.56033 -122.30445 San Mateo 29 []
1076596 September 16, 2020 - 22:59:41 UTC 37.53565 -122.30457 San Mateo 29 []
790316 February 13, 2020 - 18:09:01 UTC 37.5574 -122.30463 San Mateo 29 []
694115 October 29, 2019 - 20:43:33 UTC 37.53997 -122.30475 San Mateo 29 []
1063593 September 10, 2020 - 20:58:41 UTC 37.53653 -122.30482 San Mateo 29 []
1063237 September 10, 2020 - 18:50:08 UTC 37.52246 -122.30519 San Mateo 29 []
647444 October 08, 2019 - 18:39:17 UTC 37.52571 -122.30535 San Mateo 29 []
789850 February 13, 2020 - 00:45:15 UTC 37.56751 -122.30581 San Mateo 29 []
651524 October 09, 2019 - 23:25:15 UTC 37.55058 -122.30588 San Mateo 29 []
734872 December 09, 2019 - 23:53:41 UTC 37.5344 -122.30603 San Mateo 29 []
679506 October 24, 2019 - 16:31:41 UTC 37.53671 -122.30652 San Mateo 29 []
728804 December 03, 2019 - 20:20:06 UTC 37.54917 -122.30663 San Mateo 29 []
737925 December 13, 2019 - 02:04:41 UTC 37.54917 -122.30663 San Mateo 29 []
737940 December 13, 2019 - 03:21:00 UTC 37.54917 -122.30663 San Mateo 29 []
737955 December 13, 2019 - 04:29:00 UTC 37.54917 -122.30663 San Mateo 29 []
661814 October 16, 2019 - 20:13:55 UTC 37.54136 -122.30682 San Mateo 29 []
790661 February 14, 2020 - 02:05:21 UTC 37.56963 -122.30687 San Mateo 29 []
701834 November 07, 2019 - 18:06:46 UTC 37.52731 -122.30693 San Mateo 29 []
718611 November 27, 2019 - 04:44:00 UTC 37.54467 -122.30729 San Mateo 29 []
719517 November 27, 2019 - 04:44:00 UTC 37.54467 -122.30729 San Mateo 29 []
634824 October 01, 2019 - 20:44:36 UTC 37.56552 -122.30751 San Mateo 29 []
717752 November 27, 2019 - 03:12:15 UTC 37.56061 -122.30767 San Mateo 29 []
722736 November 28, 2019 - 16:58:59 UTC 37.56061 -122.30767 San Mateo 29 []
661774 October 16, 2019 - 19:59:43 UTC 37.56828 -122.30775 San Mateo 29 []
726082 December 01, 2019 - 20:48:00 UTC 37.5453 -122.30803 San Mateo 29 []
784389 February 09, 2020 - 21:31:42 UTC 37.57106 -122.30839 San Mateo 29 []
717824 November 27, 2019 - 03:19:10 UTC 37.56063 -122.30858 San Mateo 29 []
691451 October 28, 2019 - 16:09:43 UTC 37.52654 -122.30865 San Mateo 29 []
697485 November 01, 2019 - 18:43:31 UTC 37.56806 -122.30893 San Mateo 29 []
698003 November 02, 2019 - 02:40:51 UTC 37.56806 -122.30893 San Mateo 29 []
698082 November 02, 2019 - 14:56:44 UTC 37.56806 -122.30893 San Mateo 29 []
735916 December 11, 2019 - 00:58:49 UTC 37.52768 -122.30893 San Mateo 29 []
664193 October 17, 2019 - 16:39:00 UTC 37.54601 -122.30897 San Mateo 29 [{"latitude": "37.5453", "longitude": "-122.30803"}, {"latitude": "37.54588", "longitude": "-122.30867"}, {"latitude": "37.5456", "longitude": "-122.30837"}]
714469 November 25, 2019 - 20:45:09 UTC 37.52864 -122.30933 San Mateo 29 []
729245 December 04, 2019 - 13:04:54 UTC 37.55 -122.30936 San Mateo 29 []
729266 December 04, 2019 - 13:04:54 UTC 37.55 -122.30936 San Mateo 29 []
729307 December 04, 2019 - 14:46:22 UTC 37.55 -122.30936 San Mateo 29 []
729506 December 04, 2019 - 17:03:58 UTC 37.55 -122.30936 San Mateo 29 []
729754 December 04, 2019 - 19:39:56 UTC 37.55 -122.30936 San Mateo 29 []
712386 November 21, 2019 - 21:41:24 UTC 37.53194 -122.30971 San Mateo 29 []
717588 November 27, 2019 - 02:53:29 UTC 37.52763 -122.30981 San Mateo 29 []
647436 October 08, 2019 - 18:31:04 UTC 37.54443 -122.30983 San Mateo 29 []
645739 October 07, 2019 - 03:02:32 UTC 37.5409 -122.30993 San Mateo 29 []
664379 October 17, 2019 - 17:02:00 UTC 37.54638 -122.30995 San Mateo 29 []
664993 October 17, 2019 - 17:57:00 UTC 37.54638 -122.30995 San Mateo 29 []
1061329 September 08, 2020 - 22:27:40 UTC 37.56052 -122.30996 San Mateo 29 []
717593 November 27, 2019 - 02:54:10 UTC 37.52826 -122.30998 San Mateo 29 []
720051 November 27, 2019 - 13:22:21 UTC 37.54917 -122.31017 San Mateo 29 []
786357 February 10, 2020 - 04:17:00 UTC 37.55757 -122.31028 San Mateo 29 [{"latitude": "37.55763", "longitude": "-122.31035"}, {"latitude": "37.56063", "longitude": "-122.30858"}, {"latitude": "37.56228", "longitude": "-122.30811"}, {"latitude": "37.56561", "longitude": "-122.31231"}, {"latitude": "37.56953", "longitude": "-122.32395"}, {"latitude": "37.56653", "longitude": "-122.32779"}, {"latitude": "37.56343", "longitude": "-122.32545"}, {"latitude": "37.56256", "longitude": "-122.32455"}]
786580 February 10, 2020 - 06:12:00 UTC 37.55757 -122.31028 San Mateo 29 [{"latitude": "37.55763", "longitude": "-122.31035"}, {"latitude": "37.56063", "longitude": "-122.30858"}, {"latitude": "37.56228", "longitude": "-122.30811"}, {"latitude": "37.56561", "longitude": "-122.31231"}, {"latitude": "37.56618", "longitude": "-122.31416"}, {"latitude": "37.56776", "longitude": "-122.32009"}, {"latitude": "37.56779", "longitude": "-122.32417"}, {"latitude": "37.56655", "longitude": "-122.32296"}]
786615 February 10, 2020 - 07:14:00 UTC 37.55757 -122.31028 San Mateo 29 [{"latitude": "37.55763", "longitude": "-122.31035"}, {"latitude": "37.56063", "longitude": "-122.30858"}, {"latitude": "37.56228", "longitude": "-122.30811"}, {"latitude": "37.56561", "longitude": "-122.31231"}, {"latitude": "37.56618", "longitude": "-122.31416"}, {"latitude": "37.56776", "longitude": "-122.32009"}, {"latitude": "37.56779", "longitude": "-122.32417"}, {"latitude": "37.56654", "longitude": "-122.3253"}, {"latitude": "37.56571", "longitude": "-122.32401"}]
730464 December 05, 2019 - 18:04:50 UTC 37.56127 -122.31063 San Mateo 29 []
743773 December 16, 2019 - 23:41:41 UTC 37.5674 -122.31072 San Mateo 29 []
781830 February 09, 2020 - 17:48:37 UTC 37.57017 -122.31096 San Mateo 29 []
706398 November 14, 2019 - 00:37:28 UTC 37.56481 -122.31097 San Mateo 29 []
715812 November 26, 2019 - 22:22:08 UTC 37.56481 -122.31097 San Mateo 29 []
778897 February 06, 2020 - 11:27:04 UTC 37.56266 -122.31143 San Mateo 29 []
728351 December 03, 2019 - 16:05:19 UTC 37.55811 -122.31202 San Mateo 29 []
786421 February 10, 2020 - 04:30:00 UTC 37.5636 -122.31204 San Mateo 29 []
724830 December 01, 2019 - 01:32:00 UTC 37.55252 -122.31212 San Mateo 29 []
706084 November 13, 2019 - 18:39:32 UTC 37.56132 -122.31213 San Mateo 29 []
691603 October 28, 2019 - 17:23:31 UTC 37.53622 -122.31217 San Mateo 29 []
720409 November 27, 2019 - 15:26:48 UTC 37.56607 -122.31235 San Mateo 29 []
786436 February 10, 2020 - 04:37:00 UTC 37.56607 -122.31235 San Mateo 29 []
706232 November 13, 2019 - 21:14:28 UTC 37.56453 -122.31236 San Mateo 29 []
714370 November 25, 2019 - 19:33:47 UTC 37.56453 -122.31236 San Mateo 29 []
706477 November 14, 2019 - 03:59:16 UTC 37.56893 -122.31239 San Mateo 29 []
647618 October 08, 2019 - 23:26:17 UTC 37.55278 -122.3133 San Mateo 29 [{"latitude": "37.54811", "longitude": "-122.32026"}, {"latitude": "37.549", "longitude": "-122.31715"}, {"latitude": "37.55202", "longitude": "-122.31259"}, {"latitude": "37.56259", "longitude": "-122.31838"}, {"latitude": "37.56491", "longitude": "-122.32121"}, {"latitude": "37.5651", "longitude": "-122.32185"}, {"latitude": "37.56673", "longitude": "-122.3282"}, {"latitude": "37.56642", "longitude": "-122.32871"}, {"latitude": "37.564", "longitude": "-122.32829"}, {"latitude": "37.55983", "longitude": "-122.32713"}]
724769 December 01, 2019 - 00:46:25 UTC 37.55278 -122.3133 San Mateo 29 [{"latitude": "37.54811", "longitude": "-122.32026"}, {"latitude": "37.549", "longitude": "-122.31715"}, {"latitude": "37.55202", "longitude": "-122.31259"}, {"latitude": "37.56259", "longitude": "-122.31838"}, {"latitude": "37.56491", "longitude": "-122.32121"}, {"latitude": "37.5651", "longitude": "-122.32185"}, {"latitude": "37.56673", "longitude": "-122.3282"}, {"latitude": "37.56642", "longitude": "-122.32871"}, {"latitude": "37.564", "longitude": "-122.32829"}, {"latitude": "37.55983", "longitude": "-122.32713"}]
708250 November 16, 2019 - 18:17:15 UTC 37.56109 -122.31337 San Mateo 29 []
780929 February 09, 2020 - 13:20:47 UTC 37.56109 -122.31337 San Mateo 29 []
647628 October 08, 2019 - 23:47:50 UTC 37.55186 -122.31353 San Mateo 29 []
724789 December 01, 2019 - 01:26:21 UTC 37.55186 -122.31353 San Mateo 29 []
689345 October 27, 2019 - 21:14:11 UTC 37.5356 -122.31369 San Mateo 29 []
784006 February 09, 2020 - 20:42:27 UTC 37.55627 -122.31372 San Mateo 29 []
677484 October 23, 2019 - 16:38:25 UTC 37.55188 -122.3141 San Mateo 29 []
712532 November 22, 2019 - 00:40:08 UTC 37.55396 -122.31418 San Mateo 29 []
1080980 September 18, 2020 - 19:22:20 UTC 37.52935 -122.3142 San Mateo 29 []
788317 February 11, 2020 - 15:43:01 UTC 37.54125 -122.31441 San Mateo 29 []
670727 October 18, 2019 - 23:19:00 UTC 37.5685 -122.31448 San Mateo 29 []
708248 November 16, 2019 - 18:16:24 UTC 37.56223 -122.31461 San Mateo 29 []
645694 October 06, 2019 - 23:29:08 UTC 37.56357 -122.31471 San Mateo 29 []
779569 February 06, 2020 - 23:56:58 UTC 37.54453 -122.31479 San Mateo 29 []
647623 October 08, 2019 - 23:31:48 UTC 37.55249 -122.31487 San Mateo 29 []
724794 December 01, 2019 - 01:26:22 UTC 37.55249 -122.31487 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 93.313ms · About: About this site