Reading the ledger…
THE INDEX: 99 ▲6 · week of Nov 9 — permits soft, openings firm
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 |
|---|---|---|---|---|---|
| Jun 29, 2026 | 7169 GILLESPIE ST | EXTERIOR AREA WEEDS | Violation | OPEN | JIANG SUN JIAN |
| Jun 29, 2026 | 7162 JACKSON ST | EXTERIOR AREA WEEDS | Violation | OPEN | CHEN DE SHENG, LIN MEIMEI |
| Jun 29, 2026 | 867 BRIDGE ST | EXTERIOR AREA WEEDS | Violation | OPEN |
Free tool
Want open violations and unsafe designations mapped weekly? Get the free Building Report →
| CARABALLO KAYA MONTES DE, LOPEZ ROGER MACHUCA |
| Jun 29, 2026 | 5645 MIRIAM RD | EXTERIOR AREA WEEDS | Violation | OPEN | ALEXANDRE JEAN |
| Jun 29, 2026 | 957 GRANITE ST | EXTERIOR AREA WEEDS | Violation | OPEN | KATS YANA |
| Jun 29, 2026 | 955 GRANITE ST | EXTERIOR AREA WEEDS | Violation | OPEN | RHINE RENE ALEXANDER, RHINE ABIGAIL |
| Jun 29, 2026 | 923 GRANITE ST | EXTERIOR AREA WEEDS | Violation | OPEN | SHERIFF SAJI |
| Jun 29, 2026 | 922 GRANITE ST | EXTERIOR AREA WEEDS | Violation | OPEN | 4 ELLM PROPERTIES LLC |
| Jun 29, 2026 | 7316 FRANKFORD AVE | FIRE EXTINGUISHER HANGERS & BRACKETS | Violation | OPEN | JADE HORSE LLC |
| Jun 29, 2026 | 7316 FRANKFORD AVE | BOLT LOCKS | Violation | OPEN | JADE HORSE LLC |
| Jun 29, 2026 | 2309 N PARK AVE | EXTERIOR AREA WEEDS | Violation | OPEN | CLARK CARLTON V |
| Jun 29, 2026 | 2756 N NEWKIRK ST | RUBBISH & GARBAGE | Violation | OPEN | SAMUEL TAYLOR, LILLIAN |
| Jun 29, 2026 | 2756 N NEWKIRK ST | EXTERIOR AREA WEEDS | Violation | OPEN | SAMUEL TAYLOR, LILLIAN |
| Jun 29, 2026 | 2224 W TIOGA ST | EXTERIOR AREA WEEDS | Violation | OPEN | WISE HOLDING GROUP LLC |
| Jun 29, 2026 | 2224 W TIOGA ST | VACANT & OPEN PROPERTIES | Violation | OPEN | WISE HOLDING GROUP LLC |
| Jun 29, 2026 | 2224 W TIOGA ST | VACANT STRUCTURE & LAND | Violation | OPEN | WISE HOLDING GROUP LLC |
| Jun 29, 2026 | 2736 N NEWKIRK ST | RUBBISH & GARBAGE | Violation | OPEN | FRAZIER E GAMBRELL, FRAZIER ERVING |
| Jun 29, 2026 | 2736 N NEWKIRK ST | EXTERIOR AREA WEEDS | Violation | OPEN | FRAZIER E GAMBRELL, FRAZIER ERVING |
| Jun 29, 2026 | 2734 N NEWKIRK ST | RUBBISH & GARBAGE | Violation | OPEN | FLOYD REED & DOLLIE |
| Jun 29, 2026 | 2734 N NEWKIRK ST | EXTERIOR AREA WEEDS | Violation | OPEN | FLOYD REED & DOLLIE |
| Jun 29, 2026 | 1908 E CLEARFIELD ST | RENTAL LICENSE- ONE & TWO FAMILY (R3) | Violation | OPEN | HILDAGO MANUEL EMEILIO |
| Jun 29, 2026 | 7316 FRANKFORD AVE | SECURITY GRILLES | Violation | OPEN | JADE HORSE LLC |
| Jun 29, 2026 | 7316 FRANKFORD AVE | EXIT SIGN ILLUMINATION | Violation | OPEN | JADE HORSE LLC |
| Jun 29, 2026 | 5641 MIRIAM RD | EXTERIOR AREA WEEDS | Violation | OPEN | PQ INVESTMENT LLC |
| Jun 29, 2026 | 5643 MIRIAM RD | EXTERIOR AREA WEEDS | Violation | OPEN | JEANNOT ANNE |