Frequencies for planreportsanctioned2015 dataset : by Jean Roth , jroth@nber.org , 14 Apr 2016 Frequencies for state variable in planreportsanctioned2015 dataset : State | Freq. Percent Cum. ----------------+----------------------------------- Alabama | 1 0.40 0.40 Alaska | 1 0.40 0.81 Arizona | 1 0.40 1.21 Arkansas | 1 0.40 1.62 California | 4 1.62 3.24 Colorado | 1 0.40 3.64 Connecticut | 1 0.40 4.05 Delaware | 1 0.40 4.45 Florida | 1 0.40 4.86 Georgia | 1 0.40 5.26 Hawaii | 1 0.40 5.67 Idaho | 1 0.40 6.07 Illinois | 1 0.40 6.48 Indiana | 1 0.40 6.88 Iowa | 1 0.40 7.29 Kansas | 1 0.40 7.69 Kentucky | 1 0.40 8.10 Louisiana | 1 0.40 8.50 Maine | 1 0.40 8.91 Maryland | 1 0.40 9.31 Massachusetts | 1 0.40 9.72 Michigan | 1 0.40 10.12 Minnesota | 1 0.40 10.53 Mississippi | 1 0.40 10.93 Missouri | 1 0.40 11.34 Montana | 1 0.40 11.74 Nebraska | 1 0.40 12.15 Nevada | 1 0.40 12.55 New Hampshire | 1 0.40 12.96 New Jersey | 1 0.40 13.36 New Mexico | 1 0.40 13.77 New York | 1 0.40 14.17 North Carolina | 1 0.40 14.57 North Dakota | 1 0.40 14.98 Ohio | 99 40.08 55.06 Oklahoma | 1 0.40 55.47 Oregon | 1 0.40 55.87 Pennsylvania | 93 37.65 93.52 Puerto Rico | 1 0.40 93.93 Rhode Island | 1 0.40 94.33 South Carolina | 1 0.40 94.74 South Dakota | 1 0.40 95.14 Tennessee | 1 0.40 95.55 Texas | 1 0.40 95.95 Utah | 1 0.40 96.36 Vermont | 1 0.40 96.76 Virginia | 1 0.40 97.17 Washington | 1 0.40 97.57 Washington D.C. | 1 0.40 97.98 West Virginia | 3 1.21 99.19 Wisconsin | 1 0.40 99.60 Wyoming | 1 0.40 100.00 ----------------+----------------------------------- Total | 247 100.00 Frequencies for county variable in planreportsanctioned2015 dataset : County | Freq. Percent Cum. ---------------+----------------------------------- (All Counties) | 56 22.67 22.67 Adams | 2 0.81 23.48 Allen | 2 0.81 24.29 Ashland | 2 0.81 25.10 Ashtabula | 3 1.21 26.32 Auglaize | 1 0.40 26.72 Berks | 5 2.02 28.74 Carroll | 4 1.62 30.36 Centre | 5 2.02 32.39 Columbia | 5 2.02 34.41 Columbiana | 4 1.62 36.03 Crawford | 1 0.40 36.44 Cumberland | 5 2.02 38.46 Cuyahoga | 4 1.62 40.08 Dauphin | 5 2.02 42.11 Defiance | 1 0.40 42.51 Erie | 2 0.81 43.32 Franklin | 5 2.02 45.34 Fulton | 4 1.62 46.96 Geauga | 4 1.62 48.58 Hancock | 2 0.81 49.39 Hardin | 1 0.40 49.80 Henry | 1 0.40 50.20 Holmes | 2 0.81 51.01 Huron | 2 0.81 51.82 Juniata | 5 2.02 53.85 Lake | 4 1.62 55.47 Lancaster | 2 0.81 56.28 Lebanon | 2 0.81 57.09 Lehigh | 5 2.02 59.11 Lorain | 3 1.21 60.32 Lucas | 3 1.21 61.54 Mahoning | 4 1.62 63.16 Marion | 2 0.81 63.97 Medina | 4 1.62 65.59 Mercer | 1 0.40 65.99 Mifflin | 5 2.02 68.02 Montour | 5 2.02 70.04 Morrow | 1 0.40 70.45 Northampton | 5 2.02 72.47 Northumberland | 5 2.02 74.49 Ottawa | 1 0.40 74.90 Paulding | 1 0.40 75.30 Perry | 5 2.02 77.33 Portage | 4 1.62 78.95 Putnam | 2 0.81 79.76 Richland | 1 0.40 80.16 San Francisco | 2 0.81 80.97 San Mateo | 1 0.40 81.38 Sandusky | 2 0.81 82.19 Schuylkill | 5 2.02 84.21 Seneca | 2 0.81 85.02 Snyder | 5 2.02 87.04 Stark | 4 1.62 88.66 Summit | 4 1.62 90.28 Trumbull | 4 1.62 91.90 Tuscarawas | 3 1.21 93.12 Union | 5 2.02 95.14 Van Wert | 1 0.40 95.55 Wayne | 4 1.62 97.17 Williams | 1 0.40 97.57 Wood | 3 1.21 98.79 Wyandot | 1 0.40 99.19 York | 2 0.81 100.00 ---------------+----------------------------------- Total | 247 100.00 Frequencies for organizationname variable in planreportsanctioned2015 dataset : Organization Name | Freq. Percent Cum. ------------------------------------+----------------------------------- Avalon Insurance Company | 4 1.62 1.62 Capital Advantage Insurance Company | 42 17.00 18.62 Chinese Community Health Plan | 3 1.21 19.84 Express Scripts Medicare | 52 21.05 40.89 Keystone Health Plan Central, Inc. | 48 19.43 60.32 SummaCare Medicare Advantage Plans | 98 39.68 100.00 ------------------------------------+----------------------------------- Total | 247 100.00 Frequencies for planname variable in planreportsanctioned2015 dataset : Plan Name | Freq. Percent Cum. --------------------------------------+----------------------------------- CCHP Senior Program (HMO) | 2 0.81 0.81 CCHP Senior Select Program (HMO SNP) | 1 0.40 1.21 SecureRx - Option 1 (PDP) | 2 0.81 2.02 SecureRx - Option 3 (PDP) | 2 0.81 2.83 SeniorBlue - Option 1 (HMO) | 16 6.48 9.31 SeniorBlue - Option 1 (PPO) | 21 8.50 17.81 SeniorBlue - Option 2 (HMO) | 16 6.48 24.29 SeniorBlue - Option 2 (PPO) | 21 8.50 32.79 SeniorBlue - Option 3 (HMO) | 16 6.48 39.27 SmartD Rx Saver (PDP) | 52 21.05 60.32 SummaCare Medicare Emerald (HMO-POS) | 15 6.07 66.40 SummaCare Medicare Ruby (HMO) | 28 11.34 77.73 SummaCare Medicare Sapphire (HMO-POS) | 41 16.60 94.33 SummaCare Medicare Topaz (HMO) | 14 5.67 100.00 --------------------------------------+----------------------------------- Total | 247 100.00 Frequencies for contractid variable in planreportsanctioned2015 dataset : Contract ID | Freq. Percent Cum. ------------+----------------------------------- H0571 | 3 1.21 1.21 H3660 | 98 39.68 40.89 H3923 | 42 17.00 57.89 H3962 | 48 19.43 77.33 S0064 | 52 21.05 98.38 S8067 | 4 1.62 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for planid variable in planreportsanctioned2015 dataset : Plan ID | Freq. Percent Cum. ------------+----------------------------------- 001 | 22 8.91 8.91 002 | 4 1.62 10.53 003 | 3 1.21 11.74 004 | 17 6.88 18.62 005 | 4 1.62 20.24 006 | 2 0.81 21.05 007 | 17 6.88 27.94 008 | 1 0.40 28.34 009 | 1 0.40 28.74 010 | 1 0.40 29.15 011 | 1 0.40 29.55 012 | 2 0.81 30.36 013 | 22 8.91 39.27 014 | 1 0.40 39.68 015 | 2 0.81 40.49 016 | 1 0.40 40.89 017 | 22 8.91 49.80 018 | 1 0.40 50.20 019 | 1 0.40 50.61 020 | 1 0.40 51.01 021 | 1 0.40 51.42 022 | 1 0.40 51.82 023 | 1 0.40 52.23 024 | 1 0.40 52.63 025 | 7 2.83 55.47 026 | 1 0.40 55.87 027 | 1 0.40 56.28 028 | 16 6.48 62.75 029 | 18 7.29 70.04 030 | 2 0.81 70.85 031 | 2 0.81 71.66 032 | 1 0.40 72.06 033 | 1 0.40 72.47 034 | 1 0.40 72.87 035 | 1 0.40 73.28 044 | 17 6.88 80.16 047 | 11 4.45 84.62 048 | 24 9.72 94.33 049 | 2 0.81 95.14 050 | 12 4.86 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for segmentid variable in planreportsanctioned2015 dataset : Segment ID | Freq. Percent Cum. ------------+----------------------------------- 0 | 247 100.00 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for organizationtype variable in planreportsanctioned2015 dataset : Organizatio | n Type | Freq. Percent Cum. ------------+----------------------------------- Local CCP | 191 77.33 77.33 PDP | 56 22.67 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for plantype variable in planreportsanctioned2015 dataset : Plan Type | Freq. Percent Cum. --------------------------------+----------------------------------- HMO | 93 37.65 37.65 HMOPOS | 56 22.67 60.32 Local PPO | 42 17.00 77.33 Medicare Prescription Drug Plan | 56 22.67 100.00 --------------------------------+----------------------------------- Total | 247 100.00 Frequencies for specialneedsplan variable in planreportsanctioned2015 dataset : Special | Needs Plan | Freq. Percent Cum. ------------+----------------------------------- No | 246 99.60 99.60 Yes | 1 0.40 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for specialneedsplantype variable in planreportsanctioned2015 dataset : Special Needs | Plan Type | Freq. Percent Cum. --------------+----------------------------------- | 246 99.60 99.60 Dual-Eligible | 1 0.40 100.00 --------------+----------------------------------- Total | 247 100.00 Frequencies for benefittype variable in planreportsanctioned2015 dataset : Benefit Type | Freq. Percent Cum. --------------------------------+----------------------------------- Actuarially Equivalent Standard | 52 21.05 21.05 Basic Alternative | 2 0.81 21.86 Defined Standard Benefit | 1 0.40 22.27 Enhanced Alternative | 192 77.73 100.00 --------------------------------+----------------------------------- Total | 247 100.00 Frequencies for partdbasicpremiumbelowregio variable in planreportsanctioned2015 dataset : Part D Basic Premium | Below Regional | Benchmark? | Freq. Percent Cum. -------------------------+----------------------------------- | 211 85.43 85.43 Below Regional Benchmark | 36 14.57 100.00 -------------------------+----------------------------------- Total | 247 100.00 Frequencies for nationalpdp variable in planreportsanctioned2015 dataset : National | PDP | Freq. Percent Cum. ------------+----------------------------------- | 195 78.95 78.95 Y | 52 21.05 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for partcpremium variable in planreportsanctioned2015 dataset : Part C | Premium2 | Freq. Percent Cum. ------------+----------------------------------- 0 | 48 19.43 19.43 2.3 | 11 4.45 23.89 27.9 | 17 6.88 30.77 29.8 | 21 8.50 39.27 35.9 | 24 9.72 48.99 38 | 2 0.81 49.80 69.5 | 16 6.48 56.28 96 | 15 6.07 62.35 117.8 | 21 8.50 70.85 123.3 | 16 6.48 77.33 . | 56 22.67 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for partdbasicpremium variable in planreportsanctioned2015 dataset : Part D | Basic | Premium3 | Freq. Percent Cum. ------------+----------------------------------- 0 | 32 12.96 12.96 13.4 | 1 0.40 13.36 22.5 | 1 0.40 13.77 24.8 | 2 0.81 14.57 24.9 | 1 0.40 14.98 25.8 | 1 0.40 15.38 25.9 | 1 0.40 15.79 26.2 | 1 0.40 16.19 26.4 | 1 0.40 16.60 26.7 | 2 0.81 17.41 27.5 | 1 0.40 17.81 28 | 1 0.40 18.22 28.6 | 5 2.02 20.24 28.8 | 1 0.40 20.65 29.1 | 2 0.81 21.46 29.3 | 1 0.40 21.86 29.7 | 1 0.40 22.27 29.9 | 1 0.40 22.67 30.6 | 2 0.81 23.48 30.7 | 1 0.40 23.89 31.8 | 2 0.81 24.70 32 | 17 6.88 31.58 32.1 | 2 0.81 32.39 32.2 | 1 0.40 32.79 33.4 | 1 0.40 33.20 33.7 | 5 2.02 35.22 34.3 | 1 0.40 35.63 34.4 | 1 0.40 36.03 34.7 | 1 0.40 36.44 35.7 | 11 4.45 40.89 36.1 | 2 0.81 41.70 36.5 | 7 2.83 44.53 41.5 | 1 0.40 44.94 41.6 | 1 0.40 45.34 42.6 | 21 8.50 53.85 44.2 | 16 6.48 60.32 48 | 16 6.48 66.80 50.1 | 41 16.60 83.40 58.1 | 21 8.50 91.90 59.7 | 15 6.07 97.98 68.8 | 2 0.81 98.79 70.3 | 1 0.40 99.19 122.1 | 2 0.81 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for partdsupplementalpremium variable in planreportsanctioned2015 dataset : Part D | Supplementa | l Premium4 | Freq. Percent Cum. ------------+----------------------------------- 0 | 209 84.62 84.62 12.4 | 2 0.81 85.43 16 | 21 8.50 93.93 26.3 | 15 6.07 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for partdtotalpremium variable in planreportsanctioned2015 dataset : Part D | Total | Premium5 | Freq. Percent Cum. ------------+----------------------------------- 0 | 32 12.96 12.96 13.4 | 1 0.40 13.36 22.5 | 1 0.40 13.77 24.8 | 2 0.81 14.57 24.9 | 1 0.40 14.98 25.8 | 1 0.40 15.38 25.9 | 1 0.40 15.79 26.2 | 1 0.40 16.19 26.4 | 1 0.40 16.60 26.7 | 2 0.81 17.41 27.5 | 1 0.40 17.81 28 | 1 0.40 18.22 28.6 | 5 2.02 20.24 28.8 | 1 0.40 20.65 29.1 | 2 0.81 21.46 29.3 | 1 0.40 21.86 29.7 | 1 0.40 22.27 29.9 | 1 0.40 22.67 30.6 | 2 0.81 23.48 30.7 | 1 0.40 23.89 31.8 | 2 0.81 24.70 32 | 17 6.88 31.58 32.1 | 2 0.81 32.39 32.2 | 1 0.40 32.79 33.4 | 1 0.40 33.20 33.7 | 5 2.02 35.22 34.3 | 1 0.40 35.63 34.4 | 1 0.40 36.03 34.7 | 1 0.40 36.44 35.7 | 11 4.45 40.89 36.1 | 2 0.81 41.70 36.5 | 7 2.83 44.53 41.5 | 1 0.40 44.94 41.6 | 1 0.40 45.34 42.6 | 21 8.50 53.85 44.2 | 16 6.48 60.32 48 | 16 6.48 66.80 50.1 | 41 16.60 83.40 68.8 | 2 0.81 84.21 70.3 | 1 0.40 84.62 74.1 | 21 8.50 93.12 86 | 15 6.07 99.19 134.5 | 2 0.81 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for partdpremiumobligationwithf variable in planreportsanctioned2015 dataset : Part D | Premium | Obligation | with Full | Premium | Assistance6 | Freq. Percent Cum. ------------+----------------------------------- 0 | 65 26.32 26.32 .1 | 1 0.40 26.72 .4 | 1 0.40 27.13 1.4 | 1 0.40 27.53 3.4 | 17 6.88 34.41 4 | 4 1.62 36.03 4.6 | 1 0.40 36.44 5.8 | 1 0.40 36.84 6.5 | 7 2.83 39.68 7.1 | 11 4.45 44.13 8.7 | 21 8.50 52.63 10.3 | 16 6.48 59.11 12.5 | 1 0.40 59.51 14.1 | 16 6.48 65.99 17.3 | 1 0.40 66.40 21.5 | 41 16.60 83.00 34.9 | 2 0.81 83.81 40.2 | 21 8.50 92.31 41.5 | 1 0.40 92.71 44.5 | 1 0.40 93.12 57.4 | 15 6.07 99.19 100.6 | 2 0.81 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for partdpremiumobligationwith75prem variable in planreportsanctioned2015 dataset : Part D | Premium | Obligation | with 75% | Premium | Assistance | Freq. Percent Cum. ------------+----------------------------------- 0 | 32 12.96 12.96 3.3 | 1 0.40 13.36 5.6 | 1 0.40 13.77 6.2 | 2 0.81 14.57 6.3 | 1 0.40 14.98 6.4 | 1 0.40 15.38 6.5 | 2 0.81 16.19 6.6 | 1 0.40 16.60 6.7 | 2 0.81 17.41 6.9 | 1 0.40 17.81 7 | 1 0.40 18.22 7.1 | 5 2.02 20.24 7.2 | 1 0.40 20.65 7.3 | 3 1.21 21.86 7.6 | 2 0.81 22.67 7.7 | 1 0.40 23.08 7.8 | 1 0.40 23.48 7.9 | 2 0.81 24.29 8 | 3 1.21 25.51 8.5 | 1 0.40 25.91 8.6 | 2 0.81 26.72 9 | 2 0.81 27.53 10.5 | 17 6.88 34.41 11.5 | 4 1.62 36.03 11.8 | 1 0.40 36.44 13 | 1 0.40 36.84 14 | 7 2.83 39.68 14.2 | 11 4.45 44.13 17.2 | 21 8.50 52.63 17.8 | 1 0.40 53.04 18.8 | 16 6.48 59.51 22.6 | 16 6.48 65.99 23.4 | 1 0.40 66.40 28.6 | 41 16.60 83.00 41.5 | 1 0.40 83.40 43.4 | 2 0.81 84.21 48.7 | 21 8.50 92.71 50.9 | 1 0.40 93.12 64.5 | 15 6.07 99.19 109.1 | 2 0.81 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for partdpremiumobligationwith50prem variable in planreportsanctioned2015 dataset : Part D | Premium | Obligation | with 50% | Premium | Assistance | Freq. Percent Cum. ------------+----------------------------------- 0 | 32 12.96 12.96 6.7 | 1 0.40 13.36 11.2 | 1 0.40 13.77 12.4 | 2 0.81 14.57 12.5 | 1 0.40 14.98 12.9 | 2 0.81 15.79 13.1 | 1 0.40 16.19 13.2 | 1 0.40 16.60 13.3 | 2 0.81 17.41 13.7 | 1 0.40 17.81 14 | 1 0.40 18.22 14.3 | 5 2.02 20.24 14.4 | 1 0.40 20.65 14.5 | 2 0.81 21.46 14.6 | 1 0.40 21.86 15.2 | 1 0.40 22.27 15.3 | 3 1.21 23.48 15.6 | 1 0.40 23.89 15.9 | 2 0.81 24.70 16 | 2 0.81 25.51 16.1 | 1 0.40 25.91 17.1 | 1 0.40 26.32 17.2 | 1 0.40 26.72 17.7 | 17 6.88 33.60 18 | 2 0.81 34.41 18.9 | 4 1.62 36.03 19 | 1 0.40 36.44 20.2 | 1 0.40 36.84 21.4 | 11 4.45 41.30 21.5 | 7 2.83 44.13 23.1 | 1 0.40 44.53 25.6 | 21 8.50 53.04 27.2 | 16 6.48 59.51 29.5 | 1 0.40 59.92 31 | 16 6.48 66.40 35.8 | 41 16.60 83.00 41.5 | 1 0.40 83.40 51.8 | 2 0.81 84.21 57.1 | 21 8.50 92.71 57.4 | 1 0.40 93.12 71.7 | 15 6.07 99.19 117.5 | 2 0.81 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for partdpremiumobligationwith25prem variable in planreportsanctioned2015 dataset : Part D | Premium | Obligation | with 25% | Premium | Assistance | Freq. Percent Cum. ------------+----------------------------------- 0 | 32 12.96 12.96 10 | 1 0.40 13.36 16.9 | 1 0.40 13.77 18.6 | 2 0.81 14.57 18.7 | 1 0.40 14.98 19.3 | 1 0.40 15.38 19.4 | 1 0.40 15.79 19.6 | 1 0.40 16.19 19.8 | 1 0.40 16.60 20 | 2 0.81 17.41 20.6 | 1 0.40 17.81 21 | 1 0.40 18.22 21.4 | 5 2.02 20.24 21.6 | 1 0.40 20.65 21.8 | 2 0.81 21.46 22 | 1 0.40 21.86 22.5 | 1 0.40 22.27 22.6 | 1 0.40 22.67 22.9 | 2 0.81 23.48 23 | 1 0.40 23.89 23.8 | 2 0.81 24.70 24.1 | 3 1.21 25.91 24.8 | 17 6.88 32.79 25.7 | 1 0.40 33.20 25.8 | 1 0.40 33.60 26.2 | 1 0.40 34.01 26.3 | 4 1.62 35.63 27.1 | 2 0.81 36.44 27.5 | 1 0.40 36.84 28.4 | 1 0.40 37.25 28.5 | 11 4.45 41.70 29 | 7 2.83 44.53 34.1 | 21 8.50 53.04 35.5 | 1 0.40 53.44 35.7 | 16 6.48 59.92 39.5 | 16 6.48 66.40 41.5 | 1 0.40 66.80 42.9 | 41 16.60 83.40 60.3 | 2 0.81 84.21 63.8 | 1 0.40 84.62 65.6 | 21 8.50 93.12 78.8 | 15 6.07 99.19 126 | 2 0.81 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for partddrugdeductible variable in planreportsanctioned2015 dataset : Part D Drug | Deductible | Freq. Percent Cum. ------------+----------------------------------- 0 | 178 72.06 72.06 100 | 14 5.67 77.73 320 | 55 22.27 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for tiersnotsubjecttodeductible variable in planreportsanctioned2015 dataset : Tiers Not | Subject to | Deductible7 | Freq. Percent Cum. ------------+----------------------------------- 1 | 16 6.48 6.48 . | 231 93.52 100.00 ------------+----------------------------------- Total | 247 100.00 Frequencies for extracoverageingap variable in planreportsanctioned2015 dataset : Extra | Coverage in | Gap | Freq. Percent Cum. ------------+----------------------------------- | 231 93.52 93.52 Y | 16 6.48 100.00 ------------+----------------------------------- Total | 247 100.00 by Jean Roth , jroth@nber.org , 14 Apr 2016