Reading the ledger…
THE INDEX: 146 ▼2 · week of Aug 3 — permits steady, openings steady, deal ledger running hot
Reading the ledger…
The raw feed behind the newsletter. Free tier: the trailing 90 days, 25 rows a page — enforced at the query, not just the pixels.
Reading the record?Get the week's biggest deals, permits, and the LLCs behind them — one free email every Thursday, every number checkable here.
Index Pro — full history, CSV exports, and morning-of alerts. $39/mo, coming soon. Get notified at launch:
New · The distress rolls
39,333 properties owe the city back taxes — 1,734 flagged for sheriff sale.
| Date | Address | Title | Kind | Status | Owner |
|---|---|---|---|---|---|
| Jul 29, 2026 | 6548 MARSDEN ST | EXTERIOR STRUCTURE HANDRAILS GUARDRAILS | Violation | OPEN | GOLDEN LANTERN HOLDING LL |
| Jul 29, 2026 | 1715 ANCHOR ST | EXTERIOR AREA WEEDS | Violation | OPEN | STREET JAMES JR |
| Jul 29, 2026 | 6548 MARSDEN ST | INTERIOR DOORS | Violation | OPEN |
Free tool
Want open violations and unsafe designations mapped weekly? Get the free Building Report →
| GOLDEN LANTERN HOLDING LL |
| Jul 29, 2026 | 4228 LANSING ST | EXTERIOR AREA WEEDS | Violation | OPEN | NGUYEN RYAN D |
| Jul 29, 2026 | 7945 BUIST AVE | FOUNDATION DEFICIENCIES | Violation | OPEN | ROBINSON CAROL A |
| Jul 29, 2026 | 7945 BUIST AVE | ARCHITECT/ENGINEER SERVICES | Violation | OPEN | ROBINSON CAROL A |
| Jul 29, 2026 | 7945 BUIST AVE | UNSAFE STRUCTURE | Violation | OPEN | ROBINSON CAROL A |
| Jul 29, 2026 | 7945 BUIST AVE | MASONRY COMPONENTS | Violation | OPEN | ROBINSON CAROL A |
| Jul 29, 2026 | 13031 SEWELL RD | ZONING REQUIRED FOR CONSTRUCTION | Violation | OPEN | CUNNINGHAM ANDREW J, HELEN LISA H/W |
| Jul 29, 2026 | 9449 ASHTON RD | EXTERIOR AREA WEEDS | Violation | OPEN | CHERIYAN SOSAMMA |
| Jul 29, 2026 | 6548 MARSDEN ST | ABATEMENT OF ELECTRICAL HAZARDS | Violation | OPEN | GOLDEN LANTERN HOLDING LL |
| Jul 29, 2026 | 3306 HOPE ST | VACANT STRUCTURE & LAND | Violation | OPEN | KOUAI MOUI |
| Jul 29, 2026 | 4222 ALDINE ST | EXTERIOR AREA WEEDS | Violation | OPEN | SANCHEZ GEORGE S, VERA YESNER GARCIA |
| Jul 29, 2026 | 5356 CHARLES ST | VACANT STRUCTURE LICENSE | Violation | OPEN | CLAUDIO IVAN, MORRABAL MARIA D |
| Jul 29, 2026 | 1 BROWN ST | INSPECTION, TESTING & MAINTENANCE | Violation | OPEN | 1 BROWN STREET OWNER LLC |
| Jul 29, 2026 | 3712 N DELHI ST | ELECTRICAL- HAZARD | Violation | OPEN | URGILES ALEX RICARDO PARRAGA |
| Jul 29, 2026 | 3712 N DELHI ST | PROHIBITED OCCUPANCY | Violation | OPEN | URGILES ALEX RICARDO PARRAGA |
| Jul 29, 2026 | 5356 CHARLES ST | VACANT STRUCTURE & LAND | Violation | OPEN | CLAUDIO IVAN, MORRABAL MARIA D |
| Jul 29, 2026 | 1233 FULLER ST | RENTAL LICENSE- ONE & TWO FAMILY (R3) | Violation | OPEN | HEPP KARIN |
| Jul 29, 2026 | 339 E WISTER ST | UNAPPROVED USED MATERIALS | Violation | OPEN | TWIN ENTERPRISE LLC |
| Jul 29, 2026 | 339 E WISTER ST | ALTER INTERIOR PORTION | Violation | OPEN | TWIN ENTERPRISE LLC |
| Jul 29, 2026 | 12026 ACADEMY RD | RENTAL LICENSE- ONE & TWO FAMILY (R3) | Violation | OPEN | RUBY HENRY |
| Jul 29, 2026 | 3304 HOPE ST | VACANT STRUCTURE & LAND | Violation | OPEN | KOUAI MOUI |
| Jul 29, 2026 | 3357 N ORKNEY ST | VACANT STRUCTURE & LAND | Violation | OPEN | PHILADELPHIA LAND BANK |
| Jul 29, 2026 | 2914 PASSMORE ST | NEW USE | Violation | OPEN | NI YANBIN, ZHENG LI WANG |