senate_exp

3 rows where expenditure_type = "Entertainment"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Party, city

Link rowid ▼ District candidate_name Party expenditure_amount expenditure_date recipient city state zip expenditure_type explanation
190 190 Senate District 03 Nick Hinrichsen Democratic 100.0 6/10/22 Cobalt Advocates Denver CO 80222 Entertainment  
1994 1994 Senate District 11 Tony Exum Democratic 250.0 12/8/22 Dj Shield Llc Fountain CO 80817 Entertainment Audio For Volunteer Appreciation
3738 3738 Senate District 24 Courtney Potter Republican 45.16 7/21/22 Hillstone Denver Denver CO 80206 Entertainment  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "senate_exp" (
"District" TEXT,
  "candidate_name" TEXT,
  "Party" TEXT,
  "expenditure_amount" REAL,
  "expenditure_date" TEXT,
  "recipient" TEXT,
  "city" TEXT,
  "state" TEXT,
  "zip" TEXT,
  "expenditure_type" TEXT,
  "explanation" TEXT
);