ed_cand_exp
128 rows where state = "CA" sorted by expenditure_date
This data as json, CSV (advanced)
Link | rowid | district | candidate | affiliation | expenditure_amount | expenditure_date ▼ | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
727 | 727 | CU Regent District 02 | Gross, David | Democratic | 300.0 | 6/29/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Ads | |
728 | 728 | CU Regent District 02 | Gross, David | Democratic | 1000.0 | 6/29/20 0:00 | Twilio | San Francisco | CA | 94105 | Other | Text Messaging |
729 | 729 | CU Regent District 02 | Gross, David | Democratic | 1000.0 | 6/29/20 0:00 | Twilio | San Francisco | CA | 94105 | Other | Text Messaging |
1169 | 1169 | CU Regent District 06 | Rahn, Priscilla | Republican | 138.05 | 6/29/20 0:00 | My Soapbox Llc | Camacillo | CA | 93010 | Consultant & Professional Services | |
690 | 690 | CU Regent District 02 | Gross, David | Democratic | 100.0 | 6/3/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Ads | |
38 | 38 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 125.0 | 6/30/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
731 | 731 | CU Regent District 02 | Gross, David | Democratic | 300.0 | 6/30/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Ads | |
732 | 732 | CU Regent District 02 | Gross, David | Democratic | 48.58 | 6/30/20 0:00 | Menlo Park | CA | 94025 | Advertising | Digital Ads | |
733 | 733 | CU Regent District 02 | Gross, David | Democratic | 200.0 | 6/30/20 0:00 | Twilio | San Francisco | CA | 94105 | Other | Text Messaging |
734 | 734 | CU Regent District 02 | Gross, David | Democratic | 215.17 | 6/30/20 0:00 | Twilio | San Francisco | CA | 94105 | Other | Text Messaging |
518 | 518 | CU Regent District 02 | Rennison, Callie | Democratic | 0.71 | 6/5/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
519 | 519 | CU Regent District 02 | Rennison, Callie | Democratic | 1.29 | 6/6/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
817 | 817 | CU Regent District 06 | Spiegel, Ilana | Democratic | 569.0 | 6/7/19 0:00 | Instashirt | Chico | CA | 95926 | Miscellaneous | T Shirt Printing |
520 | 520 | CU Regent District 02 | Rennison, Callie | Democratic | 1.29 | 6/7/20 0:00 | Menlo Park | CA | 94025 | Advertising | Fb Post Boost | |
522 | 522 | CU Regent District 02 | Rennison, Callie | Democratic | 1.29 | 6/8/20 0:00 | Menlo Park | CA | 94025 | Advertising | Fb Post Boost | |
523 | 523 | CU Regent District 02 | Rennison, Callie | Democratic | -1.29 | 6/8/20 0:00 | Menlo Park | CA | 94025 | Advertising | Offset Due To Update Of Filed Item - Fb Post Boost | |
524 | 524 | CU Regent District 02 | Rennison, Callie | Democratic | 1.29 | 6/8/20 0:00 | Menlo Park | CA | 94025 | Advertising | Fb Post Boost | |
40 | 40 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 289.55 | 7/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
1170 | 1170 | CU Regent District 06 | Rahn, Priscilla | Republican | 126.82 | 7/1/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
859 | 859 | CU Regent District 06 | Spiegel, Ilana | Democratic | 63.01 | 7/2/20 0:00 | Google Llc | Mountain View | CA | 94043 | Advertising | |
46 | 46 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 96.94 | 7/28/20 0:00 | Mountain View | CA | 94043 | Advertising | Advertising | |
740 | 740 | CU Regent District 02 | Gross, David | Democratic | 98.25 | 7/31/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
219 | 219 | Bd. Ed. District 03 | Simpson, Mayling | Democratic | 16.24 | 8/28/20 0:00 | Zoom | San Jose | CA | 95113 | Miscellaneous | |
48 | 48 | Bd. Ed. District 01 | Escarcega, Lisa | Democratic | 3.56 | 8/3/20 0:00 | Menlo Park | CA | 94025 | Advertising | ||
442 | 442 | Bd. Ed. District 07 | Pallozzi, Nancy | Republican | 80.0 | 9/2/20 0:00 | Menlo Park | CA | 94025 | Advertising | Social Media | |
869 | 869 | CU Regent District 06 | Spiegel, Ilana | Democratic | 62.39 | 9/2/20 0:00 | Google Llc | Mountain View | CA | 94043 | Advertising | |
1042 | 1042 | CU Regent District 06 | Murray, Richard | Republican | 12.78 | 9/30/20 0:00 | Mountain View | CA | 94043 | Other | 6410 ∑ Registration & Hosting | |
1043 | 1043 | CU Regent District 06 | Murray, Richard | Republican | 12.0 | 9/30/20 0:00 | Mountain View | CA | 94043 | Other | 6410 ∑ Registration & Hosting |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "ed_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 );