How to Pull Code Violation County Data for DeKalb County, GA

The fields you get

• Application number
• Status
• Process state
• Address with city and ZIP
• Violation description
• Date added

The newest case we saw on November 5 was added November 4, 2026.

Follow these 5 steps

1. 1

   Open the DeKalb Code Cases page

   Go to DeKalb Code Cases. This is a plain city data page. It shows the list of columns.

   Enlarge
2. 2

   Open the query form

   Scroll to the bottom of the page. Click the link Query.

   Enlarge
3. 3

   Fill the top of the form

   In Where type status='Open'. In Out Fields type applicationNumber,status,processState,address_displayText,codeViolations_0__description,addedDateTime.

   Enlarge
4. 4

   Fill the bottom of the form

   In Order By Fields type addedDateTime DESC. Set Format to HTML. Click Query (GET).

   Enlarge
5. 5

   Copy your records

   The page shows # records, then one block per case. Select the blocks you need and paste them into a sheet.

   Enlarge

Watch out for these

• There is no download button. You copy from the screen.
• The date shows as a long number. In Excel, put this formula next to it to get a real date: =A1/86400000+25569. Change A1 to your cell and format the result as a date.
• The page shows 2,000 records at a time, and there are about 3,000 open cases. Use 2000 in Result Offset to see the rest.
• Some cases have no violation description. Of the open cases, about 2,300 had one.
• The county Permit and Application Tracker map also has a list called Open Code Cases, past 30 days. When we checked, its newest case was from April 2026, so do not rely on it.
• There is no owner name. Use the address on the county tax site.

Other lists in DeKalb County

We only have this list for DeKalb County so far. See all Georgia guides.