state_iec

3 rows where district contains "Senate District 08", position = "Supporting/Opposing" and vendor = "CP Solutions"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date_spent, date_delivered

Link rowid ▼ committee vendor amount_spent date_spent date_delivered type position candidate affiliation district
1342 1342 Family Policy Alliance Independent Expenditure Committee CP Solutions 1618.95 10/23/20 10/23/20 Mailing Supporting/Opposing Rankin, Bob/Hanlon, Karl Republican Senate District 08
1343 1343 Family Policy Alliance Independent Expenditure Committee CP Solutions 1664.86 10/23/20 10/23/20 Mailing Supporting/Opposing Rankin, Bob/Hanlon, Karl Republican Senate District 08
1344 1344 Family Policy Alliance Independent Expenditure Committee CP Solutions 1704.92 9/24/20 9/25/20 Mailing Supporting/Opposing Rankin, Bob/Hanlon, Karl 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
);