About this Dataset

Assisted Living Service Agencies

Assisted Living Service Agencies derived from Licenses and Credentials recorded in Connecticut's eLicensing system.

This dataset is pulled from the full State Licenses and Credentials dataset: https://data.ct.gov/Business/State-Licenses-and-Credentials/ngch-56tr/data

Updated daily.
Organization: State of Connecticut
Last updated: 2020-11-12T14:56:29.873283
Tags: assisted-living-facilities, credentials, elicense, licenses

Tables

Table 1

@usgov.state_of_connecticut_assisted_living_service_agencies.table_1

44.31 kB
250 rows
22 columns

CREATE TABLE table_1 (
  "credentialid" BIGINT,
  "name" VARCHAR,
  "type" VARCHAR,
  "businessname" VARCHAR,
  "dba" VARCHAR,
  "fullcredentialcode" VARCHAR,
  "credentialtype" VARCHAR,
  "credentialnumber" VARCHAR,
  "credentialsubcategory" VARCHAR,
  "credential" VARCHAR,
  "status" VARCHAR,
  "statusreason" VARCHAR,
  "active" BIGINT,
  "issuedate" VARCHAR,
  "effectivedate" VARCHAR,
  "expirationdate" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "recordrefreshedon" VARCHAR,
  "new_georeferenced_column" VARCHAR
);