super_pacs_cont

5 rows where committee contains "unite for colorado" sorted by rowid

View and edit SQL

Suggested facets: contribution_amount, contribution_date, contributor, city, zip

Link rowid ▼ committee committee_type contribution_amount contribution_date contributor city state zip employer occupation contributor_type contribution_type explanation
9834 Unite For Colorado Action Iec Independent Expenditure Committee 500000 8/7/20 0:00 Unite For Colorado Lafayette CO 80026     Corporation Monetary (Itemized) Wire
10381 Unite For Colorado Action Iec Independent Expenditure Committee 500000 8/27/20 0:00 Unite For Colorado Lafayette CO 80026     Corporation Monetary (Itemized) Wire
11250 Unite For Colorado Action Iec Independent Expenditure Committee 500000 9/24/20 0:00 Unite For Colorado Lafayette CO 80026     Corporation Monetary (Itemized) Wire
12385 Unite For Colorado Action Iec Independent Expenditure Committee 50000 10/21/20 0:00 Unite For Colorado Lafayette CO 80026     Corporation Monetary (Itemized) Wire
12386 Unite For Colorado Action Iec Independent Expenditure Committee 50000 10/21/20 0:00 Ready Colorado Littleton CO 80120     Corporation Monetary (Itemized) Wire

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,
	"contribution_type"	TEXT,
	"explanation"	TEXT
);
Powered by Datasette · Query took 211.769ms