austintexas-gov/campaign-finance-transaction-detail-dataset-g4yx-aw9r

  • campaign finance
  • city clerk
  • contributions
  • election
  • expenditures
  • + 1

Campaign Finance - Transaction Detail Dataset

Campaign Finance - Transaction Detail Dataset

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://www.austintexas.gov/edims/document.cfm?id=247730

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Guarantor_Occupationguarantor_occupationguarantor_occupationTextFor loans, the occupation of the guarantor, if applicable.
Office_Soughtoffice_soughtoffice_soughtTextFor candidates in an upcoming election, the office being sought. For unsuccessful candidates in a recently held election, the office sought during the election preceding the deadline for this report
Transactor_Statetransactor_statetransactor_stateTextState of the individual or entity involved in the transaction.
CollateralcollateralcollateralTextFor loans, a description of the collateral, if applicable
Transactor_Employertransactor_employertransactor_employerTextThe transactor's employer (for individuals)
Transaction_IDtransaction_idtransaction_idTextUnique ID based upon the concatenation of the Report_ID and Transaction_ID field - acts as a unique key for each individual transaction
Transaction_Typetransaction_typetransaction_typeTextIdentifies the type of transaction reported: Loan, Expenditure, Credit, Pledge, or Contribution.
Guarantor_City_State_Zipguarantor_cityguarantor_cityTextFor loans, the city of the guarantor, if applicable.
Guarantor_Employerguarantor_employerguarantor_employerTextFor loans, the employer of the guarantor, if applicable.
Schedule_Reportedschedule_reportedschedule_reportedTextIdentifies the TEC Schedule or ATX form on which the transaction is listed
Office_Heldoffice_heldoffice_heldTextFor officeholders, the office currently held
Report_Typereport_typereport_typeTextThe primary report type as listed on the form.
Reportreport_idreport_idTextUnique identifier for the specific report - can be used to link individual transactions to a specific report.
Transaction_Amounttransaction_amounttransaction_amountNumberAmount involved in the transaction. Amounts will be listed as a negative (-) for expenditures.
Transactor_Nametransactor_nametransactor_nameTextThe transactor's name (for individuals) or the name of the company, political committee, organization, or group (for entities).
Transaction_Datetransaction_datetransaction_dateCalendar dateDate on which the transaction occurred.
Guarantor_Nameguarantor_nameguarantor_nameTextFor loans, the name of the guarantor, if applicable.
GuarantorguarantorguarantorTextFor loans, if there is a guarantor, this field will be marked ‘Y.’ When this is marked ‘N,’ it indicates that there is no guarantor for the loan.
Election_Typeelection_typeelection_typeTextThe type of the election for which this report is filed, if applicable
Transactor_Zip_Codetransactor_zip_codetransactor_zip_codeTextZip code of the individual or entity involved in the transaction.
Maturity_Datematurity_datematurity_dateCalendar dateFor loans, the final maturity date of the loan.
Transactor_Occupationtransactor_occupationtransactor_occupationTextThe transactor's occupation (for individuals)
Reimbursement_Intendedreimbursement_intendedreimbursement_intendedTextIf the filer intends to be reimbursed for this expenditure, this field will be marked ‘Y.’
Transactor_City_State_Ziptransactor_citytransactor_cityTextCity of the individual or entity involved in the transaction.
Transaction_CodetransactiontransactionTextUnique identifier for the individual transaction listed - can be used to link transactions associated with multiple records, e.g. Direct Campaign Expenditures or Out of State Travel
FormformformTextThe type of form filed
Date_Fileddate_fileddate_filedCalendar dateDate the structured data file was received by the Office of the City Clerk
Correction_Flagcor_flagcor_flagTextIf the transaction is reported on a Correction Affidavit, the correction flag will contain either NEW, or MODIFY. NEW indicates the transaction is newly reported, MODIFY indicates the transaction is a modification of a previously reported transaction.
Date_Duedate_duedate_dueCalendar dateDue date of the report
Travel_Outside_Texasoutside_traveloutside_travelTextWhen marked ‘X,’ indicates that a transaction is for travel outside the state of Texas.
Returned_to_Filerreturned_to_filerreturned_to_filerTextIf the transaction was a political contribution returned to the filer, this field will be marked ‘Y.’
Personal_Fundspersonal_funds_depositedpersonal_funds_depositedTextWhen marked ’X,‘ indicates that the loan is a deposit of personal funds into an account in which political contributions are held.
Amount_Guaranteedamount_guaranteedamount_guaranteedNumberFor loans, the amount guaranteed by the guarantor, if applicable.
Out_Of_State_PACout_of_state_pacout_of_state_pacTextFor contributions, pledges, or loans, if the contributor or lender is an out-of-state political committee (PAC), this field will be marked ‘Y.’
Election_Dateelection_dateelection_dateCalendar dateThe date of the election for which this report is filed, if applicable
Out_of_State_PAC_IDout_of_state_pac_idout_of_state_pac_idTextFor contributions, pledges, or loans, if the contributor or lender is an out-of-state political committee (PAC), the committee's Federal Election Commission (FEC) identification number.
Filer_Namefiler_namefiler_nameTextName of individual, committee or entity filing the report. This name is a standardized format used by the Office of the City Clerk to ensure all of a filer's reports are accessible under a single name
Guarantor_Addressguarantor_address_2guarantor_address_2TextFor loans, the address of the guarantor, if applicable.
View_Reportlink_to_reportlink_to_reportURLA link to view a pdf version of the report on which the transaction is listed
Interest_Rateinterest_rateinterest_rateTextFor loans, the interest rate of the loan.
Financial_Institutionlender_institutionlender_institutionTextFor loans, if the lender is a financial institution, this field is marked ‘Y.’ This field is marked ‘N’ for any other type of lender.
EntityentityentityTextIdentifies the transactor as either an entity (such as a company, political committee, organization, or other group) or an individual person
Political_Obligationpolitical_obligationpolitical_obligationTextFor an unpaid incurred obligation reported on F2, or a credit card expenditure reported on F4, ’Y’ indicates the expenditure was political.
Expense_Descriptionexpense_descriptionexpense_descriptionTextIf the transaction is an expenditure, a category and brief description of the purpose of the expenditure reported.
Transaction_Descriptiontransaction_descriptiontransaction_descriptionTextFor credits, expenditures, and contributions, a brief description of the transaction. For in-kind contributions, a description of the contribution or item. For credits, a description of the purpose for which the amount was received. For expenditures, a description of the activity conducted by making the expenditure.
Transactor_Addresstransactor_address_2transactor_address_2TextAddress of the individual or entity involved in the transaction.

Upstream Metadata