Icon for Socrata external plugin
  • charges
Updated 6 days ago
Indexed 5 hours ago


This data set features DCA-issued charges 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
DescriptiondescriptiondescriptionTextAdditional description of the location of the business.
ChargechargechargeTextCharge description and legal code.
LatitudelatitudelatitudeNumberLatitude of business’s address.
Business Namebusiness_namebusiness_nameTextPrimary Business Name
Violation Dateviolation_dateviolation_dateCalendar dateDate when violation occurred.
IndustryindustryindustryTextThe category that describes the business.
BoroughboroughboroughTextThe borough where the business is located.
Counts Settledcounts_settledcounts_settledTextNumber of charges settled or cured.
Counts Not Guiltycounts_not_guiltycounts_not_guiltyTextNumber of charges found not guilty.
UnitunitunitTextThe unit number of the business’s address.
StatestatestateTextThe state where the business is located.
LongitudelongitudelongitudeNumberLongitude of business’s address.
ZipzipzipTextThe zip code where the business is located.
Unit Typeunit_typeunit_typeTextThe unit type of the business’s address (e.g., Apartment/Suite/Other).
Counts Guiltycounts_guiltycounts_guiltyTextNumber of charges found guilty via decision.
Charge Countcharge_countcharge_countTextNumber of charges of this type.
StreetstreetstreetTextThe street name of the business’s address.
OutcomeoutcomeoutcomeTextResult after a charge has been adjudicated or settled.
Building Numberbuilding_numberbuilding_numberTextThe building number of the business’s address.
CitycitycityTextThe city where the business is located.
Street 2street_2street_2TextThe cross-street of the business’s address.
Record IDrecord_idrecord_idTextAn identification number assigned by DCA to record each charge against a business. For DCA office tracking purposes.
Certificate Numbercertificate_numbercertificate_numberTextCertificate number issued to the business upon inspection. Note that there may be multiple certificate numbers for a single inspection.
Upstream Metadata