house_cand_exp
4 rows where city = "Firestone" and expenditure_type = "Returned Expenditure"
This data as json, CSV (advanced)
Suggested facets: district, candidate, expenditure_amount, recipient, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
9724 | 9724 | House District 39 | Baisley, Mark | Republican | -100.0 | 8/10/20 0:00 | House Republican Caucus | Firestone | CO | 80520 | Returned Expenditure | 2019 Dues Refund |
13542 | 13542 | House District 55 | Rich, Janice | Republican | -100.0 | 8/8/20 0:00 | House Republican Caucus | Firestone | CO | 80520 | Returned Expenditure | 2019 Refund Of Unused Dues |
14765 | 14765 | House District 63 | Seulean, Corey | Republican | -6.0 | 9/23/19 0:00 | United States Postal Services | Firestone | CO | 80520 | Returned Expenditure | Post Office Key Refund |
14796 | 14796 | House District 63 | Seulean, Corey | Republican | -85.26 | 6/25/20 0:00 | Home Depot | Firestone | CO | 80504 | Returned Expenditure | Return Items Not Used |
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 );