{"slug":"campaign-finance-reports","title":"Campaign Finance Reports","description":"Campaign finance reports cover transactions related to Philadelphia elections from 2019 to the present, submitted by candidates and political committees. Each record includes details on financial contributions, expenditures, and outstanding debt reported by filers.","publisher":"City of Philadelphia","organization_title":"City of Philadelphia","landing_page":"https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_transactions+WHERE+report_year=2019&filename=campfin_transactions&format=csv&skipfields=cartodb_id","file_count":15,"use_cases":[],"enrichment":{"jurisdiction_names":["Philadelphia, PA"],"jurisdiction_levels":["city"],"date_range":{"start":"2019"},"date_descriptions":["2019 to present"],"cluster_name":"Philadelphia Campaign Finance Entities","has_geo_fields":true,"has_contact_fields":false,"has_temporal_fields":false,"has_financial_fields":false,"has_business_data":true,"resource_version_url":"https://phl.carto.com/api/v2/sql?q=SELECT+*+FROM+campfin_transactions+WHERE+report_year=2019&filename=campfin_transactions&format=csv&skipfields=cartodb_id"},"schema_count":1,"schemas":[{"columns":["city","state","zip_code","business_name","street_address","business_name_2","full_name_string","full_address_string"],"column_mapping":null,"sample_rows":[]}]}