senate_exp

9 rows where state = "DC" and zip = 20006

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: District, candidate_name, Party, expenditure_amount, recipient, expenditure_type, explanation

Link rowid ▼ District candidate_name Party expenditure_amount expenditure_date recipient city state zip expenditure_type explanation
1450 1450 Senate District 08 Matt Solomon Republican 100.0 8/22/22 Rumbleup, Llc Washington DC 20006 Advertising  
2828 2828 Senate District 15 Rob Woodward Republican 312.0 11/22/21 Sitebuilder Washington DC 20006 Other 6410 ∑ Registration & Hosting
3053 3053 Senate District 20 Tim Walsh Republican 16400.0 5/3/22 Cygnal Llc Washington DC 20006 Miscellaneous Benchmark Polls
3095 3095 Senate District 20 Tim Walsh Republican 15200.0 9/1/22 Cyngal Llc Washington DC 20006 Other 6510 ∑ Survey Research
3142 3142 Senate District 20 Tim Walsh Republican 11900.0 10/24/22 Cyngal Llc Washington DC 20006 Other 6510 ∑ Survey Research
3792 3792 Senate District 25 Faith Winter Democratic 10.0 3/22/22 Action Network Washington DC 20006 Fundraising Expenses  
3793 3793 Senate District 25 Faith Winter Democratic 10.0 4/21/22 Action Network Washington DC 20006 Fundraising Expenses  
3798 3798 Senate District 25 Faith Winter Democratic 10.0 5/23/22 Action Network Washington DC 20006 Fundraising Expenses  
3808 3808 Senate District 25 Faith Winter Democratic 10.0 7/21/22 Action Network Washington DC 20006 Bank Fees  

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