outages

447 rows where regionName = 29 sorted by outageDevices

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices ▼
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 []
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 []
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 []
718536 November 27, 2019 - 04:36:05 UTC 37.54986 -122.29917 San Mateo 29 []
718611 November 27, 2019 - 04:44:00 UTC 37.54467 -122.30729 San Mateo 29 []
719054 November 27, 2019 - 05:49:50 UTC 37.54035 -122.30338 San Mateo 29 []
719214 November 27, 2019 - 06:28:24 UTC 37.5313 -122.27828 San Mateo 29 []
719354 November 27, 2019 - 06:55:00 UTC 37.54035 -122.30338 San Mateo 29 []
719514 November 27, 2019 - 08:07:04 UTC 37.57328 -122.31866 San Mateo 29 []
719517 November 27, 2019 - 04:44:00 UTC 37.54467 -122.30729 San Mateo 29 []
719735 November 27, 2019 - 10:44:56 UTC 37.52863 -122.31889 San Mateo 29 []
720051 November 27, 2019 - 13:22:21 UTC 37.54917 -122.31017 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 []
720409 November 27, 2019 - 15:26:48 UTC 37.56607 -122.31235 San Mateo 29 []
720493 November 27, 2019 - 15:54:02 UTC 37.53775 -122.31763 San Mateo 29 []
720621 November 27, 2019 - 16:31:11 UTC 37.55547 -122.31653 San Mateo 29 []
720860 November 27, 2019 - 17:24:55 UTC 37.523 -122.30293 San Mateo 29 []
721133 November 27, 2019 - 18:35:33 UTC 37.55004 -122.29836 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 1348.225ms · About: About this site