759 rows where regionName = 34 sorted by longitude

View and edit SQL

id outageStartTime latitude longitude ▼ regionName outageDevices
1156767 December 01, 2020 - 03:55:00 UTC 38.74205 -121.63414 Woodland 34 [{"latitude": "38.74171", "longitude": "-121.65165"}, {"latitude": "38.742", "longitude": "-121.64334"}, {"latitude": "38.74819", "longitude": "-121.64949"}, {"latitude": "38.74173", "longitude": "-121.6589"}]
675155 October 21, 2019 - 14:48:44 UTC 38.58794 -121.63567 Woodland 34 []
1168115 December 07, 2020 - 17:28:53 UTC 38.61794 -121.64519 Woodland 34 []
1182519 December 13, 2020 - 19:04:06 UTC 38.61794 -121.64519 Woodland 34 []
652788 October 10, 2019 - 16:53:39 UTC 38.74847 -121.66232 Woodland 34 []
687963 October 27, 2019 - 18:08:44 UTC 38.75497 -121.66475 Woodland 34 []
736248 December 11, 2019 - 16:57:00 UTC 38.59107 -121.66921 Woodland 34 []
1160667 December 03, 2020 - 19:55:04 UTC 38.70212 -121.67278 Woodland 34 []
1217426 January 19, 2021 - 22:40:56 UTC 38.75871 -121.67381 Woodland 34 []
1161068 December 03, 2020 - 21:44:00 UTC 38.70561 -121.67593 Woodland 34 [{"latitude": "38.70212", "longitude": "-121.67278"}, {"latitude": "38.70563", "longitude": "-121.66979"}, {"latitude": "38.7057", "longitude": "-121.67116"}]
714412 November 25, 2019 - 20:01:02 UTC 38.71263 -121.67657 Woodland 34 []
732542 December 07, 2019 - 18:44:22 UTC 38.74826 -121.67781 Woodland 34 [{"latitude": "38.74847", "longitude": "-121.66232"}, {"latitude": "38.75497", "longitude": "-121.66475"}, {"latitude": "38.75825", "longitude": "-121.66824"}, {"latitude": "38.75844", "longitude": "-121.66943"}, {"latitude": "38.75896", "longitude": "-121.67511"}]
714409 November 25, 2019 - 20:00:11 UTC 38.72727 -121.67976 Woodland 34 []
722640 November 28, 2019 - 15:24:00 UTC 38.72727 -121.67976 Woodland 34 []
732941 December 07, 2019 - 21:25:00 UTC 38.74854 -121.68158 Woodland 34 [{"latitude": "38.73152", "longitude": "-121.67595"}, {"latitude": "38.73422", "longitude": "-121.66035"}, {"latitude": "38.74317", "longitude": "-121.67063"}, {"latitude": "38.73325", "longitude": "-121.6782"}]
1168596 December 07, 2020 - 19:12:00 UTC 38.74854 -121.68158 Woodland 34 [{"latitude": "38.73152", "longitude": "-121.67595"}, {"latitude": "38.73422", "longitude": "-121.66035"}, {"latitude": "38.74317", "longitude": "-121.67063"}, {"latitude": "38.73325", "longitude": "-121.6782"}]
689460 October 27, 2019 - 21:28:46 UTC 38.77649 -121.68919 Woodland 34 []
714408 November 25, 2019 - 20:00:11 UTC 38.72585 -121.69011 Woodland 34 []
1153195 November 23, 2020 - 18:05:00 UTC 38.76466 -121.6904 Woodland 34 [{"latitude": "38.7572", "longitude": "-121.69575"}, {"latitude": "38.76333", "longitude": "-121.68711"}, {"latitude": "38.77009", "longitude": "-121.67905"}, {"latitude": "38.78244", "longitude": "-121.68791"}]
689736 October 27, 2019 - 21:57:58 UTC 38.78156 -121.69252 Woodland 34 []
1131304 October 29, 2020 - 15:38:43 UTC 38.59074 -121.69273 Woodland 34 []
715076 November 26, 2019 - 16:17:39 UTC 38.78249 -121.69425 Woodland 34 []
1114440 October 09, 2020 - 19:15:27 UTC 38.66844 -121.69724 Woodland 34 []
714473 November 25, 2019 - 20:47:00 UTC 38.73503 -121.6973 Woodland 34 []
710200 November 19, 2019 - 20:19:58 UTC 38.60306 -121.70813 Woodland 34 []
698387 November 03, 2019 - 00:39:05 UTC 38.67773 -121.71008 Woodland 34 []
1205277 January 06, 2021 - 17:37:21 UTC 38.63402 -121.71011 Woodland 34 []
699730 November 05, 2019 - 12:24:00 UTC 38.67686 -121.71031 Woodland 34 [{"latitude": "38.67647", "longitude": "-121.71038"}, {"latitude": "38.67724", "longitude": "-121.71033"}, {"latitude": "38.67693", "longitude": "-121.7178"}]
1120718 October 19, 2020 - 15:34:00 UTC 38.63393 -121.71083 Woodland 34 []
1120721 October 19, 2020 - 15:46:00 UTC 38.62177 -121.71111 Woodland 34 []
1119770 October 17, 2020 - 15:35:00 UTC 38.63772 -121.71117 Woodland 34 [{"latitude": "38.63604", "longitude": "-121.71853"}, {"latitude": "38.6377", "longitude": "-121.71315"}, {"latitude": "38.63765", "longitude": "-121.71827"}, {"latitude": "38.63761", "longitude": "-121.7209"}]
1111197 October 05, 2020 - 15:49:41 UTC 38.61872 -121.71169 Woodland 34 []
1120723 October 19, 2020 - 15:57:00 UTC 38.59164 -121.71179 Woodland 34 [{"latitude": "38.59193", "longitude": "-121.71258"}, {"latitude": "38.59207", "longitude": "-121.71152"}, {"latitude": "38.60306", "longitude": "-121.70813"}, {"latitude": "38.64261", "longitude": "-121.71012"}, {"latitude": "38.64473", "longitude": "-121.71048"}, {"latitude": "38.64537", "longitude": "-121.71076"}, {"latitude": "38.6448", "longitude": "-121.71232"}, {"latitude": "38.63761", "longitude": "-121.7209"}, {"latitude": "38.61873", "longitude": "-121.72024"}]
1071873 September 15, 2020 - 17:58:33 UTC 38.65796 -121.71425 Woodland 34 []
686258 October 27, 2019 - 08:58:25 UTC 38.60494 -121.71465 Woodland 34 []
686628 October 27, 2019 - 08:58:25 UTC 38.60494 -121.71465 Woodland 34 []
786339 February 10, 2020 - 04:08:01 UTC 38.63761 -121.7209 Woodland 34 []
786593 February 10, 2020 - 06:38:19 UTC 38.63761 -121.7209 Woodland 34 []
1136191 November 05, 2020 - 07:22:00 UTC 38.67345 -121.7253 Woodland 34 []
1139827 November 09, 2020 - 05:17:00 UTC 38.67345 -121.7253 Woodland 34 []
714582 November 25, 2019 - 21:38:00 UTC 38.69173 -121.72773 Woodland 34 [{"latitude": "38.6907", "longitude": "-121.70987"}, {"latitude": "38.69814", "longitude": "-121.72037"}, {"latitude": "38.69159", "longitude": "-121.71696"}]
1136213 November 05, 2020 - 08:06:00 UTC 38.70985 -121.72801 Woodland 34 [{"latitude": "38.70212", "longitude": "-121.67278"}, {"latitude": "38.70563", "longitude": "-121.66979"}, {"latitude": "38.71649", "longitude": "-121.66372"}, {"latitude": "38.72109", "longitude": "-121.66401"}, {"latitude": "38.73551", "longitude": "-121.684"}, {"latitude": "38.73464", "longitude": "-121.72749"}, {"latitude": "38.71285", "longitude": "-121.72658"}, {"latitude": "38.70241", "longitude": "-121.691"}]
686263 October 27, 2019 - 09:01:15 UTC 38.60798 -121.72812 Woodland 34 []
687307 October 27, 2019 - 16:00:16 UTC 38.60798 -121.72812 Woodland 34 []
697579 November 01, 2019 - 19:30:47 UTC 38.74135 -121.72925 Woodland 34 [{"latitude": "38.74109", "longitude": "-121.72049"}, {"latitude": "38.74136", "longitude": "-121.72872"}, {"latitude": "38.74125", "longitude": "-121.72841"}]
1215693 January 19, 2021 - 16:13:00 UTC 38.61979 -121.72934 Woodland 34 [{"latitude": "38.61536", "longitude": "-121.73787"}, {"latitude": "38.6177", "longitude": "-121.73134"}, {"latitude": "38.61872", "longitude": "-121.72937"}, {"latitude": "38.62408", "longitude": "-121.73967"}, {"latitude": "38.62031", "longitude": "-121.74942"}]
1219183 January 21, 2021 - 01:50:00 UTC 38.61872 -121.72937 Woodland 34 []
735893 December 11, 2019 - 00:22:28 UTC 38.79244 -121.72947 Woodland 34 []
690943 October 28, 2019 - 04:30:00 UTC 38.60798 -121.72958 Woodland 34 [{"latitude": "38.60694", "longitude": "-121.72037"}, {"latitude": "38.60799", "longitude": "-121.72697"}, {"latitude": "38.60798", "longitude": "-121.72945"}]
744489 December 17, 2019 - 18:57:10 UTC 38.60798 -121.72958 Woodland 34 [{"latitude": "38.60694", "longitude": "-121.72037"}, {"latitude": "38.60799", "longitude": "-121.72697"}, {"latitude": "38.60798", "longitude": "-121.72945"}]
686262 October 27, 2019 - 09:01:15 UTC 38.60794 -121.72967 Woodland 34 []
687312 October 27, 2019 - 16:01:24 UTC 38.60794 -121.72967 Woodland 34 []
744443 December 17, 2019 - 18:24:15 UTC 38.60794 -121.72967 Woodland 34 []
1131420 October 29, 2020 - 17:02:34 UTC 38.6467 -121.72983 Woodland 34 []
1134482 November 02, 2020 - 19:04:25 UTC 38.59433 -121.73036 Woodland 34 []
1130577 October 28, 2020 - 16:02:45 UTC 38.64858 -121.73059 Woodland 34 []
1133681 November 02, 2020 - 16:06:09 UTC 38.64858 -121.73059 Woodland 34 []
1064251 September 11, 2020 - 16:02:36 UTC 38.77802 -121.73068 Woodland 34 []
1167812 December 07, 2020 - 16:32:56 UTC 38.77802 -121.73068 Woodland 34 []
654356 October 11, 2019 - 18:04:17 UTC 38.67287 -121.73142 Woodland 34 []
702110 November 07, 2019 - 22:41:04 UTC 38.65256 -121.73145 Woodland 34 []
1189795 December 16, 2020 - 03:48:00 UTC 38.65055 -121.73151 Woodland 34 []
1135509 November 04, 2020 - 14:23:00 UTC 38.67197 -121.73183 Woodland 34 []
1122034 October 21, 2020 - 14:20:06 UTC 38.65156 -121.73237 Woodland 34 []
1130474 October 28, 2020 - 14:10:40 UTC 38.65156 -121.73237 Woodland 34 []
1133702 November 02, 2020 - 16:24:26 UTC 38.64532 -121.73237 Woodland 34 []
1218373 January 20, 2021 - 16:34:00 UTC 38.66152 -121.73248 Woodland 34 []
651067 October 09, 2019 - 20:36:11 UTC 38.65211 -121.73257 Woodland 34 []
1130705 October 28, 2020 - 17:44:43 UTC 38.6476 -121.73264 Woodland 34 []
1122158 October 21, 2020 - 16:23:19 UTC 38.65062 -121.73497 Woodland 34 []
1122040 October 21, 2020 - 14:34:22 UTC 38.64865 -121.73502 Woodland 34 []
1129681 October 27, 2020 - 14:18:48 UTC 38.64865 -121.73502 Woodland 34 []
1130485 October 28, 2020 - 14:24:57 UTC 38.64865 -121.73502 Woodland 34 []
1131239 October 29, 2020 - 14:28:58 UTC 38.64865 -121.73502 Woodland 34 []
1081919 September 18, 2020 - 23:14:00 UTC 38.67231 -121.7358 Woodland 34 []
1081953 September 18, 2020 - 23:14:00 UTC 38.67231 -121.7358 Woodland 34 []
1122153 October 21, 2020 - 16:20:37 UTC 38.64746 -121.73625 Woodland 34 []
1133297 November 01, 2020 - 14:12:00 UTC 38.64506 -121.7373 Woodland 34 []
1133690 November 02, 2020 - 16:13:50 UTC 38.64506 -121.7373 Woodland 34 []
699287 November 04, 2019 - 19:19:36 UTC 38.68511 -121.73748 Woodland 34 []
1081914 September 18, 2020 - 22:57:00 UTC 38.6717 -121.73785 Woodland 34 [{"latitude": "38.67285", "longitude": "-121.73725"}, {"latitude": "38.67298", "longitude": "-121.73337"}, {"latitude": "38.67322", "longitude": "-121.73525"}, {"latitude": "38.67325", "longitude": "-121.73679"}]
728634 December 03, 2019 - 18:28:21 UTC 38.67633 -121.73798 Woodland 34 []
686264 October 27, 2019 - 09:01:36 UTC 38.61752 -121.73816 Woodland 34 []
1120969 October 19, 2020 - 19:50:08 UTC 38.6495 -121.73871 Woodland 34 []
1121658 October 20, 2020 - 19:25:36 UTC 38.6495 -121.73871 Woodland 34 []
1122055 October 21, 2020 - 14:56:58 UTC 38.6495 -121.73871 Woodland 34 []
1130471 October 28, 2020 - 14:07:35 UTC 38.6495 -121.73871 Woodland 34 []
1131231 October 29, 2020 - 14:16:00 UTC 38.6495 -121.73871 Woodland 34 []
1130602 October 28, 2020 - 16:20:24 UTC 38.64542 -121.73924 Woodland 34 []
1197100 December 22, 2020 - 17:39:42 UTC 38.66671 -121.73951 Woodland 34 []
1173100 December 09, 2020 - 16:14:02 UTC 38.72651 -121.74051 Woodland 34 []
1131225 October 29, 2020 - 14:10:34 UTC 38.64791 -121.74086 Woodland 34 [{"latitude": "38.64473", "longitude": "-121.7433"}, {"latitude": "38.64546", "longitude": "-121.74161"}, {"latitude": "38.64665", "longitude": "-121.74087"}, {"latitude": "38.64767", "longitude": "-121.74126"}, {"latitude": "38.64781", "longitude": "-121.74312"}, {"latitude": "38.64625", "longitude": "-121.74364"}, {"latitude": "38.6455", "longitude": "-121.74365"}]
1122185 October 21, 2020 - 16:33:17 UTC 38.64621 -121.7415 Woodland 34 []
1130496 October 28, 2020 - 14:56:45 UTC 38.64546 -121.74161 Woodland 34 []
736207 December 11, 2019 - 16:35:00 UTC 38.64919 -121.74199 Woodland 34 []
737223 December 12, 2019 - 16:43:27 UTC 38.64919 -121.74199 Woodland 34 []
1122053 October 21, 2020 - 14:52:55 UTC 38.65017 -121.74256 Woodland 34 []
1129721 October 27, 2020 - 15:33:39 UTC 38.65017 -121.74256 Woodland 34 []
1131242 October 29, 2020 - 14:32:29 UTC 38.65017 -121.74256 Woodland 34 []
1201130 December 30, 2020 - 15:08:13 UTC 38.77827 -121.74265 Woodland 34 [{"latitude": "38.78175", "longitude": "-121.7426"}, {"latitude": "38.78533", "longitude": "-121.73387"}, {"latitude": "38.78483", "longitude": "-121.74094"}, {"latitude": "38.78375", "longitude": "-121.74158"}]

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