Home › Sources › sfsheriff_current_jail_data_powerbi
SF Sheriff Current Jail Data and Trends
Source ID sfsheriff_current_jail_data_powerbi. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | sfsheriff_current_jail_data_powerbi |
| Name | SF Sheriff Current Jail Data and Trends |
| Owner | San Francisco Sheriff's Office |
| Layer | custody_operations_context |
| Coverage | Current jail PowerBI model exposes daily population, last-180-day, demographics, and length-of-stay pages; saved daily-population querydata parsed into 30 aggregate court_metric rows. |
| Formats | HTML, PowerBI JSON |
| Join keys | report_date, population_count |
| Caveats | Aggregate custody operations context only., Masked booking, demographic, and length-of-stay rows must not be exposed as person-level custody records. |
Linked cases
0 matching cases for this source filter.
No matching cases.
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| - | sfsheriff_current_jail_data_powerbi | public_powerbi_profile | - | - | - |
Full source record
| Access Mode | public_powerbi_embed_querydata |
| Cadence | PowerBI refresh observed in model metadata |
| Coverage | Current jail PowerBI model exposes daily population, last-180-day, demographics, and length-of-stay pages; saved daily-population querydata parsed into 30 aggregate court_metric rows. |
| Government Level | local_sheriff |
| ID | sfsheriff_current_jail_data_powerbi |
| Layer | custody_operations_context |
| Name | SF Sheriff Current Jail Data and Trends |
| Owner | San Francisco Sheriff's Office |
| Profile Status | promoted_bounded_powerbi_metric_extract |
| Canonical Records | court_metric, custody_metric, facility, source_record |
| Caveats | Aggregate custody operations context only., Masked booking, demographic, and length-of-stay rows must not be exposed as person-level custody records. |
| Evidence | artifacts/source-discovery/sfsheriff-current-jail-data.html, artifacts/source-discovery/sfsheriff-powerbi.profile.json, artifacts/source-discovery/sfsheriff-powerbi-querydata-response-1.sample.json, data/court_metrics_raw/sfsheriff-current-jail-daily-population.json, data/court_metrics_raw/sfsheriff-current-jail-daily-population.manifest.json |
| Formats | HTML, PowerBI JSON |
| Join Keys | report_date, population_count |
| Known Endpoints | PowerBI Government public modelsAndExploration, PowerBI Government public conceptualschema, PowerBI Government public querydata |
| Rate Limit Notes | Use pinned resource key/model/query payload for scheduled aggregate sync; do not call PowerBI per API request. |
| Source Urls | https://sfsheriff.com/services/jail-services/current-and-historical-jail-data/current-jail-data-and-trends |
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/sfsheriff_current_jail_data_powerbiJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=sfsheriff_current_jail_data_powerbi&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON