Icon for Socrata external plugin
Updated 4 days ago
Indexed 2 hours ago


This data set features DCA inspections during the last and current calendar years to ensure compliance with local consumer protection and licensing laws, and State and federal regulations.


NameSocrata field nameColumn name in sgr mountData typeDescription
Inspection Resultinspection_resultinspection_resultTextResult of inspection (e.g., No Violation Issued, Violation Issued, Pass, Fail). Refer to Appendix A for details.
Inspection Dateinspection_dateinspection_dateCalendar dateDate when DCA conducted inspection.
Business Namebusiness_namebusiness_nameTextPrimary Business Name
Certificate Numbercertificate_numbercertificate_numberTextCertificate number issued to the business upon inspection. Note that there may be multiple certificate numbers for a single inspection.
LatitudelatitudelatitudeNumberLatitude of business’s address.
StatestatestateTextThe state where the business is located.
CitycitycityTextThe city where the business is located.
Record IDrecord_idrecord_idTextAn identification number assigned by DCA to record each inspection. For DCA office tracking purposes.
BoroughboroughboroughTextThe borough where the business is located.
ZipzipzipTextThe zip code where the business is located.
StreetstreetstreetTextThe street name of the business’s address.
Street 2street_2street_2TextThe cross-street of the business’s address.
LongitudelongitudelongitudeNumberLongitude of business’s address.
DescriptiondescriptiondescriptionTextAdditional details of the location of the business.
UnitunitunitTextThe unit number of the business.
Unit Typeunit_typeunit_typeTextThe unit type of the business’s address (e.g., Apartment/Suite/Other).
Building Numberbuilding_numberbuilding_numberTextThe building number of the business’s address.
IndustryindustryindustryTextThe category that describes the business.
  • inspections
Upstream Metadata