senate_cand_exp
8 rows where candidate = "Hanlon, Karl" and expenditure_type = "Travel & Lodging"
This data as json, CSV (advanced)
Suggested facets: city, state, zip
Link | rowid ▼ | district | candidate | affiliation | expenditure_amount | expenditure_date | recipient | city | state | zip | expenditure_type | explanation |
---|---|---|---|---|---|---|---|---|---|---|---|---|
386 | 386 | Senate District 08 | Hanlon, Karl | Democratic | 43.49 | 6/12/20 0:00 | Kum & Go | Craig | CO | 81625 | Travel & Lodging | |
388 | 388 | Senate District 08 | Hanlon, Karl | Democratic | 54.2 | 6/17/20 0:00 | Circle K | Lakewood | CO | 80401 | Travel & Lodging | |
391 | 391 | Senate District 08 | Hanlon, Karl | Democratic | 56.79 | 6/19/20 0:00 | Phillips 66 | Steamboat Springs | CO | 80487 | Travel & Lodging | |
426 | 426 | Senate District 08 | Hanlon, Karl | Democratic | 69.99 | 8/31/20 0:00 | Recreation.Gov | Glenwood Springs | CO | 81601 | Travel & Lodging | |
438 | 438 | Senate District 08 | Hanlon, Karl | Democratic | 4.0 | 9/14/20 0:00 | Town Of Breckenridge | Breckenridge | CO | 80424 | Travel & Lodging | Parking |
439 | 439 | Senate District 08 | Hanlon, Karl | Democratic | 60.65 | 9/15/20 0:00 | Koa Steamboat Springs | Steamboat Springs | CO | 80487 | Travel & Lodging | Lodging |
445 | 445 | Senate District 08 | Hanlon, Karl | Democratic | 161.43 | 9/21/20 0:00 | Hotels.Com | Dallas | TX | 75240 | Travel & Lodging | |
449 | 449 | Senate District 08 | Hanlon, Karl | Democratic | 137.21 | 9/25/20 0:00 | River Run Rv Resort | Granby | CO | 80446 | 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 );