senate_cand_exp
15 rows where candidate = "Rankin, Bob" and expenditure_type = "Miscellaneous"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, recipient, city, state, zip, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
236 | 236 | Senate District 08 | Rankin, Bob | Republican | 400.0 | 3/5/19 0:00 | Colorado Senate Caucus | Denvver | CO | 80203 | Miscellaneous | Dues |
237 | 237 | Senate District 08 | Rankin, Bob | Republican | 11.99 | 4/4/19 0:00 | Denver Post | Miscellaneous | Subscription | |||
240 | 240 | Senate District 08 | Rankin, Bob | Republican | 290.0 | 4/17/19 0:00 | Club 20 | Grand Junction | CO | 81501 | Miscellaneous | Registration |
244 | 244 | Senate District 08 | Rankin, Bob | Republican | 11.99 | 5/6/19 0:00 | Denver Post | Miscellaneous | Subscription | |||
246 | 246 | Senate District 08 | Rankin, Bob | Republican | 12.42 | 5/7/19 0:00 | Colorado Politics | Colorado Springs | CO | 80903 | Miscellaneous | Subscription |
247 | 247 | Senate District 08 | Rankin, Bob | Republican | 26.0 | 5/9/19 0:00 | Cci | Denver | CO | 80203 | Miscellaneous | Flag |
260 | 260 | Senate District 08 | Rankin, Bob | Republican | 134.0 | 7/5/19 0:00 | Us Postal Service | Carbondale | CO | 81623 | Miscellaneous | Box Rent |
261 | 261 | Senate District 08 | Rankin, Bob | Republican | 134.0 | 7/18/19 0:00 | Us Postal Service | CO | Miscellaneous | Box Rent | ||
297 | 297 | Senate District 08 | Rankin, Bob | Republican | 300.92 | 7/10/20 0:00 | Customink | Fairfax | VA | 22031 | Miscellaneous | Shirts |
298 | 298 | Senate District 08 | Rankin, Bob | Republican | 24.91 | 7/16/20 0:00 | Godaddy | Scottsdale | AZ | 85260 | Miscellaneous | Website |
303 | 303 | Senate District 08 | Rankin, Bob | Republican | 24.84 | 8/5/20 0:00 | Colorado Politics | Colorado Springs | CO | 80903 | Miscellaneous | Subscription |
306 | 306 | Senate District 08 | Rankin, Bob | Republican | 488.05 | 8/15/20 0:00 | Wall State Journal | New York City | NY | 10001 | Miscellaneous | Subscription |
310 | 310 | Senate District 08 | Rankin, Bob | Republican | 130.39 | 9/3/20 0:00 | The Business Journal | Charlotte | NC | 28202 | Miscellaneous | Subscription |
313 | 313 | Senate District 08 | Rankin, Bob | Republican | 35.97 | 9/4/20 0:00 | Denver Post | Denver | CO | 80216 | Miscellaneous | Subscription |
318 | 318 | Senate District 08 | Rankin, Bob | Republican | 1256.95 | 9/16/20 0:00 | Bob Rankin | Carbondale | CO | 81623 | Miscellaneous | Mileage |
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 );