Home › Sources › bscc_jail_profile_survey
Jail Profile Survey
Source ID bscc_jail_profile_survey. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | bscc_jail_profile_survey |
| Name | Jail Profile Survey |
| Owner | California Board of State and Community Corrections |
| Layer | custody_aggregate_context |
| Coverage | Adult Jail Profile Survey public query dashboard exposes facility-level monthly, countywide monthly, and countywide quarterly modes for San Francisco plus XLSX exports. Bounded December 2025 and 2025 Q4 samples parse into 22 court_metrics rows: 1 countywide ADP row, 15 facility population/sex-by-custody-status rows across 3 facilities, and 6 quarterly operations/spending/release rows. |
| Formats | HTML, JSON, XLSX, PDF |
| Join keys | county, entity_id, entity_name, facility_name, reporting_year, reporting_month, quarter, variable_name |
| Caveats | BSCC states local agencies report the data and may revise submissions., Aggregate custody context only; do not infer person-level custody status., Quarterly values use YYYY01 through YYYY04 period codes in the public API. |
Linked cases
0 matching cases for this source filter.
No matching cases.
Source artifacts
| Artifact ID | Source ID | Artifact Type | Path | URL | Captured At |
|---|---|---|---|---|---|
| - | bscc_jail_profile_survey | public_json_query_profile | - | - | - |
Full source record
| Access Mode | public_json_api_via_query_dashboard |
| Cadence | monthly and quarterly public reporting; public query model observed through 2025 Q4 |
| Coverage | Adult Jail Profile Survey public query dashboard exposes facility-level monthly, countywide monthly, and countywide quarterly modes for San Francisco plus XLSX exports. Bounded December 2025 and 2025 Q4 samples parse into 22 court_metrics rows: 1 countywide ADP row, 15 facility population/sex-by-custody-status rows across 3 facilities, and 6 quarterly operations/spending/release rows. |
| Government Level | state |
| ID | bscc_jail_profile_survey |
| Layer | custody_aggregate_context |
| Name | Jail Profile Survey |
| Owner | California Board of State and Community Corrections |
| Profile Status | promoted_expanded_facility_monthly_quarterly_xlsx_samples |
| Canonical Records | court_metric, custody_metric, facility, jurisdiction, source_record |
| Caveats | BSCC states local agencies report the data and may revise submissions., Aggregate custody context only; do not infer person-level custody status., Quarterly values use YYYY01 through YYYY04 period codes in the public API. |
| Evidence | https://www.bscc.ca.gov/s_fsojailprofilesurvey/, https://jpjdreporting.bscc.ca.gov/jps-query, artifacts/source-discovery/bscc-jp-jd-query-modes.profile.json, artifacts/source-discovery/bscc-jps-san-francisco-sheriff-s-dept-facility-202512-query-model.sample.json, artifacts/source-discovery/bscc-jps-san-francisco-sheriff-s-dept-facility-202512.sample.json, artifacts/source-discovery/bscc-jps-san-francisco-sheriff-s-dept-facility-202512.sample.xlsx, artifacts/source-discovery/bscc-jps-san-francisco-sheriff-s-dept-monthly-202512-adp-query-model.sample.json, artifacts/source-discovery/bscc-jps-san-francisco-sheriff-s-dept-monthly-202512-adp.sample.json, artifacts/source-discovery/bscc-jps-san-francisco-sheriff-s-dept-monthly-202512-adp.sample.xlsx, artifacts/source-discovery/bscc-jps-san-francisco-sheriff-s-dept-quarterly-2025q4-query-model.sample.json, artifacts/source-discovery/bscc-jps-san-francisco-sheriff-s-dept-quarterly-2025q4.sample.json, artifacts/source-discovery/bscc-jps-san-francisco-sheriff-s-dept-quarterly-2025q4.sample.xlsx, data/court_metrics_raw/bscc-jps-san-francisco-sheriff-expanded-metrics.json, data/court_metrics_raw/bscc-jps-san-francisco-sheriff-expanded-metrics.manifest.json, data/court_metrics_raw/bscc-jps-san-francisco-sheriff-adp.json, data/court_metrics_raw/bscc-jps-san-francisco-sheriff-adp.manifest.json |
| Formats | HTML, JSON, XLSX, PDF |
| Join Keys | county, entity_id, entity_name, facility_name, reporting_year, reporting_month, quarter, variable_name |
| Known Endpoints | PUT /api/jpsquery/jurisdictionsMonthlyQueryModel/, PUT /api/jpsquery/jurisdictionsMonthlyDataModel/, PUT /api/jpsquery/jurisdictionsMonthlyExcelDataModel/ |
| Rate Limit Notes | Use dashboard JSON endpoints for scheduled aggregate pulls; store raw JSON and XLSX response envelopes before normalization. |
| Source Urls | https://www.bscc.ca.gov/s_fsojailprofilesurvey/, https://jpjdreporting.bscc.ca.gov/jps-query |
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/bscc_jail_profile_surveyJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=bscc_jail_profile_survey&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON