About this Dataset

Iowa Campaign Contributions Received

This dataset contains information on contributions and in kind donations made by organizations and individuals to state-wide, legislative or local candidate committees, state PACs, county central committees, state parties, and state and local ballot issue committees in Iowa. Data is available beginning in 2003 for all reports filed electronically, and some paper filed reports. Please note: data has been filtered by date into two additional assets so that the user can properly download all the data, as Excel has a limit of 1,048,576 rows.

Data is provided through reports submitted by candidate committees, state political committees, federal/out-of-state political committees, county central committees, ballot issue committees and organizations making contributions or independent expenditures. Quality of the data provided in the dataset is dependent upon the accuracy of the data reported electronically.
Organization: State of Iowa
Last updated: 2023-01-20T00:12:42.202467
Tags: ballot-issue-committees, campaigns, candidates, county-central-committees, county-local-committees, federal-out-of-state-political-committees, pac, party-committees, political, state-political-committees

Tables

Table 1

@usgov.state_of_iowa_iowa_campaign_contributions_received.table_1

68.71 MB
2,816,050 rows
16 columns

CREATE TABLE table_1 (
  "date" TIMESTAMP,
  "committee_code" VARCHAR,
  "committee_type" VARCHAR,
  "committee_name" VARCHAR,
  "transaction_type" VARCHAR,
  "contributing_committee_code" VARCHAR,
  "contributing_organization" VARCHAR,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "address_line_1" VARCHAR  -- Address - Line 1,
  "address_line_2" VARCHAR  -- Address - Line 2,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "contribution_amount" DOUBLE,
  "check_number" VARCHAR
);