About this Dataset

Campaign Finance - Loans

This dataset lists all loans taken out by candidates, officeholders and political committees on data files submitted per City Code Chapter 2-2-26.

For a complete listing of each column heading, please see the field listing here: http://services.austintexas.gov/edims/document.cfm?id=262466
Organization: City of Austin
Last updated: 2020-11-12T13:32:43.342084
Tags: campaign-finance, city-clerk, election, financial, loans

Tables

Table 1

@usgov.city_of_austin_campaign_finance_loans_dataset.table_1

36.01 KB
303 rows
26 columns


CREATE TABLE table_1 (
  "borrower" VARCHAR,
  "lender" VARCHAR,
  "loan_amount" DOUBLE,
  "loan_date" TIMESTAMP,
  "lender_type" VARCHAR,
  "financial_institution" VARCHAR,
  "lender_address" VARCHAR,
  "city_state_zip" VARCHAR,
  "loan_year" BIGINT,
  "interest_rate" VARCHAR,
  "maturity_date" TIMESTAMP,
  "collateral" VARCHAR,
  "personal_funds" VARCHAR,
  "lender_reported_occupation" VARCHAR,
  "lender_reported_employer" VARCHAR,
  "date_reported" TIMESTAMP,
  "report_filed" VARCHAR,
  "guarantor" VARCHAR,
  "guarantor_address" VARCHAR,
  "guarantor_city_state_zip" VARCHAR,
  "guarantor_occupation" VARCHAR,
  "guarantor_employer" VARCHAR,
  "amount_guaranteed" DOUBLE,
  "correction" VARCHAR,
  "view_report" VARCHAR,
  "transaction_id" VARCHAR
);