senate_cand_exp
873 rows where expenditure_type = "Advertising" sorted by state
This data as json, CSV (advanced)
Link | rowid | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state ▼ | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1954 | 1954 | Senate District 18 | Fenberg, Stephen | Democratic | 25.0 | 10/26/17 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
1982 | 1982 | Senate District 18 | Fenberg, Stephen | Democratic | 25.0 | 12/21/17 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | |
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 | |
2198 | 2198 | Senate District 19 | Gerber, Lynn | Republican | 553.0 | 11/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
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 | |
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 | |
2645 | 2645 | Senate District 19 | Zenzinger, Rachel | Democratic | 8.0 | 1/1/18 0:00 | Menlo | CA | 94025 | Advertising | Facebook Advertising | |
2740 | 2740 | Senate District 19 | Zenzinger, Rachel | Democratic | 8.0 | 12/4/17 0:00 | Menlo | CA | 94025 | Advertising | Facebook Ad | |
3666 | 3666 | Senate District 23 | Parchment, Rupert | Republican | 23.91 | 3/2/20 0:00 | Facebook Internet | CA | Advertising | Online Ads | ||
3678 | 3678 | Senate District 23 | Parchment, Rupert | Republican | 250.0 | 3/24/20 0:00 | Facebook Internet | CA | Advertising | Online Ads | ||
3685 | 3685 | Senate District 23 | Parchment, Rupert | Republican | 6.07 | 3/31/20 0:00 | Facebook Internet | CA | Advertising | Online Ads | ||
3695 | 3695 | Senate District 23 | Parchment, Rupert | Republican | 75.0 | 4/30/20 0:00 | Facebook Internet | CA | Advertising | |||
3702 | 3702 | Senate District 23 | Parchment, Rupert | Republican | 250.0 | 5/22/20 0:00 | Facebook Internet | CA | Advertising | Online Ads | ||
3703 | 3703 | Senate District 23 | Parchment, Rupert | Republican | 60.76 | 5/23/20 0:00 | Alrecho | Carlsbad | CA | 92008 | Advertising | Flag Poles |
3706 | 3706 | Senate District 23 | Parchment, Rupert | Republican | 250.0 | 5/29/20 0:00 | Facebook Internet | CA | Advertising | Online Marketing | ||
3707 | 3707 | Senate District 23 | Parchment, Rupert | Republican | 25.0 | 5/31/20 0:00 | Facebook Internet | CA | Advertising | Online Marketing | ||
3713 | 3713 | Senate District 23 | Parchment, Rupert | Republican | 250.0 | 6/9/20 0:00 | Facebook Internet | CA | Advertising | Online Marketing | ||
3717 | 3717 | Senate District 23 | Parchment, Rupert | Republican | 5.0 | 6/22/20 0:00 | Clicksend.Com | Sanfrancisco | CA | 94133 | Advertising | Text Messaging |
3718 | 3718 | Senate District 23 | Parchment, Rupert | Republican | 500.0 | 6/23/20 0:00 | Clicksend.Com | Sanfrancisco | CA | 94133 | Advertising | Text Messaging |
3719 | 3719 | Senate District 23 | Parchment, Rupert | Republican | 1.0 | 6/25/20 0:00 | Clicksend.Com | Sanfrancisco | CA | 94133 | Advertising | Text Messages |
3720 | 3720 | Senate District 23 | Parchment, Rupert | Republican | 100.0 | 6/25/20 0:00 | Clicksend.Com | Sanfrancisco | CA | 94133 | Advertising | Text Messages |
3721 | 3721 | Senate District 23 | Parchment, Rupert | Republican | 10.56 | 6/25/20 0:00 | Freedomvoice | Carlsbad | CA | 92008 | Advertising | Campaign Phone |
3722 | 3722 | Senate District 23 | Parchment, Rupert | Republican | 400.0 | 6/26/20 0:00 | Facebook Internet | Menlo Park | CA | 94025 | Advertising | Online Marketing |
3723 | 3723 | Senate District 23 | Parchment, Rupert | Republican | 287.17 | 6/30/20 0:00 | Facebook Internet | Menlo Park | CA | 94025 | Advertising | Online Marketing |
3739 | 3739 | Senate District 23 | Parchment, Rupert | Republican | 250.0 | 12/24/19 0:00 | Facebook Internet | CA | Advertising | Facebook Page | ||
3741 | 3741 | Senate District 23 | Parchment, Rupert | Republican | 158.0 | 12/31/19 0:00 | Facebook Internet | CA | Advertising | Facebook Page | ||
3746 | 3746 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 48.0 | 2/18/20 0:00 | Automattic Inc. (Wordpress) | San Francisco | CA | 94110 | Advertising | Wordpress Domain And Site Hosting For Campaign Website |
3747 | 3747 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 48.0 | 2/18/20 0:00 | Auomattic, Inc. Wordpress | San Francisco | CA | 94110 | Advertising | Wordpress Campaign Website: Web Design Programming |
3786 | 3786 | Senate District 23 | Siergiejczyk-Nicoll, Galina | Democratic | 60.0 | 6/15/20 0:00 | Automattic Inc. (Wordpress) | San Francisco | CA | 94110 | Advertising | Wordpress Site, Email Fee |
3820 | 3820 | Senate District 23 | Boccella, Sally | Democratic | 114.21 | 6/10/20 0:00 | Menlo Park | CA | 94025 | Advertising | Charges For Report Period | |
3834 | 3834 | Senate District 23 | Boccella, Sally | Democratic | 415.29 | 7/27/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook For Report Period 06/25 - 07/27/2020 | |
3910 | 3910 | Senate District 25 | Priola, Kevin | Republican | 16.55 | 5/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4083 | 4083 | Senate District 25 | Priola, Kevin | Republican | 10.73 | 10/27/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4136 | 4136 | Senate District 25 | Priola, Kevin | Republican | 24.27 | 10/28/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4139 | 4139 | Senate District 25 | Priola, Kevin | Republican | 35.0 | 10/29/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4167 | 4167 | Senate District 25 | Priola, Kevin | Republican | 14.7 | 1/30/17 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4172 | 4172 | Senate District 25 | Priola, Kevin | Republican | 31.28 | 2/28/17 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4177 | 4177 | Senate District 25 | Priola, Kevin | Republican | 62.37 | 6/14/17 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4178 | 4178 | Senate District 25 | Priola, Kevin | Republican | 18.09 | 6/14/17 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4180 | 4180 | Senate District 25 | Priola, Kevin | Republican | 12.99 | 6/14/17 0:00 | Apple | Cupertino | CA | 95014 | Advertising | |
4185 | 4185 | Senate District 25 | Priola, Kevin | Republican | 11.27 | 7/15/17 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4192 | 4192 | Senate District 25 | Priola, Kevin | Republican | 25.0 | 8/15/17 0:00 | Apple | Cupertino | CA | 95014 | Advertising | |
4195 | 4195 | Senate District 25 | Priola, Kevin | Republican | 207.45 | 12/8/16 0:00 | Mountain View | CA | 94043 | Advertising | ||
4199 | 4199 | Senate District 25 | Priola, Kevin | Republican | 50.0 | 12/29/16 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4213 | 4213 | Senate District 25 | Priola, Kevin | Republican | 2.99 | 3/9/18 0:00 | Apple | Cupertino | CA | 95014 | Advertising | |
4220 | 4220 | Senate District 25 | Priola, Kevin | Republican | 6.87 | 4/15/18 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4235 | 4235 | Senate District 25 | Priola, Kevin | Republican | 50.0 | 8/24/18 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4254 | 4254 | Senate District 25 | Priola, Kevin | Republican | 20.0 | 12/15/17 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4832 | 4832 | Senate District 27 | Kolker, Chris | Democratic | 20.33 | 2/4/19 0:00 | Menlo Park | CA | 94025 | Advertising | Post Boost | |
4833 | 4833 | Senate District 27 | Kolker, Chris | Democratic | 4.67 | 2/11/19 0:00 | Menlo Park | CA | 94025 | Advertising | Post Boost | |
4846 | 4846 | Senate District 27 | Kolker, Chris | Democratic | 21.84 | 4/25/19 0:00 | Menlo Park | CA | 94025 | Advertising | Post Boost | |
4848 | 4848 | Senate District 27 | Kolker, Chris | Democratic | 33.71 | 4/29/19 0:00 | Menlo Park | CA | 94025 | Advertising | Post Boost | |
4849 | 4849 | Senate District 27 | Kolker, Chris | Democratic | 42.13 | 5/1/19 0:00 | Menlo Park | CA | 94025 | Advertising | Post Boost | |
4850 | 4850 | Senate District 27 | Kolker, Chris | Democratic | 31.33 | 5/3/19 0:00 | Menlo Park | CA | 94025 | Advertising | Post Boost | |
4851 | 4851 | Senate District 27 | Kolker, Chris | Democratic | 12.83 | 5/9/19 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
4857 | 4857 | Senate District 27 | Kolker, Chris | Democratic | 34.71 | 6/10/19 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
4858 | 4858 | Senate District 27 | Kolker, Chris | Democratic | 25.29 | 6/12/19 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
4862 | 4862 | Senate District 27 | Kolker, Chris | Democratic | 49.65 | 7/1/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4864 | 4864 | Senate District 27 | Kolker, Chris | Democratic | 10.35 | 7/8/19 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ad | |
4875 | 4875 | Senate District 27 | Kolker, Chris | Democratic | 38.48 | 9/6/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4878 | 4878 | Senate District 27 | Kolker, Chris | Democratic | 21.51 | 9/13/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5012 | 5012 | Senate District 27 | Kolker, Chris | Democratic | 60.0 | 10/5/20 0:00 | Callfire | Santa Monica | CA | 90401 | Advertising | Voter Outreach Software |
5430 | 5430 | Senate District 29 | Fields, Rhonda | Democratic | 24.0 | 5/1/17 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5474 | 5474 | Senate District 29 | Fields, Rhonda | Democratic | 18.0 | 1/2/18 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5770 | 5770 | Senate District 31 | Hansen, Chris | Democratic | 121.8 | 6/19/20 0:00 | Menlo Park | CA | 94025 | Advertising | Ads | |
5795 | 5795 | Senate District 31 | Hansen, Chris | Democratic | 379.3 | 7/23/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5858 | 5858 | Senate District 31 | Hansen, Chris | Democratic | 350.0 | 10/14/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Advertisements | |
5885 | 5885 | Senate District 31 | Hansen, Chris | Democratic | 1624.2 | 10/27/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertisements | |
5947 | 5947 | Senate District 31 | Hansen, Chris | Democratic | 52.65 | 11/23/20 0:00 | Menlo Park | CA | 94025 | Advertising | Final Payment For Early November Election Ads | |
6087 | 6087 | Senate District 31 | Orms, Maria | Democratic | 212.4 | 5/27/20 0:00 | Menlo Park | CA | 94025 | Advertising | Candidate Paid For Facebook Ads With A Pre-Paid Credit Card |
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 );