state_iec

2 rows where committee contains "Coloradans For Constitutional Values", date_spent = "6/8/20" and district = "House District 63"

✎ 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
733 733 Coloradans For Constitutional Values Polestar 6910.0 6/8/20 6/15/20 Mailing Opposing Miller, Patricia Elaine Republican House District 63
763 763 Coloradans For Constitutional Values Polestar 55750.0 6/8/20 6/9/20 Television Supporting Woog, Dan Republican House District 63

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