super_pacs_cont

3 rows where state = "PA"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ committee committee_type contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
135 135 ALL TOGETHER COLORADO Independent Expenditure Committee 6000.0 8/30/23 Cigna Philadelphia PA 19192     Business Monetary (Itemized)  
136 136 SENATE MAJORITY FUND 527 Political Organization 6000.0 9/4/23 The Cigna Group Employee Pac Philadelphia PA 19192     Other Monetary (Itemized) Federal Pac
274 274 ALL TOGETHER COLORADO Independent Expenditure Committee 2500.0 1/5/23 Fresenuis Medical Care Waltham PA 02451     Business 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
);