senate_cand_cont
1,355 rows where district = "Senate District 23" sorted by contribution_amount
This data as json, CSV (advanced)
Suggested facets: candidate, affiliation, state, occupation, contribution_type
Link | rowid | district | candidate | affiliation | contribution_amount ▼ | contribution_date | contributor | city | state | zip | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7507 | 7507 | Senate District 23 | Parchment, Rupert | Republican | -4253.93 | 7/17/20 0:00 | Rupert Parchment | Windsor | CO | 80550 | Candidate | Returned Contributions | Reimbursement To Candidate | ||
8142 | 8142 | Senate District 23 | Boccella, Sally | Democratic | -1000.0 | 10/19/20 0:00 | Colorado Dental Small Donor Committee | Greenwood Village | CO | 80111 | Small Donor Committee | Monetary (Itemized) | Offset Due To Deletion Of Filed Item | ||
7612 | 7612 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | -250.0 | 5/18/20 0:00 | Roger Bagg | Longmont | CO | 80501 | Carbon Valley Animal Hospital | Healthcare/Medical | Individual | Returned Contributions | Contributor Over-Contributed Unknowingly, Refund Processed For The Full Amount Of The Contribution. |
6941 | 6941 | Senate District 23 | Kirkmeyer, Barbara | Republican | -200.0 | 1/31/20 0:00 | Keith Engler | Denver | CO | 80202 | Clear Creek Resource Partners | Mining/Energy | Individual (Member of LLC: KEITH ENGLER) | Returned Contributions - LLC Contribution (Total Amount: -200.00) | 0 |
6942 | 6942 | Senate District 23 | Kirkmeyer, Barbara | Republican | -200.0 | 1/31/20 0:00 | Ryan Zorn | Denver | CO | 80202 | Clear Creek Resource Partners | Mining/Energy | Individual (Member of LLC: RYAN ZORN) | Returned Contributions - LLC Contribution (Total Amount: -200.00) | 0 |
7085 | 7085 | Senate District 23 | Kirkmeyer, Barbara | Republican | -200.0 | 9/2/20 0:00 | Scott Reasoner | Denver | CO | 80203 | Pdc Energy | Mining/Energy | Individual | Returned Contributions | 0 |
7353 | 7353 | Senate District 23 | Parchment, Rupert | Republican | -200.0 | 4/30/20 0:00 | Lesley Hollywood | Johnstown | CO | 80534 | Modern Media Management | Media/Public Relations | Individual | Monetary (Itemized) | Offset Due To Update Of Filed Item |
7489 | 7489 | Senate District 23 | Parchment, Rupert | Republican | -200.0 | 6/15/20 0:00 | Todd Bontrager | Broomfield | CO | 80023 | Self | Financial/Investment | Individual | Returned Contributions | Returned Over Contribution |
7006 | 7006 | Senate District 23 | Kirkmeyer, Barbara | Republican | -100.0 | 6/24/20 0:00 | Susan Fakharzadeh | Denver | CO | 80218 | Great Western | Mining/Energy | Individual | Returned Contributions | 0 |
7144 | 7144 | Senate District 23 | Kirkmeyer, Barbara | Republican | -50.0 | 10/2/19 0:00 | Art Guttersen | Greeley | CO | 80634 | Guttersen Ranch | Agriculture | Individual | Returned Contributions | 0 |
7762 | 7762 | Senate District 23 | Boccella, Sally | Democratic | -25.0 | 5/8/20 0:00 | Jack Regenbogen | Denver | CO | 8203 | Individual | Returned Contributions | Returned Via Act Blue | ||
7777 | 7777 | Senate District 23 | Boccella, Sally | Democratic | 1.0 | 6/4/20 0:00 | Rebecca Christensen | Denver | CO | 80202 | Individual | Monetary (Itemized) | |||
7783 | 7783 | Senate District 23 | Boccella, Sally | Democratic | 1.0 | 6/14/20 0:00 | Theodore Tritsch | Johnstown | CO | 80534 | Individual | Monetary (Itemized) | |||
7181 | 7181 | Senate District 23 | Kirkmeyer, Barbara | Republican | 1.92 | 10/26/20 0:00 | Charlotte Freyer 2011 Tru Freyer | Denver | CO | 80206 | Individual (Member of LLC: CHARLOTTE FREYER 2011 TRU WESTERN ROOTS LLC) | Monetary (Itemized) - LLC Contribution (Total Amount: 1.92) | |||
7185 | 7185 | Senate District 23 | Kirkmeyer, Barbara | Republican | 1.92 | 10/26/20 0:00 | John 0 Freyer Iii | Denver | CO | 80206 | Individual (Member of LLC: JOHN E FREYER) | Monetary (Itemized) - LLC Contribution (Total Amount: 152.96) | |||
7188 | 7188 | Senate District 23 | Kirkmeyer, Barbara | Republican | 1.92 | 10/26/20 0:00 | John Walker 2017 Trust Walker | Denver | CO | 80206 | Individual (Member of LLC: JOHN FREYER III) | Monetary (Itemized) - LLC Contribution (Total Amount: 1.92) | |||
7190 | 7190 | Senate District 23 | Kirkmeyer, Barbara | Republican | 1.92 | 10/26/20 0:00 | Soophia Freyer 2010 Trust Freyer | Denver | CO | 80206 | Individual (Member of LLC: SOOPHIA FREYER 2010 TRUST WESTERN ROOTS LLC) | Monetary (Itemized) - LLC Contribution (Total Amount: 1.92) | |||
7191 | 7191 | Senate District 23 | Kirkmeyer, Barbara | Republican | 1.92 | 10/26/20 0:00 | Taylor Walker 2019 Trust Walker | Denver | CO | 80206 | Individual (Member of LLC: TAYLOR WALKER 2019 TRUST WESTERN ROOTS LLC) | Monetary (Itemized) - LLC Contribution (Total Amount: 1.92) | |||
7192 | 7192 | Senate District 23 | Kirkmeyer, Barbara | Republican | 1.92 | 10/26/20 0:00 | Zella Freyer 2012 Trust Freyer | Denver | CO | 80206 | Individual (Member of LLC: ZELLA FREYER 2012 TRUST WESTERN ROOTS LLC) | Monetary (Itemized) - LLC Contribution (Total Amount: 1.92) | |||
6940 | 6940 | Senate District 23 | Kirkmeyer, Barbara | Republican | 4.72 | 1/31/20 0:00 | Tammy Klein | Fort Lupton | CO | 80621 | Self | Consultant | Individual | Non-Monetary (Itemized) | |
7368 | 7368 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/15/20 0:00 | Lesley Taylor | Johnstown | CO | 80534 | Modern Media Management | Media/Public Relations | Individual | Monetary (Itemized) | |
7370 | 7370 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/15/20 0:00 | Susan Freehauf | CO | Individual | Monetary (Itemized) | |||||
7376 | 7376 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/15/20 0:00 | Marlo Acevedo | CO | Individual | Monetary (Itemized) | |||||
7378 | 7378 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/15/20 0:00 | Myrtice Smith | Fayetteville | GA | 30215 | Self | Retail Sales | Individual | Monetary (Itemized) | |
7388 | 7388 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/15/20 0:00 | Priscilla Rahn | CO | Individual | Monetary (Itemized) | |||||
7392 | 7392 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/15/20 0:00 | Ainsworth Jones | Stoneham | MA | 2180 | Self | Consultant | Individual | Monetary (Itemized) | |
7398 | 7398 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/15/20 0:00 | Tammy Fisher | Loveland | CO | 80538 | Individual | Monetary (Itemized) | |||
7399 | 7399 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/15/20 0:00 | Beth Hoffman | CO | Individual | Monetary (Itemized) | |||||
7400 | 7400 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/15/20 0:00 | Chris Lockamy | Durhan | NC | 27713 | Individual | Monetary (Itemized) | |||
7407 | 7407 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/16/20 0:00 | Timothy Roberts | Queens | NY | 11101 | Individual | Monetary (Itemized) | |||
7408 | 7408 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/16/20 0:00 | Jessica Lovitt | Castle Pines | CO | 80108 | Individual | Monetary (Itemized) | |||
7411 | 7411 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/18/20 0:00 | Melissa Smith | Westminster | CO | 80234 | Individual | Monetary (Itemized) | |||
7421 | 7421 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/22/20 0:00 | Mindy Rietz | CO | Individual | Monetary (Itemized) | |||||
7437 | 7437 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/30/20 0:00 | Chris Leinster | CO | Individual | Monetary (Itemized) | |||||
7443 | 7443 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/31/20 0:00 | Will Hogrefe | CO | Individual | Monetary (Itemized) | |||||
7444 | 7444 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 5/31/20 0:00 | Rebekah Wuinlan | CO | Individual | Monetary (Itemized) | |||||
7463 | 7463 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 6/5/20 0:00 | Susan Freehauf | CO | Individual | Monetary (Itemized) | |||||
7467 | 7467 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 6/5/20 0:00 | Lance Cayko | CO | Individual | Monetary (Itemized) | |||||
7471 | 7471 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 6/5/20 0:00 | Tamara Wessel-Stodder | CO | Individual | Monetary (Itemized) | |||||
7472 | 7472 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 6/6/20 0:00 | Marlo Acevedo | CO | Individual | Monetary (Itemized) | |||||
7473 | 7473 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 6/6/20 0:00 | Heather Jolly | CO | Individual | Monetary (Itemized) | |||||
7528 | 7528 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 10/25/19 0:00 | Monetary (Non-Itemized) | ||||||||
7532 | 7532 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 10/31/19 0:00 | Monetary (Non-Itemized) | ||||||||
7576 | 7576 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 5.0 | 4/9/20 0:00 | Marjorie Birks | Broomfield | CO | 80023 | Individual | Monetary (Itemized) | |||
7585 | 7585 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 5.0 | 4/22/20 0:00 | Marjorie Birks | Broomfield | CO | 80023 | Individual | Monetary (Itemized) | |||
7680 | 7680 | Senate District 23 | Boccella, Sally | Democratic | 5.0 | 1/20/20 0:00 | Rydell Degeldere | Johnstown | CO | 80534 | Individual | Monetary (Itemized) | |||
7683 | 7683 | Senate District 23 | Boccella, Sally | Democratic | 5.0 | 1/20/20 0:00 | Julie Maslowski | Firestone | CO | 80504 | Individual | Monetary (Itemized) | |||
8123 | 8123 | Senate District 23 | Boccella, Sally | Democratic | 5.0 | 10/14/20 0:00 | Daniel Greteman | West Hollywood | CA | 90046 | Individual | Monetary (Itemized) | |||
7790 | 7790 | Senate District 23 | Boccella, Sally | Democratic | 7.48 | 6/21/20 0:00 | Sally Boccella | Johnstown | CO | 80534 | Individual | Monetary (Itemized) | Sally Purchased Thank You Cards | ||
7634 | 7634 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 8.0 | 6/10/20 0:00 | Victor Belousov | Leadville | CO | 80461 | Individual | Monetary (Itemized) | |||
7558 | 7558 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 9.0 | 2/29/20 0:00 | Maria Spiridonova | Denver | CO | 80239 | Not Employed | Individual | Monetary (Itemized) | ||
7182 | 7182 | Senate District 23 | Kirkmeyer, Barbara | Republican | 9.44 | 10/26/20 0:00 | Christina Freyerr 1998 Tr Freyer | Denver | CO | 80206 | Individual (Member of LLC: CHRISTINA FREYERR 1998 TR WESTERN ROOTS LLC) | Monetary (Itemized) - LLC Contribution (Total Amount: 9.44) | |||
7186 | 7186 | Senate District 23 | Kirkmeyer, Barbara | Republican | 9.44 | 10/26/20 0:00 | John Evans Freyer Jr 1998 Trust | Denver | CO | 80206 | Individual (Member of LLC: JOHN FREYER 2012 TRUST WESTERN ROOTS LLC) | Monetary (Itemized) - LLC Contribution (Total Amount: 51.36) | |||
7189 | 7189 | Senate District 23 | Kirkmeyer, Barbara | Republican | 9.44 | 10/26/20 0:00 | Miles Freyer 1998 Trust Freyer | Denver | CO | 80206 | Individual (Member of LLC: MILES FREYER 1998 TRUST WESTERN ROOTS LLC) | Monetary (Itemized) - LLC Contribution (Total Amount: 9.44) | |||
7015 | 7015 | Senate District 23 | Kirkmeyer, Barbara | Republican | 10.0 | 7/1/20 0:00 | Isaac Smith | Gahanna | OH | 43230 | Oilfield | Mining/Energy | Individual | Monetary (Itemized) | |
7147 | 7147 | Senate District 23 | Kirkmeyer, Barbara | Republican | 10.0 | 10/8/20 0:00 | Hannah Childs | Colorado Springs | CO | 80926 | Self | Healthcare/Medical | Individual | Monetary (Itemized) | |
7327 | 7327 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 3/31/20 0:00 | Ananymous Anonymous | CO | Individual | Monetary (Itemized) | |||||
7342 | 7342 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 4/25/20 0:00 | Alan Kessock | Ft Collins | CO | 80528 | Nutrien | Other | Individual | Monetary (Itemized) | |
7344 | 7344 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 4/25/20 0:00 | Susan Mccrary | Berthoud | CO | 80513 | Banner Health | Healthcare/Medical | Individual | Monetary (Itemized) | |
7346 | 7346 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 4/25/20 0:00 | Shawna Wessel | Ft Collins | CO | 80526 | Self | Other | Individual | Monetary (Itemized) | |
7349 | 7349 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 4/26/20 0:00 | Ronald Ross | Loveland | CO | 80538 | Retired | Retired | Individual | Monetary (Itemized) | |
7350 | 7350 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 4/27/20 0:00 | J Freestone | Johnstown | CO | 80534 | Haynes | Teacher/Education | Individual | Monetary (Itemized) | |
7363 | 7363 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/15/20 0:00 | Jenna Ikuta | Wheat Ridge | CO | 80033 | Individual | Monetary (Itemized) | Donor Box | ||
7367 | 7367 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/15/20 0:00 | Linsey Jones | Brighton | CO | 80602 | Individual | Monetary (Itemized) | |||
7369 | 7369 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/15/20 0:00 | Brian Anderson | Mead | CO | 80542 | Individual | Monetary (Itemized) | |||
7374 | 7374 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/15/20 0:00 | Kane Gallardo | CO | Individual | Monetary (Itemized) | |||||
7377 | 7377 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/15/20 0:00 | Michael Stapleton | CO | Individual | Monetary (Itemized) | |||||
7381 | 7381 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/15/20 0:00 | Zach Roth | CO | Individual | Monetary (Itemized) | |||||
7387 | 7387 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/15/20 0:00 | Bryan Kramer | CO | Individual | Monetary (Itemized) | |||||
7389 | 7389 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/15/20 0:00 | Sandi Knowles | CO | Individual | Monetary (Itemized) | |||||
7396 | 7396 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/15/20 0:00 | Mary Brumder | Boulder | CO | 80304 | Individual | Monetary (Itemized) | |||
7405 | 7405 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/15/20 0:00 | Bruce Breshears | Broomfield | CO | 80020 | Individual | Monetary (Itemized) | |||
7413 | 7413 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/20/20 0:00 | Jim Paschis | Boulder | CO | 80302 | Individual | Monetary (Itemized) | Ck #376 | ||
7425 | 7425 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/25/20 0:00 | Maggie Demers | CO | Individual | Monetary (Itemized) | |||||
7430 | 7430 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/29/20 0:00 | Dan Collins | Severence | CO | 80550 | Individual | Monetary (Itemized) | |||
7432 | 7432 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/29/20 0:00 | Curtis Degroote | Castle Rock | CO | 80109 | Individual | Monetary (Itemized) | |||
7433 | 7433 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/29/20 0:00 | Chad Shepherd | Greeley | CO | 80634 | Individual | Monetary (Itemized) | |||
7435 | 7435 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/29/20 0:00 | Cindy Staudt | Westminster | CO | 80021 | Individual | Monetary (Itemized) | |||
7436 | 7436 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/29/20 0:00 | Cameron Snell | CO | Individual | Monetary (Itemized) | |||||
7438 | 7438 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 5/30/20 0:00 | Gina Derosa | Evergreen | CO | 80439 | Self | Homemaker | Individual | Monetary (Itemized) | |
7465 | 7465 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 6/5/20 0:00 | Brian Glotzbach | CO | Individual | Monetary (Itemized) | |||||
7488 | 7488 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 6/13/20 0:00 | Katie Adams | CO | Individual | Monetary (Itemized) | |||||
7500 | 7500 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 6/24/20 0:00 | Hudson Marsh | CO | Individual | Monetary (Itemized) | |||||
7506 | 7506 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 7/3/20 0:00 | Donna Noxon | Ft Collins | CO | Individual | Monetary (Itemized) | ||||
7514 | 7514 | Senate District 23 | Parchment, Rupert | Republican | 10.0 | 10/16/19 0:00 | Monetary (Non-Itemized) | ||||||||
7578 | 7578 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 10.0 | 4/14/20 0:00 | Galina Siergiejczyk-Nicoll | Broomfield | CO | 80020 | Candidate | Monetary (Itemized) | |||
7580 | 7580 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 10.0 | 4/17/20 0:00 | Kirsten Erkfritz | Boulder | CO | 80304 | Individual | Monetary (Itemized) | |||
7587 | 7587 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 10.0 | 4/26/20 0:00 | Marjorie Birks | Broomfield | CO | 80023 | Individual | Monetary (Itemized) | |||
7591 | 7591 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 10.0 | 4/27/20 0:00 | Meherab Amaria | Broomfield | CO | 80020 | Seagate Technology | Science/Technology | Individual | Monetary (Itemized) | |
7601 | 7601 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 10.0 | 5/2/20 0:00 | Dawn Kairns | Boulder | CO | 80302 | Individual | Monetary (Itemized) | Act Blue | ||
7604 | 7604 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 10.0 | 5/9/20 0:00 | Samuel Thompson | Chattanooga | TN | 37419 | Individual | Monetary (Itemized) | Act Blue | ||
7621 | 7621 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 10.0 | 5/26/20 0:00 | Halie Binstock | MA | 2144 | Individual | Monetary (Itemized) | ||||
7622 | 7622 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 10.0 | 5/27/20 0:00 | Meherab Amaria | Broomfield | CO | 80020 | Seagate Technology | Science/Technology | Individual | Monetary (Itemized) | |
7644 | 7644 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 10.0 | 6/26/20 0:00 | Meherab Amaria | Broomfield | CO | 80020 | Seagate Technology | Science/Technology | Individual | Monetary (Itemized) | |
7645 | 7645 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 10.0 | 6/27/20 0:00 | Meherab Amaria | Broomfield | CO | 80020 | Seagate Technology | Science/Technology | Individual | Monetary (Itemized) | |
7647 | 7647 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 10.0 | 7/4/20 0:00 | Gordon Hadlow | Fort Collins | CO | 80528 | Individual | Monetary (Itemized) | |||
7685 | 7685 | Senate District 23 | Boccella, Sally | Democratic | 10.0 | 1/20/20 0:00 | Bheema Bachus | Longmont | CO | 80501 | Individual | Monetary (Itemized) | |||
7704 | 7704 | Senate District 23 | Boccella, Sally | Democratic | 10.0 | 1/28/20 0:00 | Edward Hoskins | Broomfield | CO | 80020 | Individual | Monetary (Itemized) | |||
7771 | 7771 | Senate District 23 | Boccella, Sally | Democratic | 10.0 | 5/24/20 0:00 | Douglas Harris | Broomfield | CO | 80023 | Individual | Monetary (Itemized) | |||
7788 | 7788 | Senate District 23 | Boccella, Sally | Democratic | 10.0 | 6/18/20 0:00 | Judy Shadduck-Mcnally | Loveland | CO | 80537 | 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 );