senate_cand_cont
15,090 rows sorted by contributor descending
This data as json, CSV (advanced)
affiliation 5 ✖
- Democratic 10,495
- Republican 4,488
- Libertarian 5
- Unaffiliated 1
- Unity Party 1
Link | rowid | district | candidate | affiliation | contribution_amount | contribution_date | contributor ▲ | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2989 | 2989 | Senate District 12 | Gardner, Robert | Republican | 400.0 | 9/26/19 0:00 | William J Hybl | Colorado Springs | CO | 80906 | El Pomar Foundation | General Business | Individual | Monetary (Itemized) | |
2986 | 2986 | Senate District 12 | Gardner, Robert | Republican | 300.0 | 9/26/19 0:00 | William H Temby | Colorado Springs | CO | 80920 | Aprentice Personnel | General Business | Individual | Monetary (Itemized) | |
1998 | 1998 | Senate District 10 | Liston, Larry | Republican | 200.0 | 10/25/19 0:00 | William D Sinclair | Colorado Springs | CO | 80909 | Retired | Individual | Monetary (Itemized) | ||
9250 | 9250 | Senate District 26 | Bridges, Jeff | Democratic | 250.0 | 1/7/20 0:00 | William D Mutch | Colorado Springs | CO | 80907 | Mutch Government Relations | Lobbyist | Individual | Monetary (Itemized) | |
9949 | 9949 | Senate District 26 | Bridges, Jeff | Democratic | 50.0 | 10/14/20 0:00 | William D Mutch | Colorado Springs | CO | 80907 | Mutch Government Relations | Lobbyist | Individual | Monetary (Itemized) | |
10107 | 10107 | Senate District 26 | Bridges, Jeff | Democratic | 100.0 | 12/31/19 0:00 | William D Mutch | Colorado Springs | CO | 80907 | Mutch Government Relations | Lobbyist | Individual | Monetary (Itemized) | |
1728 | 1728 | Senate District 10 | Liston, Larry | Republican | 50.0 | 9/19/19 0:00 | William B Herpin | Colorado Springs | CO | 80909 | Retired | Individual | Monetary (Itemized) | ||
1790 | 1790 | Senate District 10 | Liston, Larry | Republican | 50.0 | 7/21/20 0:00 | William B Herpin | Colorado Springs | CO | 80909 | Retired | Individual | Monetary (Itemized) | ||
13591 | 13591 | Senate District 31 | Hansen, Chris | Democratic | 150.0 | 10/31/19 0:00 | William B Galloway | Aurora | CO | 80014 | Self | Healthcare/Medical | Individual | Monetary (Itemized) | |
13687 | 13687 | Senate District 31 | Hansen, Chris | Democratic | 400.0 | 12/15/19 0:00 | William Zhao | Lexington | MA | 2421 | Total | Environmental Services | Individual | Monetary (Itemized) | |
8005 | 8005 | Senate District 23 | Boccella, Sally | Democratic | 50.0 | 9/15/20 0:00 | William Zessar | Broomfield | CO | 80023 | Individual | Monetary (Itemized) | |||
3462 | 3462 | Senate District 14 | Ginal, Joann | Democratic | 5.0 | 9/3/20 0:00 | William Zalewski | Fort Collins | CO | 80528 | Individual | Monetary (Itemized) | |||
9589 | 9589 | Senate District 26 | Bridges, Jeff | Democratic | 200.0 | 7/27/20 0:00 | William Wynne | Denver | CO | 80209 | Thorn Run Partners | Consultant | Individual | Monetary (Itemized) | |
7288 | 7288 | Senate District 23 | Kirkmeyer, Barbara | Republican | 200.0 | 12/14/19 0:00 | William Wycoff | Brighton | CO | 80603 | Retired | Retired | Individual | Monetary (Itemized) | |
188 | 188 | Senate District 04 | Smallwood, James | Republican | 50.0 | 9/30/20 0:00 | William Wood | Parker | CO | 80134 | None | Retired | Individual | Monetary (Itemized) | |
10187 | 10187 | Senate District 27 | Staiert, Suzanne | Republican | 400.0 | 2/19/20 0:00 | William Witter | Boulder | CO | 80303 | Self Employed | General Business | Individual | Monetary (Itemized) | |
8934 | 8934 | Senate District 26 | Roth, Robert | Republican | 400.0 | 4/25/20 0:00 | William Wichterman | Phoenix | AZ | 85028 | The San Juan Company | Construction/Engineering | Individual | Monetary (Itemized) | |
197 | 197 | Senate District 04 | Smallwood, James | Republican | 75.0 | 9/30/20 0:00 | William Wasserman | Parker | CO | 80134 | Self | Other | Individual | Monetary (Itemized) | |
5546 | 5546 | Senate District 19 | Zenzinger, Rachel | Democratic | 25.0 | 8/11/20 0:00 | William Walser | Arvada | CO | 80003 | Jcmh | Healthcare/Medical | Individual | Monetary (Itemized) | |
3330 | 3330 | Senate District 14 | Hochheimer, Hans | Republican | 50.0 | 10/14/20 0:00 | William Tredenick | Windsor | CO | 80528 | Retired | Retired | Individual | Monetary (Itemized) | |
3403 | 3403 | Senate District 14 | Ginal, Joann | Democratic | 25.0 | 8/18/20 0:00 | William Timpson | Fort Collins | CO | 80521 | Individual | Monetary (Itemized) | |||
3571 | 3571 | Senate District 14 | Ginal, Joann | Democratic | 100.0 | 10/9/20 0:00 | William Thompson | Fort Collins | CO | 80526 | None | Retired | Individual | Monetary (Itemized) | |
10954 | 10954 | Senate District 27 | Kolker, Chris | Democratic | 100.0 | 3/23/20 0:00 | William Stevenson | Englewood | CO | 80111 | Not Currently Employed | Individual | Monetary (Itemized) | ||
9062 | 9062 | Senate District 26 | Roth, Robert | Republican | 200.0 | 9/9/20 0:00 | William Starker | Wheat Ridge | CO | 80214 | Retired | Retired | Individual | Monetary (Itemized) | |
6977 | 6977 | Senate District 23 | Kirkmeyer, Barbara | Republican | 25.0 | 5/20/20 0:00 | William Smellage | Longmont | CO | 80504 | Bank Of Colorado | Financial/Investment | Individual | Monetary (Itemized) | |
7130 | 7130 | Senate District 23 | Kirkmeyer, Barbara | Republican | 200.0 | 9/25/20 0:00 | William Skewes | Denver | CO | 80230 | Skewes Government Affairs | Lobbyist | Individual (Member of LLC: WILLIAM SKEWES) | Monetary (Itemized) - LLC Contribution (Total Amount: 200.00) | |
7131 | 7131 | Senate District 23 | Kirkmeyer, Barbara | Republican | 200.0 | 9/25/20 0:00 | William Skewes | Denver | CO | 80230 | Skewes Government Affairs | Lobbyist | Individual (Member of LLC: WILLIAM SKEWES) | Monetary (Itemized) - LLC Contribution (Total Amount: 200.00) | |
4197 | 4197 | Senate District 18 | Cage, Peggy | Republican | 50.0 | 10/1/20 0:00 | William Schaefer | Boulder | CO | 80301 | Individual | Monetary (Itemized) | |||
7156 | 7156 | Senate District 23 | Kirkmeyer, Barbara | Republican | 200.0 | 10/13/20 0:00 | William Scaff | Aurora | CO | 80016 | Store Petroleum Mgt Llc | Mining/Energy | Individual | Monetary (Itemized) | |
1382 | 1382 | Senate District 08 | Hanlon, Karl | Democratic | 100.0 | 10/14/20 0:00 | William Reed | Silverthorne | CO | 80497 | Ceres Group | Office and Administrative Occupations | Individual | Monetary (Itemized) | |
5140 | 5140 | Senate District 19 | Zenzinger, Rachel | Democratic | 50.0 | 5/30/20 0:00 | William Ray | Arvada | CO | 80002 | Not Currently Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
3456 | 3456 | Senate District 14 | Ginal, Joann | Democratic | 100.0 | 9/2/20 0:00 | William Pauzauskie | Fort Collins | CO | 80525 | Self | Attorney/Legal | Individual | Monetary (Itemized) | |
966 | 966 | Senate District 08 | Hanlon, Karl | Democratic | 100.0 | 5/14/20 0:00 | William Patterson | Montrose | CO | 81401 | Tei Rock Drills Inc. | Construction/Engineering | Individual | Monetary (Itemized) | |
11374 | 11374 | Senate District 27 | Kolker, Chris | Democratic | 50.0 | 7/21/20 0:00 | William Owens | Centennial | CO | 80112 | None | Retired | Individual | Monetary (Itemized) | |
11676 | 11676 | Senate District 27 | Kolker, Chris | Democratic | 100.0 | 9/12/20 0:00 | William Owens | Centennial | CO | 80112 | None | Retired | Individual | Monetary (Itemized) | |
11942 | 11942 | Senate District 27 | Kolker, Chris | Democratic | 50.0 | 10/11/19 0:00 | William Owens | Centennial | CO | 80112 | None | Retired | Individual | Monetary (Itemized) | |
12041 | 12041 | Senate District 27 | Kolker, Chris | Democratic | 50.0 | 10/21/20 0:00 | William Owens | Centennial | CO | 80112 | None | Retired | Individual | Monetary (Itemized) | |
11889 | 11889 | Senate District 27 | Kolker, Chris | Democratic | 400.0 | 10/6/20 0:00 | William Ostroski | Denver | CO | 80211 | Self | Attorney/Legal | Individual | Monetary (Itemized) | |
5435 | 5435 | Senate District 19 | Zenzinger, Rachel | Democratic | 100.0 | 7/24/20 0:00 | William Orchard | Arvada | CO | 80004 | Retired | Retired | Individual | Monetary (Itemized) | |
6562 | 6562 | Senate District 19 | Zenzinger, Rachel | Democratic | 200.0 | 7/9/18 0:00 | William Orchard | Arvada | CO | 80004 | Fluor Facility & Plant Services | Other | Individual | Monetary (Itemized) | |
6610 | 6610 | Senate District 19 | Zenzinger, Rachel | Democratic | 100.0 | 11/30/17 0:00 | William Orchard | Arvada | CO | 80004 | Fluor Facility & Plant Services | Other | Individual | Monetary (Itemized) | |
10406 | 10406 | Senate District 27 | Staiert, Suzanne | Republican | 100.0 | 9/26/20 0:00 | William Nazzaro | Centennial | CO | 80122 | Bill Nazarro Real Estate | Real Estate Professional | Individual | Monetary (Itemized) | |
657 | 657 | Senate District 08 | Rankin, Bob | Republican | 200.0 | 9/9/20 0:00 | William Mutch | Colorado Springs | CO | 80907 | Self | Lobbyist | Individual | Monetary (Itemized) | |
1797 | 1797 | Senate District 10 | Liston, Larry | Republican | 200.0 | 7/28/20 0:00 | William Mutch | Colorado Springs | CO | 80907 | Mutch Government Relations | Other | Individual | Monetary (Itemized) | |
3179 | 3179 | Senate District 12 | Gardner, Robert | Republican | 400.0 | 10/28/19 0:00 | William Mutch | Colorado Springs | CO | 80907 | Md Mutch | Media/Public Relations | Individual | Monetary (Itemized) | |
6410 | 6410 | Senate District 19 | Zenzinger, Rachel | Democratic | 100.0 | 12/11/19 0:00 | William Mutch | Colorado Springs | CO | 80907 | Mutch Government Relations | Consultant | Individual | Monetary (Itemized) | |
10362 | 10362 | Senate District 27 | Staiert, Suzanne | Republican | 200.0 | 9/9/20 0:00 | William Mutch | Colorado Springs | CO | 80907 | Mutch Government Relations | Government/Civil | Individual | Monetary (Itemized) | |
12664 | 12664 | Senate District 28 | Buckner, Janet | Democratic | 100.0 | 11/15/19 0:00 | William Mutch | Colorado Springs | CO | 80907 | Mutch Government Relations | Lobbyist | Individual | Monetary (Itemized) | |
13643 | 13643 | Senate District 31 | Hansen, Chris | Democratic | 100.0 | 11/17/19 0:00 | William Mutch | Colorado Springs | CO | 80907 | Mutch Government Relations | Government/Civil | Individual | Monetary (Itemized) | |
14384 | 14384 | Senate District 33 | Coleman, James | Democratic | 100.0 | 10/19/20 0:00 | William Mutch | Colorado Springs | CO | 80907 | Mutch Government Relations | Individual | Monetary (Itemized) | ||
13331 | 13331 | Senate District 31 | Hansen, Chris | Democratic | 100.0 | 6/8/20 0:00 | William Muir | Manhattan | KS | 66502 | Not Currently Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
7283 | 7283 | Senate District 23 | Kirkmeyer, Barbara | Republican | 100.0 | 11/27/19 0:00 | William Moser | Greeley | CO | 80634 | Josh Wells | Agriculture | Individual | Monetary (Itemized) | |
13135 | 13135 | Senate District 31 | Townsend, Doug | Republican | 20.0 | 9/16/20 0:00 | William Miller | Denver | CO | 80203 | Slawson Exploration Company Inc | Construction/Engineering | Individual | Monetary (Itemized) | |
3331 | 3331 | Senate District 14 | Hochheimer, Hans | Republican | 250.0 | 11/4/20 0:00 | William Mccoy | Windsor | CO | 80550 | Xaxax Analytics | Consultant | Individual | Monetary (Itemized) | |
6203 | 6203 | Senate District 19 | Zenzinger, Rachel | Democratic | 100.0 | 10/15/20 0:00 | William Mccarron | Denver | CO | 80207 | Retired | Retired | Individual | Monetary (Itemized) | |
10914 | 10914 | Senate District 27 | Kolker, Chris | Democratic | 200.0 | 3/10/20 0:00 | William Mccarron | Denver | CO | 80207 | Not Currently Employed | Individual | Monetary (Itemized) | ||
14716 | 14716 | Senate District 35 | Lopez, Carlos | Democratic | 400.0 | 9/21/20 0:00 | William Marlin | Denver | CO | 80210 | Franklin D. Azar & Associates | Attorney/Legal | Individual | Monetary (Itemized) | Campaign Donation |
3760 | 3760 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 25.0 | 10/6/19 0:00 | William Lindstedt | Broomfield | CO | 80020 | Self | Individual | Monetary (Itemized) | Campaign Contribution | |
11302 | 11302 | Senate District 27 | Kolker, Chris | Democratic | 27.0 | 7/8/20 0:00 | William Lindstedt | Broomfield | CO | 80020 | City Of Broomfield | Other | Individual | Monetary (Itemized) | |
14467 | 14467 | Senate District 33 | Coleman, James | Democratic | 25.0 | 11/21/19 0:00 | William Lindstedt | Broomfield | CO | 80020 | City And County Of Broomfield | Individual | Monetary (Itemized) | ||
3922 | 3922 | Senate District 17 | Menza, Matthew | Republican | 200.0 | 9/23/20 0:00 | William Kreidler | Glendale | OH | 45246 | Whitney Corp | Financial/Investment | Individual | Monetary (Itemized) | Donation Via Website |
3562 | 3562 | Senate District 14 | Ginal, Joann | Democratic | 5.0 | 10/8/20 0:00 | William Karspeek | Berthoud | CO | 80513 | Individual | Monetary (Itemized) | |||
5315 | 5315 | Senate District 19 | Zenzinger, Rachel | Democratic | 100.0 | 7/3/20 0:00 | William James | Denver | CO | 80206 | James Real Estate Services, Inc | Real Estate Professional | Individual | Monetary (Itemized) | |
1169 | 1169 | Senate District 08 | Hanlon, Karl | Democratic | 100.0 | 8/19/20 0:00 | William Infante | Basalt | CO | 81621-1827 | Hangai Mountain Textiles | Other | Individual | Monetary (Itemized) | |
5006 | 5006 | Senate District 19 | Zenzinger, Rachel | Democratic | 50.0 | 4/29/20 0:00 | William Husson | Arvada | CO | 80005 | None | Retired | Individual | Monetary (Itemized) | |
8976 | 8976 | Senate District 26 | Roth, Robert | Republican | 50.0 | 7/24/20 0:00 | William Horbatt | Denver | CO | 80203 | Retired | Retired | Individual | Monetary (Itemized) | |
10234 | 10234 | Senate District 27 | Staiert, Suzanne | Republican | 50.0 | 7/13/20 0:00 | William Horbatt | Denver | CO | 80203 | Retired | Retired | Individual | Monetary (Itemized) | |
9341 | 9341 | Senate District 26 | Bridges, Jeff | Democratic | 50.0 | 3/31/20 0:00 | William Hopping | Littleton | CO | 80123 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
9554 | 9554 | Senate District 26 | Bridges, Jeff | Democratic | 50.0 | 7/27/20 0:00 | William Hopping | Littleton | CO | 80123 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
9652 | 9652 | Senate District 26 | Bridges, Jeff | Democratic | 50.0 | 8/9/20 0:00 | William Hopping | Littleton | CO | 80123 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
3866 | 3866 | Senate District 17 | Menza, Matthew | Republican | 50.0 | 8/27/20 0:00 | William Hollander | Boulder | CO | 80301 | Ceo Hpd | Science/Technology | Individual | Monetary (Itemized) | Anedot Payment System Contribution |
3934 | 3934 | Senate District 17 | Menza, Matthew | Republican | 50.0 | 10/9/20 0:00 | William Hollander | Boulder | CO | 80301 | Ceo Hpd | Science/Technology | Individual | Monetary (Itemized) | Anedot Payment |
4288 | 4288 | Senate District 19 | Gerber, Lynn | Republican | 25.0 | 5/11/20 0:00 | William Hineser | Arvada | CO | 80004 | Retired | Retired | Individual | Monetary (Itemized) | |
7484 | 7484 | Senate District 23 | Parchment, Rupert | Republican | 100.0 | 6/10/20 0:00 | William Hembree | Broomfield | CO | 80020 | Retired | Retired | Individual | Monetary (Itemized) | |
10153 | 10153 | Senate District 27 | Staiert, Suzanne | Republican | 35.0 | 9/9/19 0:00 | William Hembree | Broomfield | CO | 80020 | Retired | Retired | Individual | Monetary (Itemized) | |
6613 | 6613 | Senate District 19 | Zenzinger, Rachel | Democratic | 25.0 | 12/1/17 0:00 | William Hauer | Arvada | CO | 80003 | Retired | Retired | Individual | Monetary (Itemized) | |
13299 | 13299 | Senate District 31 | Hansen, Chris | Democratic | 400.0 | 5/17/20 0:00 | William Hartman | Denver | CO | 80207 | High Noon Entertainment | Other | Individual | Monetary (Itemized) | |
4725 | 4725 | Senate District 19 | Zenzinger, Rachel | Democratic | 400.0 | 6/18/19 0:00 | William Grant | Denver | CO | 80206 | Not Currently Employed | Individual | Monetary (Itemized) | ||
1124 | 1124 | Senate District 08 | Hanlon, Karl | Democratic | 100.0 | 8/5/20 0:00 | William Graham | Grand Junction | CO | 81506 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
1358 | 1358 | Senate District 08 | Hanlon, Karl | Democratic | 100.0 | 10/7/20 0:00 | William Graham | Grand Junction | CO | 81506 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
12496 | 12496 | Senate District 28 | Buckner, Janet | Democratic | 400.0 | 10/9/20 0:00 | William Goodrum | Greenwood Village | CO | 80111 | Not Currently Employed | Individual | Monetary (Itemized) | ||
4363 | 4363 | Senate District 19 | Gerber, Lynn | Republican | 50.0 | 5/27/20 0:00 | William Gerber | Westminster | CO | 80021 | Talk To The Camera | Media/Public Relations | Individual | Monetary (Itemized) | |
4429 | 4429 | Senate District 19 | Gerber, Lynn | Republican | 40.0 | 7/24/20 0:00 | William Gerber | Westminster | CO | 80021 | Talk To The Camera | Media/Public Relations | Individual | Monetary (Itemized) | |
4484 | 4484 | Senate District 19 | Gerber, Lynn | Republican | 231.0 | 8/3/20 0:00 | William Gerber | Westminster | CO | 80021 | Talk To The Camera | Media/Public Relations | Individual | Monetary (Itemized) | |
4639 | 4639 | Senate District 19 | Gerber, Lynn | Republican | 75.0 | 10/7/20 0:00 | William Gerber | Westminster | CO | 80021 | Talk To The Camera | Media/Public Relations | Individual | Monetary (Itemized) | |
14333 | 14333 | Senate District 33 | Coleman, James | Democratic | 100.0 | 10/7/20 0:00 | William Galloway Md | Evergreen | CO | 80439 | Self Employed | Individual | Monetary (Itemized) | ||
12649 | 12649 | Senate District 28 | Buckner, Janet | Democratic | 300.0 | 11/13/19 0:00 | William Galloway | Aurora | CO | 80012 | Not Currently Employed | Individual | Monetary (Itemized) | ||
12928 | 12928 | Senate District 29 | Fields, Rhonda | Democratic | 200.0 | 10/2/20 0:00 | William Galloway | Aurora | CO | 80014 | Physician | Healthcare/Medical | Individual | Monetary (Itemized) | |
4073 | 4073 | Senate District 18 | Fenberg, Stephen | Democratic | 100.0 | 12/29/16 0:00 | William Fenberg | Dayton | OH | 45459 | Kettering Health Alliance | Healthcare/Medical | Individual | Monetary (Itemized) | William Fenberg |
7450 | 7450 | Senate District 23 | Parchment, Rupert | Republican | 100.0 | 6/2/20 0:00 | William Farr | Timnath | CO | 80547 | Retired | Retired | Individual | Monetary (Itemized) | |
14530 | 14530 | Senate District 33 | Coleman, James | Democratic | 400.0 | 12/31/19 0:00 | William Doherty | Atlantic | IA | 50022 | Liberty Consulting | Individual | Monetary (Itemized) | ||
1745 | 1745 | Senate District 10 | Liston, Larry | Republican | 200.0 | 1/7/20 0:00 | William Coyne | Denver | CO | 80220 | Headwaters Strategies | Consultant | Individual | Monetary (Itemized) | |
5727 | 5727 | Senate District 19 | Zenzinger, Rachel | Democratic | 200.0 | 9/2/20 0:00 | William Coyne | Denver | CO | 80206 | Headwaters Strategies | Lobbyist | Individual | Monetary (Itemized) | |
9270 | 9270 | Senate District 26 | Bridges, Jeff | Democratic | 200.0 | 1/31/20 0:00 | William Coyne | Denver | CO | 80220 | Headwaters Strategies | Consultant | Individual | Monetary (Itemized) | |
13396 | 13396 | Senate District 31 | Hansen, Chris | Democratic | 200.0 | 7/6/20 0:00 | William Coyne | Denver | CO | 80220 | Headwaters Strategies | Consultant | Individual | Monetary (Itemized) | |
13690 | 13690 | Senate District 31 | Hansen, Chris | Democratic | 200.0 | 12/17/19 0:00 | William Coyne | Denver | CO | 80220 | Headwaters Strategies | Consultant | Individual | Monetary (Itemized) | |
13630 | 13630 | Senate District 31 | Hansen, Chris | Democratic | 400.0 | 11/6/19 0:00 | William Clay | Centennial | CO | 80112 | Solar Installation | General Business | Individual | Monetary (Itemized) | |
1681 | 1681 | Senate District 08 | Menconi, Arn | Democratic | 100.0 | 6/20/20 0:00 | William Cisney | Denver | CO | 80212 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
2587 | 2587 | Senate District 10 | Mccallian, Randal | Democratic | 50.0 | 7/27/20 0:00 | William Cisney | Denver | CO | 80212 | Individual | Monetary (Itemized) | |||
4894 | 4894 | Senate District 19 | Zenzinger, Rachel | Democratic | 50.0 | 2/21/20 0:00 | William Cisney | Denver | CO | 80212 | Not Currently Employed | Individual | Monetary (Itemized) |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_cand_cont" ( "district" TEXT, "candidate" TEXT, "affiliation" TEXT, "contribution_amount" REAL, "contribution_date" TEXT, "contributor" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "employer" TEXT, "occupation" TEXT, "contributor_type" TEXT, "contribution_type" TEXT, "explanation" TEXT );