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)