ed_cand_exp

2 rows where expenditure_type = "Employee Services"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ district candidate affiliation expenditure_amount expenditure_date recipient city state zip expenditure_type explanation
883 883 CU Regent District 06 Spiegel, Ilana Democratic 649.0 10/1/20 0:00 Emma Carroll Centennial CO 80112 Employee Services  
896 896 CU Regent District 06 Spiegel, Ilana Democratic 874.01 10/16/20 0:00 Community Labor Administrative Services Brooklyn NY 11201 Employee Services  

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
);