How to Pull Code Violation County Data for San Francisco City, CA
A code violation list shows cases a city opens when a property breaks local building or safety rules. To find code violation records for San Francisco City, California (CA), use DataSF. No account is needed. It is free to use. No VPN is needed. You can download a CSV file.
Also known as: code enforcement, code enforcement cases, building code violations.
What you need
What it is
Complaints handled by the San Francisco Department of Building Inspection, across housing, building, electrical, plumbing and code enforcement.
Why it matters
An open code case can mean a neglected or vacant house, and an owner who may want out. Fines and repair orders add pressure to sell.
The fields you get
- Complaint Number
- Complaint Description
- Status
- Street Number
- Street Name
- Street Suffix
- ZIP Code
- Parcel Number
- Date Filed
- Date 1st NOV Issued
The page showed data updated November 4, 2026.
Follow these 5 steps
-
Check the full table
A table opens with the filter box under it. Bottom right says 338,255 rows.
Enlarge
-
Keep the active complaints
Click Select a column to filter and pick Status. In the search box, pick Active. Click Apply. The row count changes to 14,967.
Enlarge
-
Put the newest records first
Find the Date Filed column. Scroll right if needed. Click the three lines in its header, then Sort descending.
Enlarge
-
Export the CSV
Click Export at the top right. Keep Download file and CSV. Click Download. Only the rows in your current view go in the file. Open it in Excel or Google Sheets.
Enlarge
Watch out for these
- The site moved from data.sfgov.org to data.sf.gov. Use the new address.
- Date 1st NOV Issued shows if a notice of violation went out. A complaint alone is not a violation.
- The address is split across columns. Join number, name and suffix.
- There is no owner name. Use the parcel number on the San Francisco Assessor site.
Common questions
Is this list free?
Does the file show the owner?
Other lists in San Francisco City
We only have this list for San Francisco City so far. See all California guides.
Code Violation in other California areas
Code Violation in other states
See every guide
Do not want to do this by hand?
CountyPull pulls this list for you automatically.