About this Dataset

Alcohol License Business Locations

The dataset contains locations and attributes of Liquor Licensees provided by the Alcoholic Beverage and Cannabis Administration (ABCA). For further information visit https://abca.dc.gov/.
Organization: District of Columbia
Last updated: 2024-04-30T17:37:50.245726
Tags: abca, alcohol, alcoholic-beverage, dc, district-of-columbia, licensee, liquor-license, washington-dc

Tables

Table 1

@usgov.district_of_columbia_liquor_licenses_45a2f.table_1

397.93 kB
2,421 rows
43 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "license" VARCHAR,
  "applicant" VARCHAR,
  "trade_name" VARCHAR,
  "class" VARCHAR,
  "address" VARCHAR,
  "zipcode" DOUBLE,
  "ward" VARCHAR,
  "anc" VARCHAR,
  "smd" VARCHAR,
  "status" VARCHAR,
  "type" VARCHAR,
  "brew_pub" VARCHAR,
  "entertainment" VARCHAR,
  "sales_consumption" VARCHAR,
  "sidewalk_cafe" VARCHAR,
  "summer_garden" VARCHAR,
  "tasting" VARCHAR,
  "wine_pub" VARCHAR,
  "covercharge" VARCHAR,
  "dancing" VARCHAR,
  "offpremisestorage" VARCHAR,
  "storagefacility" VARCHAR,
  "distillery_pub" VARCHAR,
  "total_capacity" DOUBLE,
  "games_of_skill" VARCHAR,
  "sports_waggering" VARCHAR,
  "carryout_delivery" VARCHAR,
  "streatery" VARCHAR,
  "expiration_date" TIMESTAMP,
  "co_capacity" DOUBLE,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "mar_id" DOUBLE,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "created" TIMESTAMP,
  "edited" TIMESTAMP,
  "shape" VARCHAR,
  "objectid" BIGINT
);