This dataset includes the number of people enrolled in DSS services by town and by ethnicity from CY 2015-2024. To view the full dataset and filter the data, click the "View Data" button at the top right of the screen. More data on people served by DSS can be found here. About this data For privacy considerations, a count of zero is used for counts less than five. A recipient is counted in all towns where that recipient resided in that year. Due to eligibility policies and operational processes, enrollment can vary slightly after publication. Please be aware of the point-in-time nature of the published data when comparing to other data published or shared by the Department of Social Services, as this data may vary slightly. Notes by year 2021 In March 2020, Connecticut opted to add a new Medicaid coverage group: the COVID-19 Testing Coverage for the Uninsured. Enrollment data on this limited-benefit Medicaid coverage group is being incorporated into Medicaid data effective January 1, 2021. Enrollment data for this coverage group prior to January 1, 2021, was listed under State Funded Medical. An historical accounting of enrollment of the specific coverage group starting in calendar year 2020 will also be published separately. 2018 On April 22, 2019 the methodology for determining HUSKY A Newborn recipients changed, which caused an increase of recipients for that benefit starting in October 2016. We now count recipients recorded in the ImpaCT system as well as in the HIX system for that assistance type, instead using HIX exclusively. Also, the methodology for determining the address of the recipients changed: 1. The address of a recipient in the ImpaCT system is now correctly determined specific to that month instead of using the address of the most recent month. This resulted in some shuffling of the recipients among townships starting in October 2016. If, in a given month, a recipient has benefit records in both the HIX system and in the ImpaCT system, the address of the recipient is now calculated as follows to resolve conflicts: Use the residential address in ImpaCT if it exists, else use the mailing address in ImpaCT if it exists, else use the address in HIX. This resulted in a reduction in counts for most townships starting in March 2017 because a single address is now used instead of two when the systems do not agree. On February 14, 2019 the enrollment counts for 2012-2015 across all programs were updated to account for an error in the data integration process. As a result, the count of the number of people served increased by 13% for 2012, 10% for 2013, 8% for 2014 and 4% for 2015. Counts for 2016, 2017 and 2018 remain unchanged. On January 16, 2019 these counts were revised to count a recipient in all locations that recipient resided in that year. On January 1, 2019 the counts were revised to count a recipient in only one town per year even when the recipient moved within the year. The most recent address is used.

This dataset includes total enrollment in separate CHIP (S-CHIP) programs by month and state from April 2023 forward. Sources: T-MSIS Analytic Files (TAF) and state-submitted enrollment totals. The data notes indicate when a state’s monthly total was a state-submitted value, rather than from T-MSIS. Methods: Enrollment includes individuals enrolled in S-CHIP at any point during the coverage month, excluding those enrolled in dental-only coverage. The S-CHIP enrollment in this report also excludes enrollees covered by Medicaid expansion CHIP, a program in which a state receives federal funding to expand Medicaid eligibility to optional targeted low-income children that meets the requirements of section 2103 of the Social Security Act. If an individual is enrolled in both Medicaid or Medicaid-expansion CHIP and S-CHIP in a given month, TAF picks the program in which they were last enrolled. Unless S-CHIP enrollment counts are replaced with a state-submitted value, each state's monthly S-CHIP enrollment is equal to the number of unique people in TAF with a CHIP_CODE = 3 (S-CHIP) and ELGBLTY_GRP_CD not equal to ‘66’ (Children Eligible for Dental Only Supplemental Coverage). More information about TAF is available at https://www.medicaid.gov/medicaid/data-systems/macbis/medicaid-chip-research-files/transformed-medicaid-statistical-information-system-t-msis-analytic-files-taf/index.html. Note: A historic dataset with S-CHIP enrollment by month and state from April 2023 to June 2024 is also available at: https://data.medicaid.gov/dataset/d30cfc7c-4b32-4df1-b2bf-e0a850befd77. This historic dataset was created to fulfill reporting requirements under section 1902(tt)(1) of the Social Security Act, which was added by section 5131(b) of subtitle D of title V of division FF of the Consolidated Appropriations Act, 2023 (P.L. 117-328) (CAA, 2023). Please note that the methods used to count S-CHIP enrollees differ slightly between the two datasets; as a result, data users should exercise caution if comparing S-CHIP enrollment across the two datasets. State notes: Alaska, District of Columbia, Hawaii, New Hampshire, New Mexico, North Carolina, North Dakota, Ohio, South Carolina, Vermont, and Wyoming do not have S-CHIP programs. Maryland has an S-CHIP program for the from conception to end of pregnancy group that began in July 2023; April 2023 - June 2023 data for Maryland represents retroactive coverage. Oregon moved all its S-CHIP enrollees, other than those in the from conception to the end of pregnancy group, to a Medicaid-expansion CHIP program effective January 1, 2024. CHIP: Children's Health Insurance Program

On April 5, 2023, the Children’s Bureau issued Information Memorandum 23-04 on the changes to Medicaid eligibility for youth/young adults age 18 and older who transition out of foster care and move to a new state. On the webinar, the Center for Medicare & Medicaid Services (CMS) will provide an overview to the changes made by the Substance Use-Disorder Prevention that Promotes Opioid Recovery and Treatment for Patients and Communities (SUPPORT) Act and the State Health Official Letter issued by CMS. Following the CMS overview, the Children’s Bureau will provide information on the action steps states can take to collaborate on the implementation. A critical component of the webinar is to provide information on how the implementation of the SUPPORT Act can be used to address the inequities and health disparities experienced by young people as they transition out of foster care. Leaders from the Center for Medicare & Medicaid Services (CMS) and the Administration on Children, Youth, and Families (ACYF) presented during the webinar. The webinar was originally recorded on May 11, 2023. Audio Description Version Metadata-only record linking to the original dataset. Open original dataset below.

Context

The CMS National Plan and Provider Enumeration System (NPPES) was developed as part of the Administrative Simplification provisions in the original HIPAA act. The primary purpose of NPPES was to develop a unique identifier for each physician that billed medicare and medicaid. This identifier is now known as the National Provider Identifier Standard (NPI) which is a required 10 digit number that is unique to an individual provider at the national level.

Once an NPI record is assigned to a healthcare provider, parts of the NPI record that have public relevance, including the provider’s name, speciality, and practice address are published in a searchable website as well as downloadable file of zipped data containing all of the FOIA disclosable health care provider data in NPPES and a separate PDF file of code values which documents and lists the descriptions for all of the codes found in the data file.

Content

The dataset contains the latest NPI downloadable file in an easy to query BigQuery table, npi_raw. In addition, there is a second table, npi_optimized which harnesses the power of Big Query’s next-generation columnar storage format to provide an analytical view of the NPI data containing description fields for the codes based on the mappings in Data Dissemination Public File - Code Values documentation as well as external lookups to the healthcare provider taxonomy codes . While this generates hundreds of columns, BigQuery makes it possible to process all this data effectively and have a convenient single lookup table for all provider information.

Fork this kernel to get started.

Acknowledgements

https://bigquery.cloud.google.com/dataset/bigquery-public-data:nppes?_ga=2.117120578.-577194880.1523455401

https://console.cloud.google.com/marketplace/details/hhs/nppes?filter=category:science-research

Dataset Source: Center for Medicare and Medicaid Services. This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source - http://www.data.gov/privacy-policy#data_policy — and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

Banner Photo by @rawpixel from Unplash.

Inspiration

What are the top ten most common types of physicians in Mountain View?

What are the names and phone numbers of dentists in California who studied public health?

DQS Medicaid coverage among persons under age 65, by selected characteristics: United States

  Description

Data on Medicaid coverage among people under age 65, in the United States, by selected population characteristics. Data from Health, United States. SOURCE: National Center for Health Statistics, National Health Interview Survey. Search, visualize, and download these and other estimates from over 120 health topics with the NCHS Data Query System (DQS), available from:… See the full description on the dataset page: https://huggingface.co/datasets/HHS-Official/dqs-medicaid-coverage-among-persons-under-age-65-b.

This table represents details of Medicaid income levels (ages 65 and up). Medicaid provides free health insurance for low-income older adults. Eligible adults receive their medical care through a managed care plan or fee-for-service. While ones application is being processed, Medicaid may provide up to 90 days of retroactive coverage for unpaid medical bills, if the individual is eligible during those 90 days.

In order to facilitate public review and access, enrollment data published on the Open Data Portal is provided as promptly as possible after the end of each month or year, as applicable to the data set. Due to eligibility policies and operational processes, enrollment can vary slightly after publication. Please be aware of the point-in-time nature of the published data when comparing to other data published or shared by the Department of Social Services, as this data may vary slightly. As a general practice, for monthly data sets published on the Open Data Portal, DSS will continue to refresh the monthly enrollment data for three months, after which time it will remain static. For example, when March data is published the data in January and February will be refreshed. When April data is published, February and March data will be refreshed, but January will not change. This allows the Department to account for the most common enrollment variations in published data while also ensuring that data remains as stable as possible over time. In the event of a significant change in enrollment data, the Department may republish reports and will notate such republication dates and reasons accordingly. In March 2020, Connecticut opted to add a new Medicaid coverage group: the COVID-19 Testing Coverage for the Uninsured. Enrollment data on this limited-benefit Medicaid coverage group is being incorporated into Medicaid data effective January 1, 2021. Enrollment data for this coverage group prior to January 1, 2021, was listed under State Funded Medical. Effective January 1, 2021, this coverage group have been separated: (1) the COVID-19 Testing Coverage for the Uninsured is now G06-I and is now listed as a limited benefit plan that rolls up into “Program Name” of Medicaid and “Medical Benefit Plan” of HUSKY Limited Benefit; (2) the emergency medical coverage has been separated into G06-II as a limited benefit plan that rolls up into “Program Name” of Emergency Medical and “Medical Benefit Plan” of Other Medical. An historical accounting of enrollment of the specific coverage group starting in calendar year 2020 will also be published separately. The data represents number of active recipients who received benefits from a type of assistance (TOA) in that calendar year and month. A recipient may have received benefits from multiple TOAs in the same month; if so that recipient will be included in multiple categories in this dataset (counted more than once.) For privacy considerations, a count of zero is used for counts less than five. The methodology for determining the address of the recipients changed: 1. The address of a recipient in the ImpaCT system is now correctly determined specific to that month instead of using the address of the most recent month. This resulted in some shuffling of the recipients among townships starting in October 2016. 2. If, in a given month, a recipient has benefit records in both the HIX system and in the ImpaCT system, the address of the recipient is now calculated as follows to resolve conflicts: Use the residential address in ImpaCT if it exists, else use the mailing address in ImpaCT if it exists, else use the address in HIX. This resulted in a reduction in counts for most townships starting in March 2017 because a single address is now used instead of two when the systems do not agree.

This dataset includes the total number of individuals enrolled in Medi-Cal by eligibility group: Modified Adjusted Gross Income (MAGI), non-MAGI, and Children’s Health Insurance Program (CHIP). The groups are defined by the Centers for Medicare and Medicaid Services (CMS) Performance Indicators (CMSPI) reporting requirements. The Department of Health Care Services (DHCS) submits eligibility and enrollment data regarding Medicaid and CHIP monthly to CMS. The enrollment data represents enrollment totals as of 60 days after the eligibility month (indicated as “Reporting Period” in the dataset). CMS publishes the state total enrollments on the CMSPI website. The total enrollment comprises of individuals who are eligible for full scope Medi-Cal by MAGI – Child, MAGI – Adult, Non-MAGI Child, Non-MAGI Adult, and CHIP eligibility groups. DHCS does not report to CMS the total enrollment in limited scope Medi-Cal or state-only funded programs (indicated as the “Non-CMSPI” in the dataset).

Metrics from individual Marketplaces during the current reporting period. The report includes data for the states using HealthCare.gov. As of August 2024, CMS is no longer releasing the “HealthCare.gov” metrics. Historical data between July 2023-July 2024 will remain available. The “HealthCare.gov Transitions” metrics, which are the CAA, 2023 required metrics, will continue to be released.
Sources: HealthCare.gov application and policy data through May 5, 2024, and T-MSIS Analytic Files (TAF) through March 2024 (TAF version 7.1 with T-MSIS enrollment through the end of March 2024). Data include consumers in HealthCare.gov states where the first unwinding renewal cohort is due on or after the end of reporting month (state identification based on HealthCare.gov policy and application data). State data start being reported in the month when the state's first unwinding renewal cohort is due. April data include Arizona, Arkansas, Florida, Indiana, Iowa, Kansas, Nebraska, New Hampshire, Ohio, Oklahoma, South Dakota, Utah, West Virginia, and Wyoming. May data include the previous states and the following new states: Alaska, Delaware, Georgia, Hawaii, Montana, North Dakota, South Carolina, Texas, and Virginia. June data include the previous states and the following new states: Alabama, Illinois, Louisiana, Michigan, Missouri, Mississippi, North Carolina, Tennessee, and Wisconsin. July data include the previous states and Oregon. All HealthCare.gov states are included in this version of the report.
Notes:

1. This table includes Marketplace consumers who: 1) submitted a HealthCare.gov application on or after the start of each state’s first reporting month; and 2) who can be linked to an enrollment record in TAF that shows Medicaid or CHIP enrollment between March 2023 and the latest reporting month.
2. Cumulative counts show the number of unique consumers from the included population who had a Marketplace application submitted or a HealthCare.gov Marketplace policy on or after the start of each state’s first reporting month through the latest reporting month. Net counts show the difference between the cumulative counts through a given reporting month and previous reporting months.
3. The data used to produce the metrics are organized by week. Reporting months start on the first Monday of the month and end on the first Sunday of the next month when the last day of the reporting month is not a Sunday. For example, the April 2023 reporting period extends from Monday, April 3 through Sunday, April 30.
4. Data are preliminary and will be restated over time to reflect consumers most recent HealthCare.gov status. Data may change as states resubmit T-MSIS data or data quality issues are identified.
5. Data do not represent Marketplace consumers who had a confirmed Medicaid/CHIP loss. Future reporting will look at coverage transitions for people who lost Medicaid/CHIP.
6. See the data and methodology documentation for a full description of the data sources, measure definitions, and general data limitations.

Data notes:

1. Virginia operated a Federally Facilitated Exchange (FFE) on the HealthCare.gov platform during 2023. In 2024, the state started operating a State Based Marketplace (SBM) platform. This table only includes data on 2023 applications and policies obtained through the HealthCare.gov Marketplace. Due to limited Marketplace activity on the HealthCare.gov platform in December 2023, data from December 2023 onward are excluded. The cumulative count and percentage for Virginia and the HealthCare.gov total reflect Virginia data from April 2023 through November 2023.
2. The report may include negative 'net counts,' which reflect that there were cumulatively fewer counts from one month to the next.
3. Wyoming has negative ‘net counts’ for most of its metrics in March 2024, including 'Marketplace Consumers with Previous Medicaid or CHIP Enrollment.' Negative counts reflect that there were cumulatively fewer individual counts from one month to the next. The net percentages have been replaced with an asterisk for March 2024 due to the uninterpretable values.

Percentages shown are of total Marketplace consumers with previous Medicaid or CHIP enrollment.
Some cells have a value of "NR" or not reported. State data starts being reported in the month when the state's first unwinding renewal cohort is due.

APTC: Advance Premium Tax Credit; CHIP: Children's Health Insurance Program; NR: Not reported; QHP: Qualified Health Plan

This dataset includes the number of people enrolled in DSS services by town and by type of assistance (TOA) from CY 2015-2024. To view the full dataset and filter the data, click the "View Data" button at the top right of the screen. More data on people served by DSS can be found here.

About this data