Home › Sources › sfsheriff_custody_booking
San Francisco Sheriff's Office Booking/Custody Sources
Source ID sfsheriff_custody_booking. Use source caveats and join keys before treating context records as court facts.
Source overview
| Source ID | sfsheriff_custody_booking |
| Name | San Francisco Sheriff's Office Booking/Custody Sources |
| Owner | San Francisco Sheriff's Office |
| Layer | custody_context |
| Coverage | Monthly aggregate jail booking counts are verified on DataSF and promoted into court_metrics (3,820 rows from 2012-01 through 2026-04; data_as_of through 2026-05-01). Person-level current custody remains separately policy-gated. |
| Formats | HTML lookup, Socrata API/CSV where available |
| Join keys | booking_number, person_name, booking_date, release_date, court_number, charge_code |
| Caveats | Custody status is sensitive and volatile; production release needs suppression, freshness, and public-interest 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 |
|---|---|---|---|---|---|
| - | sfsheriff_custody_booking | socrata_aggregate_dataset | - | - | - |
Full source record
| Access Mode | public_lookup_and_or_socrata |
| Cadence | operational |
| Coverage | Monthly aggregate jail booking counts are verified on DataSF and promoted into court_metrics (3,820 rows from 2012-01 through 2026-04; data_as_of through 2026-05-01). Person-level current custody remains separately policy-gated. |
| Government Level | local_sheriff |
| ID | sfsheriff_custody_booking |
| Layer | custody_context |
| Name | San Francisco Sheriff's Office Booking/Custody Sources |
| Owner | San Francisco Sheriff's Office |
| Profile Status | promoted_bounded_metric_extract |
| Canonical Records | court_metric, custody_metric, custody_booking, custody_release, case_person, source_record |
| Caveats | Custody status is sensitive and volatile; production release needs suppression, freshness, and public-interest review. |
| Evidence | artifacts/source-metadata/datasf-sheriff-jail-bookings-pnsi-p43w.view.json, artifacts/source-metadata/datasf-sheriff-jail-bookings-pnsi-p43w.sample.json, artifacts/source-discovery/datasf-sheriff-jail-bookings-pnsi-p43w.full-sample.json, data/court_metrics_raw/sfsheriff-jail-booking-aggregate-metrics.json, data/court_metrics_raw/sfsheriff-jail-booking-aggregate-metrics.manifest.json, docs/research/enrichment-findings.md, artifacts/source-discovery/datasf-place-public-safety-context.profile.json |
| Formats | HTML lookup, Socrata API/CSV where available |
| Join Keys | booking_number, person_name, booking_date, release_date, court_number, charge_code |
| Known Endpoints | Socrata /resource/pnsi-p43w.json |
| Rate Limit Notes | Treat current custody lookup as sensitive and lower-priority; prefer historical aggregate/open-data exports for production enrichment. |
| Source Urls | https://www.sfsheriff.com/, https://data.sfgov.org/Public-Safety/Sheriff-Jail-Bookings/pnsi-p43w |
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_custody_bookingJSONGET https://api.bluedoor.sh/sf-superior-court/v1/case-search?source_id=sfsheriff_custody_booking&division=criminal&limit=25&include_facets=trueJSONGET https://api.bluedoor.sh/sf-superior-court/v1/source-artifactsJSON