senate_exp

2 rows where recipient = "Usps.Com"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ District candidate_name Party expenditure_amount expenditure_date recipient city state zip expenditure_type explanation
3230 3230 Senate District 22 Jessie Danielson Democratic 111.8 12/31/20 Usps.Com Washington DC 20260 Office Equipment & Supplies  
3433 3433 Senate District 22 Jessie Danielson Democratic 221.8 7/27/20 Usps.Com Washington DC 20260 Office Equipment & Supplies  

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