Frequencies for snpsanctioned2017 dataset : by Jean Roth , jroth@nber.org , 6 Dec 2016 Frequencies for state variable in snpsanctioned2017 dataset : State | Freq. Percent Cum. ----------------+----------------------------------- Alabama | 28 9.49 9.49 Arizona | 2 0.68 10.17 Arkansas | 6 2.03 12.20 Delaware | 9 3.05 15.25 Florida | 5 1.69 16.95 Georgia | 47 15.93 32.88 Illinois | 4 1.36 34.24 Maryland | 26 8.81 43.05 Mississippi | 17 5.76 48.81 North Carolina | 16 5.42 54.24 Pennsylvania | 24 8.14 62.37 Tennessee | 63 21.36 83.73 Texas | 45 15.25 98.98 Washington D.C. | 3 1.02 100.00 ----------------+----------------------------------- Total | 295 100.00 Frequencies for county variable in snpsanctioned2017 dataset : County | Freq. Percent Cum. ---------------------+----------------------------------- Alexander | 1 0.34 0.34 Angelina | 1 0.34 0.68 Anne Arundel | 3 1.02 1.69 Attala | 1 0.34 2.03 Autauga | 1 0.34 2.37 Baldwin | 2 0.68 3.05 Baltimore | 3 1.02 4.07 Baltimore City | 3 1.02 5.08 Banks | 1 0.34 5.42 Barrow | 1 0.34 5.76 Bartow | 1 0.34 6.10 Bay | 1 0.34 6.44 Bedford | 1 0.34 6.78 Benton | 1 0.34 7.12 Berks | 1 0.34 7.46 Bexar | 1 0.34 7.80 Bibb | 1 0.34 8.14 Bledsoe | 1 0.34 8.47 Blount | 1 0.34 8.81 Bradley | 1 0.34 9.15 Brazoria | 1 0.34 9.49 Bucks | 3 1.02 10.51 Butts | 1 0.34 10.85 Cabarrus | 1 0.34 11.19 Cameron | 1 0.34 11.53 Cannon | 1 0.34 11.86 Caroline | 1 0.34 12.20 Carroll | 1 0.34 12.54 Catawba | 1 0.34 12.88 Chambers | 1 0.34 13.22 Chattooga | 1 0.34 13.56 Cheatham | 1 0.34 13.90 Cherokee | 3 1.02 14.92 Chester | 4 1.36 16.27 Chilton | 1 0.34 16.61 Clarke | 1 0.34 16.95 Clay | 1 0.34 17.29 Clayton | 1 0.34 17.63 Cleveland | 1 0.34 17.97 Cobb | 1 0.34 18.31 Coffee | 1 0.34 18.64 Colbert | 1 0.34 18.98 Collin | 1 0.34 19.32 Cook | 1 0.34 19.66 Covington | 1 0.34 20.00 Coweta | 1 0.34 20.34 Craighead | 1 0.34 20.68 Crittenden | 1 0.34 21.02 Crockett | 1 0.34 21.36 Cullman | 1 0.34 21.69 Cumberland | 3 1.02 22.71 Dallas | 2 0.68 23.39 Davidson | 2 0.68 24.07 Davie | 1 0.34 24.41 Dawson | 1 0.34 24.75 DeKalb | 3 1.02 25.76 Decatur | 1 0.34 26.10 Delaware | 3 1.02 27.12 Denton | 1 0.34 27.46 Dickson | 1 0.34 27.80 District of Columbia | 3 1.02 28.81 Dorchester | 1 0.34 29.15 Douglas | 1 0.34 29.49 DuPage | 1 0.34 29.83 El Paso | 2 0.68 30.51 Elbert | 1 0.34 30.85 Elmore | 1 0.34 31.19 Escambia | 1 0.34 31.53 Etowah | 1 0.34 31.86 Fayette | 2 0.68 32.54 Fentress | 1 0.34 32.88 Floyd | 1 0.34 33.22 Forrest | 1 0.34 33.56 Forsyth | 2 0.68 34.24 Fort Bend | 1 0.34 34.58 Franklin | 1 0.34 34.92 Fulton | 1 0.34 35.25 Galveston | 1 0.34 35.59 Gaston | 1 0.34 35.93 George | 1 0.34 36.27 Gibson | 1 0.34 36.61 Giles | 1 0.34 36.95 Gordon | 1 0.34 37.29 Grayson | 1 0.34 37.63 Greene | 2 0.68 38.31 Gregg | 1 0.34 38.64 Grundy | 1 0.34 38.98 Guilford | 1 0.34 39.32 Gwinnett | 1 0.34 39.66 Habersham | 1 0.34 40.00 Hall | 1 0.34 40.34 Hamilton | 1 0.34 40.68 Hancock | 1 0.34 41.02 Hardeman | 1 0.34 41.36 Hardin | 2 0.68 42.03 Harford | 3 1.02 43.05 Harris | 1 0.34 43.39 Harrison | 1 0.34 43.73 Hart | 1 0.34 44.07 Haywood | 1 0.34 44.41 Henderson | 2 0.68 45.08 Hickman | 1 0.34 45.42 Hidalgo | 1 0.34 45.76 Hinds | 1 0.34 46.10 Hood | 1 0.34 46.44 Houston | 1 0.34 46.78 Howard | 3 1.02 47.80 Humphreys | 1 0.34 48.14 Iredell | 1 0.34 48.47 Jackson | 4 1.36 49.83 Jasper | 2 0.68 50.51 Jefferson | 2 0.68 51.19 Johnson | 1 0.34 51.53 Jones | 1 0.34 51.86 Kane | 1 0.34 52.20 Kent | 4 1.36 53.56 Lamar | 2 0.68 54.24 Lancaster | 2 0.68 54.92 Lauderdale | 2 0.68 55.59 Lawrence | 3 1.02 56.61 Leake | 1 0.34 56.95 Lehigh | 1 0.34 57.29 Lewis | 1 0.34 57.63 Liberty | 1 0.34 57.97 Limestone | 1 0.34 58.31 Lincoln | 2 0.68 58.98 Lowndes | 1 0.34 59.32 Lubbock | 1 0.34 59.66 Lumpkin | 1 0.34 60.00 Macon | 1 0.34 60.34 Madison | 4 1.36 61.69 Maricopa | 1 0.34 62.03 Marion | 2 0.68 62.71 Marshall | 2 0.68 63.39 Maury | 1 0.34 63.73 McNairy | 1 0.34 64.07 Mississippi | 1 0.34 64.41 Mobile | 1 0.34 64.75 Montgomery | 9 3.05 67.80 Moore | 1 0.34 68.14 Morgan | 2 0.68 68.81 Nacogdoches | 1 0.34 69.15 New Castle | 3 1.02 70.17 Newton | 2 0.68 70.85 Northampton | 1 0.34 71.19 Oconee | 1 0.34 71.53 Oglethorpe | 1 0.34 71.86 Okaloosa | 1 0.34 72.20 Orange | 1 0.34 72.54 Overton | 1 0.34 72.88 Parker | 1 0.34 73.22 Paulding | 1 0.34 73.56 Pearl River | 1 0.34 73.90 Perry | 2 0.68 74.58 Philadelphia | 3 1.02 75.59 Pickens | 1 0.34 75.93 Pickett | 1 0.34 76.27 Pike | 1 0.34 76.61 Pinal | 1 0.34 76.95 Poinsett | 1 0.34 77.29 Polk | 4 1.36 78.64 Prince George's | 3 1.02 79.66 Putnam | 2 0.68 80.34 Queen Anne's | 1 0.34 80.68 Rabun | 1 0.34 81.02 Rains | 1 0.34 81.36 Rankin | 1 0.34 81.69 Rhea | 1 0.34 82.03 Robertson | 1 0.34 82.37 Rockdale | 1 0.34 82.71 Rowan | 1 0.34 83.05 Rusk | 1 0.34 83.39 Rutherford | 1 0.34 83.73 San Jacinto | 1 0.34 84.07 Santa Rosa | 1 0.34 84.41 Sequatchie | 1 0.34 84.75 Shelby | 2 0.68 85.42 Smith | 2 0.68 86.10 Spalding | 1 0.34 86.44 St. Clair | 1 0.34 86.78 Stephens | 1 0.34 87.12 Stewart | 1 0.34 87.46 Stokes | 1 0.34 87.80 Stone | 1 0.34 88.14 Sumner | 1 0.34 88.47 Sussex | 3 1.02 89.49 Talbot | 1 0.34 89.83 Talladega | 1 0.34 90.17 Tarrant | 1 0.34 90.51 Tipton | 1 0.34 90.85 Trousdale | 1 0.34 91.19 Tuscaloosa | 1 0.34 91.53 Tyler | 1 0.34 91.86 Union | 1 0.34 92.20 Upshur | 1 0.34 92.54 Van Buren | 1 0.34 92.88 Van Zandt | 1 0.34 93.22 Walker | 2 0.68 93.90 Waller | 1 0.34 94.24 Walton | 2 0.68 94.92 Warren | 1 0.34 95.25 Wayne | 1 0.34 95.59 Webb | 1 0.34 95.93 White | 2 0.68 96.61 Wilkes | 1 0.34 96.95 Will | 1 0.34 97.29 Willacy | 1 0.34 97.63 Williamson | 1 0.34 97.97 Wilson | 1 0.34 98.31 Wise | 1 0.34 98.64 Wood | 1 0.34 98.98 Yadkin | 1 0.34 99.32 York | 2 0.68 100.00 ---------------------+----------------------------------- Total | 295 100.00 Frequencies for organizationname variable in snpsanctioned2017 dataset : Organization Name | Freq. Percent Cum. ------------------------------+----------------------------------- Cigna | 2 0.68 0.68 Cigna-HealthSpring | 272 92.20 92.88 Cigna-Healthspring | 16 5.42 98.31 HealthSpring of Florida, Inc. | 5 1.69 100.00 ------------------------------+----------------------------------- Total | 295 100.00 Frequencies for planname variable in snpsanctioned2017 dataset : Plan Name | Freq. Percent Cum. ----------------------------------------+----------------------------------- Cigna-HealthSpring Achieve (HMO SNP) | 19 6.44 6.44 Cigna-HealthSpring Achieve Plus (HMO .. | 2 0.68 7.12 Cigna-HealthSpring TotalCare (HMO SNP) | 227 76.95 84.07 Cigna-HealthSpring TotalCare AR (HMO .. | 6 2.03 86.10 Cigna-HealthSpring TotalCare ETN (HMO.. | 8 2.71 88.81 Cigna-HealthSpring TotalCare SMS (HMO.. | 17 5.76 94.58 Cigna-HealthSpring Traditions (HMO SNP) | 16 5.42 100.00 ----------------------------------------+----------------------------------- Total | 295 100.00 Frequencies for typeofmedicarehealthplan variable in snpsanctioned2017 dataset : Type of | Medicare | Health Plan | Freq. Percent Cum. ------------+----------------------------------- Local HMO | 295 100.00 100.00 ------------+----------------------------------- Total | 295 100.00 Frequencies for specialneedsplantype variable in snpsanctioned2017 dataset : Special Needs Plan Type | Freq. Percent Cum. -------------------------------+----------------------------------- Chronic or Disabling Condition | 21 7.12 7.12 Dual-Eligible | 258 87.46 94.58 Institutional | 16 5.42 100.00 -------------------------------+----------------------------------- Total | 295 100.00 Frequencies for monthlyconsolidatedpremium variable in snpsanctioned2017 dataset : Monthly | Consolidate | d Premium* | (Includes | Part C + D) | Freq. Percent Cum. ------------+----------------------------------- 0 | 2 0.68 0.68 16 | 10 3.39 4.07 18.8 | 55 18.64 22.71 20.3 | 28 9.49 32.20 21.6 | 6 2.03 34.24 21.7 | 8 2.71 36.95 22 | 24 8.14 45.08 24.1 | 16 5.42 50.51 24.8 | 17 5.76 56.27 26 | 5 1.69 57.97 26.4 | 47 15.93 73.90 26.8 | 4 1.36 75.25 27.3 | 11 3.73 78.98 28.8 | 11 3.73 82.71 31.4 | 16 5.42 88.14 33.2 | 11 3.73 91.86 39.4 | 5 1.69 93.56 58.5 | 8 2.71 96.27 70.5 | 6 2.03 98.31 76.5 | 5 1.69 100.00 ------------+----------------------------------- Total | 295 100.00 Frequencies for annualdrugdeductible variable in snpsanctioned2017 dataset : Annual Drug | Deductible | Freq. Percent Cum. ------------+----------------------------------- 0 | 2 0.68 0.68 280 | 19 6.44 7.12 400 | 274 92.88 100.00 ------------+----------------------------------- Total | 295 100.00 Frequencies for drugbenefittype variable in snpsanctioned2017 dataset : Drug | Benefit | Type | Freq. Percent Cum. ------------+----------------------------------- Basic | 274 92.88 92.88 Enhanced | 21 7.12 100.00 ------------+----------------------------------- Total | 295 100.00 Frequencies for additionalcoverageofferedin variable in snpsanctioned2017 dataset : Additional | Coverage | Offered in | the Gap | Freq. Percent Cum. ------------+----------------------------------- No | 295 100.00 100.00 ------------+----------------------------------- Total | 295 100.00 Frequencies for drugbenefittypedetail variable in snpsanctioned2017 dataset : Drug | Benefit | Type Detail | Freq. Percent Cum. ------------+----------------------------------- DS | 274 92.88 92.88 EA | 21 7.12 100.00 ------------+----------------------------------- Total | 295 100.00 Frequencies for contractid variable in snpsanctioned2017 dataset : Contract ID | Freq. Percent Cum. ------------+----------------------------------- H0150 | 28 9.49 9.49 H0354 | 2 0.68 10.17 H0439 | 47 15.93 26.10 H1415 | 4 1.36 27.46 H2108 | 38 12.88 40.34 H2165 | 11 3.73 44.07 H3949 | 24 8.14 52.20 H4407 | 17 5.76 57.97 H4454 | 69 23.39 81.36 H4513 | 24 8.14 89.49 H4528 | 10 3.39 92.88 H5410 | 5 1.69 94.58 H9725 | 16 5.42 100.00 ------------+----------------------------------- Total | 295 100.00 Frequencies for planid variable in snpsanctioned2017 dataset : Plan ID | Freq. Percent Cum. ------------+----------------------------------- 001 | 16 5.42 5.42 002 | 57 19.32 24.75 003 | 16 5.42 30.17 004 | 17 5.76 35.93 005 | 4 1.36 37.29 007 | 28 9.49 46.78 009 | 11 3.73 50.51 010 | 24 8.14 58.64 013 | 5 1.69 60.34 016 | 5 1.69 62.03 019 | 11 3.73 65.76 020 | 66 22.37 88.14 024 | 8 2.71 90.85 027 | 2 0.68 91.53 029 | 6 2.03 93.56 030 | 5 1.69 95.25 034 | 6 2.03 97.29 035 | 8 2.71 100.00 ------------+----------------------------------- Total | 295 100.00 Frequencies for segmentid variable in snpsanctioned2017 dataset : Segment ID | Freq. Percent Cum. ------------+----------------------------------- 0 | 295 100.00 100.00 ------------+----------------------------------- Total | 295 100.00 Frequencies for diabetesmellitus variable in snpsanctioned2017 dataset : Diabetes | Mellitus | Freq. Percent Cum. ------------+----------------------------------- | 274 92.88 92.88 * | 21 7.12 100.00 ------------+----------------------------------- Total | 295 100.00 Frequencies for overallstarrating variable in snpsanctioned2017 dataset : Overall | Star Rating | Freq. Percent Cum. ------------+----------------------------------- 3 | 84 28.47 28.47 3.5 | 204 69.15 97.63 4 | 7 2.37 100.00 ------------+----------------------------------- Total | 295 100.00 Frequencies for overallstarratingstr variable in snpsanctioned2017 dataset : Overall | Star Rating | Freq. Percent Cum. ------------+----------------------------------- 3 Stars | 84 28.47 28.47 3.5 Stars | 204 69.15 97.63 4 Stars | 7 2.37 100.00 ------------+----------------------------------- Total | 295 100.00 by Jean Roth , jroth@nber.org , 6 Dec 2016