state_iec

3 rows where district = "Senate District 08" and type = "Radio"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committee, amount_spent

Link rowid ▼ committee vendor amount_spent date_spent date_delivered type position candidate affiliation district
802 802 Colorado Advocates For Rural Electrification (CARE) Wr Communications 8012.0 10/16/20 10/19/20-11/2/20 Radio Supporting Rankin, Bob Republican Senate District 08
2443 2443 Unite For Colorado Action Ascent Media 75000.0 9/3/20 9/8/20 - 9/29/20 Radio Supporting Rankin, Bob Republican Senate District 08
2449 2449 Unite For Colorado Action Wire Grp Buying Llc 75000.0 10/14/20 10/16/20 - 10/30/20 Radio Supporting 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
);