senate_cand_exp
58 rows where district = "Senate District 19" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: candidate, affiliation, recipient, city, zip, expenditure_type, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2073 | 2073 | Senate District 19 | Gerber, Lynn | Republican | 30.0 | 4/2/20 0:00 | Mountain View | CA | 94043 | Rent & Utilities | ||
2082 | 2082 | Senate District 19 | Gerber, Lynn | Republican | 96.47 | 5/11/20 0:00 | Uprinting | Van Nuys | CA | 91406 | Fundraising Expenses | |
2085 | 2085 | Senate District 19 | Gerber, Lynn | Republican | 24.98 | 5/26/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2086 | 2086 | Senate District 19 | Gerber, Lynn | Republican | 25.0 | 5/27/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2087 | 2087 | Senate District 19 | Gerber, Lynn | Republican | 25.0 | 5/28/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2090 | 2090 | Senate District 19 | Gerber, Lynn | Republican | 35.0 | 6/2/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2094 | 2094 | Senate District 19 | Gerber, Lynn | Republican | 350.0 | 6/15/20 0:00 | Mountain View | CA | 94043 | Advertising | Search | |
2095 | 2095 | Senate District 19 | Gerber, Lynn | Republican | 15.0 | 6/26/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2099 | 2099 | Senate District 19 | Gerber, Lynn | Republican | 127.54 | 7/2/20 0:00 | Uprinting | Van Nuys | CA | 91406 | Office Equipment & Supplies | |
2106 | 2106 | Senate District 19 | Gerber, Lynn | Republican | 50.0 | 7/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2107 | 2107 | Senate District 19 | Gerber, Lynn | Republican | 376.37 | 7/13/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
2112 | 2112 | Senate District 19 | Gerber, Lynn | Republican | 47.1 | 7/21/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2113 | 2113 | Senate District 19 | Gerber, Lynn | Republican | 50.0 | 7/27/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2120 | 2120 | Senate District 19 | Gerber, Lynn | Republican | 75.0 | 8/3/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2121 | 2121 | Senate District 19 | Gerber, Lynn | Republican | 5.34 | 8/3/20 0:00 | Mountain View | CA | 94043 | Rent & Utilities | ||
2124 | 2124 | Senate District 19 | Gerber, Lynn | Republican | 50.0 | 8/5/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2125 | 2125 | Senate District 19 | Gerber, Lynn | Republican | 50.0 | 8/5/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2126 | 2126 | Senate District 19 | Gerber, Lynn | Republican | 25.0 | 8/5/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2130 | 2130 | Senate District 19 | Gerber, Lynn | Republican | 175.0 | 8/10/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2131 | 2131 | Senate District 19 | Gerber, Lynn | Republican | 153.66 | 8/10/20 0:00 | Uprinting | Van Nuys | CA | 91406 | Office Equipment & Supplies | |
2136 | 2136 | Senate District 19 | Gerber, Lynn | Republican | 174.77 | 8/13/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
2143 | 2143 | Senate District 19 | Gerber, Lynn | Republican | 195.98 | 8/26/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2152 | 2152 | Senate District 19 | Gerber, Lynn | Republican | 16.25 | 9/3/20 0:00 | Mountain View | CA | 94043 | Rent & Utilities | ||
2158 | 2158 | Senate District 19 | Gerber, Lynn | Republican | 229.02 | 9/12/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2160 | 2160 | Senate District 19 | Gerber, Lynn | Republican | 408.25 | 9/14/20 0:00 | Mountain View | CA | 94043 | Advertising | ||
2163 | 2163 | Senate District 19 | Gerber, Lynn | Republican | 1400.0 | 9/25/20 0:00 | Mountain View | CA | 94043 | Advertising | Lynn Gerber Is Running For Sd19 | |
2166 | 2166 | Senate District 19 | Gerber, Lynn | Republican | 384.15 | 9/28/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
2167 | 2167 | Senate District 19 | Gerber, Lynn | Republican | 105.36 | 9/28/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
2168 | 2168 | Senate District 19 | Gerber, Lynn | Republican | 250.0 | 9/29/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising | |
2173 | 2173 | Senate District 19 | Gerber, Lynn | Republican | 18.0 | 10/1/20 0:00 | Mountain View | CA | 94043 | Rent & Utilities | ||
2174 | 2174 | Senate District 19 | Gerber, Lynn | Republican | 400.0 | 10/2/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising | |
2177 | 2177 | Senate District 19 | Gerber, Lynn | Republican | 553.0 | 10/8/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
2179 | 2179 | Senate District 19 | Gerber, Lynn | Republican | 3123.0 | 10/9/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Advertising | |
2183 | 2183 | Senate District 19 | Gerber, Lynn | Republican | 553.0 | 10/15/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
2189 | 2189 | Senate District 19 | Gerber, Lynn | Republican | 350.64 | 10/20/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
2192 | 2192 | Senate District 19 | Gerber, Lynn | Republican | 54.1 | 10/26/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Ads | |
2193 | 2193 | Senate District 19 | Gerber, Lynn | Republican | 372.59 | 10/30/20 0:00 | Adobe Stock | San Jose | CA | 95110 | Consultant & Professional Services | |
2198 | 2198 | Senate District 19 | Gerber, Lynn | Republican | 553.0 | 11/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
2200 | 2200 | Senate District 19 | Gerber, Lynn | Republican | 18.0 | 11/3/20 0:00 | Mountain View | CA | 94043 | Rent & Utilities | ||
2203 | 2203 | Senate District 19 | Gerber, Lynn | Republican | 248.09 | 11/12/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
2204 | 2204 | Senate District 19 | Gerber, Lynn | Republican | 468.54 | 11/12/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Ads | |
2206 | 2206 | Senate District 19 | Gerber, Lynn | Republican | 18.62 | 11/30/20 0:00 | Mountain View | CA | 94043 | Rent & Utilities | ||
2254 | 2254 | Senate District 19 | Zenzinger, Rachel | Democratic | 13.0 | 4/1/19 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ad | |
2255 | 2255 | Senate District 19 | Zenzinger, Rachel | Democratic | 13.0 | 4/1/19 0:00 | Menlo | CA | 94025 | Advertising | Facebook Ad | |
2315 | 2315 | Senate District 19 | Zenzinger, Rachel | Democratic | 119.88 | 9/10/19 0:00 | Dropbox | San Francisco | CA | 94107 | Miscellaneous | For Dropbox Subscription |
2358 | 2358 | Senate District 19 | Zenzinger, Rachel | Democratic | 162.2 | 12/15/18 0:00 | Blue Sneaker Ball | San Francisco | CA | 94103 | Other | Blue Sneaker Ball |
2415 | 2415 | Senate District 19 | Zenzinger, Rachel | Democratic | 16.17 | 6/6/20 0:00 | Zoom Us | San Jose | CA | 95113 | Office Equipment & Supplies | Remote Meeting Software |
2423 | 2423 | Senate District 19 | Zenzinger, Rachel | Democratic | 14.39 | 6/28/20 0:00 | Zoom Us | San Jose | CA | 95113 | Fundraising Expenses | Virtual Meeting Software |
2432 | 2432 | Senate District 19 | Zenzinger, Rachel | Democratic | 70.15 | 7/6/20 0:00 | Zoom Us | San Jose | CA | 95113 | Fundraising Expenses | Virtual Meeting Software |
2450 | 2450 | Senate District 19 | Zenzinger, Rachel | Democratic | 70.15 | 8/7/20 0:00 | Zoom Us | San Jose | CA | 95113 | Rent & Utilities | Software For Online Meeting |
2468 | 2468 | Senate District 19 | Zenzinger, Rachel | Democratic | 70.15 | 9/7/20 0:00 | Zoom Us | San Jose | CA | 95113 | Rent & Utilities | Remote Meeting Software |
2472 | 2472 | Senate District 19 | Zenzinger, Rachel | Democratic | 119.88 | 9/9/20 0:00 | Dropbox | San Francisco | CA | 94107 | Office Equipment & Supplies | File Sharing Software |
2505 | 2505 | Senate District 19 | Zenzinger, Rachel | Democratic | 70.15 | 10/6/20 0:00 | Zoom Us | San Jose | CA | 95113 | Rent & Utilities | Software For Meetings |
2550 | 2550 | Senate District 19 | Zenzinger, Rachel | Democratic | 70.15 | 11/7/20 0:00 | Zoom Us | San Jose | CA | 95113 | Other | Meeting Software |
2645 | 2645 | Senate District 19 | Zenzinger, Rachel | Democratic | 8.0 | 1/1/18 0:00 | Menlo | CA | 94025 | Advertising | Facebook Advertising | |
2679 | 2679 | Senate District 19 | Zenzinger, Rachel | Democratic | 60.0 | 4/19/18 0:00 | Eb 60Th Anniversary Dinner | San Francisco | CA | 94103 | Food, Beverages and Meals | Ticket For Jefferson Center Mental Health Gala Dinner. |
2729 | 2729 | Senate District 19 | Zenzinger, Rachel | Democratic | 50.0 | 10/6/17 0:00 | Cdot/Transit Alliance | San Francisco | CA | 94103 | Food, Beverages and Meals | Fee For Transportation Summit |
2740 | 2740 | Senate District 19 | Zenzinger, Rachel | Democratic | 8.0 | 12/4/17 0:00 | Menlo | CA | 94025 | Advertising | Facebook Ad |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_cand_exp" ( "district" TEXT, "candidate" TEXT, "affiliation" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );