super_pacs_cont

9 rows where state = "IL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committee, committee_type, contribution_amount, contribution_date, contributor, city, zip, contributor_type

state 1 ✖

Link rowid ▼ committee committee_type contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
205 205 ALL TOGETHER COLORADO Independent Expenditure Committee 5000.0 8/17/23 Invenergy Chicago IL 60606     Business Monetary (Itemized)  
207 207 ALL TOGETHER COLORADO Independent Expenditure Committee 5000.0 8/22/23 Allstate Northbrook IL 60062     Business Monetary (Itemized)  
319 319 ALL TOGETHER COLORADO Independent Expenditure Committee 2500.0 3/27/23 Motorola Solutions Chicago IL 60661     Business Monetary (Itemized)  
320 320 BETTER COLORADO ALLIANCE Independent Expenditure Committee 2500.0 3/27/23 Motorola Solutions Chicago IL 60661     Business Monetary (Itemized)  
322 322 SENATE MAJORITY FUND 527 Political Organization 2500.0 3/28/23 Motorola Solutions Schaumburg IL 60196     Corporation Monetary (Itemized)  
337 337 SENATE MAJORITY FUND 527 Political Organization 2500.0 8/14/23 Allstate Insurance Co Northbrook IL 60062     Corporation Monetary (Itemized)  
353 353 ALL TOGETHER COLORADO Independent Expenditure Committee 2500.0 9/19/23 Hecate Energy Chicago IL 60661     Business Monetary (Itemized)  
383 383 RESTORE COLORADO LEADERSHIP FUND 527 Political Organization 2000.0 1/6/23 Cresco Labs Chicago IL 60654     Corporation Monetary (Itemized)  
663 663 SENATE MAJORITY FUND 527 Political Organization 100.0 3/17/23 Kurt Heerwagen La Grange IL 60525 Sbc Global Financial/Investment Individual Monetary (Itemized)  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "super_pacs_cont" (
"committee" TEXT,
  "committee_type" TEXT,
  "contribution_amount" REAL,
  "contribution_date" TEXT,
  "contributor" TEXT,
  "city" TEXT,
  "state" TEXT,
  "zip" TEXT,
  "employer" TEXT,
  "occupation" TEXT,
  "contributor_type" TEXT,
  "contribution_type" TEXT,
  "explanation" TEXT
);