house_cand_exp
2,378 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|
3077 | 3077 | House District 13 | Amabile, Judith | Democratic | 33.47 | 6/10/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
3114 | 3114 | House District 13 | Amabile, Judith | Democratic | 20.0 | 10/15/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
3131 | 3131 | House District 13 | Amabile, Judith | Democratic | 12.84 | 11/12/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
3278 | 3278 | House District 14 | Sandridge, Shane | Republican | 72.3 | 10/25/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
3286 | 3286 | House District 14 | Sandridge, Shane | Republican | 27.7 | 11/25/20 0:00 | Menlo Park | CA | 94025 | Advertising | Second Payment On A Campaign Ad. | |
3759 | 3759 | House District 18 | Snyder, Marc | Democratic | 30.0 | 1/7/19 0:00 | Mountain View | CA | 94043 | Advertising | ||
3763 | 3763 | House District 18 | Snyder, Marc | Democratic | 30.0 | 2/7/19 0:00 | Mountain View | CA | 94043 | Advertising | ||
3769 | 3769 | House District 18 | Snyder, Marc | Democratic | 30.0 | 3/6/19 0:00 | Mountain View | CA | 94043 | Advertising | ||
3788 | 3788 | House District 18 | Snyder, Marc | Democratic | 36.0 | 7/8/19 0:00 | Mountain View | CA | 94043 | Advertising | Google Apps | |
3791 | 3791 | House District 18 | Snyder, Marc | Democratic | 36.0 | 8/6/19 0:00 | Mountain View | CA | 94043 | Advertising | Google Apps | |
3794 | 3794 | House District 18 | Snyder, Marc | Democratic | 36.0 | 9/9/19 0:00 | Mountain View | CA | 94043 | Advertising | Google Apps | |
3800 | 3800 | House District 18 | Snyder, Marc | Democratic | 2.33 | 12/6/18 0:00 | Mountain View | CA | 94043 | Advertising | ||
3838 | 3838 | House District 18 | Snyder, Marc | Democratic | 45.09 | 8/6/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Apps | |
3851 | 3851 | House District 18 | Snyder, Marc | Democratic | 48.0 | 9/8/20 0:00 | Mountain View | CA | 94043 | Advertising | Google Apps | |
3866 | 3866 | House District 18 | Snyder, Marc | Democratic | 36.0 | 10/2/19 0:00 | Mountain View | CA | 94043 | Advertising | ||
3883 | 3883 | House District 18 | Snyder, Marc | Democratic | 36.0 | 11/6/19 0:00 | Mountain View | CA | 94043 | Advertising | Google Apps | |
4024 | 4024 | House District 20 | Crutchfield, Susan | Democratic | 124.94 | 3/31/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising | |
4028 | 4028 | House District 20 | Crutchfield, Susan | Democratic | 25.0 | 4/18/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising | |
4032 | 4032 | House District 20 | Crutchfield, Susan | Democratic | 25.0 | 4/27/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising | |
4033 | 4033 | House District 20 | Crutchfield, Susan | Democratic | 25.0 | 4/29/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising | |
4041 | 4041 | House District 20 | Crutchfield, Susan | Democratic | 35.0 | 5/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising | |
4042 | 4042 | House District 20 | Crutchfield, Susan | Democratic | 24.89 | 5/16/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising | |
4045 | 4045 | House District 20 | Crutchfield, Susan | Democratic | 140.0 | 5/27/20 0:00 | Textedly | Los Angeles | CA | 91723 | Advertising | |
4047 | 4047 | House District 20 | Crutchfield, Susan | Democratic | 50.0 | 5/29/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
4053 | 4053 | House District 20 | Crutchfield, Susan | Democratic | 50.0 | 6/11/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising - Boosted Post | |
4054 | 4054 | House District 20 | Crutchfield, Susan | Democratic | 75.0 | 6/14/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising - Boosted Post | |
4055 | 4055 | House District 20 | Crutchfield, Susan | Democratic | 18.01 | 6/16/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising | |
4056 | 4056 | House District 20 | Crutchfield, Susan | Democratic | 140.0 | 6/28/20 0:00 | Textedly | Los Angeles | CA | 91723 | Advertising | |
4061 | 4061 | House District 20 | Crutchfield, Susan | Democratic | 111.93 | 7/6/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Advertising | |
4116 | 4116 | House District 20 | Carver, Terri | Republican | 400.0 | 10/23/20 0:00 | Callfire | Santa Monica | CA | 90401 | Advertising | Robo Calls |
4666 | 4666 | House District 22 | Everett, Justin | Republican | 100.0 | 6/25/20 0:00 | Callhub | Walnut | CA | 91789 | Advertising | Call System For Volunteers |
4672 | 4672 | House District 22 | Parker, Mary | Democratic | 119.4 | 2/15/20 0:00 | Dream Host Web Hosting | Brea | CA | 92821 | Advertising | Web Hosting |
4755 | 4755 | House District 23 | Kennedy, Chris | Democratic | 30.0 | 2/1/19 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | |
4777 | 4777 | House District 23 | Kennedy, Chris | Democratic | 20.0 | 5/1/19 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | |
4785 | 4785 | House District 23 | Kennedy, Chris | Democratic | 14.26 | 7/2/19 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising |
4794 | 4794 | House District 23 | Kennedy, Chris | Democratic | 15.74 | 8/1/19 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising |
4802 | 4802 | House District 23 | Kennedy, Chris | Democratic | 88.53 | 12/1/18 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | |
4826 | 4826 | House District 23 | Kennedy, Chris | Democratic | 44.75 | 2/29/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | |
4833 | 4833 | House District 23 | Kennedy, Chris | Democratic | 150.0 | 3/31/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | |
4893 | 4893 | House District 23 | Kennedy, Chris | Democratic | 25.0 | 8/29/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising |
4897 | 4897 | House District 23 | Kennedy, Chris | Democratic | 25.0 | 9/1/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising |
4899 | 4899 | House District 23 | Kennedy, Chris | Democratic | 50.0 | 9/2/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising |
4900 | 4900 | House District 23 | Kennedy, Chris | Democratic | 25.0 | 9/2/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | |
4901 | 4901 | House District 23 | Kennedy, Chris | Democratic | 35.0 | 9/3/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising |
4902 | 4902 | House District 23 | Kennedy, Chris | Democratic | 75.0 | 9/5/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising 9/3-9/5 |
4903 | 4903 | House District 23 | Kennedy, Chris | Democratic | 75.0 | 9/7/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising 9/5-9/7 |
4904 | 4904 | House District 23 | Kennedy, Chris | Democratic | 125.0 | 9/11/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising 09-07-2020 - 09-11-2020 |
4914 | 4914 | House District 23 | Kennedy, Chris | Democratic | 146.22 | 9/26/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising |
4916 | 4916 | House District 23 | Kennedy, Chris | Democratic | 367.39 | 9/29/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising |
4944 | 4944 | House District 23 | Kennedy, Chris | Democratic | 32.53 | 10/28/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising |
4948 | 4948 | House District 23 | Kennedy, Chris | Democratic | 500.0 | 10/29/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising |
4952 | 4952 | House District 23 | Kennedy, Chris | Democratic | 500.0 | 10/31/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising |
4964 | 4964 | House District 23 | Kennedy, Chris | Democratic | 138.82 | 11/30/20 0:00 | Facebook.Com | Menlo Park | CA | 94025 | Advertising | Advertising |
4986 | 4986 | House District 23 | Clifford, Fred | Republican | 204.0 | 3/19/20 0:00 | Wix.Com | San Francisco | CA | Advertising | Fred Paid For The Website Hosting And Development Out Of His Personal Account | |
4994 | 4994 | House District 23 | Clifford, Fred | Republican | 155.99 | 4/10/20 0:00 | Psprint By Deluxe | Oakland | CA | 94606 | Advertising | Printing Cost For Door Hangers |
5003 | 5003 | House District 23 | Clifford, Fred | Republican | 748.16 | 5/7/20 0:00 | Psprint By Deluxe | Oakland | CA | 94606 | Advertising | Door Hanger V2.0 |
5093 | 5093 | House District 24 | Imer, Laurel | Republican | 25.0 | 9/8/20 0:00 | Menlo Park | CA | 94025 | Advertising | Internet Ads | |
5098 | 5098 | House District 24 | Imer, Laurel | Republican | 25.0 | 9/14/20 0:00 | Menlo Park | CA | 94025 | Advertising | Ads | |
5111 | 5111 | House District 24 | Imer, Laurel | Republican | 5.0 | 10/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5115 | 5115 | House District 24 | Imer, Laurel | Republican | 25.0 | 10/7/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5120 | 5120 | House District 24 | Imer, Laurel | Republican | 35.0 | 10/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5136 | 5136 | House District 24 | Imer, Laurel | Republican | 20.0 | 11/2/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
5204 | 5204 | House District 24 | Duran, Monica | Democratic | 1.21 | 7/2/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5225 | 5225 | House District 24 | Duran, Monica | Democratic | 206.14 | 8/1/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5240 | 5240 | House District 24 | Duran, Monica | Democratic | 202.32 | 9/3/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5270 | 5270 | House District 24 | Duran, Monica | Democratic | 357.21 | 2/3/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Ads | |
5283 | 5283 | House District 24 | Duran, Monica | Democratic | 33.81 | 3/2/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Ads | |
5295 | 5295 | House District 24 | Duran, Monica | Democratic | 43.13 | 4/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Ads | |
5302 | 5302 | House District 24 | Duran, Monica | Democratic | 347.14 | 4/27/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Ads | |
5315 | 5315 | House District 24 | Duran, Monica | Democratic | 134.93 | 6/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5333 | 5333 | House District 24 | Duran, Monica | Democratic | 155.27 | 7/7/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5344 | 5344 | House District 24 | Duran, Monica | Democratic | 44.03 | 8/3/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5366 | 5366 | House District 24 | Duran, Monica | Democratic | 96.75 | 9/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5384 | 5384 | House District 24 | Duran, Monica | Democratic | 91.25 | 10/1/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5387 | 5387 | House District 24 | Duran, Monica | Democratic | 131.02 | 10/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Ads | |
5419 | 5419 | House District 24 | Duran, Monica | Democratic | 100.0 | 11/1/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5421 | 5421 | House District 24 | Duran, Monica | Democratic | 228.38 | 11/2/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5448 | 5448 | House District 24 | Duran, Monica | Democratic | 30.0 | 12/2/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
5458 | 5458 | House District 24 | Duran, Monica | Democratic | 205.35 | 12/31/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
6216 | 6216 | House District 26 | Roberts, Dylan | Democratic | 150.0 | 1/2/19 0:00 | Melno Park | CA | 94025 | Advertising | Facebook Ads | |
6224 | 6224 | House District 26 | Roberts, Dylan | Democratic | 10.0 | 2/1/19 0:00 | Melno Park | CA | 94025 | Advertising | Facebook Ads | |
6237 | 6237 | House District 26 | Roberts, Dylan | Democratic | 15.0 | 3/1/19 0:00 | Melno Park | CA | 94025 | Advertising | Facebook Ads | |
6254 | 6254 | House District 26 | Roberts, Dylan | Democratic | 20.0 | 4/1/19 0:00 | Melno Park | CA | 94025 | Advertising | Facebook Ads | |
6268 | 6268 | House District 26 | Roberts, Dylan | Democratic | 30.0 | 6/3/19 0:00 | Melno Park | CA | 94025 | Advertising | Facebook Ads | |
6279 | 6279 | House District 26 | Roberts, Dylan | Democratic | 33.0 | 8/1/19 0:00 | Melno Park | CA | 94025 | Advertising | Facebook Ads | |
6292 | 6292 | House District 26 | Roberts, Dylan | Democratic | 216.31 | 12/3/18 0:00 | Melno Park | CA | 94025 | Advertising | Facebook Ads | |
6293 | 6293 | House District 26 | Roberts, Dylan | Democratic | 9.71 | 12/7/18 0:00 | Mountain View | CA | 94039 | Advertising | Google Ad Words | |
6328 | 6328 | House District 26 | Roberts, Dylan | Democratic | 25.0 | 8/3/20 0:00 | Melno Park | CA | 94025 | Advertising | Facebook Advertising | |
6346 | 6346 | House District 26 | Roberts, Dylan | Democratic | 9.53 | 10/1/19 0:00 | Melno Park | CA | 94025 | Advertising | Facebook Ads | |
6347 | 6347 | House District 26 | Roberts, Dylan | Democratic | 20.0 | 10/1/20 0:00 | Melno Park | CA | 94025 | Advertising | Facebook Ads | |
6361 | 6361 | House District 26 | Roberts, Dylan | Democratic | 4.51 | 11/1/19 0:00 | Melno Park | CA | 94025 | Advertising | Facebook Ads | |
6363 | 6363 | House District 26 | Roberts, Dylan | Democratic | 30.0 | 11/2/20 0:00 | Melno Park | CA | 94025 | Advertising | Facebook Ads | |
6376 | 6376 | House District 26 | Roberts, Dylan | Democratic | 15.49 | 12/2/19 0:00 | Melno Park | CA | 94025 | Advertising | Facebook Ads | |
6449 | 6449 | House District 27 | Titone, Brianna | Democratic | 100.0 | 5/30/19 0:00 | Menlo Park | CA | 94025 | Advertising | Ads | |
6475 | 6475 | House District 27 | Titone, Brianna | Democratic | 20.0 | 7/1/19 0:00 | Menlo Park | CA | 94025 | Advertising | ||
6626 | 6626 | House District 27 | Titone, Brianna | Democratic | 25.0 | 9/29/20 0:00 | Menlo Park | CA | 94025 | Advertising | Advertising | |
6650 | 6650 | House District 27 | Titone, Brianna | Democratic | 14.13 | 10/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
6651 | 6651 | House District 27 | Titone, Brianna | Democratic | 25.0 | 10/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
6652 | 6652 | House District 27 | Titone, Brianna | Democratic | 35.0 | 10/13/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads | |
6657 | 6657 | House District 27 | Titone, Brianna | Democratic | 50.0 | 10/14/20 0:00 | Menlo Park | CA | 94025 | Advertising | Facebook Ads |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_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 );