The Health Insurance Marketplace Public Use Files contain data on health and dental plans offered to individuals and small businesses through the US Health Insurance Marketplace.

Exploration Ideas

To help get you started, here are some data exploration ideas:

• How do plan rates and benefits vary across states?
• How do plan benefits relate to plan rates?
• How do plan rates vary by age?
• How do plans vary across insurance network providers?

See this forum thread for more ideas, and post there if you want to add your own ideas or answer some of the open questions!

Data Description

This data was originally prepared and released by the Centers for Medicare & Medicaid Services (CMS). Please read the CMS Disclaimer-User Agreement before using this data.

Here, we've processed the data to facilitate analytics. This processed version has three components:

1. Original versions of the data

The original versions of the 2014, 2015, 2016 data are available in the "raw" directory of the download and "../input/raw" on Kaggle Scripts. Search for "dictionaries" on this page to find the data dictionaries describing the individual raw files.

2. Combined CSV files that contain

In the top level directory of the download ("../input" on Kaggle Scripts), there are six CSV files that contain the combined at across all years:

• BenefitsCostSharing.csv
• BusinessRules.csv
• Network.csv
• PlanAttributes.csv
• Rate.csv
• ServiceArea.csv

Additionally, there are two CSV files that facilitate joining data across years:

• Crosswalk2015.csv - joining 2014 and 2015 data
• Crosswalk2016.csv - joining 2015 and 2016 data

3. SQLite database

The "database.sqlite" file contains tables corresponding to each of the processed CSV files.

The code to create the processed version of this data is available on GitHub.

Context

This public dataset contains data concerning the public and private insurance companies provided by IRDAI(Insurance Regulatory and Development Authority of India) from 2013-2022. This is a multi-index data and can be a great practice to hone manipulation of pandas multi-index dataframes. Mainly, the business of the companies (total premiums and number of policies), subscription information(number of people subscribed), Claims incurred and the Network hospitals enrolled by Third Party Administrators are attributes focused by the dataset.

Content

The Excel file contains the following data | Table No.| Contents| | --- | --- | |**A**|**III.A: HEALTH INSURANCE BUSINESS OF GENERAL AND HEALTH INSURERS**| |62| Health Insurance - Number of Policies, Number of Persons Covered and Gross Premium| |63| Personal Accident Insurance - Number of Policies, Number of Persons Covered and Gross Premium| |64| Overseas Travel Insurance - Number of Policies, Number of Persons Covered and Gross Premium| |65| Domestic Travel Insurance - Number of Policies, Number of Persons Covered and Gross Premium| |66| Health Insurance - Net Premium Earned, Incurred Claims and Incurred Claims Ratio| |67| Personal Accident Insurance - Net Premium Earned, Incurred Claims and Incurred Claims Ratio| |68| Overseas Travel Insurance - Net Earned Premium, Incurred Claims and Incurred Claims Ratio| |69| Domestic Travel Insurance - Net Earned Premium, Incurred Claims and Incurred Claims Ratio| |70| Details of Claims Development and Aging - Health Insurance Business| |71| State-wise Health Insurance Business| |72| State-wise Individual Health Insurance Business| |73| State-wise Personal Accident Insurance Business| |74| State-wise Overseas Insurance Business| |75| State-wise Domestic Insurance Business| |76| State-wise Claims Settlement under Health Insurance Business| |**B**|**III.B: HEALTH INSURANCE BUSINESS OF LIFE INSURERS**| |77| Health Insurance Business in respect of Products offered by Life Insurers - New Busienss| |78| Health Insurance Business in respect of Products offered by Life insurers - Renewal Business| |79| Health Insurance Business in respect of Riders attached to Life Insurance Products - New Business| |80| Health Insurance Business in respect of Riders attached to Life Insurance Products - Renewal Business| |**C**|**III.C: OTHERS**| |81| Network Hospital Enrolled by TPAs| |82| State-wise Details on Number of Network Providers |

The website shows data on the plan and implementation of the health services program by individual health activities (VZD) :

• hospital medical activity,
• general outpatient medical activity,
• specialist outpatient medical activity,
• dental practice,
• other health activities,
• activity of accommodation facilities for patient care,
• social care without accommodation for the elderly and disabled,
• production of pharmaceutical preparations,
• retail trade in specialized stores with pharmaceutical products,
• compulsory social security activity.

Within the framework of each activity, the data for each period are shown separately by contractors and together, the activity by regional units of ZZZS and the activity data at the level of Slovenia together.

Data on the plan and implementation of the health services program are shown in the accounting unit (e.g. points, quotients, weights, groups of comparable cases, non-medical care day, care, days...), which are used to calculate the work performed in the field of individual activities.

The publication of information about the plan and implementation of the program on the ZZZS website is primarily intended for the professional public. The displayed program plan for an individual contractor refers to the defined billing period. (example: The plan for the period 1-3 201X is calculated as 3/12 of the annual plan agreed in the contract).

The data on the implementation of the program represents the implementation of the program at an individual provider for insured persons who benefited from medical services from him during the accounting period. Data on the realization of the program do not refer to persons insured in accordance with the European legal order and bilateral agreements on social security. Data for individual contractors are classified by regional units based on the contractor's headquarters. The content of the data on the "number of cases" is defined in the Instruction on recording and accounting for medical services and issued materials.

The institute reserves the right to change the data, in the event of subsequently discovered irregularities after already published on the Internet.

United States Health Insurance: Premium Per Member Per Month data was reported at 364.000 USD in Sep 2024. This stayed constant from the previous number of 364.000 USD for Jun 2024. United States Health Insurance: Premium Per Member Per Month data is updated quarterly, averaging 262.000 USD from Mar 2012 (Median) to Sep 2024, with 51 observations. The data reached an all-time high of 364.000 USD in Sep 2024 and a record low of 178.000 USD in Sep 2013. United States Health Insurance: Premium Per Member Per Month data remains active status in CEIC and is reported by National Association of Insurance Commissioners. The data is categorized under Global Database’s United States – Table US.RG017: Health Insurance: Industry Financial Snapshots.

Analysis of ‘Medical Insurance Premium Prediction’ provided by Analyst-2 (analyst-2.ai), based on source dataset retrieved from https://www.kaggle.com/tejashvi14/medical-insurance-premium-prediction on 12 November 2021.

--- Dataset description provided by original source is as follows ---

Context

A Medical Insurance Company Has Released Data For Almost 1000 Customers. Create A Model That Predicts The Yearly Medical Cover Cost. The Data Is Voluntarily Given By Customers.

Content

The Dataset Contains Health Related Parameters Of The Customers. Use Them To Build A Model And Also Perform EDA On The Same. The Premium Price Is In INR(₹) Currency And Showcases Prices For A Whole Year.

Inspiration

Help Solve A Crucial Finance Problem That Would Potentially Impact Many People And Would Help Them Make Better Decisions. Don't Forget To Submit Your EDAs And Models In The Task Section. These Will Be Keenly Reviewed Hope You Enjoy Working On The Data. note- This is a dummy dataset used for teaching and training purposes. It is free to use, Image Credits-Unsplash

--- Original source retains full ownership of the source dataset ---

Coverage of Social Insurance Programs in Richest Quintile

Percent of Population Eligible

By data.world's Admin [source]

About this dataset

This dataset offers a unique insight into the coverage of social insurance programs for the wealthiest quintile of populations around the world. It reveals how many individuals in each country are receiving support from old age contributory pensions, disability benefits, and social security and health insurance benefits such as occupational injury benefits, paid sick leave, maternity leave, and more. This data provides an invaluable resource to understand the health and well-being of those most financially privileged in society – often having greater impact on decision making than other groups. With up-to-date figures from 2019-05-11 this dataset is invaluable in uncovering where there is work to be done for improved healthcare provision in each country across the world

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

• Understand the context: Before you begin analyzing this dataset, it is important to understand the information that it provides. Take some time to read the description of what is included in the dataset, including a clear understanding of the definitions and scope of coverage provided with each data point.

• Examine the data: Once you have a general understanding of this dataset's contents, take some time to explore its contents in more depth. What specific questions does this dataset help answer? What kind of insights does it provide? Are there any missing pieces?

• Clean & Prepare Data: After you've preliminarily examined its content, start preparing your data for further analysis and visualization. Clean up any formatting issues or irregularities present in your data set by correcting typos and eliminating unnecessary rows or columns before working with your chosen programming language (I prefer R for data manipulation tasks). Additionally, consider performing necessary transformations such as sorting or averaging values if appropriate for the findings you wish to draw from your analysis.

• Visualize Results: Once you've cleaned and prepared your data, use visualizations such as charts, graphs or tables to reveal patterns within it that support specific conclusions about how insurance coverage under social programs vary among different groups within society's quintiles - based on age groups etc.. This type of visualization allows those who aren't familiar with programming to process complex information quickly and accurately than when displayed numerically in tabular form only!

5 Final Analysis & Export Results: Finally export your visuals into presentation-ready formats (e.g., PDFs) which can be shared with colleagues! Additionally use these results as part of a narrative conclusion report providing an accurate assessment and meaningful interpretation about how social insurance programs vary between different members within society's quintiles (i..e., accordingest vs poorest), along with potential policy implications relevant for implementing effective strategies that improve access accordingly!

Research Ideas

• Analyzing the effectiveness of social insurance programs by comparing the coverage levels across different geographic areas or socio-economic groups;
• Estimating the economic impact of social insurance programs on local and national economies by tracking spending levels and revenues generated;
• Identifying potential problems with access to social insurance benefits, such as racial or gender disparities in benefit coverage

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

License: CC0 1.0 Universal (CC0 1.0) - Public Domain Dedication No Copyright - You can copy, modify, distribute and perform the work, even for commercial purposes, all without asking permission. See Other Information.

Columns

File: coverage-of-social-insurance-programs-in-richest-quintile-of-population-1.csv

Acknowledgements

If you use this dataset in your research, please credit the original authors. If you use this dataset in your research, please credit data.world's Admin.

In 2008, a group of uninsured low-income adults in Oregon was selected by lottery to be given the chance to apply for Medicaid. This lottery provides an opportunity to gauge the effects of expanding access to public health insurance on the health care use, financial strain, and health of low-income adults using a randomized controlled design. The Oregon Health Insurance Experiment follows and compares those selected in the lottery (treatment group) with those not selected (control group). The data collected and provided here include data from in-person interviews, three mail surveys, emergency department records, and administrative records on Medicaid enrollment, the initial lottery sign-up list, welfare benefits, and mortality. This data collection has seven data files: Dataset 1 contains administrative data on the lottery from the state of Oregon. These data include demographic characteristics that were recorded when individuals signed up for the lottery, date of lottery draw, and information on who was selected for the lottery, applied for the lotteried Medicaid plan if selected, and whose application for the lotteried plan was approved. Also included are Oregon mortality data for 2008 and 2009. Dataset 2 contains information from the state of Oregon on the individuals' participation in Medicaid, Supplemental Nutrition Assistance Program (SNAP), and Temporary Assistance to Needy Families (TANF). Datasets 3-5 contain the data from the initial, six month, and 12 month mail surveys, respectively. Topics covered by the surveys include demographic characteristics; health insurance, access to health care and health care utilization; health care needs, experiences, and costs; overall health status and changes in health; and depression and medical conditions and use of medications to treat them. Dataset 6 contains an analysis subset of the variables from the in-person interviews. Topics covered by the survey questionnaire include overall health, health insurance coverage, health care access, health care utilization, conditions and treatments, health behaviors, medical and dental costs, and demographic characteristics. The interviewers also obtained blood pressure and anthropometric measurements and collected dried blood spots to measure levels of cholesterol, glycated hemoglobin and C-reactive protein. Dataset 7 contains an analysis subset of the variables the study obtained for all emergency department (ED) visits to twelve hospitals in the Portland area during 2007-2009. These variables capture total hospital costs, ED costs, and the number of ED visits categorized by time of the visit (daytime weekday or nighttime and weekends), necessity of the visit (emergent, ED care needed, non-preventable; emergent, ED care needed, preventable; emergent, primary care treatable), ambulatory case sensitive status, whether or not the patient was hospitalized, and the reason for the visit (e.g., injury, abdominal pain, chest pain, headache, and mental disorders). The collection also includes a ZIP archive (Dataset 8) with Stata programs that replicate analyses reported in three articles by the principal investigators and others: Finkelstein, Amy et al "The Oregon Health Insurance Experiment: Evidence from the First Year". The Quarterly Journal of Economics. August 2012. Vol 127(3). Baicker, Katherine et al "The Oregon Experiment - Effects of Medicaid on Clinical Outcomes". New England Journal of Medicine. 2 May 2013. Vol 368(18). Taubman, Sarah et al "Medicaid Increases Emergency Department Use: Evidence from Oregon's Health Insurance Experiment". Science. 2 Jan 2014.

After May 3, 2024, this dataset and webpage will no longer be updated because hospitals are no longer required to report data on COVID-19 hospital admissions, and hospital capacity and occupancy data, to HHS through CDC’s National Healthcare Safety Network. Data voluntarily reported to NHSN after May 1, 2024, will be available starting May 10, 2024, at COVID Data Tracker Hospitalizations.

This report shows data completeness information on data submitted by hospitals for the previous week, from Friday to Thursday. The U.S. Department of Health and Human Services requires all hospitals licensed to provide 24-hour care to report certain data necessary to the all-of-America COVID-19 response. The report includes the following information for each hospital:

• The percentage of mandatory fields reported.
• The number of days in the preceding week where 100% of the fields were completed.
• Whether a hospital is required to report on Wednesdays only.
• A cell for each required field with the number of days that specific field was reported for the week.