state_iec

12 rows where district contains "Senate District 08" and position = "Supporting/Opposing"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committee, vendor, amount_spent, date_spent, date_delivered, type, candidate, affiliation, district

Link rowid ▼ committee vendor amount_spent date_spent date_delivered type position candidate affiliation district
1113 1113 Colorado Sierra Club Independent Action Mission Control 7200.25 10/16/20 10/20/20 Mailing Supporting/Opposing Hanlon, Karl/Rankin, Bob Democratic Senate District 08
1340 1340 Family Policy Alliance Independent Expenditure Committee Awareness Analytics Partners, Llc 1500.0 10/20/20 10/20/20 Internet Supporting/Opposing Rankin, Bob/Hanlon, Karl Republican Senate District 08
1341 1341 Family Policy Alliance Independent Expenditure Committee Awareness Analytics Partners, Llc 400.0 10/30/20 10/30/20 Internet Supporting/Opposing Rankin, Bob/Hanlon, Karl Republican Senate District 08
1342 1342 Family Policy Alliance Independent Expenditure Committee CP Solutions 1618.95 10/23/20 10/23/20 Mailing Supporting/Opposing Rankin, Bob/Hanlon, Karl Republican Senate District 08
1343 1343 Family Policy Alliance Independent Expenditure Committee CP Solutions 1664.86 10/23/20 10/23/20 Mailing Supporting/Opposing Rankin, Bob/Hanlon, Karl Republican Senate District 08
1344 1344 Family Policy Alliance Independent Expenditure Committee CP Solutions 1704.92 9/24/20 9/25/20 Mailing Supporting/Opposing Rankin, Bob/Hanlon, Karl Republican Senate District 08
1472 1472 Leading Colorado Forward Moxie Media 11669.0 9/29/20 10/2/20 Mailing Supporting/Opposing Hanlon, Karl/Rankin, Bob Democratic Senate District 08
1473 1473 Leading Colorado Forward Moxie Media 11669.0 10/6/20 10/7/20 Mailing Supporting/Opposing Hanlon, Karl/Rankin, Bob Democratic Senate District 08
1474 1474 Leading Colorado Forward Plumb Marketing 7579.15 10/1/20 10/2/20 Mailing Supporting/Opposing Hanlon, Karl/Rankin, Bob Democratic Senate District 08
1475 1475 Leading Colorado Forward Plumb Marketing 7579.15 10/6/20 10/7/20 Mailing Supporting/Opposing Hanlon, Karl/Rankin, Bob Democratic Senate District 08
1476 1476 Leading Colorado Forward Plumb Marketing 7589.14 10/20/20 10/21/20 Mailing Supporting/Opposing Hanlon, Karl/Rankin, Bob Democratic Senate District 08
2346 2346 Senate Majority Fund Cole Communications 918.19 10/19/20 10/01/2020-11/3/2020 Internet Supporting/Opposing Priola, Kevin; Rankin, Bob/Dickerson, Paula Jane Republican Senate District 25 & Senate District 08

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "state_iec" (
	"committee"	TEXT,
	"vendor"	TEXT,
	"amount_spent"	REAL,
	"date_spent"	TEXT,
	"date_delivered"	TEXT,
	"type"	TEXT,
	"position"	TEXT,
	"candidate"	TEXT,
	"affiliation"	TEXT,
	"district"	TEXT
);