ny-gov/liquor-authority-current-list-of-active-licenses-hrvs-fxs2
Icon for Socrata external plugin
 
Preview
  • liquor_authority_current_list_of_active_licenses
     
 
Readme
Updated 12 hours ago
Indexed 6 hours ago

Liquor Authority Current List of Active Licenses

Liquor Authority current list of all active licensees in NYS.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Effective Dateeffective_dateeffective_dateCalendar dateMost recent start date of the license.
OtherotherotherTextOther relevant information
License Expiration Datelicense_expiration_datelicense_expiration_dateCalendar dateDate license expires
License Issued Datelicense_issued_datelicense_issued_dateCalendar dateDate license was issued
Premise Namepremise_namepremise_nameTextCorporate Name of Licensee
Premise Address 2premise_address_2premise_address_2TextAdditional address information
CountycountycountyTextCounty License is located
Serial Numberserial_numberserial_numberNumberUnique Serial Number of Licensee
GeoreferencegeoreferencegeoreferencePointOpen Data/Socrata-generated geocoding information from supplied address components.
Certificate Numbercertificate_numbercertificate_numberNumberUnique Certificate Number for the licensee
Premise Citypremise_citypremise_cityTextCity of licensed premise
Premise Zippremise_zippremise_zipTextZip code of licensed premise
Days/Hours of Operationdays_hours_of_operationdays_hours_of_operationTextHours of Operation of business
Premise Statepremise_statepremise_stateTextState of licensed premise
Premise Addresspremise_addresspremise_addressTextAddress of licensed premise
Method of Operationmethod_of_operationmethod_of_operationTextMethod of Operation of business
License Class Codelicense_class_codelicense_class_codeText3 digit numeric code of license type
License Type Codelicense_type_codelicense_type_codeText1 or 2 character alpha code of license type
ZonezonezoneNumberSLA zone where license is located.
DBAdbadbaTextDoing Business As
Original Dateoriginal_dateoriginal_dateCalendar dateFirst date the license was issued.
New York Zip Codes:@computed_region_wbg7_3whc:@computed_region_wbg7_3whcNumber
NYS Municipal Boundaries:@computed_region_yamh_8v7k:@computed_region_yamh_8v7kNumber
Counties:@computed_region_kjdx_g34t:@computed_region_kjdx_g34tNumber
Upstream Metadata