Distressed property leads in Chicago, straight out of the city's violation file

The exact signal we pull here

Chicago publishes Building Violations as an open Socrata dataset — 22u3-xenr on data.cityofchicago.org. Every record is a violation written by a Department of Buildings inspector against a specific address.

We filter it to violation_status = 'OPEN' and date it by violation_date. Open means the city has not recorded compliance: the case is still live, the owner still has an obligation, and in most cases there is still a hearing or a re-inspection ahead of them. Closed and complied cases are dropped, because a fixed violation is a fixed house.

The issue column on your file is the city's own department_bureau plus its violation_description — so you get "Conservation / Complaint", "Plumbing / Permit", "Electrical / Complaint" rather than a category we invented. Chicago has a single clean address field, so there is no address-composition guesswork on this market.

Both counts were run straight against the city's API on 6 August 2026. You can reproduce them: the query is a count(*) and a count(distinct address) over violation_status='OPEN' with violation_date inside the last 30 days.

What a test pull actually returns

Raw row count is not lead count, and we would rather show you the gap than hide it. Our documented Chicago test runs:

• --source chicago_code_violations --days 30 --limit 60 → 60 raw rows in, 27 unique properties out.
• --source chicago_code_violations --days 30 --limit 40 → 40 raw rows in, 15 unique properties out.

That roughly 2:1 collapse is Chicago's repeat-citation pattern: a single distressed building routinely picks up several violations in one inspection, and the same address reappears across weeks. We dedupe on (city, address) before anything reaches you, and we dedupe again against everything we have already delivered to you, so you are not paying to be handed the same house twice.

The repeat pattern is also a sorting tool. An address that shows up three times in six weeks is a materially different lead from one that picked up a single periodic inspection notice.

Real rows from the 5 August 2026 pull

Unedited. Every address, date and violation type below is exactly what the city published — paste any of them into the city's own portal and you will find the case.

What an investor actually does with this file

The file is a call sheet, not a research project. A working sequence that fits a Chicago buy box:

1. Cut to your ZIPs first. The city writes violations across all 50 wards; you probably buy in six or eight ZIP codes. Filter before you look at anything else.
2. Sort by repeat address. Two or more open cases on one property means an owner who has already ignored the city at least once. That is the strongest column in the file and it costs you a pivot table.
3. Read the bureau, not just the count. "Conservation / Complaint" is usually a neighbour or tenant complaint about the condition of a residential building. "Plumbing / Permit" and "Electrical / Complaint" often mean work started without a permit — an owner mid-project who ran out of money is a very different conversation from a tired landlord.
4. Drop the obvious commercial rows. Refrigeration and elevator inspections are businesses and multi-storey buildings. Unless you buy commercial, delete them.
5. Sort by the absentee flag, then dial. Absentee is derived at skip-trace time by comparing the owner's mailing address against the property address. An out-of-area owner with an open violation is the highest-yield call on the sheet.

Then work it like any other list: call, leave a specific voicemail that names the property, follow up with mail on the ones that do not pick up. The data does not close anything. It just puts you in front of a motivated owner before the property gets listed.

The honest limits in Chicago