Doc: Tobacco & Liquor - wimlds/smart_cities GitHub Wiki

New York State provides multiple data sets on it's data portal. These are just two of them. The liquor data set provides a list of all active liquor lisencees in the state (updated quarterly) and the tobacco data set is a list of all active tobacco vendors.

---

Liquor Data Set

Table path: `smart_cities_data.liquor_licenses`

Shape: 50,792 rows, 21 columns

Column Name	Explanation
License_Serial_Number	Integer
License_Type_Name	String
License_Class_Code	Integer
License_Type_Code	String
Agency_Zone_Office_Name	String
Agency_Zone_Office_Number	Integer
County_Name_Licensee	String
Premises_Name	String
Doing_Business_As_DBA	String
Actual_Address_of_Premises_Address1	String
Additional_Address_Information_Address2	String
City	String
State	String
Zip	String
License_Certificate_Number	Integer
License_Original_Issue_Date	String
License_Effective_Date	String
License_Expiration_Date	String
Latitude	Float
Longitude	Float
Location	String

Tobacco Data Set

Table path: `smart_cities_data.tobacco_vendors`

Shape: 10,537 rows, 11 columns

Column Name	Explanation
LOCAL_HEALTH_UNIT	String
OPERATION_NAME	String
ADDRESS	String
CITY	String
STATE	String
ZIP	Integer
MUNCIPALITY	String
COUNTY	String
VENDOR_TYPE	String
CREATION_DATE	Date
LOCATION	String