About this Dataset

Campaign Finance - Report Detail

This dataset contains data about the Campaign Finance Report received by a filer. The Reports table contains information about the type of report filed, the due date, original filing date, and transaction totals.

To access the Transactions table, where individual transactions are listed, please go to: https://data.austintexas.gov/Government/Campaign-Finance-Transaction-Detail/g4yx-aw9r

A data dictionary for this dataset is available at http://services.austintexas.gov/edims/document.cfm?id=247730
Organization: City of Austin
Last updated: 2020-11-12T13:24:42.958267
Tags: campaign-finance, city-clerk, contributions, election, expenditures, financial

Tables

Table 1

@usgov.city_of_austin_campaign_finance_report_detail_dataset.table_1

196.58 kB
2,419 rows
35 columns

CREATE TABLE table_1 (
  "filer_name" VARCHAR,
  "form" VARCHAR,
  "report_type" VARCHAR,
  "report_type2" VARCHAR,
  "view_report" VARCHAR,
  "date_filed" TIMESTAMP,
  "filer_address" VARCHAR,
  "filer_city_state_zip" VARCHAR,
  "report_id" VARCHAR,
  "treasurer_name" VARCHAR,
  "treasurer_address" VARCHAR,
  "treasurer_city_state_zip" VARCHAR,
  "date_due" TIMESTAMP,
  "name_as_reported" VARCHAR,
  "filer_phone" VARCHAR,
  "treasurer_state" VARCHAR,
  "treasurer_zip_code" VARCHAR,
  "treasurer_phone" VARCHAR,
  "period_from" TIMESTAMP,
  "period_to" TIMESTAMP,
  "election_date" TIMESTAMP,
  "election_type" VARCHAR,
  "office_held" VARCHAR,
  "office_sought" VARCHAR,
  "unitemized_contrib_total" DOUBLE,
  "contrib_total" DOUBLE,
  "unitemized_expend_total" DOUBLE,
  "expend_total" DOUBLE,
  "contrib_balance" DOUBLE,
  "outstand_loan" DOUBLE,
  "unitemized_inkind_total" DOUBLE,
  "unitemized_pledge_total" DOUBLE,
  "unitemized_loan_total" DOUBLE,
  "unitemized_unpaid_total" DOUBLE,
  "unitemized_cred_card_total" DOUBLE
);