outages

227 rows where regionName = 21

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
699299 November 04, 2019 - 19:35:00 UTC 38.19618 -121.71549 Rio Vista 21 []
699406 November 04, 2019 - 21:21:18 UTC 38.17579 -121.71177 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"}]
700280 November 05, 2019 - 23:26:00 UTC 38.16488 -121.69107 Rio Vista 21 []
700298 November 05, 2019 - 23:47:48 UTC 38.18809 -121.71585 Rio Vista 21 []
700322 November 06, 2019 - 00:24:32 UTC 38.20664 -121.71169 Rio Vista 21 []
700358 November 06, 2019 - 01:21:14 UTC 38.15134 -121.6988 Rio Vista 21 []
700448 November 06, 2019 - 08:47:00 UTC 38.15991 -121.68691 Rio Vista 21 [{"latitude": "38.15483", "longitude": "-121.69047"}, {"latitude": "38.15521", "longitude": "-121.68967"}, {"latitude": "38.16153", "longitude": "-121.68553"}, {"latitude": "38.16298", "longitude": "-121.6866"}, {"latitude": "38.15978", "longitude": "-121.68861"}, {"latitude": "38.15515", "longitude": "-121.69093"}, {"latitude": "38.15488", "longitude": "-121.69056"}]
700449 November 06, 2019 - 08:47:00 UTC 38.16063 -121.69639 Rio Vista 21 [{"latitude": "38.15986", "longitude": "-121.69446"}, {"latitude": "38.16063", "longitude": "-121.69022"}, {"latitude": "38.16115", "longitude": "-121.68943"}, {"latitude": "38.16292", "longitude": "-121.68688"}, {"latitude": "38.1633", "longitude": "-121.68756"}, {"latitude": "38.16368", "longitude": "-121.68847"}, {"latitude": "38.16482", "longitude": "-121.69349"}, {"latitude": "38.16537", "longitude": "-121.69727"}, {"latitude": "38.16206", "longitude": "-121.69695"}, {"latitude": "38.16148", "longitude": "-121.69642"}, {"latitude": "38.16124", "longitude": "-121.69618"}, {"latitude": "38.16047", "longitude": "-121.6954"}]
700450 November 06, 2019 - 09:35:00 UTC 38.16435 -121.69039 Rio Vista 21 []
700451 November 06, 2019 - 09:36:25 UTC 38.16534 -121.69336 Rio Vista 21 []
700459 November 06, 2019 - 09:35:00 UTC 38.16435 -121.69039 Rio Vista 21 []
700460 November 06, 2019 - 10:33:00 UTC 38.16045 -121.68865 Rio Vista 21 [{"latitude": "38.15765", "longitude": "-121.69096"}, {"latitude": "38.15809", "longitude": "-121.69041"}, {"latitude": "38.15875", "longitude": "-121.68965"}, {"latitude": "38.15952", "longitude": "-121.68911"}, {"latitude": "38.16028", "longitude": "-121.68985"}, {"latitude": "38.16026", "longitude": "-121.69025"}, {"latitude": "38.16019", "longitude": "-121.69154"}, {"latitude": "38.16016", "longitude": "-121.69202"}]
700527 November 06, 2019 - 15:54:00 UTC 38.16435 -121.69039 Rio Vista 21 []
700528 November 06, 2019 - 15:54:00 UTC 38.16391 -121.6923 Rio Vista 21 []
700548 November 06, 2019 - 15:57:47 UTC 38.16243 -121.69975 Rio Vista 21 []
700549 November 06, 2019 - 15:57:00 UTC 38.18053 -121.72094 Rio Vista 21 []
700550 November 06, 2019 - 15:58:05 UTC 38.15718 -121.69162 Rio Vista 21 []
700552 November 06, 2019 - 16:01:00 UTC 38.18582 -121.71301 Rio Vista 21 []
700557 November 06, 2019 - 16:02:00 UTC 38.16063 -121.70322 Rio Vista 21 []
700559 November 06, 2019 - 16:05:19 UTC 38.17685 -121.71582 Rio Vista 21 []
700569 November 06, 2019 - 16:12:09 UTC 38.17357 -121.74605 Rio Vista 21 []
700572 November 06, 2019 - 16:13:24 UTC 38.18445 -121.70639 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"}]
700583 November 06, 2019 - 16:21:27 UTC 38.20663 -121.70875 Rio Vista 21 []
700590 November 06, 2019 - 16:29:41 UTC 38.17273 -121.69591 Rio Vista 21 []
700783 November 06, 2019 - 17:42:40 UTC 38.1892 -121.71935 Rio Vista 21 []
700849 November 06, 2019 - 18:15:23 UTC 38.17488 -121.71394 Rio Vista 21 []
700931 November 06, 2019 - 19:39:53 UTC 38.18585 -121.70779 Rio Vista 21 []
700941 November 06, 2019 - 19:45:01 UTC 38.17927 -121.71394 Rio Vista 21 []
700946 November 06, 2019 - 19:47:20 UTC 38.18829 -121.70624 Rio Vista 21 []
700972 November 06, 2019 - 20:15:07 UTC 38.17596 -121.70406 Rio Vista 21 []
700974 November 06, 2019 - 20:16:30 UTC 38.18108 -121.72027 Rio Vista 21 []
700978 November 06, 2019 - 20:19:32 UTC 38.18727 -121.71398 Rio Vista 21 []
700981 November 06, 2019 - 20:21:42 UTC 38.18633 -121.72031 Rio Vista 21 []
700987 November 06, 2019 - 20:24:06 UTC 38.18582 -121.71301 Rio Vista 21 []
700988 November 06, 2019 - 20:24:57 UTC 38.18021 -121.70042 Rio Vista 21 []
700996 November 06, 2019 - 20:28:50 UTC 38.18273 -121.70438 Rio Vista 21 []
701006 November 06, 2019 - 20:40:48 UTC 38.17973 -121.70687 Rio Vista 21 []
701141 November 06, 2019 - 23:31:12 UTC 38.17579 -121.71177 Rio Vista 21 []
701144 November 06, 2019 - 23:32:20 UTC 38.18566 -121.71941 Rio Vista 21 []
701147 November 06, 2019 - 23:36:51 UTC 38.18683 -121.71233 Rio Vista 21 []
701156 November 06, 2019 - 23:42:55 UTC 38.15922 -121.70484 Rio Vista 21 []
701159 November 06, 2019 - 23:44:00 UTC 38.17791 -121.7162 Rio Vista 21 []
701162 November 06, 2019 - 23:45:49 UTC 38.20664 -121.71169 Rio Vista 21 []
701165 November 06, 2019 - 23:46:00 UTC 38.17953 -121.70488 Rio Vista 21 []
701166 November 06, 2019 - 23:46:52 UTC 38.19656 -121.7179 Rio Vista 21 []
701167 November 06, 2019 - 23:47:46 UTC 38.17676 -121.70442 Rio Vista 21 []
701169 November 06, 2019 - 23:48:00 UTC 38.18118 -121.71888 Rio Vista 21 []
701171 November 06, 2019 - 23:49:58 UTC 38.17054 -121.69401 Rio Vista 21 []
701174 November 06, 2019 - 23:52:36 UTC 38.18521 -121.70546 Rio Vista 21 []
701214 November 07, 2019 - 00:23:11 UTC 38.15217 -121.69589 Rio Vista 21 []
701242 November 07, 2019 - 00:31:08 UTC 38.1871 -121.71518 Rio Vista 21 []
701250 November 07, 2019 - 00:35:40 UTC 38.17363 -121.69415 Rio Vista 21 []
701533 November 07, 2019 - 15:05:00 UTC 38.17685 -121.71582 Rio Vista 21 []
701540 November 07, 2019 - 15:10:13 UTC 38.18225 -121.70336 Rio Vista 21 []
701542 November 07, 2019 - 15:11:02 UTC 38.18062 -121.71098 Rio Vista 21 []
701606 November 07, 2019 - 15:51:23 UTC 38.17726 -121.70515 Rio Vista 21 []
701660 November 07, 2019 - 16:15:52 UTC 38.1584 -121.70377 Rio Vista 21 []
701669 November 07, 2019 - 16:23:49 UTC 38.17461 -121.69688 Rio Vista 21 []
701678 November 07, 2019 - 16:35:20 UTC 38.19751 -121.71529 Rio Vista 21 []
701681 November 07, 2019 - 16:38:34 UTC 38.17857 -121.71271 Rio Vista 21 []
701686 November 07, 2019 - 16:41:27 UTC 38.18878 -121.71444 Rio Vista 21 []
701688 November 07, 2019 - 16:42:25 UTC 38.07311 -121.7565 Rio Vista 21 []
701708 November 07, 2019 - 16:52:30 UTC 38.18878 -121.71444 Rio Vista 21 []
701747 November 07, 2019 - 17:13:47 UTC 38.19751 -121.71529 Rio Vista 21 []
702867 November 08, 2019 - 21:12:51 UTC 38.15713 -121.68942 Rio Vista 21 []
703053 November 09, 2019 - 01:01:58 UTC 38.18633 -121.72031 Rio Vista 21 []
705542 November 13, 2019 - 00:40:00 UTC 38.12243 -121.83043 Rio Vista 21 []
706132 November 13, 2019 - 19:09:42 UTC 38.07345 -121.75573 Rio Vista 21 []
706174 November 13, 2019 - 20:01:12 UTC 38.07212 -121.75875 Rio Vista 21 []
706785 November 14, 2019 - 18:16:45 UTC 38.17972 -121.71032 Rio Vista 21 []
706957 November 14, 2019 - 21:28:54 UTC 38.16234 -121.68934 Rio Vista 21 []
708113 November 16, 2019 - 15:29:00 UTC 38.17238 -121.67662 Rio Vista 21 [{"latitude": "38.16303", "longitude": "-121.68505"}, {"latitude": "38.16309", "longitude": "-121.68406"}, {"latitude": "38.16335", "longitude": "-121.68357"}, {"latitude": "38.17041", "longitude": "-121.67773"}, {"latitude": "38.1722", "longitude": "-121.67693"}, {"latitude": "38.17306", "longitude": "-121.68686"}, {"latitude": "38.16984", "longitude": "-121.69004"}, {"latitude": "38.16665", "longitude": "-121.69247"}, {"latitude": "38.16534", "longitude": "-121.69336"}, {"latitude": "38.16367", "longitude": "-121.69075"}]
708368 November 16, 2019 - 21:00:50 UTC 38.07345 -121.75573 Rio Vista 21 []
708530 November 17, 2019 - 06:35:40 UTC 38.15927 -121.69669 Rio Vista 21 []
708661 November 17, 2019 - 18:22:07 UTC 38.07212 -121.75875 Rio Vista 21 []
708719 November 17, 2019 - 20:52:13 UTC 38.14456 -121.68347 Rio Vista 21 []
708738 November 17, 2019 - 22:31:26 UTC 38.17966 -121.70118 Rio Vista 21 []
709176 November 18, 2019 - 17:43:44 UTC 38.05282 -121.7833 Rio Vista 21 []
709617 November 19, 2019 - 00:43:00 UTC 38.16202 -121.702 Rio Vista 21 [{"latitude": "38.15922", "longitude": "-121.70484"}, {"latitude": "38.16063", "longitude": "-121.70322"}, {"latitude": "38.16181", "longitude": "-121.70188"}, {"latitude": "38.16028", "longitude": "-121.7041"}]
709703 November 19, 2019 - 03:35:00 UTC 38.16043 -121.70083 Rio Vista 21 []
710086 November 19, 2019 - 18:38:09 UTC 38.17239 -121.7072 Rio Vista 21 []
710721 November 20, 2019 - 15:14:28 UTC 38.1586 -121.70127 Rio Vista 21 []
710752 November 20, 2019 - 15:17:40 UTC 38.15927 -121.69669 Rio Vista 21 []
711398 November 20, 2019 - 18:09:50 UTC 38.1595 -121.7001 Rio Vista 21 []
711677 November 20, 2019 - 21:45:47 UTC 38.18273 -121.70438 Rio Vista 21 []
712821 November 22, 2019 - 17:20:56 UTC 38.17951 -121.71181 Rio Vista 21 []
712856 November 22, 2019 - 17:48:44 UTC 38.18886 -121.70861 Rio Vista 21 []
713482 November 23, 2019 - 19:10:53 UTC 38.15536 -121.69342 Rio Vista 21 []
713670 November 24, 2019 - 03:33:52 UTC 38.16537 -121.69727 Rio Vista 21 []
714183 November 25, 2019 - 16:45:00 UTC 38.1805 -121.71497 Rio Vista 21 []
714360 November 25, 2019 - 19:26:46 UTC 38.17041 -121.67773 Rio Vista 21 []
715837 November 26, 2019 - 22:26:26 UTC 38.14467 -121.68347 Rio Vista 21 []
719085 November 27, 2019 - 05:55:52 UTC 38.19049 -121.72245 Rio Vista 21 []
719326 November 27, 2019 - 06:42:23 UTC 38.17357 -121.74605 Rio Vista 21 []
719335 November 27, 2019 - 06:47:13 UTC 38.20664 -121.71169 Rio Vista 21 []
719337 November 27, 2019 - 06:47:00 UTC 38.19135 -121.73554 Rio Vista 21 []
719388 November 27, 2019 - 07:11:41 UTC 38.19869 -121.71303 Rio Vista 21 []
719405 November 27, 2019 - 07:20:00 UTC 38.20515 -121.7051 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 25.334ms · About: About this site