Home › Sources
Sources
70 public source definitions behind the SF Superior Court API. Source pages include caveats and sample linked cases when the source joins to court records.
| Source ID | Name | Owner | Layer | Canonical Records | Coverage | Formats |
|---|---|---|---|---|---|---|
| sfsc_criminal_case_search | SFSC Criminal Case Search Read Model | Bluedoor normalized from SF Superior Court public criminal records | derived_case_search_read_model | court_case, case_person, court_charge, court_event, source_record | Normalized criminal case-search rows served by the production SF Superior Court API read model. | Postgres, ClickHouse read model, JSON API |
| sfsc_criminal_portal | San Francisco Superior Court Criminal Portal | Superior Court of California, County of San Francisco | core_court_record | court_case, case_person, court_charge, court_event, source_record | Criminal cases exposed by crimportal.dll; observed historical floor case_id 1548625 with records back to the 1970s/1980s and present-day CRI cases. | HTML, DataSnap JSON envelope |
| sfsc_criminal_cumulative_index | San Francisco Superior Court Cumulative Criminal Index and Bench Warrants | Superior Court of California, County of San Francisco | core_court_record | court_case, case_person, court_charge, court_event, source_record | Official SFSC cumulative criminal index and bench-warrant search surface exposed by crimindex.dll; profile verified the page, lookup.js DataSnap contract, zero-result behavior, and a capped positive bench-warrant result set. | HTML, JavaScript, DataSnap JSON envelope |
| sfsc_civil_portal | San Francisco Superior Court Civil/Family/Probate/UD CaseInfo Portal | Superior Court of California, County of San Francisco | core_court_record | court_case, case_person, court_event, court_document, court_payment, attorney_license_hint, source_record | Civil, unlawful detainer, appeals, family/probate-style CaseInfo records; filing-date enumeration observed back at least to 2000, with evidence for older scope in research notes. Live multi-date filing-date enumeration now proves 431 filing rows across sampled 2010, 2015, 2020, 2024, and 2026 filing dates. | HTML, DataSnap JSON envelope, proxied document URLs |
| sfsc_calendar_portal | San Francisco Superior Court Case Calendar Portal | Superior Court of California, County of San Francisco | near_term_calendar | court_calendar_event, court_event, court_case_reference, source_record | Current/future public court calendars by date/type plus name-search calendar rows. A 2026-05-30 headed Agent Browser refresh observed 8,684 endpoint rows across six positive result sets and promoted a bounded 139-row normalized extract into court_calendar_events: 18 Law & Motion, 21 Probate, 25 Unified Family Court, 50 Criminal, and 25 civil SMITH name-search rows with historical dates back to 1928-05-22. | DataSnap JSON envelope |
| sfsc_traffic_payment_portal | SFSC Traffic Citation Payment and Lookup Portal | Superior Court of California, County of San Francisco / nCourt | traffic_case_payment_lookup_context | traffic_case_lookup, court_payment_context, source_record | Authorized nCourt payment/search page for San Francisco Superior Court Traffic Infractions Division. The static page exposes a record-search form with case number, citation number, and driver's license search modes, payment/service-fee text, and traffic-school/payment availability caveats. No lookup was submitted. | HTML, ASP.NET form |
| sfsc_tentative_rulings | San Francisco Superior Court Tentative Rulings | Superior Court of California, County of San Francisco | court_ruling_context | tentative_ruling, court_event, case_person, source_record | Civil, family law, probate, asbestos, law-and-motion/discovery, and real-property housing tentative ruling surfaces. UFC endpoint exposed 24 current/previous PDF links on 2026-05-30; the bounded parser downloaded those 24 public PDFs and extracted 173 tentative-ruling metadata/outcome-hint rows. A headed Agent Browser tr.dll reprobe minted a public session, proved GetRulings, and found 145 records across 8 RulingID calendars over 2026-05-29 and 2026-06-01; 4 bounded tr.dll sample rows now load into the sample API. | HTML, PDF, captcha-gated HTML |
| hf_sf_criminal_court | jamiequint/sf_criminal_court Hugging Face Dataset | Independent public dataset compiler using SFSC and public agency sources | reference_enrichment | court_case, court_charge, charge_disposition, prosecution_event, arrest_event, judge_assignment, source_record | Public Hugging Face parquet snapshot last modified 2026-05-04 with 13 tables: 77,406 cases, 776,728 ROA rows, 72,289 attorney rows, 318,993 calendar rows, 318,993 calendar+judge-assignment rows, 44,029 SFSC charge-disposition rows, 13,790 inferred SFSC case matches, DA arrest/prosecuted tables, and judicial assignment dimensions. The prototype now loads a bounded 120-case reference extract into the API: 120 cases, 4,079 docket rows, 452 attorney rows, 1,844 judge-enriched hearing rows, 340 charge-disposition rows, and 292 court-charge outcome rows. | Parquet |
| sf_assessor_recorder_records_manager | SF Assessor-Recorder Records Manager | San Francisco Office of the Assessor-Recorder | recorded_document_property_context | recorded_document, property_document_reference, party_name_context, source_record | Official Assessor-Recorder recorded-document access path. SF.gov says records from 1990 to present can be searched in Records Manager and viewed online for free, with official copies available for purchase; preview requires registered user ID verification. Static Records Manager config exposes SearchService endpoints including Search/GetSearchResults, Search/GetSelectAllDocumentList, search/GetDocumentDetails, search/GetDocumentPages, and Search/Image. No search or document download was submitted. | HTML, Angular app, SearchService JSON API config |
| datasf_sfpd_drone_flight_logs_giw5_ttjs | San Francisco Police Department Drone Flight Logs | San Francisco Police Department / DataSF | public_safety_response_context | public_safety_event, source_record | Full small DataSF SFPD drone-flight log extract: 5,363 rows from 2024-05-16 through 2026-03-31. Rows include date, case_cad_event_number, flight duration, reason for flight, location, neighborhood, supervisor district, and point geometry, and now load into public_safety_events as sfpd_drone_flight context. | JSON API, CSV, GeoJSON |
| datasf_police_incident_code_crosswalk_ci9u_8awy | Reference: Police Department Incident Code Crosswalk | San Francisco Police Department / DataSF | incident_reference | incident_code_crosswalk, source_record | Official DataSF incident-code crosswalk exposes 1,012 inc_code rows across 53 observed categories. The bounded parser loads all rows into incident_code_crosswalk and uses incident_code to normalize SFPD incident rows. | JSON API, CSV |
| sfda_arrests | San Francisco District Attorney Actions Taken on Arrests Presented | San Francisco District Attorney / DataSF | incident_arrest_prosecution | prosecution_event, agency_action, court_charge, source_record | Every arrest presented to SFDA since 2011; the full paged Socrata pull generated 2026-06-05 captured 177,387 rows from 2011-01-01 through 2026-05-31, with data_loaded_at 2026-06-01T22:09:14.737. The local sample index and full public RDS/Postgres corpus load all 177,387 arrest-action rows into prosecution_events with one upstream source_record per row; 25,361 full-corpus rows exact-join to court cases by normalized court_number/case_number. | JSON API, CSV, OData, Parquet via derived mirrors |
| sfda_prosecuted_cases | San Francisco District Attorney Cases Prosecuted | San Francisco District Attorney / DataSF | incident_arrest_prosecution | prosecution_event, court_charge, case_outcome, source_record | Cases where SFDA filed charges or motions to revoke; the full paged Socrata pull generated 2026-06-05 captured 121,641 rows from 2011-01-01 through 2026-05-29, including 109,267 distinct court_number values and 101,352 distinct incident_number values. The local sample index and full public RDS/Postgres corpus load all prosecuted-case rows into prosecution_events and DA-derived case_outcomes with one upstream source_record per row; 24,336 full-corpus rows exact-join to court cases by normalized court_number/case_number. | JSON API, CSV, OData, Parquet via derived mirrors |
| sfda_case_resolutions | San Francisco District Attorney Case Resolutions | San Francisco District Attorney / DataSF | disposition_enrichment | case_outcome, prosecution_event, court_charge, source_record | Criminal cases prosecuted by SFDA that reached final resolution/disposition; the full paged Socrata pull generated 2026-06-05 captured 81,162 rows with disposition_date 2011-01-04 through 2026-05-29, including 81,162 distinct court_number values and 76,300 distinct incident_number values. The local sample index and full public RDS/Postgres corpus load all resolution rows into prosecution_events and DA-derived case_outcomes with one upstream source_record per row; 16,062 full-corpus rows exact-join to court cases by normalized court_number/case_number. | JSON API, CSV, OData, Parquet via derived mirrors |
| datasf_police_incidents_2018_present | DataSF Police Department Incident Reports 2018 to Present | San Francisco Police Department / DataSF | incident_context | police_incident, place_context, agency_action, source_record | Current SFPD incident reports from 2018-01-01 through at least 2026-05-29; live profile counted 1,034,340 rows through 2026-05-28, and the 2026-05-30 bounded sync observed latest data_as_of 2026-05-30 and latest data_loaded_at 2026-05-30. The prototype loads 23 DA-bridged linked rows across 9 incident numbers plus a checkpointed recent-sync slice of 1,000 current incident rows into police_incidents. | JSON API, CSV, GeoJSON |
| datasf_police_incidents_historical | DataSF Police Department Incident Reports Historical 2003 to May 2018 | San Francisco Police Department / DataSF | incident_context | incident, place_context, agency_action, source_record | Historical SFPD incident records from 2003-01-01 through 2018-05-15; the prototype now loads a checkpointed 1,000-row recent historical slice from 2018-05-09 through 2018-05-15 plus the original 1-row official sample into police_incidents. | JSON API, CSV, GeoJSON |
| datasf_law_enforcement_dispatch_calls | DataSF Law Enforcement Dispatched Calls | San Francisco Department of Emergency Management / DataSF | call_for_service_context | dispatch_call, place_context, source_record | Rolling 48-hour window of law-enforcement dispatched calls resulting in an agency dispatch. | JSON API, CSV, GeoJSON |
| datasf_law_enforcement_dispatch_closed | DataSF Law Enforcement Dispatched Calls for Service: Closed | San Francisco Department of Emergency Management / DataSF | call_for_service_context | dispatch_call, place_context, source_record | Historical closed law-enforcement dispatch calls from 2014-12-31 through 2026-05-28 in the aggregate probe; the 2026-05-30 bounded sync loaded 1,000 recent rows from 2026-05-29T13:00:42 through 2026-05-29T23:48:37, with latest data_as_of 2026-05-30 and latest data_loaded_at 2026-05-30. The prototype also keeps 11 CAD-bridged fixture rows, so dispatch_calls now exercises 1,011 closed CAD rows. | JSON API, CSV, GeoJSON |
| sfsheriff_custody_booking | San Francisco Sheriff's Office Booking/Custody Sources | San Francisco Sheriff's Office | custody_context | court_metric, custody_metric, custody_booking, custody_release, case_person, source_record | 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. | HTML lookup, Socrata API/CSV where available |
| sfsheriff_current_jail_data_powerbi | SF Sheriff Current Jail Data and Trends | San Francisco Sheriff's Office | custody_operations_context | court_metric, custody_metric, facility, source_record | 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. | HTML, PowerBI JSON |
| datasf_sheriff_inspector_general | DataSF Sheriff's Inspector General Cases and Resolutions | San Francisco Sheriff's Office Inspector General / DataSF | agency_oversight_context | agency_oversight_case, source_record | Public Sheriff Inspector General oversight dataset has 76 allegation/deputy-involvement rows across 39 distinct oversight cases; complaint_received_date spans 2023-01-31 through 2026-01-20, latest findings_issued_date 2026-02-02, latest data_loaded_at 2026-05-29. | JSON API, CSV |
| sf_dpa_policing_complaint_reports | San Francisco DPA Policing Complaint Dashboard and Reports | San Francisco Department of Police Accountability | agency_oversight_aggregate_context | court_metric, oversight_metric, source_record | Official DPA report pages and three public PowerBI Government embeds covering aggregate complaint cases opened/closed/sustained, allegation categories, and finding categories. The bounded parser promotes 37 aggregate metric rows from saved querydata for 2019-2025. | HTML, PDF, PowerBI querydata, JSON |
| datasf_dpa_misconduct_cases_b4we_97wx | DataSF Police Accountability Misconduct Cases and Allegations | San Francisco Department of Police Accountability / DataSF | agency_oversight_context | agency_oversight_case, source_record | Full small DataSF DPA misconduct cases/allegations extract: 8,793 rows across 2,063 distinct DPA case numbers. Complaint received dates span 2017-01-06 through 2026-03-29; findings issued dates span 2024-01-02 through 2026-03-30; latest observed data_loaded_at is 2026-05-29T12:10:00.581. Rows now load into agency_oversight_cases as source-labeled DPA allegation context. | JSON API, CSV, GeoJSON |
| datasf_sfpd_victim_suspect_demographics_cd9v_umhr | DataSF Police Department Reported Victim and Suspect Demographic Data | San Francisco Police Department / DataSF | aggregate_public_safety_demographic_context | court_metric, source_record | DataSF SFPD reported victim/suspect demographic dataset has 300,835 aggregate source rows from 2013-01-01 through 2026-01-01, latest data_as_of 2026-05-28 and data_loaded_at 2026-05-28. The prototype promotes 15,944 grouped metric rows covering category/role/quarter, recent district/category/role, recent demographic mix, and hate-crime bias aggregates into court_metrics. | JSON API, CSV |
| bscc_jail_profile_survey | Jail Profile Survey | California Board of State and Community Corrections | custody_aggregate_context | court_metric, custody_metric, facility, jurisdiction, source_record | 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. | HTML, JSON, XLSX, PDF |
| bscc_juvenile_detention_profile_survey | Juvenile Detention Profile Survey | California Board of State and Community Corrections | juvenile_detention_aggregate_context | court_metric, juvenile_detention_metric, facility, jurisdiction, source_record | The same BSCC JP/JD public app bundle exposes Juvenile Detention Profile Survey endpoints under jdsquery. Bounded San Francisco samples verify facility-level monthly, countywide monthly, and countywide quarterly modes plus XLSX exports; December 2025 and 2025 Q4 samples parse into 13 court_metrics rows across Juvenile Justice Center, Secure Youth Treatment Facility, countywide juvenile hall ADP, length-of-stay, and assault metrics. | HTML, JSON, XLSX, PDF |
| cdcr_population_data_points | CDCR Population Data Points | California Department of Corrections and Rehabilitation | state_corrections_context | court_metric, agency_profile, source_record | Population Data Points public PowerBI model exposes admissions, releases, in-custody, parole, youth population, county/location, offense, sentence, and demographic dimensions. Bounded parser promotes 100 aggregate admissions rows: 40 statewide monthly counts and 60 county all-month average rows for 2023-01 through 2026-04. | HTML, PowerBI querydata, PDF archive |
| calbar_attorney_search | State Bar of California Attorney Search | The State Bar of California | attorney_identity | attorney_license, attorney_license_event, attorney_license_candidate, case_person, source_record | California attorney license number, status, city, admission date, firm/address, public detail lookup, and detail-page license history. The case-seeded cache now covers 454 hydrated case-attorney rows, 161 unique attorney-name searches, 3 direct SFSC civil BARNUM detail hits, 115 one-result name hits, 26 ambiguous name-query buckets, and 20 no-hit name queries. The promoted index contains 117 attorney_licenses, 539 attorney_license_candidates, and 241 attorney_license_events; the bounded public discipline sample brings the profile to 249 parsed history rows and proves discipline/admin rows and State Bar Court case-number extraction. | HTML |
| california_codes_leginfo | California Legislative Information Code Text | California Legislative Counsel | statute_reference | statute, court_charge, source_record | California code sections such as Penal Code, Health and Safety Code, Vehicle Code, and Welfare and Institutions Code. Official PUBINFO downloads provide session/current/daily archives with code and law-section tables. The sample index includes 17 bounded official section-page fixtures; a current PUBINFO range extractor now proves CODES_TBL, LAW_SECTION_TBL, LAW_SECTION_TBL_*.lob, LAW_TOC_TBL, and LAW_TOC_SECTIONS_TBL parsing by extracting PEN:487, HSC:11352, and VEH:10851 from pubinfo_2025.zip without downloading the full 915 MB archive. | HTML, ZIP, tab_delimited, LOB, SQL |
| sfsc_judicial_assignments | SFSC Judicial Assignments and Department/Judge Dimensions | SFSC public postings and derived HF tables | judge_context | judge, judge_assignment, court_event, source_record | Current department-to-judge assignments effective April 27, 2026, plus official SFSC search/news/PDF-derived historical assignment intervals spanning 2020-01-21 through 2025-10-01 with 621 OCR/text-derived historical rows. | HTML, PDF, Parquet |
| datasf_analysis_neighborhoods | DataSF Analysis Neighborhoods | City and County of San Francisco / DataSF | place_context | place_context, neighborhood, source_record | San Francisco analysis-neighborhood polygons. | GeoJSON, JSON API, CSV |
| datasf_neighborhood_zip_crosswalk_jc98_7xvv | DataSF Analysis Neighborhoods to ZIP Code Crosswalk | City and County of San Francisco / DataSF | place_reference_context | place_context, neighborhood_zip_crosswalk, source_record | Static DataSF analysis-neighborhood to ZIP Code crosswalk: 152 source rows covering 41 analysis neighborhoods and 27 ZIP codes, latest data_loaded_at 2023-06-23T18:21:48.562Z. Rows collapse to 150 unique neighborhood/ZIP place rows plus 152 source_records. | JSON API, CSV |
| datasf_high_injury_network_2022_8vtn_qytr | DataSF 2022 High Injury Network | DataSF / San Francisco Department of Public Health / Vision Zero | place_reference_context | place_context, high_injury_network_segment, source_record | Full DataSF 2022 High Injury Network extract: 7,988 Socrata rows across 133 street names, data_as_of 2024-08-20T14:06:40.430 and data_loaded_at 2024-08-20T14:22:43.054. The source contains 2,388 unique objectid/CNN segments and 5,600 duplicate segment occurrences; places deduplicates to high_injury_network_segment context while source_records preserves each Socrata row ID. | JSON API, CSV, GeoJSON |
| datasf_high_injury_network_2024_enwt_3u8m | DataSF 2024 High Injury Network | DataSF / San Francisco Department of Public Health / Vision Zero | place_reference_context | place_context, high_injury_network_segment, source_record | Full DataSF 2024 High Injury Network extract: 5,917 Socrata rows across 126 street names, data_as_of 2026-03-23T14:09:36.223 and data_loaded_at 2026-03-23T14:12:26.483. The source contains 1,917 unique objectid/CNN segments and 4,000 duplicate segment occurrences; places deduplicates to high_injury_network_segment context while source_records preserves each Socrata row ID. | JSON API, CSV, GeoJSON |
| datasf_police_districts_current | DataSF Current Police Districts | San Francisco Police Department / DataSF | place_context | place_context, police_district, source_record | Current SFPD police district geometry; 1-row bounded sample now loads into places. Additional boundary profile found current ArcGIS district attributes, official SFPD DGO 1.02 boundary narratives, SFPD/Controller boundary-analysis report metadata, and a 2003 public shapefile catalog derived from an SFPD shapefile. | GeoJSON, JSON API, CSV |
| census_acs_tiger | US Census ACS and TIGER/Line Geography | US Census Bureau | demographic_geographic_context | place_context, demographic_metric, source_record | Census block, tract, block group, ACS demographic and socioeconomic context. | JSON API, Shapefile, GeoJSON |
| usaspending_awards | USAspending Federal Awards | US Department of the Treasury / USAspending | federal_program_context | program_context, agency_action, source_record | Federal award and agency spending records involving San Francisco recipients or programs. | JSON API |
| courtlistener_recap_federal_overlap | CourtListener / RECAP Federal Case Data | Free Law Project | federal_court_overlap_context | external_case, external_party, attorney_reference, court_document, source_record | CourtListener/RECAP federal dockets, docket entries, parties, attorneys, courts, FJC Integrated Database fields, RECAP documents, search, and public bulk CSV exports. Current bounded S3 probe found March 31, 2026 docket and opinion snapshots, with dockets near 4.98 GB and opinions near 54.19 GB compressed. | JSON API, CSV, bzip2, HTML |
| sfsc_criminal_data_dashboards | SFSC Criminal Case Data Dashboards | Superior Court of California, County of San Francisco | aggregate_court_performance_and_counsel_capacity | court_metric, counsel_capacity_metric, court_counsel_context, court_case_reference, source_record | Official aggregate criminal performance metrics and conflict-counsel/public-defender-unavailability dashboard; saved querydata samples parsed into 292 bounded aggregate court_metric rows. A schema entity map proves the main criminal performance dashboard has no exact case-number rowsets, while the counsel/unavailability model has six case-number-bearing entities. Bounded case-field probes emit 150 source-labeled counsel rows across 123 distinct CRI case numbers, including the May/June 2025 Public Defender errata rowset. | HTML, PowerBI JSON |
| ca_courts_csr_filing_disposition | California Courts Court Statistics Report Filing and Disposition Data | Judicial Council of California | state_court_volume_context | court_metric, jurisdiction, source_record | Statewide county/fiscal-year/case-type filing and disposition CSV; San Francisco rows parsed into 394 court_metric rows for fiscal years ending 2016 through 2025. | CSV |
| ca_courts_judicial_positions | California Courts Judicial Positions Data | Judicial Council of California | state_court_staffing_context | court_metric, court_staffing_metric, source_record | Judicial Council workbook with county superior-court and appellate judicial-position/staffing rows. The parser promotes 189 statewide aggregate court_metric rows, including San Francisco authorized judges, authorized subordinate judicial officers, and filled staff FTE. | HTML, XLSX, JSON |
| ca_cjp_public_decisions | California Commission on Judicial Performance Public Decisions Database | California Commission on Judicial Performance | state_judicial_discipline_context | judicial_discipline_record, judge_assignment_context, source_record | Public judicial disciplinary cases since the commission's inception, searchable by judge name, date of decision, disposition, misconduct type, county, and court level. The San Francisco Superior Court probe returned two public decision rows, now parsed into judicial_discipline_record rows and exposed through the sample API. | HTML, PDF |
| sfsc_bail_bonds_reports | SFSC Monthly Bail Bonds Reports | Superior Court of California, County of San Francisco | case_financial_custody_context | bail_bond, court_case_reference, source_record | Monthly bail-bond PDF reports observed from January 2024 through April 2026; full-index extraction parses all 28 PDFs into 1,851 bail_bond rows with zero failed PDFs and zero row errors. | HTML, PDF, text_extract, layout_text, JSON |
| datasf_housing_rent_board_context | DataSF Housing, Eviction, and Rent Board Context | San Francisco Rent Board / DataSF | civil_ud_housing_context | housing_notice, rent_board_petition, housing_buyout, housing_protected_status_request, place_context, source_record | Eviction notices and Rent Board petitions from 1997, protected-status OMI requests from 1999, and buyout agreements from 2015, all current through 2026-05 profile probes; 20 bounded rows across all four datasets now load into housing_context. | JSON API, CSV, GeoJSON |
| datasf_rent_board_appeals_w2ze_eag5 | DataSF Appeals to the Rent Board | San Francisco Rent Board / DataSF | civil_ud_housing_context | housing_context, rent_board_appeal, source_record | Full small DataSF Rent Board appeals extract: 5,178 rows from 1997-01-03 through 2026-05-22, latest data_loaded_at 2026-05-30T05:23:10.000. Rows include appeal_id, filing party, hardship and interpreter flags, address, ZIP, neighborhood, supervisor district, and point geometry, and now load into housing_context as rent_board_appeal rows. | JSON API, CSV, GeoJSON |
| datasf_police_stop_data | DataSF Police Department Stop Data | San Francisco Police Department / DataSF | stop_enforcement_context | police_stop, agency_action, place_context, source_record | RIPA-style stop records from 2018-07-01 through 2026-03-31 in profile query; the prototype now loads a checkpointed 1,000-row recent sync slice from 2026-03-22 through 2026-03-31 plus the original 5-row bounded sample into police_stops. | JSON API, CSV, GeoJSON |
| ca_doj_openjustice_crime_statistics | California DOJ OpenJustice Crime Statistics | California Department of Justice / Criminal Justice Statistics Center | statewide_public_safety_context | court_metric, agency_profile, source_record, source_publication_file | 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. | JSON, JSON:API, HTML, CSV |
| ca_doj_ripa_stop_data | California DOJ OpenJustice RIPA Stop Data | California Department of Justice / OpenJustice | statewide_stop_enforcement_context | police_stop, agency_action, source_record | Official statewide RIPA bulk files for 2018-2024 are exposed through the OpenJustice Data Portal registry. ZIP central-directory profiling covered seven annual ZIPs totaling 8,418,103,124 declared bytes while fetching 2,004,987 metadata bytes. The San Francisco XLSX members are individually range-addressable: seven 2018-2024 members were extracted with 98,933,067 compressed member bytes, recovered as 113,277,457 XLSX bytes, and normalized into 288,200 source-distinct police_stop rows in a compressed JSONL artifact. | JSON:API, ZIP, PDF, JSONL.GZ |
| fbi_cde_ucr_agencies | FBI Crime Data Explorer UCR Agency Data | Federal Bureau of Investigation Uniform Crime Reporting Program | agency_identifier_context | agency_profile, agency_ori_crosswalk, source_record | California FBI CDE/UCR agency inventory normalized into 867 agency_profiles across 59 county buckets, including 14 San Francisco-related ORIs such as SFPD CA0380100, Sheriff CA0380000, BART CA0380500, UCSF CA0389700, and CHP San Francisco offices. The 2026-05-31 live endpoint returned HTTP 403, so the parser fell back to the saved official JSON artifact while recording fetch_status. | JSON |
| ca_post_law_enforcement_context | California POST Law Enforcement Context | California Commission on Peace Officer Standards and Training | agency_and_officer_context | agency_profile, law_enforcement_staffing_metric, certification_action, source_record | 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. | HTML, PowerBI JSON, JSON |
| ca_post_peace_officer_certification_actions | California POST Peace Officer Certification Actions | California Commission on Peace Officer Standards and Training | agency_and_officer_context | officer_certification_action, source_record | California POST public peace-officer certification action table parsed into 671 normalized source-labeled rows, including 26 San Francisco-related rows. Pleadings/order PDF links are retained as metadata only. | HTML, JSON |
| sf_public_defender_annual_reports | San Francisco Public Defender Annual Reports | San Francisco Public Defender | defense_capacity_context | defense_capacity_metric, source_record | Annual Public Defender reports/calendars from FY03-04 through FY24-25 in indexed links. The latest annual report text extract promotes 23 aggregate defense-capacity metrics into court_metrics. | HTML, PDF, text_extract |
| sfsheriff_inmate_finder_current_custody | San Francisco Sheriff Find a Person in Jail | San Francisco Sheriff's Office | current_custody_lookup | custody_status, booking, court_case_reference, source_record | Current in-custody lookup by name prefix, SF number, or booking number; endpoint/result fields identified from official React bundle and no-hit probe. | HTML, JavaScript, JSON API |
| ca_doi_license_status_bail_agents | California DOI License Status Inquiry for Bail Agents and Agencies | California Department of Insurance | bail_agent_surety_license_context | bail_agent_license, business_license, enforcement_action, source_record | Public license status and enforcement-action lookup identified, but CSRF-only, headless browser, and headed Agent Browser business-name result probes returned no rows because the workflow requires a usable Turnstile/captcha token. | HTML |
| datasf_address_property_context | DataSF Address, Parcel, Business, Permit, and 311 Context | DataSF / City and County of San Francisco | block_address_property_context | place_context, civic_service_request, housing_context, source_record | Address/unit inventory (388,568 rows), parcels (235,262 rows), registered businesses (361,704 rows), building permits (1,289,155 rows), and 311 cases (8,653,998 rows) with count/date-range/sample probes current through 2026-05-30; 3 bounded address/parcel/business rows load into places and 3 latest 311 rows load into civic_service_requests. | JSON API, CSV, GeoJSON |
| datasf_assessor_property_tax_context | DataSF Assessor-Recorder Secured Property Tax Roll Context | DataSF / San Francisco Office of the Assessor-Recorder | parcel_property_tax_context | property_assessment, property_code_reference, place_context, source_record | Assessor secured property tax roll has 3,722,920 rows for closed roll years 2007 through 2024, latest observed data_as_of 2025-06-09T00:00:00.000 and data_loaded_at 2025-09-25T14:31:23.000. A bounded 2024 extract now materializes 500 property_assessment rows across 3 neighborhoods and 38 blocks, plus 255 full reference-code rows (145 property class/use, 17 exemption, 93 assessor neighborhood). | JSON API, CSV, GeoJSON |
| datasf_public_safety_response_context | DataSF Public Safety Response and Use-of-Force Context | DataSF / San Francisco public safety agencies | public_safety_response_context | public_safety_event, use_of_force_event, emergency_call, place_context, agency_profile, source_record | Police use-of-force rows (8,166, 2016-12-21 to 2022-04-11) and Fire/EMS calls (7,328,305, 2000-04-12 to 2026-05-29) profiled with metadata, count, date-range, and sample probes; 2 bounded response rows now load into public_safety_events. | JSON API, CSV, GeoJSON |
| datasf_fire_incidents_wr8u_xric | DataSF Fire Incidents | DataSF / San Francisco Fire Department | public_safety_response_context | public_safety_event, fire_incident, place_context, source_record | DataSF Fire Incidents `wr8u-xric`: 732,885 source rows from 2003-01-01 through 2026-02-18, latest data_loaded_at 2026-05-30T02:20:16.000. A bounded 1,000-row recent sync slice from 2025-12-25 through 2026-02-18 loads into public_safety_events as fire_incident. | JSON API, CSV, GeoJSON |
| datasf_adult_probation_performance_metrics | Adult Probation Performance Metrics | DataSF / San Francisco Controller / Adult Probation Department | post_disposition_aggregate_context | court_metric, agency_profile, source_record | Official Citywide Performance Metrics slice for Adult Probation exposes 210 source rows across 18 measures, with end calendar years from 2013 through 2027; bounded parser promotes 542 aggregate court_metric rows. | JSON API, CSV |
| datasf_traffic_crash_context | DataSF Traffic Crash Injury, Party, and Fatality Context | DataSF / San Francisco Municipal Transportation Agency | traffic_crash_context | traffic_collision, traffic_collision_party, traffic_fatality, public_safety_event, place_context, source_record | Official crash context with 64,694 injury crash rows from 2005-01-01T01:15:00 through 2026-02-28T22:42:00, 136,178 crash-party rows over the same window, and 359 fatal-crash rows from 2014-01-04T18:20:00 through 2026-03-27T07:43:00. All three profile probes observed data_loaded_at on 2026-05-01; the prototype now materializes 25-row bounded samples for injury collisions, crash parties, and fatal crashes into public_safety_events. | JSON API, CSV, GeoJSON |
| datasf_sfmta_citation_enforcement_context | DataSF/SFMTA Citation Enforcement Context | DataSF / San Francisco Municipal Transportation Agency | traffic_citation_enforcement_context | traffic_citation_context, court_metric, place_context, source_record | DataSF/SFMTA catalog terms returned citation-adjacent datasets for parking, transit fare, automated speed enforcement, and red-light camera citations. Bounded profile evidence covers 23,742,383 parking citation/fine rows from 2008-01-01T07:53:00 through a dirty future max of 2027-04-15T09:23:00; a Muni transit fare citation filtered view with masked samples; 17,532 automated speed-enforcement aggregate rows from 2025-04-01 through 2026-03-31, latest data_loaded_at 2026-05-01; and 608 red-light camera aggregate rows from 2024-01-01 through 2026-03-01, latest data_loaded_at 2026-04-23. | JSON API, CSV, GeoJSON |
| datasf_muni_driver_transit_only_lane_violations_sd75_dps9 | DataSF Muni Driver Reported Transit Only Lane Violations | DataSF / San Francisco Municipal Transportation Agency | traffic_citation_enforcement_context | traffic_citation_context, source_record | Full DataSF Muni driver-reported transit-only-lane violations extract: 17,178 rows from 2008-02-29 through 2015-02-23, with citation status counts Closed 15,375, Open 1,719, and Unapplied 84. Rows load into traffic_citation_context as muni_driver_transit_only_lane_violation. | JSON API, CSV |
| sfpd_traffic_violation_reports | SFPD Traffic Violation Reports and Focus-Five Citation Scorecard | San Francisco Police Department / DataSF | traffic_enforcement_context | court_metric, agency_profile, source_record | Official SFPD page exposed 125 traffic-violation PDF links; a bounded modern-layout PDF extractor parsed five recent reports for January-May 2025 into 140 table rows and 2,100 aggregate court_metric rows with zero PDF failures. DataSF Scorecard measure 1058 exposes 60 monthly focus-five citation source rows from 2021-07-31 through 2026-06-30; bounded parser promotes 117 additional aggregate traffic-enforcement metric rows. | HTML, PDF, JSON API, CSV |
| datasf_property_code_fire_enforcement_context | DataSF Property, Code, and Fire Enforcement Context | DataSF / San Francisco Department of Building Inspection / San Francisco Fire Department | building_fire_code_enforcement_context | property_enforcement_event, place_context, civic_service_request, source_record | Six DataSF DBI/fire enforcement datasets profiled with current metadata, count/date probes, and 5-row samples: 331,038 DBI complaints, 513,017 DBI NOV rows, 687,815 building inspections, 77,061 fire-safety complaints, 52,831 fire violations, and 436,008 fire inspections. Latest observed dates reach 2026-05-29 for DBI/fire complaints and violations, 2026-05-30 for fire inspections, and 2026-06-02 scheduled building inspections; 30 bounded rows now load into property_enforcement_events. | JSON API, CSV, GeoJSON |
| datasf_public_health_overdose_substance_context | DataSF Public Health Overdose and Substance Use Context | DataSF / San Francisco Department of Public Health / Office of the Chief Medical Examiner | public_health_drug_overdose_context | court_metric, source_record | Four aggregate DataSF public-health datasets profiled and fully fetched because each table is small: 76 monthly preliminary overdose-death rows, 191 weekly overdose-related EMS/911 rows, 25 annual race/ethnicity overdose death-rate rows, and 74 substance-use service rows. The parser promotes 391 aggregate metric rows into court_metrics; latest observed data_as_of is 2026-05-20 for overdose deaths and substance-use services, 2026-04-10 for EMS/911 rows, and 2025-08-15 for race/ethnicity death-rate rows. | JSON API, CSV |
| datasf_behavioral_health_service_directory_context | DataSF Behavioral Health and Substance Use Service Directory Context | DataSF / San Francisco Department of Public Health | behavioral_health_sud_service_context | place_context, court_metric, source_record | Two DataSF DPH behavioral-health/SUD provider-directory datasets profiled: 164 service-site source rows collapsing to 157 distinct API place rows, and 1,557 individual provider rows. The prototype loads the distinct public service sites into places as behavioral_health_service_site context and promotes 41 aggregate directory metrics; individual provider rows remain sample/aggregate-only and are not loaded into API tables. | JSON API, CSV |
| datasf_sfpd_investigated_hate_crimes | DataSF SFPD Investigated Hate Crimes | San Francisco Police Department / DataSF | hate_crime_public_safety_context | public_safety_event, source_record | SFPD hate-crime incidents reported to California DOJ, 1,813 rows from 2001-01 through 2026-03, latest data_as_of 2026-05-15 and data_loaded_at 2026-05-20. The full small table loads into public_safety_events as hate_crime_incident context. | JSON API, CSV |
| ca_doj_calecpa_search_warrant_notifications | California DOJ CalECPA Electronic Search Warrant Notifications | California Department of Justice / OpenJustice | court_process_context | search_warrant_notification, source_record | OpenJustice CalECPA Electronic Search Warrant Notifications dataset exposes 2016-2026 public files through the Data Portal registry. The bounded parser downloads and parses 22 CSV/XLSX files, scans statewide rows, and promotes 172 San Francisco County of Court notification rows (2016: 10, 2017: 18, 2018: 8, 2019: 7, 2020: 10, 2021: 14, 2022: 14, 2023: 15, 2024: 31, 2025: 11, 2026: 34). Fields include agency name, submitted timestamp/date, nature of investigation, items searched, grounds for issuance, emergency flag/facts, delayed notification flag, and delay reasons. | JSON:API, CSV, XLSX, JSON |
| bjs_nibrs_national_estimates_context | BJS NIBRS National Estimates Context | U.S. Department of Justice Bureau of Justice Statistics | federal_aggregate_justice_context | court_metric, justice_metric, source_record | Full BJS NIBRS National Estimates pull for violent-incident and property-incident endpoints: 9,448 violent endpoint rows and 6,978 property endpoint rows fetched, with 16,036 estimate rows loaded into court_metrics for 2022-2024 after excluding rows without numeric estimates. | JSON, CSV |
| datasf_building_permits_i98e_djp9 | DataSF Building Permits | DataSF / San Francisco Department of Building Inspection | property_activity_context | building_permit, property_activity, source_record | Official DataSF Building Permits has 1,289,267 rows with permit creation dates from 1901-03-10T00:07:00.000 through 2026-05-29T20:08:30.000; latest observed data_as_of 2026-05-30T01:05:04.000 and data_loaded_at 2026-05-30T05:29:16.710. A bounded latest extract materializes 500 source-distinct permit rows across 35 neighborhoods and 408 blocks into building_permits. | JSON API, CSV, GeoJSON |
Get this page with API
Rendered from the bluedoor SF Superior Court API. Reproduce it:
GET https://api.bluedoor.sh/sf-superior-court/v1/sourcesJSON