super_pacs_cont

20 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, state, zip, employer

Link rowid ▼ committee committee_type contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
95 95 FUTURE DENVER Independent Expenditure Committee 10000.0 9/12/23 Janice Gross Newton MA 02458 Goulston & Storrs Attorney/Legal Individual Monetary (Itemized)  
105 105 BETTER LEADERS, STRONGER SCHOOLS Independent Expenditure Committee 10000.0 10/29/23 Stanton Dodge Castle Rock CO 80237 Draft Kings Attorney/Legal Individual Monetary (Itemized)  
189 189 SENATE MAJORITY FUND 527 Political Organization 5000.0 6/21/23 Andrew Hamrick Greenwood Village CO 80111 Apartment Association Of Metro Denver Attorney/Legal Individual Monetary (Itemized)  
209 209 SENATE MAJORITY FUND 527 Political Organization 5000.0 8/23/23 Stanton Dodge Castle Rock CO 80108 Draftkings Attorney/Legal Individual Monetary (Itemized)  
229 229 FUTURE DENVER Independent Expenditure Committee 5000.0 9/25/23 Patrick Meyers Denver CO 80210 State Of Colorado Attorney/Legal Individual Monetary (Itemized)  
364 364 FUTURE DENVER Independent Expenditure Committee 2500.0 9/29/23 Lisa Cohn Denver CO 80231 Apartment Income Reit Corp. Attorney/Legal Individual Monetary (Itemized)  
387 387 COMMUNITY FORWARD Independent Expenditure Committee 2000.0 6/29/23 Fred Otis Greeley CO 80634 Otis And Bedingfield Attorney/Legal Individual Monetary (Itemized)  
389 389 SENATE MAJORITY FUND 527 Political Organization 2000.0 8/24/23 John Stinar Colorado Springs CO 80903 Stinar Zendejas Burrell & Wilhelmi, Pllc Attorney/Legal Individual Monetary (Itemized)  
468 468 BETTER COLORADO ALLIANCE Independent Expenditure Committee 1000.0 1/20/23 Ted Trimpa Denver CO 80202 Trimpa Group Attorney/Legal Individual Monetary (Itemized)  
496 496 COMMUNITY FORWARD Independent Expenditure Committee 1000.0 8/10/23 John Todd Greeley CO 80634 Self Attorney/Legal Individual Monetary (Itemized)  
497 497 COMMUNITY FORWARD Independent Expenditure Committee 1000.0 8/10/23 Tinothy Brynteson Greeley CO 80634 Otis And Bedingfield Attorney/Legal Individual Monetary (Itemized)  
513 513 FUTURE DENVER Independent Expenditure Committee 1000.0 9/29/23 Steven Paletz Denver CO 80220 Akerman Attorney/Legal Individual Monetary (Itemized)  
555 555 SENATE MAJORITY FUND 527 Political Organization 500.0 7/31/23 Matthew Zendejas Colorado Springs CO 80903 Stinar Zendejas & Gaithe Llc Attorney/Legal Individual Monetary (Itemized)  
558 558 ALL TOGETHER COLORADO Independent Expenditure Committee 500.0 9/7/23 Karen Langsley Denver CO 80227 Landsley Mills Law Attorney/Legal Individual Monetary (Itemized)  
590 590 SENATE MAJORITY FUND 527 Political Organization 300.0 7/17/23 John Buckley Iii Colorado Springs CO 80920 Buckley Law Attorney/Legal Individual Monetary (Itemized)  
602 602 SENATE MAJORITY FUND 527 Political Organization 250.0 8/13/23 Jia Meeks Aurora CO 80011 Bhfs Attorney/Legal Individual Monetary (Itemized)  
620 620 ALL TOGETHER COLORADO Independent Expenditure Committee 250.0 9/7/23 Michael Carrigan Denver CO 80238 Holland & Hart Attorney/Legal Individual Monetary (Itemized)  
624 624 ALL TOGETHER COLORADO Independent Expenditure Committee 250.0 9/19/23 Mike Foote Lafayette CO 80026 Foote Law Firm Attorney/Legal Individual Monetary (Itemized)  
626 626 ALL TOGETHER COLORADO Independent Expenditure Committee 250.0 9/19/23 Jep Seman Denver CO 80223 Jps Law Group Attorney/Legal Individual Monetary (Itemized)  
701 701 SENATE MAJORITY FUND 527 Political Organization 75.0 8/14/23 Matthew Groves Greenwood Village CO 80121 Cada 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
);