senate_cand_cont
10,563 rows where affiliation = "Democratic" sorted by zip descending
This data as json, CSV (advanced)
Link | rowid | district | candidate | affiliation | contribution_amount | contribution_date | contributor | city | state | zip ▲ | employer | occupation | contributor_type | contribution_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2301 | 2301 | Senate District 10 | Mccallian, Randal | Democratic | 15.0 | 1/31/20 0:00 | Laura Cottril | Walnut Creek | CA | 94597 | Individual | Monetary (Itemized) | |||
2369 | 2369 | Senate District 10 | Mccallian, Randal | Democratic | 10.0 | 3/11/20 0:00 | Laura Cottril | Walnut Creek | CA | 94597 | Individual | Monetary (Itemized) | |||
2383 | 2383 | Senate District 10 | Mccallian, Randal | Democratic | 10.0 | 3/31/20 0:00 | Laura Cottril | Walnut Creek | CA | 94597 | Individual | Monetary (Itemized) | |||
2425 | 2425 | Senate District 10 | Mccallian, Randal | Democratic | 25.0 | 4/23/20 0:00 | Laura Cottril | Walnut Creek | CA | 94597 | Individual | Monetary (Itemized) | |||
2464 | 2464 | Senate District 10 | Mccallian, Randal | Democratic | 25.0 | 5/13/20 0:00 | Laura Cottril | Walnut Creek | CA | 94597 | Individual | Monetary (Itemized) | |||
2526 | 2526 | Senate District 10 | Mccallian, Randal | Democratic | 25.0 | 6/24/20 0:00 | Laura Cottril | Walnut Creek | CA | 94597 | Individual | Monetary (Itemized) | |||
2592 | 2592 | Senate District 10 | Mccallian, Randal | Democratic | 25.0 | 7/28/20 0:00 | Laura Cottril | Walnut Creek | CA | 94597 | Individual | Monetary (Itemized) | |||
2605 | 2605 | Senate District 10 | Mccallian, Randal | Democratic | 25.0 | 8/3/20 0:00 | Laura Cottril | Walnut Creek | CA | 94597 | Individual | Monetary (Itemized) | |||
2696 | 2696 | Senate District 10 | Mccallian, Randal | Democratic | 25.0 | 9/19/20 0:00 | Laura Cottril | Walnut Creek | CA | 94597 | Individual | Monetary (Itemized) | |||
2755 | 2755 | Senate District 10 | Mccallian, Randal | Democratic | 25.0 | 10/12/20 0:00 | Laura Cottril | Walnut Creek | CA | 94597 | Individual | Monetary (Itemized) | |||
5513 | 5513 | Senate District 19 | Zenzinger, Rachel | Democratic | 20.41 | 8/5/20 0:00 | Jennifer Kurz | Walnut Creek | CA | 94596 | Jennifer Kurz Consulting | Consultant | Individual | Monetary (Itemized) | |
300 | 300 | Senate District 04 | Flaumenhaft, Elissa | Democratic | 20.0 | 5/13/20 0:00 | Amy Pitt | Walnut Creek | CA | 94595 | Self-Employed | Healthcare/Medical | Individual | Monetary (Itemized) | |
12529 | 12529 | Senate District 28 | Buckner, Janet | Democratic | 50.0 | 10/15/20 0:00 | S. Jamila Buckner | San Ramon | CA | 94583 | Saint Mary'S College | Teacher/Education | Individual | Monetary (Itemized) | |
12665 | 12665 | Senate District 28 | Buckner, Janet | Democratic | 50.0 | 11/15/20 0:00 | S. Jamila Buckner | San Ramon | CA | 94583 | Saint Mary'S College | Teacher/Education | Individual | Monetary (Itemized) | |
14069 | 14069 | Senate District 31 | Orms, Maria | Democratic | 50.0 | 7/1/20 0:00 | Oluwatoyin Bakare | San Ramon | CA | 94582 | Verizon | Other | Individual | Monetary (Itemized) | |
3465 | 3465 | Senate District 14 | Ginal, Joann | Democratic | 200.0 | 9/3/20 0:00 | Doctors Company Colorado Pac (Colorado Docpac) | Napa | CA | 94558 | Political Committee | Monetary (Itemized) | |||
5795 | 5795 | Senate District 19 | Zenzinger, Rachel | Democratic | 400.0 | 9/10/20 0:00 | Doctors Company Colorado Pac (Colorado Docpac) | Napa | CA | 94558 | Political Committee | Monetary (Itemized) | |||
6728 | 6728 | Senate District 21 | Moreno, Dominick | Democratic | 200.0 | 9/8/20 0:00 | Doctors Company Colorado Pac (Colorado Docpac) | Napa | CA | 94558 | Political Committee | Monetary (Itemized) | |||
6800 | 6800 | Senate District 21 | Moreno, Dominick | Democratic | 200.0 | 11/25/19 0:00 | Doctors Company Colorado Pac (Colorado Docpac) | Napa | CA | 94558 | Political Committee | Monetary (Itemized) | |||
8135 | 8135 | Senate District 23 | Boccella, Sally | Democratic | 200.0 | 10/17/20 0:00 | Doctors Company Colorado Pac (Colorado Docpac) | Napa | CA | 94558 | Political Committee | Monetary (Itemized) | |||
12990 | 12990 | Senate District 29 | Fields, Rhonda | Democratic | 400.0 | 10/19/20 0:00 | Doctors Company Colorado Pac (Colorado Docpac) | Napa | CA | 94558 | Political Committee | Monetary (Itemized) | |||
13432 | 13432 | Senate District 31 | Hansen, Chris | Democratic | 200.0 | 9/9/20 0:00 | Doctors Company Colorado Pac (Colorado Docpac) | Napa | CA | 94558 | Political Committee | Monetary (Itemized) | |||
1258 | 1258 | Senate District 08 | Hanlon, Karl | Democratic | 25.0 | 9/4/20 0:00 | Nikhil Desai | Fremont | CA | 94539 | Google Inc | Construction/Engineering | Individual | Monetary (Itemized) | |
5958 | 5958 | Senate District 19 | Zenzinger, Rachel | Democratic | 6.25 | 9/21/20 0:00 | Alborz Wozniak | Pleasant Hill | CO | 94523 | Gap, Inc. | Retail Sales | Individual | Monetary (Itemized) | |
8723 | 8723 | Senate District 25 | Dickerson, Paula | Democratic | 6.25 | 9/21/20 0:00 | Alborz Wozniak | Pleasant Hll | CA | 94523 | Gap | Retail Sales | Individual | Monetary (Itemized) | |
5492 | 5492 | Senate District 19 | Zenzinger, Rachel | Democratic | 5.0 | 8/1/20 0:00 | Ross Jensen | Palo Alto | CA | 94301 | Emerson Collective | Media/Public Relations | Individual | Monetary (Itemized) | |
5836 | 5836 | Senate District 19 | Zenzinger, Rachel | Democratic | 3.0 | 9/13/20 0:00 | Ross Jensen | Palo Alto | CA | 94301 | Emerson Collective | Media/Public Relations | Individual | Monetary (Itemized) | |
6078 | 6078 | Senate District 19 | Zenzinger, Rachel | Democratic | 3.0 | 10/3/20 0:00 | Ross Jensen | Palo Alto | CA | 94301 | Emerson Collective | Media/Public Relations | Individual | Monetary (Itemized) | |
6195 | 6195 | Senate District 19 | Zenzinger, Rachel | Democratic | 400.0 | 10/14/20 0:00 | Lauren Jobs | Palo Alto | CA | 94301 | Emerson Collective | Media/Public Relations | Individual | Monetary (Itemized) | |
9619 | 9619 | Senate District 26 | Bridges, Jeff | Democratic | 5.0 | 8/1/20 0:00 | Ross Jensen | Palo Alto | CA | 94301 | Emerson Collective | Teacher/Education | Individual | Monetary (Itemized) | |
9953 | 9953 | Senate District 26 | Bridges, Jeff | Democratic | 400.0 | 10/14/20 0:00 | Laurene Powell Jobs | Palo Alto | CA | 94301 | Emerson Collective | Teacher/Education | Individual | Monetary (Itemized) | |
4988 | 4988 | Senate District 19 | Zenzinger, Rachel | Democratic | 5.0 | 4/24/20 0:00 | James Roediger | San Francisco | CA | 94124 | Retired | Retired | Individual | Monetary (Itemized) | |
2337 | 2337 | Senate District 10 | Mccallian, Randal | Democratic | 25.0 | 2/26/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2358 | 2358 | Senate District 10 | Mccallian, Randal | Democratic | 15.0 | 3/5/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2359 | 2359 | Senate District 10 | Mccallian, Randal | Democratic | 25.0 | 3/5/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2393 | 2393 | Senate District 10 | Mccallian, Randal | Democratic | 15.0 | 4/5/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2406 | 2406 | Senate District 10 | Mccallian, Randal | Democratic | 25.0 | 4/13/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2420 | 2420 | Senate District 10 | Mccallian, Randal | Democratic | 35.0 | 4/23/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2441 | 2441 | Senate District 10 | Mccallian, Randal | Democratic | 15.0 | 5/5/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2495 | 2495 | Senate District 10 | Mccallian, Randal | Democratic | 15.0 | 6/5/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2524 | 2524 | Senate District 10 | Mccallian, Randal | Democratic | 25.0 | 6/24/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2548 | 2548 | Senate District 10 | Mccallian, Randal | Democratic | 15.0 | 7/5/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2609 | 2609 | Senate District 10 | Mccallian, Randal | Democratic | 15.0 | 8/5/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2619 | 2619 | Senate District 10 | Mccallian, Randal | Democratic | 10.0 | 8/6/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2672 | 2672 | Senate District 10 | Mccallian, Randal | Democratic | 15.0 | 9/5/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2742 | 2742 | Senate District 10 | Mccallian, Randal | Democratic | 15.0 | 10/5/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
2815 | 2815 | Senate District 10 | Mccallian, Randal | Democratic | 15.0 | 11/5/20 0:00 | Catherine Daly | San Francisco | CA | 94122 | Individual | Monetary (Itemized) | |||
4997 | 4997 | Senate District 19 | Zenzinger, Rachel | Democratic | 38.46 | 4/25/20 0:00 | Martin Vanderlaan | San Francisco | CA | 94122 | Retired | Retired | Individual | Monetary (Itemized) | |
1502 | 1502 | Senate District 08 | Menconi, Arn | Democratic | 200.0 | 3/15/20 0:00 | Alex Potente | San Francisco | CA | 94118 | Clyde & Co | Attorney/Legal | Individual | Monetary (Itemized) | |
6011 | 6011 | Senate District 19 | Zenzinger, Rachel | Democratic | 6.82 | 9/25/20 0:00 | Corey Friedman | San Francisco | CA | 94118 | State Of California | Government/Civil | Individual | Monetary (Itemized) | |
9277 | 9277 | Senate District 26 | Bridges, Jeff | Democratic | 200.0 | 1/31/20 0:00 | Carter Mundell | San Francisco | CA | 94116 | Self | Financial/Investment | Individual | Monetary (Itemized) | |
9282 | 9282 | Senate District 26 | Bridges, Jeff | Democratic | 200.0 | 1/31/20 0:00 | Upekha Weerasinghe | San Francisco | CA | 94116 | Self | General Business | Individual | Monetary (Itemized) | |
9625 | 9625 | Senate District 26 | Bridges, Jeff | Democratic | 200.0 | 8/1/20 0:00 | Carter Mundell | San Francisco | CA | 94116 | Self Employed | Financial/Investment | Individual | Monetary (Itemized) | |
9631 | 9631 | Senate District 26 | Bridges, Jeff | Democratic | 200.0 | 8/1/20 0:00 | Upekha Weerasinghe | San Francisco | CA | 94116 | Self | General Business | Individual | Monetary (Itemized) | |
8679 | 8679 | Senate District 25 | Dickerson, Paula | Democratic | 250.0 | 9/2/20 0:00 | Meg O'Shaughnessy | San Francisco | CA | 94115 | Unknown | Not Currently Employed | Individual | Monetary (Itemized) | |
11594 | 11594 | Senate District 27 | Kolker, Chris | Democratic | 270.0 | 9/2/20 0:00 | Meg O'Shaughnessy | San Fransico | CA | 94115 | Not Currently Employed | Individual | Monetary (Itemized) | ||
13689 | 13689 | Senate District 31 | Hansen, Chris | Democratic | 400.0 | 12/17/19 0:00 | Alex Rau | San Francisco | CA | 94115 | Not Currently Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
14200 | 14200 | Senate District 33 | Coleman, James | Democratic | 50.0 | 5/1/20 0:00 | Austin Spires | San Francisco | CA | 94115 | Finix Payments | Other | Individual | Monetary (Itemized) | |
5198 | 5198 | Senate District 19 | Zenzinger, Rachel | Democratic | 2.0 | 6/18/20 0:00 | Brian Midili | San Francisco | CA | 94110 | Nielsen | Media/Public Relations | Individual | Monetary (Itemized) | |
9455 | 9455 | Senate District 26 | Bridges, Jeff | Democratic | 2.0 | 6/18/20 0:00 | Brian Midili | San Francisco | CA | 94110 | Nielsen | Media/Public Relations | Individual | Monetary (Itemized) | |
5806 | 5806 | Senate District 19 | Zenzinger, Rachel | Democratic | 400.0 | 9/10/20 0:00 | Tom Steyer | San Francisco | CA | 94104 | Fahr Llc | Financial/Investment | Individual | Monetary (Itemized) | |
5807 | 5807 | Senate District 19 | Zenzinger, Rachel | Democratic | 400.0 | 9/10/20 0:00 | Kathryn Taylor | San Francisco | CA | 94104 | Beneficial State Bank | Financial/Investment | Individual | Monetary (Itemized) | |
7589 | 7589 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 50.0 | 4/26/20 0:00 | Francois-Marie Lefevere | Sunnyvale | CA | 94086 | Individual | Monetary (Itemized) | |||
5449 | 5449 | Senate District 19 | Zenzinger, Rachel | Democratic | 160.71 | 7/26/20 0:00 | Daniel Yost | Redwood City | CA | 94062 | Orrick | Attorney/Legal | Individual | Monetary (Itemized) | |
7596 | 7596 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 50.0 | 4/29/20 0:00 | Hilary Borison | Redwood City | CA | 94062 | Not Employed | Individual | Monetary (Itemized) | ||
9527 | 9527 | Senate District 26 | Bridges, Jeff | Democratic | 160.71 | 7/26/20 0:00 | Daniel Yost | Woodside | CA | 94062 | Orrick | Attorney/Legal | Individual | Monetary (Itemized) | |
13707 | 13707 | Senate District 31 | Hansen, Chris | Democratic | 400.0 | 12/23/19 0:00 | Jessica Reinhardt | Pacifica | CA | 94044 | Sunrun | Government/Civil | Individual | Monetary (Itemized) | |
5962 | 5962 | Senate District 19 | Zenzinger, Rachel | Democratic | 100.0 | 9/21/20 0:00 | Sarah Sibley | Mountain View | CA | 94043 | Media/Public Relations | Individual | Monetary (Itemized) | ||
5260 | 5260 | Senate District 19 | Zenzinger, Rachel | Democratic | 30.0 | 6/26/20 0:00 | Gloria Purcell | Belmont | CA | 94002 | Retired | Retired | Individual | Monetary (Itemized) | |
9477 | 9477 | Senate District 26 | Bridges, Jeff | Democratic | 30.0 | 6/26/20 0:00 | Gloria And Jim Purcell | Belmont | CA | 94002 | None | Retired | Individual | Monetary (Itemized) | |
9479 | 9479 | Senate District 26 | Bridges, Jeff | Democratic | -30.0 | 6/26/20 0:00 | Gloria And Jim Purcell | Belmont | CA | 94002 | None | Retired | Individual | Monetary (Itemized) | Offset Due To Update Of Filed Item |
9480 | 9480 | Senate District 26 | Bridges, Jeff | Democratic | 30.0 | 6/26/20 0:00 | Gloria And Jim Purcell | Belmont | CA | 94002 | None | Retired | Individual | Monetary (Itemized) | |
2163 | 2163 | Senate District 10 | Mccallian, Randal | Democratic | 100.0 | 6/30/19 0:00 | Kimberly Ventimiglia | Del Ray Oaks | CA | 93940 | Community Hospital Of Monterey | Healthcare/Medical | Individual | Monetary (Itemized) | |
2589 | 2589 | Senate District 10 | Mccallian, Randal | Democratic | 50.0 | 7/27/20 0:00 | Kimberly Ventimiglia | Del Ray Oaks | CA | 93940 | Community Hospital Of Monterey | Healthcare/Medical | Individual | Monetary (Itemized) | |
2775 | 2775 | Senate District 10 | Mccallian, Randal | Democratic | 100.0 | 10/17/20 0:00 | Kimberly Ventimiglia | Del Ray Oaks | CA | 93940 | Community Hospital Of Monterey | Healthcare/Medical | Individual | Monetary (Itemized) | |
1535 | 1535 | Senate District 08 | Menconi, Arn | Democratic | 25.0 | 4/16/20 0:00 | Susan Coyle | Cambria | CA | 93428 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
1570 | 1570 | Senate District 08 | Menconi, Arn | Democratic | 50.0 | 5/4/20 0:00 | Susan Coyle | Cambria | CA | 93428 | Not Employed | Individual | Monetary (Itemized) | ||
1598 | 1598 | Senate District 08 | Menconi, Arn | Democratic | 25.0 | 5/13/20 0:00 | Susan Coyle | Cambria | CA | 93428 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
1658 | 1658 | Senate District 08 | Menconi, Arn | Democratic | 25.0 | 6/8/20 0:00 | Susan Coyle | Cambria | CA | 93428 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
1678 | 1678 | Senate District 08 | Menconi, Arn | Democratic | 25.0 | 6/18/20 0:00 | Susan Coyle | Cambria | CA | 93428 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
5319 | 5319 | Senate District 19 | Zenzinger, Rachel | Democratic | 25.0 | 7/5/20 0:00 | Katie Davis | Goleta | CA | 93117 | Retired | Retired | Individual | Monetary (Itemized) | |
9486 | 9486 | Senate District 26 | Bridges, Jeff | Democratic | 25.0 | 7/5/20 0:00 | Katie Davis | Goleta | CA | 93117 | Retired | Retired | Individual | Monetary (Itemized) | |
11457 | 11457 | Senate District 27 | Kolker, Chris | Democratic | 40.0 | 8/10/20 0:00 | Brent Goodlet | Santa Barbara | CA | 93111 | Individual | Monetary (Itemized) | |||
14117 | 14117 | Senate District 31 | Orms, Maria | Democratic | 200.0 | 12/30/19 0:00 | David De Board | Yorba Linda | CA | 92886 | Verizon | Individual | Monetary (Itemized) | ||
7607 | 7607 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 25.0 | 5/14/20 0:00 | Allison Miller | Tustin | CA | 92780 | Individual | Monetary (Itemized) | Act Blue | ||
7609 | 7609 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 25.0 | 5/14/20 0:00 | Allison Miller | Tustin | CA | 92780 | Individual | Monetary (Itemized) | Campaign Contribution | ||
4966 | 4966 | Senate District 19 | Zenzinger, Rachel | Democratic | 200.0 | 4/20/20 0:00 | Stacey Herzing | San Juan Capistrano | CA | 92675 | Self | General Business | Individual | Monetary (Itemized) | |
5262 | 5262 | Senate District 19 | Zenzinger, Rachel | Democratic | 27.0 | 6/26/20 0:00 | G Itano | Newport Beach | CA | 92663 | Retired | Retired | Individual | Monetary (Itemized) | |
9476 | 9476 | Senate District 26 | Bridges, Jeff | Democratic | 27.0 | 6/26/20 0:00 | G. Itano | Newport Beach | CA | 92663 | Retired | Retired | Individual | Monetary (Itemized) | |
2837 | 2837 | Senate District 10 | Mccallian, Randal | Democratic | 25.0 | 11/19/19 0:00 | Jeanmarie Horwath | Irvine | CA | 92620 | Individual | Monetary (Itemized) | |||
5341 | 5341 | Senate District 19 | Zenzinger, Rachel | Democratic | 400.0 | 7/8/20 0:00 | Michael Mavrovouniotis | Irvine | CA | 92614 | Retired | Retired | Individual | Monetary (Itemized) | |
9487 | 9487 | Senate District 26 | Bridges, Jeff | Democratic | 400.0 | 7/8/20 0:00 | Michael Mavrovouniotis | Irvine | CA | 92614 | Retired | Retired | Individual | Monetary (Itemized) | |
2143 | 2143 | Senate District 10 | Mccallian, Randal | Democratic | 200.0 | 5/3/19 0:00 | Russell Mccallian | San Diego | CA | 92130 | Center For Creative Leadership | Teacher/Education | Individual | Monetary (Itemized) | |
2778 | 2778 | Senate District 10 | Mccallian, Randal | Democratic | 100.0 | 10/18/20 0:00 | Russell Mccallian | San Diego | CA | 92130 | Center For Creative Leadership | Teacher/Education | Individual | Monetary (Itemized) | |
12493 | 12493 | Senate District 28 | Buckner, Janet | Democratic | 50.0 | 10/9/20 0:00 | Sonja Badu | San Diego | CA | 92130 | San Diego Unified | Teacher/Education | Individual | Monetary (Itemized) | |
9559 | 9559 | Senate District 26 | Bridges, Jeff | Democratic | 400.0 | 7/27/20 0:00 | Karen Klein | San Diego | CA | 92121 | Ucsd | Healthcare/Medical | Individual | Monetary (Itemized) | |
1257 | 1257 | Senate District 08 | Hanlon, Karl | Democratic | 200.0 | 9/3/20 0:00 | Lawrence Hess | San Diego | CA | 92120 | Not Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
5744 | 5744 | Senate District 19 | Zenzinger, Rachel | Democratic | 200.0 | 9/3/20 0:00 | Lawrence Hess | San Diego | CA | 92120 | Not Currently Employed | Not Currently Employed | Individual | Monetary (Itemized) | |
8683 | 8683 | Senate District 25 | Dickerson, Paula | Democratic | 200.0 | 9/3/20 0:00 | Lawrence Hess | San Diego | CA | 92120 | None | Retired | Individual | Monetary (Itemized) | |
11611 | 11611 | Senate District 27 | Kolker, Chris | Democratic | 200.0 | 9/3/20 0:00 | Lawerence Hess | San Diego | CA | 92120 | 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 );