This dataset includes the number of people enrolled in DSS services by town and by assistance type 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

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?

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).

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. This data represents number of active recipients who received benefits under a program in that calendar year and month. A recipient may have received benefits from multiple programs in the same month; if so that recipient will be included in multiple categories in this dataset (counted more than once.) 2021 is a partial year. For privacy considerations, a count of zero is used for counts less than five. NOTE: 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, corrections in the ImpaCT system for January and February 2019 caused the addition of around 2000 and 3000 recipients respectively, and the counts for many types of assistance (e.g. SNAP) were adjusted upward for those 2 months. 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. 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. NOTE: 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. NOTE: On 11/30/2018 the counts were revised because of a change in the way active recipients were counted in one source system.

This map shows where people have Medicaid or means-tested healthcare coverage in the US (ages under 65). This is shown by State, County, and Census Tract, and uses the most current ACS 5-year estimates.

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.

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: 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. 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. 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. 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. 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. See the data and methodology documentation for a full description of the data sources, measure definitions, and general data limitations. Data notes: 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. The report may include negative 'net counts,' which reflect that there were cumulatively fewer counts from one month to the next. Wyoming has negative ‘net counts’ for most of its metrics in March 2024, including 'Marketplace Consumers with Previous M

This dataset contains aggregate Medicaid payments, and counts for eligible recipients and recipients served by month and county in Iowa, starting with month ending 1/31/2011. Eligibility groups are a category of people who meet certain common eligibility requirements. Some Medicaid eligibility groups cover additional services, such as nursing facility care and care received in the home. Others have higher income and resource limits, charge a premium, only pay the Medicare premium or cover only expenses also paid by Medicare, or require the recipient to pay a specific dollar amount of their medical expenses. Eligible Medicaid recipients may be considered medically needy if their medical costs are so high that they use up most of their income. Those considered medically needy are responsible for paying some of their medical expenses. This is called meeting a spend down. Then Medicaid would start to pay for the rest. Think of the spend down like a deductible that people pay as part of a private insurance plan.

This dataset represents the number of Medicaid eligible individuals receiving the various Medicaid services over time.

This dataset contains the total number of Medi-Cal Managed Care enrollees based on the reported month, plan type, county, and health plan.

NCHS has linked data from various surveys with Medicare program enrollment and health care utilization and expenditure data from the Centers for Medicare & Medicaid Services (CMS). Linkage of the NCHS survey participants with the CMS Medicare data provides the opportunity to study changes in health status, health care utilization and costs, and prescription drug use among Medicare enrollees. Medicare is the federal health insurance program for people who are 65 or older, certain younger people with disabilities, and people with End-Stage Renal Disease.

This dataset includes the number of people enrolled in DSS services by town and by age group 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