state_iec

3 rows where affiliation = "Democratic/Republican" and district contains "Senate District 08"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date_spent, candidate, district

Link rowid ▼ committee vendor amount_spent date_spent date_delivered type position candidate affiliation district
791 791 Colorado Advocates For Rural Electrification (CARE) Wr Communications 23969.78 9/17/20 9/28/20-11/2/20 Radio Supporting Buentello, Brianna Anastasia; Rankin, Bob Democratic/Republican House District 47/Senate District 08
792 792 Colorado Advocates For Rural Electrification (CARE) Wr Communications 5540.0 9/17/20 09/28/2020 – 10/30/2020 Other Supporting Buentello, Brianna Anastasia; Rankin, Bob Democratic/Republican House District 47/Senate District 08
793 793 Colorado Advocates For Rural Electrification (CARE) Wr Communications 9000.0 10/6/20     Supporting Buentello, Brianna Anastasia; Priola, Kevin; Rankin, Bob Democratic/Republican House District 47/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
);