senate_exp
8 rows where District = "Senate District 22" and city = "Cupertino"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
3200 | 3200 | Senate District 22 | Jessie Danielson | Democratic | 50.76 | 7/14/21 | Apple Inc. | Cupertino | CA | 95014 | Office Equipment & Supplies | |
3254 | 3254 | Senate District 22 | Jessie Danielson | Democratic | 463.32 | 4/8/22 | Apple Inc. | Cupertino | CA | 95014 | Office Equipment & Supplies | |
3258 | 3258 | Senate District 22 | Jessie Danielson | Democratic | 113.4 | 4/18/22 | Apple Inc. | Cupertino | CA | 95014 | Office Equipment & Supplies | |
3259 | 3259 | Senate District 22 | Jessie Danielson | Democratic | 463.32 | 4/18/22 | Apple Inc. | Cupertino | CA | 95014 | Office Equipment & Supplies | |
3288 | 3288 | Senate District 22 | Jessie Danielson | Democratic | 100.0 | 12/2/21 | Apple Inc. | Cupertino | CA | 95014 | Office Equipment & Supplies | |
3289 | 3289 | Senate District 22 | Jessie Danielson | Democratic | 1240.92 | 12/2/21 | Apple Inc. | Cupertino | CA | 95014 | Office Equipment & Supplies | |
3292 | 3292 | Senate District 22 | Jessie Danielson | Democratic | -1240.92 | 12/2/21 | Apple Inc. | Cupertino | CA | 95014 | Office Equipment & Supplies | Offset Due To Update Of Filed Item |
3293 | 3293 | Senate District 22 | Jessie Danielson | Democratic | 1402.92 | 12/2/21 | Apple Inc. | Cupertino | CA | 95014 | Office Equipment & Supplies |
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 );