state_iec

8 rows where district contains "Senate District 08" and position = "Associated"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vendor, amount_spent, date_spent, date_delivered

Link rowid ▼ committee vendor amount_spent date_spent date_delivered type position candidate affiliation district
1143 1143 Colorado Values Project Ascend Digital Stervices 1250.0 6/11/20 6/11/2020-6/17/2020 Digital Associated Rankin, Bob Republican Senate District 08
1144 1144 Colorado Values Project Facebook 1250.0 6/11/20 6/11/2020-6/17/2020 Digital Associated Rankin, Bob Republican Senate District 08
1145 1145 Colorado Values Project Ascend Digital Stervices 1250.0 6/18/20 6/18/2020-6/24/2020 Digital Associated Rankin, Bob Republican Senate District 08
1147 1147 Colorado Values Project Facebook 1250.0 6/19/20 6/19/2020-6/25/2020 Digital Associated Rankin, Bob Republican Senate District 08
1150 1150 Colorado Values Project Ascend Digital Stervices 1250.0 6/26/20 6/26/2020-6/30/2020 Digital Associated Rankin, Bob Republican Senate District 08
1153 1153 Colorado Values Project Facebook 507.37 6/30/20 6/25/2020-6/30/2020 Digital Associated Rankin, Bob Republican Senate District 08
1156 1156 Colorado Values Project Ascend Digital Strategies 3750.0 7/1/20 6/25/2020-6/30/2020 Digital Associated Rankin, Bob Republican Senate District 08
1157 1157 Colorado Values Project Facebook 2000.0 8/7/20 8/7/2020-8/14/2020 Digital Associated Rankin, Bob Republican 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
);