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

About this Dataset

Grocery Stores

List of geocoded businesses holding a "GROCERY BEER" license from Licenses and Credentials recorded in Connecticut's eLicensing system.
Organization: State of Connecticut
Last updated: 2020-11-12T14:56:02.529538
Tags: credential, license

Tables

Table 1

@usgov.state_of_connecticut_grocery_stores_37fde.table_1

98.53 KB
794 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,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" DOUBLE,
  "new_georeferenced_column" VARCHAR,
  "issuedate" VARCHAR,
  "effectivedate" VARCHAR,
  "expirationdate" VARCHAR,
  "recordrefreshedon" VARCHAR
);