Home › Sources › sfsc_criminal_case_search
SFSC Criminal Case Search Read Model
Source ID sfsc_criminal_case_search. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | sfsc_criminal_case_search |
| Name | SFSC Criminal Case Search Read Model |
| Owner | Bluedoor normalized from SF Superior Court public criminal records |
| Layer | derived_case_search_read_model |
| Coverage | Normalized criminal case-search rows served by the production SF Superior Court API read model. |
| Formats | Postgres, ClickHouse read model, JSON API |
| Join keys | case_id, case_number, case_uid, source_record_ids |
| Caveats | This is a normalized API/search provenance label, not a separate upstream court portal., Use linked source records and source_ids for upstream provenance when available. |
Linked cases
5 matching cases for this source filter.
| Case | Filed | Division / type | Status | Named litigant | Events | Charges | Sources |
|---|---|---|---|---|---|---|---|
| CRI-26010337 | 2026-05-08 | criminal | Sentencing Observed | JOSE VELASQUEZ | 12 | 6 | datasf_law_enforcement_dispatch_closed · datasf_police_incidents_2018_present · sfda_arrests |
| CRI-26010300 | 2026-05-08 | criminal | - | VICO FOREST | 9 | 3 | datasf_law_enforcement_dispatch_closed · datasf_police_incidents_2018_present · sfda_arrests |
| CRI-26408991 | 2026-05-08 | criminal | Bench Warrant Observed | SARAH E MACKIN | 4 | 2 | datasf_law_enforcement_dispatch_closed · datasf_police_incidents_2018_present · sfda_prosecuted_cases |
| CRI-26500277 | 2026-05-07 | criminal | - | SERGIO SANTOS RANGEL | 3 | 1 | sfsc_criminal_case_search |
| CRI-26010226 | 2026-05-07 | criminal | - | JONATHAN QUINTAY BROWN | 12 | 12 | datasf_law_enforcement_dispatch_closed · datasf_police_incidents_2018_present · sfda_arrests |
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| No matching rows. | |||||
Full source record
| Access Mode | derived_case_search_read_model |
| Cadence | derived from promoted SFSC criminal portal, cumulative-index, and backfill records during API build and sync |
| Coverage | Normalized criminal case-search rows served by the production SF Superior Court API read model. |
| Government Level | local_court_derived |
| ID | sfsc_criminal_case_search |
| Layer | derived_case_search_read_model |
| Name | SFSC Criminal Case Search Read Model |
| Owner | Bluedoor normalized from SF Superior Court public criminal records |
| Profile Status | production_read_model |
| Canonical Records | court_case, case_person, court_charge, court_event, source_record |
| Caveats | This is a normalized API/search provenance label, not a separate upstream court portal., Use linked source records and source_ids for upstream provenance when available. |
| Evidence | apps/api/src/server.mjs, data/api_data_map.json, docs/productionization-decision-and-validation-2026-06-06.md |
| Formats | Postgres, ClickHouse read model, JSON API |
| Join Keys | case_id, case_number, case_uid, source_record_ids |
| Known Endpoints | /v1/case-search, /v1/search, /v1/cases/{case_id} |
| Rate Limit Notes | Served through the Bluedoor SFSC API; upstream court collection limits apply to source sync workers, not this read model route. |
| Source Urls | https://api.bluedoor.sh/sf-superior-court/v1/case-search |
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_case_searchJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=sfsc_criminal_case_search&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON