state_iec

26 rows where committee contains "unite for colorado" sorted by amount_spent descending

View and edit SQL

Suggested facets: vendor, amount_spent, date_spent, date_delivered, type, position, candidate, affiliation_x, district

Link rowid committee vendor amount_spent ▲ date_spent date_delivered type position candidate affiliation_x district field11
577 Unite For Colorado Action Iec Majority Strategies 198600.5 9/10/20 9/14/20 - 9/30/20 Mailing Opposing Dickerson, Paula Jane Democratic Senate District 25  
1390 Unite For Colorado Action Iec Effectv 150000.35 10/16/20 10/16/20 - 11/1/20 Television Opposing Dickerson, Paula Jane Democratic Senate District 25  
1139 Unite For Colorado Action Iec Majority Strategies 110000.79 10/8/20 10/9/20- 10/30/20 Internet Opposing Dickerson, Paula Jane Democratic Senate District 25  
1137 Unite For Colorado Action Iec Effectv 100002.5 10/8/20 10/8/20- 10/16/20 Television Opposing Dickerson, Paula Jane Democratic Senate District 25  
421 Unite For Colorado Action Iec Majority Strategies 100000 8/13/20 8/14/20 - 8/31/20 Mailing Supporting Staiert, Suzanne Republican Senate District 27  
423 Unite For Colorado Action Iec Majority Strategies 100000 8/13/20 8/14/20 - 8/31/20 Mailing Supporting Gerber, Lynn Republican Senate District 19  
771 Unite For Colorado Action Iec Effectv 100000 9/24/20 9/25/20 - 8/8/20 Television Opposing Dickerson, Paula Jane Democratic Senate District 25  
1554 Unite For Colorado Action Iec Effectv 90000 10/22/20 10/22/20 - 11/3/20 Television Opposing Dickerson, Paula Jane Democratic Senate District 25  
420 Unite For Colorado Action Iec Grp Buying Llc 75000 8/13/20 8/14/20- 8/31/20 Television Supporting Staiert, Suzanne Republican Senate District 27  
422 Unite For Colorado Action Iec Grp Buying Llc 75000 8/13/20 8/14/20- 8/31/20 Television Supporting Gerber, Lynn Republican Senate District 19  
519 Unite For Colorado Action Iec Ascent Media Llc 75000 9/3/20 9/8/20 - 9/29/20 Radio Supporting Rankin, Bob Republican Senate District 08  
1313 Unite For Colorado Action Iec Wire Grp Buying Llc 75000 10/14/20 10/16/20 - 10/30/20 Radio Supporting Rankin, Bob Republican Senate District 08  
520 Unite For Colorado Action Iec Majority Strategies 53835 9/3/20 9/8/20 - 9/29/20 Mailing Supporting Rankin, Bob Republican Senate District 08  
578 Unite For Colorado Action Iec Victors Canvassing 50000 9/10/20 9/14/20 - 9/30/20 Door to Door Opposing Dickerson, Paula Jane Democratic Senate District 25  
1141 Unite For Colorado Action Iec Victors Canvassing 49998 10/8/20 10/12/20 - 11/1/20 Door to Door Opposing Dickerson, Paula Jane Democratic Senate District 25  
1140 Unite For Colorado Action Iec Majority Strategies 47216 10/8/20 10/12/20 - 10/23/20 Mailing Opposing Dickerson, Paula Jane Democratic Senate District 25  
1142 Unite For Colorado Action Iec Majority Strategies 34337.99 10/8/20 10/12/20 - 10/23/20 Mailing Opposing Hanlon, Karl Democratic Senate District 08  
579 Unite For Colorado Action Iec Victors Canvassing 25000 9/10/20 9/14/20 - 9/30/20 Door to Door Supporting Rankin, Bob Republican Senate District 08  
1555 Unite For Colorado Action Iec Majority Strategies 20000 10/22/20 10/22/20 - 11/3/20 Internet Supporting Kellner, John Republican Arapahoe County District Attorney  
1312 Unite For Colorado Action Iec Madison Mcqueen, Llc 18808 10/14/20 10/16/20 - 11/1/20 Television Opposing Dickerson, Paula Jane Democratic Senate District 25  
1076 Unite For Colorado Action Iec Madison Mcqueen, Llc 14280 10/6/20 10/8/20- 10/15/20 Television Opposing Dickerson, Paula Jane Democratic Senate District 25  
1138 Unite For Colorado Action Iec Madison Mcqueen, Llc 6000 10/8/20 10/8/20- 10/15/20 Television Opposing Dickerson, Paula Jane Democratic Senate District 25  
1588 Unite For Colorado Action Iec Co/Efficient 1895.44 10/23/20 10/24/20 Other Opposing Dickerson, Paula Jane Democratic Senate District 25  
1669 Unite For Colorado Action Iec Telephone Town Hall Meeting 1456 10/28/20 10/28/20 - 10/30/20 Other Supporting Rankin, Bob Republican Senate District 08  
1457 Unite For Colorado Action Iec Madison Mcqueen, Llc 1150 10/19/20 10/19/20 - 11/1/20 Television Opposing Dickerson, Paula Jane Democratic Senate District 25  
1753 Unite For Colorado Action Iec Cole Communications 884.94 10/12/20 10/12/20 - 1/1/20 Internet Opposing Dickerson, Paula Jane Democratic Senate District 25  

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "state_iec" (
	"committee"	TEXT,
	"vendor"	TEXT,
	"amount_spent"	INTEGER,
	"date_spent"	TEXT,
	"date_delivered"	TEXT,
	"type"	TEXT,
	"position"	TEXT,
	"candidate"	TEXT,
	"affiliation_x"	TEXT,
	"district"	TEXT,
	"field11"	TEXT
);
Powered by Datasette · Query took 56.996ms