Internal objects

PoliticalDonation

Voluntary gift made to a political committee to support specific candidate or party

• id: Primary key, unique identifier for each record in the table
• is_annonymous: Whether donation is anonymous vs not
• contributor_id: Primary key, unique identifier for a contributor who made donation
• contributor: Contributor name
• contributor_type_id: Primary key, unique identifier for a contributor type who made donation
• contributor_type: Currently unused
• contribution_type_id: Primary key, unique identifier for a contribution type
• contribution_type: Label that Philadelphia government assigns to every contribution
• committee_id: Primary key, unique identifier for a committee to which donation was made
• committee: Committee that filed donation
• filing_period_id: Id of the period when donation was made
• filing_period: Period when donation was made (could be prior or after elections)
• employer_name_id: Primary key, unique identifier for a employer of the contributor who made donation
• employer_name: An employer name of the contributor who made donation
• employer_occupation_id: Primary key, unique identifier for an employer occupation
• employer_occupation: Employer occupation
• donation_date: Date when donation was made
• donation_amount: Donation amount
• provided_name: Contributor name provided
• provided_address: Contributor address provided
• is_fixed_asset: Whether donation is a monetary vs non-monetary asset