senate_cand_exp
7 rows where expenditure_type = "Miscellaneous" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: district, candidate, affiliation, city, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1733 | 1733 | Senate District 18 | Fenberg, Stephen | Democratic | 7.15 | 3/3/17 0:00 | Lyft | San Francisco | CA | 94170 | Miscellaneous | Lyft |
2315 | 2315 | Senate District 19 | Zenzinger, Rachel | Democratic | 119.88 | 9/10/19 0:00 | Dropbox | San Francisco | CA | 94107 | Miscellaneous | For Dropbox Subscription |
3684 | 3684 | Senate District 23 | Parchment, Rupert | Republican | 75.73 | 3/27/20 0:00 | S.I. Products | Sanjose | CA | 95125 | Miscellaneous | Flag Holder |
5262 | 5262 | Senate District 29 | Fields, Rhonda | Democratic | 62.79 | 3/22/19 0:00 | Proflowers | San Diego | CA | 92121 | Miscellaneous | Flowers |
5435 | 5435 | Senate District 29 | Fields, Rhonda | Democratic | 60.0 | 6/13/17 0:00 | Paypal | San Jose | CA | 95131 | Miscellaneous | |
5956 | 5956 | Senate District 31 | Hansen, Chris | Democratic | 1.99 | 11/28/20 0:00 | Google Corporation | Mountain View | CA | 94043 | Miscellaneous | Google Storage |
6170 | 6170 | Senate District 31 | Orms, Maria | Democratic | 18.58 | 12/31/19 0:00 | Google Suite | Mountain View | CA | 94043 | Miscellaneous | Google Suite |
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 );