How to Pull Code Violation County Data for Allegheny 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 Allegheny County, Pennsylvania (PA), use Western Pennsylvania Regional Data Center. 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
You must click to agree to the site terms of use. No account needed.
What it is
Violations and inspections from City of Pittsburgh departments, from June 2020 to now. This covers Pittsburgh only, not all of Allegheny 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
- casefile_number
- case_file_type
- status
- address
- parcel_id
- investigation_date
- investigation_outcome
- violation_description
- docket_number
- court_date
- neighborhood
Follow these 5 steps
-
Open the Violations page
Go to Violations table. A Data Use Agreement box opens. Read it, then click I Agree to the Terms of Use.
Enlarge
-
Download the CSV
Click the dark Download button at the top right. The file saves as CSV. It is large, so wait for it to finish.
Enlarge
-
Look at the table if you want
Click Fullscreen to see the rows on screen. It said 653,152 entries. You do not need this step to get the file.
Enlarge
-
Keep the open cases
Open the file in Excel. Filter the status column to In Violation. We counted 7,683 of those rows on November 5. -
Sort the newest first
Sort investigation_date newest to oldest. You now have the list.
Watch out for these
- A second agreement box can show over the table. Click I Agree in it too.
- Do not use the Historical PLI Violations files. They cover only 2015 to 2020.
- Each case has separate rows for inspections, violations and court, so some dates are blank. Remove duplicate case numbers if you want one row per house.
- In Court and Clean and Lien are also live statuses. Most rows are Closed.
- There is no owner name. Use parcel_id on the Allegheny County property site.
Common questions
Is this list free?
Does the file show the owner?
Other lists in Allegheny County
We only have this list for Allegheny 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.