How to Pull Code Violation County Data for Hamilton County, OH

The fields you get

• Case number (NUMBER_KEY)
• Complaint type
• Sub type
• Entered date
• Status
• Status class
• Neighborhood
• Full address
• Link to case

The page says daily. The newest entry date we saw on November 4 was November 2, 2026.

Follow these 6 steps

1. 1

   Open the Code Enforcement page

   Go to City of Cincinnati Code Enforcement. The page shows when the data was last updated.

   Enlarge
2. 2

   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
3. 3

   Filter the list

   Pick DATA_STATUS_DISPLAY in the box Select a column to filter. In the value box type Orders Issued and tick it. Click Apply. The row count drops to the orders.

   Enlarge
4. 4

   Put the newest records first

   Find the ENTERED_DATE column. Click the three lines next to its name, then click Sort descending.

   Enlarge
5. 5

   Download the file

   Click Export. Keep Download file and CSV selected. Click Download. Only your filtered rows go in the file.

   Enlarge
6. 6

   Check your records

   Open the CSV in Excel or Google Sheets. We saw 3,789 rows on November 4. Keep NUMBER_KEY, COMP_TYPE_DESC, SUB_TYPE_DESC, FULL_ADDRESS and ENTERED_DATE.

   Enlarge

Watch out for these

• The list has about 773,000 rows and many are closed or duplicates. Always filter first.
• Other useful status values include Citation Issued and Refer to Abandoned Property Program.
• Some rows are abandoned vehicles, not buildings. Filter COMP_TYPE_DESC if you only want property problems.
• There is no owner name. Use the address on the Hamilton County Auditor site.
• This is a City of Cincinnati list, not all of Hamilton County.

Other lists in Hamilton County