How to Pull Code Violation County Data for Philadelphia County, PA
A code violation list shows cases a city opens when a property breaks local building or safety rules. To find code violation records for Philadelphia County, Pennsylvania (PA), use OpenDataPhilly. 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.
What you need
What it is
Violations written by the Philadelphia Department of Licenses and Inspections.
Why it matters
An owner in violation may face fines and repair costs. The file already includes the owner name.
The fields you get
- Case number
- Case status
- Violation date
- Violation code title
- Address
- Unit
- ZIP
- OPA account number
- Owner name
The dataset page says updated daily. The newest row we saw was dated November 3, 2026.
Follow these 6 steps
-
Look at the data files
Scroll to Resources. You will see a CSV file for each group of years. The file for 2019 to present is very large, about 376 MB.
Enlarge
-
See the charts if you want
Click L&I Violations (Visualization) to see charts by date, type and status. Do not use the Download button on that page. It led to a page not found when we tried it.
Enlarge
-
Download a smaller file
Click this link: Open violations since January 2025. It asks the city data site for rows still marked IN VIOLATION, newest first. We got about 61,000 rows and a 33 MB file.Tip: To get another period, download a year file from Resources and filter it in Excel. -
Open the file
Open the CSV in Excel or Google Sheets. The address is in address and the ZIP is in zip. Sample rows from the downloaded file, owner columns left out. This image is not a site screenshot.
Enlarge
-
Save your records
Keep casenumber, violationcodetitle, violationdate, address, zip, opa_account_num and opa_owner. Save the sheet.
Watch out for these
- The Download button on the visualization page led to a page not found on November 5. Use the links on the dataset page.
- The year files are large. Excel may be slow with them, so use the smaller link.
- Some owners are public bodies, such as the city, the school district or the redevelopment authority. Remove them if they are not leads for you.
Other lists in Philadelphia County
We only have this list for Philadelphia County so far. See all Pennsylvania guides.
Code Violation in other Pennsylvania areas
Code Violation in other states
See every guide
Do not want to do this by hand?
CountyPull pulls this list for you automatically.