About this Dataset

Substance Abuse Care Facilities

Licensed Substance Abuse Care facilities derived from Licenses and Credentials recorded in Connecticut's eLicensing system. Includes active and inactive licenses.

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: 2021-08-07T13:15:04.159940
Tags: credentials, elicense, licenses, substance-abuse

Tables

Table 1

@usgov.state_of_connecticut_substance_abuse_care_facilities.table_1

79.48 KB
619 rows
22 columns


CREATE TABLE table_1 (
  "credential_id" BIGINT,
  "name" VARCHAR,
  "type" VARCHAR,
  "business_name" VARCHAR,
  "dba" VARCHAR,
  "full_credential_code" VARCHAR,
  "credential_type" VARCHAR,
  "credential_number" VARCHAR,
  "credential_subcategory" VARCHAR,
  "credential" VARCHAR,
  "status" VARCHAR,
  "status_reason" VARCHAR,
  "active" BIGINT,
  "issue_date" TIMESTAMP,
  "effective_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" BIGINT,
  "record_refreshed_on" TIMESTAMP,
  "geocode" VARCHAR
);