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 | 45 S 3RD ST | CAL LICENSE OBTAIN | Violation | OPEN | YOUME&BEE LLC |
| Jul 23, 2026 | 40 S 2ND ST | PERIODIC TESTING | Violation | OPEN | SECOND AND TROTTER OWNER 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 | 2600 CARROLL ST | EXTERIOR AREA SANITATION | Violation | OPEN | AIJOBORY INVESTMENT LLC |
| Jul 22, 2026 | 6615-35 CHARLES ST | VENTILATION- BATHROOMS | Violation | OPEN | CHARLES MAYFAIR ENTERPRIS |
| Jul 22, 2026 | 2129 UNRUH AVE | EXTERIOR AREA WEEDS | Violation | OPEN | JIANG XIANG, JIANG TING |
| Jul 22, 2026 | 1904 E HAGERT ST | SUPPRESSION SYSTEM TESTING & MAINTENANCE | Violation | OPEN | — |
| Jul 22, 2026 | 2332 W SERGEANT ST | RUBBISH & GARBAGE | Violation | OPEN | BRESNENI ESTATE LLC |
| Jul 22, 2026 | 2332 W SERGEANT ST | EXTERIOR AREA WEEDS | Violation | OPEN | BRESNENI ESTATE LLC |
| Jul 22, 2026 | 1300 N 29TH ST | UNSAFE STRUCTURE | Violation | OPEN | THE CROSS OF CALVARY, BAPTIST CHURCH |
| Jul 22, 2026 | 308 E MOUNT AIRY AVE | WORK OUTSIDE OF SCOPE | Violation | OPEN | ACE & ASSOCIATES LLC |
| Jul 22, 2026 | 75 E GARFIELD ST | VACANT STRUCTURE & LAND | Violation | OPEN | LOMBARD PROPERTIES LLC |
| Jul 22, 2026 | 3136 BRIGHTON ST | EXTERIOR AREA WEEDS | Violation | OPEN | LI ZHENSEN, PENG AIHUA |
| Jul 22, 2026 | 6621 AKRON ST | RUBBISH & GARBAGE | Violation | OPEN | ZHAO YAN CI |
| Jul 22, 2026 | 1904 E HAGERT ST | RENTAL LICENSE- ONE & TWO FAMILY (R3) | Violation | OPEN | — |
| Jul 22, 2026 | 2125 SAINT JAMES ST | EXTERIOR STRUCTURE DOORS | Violation | OPEN | HSU IRENE |
| Jul 22, 2026 | 55 COSGROVE ST | EXTERIOR AREA MOTOR VEHICLE WITHIN THE PROPERTY LINE | Violation | OPEN | LEVINE FRED R |
| Jul 22, 2026 | 1913-19 CECIL B MOORE AVE | SMOKE ALARM LOCATION | Violation | OPEN | THE 88 GROUP LLC |
| Jul 22, 2026 | 3134 BRIGHTON ST | EXTERIOR AREA WEEDS | Violation | OPEN | LIN JIN HAI |
| Jul 22, 2026 | 6615-35 CHARLES ST | EXTERIOR STRUCTURE WINDOWS, SKYLIGHTS DOOR FRAMES | Violation | OPEN | CHARLES MAYFAIR ENTERPRIS |
| Jul 22, 2026 | 1300 N 29TH ST | ARCHITECT/ENGINEER SERVICES | Violation | OPEN | THE CROSS OF CALVARY, BAPTIST CHURCH |
| Jul 22, 2026 | 6607 AKRON ST | EXTERIOR AREA WEEDS | Violation | OPEN | DALEY CAROL |
| Jul 22, 2026 | 1444 HOWELL ST | RUBBISH & GARBAGE | Violation | OPEN | HORACE REBECCA |
| Jul 22, 2026 | 219 E WILLOW GROVE AVE | INTERIOR DOORS | Violation | OPEN | 219 E WILLOW GROVE AVE LP |