super_pacs_cont

28 rows where occupation = "Insurance Industry"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
375 375 COLORADO FOR SMALL BUSINESS 527 Political Organization 2400.0 6/30/23 Richard Shriver Erie CO 80516 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
392 392 COLORADO FOR SMALL BUSINESS 527 Political Organization 1800.0 9/10/23 Bruce Anderson Evergreen CO 80439 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
409 409 COLORADO FOR SMALL BUSINESS 527 Political Organization 1500.0 9/11/23 Bryce Babcock Thornton CO 80602 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
526 526 COLORADO FOR SMALL BUSINESS 527 Political Organization 750.0 9/6/23 Gary Dyer Lakewood CO 80215 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
557 557 COLORADO FOR SMALL BUSINESS 527 Political Organization 500.0 8/10/23 Jason Brassell Castle Pines CO 80108 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
575 575 COLORADO FOR SMALL BUSINESS 527 Political Organization 400.0 8/9/23 Kevin Shriver Colorado Springs CO 80901 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
633 633 COLORADO FOR SMALL BUSINESS 527 Political Organization 200.0 4/30/23 Jason Brassell Castle Pines CO 80108 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
639 639 COLORADO FOR SMALL BUSINESS 527 Political Organization 150.0 5/30/23 Richard Marchesini Littleton CO 80123 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
640 640 COLORADO FOR SMALL BUSINESS 527 Political Organization 150.0 6/30/23 Richard Marchesini Littleton CO 80123 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
641 641 COLORADO FOR SMALL BUSINESS 527 Political Organization 150.0 7/22/23 Richard Marchesini Littleton CO 80123 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
642 642 COLORADO FOR SMALL BUSINESS 527 Political Organization 150.0 8/9/23 Jason Brassell Castle Pines CO 80108 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
643 643 COLORADO FOR SMALL BUSINESS 527 Political Organization 150.0 8/11/23 Richard Marchesini Littleton CO 80123 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
665 665 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 5/30/23 Stacey Caruthers Fort Collins CO 80528 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
666 666 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 5/30/23 Keith Dodd Castle Pines CO 80108 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
668 668 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 6/30/23 Stacey Caruthers Fort Collins CO 80528 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
669 669 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 6/30/23 Eli Collins Denver CO 80219 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
671 671 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 7/7/23 Jason Brassell Castle Pines CO 80108 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
673 673 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 7/22/23 Dustin Larsen Colorado Springs CO 80927 Self Insurance Industry Individual Monetary (Itemized)  
675 675 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 8/10/23 Shelly Harsch Wheat Ridge CO 80033 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
676 676 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 8/10/23 Richard Seymour Westminster CO 80021 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
677 677 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 8/10/23 Alan Carpenter Hudson CO 80642 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
679 679 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 8/10/23 Dustin Larsen Colorado Springs CO 80927 Self Insurance Industry Individual Monetary (Itemized)  
681 681 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 8/18/23 Kelli Holt Colorado Springs CO 80927 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
684 684 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 9/2/23 Fabin Crespin Pueblo West CO 81007 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
685 685 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 9/11/23 Richard Seymour Westminster CO 80021 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
686 686 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 9/11/23 Shelly Harsch Wheat Ridge CO 80033 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
688 688 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 9/15/23 Alan Carpenter Hudson CO 80642 Farmers Insurance Insurance Industry Individual Monetary (Itemized)  
689 689 COLORADO FOR SMALL BUSINESS 527 Political Organization 100.0 9/15/23 Dustin Larsen Colorado Springs CO 80927 Self Insurance Industry 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
);