Home › Sources › ca_post_law_enforcement_context
California POST Law Enforcement Context
Source ID ca_post_law_enforcement_context. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | ca_post_law_enforcement_context |
| Name | California POST Law Enforcement Context |
| Owner | California Commission on Peace Officer Standards and Training |
| Layer | agency_and_officer_context |
| Coverage | POST agency statistics, reimbursement/program data, current demographics dashboards, and public certification-action table. The bounded parser promotes 220 county aggregate agency staffing metrics into agency_profiles, including San Francisco County rows. |
| Formats | HTML, PowerBI JSON, JSON |
| Join keys | agency_name, agency_number, county, agency_ori, officer_name |
| Caveats | Officer certification actions are high sensitivity; do not name-join to cases without direct identifiers and review. |
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_post_law_enforcement_context | public_powerbi_and_html_profile | - | - | - |
Full source record
| Access Mode | public_powerbi_embed_and_html_table |
| Cadence | daily PowerBI refresh observed; certification table changes as actions are posted |
| Coverage | POST agency statistics, reimbursement/program data, current demographics dashboards, and public certification-action table. The bounded parser promotes 220 county aggregate agency staffing metrics into agency_profiles, including San Francisco County rows. |
| Government Level | state |
| ID | ca_post_law_enforcement_context |
| Layer | agency_and_officer_context |
| Name | California POST Law Enforcement Context |
| Owner | California Commission on Peace Officer Standards and Training |
| Profile Status | promoted_bounded_agency_profile_extract |
| Canonical Records | agency_profile, law_enforcement_staffing_metric, certification_action, source_record |
| Caveats | Officer certification actions are high sensitivity; do not name-join to cases without direct identifiers and review. |
| Evidence | artifacts/source-discovery/ca-post-law-enforcement-profile.profile.json, artifacts/source-discovery/ca-post-powerbi-agency-stats-querydata-response.sample.json, data/agency_profiles_raw/ca-post-law-enforcement-agency-profiles.json, data/agency_profiles_raw/manifest.json, scripts/parse_ca_post_agency_profiles.py |
| Formats | HTML, PowerBI JSON, JSON |
| Join Keys | agency_name, agency_number, county, agency_ori, officer_name |
| Known Endpoints | PowerBI public modelsAndExploration, PowerBI public conceptualschema, PowerBI public querydata, HTML certification actions table |
| Rate Limit Notes | Use scheduled dashboard/table sync; do not call POST dashboards per API request. |
| Source Urls | https://post.ca.gov/Data-Warehouse, https://post.ca.gov/Peace-Officer-Certification-Actions |
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_post_law_enforcement_contextJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=ca_post_law_enforcement_context&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON