Interactive portion of my blog post about healthcare.gov individual and small business insurance exchange premiums by county at http://socialhealthinsights.com/2013/10/healthcare-gov-open-data/
| To start this process, here is a list of the 17 other health insurance exchanges: | |
| * California – Covered California (http://www.coveredca.com) | |
| - PDF of the four plan levels (Platinum, Gold, Silver, Bronze): https://www.coveredca.com/PDFs/English/CoveredCA-HealthPlanBenefitsComparisonChart.pdf | |
| - PDF of pricing by region: https://www.coveredca.com/PDFs/English/booklets/CC-health-plans-booklet-rev2.pdf | |
| - Finding: there are 19 different pricing regions which are split up by counties. Each pricing region lists number of subsidy-eligible individuals in that area and also which insurance providers are providing plans in the region | |
| - Finding: there are 12 different insurance plan providers | |
| * Colorado – Connect for Health Colorado (http://www.connectforhealthco.com) | |
| - I couldn't seem to browse plans without putting in location/age/etc information | |
| * Connecticut – Access Health CT (http://www.accesshealthct.com/) | |
| - I couldn't seem to browse plans without putting in location/age/etc information | |
| * District of Columbia – DC Health Link (http://www.dchealthlink.com/) | |
| - I couldn't seem to browse plans without putting in location/age/etc information | |
| * Hawaii – Hawaii Health Connector (http://www.hawaiihealthconnector.com) | |
| - I couldn't seem to browse plans without putting in location/age/etc information | |
| - I was able to use web-chat and they said what I was looking for was not available | |
| - "Kim B > [In the] coming weeks, you'll be able to shop and compare so you can select the plan that meets your financial and health needs." | |
| - I was able to learn which five payers will be participating: Best Life Dental, Guardian Dental, Hawaii Dental Service, HMSA, and Kaiser Permanente | |
| * Idaho – Your Health Idaho (http://www.yourhealthidaho.org/) | |
| - Data is at https://data.healthcare.gov/dataset/Idaho-QHP-Individual-Market-Medical-Landscape/e8ws-ngn9 | |
| - "Country" column should read "County" | |
| - To be consistent with other data files, "Premium Adult Individual Age 50 *" column should be "Premium Adult Individual Age 50*" | |
| * Kentucky – Kynect KY (http://kyenroll.ky.gov/) | |
| - I couldn't seem to browse plans without putting in location/age/etc information | |
| * Maryland – Marlyand Health Connection (http://www.marylandhealthconnection.gov/) | |
| - I couldn't seem to browse plans without putting in location/age/etc information | |
| * Massachusetts – Health Connector | |
| - | |
| * Minnesota – MNsure (http://www.mnsure.org) | |
| - Excel spreadsheets includes county-level data on metal levels, plan name, and insurer but not prices: | |
| - for individuals: http://www.mnsure.org/images/Individual-ServiceAreas-ProviderLook-up.xls | |
| - for SHOP: http://www.mnsure.org/www.mnsure.org/images/SHOP-ServiceArea-ProviderLook-up.xls | |
| * Nevada – Nevada Health Link (http://www.nevadahealthlink.com/) | |
| - I couldn't seem to browse plans without putting in location/age/etc information | |
| * New Mexico – Be Well NM (http://bewellnm.com/) | |
| - Data is available at https://data.healthcare.gov/dataset/New-Mexico-QHP-Individual-Market-Medical-Landscape/mq97-jxwi | |
| - To be consistent with other data files, "Premium Adult Individual Age 50 *" column should be "Premium Adult Individual Age 50*" | |
| - To be consistent with other data files, "Premium Couple *" column should be "Premium Couple*" | |
| * New York – NY State of Health (http://www.healthbenefitexchange.ny.gov/) | |
| - I couldn't seem to browse plans without putting in location/age/etc information | |
| - Live chat was helpful and directed me to http://www.healthbenefitexchange.ny.gov/resource/covered-benefits-and-out-pocket-costs-standard-health-plans which has a calculator which has a macro that we might be able to look at the code for and get the needed data | |
| - PDF of each county and who the insurers are for individual and SHOP plans: http://www.healthbenefitexchange.ny.gov/sites/default/files/Certified%20Plans%20by%20Counties%20and%20Boroughs%2C%209-4-13.pdf | |
| * Oregon – Cover Oregon (http://www.coveroregon.com/) | |
| * Rhode Island – Health Source RI (http://www.healthsourceri.com/) | |
| - I couldn't seem to browse plans without putting in location/age/etc information | |
| - Web chat did confirm that rates are the same across the state (nothing specific to each county) | |
| * Vermont – Health Connect (http://healthconnect.vermont.gov) | |
| - Website (http://info.healthconnect.vermont.gov/healthplans) seems to show 2 insurance providers for each metal level and PDF (http://info.healthconnect.vermont.gov/sites/hcexchange/files/Plan%20Designs%20with%20Final%20Rates_updated_10%201%2013%20%282%29.pdf) has specific plans and premiums. | |
| - Calculator at http://www.healthsourceri.com/news-events/calculate-your-savings/ might have data we want | |
| * Washington – WA Health Plan Finder (http://www.wahealthplanfinder.org/) | |
| - I couldn't seem to browse plans without putting in location/age/etc information | |
| - PDF shows there are 5 rating areas and which payers are servicing each area along with the premiums for each plan for each area | |
| - http://www.wahbexchange.org/files/6413/8022/9697/Health_Insurance_Companies_and_Plan_Rates_2014_9.26.13.pdf |
This comment has been minimized.
This comment has been minimized.
|
Thank you to Brian of Intercarve.net for pointing me toward the ID & NM data sets on http://data.healthcare.gov. I do wish all the states were in one data set though! |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
This comment has been minimized.
(All data for the remaining 34 states can be found at http://data.healthcare.gov/ which is linked to from http://socialhealthinsights.com/2013/10/healthcare-gov-open-data/)