Request
I am looking for data that's currently available through Open Data, but just older years. I'd like as much available as possible for each (all geographic identifiers, DCA License #, inspection result):
-Tobacco retailers that had an active license between 2016 and 2017 (for any period of time)
-Inspections of tobacco retailers between 2016 and 2017
NEW QUESTIONS! Thank you so much for responding to my requests and questions. I have one other question at the moment. I noticed that the Inspections data doesn't have as much information as I'd need for my analysis. Is it possible to get geographic information (CT, CD, Lat, Long) and DCA license number for the inspections dataset? Also, the CT variable is hard to use without a decimal place present. Do you have a decimal version of CT and/or have a recommendation as to how to use this variable when there is no decimal present? I greatly appreciate your help!
Take care,
*****
What predictors are associated with the locations of tobacco and e-cigarette retail dealers
Response
Original:
You can filter the “Legally Operating Businesses” (https://data.cityofnewyork.us/Business/Legally-Operating-Businesses/w7w3-xahh) dataset to identify businesses that had an active license at any given time by filtering on,
• Industry (if you are interested in a particular industry)
• License Expiration Date (is greater than or equal to the start date of the time period they are interested in), and
• License Creation Date (is less than or equal to the end date of the time period they are interested in).
For example, to find active tow truck companies between 2015 and 2016, your filters would be:
• Industry = “Tow Truck Company”
• License Expiration Date >= January 1, 2015
• License Creation Date <= December 31, 2016
To further refine your dataset, you can join these licenses to the “License Revocations, Suspensions, Surrenders and Reinstatements” (https://data.cityofnewyork.us/Business/License-Revocations-Suspensions-Surrenders-and-Rei/rpeq-j89e) dataset to identify acute periods of licenses being inactive.
Also, we have updated the “Inspections” (https://data.cityofnewyork.us/Business/Inspections/jzhd-m6uv) open dataset to include all inspections dating back to January 2014. The dataset should be updated on the next scheduled refresh on December 11th. Thank you,
- NYC DCA Open Data
-------------------------------------------------------------------------
After edit:
The Inspections dataset is currently under review and updates are expected to be available by the end of 2021. Proposed enhancements to the dataset include the geographic information included in this request and the license number, where applicable. We are not able to provide the CT data in any format other than what is captured in our systems.
Thank you,
- NYC DCWP Open Data