{"action":"create","ckan_id":null,"date_created":"Tue, 17 Mar 2026 00:20:35 GMT","date_finished":null,"harvest_job_id":"40ea108b-242b-4453-ab6b-c7014ec01fcd","harvest_source_id":"8e934d41-a763-4fd0-bac6-210a47148d37","id":"0702247e-d024-4248-963d-ee492ffd6a30","identifier":"https://data.sfgov.org/api/views/cd9v-umhr","parent_identifier":null,"source_hash":"98b8376a224e8641cff4d8ddc89f660406c3d8e8a5b77602ce14c243a55e8514","source_raw":"{\"@type\": \"dcat:Dataset\", \"accessLevel\": \"public\", \"contactPoint\": {\"@type\": \"vcard:Contact\", \"fn\": \"OpenData\", \"hasEmail\": \"mailto:no-reply@data.sfgov.org\"}, \"description\": \"<strong>A. SUMMARY</strong>\\nThis dataset provides aggregated counts of victims and suspects involved in crimes that fall under San Francisco\\u2019s mandated crime reporting categories, as recorded by the San Francisco Police Department (SFPD). The data is sourced from Crime Data Warehouse (CDW), which has been in operation since January 1, 2013.\\n\\nBecause CDW was implemented on that date, data prior to 2013 is incomplete or unavailable. To protect the privacy and safety of vulnerable individuals, the dataset is aggregated and does not contain any personally identifiable information or individual case records.\\nCrime categories are organized using:\\n\\n- San Francisco\\u2019s 96A.5 \\u201cQuarterly Crime Victim Data Reporting\\u201d, legislated for victim demographic reporting (Definitions of crime types can be found in <u><a href=\\\"https://codelibrary.amlegal.com/codes/san_francisco/latest/sf_admin/0-0-0-52357#JD_96A.1\\\">Chapter 96A.1</a></u>)\\n\\n- FBI Uniform Crime Reporting (UCR) system (Definitions can be found on the <u><a href=\\\"https://www.sanfranciscopolice.org/stay-safe/crime-data/crime-dashboard\\\">SFPD website</a></u>.)\\n\\nThis dataset also powers the public crime dashboards on the SFPD website, where users can explore summary statistics. \\n\\n<strong>B. HOW THE DATASET IS CREATED</strong>\\nData is added to open data once a quarter after extraction, transformation, and aggregation. \\n\\n<strong>Disclaimer</strong>: The San Francisco Police Department does not guarantee the accuracy, completeness, timeliness or correct sequencing of the information as the data is subject to change as modifications and updates are completed. \\n\\n<strong>C. UPDATE PROCESS</strong>\\nInformation is updated on a quarterly basis. \\n\\n<strong>D. HOW TO USE THIS DATASET</strong>\\nThis dataset provides aggregated counts of individuals involved in reported crimes, categorized by key demographics and crime-related attributes. It is used to power public-facing dashboards on the San Francisco Police Department (SFPD) website, where summary statistics and visualizations allow users to explore crime and victimization trends across the city. While the SFPD public dashboard provides many useful summaries and visualizations, not all data details are displayed there. For deeper or custom analysis, the full dataset can be downloaded for personal use.\", \"distribution\": [{\"@type\": \"dcat:Distribution\", \"describedBy\": \"https://data.sfgov.org/api/views/cd9v-umhr/columns.json\", \"describedByType\": \"application/json\", \"downloadURL\": \"https://data.sfgov.org/api/views/cd9v-umhr/rows.json?accessType=DOWNLOAD\", \"mediaType\": \"application/json\"}, {\"@type\": \"dcat:Distribution\", \"describedBy\": \"https://data.sfgov.org/api/views/cd9v-umhr/columns.rdf\", \"describedByType\": \"application/rdf+xml\", \"downloadURL\": \"https://data.sfgov.org/api/views/cd9v-umhr/rows.rdf?accessType=DOWNLOAD\", \"mediaType\": \"application/rdf+xml\"}, {\"@type\": \"dcat:Distribution\", \"describedBy\": \"https://data.sfgov.org/api/views/cd9v-umhr/columns.xml\", \"describedByType\": \"application/xml\", \"downloadURL\": \"https://data.sfgov.org/api/views/cd9v-umhr/rows.xml?accessType=DOWNLOAD\", \"mediaType\": \"application/xml\"}, {\"@type\": \"dcat:Distribution\", \"downloadURL\": \"https://data.sfgov.org/api/views/cd9v-umhr/rows.csv?accessType=DOWNLOAD\", \"mediaType\": \"text/csv\"}], \"identifier\": \"https://data.sfgov.org/api/views/cd9v-umhr\", \"issued\": \"2025-10-22\", \"landingPage\": \"https://data.sfgov.org/d/cd9v-umhr\", \"license\": \"http://opendatacommons.org/licenses/pddl/1.0/\", \"modified\": \"2026-01-22\", \"publisher\": {\"@type\": \"org:Organization\", \"name\": \"data.sfgov.org\"}, \"theme\": [\"Public Safety\"], \"title\": \"Police Department Reported Victim and Suspect Demographic Data\"}","source_transform":null,"status":"error"}