outages

391 rows where regionName = 29

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
691310 October 28, 2019 - 14:18:00 UTC 37.54701 -122.31512 San Mateo 29 [{"latitude": "37.53611", "longitude": "-122.32305"}, {"latitude": "37.54571", "longitude": "-122.31408"}, {"latitude": "37.54868", "longitude": "-122.31284"}, {"latitude": "37.5489", "longitude": "-122.31311"}, {"latitude": "37.54896", "longitude": "-122.3138"}, {"latitude": "37.54868", "longitude": "-122.31534"}, {"latitude": "37.54843", "longitude": "-122.31636"}, {"latitude": "37.54533", "longitude": "-122.32688"}, {"latitude": "37.54266", "longitude": "-122.33206"}, {"latitude": "37.54033", "longitude": "-122.33513"}, {"latitude": "37.53738", "longitude": "-122.32774"}, {"latitude": "37.53665", "longitude": "-122.32535"}]
691349 October 28, 2019 - 15:02:11 UTC 37.57454 -122.33509 San Mateo 29 []
691449 October 28, 2019 - 16:09:00 UTC 37.5541 -122.33535 San Mateo 29 []
691451 October 28, 2019 - 16:09:43 UTC 37.52654 -122.30865 San Mateo 29 []
691603 October 28, 2019 - 17:23:31 UTC 37.53622 -122.31217 San Mateo 29 []
691859 October 28, 2019 - 20:00:00 UTC 37.51599 -122.32972 San Mateo 29 []
693217 October 29, 2019 - 15:09:02 UTC 37.55803 -122.28933 San Mateo 29 []
694115 October 29, 2019 - 20:43:33 UTC 37.53997 -122.30475 San Mateo 29 []
695338 October 30, 2019 - 20:14:07 UTC 37.56484 -122.3303 San Mateo 29 []
696961 October 31, 2019 - 22:20:47 UTC 37.56475 -122.30133 San Mateo 29 []
697326 November 01, 2019 - 16:15:31 UTC 37.56475 -122.30133 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 []
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 []
699126 November 04, 2019 - 17:36:52 UTC 37.55836 -122.29792 San Mateo 29 []
699204 November 04, 2019 - 18:25:15 UTC 37.52659 -122.33268 San Mateo 29 []
699343 November 04, 2019 - 20:06:00 UTC 37.54552 -122.2976 San Mateo 29 []
699527 November 04, 2019 - 23:43:01 UTC 37.55921 -122.29426 San Mateo 29 []
699537 November 05, 2019 - 00:02:42 UTC 37.57504 -122.31903 San Mateo 29 []
699839 November 05, 2019 - 16:23:11 UTC 37.57428 -122.32966 San Mateo 29 []
700108 November 05, 2019 - 20:08:54 UTC 37.56361 -122.35311 San Mateo 29 []
700670 November 06, 2019 - 17:07:49 UTC 37.55921 -122.29426 San Mateo 29 []
700715 November 06, 2019 - 17:27:00 UTC 37.53566 -122.30285 San Mateo 29 []
700917 November 06, 2019 - 19:23:27 UTC 37.5789 -122.31821 San Mateo 29 []
701005 November 06, 2019 - 20:39:46 UTC 37.55226 -122.32804 San Mateo 29 []
701293 November 07, 2019 - 01:59:55 UTC 37.54092 -122.2964 San Mateo 29 []
701531 November 07, 2019 - 15:03:02 UTC 37.54581 -122.28051 San Mateo 29 []
701834 November 07, 2019 - 18:06:46 UTC 37.52731 -122.30693 San Mateo 29 []
702126 November 07, 2019 - 22:59:06 UTC 37.57916 -122.32103 San Mateo 29 []
702153 November 07, 2019 - 23:42:42 UTC 37.5498 -122.32515 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 []
703028 November 09, 2019 - 00:24:40 UTC 37.523 -122.30293 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 []
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 []
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 []
704114 November 11, 2019 - 02:44:58 UTC 37.55558 -122.30263 San Mateo 29 []
706084 November 13, 2019 - 18:39:32 UTC 37.56132 -122.31213 San Mateo 29 []
706120 November 13, 2019 - 18:59:33 UTC 37.55364 -122.31549 San Mateo 29 []
706215 November 13, 2019 - 20:52:27 UTC 37.55036 -122.2973 San Mateo 29 []
706232 November 13, 2019 - 21:14:28 UTC 37.56453 -122.31236 San Mateo 29 []
706302 November 13, 2019 - 22:46:24 UTC 37.57832 -122.33314 San Mateo 29 []
706326 November 13, 2019 - 23:25:18 UTC 37.56179 -122.29091 San Mateo 29 []
706398 November 14, 2019 - 00:37:28 UTC 37.56481 -122.31097 San Mateo 29 []
706477 November 14, 2019 - 03:59:16 UTC 37.56893 -122.31239 San Mateo 29 []
706895 November 14, 2019 - 19:55:06 UTC 37.57526 -122.34023 San Mateo 29 []
707099 November 15, 2019 - 00:39:02 UTC 37.55788 -122.32394 San Mateo 29 []
707305 November 15, 2019 - 15:56:00 UTC 37.53958 -122.2802 San Mateo 29 []
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"}]
707345 November 15, 2019 - 16:26:00 UTC 37.53938 -122.2826 San Mateo 29 []
707386 November 15, 2019 - 16:55:32 UTC 37.55921 -122.2818 San Mateo 29 []
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"}]
708093 November 16, 2019 - 14:51:16 UTC 37.53628 -122.31621 San Mateo 29 []
708097 November 16, 2019 - 14:57:51 UTC 37.53669 -122.31519 San Mateo 29 []
708100 November 16, 2019 - 15:04:09 UTC 37.5304 -122.28433 San Mateo 29 []
708108 November 16, 2019 - 15:18:00 UTC 37.54963 -122.32252 San Mateo 29 []
708158 November 16, 2019 - 16:38:37 UTC 37.57337 -122.32745 San Mateo 29 []
708248 November 16, 2019 - 18:16:24 UTC 37.56223 -122.31461 San Mateo 29 []
708250 November 16, 2019 - 18:17:15 UTC 37.56109 -122.31337 San Mateo 29 []
708476 November 17, 2019 - 01:36:21 UTC 37.57672 -122.31846 San Mateo 29 []
708532 November 17, 2019 - 06:42:17 UTC 37.56856 -122.30133 San Mateo 29 []
708869 November 18, 2019 - 07:59:41 UTC 37.57328 -122.31866 San Mateo 29 []
708937 November 18, 2019 - 15:13:14 UTC 37.56899 -122.30183 San Mateo 29 []
709270 November 18, 2019 - 17:37:00 UTC 37.56632 -122.3211 San Mateo 29 []
709708 November 19, 2019 - 04:09:48 UTC 37.52802 -122.303 San Mateo 29 []
709721 November 19, 2019 - 05:15:09 UTC 37.52765 -122.30385 San Mateo 29 []
710234 November 19, 2019 - 21:07:37 UTC 37.55502 -122.32477 San Mateo 29 []
710470 November 20, 2019 - 02:12:59 UTC 37.57321 -122.33466 San Mateo 29 []
710754 November 20, 2019 - 15:17:57 UTC 37.55346 -122.32394 San Mateo 29 []
711007 November 20, 2019 - 16:21:06 UTC 37.56699 -122.34485 San Mateo 29 []
712167 November 21, 2019 - 17:36:00 UTC 37.549 -122.29036 San Mateo 29 []
712386 November 21, 2019 - 21:41:24 UTC 37.53194 -122.30971 San Mateo 29 []
712446 November 21, 2019 - 22:52:45 UTC 37.57065 -122.32809 San Mateo 29 []
712532 November 22, 2019 - 00:40:08 UTC 37.55396 -122.31418 San Mateo 29 []
712558 November 22, 2019 - 01:38:16 UTC 37.55142 -122.33608 San Mateo 29 []
713155 November 23, 2019 - 00:15:14 UTC 37.53413 -122.31937 San Mateo 29 []
713383 November 23, 2019 - 16:38:59 UTC 37.54198 -122.30011 San Mateo 29 []
713770 November 24, 2019 - 16:56:15 UTC 37.57669 -122.31933 San Mateo 29 []
713771 November 24, 2019 - 16:56:15 UTC 37.57682 -122.32 San Mateo 29 []
713873 November 24, 2019 - 18:20:00 UTC 37.54422 -122.28525 San Mateo 29 []
714370 November 25, 2019 - 19:33:47 UTC 37.56453 -122.31236 San Mateo 29 []
714469 November 25, 2019 - 20:45:09 UTC 37.52864 -122.30933 San Mateo 29 []
714640 November 25, 2019 - 22:16:00 UTC 37.56826 -122.32385 San Mateo 29 []
715812 November 26, 2019 - 22:22:08 UTC 37.56481 -122.31097 San Mateo 29 []
717588 November 27, 2019 - 02:53:29 UTC 37.52763 -122.30981 San Mateo 29 []
717593 November 27, 2019 - 02:54:10 UTC 37.52826 -122.30998 San Mateo 29 []
717752 November 27, 2019 - 03:12:15 UTC 37.56061 -122.30767 San Mateo 29 []
717824 November 27, 2019 - 03:19:10 UTC 37.56063 -122.30858 San Mateo 29 []
717854 November 27, 2019 - 03:21:31 UTC 37.54658 -122.28382 San Mateo 29 []
718226 November 27, 2019 - 03:59:06 UTC 37.56051 -122.32801 San Mateo 29 []
718527 November 27, 2019 - 04:35:00 UTC 37.55081 -122.2987 San Mateo 29 []
718534 November 27, 2019 - 04:35:05 UTC 37.55036 -122.2973 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 20.683ms · About: About this site