outages

1,572 rows where regionName = 30

View and edit SQL

id outageStartTime latitude longitude regionName outageDevices
629993 September 30, 2019 - 16:00:00 UTC 38.50277 -122.71038 Santa Rosa 30 []
633798 October 01, 2019 - 16:00:25 UTC 38.37566 -122.71296 Santa Rosa 30 [{"latitude": "38.37289", "longitude": "-122.7018"}, {"latitude": "38.37468", "longitude": "-122.69839"}, {"latitude": "38.37572", "longitude": "-122.698"}, {"latitude": "38.37665", "longitude": "-122.70101"}, {"latitude": "38.37567", "longitude": "-122.71147"}]
633858 October 01, 2019 - 16:34:45 UTC 38.48624 -122.66211 Santa Rosa 30 []
633968 October 01, 2019 - 18:01:27 UTC 38.36951 -122.75603 Santa Rosa 30 []
635347 October 01, 2019 - 23:26:51 UTC 38.43586 -122.74069 Santa Rosa 30 []
635760 October 02, 2019 - 15:03:00 UTC 38.49694 -122.65506 Santa Rosa 30 [{"latitude": "38.49373", "longitude": "-122.65176"}, {"latitude": "38.49765", "longitude": "-122.65355"}, {"latitude": "38.49692", "longitude": "-122.65485"}, {"latitude": "38.49397", "longitude": "-122.65358"}]
635854 October 02, 2019 - 16:02:15 UTC 38.44864 -122.69249 Santa Rosa 30 []
635862 October 02, 2019 - 16:09:00 UTC 38.48875 -122.59085 Santa Rosa 30 [{"latitude": "38.48875", "longitude": "-122.57631"}, {"latitude": "38.48877", "longitude": "-122.57235"}, {"latitude": "38.4902", "longitude": "-122.59165"}, {"latitude": "38.49013", "longitude": "-122.59319"}, {"latitude": "38.48883", "longitude": "-122.59048"}]
635885 October 02, 2019 - 16:23:00 UTC 38.48271 -122.75705 Santa Rosa 30 []
636955 October 02, 2019 - 18:45:39 UTC 38.42388 -122.72997 Santa Rosa 30 []
637255 October 02, 2019 - 19:31:01 UTC 38.35731 -122.62626 Santa Rosa 30 []
637673 October 02, 2019 - 20:27:24 UTC 38.4453 -122.74009 Santa Rosa 30 []
638633 October 02, 2019 - 23:05:54 UTC 38.43019 -122.70731 Santa Rosa 30 []
638800 October 03, 2019 - 00:10:00 UTC 38.43064 -122.79786 Santa Rosa 30 [{"latitude": "38.42815", "longitude": "-122.80646"}, {"latitude": "38.43066", "longitude": "-122.80213"}, {"latitude": "38.4307", "longitude": "-122.80867"}, {"latitude": "38.43069", "longitude": "-122.81238"}, {"latitude": "38.42999", "longitude": "-122.8111"}]
638801 October 03, 2019 - 00:12:11 UTC 38.42728 -122.81495 Santa Rosa 30 []
638874 October 03, 2019 - 02:37:44 UTC 38.4159 -122.7112 Santa Rosa 30 []
639252 October 03, 2019 - 17:00:35 UTC 38.45439 -122.69868 Santa Rosa 30 [{"latitude": "38.45459", "longitude": "-122.69506"}, {"latitude": "38.45546", "longitude": "-122.69468"}, {"latitude": "38.45647", "longitude": "-122.69428"}, {"latitude": "38.45696", "longitude": "-122.69505"}, {"latitude": "38.45736", "longitude": "-122.69588"}, {"latitude": "38.45487", "longitude": "-122.69823"}]
640033 October 03, 2019 - 18:48:08 UTC 38.4379 -122.69285 Santa Rosa 30 []
640475 October 03, 2019 - 19:45:12 UTC 38.40024 -122.59953 Santa Rosa 30 []
641893 October 03, 2019 - 23:57:40 UTC 38.47659 -122.75108 Santa Rosa 30 []
641993 October 04, 2019 - 00:36:00 UTC 38.41954 -122.76897 Santa Rosa 30 [{"latitude": "38.41838", "longitude": "-122.77451"}, {"latitude": "38.4195", "longitude": "-122.76923"}, {"latitude": "38.41984", "longitude": "-122.77501"}, {"latitude": "38.41887", "longitude": "-122.77742"}]
641994 October 04, 2019 - 00:36:23 UTC 38.43655 -122.70443 Santa Rosa 30 []
642053 October 04, 2019 - 00:48:57 UTC 38.46377 -122.74472 Santa Rosa 30 []
642201 October 04, 2019 - 03:48:29 UTC 38.39899 -122.59967 Santa Rosa 30 []
642264 October 04, 2019 - 14:59:16 UTC 38.42799 -122.718 Santa Rosa 30 []
642474 October 04, 2019 - 15:33:00 UTC 38.36506 -122.67925 Santa Rosa 30 [{"latitude": "38.36562", "longitude": "-122.67878"}, {"latitude": "38.36564", "longitude": "-122.67728"}, {"latitude": "38.36686", "longitude": "-122.6773"}, {"latitude": "38.36684", "longitude": "-122.6788"}, {"latitude": "38.36613", "longitude": "-122.67879"}]
642597 October 04, 2019 - 15:42:01 UTC 38.43595 -122.66666 Santa Rosa 30 []
642743 October 04, 2019 - 16:02:53 UTC 38.45181 -122.69098 Santa Rosa 30 []
642744 October 04, 2019 - 16:02:53 UTC 38.45207 -122.6903 Santa Rosa 30 []
642795 October 04, 2019 - 16:15:59 UTC 38.4896 -122.66734 Santa Rosa 30 [{"latitude": "38.49018", "longitude": "-122.66926"}, {"latitude": "38.49067", "longitude": "-122.66797"}, {"latitude": "38.49145", "longitude": "-122.66796"}, {"latitude": "38.49383", "longitude": "-122.66795"}, {"latitude": "38.49537", "longitude": "-122.66795"}, {"latitude": "38.49623", "longitude": "-122.6701"}]
642933 October 04, 2019 - 16:29:01 UTC 38.45213 -122.69091 Santa Rosa 30 []
643400 October 04, 2019 - 17:22:44 UTC 38.44457 -122.75433 Santa Rosa 30 []
643575 October 04, 2019 - 19:31:44 UTC 38.44548 -122.7692 Santa Rosa 30 [{"latitude": "38.44373", "longitude": "-122.77541"}, {"latitude": "38.44512", "longitude": "-122.76497"}, {"latitude": "38.44571", "longitude": "-122.76292"}, {"latitude": "38.44698", "longitude": "-122.76209"}, {"latitude": "38.4501", "longitude": "-122.76173"}, {"latitude": "38.44499", "longitude": "-122.77541"}]
643767 October 04, 2019 - 23:03:00 UTC 38.45147 -122.68985 Santa Rosa 30 [{"latitude": "38.45066", "longitude": "-122.68933"}, {"latitude": "38.45133", "longitude": "-122.68983"}, {"latitude": "38.45149", "longitude": "-122.69037"}]
644214 October 05, 2019 - 16:00:00 UTC 38.53813 -122.64679 Santa Rosa 30 [{"latitude": "38.53682", "longitude": "-122.63725"}, {"latitude": "38.53856", "longitude": "-122.62194"}, {"latitude": "38.53979", "longitude": "-122.62338"}, {"latitude": "38.54067", "longitude": "-122.62511"}, {"latitude": "38.54256", "longitude": "-122.63318"}, {"latitude": "38.54102", "longitude": "-122.642"}, {"latitude": "38.53876", "longitude": "-122.64651"}, {"latitude": "38.53701", "longitude": "-122.64022"}]
645130 October 06, 2019 - 02:30:49 UTC 38.47324 -122.6364 Santa Rosa 30 []
645592 October 06, 2019 - 17:15:22 UTC 38.44867 -122.70957 Santa Rosa 30 []
645939 October 07, 2019 - 16:24:24 UTC 38.39803 -122.71379 Santa Rosa 30 [{"latitude": "38.39636", "longitude": "-122.71329"}, {"latitude": "38.39692", "longitude": "-122.71032"}, {"latitude": "38.39761", "longitude": "-122.71188"}]
645979 October 07, 2019 - 16:53:28 UTC 38.45508 -122.6071 Santa Rosa 30 []
646002 October 07, 2019 - 17:10:41 UTC 38.46643 -122.65273 Santa Rosa 30 []
646981 October 08, 2019 - 01:48:09 UTC 38.39871 -122.69299 Santa Rosa 30 []
646984 October 08, 2019 - 01:51:00 UTC 38.39951 -122.69539 Santa Rosa 30 []
647029 October 08, 2019 - 05:35:43 UTC 38.45835 -122.72893 Santa Rosa 30 []
647030 October 08, 2019 - 05:35:47 UTC 38.4581 -122.72985 Santa Rosa 30 []
647066 October 08, 2019 - 14:06:00 UTC 38.51185 -122.63853 Santa Rosa 30 [{"latitude": "38.51086", "longitude": "-122.63319"}, {"latitude": "38.51125", "longitude": "-122.6332"}, {"latitude": "38.51183", "longitude": "-122.63361"}, {"latitude": "38.51267", "longitude": "-122.6357"}, {"latitude": "38.51214", "longitude": "-122.63748"}, {"latitude": "38.51111", "longitude": "-122.63452"}]
647602 October 08, 2019 - 23:04:38 UTC 38.46433 -122.66239 Santa Rosa 30 []
647746 October 09, 2019 - 03:41:11 UTC 38.36409 -122.66404 Santa Rosa 30 []
647759 October 09, 2019 - 04:11:40 UTC 38.43216 -122.74081 Santa Rosa 30 []
648012 October 09, 2019 - 07:55:00 UTC 38.44055 -122.59919 Santa Rosa 30 []
648034 October 09, 2019 - 07:59:22 UTC 38.42482 -122.56324 Santa Rosa 30 []
648433 October 09, 2019 - 08:53:55 UTC 38.49014 -122.66601 Santa Rosa 30 [{"latitude": "38.42228", "longitude": "-122.59798"}, {"latitude": "38.42541", "longitude": "-122.59265"}, {"latitude": "38.46644", "longitude": "-122.57355"}, {"latitude": "38.48877", "longitude": "-122.57235"}, {"latitude": "38.50541", "longitude": "-122.60854"}, {"latitude": "38.49423", "longitude": "-122.66169"}, {"latitude": "38.4896", "longitude": "-122.66485"}, {"latitude": "38.48271", "longitude": "-122.66468"}, {"latitude": "38.46578", "longitude": "-122.65506"}, {"latitude": "38.46309", "longitude": "-122.65278"}, {"latitude": "38.46217", "longitude": "-122.65168"}, {"latitude": "38.42228", "longitude": "-122.59967"}]
648824 October 09, 2019 - 09:05:00 UTC 38.49014 -122.66604 Santa Rosa 30 [{"latitude": "38.45389", "longitude": "-122.6481"}, {"latitude": "38.45397", "longitude": "-122.64711"}, {"latitude": "38.45534", "longitude": "-122.6435"}, {"latitude": "38.45917", "longitude": "-122.64403"}, {"latitude": "38.49537", "longitude": "-122.66795"}, {"latitude": "38.49623", "longitude": "-122.6701"}, {"latitude": "38.48205", "longitude": "-122.67662"}, {"latitude": "38.45945", "longitude": "-122.6773"}, {"latitude": "38.45917", "longitude": "-122.67624"}, {"latitude": "38.45517", "longitude": "-122.66046"}, {"latitude": "38.45493", "longitude": "-122.65862"}]
648881 October 09, 2019 - 09:15:42 UTC 38.49014 -122.66614 Santa Rosa 30 [{"latitude": "38.41891", "longitude": "-122.65287"}, {"latitude": "38.42026", "longitude": "-122.65084"}, {"latitude": "38.42112", "longitude": "-122.64969"}, {"latitude": "38.42273", "longitude": "-122.64896"}, {"latitude": "38.44148", "longitude": "-122.65028"}, {"latitude": "38.44695", "longitude": "-122.65154"}, {"latitude": "38.48151", "longitude": "-122.6677"}, {"latitude": "38.47867", "longitude": "-122.67508"}, {"latitude": "38.47763", "longitude": "-122.67648"}, {"latitude": "38.46755", "longitude": "-122.68695"}, {"latitude": "38.46211", "longitude": "-122.68914"}, {"latitude": "38.42441", "longitude": "-122.66667"}, {"latitude": "38.42247", "longitude": "-122.66379"}]
649066 October 09, 2019 - 09:26:37 UTC 38.49014 -122.66611 Santa Rosa 30 [{"latitude": "38.45909", "longitude": "-122.63632"}, {"latitude": "38.46139", "longitude": "-122.63077"}, {"latitude": "38.50855", "longitude": "-122.5754"}, {"latitude": "38.51881", "longitude": "-122.57617"}, {"latitude": "38.52606", "longitude": "-122.58032"}, {"latitude": "38.53318", "longitude": "-122.59257"}, {"latitude": "38.5486", "longitude": "-122.63102"}, {"latitude": "38.55854", "longitude": "-122.66269"}, {"latitude": "38.55213", "longitude": "-122.66787"}, {"latitude": "38.53646", "longitude": "-122.67014"}, {"latitude": "38.47469", "longitude": "-122.6623"}, {"latitude": "38.46654", "longitude": "-122.65663"}, {"latitude": "38.46263", "longitude": "-122.64753"}, {"latitude": "38.45936", "longitude": "-122.63769"}]
649210 October 09, 2019 - 09:34:43 UTC 38.42872 -122.66442 Santa Rosa 30 []
649211 October 09, 2019 - 09:34:43 UTC 38.48066 -122.67811 Santa Rosa 30 []
649212 October 09, 2019 - 09:34:43 UTC 38.47828 -122.67669 Santa Rosa 30 []
649308 October 09, 2019 - 09:47:00 UTC 38.45328 -122.74415 Santa Rosa 30 [{"latitude": "38.45656", "longitude": "-122.74476"}, {"latitude": "38.45798", "longitude": "-122.71666"}, {"latitude": "38.45993", "longitude": "-122.70751"}, {"latitude": "38.47479", "longitude": "-122.69126"}, {"latitude": "38.47685", "longitude": "-122.69261"}, {"latitude": "38.47881", "longitude": "-122.70137"}, {"latitude": "38.47897", "longitude": "-122.7051"}, {"latitude": "38.47067", "longitude": "-122.73878"}, {"latitude": "38.47044", "longitude": "-122.73933"}, {"latitude": "38.46891", "longitude": "-122.742"}, {"latitude": "38.468", "longitude": "-122.7426"}]
649363 October 09, 2019 - 09:52:00 UTC 38.43743 -122.71262 Santa Rosa 30 [{"latitude": "38.40119", "longitude": "-122.6469"}, {"latitude": "38.4017", "longitude": "-122.63993"}, {"latitude": "38.40858", "longitude": "-122.63862"}, {"latitude": "38.41419", "longitude": "-122.64208"}, {"latitude": "38.43394", "longitude": "-122.67183"}, {"latitude": "38.43628", "longitude": "-122.6852"}, {"latitude": "38.43787", "longitude": "-122.69966"}, {"latitude": "38.43615", "longitude": "-122.70971"}, {"latitude": "38.43557", "longitude": "-122.71059"}, {"latitude": "38.4324", "longitude": "-122.71084"}, {"latitude": "38.42405", "longitude": "-122.70746"}, {"latitude": "38.42312", "longitude": "-122.70676"}, {"latitude": "38.42271", "longitude": "-122.70636"}, {"latitude": "38.42183", "longitude": "-122.70482"}, {"latitude": "38.40265", "longitude": "-122.65111"}]
649446 October 09, 2019 - 10:11:23 UTC 38.4404 -122.71142 Santa Rosa 30 []
649447 October 09, 2019 - 10:11:23 UTC 38.44816 -122.70003 Santa Rosa 30 []
649454 October 09, 2019 - 10:13:43 UTC 38.45867 -122.68982 Santa Rosa 30 []
649850 October 09, 2019 - 10:48:03 UTC 38.38001 -122.68583 Santa Rosa 30 [{"latitude": "38.34235", "longitude": "-122.66679"}, {"latitude": "38.34892", "longitude": "-122.63859"}, {"latitude": "38.36475", "longitude": "-122.60498"}, {"latitude": "38.37349", "longitude": "-122.59361"}, {"latitude": "38.38926", "longitude": "-122.58488"}, {"latitude": "38.39359", "longitude": "-122.58725"}, {"latitude": "38.39526", "longitude": "-122.58914"}, {"latitude": "38.40026", "longitude": "-122.59705"}, {"latitude": "38.40123", "longitude": "-122.59905"}, {"latitude": "38.40212", "longitude": "-122.60135"}, {"latitude": "38.4034", "longitude": "-122.60489"}, {"latitude": "38.40362", "longitude": "-122.60603"}, {"latitude": "38.40504", "longitude": "-122.61758"}, {"latitude": "38.40567", "longitude": "-122.63337"}, {"latitude": "38.40636", "longitude": "-122.69475"}, {"latitude": "38.4059", "longitude": "-122.69977"}, {"latitude": "38.3855", "longitude": "-122.69136"}, {"latitude": "38.38278", "longitude": "-122.69003"}]
650278 October 09, 2019 - 07:51:00 UTC 38.5588 -122.62836 Santa Rosa 30 [{"latitude": "38.55041", "longitude": "-122.6258"}, {"latitude": "38.55228", "longitude": "-122.62452"}, {"latitude": "38.55608", "longitude": "-122.62628"}, {"latitude": "38.55768", "longitude": "-122.62823"}, {"latitude": "38.55639", "longitude": "-122.62992"}, {"latitude": "38.55208", "longitude": "-122.62906"}]
650283 October 09, 2019 - 07:51:00 UTC 38.54727 -122.58221 Santa Rosa 30 [{"latitude": "38.53768", "longitude": "-122.58648"}, {"latitude": "38.5429", "longitude": "-122.58365"}, {"latitude": "38.54482", "longitude": "-122.58304"}, {"latitude": "38.53835", "longitude": "-122.58782"}]
650431 October 09, 2019 - 12:46:06 UTC 38.43972 -122.71729 Santa Rosa 30 []
650501 October 09, 2019 - 13:26:24 UTC 38.39442 -122.70918 Santa Rosa 30 []
650650 October 09, 2019 - 14:25:28 UTC 38.44899 -122.80079 Santa Rosa 30 []
650667 October 09, 2019 - 14:29:02 UTC 38.44944 -122.75132 Santa Rosa 30 [{"latitude": "38.44944", "longitude": "-122.75478"}, {"latitude": "38.44956", "longitude": "-122.75189"}, {"latitude": "38.45108", "longitude": "-122.75349"}, {"latitude": "38.45106", "longitude": "-122.75493"}, {"latitude": "38.44995", "longitude": "-122.75871"}]
650844 October 09, 2019 - 17:13:27 UTC 38.45829 -122.75382 Santa Rosa 30 []
650880 October 09, 2019 - 09:47:00 UTC 38.47677 -122.70356 Santa Rosa 30 [{"latitude": "38.47479", "longitude": "-122.69126"}, {"latitude": "38.47685", "longitude": "-122.69261"}, {"latitude": "38.47825", "longitude": "-122.69986"}, {"latitude": "38.47713", "longitude": "-122.70203"}, {"latitude": "38.47589", "longitude": "-122.70017"}, {"latitude": "38.47524", "longitude": "-122.69893"}, {"latitude": "38.47496", "longitude": "-122.69686"}]
650928 October 09, 2019 - 09:26:37 UTC 38.49694 -122.65506 Santa Rosa 30 [{"latitude": "38.49373", "longitude": "-122.65176"}, {"latitude": "38.49765", "longitude": "-122.65355"}, {"latitude": "38.49692", "longitude": "-122.65485"}, {"latitude": "38.49397", "longitude": "-122.65358"}]
650929 October 09, 2019 - 09:26:37 UTC 38.49676 -122.64398 Santa Rosa 30 [{"latitude": "38.48226", "longitude": "-122.62381"}, {"latitude": "38.48226", "longitude": "-122.62174"}, {"latitude": "38.4902", "longitude": "-122.625"}, {"latitude": "38.49613", "longitude": "-122.63395"}, {"latitude": "38.49563", "longitude": "-122.64098"}, {"latitude": "38.48462", "longitude": "-122.64277"}, {"latitude": "38.4823", "longitude": "-122.63448"}]
650943 October 09, 2019 - 10:50:32 UTC 38.52487 -122.71953 Santa Rosa 30 [{"latitude": "38.52613", "longitude": "-122.72449"}, {"latitude": "38.52617", "longitude": "-122.71952"}, {"latitude": "38.54822", "longitude": "-122.71852"}, {"latitude": "38.54579", "longitude": "-122.7204"}, {"latitude": "38.53778", "longitude": "-122.72508"}, {"latitude": "38.52966", "longitude": "-122.72888"}, {"latitude": "38.52844", "longitude": "-122.72798"}, {"latitude": "38.52687", "longitude": "-122.72608"}]
650952 October 09, 2019 - 10:50:32 UTC 38.5423 -122.72032 Santa Rosa 30 [{"latitude": "38.54036", "longitude": "-122.71593"}, {"latitude": "38.54184", "longitude": "-122.71458"}, {"latitude": "38.54294", "longitude": "-122.71538"}, {"latitude": "38.54326", "longitude": "-122.71812"}, {"latitude": "38.54287", "longitude": "-122.71843"}, {"latitude": "38.5417", "longitude": "-122.71912"}, {"latitude": "38.54044", "longitude": "-122.71931"}]
650957 October 09, 2019 - 10:50:32 UTC 38.54721 -122.72036 Santa Rosa 30 [{"latitude": "38.5414", "longitude": "-122.71122"}, {"latitude": "38.54659", "longitude": "-122.70917"}, {"latitude": "38.54752", "longitude": "-122.71513"}, {"latitude": "38.54716", "longitude": "-122.71964"}, {"latitude": "38.54153", "longitude": "-122.71284"}]
650961 October 09, 2019 - 10:50:32 UTC 38.55013 -122.71882 Santa Rosa 30 [{"latitude": "38.55074", "longitude": "-122.71948"}, {"latitude": "38.55208", "longitude": "-122.7178"}, {"latitude": "38.5575", "longitude": "-122.72003"}, {"latitude": "38.56415", "longitude": "-122.72683"}, {"latitude": "38.56615", "longitude": "-122.73255"}, {"latitude": "38.56186", "longitude": "-122.73921"}, {"latitude": "38.55423", "longitude": "-122.73637"}, {"latitude": "38.5527", "longitude": "-122.73432"}, {"latitude": "38.55196", "longitude": "-122.73328"}]
650965 October 09, 2019 - 10:50:32 UTC 38.55964 -122.6915 Santa Rosa 30 [{"latitude": "38.55958", "longitude": "-122.69188"}, {"latitude": "38.56626", "longitude": "-122.67559"}, {"latitude": "38.57158", "longitude": "-122.68004"}, {"latitude": "38.57253", "longitude": "-122.69441"}, {"latitude": "38.56047", "longitude": "-122.69375"}, {"latitude": "38.5599", "longitude": "-122.69354"}]
651029 October 09, 2019 - 09:34:43 UTC 38.45108 -122.69435 Santa Rosa 30 [{"latitude": "38.45134", "longitude": "-122.6941"}, {"latitude": "38.45481", "longitude": "-122.6905"}, {"latitude": "38.45567", "longitude": "-122.68998"}, {"latitude": "38.45801", "longitude": "-122.69003"}, {"latitude": "38.46073", "longitude": "-122.69098"}, {"latitude": "38.45984", "longitude": "-122.69311"}]
651058 October 09, 2019 - 20:29:33 UTC 38.45168 -122.74678 Santa Rosa 30 []
651135 October 09, 2019 - 21:18:32 UTC 38.48023 -122.71795 Santa Rosa 30 [{"latitude": "38.47535", "longitude": "-122.71405"}, {"latitude": "38.47546", "longitude": "-122.71287"}, {"latitude": "38.47703", "longitude": "-122.71347"}, {"latitude": "38.479", "longitude": "-122.71502"}, {"latitude": "38.48037", "longitude": "-122.71625"}, {"latitude": "38.48001", "longitude": "-122.71833"}, {"latitude": "38.47894", "longitude": "-122.71831"}, {"latitude": "38.47555", "longitude": "-122.71532"}]
651147 October 09, 2019 - 09:05:00 UTC 38.47978 -122.67232 Santa Rosa 30 []
651150 October 09, 2019 - 09:05:00 UTC 38.46908 -122.66688 Santa Rosa 30 [{"latitude": "38.46397", "longitude": "-122.6651"}, {"latitude": "38.4675", "longitude": "-122.66163"}, {"latitude": "38.46967", "longitude": "-122.66227"}, {"latitude": "38.47163", "longitude": "-122.66301"}, {"latitude": "38.46767", "longitude": "-122.67133"}, {"latitude": "38.46704", "longitude": "-122.67202"}, {"latitude": "38.46531", "longitude": "-122.67052"}, {"latitude": "38.46407", "longitude": "-122.6694"}]
651154 October 09, 2019 - 09:05:00 UTC 38.47121 -122.66711 Santa Rosa 30 [{"latitude": "38.47127", "longitude": "-122.66694"}, {"latitude": "38.47159", "longitude": "-122.66603"}, {"latitude": "38.47329", "longitude": "-122.66219"}, {"latitude": "38.47747", "longitude": "-122.66759"}, {"latitude": "38.47695", "longitude": "-122.66879"}]
651157 October 09, 2019 - 09:05:00 UTC 38.46372 -122.66512 Santa Rosa 30 [{"latitude": "38.45389", "longitude": "-122.6481"}, {"latitude": "38.45397", "longitude": "-122.64711"}, {"latitude": "38.45534", "longitude": "-122.6435"}, {"latitude": "38.45917", "longitude": "-122.64403"}, {"latitude": "38.47348", "longitude": "-122.65838"}, {"latitude": "38.47271", "longitude": "-122.66195"}, {"latitude": "38.46695", "longitude": "-122.67341"}, {"latitude": "38.46645", "longitude": "-122.67398"}, {"latitude": "38.46239", "longitude": "-122.67606"}, {"latitude": "38.46112", "longitude": "-122.67666"}, {"latitude": "38.45945", "longitude": "-122.6773"}, {"latitude": "38.45917", "longitude": "-122.67624"}, {"latitude": "38.45517", "longitude": "-122.66046"}, {"latitude": "38.45493", "longitude": "-122.65862"}]
651162 October 09, 2019 - 09:05:00 UTC 38.46214 -122.6582 Santa Rosa 30 [{"latitude": "38.45493", "longitude": "-122.65862"}, {"latitude": "38.46041", "longitude": "-122.65799"}, {"latitude": "38.45517", "longitude": "-122.66046"}]
651468 October 09, 2019 - 23:04:50 UTC 38.38715 -122.73144 Santa Rosa 30 []
651563 October 09, 2019 - 09:34:43 UTC 38.48801 -122.67803 Santa Rosa 30 [{"latitude": "38.48652", "longitude": "-122.68477"}, {"latitude": "38.48826", "longitude": "-122.67751"}, {"latitude": "38.48753", "longitude": "-122.68378"}]
651568 October 09, 2019 - 09:34:43 UTC 38.49662 -122.68494 Santa Rosa 30 [{"latitude": "38.49346", "longitude": "-122.7012"}, {"latitude": "38.49356", "longitude": "-122.70017"}, {"latitude": "38.49555", "longitude": "-122.68657"}, {"latitude": "38.49667", "longitude": "-122.68775"}, {"latitude": "38.49669", "longitude": "-122.69093"}, {"latitude": "38.49664", "longitude": "-122.69553"}, {"latitude": "38.49603", "longitude": "-122.70257"}, {"latitude": "38.49433", "longitude": "-122.70479"}, {"latitude": "38.49348", "longitude": "-122.7045"}]
651574 October 09, 2019 - 09:34:43 UTC 38.50062 -122.68629 Santa Rosa 30 [{"latitude": "38.50062", "longitude": "-122.68624"}, {"latitude": "38.50109", "longitude": "-122.68534"}, {"latitude": "38.50355", "longitude": "-122.68123"}, {"latitude": "38.50804", "longitude": "-122.67865"}, {"latitude": "38.50862", "longitude": "-122.67961"}]
651620 October 09, 2019 - 09:34:43 UTC 38.51168 -122.69201 Santa Rosa 30 [{"latitude": "38.51202", "longitude": "-122.69986"}, {"latitude": "38.5134", "longitude": "-122.69008"}, {"latitude": "38.51644", "longitude": "-122.69364"}, {"latitude": "38.51847", "longitude": "-122.69646"}, {"latitude": "38.51969", "longitude": "-122.69922"}, {"latitude": "38.52048", "longitude": "-122.70118"}, {"latitude": "38.5203", "longitude": "-122.70212"}, {"latitude": "38.51307", "longitude": "-122.7003"}]
651622 October 09, 2019 - 09:34:43 UTC 38.45428 -122.70052 Santa Rosa 30 [{"latitude": "38.45459", "longitude": "-122.70023"}, {"latitude": "38.45621", "longitude": "-122.69754"}, {"latitude": "38.45829", "longitude": "-122.69439"}, {"latitude": "38.45898", "longitude": "-122.69591"}, {"latitude": "38.4576", "longitude": "-122.70395"}, {"latitude": "38.45694", "longitude": "-122.70364"}, {"latitude": "38.45507", "longitude": "-122.70101"}]
651634 October 09, 2019 - 09:34:43 UTC 38.45797 -122.70795 Santa Rosa 30 [{"latitude": "38.45783", "longitude": "-122.70597"}, {"latitude": "38.45823", "longitude": "-122.70295"}, {"latitude": "38.45849", "longitude": "-122.70185"}, {"latitude": "38.46075", "longitude": "-122.70005"}, {"latitude": "38.46299", "longitude": "-122.69949"}, {"latitude": "38.46358", "longitude": "-122.69961"}, {"latitude": "38.46487", "longitude": "-122.70099"}, {"latitude": "38.466", "longitude": "-122.70249"}, {"latitude": "38.46505", "longitude": "-122.70434"}, {"latitude": "38.46376", "longitude": "-122.70651"}, {"latitude": "38.46094", "longitude": "-122.70737"}, {"latitude": "38.45822", "longitude": "-122.70734"}]
651636 October 09, 2019 - 09:34:43 UTC 38.45042 -122.69249 Santa Rosa 30 [{"latitude": "38.45061", "longitude": "-122.69232"}, {"latitude": "38.45066", "longitude": "-122.68933"}, {"latitude": "38.45153", "longitude": "-122.689"}, {"latitude": "38.45392", "longitude": "-122.68871"}, {"latitude": "38.45447", "longitude": "-122.68889"}]
651659 October 09, 2019 - 09:34:43 UTC 38.48639 -122.67711 Santa Rosa 30 [{"latitude": "38.48853", "longitude": "-122.67547"}, {"latitude": "38.49058", "longitude": "-122.67396"}, {"latitude": "38.50846", "longitude": "-122.66278"}, {"latitude": "38.53302", "longitude": "-122.67641"}, {"latitude": "38.53386", "longitude": "-122.68081"}, {"latitude": "38.52976", "longitude": "-122.69624"}, {"latitude": "38.51192", "longitude": "-122.69325"}, {"latitude": "38.49821", "longitude": "-122.68874"}, {"latitude": "38.49048", "longitude": "-122.68007"}]
651665 October 09, 2019 - 09:34:43 UTC 38.5039 -122.68664 Santa Rosa 30 [{"latitude": "38.49786", "longitude": "-122.70295"}, {"latitude": "38.49809", "longitude": "-122.69786"}, {"latitude": "38.49932", "longitude": "-122.69316"}, {"latitude": "38.50548", "longitude": "-122.68945"}, {"latitude": "38.51641", "longitude": "-122.70194"}, {"latitude": "38.51747", "longitude": "-122.70486"}, {"latitude": "38.51864", "longitude": "-122.71075"}, {"latitude": "38.51839", "longitude": "-122.71202"}, {"latitude": "38.51654", "longitude": "-122.71355"}, {"latitude": "38.51101", "longitude": "-122.71662"}, {"latitude": "38.49793", "longitude": "-122.71181"}]
651673 October 09, 2019 - 10:38:00 UTC 38.38369 -122.6868 Santa Rosa 30 [{"latitude": "38.38277", "longitude": "-122.6891"}, {"latitude": "38.38307", "longitude": "-122.68788"}, {"latitude": "38.38529", "longitude": "-122.68631"}, {"latitude": "38.39119", "longitude": "-122.68349"}, {"latitude": "38.40033", "longitude": "-122.68798"}, {"latitude": "38.40636", "longitude": "-122.69475"}, {"latitude": "38.4059", "longitude": "-122.69977"}, {"latitude": "38.3855", "longitude": "-122.69136"}, {"latitude": "38.38278", "longitude": "-122.69003"}]
651683 October 09, 2019 - 10:38:00 UTC 38.38085 -122.68372 Santa Rosa 30 [{"latitude": "38.38267", "longitude": "-122.68305"}, {"latitude": "38.38278", "longitude": "-122.67383"}, {"latitude": "38.38396", "longitude": "-122.67158"}, {"latitude": "38.38548", "longitude": "-122.67238"}, {"latitude": "38.39134", "longitude": "-122.68125"}]
651691 October 09, 2019 - 10:38:00 UTC 38.37475 -122.67131 Santa Rosa 30 [{"latitude": "38.38173", "longitude": "-122.66725"}, {"latitude": "38.38545", "longitude": "-122.6654"}, {"latitude": "38.38998", "longitude": "-122.66389"}, {"latitude": "38.39213", "longitude": "-122.66408"}, {"latitude": "38.38677", "longitude": "-122.66946"}, {"latitude": "38.38386", "longitude": "-122.66875"}]
651693 October 09, 2019 - 10:38:00 UTC 38.3451 -122.6667 Santa Rosa 30 [{"latitude": "38.34511", "longitude": "-122.66617"}, {"latitude": "38.34542", "longitude": "-122.65762"}, {"latitude": "38.34892", "longitude": "-122.63859"}, {"latitude": "38.3515", "longitude": "-122.63316"}, {"latitude": "38.35594", "longitude": "-122.62666"}, {"latitude": "38.35731", "longitude": "-122.62626"}, {"latitude": "38.36142", "longitude": "-122.62972"}, {"latitude": "38.36399", "longitude": "-122.63201"}, {"latitude": "38.36335", "longitude": "-122.63747"}, {"latitude": "38.35669", "longitude": "-122.65155"}, {"latitude": "38.35428", "longitude": "-122.65618"}]

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