Ohio · Franklin County (Columbus) · Verified Aug 2026

How do I pull code enforcement case lists in Columbus, Ohio?

The short answer

Columbus code enforcement cases are free on opendata.columbus.gov, the city's official maps and open data portal — no login needed. Open the Code Enforcement Cases dataset, filter the status column to active cases, sort by file date, and download the list as a CSV.

COST FREE LISTS 1 VERIFIED Aug 2026

How do I pull code violations records step by step?

These code enforcement cases are managed by the Columbus Department of Building & Zoning Services and published from 2019 to the present on the city's official maps and open data portal.

Go to the Columbus GIS Open Data site

Navigate to opendata.columbus.gov. This is the City of Columbus's official maps and open data portal — free to browse, no login.

Open the Code Enforcement Cases dataset

Search for Code Enforcement Cases and open the dataset with that name. It holds code enforcement cases managed by the Columbus Department of Building & Zoning Services from 2019 to present — about 300,000 records, refreshed nightly.

Open the data table

Click View data table on the dataset page. Each row is one case, with columns like B1_PER_TYPE (case type, e.g. Environmental Health or Zoning Code Inspection), B1_PER_CATEGORY (e.g. Weeds), the site address, and the parcel number.

Filter to active cases

Open the Filter panel (funnel icon) and filter B1_APPL_STATUS — the case status column — to the open/active statuses so you are not chasing cases that were already resolved.

Sort by newest cases first

Sort the B1_FILE_DD column (the date the case was filed) descending so the freshest enforcement cases are at the top.

Download the list

Click Download and choose CSV to save your filtered list as a spreadsheet.

Record the data

For each lead, capture the case number (B1_ALT_ID), case type (B1_PER_TYPE), status (B1_APPL_STATUS), site address, parcel number (B1_PARCEL_NBR), and the file date (B1_FILE_DD). Use the parcel number in the Franklin County Auditor's property search to pull the owner's name and mailing address.

What property data does Franklin County publish?

Code Violations

opendata.columbus.gov · ArcGIS · FREE

Common questions

Is Columbus code enforcement data free to access?Yes. The Code Enforcement Cases dataset lives on opendata.columbus.gov, the City of Columbus's official maps and open data portal — free to browse with no login. It covers cases from 2019 to the present.

What information does each Columbus code case include?Each row is one case with the case number (B1_ALT_ID), case type (B1_PER_TYPE, such as Environmental Health or Zoning Code Inspection), category (B1_PER_CATEGORY, such as Weeds), status (B1_APPL_STATUS), the site address, the parcel number (B1_PARCEL_NBR), and the file date (B1_FILE_DD).

How do I get just the active Columbus code cases with the newest first?In the Filter panel, set B1_APPL_STATUS — the case status column — to the open/active statuses so you are not chasing cases that were already resolved, then sort B1_FILE_DD (the date the case was filed) descending so the freshest enforcement cases are at the top. Click Download and choose CSV to save the filtered list as a spreadsheet.

How do I find the owner of a property with a Columbus code violation?Each case includes the parcel number (B1_PARCEL_NBR). Use it in the Franklin County Auditor's property search to pull the owner's name and mailing address.

Live in CountyPull for Franklin County right now

List type	Records	New in 30 days
Code Violation	26,708	26,708
Foreclosure	1	0

Want these lists without the clicking?

CountyPull pulls Franklin County fresh every morning — cleaned, deduped, skip-trace ready. The free plan includes 100 rows every month.

Get 100 Free Leads →

Nearby counties

Cuyahoga County (Cleveland) Hamilton County (Cincinnati) Marion County Montgomery County (Dayton) Summit County (Akron)