senate_exp

8 rows where state = "IL" and zip = 60197

✎ 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
943 943 Senate District 04 Jeff Ravage Democratic 22.61 4/2/22 At&T Carol Stream IL 60197 Telephone  
948 948 Senate District 04 Jeff Ravage Democratic 9.09 5/2/22 At&T Carol Stream IL 60197 Telephone Monthly Phone
952 952 Senate District 04 Jeff Ravage Democratic 30.0 6/6/22 At&T Carol Stream IL 60197 Telephone Monthly Phone
1608 1608 Senate District 09 Paul Lundeen Republican 60.0 7/1/21 Chase Card Services Carol Stream IL 60197 Other 7720 ∑ Licenses & Fees
1708 1708 Senate District 09 Paul Lundeen Republican 316.39 8/23/22 Chase Card Services Carol Stream IL 60197 Food, Beverages and Meals  
1738 1738 Senate District 09 Paul Lundeen Republican 45.0 3/28/19 Cardmember Services Carol Stream IL 60197 Bank Fees  
1803 1803 Senate District 09 Paul Lundeen Republican 41.49 3/15/20 Chase Card Services Carol Stream IL 60197 Other 7820 ∑ Merchant Account Fees
1806 1806 Senate District 09 Paul Lundeen Republican 45.0 3/25/20 Chase Card Services Carol Stream IL 60197 Other 7218 ∑ Dues And Subscriptions

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