Minimum Data Set Frequency
U.S. Department of Health & Human Services
@usgov.hhs_gov_minimum_data_set_frequency_11134
U.S. Department of Health & Human Services
@usgov.hhs_gov_minimum_data_set_frequency_11134
The Minimum Data Set (MDS) Frequency data summarizes health status indicators for active residents currently in nursing homes. The MDS is part of the Federally-mandated process for clinical assessment of all residents in Medicare and Medicaid certified nursing homes. This process provides a comprehensive assessment of each resident's functional capabilities and helps nursing home staff identify health problems. Care Area Assessments (CAAs) are part of this process, and provide the foundation upon which a resident's individual care plan is formulated. MDS assessments are completed for all residents in certified nursing homes, regardless of source of payment for the individual resident. MDS assessments are required for residents on admission to the nursing facility, periodically, and on discharge. All assessments are completed within specific guidelines and time frames. In most cases, participants in the assessment process are licensed health care professionals employed by the nursing home. MDS information is transmitted electronically by nursing homes to the national MDS database at CMS.
When reviewing the MDS 3.0 Frequency files, some common software programs e.g., ‘Microsoft Excel’ might inaccurately strip leading zeros from designated code values (i.e., "01" becomes "1") or misinterpret code ranges as dates (i.e., O0600 ranges such as 02-04 are misread as 04-Feb). As each piece of software is unique, if you encounter an issue when reading the CSV file of Frequency data, please open the file in a plain text editor such as ‘Notepad’ or ‘TextPad’ to review the underlying data, before reaching out to CMS for assistance.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:25:39.063264
Tags: medicaid, medicare
CREATE TABLE minimum_data_set_frequency_2020_01_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2020_04_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2020_07_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2020_12_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2021_01_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2021_04_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2021_07_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2021_12_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2022_01_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2022_04_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2022_07_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2022_12_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2023_01_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2023_04_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2023_07_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2023_12_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2024_01_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2024_04_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2024_07_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2024_12_02 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2025_01_01 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
CREATE TABLE minimum_data_set_frequency_2025_04_01 (
"geographical_location" VARCHAR,
"report_date" VARCHAR,
"mds_item_question_description" VARCHAR,
"mds_item_response" VARCHAR,
"percent" VARCHAR,
"total_residents" VARCHAR
);
Anyone who has the link will be able to view this.