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

A code violation list shows cases a city opens when a property breaks local building or safety rules. To find code violation records for Franklin County, Ohio (OH), use Columbus GIS 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.

Verified November 5, 2026 5 steps Columbus GIS Open Data
See the steps Open the site

What you need

Account
No account needed
Cost
Free
CAPTCHA
No CAPTCHA
Export
CSV download
VPN
No VPN needed

What it is

Code enforcement cases from the City of Columbus Department of Building and Zoning Services, from 2019 to now. This covers Columbus only, not all of Franklin County.

Why it matters

An open code case can mean a neglected or vacant house, and an owner who may want out. Fines and repair orders add pressure to sell.

The fields you get

  • B1_ALT_ID (case number)
  • B1_PER_TYPE (case type)
  • B1_PER_CATEGORY
  • SITE_ADDRESS
  • B1_PARCEL_NBR (parcel)
  • B1_APPL_STATUS (status)
  • B1_FILE_DD (file date)
  • INSP_LAST_DATE
  • INSP_LAST_RESULT

The page says it updates nightly. The newest file date we saw on November 5 was November 2, 2026.

Follow these 5 steps

  1. Open the Columbus code enforcement table

    Go to Columbus GIS Open Data. The table opens on the right. It shows 321,167 rows.
    Screenshot of Columbus GIS Open Data, step 1: Open the Columbus code enforcement table Enlarge

  2. Filter to the open cases

    Click the funnel icon. In the list, tick B1_APPL_STATUS. Then tick Active. The count at the top changes to 11,540.
    Screenshot of Columbus GIS Open Data, step 2: Filter to the open cases Enlarge

  3. Put the newest cases first

    Scroll the table to the right. Click the B1_FILE_DD column name two times. The newest dates move to the top.
    Screenshot of Columbus GIS Open Data, step 3: Put the newest cases first Enlarge

  4. Keep your filter for the download

    Click the download icon (cloud with an arrow). Turn on Toggle Filters. The record count must now say (Filtered).
    Screenshot of Columbus GIS Open Data, step 4: Keep your filter for the download Enlarge

  5. Download the CSV

    Under CSV, click Download. Wait for the file to save, then open it in Excel or Google Sheets. You now have the list.

Watch out for these

  • Column names are codes. B1_ALT_ID is the case number and B1_FILE_DD is the file date.
  • Other open statuses are Court and Civil Injunction. Tick them too if you want them.
  • There is no owner name. Use the parcel number on the Franklin County property site.
  • If Toggle Filters is off, you get the whole table, not your filtered rows.

Common questions

Is this list free?
Yes. Columbus GIS Open Data is free and no account is needed.
Does the file show the owner?
No. Use the address or parcel number on the county property site to find the owner.

Other lists in Franklin County

ForeclosureFranklin County, OH

Code Violation in other Ohio areas

Hamilton County

More Ohio guides

Gallia County ForeclosureGeauga County ForeclosureGreene County ForeclosureGuernsey County ForeclosureHamilton County ForeclosureHancock County ForeclosureHardin County ForeclosureHarrison County Foreclosure

Code Violation in other states

Allegheny County, PALehigh County, PATarrant County, TXTravis County, TXVirginia Beach City, VAClark County, WAKing County, WAMilwaukee County, WI

See every guide

All Ohio guides 81 All Code Violation guides 40

Do not want to do this by hand?

CountyPull pulls this list for you automatically.

Start free 100 free rows each month