75 rows where regionName = 65

View and edit SQL

Suggested facets: outageDevices

id ▼ outageStartTime latitude longitude regionName outageDevices
633586 October 01, 2019 - 14:42:30 UTC 38.03178 -122.2639 Rodeo 65 []
650765 October 09, 2019 - 15:49:00 UTC 38.03553 -122.25833 Rodeo 65 [{"latitude": "38.04367", "longitude": "-122.25738"}, {"latitude": "38.04558", "longitude": "-122.23367"}, {"latitude": "38.04669", "longitude": "-122.23045"}, {"latitude": "38.04757", "longitude": "-122.22798"}, {"latitude": "38.05588", "longitude": "-122.2253"}, {"latitude": "38.05652", "longitude": "-122.22815"}, {"latitude": "38.05734", "longitude": "-122.23585"}, {"latitude": "38.05396", "longitude": "-122.24123"}]
653770 October 11, 2019 - 01:30:47 UTC 38.02227 -122.2556 Rodeo 65 []
659840 October 15, 2019 - 21:36:00 UTC 38.0397 -122.264 Rodeo 65 [{"latitude": "38.03985", "longitude": "-122.26368"}, {"latitude": "38.04837", "longitude": "-122.24706"}, {"latitude": "38.04987", "longitude": "-122.24537"}, {"latitude": "38.05414", "longitude": "-122.24792"}, {"latitude": "38.04134", "longitude": "-122.26349"}]
660771 October 16, 2019 - 17:43:00 UTC 38.026 -122.26314 Rodeo 65 []
660873 October 16, 2019 - 18:29:53 UTC 38.04367 -122.25738 Rodeo 65 []
662365 October 16, 2019 - 21:21:00 UTC 38.03553 -122.25833 Rodeo 65 []
667156 October 18, 2019 - 00:04:53 UTC 38.04808 -122.24849 Rodeo 65 []
683217 October 27, 2019 - 03:05:00 UTC 38.03553 -122.25833 Rodeo 65 [{"latitude": "38.04367", "longitude": "-122.25738"}, {"latitude": "38.04558", "longitude": "-122.23367"}, {"latitude": "38.04669", "longitude": "-122.23045"}, {"latitude": "38.04757", "longitude": "-122.22798"}]
683381 October 27, 2019 - 03:17:00 UTC 38.04839 -122.24813 Rodeo 65 [{"latitude": "38.04837", "longitude": "-122.24706"}, {"latitude": "38.04987", "longitude": "-122.24537"}, {"latitude": "38.05414", "longitude": "-122.24792"}, {"latitude": "38.05066", "longitude": "-122.24978"}, {"latitude": "38.04876", "longitude": "-122.24797"}]
689807 October 27, 2019 - 22:10:29 UTC 38.02227 -122.2556 Rodeo 65 []
696048 October 31, 2019 - 01:31:33 UTC 38.03414 -122.2652 Rodeo 65 [{"latitude": "38.02843", "longitude": "-122.26333"}, {"latitude": "38.03391", "longitude": "-122.26434"}, {"latitude": "38.03374", "longitude": "-122.26527"}, {"latitude": "38.03311", "longitude": "-122.26632"}, {"latitude": "38.02926", "longitude": "-122.26441"}]
696149 October 31, 2019 - 02:39:00 UTC 38.03184 -122.26331 Rodeo 65 []
696819 October 31, 2019 - 20:07:39 UTC 38.03655 -122.27176 Rodeo 65 []
707084 November 15, 2019 - 00:21:07 UTC 38.04095 -122.26184 Rodeo 65 []
707123 November 15, 2019 - 01:20:17 UTC 38.04837 -122.24706 Rodeo 65 []
707134 November 15, 2019 - 01:38:00 UTC 38.04837 -122.24706 Rodeo 65 []
707155 November 15, 2019 - 03:40:27 UTC 38.04837 -122.24706 Rodeo 65 []
711682 November 20, 2019 - 21:49:47 UTC 38.03311 -122.26632 Rodeo 65 []
714724 November 25, 2019 - 23:15:36 UTC 38.03052 -122.26133 Rodeo 65 []
717736 November 27, 2019 - 03:10:30 UTC 38.03464 -122.26096 Rodeo 65 []
723175 November 29, 2019 - 00:41:00 UTC 38.03464 -122.26096 Rodeo 65 []
723374 November 29, 2019 - 16:07:00 UTC 38.03464 -122.26096 Rodeo 65 []
730025 December 05, 2019 - 00:49:28 UTC 38.01604 -122.25507 Rodeo 65 []
730221 December 05, 2019 - 13:40:00 UTC 38.01604 -122.25507 Rodeo 65 []
730694 December 05, 2019 - 21:29:47 UTC 38.01604 -122.25507 Rodeo 65 []
740277 December 15, 2019 - 21:11:08 UTC 38.03184 -122.26331 Rodeo 65 []
787116 February 10, 2020 - 17:01:46 UTC 38.03161 -122.26152 Rodeo 65 []
789651 February 12, 2020 - 21:10:14 UTC 38.02879 -122.26673 Rodeo 65 []
790583 February 13, 2020 - 23:36:22 UTC 38.03655 -122.27176 Rodeo 65 []
1063836 September 10, 2020 - 22:47:32 UTC 38.03199 -122.27146 Rodeo 65 []
1079543 September 18, 2020 - 01:26:17 UTC 38.03683 -122.26683 Rodeo 65 []
1097897 September 29, 2020 - 15:43:05 UTC 38.03104 -122.25917 Rodeo 65 []
1105764 October 02, 2020 - 00:02:15 UTC 38.03212 -122.26033 Rodeo 65 []
1105842 October 02, 2020 - 01:26:21 UTC 38.03052 -122.26133 Rodeo 65 []
1105843 October 02, 2020 - 01:26:20 UTC 38.03161 -122.25949 Rodeo 65 []
1113829 October 09, 2020 - 03:16:00 UTC 38.02728 -122.25952 Rodeo 65 [{"latitude": "38.02442", "longitude": "-122.26226"}, {"latitude": "38.02596", "longitude": "-122.26077"}, {"latitude": "38.02641", "longitude": "-122.26034"}, {"latitude": "38.02689", "longitude": "-122.25989"}, {"latitude": "38.02909", "longitude": "-122.25898"}, {"latitude": "38.02972", "longitude": "-122.25915"}, {"latitude": "38.0295", "longitude": "-122.25996"}, {"latitude": "38.02774", "longitude": "-122.26534"}, {"latitude": "38.02556", "longitude": "-122.2642"}, {"latitude": "38.0251", "longitude": "-122.26395"}, {"latitude": "38.02458", "longitude": "-122.26317"}]
1115188 October 11, 2020 - 15:52:20 UTC 38.02645 -122.25056 Rodeo 65 []
1117360 October 14, 2020 - 20:10:05 UTC 38.02724 -122.26074 Rodeo 65 []
1130310 October 28, 2020 - 01:06:05 UTC 38.02513 -122.24495 Rodeo 65 []
1135707 November 04, 2020 - 17:53:04 UTC 38.04883 -122.24735 Rodeo 65 [{"latitude": "38.04917", "longitude": "-122.24775"}, {"latitude": "38.05088", "longitude": "-122.24941"}, {"latitude": "38.05066", "longitude": "-122.24978"}]
1136818 November 05, 2020 - 22:56:38 UTC 38.03656 -122.2627 Rodeo 65 []
1146728 November 17, 2020 - 14:32:00 UTC 38.03414 -122.2652 Rodeo 65 [{"latitude": "38.02843", "longitude": "-122.26333"}, {"latitude": "38.03391", "longitude": "-122.26434"}, {"latitude": "38.03374", "longitude": "-122.26527"}, {"latitude": "38.03311", "longitude": "-122.26632"}, {"latitude": "38.02926", "longitude": "-122.26441"}]
1146746 November 17, 2020 - 15:15:00 UTC 38.03184 -122.26331 Rodeo 65 []
1155191 November 27, 2020 - 18:43:57 UTC 38.02689 -122.25989 Rodeo 65 []
1160709 December 03, 2020 - 20:37:14 UTC 38.02458 -122.24748 Rodeo 65 []
1164647 December 05, 2020 - 18:22:22 UTC 38.03413 -122.27112 Rodeo 65 [{"latitude": "38.03199", "longitude": "-122.27146"}, {"latitude": "38.03408", "longitude": "-122.27145"}, {"latitude": "38.03462", "longitude": "-122.27208"}, {"latitude": "38.03433", "longitude": "-122.27298"}, {"latitude": "38.03319", "longitude": "-122.27271"}]
1168567 December 07, 2020 - 18:51:03 UTC 38.01841 -122.2532 Rodeo 65 []
1182473 December 13, 2020 - 17:47:37 UTC 38.03316 -122.25957 Rodeo 65 []
1186367 December 15, 2020 - 16:00:17 UTC 38.03462 -122.27208 Rodeo 65 []
1201216 December 30, 2020 - 17:29:45 UTC 38.02012 -122.2496 Rodeo 65 []
1208032 January 11, 2021 - 16:38:13 UTC 38.03656 -122.2627 Rodeo 65 []
1216924 January 19, 2021 - 20:05:34 UTC 38.03784 -122.26408 Rodeo 65 []
1230232 January 27, 2021 - 06:58:00 UTC 38.02924 -122.26885 Rodeo 65 [{"latitude": "38.02774", "longitude": "-122.26705"}, {"latitude": "38.02838", "longitude": "-122.2651"}, {"latitude": "38.03155", "longitude": "-122.26586"}, {"latitude": "38.03338", "longitude": "-122.26735"}, {"latitude": "38.0299", "longitude": "-122.26853"}, {"latitude": "38.02914", "longitude": "-122.26835"}, {"latitude": "38.02881", "longitude": "-122.26827"}]
1232553 January 27, 2021 - 11:36:15 UTC 38.03161 -122.25949 Rodeo 65 []
1232896 January 27, 2021 - 13:19:20 UTC 38.02821 -122.25863 Rodeo 65 []
1233600 January 27, 2021 - 15:35:00 UTC 38.03253 -122.25878 Rodeo 65 []
1234860 January 27, 2021 - 18:34:00 UTC 38.02972 -122.25915 Rodeo 65 []
1235433 January 27, 2021 - 20:15:00 UTC 38.02821 -122.25863 Rodeo 65 []
1237909 January 28, 2021 - 06:39:25 UTC 38.03458 -122.26053 Rodeo 65 []
1239847 January 28, 2021 - 22:08:51 UTC 38.02986 -122.25706 Rodeo 65 []
1245662 February 02, 2021 - 14:03:00 UTC 38.02468 -122.24823 Rodeo 65 []
1246566 February 03, 2021 - 03:38:00 UTC 38.02468 -122.24823 Rodeo 65 []
1246970 February 03, 2021 - 18:27:57 UTC 38.03284 -122.26111 Rodeo 65 []
1260389 February 23, 2021 - 21:23:46 UTC 38.03784 -122.26408 Rodeo 65 []
1264701 March 01, 2021 - 19:08:56 UTC 38.03617 -122.26932 Rodeo 65 []
1265716 March 03, 2021 - 02:09:55 UTC 38.02926 -122.26441 Rodeo 65 []
1274500 March 09, 2021 - 01:03:25 UTC 38.03048 -122.26229 Rodeo 65 []
1286708 March 17, 2021 - 20:18:39 UTC 38.03827 -122.2673 Rodeo 65 []
1289223 March 19, 2021 - 21:55:45 UTC 38.03553 -122.27117 Rodeo 65 []
1300309 March 27, 2021 - 16:32:52 UTC 38.02689 -122.25989 Rodeo 65 []
1308641 April 07, 2021 - 15:55:36 UTC 38.03464 -122.26096 Rodeo 65 []
1310698 April 08, 2021 - 17:26:20 UTC 38.03464 -122.26096 Rodeo 65 []
1329795 April 23, 2021 - 15:32:27 UTC 38.02843 -122.26333 Rodeo 65 []
1348110 May 13, 2021 - 17:19:03 UTC 38.05103 -122.24944 Rodeo 65 []

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
);