How to Pull Code Violation County Data for Hartford County, CT

The fields you get

• Case number
• Parcel ID
• Address
• Unit
• Record type
• Record status
• Date opened
• Date closed
• Property owner
• Contact name
• City
• ZIP

The page says the data updates nightly and the dates on the page do not change.

Follow these 6 steps

1. 1

   Open the Code Enforcement page

   Go to Open Data Hartford. A table opens on the right side of the page.

   Enlarge
2. 2

   Open the filters

   Click the funnel icon on the blue bar next to the table. In the list of columns, tick Record_Status.

   Enlarge
3. 3

   Pick the records you want

   Tick In Violation. The row count drops. We saw 1,921 rows.

   Enlarge
4. 4

   Put the newest records first

   Scroll the table to the right. Click the Date_Opened column name two times. The newest date moves to the top.

   Enlarge
5. 5

   Download the filtered file

   Click the cloud icon on the blue bar. Turn on Toggle Filters so Records shows the word Filtered. Under CSV, click Download.

   Enlarge
6. 6

   Check your records

   Open the CSV in Excel or Google Sheets. Sort it again by date, because the file does not keep the sort from the screen. Keep the case number, address, ZIP, parcel ID, owner and date opened.

Watch out for these

• The CSV can be older than the table on screen. On November 5 the table had 1,921 rows with cases up to 2026-11-03. The CSV had 1,785 rows and stopped at 2026/06/29. Check the newest date in your file.
• If your file is old, copy the newest rows from the table on screen.
• Other open statuses exist, like NOV Issued and Citation Issued. Tick them too if you want more records.
• This is a City of Hartford list, not the whole county.

Other lists in Hartford County

We only have this list for Hartford County so far. See all Connecticut guides.