super_pacs_cont

10 rows where committee contains "unite colorado" sorted by contribution_amount descending

View and edit SQL

Suggested facets: contribution_amount, contribution_date, contributor, zip, contributor_type, explanation

Link rowid committee committee_type contribution_amount ▲ contribution_date contributor city state zip employer occupation contributor_type explanation
8054 Unite Colorado Election Fund Independent Expenditure Committee 500000 5/15/20 0:00 Unite America (Federal Hybrid Pac) Denver CO 80203     Other Donation From Unite America Non-Contribution Account
8308 Unite Colorado Election Fund Independent Expenditure Committee 100000 6/5/20 0:00 Unite America (Federal Hybrid Pac) Denver CO 80203     Other Unite America Non-Contribution Account
8496 Unite Colorado Election Fund Independent Expenditure Committee 100000 6/18/20 0:00 Unite America (Federal Hybrid Pac) Denver CO 80203     Other Unite America Non-Contribution Account
8500 Unite Colorado Election Fund Independent Expenditure Committee 50000 6/19/20 0:00 Unite America (Federal Hybrid Pac) Denver CO 80203     Other Unite America Non-Contribution Account
10747 Unite Colorado Election Fund Independent Expenditure Committee 44000 9/11/20 0:00 Better Leaders, Better Colorado Denver CO 80202     Independent Expenditure Committee  
10748 Unite Colorado Election Fund Independent Expenditure Committee 27165.55 9/11/20 0:00 Coloradans For Constitutional Values Denver CO 80202     Independent Expenditure Committee  
8028 Unite Colorado Election Fund Independent Expenditure Committee 7500 5/14/20 0:00 Unite America (Federal Hybrid Pac) Denver CO 80203     Other Donation From Unite America Non-Contribution Account
7765 Unite Colorado Election Fund Independent Expenditure Committee 30 4/16/20 0:00 Wells Fargo Denver CO 80222     Business Refund For Monthly Svc Fees (Jan, Feb, Mar)
11452 Unite Colorado Election Fund Independent Expenditure Committee 12.31 12/9/19 0:00                
7766 Unite Colorado Election Fund Independent Expenditure Committee -30 4/16/20 0:00 Wells Fargo Denver CO 80222     Business Offset Due To Deletion Of Filed Item - Refund For Monthly Svc Fees (Jan, Feb, Mar)

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "super_pacs_cont" (
	"committee"	TEXT,
	"committee_type"	TEXT,
	"contribution_amount"	INTEGER,
	"contribution_date"	TEXT,
	"contributor"	TEXT,
	"city"	TEXT,
	"state"	TEXT,
	"zip"	INTEGER,
	"employer"	TEXT,
	"occupation"	TEXT,
	"contributor_type"	TEXT,
	"explanation"	TEXT
);
Powered by Datasette · Query took 100.254ms