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/

non_federal_exchanges.txt

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

(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/)

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!