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
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Guarantor_Occupation | guarantor_occupation | guarantor_occupation | Text | For loans, the occupation of the guarantor, if applicable. |
| Office_Sought | office_sought | office_sought | Text | For 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_State | transactor_state | transactor_state | Text | State of the individual or entity involved in the transaction. |
| Collateral | collateral | collateral | Text | For loans, a description of the collateral, if applicable |
| Transactor_Employer | transactor_employer | transactor_employer | Text | The transactor's employer (for individuals) |
| Transaction_ID | transaction_id | transaction_id | Text | Unique ID based upon the concatenation of the Report_ID and Transaction_ID field - acts as a unique key for each individual transaction |
| Transaction_Type | transaction_type | transaction_type | Text | Identifies the type of transaction reported: Loan, Expenditure, Credit, Pledge, or Contribution. |
| Guarantor_City_State_Zip | guarantor_city | guarantor_city | Text | For loans, the city of the guarantor, if applicable. |
| Guarantor_Employer | guarantor_employer | guarantor_employer | Text | For loans, the employer of the guarantor, if applicable. |
| Schedule_Reported | schedule_reported | schedule_reported | Text | Identifies the TEC Schedule or ATX form on which the transaction is listed |
| Office_Held | office_held | office_held | Text | For officeholders, the office currently held |
| Report_Type | report_type | report_type | Text | The primary report type as listed on the form. |
| Report | report_id | report_id | Text | Unique identifier for the specific report - can be used to link individual transactions to a specific report. |
| Transaction_Amount | transaction_amount | transaction_amount | Number | Amount involved in the transaction. Amounts will be listed as a negative (-) for expenditures. |
| Transactor_Name | transactor_name | transactor_name | Text | The transactor's name (for individuals) or the name of the company, political committee, organization, or group (for entities). |
| Transaction_Date | transaction_date | transaction_date | Calendar date | Date on which the transaction occurred. |
| Guarantor_Name | guarantor_name | guarantor_name | Text | For loans, the name of the guarantor, if applicable. |
| Guarantor | guarantor | guarantor | Text | For 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_Type | election_type | election_type | Text | The type of the election for which this report is filed, if applicable |
| Transactor_Zip_Code | transactor_zip_code | transactor_zip_code | Text | Zip code of the individual or entity involved in the transaction. |
| Maturity_Date | maturity_date | maturity_date | Calendar date | For loans, the final maturity date of the loan. |
| Transactor_Occupation | transactor_occupation | transactor_occupation | Text | The transactor's occupation (for individuals) |
| Reimbursement_Intended | reimbursement_intended | reimbursement_intended | Text | If the filer intends to be reimbursed for this expenditure, this field will be marked ‘Y.’ |
| Transactor_City_State_Zip | transactor_city | transactor_city | Text | City of the individual or entity involved in the transaction. |
| Transaction_Code | transaction | transaction | Text | Unique 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 |
| Form | form | form | Text | The type of form filed |
| Date_Filed | date_filed | date_filed | Calendar date | Date the structured data file was received by the Office of the City Clerk |
| Correction_Flag | cor_flag | cor_flag | Text | If 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_Due | date_due | date_due | Calendar date | Due date of the report |
| Travel_Outside_Texas | outside_travel | outside_travel | Text | When marked ‘X,’ indicates that a transaction is for travel outside the state of Texas. |
| Returned_to_Filer | returned_to_filer | returned_to_filer | Text | If the transaction was a political contribution returned to the filer, this field will be marked ‘Y.’ |
| Personal_Funds | personal_funds_deposited | personal_funds_deposited | Text | When marked ’X,‘ indicates that the loan is a deposit of personal funds into an account in which political contributions are held. |
| Amount_Guaranteed | amount_guaranteed | amount_guaranteed | Number | For loans, the amount guaranteed by the guarantor, if applicable. |
| Out_Of_State_PAC | out_of_state_pac | out_of_state_pac | Text | For contributions, pledges, or loans, if the contributor or lender is an out-of-state political committee (PAC), this field will be marked ‘Y.’ |
| Election_Date | election_date | election_date | Calendar date | The date of the election for which this report is filed, if applicable |
| Out_of_State_PAC_ID | out_of_state_pac_id | out_of_state_pac_id | Text | For 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_Name | filer_name | filer_name | Text | Name 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_Address | guarantor_address_2 | guarantor_address_2 | Text | For loans, the address of the guarantor, if applicable. |
| View_Report | link_to_report | link_to_report | URL | A link to view a pdf version of the report on which the transaction is listed |
| Interest_Rate | interest_rate | interest_rate | Text | For loans, the interest rate of the loan. |
| Financial_Institution | lender_institution | lender_institution | Text | For loans, if the lender is a financial institution, this field is marked ‘Y.’ This field is marked ‘N’ for any other type of lender. |
| Entity | entity | entity | Text | Identifies the transactor as either an entity (such as a company, political committee, organization, or other group) or an individual person |
| Political_Obligation | political_obligation | political_obligation | Text | For an unpaid incurred obligation reported on F2, or a credit card expenditure reported on F4, ’Y’ indicates the expenditure was political. |
| Expense_Description | expense_description | expense_description | Text | If the transaction is an expenditure, a category and brief description of the purpose of the expenditure reported. |
| Transaction_Description | transaction_description | transaction_description | Text | For 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_Address | transactor_address_2 | transactor_address_2 | Text | Address of the individual or entity involved in the transaction. |