Home › Sources › sfsc_criminal_cumulative_index
San Francisco Superior Court Cumulative Criminal Index and Bench Warrants
Source ID sfsc_criminal_cumulative_index. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | sfsc_criminal_cumulative_index |
| Name | San Francisco Superior Court Cumulative Criminal Index and Bench Warrants |
| Owner | Superior Court of California, County of San Francisco |
| Layer | core_court_record |
| Coverage | Official SFSC cumulative criminal index and bench-warrant search surface exposed by crimindex.dll; profile verified the page, lookup.js DataSnap contract, zero-result behavior, and a capped positive bench-warrant result set. |
| Formats | HTML, JavaScript, DataSnap JSON envelope |
| Join keys | case_number, defendant_name, filed_date, charge_text, warrant_issued_date, department |
| Caveats | The endpoint is not a complete bulk export; production must feed it a curated name/case-number seed queue from already-permitted court/person sources., GetCrimIndex returns cumulative-index rows by last and first name but does not expose judges, attorneys, dispositions, sentences, or full docket events., GetBW/GetBWNum expose bench-warrant index rows; a bounded profile observed GetBWNum/000 returning a capped 1500-row result set, so broad probes must be explicit and count/sample limited., Raw rows can contain public names, case numbers, charge text, warrant dates, departments, and warrant details; persist provenance and suppression policy before broad release. |
Linked cases
0 matching cases for this source filter.
No matching cases.
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| - | sfsc_criminal_cumulative_index | agent_browser_har_profile_and_lookup_js_contract | - | - | - |
Full source record
| Access Mode | turnstile_session_datasnap_rest_seeded_index |
| Cadence | Official case-information page describes the cumulative criminal index as updated weekly; sync is seed-driven by defendant name or bench-warrant case number. |
| Coverage | Official SFSC cumulative criminal index and bench-warrant search surface exposed by crimindex.dll; profile verified the page, lookup.js DataSnap contract, zero-result behavior, and a capped positive bench-warrant result set. |
| Government Level | local_court |
| ID | sfsc_criminal_cumulative_index |
| Layer | core_court_record |
| Name | San Francisco Superior Court Cumulative Criminal Index and Bench Warrants |
| Owner | Superior Court of California, County of San Francisco |
| Profile Status | bounded_agent_browser_datasnap_profile |
| Canonical Records | court_case, case_person, court_charge, court_event, source_record |
| Caveats | The endpoint is not a complete bulk export; production must feed it a curated name/case-number seed queue from already-permitted court/person sources., GetCrimIndex returns cumulative-index rows by last and first name but does not expose judges, attorneys, dispositions, sentences, or full docket events., GetBW/GetBWNum expose bench-warrant index rows; a bounded profile observed GetBWNum/000 returning a capped 1500-row result set, so broad probes must be explicit and count/sample limited., Raw rows can contain public names, case numbers, charge text, warrant dates, departments, and warrant details; persist provenance and suppression policy before broad release. |
| Evidence | artifacts/source-discovery/sf-courts-case-information-page.html, artifacts/source-discovery/sfsc-crimindex-entry-20260531.html, artifacts/source-discovery/sfsc-crimindex-entry-20260531.headers.txt, artifacts/source-discovery/sfsc-crimindex-lookup-js-20260531.js, artifacts/source-discovery/sfsc-crimindex-agent-browser-profile-20260531.json, artifacts/profiling/sfsc-crimindex-agent-browser-profile-20260531.har, scripts/profile_sfsc_crimindex_agent_browser.py, scripts/sync_sfsc_crimindex.py |
| Formats | HTML, JavaScript, DataSnap JSON envelope |
| Join Keys | case_number, defendant_name, filed_date, charge_text, warrant_issued_date, department |
| Known Endpoints | GetCrimIndex, GetBW, GetBWNum |
| Rate Limit Notes | Repo-native bounded sync requires an explicit fresh SessionID and defaults to 35 calls per session., Headed Agent Browser profile minted a SessionID; direct HTTP and headless entry fetches hit the Turnstile/captcha gate., Do not run broad warrant probes unless explicitly requested; persist row counts/fields first and quarantine full rows for policy review., Use this source as an enrichment/discovery layer over known names/case numbers, not as the sole criminal backfill spine. |
| Source Urls | https://webapps.sftc.org/crimindex/crimindex.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_cumulative_indexJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=sfsc_criminal_cumulative_index&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON