state_iec

25 rows where affiliation = "Democratic" and date_spent = "9/21/20"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: committee, vendor, amount_spent, date_delivered, type, position, candidate, district

Link rowid ▼ committee vendor amount_spent date_spent date_delivered type position candidate affiliation district
136 136 Better Colorado Alliance Gumbinner & Davies 14278.13 9/21/20 9/22/20 Mailing Supporting/Opposing Cutter, Lisa Ann/Rosier, Donald Democratic House District 25
201 201 Better Colorado Alliance Bluewest Media 25650.0 9/21/20 9/28/2020-10/4/2020 Television Supporting Ortiz, David Daniel Democratic House District 38
202 202 Better Colorado Alliance Bluewest Media 25650.0 9/21/20 10/5/2020-10/11/2020 Television Supporting Ortiz, David Daniel Democratic House District 38
203 203 Better Colorado Alliance Bluewest Media 27788.0 9/21/20 10/12/2020-10/18/2020 Television Supporting Ortiz, David Daniel Democratic House District 38
212 212 Better Colorado Alliance Gumbinner & Davies 14395.63 9/21/20 9/22/20 Mailing Supporting/Opposing Ortiz, David Daniel/Champion, Richard Alan Democratic House District 38
811 811 Colorado Fair Share Action Grassroots Voter Outreach 370.29 9/21/20     Supporting Bridges, Jeff Democratic Senate District 26
820 820 Colorado Fair Share Action Grassroots Voter Outreach 740.57 9/21/20     Supporting Buentello, Brianna Anastasia Democratic House District 47
829 829 Colorado Fair Share Action Grassroots Voter Outreach 246.86 9/21/20     Supporting Cutter, Lisa Ann Democratic House District 25
838 838 Colorado Fair Share Action Grassroots Voter Outreach 617.14 9/21/20     Supporting Daugherty, Lindsey Democratic House District 29
847 847 Colorado Fair Share Action Grassroots Voter Outreach 246.86 9/21/20     Supporting Dickerson, Paula Jane Democratic Senate District 25
856 856 Colorado Fair Share Action Grassroots Voter Outreach 740.57 9/21/20     Supporting Esgar, Daneya Leigh Democratic House District 46
865 865 Colorado Fair Share Action Grassroots Voter Outreach 1481.14 9/21/20     Supporting Exum Sr, Thomas Earl Democratic House District 17
874 874 Colorado Fair Share Action Grassroots Voter Outreach 617.14 9/21/20     Supporting Hanlon, Karl Democratic Senate District 08
883 883 Colorado Fair Share Action Grassroots Voter Outreach 370.29 9/21/20     Supporting Kolker, Chris Democratic Senate District 27
892 892 Colorado Fair Share Action Grassroots Voter Outreach 617.14 9/21/20     Supporting Mclachlan, Barbara Democratic House District 59
899 899 Colorado Fair Share Action Grassroots Voter Outreach 246.86 9/21/20     Supporting Michaelson Jenet, Dafna Democratic House District 30
932 932 Colorado Fair Share Action Grassroots Voter Outreach 370.29 9/21/20     Supporting Sullivan, Tom Democratic House District 37
941 941 Colorado Fair Share Action Grassroots Voter Outreach 246.86 9/21/20     Supporting Titone, Brianna Caterina Democratic House District 27
950 950 Colorado Fair Share Action Grassroots Voter Outreach 246.86 9/21/20     Supporting Zenzinger, Rachel Democratic Senate District 19
1509 1509 Leading Colorado Forward Facebook 3800.0 9/21/20 9/17/2020-9/21/2020 Internet Supporting/Opposing Kolker, Chris/Staiert, Suzanne Democratic Senate District 27
1542 1542 Leading Colorado Forward Plumb Marketing 3830.3 9/21/20 9/22/20 Mailing Supporting/Opposing Kolker, Chris/Staiert, Suzanne Democratic Senate District 27
1829 1829 Leading Colorado Forward Moxie Media 7358.0 9/21/20 9/24/20 Mailing Supporting Zenzinger, Rachel Democratic Senate District 19
2377 2377 Take Back Colorado Connell Donatelli, Inc 30000.0 9/21/20 10/1/2020-11/3/2020 Internet Opposing Buentello, Brianna Anastasia Democratic House District 47
2388 2388 Take Back Colorado Connell Donatelli, Inc 20000.0 9/21/20 10/1/2020-11/3/2020 Internet Opposing Mclachlan, Barbara Democratic House District 59
2393 2393 Take Back Colorado Connell Donatelli, Inc 30000.0 9/21/20 10/1/2020-11/1/2020 Internet Opposing Titone, Brianna Caterina Democratic House District 27

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