Home › Sources › ca_courts_judicial_positions
California Courts Judicial Positions Data
Source ID ca_courts_judicial_positions. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | ca_courts_judicial_positions |
| Name | California Courts Judicial Positions Data |
| Owner | Judicial Council of California |
| Layer | state_court_staffing_context |
| Coverage | Judicial Council workbook with county superior-court and appellate judicial-position/staffing rows. The parser promotes 189 statewide aggregate court_metric rows, including San Francisco authorized judges, authorized subordinate judicial officers, and filled staff FTE. |
| Formats | HTML, XLSX, JSON |
| Join keys | county, appellate_district, metric_name, data_updated |
| Caveats | Staffing capacity context only; not case assignment evidence., The source page reports Data updated June 2025; metric period is modeled as the update month. |
Linked cases
0 matching cases for this source filter.
No matching cases.
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| - | ca_courts_judicial_positions | official_xlsx_download_metric_extract | - | - | - |
Full source record
| Access Mode | public_static_xlsx |
| Cadence | annual research data update |
| Coverage | Judicial Council workbook with county superior-court and appellate judicial-position/staffing rows. The parser promotes 189 statewide aggregate court_metric rows, including San Francisco authorized judges, authorized subordinate judicial officers, and filled staff FTE. |
| Government Level | state |
| ID | ca_courts_judicial_positions |
| Layer | state_court_staffing_context |
| Name | California Courts Judicial Positions Data |
| Owner | Judicial Council of California |
| Profile Status | promoted_bounded_statewide_metric_extract |
| Canonical Records | court_metric, court_staffing_metric, source_record |
| Caveats | Staffing capacity context only; not case assignment evidence., The source page reports Data updated June 2025; metric period is modeled as the update month. |
| Evidence | artifacts/source-discovery/ca-courts-judicial-officers-and-court-employees-page.html, artifacts/source-discovery/ca-courts-judicial-positions.sample.xlsx, data/court_metrics_raw/ca-courts-judicial-positions-metrics.json, data/court_metrics_raw/ca-courts-judicial-positions-metrics.manifest.json |
| Formats | HTML, XLSX, JSON |
| Join Keys | county, appellate_district, metric_name, data_updated |
| Known Endpoints | Static XLSX download |
| Rate Limit Notes | Download as a static workbook; do not query per API request. |
| Source Urls | https://courts.ca.gov/news-reference/research-data/judicial-officers-and-court-employees, https://courts.ca.gov/system/files/file/judicial-positions-data.xlsx |
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/ca_courts_judicial_positionsJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=ca_courts_judicial_positions&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON