About this Dataset

Long-Term Care Facility Characteristics

The Long-Term Care Facility Characteristics, CMS Form 671, dataset provides information submitted by nursing homes on the CMS Form 671 collected during annual surveys. The data include information about resident census, ownership, dedicated special care units, facility characteristics, and staffing.

Note: Annual surveys are conducted every 9 to 15 months. Additionally, some states are experiencing delays in conducting annual surveys, resulting in longer periods of time since the last annual survey. As such, some of the data included in these files may not be up to date.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-07-31T19:14:33.765280
Tags: hospitals-facilities, inpatient, long-term-care, medicare, skilled-nursing

Tables

Long-Term Care Facility Characteristics : 2023-10-01

@usgov.hhs_gov_long_term_care_facility_characteristics.long_term_care_facility_characteristics_2023_10_01

682.51 KB
14922 rows
33 columns


CREATE TABLE long_term_care_facility_characteristics_2023_10_01 (
  "provider_number" VARCHAR,
  "facility_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "certification_date" TIMESTAMP,
  "medicare_census" BIGINT,
  "medicaid_census" BIGINT,
  "other_census" BIGINT,
  "total_residents" BIGINT,
  "program_participation_code" VARCHAR,
  "hospital_based" VARCHAR,
  "ownership_type" VARCHAR,
  "multi_facility_organization" VARCHAR,
  "multi_facility_organization_name" VARCHAR,
  "number_of_aids_beds" BIGINT,
  "number_of_alzheimer_s_disease_beds" BIGINT,
  "number_of_dialysis_beds" BIGINT,
  "number_of_disabled_children_young_adult_beds" BIGINT,
  "number_of_head_trauma_beds" BIGINT,
  "number_of_hospice_beds" BIGINT,
  "number_of_huntington_s_disease_beds" BIGINT,
  "number_of_ventilator_beds" BIGINT,
  "number_of_other_specialized_rehab_beds" BIGINT,
  "organized_residents_group" VARCHAR,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR,
  "n_7_day_rn_waiver_date" TIMESTAMP,
  "n_7_day_rn_hrs_waived_per_week" BIGINT,
  "n_24_hr_licensed_nursing_waiver_date" TIMESTAMP,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);

Long-Term Care Facility Characteristics : 2024-01-01

@usgov.hhs_gov_long_term_care_facility_characteristics.long_term_care_facility_characteristics_2024_01_01

681.4 KB
14882 rows
33 columns


CREATE TABLE long_term_care_facility_characteristics_2024_01_01 (
  "provider_number" VARCHAR,
  "facility_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "certification_date" TIMESTAMP,
  "medicare_census" BIGINT,
  "medicaid_census" BIGINT,
  "other_census" BIGINT,
  "total_residents" BIGINT,
  "program_participation_code" VARCHAR,
  "hospital_based" VARCHAR,
  "ownership_type" VARCHAR,
  "multi_facility_organization" VARCHAR,
  "multi_facility_organization_name" VARCHAR,
  "number_of_aids_beds" BIGINT,
  "number_of_alzheimer_s_disease_beds" BIGINT,
  "number_of_dialysis_beds" BIGINT,
  "number_of_disabled_children_young_adult_beds" BIGINT,
  "number_of_head_trauma_beds" BIGINT,
  "number_of_hospice_beds" BIGINT,
  "number_of_huntington_s_disease_beds" BIGINT,
  "number_of_ventilator_beds" BIGINT,
  "number_of_other_specialized_rehab_beds" BIGINT,
  "organized_residents_group" VARCHAR,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR,
  "n_7_day_rn_waiver_date" TIMESTAMP,
  "n_7_day_rn_hrs_waived_per_week" BIGINT,
  "n_24_hr_licensed_nursing_waiver_date" TIMESTAMP,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);

Long-Term Care Facility Characteristics : 2024-04-01

@usgov.hhs_gov_long_term_care_facility_characteristics.long_term_care_facility_characteristics_2024_04_01

679.47 KB
14861 rows
33 columns


CREATE TABLE long_term_care_facility_characteristics_2024_04_01 (
  "provider_number" VARCHAR,
  "facility_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "certification_date" TIMESTAMP,
  "medicare_census" BIGINT,
  "medicaid_census" BIGINT,
  "other_census" BIGINT,
  "total_residents" BIGINT,
  "program_participation_code" VARCHAR,
  "hospital_based" VARCHAR,
  "ownership_type" VARCHAR,
  "multi_facility_organization" VARCHAR,
  "multi_facility_organization_name" VARCHAR,
  "number_of_aids_beds" BIGINT,
  "number_of_alzheimer_s_disease_beds" BIGINT,
  "number_of_dialysis_beds" BIGINT,
  "number_of_disabled_children_young_adult_beds" BIGINT,
  "number_of_head_trauma_beds" BIGINT,
  "number_of_hospice_beds" BIGINT,
  "number_of_huntington_s_disease_beds" BIGINT,
  "number_of_ventilator_beds" BIGINT,
  "number_of_other_specialized_rehab_beds" BIGINT,
  "organized_residents_group" VARCHAR,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR,
  "n_7_day_rn_waiver_date" TIMESTAMP,
  "n_7_day_rn_hrs_waived_per_week" BIGINT,
  "n_24_hr_licensed_nursing_waiver_date" TIMESTAMP,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);

Long-Term Care Facility Characteristics : 2024-07-01

@usgov.hhs_gov_long_term_care_facility_characteristics.long_term_care_facility_characteristics_2024_07_01

680.32 KB
14830 rows
33 columns


CREATE TABLE long_term_care_facility_characteristics_2024_07_01 (
  "provider_number" VARCHAR,
  "facility_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "certification_date" TIMESTAMP,
  "medicare_census" BIGINT,
  "medicaid_census" BIGINT,
  "other_census" BIGINT,
  "total_residents" BIGINT,
  "program_participation_code" VARCHAR,
  "hospital_based" VARCHAR,
  "ownership_type" VARCHAR,
  "multi_facility_organization" VARCHAR,
  "multi_facility_organization_name" VARCHAR,
  "number_of_aids_beds" BIGINT,
  "number_of_alzheimer_s_disease_beds" BIGINT,
  "number_of_dialysis_beds" BIGINT,
  "number_of_disabled_children_young_adult_beds" BIGINT,
  "number_of_head_trauma_beds" BIGINT,
  "number_of_hospice_beds" BIGINT,
  "number_of_huntington_s_disease_beds" BIGINT,
  "number_of_ventilator_beds" BIGINT,
  "number_of_other_specialized_rehab_beds" BIGINT,
  "organized_residents_group" VARCHAR,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR,
  "n_7_day_rn_waiver_date" TIMESTAMP,
  "n_7_day_rn_hrs_waived_per_week" BIGINT,
  "n_24_hr_licensed_nursing_waiver_date" TIMESTAMP,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);

Long-Term Care Facility Characteristics : 2024-10-01

@usgov.hhs_gov_long_term_care_facility_characteristics.long_term_care_facility_characteristics_2024_10_01

677.8 KB
14799 rows
33 columns


CREATE TABLE long_term_care_facility_characteristics_2024_10_01 (
  "provider_number" VARCHAR,
  "facility_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "certification_date" TIMESTAMP,
  "medicare_census" BIGINT,
  "medicaid_census" BIGINT,
  "other_census" BIGINT,
  "total_residents" BIGINT,
  "program_participation_code" VARCHAR,
  "hospital_based" VARCHAR,
  "ownership_type" VARCHAR,
  "multi_facility_organization" VARCHAR,
  "multi_facility_organization_name" VARCHAR,
  "number_of_aids_beds" BIGINT,
  "number_of_alzheimer_s_disease_beds" BIGINT,
  "number_of_dialysis_beds" BIGINT,
  "number_of_disabled_children_young_adult_beds" BIGINT,
  "number_of_head_trauma_beds" BIGINT,
  "number_of_hospice_beds" BIGINT,
  "number_of_huntington_s_disease_beds" BIGINT,
  "number_of_ventilator_beds" BIGINT,
  "number_of_other_specialized_rehab_beds" BIGINT,
  "organized_residents_group" VARCHAR,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR,
  "n_7_day_rn_waiver_date" TIMESTAMP,
  "n_7_day_rn_hrs_waived_per_week" BIGINT,
  "n_24_hr_licensed_nursing_waiver_date" TIMESTAMP,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);

Long-Term Care Facility Characteristics : 2025-01-01

@usgov.hhs_gov_long_term_care_facility_characteristics.long_term_care_facility_characteristics_2025_01_01

674.66 KB
14773 rows
33 columns


CREATE TABLE long_term_care_facility_characteristics_2025_01_01 (
  "provider_number" VARCHAR,
  "facility_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "certification_date" TIMESTAMP,
  "medicare_census" BIGINT,
  "medicaid_census" BIGINT,
  "other_census" BIGINT,
  "total_residents" BIGINT,
  "program_participation_code" VARCHAR,
  "hospital_based" VARCHAR,
  "ownership_type" VARCHAR,
  "multi_facility_organization" VARCHAR,
  "multi_facility_organization_name" VARCHAR,
  "number_of_aids_beds" BIGINT,
  "number_of_alzheimer_s_disease_beds" BIGINT,
  "number_of_dialysis_beds" BIGINT,
  "number_of_disabled_children_young_adult_beds" BIGINT,
  "number_of_head_trauma_beds" BIGINT,
  "number_of_hospice_beds" BIGINT,
  "number_of_huntington_s_disease_beds" BIGINT,
  "number_of_ventilator_beds" BIGINT,
  "number_of_other_specialized_rehab_beds" BIGINT,
  "organized_residents_group" VARCHAR,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR,
  "n_7_day_rn_waiver_date" TIMESTAMP,
  "n_7_day_rn_hrs_waived_per_week" BIGINT,
  "n_24_hr_licensed_nursing_waiver_date" VARCHAR,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);

Long-Term Care Facility Characteristics : 2025-04-01

@usgov.hhs_gov_long_term_care_facility_characteristics.long_term_care_facility_characteristics_2025_04_01

670.58 KB
14758 rows
33 columns


CREATE TABLE long_term_care_facility_characteristics_2025_04_01 (
  "provider_number" VARCHAR,
  "facility_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" BIGINT,
  "certification_date" TIMESTAMP,
  "medicare_census" BIGINT,
  "medicaid_census" BIGINT,
  "other_census" BIGINT,
  "total_residents" BIGINT,
  "program_participation_code" VARCHAR,
  "hospital_based" VARCHAR,
  "ownership_type" VARCHAR,
  "multi_facility_organization" VARCHAR,
  "multi_facility_organization_name" VARCHAR,
  "number_of_aids_beds" BIGINT,
  "number_of_alzheimer_s_disease_beds" BIGINT,
  "number_of_dialysis_beds" BIGINT,
  "number_of_disabled_children_young_adult_beds" BIGINT,
  "number_of_head_trauma_beds" BIGINT,
  "number_of_hospice_beds" BIGINT,
  "number_of_huntington_s_disease_beds" BIGINT,
  "number_of_ventilator_beds" BIGINT,
  "number_of_other_specialized_rehab_beds" BIGINT,
  "organized_residents_group" VARCHAR,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR,
  "n_7_day_rn_waiver_date" TIMESTAMP,
  "n_7_day_rn_hrs_waived_per_week" BIGINT,
  "n_24_hr_licensed_nursing_waiver_date" TIMESTAMP,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);