outages

297 rows where regionName = 33

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
632153 September 30, 2019 - 20:18:37 UTC 37.89203 -122.03894 Walnut Creek 33 []
633546 October 01, 2019 - 13:07:08 UTC 37.87055 -122.03021 Walnut Creek 33 []
633594 October 01, 2019 - 14:57:11 UTC 37.91565 -122.02158 Walnut Creek 33 []
633894 October 01, 2019 - 17:08:16 UTC 37.88173 -122.06065 Walnut Creek 33 []
635653 October 02, 2019 - 04:24:00 UTC 37.87056 -122.03111 Walnut Creek 33 []
635861 October 02, 2019 - 16:09:46 UTC 37.91821 -122.03537 Walnut Creek 33 []
636677 October 02, 2019 - 17:54:48 UTC 37.93184 -122.01142 Walnut Creek 33 []
638233 October 02, 2019 - 21:45:36 UTC 37.92807 -122.04595 Walnut Creek 33 []
638393 October 02, 2019 - 21:59:26 UTC 37.91811 -122.03487 Walnut Creek 33 [{"latitude": "37.91859", "longitude": "-122.0344"}, {"latitude": "37.91922", "longitude": "-122.03465"}, {"latitude": "37.91952", "longitude": "-122.03556"}]
638829 October 03, 2019 - 00:57:19 UTC 37.8997 -122.04257 Walnut Creek 33 []
642250 October 04, 2019 - 14:25:08 UTC 37.90531 -122.05356 Walnut Creek 33 []
642533 October 04, 2019 - 15:35:36 UTC 37.90362 -122.07282 Walnut Creek 33 [{"latitude": "37.90308", "longitude": "-122.07094"}, {"latitude": "37.90319", "longitude": "-122.07096"}, {"latitude": "37.90365", "longitude": "-122.07158"}, {"latitude": "37.90362", "longitude": "-122.07237"}]
642742 October 04, 2019 - 16:02:00 UTC 37.90531 -122.05356 Walnut Creek 33 []
642778 October 04, 2019 - 16:13:00 UTC 37.90493 -122.0529 Walnut Creek 33 []
644723 October 05, 2019 - 19:40:15 UTC 37.90126 -122.04802 Walnut Creek 33 []
645595 October 06, 2019 - 17:40:33 UTC 37.91709 -122.06095 Walnut Creek 33 []
645610 October 06, 2019 - 18:31:39 UTC 37.9171 -122.06193 Walnut Creek 33 []
645772 October 07, 2019 - 11:00:10 UTC 37.90387 -122.06327 Walnut Creek 33 [{"latitude": "37.90148", "longitude": "-122.06577"}, {"latitude": "37.90148", "longitude": "-122.0655"}, {"latitude": "37.90347", "longitude": "-122.06321"}, {"latitude": "37.90393", "longitude": "-122.06431"}, {"latitude": "37.90372", "longitude": "-122.06591"}]
646151 October 07, 2019 - 18:58:24 UTC 37.91904 -122.08001 Walnut Creek 33 []
646972 October 08, 2019 - 01:12:00 UTC 37.90412 -122.07097 Walnut Creek 33 []
647016 October 08, 2019 - 04:04:00 UTC 37.89259 -122.0616 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"}]
652117 October 10, 2019 - 05:50:49 UTC 37.90872 -122.05746 Walnut Creek 33 [{"latitude": "37.88899", "longitude": "-122.13975"}, {"latitude": "37.91173", "longitude": "-122.05808"}, {"latitude": "37.91336", "longitude": "-122.056"}, {"latitude": "37.91386", "longitude": "-122.05571"}, {"latitude": "37.91479", "longitude": "-122.05541"}, {"latitude": "37.92621", "longitude": "-122.05288"}, {"latitude": "37.94294", "longitude": "-122.07038"}, {"latitude": "37.94278", "longitude": "-122.10554"}, {"latitude": "37.94088", "longitude": "-122.10922"}]
652126 October 10, 2019 - 05:50:49 UTC 37.92646 -122.06107 Walnut Creek 33 [{"latitude": "37.92508", "longitude": "-122.07678"}, {"latitude": "37.92555", "longitude": "-122.06439"}, {"latitude": "37.92658", "longitude": "-122.06106"}, {"latitude": "37.94294", "longitude": "-122.07038"}, {"latitude": "37.93853", "longitude": "-122.0775"}, {"latitude": "37.92664", "longitude": "-122.08633"}]
652153 October 10, 2019 - 05:50:49 UTC 37.92533 -122.08749 Walnut Creek 33 [{"latitude": "37.91062", "longitude": "-122.09523"}, {"latitude": "37.9114", "longitude": "-122.09355"}, {"latitude": "37.92484", "longitude": "-122.08891"}, {"latitude": "37.92487", "longitude": "-122.09531"}, {"latitude": "37.91654", "longitude": "-122.1007"}, {"latitude": "37.91511", "longitude": "-122.10124"}, {"latitude": "37.91089", "longitude": "-122.09652"}]
652337 October 10, 2019 - 06:30:05 UTC 37.93283 -122.06781 Walnut Creek 33 []
652572 October 10, 2019 - 11:17:00 UTC 37.90775 -122.05502 Walnut Creek 33 []
653028 October 10, 2019 - 18:42:05 UTC 37.88767 -122.02371 Walnut Creek 33 []
653055 October 10, 2019 - 18:59:10 UTC 37.9144 -122.02577 Walnut Creek 33 [{"latitude": "37.91268", "longitude": "-122.02385"}, {"latitude": "37.91468", "longitude": "-122.02363"}, {"latitude": "37.91432", "longitude": "-122.02443"}, {"latitude": "37.91409", "longitude": "-122.02494"}]
653355 October 10, 2019 - 20:35:24 UTC 37.9269 -122.06331 Walnut Creek 33 []
653409 October 10, 2019 - 21:18:00 UTC 37.92449 -122.0789 Walnut Creek 33 []
653803 October 11, 2019 - 01:53:00 UTC 37.92641 -122.0695 Walnut Creek 33 []
653963 October 11, 2019 - 04:26:20 UTC 37.9269 -122.06331 Walnut Creek 33 []
654391 October 11, 2019 - 18:50:38 UTC 37.88767 -122.02371 Walnut Creek 33 []
654758 October 11, 2019 - 23:53:21 UTC 37.91545 -122.07089 Walnut Creek 33 []
654769 October 12, 2019 - 00:01:29 UTC 37.92641 -122.0695 Walnut Creek 33 []
655851 October 14, 2019 - 15:09:02 UTC 37.88279 -122.06069 Walnut Creek 33 []
656153 October 14, 2019 - 16:33:51 UTC 37.9269 -122.06331 Walnut Creek 33 []
658967 October 15, 2019 - 16:31:00 UTC 37.86391 -122.0786 Walnut Creek 33 []
659831 October 15, 2019 - 21:28:54 UTC 37.89195 -122.05035 Walnut Creek 33 []
659841 October 15, 2019 - 21:41:08 UTC 37.92213 -122.08546 Walnut Creek 33 []
659956 October 16, 2019 - 02:07:36 UTC 37.9269 -122.06331 Walnut Creek 33 []
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 []
668375 October 18, 2019 - 16:34:14 UTC 37.91449 -122.03168 Walnut Creek 33 []
674898 October 20, 2019 - 21:55:00 UTC 37.93213 -122.03803 Walnut Creek 33 []
674987 October 21, 2019 - 11:27:00 UTC 37.90387 -122.06327 Walnut Creek 33 [{"latitude": "37.90148", "longitude": "-122.06577"}, {"latitude": "37.90148", "longitude": "-122.0655"}, {"latitude": "37.90347", "longitude": "-122.06321"}, {"latitude": "37.90393", "longitude": "-122.06431"}, {"latitude": "37.90372", "longitude": "-122.06591"}]
675924 October 21, 2019 - 16:13:59 UTC 37.9155 -122.06907 Walnut Creek 33 []
676121 October 21, 2019 - 18:15:25 UTC 37.91006 -122.06238 Walnut Creek 33 []
677041 October 22, 2019 - 22:00:44 UTC 37.90234 -122.04097 Walnut Creek 33 []
677148 October 23, 2019 - 00:34:25 UTC 37.92874 -122.06261 Walnut Creek 33 []
677435 October 23, 2019 - 16:11:36 UTC 37.91612 -122.07843 Walnut Creek 33 []
677500 October 23, 2019 - 16:41:54 UTC 37.9036 -122.04189 Walnut Creek 33 []
679821 October 24, 2019 - 22:11:25 UTC 37.92913 -122.01172 Walnut Creek 33 []
680350 October 25, 2019 - 17:02:47 UTC 37.91142 -122.00379 Walnut Creek 33 []
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"}]
685498 October 27, 2019 - 06:22:00 UTC 37.86391 -122.0786 Walnut Creek 33 []
685503 October 27, 2019 - 06:23:49 UTC 37.85536 -122.0657 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"}]
685532 October 27, 2019 - 06:26:11 UTC 37.85945 -122.07604 Walnut Creek 33 []
685534 October 27, 2019 - 06:26:11 UTC 37.85787 -122.07579 Walnut Creek 33 []
685537 October 27, 2019 - 06:25:18 UTC 37.85681 -122.07438 Walnut Creek 33 []
687101 October 27, 2019 - 14:45:15 UTC 37.85217 -122.05739 Walnut Creek 33 []
687450 October 27, 2019 - 16:20:00 UTC 37.90872 -122.05761 Walnut Creek 33 [{"latitude": "37.90874", "longitude": "-122.05566"}, {"latitude": "37.90899", "longitude": "-122.0539"}, {"latitude": "37.92039", "longitude": "-122.02226"}, {"latitude": "37.92309", "longitude": "-122.01748"}, {"latitude": "37.92613", "longitude": "-122.01416"}, {"latitude": "37.92736", "longitude": "-122.01627"}, {"latitude": "37.93029", "longitude": "-122.02142"}, {"latitude": "37.93059", "longitude": "-122.0425"}, {"latitude": "37.93049", "longitude": "-122.04451"}, {"latitude": "37.93007", "longitude": "-122.04653"}, {"latitude": "37.92884", "longitude": "-122.05137"}, {"latitude": "37.92867", "longitude": "-122.05194"}, {"latitude": "37.92674", "longitude": "-122.05385"}, {"latitude": "37.92318", "longitude": "-122.05488"}, {"latitude": "37.91022", "longitude": "-122.05582"}]
687475 October 27, 2019 - 16:33:41 UTC 37.92584 -122.06368 Walnut Creek 33 []
687497 October 27, 2019 - 16:39:50 UTC 37.93362 -122.05208 Walnut Creek 33 []
687622 October 27, 2019 - 17:07:49 UTC 37.90122 -122.06624 Walnut Creek 33 []
687717 October 27, 2019 - 17:30:39 UTC 37.89922 -122.06453 Walnut Creek 33 []
687718 October 27, 2019 - 17:30:54 UTC 37.92898 -122.06223 Walnut Creek 33 []
687735 October 27, 2019 - 17:34:55 UTC 37.9127 -122.06813 Walnut Creek 33 []
687784 October 27, 2019 - 17:46:35 UTC 37.93498 -122.01684 Walnut Creek 33 []
687795 October 27, 2019 - 17:48:00 UTC 37.93207 -122.04057 Walnut Creek 33 [{"latitude": "37.93286", "longitude": "-122.03986"}, {"latitude": "37.93333", "longitude": "-122.03922"}, {"latitude": "37.9336", "longitude": "-122.03948"}, {"latitude": "37.93394", "longitude": "-122.03983"}, {"latitude": "37.93445", "longitude": "-122.04139"}, {"latitude": "37.93349", "longitude": "-122.0406"}]
687821 October 27, 2019 - 17:50:00 UTC 37.93161 -122.03404 Walnut Creek 33 []
687840 October 27, 2019 - 17:42:00 UTC 37.93119 -122.0439 Walnut Creek 33 [{"latitude": "37.91997", "longitude": "-122.03647"}, {"latitude": "37.92039", "longitude": "-122.02226"}, {"latitude": "37.92309", "longitude": "-122.01748"}, {"latitude": "37.92613", "longitude": "-122.01416"}, {"latitude": "37.92736", "longitude": "-122.01627"}, {"latitude": "37.93029", "longitude": "-122.02142"}, {"latitude": "37.93445", "longitude": "-122.04139"}, {"latitude": "37.93331", "longitude": "-122.04321"}, {"latitude": "37.93007", "longitude": "-122.04653"}, {"latitude": "37.92721", "longitude": "-122.04747"}, {"latitude": "37.92119", "longitude": "-122.04055"}]
687864 October 27, 2019 - 17:56:47 UTC 37.93675 -122.05241 Walnut Creek 33 []
687945 October 27, 2019 - 18:06:19 UTC 37.87801 -122.0739 Walnut Creek 33 []
688033 October 27, 2019 - 18:20:37 UTC 37.91385 -122.03862 Walnut Creek 33 []
688052 October 27, 2019 - 18:23:03 UTC 37.90087 -122.04968 Walnut Creek 33 []
688156 October 27, 2019 - 18:42:12 UTC 37.88349 -122.06082 Walnut Creek 33 []
688332 October 27, 2019 - 19:09:52 UTC 37.93256 -122.02365 Walnut Creek 33 []
688506 October 27, 2019 - 19:40:09 UTC 37.93826 -122.05962 Walnut Creek 33 []
688684 October 27, 2019 - 20:01:55 UTC 37.88703 -122.06095 Walnut Creek 33 []
688752 October 27, 2019 - 17:07:49 UTC 37.90485 -122.06068 Walnut Creek 33 [{"latitude": "37.89925", "longitude": "-122.06962"}, {"latitude": "37.90132", "longitude": "-122.06562"}, {"latitude": "37.90145", "longitude": "-122.06603"}, {"latitude": "37.90156", "longitude": "-122.06767"}, {"latitude": "37.90135", "longitude": "-122.06897"}]
688756 October 27, 2019 - 20:13:00 UTC 37.88777 -122.06097 Walnut Creek 33 []
689199 October 27, 2019 - 20:57:38 UTC 37.87245 -122.08131 Walnut Creek 33 []
689227 October 27, 2019 - 21:01:11 UTC 37.92224 -122.08192 Walnut Creek 33 []
689678 October 27, 2019 - 17:21:19 UTC 37.90872 -122.05756 Walnut Creek 33 [{"latitude": "37.87002", "longitude": "-122.03422"}, {"latitude": "37.87069", "longitude": "-122.0215"}, {"latitude": "37.87376", "longitude": "-122.01526"}, {"latitude": "37.88773", "longitude": "-122.01498"}, {"latitude": "37.90792", "longitude": "-122.052"}, {"latitude": "37.90819", "longitude": "-122.05348"}, {"latitude": "37.9077", "longitude": "-122.0568"}, {"latitude": "37.9073", "longitude": "-122.05763"}, {"latitude": "37.9035", "longitude": "-122.05576"}, {"latitude": "37.87592", "longitude": "-122.03984"}]
689723 October 27, 2019 - 21:55:44 UTC 37.90451 -122.04976 Walnut Creek 33 []
689724 October 27, 2019 - 21:56:06 UTC 37.86999 -122.02049 Walnut Creek 33 []
689767 October 27, 2019 - 22:03:15 UTC 37.90224 -122.05343 Walnut Creek 33 []
689768 October 27, 2019 - 22:03:15 UTC 37.89118 -122.04786 Walnut Creek 33 []
689769 October 27, 2019 - 22:03:15 UTC 37.90832 -122.05431 Walnut Creek 33 []
689833 October 27, 2019 - 19:43:03 UTC 37.90877 -122.05753 Walnut Creek 33 [{"latitude": "37.87736", "longitude": "-122.07732"}, {"latitude": "37.89271", "longitude": "-122.05559"}, {"latitude": "37.91995", "longitude": "-122.05638"}, {"latitude": "37.92047", "longitude": "-122.05649"}, {"latitude": "37.92062", "longitude": "-122.05669"}, {"latitude": "37.92303", "longitude": "-122.06022"}, {"latitude": "37.92236", "longitude": "-122.07366"}, {"latitude": "37.9211", "longitude": "-122.08051"}, {"latitude": "37.89894", "longitude": "-122.08493"}, {"latitude": "37.87751", "longitude": "-122.08024"}]
689845 October 27, 2019 - 22:14:20 UTC 37.9028 -122.05714 Walnut Creek 33 []
689870 October 27, 2019 - 22:18:33 UTC 37.90359 -122.06679 Walnut Creek 33 []
689884 October 27, 2019 - 22:21:41 UTC 37.91069 -122.05905 Walnut Creek 33 []
689986 October 27, 2019 - 22:35:11 UTC 37.87602 -122.08757 Walnut Creek 33 []
690005 October 27, 2019 - 22:38:49 UTC 37.9338 -122.01756 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 455.437ms · About: About this site