pa-gov/campaign-finance-disclosure-debt-data-current-8bef-t5zg
Icon for Socrata external plugin
 
Readme
Updated 3 years ago
Indexed 2 hours ago

Campaign Finance Disclosure Debt Data Current State

This file contains information about the debt(s) by which a candidate or committee is encumbered, including information about the person or entity to whom the debt is owed. The data is also available and searchable on www.campaignfinanceonline.pa.gov.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Debt Reporting Location 1 (state)debt_reporting_location_1_statedebt_reporting_location_1_stateText
Debt Reporting Location 2 (address)debt_reporting_location_2_addressdebt_reporting_location_2_addressText
Debt Reporting Location 2 (state)debt_reporting_location_2_statedebt_reporting_location_2_stateText
Debt Reporting Location 2 (city)debt_reporting_location_2_citydebt_reporting_location_2_cityText
Debt Reporting Location 1 (zip)debt_reporting_location_1_zipdebt_reporting_location_1_zipText
Debt Reporting Location 1 (address)debt_reporting_location_1_addressdebt_reporting_location_1_addressText
Debt Reporting Location 2 (zip)debt_reporting_location_2_zipdebt_reporting_location_2_zipText
Debt Reporting Location 1 (city)debt_reporting_location_1_citydebt_reporting_location_1_cityText
Debt Reporting Location 2debt_reporting_location_2debt_reporting_location_2PointDebt Reporting Location based on the Debt Reporting Address 2. This could be a generalized location if the Debt Reporting Address 2 is blank. This location field includes Latitude and Longitude created during data load.
Debt Reporting Location 1debt_reporting_location_1debt_reporting_location_1PointDebt Reporting Location based on the Debt address using the Debt Reporting Address 1. This location field includes Latitude and Longitude created during data load.
Debt Descriptiondebt_descriptiondebt_descriptionTextA field for the candidate or committee to explain the reported debt.
Debt Accrual Datedebt_accrual_datedebt_accrual_dateTextThe date on which the debt was accrued by the candidate or committee. Formatted as YYYYMMDD.
Debt Reporting Statedebt_reporting_statedebt_reporting_stateTextThe state of the reported debt
Debt Reporting Address 2debt_reporting_address_2debt_reporting_address_2TextThis is a secondary address field for the individual or entity reporting the debt
Debt Reporting Address 1debt_reporting_address_1debt_reporting_address_1TextThe address of the individual or entity reporting the debt
Debt Reporter's Namedebt_reporter_s_namedebt_reporter_s_nameTextThe name of the individual or entity reporting the debt
Election CyclecyclecycleNumberThis specifies the reporting cycle, or timeframe, of the contributions accepted by the candidate or committee.
Filer Identification Numberfiler_identification_numberfiler_identification_numberTextThis is the Filer Identification Number which is unique to each entity reporting campaign finance contributions (i.e. candidates and committees)
Debt Reporting Zip Codedebt_reporting_zip_codedebt_reporting_zip_codeTextThe zip code of the reported deb
Debt Reporting Citydebt_reporting_citydebt_reporting_cityTextThe city of the reported debt
Election Yearelection_yearelection_yearNumberThis denotes the election cycle or year the candidate or committee is filing
Debt Amountdebt_amountdebt_amountNumberThe amount of debt accrued by the candidate or committee
 
Preview
  • campaign_finance_disclosure_debt_data_current
     
Upstream Metadata