outages

128 rows where regionName = 94

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude longitude regionName outageDevices
633637 October 01, 2019 - 15:09:50 UTC 36.67996 -119.18248 Squaw Valley 94 []
633646 October 01, 2019 - 15:19:40 UTC 36.6889 -119.19134 Squaw Valley 94 []
633838 October 01, 2019 - 16:22:21 UTC 36.69365 -119.19369 Squaw Valley 94 []
633843 October 01, 2019 - 16:23:55 UTC 36.68014 -119.18197 Squaw Valley 94 []
633920 October 01, 2019 - 17:22:42 UTC 36.68242 -119.18556 Squaw Valley 94 []
633976 October 01, 2019 - 18:00:36 UTC 36.68733 -119.19347 Squaw Valley 94 []
635391 October 01, 2019 - 23:59:05 UTC 36.75404 -119.16838 Squaw Valley 94 []
635747 October 02, 2019 - 14:40:30 UTC 36.68578 -119.2114 Squaw Valley 94 []
635758 October 02, 2019 - 14:58:17 UTC 36.69592 -119.23816 Squaw Valley 94 []
636136 October 02, 2019 - 16:47:19 UTC 36.68603 -119.20963 Squaw Valley 94 []
636696 October 02, 2019 - 17:56:26 UTC 36.68682 -119.22556 Squaw Valley 94 []
639033 October 03, 2019 - 15:13:51 UTC 36.69532 -119.22031 Squaw Valley 94 []
639034 October 03, 2019 - 15:15:20 UTC 36.68363 -119.18051 Squaw Valley 94 []
639066 October 03, 2019 - 15:36:08 UTC 36.67613 -119.19498 Squaw Valley 94 []
639141 October 03, 2019 - 15:57:42 UTC 36.71183 -119.25664 Squaw Valley 94 []
639191 October 03, 2019 - 16:16:21 UTC 36.69501 -119.21886 Squaw Valley 94 []
639244 October 03, 2019 - 16:47:43 UTC 36.67573 -119.19308 Squaw Valley 94 []
639257 October 03, 2019 - 17:06:47 UTC 36.69481 -119.2174 Squaw Valley 94 []
639314 October 03, 2019 - 17:15:45 UTC 36.70979 -119.25618 Squaw Valley 94 []
639654 October 03, 2019 - 17:56:58 UTC 36.7004 -119.18804 Squaw Valley 94 []
639693 October 03, 2019 - 18:00:15 UTC 36.68934 -119.21626 Squaw Valley 94 []
639733 October 03, 2019 - 18:06:14 UTC 36.68959 -119.186 Squaw Valley 94 []
640893 October 03, 2019 - 20:30:49 UTC 36.67457 -119.18706 Squaw Valley 94 []
642263 October 04, 2019 - 14:53:20 UTC 36.68968 -119.18351 Squaw Valley 94 []
642293 October 04, 2019 - 15:17:09 UTC 36.69602 -119.25341 Squaw Valley 94 []
642813 October 04, 2019 - 16:14:13 UTC 36.68771 -119.18051 Squaw Valley 94 []
643393 October 04, 2019 - 17:12:13 UTC 36.69043 -119.24765 Squaw Valley 94 []
643422 October 04, 2019 - 17:35:33 UTC 36.69672 -119.25432 Squaw Valley 94 []
643435 October 04, 2019 - 17:50:49 UTC 36.69024 -119.24179 Squaw Valley 94 []
643493 October 04, 2019 - 18:51:52 UTC 36.69074 -119.24885 Squaw Valley 94 []
643686 October 04, 2019 - 20:20:06 UTC 36.69235 -119.24572 Squaw Valley 94 []
643943 October 05, 2019 - 14:31:18 UTC 36.69786 -119.25845 Squaw Valley 94 []
643951 October 05, 2019 - 14:44:01 UTC 36.70369 -119.25813 Squaw Valley 94 []
643961 October 05, 2019 - 14:58:14 UTC 36.7027 -119.25271 Squaw Valley 94 []
644185 October 05, 2019 - 16:13:42 UTC 36.70422 -119.25315 Squaw Valley 94 []
644613 October 05, 2019 - 17:31:39 UTC 36.69891 -119.25516 Squaw Valley 94 []
644692 October 05, 2019 - 18:18:34 UTC 36.69586 -119.18052 Squaw Valley 94 []
645809 October 07, 2019 - 14:28:49 UTC 36.69719 -119.24183 Squaw Valley 94 []
645821 October 07, 2019 - 14:59:51 UTC 36.69323 -119.18793 Squaw Valley 94 []
645822 October 07, 2019 - 14:54:07 UTC 36.67755 -119.19046 Squaw Valley 94 []
645835 October 07, 2019 - 15:15:04 UTC 36.71332 -119.2348 Squaw Valley 94 []
645877 October 07, 2019 - 15:46:32 UTC 36.69651 -119.24369 Squaw Valley 94 []
646033 October 07, 2019 - 17:25:04 UTC 36.67208 -119.18621 Squaw Valley 94 []
646063 October 07, 2019 - 17:45:54 UTC 36.7053 -119.23381 Squaw Valley 94 []
647084 October 08, 2019 - 14:42:26 UTC 36.70731 -119.25523 Squaw Valley 94 []
647098 October 08, 2019 - 15:05:52 UTC 36.70964 -119.23968 Squaw Valley 94 []
647264 October 08, 2019 - 15:49:12 UTC 36.70999 -119.26719 Squaw Valley 94 []
647309 October 08, 2019 - 16:19:04 UTC 36.72534 -119.2376 Squaw Valley 94 []
647328 October 08, 2019 - 16:30:52 UTC 36.70985 -119.2382 Squaw Valley 94 []
647356 October 08, 2019 - 16:56:44 UTC 36.68851 -119.19424 Squaw Valley 94 []
647398 October 08, 2019 - 17:46:34 UTC 36.71327 -119.23962 Squaw Valley 94 []
647417 October 08, 2019 - 18:03:59 UTC 36.68713 -119.19236 Squaw Valley 94 []
647438 October 08, 2019 - 18:33:32 UTC 36.71296 -119.23934 Squaw Valley 94 []
653308 October 10, 2019 - 20:14:31 UTC 36.67943 -119.13995 Squaw Valley 94 []
655819 October 14, 2019 - 14:34:39 UTC 36.73166 -119.27043 Squaw Valley 94 []
655825 October 14, 2019 - 14:46:26 UTC 36.73143 -119.25618 Squaw Valley 94 []
655911 October 14, 2019 - 15:55:10 UTC 36.7543 -119.23104 Squaw Valley 94 []
656134 October 14, 2019 - 16:26:39 UTC 36.74324 -119.23233 Squaw Valley 94 []
656575 October 14, 2019 - 17:07:32 UTC 36.75089 -119.23189 Squaw Valley 94 []
657173 October 14, 2019 - 18:23:51 UTC 36.73997 -119.25731 Squaw Valley 94 []
657835 October 14, 2019 - 20:09:11 UTC 36.72713 -119.28489 Squaw Valley 94 []
658513 October 14, 2019 - 22:04:04 UTC 36.73636 -119.21565 Squaw Valley 94 []
658791 October 15, 2019 - 14:00:00 UTC 36.74246 -119.24245 Squaw Valley 94 []
658826 October 15, 2019 - 14:56:13 UTC 36.73508 -119.24384 Squaw Valley 94 []
658846 October 15, 2019 - 15:12:20 UTC 36.74424 -119.23848 Squaw Valley 94 []
658852 October 15, 2019 - 15:17:47 UTC 36.74975 -119.23985 Squaw Valley 94 []
658873 October 15, 2019 - 15:34:12 UTC 36.73773 -119.2182 Squaw Valley 94 []
659214 October 15, 2019 - 17:26:52 UTC 36.7559 -119.21788 Squaw Valley 94 []
659216 October 15, 2019 - 17:54:56 UTC 36.7533 -119.2169 Squaw Valley 94 []
659614 October 15, 2019 - 19:00:55 UTC 36.75395 -119.23406 Squaw Valley 94 []
659714 October 15, 2019 - 19:17:54 UTC 36.73668 -119.24224 Squaw Valley 94 []
660053 October 16, 2019 - 14:39:52 UTC 36.70789 -119.23971 Squaw Valley 94 []
660650 October 16, 2019 - 16:30:31 UTC 36.73785 -119.15531 Squaw Valley 94 []
660788 October 16, 2019 - 17:56:08 UTC 36.73621 -119.15359 Squaw Valley 94 []
663614 October 17, 2019 - 14:59:32 UTC 36.70997 -119.24642 Squaw Valley 94 []
667794 October 18, 2019 - 15:30:00 UTC 36.7479 -119.23548 Squaw Valley 94 [{"latitude": "36.74711", "longitude": "-119.23858"}, {"latitude": "36.74892", "longitude": "-119.23654"}, {"latitude": "36.75172", "longitude": "-119.23718"}, {"latitude": "36.75456", "longitude": "-119.23811"}, {"latitude": "36.75481", "longitude": "-119.23927"}, {"latitude": "36.74975", "longitude": "-119.23985"}]
691409 October 28, 2019 - 15:43:06 UTC 36.75648 -119.22918 Squaw Valley 94 [{"latitude": "36.75555", "longitude": "-119.22208"}, {"latitude": "36.75607", "longitude": "-119.22042"}, {"latitude": "36.75904", "longitude": "-119.22079"}, {"latitude": "36.76114", "longitude": "-119.22618"}, {"latitude": "36.7587", "longitude": "-119.22768"}, {"latitude": "36.75663", "longitude": "-119.22886"}]
698994 November 04, 2019 - 15:42:50 UTC 36.70978 -119.25213 Squaw Valley 94 []
699788 November 05, 2019 - 15:45:30 UTC 36.72417 -119.26004 Squaw Valley 94 []
700040 November 05, 2019 - 17:57:17 UTC 36.71282 -119.25721 Squaw Valley 94 []
701697 November 07, 2019 - 16:47:06 UTC 36.68715 -119.15741 Squaw Valley 94 []
701974 November 07, 2019 - 20:24:59 UTC 36.72621 -119.25634 Squaw Valley 94 [{"latitude": "36.70205", "longitude": "-119.22352"}, {"latitude": "36.70574", "longitude": "-119.17563"}, {"latitude": "36.70619", "longitude": "-119.17007"}, {"latitude": "36.70634", "longitude": "-119.16828"}, {"latitude": "36.71942", "longitude": "-119.13546"}, {"latitude": "36.72391", "longitude": "-119.13808"}, {"latitude": "36.7672", "longitude": "-119.23308"}, {"latitude": "36.76872", "longitude": "-119.24765"}, {"latitude": "36.76624", "longitude": "-119.2484"}, {"latitude": "36.76524", "longitude": "-119.2486"}, {"latitude": "36.72613", "longitude": "-119.25424"}, {"latitude": "36.71918", "longitude": "-119.25318"}]
702250 November 08, 2019 - 04:50:09 UTC 36.67604 -119.30249 Squaw Valley 94 []
703203 November 09, 2019 - 16:13:00 UTC 36.67001 -119.15355 Squaw Valley 94 [{"latitude": "36.67098", "longitude": "-119.15342"}, {"latitude": "36.67395", "longitude": "-119.15289"}, {"latitude": "36.67603", "longitude": "-119.15527"}]
703350 November 09, 2019 - 18:29:39 UTC 36.68801 -119.10907 Squaw Valley 94 []
704217 November 11, 2019 - 14:42:00 UTC 36.6759 -119.18687 Squaw Valley 94 [{"latitude": "36.65936", "longitude": "-119.15014"}, {"latitude": "36.66046", "longitude": "-119.14361"}, {"latitude": "36.6727", "longitude": "-119.09361"}, {"latitude": "36.67339", "longitude": "-119.09232"}, {"latitude": "36.68192", "longitude": "-119.08604"}, {"latitude": "36.69853", "longitude": "-119.08909"}, {"latitude": "36.71887", "longitude": "-119.13545"}, {"latitude": "36.70015", "longitude": "-119.1908"}, {"latitude": "36.68733", "longitude": "-119.19347"}, {"latitude": "36.68275", "longitude": "-119.19101"}, {"latitude": "36.67726", "longitude": "-119.18667"}, {"latitude": "36.66716", "longitude": "-119.1717"}, {"latitude": "36.66018", "longitude": "-119.15594"}, {"latitude": "36.65949", "longitude": "-119.1522"}]
705824 November 13, 2019 - 16:25:37 UTC 36.75079 -119.23545 Squaw Valley 94 []
708165 November 16, 2019 - 16:49:59 UTC 36.72685 -119.24055 Squaw Valley 94 []
709042 November 18, 2019 - 16:29:21 UTC 36.7316 -119.25078 Squaw Valley 94 []
709194 November 18, 2019 - 17:52:14 UTC 36.73142 -119.25434 Squaw Valley 94 []
709280 November 18, 2019 - 18:49:33 UTC 36.72978 -119.25286 Squaw Valley 94 []
710129 November 19, 2019 - 19:17:29 UTC 36.68771 -119.21546 Squaw Valley 94 []
710914 November 20, 2019 - 15:59:19 UTC 36.72716 -119.24518 Squaw Valley 94 []
711329 November 20, 2019 - 17:30:21 UTC 36.72739 -119.25274 Squaw Valley 94 []
711411 November 20, 2019 - 18:17:06 UTC 36.72649 -119.24713 Squaw Valley 94 []
711528 November 20, 2019 - 19:35:25 UTC 36.72613 -119.25424 Squaw Valley 94 []
712008 November 21, 2019 - 16:22:49 UTC 36.69865 -119.13349 Squaw Valley 94 []
712023 November 21, 2019 - 16:39:00 UTC 36.7485 -119.23784 Squaw Valley 94 []
712026 November 21, 2019 - 16:36:20 UTC 36.73783 -119.2154 Squaw Valley 94 []
712219 November 21, 2019 - 18:17:17 UTC 36.73312 -119.22227 Squaw Valley 94 []

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