How to Pull Code Violation County Data for Queens County, NY
A code violation list shows cases a city opens when a property breaks local building or safety rules. To find code violation records for Queens County, New York (NY), use NYC Open Data. No account is needed. It is free to use. No VPN is needed. You can download a CSV file.
Also known as: code enforcement, code enforcement cases, building code violations.
What you need
What it is
New York City housing violations written by the Department of Housing Preservation and Development against rental buildings.
Why it matters
An open violation means the problem is not fixed yet. Class C is the most serious, and owners with many of them may be open to selling.
The fields you get
- Violation ID
- Borough
- House number
- Street name
- Apartment
- ZIP (Postcode)
- Block and lot
- Class
- Inspection date
- Violation status
- Description (NOVDescription)
The page says daily. It showed Last Updated November 4, 2026.
Follow these 7 steps
-
Open the violations page
Go to Housing Maintenance Code Violations. It covers all of New York City and shows Last Updated at the top.
Enlarge
-
Open the query screen
Click the Data tab. Click the Actions button, then click Query data. A table opens with a Filters panel under it.
Enlarge
-
Filter to open violations
Pick ViolationStatus in the box Select a column to filter. In the value box tick Open.
Enlarge
-
Filter to Queens County
Click the plus sign. Pick Borough. Tick the borough name for your county. Bronx County is BRONX, Kings County is BROOKLYN, New York County is MANHATTAN, Queens County is QUEENS, Richmond County is STATEN ISLAND. -
Make the list smaller
Click the plus sign again. Pick Class and tick C. Class C means immediately hazardous. Click Apply and wait. This data is very large, so it can take a minute. -
Put the newest records first
Find the InspectionDate column. Click the three lines next to its name, then click Sort descending.
Enlarge
-
Download the file
Click Export. Keep Download file and CSV. Click Download. Open the file in Excel or Google Sheets.
Enlarge
Tip: If you see Large dataset warning, your file is too big for Excel. Add one more filter first.
Watch out for these
- The file can be huge. On November 4, open violations alone were about 1,210,000 in Brooklyn, 661,000 in the Bronx, 494,000 in Queens, 449,000 in Manhattan and 69,000 in Staten Island. Filter before you export.
- Without a Class or other filter, the Brooklyn export is too big for Excel. With Open and Class C, Brooklyn was about 224,000 rows.
- There is no owner name. Use Block and Lot, or BBL, to find the owner in NYC property records.
- One building can have many rows. Remove duplicates by address if you want one row per property.
Common questions
Which county is Brooklyn?
Other lists in Queens County
We only have this list for Queens County so far. See all New York guides.
Code Violation in other New York areas
More New York guides
Code Violation in other states
See every guide
Do not want to do this by hand?
CountyPull pulls this list for you automatically.