ed_cand_exp

3 rows where expenditure_type = "Telephone"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: expenditure_amount, state

Link rowid ▼ district candidate affiliation expenditure_amount expenditure_date recipient city state zip expenditure_type explanation
437 437 Bd. Ed. District 07 Pallozzi, Nancy Republican 262.78 7/21/20 0:00 Century Link   CO   Telephone  
438 438 Bd. Ed. District 07 Pallozzi, Nancy Republican 108.68 8/20/20 0:00 Century Link   CO   Telephone Telephone Bill
443 443 Bd. Ed. District 07 Pallozzi, Nancy Republican 108.68 10/20/20 0:00 Century Link Seattle WA 98111-9255 Telephone  

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