senate_cand_exp
12 rows where candidate = "Rankin, Bob" and expenditure_type = "Food, Beverages and Meals"
This data as json, CSV (advanced)
Suggested facets: expenditure_amount, expenditure_date, recipient, city, zip, explanation
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
239 | 239 | Senate District 08 | Rankin, Bob | Republican | 150.0 | 4/15/19 0:00 | Garfield County Republican Central Committee | Carbondale | CO | 81623-9117 | Food, Beverages and Meals | |
250 | 250 | Senate District 08 | Rankin, Bob | Republican | 15.2 | 5/14/19 0:00 | Bonfire Coffee | Carbondale | CO | 81623 | Food, Beverages and Meals | Constituent Meeting |
252 | 252 | Senate District 08 | Rankin, Bob | Republican | 38.8 | 5/17/19 0:00 | River Rock Cafe | Walden | CO | 80480 | Food, Beverages and Meals | Constituent Meeting |
254 | 254 | Senate District 08 | Rankin, Bob | Republican | 30.0 | 5/21/19 0:00 | Jackson County Republican Central Committee | Walden | CO | 80480 | Food, Beverages and Meals | |
257 | 257 | Senate District 08 | Rankin, Bob | Republican | 31.65 | 6/23/19 0:00 | Johnny B Good Restaurant | Steamboat Springs | CO | 80487 | Food, Beverages and Meals | Local Official Meeting |
271 | 271 | Senate District 08 | Rankin, Bob | Republican | 100.0 | 2/20/20 0:00 | Moffat County Republican Central Committee (Mcrcc) | Craig | CO | 81626 | Food, Beverages and Meals | |
272 | 272 | Senate District 08 | Rankin, Bob | Republican | 150.0 | 2/20/20 0:00 | Garfield County Republican Central Committee | Carbondale | CO | 81623-9117 | Food, Beverages and Meals | |
299 | 299 | Senate District 08 | Rankin, Bob | Republican | 36.43 | 7/16/20 0:00 | Sauce On The Blue | Silverthorne | CO | 80497 | Food, Beverages and Meals | |
304 | 304 | Senate District 08 | Rankin, Bob | Republican | 30.41 | 8/7/20 0:00 | Mavericks Grille | Granby | CO | 80446 | Food, Beverages and Meals | |
311 | 311 | Senate District 08 | Rankin, Bob | Republican | 41.53 | 9/3/20 0:00 | Vallartas | Craig | CO | 81625 | Food, Beverages and Meals | |
312 | 312 | Senate District 08 | Rankin, Bob | Republican | 5.15 | 9/3/20 0:00 | Starbucks | Frisco | CO | 80443 | Food, Beverages and Meals | |
314 | 314 | Senate District 08 | Rankin, Bob | Republican | 7.48 | 9/4/20 0:00 | Jump Start | Grand Lake | CO | 80447 | Food, Beverages and Meals |
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 );