senate_cand_exp
9 rows where district = "Senate District 26" and expenditure_type = "Other"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date, recipient, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
4325 | 4325 | Senate District 26 | Roth, Robert | Republican | 2.8 | 4/2/20 0:00 | Google Llc | Mountain View | CA | Other | Campaign Email | |
4337 | 4337 | Senate District 26 | Roth, Robert | Republican | 12.45 | 6/4/20 0:00 | Google Llc | Mountain View | CA | Other | Campaign Email | |
4346 | 4346 | Senate District 26 | Roth, Robert | Republican | 12.45 | 7/2/20 0:00 | Google, Llc | Mountain View | CA | Other | Campaign Email | |
4352 | 4352 | Senate District 26 | Roth, Robert | Republican | 12.45 | 8/3/20 0:00 | Google Llc | Mountain View | CA | Other | Campaign Email | |
4369 | 4369 | Senate District 26 | Roth, Robert | Republican | 12.45 | 9/2/20 0:00 | Google Llc | Mountain View | CA | Other | Campaign Email | |
4394 | 4394 | Senate District 26 | Roth, Robert | Republican | 12.45 | 10/5/20 0:00 | Google Llc | Mountain View | CA | Other | Campaign Email | |
4397 | 4397 | Senate District 26 | Roth, Robert | Republican | -12.45 | 10/5/20 0:00 | Google Llc | Mountain View | CA | Other | Offset Due To Update Of Filed Item - Campaign Email | |
4398 | 4398 | Senate District 26 | Roth, Robert | Republican | 12.45 | 10/5/20 0:00 | Google Llc | Mountain View | CA | 94043 | Other | Campaign Email |
4411 | 4411 | Senate District 26 | Roth, Robert | Republican | 12.45 | 11/2/20 0:00 | Google Llc | Mountain View | CA | 94043 | Other | Campaign Email |
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 );