class CommitteeTotalsHouseOrSenate(db.Model):
committee_id = db.Column(db.String(10), primary_key=True)
cycle = db.Column(db.Integer, primary_key=True)
committee_type = db.Column(db.String(1))
coverage_start_date = db.Column(db.DateTime())
coverage_end_date = db.Column(db.DateTime())
all_other_loans = db.Column(db.Integer)
candidate_contribution = db.Column(db.Integer)
contribution_refunds = db.Column(db.Integer)
contributions = db.Column(db.Integer)
disbursements = db.Column(db.Integer)
individual_contributions = db.Column(db.Integer)
individual_itemized_contributions = db.Column(db.Integer)
individual_unitemized_contributions = db.Column(db.Integer)
loan_repayments = db.Column(db.Integer)
loan_repayments_candidate_loans = db.Column(db.Integer)
loan_repayments_other_loans = db.Column(db.Integer)
loans = db.Column(db.Integer)
loans_made_by_candidate = db.Column(db.Integer)
offsets_to_operating_expenditures = db.Column(db.Integer)
operating_expenditures = db.Column(db.Integer)
other_disbursements = db.Column(db.Integer)
other_political_committee_contributions = db.Column(db.Integer)
other_receipts = db.Column(db.Integer)
political_party_committee_contributions = db.Column(db.Integer)
receipts = db.Column(db.Integer)
refunds_individual_contributions = db.Column(db.Integer)
refunds_other_political_committee_contributions = db.Column(db.Integer)
refunds_political_party_committee_contributions = db.Column(db.Integer)
transfers_from_other_authorized_committee = db.Column(db.Integer)
transfers_to_other_authorized_committee = db.Column(db.Integer)
__tablename__ = 'ofec_totals_house_senate_mv'
class CommitteeTotalsPacOrParty(db.Model):
committee_id = db.Column(db.String(10), primary_key=True)
cycle = db.Column(db.Integer, primary_key=True)
committee_type = db.Column(db.String(1))
coverage_start_date = db.Column(db.DateTime())
coverage_end_date = db.Column(db.DateTime())
all_loans_received = db.Column(db.Integer)
contribution_refunds = db.Column(db.Integer)
contributions = db.Column(db.Integer)
coordinated_expenditures_by_party_committee = db.Column(db.Integer)
disbursements = db.Column(db.Integer)
fed_candidate_committee_contributions = db.Column(db.Integer)
fed_candidate_contribution_refunds = db.Column(db.Integer)
fed_disbursements = db.Column(db.Integer)
fed_elect_activity = db.Column(db.Integer)
fed_operating_expenditures = db.Column(db.Integer)
fed_receipts = db.Column(db.Integer)
independent_expenditures = db.Column(db.Integer)
individual_contribution_refunds = db.Column(db.Integer)
individual_itemized_contributions = db.Column(db.Integer)
individual_unitemized_contributions = db.Column(db.Integer)
loan_repayments_made = db.Column(db.Integer)
loan_repayments_received = db.Column(db.Integer)
loans_made = db.Column(db.Integer)
net_contributions = db.Column(db.Integer)
non_allocated_fed_election_activity = db.Column(db.Integer)
nonfed_transfers = db.Column(db.Integer)
offsets_to_operating_expenditures = db.Column(db.Integer)
operating_expenditures = db.Column(db.Integer)
other_disbursements = db.Column(db.Integer)
other_fed_operating_expenditures = db.Column(db.Integer)
other_fed_receipts = db.Column(db.Integer)
other_political_committee_contributions = db.Column(db.Integer)
political_party_committee_contributions = db.Column(db.Integer)
receipts = db.Column(db.Integer)
shared_fed_activity = db.Column(db.Integer)
shared_fed_activity_nonfed = db.Column(db.Integer)
shared_fed_operating_expenditures = db.Column(db.Integer)
shared_nonfed_operating_expenditures = db.Column(db.Integer)
transfers_from_affiliated_party = db.Column(db.Integer)
transfers_from_nonfed_account = db.Column(db.Integer)
transfers_from_nonfed_levin = db.Column(db.Integer)
transfers_to_affiliated_committee = db.Column(db.Integer)
__tablename__ = 'ofec_totals_pacs_parties_mv'
class CommitteeTotalsPresidential(db.Model):
committee_id = db.Column(db.String(10), primary_key=True)
cycle = db.Column(db.Integer, primary_key=True)
committee_type = db.Column(db.String(1))
coverage_start_date = db.Column(db.DateTime())
coverage_end_date = db.Column(db.DateTime())
candidate_contribution = db.Column(db.Integer)
contribution_refunds = db.Column(db.Integer)
contributions = db.Column(db.Integer)
disbursements = db.Column(db.Integer)
exempt_legal_accounting_disbursement = db.Column(db.Integer)
federal_funds = db.Column(db.Integer)
fundraising_disbursements = db.Column(db.Integer)
individual_contributions = db.Column(db.Integer)
loan_repayments_made = db.Column(db.Integer)
loans_received = db.Column(db.Integer)
loans_received_from_candidate = db.Column(db.Integer)
offsets_to_fundraising_expenses = db.Column(db.Integer)
offsets_to_legal_accounting = db.Column(db.Integer)
offsets_to_operating_expenditures = db.Column(db.Integer)
operating_expenditures = db.Column(db.Integer)
other_disbursements = db.Column(db.Integer)
other_loans_received = db.Column(db.Integer)
other_political_committee_contributions = db.Column(db.Integer)
other_receipts = db.Column(db.Integer)
political_party_committee_contributions = db.Column(db.Integer)
receipts = db.Column(db.Integer)
refunded_other_political_committee_contributions = db.Column(db.Integer)
refunded_political_party_committee_contributions = db.Column(db.Integer)
refunded_individual_contributions = db.Column(db.Integer)
repayments_loans_made_by_candidate = db.Column(db.Integer)
repayments_other_loans = db.Column(db.Integer)
transfer_from_affiliated_committee = db.Column(db.Integer)
transfer_to_other_authorized_committee = db.Column(db.Integer)
__tablename__ = 'ofec_totals_presidential_mv'
class CommitteeReportsPacOrParty(db.Model):
__tablename__ = 'ofec_reports_pacs_parties_mv'
report_key = db.Column(db.BigInteger, primary_key=True)
committee_id = db.Column(db.String(10))
cycle = db.Column(db.Integer)
# common fields
beginning_image_number = db.Column(db.Integer)
cash_on_hand_beginning_period = db.Column(db.Integer)
cash_on_hand_end_period = db.Column(db.Integer)
coverage_end_date = db.Column(db.DateTime)
coverage_start_date = db.Column(db.DateTime)
debts_owed_by_committee = db.Column(db.Integer)
debts_owed_to_committee = db.Column(db.Integer)
end_image_number = db.Column(db.Integer)
expire_date = db.Column(db.DateTime)
other_disbursements_period = db.Column(db.Integer)
other_disbursements_ytd = db.Column(db.Integer)
other_political_committee_contributions_period = db.Column(db.Integer)
other_political_committee_contributions_ytd = db.Column(db.Integer)
political_party_committee_contributions_period = db.Column(db.Integer)
political_party_committee_contributions_ytd = db.Column(db.Integer)
report_type = db.Column(db.String)
report_type_full = db.Column(db.String)
report_year = db.Column(db.Integer)
total_contribution_refunds_period = db.Column(db.Integer)
total_contribution_refunds_ytd = db.Column(db.Integer)
total_contributions_period = db.Column(db.Integer)
total_contributions_ytd = db.Column(db.Integer)
total_disbursements_period = db.Column(db.Integer)
total_disbursements_ytd = db.Column(db.Integer)
total_receipts_period = db.Column(db.Integer)
total_receipts_ytd = db.Column(db.Integer)
# pac-party specific fields
all_loans_received_period = db.Column(db.Integer)
all_loans_received_ytd = db.Column(db.Integer)
allocated_federal_election_levin_share_period = db.Column(db.Integer)
calendar_ytd = db.Column(db.Integer)
cash_on_hand_beginning_calendar_ytd = db.Column(db.Integer)
cash_on_hand_close_ytd = db.Column(db.Integer)
coordinated_expenditures_by_party_committee_period = db.Column(db.Integer)
coordinated_expenditures_by_party_committee_ytd = db.Column(db.Integer)
fed_candidate_committee_contribution_refunds_ytd = db.Column(db.Integer)
fed_candidate_committee_contributions_period = db.Column(db.Integer)
fed_candidate_committee_contributions_ytd = db.Column(db.Integer)
fed_candidate_contribution_refunds_period = db.Column(db.Integer)
independent_expenditures_period = db.Column(db.Integer)
independent_expenditures_ytd = db.Column(db.Integer)
individual_contribution_refunds_period = db.Column(db.Integer)
individual_contribution_refunds_ytd = db.Column(db.Integer)
individual_itemized_contributions_period = db.Column(db.Integer)
individual_itemized_contributions_ytd = db.Column(db.Integer)
individual_unitemized_contributions_period = db.Column(db.Integer)
individual_unitemized_contributions_ytd = db.Column(db.Integer)
loan_repayments_made_period = db.Column(db.Integer)
loan_repayments_made_ytd = db.Column(db.Integer)
loan_repayments_received_period = db.Column(db.Integer)
loan_repayments_received_ytd = db.Column(db.Integer)
loans_made_period = db.Column(db.Integer)
loans_made_ytd = db.Column(db.Integer)
net_contributions_period = db.Column(db.Integer)
net_contributions_ytd = db.Column(db.Integer)
net_operating_expenditures_period = db.Column(db.Integer)
net_operating_expenditures_ytd = db.Column(db.Integer)
non_allocated_fed_election_activity_period = db.Column(db.Integer)
non_allocated_fed_election_activity_ytd = db.Column(db.Integer)
nonfed_share_allocated_disbursements_period = db.Column(db.Integer)
offsets_to_operating_expenditures_period = db.Column(db.Integer)
offsets_to_operating_expenditures_ytd = db.Column(db.Integer)
other_fed_operating_expenditures_period = db.Column(db.Integer)
other_fed_operating_expenditures_ytd = db.Column(db.Integer)
other_fed_receipts_period = db.Column(db.Integer)
other_fed_receipts_ytd = db.Column(db.Integer)
other_political_committee_contribution_refunds_period = db.Column(db.Integer)
other_political_committee_contribution_refunds_ytd = db.Column(db.Integer)
political_party_committee_contribution_refunds_period = db.Column(db.Integer)
political_party_committee_contribution_refunds_ytd = db.Column(db.Integer)
shared_fed_activity_nonfed_ytd = db.Column(db.Integer)
shared_fed_activity_period = db.Column(db.Integer)
shared_fed_activity_ytd = db.Column(db.Integer)
shared_fed_operating_expenditures_period = db.Column(db.Integer)
shared_fed_operating_expenditures_ytd = db.Column(db.Integer)
shared_nonfed_operating_expenditures_ytd = db.Column(db.Integer)
subtotal_summary_page_period = db.Column(db.Integer)
subtotal_summary_ytd = db.Column(db.Integer)
total_disbursements_summary_page_period = db.Column(db.Integer)
total_disbursements_summary_page_ytd = db.Column(db.Integer)
total_fed_disbursements_period = db.Column(db.Integer)
total_fed_disbursements_ytd = db.Column(db.Integer)
total_fed_elect_activity_period = db.Column(db.Integer)
total_fed_election_activity_ytd = db.Column(db.Integer)
total_fed_operating_expenditures_period = db.Column(db.Integer)
total_fed_operating_expenditures_ytd = db.Column(db.Integer)
total_fed_receipts_period = db.Column(db.Integer)
total_fed_receipts_ytd = db.Column(db.Integer)
total_individual_contributions = db.Column(db.Integer)
total_individual_contributions_ytd = db.Column(db.Integer)
total_nonfed_transfers_period = db.Column(db.Integer)
total_nonfed_transfers_ytd = db.Column(db.Integer)
total_operating_expenditures_period = db.Column(db.Integer)
total_operating_expenditures_ytd = db.Column(db.Integer)
total_receipts_summary_page_period = db.Column(db.Integer)
total_receipts_summary_page_ytd = db.Column(db.Integer)
transfers_from_affiliated_party_period = db.Column(db.Integer)
transfers_from_affiliated_party_ytd = db.Column(db.Integer)
transfers_from_nonfed_account_period = db.Column(db.Integer)
transfers_from_nonfed_account_ytd = db.Column(db.Integer)
transfers_from_nonfed_levin_period = db.Column(db.Integer)
transfers_from_nonfed_levin_ytd = db.Column(db.Integer)
transfers_to_affiliated_committee_period = db.Column(db.Integer)
transfers_to_affilitated_committees_ytd = db.Column(db.Integer)
class CommitteeReportsPresidential(db.Model):
__tablename__ = 'ofec_reports_presidential_mv'
report_key = db.Column(db.BigInteger, primary_key=True)
committee_id = db.Column(db.String(10))
cycle = db.Column(db.Integer)
# common fields
beginning_image_number = db.Column(db.Integer)
cash_on_hand_beginning_period = db.Column(db.Integer)
cash_on_hand_end_period = db.Column(db.Integer)
coverage_end_date = db.Column(db.DateTime)
coverage_start_date = db.Column(db.DateTime)
debts_owed_by_committee = db.Column(db.Integer)
debts_owed_to_committee = db.Column(db.Integer)
end_image_number = db.Column(db.Integer)
expire_date = db.Column(db.DateTime)
operating_expenditures_period = db.Column(db.Integer)
other_disbursements_period = db.Column(db.Integer)
other_disbursements_ytd = db.Column(db.Integer)
other_political_committee_contributions_period = db.Column(db.Integer)
other_political_committee_contributions_ytd = db.Column(db.Integer)
political_party_committee_contributions_period = db.Column(db.Integer)
political_party_committee_contributions_ytd = db.Column(db.Integer)
report_type = db.Column(db.String)
report_type_full = db.Column(db.String)
report_year = db.Column(db.Integer)
total_contribution_refunds_period = db.Column(db.Integer)
total_contribution_refunds_ytd = db.Column(db.Integer)
total_contributions_period = db.Column(db.Integer)
total_contributions_ytd = db.Column(db.Integer)
total_disbursements_period = db.Column(db.Integer)
total_disbursements_ytd = db.Column(db.Integer)
total_receipts_period = db.Column(db.Integer)
total_receipts_ytd = db.Column(db.Integer)
# president-specific fields
candidate_contribution_period = db.Column(db.Integer)
candidate_contribution_ytd = db.Column(db.Integer)
exempt_legal_accounting_disbursement_period = db.Column(db.Integer)
exempt_legal_accounting_disbursement_ytd = db.Column(db.Integer)
expentiture_subject_to_limits = db.Column(db.Integer)
federal_funds_period = db.Column(db.Integer)
federal_funds_ytd = db.Column(db.Integer)
fundraising_disbursements_period = db.Column(db.Integer)
fundraising_disbursements_ytd = db.Column(db.Integer)
individual_contributions_period = db.Column(db.Integer)
individual_contributions_ytd = db.Column(db.Integer)
items_on_hand_liquidated = db.Column(db.Integer)
loans_received_from_candidate_period = db.Column(db.Integer)
loans_received_from_candidate_ytd = db.Column(db.Integer)
net_contribution_summary_period = db.Column(db.Integer)
net_operating_expenses_summary_period = db.Column(db.Integer)
offsets_to_fundraising_exp_ytd = db.Column(db.Integer)
offsets_to_fundraising_expenses_period = db.Column(db.Integer)
offsets_to_legal_accounting_period = db.Column(db.Integer)
offsets_to_legal_accounting_ytd = db.Column(db.Integer)
offsets_to_operating_expenditures_period = db.Column(db.Integer)
offsets_to_operating_expenditures_ytd = db.Column(db.Integer)
operating_expenditures_period = db.Column(db.Integer)
operating_expenditures_ytd = db.Column(db.Integer)
other_loans_received_period = db.Column(db.Integer)
other_loans_received_ytd = db.Column(db.Integer)
other_receipts_period = db.Column(db.Integer)
other_receipts_ytd = db.Column(db.Integer)
refunded_individual_contributions_ytd = db.Column(db.Integer)
refunded_other_political_committee_contributions_period = db.Column(db.Integer)
refunded_other_political_committee_contributions_ytd = db.Column(db.Integer)
refunded_political_party_committee_contributions_period = db.Column(db.Integer)
refunded_political_party_committee_contributions_ytd = db.Column(db.Integer)
refunds_individual_contributions_period = db.Column(db.Integer)
repayments_loans_made_by_candidate_period = db.Column(db.Integer)
repayments_loans_made_candidate_ytd = db.Column(db.Integer)
repayments_other_loans_period = db.Column(db.Integer)
repayments_other_loans_ytd = db.Column(db.Integer)
subtotal_summary_period = db.Column(db.Integer)
total_disbursements_summary_period = db.Column(db.Integer)
total_loan_repayments_made_period = db.Column(db.Integer)
total_loan_repayments_made_ytd = db.Column(db.Integer)
total_loans_received_period = db.Column(db.Integer)
total_loans_received_ytd = db.Column(db.Integer)
total_offsets_to_operating_expenditures_period = db.Column(db.Integer)
total_offsets_to_operating_expenditures_ytd = db.Column(db.Integer)
total_period = db.Column(db.Integer)
total_receipts_summary_period = db.Column(db.Integer)
total_ytd = db.Column(db.Integer)
transfer_from_affiliated_committee_period = db.Column(db.Integer)
transfer_from_affiliated_committee_ytd = db.Column(db.Integer)
transfer_to_other_authorized_committee_period = db.Column(db.Integer)
transfer_to_other_authorized_committee_ytd = db.Column(db.Integer)
class CommitteeTotalsHouseOrSenate(CommitteeTotals):
__tablename__ = 'ofec_totals_house_senate_mv'
all_other_loans = db.Column(db.Integer)
candidate_contribution = db.Column(db.Integer)
individual_contributions = db.Column(db.Integer)
individual_itemized_contributions = db.Column(db.Integer)
individual_unitemized_contributions = db.Column(db.Integer)
loan_repayments = db.Column(db.Integer)
loan_repayments_candidate_loans = db.Column(db.Integer)
loan_repayments_other_loans = db.Column(db.Integer)
loans = db.Column(db.Integer)
loans_made_by_candidate = db.Column(db.Integer)
other_receipts = db.Column(db.Integer)
refunds_individual_contributions = db.Column(db.Integer)
refunds_other_political_committee_contributions = db.Column(db.Integer)
refunds_political_party_committee_contributions = db.Column(db.Integer)
transfers_from_other_authorized_committee = db.Column(db.Integer)
transfers_to_other_authorized_committee = db.Column(db.Integer)
class CommitteeReportsHouseOrSenate(db.Model):
__tablename__ = 'ofec_reports_house_senate_mv'
report_key = db.Column(db.BigInteger, primary_key=True)
committee_id = db.Column(db.String(10))
cycle = db.Column(db.Integer)
# common fields
beginning_image_number = db.Column(db.Integer)
cash_on_hand_beginning_period = db.Column(db.Integer)
cash_on_hand_end_period = db.Column(db.Integer)
coverage_end_date = db.Column(db.DateTime)
coverage_start_date = db.Column(db.DateTime)
debts_owed_by_committee = db.Column(db.Integer)
debts_owed_to_committee = db.Column(db.Integer)
end_image_number = db.Column(db.Integer)
expire_date = db.Column(db.DateTime)
other_disbursements_period = db.Column(db.Integer)
other_disbursements_ytd = db.Column(db.Integer)
other_political_committee_contributions_period = db.Column(db.Integer)
other_political_committee_contributions_ytd = db.Column(db.Integer)
political_party_committee_contributions_period = db.Column(db.Integer)
political_party_committee_contributions_ytd = db.Column(db.Integer)
report_type = db.Column(db.String)
report_type_full = db.Column(db.String)
report_year = db.Column(db.Integer)
total_contribution_refunds_period = db.Column(db.Integer)
total_contribution_refunds_ytd = db.Column(db.Integer)
total_contributions_period = db.Column(db.Integer)
total_contributions_ytd = db.Column(db.Integer)
total_disbursements_period = db.Column(db.Integer)
total_disbursements_ytd = db.Column(db.Integer)
total_receipts_period = db.Column(db.Integer)
total_receipts_ytd = db.Column(db.Integer)
# house-senate specific fields
aggregate_amount_personal_contributions_general = db.Column(db.Integer)
aggregate_contributions_personal_funds_primary = db.Column(db.Integer)
all_other_loans_period = db.Column(db.Integer)
all_other_loans_ytd = db.Column(db.Integer)
candidate_contribution_period = db.Column(db.Integer)
candidate_contribution_ytd = db.Column(db.Integer)
gross_receipt_authorized_committee_general = db.Column(db.Integer)
gross_receipt_authorized_committee_primary = db.Column(db.Integer)
gross_receipt_minus_personal_contribution_general = db.Column(db.Integer)
gross_receipt_minus_personal_contributions_primary = db.Column(db.Integer)
individual_itemized_contributions_period = db.Column(db.Integer)
individual_unitemized_contributions_period = db.Column(db.Integer)
loan_repayments_candidate_loans_period = db.Column(db.Integer)
loan_repayments_candidate_loans_ytd = db.Column(db.Integer)
loan_repayments_other_loans_period = db.Column(db.Integer)
loan_repayments_other_loans_ytd = db.Column(db.Integer)
loans_made_by_candidate_period = db.Column(db.Integer)
loans_made_by_candidate_ytd = db.Column(db.Integer)
net_contributions_period = db.Column(db.Integer)
net_contributions_ytd = db.Column(db.Integer)
net_operating_expenditures_period = db.Column(db.Integer)
net_operating_expenditures_ytd = db.Column(db.Integer)
offsets_to_operating_expenditures_period = db.Column(db.Integer)
offsets_to_operating_expenditures_ytd = db.Column(db.Integer)
operating_expenditures_period = db.Column(db.Integer)
operating_expenditures_ytd = db.Column(db.Integer)
other_receipts_period = db.Column(db.Integer)
other_receipts_ytd = db.Column(db.Integer)
refunds_individual_contributions_period = db.Column(db.Integer)
refunds_individual_contributions_ytd = db.Column(db.Integer)
refunds_other_political_committee_contributions_period = db.Column(db.Integer)
refunds_other_political_committee_contributions_ytd = db.Column(db.Integer)
refunds_political_party_committee_contributions_period = db.Column(db.Integer)
refunds_political_party_committee_contributions_ytd = db.Column(db.Integer)
refunds_total_contributions_col_total_ytd = db.Column(db.Integer)
subtotal_period = db.Column(db.Integer)
total_contribution_refunds_col_total_period = db.Column(db.Integer)
total_contributions_column_total_period = db.Column(db.Integer)
total_individual_contributions_period = db.Column(db.Integer)
total_individual_contributions_ytd = db.Column(db.Integer)
total_individual_itemized_contributions_ytd = db.Column(db.Integer)
total_individual_unitemized_contributions_ytd = db.Column(db.Integer)
total_loan_repayments_period = db.Column(db.Integer)
total_loan_repayments_ytd = db.Column(db.Integer)
total_loans_period = db.Column(db.Integer)
total_loans_ytd = db.Column(db.Integer)
total_offsets_to_operating_expenditures_period = db.Column(db.Integer)
total_offsets_to_operating_expenditures_ytd = db.Column(db.Integer)
total_operating_expenditures_period = db.Column(db.Integer)
total_operating_expenditures_ytd = db.Column(db.Integer)
total_receipts = db.Column(db.Integer)
transfers_from_other_authorized_committee_period = db.Column(db.Integer)
transfers_from_other_authorized_committee_ytd = db.Column(db.Integer)
transfers_to_other_authorized_committee_period = db.Column(db.Integer)
transfers_to_other_authorized_committee_ytd = db.Column(db.Integer)
class CommitteeTotalsPacOrParty(CommitteeTotals):
__tablename__ = 'ofec_totals_pacs_parties_mv'
all_loans_received = db.Column(db.Integer)
coordinated_expenditures_by_party_committee = db.Column(db.Integer)
fed_candidate_committee_contributions = db.Column(db.Integer)
fed_candidate_contribution_refunds = db.Column(db.Integer)
fed_disbursements = db.Column(db.Integer)
fed_elect_activity = db.Column(db.Integer)
fed_operating_expenditures = db.Column(db.Integer)
fed_receipts = db.Column(db.Integer)
independent_expenditures = db.Column(db.Integer)
individual_contribution_refunds = db.Column(db.Integer)
individual_itemized_contributions = db.Column(db.Integer)
individual_unitemized_contributions = db.Column(db.Integer)
loan_repayments_made = db.Column(db.Integer)
loan_repayments_received = db.Column(db.Integer)
loans_made = db.Column(db.Integer)
net_contributions = db.Column(db.Integer)
non_allocated_fed_election_activity = db.Column(db.Integer)
nonfed_transfers = db.Column(db.Integer)
other_fed_operating_expenditures = db.Column(db.Integer)
other_fed_receipts = db.Column(db.Integer)
shared_fed_activity = db.Column(db.Integer)
shared_fed_activity_nonfed = db.Column(db.Integer)
shared_fed_operating_expenditures = db.Column(db.Integer)
shared_nonfed_operating_expenditures = db.Column(db.Integer)
transfers_from_affiliated_party = db.Column(db.Integer)
transfers_from_nonfed_account = db.Column(db.Integer)
transfers_from_nonfed_levin = db.Column(db.Integer)
transfers_to_affiliated_committee = db.Column(db.Integer)
class CommitteeTotalsPresidential(CommitteeTotals):
__tablename__ = 'ofec_totals_presidential_mv'
candidate_contribution = db.Column(db.Integer)
exempt_legal_accounting_disbursement = db.Column(db.Integer)
federal_funds = db.Column(db.Integer)
fundraising_disbursements = db.Column(db.Integer)
individual_contributions = db.Column(db.Integer)
loan_repayments_made = db.Column(db.Integer)
loans_received = db.Column(db.Integer)
loans_received_from_candidate = db.Column(db.Integer)
offsets_to_fundraising_expenses = db.Column(db.Integer)
offsets_to_legal_accounting = db.Column(db.Integer)
other_loans_received = db.Column(db.Integer)
other_receipts = db.Column(db.Integer)
refunded_other_political_committee_contributions = db.Column(db.Integer)
refunded_political_party_committee_contributions = db.Column(db.Integer)
refunded_individual_contributions = db.Column(db.Integer)
repayments_loans_made_by_candidate = db.Column(db.Integer)
repayments_other_loans = db.Column(db.Integer)
transfer_from_affiliated_committee = db.Column(db.Integer)
transfer_to_other_authorized_committee = db.Column(db.Integer)
class CommitteeTotals(db.Model):
__abstract__ = True
committee_id = db.Column(db.String(10), primary_key=True)
cycle = db.Column(db.Integer, primary_key=True)
committee_type = db.Column(db.String(1))
offsets_to_operating_expenditures = db.Column(db.Integer)
political_party_committee_contributions = db.Column(db.Integer)
other_disbursements = db.Column(db.Integer)
other_political_committee_contributions = db.Column(db.Integer)
operating_expenditures = db.Column(db.Integer)
disbursements = db.Column(db.Integer)
contributions = db.Column(db.Integer)
contribution_refunds = db.Column(db.Integer)
receipts = db.Column(db.Integer)
coverage_start_date = db.Column(db.DateTime())
coverage_end_date = db.Column(db.DateTime())
class CommitteeReportsHouseOrSenate(CommitteeReports):
__tablename__ = 'ofec_reports_house_senate_mv'
aggregate_amount_personal_contributions_general = db.Column(db.Integer)
aggregate_contributions_personal_funds_primary = db.Column(db.Integer)
all_other_loans_period = db.Column(db.Integer)
all_other_loans_ytd = db.Column(db.Integer)
candidate_contribution_period = db.Column(db.Integer)
candidate_contribution_ytd = db.Column(db.Integer)
gross_receipt_authorized_committee_general = db.Column(db.Integer)
gross_receipt_authorized_committee_primary = db.Column(db.Integer)
gross_receipt_minus_personal_contribution_general = db.Column(db.Integer)
gross_receipt_minus_personal_contributions_primary = db.Column(db.Integer)
individual_itemized_contributions_period = db.Column(db.Integer)
individual_unitemized_contributions_period = db.Column(db.Integer)
loan_repayments_candidate_loans_period = db.Column(db.Integer)
loan_repayments_candidate_loans_ytd = db.Column(db.Integer)
loan_repayments_other_loans_period = db.Column(db.Integer)
loan_repayments_other_loans_ytd = db.Column(db.Integer)
loans_made_by_candidate_period = db.Column(db.Integer)
loans_made_by_candidate_ytd = db.Column(db.Integer)
net_contributions_period = db.Column(db.Integer)
net_contributions_ytd = db.Column(db.Integer)
net_operating_expenditures_period = db.Column(db.Integer)
net_operating_expenditures_ytd = db.Column(db.Integer)
offsets_to_operating_expenditures_period = db.Column(db.Integer)
offsets_to_operating_expenditures_ytd = db.Column(db.Integer)
operating_expenditures_period = db.Column(db.Integer)
operating_expenditures_ytd = db.Column(db.Integer)
other_receipts_period = db.Column(db.Integer)
other_receipts_ytd = db.Column(db.Integer)
refunds_individual_contributions_period = db.Column(db.Integer)
refunds_individual_contributions_ytd = db.Column(db.Integer)
refunds_other_political_committee_contributions_period = db.Column(
db.Integer)
refunds_other_political_committee_contributions_ytd = db.Column(db.Integer)
refunds_political_party_committee_contributions_period = db.Column(
db.Integer)
refunds_political_party_committee_contributions_ytd = db.Column(db.Integer)
refunds_total_contributions_col_total_ytd = db.Column(db.Integer)
subtotal_period = db.Column(db.Integer)
total_contribution_refunds_col_total_period = db.Column(db.Integer)
total_contributions_column_total_period = db.Column(db.Integer)
total_individual_contributions_period = db.Column(db.Integer)
total_individual_contributions_ytd = db.Column(db.Integer)
total_individual_itemized_contributions_ytd = db.Column(db.Integer)
total_individual_unitemized_contributions_ytd = db.Column(db.Integer)
total_loan_repayments_period = db.Column(db.Integer)
total_loan_repayments_ytd = db.Column(db.Integer)
total_loans_period = db.Column(db.Integer)
total_loans_ytd = db.Column(db.Integer)
total_offsets_to_operating_expenditures_period = db.Column(db.Integer)
total_offsets_to_operating_expenditures_ytd = db.Column(db.Integer)
total_operating_expenditures_period = db.Column(db.Integer)
total_operating_expenditures_ytd = db.Column(db.Integer)
total_receipts = db.Column(db.Integer)
transfers_from_other_authorized_committee_period = db.Column(db.Integer)
transfers_from_other_authorized_committee_ytd = db.Column(db.Integer)
transfers_to_other_authorized_committee_period = db.Column(db.Integer)
transfers_to_other_authorized_committee_ytd = db.Column(db.Integer)
class CommitteeReportsPresidential(CommitteeReports):
__tablename__ = 'ofec_reports_presidential_mv'
candidate_contribution_period = db.Column(db.Integer)
candidate_contribution_ytd = db.Column(db.Integer)
exempt_legal_accounting_disbursement_period = db.Column(db.Integer)
exempt_legal_accounting_disbursement_ytd = db.Column(db.Integer)
expentiture_subject_to_limits = db.Column(db.Integer)
federal_funds_period = db.Column(db.Integer)
federal_funds_ytd = db.Column(db.Integer)
fundraising_disbursements_period = db.Column(db.Integer)
fundraising_disbursements_ytd = db.Column(db.Integer)
individual_contributions_period = db.Column(db.Integer)
individual_contributions_ytd = db.Column(db.Integer)
items_on_hand_liquidated = db.Column(db.Integer)
loans_received_from_candidate_period = db.Column(db.Integer)
loans_received_from_candidate_ytd = db.Column(db.Integer)
net_contribution_summary_period = db.Column(db.Integer)
net_operating_expenses_summary_period = db.Column(db.Integer)
offsets_to_fundraising_exp_ytd = db.Column(db.Integer)
offsets_to_fundraising_expenses_period = db.Column(db.Integer)
offsets_to_legal_accounting_period = db.Column(db.Integer)
offsets_to_legal_accounting_ytd = db.Column(db.Integer)
offsets_to_operating_expenditures_period = db.Column(db.Integer)
offsets_to_operating_expenditures_ytd = db.Column(db.Integer)
operating_expenditures_period = db.Column(db.Integer)
operating_expenditures_ytd = db.Column(db.Integer)
other_loans_received_period = db.Column(db.Integer)
other_loans_received_ytd = db.Column(db.Integer)
other_receipts_period = db.Column(db.Integer)
other_receipts_ytd = db.Column(db.Integer)
refunded_individual_contributions_ytd = db.Column(db.Integer)
refunded_other_political_committee_contributions_period = db.Column(
db.Integer)
refunded_other_political_committee_contributions_ytd = db.Column(
db.Integer)
refunded_political_party_committee_contributions_period = db.Column(
db.Integer)
refunded_political_party_committee_contributions_ytd = db.Column(
db.Integer)
refunds_individual_contributions_period = db.Column(db.Integer)
repayments_loans_made_by_candidate_period = db.Column(db.Integer)
repayments_loans_made_candidate_ytd = db.Column(db.Integer)
repayments_other_loans_period = db.Column(db.Integer)
repayments_other_loans_ytd = db.Column(db.Integer)
subtotal_summary_period = db.Column(db.Integer)
total_disbursements_summary_period = db.Column(db.Integer)
total_loan_repayments_made_period = db.Column(db.Integer)
total_loan_repayments_made_ytd = db.Column(db.Integer)
total_loans_received_period = db.Column(db.Integer)
total_loans_received_ytd = db.Column(db.Integer)
total_offsets_to_operating_expenditures_period = db.Column(db.Integer)
total_offsets_to_operating_expenditures_ytd = db.Column(db.Integer)
total_period = db.Column(db.Integer)
total_receipts_summary_period = db.Column(db.Integer)
total_ytd = db.Column(db.Integer)
transfer_from_affiliated_committee_period = db.Column(db.Integer)
transfer_from_affiliated_committee_ytd = db.Column(db.Integer)
transfer_to_other_authorized_committee_period = db.Column(db.Integer)
transfer_to_other_authorized_committee_ytd = db.Column(db.Integer)
class CommitteeReportsPacOrParty(CommitteeReports):
__tablename__ = 'ofec_reports_pacs_parties_mv'
all_loans_received_period = db.Column(db.Integer)
all_loans_received_ytd = db.Column(db.Integer)
allocated_federal_election_levin_share_period = db.Column(db.Integer)
calendar_ytd = db.Column(db.Integer)
cash_on_hand_beginning_calendar_ytd = db.Column(db.Integer)
cash_on_hand_close_ytd = db.Column(db.Integer)
coordinated_expenditures_by_party_committee_period = db.Column(db.Integer)
coordinated_expenditures_by_party_committee_ytd = db.Column(db.Integer)
fed_candidate_committee_contribution_refunds_ytd = db.Column(db.Integer)
fed_candidate_committee_contributions_period = db.Column(db.Integer)
fed_candidate_committee_contributions_ytd = db.Column(db.Integer)
fed_candidate_contribution_refunds_period = db.Column(db.Integer)
independent_expenditures_period = db.Column(db.Integer)
independent_expenditures_ytd = db.Column(db.Integer)
individual_contribution_refunds_period = db.Column(db.Integer)
individual_contribution_refunds_ytd = db.Column(db.Integer)
individual_itemized_contributions_period = db.Column(db.Integer)
individual_itemized_contributions_ytd = db.Column(db.Integer)
individual_unitemized_contributions_period = db.Column(db.Integer)
individual_unitemized_contributions_ytd = db.Column(db.Integer)
loan_repayments_made_period = db.Column(db.Integer)
loan_repayments_made_ytd = db.Column(db.Integer)
loan_repayments_received_period = db.Column(db.Integer)
loan_repayments_received_ytd = db.Column(db.Integer)
loans_made_period = db.Column(db.Integer)
loans_made_ytd = db.Column(db.Integer)
net_contributions_period = db.Column(db.Integer)
net_contributions_ytd = db.Column(db.Integer)
net_operating_expenditures_period = db.Column(db.Integer)
net_operating_expenditures_ytd = db.Column(db.Integer)
non_allocated_fed_election_activity_period = db.Column(db.Integer)
non_allocated_fed_election_activity_ytd = db.Column(db.Integer)
nonfed_share_allocated_disbursements_period = db.Column(db.Integer)
offsets_to_operating_expenditures_period = db.Column(db.Integer)
offsets_to_operating_expenditures_ytd = db.Column(db.Integer)
other_fed_operating_expenditures_period = db.Column(db.Integer)
other_fed_operating_expenditures_ytd = db.Column(db.Integer)
other_fed_receipts_period = db.Column(db.Integer)
other_fed_receipts_ytd = db.Column(db.Integer)
other_political_committee_contribution_refunds_period = db.Column(
db.Integer)
other_political_committee_contribution_refunds_ytd = db.Column(db.Integer)
political_party_committee_contribution_refunds_period = db.Column(
db.Integer)
political_party_committee_contribution_refunds_ytd = db.Column(db.Integer)
shared_fed_activity_nonfed_ytd = db.Column(db.Integer)
shared_fed_activity_period = db.Column(db.Integer)
shared_fed_activity_ytd = db.Column(db.Integer)
shared_fed_operating_expenditures_period = db.Column(db.Integer)
shared_fed_operating_expenditures_ytd = db.Column(db.Integer)
shared_nonfed_operating_expenditures_ytd = db.Column(db.Integer)
subtotal_summary_page_period = db.Column(db.Integer)
subtotal_summary_ytd = db.Column(db.Integer)
total_disbursements_summary_page_period = db.Column(db.Integer)
total_disbursements_summary_page_ytd = db.Column(db.Integer)
total_fed_disbursements_period = db.Column(db.Integer)
total_fed_disbursements_ytd = db.Column(db.Integer)
total_fed_elect_activity_period = db.Column(db.Integer)
total_fed_election_activity_ytd = db.Column(db.Integer)
total_fed_operating_expenditures_period = db.Column(db.Integer)
total_fed_operating_expenditures_ytd = db.Column(db.Integer)
total_fed_receipts_period = db.Column(db.Integer)
total_fed_receipts_ytd = db.Column(db.Integer)
total_individual_contributions = db.Column(db.Integer)
total_individual_contributions_ytd = db.Column(db.Integer)
total_nonfed_transfers_period = db.Column(db.Integer)
total_nonfed_transfers_ytd = db.Column(db.Integer)
total_operating_expenditures_period = db.Column(db.Integer)
total_operating_expenditures_ytd = db.Column(db.Integer)
total_receipts_summary_page_period = db.Column(db.Integer)
total_receipts_summary_page_ytd = db.Column(db.Integer)
transfers_from_affiliated_party_period = db.Column(db.Integer)
transfers_from_affiliated_party_ytd = db.Column(db.Integer)
transfers_from_nonfed_account_period = db.Column(db.Integer)
transfers_from_nonfed_account_ytd = db.Column(db.Integer)
transfers_from_nonfed_levin_period = db.Column(db.Integer)
transfers_from_nonfed_levin_ytd = db.Column(db.Integer)
transfers_to_affiliated_committee_period = db.Column(db.Integer)
transfers_to_affilitated_committees_ytd = db.Column(db.Integer)
class CommitteeReports(db.Model):
__abstract__ = True
report_key = db.Column(db.BigInteger, primary_key=True)
committee_id = db.Column(db.String(10))
cycle = db.Column(db.Integer)
beginning_image_number = db.Column(db.Integer)
cash_on_hand_beginning_period = db.Column(db.Integer)
cash_on_hand_end_period = db.Column(db.Integer)
coverage_end_date = db.Column(db.DateTime)
coverage_start_date = db.Column(db.DateTime)
debts_owed_by_committee = db.Column(db.Integer)
debts_owed_to_committee = db.Column(db.Integer)
end_image_number = db.Column(db.Integer)
expire_date = db.Column(db.DateTime)
other_disbursements_period = db.Column(db.Integer)
other_disbursements_ytd = db.Column(db.Integer)
other_political_committee_contributions_period = db.Column(db.Integer)
other_political_committee_contributions_ytd = db.Column(db.Integer)
political_party_committee_contributions_period = db.Column(db.Integer)
political_party_committee_contributions_ytd = db.Column(db.Integer)
report_type = db.Column(db.String)
report_type_full = db.Column(db.String)
report_year = db.Column(db.Integer)
total_contribution_refunds_period = db.Column(db.Integer)
total_contribution_refunds_ytd = db.Column(db.Integer)
total_contributions_period = db.Column(db.Integer)
total_contributions_ytd = db.Column(db.Integer)
total_disbursements_period = db.Column(db.Integer)
total_disbursements_ytd = db.Column(db.Integer)
total_receipts_period = db.Column(db.Integer)
total_receipts_ytd = db.Column(db.Integer)