senate_cand_exp
13 rows where candidate = "Rankin, Bob" and expenditure_type = "Travel & Lodging"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date, recipient, city, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
238 | 238 | Senate District 08 | Rankin, Bob | Republican | 134.36 | 4/13/19 0:00 | Double Tree Inn | Grand Junction | CO | 81506 | Travel & Lodging | |
248 | 248 | Senate District 08 | Rankin, Bob | Republican | 126.5 | 5/9/19 0:00 | Allington Inn | Kremmling | CO | 80459 | Travel & Lodging | Constituent Meeting |
249 | 249 | Senate District 08 | Rankin, Bob | Republican | 90.98 | 5/12/19 0:00 | Qaulity Inn | Steamboat | CO | 80487 | Travel & Lodging | |
251 | 251 | Senate District 08 | Rankin, Bob | Republican | 97.81 | 5/17/19 0:00 | River Rock Cafe | Walden | CO | 80480 | Travel & Lodging | |
255 | 255 | Senate District 08 | Rankin, Bob | Republican | 149.87 | 6/22/19 0:00 | Qaulity Inn | Steamboat | CO | 80487 | Travel & Lodging | Routt Gop Ldd |
256 | 256 | Senate District 08 | Rankin, Bob | Republican | 132.08 | 6/22/19 0:00 | Bob Rankin | Carbondale | CO | 81623 | Travel & Lodging | Mileage To Steamboat Springs |
258 | 258 | Senate District 08 | Rankin, Bob | Republican | 104.0 | 6/28/19 0:00 | Bob Rankin | Carbondale | CO | 81623 | Travel & Lodging | Mileage To Grand Junction |
259 | 259 | Senate District 08 | Rankin, Bob | Republican | 122.0 | 6/29/19 0:00 | Econolodge | Grand Junction | CO | 81506 | Travel & Lodging | Assn Of Corrections Annual Meeting |
305 | 305 | Senate District 08 | Rankin, Bob | Republican | 109.75 | 8/8/20 0:00 | Best Western | Craig | CO | 81625 | Travel & Lodging | |
315 | 315 | Senate District 08 | Rankin, Bob | Republican | 154.29 | 9/4/20 0:00 | Grand Escape Cottages | Grand Lake | CO | 80447 | Travel & Lodging | |
316 | 316 | Senate District 08 | Rankin, Bob | Republican | 193.84 | 9/5/20 0:00 | Nordic Lodge | Steamboat Springs | CO | 80477 | Travel & Lodging | |
339 | 339 | Senate District 08 | Rankin, Bob | Republican | 208.02 | 11/27/20 0:00 | Hotel Maverick | Grand Junction | CO | 81501 | Travel & Lodging | |
340 | 340 | Senate District 08 | Rankin, Bob | Republican | 193.84 | 11/27/20 0:00 | Bob Rankin | Carbondale | CO | 81623 | Travel & Lodging |
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 );