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 | 5523 WHITBY AVE | EXTERIOR STRUCTURE PROTECTIVE TREATMENT | Violation | OPEN | CHARLES T HARMON, CATHERINE |
| Jul 29, 2026 | 6548 MARSDEN ST | INTERIOR SURFACES | Violation | OPEN | GOLDEN LANTERN HOLDING LL |
| Jul 29, 2026 | 3139 N 24TH ST | EXTERIOR AREA WEEDS | Violation |
Free tool
Want open violations and unsafe designations mapped weekly? Get the free Building Report →
| OPEN |
| BISHOP MARQUITA, HASSAN SHAWANDA G |
| Jul 29, 2026 | 100 MARKET ST | NEW USE | Violation | OPEN | 100 MARKET STREET ASSOCIA |
| Jul 29, 2026 | 100 MARKET ST | OCCUPIED W/O TCO OR CO | Violation | OPEN | 100 MARKET STREET ASSOCIA |
| Jul 29, 2026 | 100 MARKET ST | CAL LICENSE OBTAIN | Violation | OPEN | 100 MARKET STREET ASSOCIA |
| Jul 29, 2026 | 1207 FULLER ST | RENTAL LICENSE- ONE & TWO FAMILY (R3) | Violation | OPEN | JACKSON WILLIAM C |
| Jul 29, 2026 | 1202 FULLER ST | RENTAL LICENSE- ONE & TWO FAMILY (R3) | Violation | OPEN | SWEDLIGE SUZANNE |
| Jul 29, 2026 | 1200 FULLER ST | RENTAL LICENSE- ONE & TWO FAMILY (R3) | Violation | OPEN | 220 MAPLE LLC |
| Jul 29, 2026 | 100 MARKET ST | EXTERIOR STRUCTURE WALLS | Violation | OPEN | 100 MARKET STREET ASSOCIA |
| Jul 29, 2026 | 5523 WHITBY AVE | EXTERIOR STRUCTURE IDENTIFICATION | Violation | OPEN | CHARLES T HARMON, CATHERINE |
| Jul 29, 2026 | 5523 WHITBY AVE | EXTERIOR STRUCTURE ROOF DRAINAGE | Violation | OPEN | CHARLES T HARMON, CATHERINE |
| Jul 29, 2026 | 112 MARKET ST | PERIODIC TESTING | Violation | OPEN | — |
| Jul 29, 2026 | 742 S 52ND ST | INTERIOR SURFACES | Violation | OPEN | WALKER ADAM C |
| Jul 29, 2026 | 5523 WHITBY AVE | EXTERIOR AREA RODENT HARBORAGE | Violation | OPEN | CHARLES T HARMON, CATHERINE |
| Jul 29, 2026 | 212 BROWN ST | PERIODIC TESTING | Violation | OPEN | — |
| Jul 29, 2026 | 5517 W OXFORD ST | NEW USE | Violation | OPEN | HATFIELD GEORGE R TR, TRUST ESTABLISHED UNDER MMANDI SD401K PL |
| Jul 29, 2026 | 3367 HOLME AVE | RUBBISH & GARBAGE | Violation | OPEN | CHEN JIA YING |
| Jul 29, 2026 | 1315 E WASHINGTON LN | EXTERIOR WALLS | Violation | OPEN | DANIEL G KAMIN EAST WASHI |
| Jul 29, 2026 | 742 S 52ND ST | PLUMBING SYSTEMS- GENERAL | Violation | OPEN | WALKER ADAM C |
| Jul 29, 2026 | 8014 COTTAGE ST | RUBBISH & GARBAGE | Violation | OPEN | LLOYD DANIEL A |
| Jul 29, 2026 | 742 S 52ND ST | PLUMBING SYSTEMS- HAZARDS | Violation | OPEN | WALKER ADAM C |
| Jul 29, 2026 | 742 S 52ND ST | UNFIT STRUCTURE | Violation | OPEN | WALKER ADAM C |
| Jul 29, 2026 | 5523 WHITBY AVE | EXTERIOR AREA SANITATION | Violation | OPEN | CHARLES T HARMON, CATHERINE |
| Jul 29, 2026 | 813 W ERIE AVE | EXTERIOR AREA SANITATION | Violation | OPEN | GOMEZ LIZANDRO SANCHEZ |