Campaign Finance
This dataset has the following 19 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| ID | id | text | Unique identifier for record | A48064 A48065 A48067 A48068 A48069 view top 100 |
| Record ID | record_id | number | Unique identifier for search | 48064 48065 48067 48068 48069 view top 100 |
| Report ID | report_id | number | Unique identifier for report | 449 270 1120 1216 1349 view top 100 |
| File Link | file_link | url | PDF Link to Report | {"url":"http://campfin.dallascityhall.com/FinalReports/rpt0000000449_20100312_154155.pdf"} {"url":"http://campfin.dallascityhall.com/FinalReports/rpt0000000270_20090409_101429.pdf"} {"url":"http://campfin.dallascityhall.com/FinalReports/rpt0000001120_20150409_165317.pdf"} {"url":"http://campfin.dallascityhall.com/FinalReports/rpt0000001216_20150713_135434.pdf"} {"url":"http://campfin.dallascityhall.com/FinalReports/srp0000001349_20170117_163748.pdf"} view top 100 |
| First Name | first_name | text | Client first name who paid the amount | John Carolyn Kimberly Aric Venek view top 100 |
| Last Name | last_name | text | Client last name who paid the amount | Williams Davis Wilson Green Oree view top 100 |
| Business Name | business_name | text | Client Business name who paid the amount | Sams Club Self USPS Shell Office Depot view top 100 |
| Contact Type | contact_type | text | Type of the client | Candidate / Committee Expenditure Contributor Lender Pledger view top 100 |
| Record Type | record_type | text | The election for which the client made the contribution | January 15: Semi-Annual 2014 Final Report (COH) April 11: 30th Day Before General Election 2013 July 15 Semi-Annual 2013 Final Dissolution (SPAC) view top 100 |
| Amount | amount | text | The amount of the contribution | 0.00 500.00 1000.00 250.00 100.00 view top 100 |
| Schedule Type | schedule_type | text | The type of the contribution | Report Political Expenditures Political Contributions Other Than Pledges Or Loans Payment From Political Contributions To A Business Of C/OH Loans view top 100 |
| Candidate Name | candidate_name | text | Michael Rawlings Vonciel Hill Monica Alonzo Tennell Atkins Jennifer Gates view top 100 | |
| Election Date | election_date | calendar_date | 2013-05-13T00:00:00 2015-05-09T00:00:00 2013-05-11T00:00:00 2013-06-15T00:00:00 2013-05-15T00:00:00 view top 100 | |
| Transaction Date | transaction_date | calendar_date | 2009-10-13T00:00:00 2017-03-27T00:00:00 2017-04-19T00:00:00 2017-04-26T00:00:00 2017-04-11T00:00:00 view top 100 | |
| Street | street | text | 4318 Idaho Ave 9218 Linda Vista 2211 N First Street PO Box 4126 721 W Tarrant Road view top 100 | |
| City | city | text | Dallas Richardson Plano San Francisco San Jose view top 100 | |
| State | state | text | TX WA CA NY NV view top 100 | |
| Zipcode | zipcode | text | 75204 75201 75225 75208 75219 view top 100 | |
| Geo Location | geo_location | location | view top 100 |