Nursing Facility Registry by US Government | Demographics and Population Studies

About this Dataset

Nursing Facility Registry

This registry provides a list of licensed nursing facilities in Connecticut as of September 30th each year, beginning with data from 2013. For each facility, this dataset includes aggregate resident demographic information, private pay rates for private and semi-private rooms, payment sources and occupancy levels for each year.
Organization: State of Connecticut
Last updated: 2020-11-12T14:57:29.229916
Tags: census, long-term-care, ltc, nursing-facilities, nursing-homes, opm, pdpd

Tables

Table 1

@usgov.state_of_connecticut_nursing_facility_registry.table_1

191.35 KB
2580 rows
66 columns


CREATE TABLE table_1 (
  "federal_provider_number" VARCHAR,
  "ct_credential_number" VARCHAR,
  "level_of_care" VARCHAR,
  "facility_name" VARCHAR,
  "facility_telephone" VARCHAR,
  "address" VARCHAR,
  "town" VARCHAR,
  "county" VARCHAR,
  "state" VARCHAR,
  "ownership_type" VARCHAR,
  "medicare_certified" BOOLEAN,
  "medicaid_certified" BOOLEAN,
  "total_licensed_beds" BIGINT,
  "licensed_ccnh_beds" BIGINT,
  "licensed_ccnh_beds_occupied" BIGINT,
  "licensed_rhns_beds" DOUBLE,
  "licensed_rhns_beds_occupied" DOUBLE,
  "ccnh_room_rate_private_1_bed" DOUBLE,
  "ccnh_room_rate_semi_private_2_beds" DOUBLE,
  "ccnh_room_rate_3_4_beds" DOUBLE,
  "rhns_room_rate_private_1_bed" DOUBLE,
  "rhns_room_rate_semi_private_2_beds" DOUBLE,
  "rhns_room_rate_3_4_beds" DOUBLE,
  "total_number_of_patients" BIGINT,
  "n__18" BIGINT,
  "n_18_24" BIGINT,
  "n_25_34" BIGINT,
  "n_35_44" BIGINT,
  "n_45_54" BIGINT,
  "n_55_64" BIGINT,
  "n_65_74" BIGINT,
  "n_75_84" BIGINT,
  "n_85_94" BIGINT,
  "n_95_and_older" BIGINT,
  "unknown_age" BIGINT,
  "male" BIGINT,
  "female" BIGINT,
  "unknown_gender" BIGINT,
  "married" BIGINT,
  "never_married" BIGINT,
  "widowed" BIGINT,
  "separated" BIGINT,
  "divorced" BIGINT,
  "unknown_marital_status" DOUBLE,
  "white" BIGINT,
  "african_american" BIGINT,
  "hispanic_or_latino_origin" BIGINT,
  "american_indian_or_alaskan_native" BIGINT,
  "asian_or_pacific_islander" BIGINT,
  "other_or_unknown" BIGINT,
  "medicaid_fee_for_service_ct" BIGINT,
  "medicaid_fee_for_service_out_of_state" BIGINT,
  "medicaid_managed_care_out_of_state" BIGINT,
  "medicaid_pending_ct" BIGINT,
  "medicaid_pending_out_of_state" BIGINT,
  "medicare_fee_for_service_traditional" BIGINT,
  "medicare_managed_care" BIGINT,
  "veterans_administration" BIGINT,
  "ccrc_life_care" BIGINT,
  "long_term_care_insurance_ct_partnership_for_long_term_care" BIGINT,
  "long_term_care_insurance_not_ct_partnership" BIGINT,
  "private_insurance_not_long_term_care" BIGINT,
  "private_pay_no_insurance" BIGINT,
  "unknown_payment_source" DOUBLE,
  "reporting_year" BIGINT,
  "new_georeferenced_column" VARCHAR
);