outages

297 rows where regionName = 33 sorted by latitude

View and edit SQL

id outageStartTime latitude ▼ longitude regionName outageDevices
687101 October 27, 2019 - 14:45:15 UTC 37.85217 -122.05739 Walnut Creek 33 []
685504 October 27, 2019 - 06:23:49 UTC 37.85535 -122.06817 Walnut Creek 33 [{"latitude": "37.85123", "longitude": "-122.0644"}, {"latitude": "37.85151", "longitude": "-122.06401"}, {"latitude": "37.85577", "longitude": "-122.06609"}, {"latitude": "37.85626", "longitude": "-122.06699"}, {"latitude": "37.85651", "longitude": "-122.06753"}, {"latitude": "37.85622", "longitude": "-122.06789"}, {"latitude": "37.85584", "longitude": "-122.06822"}, {"latitude": "37.85357", "longitude": "-122.06838"}, {"latitude": "37.85221", "longitude": "-122.06658"}]
685503 October 27, 2019 - 06:23:49 UTC 37.85536 -122.0657 Walnut Creek 33 []
704690 November 12, 2019 - 15:10:11 UTC 37.85586 -122.06944 Walnut Creek 33 []
685537 October 27, 2019 - 06:25:18 UTC 37.85681 -122.07438 Walnut Creek 33 []
685534 October 27, 2019 - 06:26:11 UTC 37.85787 -122.07579 Walnut Creek 33 []
685532 October 27, 2019 - 06:26:11 UTC 37.85945 -122.07604 Walnut Creek 33 []
658967 October 15, 2019 - 16:31:00 UTC 37.86391 -122.0786 Walnut Creek 33 []
685498 October 27, 2019 - 06:22:00 UTC 37.86391 -122.0786 Walnut Creek 33 []
691607 October 28, 2019 - 17:28:00 UTC 37.86446 -122.07839 Walnut Creek 33 []
690255 October 27, 2019 - 23:36:56 UTC 37.86452 -122.07842 Walnut Creek 33 []
652085 October 10, 2019 - 05:44:21 UTC 37.86475 -122.08089 Walnut Creek 33 [{"latitude": "37.826", "longitude": "-122.08537"}, {"latitude": "37.82757", "longitude": "-122.08155"}, {"latitude": "37.83163", "longitude": "-122.07802"}, {"latitude": "37.85292", "longitude": "-122.07779"}, {"latitude": "37.86275", "longitude": "-122.08226"}, {"latitude": "37.88199", "longitude": "-122.11192"}, {"latitude": "37.88376", "longitude": "-122.11837"}, {"latitude": "37.88398", "longitude": "-122.12168"}, {"latitude": "37.87989", "longitude": "-122.1286"}, {"latitude": "37.87132", "longitude": "-122.14028"}, {"latitude": "37.87025", "longitude": "-122.13987"}, {"latitude": "37.85999", "longitude": "-122.13521"}, {"latitude": "37.84284", "longitude": "-122.12458"}, {"latitude": "37.82637", "longitude": "-122.08725"}]
652097 October 10, 2019 - 05:46:00 UTC 37.86475 -122.08095 Walnut Creek 33 [{"latitude": "37.8536", "longitude": "-122.08989"}, {"latitude": "37.8552", "longitude": "-122.0855"}, {"latitude": "37.86361", "longitude": "-122.08173"}, {"latitude": "37.88153", "longitude": "-122.09982"}, {"latitude": "37.88457", "longitude": "-122.10455"}, {"latitude": "37.89078", "longitude": "-122.11445"}, {"latitude": "37.89126", "longitude": "-122.11845"}, {"latitude": "37.89126", "longitude": "-122.12318"}, {"latitude": "37.88959", "longitude": "-122.1283"}, {"latitude": "37.88891", "longitude": "-122.12927"}, {"latitude": "37.88491", "longitude": "-122.12981"}, {"latitude": "37.88322", "longitude": "-122.12906"}, {"latitude": "37.86473", "longitude": "-122.10985"}, {"latitude": "37.86014", "longitude": "-122.10177"}]
683249 October 27, 2019 - 03:08:00 UTC 37.86475 -122.08089 Walnut Creek 33 [{"latitude": "37.826", "longitude": "-122.08537"}, {"latitude": "37.82757", "longitude": "-122.08155"}, {"latitude": "37.83163", "longitude": "-122.07802"}, {"latitude": "37.85292", "longitude": "-122.07779"}, {"latitude": "37.86275", "longitude": "-122.08226"}, {"latitude": "37.88199", "longitude": "-122.11192"}, {"latitude": "37.88376", "longitude": "-122.11837"}, {"latitude": "37.88398", "longitude": "-122.12168"}, {"latitude": "37.87989", "longitude": "-122.1286"}, {"latitude": "37.87132", "longitude": "-122.14028"}, {"latitude": "37.87025", "longitude": "-122.13987"}, {"latitude": "37.85999", "longitude": "-122.13521"}, {"latitude": "37.84284", "longitude": "-122.12458"}, {"latitude": "37.82637", "longitude": "-122.08725"}]
683505 October 27, 2019 - 03:25:55 UTC 37.86475 -122.08095 Walnut Creek 33 [{"latitude": "37.8536", "longitude": "-122.08989"}, {"latitude": "37.8552", "longitude": "-122.0855"}, {"latitude": "37.86361", "longitude": "-122.08173"}, {"latitude": "37.88153", "longitude": "-122.09982"}, {"latitude": "37.88457", "longitude": "-122.10455"}, {"latitude": "37.89078", "longitude": "-122.11445"}, {"latitude": "37.89126", "longitude": "-122.11845"}, {"latitude": "37.89126", "longitude": "-122.12318"}, {"latitude": "37.88959", "longitude": "-122.1283"}, {"latitude": "37.88891", "longitude": "-122.12927"}, {"latitude": "37.88491", "longitude": "-122.12981"}, {"latitude": "37.88322", "longitude": "-122.12906"}, {"latitude": "37.86473", "longitude": "-122.10985"}, {"latitude": "37.86014", "longitude": "-122.10177"}]
690757 October 28, 2019 - 02:27:14 UTC 37.86782 -122.02694 Walnut Creek 33 []
706323 November 13, 2019 - 23:21:47 UTC 37.86852 -122.0267 Walnut Creek 33 []
706501 November 13, 2019 - 23:21:47 UTC 37.86852 -122.0267 Walnut Creek 33 []
689724 October 27, 2019 - 21:56:06 UTC 37.86999 -122.02049 Walnut Creek 33 []
690523 October 28, 2019 - 01:12:20 UTC 37.86999 -122.02049 Walnut Creek 33 []
721947 November 28, 2019 - 00:16:00 UTC 37.86999 -122.02049 Walnut Creek 33 []
732429 December 07, 2019 - 17:43:00 UTC 37.86999 -122.02665 Walnut Creek 33 []
633546 October 01, 2019 - 13:07:08 UTC 37.87055 -122.03021 Walnut Creek 33 []
635653 October 02, 2019 - 04:24:00 UTC 37.87056 -122.03111 Walnut Creek 33 []
732433 December 07, 2019 - 17:46:46 UTC 37.87076 -122.02732 Walnut Creek 33 []
721954 November 28, 2019 - 00:18:40 UTC 37.87192 -122.03359 Walnut Creek 33 []
689199 October 27, 2019 - 20:57:38 UTC 37.87245 -122.08131 Walnut Creek 33 []
735221 December 10, 2019 - 16:17:48 UTC 37.87429 -122.03266 Walnut Creek 33 []
692099 October 28, 2019 - 22:01:51 UTC 37.87513 -122.0874 Walnut Creek 33 []
706288 November 13, 2019 - 22:22:33 UTC 37.87529 -122.08656 Walnut Creek 33 []
689986 October 27, 2019 - 22:35:11 UTC 37.87602 -122.08757 Walnut Creek 33 []
781016 February 09, 2020 - 15:07:49 UTC 37.87619 -122.03096 Walnut Creek 33 []
729570 December 04, 2019 - 17:31:48 UTC 37.87635 -122.03202 Walnut Creek 33 []
721951 November 28, 2019 - 00:17:00 UTC 37.87687 -122.03554 Walnut Creek 33 []
687945 October 27, 2019 - 18:06:19 UTC 37.87801 -122.0739 Walnut Creek 33 []
699921 November 05, 2019 - 17:14:49 UTC 37.87883 -122.08108 Walnut Creek 33 []
707809 November 15, 2019 - 21:29:28 UTC 37.87927 -122.07256 Walnut Creek 33 []
715043 November 26, 2019 - 15:09:34 UTC 37.88079 -122.06511 Walnut Creek 33 []
697641 November 01, 2019 - 20:34:00 UTC 37.88121 -122.05971 Walnut Creek 33 [{"latitude": "37.88028", "longitude": "-122.06177"}, {"latitude": "37.88115", "longitude": "-122.06007"}, {"latitude": "37.88368", "longitude": "-122.06218"}, {"latitude": "37.88327", "longitude": "-122.06308"}]
633894 October 01, 2019 - 17:08:16 UTC 37.88173 -122.06065 Walnut Creek 33 []
743655 December 16, 2019 - 22:04:31 UTC 37.88183 -122.0252 Walnut Creek 33 []
711621 November 20, 2019 - 20:53:48 UTC 37.88209 -122.05351 Walnut Creek 33 []
728931 December 03, 2019 - 22:08:53 UTC 37.88212 -122.04943 Walnut Creek 33 []
709789 November 19, 2019 - 14:48:01 UTC 37.88252 -122.0567 Walnut Creek 33 []
722827 November 28, 2019 - 18:23:00 UTC 37.88263 -122.02252 Walnut Creek 33 []
655851 October 14, 2019 - 15:09:02 UTC 37.88279 -122.06069 Walnut Creek 33 []
688156 October 27, 2019 - 18:42:12 UTC 37.88349 -122.06082 Walnut Creek 33 []
691403 October 28, 2019 - 15:42:58 UTC 37.88349 -122.06082 Walnut Creek 33 []
697140 November 01, 2019 - 02:33:41 UTC 37.88373 -122.05698 Walnut Creek 33 []
702636 November 08, 2019 - 17:29:42 UTC 37.88476 -122.05169 Walnut Creek 33 []
688684 October 27, 2019 - 20:01:55 UTC 37.88703 -122.06095 Walnut Creek 33 []
694167 October 29, 2019 - 21:18:56 UTC 37.88703 -122.06095 Walnut Creek 33 []
694204 October 29, 2019 - 21:46:09 UTC 37.88758 -122.05969 Walnut Creek 33 []
653028 October 10, 2019 - 18:42:05 UTC 37.88767 -122.02371 Walnut Creek 33 []
654391 October 11, 2019 - 18:50:38 UTC 37.88767 -122.02371 Walnut Creek 33 []
688756 October 27, 2019 - 20:13:00 UTC 37.88777 -122.06097 Walnut Creek 33 []
694391 October 29, 2019 - 23:42:45 UTC 37.88777 -122.06097 Walnut Creek 33 []
721958 November 28, 2019 - 00:19:50 UTC 37.8887 -122.02023 Walnut Creek 33 []
714999 November 26, 2019 - 12:12:00 UTC 37.88964 -122.06315 Walnut Creek 33 [{"latitude": "37.88158", "longitude": "-122.07079"}, {"latitude": "37.88178", "longitude": "-122.06968"}, {"latitude": "37.8829", "longitude": "-122.06574"}, {"latitude": "37.88333", "longitude": "-122.06474"}, {"latitude": "37.88979", "longitude": "-122.0639"}, {"latitude": "37.89106", "longitude": "-122.06643"}, {"latitude": "37.89199", "longitude": "-122.06844"}, {"latitude": "37.88958", "longitude": "-122.07996"}, {"latitude": "37.8863", "longitude": "-122.07984"}]
721952 November 28, 2019 - 00:17:00 UTC 37.88971 -122.0252 Walnut Creek 33 []
731604 December 06, 2019 - 21:39:23 UTC 37.88979 -122.0639 Walnut Creek 33 []
689768 October 27, 2019 - 22:03:15 UTC 37.89118 -122.04786 Walnut Creek 33 []
691658 October 28, 2019 - 17:55:01 UTC 37.89125 -122.04036 Walnut Creek 33 []
717337 November 27, 2019 - 02:30:25 UTC 37.89125 -122.04036 Walnut Creek 33 []
659831 October 15, 2019 - 21:28:54 UTC 37.89195 -122.05035 Walnut Creek 33 []
632153 September 30, 2019 - 20:18:37 UTC 37.89203 -122.03894 Walnut Creek 33 []
647016 October 08, 2019 - 04:04:00 UTC 37.89259 -122.0616 Walnut Creek 33 []
715010 November 26, 2019 - 13:42:59 UTC 37.89271 -122.05559 Walnut Creek 33 []
778920 February 06, 2020 - 15:06:07 UTC 37.89273 -122.05229 Walnut Creek 33 []
737972 December 13, 2019 - 05:21:43 UTC 37.89375 -122.05455 Walnut Creek 33 [{"latitude": "37.89367", "longitude": "-122.05377"}, {"latitude": "37.89436", "longitude": "-122.05378"}, {"latitude": "37.89433", "longitude": "-122.05441"}]
667311 October 18, 2019 - 05:05:00 UTC 37.89399 -122.06147 Walnut Creek 33 [{"latitude": "37.89392", "longitude": "-122.06065"}, {"latitude": "37.89408", "longitude": "-122.06133"}, {"latitude": "37.89424", "longitude": "-122.06248"}]
667314 October 18, 2019 - 05:05:00 UTC 37.89424 -122.06248 Walnut Creek 33 []
690531 October 28, 2019 - 01:17:01 UTC 37.89474 -122.07015 Walnut Creek 33 []
693987 October 29, 2019 - 19:21:49 UTC 37.89474 -122.07015 Walnut Creek 33 []
737976 December 13, 2019 - 05:35:51 UTC 37.89486 -122.05331 Walnut Creek 33 []
692491 October 29, 2019 - 00:45:42 UTC 37.89493 -122.05392 Walnut Creek 33 []
696561 October 31, 2019 - 17:06:53 UTC 37.89654 -122.05052 Walnut Creek 33 []
780036 February 07, 2020 - 18:07:46 UTC 37.89654 -122.05052 Walnut Creek 33 []
693544 October 29, 2019 - 17:06:29 UTC 37.89735 -122.07031 Walnut Creek 33 []
694592 October 30, 2019 - 02:51:36 UTC 37.89735 -122.07031 Walnut Creek 33 []
694852 October 30, 2019 - 15:43:21 UTC 37.89735 -122.07031 Walnut Creek 33 []
779487 February 06, 2020 - 21:46:48 UTC 37.89771 -122.05336 Walnut Creek 33 []
700977 November 06, 2019 - 20:19:26 UTC 37.898 -122.05478 Walnut Creek 33 []
738023 December 13, 2019 - 08:45:36 UTC 37.89846 -122.06337 Walnut Creek 33 []
702530 November 08, 2019 - 16:37:30 UTC 37.89878 -122.05604 Walnut Creek 33 []
691495 October 28, 2019 - 16:17:32 UTC 37.89903 -122.06128 Walnut Creek 33 []
691328 October 28, 2019 - 14:39:11 UTC 37.89914 -122.06516 Walnut Creek 33 []
687717 October 27, 2019 - 17:30:39 UTC 37.89922 -122.06453 Walnut Creek 33 []
690910 October 28, 2019 - 04:12:02 UTC 37.89922 -122.06453 Walnut Creek 33 []
694987 October 30, 2019 - 17:00:00 UTC 37.89922 -122.06453 Walnut Creek 33 []
638829 October 03, 2019 - 00:57:19 UTC 37.8997 -122.04257 Walnut Creek 33 []
729784 December 04, 2019 - 20:05:39 UTC 37.89979 -122.05528 Walnut Creek 33 []
691571 October 28, 2019 - 16:57:38 UTC 37.90024 -122.06891 Walnut Creek 33 []
688052 October 27, 2019 - 18:23:03 UTC 37.90087 -122.04968 Walnut Creek 33 []
691965 October 28, 2019 - 20:48:28 UTC 37.90087 -122.04968 Walnut Creek 33 []
690577 October 28, 2019 - 01:30:42 UTC 37.90112 -122.07152 Walnut Creek 33 []
691777 October 28, 2019 - 19:09:19 UTC 37.90117 -122.04876 Walnut Creek 33 []
711877 November 21, 2019 - 03:41:03 UTC 37.90117 -122.04876 Walnut Creek 33 []
687622 October 27, 2019 - 17:07:49 UTC 37.90122 -122.06624 Walnut Creek 33 []
736435 December 11, 2019 - 18:57:18 UTC 37.90122 -122.05845 Walnut Creek 33 []

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