senate_cand_exp
6 rows where expenditure_type = "Fundraising Expenses" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: district, candidate, affiliation, expenditure_amount, expenditure_date, recipient, city, zip, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
539 | 539 | Senate District 08 | Menconi, Arn | Democratic | 119.88 | 5/1/20 0:00 | Dropbox | San Francisco | CA | 94158 | Fundraising Expenses | |
542 | 542 | Senate District 08 | Menconi, Arn | Democratic | -119.88 | 5/1/20 0:00 | Dropbox | San Francisco | CA | 94158 | Fundraising Expenses | Offset Due To Update Of Filed Item |
543 | 543 | Senate District 08 | Menconi, Arn | Democratic | 119.88 | 5/1/20 0:00 | Dropbox | San Francisco | CA | 94158 | Fundraising Expenses | |
2082 | 2082 | Senate District 19 | Gerber, Lynn | Republican | 96.47 | 5/11/20 0:00 | Uprinting | Van Nuys | CA | 91406 | Fundraising Expenses | |
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 |
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 );