senate_exp
6 rows where District = "Senate District 07" and zip = 94107
This data as json, CSV (advanced)
Suggested facets: expenditure_amount
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
988 | 988 | Senate District 07 | Janice Rich | Republican | 24.2 | 8/18/21 | Stripe | San Francisco | CA | 94107 | Bank Fees | |
989 | 989 | Senate District 07 | Janice Rich | Republican | 3.25 | 8/20/21 | Stripe | San Francisco | CA | 94107 | Bank Fees | |
990 | 990 | Senate District 07 | Janice Rich | Republican | 12.1 | 8/23/21 | Stripe | San Francisco | CA | 94107 | Bank Fees | |
991 | 991 | Senate District 07 | Janice Rich | Republican | 23.9 | 8/25/21 | Stripe | San Francisco | CA | 94107 | Bank Fees | |
992 | 992 | Senate District 07 | Janice Rich | Republican | 3.25 | 8/31/21 | Stripe | San Francisco | CA | 94107 | Bank Fees | |
994 | 994 | Senate District 07 | Janice Rich | Republican | 6.2 | 9/10/21 | Stripe | San Francisco | CA | 94107 | Bank Fees |
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 );