house_cand_exp
4 rows where candidate = "Baisley, Mark" and expenditure_type = "Gifts"
This data as json, CSV (advanced)
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
9633 | 9633 | House District 39 | Baisley, Mark | Republican | 83.24 | 3/3/20 0:00 | Cindy'S Floral | Littleton | CO | 80127 | Gifts | Condolences For Rep. Polly Lawrence |
9706 | 9706 | House District 39 | Baisley, Mark | Republican | 120.0 | 7/3/20 0:00 | Mark A Baisley | Roxborough Park | CO | 80125 | Gifts | Reimbursement For Capitol Staff Recognition (Gifts) |
9760 | 9760 | House District 39 | Baisley, Mark | Republican | 19.74 | 10/12/20 0:00 | Officemax | Highlands Ranch | CO | 80129 | Gifts | Thank-You Cards |
9821 | 9821 | House District 39 | Baisley, Mark | Republican | 312.0 | 11/25/19 0:00 | Andy Marquez | Littleton | CO | 80125 | Gifts | Coffee Table Books For Volunteer Gifts |
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 );