ed_cand_exp

3 rows where expenditure_type = "Rent & Utilities"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: candidate, expenditure_amount, city, zip

Link rowid ▼ district candidate affiliation expenditure_amount expenditure_date recipient city state zip expenditure_type explanation
617 617 CU Regent District 02 Gross, David Democratic 77.0 9/4/19 0:00 Usps Lafayette CO 80026 Rent & Utilities Po Box
626 626 CU Regent District 02 Gross, David Democratic 77.0 1/2/20 0:00 United States Postal Service Lafayette CO 80026 Rent & Utilities Po Box Renewal
782 782 CU Regent District 02 Harber, Aaron Democratic 77.67 4/30/20 0:00 Boulder Valley School District Boulder CO 80303 Rent & Utilities  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "ed_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
);