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.
Organization: U.S. Department of Health & Human Services
Last updated: 2025-10-07T07:28:04.508303
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_4e309.long_term_care_facility_characteristics_2023_10_01

698.89 kB
14,922 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 Residents' Group,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR  -- Continuing Care Retirement Community (CCRC),
  "n_7_day_rn_waiver_date" TIMESTAMP  -- 7 Day RN Waiver Date,
  "n_7_day_rn_hrs_waived_per_week" BIGINT  -- 7 Day RN Hrs Waived Per Week,
  "n_24_hr_licensed_nursing_waiver_date" TIMESTAMP  -- 24 Hr Licensed Nursing Waiver Date,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT  -- 24 Hr Licensed Nursing Hrs Waived Per Week,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);

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

@usgov.hhs_gov_long_term_care_facility_characteristics_4e309.long_term_care_facility_characteristics_2024_01_01

697.76 kB
14,882 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 Residents' Group,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR  -- Continuing Care Retirement Community (CCRC),
  "n_7_day_rn_waiver_date" TIMESTAMP  -- 7 Day RN Waiver Date,
  "n_7_day_rn_hrs_waived_per_week" BIGINT  -- 7 Day RN Hrs Waived Per Week,
  "n_24_hr_licensed_nursing_waiver_date" TIMESTAMP  -- 24 Hr Licensed Nursing Waiver Date,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT  -- 24 Hr Licensed Nursing Hrs Waived Per Week,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);

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

@usgov.hhs_gov_long_term_care_facility_characteristics_4e309.long_term_care_facility_characteristics_2024_04_01

695.78 kB
14,861 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 Residents' Group,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR  -- Continuing Care Retirement Community (CCRC),
  "n_7_day_rn_waiver_date" TIMESTAMP  -- 7 Day RN Waiver Date,
  "n_7_day_rn_hrs_waived_per_week" BIGINT  -- 7 Day RN Hrs Waived Per Week,
  "n_24_hr_licensed_nursing_waiver_date" TIMESTAMP  -- 24 Hr Licensed Nursing Waiver Date,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT  -- 24 Hr Licensed Nursing Hrs Waived Per Week,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);

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

@usgov.hhs_gov_long_term_care_facility_characteristics_4e309.long_term_care_facility_characteristics_2024_07_01

696.64 kB
14,830 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 Residents' Group,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR  -- Continuing Care Retirement Community (CCRC),
  "n_7_day_rn_waiver_date" TIMESTAMP  -- 7 Day RN Waiver Date,
  "n_7_day_rn_hrs_waived_per_week" BIGINT  -- 7 Day RN Hrs Waived Per Week,
  "n_24_hr_licensed_nursing_waiver_date" TIMESTAMP  -- 24 Hr Licensed Nursing Waiver Date,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT  -- 24 Hr Licensed Nursing Hrs Waived Per Week,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);

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

@usgov.hhs_gov_long_term_care_facility_characteristics_4e309.long_term_care_facility_characteristics_2024_10_01

694.07 kB
14,799 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 Residents' Group,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR  -- Continuing Care Retirement Community (CCRC),
  "n_7_day_rn_waiver_date" TIMESTAMP  -- 7 Day RN Waiver Date,
  "n_7_day_rn_hrs_waived_per_week" BIGINT  -- 7 Day RN Hrs Waived Per Week,
  "n_24_hr_licensed_nursing_waiver_date" TIMESTAMP  -- 24 Hr Licensed Nursing Waiver Date,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT  -- 24 Hr Licensed Nursing Hrs Waived Per Week,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);

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

@usgov.hhs_gov_long_term_care_facility_characteristics_4e309.long_term_care_facility_characteristics_2025_01_01

690.86 kB
14,773 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 Residents' Group,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR  -- Continuing Care Retirement Community (CCRC),
  "n_7_day_rn_waiver_date" TIMESTAMP  -- 7 Day RN Waiver Date,
  "n_7_day_rn_hrs_waived_per_week" BIGINT  -- 7 Day RN Hrs Waived Per Week,
  "n_24_hr_licensed_nursing_waiver_date" VARCHAR  -- 24 Hr Licensed Nursing Waiver Date,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT  -- 24 Hr Licensed Nursing Hrs Waived Per Week,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);

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

@usgov.hhs_gov_long_term_care_facility_characteristics_4e309.long_term_care_facility_characteristics_2025_04_01

686.67 kB
14,758 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 Residents' Group,
  "organized_family_member_group" VARCHAR,
  "facility_conducts_experimental_research" VARCHAR,
  "continuing_care_retirement_community_ccrc" VARCHAR  -- Continuing Care Retirement Community (CCRC),
  "n_7_day_rn_waiver_date" TIMESTAMP  -- 7 Day RN Waiver Date,
  "n_7_day_rn_hrs_waived_per_week" BIGINT  -- 7 Day RN Hrs Waived Per Week,
  "n_24_hr_licensed_nursing_waiver_date" TIMESTAMP  -- 24 Hr Licensed Nursing Waiver Date,
  "n_24_hr_licensed_nursing_hrs_waived_per_week" BIGINT  -- 24 Hr Licensed Nursing Hrs Waived Per Week,
  "nurse_aide_training_and_competency_evaluation_program" VARCHAR
);