Total Records
0
All record types (complaints, NOVs, citations, etc.)
Complaints (CP)
0
RecordNum ends with -CP
Notices of Violation (VI)
0
RecordNum ends with -VI
% NOV per Complaint
0%
Higher means more enforcement relative to complaints
Missing Inspection Date
0
No LastInspDate (or flagged “No Inspection Date”)
Closed/Completed with No Inspection Date
0
Cannot verify response time or whether a site visit occurred
Blank RecordTypeDesc
0
Uncategorized: RecordTypeDesc is empty
Emergency (Unqualified)
0
Included inside Landlord/Tenant totals
Complaints vs NOVs over time (counts)
All Years · Citywide
NOV conversion rate by year (% VI per CP)
All Years · Citywide
NOV rate by district (highest to lowest)
All Years · Citywide
Top categories: Complaints vs NOVs
All Years · Citywide
The Verification Gap
If a record is marked “Closed” or “Completed” but has no inspection date, the public cannot verify if SDCI responded, how long it took, or whether a site visit happened at all. This is an evidence integrity problem, not a paperwork problem.
Missing inspection rate by district (% records)
All Years · Citywide
Missing inspection dates by status (present vs missing)
All Years · Citywide
Records missing an inspection date (by Open Year)
All Years · Citywide
Oldest Open LandLord/Tenant Complaints — Still Under Investigation (top 25)
All Years · Citywide
| Open Date | Record | Status | Category | Address |
|---|
Last 25 LandLord/Tenant Complaints Filed
LLT records only · All Years · Citywide
| Open Date | Record | Status | Category | Address |
|---|
Calculation rules used in this dashboard
- Complaint = RecordNum ends with -CP.
- NOV = RecordNum ends with -VI.
- % NOV per Complaint = NOVs ÷ Complaints.
- Missing inspection date = No LastInspDate (or “No Inspection Date” flag).
- Closed/Completed with no inspection date = StatusCurrent is exactly Closed or Completed, and inspection date is missing.
- Blank RecordTypeDesc = RecordTypeDesc is empty.
- Emergency = RecordTypeDesc equals Emergency.