Site Name: Columbia River at Mica Dam USGS ID Number: 12227100 Time step: monthly Data record: 10/49 - 9/89, water year 1950-1989 Units: cfs Source of observed naturalized data: Bonneville Power Administration. Source of simulated naturalized data: Variable Infiltration Capacity VIC hydrologic model, Dept. of Civil and Envir. Eng., University of Washington. VIC Version 4.0.3, 1/8 degree spatial resolution, daily time step water balance simulation, 1-hour snow model time step. Notes: The climate change scenarios are created by adjusting the observed naturalized flows in the first column of data using changes in streamflow extracted from bias corrected hydrologic simulations. month water_year observed adjusted_comp_2020 adjusted_comp_2040 10 1950 7955 10676 10666 11 1950 6405 6186 6173 12 1950 4014 4114 4047 1 1950 2428 2393 2300 2 1950 2355 2359 2418 3 1950 2923 3489 3596 4 1950 4730 4574 4601 5 1950 17626 23403 21514 6 1950 66408 71619 71514 7 1950 73301 65847 61006 8 1950 39670 36422 34679 9 1950 23044 20139 19003 10 1951 9655 9581 9482 11 1951 6348 6193 6138 12 1951 4653 4510 4578 1 1951 4001 3809 3849 2 1951 3534 3387 3407 3 1951 3490 3356 3496 4 1951 6711 8627 9557 5 1951 36347 42316 42020 6 1951 47470 57862 58884 7 1951 68073 62315 62312 8 1951 37244 29291 26656 9 1951 16598 13915 12059 10 1952 10458 10171 10061 11 1952 5430 5129 4466 12 1952 3237 2986 3101 1 1952 2665 2217 2195 2 1952 2550 2421 2729 3 1952 2637 2609 2847 4 1952 8387 10677 11350 5 1952 33965 39998 41178 6 1952 52544 58307 61185 7 1952 53560 46887 49319 8 1952 37592 26978 26559 9 1952 16991 14557 13492 10 1953 10227 9597 8273 11 1953 4566 4335 3106 12 1953 3191 3066 2829 1 1953 3137 3072 2903 2 1953 3025 3080 2897 3 1953 2982 3169 3045 4 1953 3974 5260 5275 5 1953 25514 34546 32307 6 1953 52945 60085 56933 7 1953 55327 49606 46882 8 1953 38136 30931 27869 9 1953 20801 18905 15588 10 1954 12558 13658 12164 11 1954 8988 9837 9495 12 1954 4857 4938 4914 1 1954 3616 3812 3719 2 1954 3804 4189 4729 3 1954 3444 3701 3830 4 1954 4035 4377 4599 5 1954 28183 36462 35337 6 1954 59679 80501 80447 7 1954 81632 87062 84646 8 1954 49251 44964 43512 9 1954 28799 26235 19363 10 1955 11722 10573 9049 11 1955 9492 9678 8615 12 1955 6134 6149 5622 1 1955 4092 3904 3366 2 1955 3590 3489 3158 3 1955 3476 3347 3190 4 1955 4811 6068 6098 5 1955 14650 18403 15101 6 1955 58698 64830 62866 7 1955 69911 67143 63738 8 1955 38470 29515 26699 9 1955 21165 17154 14666 10 1956 8985 8177 7450 11 1956 5637 5355 5015 12 1956 4402 3886 3309 1 1956 3643 3240 2922 2 1956 2684 2298 1985 3 1956 3028 2968 3031 4 1956 8468 10893 11934 5 1956 34922 50418 45652 6 1956 65049 83556 78575 7 1956 56629 45125 44797 8 1956 37859 26608 25326 9 1956 19435 14706 13396 10 1957 10966 10414 10386 11 1957 5866 4981 5016 12 1957 4192 3555 3705 1 1957 3289 3095 3240 2 1957 3332 3035 3115 3 1957 3387 3428 3848 4 1957 5687 7718 8721 5 1957 52969 70269 69144 6 1957 56009 55835 58096 7 1957 43836 34923 36783 8 1957 28014 24299 24923 9 1957 19284 16244 16220 10 1958 10245 10185 10040 11 1958 5680 5823 5607 12 1958 4023 4258 4094 1 1958 3729 3701 3645 2 1958 3551 3807 4033 3 1958 3599 3880 4323 4 1958 6167 7964 8359 5 1958 41684 50113 45601 6 1958 68217 67465 67371 7 1958 47495 38473 37920 8 1958 38058 33485 20917 9 1958 19397 18637 15681 10 1959 11746 11030 10555 11 1959 6063 6072 5461 12 1959 4635 4845 4371 1 1959 4038 4254 3857 2 1959 3443 3263 3153 3 1959 3180 3391 3578 4 1959 6232 8253 8406 5 1959 26728 36900 36682 6 1959 61233 69464 69299 7 1959 69107 60400 57152 8 1959 37106 30533 29651 9 1959 26432 23615 17366 10 1960 13340 12441 11913 11 1960 8236 8158 7839 12 1960 6007 5881 5759 1 1960 4212 3951 3830 2 1960 3856 3674 3791 3 1960 3894 4101 4706 4 1960 9020 11799 12402 5 1960 17931 25414 24276 6 1960 47993 57078 58817 7 1960 68274 54894 57228 8 1960 38123 28136 27554 9 1960 21165 19099 17482 10 1961 12284 11448 12327 11 1961 8069 8767 8492 12 1961 4536 4237 4769 1 1961 4305 4570 5087 2 1961 3885 3966 4974 3 1961 3879 4904 5250 4 1961 6266 7820 9192 5 1961 35499 45372 40901 6 1961 84206 79573 88431 7 1961 50050 41004 44268 8 1961 40985 35544 38185 9 1961 17732 15026 14549 10 1962 12688 14149 13157 11 1962 6356 6066 5707 12 1962 4587 4441 3816 1 1962 3615 3660 3320 2 1962 4113 4238 4551 3 1962 3116 3296 3624 4 1962 9475 11513 12262 5 1962 24456 33289 32053 6 1962 52715 63083 65821 7 1962 54585 48405 49299 8 1962 42066 36561 35750 9 1962 18778 16688 15294 10 1963 10926 10141 10367 11 1963 8771 9331 8678 12 1963 5452 5454 5499 1 1963 4380 4445 4321 2 1963 4946 5253 5962 3 1963 4619 5283 5661 4 1963 8803 10245 12703 5 1963 25113 32994 34508 6 1963 58475 64754 67380 7 1963 54597 46969 49455 8 1963 39973 32104 30967 9 1963 27117 23101 22429 10 1964 12510 11965 11370 11 1964 6751 6822 6297 12 1964 4610 4632 4379 1 1964 3953 3881 3787 2 1964 3353 3340 3210 3 1964 2961 2918 2897 4 1964 5232 7089 7187 5 1964 18311 27371 25564 6 1964 61183 78805 77085 7 1964 66344 66211 63404 8 1964 35460 33317 30787 9 1964 19057 14924 10831 10 1965 15006 16568 14483 11 1965 8945 9650 8838 12 1965 4799 4893 4449 1 1965 4082 3957 3775 2 1965 3926 3868 3856 3 1965 3531 3861 4314 4 1965 8464 11010 11454 5 1965 23766 32844 32482 6 1965 55757 73639 67319 7 1965 59623 48695 48743 8 1965 49111 42439 41713 9 1965 14889 11560 10744 10 1966 12439 12919 11493 11 1966 9590 10772 9525 12 1966 5831 6971 6567 1 1966 4298 4393 4015 2 1966 4208 4244 3866 3 1966 4501 5477 5421 4 1966 10766 14518 14850 5 1966 32240 36329 34504 6 1966 55465 86956 83303 7 1966 62405 60796 57974 8 1966 41803 32422 29758 9 1966 23133 17415 15740 10 1967 12817 11539 11549 11 1967 7831 7612 7128 12 1967 5369 6252 6690 1 1967 4427 4199 4396 2 1967 3974 4048 4477 3 1967 3540 4183 4702 4 1967 5338 6988 8568 5 1967 23564 32718 33866 6 1967 87675 103353 108252 7 1967 75998 65920 70311 8 1967 47979 35759 37643 9 1967 29457 22888 22862 10 1968 13420 12587 11352 11 1968 8333 7984 7082 12 1968 4102 3792 3420 1 1968 3925 3779 3498 2 1968 4045 3880 3902 3 1968 4559 5372 5563 4 1968 4774 6602 6496 5 1968 24619 33972 30094 6 1968 59742 70698 64324 7 1968 70054 61872 53249 8 1968 39215 32544 28246 9 1968 24279 22426 17400 10 1969 11505 11235 10388 11 1969 7666 8185 7075 12 1969 4584 4549 4243 1 1969 2790 2745 2452 2 1969 3072 2841 2760 3 1969 3412 3947 4303 4 1969 11130 15508 16773 5 1969 36670 57139 51834 6 1969 70351 64757 63678 7 1969 46908 43733 42428 8 1969 34446 27763 25740 9 1969 20282 17577 16335 10 1970 11588 11352 9157 11 1970 7386 7619 6192 12 1970 4184 5094 3670 1 1970 3388 3252 2513 2 1970 3386 3335 3007 3 1970 2996 3735 3601 4 1970 4113 5513 4914 5 1970 18780 26691 22704 6 1970 60102 62375 55139 7 1970 49940 35699 30971 8 1970 36382 27372 23899 9 1970 14929 12842 9351 10 1971 7949 7035 6139 11 1971 4219 3900 2857 12 1971 3028 2773 2083 1 1971 3118 2890 2468 2 1971 3277 3351 3805 3 1971 2829 2882 3003 4 1971 6257 9549 9989 5 1971 34948 36711 37190 6 1971 59642 82195 84022 7 1971 50235 38568 39719 8 1971 47529 40638 38817 9 1971 20595 17531 15789 10 1972 10703 9413 8186 11 1972 5964 5412 5619 12 1972 3054 2634 2420 1 1972 2763 2304 1926 2 1972 2706 2295 2198 3 1972 3748 4627 5711 4 1972 6024 8975 10031 5 1972 35839 41313 42806 6 1972 90309 95830 98819 7 1972 61120 50352 53677 8 1972 47776 35850 36752 9 1972 19273 11131 9026 10 1973 10508 10538 10293 11 1973 6087 6336 5953 12 1973 4295 5767 5904 1 1973 3518 3931 3872 2 1973 3172 3582 3656 3 1973 3533 4264 4817 4 1973 5623 7924 8261 5 1973 25502 30387 30430 6 1973 48825 58381 59887 7 1973 49564 45326 46772 8 1973 35875 32688 29863 9 1973 18433 16567 14787 10 1974 11482 11792 11069 11 1974 9750 10109 9728 12 1974 4216 4202 4010 1 1974 3662 3657 3484 2 1974 3447 3535 3448 3 1974 3143 3252 3507 4 1974 8021 11051 11932 5 1974 20341 35639 33204 6 1974 68848 96392 91820 7 1974 63394 62921 59192 8 1974 44516 35850 32276 9 1974 28068 22383 19735 10 1975 10779 9911 7916 11 1975 6201 6048 5904 12 1975 4957 4835 4855 1 1975 3549 3308 2835 2 1975 3529 3355 2949 3 1975 2247 2219 2212 4 1975 6558 7739 8311 5 1975 19086 27709 25522 6 1975 44687 55669 56630 7 1975 60868 48597 49223 8 1975 35047 31678 30731 9 1975 18515 16219 15345 10 1976 11043 10679 11636 11 1976 11918 12614 13418 12 1976 5363 5620 6175 1 1976 4163 3997 4402 2 1976 3685 3490 4084 3 1976 3051 3613 4208 4 1976 8182 9889 11598 5 1976 34975 38913 37620 6 1976 44816 54095 59875 7 1976 70985 66812 72625 8 1976 57407 43824 41747 9 1976 32468 27735 27614 10 1977 11717 10642 9727 11 1977 6263 5904 5307 12 1977 4476 4584 5110 1 1977 4397 4248 4120 2 1977 3298 3297 3307 3 1977 4407 4947 4800 4 1977 8283 10253 10305 5 1977 22719 33070 32350 6 1977 49129 51674 51537 7 1977 39719 32946 32503 8 1977 39707 33919 29071 9 1977 16352 12912 11406 10 1978 7211 6453 4775 11 1978 5241 5328 4957 12 1978 4328 4115 4031 1 1978 3696 3427 3356 2 1978 3027 2778 2803 3 1978 3556 3975 4492 4 1978 7624 9553 9767 5 1978 18993 30298 29974 6 1978 51866 58777 58343 7 1978 60135 48911 49374 8 1978 35827 29418 25776 9 1978 28543 25730 19449 10 1979 12728 15299 11603 11 1979 9798 10763 8620 12 1979 5143 6472 4957 1 1979 3326 3869 3273 2 1979 3752 4359 3835 3 1979 4060 4911 4856 4 1979 5939 8639 8386 5 1979 21669 35576 31625 6 1979 48097 68626 63118 7 1979 52460 50056 45170 8 1979 36000 32458 29691 9 1979 21425 21797 18519 10 1980 9889 8493 7143 11 1980 4046 3167 2313 12 1980 4044 3885 3935 1 1980 3614 3300 2850 2 1980 3038 2782 2643 3 1980 3229 3273 3867 4 1980 11742 13599 14674 5 1980 45508 68162 64314 6 1980 50530 54437 54691 7 1980 41663 35527 35720 8 1980 27127 20827 18087 9 1980 17360 14620 13400 10 1981 11976 11948 10777 11 1981 6672 7855 6975 12 1981 6064 6292 6488 1 1981 4237 4731 4816 2 1981 3641 3823 4575 3 1981 4528 5073 5788 4 1981 7709 10705 11562 5 1981 37225 52143 44261 6 1981 41590 54899 56127 7 1981 58692 53150 53038 8 1981 49011 38257 37435 9 1981 22417 16943 16084 10 1982 8358 7774 7107 11 1982 8232 9246 8776 12 1982 4418 4373 4251 1 1982 4107 3888 3809 2 1982 3921 3819 4046 3 1982 3520 4100 4433 4 1982 4373 6039 6160 5 1982 21220 33526 32525 6 1982 68780 83730 83090 7 1982 60663 54104 53990 8 1982 36206 26744 24935 9 1982 27593 24064 17779 10 1983 11324 12956 11058 11 1983 6611 7608 6376 12 1983 4191 4192 4013 1 1983 4371 4122 4067 2 1983 3748 4431 4818 3 1983 4403 5091 5703 4 1983 7387 10985 11289 5 1983 26108 41838 32619 6 1983 49235 55055 54028 7 1983 53923 50666 49362 8 1983 39277 37117 33540 9 1983 18224 17399 15219 10 1984 9280 9336 8759 11 1984 9917 11398 11123 12 1984 4194 4736 3875 1 1984 5293 5675 5890 2 1984 4053 4467 4822 3 1984 4000 4587 5098 4 1984 7127 9654 10074 5 1984 11343 14385 13238 6 1984 49542 62691 64578 7 1984 54545 52202 50030 8 1984 41259 36376 36053 9 1984 19915 18617 12452 10 1985 10240 8693 7964 11 1985 5710 4984 3961 12 1985 4276 3594 3454 1 1985 3556 2994 2718 2 1985 4315 3804 3628 3 1985 2537 2553 2701 4 1985 6831 8797 9257 5 1985 32610 40772 31756 6 1985 46212 63022 52369 7 1985 48979 35713 37192 8 1985 28486 18311 17895 9 1985 13286 10031 9155 10 1986 8561 9205 8748 11 1986 5376 6840 5712 12 1986 3675 3873 3552 1 1986 3585 4302 4127 2 1986 3520 3978 3894 3 1986 4373 5524 6054 4 1986 7561 10333 10641 5 1986 26954 38410 36859 6 1986 72980 78134 75386 7 1986 50935 46578 41219 8 1986 37209 34633 31387 9 1986 16351 15028 13561 10 1987 8491 8746 7370 11 1987 5879 6787 5998 12 1987 4923 5174 4669 1 1987 2905 3127 2830 2 1987 3605 3862 3742 3 1987 5143 5992 6271 4 1987 9378 13257 13010 5 1987 38237 60325 51545 6 1987 58486 72261 68148 7 1987 45690 41772 39420 8 1987 27938 25814 20667 9 1987 19686 18513 16443 10 1988 6861 5784 6101 11 1988 5032 5388 5375 12 1988 3748 4046 4414 1 1988 3262 3094 3420 2 1988 4154 4381 5044 3 1988 3571 4329 5331 4 1988 11666 15689 18398 5 1988 28325 34891 31993 6 1988 56371 68964 63393 7 1988 44827 34285 39176 8 1988 34234 28929 29544 9 1988 17815 14078 14676 10 1989 11278 10813 10292 11 1989 7606 8478 7828 12 1989 4827 4320 4939 1 1989 4783 4697 4779 2 1989 4249 4175 4293 3 1989 3308 3838 4466 4 1989 7888 10153 11263 5 1989 27041 39473 29850 6 1989 54300 67583 71095 7 1989 46881 41574 43404 8 1989 38896 34218 34304 9 1989 16525 13881 12526