Health Plan Selection

**Overview**
This package was designed to offer as main data health plans selection related data, provided by the Office of Enterprise Data and Analytics, part of Centers for Medicare & Medicaid Services (CMS), that cover multiple characteristics for the health/dental insurance consumers from 38 states that that use the HealthCare.gov platform.

**Description**
As part of the Obama Administration’s efforts to make healthcare system more transparent, affordable, and accountable, the Office of Enterprise Data and Analytics, within the Centers for Medicare & Medicaid Services (CMS), has prepared public datasets to provide the total number of health plan selections by county for the 38 states that use the HealthCare.gov platform, including the Federally-facilitated Marketplace, State Partnership Marketplaces, and supported State-based Marketplaces. The datasets for county-level plan selection information cut by:

- The type of consumer (consumers auto enrolled or who actively selected a new plan)
- The household income as percent of the Federal Poverty Level (FPL)
- Individual and family health/dental plan selection
- Race/ethnicity
- The presence or absence of Advanced Premium Tax Credits (APTC)
- The presence or absence of cost-sharing reductions
- Metal level or plan policy (Platinum, Gold, Silver, Bronze, Catastrophic)

Data were obtained from the Multi-Dimensional Insurance Data Analytics System (MIDAS), which serves as a central repository for capturing, organizing, aggregating, and analyzing CMS’s Marketplace data.
As mentioned in the summary information, the data package contains context data related to health professionals (registered nurse, nurse practitioners), public providers enrollment and eligible uninsured people at country level, and, at state level, related to the California’s Medical Service Study Areas (MSSA).

**Benefits**
- Useful for researchers to assess the health plan selection consumers and influencing factors
- useful for policy makers and other health insurance interested parties to adjust the health plans according to the population needs and to context changes
- john snow labs datasets versions are improved through a process of curation and standardization making the datasets easier to use version, alone or in combination with other datasets from other data packages.

**License Information**
The use of John Snow Labs datasets is free for personal and research purposes. For commercial use please subscribe to the [Data Library](https://www.johnsnowlabs.com/marketplace/) on John Snow Labs website. The subscription will allow you to use all John Snow Labs datasets and data packages for commercial purposes.

**Included Datasets**
- [Health Plan by Household Income as Percent of the FPL and County 2015](https://www.johnsnowlabs.com/marketplace/health-plan-by-household-income-as-percent-of-the-fpl-and-county-2015)
- The dataset gives information on the total number of Health plan selection of 2601 counties with respect to the Household Income as Percent of the Federal Poverty Level (FPL).
- [Individual and Family Health Plan Information PY2017 to PY2018](https://www.johnsnowlabs.com/marketplace/individual-and-family-health-plan-information-py2017-to-py2018)
- This dataset includes 2017 Individual and Family health plans available in the United States where the federal government is operating the Marketplace. It contains plan information for states in the Federally-facilitated Marketplaces and State Partnership Marketplaces: "Medical plans in the individual market", "Medical plans in the small group (SHOP) market", "Dental plans in the individual market" and "Dental plans in the small group (SHOP) market".
- [Medical Service Study Areas Subcity Subcounty Geographical Units 2000](https://www.johnsnowlabs.com/marketplace/medical-service-study-areas-subcity-subcounty-geographical-units-2000)
- The dataset contains information on California’s Medical Service Study Areas (MSSA). MSSAs are sub-city and sub-county geographical units used to organize and display population, demographic and physician data for 2000. Medical Service Study Areas are a geographic analysis unit defined by the California Office of Statewide Health Planning and Development. MSSA are a good foundation for needs assessment analysis, healthcare planning, and healthcare policy development.
- [Medical Service Study Areas Subcity Subcounty Geographical Units 2010](https://www.johnsnowlabs.com/marketplace/medical-service-study-areas-subcity-subcounty-geographical-units-2010)
- The dataset contains information on California’s Medical Service Study Areas (MSSA). MSSAs are sub-city and sub-county geographical units used to organize and display population, demographic and physician data for 2010. Medical Service Study Areas are a geographic analysis unit defined by the California Office of Statewide Health Planning and Development. MSSA are a good foundation for needs assessment analysis, healthcare planning, and healthcare policy development.
- [Medical Service Study Areas by Census Tract Detail 2000](https://www.johnsnowlabs.com/marketplace/medical-service-study-areas-by-census-tract-detail-2000)
- The dataset contains information on California’s Medical Service Study Areas (MSSA), at the census tract level for 2000. MSSAs are sub-city and sub-county geographical units used to organize and display population, demographic and physician data. MSSA areas are a geographic analysis unit defined by the California Office of Statewide Health Planning and Development. MSSA are a good foundation for needs assessment analysis, healthcare planning, and healthcare policy development.
- [Medical Service Study Areas by Census Tract Detail 2013](https://www.johnsnowlabs.com/marketplace/medical-service-study-areas-by-census-tract-detail-2013)
- The dataset contains information on California’s Medical Service Study Areas (MSSA), at the census tract level for 2013. MSSAs are sub-city and sub-county geographical units used to organize and display population, demographic and physician data. Medical Service Study Areas are a geographic analysis unit defined by the California Office of Statewide Health Planning and Development.
- [Medicare Public Provider Enrollment Data Reassignment Sub File 2016 Q2](https://www.johnsnowlabs.com/marketplace/medicare-public-provider-enrollment-data-reassignment-sub-file-2016-q2)
- The Public Provider Enrollment data for Medicare fee-for-service includes providers who are actively approved to bill Medicare. This dataset contains an enrollment ID crosswalk between those individual providers reassigning their benefits and those providers receiving the reassignment of benefits.
- [National Sample Survey Of Nurse Practitioners 2012](https://www.johnsnowlabs.com/marketplace/national-sample-survey-of-nurse-practitioners-2012)
- Nurse practitioners play a critical role in extending access to health care by providing a range of primary and specialty care services. The Health Resources and Services Administration (HRSA) conducted the 2012 National Sample Survey of Nurse Practitioners to provide accurate national estimates of the nurse practitioner workforce and to profile their education, certification, and practice patterns.
- [National Sample Survey of Registered Nurses 2008](https://www.johnsnowlabs.com/marketplace/national-sample-survey-of-registered-nurses-2008)
- The National Sample Survey of Registered Nurses (NSSRN) assists the Health Resources and Services Administration (HRSA), Bureau of Health Professions (BHPr), in carrying out congressional mandates. This is the ninth study and was conducted with registered nurses (RN) who held an active RN license as of March 10, 2008.
- [Percentage of Estimated Eligible Uninsured People](https://www.johnsnowlabs.com/marketplace/percentage-of-estimated-eligible-uninsured-people)
- The dataset has information on percentage of uninsured population with respect to different population characteristics, including federal poverty level, education, and language. The data here are for outreach targeting purposes only. The number of people with incomes at varying federal poverty levels is based on data from the Census Bureau’s American Community Survey (ACS) data for 2011.
- [Qualifying Health Plan Selections by APTC and County 2015](https://www.johnsnowlabs.com/marketplace/qualifying-health-plan-selections-by-aptc-and-county-2015)
- The dataset gives information on the total number of Health Plan Selection of 2601 counties with respect to the presence or absence of advanced premium tax credit for the year 2015.
- [Qualifying Health Plan Selections by CSR and County 2015](https://www.johnsnowlabs.com/marketplace/qualifying-health-plan-selections-by-csr-and-county-2015)
- The dataset gives information on the total number of Health Plan Selection of 2601 counties with respect to the presence or absence of cost-sharing reductions for the year 2015.
- [Qualifying Health Plan Selections by Metal Level and County 2015](https://www.johnsnowlabs.com/marketplace/qualifying-health-plan-selections-by-metal-level-and-county-2015)
- The dataset gives information on the total number of Health Plan Selection of 2601 counties with respect to different metal level or plan policy for the year 2015. The dataset includes the total number of unique individuals who have a non-canceled plan selection with March 2015 coverage for the 37 states that use the HealthCare.gov platform, including the Federally-facilitated Marketplace, State Partnership Marketplaces and supported State-based Marketplaces.
- [Qualifying Health Plan Selections by Race or Ethnicity and County 2015](https://www.johnsnowlabs.com/marketplace/qualifying-health-plan-selections-by-race-or-ethnicity-and-county-2015)
- The dataset gives information on the total number of Health Plan Selection of 2601 counties with respect to the race or ethnicity and county for the year 2015. The dataset includes the total number of unique individuals who have a non-canceled plan selection with March 2015 coverage for the 37 states that use the HealthCare.gov platform, including the Federally-facilitated Marketplace, State Partnership Marketplaces and supported State-based Marketplaces.
- [Qualifying Health Plan Selections by Type of Consumer and County 2015](https://www.johnsnowlabs.com/marketplace/qualifying-health-plan-selections-by-type-of-consumer-and-county-2015)
- The dataset covers the 2601 counties' Health plan selection either the presence or absence of Advanced premium tax credit for 2015. It also includes the total number of unique individuals with non-canceled plan selection for March 2015 of the 37 states that use the HealthCare.gov platform, Federally-facilitated, State-Partnership and supported State-based Marketplaces. Plan selections are from November 15, 2014, to February 15, 2015, plus the special enrollment period from February 22, 2015.
- [US Delay or Non Receipt of Needed Healthcare](https://www.johnsnowlabs.com/marketplace/us-delay-or-non-receipt-of-needed-healthcare)
- This dataset shows the delay or non-receipt of needed medical care, non-receipt of needed prescription drugs, or non-receipt of needed dental care during the past 12 months due to cost, by selected characteristics for years 1997–2016. Data are based on household interviews of a sample of the civilian noninstitutionalized population.
- [US Healthcare Visits Statistics](https://www.johnsnowlabs.com/marketplace/us-healthcare-visits-statistics)
- The US Healthcare Visits Statistics dataset includes data about the frequency of healthcare visits to doctor offices, emergency departments, and home visits within the past 12 months in the United States by age, race, Hispanic origin, poverty level, health insurance status, geographic region and other characteristics between 1997 and 2016.
- [US Uninsured Statistics](https://www.johnsnowlabs.com/marketplace/us-uninsured-statistics)
- This dataset shows the statistics of United States uninsured persons with no health coverage under age 65 by selected characteristics. Data are based on household interviews of a sample of the civilian noninstitutionalized population.

**Data Engineering Overview**
**We deliver high-quality data**
- Each dataset goes through 3 levels of quality review
- 2 Manual reviews are done by domain experts
- Then, an automated set of 60+ validations enforces every datum matches metadata & defined constraints
- Data is normalized into one unified type system
- All dates, unites, codes, currencies look the same
- All null values are normalized to the same value
- All dataset and field names are SQL and Hive compliant
- Data and Metadata
- Data is available in both CSV and Apache Parquet format, optimized for high read performance on distributed Hadoop, Spark & MPP clusters
- Metadata is provided in the open Frictionless Data standard, and its every field is normalized & validated
- Data Updates
- Data updates support replace-on-update: outdated foreign keys are deprecated, not deleted

**Our data is curated and enriched by domain experts**

Each dataset is manually curated by our team of doctors, pharmacists, public health & medical billing experts:
- Field names, descriptions, and normalized values are chosen by people who actually understand their meaning
- Healthcare & life science experts add categories, search keywords, descriptions and more to each dataset
- Both manual and automated data enrichment supported for clinical codes, providers, drugs, and geo-locations
- The data is always kept up to date – even when the source requires manual effort to get updates
- Support for data subscribers is provided directly by the domain experts who curated the data sets
- Every data source’s license is manually verified to allow for royalty-free commercial use and redistribution.

**Need Help?**
If you have questions about our products, contact us at [[e-mail]](mailto:[e-mail]).