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

195.94 kB
2,580 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: PRIVATE (1 BED),
  "ccnh_room_rate_semi_private_2_beds" DOUBLE  -- CCNH Room Rate: SEMI-PRIVATE (2 BEDS),
  "ccnh_room_rate_3_4_beds" DOUBLE  -- CCNH Room Rate: 3 - 4 BEDS,
  "rhns_room_rate_private_1_bed" DOUBLE  -- RHNS Room Rate: PRIVATE (1 BED),
  "rhns_room_rate_semi_private_2_beds" DOUBLE  -- RHNS Room Rate: SEMI-PRIVATE (2 BEDS),
  "rhns_room_rate_3_4_beds" DOUBLE  -- RHNS Room Rate: 3 - 4 BEDS,
  "total_number_of_patients" BIGINT,
  "n__18" BIGINT  -- <18,
  "n_18_24" BIGINT  -- 18 - 24,
  "n_25_34" BIGINT  -- 25 - 34,
  "n_35_44" BIGINT  -- 35 - 44,
  "n_45_54" BIGINT  -- 45 - 54,
  "n_55_64" BIGINT  -- 55 - 64,
  "n_65_74" BIGINT  -- 65 - 74,
  "n_75_84" BIGINT  -- 75 - 84,
  "n_85_94" BIGINT  -- 85 - 94,
  "n_95_and_older" BIGINT  -- 95 And Older,
  "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 -- CT,
  "medicaid_fee_for_service_out_of_state" BIGINT  -- Medicaid Fee-for-service -- Out Of State,
  "medicaid_managed_care_out_of_state" BIGINT  -- Medicaid Managed Care -- Out Of State,
  "medicaid_pending_ct" BIGINT  -- Medicaid Pending -- CT,
  "medicaid_pending_out_of_state" BIGINT  -- Medicaid Pending -- Out Of State,
  "medicare_fee_for_service_traditional" BIGINT  -- Medicare Fee-for-service (traditional),
  "medicare_managed_care" BIGINT,
  "veterans_administration" BIGINT,
  "ccrc_life_care" BIGINT  -- CCRC -- Life Care,
  "long_term_care_insurance_ct_partnership_for_long_term_care" BIGINT  -- Long-term Care Insurance -- CT Partnership For Long-Term Care,
  "long_term_care_insurance_not_ct_partnership" BIGINT  -- Long-Term Care Insurance -- Not CT Partnership,
  "private_insurance_not_long_term_care" BIGINT  -- Private Insurance (not Long-term Care),
  "private_pay_no_insurance" BIGINT  -- Private Pay (no Insurance),
  "unknown_payment_source" DOUBLE,
  "reporting_year" BIGINT,
  "new_georeferenced_column" VARCHAR
);