Reading the ledger…
THE INDEX: 93 ▼9 · week of Nov 2 — permits steady, openings quiet
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 23, 2026 | 46 S 2ND ST | PERIODIC TESTING | Violation | OPEN | DGLM46 LLC |
| Jul 23, 2026 | 45 S 3RD ST | CAL LICENSE OBTAIN | Violation | OPEN | YOUME&BEE LLC |
| Jul 22, 2026 | 229 CHESTNUT ST | NEW USE | Violation | OPEN |
Free tool
Want open violations and unsafe designations mapped weekly? Get the free Building Report →
| Jul 22, 2026 | 229 CHESTNUT ST | PERIODIC TESTING | Violation | OPEN | — |
| Jul 22, 2026 | 6615-35 CHARLES ST | PERIODIC TESTING | Violation | OPEN | CHARLES MAYFAIR ENTERPRIS |
| Jul 22, 2026 | 4847 N 5TH ST | PLUMBING SYSTEMS- SANITARY MAINTENANCE | Violation | OPEN | JOHNSON AHASTHA |
| Jul 22, 2026 | 6615-35 CHARLES ST | INTERIOR SURFACES | Violation | OPEN | CHARLES MAYFAIR ENTERPRIS |
| Jul 22, 2026 | 6615-35 CHARLES ST | SINGLE- & MULTIPLE-STATION SMOKE ALARMS | Violation | OPEN | CHARLES MAYFAIR ENTERPRIS |
| Jul 22, 2026 | 1904 E HAGERT ST | SUPPRESSION SYSTEM TESTING & MAINTENANCE | Violation | OPEN | — |
| Jul 22, 2026 | 7036 TORRESDALE AVE | NEW USE | Violation | OPEN | XUE LIEYUAN |
| Jul 22, 2026 | 213 CHESTNUT ST | PERIODIC TESTING | Violation | OPEN | ORLY INVESTMENT L L C |
| Jul 22, 2026 | 213 CHESTNUT ST | WET CHEMICAL SYSTEMS | Violation | OPEN | ORLY INVESTMENT L L C |
| Jul 22, 2026 | 215 CHESTNUT ST | SIDEWALK CAFE LICENSE | Violation | OPEN | TONY REAL ESTATE LLC |
| Jul 22, 2026 | 3038 FANSHAWE ST | EXTERIOR AREA WEEDS | Violation | OPEN | CHEN LUNBING |
| Jul 22, 2026 | 7226 SOUDER ST | RUBBISH & GARBAGE | Violation | OPEN | JIANG MIN XING |
| Jul 22, 2026 | 1444 HOWELL ST | EXTERIOR AREA MOTOR VEHICLE WITHIN THE PROPERTY LINE | Violation | OPEN | HORACE REBECCA |
| Jul 22, 2026 | 1444 HOWELL ST | RUBBISH & GARBAGE | Violation | OPEN | HORACE REBECCA |
| Jul 22, 2026 | 1444 HOWELL ST | EXTERIOR AREA WEEDS | Violation | OPEN | HORACE REBECCA |
| Jul 22, 2026 | 3118 STIRLING ST | EXTERIOR AREA WEEDS | Violation | OPEN | ZUNA EDI |
| Jul 22, 2026 | 3116 STIRLING ST | EXTERIOR AREA WEEDS | Violation | OPEN | HUANG JOSEPH CHU FU, LIN RACHEL LUOPING |
| Jul 22, 2026 | 5838R N PENN ST | EXTERIOR AREA WEEDS | Violation | OPEN | SILVA JOSE G, SILVA BELMIRA H/W |
| Jul 22, 2026 | 6928 HORROCKS ST | RUBBISH & GARBAGE | Violation | OPEN | TSE JACK CHENG YIN, TSE HUI JUN CHEN |
| Jul 22, 2026 | 4301 N DELAWARE AVE | NO SMOKING SIGNS | Violation | OPEN | 4301 N DELAWARE QOB LLC |
| Jul 22, 2026 | 4301 N DELAWARE AVE | VEGETATION | Violation | OPEN | 4301 N DELAWARE QOB LLC |
| Jul 22, 2026 | 4301 N DELAWARE AVE | CLEARANCE FROM COMBUSTIBLES | Violation | OPEN | 4301 N DELAWARE QOB LLC |