state_exp
3 rows where District = "CU Regent District 08" and expenditure_type = "Food, Beverages and Meals"
This data as json, CSV (advanced)
Link | rowid ▼ | District | candidate_name | Party | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
8283 | 8283 | CU Regent District 08 | Yolanda Ortega | Democratic | 41.39 | 5/26/22 | Red Robin No 127 | Brighton | CO | 80601 | Food, Beverages and Meals | |
8339 | 8339 | CU Regent District 08 | Yolanda Ortega | Democratic | 83.94 | 11/18/22 | Lazy Dog Restaurant | Westminster | CO | 80023 | Food, Beverages and Meals | Campaign Wrap Up Meeting #1 |
8343 | 8343 | CU Regent District 08 | Yolanda Ortega | Democratic | 122.63 | 11/27/22 | Bluebird Cafe | Thornton | CO | 80229 | Food, Beverages and Meals | Campaign Wrap Up Meeting #2 |
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 );