senate_cand_exp
6 rows where expenditure_type = "Rent & Utilities" and zip = 94043
This data as json, CSV (advanced)
Suggested facets: expenditure_amount
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2073 | 2073 | Senate District 19 | Gerber, Lynn | Republican | 30.0 | 4/2/20 0:00 | Mountain View | CA | 94043 | Rent & Utilities | ||
2121 | 2121 | Senate District 19 | Gerber, Lynn | Republican | 5.34 | 8/3/20 0:00 | Mountain View | CA | 94043 | Rent & Utilities | ||
2152 | 2152 | Senate District 19 | Gerber, Lynn | Republican | 16.25 | 9/3/20 0:00 | Mountain View | CA | 94043 | Rent & Utilities | ||
2173 | 2173 | Senate District 19 | Gerber, Lynn | Republican | 18.0 | 10/1/20 0:00 | Mountain View | CA | 94043 | Rent & Utilities | ||
2200 | 2200 | Senate District 19 | Gerber, Lynn | Republican | 18.0 | 11/3/20 0:00 | Mountain View | CA | 94043 | Rent & Utilities | ||
2206 | 2206 | Senate District 19 | Gerber, Lynn | Republican | 18.62 | 11/30/20 0:00 | Mountain View | CA | 94043 | Rent & Utilities |
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 );