{"action":"create","ckan_id":null,"date_created":"Sat, 21 Mar 2026 20:44:10 GMT","date_finished":null,"harvest_job_id":"f08f3c6e-e329-4773-8254-374d0e77825d","harvest_source_id":"17aad263-f33f-4d22-891b-57bdef961cab","id":"2dd24e3b-34be-4bb4-b3a6-19b8fbbcb8f5","identifier":"https://data.sfgov.org/api/views/fgqe-ia8k","parent_identifier":null,"source_hash":"05371831eb3d0f4dbf4dd67a095f5cf2908ce40abe54e28c62168e231e9be841","source_raw":"{\"@type\": \"dcat:Dataset\", \"accessLevel\": \"public\", \"contactPoint\": {\"@type\": \"vcard:Contact\", \"fn\": \"San Francisco Ethics Commission\", \"hasEmail\": \"mailto:no-reply@data.sfgov.org\"}, \"description\": \"<strong>A. SUMMARY</strong>\\nThis dataset contains information about the Employment of Local Officeholders and City Employees section of the Campaign Consultant Report.\\n\\nFor more information, visit the Ethics Commission\\u2019s webpage on <a href=\\\"https://sfethics.org/guidance/campaign-consultants\\\">Campaign Consultants</a>.\\n\\n<strong>B. HOW THE DATASET IS CREATED</strong>\\nData for this dataset is created when campaign consultants electronically file the following reports with employment information: \\n\\nForm 3 \\u2013 Quarterly Disclosure Report for Campaign Consultants\\nForm 6 \\u2013 Campaign Consultant Termination Statement\\n\\nThis dataset contains reports filings starting from December 9, 2024, when electronic filing of campaign consultant reports will be required.\\n\\n<strong>C. UPDATE PROCESS</strong>\\nThe dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by campaign consultants.\\n\\n<strong>D. HOW TO USE THIS DATASET</strong>\\nThe unique row identifier for an employment entry is \\u201cEntry Id\\u201d. This dataset should be joined with the SFEC Campaign Consultant Report dataset by \\u201cEnvelope Id\\u201d.\\n\\n<strong>E. RELATED DATASETS</strong>\\nFor detail reporting on campaign consultant activities, visit <a href=\\\"https://data.sfgov.org/City-Management-and-Ethics/SFEC-Campaign-Consultant-Report/iv34-5p9x/about_data\\\">SFEC Campaign Consultant Report</a>.\", \"distribution\": [{\"@type\": \"dcat:Distribution\", \"describedBy\": \"https://data.sfgov.org/api/views/fgqe-ia8k/columns.json\", \"describedByType\": \"application/json\", \"downloadURL\": \"https://data.sfgov.org/api/views/fgqe-ia8k/rows.json?accessType=DOWNLOAD\", \"mediaType\": \"application/json\"}, {\"@type\": \"dcat:Distribution\", \"describedBy\": \"https://data.sfgov.org/api/views/fgqe-ia8k/columns.rdf\", \"describedByType\": \"application/rdf+xml\", \"downloadURL\": \"https://data.sfgov.org/api/views/fgqe-ia8k/rows.rdf?accessType=DOWNLOAD\", \"mediaType\": \"application/rdf+xml\"}, {\"@type\": \"dcat:Distribution\", \"describedBy\": \"https://data.sfgov.org/api/views/fgqe-ia8k/columns.xml\", \"describedByType\": \"application/xml\", \"downloadURL\": \"https://data.sfgov.org/api/views/fgqe-ia8k/rows.xml?accessType=DOWNLOAD\", \"mediaType\": \"application/xml\"}, {\"@type\": \"dcat:Distribution\", \"downloadURL\": \"https://data.sfgov.org/api/views/fgqe-ia8k/rows.csv?accessType=DOWNLOAD\", \"mediaType\": \"text/csv\"}], \"identifier\": \"https://data.sfgov.org/api/views/fgqe-ia8k\", \"issued\": \"2024-12-05\", \"landingPage\": \"https://data.sfgov.org/d/fgqe-ia8k\", \"license\": \"http://opendatacommons.org/licenses/pddl/1.0/\", \"modified\": \"2025-06-23\", \"publisher\": {\"@type\": \"org:Organization\", \"name\": \"data.sfgov.org\"}, \"theme\": [\"City Management and Ethics\"], \"title\": \"SFEC Campaign Consultant Report - City Officeholders & Employees\"}","source_transform":null,"status":"error"}