{"action":"create","ckan_id":null,"date_created":"Sat, 04 Apr 2026 21:23:54 GMT","date_finished":null,"harvest_job_id":"b44cbcfd-15d6-49e7-9251-50008b105652","harvest_source_id":"17aad263-f33f-4d22-891b-57bdef961cab","id":"90062bf9-46b9-457d-809c-148e3c516e2c","identifier":"https://data.sfgov.org/api/views/dcjk-vw8q","parent_identifier":null,"source_hash":"01b10702c995d7ba811248378c8d85f845031c0a4b133a05265adcba3b4e8b6e","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>\\n\\n<strong><i>Please note that the \\\"Data Last Updated\\\" date on this page denotes the most recent DataSF update and does not reflect the most recent update to this dataset. To confirm the completeness of this dataset please contact the District Attorney's office at <u><a href=\\u201dmailto:districtattorney@sfgov.org\\u201d>districtattorney@sfgov.org</a></u>.</strong></i>\\n\\nThis dataset includes information on all cases presented to the District Attorney\\u2019s Office in which the office has taken action to prosecute a case, either by filing new criminal charges or by filing a motion to revoke probation or parole (MTR). This does not include cases in which the San Francisco Adult Probation Department or the state Division of Adult Parole Operations files a motion to revoke.\\n\\nFor cases in which SFDA files a new criminal charge, the most serious offense type is categorized as the most serious offense for which SFDA prosecuted the defendant. For cases in which SFDA files an MTR, the most serious offense is categorized as the most serious offense for which the person was initially prosecuted. This is because a filing of an MTR means that new criminal charges were not filed for the new arresting offense, but rather that the District Attorney\\u2019s Office is seeking a new sanction as part of the sentence of a prior criminal conviction. For MTRs, the filing date is based on the date when SFDA filed the MTR for the new arrest.\\n\\nMore information about this dataset can be found under the \\u201cCases Prosecuted\\u201d section on the <u><a href=\\\"https://sfdistrictattorney.org/policy/data-dashboards/#cases-prosecuted\\\">Data Dashboards page</a></u>\\n\\n<strong><i>Disclaimer: The San Francisco District Attorney's Office does not guarantee the accuracy, completeness, or timeliness of the information as the data is subject to change as modifications and updates are completed.</strong></i>\\n\\n<strong>B. HOW THE DATASET IS CREATED</strong>\\n\\nWhen District Attorney\\u2019s Office takes action to prosecute a case, relevant data is manually entered into the District Attorney Office's case management system. Data reports are pulled from this system on a semi-regular basis, cleaned, anonymized, and added to Open Data.\\n\\n<strong>C. UPDATE PROCESS</strong>\\n\\nWe strive to update this dataset at the beginning of every week. However, the creation of this dataset requires a manual pull from the Office's case management system and is dependent on staff availability.\\n\\n<strong>D. HOW TO USE THIS DATASET</strong>\\n\\nPlease review the \\u201cCases Prosecuted\\u201d section on the <u><a href=\\\"https://sfdistrictattorney.org/policy/data-dashboards/#cases-prosecuted\\\">Data Dashboards page</a></u> for more information about this dataset.\\n\\n<strong>E. Related DATASETS</strong>\\n\\n<u><a href=\\\"https://data.sfgov.org/d/czsm-3ei3\\\">District Attorney Actions Taken on Arrests Presented</a></u> \\n<u><a href=\\\"https://data.sfgov.org/d/ynfy-z5kt\\\">District Attorney Case Resolutions</a></u>\", \"distribution\": [{\"@type\": \"dcat:Distribution\", \"describedBy\": \"https://data.sfgov.org/api/views/dcjk-vw8q/columns.json\", \"describedByType\": \"application/json\", \"downloadURL\": \"https://data.sfgov.org/api/views/dcjk-vw8q/rows.json?accessType=DOWNLOAD\", \"mediaType\": \"application/json\"}, {\"@type\": \"dcat:Distribution\", \"describedBy\": \"https://data.sfgov.org/api/views/dcjk-vw8q/columns.rdf\", \"describedByType\": \"application/rdf+xml\", \"downloadURL\": \"https://data.sfgov.org/api/views/dcjk-vw8q/rows.rdf?accessType=DOWNLOAD\", \"mediaType\": \"application/rdf+xml\"}, {\"@type\": \"dcat:Distribution\", \"describedBy\": \"https://data.sfgov.org/api/views/dcjk-vw8q/columns.xml\", \"describedByType\": \"application/xml\", \"downloadURL\": \"https://data.sfgov.org/api/views/dcjk-vw8q/rows.xml?accessType=DOWNLOAD\", \"mediaType\": \"application/xml\"}, {\"@type\": \"dcat:Distribution\", \"downloadURL\": \"https://data.sfgov.org/api/views/dcjk-vw8q/rows.csv?accessType=DOWNLOAD\", \"mediaType\": \"text/csv\"}], \"identifier\": \"https://data.sfgov.org/api/views/dcjk-vw8q\", \"issued\": \"2022-03-30\", \"landingPage\": \"https://data.sfgov.org/d/dcjk-vw8q\", \"license\": \"http://opendatacommons.org/licenses/pddl/1.0/\", \"modified\": \"2026-03-31\", \"publisher\": {\"@type\": \"org:Organization\", \"name\": \"data.sfgov.org\"}, \"theme\": [\"Public Safety\"], \"title\": \"District Attorney Cases Prosecuted\"}","source_transform":null,"status":"error"}