senate_exp
4 rows where expenditure_date = "6/25/19"
This data as json, CSV (advanced)
Suggested facets: state, expenditure_type
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
4960 | 4960 | Senate District 34 | Julie C. Gonzales | Democratic | 8.38 | 6/25/19 | King Soopers | Commerce City | CO | 80022 | Food, Beverages and Meals | Dinner For School Safety Committee Meeting |
4961 | 4961 | Senate District 34 | Julie C. Gonzales | Democratic | 11.47 | 6/25/19 | Lyft | San Francisco | CA | 94104 | Travel & Lodging | Travel From Reagan Airport To Hotel During Ncsl Conference In Washington, Dc |
4962 | 4962 | Senate District 34 | Julie C. Gonzales | Democratic | 10.5 | 6/25/19 | Rtd Denver | Denver | CO | 80202 | Travel & Lodging | A-Line From Union Station To Dia Airport For Ncsl Conference In Washington, Dc |
4963 | 4963 | Senate District 34 | Julie C. Gonzales | Democratic | 32.0 | 6/25/19 | Willard Intercontinental Hotel | Washington | DC | 20004 | Food, Beverages and Meals | Meal During Ncsl Conference In Washington, Dc |
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 );