Dataset
Archived DCWP Charges
nyc.wyj6-frpa
Ask your agent
Use escrito dataset nyc.wyj6-frpa
Connect an agent at https://data.escrito.io/mcp
About
An archival list of all charges and their outcomes in DCWP's Accela system. This data set features DCA-issued charges to ensure compliance with local consumer protection and licensing laws, and State and federal regulations. For the current list of charges, please refer to https://data.cityofnewyork.us/d/5fn4-dr26
Cite as: Department of Consumer and Worker Protection (DCWP). Archived DCWP Charges. https://data.cityofnewyork.us/d/wyj6-frpa
- Publisher
- City of New York
- Tier
- Official
- Covers
- not stated
- Places
- New York City
- Updated
- never
- Last modified
- 2025-02-11
- Units
- not stated
- License
- NYC Open Data Terms of Use
- Method
- https://data.cityofnewyork.us/d/wyj6-frpa
Columns
| Name | Type | Description |
|---|---|---|
| industry | text | The category that describes the business. |
| ct2020 | number | The Census Tract (Census 2020) is a small, relatively permanent statistical subdivisions of a county uniquely numbered in each county with a numeric code. Note: as part of the geocoding process, leading and trailing zeros are dropped. |
| cert_nbr | text | An identification number assigned by DCWP to record each charge against a business. For DCWP office tracking purposes. Certificate number issued to the business upon inspection. Note that there may be multiple certificate numbers for a single inspection. |
| biz_name | text | Primary Business Name. |
| bbl | number | The BBL (Borough, Block, and Lot) is a combination of three numeric codes -- a 1-digit borough number, a block number (up to 5 digits) and a lot number (up to 4 digits) - designated and modified by the Department of Finance (DOF). BBLs are used by various city agencies to identify real estate for taxes, zoning, construction, and other purposes. |
| vio_dt | calendar_date | Date when violation occurred. |
| bldg_nbr | text | The building number of the business’s address. |
| x_coord | number | X Coordinate of business’s address. |
| ct_not_glty | text | Number of charges found not guilty. |
| ct_guilty | number | Number of charges found guilty via decision. |
| bin | number | The BIN (Building Identification Number) is a unique 7-digit number assigned to every known building by the Department of City Planning (DCP), the first digit of which is the borough code. BINs allow city agencies to process and match building-related data easily and in a consistent manner. |
| council_district | number | The City Council is the lawmaking body of NYC, on equal footing with the mayor in terms of governing power. Besides legislating, the Council has sole approval power over the city budget, and is the final decision-maker in land use matters. There are 51 City Council members in total, each representing a unique geographical area, called a Council District. |
| city | text | The city where the business is located. |
| nta2020 | text | The Neighborhood Tabulation Area (Census 2020) are small area boundaries, created by the Department of City Planning (DCP) to aggregate population projections in a small area. Each NTA approximates a minimum population of 15,000. While NTAs were initially created to support PlaNYC, the thirty-year (2000-2030) sustainability plan for NYC, NTAs are now also being used to present data from the Decennial Census and American Community Survey. NTA boundaries and their associated names do not definitively represent neighborhood boundaries. |
| descr | text | Additional description of the location of the business. |
| unit | number | The unit number of the business’s address. |
| y_coord | number | Y Coordinate of business’s address. |
| unit_typ | text | The unit type of the business’s address (e.g., Apartment/Suite/Other). |
| street2 | text | The cross-street of the business’s address. |
| ct_settl | number | Number of charges settled or cured. |
| state | text | The state where the business is located. |
| street | text | The street name of the business’s address. |
| outcome | text | Result after a charge has been adjudicated or settled based on the key. |
| chrg_ct | number | Number of charges of this type. |
| latitude | number | Latitude of the business’s address. |
| chrg | text | Charge description and legal code. |
| longitude | number | Longitude of the business’s address. |
| zip | text | The zip code where the business is located. |
| community_board | number | Community Boards are volunteer-run neighborhood organizations that work on all kinds of issues pertinent to their communities, often working with elected city officials in doing so. Community Board members, who can be as young as 16, are appointed by Borough Presidents and City Council representatives. They serve two-year terms. There are 59 Community Boards in NYC, each of which represents a unique geographical area, known as a Community District. Note: as a column header, “Community Board” (which refers to a group of Board members) is often used to mean “Community District” (the geographical area) instead. |
| boro | text | The borough where the business is located. |
| rec_id | text | An identification number assigned by DCWP to record each charge against a business. For DCWP office tracking purposes. |