election_finance
Tables
accrued_expenses
filer_id, filer_name, committee_type, report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, payee_last_name, payee_first_name, payee_prefix, payee_suffix, payee_city, payee_state, payee_zipcode, beginning_balance, amount_incurred, amount_paid, ending_balance, expenditure_description, committee_id, memo_reference_number
9,471 rows
contribution_reports_24_hours
filer_id, filer_name, committee_type, report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, entity_last_name, entity_first_name, entity_prefix, entity_suffix, entity_city, entity_state, entity_zipcode, contributor_employer, contributor_occupation, contributor_self_employed, contribution_date, amount, committee_id, candidate_last_name, candidate_first_name, candidate_prefix, candidate_suffix, office_sought, office_jurisdiction, district_number, incumbent, ballot_measure_name, ballot_measure_number, ballot_measure_jurisdiction, memo_reference_number
2,196 rows
expenditure_summaries
filer_id, filer_name, committee_type, report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, payee_last_name, payee_first_name, payee_prefix, payee_suffix, payee_city, payee_state, payee_zipcode, expenditure_date, expenditure_amt, year_to_date, expenditure_type, expenditure_description, committee_id, candidate_last_name, candidate_first_name, candidate_prefix, candidate_suffix, office_sought, office_jurisdiction, district_number, incumbent, ballot_measure_name, ballot_measure_number, ballot_measure_jurisdiction, support_or_oppose, memo_reference_number
3,564 rows
ie_contributions
filer_id, filer_name, report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, last_name, first_name, prefix, city, state, zipcode, employer, occupation, self_employed, transaction_type, transaction_date, transaction_amt, year_to_date, transaction_description, committee_id, memo_reference_number
9,302 rows
ie_expenditures
filer_id, filer_name, committee_type, report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, payee_last_name, payee_first_name, payee_prefix, payee_suffix, payee_city, payee_state, payee_zipcode, expenditure_date, expenditure_amt, year_to_date, expenditure_type, expenditure_description, committee_id, candidate_last_name, candidate_first_name, candidate_prefix, candidate_suffix, office_sought, office_jurisdiction, district_number, incumbent, ballot_measure_name, ballot_measure_number, ballot_measure_jurisdiction, support_or_oppose, memo_reference_number
129 rows
ie_reports_24_hours
filer_id, filer_name, committee_type, report_date, report_start_date, report_end_date, election_date, transaction_id, amount, expenditure_date, expenditure_description, memo_reference_number, ballot_measure_name, ballot_measure_number, ballot_measure_jurisdiction, support_or_oppose, candidate_last_name, candidate_first_name, candidate_prefix, candidate_suffix, office_sought, office_jurisdiction, district_number
2,029 rows
loan_guarantors
filer_id, filer_name, committee_type, report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, lender_last_name, lender_first_name, lender_prefix, lender_suffix, city, state, zipcode, loan_start_date, loan_due_date, amount_received, outstanding_balance, contributions_to_date, balance_at_period_start, interest_rate, lender_employer, lender_occupation, lender_self_employed, committee_id, memo_reference_number, amount_paid_in_period, amount_forgiven_in_period, interest_paid_in_period, original_amount
0 rows
loans_made
filer_id, filer_name, committee_type, report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, lender_last_name, lender_first_name, lender_prefix, lender_suffix, city, state, zipcode, loan_start_date, loan_due_date, amount_received, outstanding_balance, contributions_to_date, balance_at_period_start, interest_rate, lender_employer, lender_occupation, lender_self_employed, committee_id, memo_reference_number, amount_paid_in_period, amount_forgiven_in_period, interest_paid_in_period, original_amount
29 rows
major_donor_ie_statements
filer_id, filer_name, committee_type, report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, payee_last_name, payee_first_name, payee_prefix, payee_suffix, payee_city, payee_state, zipcode, expenditure_date, expenditure_amt, year_to_date, expenditure_type, expenditure_description, committee_id, candidate_last_name, candidate_first_name, candidate_prefix, candidate_suffix, office_sought, office_jurisdiction, district_number, incumbent, ballot_measure_name, ballot_measure_number, ballot_measure_jurisdiction, support_or_oppose, memo_reference_number, business_info_included, business_name, business_address_1, business_address_2, business_city, business_state, business_zipcode, business_interest, business_activity, association_interest
586 rows
misc_cash_increases
filer_id, filer_name, report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, last_name, first_name, prefix, city, state, zipcode, employer, occupation, self_employed, transaction_type, transaction_date, transaction_amt, year_to_date, transaction_description, committee_id, memo_reference_number
653 rows
monetary_contributions
filer_id, filer_name, report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, last_name, first_name, prefix, city, state, zipcode, employer, occupation, self_employed, transaction_type, transaction_date, transaction_amt, year_to_date, transaction_description, committee_id, memo_reference_number
112,209 rows
non_monetary_contributions
filer_id, filer_name, report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, last_name, first_name, prefix, city, state, zipcode, employer, occupation, self_employed, transaction_type, transaction_date, transaction_amt, year_to_date, transaction_description, committee_id, memo_reference_number
1,223 rows
on_behalf_of_expenditures
filer_id, filer_name, committee_type, report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, payee_last_name, payee_first_name, payee_prefix, payee_suffix, payee_city, payee_state, payee_zipcode, expenditure_date, expenditure_amt, year_to_date, expenditure_type, expenditure_description, committee_id, candidate_last_name, candidate_first_name, candidate_prefix, candidate_suffix, office_sought, office_jurisdiction, district_number, incumbent, ballot_measure_name, ballot_measure_number, ballot_measure_jurisdiction, support_or_oppose, memo_reference_number
7,067 rows
received_loans
filer_id, filer_name, committee_type, report_date, report_start_date, report_end_date, election_date, transaction_id, entity_type, lender_last_name, lender_first_name, lender_prefix, lender_suffix, city, state, zipcode, loan_start_date, loan_due_date, amount_received, outstanding_balance, contributions_to_date, balance_at_period_start, interest_rate, lender_employer, lender_occupation, lender_self_employed, committee_id, memo_reference_number, amount_paid_in_period, amount_forgiven_in_period, interest_paid_in_period, original_amount
1,688 rows
summaries
filer_id, filer_name, committee_type, report_date, report_start_date, report_end_date, election_date, record_type, total_this_period, year_to_date
129,065 rows
zipcodes
zip, lat, lng, city, state_id, state_name, zcta, parent_zcta, population, density, county_fips, county_name, county_weights, county_names_all, county_fips_all, imprecise, military, timezone
33,783 rows
... and 35 hidden tables
Download SQLite DB: election_finance.db 111.1 MB