{"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": [{"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+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+*+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+*+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+*+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+*+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+*+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)"}, {"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://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/56953da1bef6fe3a62c82303/", "format": "HTML", "mediaType": "text/html", "title": "CF All Transactions (Metadata)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+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+*+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+*+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+*+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+*+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+*+FROM+campfin_contributions&filename=campfin_contributions&format=geojson&skipfields=cartodb_id", "format": "GEOJSON", "mediaType": "application/octet-stream", "title": "CF Contributions - 2019 to present (GeoJSON)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_contributions", "format": "API", "mediaType": "application/http", "title": "CF Contributions - 2019 to present (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/56953da1bef6fe3a62c82303/", "format": "HTML", "mediaType": "text/html", "title": "CF Contributions (Metadata)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+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+*+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+*+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+*+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+*+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+*+FROM+campfin_expenditures&filename=campfin_expenditures&format=geojson&skipfields=cartodb_id", "format": "GEOJSON", "mediaType": "application/octet-stream", "title": "CF Expenditures to present (GeoJSON)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_expenditures", "format": "API", "mediaType": "application/http", "title": "CF Expenditures - 2019 to present (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/63d19442db0c200012bf20c8/", "format": "HTML", "mediaType": "text/html", "title": "CF Expenditures (Metadata)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+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+*+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+*+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+*+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+*+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+*+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)"}, {"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://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/63d19496db0c200012bf21b4/", "format": "HTML", "mediaType": "text/html", "title": "CF Unpaid debts (Metadata)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+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+*+FROM+campfin_balances&filename=campfin_balances&format=geojson&skipfields=cartodb_id", "format": "GEOJSON", "mediaType": "application/octet-stream", "title": "CF Balances - 2019 to present (GeoJSON)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_balances", "format": "API", "mediaType": "application/http", "title": "CF Balances - 2019 to present (API)"}, {"accessURL": "https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/63d194ff468df60012a1ac3c/", "format": "HTML", "mediaType": "text/html", "title": "CF Balances (Metadata)"}, {"downloadURL": "https://phl.carto.com/api/v2/sql?q=SELECT+*+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+*+FROM+campfin_summary&filename=campfin_summary&format=geojson&skipfields=cartodb_id", "format": "GEOJSON", "mediaType": "application/octet-stream", "title": "CF Summary - 2019 to present (GeoJSON)"}, {"accessURL": "https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_summary", "format": "API", "mediaType": "application/http", "title": "CF Summary - 2019 to present (API)"}, {"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)"}, {"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)"}], "identifier": "campaign-finance-reports", "keyword": ["elections", "politics", "Board of Ethics", "Campaign Finance", "Candidates", "Department of Records", "Elections"], "license": "https://metadata.phila.gov/#help/help-faqs/what-are-the-terms-of-use/", "publisher": {"@type": "org:Organization", "name": "City of Philadelphia"}, "spatial": "Philadelphia, Pennsylvania", "title": "Campaign Finance Reports"}