outages

281 rows where regionName = 13

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
633478 October 01, 2019 - 04:58:00 UTC 37.25687 -120.43449 Merced 13 []
633504 October 01, 2019 - 07:07:00 UTC 37.25754 -120.4345 Merced 13 []
633889 October 01, 2019 - 17:03:20 UTC 37.30767 -120.46987 Merced 13 []
633994 October 01, 2019 - 18:28:33 UTC 37.3018 -120.46319 Merced 13 []
635293 October 01, 2019 - 23:08:35 UTC 37.28064 -120.47231 Merced 13 []
635553 October 02, 2019 - 03:29:48 UTC 37.29316 -120.45997 Merced 13 []
635817 October 02, 2019 - 15:47:04 UTC 37.25877 -120.44073 Merced 13 [{"latitude": "37.25787", "longitude": "-120.43961"}, {"latitude": "37.2581", "longitude": "-120.44055"}, {"latitude": "37.25912", "longitude": "-120.45869"}, {"latitude": "37.258", "longitude": "-120.45609"}, {"latitude": "37.25791", "longitude": "-120.45312"}]
635976 October 02, 2019 - 16:38:25 UTC 37.26551 -120.4762 Merced 13 []
636194 October 02, 2019 - 16:56:12 UTC 37.3116 -120.48638 Merced 13 []
638333 October 02, 2019 - 21:56:08 UTC 37.3116 -120.48638 Merced 13 []
638889 October 03, 2019 - 04:02:50 UTC 37.31442 -120.47586 Merced 13 []
638902 October 03, 2019 - 06:08:00 UTC 37.28854 -120.35508 Merced 13 []
639228 October 03, 2019 - 16:40:56 UTC 37.29875 -120.46643 Merced 13 [{"latitude": "37.29831", "longitude": "-120.46333"}, {"latitude": "37.29863", "longitude": "-120.46421"}, {"latitude": "37.29899", "longitude": "-120.4652"}, {"latitude": "37.29862", "longitude": "-120.46609"}]
639229 October 03, 2019 - 16:41:36 UTC 37.29861 -120.4677 Merced 13 [{"latitude": "37.29874", "longitude": "-120.46805"}, {"latitude": "37.2995", "longitude": "-120.46967"}, {"latitude": "37.29898", "longitude": "-120.46868"}]
639231 October 03, 2019 - 16:41:57 UTC 37.29946 -120.46713 Merced 13 [{"latitude": "37.29846", "longitude": "-120.46715"}, {"latitude": "37.29891", "longitude": "-120.46688"}, {"latitude": "37.29947", "longitude": "-120.46656"}]
639374 October 03, 2019 - 17:28:25 UTC 37.32167 -120.46171 Merced 13 []
640413 October 03, 2019 - 19:32:28 UTC 37.3149 -120.45808 Merced 13 []
643273 October 04, 2019 - 17:05:22 UTC 37.31244 -120.45934 Merced 13 []
643657 October 04, 2019 - 19:52:06 UTC 37.32053 -120.45474 Merced 13 []
645784 October 07, 2019 - 13:49:51 UTC 37.30716 -120.45729 Merced 13 []
646875 October 07, 2019 - 22:43:35 UTC 37.31917 -120.46711 Merced 13 []
646928 October 07, 2019 - 23:49:19 UTC 37.29023 -120.50489 Merced 13 []
647033 October 08, 2019 - 06:00:54 UTC 37.27192 -120.54229 Merced 13 [{"latitude": "37.24471", "longitude": "-120.52495"}, {"latitude": "37.26798", "longitude": "-120.52852"}, {"latitude": "37.26504", "longitude": "-120.54221"}, {"latitude": "37.26081", "longitude": "-120.54223"}, {"latitude": "37.25855", "longitude": "-120.54224"}]
647099 October 08, 2019 - 15:06:20 UTC 37.23271 -120.38233 Merced 13 []
647570 October 08, 2019 - 22:00:51 UTC 37.3116 -120.48638 Merced 13 []
651566 October 09, 2019 - 23:46:52 UTC 37.29381 -120.48378 Merced 13 []
651995 October 10, 2019 - 03:26:00 UTC 37.29048 -120.45501 Merced 13 [{"latitude": "37.28981", "longitude": "-120.456"}, {"latitude": "37.29072", "longitude": "-120.4551"}, {"latitude": "37.29102", "longitude": "-120.45605"}]
651996 October 10, 2019 - 03:27:00 UTC 37.2916 -120.45695 Merced 13 []
652679 October 10, 2019 - 15:40:36 UTC 37.30743 -120.47828 Merced 13 []
653986 October 11, 2019 - 05:05:13 UTC 37.28758 -120.49847 Merced 13 []
654386 October 11, 2019 - 18:47:18 UTC 37.29703 -120.45991 Merced 13 []
654792 October 12, 2019 - 00:26:01 UTC 37.29644 -120.47707 Merced 13 [{"latitude": "37.29622", "longitude": "-120.47646"}, {"latitude": "37.2967", "longitude": "-120.47782"}, {"latitude": "37.29648", "longitude": "-120.47722"}]
655860 October 14, 2019 - 15:17:41 UTC 37.22481 -120.61676 Merced 13 []
657073 October 14, 2019 - 18:12:58 UTC 37.29742 -120.49155 Merced 13 []
657234 October 14, 2019 - 18:39:17 UTC 37.30602 -120.44625 Merced 13 []
657235 October 14, 2019 - 15:17:00 UTC 37.18626 -120.63478 Merced 13 [{"latitude": "37.18735", "longitude": "-120.63477"}, {"latitude": "37.21498", "longitude": "-120.61655"}, {"latitude": "37.21909", "longitude": "-120.61453"}, {"latitude": "37.23083", "longitude": "-120.61668"}, {"latitude": "37.23095", "longitude": "-120.64355"}, {"latitude": "37.21703", "longitude": "-120.64132"}]
657953 October 14, 2019 - 20:39:38 UTC 37.3027 -120.47198 Merced 13 []
658668 October 15, 2019 - 00:21:13 UTC 37.29893 -120.4782 Merced 13 []
658701 October 15, 2019 - 01:26:00 UTC 37.28524 -120.44815 Merced 13 []
658844 October 15, 2019 - 15:16:04 UTC 37.2877 -120.44517 Merced 13 [{"latitude": "37.28594", "longitude": "-120.44624"}, {"latitude": "37.28691", "longitude": "-120.44517"}, {"latitude": "37.28687", "longitude": "-120.44609"}]
658867 October 15, 2019 - 15:33:45 UTC 37.29409 -120.47916 Merced 13 []
659721 October 15, 2019 - 19:30:00 UTC 37.2983 -120.46157 Merced 13 []
660780 October 16, 2019 - 17:48:00 UTC 37.29475 -120.4574 Merced 13 []
661113 October 16, 2019 - 18:53:58 UTC 37.30657 -120.46927 Merced 13 []
666213 October 17, 2019 - 20:54:51 UTC 37.32018 -120.44858 Merced 13 []
667220 October 18, 2019 - 00:53:37 UTC 37.30463 -120.4869 Merced 13 [{"latitude": "37.3042", "longitude": "-120.48596"}, {"latitude": "37.30437", "longitude": "-120.48641"}, {"latitude": "37.30511", "longitude": "-120.48842"}, {"latitude": "37.30608", "longitude": "-120.49106"}, {"latitude": "37.30531", "longitude": "-120.48899"}]
667228 October 18, 2019 - 01:07:18 UTC 37.28443 -120.49134 Merced 13 []
668553 October 18, 2019 - 17:22:39 UTC 37.31362 -120.48888 Merced 13 []
670941 October 19, 2019 - 00:51:11 UTC 37.30743 -120.47828 Merced 13 []
671006 October 19, 2019 - 01:55:53 UTC 37.29854 -120.48214 Merced 13 []
673313 October 19, 2019 - 20:09:58 UTC 37.29299 -120.49904 Merced 13 []
676277 October 21, 2019 - 20:19:28 UTC 37.30119 -120.46018 Merced 13 []
677144 October 23, 2019 - 00:20:05 UTC 37.3241 -120.48298 Merced 13 []
677245 October 23, 2019 - 04:19:18 UTC 37.32645 -120.46665 Merced 13 []
679820 October 24, 2019 - 22:11:06 UTC 37.3027 -120.47198 Merced 13 []
680172 October 25, 2019 - 11:28:48 UTC 37.39853 -120.50352 Merced 13 []
680173 October 25, 2019 - 11:34:56 UTC 37.36511 -120.50318 Merced 13 []
680426 October 25, 2019 - 18:39:30 UTC 37.28137 -120.57912 Merced 13 []
680518 October 25, 2019 - 20:51:50 UTC 37.29676 -120.45584 Merced 13 []
680712 October 26, 2019 - 06:03:39 UTC 37.26575 -120.43047 Merced 13 [{"latitude": "37.26153", "longitude": "-120.42295"}, {"latitude": "37.26241", "longitude": "-120.40656"}, {"latitude": "37.26654", "longitude": "-120.40632"}, {"latitude": "37.27308", "longitude": "-120.42292"}, {"latitude": "37.27308", "longitude": "-120.42388"}, {"latitude": "37.27304", "longitude": "-120.43174"}, {"latitude": "37.27291", "longitude": "-120.43177"}, {"latitude": "37.26864", "longitude": "-120.43139"}, {"latitude": "37.26546", "longitude": "-120.42774"}, {"latitude": "37.26274", "longitude": "-120.42458"}]
690666 October 28, 2019 - 01:51:57 UTC 37.31188 -120.49567 Merced 13 []
691224 October 28, 2019 - 10:44:00 UTC 37.30914 -120.48954 Merced 13 []
691599 October 28, 2019 - 17:20:47 UTC 37.31812 -120.45722 Merced 13 []
691778 October 28, 2019 - 19:09:52 UTC 37.29696 -120.3974 Merced 13 []
693989 October 29, 2019 - 19:23:41 UTC 37.29379 -120.49153 Merced 13 []
694052 October 29, 2019 - 20:00:28 UTC 37.31854 -120.46164 Merced 13 []
695431 October 30, 2019 - 21:11:45 UTC 37.31394 -120.4929 Merced 13 []
696601 October 31, 2019 - 17:35:21 UTC 37.3259 -120.46873 Merced 13 []
697029 October 31, 2019 - 23:32:35 UTC 37.22124 -120.43387 Merced 13 []
698011 November 02, 2019 - 03:10:30 UTC 37.30259 -120.47826 Merced 13 []
698172 November 02, 2019 - 16:34:57 UTC 37.30743 -120.32483 Merced 13 []
698877 November 04, 2019 - 04:04:28 UTC 37.31245 -120.46492 Merced 13 []
699108 November 04, 2019 - 17:22:43 UTC 37.36163 -120.48264 Merced 13 []
699533 November 04, 2019 - 23:53:05 UTC 37.3116 -120.4472 Merced 13 []
699550 November 05, 2019 - 00:24:26 UTC 37.34282 -120.49909 Merced 13 []
699637 November 05, 2019 - 02:37:20 UTC 37.28907 -120.49903 Merced 13 []
700345 November 06, 2019 - 00:43:08 UTC 37.29742 -120.49155 Merced 13 []
700888 November 06, 2019 - 18:51:48 UTC 37.31918 -120.42848 Merced 13 []
701801 November 07, 2019 - 17:41:59 UTC 37.27908 -120.47961 Merced 13 []
701817 November 07, 2019 - 17:51:06 UTC 37.30307 -120.39175 Merced 13 []
701975 November 07, 2019 - 20:25:00 UTC 37.3101 -120.50505 Merced 13 [{"latitude": "37.30896", "longitude": "-120.50357"}, {"latitude": "37.30965", "longitude": "-120.4998"}, {"latitude": "37.30992", "longitude": "-120.50147"}, {"latitude": "37.30991", "longitude": "-120.50238"}, {"latitude": "37.3099", "longitude": "-120.5029"}, {"latitude": "37.30989", "longitude": "-120.50341"}, {"latitude": "37.30976", "longitude": "-120.50438"}, {"latitude": "37.30942", "longitude": "-120.50404"}]
704435 November 11, 2019 - 21:01:31 UTC 37.30351 -120.47418 Merced 13 []
704721 November 12, 2019 - 15:54:11 UTC 37.31397 -120.48236 Merced 13 []
704750 November 12, 2019 - 16:31:03 UTC 37.3148 -120.4816 Merced 13 []
704978 November 12, 2019 - 18:21:48 UTC 37.31854 -120.46087 Merced 13 []
704992 November 12, 2019 - 18:36:00 UTC 37.34627 -120.52564 Merced 13 []
705039 November 12, 2019 - 19:19:02 UTC 37.27342 -120.48615 Merced 13 [{"latitude": "37.26948", "longitude": "-120.48563"}, {"latitude": "37.27084", "longitude": "-120.48472"}, {"latitude": "37.26949", "longitude": "-120.48572"}]
705094 November 12, 2019 - 20:29:42 UTC 37.31239 -120.44741 Merced 13 []
705495 November 12, 2019 - 23:22:00 UTC 37.31099 -120.44446 Merced 13 []
706118 November 13, 2019 - 18:58:24 UTC 37.32792 -120.4674 Merced 13 []
706182 November 13, 2019 - 20:07:07 UTC 37.30014 -120.45842 Merced 13 []
706571 November 14, 2019 - 16:03:38 UTC 37.30864 -120.43874 Merced 13 [{"latitude": "37.30573", "longitude": "-120.44113"}, {"latitude": "37.30743", "longitude": "-120.43879"}, {"latitude": "37.30743", "longitude": "-120.44409"}]
706816 November 14, 2019 - 18:37:00 UTC 37.37582 -120.45029 Merced 13 [{"latitude": "37.37571", "longitude": "-120.45006"}, {"latitude": "37.37574", "longitude": "-120.44421"}, {"latitude": "37.37576", "longitude": "-120.44138"}, {"latitude": "37.37578", "longitude": "-120.43929"}, {"latitude": "37.37583", "longitude": "-120.45133"}, {"latitude": "37.37583", "longitude": "-120.45223"}]
706893 November 14, 2019 - 19:51:30 UTC 37.30742 -120.44412 Merced 13 []
706897 November 14, 2019 - 20:01:16 UTC 37.30864 -120.43874 Merced 13 []
706967 November 14, 2019 - 21:37:20 UTC 37.3179 -120.47404 Merced 13 []
707081 November 15, 2019 - 00:16:02 UTC 37.30767 -120.49541 Merced 13 []
707782 November 15, 2019 - 20:59:14 UTC 37.30018 -120.48491 Merced 13 []
708081 November 16, 2019 - 14:14:00 UTC 37.33353 -120.32085 Merced 13 []
708246 November 16, 2019 - 18:08:17 UTC 37.32421 -120.47662 Merced 13 []

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