Readme
Updated over 2 years ago
‧ Indexed 3 hours ago
Campaign Finance - Travel Outside of Texas Dataset
Contains detailed information for expenditures or an in-kind contributions that were used for travel outside the state of Texas. Data in this sheet corresponds to the information collected on Texas Ethics Commissions's Schedule T.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| Travel_ID | travel_id | travel_id | Text | Unique ID based upon the concatenation of the Report_ID, Transaction_ID and Travel fields - acts as a unique key for each individual transaction |
| Transport_Type | transport_type | transport_type | Text | The method of travel. |
| Filer_Name | filer_name | filer_name | Text | Name of individual or political committee 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. |
| Traveler | traveler | traveler | Text | The name of the individual traveler. |
| Departure_Date | departure_date | departure_date | Calendar date | The departure date. |
| Arrival_Date | arrival_date | arrival_date | Calendar date | The arrival date. |
| Correction | correction | correction | 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. |
| Arrival_City | arrival_city | arrival_city | Text | The name of the arrival/destination city or location. |
| Transaction_Type | transaction_type | transaction_type | Text | Identifies the type of transaction reported: Expenditure or Contribution. |
| Travel_Purpose | travel_purpose | travel_purpose | Text | A description of the purpose of the travel, including the name of a conference, seminar, or other event. |
| Departure_City | departure_city | departure_city | Text | The name of the departure city or location. |
| 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). |
| View_Report | view_report | view_report | Text | A link to view a PDF version of the report filed with the Office of the City Clerk. |
| Parent_Transaction | parent_transaction | parent_transaction | Text | Unique ID based upon the concatenation of the Report_ID and Transaction_ID field - acts as a unique key for each individual transaction |
Upstream Metadata