state_exp
22 rows where expenditure_type = "Food, Beverages and Meals" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: District, candidate_name, expenditure_date, recipient, city, zip
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1651 | 1651 | Secretary of State | Jena Griswold | Democratic | 22.69 | 2/17/22 | Cvs | San Francisco | CA | 94109 | Food, Beverages and Meals | |
1966 | 1966 | Secretary of State | Jena Griswold | Democratic | 24.66 | 5/18/22 | Uber Eats | San Francisco | CA | 94103 | Food, Beverages and Meals | |
1983 | 1983 | Secretary of State | Jena Griswold | Democratic | 25.58 | 5/20/22 | Uber Eats | San Francisco | CA | 94103 | Food, Beverages and Meals | |
1989 | 1989 | Secretary of State | Jena Griswold | Democratic | 21.71 | 5/23/22 | Hyatt Regency Los Angeles Airport | Los Angeles | CA | 90045 | Food, Beverages and Meals | |
2174 | 2174 | Secretary of State | Jena Griswold | Democratic | 27.16 | 7/21/22 | Postmates, Llc | San Francisco | CA | 94158 | Food, Beverages and Meals | |
2263 | 2263 | Secretary of State | Jena Griswold | Democratic | 24.56 | 8/22/22 | Uber Eats | San Francisco | CA | 94103 | Food, Beverages and Meals | |
2264 | 2264 | Secretary of State | Jena Griswold | Democratic | 26.59 | 8/22/22 | Uber Eats | San Francisco | CA | 94103 | Food, Beverages and Meals | |
2265 | 2265 | Secretary of State | Jena Griswold | Democratic | 5.87 | 8/22/22 | Uber Eats | San Francisco | CA | 94103 | Food, Beverages and Meals | |
2266 | 2266 | Secretary of State | Jena Griswold | Democratic | 41.28 | 8/22/22 | Uber Eats | San Francisco | CA | 94103 | Food, Beverages and Meals | |
2267 | 2267 | Secretary of State | Jena Griswold | Democratic | 8.19 | 8/22/22 | Uber Eats | San Francisco | CA | 94103 | Food, Beverages and Meals | |
2293 | 2293 | Secretary of State | Jena Griswold | Democratic | 157.17 | 8/29/22 | Instacart | San Francisco | CA | 94105 | Food, Beverages and Meals | |
2343 | 2343 | Secretary of State | Jena Griswold | Democratic | 25.6 | 9/9/22 | Uber Eats | San Francisco | CA | 94103 | Food, Beverages and Meals | |
2374 | 2374 | Secretary of State | Jena Griswold | Democratic | 22.14 | 9/14/22 | Uber Eats | San Francisco | CA | 94103 | Food, Beverages and Meals | |
2458 | 2458 | Secretary of State | Jena Griswold | Democratic | 25.1 | 9/30/22 | Uber Eats | San Francisco | CA | 94103 | Food, Beverages and Meals | |
2543 | 2543 | Secretary of State | Jena Griswold | Democratic | 27.56 | 10/14/22 | Uber Eats | San Francisco | CA | 94103 | Food, Beverages and Meals | |
2600 | 2600 | Secretary of State | Jena Griswold | Democratic | 27.7 | 10/25/22 | Uber Eats | San Francisco | CA | 94103 | Food, Beverages and Meals | |
2705 | 2705 | Secretary of State | Jena Griswold | Democratic | 22.21 | 11/18/22 | Sutter Pub | San Francisco | CA | 94109 | Food, Beverages and Meals | |
2706 | 2706 | Secretary of State | Jena Griswold | Democratic | 24.49 | 11/18/22 | Uber Eats | San Francisco | CA | 94103 | Food, Beverages and Meals | |
2714 | 2714 | Secretary of State | Jena Griswold | Democratic | 85.02 | 11/25/22 | Instacart | San Francisco | CA | 94105 | Food, Beverages and Meals | |
6639 | 6639 | Governor | Jared Polis | Democratic | 150.11 | 12/10/21 | The Farm Beverly Hills | Beverly Hills | CA | 90210 | Food, Beverages and Meals | Meal |
8038 | 8038 | CU Regent District 01 | Wanda James | Democratic | 130.68 | 3/28/22 | Chipotle | Newport Beach | CA | 92660 | Food, Beverages and Meals | |
9733 | 9733 | Attorney General | Phil Weiser | Democratic | 707.11 | 7/12/19 | The Ritz Carlton, Bacara, Santa Barbara | Santa Barbara | CA | 93117 | Food, Beverages and Meals | Food And Beverage For Campaign Event |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "state_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 );