super_pacs_cont

8 rows where occupation = "Mining/Energy"

✎ View and edit SQL

This data as json, CSV (advanced)

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

Link rowid ▼ committee committee_type contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
706 706 COLORADO ADVOCATES FOR RURAL ELECTRIFICATION (CARE) INDEPENDENT EXPENDITURE COMMITTEE Independent Expenditure Committee 549.98 4/12/21 Duanne Highley Broomfield CO 80023 Tri-State Mining/Energy Individual Monetary (Itemized)  
844 844 COLORADANS AGAINST JARED POLIS Independent Expenditure Committee 25.0 5/7/21 Cathy Humphreys Littleton CO 80127 Rim Operating Mining/Energy Individual Monetary (Itemized)  
938 938 SENATE MAJORITY FUND 527 Political Organization 150.0 5/23/21 David Petrocco Brighton CO 80601 United Power Mining/Energy Individual Monetary (Itemized)  
1114 1114 RESTORE COLORADO LEADERSHIP FUND 527 Political Organization 150.0 7/1/21 John Stoner Colorado Springs CO 80918 5 Points Ltd Mining/Energy Individual Monetary (Itemized)  
1262 1262 COLORADO ADVOCATES FOR RURAL ELECTRIFICATION (CARE) INDEPENDENT EXPENDITURE COMMITTEE Independent Expenditure Committee 19.14 8/5/21 Jennifer Goss Littleton CO 80124 Tri-State G&T Mining/Energy Individual Monetary (Itemized)  
1263 1263 COLORADO ADVOCATES FOR RURAL ELECTRIFICATION (CARE) INDEPENDENT EXPENDITURE COMMITTEE Independent Expenditure Committee 510.43 8/5/21 Duanne Highley Broomfield CO 80023 Tri-State Mining/Energy Individual Monetary (Itemized)  
1593 1593 SENATE MAJORITY FUND 527 Political Organization 500.0 9/22/21 Ashley Campbell Denver CO 80202 Crestone Peak Resources Mining/Energy Individual Monetary (Itemized)  
1762 1762 TAKE BACK COLORADO Independent Expenditure Committee 40.0 12/2/20 Francis Steadman Englewood CO 80112 Lyon Oil Company Mining/Energy 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
);