state_iec

2 rows where district = "House District 47" and type = "Radio"

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ committee vendor amount_spent date_spent date_delivered type position candidate affiliation district
794 794 Colorado Advocates For Rural Electrification (CARE) Wr Communications 445.0 10/6/20 10/6/20 Radio Supporting Buentello, Brianna Anastasia Democratic House District 47
2381 2381 Take Back Colorado Rearden Strategic, Inc 11014.3 10/21/20 10/22/2020-11/2/2020 Radio Opposing Buentello, Brianna Anastasia Democratic House District 47

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
);