Readme
Updated 6 days ago
‧ Indexed 5 hours ago
Charges
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.
Columns
Name | Socrata field name | Column name in sgr mount | Data type | Description |
---|---|---|---|---|
Description | description | description | Text | Additional description of the location of the business. |
Charge | charge | charge | Text | Charge description and legal code. |
Latitude | latitude | latitude | Number | Latitude of business’s address. |
Business Name | business_name | business_name | Text | Primary Business Name |
Violation Date | violation_date | violation_date | Calendar date | Date when violation occurred. |
Industry | industry | industry | Text | The category that describes the business. |
Borough | borough | borough | Text | The borough where the business is located. |
Counts Settled | counts_settled | counts_settled | Text | Number of charges settled or cured. |
Counts Not Guilty | counts_not_guilty | counts_not_guilty | Text | Number of charges found not guilty. |
Unit | unit | unit | Text | The unit number of the business’s address. |
State | state | state | Text | The state where the business is located. |
Longitude | longitude | longitude | Number | Longitude of business’s address. |
Zip | zip | zip | Text | The zip code where the business is located. |
Unit Type | unit_type | unit_type | Text | The unit type of the business’s address (e.g., Apartment/Suite/Other). |
Counts Guilty | counts_guilty | counts_guilty | Text | Number of charges found guilty via decision. |
Charge Count | charge_count | charge_count | Text | Number of charges of this type. |
Street | street | street | Text | The street name of the business’s address. |
Outcome | outcome | outcome | Text | Result after a charge has been adjudicated or settled. |
Building Number | building_number | building_number | Text | The building number of the business’s address. |
City | city | city | Text | The city where the business is located. |
Street 2 | street_2 | street_2 | Text | The cross-street of the business’s address. |
Record ID | record_id | record_id | Text | An identification number assigned by DCA to record each charge against a business. For DCA office tracking purposes. |
Certificate Number | certificate_number | certificate_number | Text | Certificate number issued to the business upon inspection. Note that there may be multiple certificate numbers for a single inspection. |
Upstream Metadata