outages

230 rows where regionName = 21 sorted by latitude descending

View and edit SQL

Suggested facets: outageDevices

id outageStartTime latitude ▲ longitude regionName outageDevices
690431 October 28, 2019 - 00:27:29 UTC 38.30654 -121.60211 Rio Vista 21 [{"latitude": "38.3043", "longitude": "-121.60647"}, {"latitude": "38.3066", "longitude": "-121.60462"}, {"latitude": "38.30674", "longitude": "-121.60667"}]
735110 December 10, 2019 - 14:04:16 UTC 38.30021 -121.63031 Rio Vista 21 []
735838 December 10, 2019 - 23:02:13 UTC 38.30021 -121.63031 Rio Vista 21 []
778813 February 06, 2020 - 01:24:41 UTC 38.30021 -121.63031 Rio Vista 21 []
692411 October 29, 2019 - 00:28:42 UTC 38.28777 -121.60629 Rio Vista 21 []
687555 October 27, 2019 - 16:54:04 UTC 38.24951 -121.73967 Rio Vista 21 []
693867 October 29, 2019 - 18:12:08 UTC 38.24951 -121.73967 Rio Vista 21 []
732563 December 07, 2019 - 19:02:36 UTC 38.24951 -121.73967 Rio Vista 21 []
694635 October 30, 2019 - 03:12:00 UTC 38.23952 -121.7125 Rio Vista 21 [{"latitude": "38.24104", "longitude": "-121.73135"}, {"latitude": "38.25003", "longitude": "-121.72407"}, {"latitude": "38.25632", "longitude": "-121.75951"}, {"latitude": "38.24455", "longitude": "-121.76546"}, {"latitude": "38.24107", "longitude": "-121.74697"}]
1067538 September 14, 2020 - 13:13:54 UTC 38.22861 -121.71249 Rio Vista 21 []
687433 October 27, 2019 - 16:19:27 UTC 38.20664 -121.71169 Rio Vista 21 []
700322 November 06, 2019 - 00:24:32 UTC 38.20664 -121.71169 Rio Vista 21 []
701162 November 06, 2019 - 23:45:49 UTC 38.20664 -121.71169 Rio Vista 21 []
719335 November 27, 2019 - 06:47:13 UTC 38.20664 -121.71169 Rio Vista 21 []
700583 November 06, 2019 - 16:21:27 UTC 38.20663 -121.70875 Rio Vista 21 []
672693 October 19, 2019 - 18:49:00 UTC 38.20515 -121.7051 Rio Vista 21 []
673433 October 19, 2019 - 20:30:21 UTC 38.20515 -121.7051 Rio Vista 21 []
674133 October 19, 2019 - 22:42:00 UTC 38.20515 -121.7051 Rio Vista 21 []
697082 November 01, 2019 - 00:45:00 UTC 38.20515 -121.7051 Rio Vista 21 []
719405 November 27, 2019 - 07:20:00 UTC 38.20515 -121.7051 Rio Vista 21 []
674154 October 19, 2019 - 22:53:36 UTC 38.20481 -121.70952 Rio Vista 21 []
697087 November 01, 2019 - 00:49:23 UTC 38.20481 -121.70952 Rio Vista 21 []
672653 October 19, 2019 - 18:46:00 UTC 38.20443 -121.70297 Rio Vista 21 []
674113 October 19, 2019 - 22:40:00 UTC 38.20443 -121.70297 Rio Vista 21 []
697090 November 01, 2019 - 00:52:00 UTC 38.20443 -121.70297 Rio Vista 21 []
719388 November 27, 2019 - 07:11:41 UTC 38.19869 -121.71303 Rio Vista 21 []
728965 December 03, 2019 - 22:49:36 UTC 38.19838 -121.72096 Rio Vista 21 []
729880 December 04, 2019 - 22:15:00 UTC 38.19838 -121.72096 Rio Vista 21 []
674941 October 21, 2019 - 01:10:15 UTC 38.19753 -121.71678 Rio Vista 21 []
701678 November 07, 2019 - 16:35:20 UTC 38.19751 -121.71529 Rio Vista 21 []
701747 November 07, 2019 - 17:13:47 UTC 38.19751 -121.71529 Rio Vista 21 []
701166 November 06, 2019 - 23:46:52 UTC 38.19656 -121.7179 Rio Vista 21 []
699299 November 04, 2019 - 19:35:00 UTC 38.19618 -121.71549 Rio Vista 21 []
719337 November 27, 2019 - 06:47:00 UTC 38.19135 -121.73554 Rio Vista 21 []
699208 November 04, 2019 - 18:28:00 UTC 38.19116 -121.71166 Rio Vista 21 []
719085 November 27, 2019 - 05:55:52 UTC 38.19049 -121.72245 Rio Vista 21 []
700783 November 06, 2019 - 17:42:40 UTC 38.1892 -121.71935 Rio Vista 21 []
712856 November 22, 2019 - 17:48:44 UTC 38.18886 -121.70861 Rio Vista 21 []
735743 December 10, 2019 - 21:18:55 UTC 38.18882 -121.67415 Rio Vista 21 []
701686 November 07, 2019 - 16:41:27 UTC 38.18878 -121.71444 Rio Vista 21 []
701708 November 07, 2019 - 16:52:30 UTC 38.18878 -121.71444 Rio Vista 21 []
700946 November 06, 2019 - 19:47:20 UTC 38.18829 -121.70624 Rio Vista 21 []
700298 November 05, 2019 - 23:47:48 UTC 38.18809 -121.71585 Rio Vista 21 []
699258 November 04, 2019 - 18:57:19 UTC 38.18767 -121.71723 Rio Vista 21 []
700978 November 06, 2019 - 20:19:32 UTC 38.18727 -121.71398 Rio Vista 21 []
701242 November 07, 2019 - 00:31:08 UTC 38.1871 -121.71518 Rio Vista 21 []
701147 November 06, 2019 - 23:36:51 UTC 38.18683 -121.71233 Rio Vista 21 []
699226 November 04, 2019 - 18:35:32 UTC 38.18635 -121.71525 Rio Vista 21 []
700981 November 06, 2019 - 20:21:42 UTC 38.18633 -121.72031 Rio Vista 21 []
703053 November 09, 2019 - 01:01:58 UTC 38.18633 -121.72031 Rio Vista 21 []
700931 November 06, 2019 - 19:39:53 UTC 38.18585 -121.70779 Rio Vista 21 []
700552 November 06, 2019 - 16:01:00 UTC 38.18582 -121.71301 Rio Vista 21 []
700987 November 06, 2019 - 20:24:06 UTC 38.18582 -121.71301 Rio Vista 21 []
701144 November 06, 2019 - 23:32:20 UTC 38.18566 -121.71941 Rio Vista 21 []
701174 November 06, 2019 - 23:52:36 UTC 38.18521 -121.70546 Rio Vista 21 []
699220 November 04, 2019 - 18:34:00 UTC 38.18513 -121.70921 Rio Vista 21 []
699221 November 04, 2019 - 18:34:17 UTC 38.1845 -121.72099 Rio Vista 21 []
699277 November 04, 2019 - 19:14:23 UTC 38.18445 -121.70639 Rio Vista 21 []
700572 November 06, 2019 - 16:13:24 UTC 38.18445 -121.70639 Rio Vista 21 []
700996 November 06, 2019 - 20:28:50 UTC 38.18273 -121.70438 Rio Vista 21 []
711677 November 20, 2019 - 21:45:47 UTC 38.18273 -121.70438 Rio Vista 21 []
725194 December 01, 2019 - 04:51:31 UTC 38.18271 -121.85069 Rio Vista 21 []
643831 October 05, 2019 - 01:04:00 UTC 38.18257 -121.74157 Rio Vista 21 [{"latitude": "38.11836", "longitude": "-121.74075"}, {"latitude": "38.14938", "longitude": "-121.70359"}, {"latitude": "38.16508", "longitude": "-121.72391"}, {"latitude": "38.17446", "longitude": "-121.74454"}, {"latitude": "38.17357", "longitude": "-121.74605"}, {"latitude": "38.13324", "longitude": "-121.74895"}]
697256 November 01, 2019 - 14:43:19 UTC 38.18257 -121.74157 Rio Vista 21 [{"latitude": "38.11836", "longitude": "-121.74075"}, {"latitude": "38.14938", "longitude": "-121.70359"}, {"latitude": "38.16508", "longitude": "-121.72391"}, {"latitude": "38.17446", "longitude": "-121.74454"}, {"latitude": "38.17357", "longitude": "-121.74605"}, {"latitude": "38.13342", "longitude": "-121.74886"}]
701540 November 07, 2019 - 15:10:13 UTC 38.18225 -121.70336 Rio Vista 21 []
726444 December 02, 2019 - 01:22:00 UTC 38.18201 -121.84309 Rio Vista 21 []
699269 November 04, 2019 - 19:04:43 UTC 38.18159 -121.70885 Rio Vista 21 []
701169 November 06, 2019 - 23:48:00 UTC 38.18118 -121.71888 Rio Vista 21 []
699210 November 04, 2019 - 18:28:32 UTC 38.18108 -121.70344 Rio Vista 21 []
700974 November 06, 2019 - 20:16:30 UTC 38.18108 -121.72027 Rio Vista 21 []
700278 November 05, 2019 - 22:58:00 UTC 38.18066 -121.69471 Rio Vista 21 [{"latitude": "38.03101", "longitude": "-121.75028"}, {"latitude": "38.0312", "longitude": "-121.74671"}, {"latitude": "38.05293", "longitude": "-121.50644"}, {"latitude": "38.05998", "longitude": "-121.50316"}, {"latitude": "38.20564", "longitude": "-121.51703"}, {"latitude": "38.2219", "longitude": "-121.54108"}, {"latitude": "38.23239", "longitude": "-121.55932"}, {"latitude": "38.16627", "longitude": "-121.70378"}, {"latitude": "38.15915", "longitude": "-121.71276"}, {"latitude": "38.06025", "longitude": "-121.78341"}, {"latitude": "38.05735", "longitude": "-121.78371"}, {"latitude": "38.05282", "longitude": "-121.7833"}]
698624 November 03, 2019 - 18:44:48 UTC 38.18062 -121.71098 Rio Vista 21 []
701542 November 07, 2019 - 15:11:02 UTC 38.18062 -121.71098 Rio Vista 21 []
700549 November 06, 2019 - 15:57:00 UTC 38.18053 -121.72094 Rio Vista 21 []
674760 October 20, 2019 - 15:06:00 UTC 38.18051 -121.69603 Rio Vista 21 [{"latitude": "38.17262", "longitude": "-121.69226"}, {"latitude": "38.17391", "longitude": "-121.69061"}, {"latitude": "38.18665", "longitude": "-121.69236"}, {"latitude": "38.192", "longitude": "-121.7002"}, {"latitude": "38.18644", "longitude": "-121.70482"}, {"latitude": "38.18148", "longitude": "-121.70113"}]
714183 November 25, 2019 - 16:45:00 UTC 38.1805 -121.71497 Rio Vista 21 []
700582 November 06, 2019 - 16:21:02 UTC 38.18045 -121.71507 Rio Vista 21 [{"latitude": "38.17813", "longitude": "-121.70789"}, {"latitude": "38.17837", "longitude": "-121.70637"}, {"latitude": "38.17973", "longitude": "-121.70687"}, {"latitude": "38.18234", "longitude": "-121.70784"}, {"latitude": "38.18308", "longitude": "-121.70813"}, {"latitude": "38.18392", "longitude": "-121.71285"}, {"latitude": "38.18428", "longitude": "-121.71539"}, {"latitude": "38.18355", "longitude": "-121.71752"}, {"latitude": "38.18065", "longitude": "-121.71487"}, {"latitude": "38.17953", "longitude": "-121.7129"}, {"latitude": "38.17843", "longitude": "-121.71041"}]
700988 November 06, 2019 - 20:24:57 UTC 38.18021 -121.70042 Rio Vista 21 []
701006 November 06, 2019 - 20:40:48 UTC 38.17973 -121.70687 Rio Vista 21 []
706785 November 14, 2019 - 18:16:45 UTC 38.17972 -121.71032 Rio Vista 21 []
708738 November 17, 2019 - 22:31:26 UTC 38.17966 -121.70118 Rio Vista 21 []
701165 November 06, 2019 - 23:46:00 UTC 38.17953 -121.70488 Rio Vista 21 []
712821 November 22, 2019 - 17:20:56 UTC 38.17951 -121.71181 Rio Vista 21 []
699222 November 04, 2019 - 18:34:19 UTC 38.17927 -121.71394 Rio Vista 21 []
700941 November 06, 2019 - 19:45:01 UTC 38.17927 -121.71394 Rio Vista 21 []
658901 October 15, 2019 - 15:58:26 UTC 38.17918 -121.69778 Rio Vista 21 []
697030 October 31, 2019 - 23:33:18 UTC 38.17879 -121.70261 Rio Vista 21 []
701681 November 07, 2019 - 16:38:34 UTC 38.17857 -121.71271 Rio Vista 21 []
701159 November 06, 2019 - 23:44:00 UTC 38.17791 -121.7162 Rio Vista 21 []
631133 September 30, 2019 - 17:05:00 UTC 38.17765 -121.71222 Rio Vista 21 []
698594 November 03, 2019 - 17:41:12 UTC 38.17761 -121.70326 Rio Vista 21 []
701606 November 07, 2019 - 15:51:23 UTC 38.17726 -121.70515 Rio Vista 21 []
700559 November 06, 2019 - 16:05:19 UTC 38.17685 -121.71582 Rio Vista 21 []
701533 November 07, 2019 - 15:05:00 UTC 38.17685 -121.71582 Rio Vista 21 []
701167 November 06, 2019 - 23:47:46 UTC 38.17676 -121.70442 Rio Vista 21 []
698633 November 03, 2019 - 18:48:47 UTC 38.17662 -121.71613 Rio Vista 21 []
698200 November 02, 2019 - 17:24:24 UTC 38.17596 -121.70406 Rio Vista 21 []
699201 November 04, 2019 - 18:27:27 UTC 38.17596 -121.70406 Rio Vista 21 []
700972 November 06, 2019 - 20:15:07 UTC 38.17596 -121.70406 Rio Vista 21 []
699406 November 04, 2019 - 21:21:18 UTC 38.17579 -121.71177 Rio Vista 21 []

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