super_pacs_cont

7 rows where occupation = "Media/Public Relations"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committee, committee_type, contribution_amount, contributor, city, zip, employer

Link rowid ▼ committee committee_type contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
13 13 TAKE BACK COLORADO Independent Expenditure Committee 25.0 1/4/21 Michael Kuhn Arvada CO 80007 Self Media/Public Relations Individual Monetary (Itemized)  
292 292 TAKE BACK COLORADO Independent Expenditure Committee 25.0 1/22/21 Peter Schmidt Colorado Springs CO 80920 Granite Creative, Inc Media/Public Relations Individual Monetary (Itemized)  
478 478 TAKE BACK COLORADO Independent Expenditure Committee 25.0 2/22/21 Peter Schmidt Colorado Springs CO 80920 Granite Creative, Inc Media/Public Relations Individual Monetary (Itemized)  
642 642 TAKE BACK COLORADO Independent Expenditure Committee 25.0 3/22/21 Peter Schmidt Colorado Springs CO 80920 Granite Creative, Inc Media/Public Relations Individual Monetary (Itemized)  
936 936 SENATE MAJORITY FUND 527 Political Organization 150.0 5/23/21 Stephen Laffey Fort Collis CO 80525 Self Media/Public Relations Individual Monetary (Itemized)  
1782 1782 TAKE BACK COLORADO Independent Expenditure Committee 25.0 12/4/20 Michael Kuhn Arvada CO 80007 Self Media/Public Relations Individual Monetary (Itemized)  
1917 1917 TAKE BACK COLORADO Independent Expenditure Committee 25.0 12/22/20 Peter Schmidt Colorado Springs CO 80920 Granite Creative, Inc Media/Public Relations 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
);