Name: Current SLA Inactive Licenses
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Current SLA Inactive Licenses

Liquor Authority Inactive Licenses
Organization: State of New York
Last updated: 2023-12-01T21:58:15.216295
Tags: abc, alcohol, liquor-authority

Tables

Table 1

@usgov.state_of_new_york_current_sla_inactive_licenses.table_1

4.91 MB
60,169 rows
19 columns

CREATE TABLE table_1 (
  "license_permit_id" VARCHAR,
  "premises_county" VARCHAR,
  "type" BIGINT,
  "class" BIGINT,
  "description" VARCHAR,
  "legalname" VARCHAR,
  "dba" VARCHAR,
  "actual_address_of_premises" VARCHAR,
  "additional_address_information" VARCHAR,
  "city" VARCHAR,
  "state_name" VARCHAR,
  "zip_code" BIGINT,
  "original_issue_date" TIMESTAMP,
  "last_issue_date" TIMESTAMP,
  "effective_date" TIMESTAMP,
  "expiration_date" TIMESTAMP,
  "legacy_serial_number" DOUBLE,
  "aka_address" VARCHAR,
  "georeference" VARCHAR
);