super_pacs_cont

8 rows where occupation = "Attorney/Legal"

✎ 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
1136 1136 SENATE MAJORITY FUND 527 Political Organization 250.0 7/13/21 Jia Meeks Aurora CO 80011 Bhfs Attorney/Legal Individual Monetary (Itemized)  
1358 1358 RESTORE COLORADO LEADERSHIP FUND 527 Political Organization 100.0 8/17/21 Andrew Hamrick Greenwood Village CO 80111 Colorado Apartment Association Attorney/Legal Individual Monetary (Itemized)  
1373 1373 ALL TOGETHER COLORADO Independent Expenditure Committee 1000.0 8/19/21 Peter Kirsch Denver CO 80206 Kaplan, Kirsch & Rockwell Attorney/Legal Individual Monetary (Itemized)  
1375 1375 RESTORE COLORADO LEADERSHIP FUND 527 Political Organization 100.0 8/19/21 Jep Seman Denver CO 80206 Jps Law Attorney/Legal Individual Monetary (Itemized)  
1388 1388 ALL TOGETHER COLORADO Independent Expenditure Committee 2500.0 8/25/21 John Walsh Denver CO 80220 Wilmerhale Attorney/Legal Individual Monetary (Itemized)  
1389 1389 ALL TOGETHER COLORADO Independent Expenditure Committee 250.0 8/25/21 Jeff Blattner Boulder CO 80304 Self Attorney/Legal Individual Monetary (Itemized)  
1623 1623 ALL TOGETHER COLORADO Independent Expenditure Committee 10000.0 9/28/21 Steven Leaffer Cherry Hills Village CO 80113 Leaffer Law Group Attorney/Legal Individual Monetary (Itemized)  
1627 1627 BETTER COLORADO ALLIANCE Independent Expenditure Committee 3300.0 9/28/21 Steven Leaffer Cherry Hills Village CO 80113 Leaffer Law Group Attorney/Legal 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
);