outages

391 rows where regionName = 29 sorted by latitude

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude ▼ longitude regionName outageDevices
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"}]
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 []
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 []
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 []
675923 October 21, 2019 - 16:08:16 UTC 37.52843 -122.32135 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 []
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 []
712386 November 21, 2019 - 21:41:24 UTC 37.53194 -122.30971 San Mateo 29 []
658254 October 14, 2019 - 21:18:25 UTC 37.53267 -122.29308 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 []
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"}]
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 []
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 []
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 []
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 []
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 []
655695 October 14, 2019 - 02:08:00 UTC 37.54148 -122.28401 San Mateo 29 []
780013 February 07, 2020 - 17:47:55 UTC 37.54164 -122.30386 San Mateo 29 []
713383 November 23, 2019 - 16:38:59 UTC 37.54198 -122.30011 San Mateo 29 []
787819 February 10, 2020 - 23:47:54 UTC 37.54229 -122.28011 San Mateo 29 []
676027 October 21, 2019 - 17:13:00 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"}]
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"}]
738408 December 13, 2019 - 17:53:00 UTC 37.54328 -122.29866 San Mateo 29 []
676687 October 22, 2019 - 15:44:26 UTC 37.54357 -122.31947 San Mateo 29 []
713873 November 24, 2019 - 18:20:00 UTC 37.54422 -122.28525 San Mateo 29 []
647436 October 08, 2019 - 18:31:04 UTC 37.54443 -122.30983 San Mateo 29 []
779569 February 06, 2020 - 23:56:58 UTC 37.54453 -122.31479 San Mateo 29 []
651175 October 09, 2019 - 21:47:00 UTC 37.5446 -122.3322 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 []
783992 February 09, 2020 - 20:41:16 UTC 37.54486 -122.32979 San Mateo 29 []
786299 February 10, 2020 - 03:46:15 UTC 37.54486 -122.32979 San Mateo 29 []
726082 December 01, 2019 - 20:48:00 UTC 37.5453 -122.30803 San Mateo 29 []
644634 October 05, 2019 - 17:34:05 UTC 37.54535 -122.31665 San Mateo 29 []
699343 November 04, 2019 - 20:06:00 UTC 37.54552 -122.2976 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 1495.583ms · About: About this site