Campaign Finance Reports

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. If 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).

Resources

Name Format Description Link
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_transactions+WHERE+report_year=2023&filename=campfin_transactions&format=csv&skipfields=cartodb_id
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_transactions+WHERE+report_year=2022&filename=campfin_transactions&format=csv&skipfields=cartodb_id
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_transactions+WHERE+report_year=2021&filename=campfin_transactions&format=csv&skipfields=cartodb_id
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_transactions+WHERE+report_year=2020&filename=campfin_transactions&format=csv&skipfields=cartodb_id
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_transactions+WHERE+report_year=2019&filename=campfin_transactions&format=csv&skipfields=cartodb_id
15 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_transactions&filename=campfin_transactions&format=geojson&skipfields=cartodb_id
2 https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_transactions
21 https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/56953da1bef6fe3a62c82303/
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_contributions+WHERE+report_year=2023&filename=campfin_contributions&format=csv&skipfields=cartodb_id
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_contributions+WHERE+report_year=2022&filename=campfin_contributions&format=csv&skipfields=cartodb_id
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_contributions+WHERE+report_year=2021&filename=campfin_contributions&format=csv&skipfields=cartodb_id
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_contributions+WHERE+report_year=2020&filename=campfin_contributions&format=csv&skipfields=cartodb_id
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_contributions+WHERE+report_year=2019&filename=campfin_contributions&format=csv&skipfields=cartodb_id
15 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_contributions&filename=campfin_contributions&format=geojson&skipfields=cartodb_id
2 https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_contributions
21 https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/56953da1bef6fe3a62c82303/
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_expenditures+WHERE+report_year=2023&filename=campfin_expenditures&format=csv&skipfields=cartodb_id
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_expenditures+WHERE+report_year=2021&filename=campfin_expenditures&format=csv&skipfields=cartodb_id
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_expenditures+WHERE+report_year=2020&filename=campfin_expenditures&format=csv&skipfields=cartodb_id
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_expenditures+WHERE+report_year=2019&filename=campfin_expenditures&format=csv&skipfields=cartodb_id
15 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_expenditures&filename=campfin_expenditures&format=geojson&skipfields=cartodb_id
2 https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_expenditures
21 https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/63d19442db0c200012bf20c8/
8 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
8 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
8 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
8 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
15 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_unpaid_debts&filename=campfin_unpaid_debts&format=geojson&skipfields=cartodb_id
2 https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_unpaid_debts
21 https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/63d19496db0c200012bf21b4/
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_balances&filename=campfin_balances&format=csv&skipfields=cartodb_id
15 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_balances&filename=campfin_balances&format=geojson&skipfields=cartodb_id
2 https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_balances
21 https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/63d194ff468df60012a1ac3c/
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_summary&filename=campfin_summary&format=csv&skipfields=cartodb_id
15 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_summary&filename=campfin_summary&format=geojson&skipfields=cartodb_id
2 https://cityofphiladelphia.github.io/carto-api-explorer/#campfin_summary
21 https://metadata.phila.gov/#home/datasetdetails/5543867c20583086178c4f5f/representationdetails/63d19d8a57a407001247959b/
47 data.zip https://github.com/CityOfPhiladelphia/phl-campaign-finance-data/blob/master/data.zip
21 README.md https://github.com/CityOfPhiladelphia/phl-campaign-finance-data/blob/master/README.md
8 https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_expenditures+WHERE+report_year=2022&filename=campfin_expenditures&format=csv&skipfields=cartodb_id
8 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

Tags

  • campaign-finance
  • board-of-ethics
  • elections
  • candidates
  • politics
  • department-of-records

Topics

  • Local Government

Categories