How do you get property lead lists in Philadelphia?
Philadelphia offers both lists free through opendataphilly.org: L&I code violations (browsable at data.phila.gov and downloadable as CSV) and real estate tax delinquencies, a property-level spreadsheet with owner names, addresses, OPA account numbers, amounts due, and years owed.
How do I pull code violations records step by step?
The Department of Licenses and Inspections issues code violations across Philadelphia, and owners of properties still in violation often face fines and repair costs that make them motivated sellers.
Go to OpenDataPhilly
Navigate to opendataphilly.org, the official open data catalog for the City of Philadelphia. Use the search box and search for Licenses and Inspections Code Violations.
Open the L&I Code Violations dataset
Open the dataset named Licenses and Inspections Code Violations. These are code violations issued by the Department of Licenses and Inspections, updated daily.
Explore the data in the L&I Violations viewer
Click the L&I Violations (Visualization) link, or go straight to data.phila.gov/visualizations/li-violations. This viewer charts violations by date, description, owner, and status, and has a Download button in the top-right corner.
Filter to active violations
You only want properties that are still out of compliance. Filter the Status field to IN VIOLATION so closed and resolved cases drop out, and focus on the most recent Violation Date entries first.
Download the CSV
Back on the dataset page, scroll to the Resources section and click the L&I Violations (CSV) link covering the most recent date range (2019 to present). Open the file in Excel or Google Sheets, filter the casestatus column to IN VIOLATION, and sort violationdate newest first.
Record the Data
For each lead, capture the case number, violation type (violation code title), case status, owner name, property address and ZIP, the OPA account number (the parcel ID), and the violation date. Owners of properties sitting in violation often face fines and repair costs, which makes them motivated sellers.
How do I pull tax delinquent records step by step?
Philadelphia's Revenue Department publishes real estate tax balances on opendataphilly.org, and owners several years behind on property taxes risk a sheriff sale, which is what makes this list worth working.
Go to OpenDataPhilly
Navigate to opendataphilly.org, the official open data catalog for the City of Philadelphia. Search for Real Estate Tax Balances.
Open the Real Estate Tax Balances dataset
Open the dataset named Real Estate Tax Balances, published by the Revenue Department. It covers accounts with overdue balances and true tax delinquencies — accounts still unpaid for previous tax years.
Review the download options
Scroll to the Resources section. The portal offers summary spreadsheets — Tax Balances by ZIP Code, by Council District, and by Census Tract — which are handy for spotting which neighborhoods carry the most delinquency before you drill down.
Download the property-level delinquency list
For the full property-by-property list, use the city's delinquency extract: download the Real Estate Tax Delinquencies spreadsheet. It contains one row per delinquent account, including the owner and property address.
Filter to serious, workable delinquencies
Open the file in Excel or Google Sheets. Filter the total_due column to greater than 1000 and the is_actionable column to true (accounts not shielded by a payment agreement or bankruptcy). Sort by total_due or num_years_owed, largest first, to surface the most distressed owners.
Record the Data
For each lead, capture the owner name, property address and ZIP, the OPA account number (the parcel ID), the total amount due, and the number of years owed. Owners several years behind on property taxes risk a sheriff sale and are often open to an offer.
What property data does Philadelphia County publish?
| Code Violations | opendataphilly.org · Carto · FREE |
| Tax Delinquent | opendataphilly.org · Carto · FREE |
Common questions
Live in CountyPull for Philadelphia County right now
| List type | Records | New in 30 days |
|---|---|---|
| Tax Delinquent | 27,448 | 27,448 |
| Code Violation | 15,780 | 15,780 |
| Lis Pendens | 59 | 0 |
CountyPull pulls Philadelphia County fresh every morning — cleaned, deduped, skip-trace ready. The free plan includes 100 rows every month.
Get 100 Free Leads →