Baselight

Alcohol License Cancellations

District of Columbia

@usgov.district_of_columbia_liquor_license_cancellations

Loading...
Loading...

About this Dataset

Alcohol License Cancellations

This dataset represents ABCA liquor license cancellations. Cancellations are processed at the request of the licensee or administratively when a licensee fails to pay annual and renewal fees. Data is updated as ABCA completes renewal and annual payment cycles.
Organization: District of Columbia
Last updated: 2024-04-30T17:37:35.641841
Tags: abca, alcohol, beverage, business, dc, liquor, liquor-license, restaurant, washington-dc

Tables

Table 1

@usgov.district_of_columbia_liquor_license_cancellations.table_1
  • 140.24 KB
  • 827 rows
  • 26 columns
Loading...

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "license" VARCHAR,
  "applicant" VARCHAR,
  "trade_name" VARCHAR,
  "address" VARCHAR,
  "zipcode" DOUBLE,
  "mar_ward" VARCHAR,
  "anc" VARCHAR,
  "smd" VARCHAR,
  "class" VARCHAR,
  "type" VARCHAR,
  "cancellation_date" TIMESTAMP,
  "reason" VARCHAR,
  "xcoord" DOUBLE,
  "ycoord" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "mar_id" BIGINT,
  "gis_id" VARCHAR,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" TIMESTAMP,
  "editor" VARCHAR,
  "edited" TIMESTAMP,
  "objectid" BIGINT
);

Share link

Anyone who has the link will be able to view this.