house_cand_exp
6 rows where city = "Platteville"
This data as json, CSV (advanced)
Suggested facets: district, candidate, recipient, zip, expenditure_type, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
12336 | 12336 | House District 48 | Van Beber, Tonya | Republican | 55.35 | 3/3/20 0:00 | Doubletree Restaurant | Platteville | CO | 80651 | Food, Beverages and Meals | Lunch |
12409 | 12409 | House District 48 | Van Beber, Tonya | Republican | 39.25 | 8/17/20 0:00 | Dollar General | Platteville | CO | 80651 | Entertainment | Parade Supplies |
14690 | 14690 | House District 63 | Seulean, Corey | Republican | 28.0 | 5/11/19 0:00 | Double Tree Restaurant | Platteville | CO | 80651 | Food, Beverages and Meals | 2 Meals At A Political Meeting In Platteville |
14760 | 14760 | House District 63 | Seulean, Corey | Republican | 24.3 | 9/14/19 0:00 | Double Tree Restaurant | Platteville | CO | 80651 | Food, Beverages and Meals | Two Meals While Attending A Political Breakfast Meeting In Platteville |
14923 | 14923 | House District 63 | Woog, Dan | Republican | 6.98 | 1/11/20 0:00 | Doubletree | Platteville | CO | 8051 | Other | 6890 ∑ Other Meeting Expense |
14948 | 14948 | House District 63 | Woog, Dan | Republican | 15.18 | 3/9/20 0:00 | Doubletree | Platteville | CO | 8051 | Other | 6890 ∑ Other Meeting Expense |
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 );