house_cand_exp
12 rows where expenditure_type = "Food, Beverages and Meals" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: district, candidate, affiliation, recipient, city, zip, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
301 | 301 | House District 02 | Garnett, Alec | Democratic | 65.26 | 1/14/20 0:00 | Uber | San Francisco | CA | 94105 | Food, Beverages and Meals | |
305 | 305 | House District 02 | Garnett, Alec | Democratic | 46.92 | 1/21/20 0:00 | Uber | San Francisco | CA | 94105 | Food, Beverages and Meals | |
308 | 308 | House District 02 | Garnett, Alec | Democratic | 58.97 | 1/28/20 0:00 | Uber | San Francisco | CA | 94105 | Food, Beverages and Meals | |
335 | 335 | House District 02 | Garnett, Alec | Democratic | 84.24 | 3/5/20 0:00 | Uber | San Francisco | CA | 94105 | Food, Beverages and Meals | |
341 | 341 | House District 02 | Garnett, Alec | Democratic | 174.32 | 4/6/20 0:00 | Uber | San Francisco | CA | 94105 | Food, Beverages and Meals | |
349 | 349 | House District 02 | Garnett, Alec | Democratic | 93.73 | 5/22/20 0:00 | Uber | San Francisco | CA | 94105 | Food, Beverages and Meals | |
355 | 355 | House District 02 | Garnett, Alec | Democratic | 33.26 | 6/22/20 0:00 | Uber | San Francisco | CA | 94105 | Food, Beverages and Meals | |
6458 | 6458 | House District 27 | Titone, Brianna | Democratic | 79.99 | 6/11/19 0:00 | Postmates | San Francisco | CA | 94105 | Food, Beverages and Meals | Food Delivery |
6467 | 6467 | House District 27 | Titone, Brianna | Democratic | 16.0 | 6/18/19 0:00 | Postmates | San Francisco | CA | 94105 | Food, Beverages and Meals | Food Delivery |
9814 | 9814 | House District 39 | Baisley, Mark | Republican | 62.58 | 11/19/19 0:00 | The Fish Market | San Diego | CA | 92101 | Food, Beverages and Meals | Travel Expense, Excelined Education Summit |
9816 | 9816 | House District 39 | Baisley, Mark | Republican | 71.42 | 11/20/19 0:00 | Lou & Mickey'S | San Diego | CA | 92101 | Food, Beverages and Meals | Travel Expense, Excelined Education Summit |
10610 | 10610 | House District 42 | Jackson, Dominique | Democratic | 19.3 | 10/23/19 0:00 | Sucuri Inc | Menifee | CA | 92504 | Food, Beverages and Meals | The Energy Council |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "house_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 );