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 24, 2026 | 123 E COULTER ST | EXTERIOR AREA SANITATION | Violation | OPEN | ADVANCED E ENTERPRISES LLC |
| Jul 24, 2026 | 5432 CHRISTIAN ST | EXTERIOR STRUCTURE PROTECTIVE TREATMENT | Violation | OPEN | OLIVER JOHN |
| Jul 24, 2026 | 3320 N SMEDLEY ST | ALTER EXTERIOR PORTION | Violation |
Free tool
Want open violations and unsafe designations mapped weekly? Get the free Building Report →
| OPEN |
| MOGELLON GUSTAVO |
| Jul 24, 2026 | 5432 CHRISTIAN ST | DOOR AND WINDOW VACANT | Violation | OPEN | OLIVER JOHN |
| Jul 24, 2026 | 3320 N SMEDLEY ST | NEW PLUMBING | Violation | OPEN | MOGELLON GUSTAVO |
| Jul 24, 2026 | 5126 MEBUS ST | FIRE SAFETY- SMOKE ALARMS | Violation | OPEN | KHATRI ROSARIO |
| Jul 24, 2026 | 5126 MEBUS ST | EXTERIOR STRUCTURE WINDOWS | Violation | OPEN | KHATRI ROSARIO |
| Jul 24, 2026 | 5126 MEBUS ST | INTERIOR SURFACES | Violation | OPEN | KHATRI ROSARIO |
| Jul 24, 2026 | 14 S 3RD ST | SUPPRESSION SYSTEM TESTING & MAINTENANCE | Violation | OPEN | PAS 14S3 LLC |
| Jul 24, 2026 | 3429 ALDINE ST | EXTERIOR AREA WEEDS | Violation | OPEN | REN IVY |
| Jul 24, 2026 | 3425 ALDINE ST | EXTERIOR AREA WEEDS | Violation | OPEN | HUANG JIAN FENG, CHEN YAN |
| Jul 24, 2026 | 3519 VISTA ST | EXTERIOR AREA WEEDS | Violation | OPEN | HUANG QINSHENG |
| Jul 24, 2026 | 4320 MEGARGEE ST | EXTERIOR AREA WEEDS | Violation | OPEN | CHONG BING LUM, LEE TING OI |
| Jul 24, 2026 | 4320 MEGARGEE ST | RUBBISH & GARBAGE | Violation | OPEN | CHONG BING LUM, LEE TING OI |
| Jul 24, 2026 | 3029 BOUDINOT ST | RENTAL LICENSE- ONE & TWO FAMILY (R3) | Violation | OPEN | SANTIAGO ARLENE |
| Jul 24, 2026 | 3412 ALDINE ST | RUBBISH & GARBAGE | Violation | OPEN | LIU WANLING |
| Jul 24, 2026 | 8 S FRONT ST | WET CHEMICAL SYSTEM TEST | Violation | OPEN | FRASE INC, SENA BROTHERS |
| Jul 24, 2026 | 6656-62 GERMANTOWN AVE | PLUMBING SYSTEMS- GENERAL | Violation | OPEN | 6656 G AVE LP |
| Jul 24, 2026 | 3320 N SMEDLEY ST | HVAC SYSTEM | Violation | OPEN | MOGELLON GUSTAVO |
| Jul 24, 2026 | 236 S 21ST ST | FDC SIGNAGE REQUIRED | Violation | OPEN | — |
| Jul 24, 2026 | 2118 S ALDEN ST | EXTERIOR AREA WEEDS | Violation | OPEN | ER MUHITTIN |
| Jul 24, 2026 | 4920 WESTMINSTER AVE | RENTAL LICENSE- ONE & TWO FAMILY (R3) | Violation | OPEN | DARNELL RUSSELL INVESTMENTS LLC |
| Jul 24, 2026 | 1305 W LEHIGH AVE | EXTERIOR STRUCTURE PROTECTIVE TREATMENT | Violation | OPEN | GILMORE VICTORIA |
| Jul 24, 2026 | 2118 S ALDEN ST | EXTERIOR AREA SANITATION | Violation | OPEN | ER MUHITTIN |
| Jul 24, 2026 | 235 S 15TH ST | FIRE COMMAND CENTER FEATURES | Violation | OPEN | 235 S 15TH STREET PARTNER |