senate_cand_exp
5 rows where expenditure_type = "Food, Beverages and Meals" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: district, candidate, city, zip, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2679 | 2679 | Senate District 19 | Zenzinger, Rachel | Democratic | 60.0 | 4/19/18 0:00 | Eb 60Th Anniversary Dinner | San Francisco | CA | 94103 | Food, Beverages and Meals | Ticket For Jefferson Center Mental Health Gala Dinner. |
2729 | 2729 | Senate District 19 | Zenzinger, Rachel | Democratic | 50.0 | 10/6/17 0:00 | Cdot/Transit Alliance | San Francisco | CA | 94103 | Food, Beverages and Meals | Fee For Transportation Summit |
3363 | 3363 | Senate District 21 | Moreno, Dominick | Democratic | 67.57 | 8/3/18 0:00 | Guelaguetza Restaurante | Los Angeles | CA | 90006 | Food, Beverages and Meals | Meal During Naleo Conference |
3364 | 3364 | Senate District 21 | Moreno, Dominick | Democratic | 20.08 | 8/4/18 0:00 | Marugame Udon | Los Angeles | CA | 90025 | Food, Beverages and Meals | Meal During Naleo Conference |
3366 | 3366 | Senate District 21 | Moreno, Dominick | Democratic | 14.89 | 8/5/18 0:00 | In N Out Burger | Los Angeles | CA | 90024 | Food, Beverages and Meals | Meal During Naleo Conference |
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 );