About this Dataset

Campaign Finance - Transaction Detail

This table lists individual transactions as reported on the Texas Ethics Commission C/OH Form. Each row represents an individual filer's transaction, which may be a loan, expenditure, credit, pledge or contribution.

For information about each report filed, please visit the Reports Table at: https://data.austintexas.gov/Government/Campaign-Finance-Data-Reports-Table/b2pc-2s8n

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:27:17.998731
Tags: campaign-finance, city-clerk, contributions, election, expenditures, financial

Tables

Table 1

@usgov.city_of_austin_campaign_finance_transaction_detail_dataset.table_1

6.58 MB
238302 rows
46 columns


CREATE TABLE table_1 (
  "transaction_type" VARCHAR,
  "filer_name" VARCHAR,
  "transactor_name" VARCHAR,
  "entity" VARCHAR,
  "transaction_amount" DOUBLE,
  "date_filed" TIMESTAMP,
  "form" VARCHAR,
  "report" VARCHAR,
  "transaction_code" VARCHAR,
  "transaction_id" VARCHAR,
  "date_due" TIMESTAMP,
  "report_type" VARCHAR,
  "election_date" VARCHAR,
  "election_type" VARCHAR,
  "office_held" VARCHAR,
  "office_sought" VARCHAR,
  "view_report" VARCHAR,
  "correction_flag" VARCHAR,
  "schedule_reported" VARCHAR,
  "transactor_address" VARCHAR,
  "transactor_city_state_zip" VARCHAR,
  "transactor_state" VARCHAR,
  "transactor_zip_code" VARCHAR,
  "transaction_date" TIMESTAMP,
  "transaction_description" VARCHAR,
  "expense_description" VARCHAR,
  "transactor_employer" VARCHAR,
  "transactor_occupation" VARCHAR,
  "financial_institution" VARCHAR,
  "interest_rate" VARCHAR,
  "maturity_date" TIMESTAMP,
  "collateral" VARCHAR,
  "personal_funds" VARCHAR,
  "guarantor" VARCHAR,
  "guarantor_name" VARCHAR,
  "guarantor_address" VARCHAR,
  "guarantor_city_state_zip" VARCHAR,
  "amount_guaranteed" VARCHAR,
  "guarantor_employer" VARCHAR,
  "guarantor_occupation" VARCHAR,
  "travel_outside_texas" VARCHAR,
  "political_obligation" VARCHAR,
  "reimbursement_intended" VARCHAR,
  "returned_to_filer" VARCHAR,
  "out_of_state_pac" VARCHAR,
  "out_of_state_pac_id" VARCHAR
);