Home › Sources › sfsc_criminal_portal
San Francisco Superior Court Criminal Portal
Source ID sfsc_criminal_portal. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | sfsc_criminal_portal |
| Name | San Francisco Superior Court Criminal Portal |
| Owner | Superior Court of California, County of San Francisco |
| Layer | core_court_record |
| Coverage | Criminal cases exposed by crimportal.dll; observed historical floor case_id 1548625 with records back to the 1970s/1980s and present-day CRI cases. |
| Formats | HTML, DataSnap JSON envelope |
| Join keys | case_id, case_number, defendant_name, filed_date, department |
| Caveats | Criminal portal does not expose parties, judges, documents, payments, dispositions, sentences, victims, witnesses, custody, or attorney bar numbers directly., Older legacy cases often hydrate to empty endpoint rows even when the case shell exists., Public identifiers and personally identifying names must be handled with clear provenance and suppression policy before broad release. |
Linked cases
890 matching cases for this source filter.
| Case | Filed | Division / type | Status | Named litigant | Events | Charges | Sources |
|---|---|---|---|---|---|---|---|
| CRI-00127489 | 1977-09-21 | criminal | - | SANDRA MICHELL LIPSCOMB | 0 | 0 | sfsc_criminal_portal |
| CRI-00127744 | 1977-09-16 | criminal | Scheduled | MELVIN CHARLES WILLIAMS | 7 | 1 | sfsc_criminal_portal |
| CRI-00128538 | 1977-09-15 | criminal | Scheduled | LUIS ARMANDO ROSA | 2 | 0 | sfsc_criminal_portal |
| CRI-00128596 | 1977-09-14 | criminal | Scheduled | ANDRALL TAYLOR | 6 | 5 | sfsc_criminal_portal |
| CRI-00128470 | 1977-09-14 | criminal | Scheduled | JOHNNY LUPE ARIAS | 5 | 2 | sfsc_criminal_portal |
| CRI-00128368 | 1977-09-14 | criminal | Scheduled | PRISCILLA LAVENTURE | 1 | 0 | sfsc_criminal_portal |
| CRI-00128564 | 1977-09-13 | criminal | - | WESLEY ROBERTSON | 0 | 0 | sfsc_criminal_portal |
| CRI-00128527 | 1977-09-13 | criminal | Scheduled | TOMMIE LEE LANGFORD | 5 | 1 | sfsc_criminal_portal |
| CRI-00128476 | 1977-09-13 | criminal | - | LARRY JAMES MCCLINTON | 0 | 0 | sfsc_criminal_portal |
| CRI-00128465 | 1977-09-13 | criminal | Scheduled | CAROL L COLEMAN | 9 | 4 | sfsc_criminal_portal |
| CRI-00128452 | 1977-09-13 | criminal | Scheduled | GEORGE W MADDOX | 6 | 1 | sfsc_criminal_portal |
| CRI-00128375 | 1977-09-13 | criminal | - | GREGORY PENDLETON | 0 | 0 | sfsc_criminal_portal |
| CRI-00128286 | 1977-09-13 | criminal | Scheduled | ROBERT R KENDRICK | 7 | 1 | sfsc_criminal_portal |
| CRI-00128212 | 1977-09-13 | criminal | Scheduled | DENA M TOVAR | 9 | 1 | sfsc_criminal_portal |
| CRI-00128498 | 1977-09-12 | criminal | Scheduled | RICHARD STEIN | 1 | 0 | sfsc_criminal_portal |
| CRI-00128419 | 1977-09-12 | criminal | Scheduled | JAMAL SORADI | 7 | 5 | sfsc_criminal_portal |
| CRI-00128260 | 1977-09-12 | criminal | - | RICHARD G JONES | 0 | 0 | sfsc_criminal_portal |
| CRI-00128224 | 1977-09-12 | criminal | Scheduled | HARRY J FLENOID | 5 | 1 | sfsc_criminal_portal |
| CRI-00127514 | 1977-09-12 | criminal | Scheduled | CALVIN J PARKER | 8 | 2 | sfsc_criminal_portal |
| CRI-00128603 | 1977-09-09 | criminal | - | CHARLES LEE BARNES | 0 | 0 | sfsc_criminal_portal |
| CRI-00128597 | 1977-09-09 | criminal | - | ANDRALL TAYLOR | 0 | 0 | sfsc_criminal_portal |
| CRI-00128555 | 1977-09-09 | criminal | - | EDDIE THOMAS GRAHAM | 0 | 0 | sfsc_criminal_portal |
| CRI-00128554 | 1977-09-09 | criminal | - | EDDIE THOMAS GRAHAM | 0 | 0 | sfsc_criminal_portal |
| CRI-00128545 | 1977-09-09 | criminal | - | ELIJAH JONES | 0 | 0 | sfsc_criminal_portal |
| CRI-00128543 | 1977-09-09 | criminal | - | ROLAND STIRRUP | 0 | 0 | sfsc_criminal_portal |
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| - | sfsc_criminal_portal | har_profile | - | - | - |
| - | sfsc_criminal_portal | raw_case_samples | - | - | - |
Full source record
| Access Mode | turnstile_session_datasnap_rest |
| Cadence | operational; sync needs continuous discovery of new case_ids plus hydration of valid cases |
| Coverage | Criminal cases exposed by crimportal.dll; observed historical floor case_id 1548625 with records back to the 1970s/1980s and present-day CRI cases. |
| Government Level | local_court |
| ID | sfsc_criminal_portal |
| Layer | core_court_record |
| Name | San Francisco Superior Court Criminal Portal |
| Owner | Superior Court of California, County of San Francisco |
| Profile Status | deep_profiled_existing_research |
| Canonical Records | court_case, case_person, court_charge, court_event, source_record |
| Caveats | Criminal portal does not expose parties, judges, documents, payments, dispositions, sentences, victims, witnesses, custody, or attorney bar numbers directly., Older legacy cases often hydrate to empty endpoint rows even when the case shell exists., Public identifiers and personally identifying names must be handled with clear provenance and suppression policy before broad release. |
| Evidence | docs/research/master-findings.md, docs/research/criminal-endpoint-catalog.md, scripts/profile_sfsc_criminal_agent_browser.py, scripts/sync_sfsc_criminal_portal.py, artifacts/source-discovery/sfsc-criminal-agent-browser-profile-20260531.json, data/macmini-dump-prod-summary.json, data/macmini-jobs-snapshot.db, artifacts/source-discovery/macmini-backfill-status-2026-05-30.profile.json, scripts/verify_sfsc_full_dump_import.py, artifacts/local-prod/full-dump-import-preflight-sample-2026-05-31.json, artifacts/local-prod/full-dump-import-preflight-macmini-path-2026-05-31.json, data/sample_raw/case_4270455.json |
| Formats | HTML, DataSnap JSON envelope |
| Join Keys | case_id, case_number, defendant_name, filed_date, department |
| Known Endpoints | CheckCaseNumber, FindCaseName, FindAttorneyName, CaseNumFromName, CaseNumFromAttorneyName, GetROA, GetAttorneys, GetCalendar, GetCharges |
| Rate Limit Notes | Repo-native bounded sync uses an explicit fresh SessionID and defaults to 45 calls, below the observed cap., Existing probes found a per-SessionID hard cap of about 50 successful calls., Session warmup via Scrapling/Camoufox is the bottleneck; bulk sync must rotate fresh sessions and respect resource limits., Do not reuse the wedged Mac mini process; recover inflight rows then relaunch only after disk pressure is fixed., Run scripts/verify_sfsc_full_dump_import.py against restored dump_prod/raw plus copied jobs/summary evidence before building data/full-index.db. |
| Source Urls | https://webapps.sftc.org/crimportal/crimportal.dll |
Get this page with API
Rendered from the bluedoor SF Superior Court API. Reproduce it:
GET https://api.bluedoor.sh/sf-superior-court/v1/sources/sfsc_criminal_portalJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=sfsc_criminal_portal&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON