Home › Sources › sfsc_criminal_data_dashboards
SFSC Criminal Case Data Dashboards
Source ID sfsc_criminal_data_dashboards. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | sfsc_criminal_data_dashboards |
| Name | SFSC Criminal Case Data Dashboards |
| Owner | Superior Court of California, County of San Francisco |
| Layer | aggregate_court_performance_and_counsel_capacity |
| Coverage | Official aggregate criminal performance metrics and conflict-counsel/public-defender-unavailability dashboard; saved querydata samples parsed into 292 bounded aggregate court_metric rows. A schema entity map proves the main criminal performance dashboard has no exact case-number rowsets, while the counsel/unavailability model has six case-number-bearing entities. Bounded case-field probes emit 150 source-labeled counsel rows across 123 distinct CRI case numbers, including the May/June 2025 Public Defender errata rowset. |
| Formats | HTML, PowerBI JSON |
| Join keys | case_number, month, case_type, hearing_type, filed_date |
| Caveats | Aggregate dashboard outcomes are not a substitute for per-case court ROA or DA disposition records., Public Defender unavailability metrics have a court-published errata affecting May and June 2025., Dashboard card totals and scalar last-updated rows are skipped unless they carry stable period dimensions., Case-number-bearing counsel rows are source-labeled context only and must not overwrite portal charges, outcomes, or attorney identity., Schema entity map confirms dashboard outcomes are aggregate-only and no charge/statute/offense fields are exposed. |
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_data_dashboards | public_powerbi_profile | - | - | - |
| - | sfsc_criminal_data_dashboards | bounded_case_counsel_context_extract | - | - | - |
| - | sfsc_criminal_data_dashboards | powerbi_schema_entity_field_map | - | - | - |
Full source record
| Access Mode | public_powerbi_embed_querydata |
| Cadence | daily PowerBI refresh observed in model metadata |
| Coverage | Official aggregate criminal performance metrics and conflict-counsel/public-defender-unavailability dashboard; saved querydata samples parsed into 292 bounded aggregate court_metric rows. A schema entity map proves the main criminal performance dashboard has no exact case-number rowsets, while the counsel/unavailability model has six case-number-bearing entities. Bounded case-field probes emit 150 source-labeled counsel rows across 123 distinct CRI case numbers, including the May/June 2025 Public Defender errata rowset. |
| Government Level | local_court |
| ID | sfsc_criminal_data_dashboards |
| Layer | aggregate_court_performance_and_counsel_capacity |
| Name | SFSC Criminal Case Data Dashboards |
| Owner | Superior Court of California, County of San Francisco |
| Profile Status | implemented_pinned_powerbi_sync_worker |
| Canonical Records | court_metric, counsel_capacity_metric, court_counsel_context, court_case_reference, source_record |
| Caveats | Aggregate dashboard outcomes are not a substitute for per-case court ROA or DA disposition records., Public Defender unavailability metrics have a court-published errata affecting May and June 2025., Dashboard card totals and scalar last-updated rows are skipped unless they carry stable period dimensions., Case-number-bearing counsel rows are source-labeled context only and must not overwrite portal charges, outcomes, or attorney identity., Schema entity map confirms dashboard outcomes are aggregate-only and no charge/statute/offense fields are exposed. |
| Evidence | artifacts/source-discovery/sfsc-criminal-data-dashboards-page.html, artifacts/source-discovery/sfsc-criminal-data-dashboards-powerbi.profile.json, artifacts/source-discovery/sfsc-criminal-dashboard-entity-field-map.profile.json, artifacts/source-discovery/sfsc-criminal-dashboard-counsel-case-fields.profile.json, data/court_counsel_context_raw/sfsc-criminal-dashboard-counsel-case-fields.json, data/court_counsel_context_raw/sfsc-criminal-dashboard-counsel-case-fields.manifest.json, data/court_metrics_raw/sfsc-criminal-dashboard-metrics.json, data/court_metrics_raw/manifest.json, scripts/sync_sfsc_powerbi_dashboard_context.py |
| Formats | HTML, PowerBI JSON |
| Join Keys | case_number, month, case_type, hearing_type, filed_date |
| Known Endpoints | PowerBI public modelsAndExploration, PowerBI public conceptualschema, PowerBI public querydata |
| Rate Limit Notes | Use pinned resource keys/model IDs and scheduled aggregate/case-context sync; avoid live PowerBI calls per API request. |
| Source Urls | https://sf.courts.ca.gov/divisions/criminal/criminal-data-dashboards |
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_data_dashboardsJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=sfsc_criminal_data_dashboards&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON