The rural-urban commuting area codes (RUCA) classify U.S. census tracts using measures of urbanization, population density, and daily commuting from the decennial census. The most recent RUCA codes are based on data from the 2000 decennial census. The classification contains two levels. Whole numbers (1-10) delineate metropolitan, micropolitan, small town, and rural commuting areas based on the size and direction of the primary (largest) commuting flows. These 10 codes are further subdivided to permit stricter or looser delimitation of commuting areas, based on secondary (second largest) commuting flows. The approach errs in the direction of more codes, providing flexibility in combining levels to meet varying definitional needs and preferences. The 1990 codes are similarly defined. However, the Census Bureau's methods of defining urban cores and clusters changed between the two censuses. And, census tracts changed in number and shapes. The 2000 rural-urban commuting codes are not directly comparable with the 1990 codes because of these differences. An update of the Rural-Urban Commuting Area Codes is planned for late 2013.

Census tracts with 4, 5, 6 and 10 tier classifications. We'll be adding 2020 data when its available from the USDA or the Census.From Asnake Hailu,The schemes shared in the RUCAGuide.pdf are DOH modified layers, prepared merely for epidemiological purposes [I.e., to delineate geography for a comprehensive epidemiologic assessment, describing rural-urban differences in demographics, health outcomes, risk factors, access to services, and the like.] Those are not as such rural/urban designation tools for census block areas, nor for any of the other geography categories. The files with the DOH modified layers are available at https://doh.wa.gov/public-health-healthcare-providers/rural-health/data-maps-and-other-resources under the sub-county level: Zip Code and Census Tract sub-heading.Please note: those files are essentially a decade old. We were anticipating to update our core products that are on our website, if and when the Federal Office of Rural Health and Policy (FORHP) produces a newer version of RUCA codes based on census 2020. The FORHP customarily contracts with a university for that task. We are three years away from 2020, except there is no update posted on the webpage I am familiar to get the original RUCA delineations. Here is a path where I go to check for the newer version: https://www.ers.usda.gov/data-products/rural-urban-commuting-area-codes/

This dataset contains measures of the urban/rural characteristics of each census tract in the United States. These include proportions of urban and rural population, population density, rural/urban commuting area (RUCA) codes, and RUCA-based four- and seven- category urbanicity scales. A curated version of this data is available through ICPSR at https://www.icpsr.umich.edu/web/ICPSR/studies/38606/versions/V1

This dataset contains two measures designed to be used in tandem to characterize United States census tracts, originally developed for use in stratified analyses of the Diabetes Location, Environmental Attributes, and Disparities (LEAD) Network. The first measure is a 2010 tract-level community type categorization based on a modification of Rural-Urban Commuting Area (RUCA) Codes that incorporates census-designated urban areas and tract land area, with five categories: higher density urban, lower density urban, suburban/small town, rural, and undesignated (McAlexander, et al., 2022). The second measure is a neighborhood social and economic environment (NSEE) score, a community-type stratified z-score sum of 6 US census-derived variables, with sums scaled between 0 and 100, computed for the year 2000 and 2010. A tract with a higher NSEE z-score sum indicates more socioeconomic disadvantage compared to a tract with a lower z-score sum. Analysts should not compare NSEE scores across LEAD community types, as values have been computed and scaled within community type.

This data set includes annual counts and percentages of Medicaid and Children’s Health Insurance Program (CHIP) enrollees who received a well-child visit paid for by Medicaid or CHIP, overall and by five subpopulation topics: age group, race and ethnicity, urban or rural residence, program type, and primary language. These results were generated using Transformed Medicaid Statistical Information System (T-MSIS) Analytic Files (TAF) Release 1 data and the Race/Ethnicity Imputation Companion File. This data set includes Medicaid and CHIP enrollees in all 50 states, the District of Columbia, Puerto Rico, and the U.S. Virgin Islands, except where otherwise noted. Enrollees in Guam, American Samoa, and the Northern Mariana Islands are not included. Results include enrollees with comprehensive Medicaid or CHIP benefits for all 12 months of the year and who were younger than age 19 at the end of the calendar year. Results shown for the race and ethnicity subpopulation topic exclude enrollees in the U.S. Virgin Islands. Results shown for the primary language subpopulation topic exclude select states with data quality issues with the primary language variable in TAF. Some rows in the data set have a value of "DS," which indicates that data were suppressed according to the Centers for Medicare & Medicaid Services’ Cell Suppression Policy for values between 1 and 10. This data set is based on the brief: "Medicaid and CHIP enrollees who received a well-child visit in 2020." Enrollees are identified as receiving a well-child visit in the year according to the Line 6 criteria in the Form CMS-416 reporting instructions. Enrollees are assigned to an age group subpopulation using age as of December 31st of the calendar year. Enrollees are assigned to a race and ethnicity subpopulation using the state-reported race and ethnicity information in TAF when it is available and of good quality; if it is missing or unreliable, race and ethnicity is indirectly estimated using an enhanced version of Bayesian Improved Surname Geocoding (BISG) (Race and ethnicity of the national Medicaid and CHIP population in 2020). Enrollees are assigned to an urban or rural subpopulation based on the 2010 Rural-Urban Commuting Area (RUCA) code associated with their home or mailing address ZIP code in TAF (Rural Medicaid and CHIP enrollees in 2020). Enrollees are assigned to a program type subpopulation based on the CHIP code and eligibility group code that applies to the majority of their enrolled-months during the year (Medicaid-Only Enrollment; M-CHIP and S-CHIP Enrollment). Enrollees are assigned to a primary language subpopulation based on their reported ISO language code in TAF (English/missing, Spanish, and all other language codes) (Primary Language). Please refer to the full brief for additional context about the methodology and detailed findings. Future updates to this data set will include more recent data years as the TAF data become available.

This data set includes annual counts and percentages of Medicaid and Children’s Health Insurance Program (CHIP) enrollees by urban or rural residence. Results are shown overall; by state; and by four subpopulation topics: scope of Medicaid and CHIP benefits, race and ethnicity, disability-related eligibility category, and managed care participation. These results were generated using Transformed Medicaid Statistical Information System (T-MSIS) Analytic Files (TAF) Release 1 data and the Race/Ethnicity Imputation Companion File. This data set includes Medicaid and CHIP enrollees in all 50 states, the District of Columbia, Puerto Rico, and the U.S. Virgin Islands who were enrolled for at least one day in the calendar year, except where otherwise noted. Enrollees in Guam, American Samoa, and the Northern Mariana Islands are not included. Results shown overall (where subpopulation topic is "Total enrollees") and for the race and ethnicity subpopulation topic exclude enrollees in the U.S. Virgin Islands. Results shown for the race and ethnicity, disability category, and managed care participation subpopulation topics only include Medicaid and CHIP enrollees with comprehensive benefits. Results shown for the disability category subpopulation topic only include working-age adults (ages 19 to 64). Results for states with TAF data quality issues in the year have a value of "Unusable data." Some rows in the data set have a value of "DS," which indicates that data were suppressed according to the Centers for Medicare & Medicaid Services’ Cell Suppression Policy for values between 1 and 10. This data set is based on the brief: "Rural Medicaid and CHIP enrollees in 2020." Enrollees are assigned to an urban or rural category based on the 2010 Rural-Urban Commuting Area (RUCA) code associated with their home or mailing address ZIP code in TAF. Enrollees are assigned to the comprehensive benefits or limited benefits subpopulation according to the criteria in the "Identifying Beneficiaries with Full-Scope, Comprehensive, and Limited Benefits in the TAF" DQ Atlas brief. Enrollees are assigned to a race and ethnicity subpopulation using the state-reported race and ethnicity information in TAF when it is available and of good quality; if it is missing or unreliable, race and ethnicity is indirectly estimated using an enhanced version of Bayesian Improved Surname Geocoding (BISG) (Race and ethnicity of the national Medicaid and CHIP population in 2020). Enrollees are assigned to a disability category subpopulation using their latest reported eligibility group code and age in the year (Medicaid enrollees who qualify for benefits based on disability in 2020). Enrollees are assigned to a managed care participation subpopulation based on the managed care plan type code that applies to the majority of their enrolled-months during the year (Enrollment in CMC Plans). Please refer to the full brief for additional context about the methodology and detailed findings. Future updates to this data set will include more recent data years as the TAF data become available.

This data set includes annual counts and percentages of Medicaid and Children’s Health Insurance Program (CHIP) enrollees by primary language spoken (English, Spanish, and all other languages). Results are shown overall; by state; and by five subpopulation topics: race and ethnicity, age group, scope of Medicaid and CHIP benefits, urban or rural residence, and eligibility category. These results were generated using Transformed Medicaid Statistical Information System (T-MSIS) Analytic Files (TAF) Release 1 data and the Race/Ethnicity Imputation Companion File. This data set includes Medicaid and CHIP enrollees in all 50 states, the District of Columbia, Puerto Rico, and the U.S. Virgin Islands who were enrolled for at least one day in the calendar year, except where otherwise noted. Enrollees in Guam, American Samoa, the Northern Mariana Islands, and select states with data quality issues with the primary language variable in TAF are not included. Results shown for the race and ethnicity subpopulation topic exclude enrollees in the U.S. Virgin Islands. Results shown overall (where subpopulation topic is "Total enrollees") exclude enrollees younger than age 5 and enrollees in the U.S. Virgin Islands. Results for states with TAF data quality issues in the year have a value of "Unusable data." Some rows in the data set have a value of "DS," which indicates that data were suppressed according to the Centers for Medicare & Medicaid Services’ Cell Suppression Policy for values between 1 and 10. This data set is based on the brief: "Primary language spoken by the Medicaid and CHIP population in 2020." Enrollees are assigned to a primary language category based on their reported ISO language code in TAF (English/missing, Spanish, and all other language codes) (Primary Language). Enrollees are assigned to a race and ethnicity subpopulation using the state-reported race and ethnicity information in TAF when it is available and of good quality; if it is missing or unreliable, race and ethnicity is indirectly estimated using an enhanced version of Bayesian Improved Surname Geocoding (BISG) (Race and ethnicity of the national Medicaid and CHIP population in 2020). Enrollees are assigned to an age group subpopulation using age as of December 31st of the calendar year. Enrollees are assigned to the comprehensive benefits or limited benefits subpopulation according to the criteria in the "Identifying Beneficiaries with Full-Scope, Comprehensive, and Limited Benefits in the TAF" DQ Atlas brief. Enrollees are assigned to an urban or rural subpopulation based on the 2010 Rural-Urban Commuting Area (RUCA) code associated with their home or mailing address ZIP code in TAF (Rural Medicaid and CHIP enrollees in 2020). Enrollees are assigned to an eligibility category subpopulation using their latest reported eligibility group code, CHIP code, and age in the calendar year. Please refer to the full brief for additional context about the methodology and detailed findings. Future updates to this data set will include more recent data years as the TAF data become available.

This data set includes annual counts and percentages of Medicaid and Children’s Health Insurance Program (CHIP) enrollees who received mental health (MH) or substance use disorder (SUD) services, overall and by six subpopulation topics: age group, sex or gender identity, race and ethnicity, urban or rural residence, eligibility category, and primary language. These results were generated using Transformed Medicaid Statistical Information System (T-MSIS) Analytic Files (TAF) Release 1 data and the Race/Ethnicity Imputation Companion File. This data set includes Medicaid and CHIP enrollees in all 50 states, the District of Columbia, Puerto Rico, and the U.S. Virgin Islands, ages 12 to 64 at the end of the calendar year, who were not dually eligible for Medicare and were continuously enrolled with comprehensive benefits for 12 months, with no more than one gap in enrollment exceeding 45 days. Enrollees who received services for both an MH condition and SUD in the year are counted toward both condition categories. Enrollees in Guam, American Samoa, the Northern Mariana Islands, and select states with TAF data quality issues are not included. Results shown for the race and ethnicity subpopulation topic exclude enrollees in the U.S. Virgin Islands. Results shown for the primary language subpopulation topic exclude select states with data quality issues with the primary language variable in TAF. Some rows in the data set have a value of "DS," which indicates that data were suppressed according to the Centers for Medicare & Medicaid Services’ Cell Suppression Policy for values between 1 and 10. This data set is based on the brief: "Medicaid and CHIP enrollees who received mental health or SUD services in 2020." Enrollees are assigned to an age group subpopulation using age as of December 31st of the calendar year. Enrollees are assigned to a sex or gender identity subpopulation using their latest reported sex in the calendar year. Enrollees are assigned to a race and ethnicity subpopulation using the state-reported race and ethnicity information in TAF when it is available and of good quality; if it is missing or unreliable, race and ethnicity is indirectly estimated using an enhanced version of Bayesian Improved Surname Geocoding (BISG) (Race and ethnicity of the national Medicaid and CHIP population in 2020). Enrollees are assigned to an urban or rural subpopulation based on the 2010 Rural-Urban Commuting Area (RUCA) code associated with their home or mailing address ZIP code in TAF (Rural Medicaid and CHIP enrollees in 2020). Enrollees are assigned to an eligibility category subpopulation using their latest reported eligibility group code, CHIP code, and age in the calendar year. Enrollees are assigned to a primary language subpopulation based on their reported ISO language code in TAF (English/missing, Spanish, and all other language codes) (Primary Language). Please refer to the full brief for additional context about the methodology and detailed findings. Future updates to this data set will include more recent data years as the TAF data become available.

This is a random sampling of the 2022 public data set hosted by the Center for Medicare & Medicaid Services at:

https://data.cms.gov/provider-summary-by-type-of-service/medicare-physician-other-practitioners/medicare-physician-other-practitioners-by-provider-and-service

The complete data set for 2022 can be found there. This random sampling has 292,663 rows and 29 columns. The full set hosted at the link above is about 3GB in size with 9,755,427 rows and 29 columns. The 29 columns are:

1. National Provider Identifier (Rndrng_NPI)
2. Last Name/Organization Name of the Provider (Rndrng_Prvdr_Last_Org_Name)
3. First Name of the Provider (Rndrng_Prvdr_First_Name)
4. Middle Initial of the Provider (Rndrng_Prvdr_MI)
5. Credentials of the Provider (Rndrng_Prvdr_Crdntls)
6. Gender of the Provider (Rndrng_Prvdr_Gndr)
7. Entity Type of the Provider (Rndrng_Prvdr_Ent_Cd)
8. Street Address 1 of the Provider (Rndrng_Prvdr_St1)
9. Street Address 2 of the Provider (Rndrng_Prvdr_St2)
10. City of the Provider (Rndrng_Prvdr_City)
11. State Abbreviation of the Provider (Rndrng_Prvdr_State_Abrvtn)
12. State FIPS Code of the Provider (Rndrng_Prvdr_State_FIPS)
13. Zip Code of the Provide (Rndrng_Prvdr_Zip5)
14. RUCA Code of the Provider (Rndrng_Prvdr_RUCA)
15. RUCA Description (Rndrng_Prvdr_RUCA_Desc)
16. Country Code of the Provider (Rndrng_Prvdr_Cntry)
17. Provider Type of the Provider (Rndrng_Prvdr_Type)
18. Medicare Participation Indicator (Rndrng_Prvdr_Mdcr_Prtcptg_Ind)
19. HCPCS Code (HCPCS_Cd)
20. HCPCS Description (HCPCS_Desc)
21. HCPCS Drug Indicator (HCPCS_Drug_Ind)
22. Place of Service (Place_Of_Srvc)
23. Number of Medicare Beneficiaries (Tot_Benes)
24. Number of Services (Tot_Srvcs)
25. Number of Distinct Medicare Beneficiary/Per Day Services (Tot_Bene_Day_Srvcs)
26. Average Submitted Charge Amount (Avg_Sbmtd_Chrg)
27. Average Medicare Allowed Amount (Avg_Mdcr_Alowd_Amt)
28. Average Medicare Payment Amount (Avg_Mdcr_Pymt_Amt)
29. Average Medicare Standardized Payment Amount (Avg_Mdcr_Stdzd_Amt)

A brief description of each these columns can be found here:

https://data.cms.gov/resources/medicare-physician-other-practitioners-by-provider-and-service-data-dictionary

A full description of the data is in the 27-page document, "Medicare Fee-For-Service Provider Utilization & Payment Data Physician and Other Supplier Public Use File: A Methodological Overview" which can be found here:

www.cms.gov/research-statistics-data-and-systems/statistics-trends-and-reports/medicare-provider-charge-data/downloads/medicare-physician-and-other-supplier-puf-methodology.pdf

This data set is similar to the one posted by Tamil Selvan here https://www.kaggle.com/datasets/tamilsel/healthcare-providers-data. That data's origin is unclear, however it is very likely from same source. It has different header text and may be from one of the earlier years.

This data set includes annual counts and percentages of Medicaid and Children’s Health Insurance Program (CHIP) enrollees who received a well-child visit paid for by Medicaid or CHIP, overall and by five subpopulation topics: age group, race and ethnicity, urban or rural residence, program type, and primary language. These results were generated using Transformed Medicaid Statistical Information System (T-MSIS) Analytic Files (TAF) Release 1 data and the Race/Ethnicity Imputation Companion File. This data set includes Medicaid and CHIP enrollees in all 50 states, the District of Columbia, Puerto Rico, and the U.S. Virgin Islands, except where otherwise noted. Enrollees in Guam, American Samoa, and the Northern Mariana Islands are not included. Results include enrollees with comprehensive Medicaid or CHIP benefits for all 12 months of the year and who were younger than age 19 at the end of the calendar year. Results shown for the race and ethnicity subpopulation topic exclude enrollees in the U.S. Virgin Islands. Results shown for the primary language subpopulation topic exclude select states with data quality issues with the primary language variable in TAF. Some rows in the data set have a value of "DS," which indicates that data were suppressed according to the Centers for Medicare & Medicaid Services’ Cell Suppression Policy for values between 1 and 10. This data set is based on the brief: "Medicaid and CHIP enrollees who received a well-child visit in 2020." Enrollees are identified as receiving a well-child visit in the year according to the Line 6 criteria in the Form CMS-416 reporting instructions. Enrollees are assigned to an age group subpopulation using age as of December 31st of the calendar year. Enrollees are assigned to a race and ethnicity subpopulation using the state-reported race and ethnicity information in TAF when it is available and of good quality; if it is missing or unreliable, race and ethnicity is indirectly estimated using an enhanced version of Bayesian Improved Surname Geocoding (BISG) (Race and ethnicity of the national Medicaid and CHIP population in 2020). Enrollees are assigned to an urban or rural subpopulation based on the 2010 Rural-Urban Commuting Area (RUCA) code associated with their home or mailing address ZIP code in TAF (Rural Medicaid and CHIP enrollees in 2020). Enrollees are assigned to a program type subpopulation based on the CHIP code and eligibility group code that applies to the majority of their enrolled-months during the year (Medicaid-Only Enrollment; M-CHIP and S-CHIP Enrollment). Enrollees are assigned to a primary language subpopulation based on their reported ISO language code in TAF (English/missing, Spanish, and all other language codes) (Primary Language). Please refer to the full brief for additional context about the methodology and detailed findings. Future updates to this data set will include more recent data years as the TAF data become available.

ZIP Code business counts data for Maptitude mapping software are from Caliper Corporation and contain aggregated ZIP Code Business Patterns (ZBP) data and Rural-Urban Commuting Area (RUCA) data.