senate_exp
9 rows where District = "Senate District 22" and city = "Mountain View"
This data as json, CSV (advanced)
Suggested facets: candidate_name, Party, expenditure_amount, expenditure_type, explanation
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
3302 | 3302 | Senate District 22 | Jessie Danielson | Democratic | 25.0 | 1/4/19 | Mountain View | CA | 94043 | Consultant & Professional Services | ||
3312 | 3312 | Senate District 22 | Jessie Danielson | Democratic | 25.0 | 2/4/19 | Mountain View | CA | 94043 | Consultant & Professional Services | ||
3367 | 3367 | Senate District 22 | Jessie Danielson | Democratic | 25.0 | 12/3/18 | Mountain View | CA | 94043 | Consultant & Professional Services | ||
3486 | 3486 | Senate District 22 | Colby Drechsel | Republican | 36.0 | 3/31/22 | Mountain View | CA | 94043 | Other | 6400 ∑ Website Expense | |
3503 | 3503 | Senate District 22 | Colby Drechsel | Republican | 36.0 | 6/6/22 | Mountain View | CA | 94043 | Consultant & Professional Services | ||
3507 | 3507 | Senate District 22 | Colby Drechsel | Republican | 36.0 | 7/24/22 | Mountain View | CA | 94043 | Consultant & Professional Services | Website | |
3512 | 3512 | Senate District 22 | Colby Drechsel | Republican | 36.0 | 7/31/22 | Mountain View | CA | 94043 | Other | 6400 ∑ Website Expense | |
3519 | 3519 | Senate District 22 | Colby Drechsel | Republican | 36.0 | 8/31/22 | Mountain View | CA | 94043 | Other | 6400 ∑ Website Expense | |
3527 | 3527 | Senate District 22 | Colby Drechsel | Republican | 36.0 | 10/3/22 | Mountain View | CA | 94043 | Consultant & Professional Services |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "senate_exp" ( "District" TEXT, "candidate_name" TEXT, "Party" TEXT, "expenditure_amount" REAL, "expenditure_date" TEXT, "recipient" TEXT, "city" TEXT, "state" TEXT, "zip" TEXT, "expenditure_type" TEXT, "explanation" TEXT );