senate_cand_exp
6 rows where candidate = "Lewis, Sonya Jaquez" and expenditure_type = "Food, Beverages and Meals"
This data as json, CSV (advanced)
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
1256 | 1256 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 56.91 | 1/6/20 0:00 | Costco | Thornton | CO | 80023 | Food, Beverages and Meals | |
1257 | 1257 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 76.34 | 1/12/20 0:00 | Tasty Asian | Longmont | CO | 80501 | Food, Beverages and Meals | |
1268 | 1268 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 18.88 | 9/25/20 0:00 | Niwot Market | Longmont | CO | 80503 | Food, Beverages and Meals | |
1271 | 1271 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 71.35 | 10/9/19 0:00 | Tasy Asia | Longmont | CO | 80501 | Food, Beverages and Meals | |
1280 | 1280 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 59.9 | 11/13/19 0:00 | Prohibition Restaurant | Denver | CO | 80203 | Food, Beverages and Meals | Fundraiser |
1284 | 1284 | Senate District 17 | Lewis, Sonya Jaquez | Democratic | 48.27 | 12/12/19 0:00 | Tandoori Kitchen | Lafayette | CO | 80026 | Food, Beverages and Meals |
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 );