outages

91 rows where regionName = 87

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices
633639 October 01, 2019 - 15:23:14 UTC 37.34955 -120.60969 Atwater 87 []
635462 October 02, 2019 - 01:49:40 UTC 37.3462 -120.54849 Atwater 87 []
638073 October 02, 2019 - 21:16:00 UTC 37.3458 -120.63575 Atwater 87 []
638658 October 02, 2019 - 23:12:37 UTC 37.35685 -120.60081 Atwater 87 []
645806 October 07, 2019 - 14:12:40 UTC 37.35353 -120.60599 Atwater 87 []
645997 October 07, 2019 - 17:07:05 UTC 37.35602 -120.61792 Atwater 87 []
647792 October 09, 2019 - 06:01:24 UTC 37.36581 -120.62241 Atwater 87 []
653437 October 10, 2019 - 21:40:19 UTC 37.35143 -120.64764 Atwater 87 []
654059 October 11, 2019 - 08:52:00 UTC 37.36004 -120.61447 Atwater 87 [{"latitude": "37.30275", "longitude": "-120.60239"}, {"latitude": "37.30284", "longitude": "-120.59984"}, {"latitude": "37.30652", "longitude": "-120.58913"}, {"latitude": "37.30875", "longitude": "-120.58456"}, {"latitude": "37.31175", "longitude": "-120.5796"}, {"latitude": "37.33138", "longitude": "-120.5849"}, {"latitude": "37.33761", "longitude": "-120.59135"}, {"latitude": "37.34241", "longitude": "-120.59693"}, {"latitude": "37.35484", "longitude": "-120.6133"}, {"latitude": "37.35739", "longitude": "-120.61679"}, {"latitude": "37.35874", "longitude": "-120.61976"}, {"latitude": "37.35877", "longitude": "-120.62099"}, {"latitude": "37.35455", "longitude": "-120.62848"}, {"latitude": "37.35335", "longitude": "-120.62949"}, {"latitude": "37.30645", "longitude": "-120.62826"}, {"latitude": "37.30484", "longitude": "-120.62795"}]
654065 October 11, 2019 - 09:34:58 UTC 37.34833 -120.61479 Atwater 87 []
655363 October 12, 2019 - 23:41:17 UTC 37.34522 -120.59564 Atwater 87 []
658966 October 15, 2019 - 16:30:04 UTC 37.34477 -120.59234 Atwater 87 []
659932 October 16, 2019 - 00:17:41 UTC 37.35993 -120.60614 Atwater 87 []
664105 October 17, 2019 - 16:23:06 UTC 37.34546 -120.59193 Atwater 87 []
667214 October 18, 2019 - 00:46:08 UTC 37.33641 -120.5729 Atwater 87 []
667295 October 18, 2019 - 04:00:34 UTC 37.31842 -120.55763 Atwater 87 []
668254 October 18, 2019 - 16:19:42 UTC 37.36415 -120.58035 Atwater 87 []
674983 October 21, 2019 - 08:46:15 UTC 37.3462 -120.54849 Atwater 87 []
676016 October 21, 2019 - 17:06:03 UTC 37.33927 -120.55878 Atwater 87 []
677228 October 23, 2019 - 03:23:10 UTC 37.35037 -120.59833 Atwater 87 []
679843 October 24, 2019 - 22:39:28 UTC 37.35477 -120.59993 Atwater 87 []
688621 October 27, 2019 - 19:53:00 UTC 37.36993 -120.67741 Atwater 87 []
688790 October 27, 2019 - 20:16:00 UTC 37.3672 -120.67655 Atwater 87 []
689189 October 27, 2019 - 20:56:34 UTC 37.35076 -120.60518 Atwater 87 []
691906 October 28, 2019 - 20:21:33 UTC 37.35448 -120.59887 Atwater 87 []
692075 October 28, 2019 - 21:51:54 UTC 37.34907 -120.60378 Atwater 87 []
693218 October 29, 2019 - 15:09:10 UTC 37.29765 -120.67763 Atwater 87 []
697613 November 01, 2019 - 20:05:00 UTC 37.35924 -120.62179 Atwater 87 []
697979 November 02, 2019 - 01:25:43 UTC 37.35097 -120.59806 Atwater 87 []
698117 November 02, 2019 - 15:39:47 UTC 37.34997 -120.59607 Atwater 87 [{"latitude": "37.34989", "longitude": "-120.59675"}, {"latitude": "37.35056", "longitude": "-120.59681"}, {"latitude": "37.35132", "longitude": "-120.59879"}, {"latitude": "37.35037", "longitude": "-120.59833"}]
698239 November 02, 2019 - 17:43:00 UTC 37.34997 -120.59607 Atwater 87 []
698304 November 02, 2019 - 21:17:31 UTC 37.35058 -120.59685 Atwater 87 []
698305 November 02, 2019 - 21:25:55 UTC 37.34997 -120.59607 Atwater 87 [{"latitude": "37.34989", "longitude": "-120.59675"}, {"latitude": "37.35132", "longitude": "-120.59879"}, {"latitude": "37.35037", "longitude": "-120.59833"}]
701090 November 06, 2019 - 22:28:35 UTC 37.36231 -120.58014 Atwater 87 []
706239 November 13, 2019 - 21:18:00 UTC 37.35078 -120.62006 Atwater 87 []
707489 November 15, 2019 - 17:47:21 UTC 37.34573 -120.66831 Atwater 87 []
707827 November 15, 2019 - 21:58:00 UTC 37.35162 -120.62034 Atwater 87 []
708409 November 16, 2019 - 22:21:55 UTC 37.35078 -120.62006 Atwater 87 []
708836 November 18, 2019 - 05:03:41 UTC 37.34934 -120.60566 Atwater 87 []
709600 November 19, 2019 - 00:39:54 UTC 37.28598 -120.59794 Atwater 87 []
711936 November 21, 2019 - 10:09:05 UTC 37.33721 -120.5772 Atwater 87 [{"latitude": "37.33718", "longitude": "-120.58326"}, {"latitude": "37.33788", "longitude": "-120.5772"}, {"latitude": "37.33893", "longitude": "-120.5766"}, {"latitude": "37.34549", "longitude": "-120.57524"}, {"latitude": "37.34669", "longitude": "-120.5768"}, {"latitude": "37.34723", "longitude": "-120.57915"}, {"latitude": "37.34526", "longitude": "-120.58277"}, {"latitude": "37.34026", "longitude": "-120.58604"}]
711948 November 21, 2019 - 12:16:55 UTC 37.33721 -120.5772 Atwater 87 [{"latitude": "37.33718", "longitude": "-120.58326"}, {"latitude": "37.33788", "longitude": "-120.5772"}, {"latitude": "37.34549", "longitude": "-120.57524"}, {"latitude": "37.34669", "longitude": "-120.5768"}, {"latitude": "37.34723", "longitude": "-120.57915"}, {"latitude": "37.34526", "longitude": "-120.58277"}, {"latitude": "37.34026", "longitude": "-120.58604"}]
713900 November 24, 2019 - 21:19:52 UTC 37.34108 -120.58857 Atwater 87 []
714243 November 25, 2019 - 17:30:50 UTC 37.35817 -120.601 Atwater 87 []
714597 November 25, 2019 - 21:52:21 UTC 37.34672 -120.61033 Atwater 87 []
719207 November 27, 2019 - 06:25:28 UTC 37.34639 -120.5954 Atwater 87 []
719430 November 27, 2019 - 07:35:49 UTC 37.34627 -120.60865 Atwater 87 []
719721 November 27, 2019 - 10:33:20 UTC 37.36004 -120.61447 Atwater 87 [{"latitude": "37.30275", "longitude": "-120.60239"}, {"latitude": "37.30284", "longitude": "-120.59984"}, {"latitude": "37.30652", "longitude": "-120.58913"}, {"latitude": "37.30875", "longitude": "-120.58456"}, {"latitude": "37.31175", "longitude": "-120.5796"}, {"latitude": "37.33138", "longitude": "-120.5849"}, {"latitude": "37.33761", "longitude": "-120.59135"}, {"latitude": "37.34241", "longitude": "-120.59693"}, {"latitude": "37.35484", "longitude": "-120.6133"}, {"latitude": "37.35739", "longitude": "-120.61679"}, {"latitude": "37.35874", "longitude": "-120.61976"}, {"latitude": "37.35877", "longitude": "-120.62099"}, {"latitude": "37.35455", "longitude": "-120.62848"}, {"latitude": "37.35335", "longitude": "-120.62949"}, {"latitude": "37.30645", "longitude": "-120.62826"}, {"latitude": "37.30484", "longitude": "-120.62795"}]
721660 November 27, 2019 - 21:24:12 UTC 37.35237 -120.62241 Atwater 87 []
721822 November 27, 2019 - 23:02:49 UTC 37.34241 -120.59693 Atwater 87 []
723423 November 29, 2019 - 17:04:43 UTC 37.34605 -120.61605 Atwater 87 []
724270 November 30, 2019 - 21:12:52 UTC 37.32958 -120.55892 Atwater 87 []
726329 December 02, 2019 - 00:13:20 UTC 37.34895 -120.61743 Atwater 87 []
726466 December 02, 2019 - 01:44:06 UTC 37.34895 -120.61743 Atwater 87 []
728448 December 03, 2019 - 16:45:34 UTC 37.35262 -120.69889 Atwater 87 []
730183 December 05, 2019 - 07:50:23 UTC 37.35145 -120.61868 Atwater 87 []
730783 December 05, 2019 - 22:45:16 UTC 37.33795 -120.58037 Atwater 87 []
733723 December 08, 2019 - 19:40:43 UTC 37.35563 -120.58364 Atwater 87 []
735796 December 10, 2019 - 22:31:29 UTC 37.33748 -120.60038 Atwater 87 []
735876 December 10, 2019 - 23:51:51 UTC 37.3512 -120.59481 Atwater 87 []
737153 December 12, 2019 - 15:49:21 UTC 37.3569 -120.55218 Atwater 87 []
737688 December 12, 2019 - 21:28:41 UTC 37.3569 -120.55218 Atwater 87 []
737903 December 13, 2019 - 01:16:22 UTC 37.34173 -120.59484 Atwater 87 []
738467 December 13, 2019 - 18:42:16 UTC 37.35784 -120.57833 Atwater 87 []
744797 December 17, 2019 - 22:53:44 UTC 37.34913 -120.59176 Atwater 87 []
744853 December 17, 2019 - 23:07:00 UTC 37.35351 -120.62327 Atwater 87 []
779568 February 06, 2020 - 23:56:15 UTC 37.36707 -120.65023 Atwater 87 [{"latitude": "37.36309", "longitude": "-120.65028"}, {"latitude": "37.36665", "longitude": "-120.64943"}, {"latitude": "37.36386", "longitude": "-120.65283"}]
787109 February 10, 2020 - 16:57:45 UTC 37.3385 -120.65616 Atwater 87 []
787646 February 10, 2020 - 21:44:25 UTC 37.34066 -120.58776 Atwater 87 []
789005 February 12, 2020 - 00:03:31 UTC 37.34634 -120.6008 Atwater 87 []
1061247 September 08, 2020 - 21:15:33 UTC 37.34672 -120.5954 Atwater 87 []
1061309 September 08, 2020 - 22:03:37 UTC 37.35327 -120.72321 Atwater 87 []
1061385 September 08, 2020 - 23:26:30 UTC 37.34509 -120.6054 Atwater 87 []
1062407 September 10, 2020 - 00:25:15 UTC 37.36189 -120.57672 Atwater 87 []
1062958 September 10, 2020 - 17:27:34 UTC 37.35216 -120.5988 Atwater 87 []
1065498 September 12, 2020 - 15:14:00 UTC 37.36156 -120.61024 Atwater 87 []
1069519 September 14, 2020 - 19:35:49 UTC 37.3515 -120.61151 Atwater 87 []
1070933 September 15, 2020 - 14:47:21 UTC 37.34303 -120.68495 Atwater 87 []
1072674 September 15, 2020 - 20:42:30 UTC 37.33126 -120.66122 Atwater 87 []
1073502 September 16, 2020 - 00:14:56 UTC 37.33084 -120.65981 Atwater 87 []
1073667 September 16, 2020 - 02:12:58 UTC 37.34191 -120.56116 Atwater 87 []
1077784 September 17, 2020 - 16:23:29 UTC 37.35346 -120.56335 Atwater 87 []
1088013 September 22, 2020 - 20:10:59 UTC 37.35078 -120.62006 Atwater 87 []
1091777 September 24, 2020 - 23:40:40 UTC 37.35273 -120.61561 Atwater 87 []
1091778 September 24, 2020 - 23:40:40 UTC 37.35113 -120.61654 Atwater 87 []
1092274 September 25, 2020 - 16:32:33 UTC 37.34778 -120.59539 Atwater 87 []
1094614 September 26, 2020 - 22:52:50 UTC 37.35613 -120.59643 Atwater 87 []
1096152 September 28, 2020 - 16:29:45 UTC 37.34044 -120.58468 Atwater 87 []
1097495 September 29, 2020 - 14:33:01 UTC 37.36235 -120.58333 Atwater 87 []
1097814 September 29, 2020 - 15:30:21 UTC 37.32558 -120.61011 Atwater 87 []
1097954 September 29, 2020 - 16:02:13 UTC 37.35311 -120.60131 Atwater 87 []

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 341.702ms · About: About this site