Home › Sources › ca_doj_openjustice_crime_statistics
California DOJ OpenJustice Crime Statistics
Source ID ca_doj_openjustice_crime_statistics. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | ca_doj_openjustice_crime_statistics |
| Name | California DOJ OpenJustice Crime Statistics |
| Owner | California Department of Justice / Criminal Justice Statistics Center |
| Layer | statewide_public_safety_context |
| Coverage | OpenJustice chart endpoints, JSON:API stats nodes, publication registry, and Data Portal dataset registry expose statewide/county aggregate arrests, arrest dispositions, adult probation, crimes/clearances, domestic violence, death-in-custody, LEOKA, personnel, hate-crime prosecution, homicide, juvenile justice, RIPA, use-of-force, and related CJSC context. The Data Portal profile maps 23 datasets, 133 files, and 57 CSVs, with direct dataset files for all 15 CJSC catalog families. Bounded San Francisco chart/report/CSV parsers now promote 55,132 OpenJustice court_metric rows: 170 annual chart rows for 2005-2014, four 2024 Hate Crime report-table rows, 320 Hate Crime Prosecution Survey rows for 2004-2024, and 54,638 direct county-CSV rows across 13 files / 10 metric families. A statewide JCPSS parser streams 1,863,648 juvenile court/probation rows for 2007-2024 from two large raw CSVs and promotes 4,305 statewide aggregate metrics while documenting that no county column is present. |
| Formats | JSON, JSON:API, HTML, CSV |
| Join keys | county, year, agency, offense_group, metric_name |
| Caveats | OpenJustice rows are aggregate context, not case facts., The bounded chart extract uses the public dashboard's 2005-2014 year axis; production should prefer downloadable modern source files where available., The public chart endpoint returned bounded 2005-2014 trend rows in profiling; 2015+ current coverage needs publication/raw-file or alternate download endpoint discovery., The 2024 Hate Crime report extract is a single official PDF table row promoted as county context, not a full report parser., OpenJustice Data Portal has large RIPA ZIPs and 100MB+ juvenile CSVs; use staged sync/profiling jobs and never fetch those payloads in API request paths., Hate Crime Prosecution Survey rows are aggregate prosecutor/county context only, not per-case SFSC outcomes., OpenJustice county CSV metric rows are aggregate county/agency/demographic context only; they do not identify specific SFSC cases or parties., JCPSS juvenile court/probation raw CSVs have no county field; promoted JCPSS metrics are statewide context, not San Francisco-specific juvenile court facts. |
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_doj_openjustice_crime_statistics | public_chart_endpoint_samples | - | - | - |
| - | ca_doj_openjustice_crime_statistics | official_catalog_endpoint_map | - | - | - |
| - | ca_doj_openjustice_crime_statistics | jsonapi_publication_registry | - | - | - |
| - | ca_doj_openjustice_crime_statistics | jsonapi_stats_source_file_registry | - | - | - |
| - | ca_doj_openjustice_crime_statistics | pdf_table_extract | - | - | - |
| - | ca_doj_openjustice_crime_statistics | openjustice_county_csv_metric_extract | - | - | - |
| - | ca_doj_openjustice_crime_statistics | openjustice_dataset_file_registry | - | - | - |
| - | ca_doj_openjustice_crime_statistics | openjustice_small_csv_metric_extract | - | - | - |
| - | ca_doj_openjustice_crime_statistics | openjustice_statewide_jcpss_metric_extract | - | - | - |
Full source record
| Access Mode | public_chart_post_and_jsonapi_catalog |
| Cadence | state dashboard/catalog refresh |
| Coverage | OpenJustice chart endpoints, JSON:API stats nodes, publication registry, and Data Portal dataset registry expose statewide/county aggregate arrests, arrest dispositions, adult probation, crimes/clearances, domestic violence, death-in-custody, LEOKA, personnel, hate-crime prosecution, homicide, juvenile justice, RIPA, use-of-force, and related CJSC context. The Data Portal profile maps 23 datasets, 133 files, and 57 CSVs, with direct dataset files for all 15 CJSC catalog families. Bounded San Francisco chart/report/CSV parsers now promote 55,132 OpenJustice court_metric rows: 170 annual chart rows for 2005-2014, four 2024 Hate Crime report-table rows, 320 Hate Crime Prosecution Survey rows for 2004-2024, and 54,638 direct county-CSV rows across 13 files / 10 metric families. A statewide JCPSS parser streams 1,863,648 juvenile court/probation rows for 2007-2024 from two large raw CSVs and promotes 4,305 statewide aggregate metrics while documenting that no county column is present. |
| Government Level | state |
| ID | ca_doj_openjustice_crime_statistics |
| Layer | statewide_public_safety_context |
| Name | California DOJ OpenJustice Crime Statistics |
| Owner | California Department of Justice / Criminal Justice Statistics Center |
| Profile Status | promoted_bounded_metric_and_dataset_file_extract |
| Canonical Records | court_metric, agency_profile, source_record, source_publication_file |
| Caveats | OpenJustice rows are aggregate context, not case facts., The bounded chart extract uses the public dashboard's 2005-2014 year axis; production should prefer downloadable modern source files where available., The public chart endpoint returned bounded 2005-2014 trend rows in profiling; 2015+ current coverage needs publication/raw-file or alternate download endpoint discovery., The 2024 Hate Crime report extract is a single official PDF table row promoted as county context, not a full report parser., OpenJustice Data Portal has large RIPA ZIPs and 100MB+ juvenile CSVs; use staged sync/profiling jobs and never fetch those payloads in API request paths., Hate Crime Prosecution Survey rows are aggregate prosecutor/county context only, not per-case SFSC outcomes., OpenJustice county CSV metric rows are aggregate county/agency/demographic context only; they do not identify specific SFSC cases or parties., JCPSS juvenile court/probation raw CSVs have no county field; promoted JCPSS metrics are statewide context, not San Francisco-specific juvenile court facts. |
| Evidence | artifacts/source-discovery/openjustice-query-catalog.json, artifacts/source-discovery/openjustice-node-stats-page0-limit100.json, artifacts/source-discovery/openjustice-sf-arrests-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-felony-arrests-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-misdemeanor-arrests-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-violent-crimes-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-violent-clearances-time-trends.sample.json, data/court_metrics_raw/ca-doj-openjustice-sf-public-safety-metrics.json, data/court_metrics_raw/ca-doj-openjustice-sf-public-safety-metrics.manifest.json, artifacts/source-discovery/openjustice-sf-status-offense-arrests-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-property-crimes-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-property-clearances-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-deaths-in-custody-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-arrest-related-deaths-in-custody-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-in-custody-deaths-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-leoka-assaults-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-leoka-assaults-with-injuries-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-leoka-assaults-without-injuries-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-leoka-deaths-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-leoka-felony-deaths-time-trends.sample.json, artifacts/source-discovery/openjustice-sf-leoka-accidental-deaths-time-trends.sample.json, artifacts/source-discovery/ca-doj-cjsc-family-endpoint-map.profile.json, artifacts/source-discovery/openjustice-node-publication-page0-limit100.json, artifacts/source-discovery/openjustice-node-publication-with-files-page0-limit100.json, artifacts/source-discovery/openjustice-node-stats-with-source-files-page0-limit100.json, artifacts/source-discovery/openjustice-stats-source-files.rows.json, artifacts/source-discovery/openjustice-stats-source-files.profile.json, artifacts/source-discovery/current-openjustice-app.27bd7a2568ccfb17905a.js, artifacts/source-discovery/current-openjustice-query-catalog.json, artifacts/source-discovery/openjustice-chart-year-window.profile.json, data/source_publication_files/openjustice-publication-files.json, data/source_publication_files/openjustice-publication-files.manifest.json, artifacts/source-discovery/openjustice-publications/Hate Crime In CA 2024.pdf, artifacts/source-discovery/openjustice-publications/Hate Crime In CA 2024.txt, artifacts/source-discovery/openjustice-hate-crime-2024-report-table.profile.json, data/court_metrics_raw/ca-doj-openjustice-hate-crime-2024-sf-report-metrics.json, data/court_metrics_raw/ca-doj-openjustice-hate-crime-2024-sf-report-metrics.manifest.json, artifacts/source-discovery/openjustice-dataset-files.profile.json, artifacts/source-discovery/openjustice-dataset-files.rows.json, artifacts/source-discovery/openjustice-node-dataset-with-files-page0-limit100.json, artifacts/source-discovery/current-openjustice-chunk-6-data-item.84c3bc7f5ac8a6f6f92c.js, artifacts/source-discovery/current-openjustice-resources-page.openjustice.live.html, artifacts/source-discovery/openjustice-hate-crime-prosecution-survey-sf.profile.json, artifacts/source-discovery/openjustice-hate-crime-prosecution-survey-2004-2024.sample.csv, data/court_metrics_raw/ca-doj-openjustice-hate-crime-prosecution-sf-metrics.json, data/court_metrics_raw/ca-doj-openjustice-hate-crime-prosecution-sf-metrics.manifest.json, artifacts/source-discovery/openjustice-county-csv-sf-metrics.profile.json, data/court_metrics_raw/ca-doj-openjustice-county-csv-sf-metrics.json, data/court_metrics_raw/ca-doj-openjustice-county-csv-sf-metrics.manifest.json, artifacts/source-discovery/openjustice-county-csvs/, artifacts/source-discovery/openjustice-juvenile-court-probation-jcpss.profile.json, artifacts/source-discovery/openjustice-juvenile-court-probation-context-06162025.pdf, artifacts/source-discovery/openjustice-juvenile-court-probation-context-06162025.txt, data/court_metrics_raw/ca-doj-openjustice-juvenile-court-probation-statewide-metrics.json, data/court_metrics_raw/ca-doj-openjustice-juvenile-court-probation-statewide-metrics.manifest.json |
| Formats | JSON, JSON:API, HTML, CSV |
| Join Keys | county, year, agency, offense_group, metric_name |
| Known Endpoints | POST /filter-queries/agencies-load-data.php, GET /jsonapi/node/stats, GET /jsonapi/node/stats?include=field_source, GET /jsonapi/file/file, GET /jsonapi/node/dataset?include=field_source |
| Rate Limit Notes | Use cached chart/query pulls for aggregate context; prefer JSON:API catalog and downloadable files for production backfills when available. |
| Source Urls | https://data-openjustice.doj.ca.gov/exploration/crime-statistics, https://data-openjustice.doj.ca.gov/filter-queries/agencies-load-data.php, https://data-openjustice.doj.ca.gov/jsonapi/node/stats, https://data-openjustice.doj.ca.gov/jsonapi/node/publication, https://openjustice.doj.ca.gov/data, https://data-openjustice.doj.ca.gov/jsonapi/node/dataset |
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_doj_openjustice_crime_statisticsJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=ca_doj_openjustice_crime_statistics&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON