{"action":"create","ckan_id":null,"date_created":"Mon, 26 Jan 2026 23:55:32 GMT","date_finished":null,"harvest_job_id":"30019ff2-3684-40a6-91ba-cc375fe4771c","harvest_source_id":"638ed9d7-1f15-4bbe-ad49-e9a819290bb1","id":"85531718-01cf-4985-92fc-1b2e50652a6e","identifier":"campaign-finance-reports","parent_identifier":null,"source_hash":"a902c751aedd4e10e0a2e2acc16975e82b96698f24588db971c32f7ef6608578","source_raw":"{\"accessLevel\": \"public\", \"contactPoint\": {\"fn\": \"bryan.mchale@phila.gov\", \"hasEmail\": \"mailto:bryan.mchale@phila.gov\"}, \"description\": \"Campaign finance reports from 2019 to the present: The tables below show different cuts of the campaign finance reports data related to Philadelphia elections provided by filers (including candidates and political committees) about their contributions, expenditures and debt. You can explore an [interactive dashboard](https://www.phila.gov/cf-dashboard) that visualizes much of this data, use the [video tutorial](https://ethics.pub/CFvizdemo) to learn how to navigate the dashboard, or read the [technical document](https://docs.google.com/document/d/1VzeY_HJOATS17pE4639OZq0fhrF7Jppps-Mc3dZhDqY/edit?usp=sharing) to understand how we compiled the data and dashboard. \\r\\n\\r\\nIf you want to use the raw, unfiltered data, please visit the [searchable database](https://apps.phila.gov/search/all). Filers can submit reports on via the [campaign finance filing system](https://apps.phila.gov/auth).\", \"distribution\": [{\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_balances\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"CF Balances - 2019 to present (API)\"}, {\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_contributions\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"CF Contributions - 2019 to present (API)\"}, {\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_expenditures\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"CF Expenditures - 2019 to present (API)\"}, {\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_summary\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"CF Summary - 2019 to present (API)\"}, {\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_transactions\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"CF All Transactions - 2019 to present (API)\"}, {\"accessURL\": \"https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_unpaid_debts\", \"format\": \"API\", \"mediaType\": \"application/http\", \"title\": \"CF Unpaid debts - 2019 to present (API)\"}, {\"accessURL\": \"https://github.com/CityOfPhiladelphia/phl-campaign-finance-data/blob/master/README.md\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"2005-2012 Campaign Finance Records (Metadata)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/56953da1bef6fe3a62c82303/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"CF All Transactions (Metadata)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/56953da1bef6fe3a62c82303/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"CF Contributions (Metadata)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/63d19442db0c200012bf20c8/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"CF Expenditures (Metadata)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/63d19496db0c200012bf21b4/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"CF Unpaid debts (Metadata)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/63d194ff468df60012a1ac3c/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"CF Balances (Metadata)\"}, {\"accessURL\": \"https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/63d19d8a57a407001247959b/\", \"format\": \"HTML\", \"mediaType\": \"text/html\", \"title\": \"CF Summary (Metadata)\"}, {\"downloadURL\": \"https://github.com/CityOfPhiladelphia/phl-campaign-finance-data/blob/master/data.zip\", \"format\": \"TXT\", \"mediaType\": \"text/plain\", \"title\": \"2005 - 2012 Campaign Finance Records (zip file)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_balances&filename=campfin_balances&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Balances - 2019 to present (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_balances&filename=campfin_balances&format=geojson&skipfields=cartodb_id\", \"format\": \"GEOJSON\", \"mediaType\": \"application/octet-stream\", \"title\": \"CF Balances - 2019 to present (GeoJSON)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_contributions&filename=campfin_contributions&format=geojson&skipfields=cartodb_id\", \"format\": \"GEOJSON\", \"mediaType\": \"application/octet-stream\", \"title\": \"CF Contributions - 2019 to present (GeoJSON)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_contributions+WHERE+report_year=2019&filename=campfin_contributions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Contributions - 2019 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_contributions+WHERE+report_year=2020&filename=campfin_contributions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Contributions - 2020 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_contributions+WHERE+report_year=2021&filename=campfin_contributions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Contributions - 2021 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_contributions+WHERE+report_year=2022&filename=campfin_contributions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Contributions - 2022 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_contributions+WHERE+report_year=2023&filename=campfin_contributions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Contributions - 2023 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_contributions+WHERE+report_year=2024&filename=campfin_contributions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Contributions - 2024 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_contributions+WHERE+report_year=2025&filename=campfin_contributions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Contributions - 2025 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_contributions+WHERE+report_year=2026&filename=campfin_contributions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Contributions - 2026 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_expenditures&filename=campfin_expenditures&format=geojson&skipfields=cartodb_id\", \"format\": \"GEOJSON\", \"mediaType\": \"application/octet-stream\", \"title\": \"CF Expenditures to present (GeoJSON)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_expenditures+WHERE+report_year=2019&filename=campfin_expenditures&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Expenditures - 2019 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_expenditures+WHERE+report_year=2020&filename=campfin_expenditures&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Expenditures - 2020 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_expenditures+WHERE+report_year=2021&filename=campfin_expenditures&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Expenditures - 2021 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_expenditures+WHERE+report_year=2022&filename=campfin_expenditures&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Expenditures - 2022 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_expenditures+WHERE+report_year=2023&filename=campfin_expenditures&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Expenditures - 2023 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_expenditures+WHERE+report_year=2024&filename=campfin_expenditures&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Expenditures - 2024 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_expenditures+WHERE+report_year=2025&filename=campfin_expenditures&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Expenditures - 2025 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_expenditures+WHERE+report_year=2026&filename=campfin_expenditures&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Expenditures - 2026 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_summary&filename=campfin_summary&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Summary - 2019 to present (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_summary&filename=campfin_summary&format=geojson&skipfields=cartodb_id\", \"format\": \"GEOJSON\", \"mediaType\": \"application/octet-stream\", \"title\": \"CF Summary - 2019 to present (GeoJSON)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_transactions&filename=campfin_transactions&format=geojson&skipfields=cartodb_id\", \"format\": \"GEOJSON\", \"mediaType\": \"application/octet-stream\", \"title\": \"CF All Transactions - 2019 to present (GeoJSON)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_transactions+WHERE+report_year=2019&filename=campfin_transactions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF All Transactions - 2019 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_transactions+WHERE+report_year=2020&filename=campfin_transactions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF All Transactions - 2020 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_transactions+WHERE+report_year=2021&filename=campfin_transactions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF All Transactions - 2021 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_transactions+WHERE+report_year=2022&filename=campfin_transactions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF All Transactions - 2022 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_transactions+WHERE+report_year=2023&filename=campfin_transactions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF All Transactions - 2023 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_transactions+WHERE+report_year=2024&filename=campfin_transactions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF All Transactions - 2024 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_transactions+WHERE+report_year=2025&filename=campfin_transactions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF All Transactions - 2025 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_transactions+WHERE+report_year=2026&filename=campfin_transactions&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF All Transactions - 2026 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_unpaid_debts&filename=campfin_unpaid_debts&format=geojson&skipfields=cartodb_id\", \"format\": \"GEOJSON\", \"mediaType\": \"application/octet-stream\", \"title\": \"CF Unpaid debts - 2019 to present (GeoJSON)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_unpaid_debts+WHERE+report_year=2019&filename=campfin_unpaid_debts&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Unpaid debts - 2019 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_unpaid_debts+WHERE+report_year=2020&filename=campfin_unpaid_debts&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Unpaid debts - 2020 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_unpaid_debts+WHERE+report_year=2021&filename=campfin_unpaid_debts&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Unpaid debts - 2021 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_unpaid_debts+WHERE+report_year=2022&filename=campfin_unpaid_debts&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Unpaid debts - 2022 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_unpaid_debts+WHERE+report_year=2023&filename=campfin_unpaid_debts&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Unpaid debts - 2023 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_unpaid_debts+WHERE+report_year=2024&filename=campfin_unpaid_debts&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Unpaid debts - 2024 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_unpaid_debts+WHERE+report_year=2025&filename=campfin_unpaid_debts&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Unpaid debts - 2025 (CSV)\"}, {\"downloadURL\": \"https://phl.carto.com/api/v2/sql?q=SELECT+%2A+FROM+campfin_unpaid_debts+WHERE+report_year=2026&filename=campfin_unpaid_debts&format=csv&skipfields=cartodb_id\", \"format\": \"CSV\", \"mediaType\": \"text/csv\", \"title\": \"CF Unpaid debts - 2026 (CSV)\"}], \"identifier\": \"campaign-finance-reports\", \"keyword\": [\"Board of Ethics\", \"Department of Records\", \"campaign finance\", \"candidates\", \"elections\", \"elections\", \"politics\"], \"license\": \"https://metadata.phila.gov/#help/help-faqs/what-are-the-terms-of-use/\", \"modified\": null, \"publisher\": {\"@type\": \"org:Organization\", \"name\": \"City of Philadelphia\"}, \"spatial\": \"Philadelphia, Pennsylvania\", \"title\": \"Campaign Finance Reports\"}","source_transform":null,"status":"error"}