Name: Pharmacies
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Pharmacies

List of geocoded businesses holding a "PHARMACY" license from Licenses and Credentials recorded in Connecticut's eLicensing system.
Organization: State of Connecticut
Last updated: 2020-11-12T14:53:39.232614
Tags: business, health

Tables

Table 1

@usgov.state_of_connecticut_pharmacies_18398.table_1

68.75 KB
646 rows
22 columns


CREATE TABLE table_1 (
  "credentialid" BIGINT,
  "name" VARCHAR,
  "type" VARCHAR,
  "businessname" VARCHAR,
  "dba" VARCHAR,
  "fullcredentialcode" VARCHAR,
  "credentialtype" VARCHAR,
  "credentialnumber" BIGINT,
  "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
);