Code Violation Leads: Property Owners, Fines & Violation Types

Philadelphia (Licenses and Inspections code violations), Detroit (blight tickets), Chicago (Department of Buildings violations), Mesa, Arizona (code compliance cases) and New York City (HPD housing maintenance code violations). Each is the city's own open-data feed. Measured on 2026-11-01, the last 7 days held 1,944 violations in Philadelphia, 489 in Detroit, 563 in Chicago, 65 in Mesa and 15,035 in New York City.

Detroit's tickets carry the owner's name and mailing address. Philadelphia's violations carry the owner's name, and the mailing address comes from the city's property roll (OPA). Mesa's owners come from the Maricopa County Assessor by parcel number, Chicago's from the Cook County Assessor by street address, and New York City's owner name from MapPLUTO, which publishes no mailing address. In a 7-day export on 2026-11-01 the owner's name was on 99% of Philadelphia rows, 100% of Detroit, 97% of Mesa, 100% of New York City (name only) and 54% of Chicago: Chicago misses are mostly large and condominium buildings, where one address has several parcels and no single owner, so none is given.

No. None of these public records carries a phone or email for the owner; the owner's name and mailing address are what is published.

Each city words its violations differently ('EXTERIOR AREA WEEDS' in Philadelphia, 'Excessive weeds or plant growth' in Detroit, 'CUT OR REMOVE HIGH WEEDS' in Chicago). The 17 types match the violation's own wording, so 'Weeds, grass & overgrowth' finds all three. A violation can match several types; one that matches none is 'other'. Keywords search the same wording for anything the types do not cover.

Yes: set 'Last N days' to 0, or give a From date. Large cities hold millions of rows (New York City added about 15,000 in one week), so set 'Maximum rows per city' to what you want to pay for, or split the range into months. Leaving the dates empty means the last 30 days in export mode.

Property rows group the violations in your date range by address (or parcel): the violation count, how many are still open, the types, the first and last date, the unpaid total where published, and the list of violations. Owner rows group by owner: how many cited properties they have and their addresses. Both are sorted most-cited first, and 'Minimum violations' keeps only repeat offenders.

Give street addresses, parcel numbers or owner names and pick the cities to search. Each one returns its violations (all time unless you set dates; any status unless you set one). Owner-name search works in Philadelphia and Detroit, where the violation record carries the owner; Chicago has no parcel number on its violations, so search Chicago by address.

It compares the owner's mailing address with the property: out_of_state, out_of_city, same_city_diff_address (mailed to another address in the same city) or owner_occupied. With no mailing address (New York City) it is unknown. 'Absentee owners only' keeps the first three.

$0.004 per violation row, $0.006 per property row or $0.01 per owner row, depending on the row type you choose. Owner names and mailing addresses are included. Free rows (input to fix, no match, a city that did not answer, a stopped run) are never charged. 'Maximum rows per city' caps each city.